Post by account_disabled on Sept 16, 2023 11:14:05 GMT
Excel Formulabot supports German, English, French, Spanish, Italian, and Turkish. In addition to the formula generator, it also provides a task generator for tasks not related to formulas. Examples include creating charts and pivot tables or sorting data.
The other two generators for scripts and regular expressions are still in beta. Unlike ChatGPT, Excel Formula Bot's script function does not explain how to use the VBA editor in Excel, but only explains the code of the generated script. Descriptions are provided in English.
The second beta, Regex, is a function for Phone Number List checking, comparing, and finding regular expressions. A regular expression can be a pattern consisting of a sequence of characters for example, finding all names in a table that contain Luis, Louis, or Lois. Excel Formula Bot generates the appropriate code.
All four generators work in the same way. First, you need to choose whether the code you want is for Excel or Google Spreadsheets. You can then choose between “Generate” and “Explain”. Enter the actual task in natural language in the field below. Click “Submit” and the tool will generate the code or explain the code.
Overall, I would rate this tool higher than ChatGPT in terms of being able to reach your goals faster. But there are also disadvantages. It's free, but there are conditions, and the basic version only allows 5 requests per month, so it runs out quickly. This is because code generation and explanation each count as one request. An unlimited account costs $6.99 per month.
Neural Formula
Neural formulas are cheaper. Users with free accounts can make up to 15 requests per month, and accounts with no limit on the number of requests cost $1.99 per month. In terms of functionality, Neural Formula is on par with Excel Formula Bot and also provides options for translating and changing formulas.
The downside is that it only supports English. Of course, it is possible to translate formulas created in English into German Excel format. For users who don't mind this limitation, Neural Formula is a cheaper Excel AI tool.
Excel formulator
Excel Formulator also supports only English. You can create up to 7 requests per month, and unlimited access costs $5.99 per month. Compared to the other two tools, the range of functions is narrow, providing only a formula generator and code explanation functions, and no other functions such as a translator.
AI Support for Excel: Final Evaluation
Overall, my favorite tool is Excel Formulabot. Among the three professional AI Excel tools, it is the most expensive, but its various functions and a user interface that supports multiple languages are its main attractions. Additionally, the procedures are more systematic compared to ChatGPT.
Also, currently, the free version of ChatGPT cannot be used reliably because the server is almost always overloaded except at night. Third place is Excel’s own “data analysis” function, which is worth using if you only need data visualization.
The other two generators for scripts and regular expressions are still in beta. Unlike ChatGPT, Excel Formula Bot's script function does not explain how to use the VBA editor in Excel, but only explains the code of the generated script. Descriptions are provided in English.
The second beta, Regex, is a function for Phone Number List checking, comparing, and finding regular expressions. A regular expression can be a pattern consisting of a sequence of characters for example, finding all names in a table that contain Luis, Louis, or Lois. Excel Formula Bot generates the appropriate code.
All four generators work in the same way. First, you need to choose whether the code you want is for Excel or Google Spreadsheets. You can then choose between “Generate” and “Explain”. Enter the actual task in natural language in the field below. Click “Submit” and the tool will generate the code or explain the code.
Overall, I would rate this tool higher than ChatGPT in terms of being able to reach your goals faster. But there are also disadvantages. It's free, but there are conditions, and the basic version only allows 5 requests per month, so it runs out quickly. This is because code generation and explanation each count as one request. An unlimited account costs $6.99 per month.
Neural Formula
Neural formulas are cheaper. Users with free accounts can make up to 15 requests per month, and accounts with no limit on the number of requests cost $1.99 per month. In terms of functionality, Neural Formula is on par with Excel Formula Bot and also provides options for translating and changing formulas.
The downside is that it only supports English. Of course, it is possible to translate formulas created in English into German Excel format. For users who don't mind this limitation, Neural Formula is a cheaper Excel AI tool.
Excel formulator
Excel Formulator also supports only English. You can create up to 7 requests per month, and unlimited access costs $5.99 per month. Compared to the other two tools, the range of functions is narrow, providing only a formula generator and code explanation functions, and no other functions such as a translator.
AI Support for Excel: Final Evaluation
Overall, my favorite tool is Excel Formulabot. Among the three professional AI Excel tools, it is the most expensive, but its various functions and a user interface that supports multiple languages are its main attractions. Additionally, the procedures are more systematic compared to ChatGPT.
Also, currently, the free version of ChatGPT cannot be used reliably because the server is almost always overloaded except at night. Third place is Excel’s own “data analysis” function, which is worth using if you only need data visualization.