Friday, August 23, 2019

Excelerator - Excel Formula Fast Fixer Windows App

Ever had the problem of finding errors in Excel formulas ?
Ever have to a missing double quotes inside an Excel formula ? = """ &A1&""" 
Ever have to a missing parenthesis inside a complex Excel formula ?

Then the Excelerator app is for you. Excelerator is intended for heavy users of Microsoft Excel such as business analyst, forecasters, information workers, accountants and CFOs. Anyone who deals with financial reporting

What is Excelerator and how can it help you? 

Excelerator - Excel Formula Fast Fixer is a separate windows application that allows you to quickly analyze and parse Excel formulas!

This program will deconstruct your complex formula and analyze each word. Each word is then validated against the Excel's Visual Basic for Applications (VBA) language and Excel functions

In example image below, the following formula is parsed.

=IFERROR(TRIM(IF(LEN(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE))>0,
   SUBSTITUTE(VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE), "te""st", "1"),"2")), "3")

Parsing the formula will detect and indicate all valid Excel functions and operators as named tokens. Invalid tokens will be identified. A token tree shows syntax indentation structure to easily to ascertain where errors can go wrong, like missing quotes or parenthesis's. 

Furthermore, the Formula Pit Stop area indicates common mistakes such as unpaired parenthesis or double quotes.
   


























































This tool currently is not sold separately, but part of https://clipboardplaintextpowertool.blogspot.com/