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.

Check out Joel's post in:

http://groups.google.com/group/micro... 4476716018400
--
Gary''s Student - gsnu2007j


"dransfield" wrote:

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.

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

"dransfield" wrote in message
...
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.