![]() That’s not to say that GPT-3 isn’t useful. Even Wolfram Alpha which does a better job is still not up to the task, although we wonder how hard it would be for them to push out Excel formulae? At least it is better than the “ prompt engineering” we’ve been hearing about. ![]() But at the level of GPT-3 guessing our formulas from natural language, it is just a toy. (“Computer: Run an analysis of all known Romulan transmission format…”). Is there a market for this? Sure, when it becomes Star Trek-level computer interaction. You could even ask for clarification or note impossible-seeming situations. You could have had some keyword-matching templates and gotten as good a result that would also be more repeatable. So, in our opinion, this is little more than a parlor trick. We think this one was right: The amount of interest on a V1 balance at a compound interest rate in P1 compounded annually for V2 yearsīut we were pretty sure this one was wrong: The time it takes a ball to fall to the ground from Q1 feet It just goes to show that the neural net doesn’t think about the problem the way we do. That flips the equation over for some reason: =C5/C6 It must be keying on the actual names of the cells because try this: The current for a resistor in C5 when the voltage is in C6 Or… The current for a resistor in R1 when the voltage is in E1 For example: Find the power if the voltage is in cell B1 and the current in cell C1 We were impressed that it seems to know how to find certain relationships. The website has disclaimers about “there may be imperfections in the model” and “verify this output before putting to use.” Verifying this is correct implies you could have written it yourself and it probably wouldn’t take much more time. Part of the problem with these sorts of things is that they are inexact. So where’s the intelligence? The result is correct, of course, but it isn’t that hard to figure out yourself. Otherwise 1 unless cell A4 is negative and then the result is 42Īnd the result: =IF(SUM(H:H)>50, -1, IF(A4<0, 42, 1)) Here’s a different prompt: Negative 1 if the sum of column H is greater than 50, It really needs to be a y=f(x) sort of problem, we suppose. Which is close, but not really how anyone even mildly proficient with Excel would interpret that request. Not realizing that, we asked: If the sum of column H is greater than 50, multiply column A by 0.33Īnd got: =IF(SUM(H:H)>50,A*0.33,0) A Better Try So trying to describe the actual result you want in terms of columns or rows seems to be beyond it. When they say “Excel formula” they mean that quite literally. ![]() Our first prompt didn’t work out very well. Based on GPT-3, it supposedly transforms your problem description into a formula suitable for Excel or Google Sheets. That’s why the “ Free AI Bot that Generates the Excel Formula for Any Problem” caught our eye. On the same website, users can find further services like the 2D and 3D drawings download area, the motors type test report download area, and the clients reserved area in which one can check the goods ready to be shipped, its own net prices and eventually send its orders.We’ve been interested in looking at how AI can process things other than silly images. This certificate is also useful to complete the technical file of a machine in accordance to the European Directives. ![]() The final test report downloader permits to trace and print all the final test data and diagram of each motive motor or gearbox, starting from its serial number. Motive's website has been developed to a level that permits it to grant to clients and designers a helpful service: The motors datasheet creator on permits to select freely the standard and special features of the desired motor, in any voltage, size and shape, and then to download from website a PDF document that, in several pages, shows the drawing, the performance, the technical data, the test reports and all the certifications. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |