Each part of the newsletter has its own file. Download the one that matches the article you are following, then build along.
The Inputs and Revenue sheets. Annual output, price, design life, discount rate, O&M and CAPEX, driving a fifteen-year payback table.
Adds the external currency list through Power Query and the conditional-formatting engine that swaps the currency symbol across the model. No macro required.
The finished build with the VB macro that auto-expands and contracts the cash-flow table to match the design life. Macro-enabled.
The same Part 03 model as a plain workbook, for paste-your-own-code along with the supplied module and worksheet event.
Both code blocks for Part 03 as plain text: the Worksheet_Change event for the Inputs sheet and the modRevenue standard module. Paste them into the macro-free workbook to build the auto-resizing cash-flow table yourself.
Files download from this page's own folder. Open in Microsoft Excel with macros enabled for the .xlsm workbook. Power Query refresh needs an internet connection for live exchange rates.
