Saturday, November 23, 2019

Beautify Excel Formulas

Excelerator is an app that will beautify Excel formulas, but will do much more. This will check if those actual functions are valid in the Excel VBA language.

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 ?

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.

Why is this an application and not online?

Because it can perform complex formula analytics quickly and it protect your privacy from a number of rouge website that infect your computer with viruses. 

Here's another complex formula to analyze


=MID(SUBSTITUTE(SUBSTITUTE(B4,"/","^",LEN(B4)-LEN(SUBSTITUTE(B4,"/",""))),
    "/","!",LEN(B4)-LEN(SUBSTITUTE(B4,"/",""))-
  

























































Beautified Formula will appear in the Formula Pit Stop area.

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


Privacy Statement

Excelerator does not store or gather or forward any personal information by the developer or gives information to any third parties. No data or metadata is gathered by the tool. No information of any kind is stored, gathered or disseminated of any kind by the tool.

The only personal information gathered is for licensing, and that is issued via the licensing tool when you purchase the product and consists of your name, address and a hardware fingerprint. This information is kept strictly confidential and is not a share with any other party. Period.