# The Data Center Power Handbook: companion files

Julian R. Sterling

## What is here

- **Data_Center_Power_Model.xlsx**: the workbook that rebuilds the Sable Ridge case and reproduces the figures of the book with live formulas. Sheets: Inputs, Load, Delivered cost, Tariff, Path A, Path B, Path C, Compare, VPPA, Checks.
- **Data_Center_Power_Toolkit.docx**: the 8 checklists of Appendix B (the load letter, reading a facilities study, reading a large-load tariff, the ESA term sheet, the lease power clauses, bridge power go or no-go, co-location approvals, the committee paper on power), in editable form.

## Which sheet answers which chapter

- Chapter 2: Load (the megawatt ladder, contract capacity, billing peak, load factor, energy)
- Chapters 5 and 8: Tariff (minimum billing demand, the slow-ramp shortfall, the exit fee, the security and its cost)
- Chapter 6: Delivered cost (energy, capacity, transmission, distribution and riders: $81.18 per MWh)
- Chapter 9: Path B (bridge power with gas engines)
- Chapter 10: Path C (co-location with the Corran Mill plant)
- Chapter 12: Path A, Path B, Path C and Compare (cost to the project budget against total economics)
- Chapter 13: VPPA (settlement of the virtual power purchase agreement)
- Chapter 15: Compare (the stress cases and how much of the rent not earned is a real cost)
- Appendix A: 18 exercises, two per sheet, with the answers the workbook returns

## Two inputs to change first

1. On Path A, move firm utility service for SR1 and SR2 six months later, to May 2030: watch path A's total economics climb and the ranking on Compare hold.
2. On Path C, move the co-located supply six months later, to May 2029: see how fast path C loses its lead. 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, green type a link to another sheet. Case-wide inputs are on the Inputs sheet; each topic sheet opens with its own input block. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Larkfield Digital Infrastructure, the Sable Ridge campus, the Corran Mill plant, the tenant, the utility and the regional market are fictional; rates, prices, costs and dates are teaching assumptions, not the tariff of any real utility, the price of any real market or a forecast. Provided as is, without warranty. Not legal, regulatory, engineering or investment advice.
