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.

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 andCtrl+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

Large Logic Files