Thanks for following the Financial Modelling Handbook Project.
"You used ctrl+x to cut the Annual Real O&M cost input from the bottom of the sheet, how do you go about pasting this in above?" - Angus
I've just posted the latest version of the Productivity Pack macros. We've been working on this for several months. A lot of the focus has been on ironing out bugs and improving the underlying code. We've also added a few new tools and updated the functionality of existing tools. Check
Conditional formatting is extremely useful. You'll find it in several places in the Handbook models. It's easy to lose track of all the conditional formats in your model. Excessive conditional formatting can cause file size bloat, and so we want to be able to check and remove conditional formatting easily.
Deleting Range Names is fiddly and annoying. This tool deletes all your unwanted Range Names.
Range Names can be extremely useful. They can also be a mess if not well maintained.
Adding multi-language support for financial models
This is useful for model audits, and for general formula reviews.
Bad people are hiding things in your model. Don't let them get away with it.
Looks like we're getting close to the finish line!