Companion files · The Data Center Operations Handbook
Running, Leasing and Scaling Colocation and Hyperscale Facilities: Uptime, Power, Cooling, Contracts and the Economics of a Live Data Center.
These are the companion files of the book. One workbook rebuilds Varden Point, the fictional 36 MW campus the book follows from the day its builder leaves: a retail colocation building, a wholesale building in suites and a building leased to a hyperscale tenant, month by month for three years. It computes capacity, PUE, rent, energy billed and bought, the operating budget, the loan and every figure the book prints. A second file holds the operating checklists and templates of Appendix B in editable form. No sign-up, no email is asked for, nothing is locked. Amounts are in US dollars; blue type is an input, black type is a formula.
The archive holds the workbook, the checklists and 00_START_HERE.md. 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 1 to 16 · Appendix A
One Inputs sheet holds every assumption. Monthly rebuilds 36 months: sold and drawn capacity, PUE by building, rent, cross-connects, services, energy billed under three structures and bought from the utility, the energy margin, churn and commissions. Annual gives the three-year budget, per-megawatt measures, water, emissions, the loan and its DSCR. Then the cooling levers, the staffing models, the generator, circuit and incident arithmetic, the maintenance program, the UPS block mapping, the price floor, the hyperscale ramp and the retrofit, and a Checks sheet that sets 86 figures the book prints beside the cells that compute them.
Download the workbook62 KBAppendix B
The first ninety days after handover, the method of procedure template, the incident report template, the monthly pack front page, opening a hall, and the lender appendix. Edit them for your own site.
Download the checklists39 KBRead first
What the files are, which tab answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The empty halls | Conditioning all four retail halls from day one would have taken the month-1 PUE of Building A from 1.45 to 2.09 and cost $0.35 million of energy margin in year 1 |
| The last suite | Building B has 1,500 kW unsold on paper, but no pair of UPS blocks can take a standard suite: it sells as 1,200 kW, and 300 kW stay stranded |
| The loan | The DSCR moves from 0.62x in year 1, carried by an interest reserve, to 1.56x in year 3, when recurring revenue could fall 15.7 percent before lock-up |
The files are provided as they are, without warranty of any kind. The model is illustrative: Varden Point, its owner, operator, customers, tenant and lender are fictional, and the figures are the book's assumptions, not market statistics. Nothing here is engineering, legal, tax, accounting 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 files