Companion files · The Private Markets Career Guides

The Data Center Construction Handbook

Delivering Hyperscale and Colocation Projects on Time and on Budget: The GMP, Long-Lead Equipment, Earned Value, Change Orders and Commissioning.

These are the companion files of the book. One workbook rebuilds BC1, the fictional 48 MW building that Harrowgate Data Centers delivers at its Brennan Creek campus, from design in 2024 to its integrated systems test in October 2026: the budget and its cost per megawatt, the milestones and the long-lead register, the planned spending curve and the earned value at the April 2026 data date, the switchgear delay and its three recovery options, the owner’s contingency log and the safety rate. A toolkit holds the checklists of Appendix B in an editable form. Around them: a blank copy of the workbook for your own project, eight documents to print, forty questions and three cases the book names but does not work.

All the companion files and the read-me, in one archive182 KB

The archive holds the workbook, the toolkit, the blank model set, eight working documents, forty questions and three new worked cases, with 00_START_HERE.md at its root. Each group below can also be downloaded on its own. Last revised 16 November 2026. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

Get an email if these files are corrected

Optional. When the workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.

Join the reader list

Run by MailerLite, off this site. How your address is used.

The files

The documents the chapters describe

Eight pages to print and use. A4, with margins wide enough for US Letter.

Three cases the book does not work

New material, not a restatement. Each case takes a situation the book names and does not compute. Each is the companion workbook with three sheets in front: the note, the case beside the book, and checks that end ALL OK. Values the book does not give are inputs, marked ADDED.

Three numbers to reproduce first

Cost per megawattA $560.0 million budget for 48 MW of critical IT is $11.67 million per MW; electrical systems are 38 percent of the money
Earned valueAt 30 April 2026: earned value $313.0 million against $336.7 million planned and $322.0 million spent, SPI 0.93, CPI 0.97, estimate at completion $550.4 million
The delayA 12-week switchgear slip costs Harrowgate $22.6 million if accepted, $10.0 million if expedited and $3.1 million if the tranche 2 lineups are reallocated

What changed, and when

16 Nov 2026Revised the workbook: the long-lead register on the Schedule sheet now computes from inputs and shows the float Appendix A describes, and delay credits count both tranches; every printed figure is unchanged and the Checks sheet compares 32. Added eight working documents to print, the blank model set with the book’s inputs, forty self-marking questions and three new worked cases (a late lease also ends late, the float option C spent, three estimates at completion).
11 Oct 2026Companion files published with the book.

The files are provided as they are, without warranty of any kind. The model is illustrative: Harrowgate Data Centers, the Brennan Creek campus, the tenant, contractors and suppliers are fictional, and lead times, rents and costs are the book’s assumptions, not market terms or forecasts. Nothing here is engineering, legal, safety or investment advice.

Free: the Private Markets Interview Cheat Sheet

Forty private markets interview questions with model answers and the arithmetic worked out. Direct download, no sign-up.

Get the cheat sheet

Explore the full companion library

Discover more of Julian R. Sterling's practical library of models, checklists and worked cases.

Browse Julian R. Sterling's books Browse all companion files

Learn to develop and finance a data center campus, step by step: the Data Center Development & Finance course →