9/4/2023 0 Comments Data sheet creatorTomekmichal39 liked ES-200 Electric Scooter Unlocker.Adrian Prinz has updated the project titled 6-Axis Robot from Scratch - Servo driven.nrwest has updated the log for Yet Another Reflow Oven.nrwest has updated the project titled Yet Another Reflow Oven.Gregg Eshelman on Data Recovery In The Woodshed.Paul Maier on Measuring Planck’s Constant (Again).dexdrako on Giving Solar Power’s Mortal Enemies A Dusting Without Wasting Water.Tom Hank on Get Your Amateur Radio License Already!.Ewald on Smart Doorbell Focuses On Privacy.Julian Skidmore on A Quarter Century Of The IMac.Joshua on Ask Hackaday: Why Retrocomputing?.Gregg Eshelman on A Quarter Century Of The IMac.Keebin’ With Kristina: The One With The QWERTY Drum Set 1 Comment Posted in Artificial Intelligence, Featured, Original Art, Rants, Slider Tagged ai, excel, GPT-3, Rant Post navigation This implementation of using it for spreadsheets just isn’t one of them. 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. We’ve been interested in looking at how AI can process things other than silly images.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |