Counting the number of calculations on a speadsheet
 

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

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

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

Thanks!
Steve


--
stevesquared
------------------------------------------------------------------------
stevesquared's Profile: http://www.excelforum.com/member.php...o&userid=33725
View this thread: http://www.excelforum.com/showthread...hreadid=535052

Counting the number of calculations on a speadsheet
 

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"
wrote in message
news:stevesquared.26mlhm_1145642104.4591@excelforu m-nospam.com...

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

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

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

Thanks!
Steve


--
stevesquared
------------------------------------------------------------------------
stevesquared's Profile:
http://www.excelforum.com/member.php...o&userid=33725
View this thread: http://www.excelforum.com/showthread...hreadid=535052