# The Data Center Construction Handbook: companion files

Julian R. Sterling

## What is here

- **Data_Center_Construction_Model.xlsx**: the workbook that rebuilds the Harrowgate case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Budget, Schedule, Earned Value, Delay Options, Contingency, Safety, Checks.
- **Data_Center_Construction_Toolkit.docx**: the checklists and outlines of Appendix B (project kickoff, GMP review, long-lead register, schedule review, monthly cost report outline, change order review, site safety walk, commissioning readiness, handover and closeout), in editable form.

## Which sheet answers which chapter

- Chapter 2: Budget (the twelve lines, the four buckets, cost per MW, the electrical share, the gross rent yield on cost)
- Chapters 5 and 7: Schedule (milestones, the long-lead register, what a week of delay costs in rent)
- Chapter 8: Safety (the total recordable incident rate)
- Chapter 9: Contingency (the owner's contingency log and the forecast final cost)
- Chapter 10: Earned Value (the planned curve, PV, EV, AC, SPI, CPI, EAC, VAC and TCPI at 30 April 2026)
- Chapter 12: Delay Options (accept, expedite or reallocate, with the cost to the budget beside the cost to the developer)

## Two inputs to change first

1. On Inputs, change the supplier slip from 12 weeks: watch the three options move on the Delay Options sheet, and see when the delay credits start.
2. On Inputs, change the physical percent complete at the data date: see what SPI, CPI and the estimate at completion say. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Harrowgate Data Centers, the Brennan Creek campus, BC1, the tenant, contractors and suppliers are fictional; lead times, rents and costs are illustrative assumptions, not market data or forecasts. Provided as is, without warranty. Not engineering, legal, safety or investment advice.

## Revised 16 November 2026

The pack is extended, and the workbook is revised without changing any printed figure.

- Revision of `Data_Center_Construction_Model.xlsx`. Appendix A describes a Schedule sheet with the float of the long-lead register, driven by inputs; the sheet held only text. The lead times, order months and need-by months are now inputs (Inputs rows 48 to 70), and Schedule computes each item's ordering margin and the tranche 2 switchgear float before and after option C (16 and 4 weeks). Delay credits on the Delay Options sheet now count both tranches (tranche 2 was ignored; in the book it is 28 days late under option A, inside the grace, so nothing changes). Checks now compares 32 printed figures and reads ALL CHECKS OK.
- `Working_Documents.pdf`: eight pages to print. The kickoff page with the lease on top, the long-lead register with float, the delay valuation sheet, the owner's cost report and contingency log, the monthly earned value table, the change order review form, the site safety walk and safety record, and commissioning readiness and handover (Appendix B and Chapters 2 to 15).
- `Blank/Data_Center_Construction_Model_Blank.xlsx` and `Blank/book_inputs.txt`: the workbook with its 60 inputs emptied. It computes once every input is filled; 15 identities check it for any inputs. Refilled from book_inputs.txt it reproduces the full workbook cell for cell.
- `Forty_Questions.xlsx`: forty questions in six parts (the project and the budget; contracts, equipment and the schedule; cost and earned value; changes and the switchgear delay; safety, commissioning and handover; the three cases), marked as you type.
- `Cases/`: three worked cases on situations the book names without computing them. Each workbook is the companion model with its note, a case sheet and a checks sheet that ends ALL OK. Values not in the book are marked ADDED.
  - `Case_1_A_Late_Lease_Also_Ends_Late.xlsx`: the book counts a late week as a week of rent lost and calls it a simplification. At an 8 percent discount rate (ADDED), a late week really costs $0.53 million, not $0.78 million; the 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. Without delay credits, accepting would beat expediting only below 2.31 percent a year.
  - `Case_2_The_Float_Option_C_Spent.xlsx`: option C left tranche 2 four weeks of float. A repeat 12-week slip of the late lineups (ADDED) would cost $11.88 million and make option C dearer than expediting; the break-even second slip is 9.41 weeks, delay credits start at 8.29 weeks, and C stays the better bet unless that repeat slip is more than 58.5 percent likely.
  - `Case_3_Three_Estimates_at_Completion.xlsx`: besides the book's $550.4 million, the two other standard estimates give $544.0 and $567.7 million; the last is $7.7 million above the approved total. The remaining work needs a TCPI of 1.04 to land on the BAC but 0.933 to stay within $560.0 million, and the October forecast sits $1.22 million above the April formula.
