Counting the number of calculations on a speadsheet

S

stevesquared

I design very large data models using Excel that calculates fundin
levels for a government program I administer.

I am trying to quantify the degree of sophistication of a particula
data model for a layman.

Does anyone know an easy way to get Excel to compute for me how man
individual calculations are present in a particular workbook? By this
mean looking at each formula and determining how many discree
calculations are required (i.e. a nested Vlookup inside nested I
statements could easily be 10 or more unique calculations).

Thanks!
Stev
 
C

Charles Williams

Most of the available auditing tools will give you counts of unique formulae
and some will give complexity measures as well, but I dont know of anything
that does exactly what you want.


Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"stevesquared" <[email protected]>
wrote in message
news:[email protected]...
 
Top