Logic Analysis Utility

Converts logic files to columnar format allowing formulas to be analysed with Excel AutoFilter. For more information see the Help section below. A Microsoft Access version of this utility which is ideal for analysing large logic files can be purcahsed.

1.	Logic to analyse: Extract logic from Enterprise and paste into this box.

2.
3.	Analysed logic: Click inside this box, press Ctrl+A to select all and Ctrl+C to copy.

4.	Paste into Excel.

Help

Overview

This script was developed to help manage a logic file that contained over 25,000 formulas. It takes a logic file like this:

[METHOD=CHART,Default Chart Logic                     ,MAXIMUM,A,]

[CATEGORY= ALL]
#GROSS_PROFIT=tot
#OPERATING_PROFIT=tot

[METHOD=CONSOL,Default Consolidation Logic             ,MAXIMUM,C,]

[METHOD=TRANS,Default Translation Logic               ,MAXIMUM,T,]

[CATEGORY= ALL]
#revenue=round(pva(@ACC,#fx_average),1)
#cost_of_sales=round(pva(@ACC,#fx_average),1)

[METHOD=CHARTDSM,Default DSM Chart Logic                 ,MAXIMUM,A,]

[CATEGORY= ALL]
#GROSS_PROFIT=tot
#OPERATING_PROFIT=tot

[METHOD=DYNVIEWACCTS,Dynamic View Accts                      ,MAXIMUM,A,]

[CATEGORY= ALL]
#gross_profit_precent=#GROSS_PROFIT/#revenue*100

and converts it to a tab delimited table that will look like this in Excel.

Target                 Method        Category  Formula
#GROSS_PROFIT          CHART         ALL       #GROSS_PROFIT=tot
#OPERATING_PROFIT      CHART         ALL       #OPERATING_PROFIT=tot
#revenue               TRANS         ALL       #revenue=round(pva(@ACC,#fx_average),1)
#cost_of_sales         TRANS         ALL       #cost_of_sales=round(pva(@ACC,#fx_average),1)
#GROSS_PROFIT          CHARTDSM      ALL       #GROSS_PROFIT=tot
#OPERATING_PROFIT      CHARTDSM      ALL       #OPERATING_PROFIT=tot
#gross_profit_precent  DYNVIEWACCTS  ALL       #gross_profit_precent=#GROSS_PROFIT/#revenue*100

You can then filter the table using AutoFilter and for example identify all the formulas that affect a particular account.

Technical

The logic file is analysed by JavaScript in your browser and no data ever leaves your browser.
The logic file is analysed entirely in memory and the script can crash. If this occurs try using a computer with more memory.

Large Logic Files

It may take a long time to analyse large logic files. For example a 800k file takes about 30 minutes to analyse on my laptop. Your browser status bar will indicate the section of the logic file being processed.
When pasting large logic files into the Formulas to Analyse and copying from the Analysed Logic box your browser may appear to crash. This is normal if you wait the operations will complete though this may take a few minutes.
The analysed logic output may exceed the 65,536 row limit in some versions of Excel

Microsoft Access

A Microsoft Access version of this utility is available for purchase please contact me for details.