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.
AES-INTERACTIVE-CURRENCY-REV01.xlsxAdds the external currency list through Power Query and the conditional-formatting engine that swaps the currency symbol across the model. No macro required.
AES-INTERACTIVE-CURRENCY-REV02.xlsxThe finished build with the VB macro that auto-expands and contracts the cash-flow table to match the design life. Macro-enabled.
AES-INTERACTIVE-CURRENCY-REV03.xlsmThe same Part 03 model as a plain workbook, for paste-your-own-code along with the supplied module and worksheet event.
AES-INTERACTIVE-CURRENCY-REV03.xlsxOpen in Microsoft Excel with macros enabled for the .xlsm workbook. Power Query refresh needs an internet connection.