Formula Analyser / Analyzer - Anyone written one?

[dransfield]

I wrote a formula analayser years ago, and I find it very useful.
Its very basic. Where you've got a formula like:
=sheet1!A1+sheet21A1+OtherSheet!A1
it parses on the plusses, and lists each part and what its value is in
a form, and then gives you the option to dump it to an new sheet.
It can't handle anything fancy, and fails eg, for =sum(A1:A20), but it
is rediculously useful for financial stuff.

Its so useful that I reckon some of you gurus will have written much
better analysers - anyone got one they would be happy to share? Or any
similar tools in your toolbox?

Regards,
Dz

PS. Of course if anyone would like a copy of mine I'd be happy to
share it.

 

[Gary''s Student]

Check out Joel's post in:

http://groups.google.com/group/micr...00?lnk=gst&q="parse+formula"#2e14476716018400

 

[Charles Williams]

Look at Rob Van Gelder's formula parsing adding AudXL
http://www.vangelder.orconhosting.net.nz/

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com