Finance 3.0 - Social Network for Finance
Smart financial thinking
HI Again
I thought you Excel Gurus might be interested in a free Excel-based add-in which can broadly be described as a formula auditing tool.
The tool (known as bpmtraverse) makes it easier to get your head around complex formulae by breaking a formula down into it's components / precedents. You can see in the below picture that the tool contains two windows:
The top window re-states the formula. Hovering over any function will solve for a result.
The bottom window displays the unique precedents contained wihin the formula. You can then click on those precedents in order to step back through your formula (using the left and right arrows will also work).
As you can see in the above example, what appears to be a pretty longwinded formula actually only contains three major precedents!
There's a heap more to the tool and it contains a help button which can be viewed after installation.
I've included both the raw XLA below along with an EXE file which makes installation a bit easier as it automatically links up the add-in.
I thought you Excel Gurus might be interested in a free Excel-based add-in which can broadly be described as a formula auditing tool.
The tool (known as bpmtraverse) makes it easier to get your head around complex formulae by breaking a formula down into it's components / precedents. You can see in the below picture that the tool contains two windows:
The top window re-states the formula. Hovering over any function will solve for a result.
The bottom window displays the unique precedents contained wihin the formula. You can then click on those precedents in order to step back through your formula (using the left and right arrows will also work).
As you can see in the above example, what appears to be a pretty longwinded formula actually only contains three major precedents!
There's a heap more to the tool and it contains a help button which can be viewed after installation.
I've included both the raw XLA below along with an EXE file which makes installation a bit easier as it automatically links up the add-in.
Tags: add-in, auditing, bpmtraverse, formula, review, tools, xla
- Attachments:
-
-
bpmTraverse.xla, 1.2 MB -
bpmTraverse.exe, 1.9 MB
-
Replies to This Discussion
-
Permalink Reply by Yasir Bilal on -
Hi Nicolas
Ihave downloaded this feature/add in.
what and how and when to use it please brief me a bit.
Thanks
-
Permalink Reply by zafar on -
hello this is zafar from pakistan,
i need all formulas using in the Execl sheet.
Regards
zafar
-
Permalink Reply by Steve Swann on -
Hi Nicolas - thank you very much for directing us to this tool
-
Permalink Reply by Nicolas Boston on -
No problems Steve - hope it's of use. I've noticed that there are similar tools to this that are being sold for around US$40 so this is a relative bargain at no cost!
Cheers
-
Permalink Reply by Vikas Gangwal on -
Hi Nicolas,
Thanks for sharing this.
This tool is really great tool. I really like it, do you have some more of these sorts. Please do share, if you can.
Regards,
Vikas
-
Permalink Reply by Ramsey Bradley on
-
You are awesome ....very fantastic tool...Big Thank you!!!!!
- ‹ Previous
- 1
- 2
- Next ›
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0
