Companion files · The Private Markets Career Guides
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.
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.
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 listRun by MailerLite, off this site. How your address is used.
Chapters 2, 5, 7 to 10 and 12
One Inputs sheet holds every assumption: the building and the lease, the twelve budget lines, the earned value data, the switchgear delay options, the contingency draws and the safety data. One sheet per topic, and a Checks sheet that puts 32 figures printed in the book beside the cells that compute them. Revised 16 November 2026: the long-lead register now computes from inputs and shows each item’s float, as Appendix A describes, and delay credits count both tranches; no printed figure changes.
Download the workbook20 KBAppendix B
Project kickoff, GMP review, long-lead register, schedule review, monthly cost report outline, change order review, site safety walk, commissioning readiness, and handover and closeout.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me5 KBFor your own project · Appendix A
The same workbook with its 60 inputs emptied: the building and the lease, the twelve budget lines, retainage, the earned value data, the delay options, the contingency draws, safety and the long-lead register. Until every input is filled, every formula shows nothing and Inputs counts what is missing; 15 identities check the result. The book’s inputs are listed cell by cell in book_inputs.txt, and refilled from it the blank set reproduces the full workbook cell for cell.
Download the blank set21 KBChapters 2 to 15 · The three cases
Six parts: the project and the budget; contracts, long-lead equipment and the schedule; cost and earned value; changes and the switchgear delay; safety, commissioning and handover; and the three new cases. Numbers and multiple choice, marked as you type; a score sheet tells you which part to revise; the marking sheet gives every answer and its reason.
Download the questions14 KBEight pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 15 · Appendix B
The kickoff page with the lease dates, grace, credits and termination on top; the long-lead register with float per item and per tranche; the delay valuation sheet, with the cost to the project budget beside the cost to the developer; the owner’s cost report and the contingency log with its type column; the monthly earned value table, split between the construction manager’s scope and owner-furnished equipment; the change order review form with its mandatory schedule line; the site safety walk and safety record; and commissioning readiness and handover, with the warranty register.
Download the PDF24 KBNew 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.
Chapters 2, 7 and 12 · Appendix C · Case one
The book counts a late week as a week of rent lost and calls it a simplification. At an 8 percent discount rate the week comes back in year 16 and really costs $0.53 million, not $0.78 million. The three options total $18.66, $9.02 and $2.56 million instead of $22.57, $10.00 and $3.05 million, and the ranking never changes: the delay credits alone make accepting the worst choice.
Chapter 12 · Case two
“If the manufacturer had missed its end-of-August promise by more than about a month, tranche 2 would have slipped.” The first four weeks are free; then about $1.13 million a week, and $1.90 million once credits start at 8.29 weeks. A second slip of 9.41 weeks makes option C as dear as expediting; a repeat 12-week slip would cost $11.88 million.
Chapters 9 and 10 · Case three
Besides the book’s $550.4 million, the two other standard estimates give $544.0 and $567.7 million, the last $7.7 million above the approved total. The remaining work needs a TCPI of 1.04 to land on the budget at completion, but 0.933 to stay within $560.0 million, and the October forecast sits $1.22 million above the April formula.
Download the three cases72 KB| Cost per megawatt | A $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 value | At 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 delay | A 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 |
| 16 Nov 2026 | Revised 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 2026 | Companion 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.
Forty private markets interview questions with model answers and the arithmetic worked out. Direct download, no sign-up.
Get the cheat sheetDiscover more of Julian R. Sterling's practical library of models, checklists and worked cases.
Browse Julian R. Sterling's books Browse all companion filesLearn to develop and finance a data center campus, step by step: the Data Center Development & Finance course →