Formula Review Tool

Replies to This Discussion

Permalink Reply by Jeff Robson on March 9, 2009 at 10:11am

This is a fantastic little tool that makes it sooooo much easier to trace formulas around your spreadsheet. We've been using it in our spreadsheet auditing practice for years - it really works a treat!

▶ Reply to This

Permalink Reply by Mike Willerton on March 9, 2009 at 10:39am

i am sure it is a very useful tool but one wonders whether the formula used in the example , which has only three precedents , could have been derived in a more simple manner by using simple calculation blocks ; without any names ; and having an overall length less than that of my thumb ... and you could even trace it back using ctrl + [ .... and especially if it only referred to one column in a series of columns ... hoh hum now't so strange as other peoples use of excel

▶ Reply to This

Permalink Reply by Nicolas Boston on March 9, 2009 at 6:04pm

Thanks Mike

Please focus on the topic of this discussion which is in relation to a helpful formula review tool, rather than views on the optimal construct of formulae. In my experience, one rarely gets to choose how the models they review have been constructed, hence any tool that makes life easier is bound to be worth sharing with finance 3.0 members!

This formula was chosen due to its complexity and to demonstrate how the tool can help - I encourage you to download and try the tool on your own complex formula.

Regards

▶ Reply to This

Permalink Reply by Gunjan Gupta on March 10, 2009 at 1:37am

Hi Nicolas,

It is really worth piece of info and tool. And I agree with your opinion.

Only efficient people can think complex things rather than thinking of the easiest way ALWAYS. I am sure easiest ways are nice but not always. Ok Mike. We need to graduate our level of working as we gain more experience. Bottom line as Nicolas has said stick to the OBJECTIVE of discussion. Nothing personal. :)

Cheers

▶ Reply to This

Permalink Reply by Joe Zepeda on March 9, 2009 at 2:56pm

Do you have a Mac version?

▶ Reply to This

Permalink Reply by Nicolas Boston on March 9, 2009 at 6:06pm

Hi Joe

Unfortunately there is no MAC version available yet. I have heard of people using on a MAC however this is through a Microsoft operating system.

Kind Regards

▶ Reply to This

Permalink Reply by Robert Searson on March 9, 2009 at 6:40pm

Thanks. I have tried the review tool tool on formulas and it looks great.

▶ Reply to This

Permalink Reply by Nicolas Boston on March 9, 2009 at 10:36pm

Great to hear Robert - Thanks for your comments!

▶ Reply to This

Permalink Reply by saket on March 10, 2009 at 1:37am

Hi Nicolas,

Thanks a lot.

Its really a very handy tool and makes life much easier.

Regards,

Saket

▶ Reply to This

Permalink Reply by Nicolas Boston on March 17, 2009 at 7:20pm

Great to hear Saket!

▶ Reply to This

Permalink Reply by Deepak Kumar Shaw on March 10, 2009 at 6:47am

Great tool mate. It makes life easier.

▶ Reply to This

Permalink Reply by Nicolas Boston on March 17, 2009 at 7:20pm

Thanks Deepak. Hope you get plenty of use out of it!

▶ Reply to This

• ‹ Previous
• 1
• 2
• Next ›
• Page