We’ve been interested in looking at how AI can process things other than silly images. That’s why the “Free AI Bot that Generates the Excel Formula for Any Problem” caught our eye. Based on GPT-3, it supposedly transforms your problem description into a formula suitable for Excel or Google Sheets.
Our first prompt didn’t work out very well. But that was sort of our fault. When they say “Excel formula” they mean that quite literally. So trying to describe the actual result you want in terms of columns or rows seems to be beyond it. Not realizing that, we asked:
If the sum of column H is greater than 50, multiply column A by 0.33
And got:
=IF(SUM(H:H)>50,A*0.33,0)
A Better Try
Which is close, but not really how anyone even mildly proficient with Excel would interpret that request. But that’s not fair. It really needs to be a y=f(x) sort of problem, we suppose.
Here’s a different prompt:
Negative 1 if the sum of column H is greater than 50, otherwise 1 unless cell A4 is negative and then the result is 42
And the result:
=IF(SUM(H:H)>50, -1, IF(A4<0, 42, 1))
So where’s the intelligence? The result is correct, of course, but it isn’t that hard to figure out yourself.
Part of the problem with these sorts of things is that they are inexact. 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.
Looking Up Formulas
We were impressed that it seems to know how to find certain relationships. For example:
Find the power if the voltage is in cell B1 and the current in cell C1 =B1*C1
Or…
The current for a resistor in R1 when the voltage is in E1 =E1/R1
Here’s what’s funny, though. 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
That flips the equation over for some reason:
=C5/C6
It just goes to show that the neural net doesn’t think about the problem the way we do. 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 =V1*(1+P1)^V2
But we were pretty sure this one was wrong:
The time it takes a ball to fall to the ground from Q1 feet =Q1/32
Our Opinion
So, in our opinion, this is little more than a parlor trick. You could have had some keyword-matching templates and gotten as good a result that would also be more repeatable. You could even ask for clarification or note impossible-seeming situations.
Is there a market for this? Sure, when it becomes Star Trek-level computer interaction. (“Computer: Run an analysis of all known Romulan transmission format…”). But at the level of GPT-3 guessing our formulas from natural language, it is just a toy. 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.
That’s not to say that GPT-3 isn’t useful. It clearly is for some problems. This implementation of using it for spreadsheets just isn’t one of them. Still neat, though.
AI Creates Your Spreadsheets, Sometimes & Latest News Update
AI Creates Your Spreadsheets, Sometimes & More Live News
All this news that I have made and shared for you people, you will like it very much and in it we keep bringing topics for you people like every time so that you keep getting news information like trending topics and you It is our goal to be able to get
all kinds of news without going through us so that we can reach you the latest and best news for free so that you can move ahead further by getting the information of that news together with you. Later on, we will continue
to give information about more today world news update types of latest news through posts on our website so that you always keep moving forward in that news and whatever kind of information will be there, it will definitely be conveyed to you people.
AI Creates Your Spreadsheets, Sometimes & More News Today
All this news that I have brought up to you or will be the most different and best news that you people are not going to get anywhere, along with the information Trending News, Breaking News, Health News, Science News, Sports News, Entertainment News, Technology News, Business News, World News of this made available to all of you so that you are always connected with the news, stay ahead in the matter and keep getting today news all types of news for free till today so that you can get the news by getting it. Always take two steps forward
Credit Goes To News Website – This Original Content Owner News Website . This Is Not My Content So If You Want To Read Original Content You Can Follow Below Links