What Every Technical Decision Actually Costs
Spreadsheet versions of the calculators and frameworks from the book. Each tool includes the formulas and methodology from the corresponding appendix, ready to customise with your organisation's data.
Three calculation frameworks for quantifying the economic cost of senior engineer departures: minimal (15 minutes), standard (30 minutes), and advanced (with tribal knowledge modelling). Produces defensible numbers suitable for executive presentations.
Use for: Retention business cases, attrition budgeting, comparing intervention costs against replacement costs
Download .xlsxSystematic framework for evaluating whether optimisation work is economically justified. Prevents the common failure mode where engineering time optimises components that do not meaningfully constrain system performance.
Use for: Prioritising performance work, building cases against premature optimisation, sprint planning
Download .xlsxTwenty-question diagnostic identifying whether engineering metrics are being gamed and quantifying severity. Organised into Detection, Severity, and Culture sections with scoring guides.
Use for: Quarterly metric health checks, dashboard reviews, identifying Goodhart's Law violations
Download .xlsxFive-year total cost of ownership model for evaluating technology choices. Covers hiring, productivity, ecosystem, optionality, and risk costs. Includes worked example comparing PostgreSQL versus Cassandra.
Use for: Database selection, language choices, deployment platform decisions, build vs buy analysis
Download .xlsxLightweight framework for tracking coordination failures prevented before they became production incidents. Produces rigorous data for calculating coordination ROI without bureaucratic overhead.
Use for: Measuring incident prevention, justifying coordination investments, team retrospectives
Download .xlsxPost-mortem template that captures what standard templates omit: whether anyone saw it coming. Includes prior warning documentation and pattern recognition across incidents.
Use for: Incident reviews, identifying systemic issues, measuring warning signal effectiveness
Download .xlsxMeasures total hiring costs and compares traditional interview-based hiring against trial-based hiring. Decomposes costs into three categories and reveals economic trade-offs at different company scales.
Use for: Hiring process redesign, comparing recruitment approaches, calculating cost per hire
Download .xlsxQuantifies the true cost of engineering onboarding and ROI of ramp acceleration programmes. Measures four distinct cost categories and evaluates interventions systematically.
Use for: Onboarding programme investment cases, measuring ramp time improvements, new hire budgeting
Download .xlsxAll spreadsheets are provided in .xlsx format, compatible with Microsoft Excel, Google Sheets, and LibreOffice Calc. Formulas are unlocked for customisation.
Found an error or have a suggestion? Email lloyd@codegood.co