Working engineering and commercial models, built in-house and shared as used.
EXCEL WORKBOOKS · OPEN WITH MACROS ENABLED WHERE MARKED .XLSM / .XLSB
Files are served directly up to 102.4 MB. Anything larger is listed here but sent another way — get in touch and it will be arranged.
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.xlsx · 38 KBAdds 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.xlsx · 68 KBThe 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.xlsm · 87 KBThe 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.xlsx · 71 KBBoth 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.
REV03_VBA_modules.txt · 7 KBFull fee-estimating workbook — builds scope, resource hours and rates into a transparent, defensible commercial fee.
AES-FEE-ESTIMATING-MODEL-2026-v4.xlsb · 4.1 MBAxial geotechnical pile capacity tool — shaft and base resistance with code-based checks, sized from 50m marine piling work.
AES-PILE-CAPACITY-2026.xlsb · 375 KBInstaller for the AES Markdown Viewer — a lightweight desktop application for viewing and navigating Markdown documents, styled to match this site. Version 1.0.0, Windows 64-bit. The installer is unsigned, so Windows SmartScreen may ask you to confirm: choose More info, then Run anyway.
AES-MD-Viewer-Setup_1_0_0.exe · 80.6 MBFiles download from this site. Open in Microsoft Excel; enable macros for .xlsm and .xlsb workbooks.
Site owner? Manage downloads →