Even though I have some knowledge of excel formulas I may forget why I have created a particular formula. I have quite a few long ones. Formula dog actually helps me quickly review and understand the formulas that may have taken me hours to create but that I've forgotten now because so much time has passed. I have found when I'm creating new formulas in excel that it's best to think about it first and be specific. Breaking up your long formula into smaller chunks, feeding it into formula dog and then putting it together yourself works best for now. Hopefully this will improve. I really like the sequel function of the app. I was surprised that It actually allows me to create a simulated a database and then test queries on it. It's helping me learn database structure and queries before I actually have to create the database. Kinda cool. Hopefully I'll be able to play with vba in the future which has been challenging for me to learn.
Formula Dog barely does what it claims. Its answers are minimal, lacking context, can't be modified, and are occasionally wrong. In order to keep this, the tool would have to give me some sort of advantage over just going to ChatGPT and asking that AI directly. It doesn't.
I tested it with the both the creation of spreadsheet formulas and explaining existing formulas. I also had it explain Regex code.
I started with a complex Google Sheets formula that I wanted it to build. I described to ChatGPT what the formula needed to do. It gave me the formula along with explanation of what the various parts do.
I decided that I wanted to refine the formula, so I told ChatGPT "Please modify the formula in cell F2 to display a number if numeric values exist in all of cells B2 through E2, but display the word "ERROR" if any of cells B2 through E2 are blank or contain non-numeric values." I was able to do several rounds of this until I got what I wanted. ChatGPT retained knowledge of my original query and modified the formula based on my later changes. The answers it gave were always correct and had a lot of additional explanation and context.
I then fed the final version of my query into Formula Dog. Formula Dog gave me the correct formula, but there was no explanation or context.
I also fed FD my orignal ChatGPT prompt. After FD gave me the answer, I tried to refine the formula as I had with ChatGPT. I told it "Please modify the formula in cell F2 to…[etc.]". Unfortunately, FD has no memory of what you did before. Formula Dog just GUESSED about what I was talking about. It correctly got the part of the formula related to what I had mentioned in the most-recent prompt, but the rest of the formula was missing. This is a clear failure.
Next I tried having the AIs explain the Google Sheets formula (try it yourself!): =IF(AND(ISNUMBER(B2), ISNUMBER(C2), ISNUMBER(D2), ISNUMBER(E2)), (E2*D2)-(B2+C2*D2), "ERROR")
ChatGPT thoroughly explained the formula. It even broke out the second formula in there and explained that one by itself. Formula Dog just gave me a terse (but correct) answer. If I were having trouble trying to understand a complex spreadsheet, the ChatGPT answer is way more helpful.
Finally, I had the AIs explain this regex code (try it yourself!): .?(\\d{3}).*(\\d{3}).*(\\d{4})
ChatGPT's answer was correct and thoroughly explained. Formula Dog gave a typically sparse answer that was incorrect in two ways.
ChatGPT said: "The initial . and ? together match an optional single character at the beginning of the string." Formula Dog didn't even mention that string, let alone tell me that it was optional.
ChatGPT also said: ".*: Matches zero or more occurrences of any character except a newline." Formula Dog said: "followed by any number of characters" This does not specify that "any number" could be zero. It also doesn't mention the newline.
I'm going to hang onto this for seven weeks to see if it gets a lot better. If not, I'm refunding.
Knowing that ChatGPT can handle all of this I wasn't encouraged to buy it at first. but then it was clear that I was about to miss an incredible tool! Considering that I have UNLIMITED Credits, Google Sheets Add-on, and support for many languages and for SQL, Regex, Sheets, and not only Excel (and all upcoming updates). Having a dedicated all-in-one tool for all of these is incredible. Happy I didn't miss the deal. And I hope they come back so other Sumolings can have another chance to get it!
So as I said I did have doubts. Not so much about FormulaDog but about me. Could I make it work? I've had very little experience with Excel. But recently I have been needing to use Excel more and more recently. So far I've been getting help from friends. Well, looks like I'm going to be doing my own formulas from now on. This works and it's working well for me. Thanks FormulaDog
CHATGPT is not used to make calculations, but what it can do is that you can use the Google Sheet or Excel to do your mathematics. FORMULA.DOG will almost undoubtedly be a TOP 10 of my best purchases in APPSUMO, although it still has small details that are not going well has much margin for improvement and to add new things. The sheets are very powerful and thanks to FORMULA.DOG we have an instructor for little money and very fast.
I want to point out that the program has a button to report errors in a fast way, I recently reported several but everything is still the same. The errors I mean are for example the use of , instead of ; in many (or almost all) in the Goggle Sheet, for example:
ramdom number betweet 1 and 10 =RANDBETWEEN(1,10) This is incorrect, correct is =RANDBETWEEN(1;10)
If R7 is less than J7 one, othewise is "Z" =IF(R7<J7,1,"Z") This is incorrect, correct is =IF(R7<=J7;1;"Z")
Verified purchaser
Time saver even if you have some experience.
Even though I have some knowledge of excel formulas I may forget why I have created a particular formula. I have quite a few long ones. Formula dog actually helps me quickly review and understand the formulas that may have taken me hours to create but that I've forgotten now because so much time has passed. I have found when I'm creating new formulas in excel that it's best to think about it first and be specific. Breaking up your long formula into smaller chunks, feeding it into formula dog and then putting it together yourself works best for now. Hopefully this will improve. I really like the sequel function of the app. I was surprised that It actually allows me to create a simulated a database and then test queries on it. It's helping me learn database structure and queries before I actually have to create the database. Kinda cool. Hopefully I'll be able to play with vba in the future which has been challenging for me to learn.
Share Formula.dog
Verified purchaser
Barely does what it claims
Formula Dog barely does what it claims. Its answers are minimal, lacking context, can't be modified, and are occasionally wrong. In order to keep this, the tool would have to give me some sort of advantage over just going to ChatGPT and asking that AI directly. It doesn't.
I tested it with the both the creation of spreadsheet formulas and explaining existing formulas. I also had it explain Regex code.
I started with a complex Google Sheets formula that I wanted it to build. I described to ChatGPT what the formula needed to do. It gave me the formula along with explanation of what the various parts do.
I decided that I wanted to refine the formula, so I told ChatGPT "Please modify the formula in cell F2 to display a number if numeric values exist in all of cells B2 through E2, but display the word "ERROR" if any of cells B2 through E2 are blank or contain non-numeric values." I was able to do several rounds of this until I got what I wanted. ChatGPT retained knowledge of my original query and modified the formula based on my later changes. The answers it gave were always correct and had a lot of additional explanation and context.
I then fed the final version of my query into Formula Dog. Formula Dog gave me the correct formula, but there was no explanation or context.
I also fed FD my orignal ChatGPT prompt. After FD gave me the answer, I tried to refine the formula as I had with ChatGPT. I told it "Please modify the formula in cell F2 to…[etc.]". Unfortunately, FD has no memory of what you did before. Formula Dog just GUESSED about what I was talking about. It correctly got the part of the formula related to what I had mentioned in the most-recent prompt, but the rest of the formula was missing. This is a clear failure.
Next I tried having the AIs explain the Google Sheets formula (try it yourself!):
=IF(AND(ISNUMBER(B2), ISNUMBER(C2), ISNUMBER(D2), ISNUMBER(E2)), (E2*D2)-(B2+C2*D2), "ERROR")
ChatGPT thoroughly explained the formula. It even broke out the second formula in there and explained that one by itself. Formula Dog just gave me a terse (but correct) answer. If I were having trouble trying to understand a complex spreadsheet, the ChatGPT answer is way more helpful.
Finally, I had the AIs explain this regex code (try it yourself!):
.?(\\d{3}).*(\\d{3}).*(\\d{4})
ChatGPT's answer was correct and thoroughly explained. Formula Dog gave a typically sparse answer that was incorrect in two ways.
ChatGPT said:
"The initial . and ? together match an optional single character at the beginning of the string."
Formula Dog didn't even mention that string, let alone tell me that it was optional.
ChatGPT also said:
".*: Matches zero or more occurrences of any character except a newline."
Formula Dog said:
"followed by any number of characters"
This does not specify that "any number" could be zero. It also doesn't mention the newline.
I'm going to hang onto this for seven weeks to see if it gets a lot better. If not, I'm refunding.
Share Formula.dog
Verified purchaser
Really Interesting tool!
Knowing that ChatGPT can handle all of this I wasn't encouraged to buy it at first. but then it was clear that I was about to miss an incredible tool! Considering that I have UNLIMITED Credits, Google Sheets Add-on, and support for many languages and for SQL, Regex, Sheets, and not only Excel (and all upcoming updates). Having a dedicated all-in-one tool for all of these is incredible. Happy I didn't miss the deal. And I hope they come back so other Sumolings can have another chance to get it!
Share Formula.dog
Verified purchaser
I had doubts but doubt no more
So as I said I did have doubts. Not so much about FormulaDog but about me. Could I make it work? I've had very little experience with Excel. But recently I have been needing to use Excel more and more recently. So far I've been getting help from friends.
Well, looks like I'm going to be doing my own formulas from now on. This works and it's working well for me.
Thanks FormulaDog
Share Formula.dog
Verified purchaser
THANKS FOR FORMULA.DOG
CHATGPT is not used to make calculations, but what it can do is that you can use the Google Sheet or Excel to do your mathematics. FORMULA.DOG will almost undoubtedly be a TOP 10 of my best purchases in APPSUMO, although it still has small details that are not going well has much margin for improvement and to add new things. The sheets are very powerful and thanks to FORMULA.DOG we have an instructor for little money and very fast.
I want to point out that the program has a button to report errors in a fast way, I recently reported several but everything is still the same. The errors I mean are for example the use of , instead of ; in many (or almost all) in the Goggle Sheet, for example:
ramdom number betweet 1 and 10
=RANDBETWEEN(1,10) This is incorrect, correct is =RANDBETWEEN(1;10)
If R7 is less than J7 one, othewise is "Z"
=IF(R7<J7,1,"Z") This is incorrect, correct is =IF(R7<=J7;1;"Z")
Share Formula.dog