Water Ledger Michigan

Methods and sources

How Water Ledger's numbers are made

Model version and data date load below.

This is Michigan's full methods page. The model is the same in every state; how other states are built, and a methods page for each, are at methods for every state.

What it estimates

For a data center of a given size, cooling design and Michigan climate region, Water Ledger estimates three amounts of water on an average day, on the hottest days (a 1-in-10-year peak day) and over a year:

Water used at power plants to make the electricity is shown separately and never added to these on-site numbers.

It also shows the place before and after: public water, the sewer plant, runoff, sediment, phosphorus, road salt, generator fuel and electricity, today and with the campus.

How

  1. Weather. Hourly temperature and humidity for 1995–2024 at eight Michigan locations, one per climate region (ERA5 reanalysis) ; wet-bulb temperature from Stull's formula .
  2. Heat. The campus's electricity becomes heat that must be removed: computers, power losses, lighting, fans, pumps and chillers. Outside air, brought in to ventilate the building, adds or takes away a little more. Heat through the water or coil is all of that except the heat rejection fans, whose heat goes straight to the exhaust air (model 1.5). An economizer carries as much as the weather allows and chillers carry the rest .
  3. Evaporation. Evaporative cooling removes heat by evaporating water (about 1,050 BTU per pound). The share of heat removed by evaporation rises with air temperature; we use the relation from Rutberg et al. (2011) as given in the U.S. Geological Survey's method for cooling towers .
  4. Blowdown and drift. A small amount escapes as droplets (drift), a share of the water passing through the wet part of the cooler . Towers also drain water to control minerals. Minerals in must equal minerals out, so blowdown + drift = evaporation ÷ (cycles of concentration − 1) . The model samples 3 to 7 cycles. FEMP calls two to four typical and six or more possible, so the range sits above its typical one, and no figure for large campuses is published [A]. At the middle of each range, 2 to 4 cycles would take about 20% more water than 3 to 7 (1.5 times the evaporation against 1.25), all of it as blowdown.
  5. Lost to evaporation and wastewater. Every gallon taken is either lost to evaporation (cooling, drift, leaks, humidifiers) or becomes wastewater, to the sewer or a stream (blowdown and nearly all sanitary use). Wastewater also carries the condensate from outside air, which was never taken from a water system. One rounding rule keeps them adding up: water taken to two significant figures, wastewater to the same place, each at the model's median, and water lost what is left, including the condensate. So the middle figure for water lost can sit a few percent above the model's own median for it (about 3% for cooling towers), since medians do not add. The likely ranges are the model's own. Numbers are shown to two significant figures (26,000; 6,200; 1.9 million), the same on every page and in the review, so the rounded figures may not add up exactly. Multiples are shown to one decimal below 10 (7.4 times) and two significant figures above.
  6. Water that is not for cooling. Every design also takes some water that is not for cooling, in three parts (model 1.3). At 300 MW, staff water and maintenance together are about 6,900 gallons a day (likely 4,200 to 9,500), about 640 of it lost. Staff water: restrooms, kitchens and cleaning for the people on site, which Microsoft says is all its zero-water design keeps water for . It follows the number of people, not the megawatts: people on site = 20 to 60 plus 0.1 to 0.5 per MW of computing capacity, times 10 to 30 gallons per person a day, so about 130 people and 2,300 gallons a day at 300 MW (middle of the runs). Gallons per person come from EPA's onsite wastewater manual, about 9 a calendar day for office and industrial workers , Michigan's septic design criteria, 35 per factory worker per shift , and one applicant's about 30 . People per MW follow announced campuses . Virginia's auditors put a typical building at about 50 full-time workers once open, about half of them contractors , and Michigan's sales tax exemption needs at least 30 new jobs . About 10% of staff water is lost (drinking, cleaning that dries; sampled 5 to 15%) and the rest goes down the drain . Maintenance and cleaning: washing equipment and floors, janitorial use, fire-system tests and loop flushing, up to 2,000 gallons a day for the campus plus 2 to 20 per MW, about 4,500 at 300 MW; 3 to 15% of it lost . No site publishes metered figures, so the range is bracketed by what applicants have projected [estimate]: Hermantown, Minnesota's loop maintenance at the low end, Crusoe's 200 MW building at the high end, checked against Saline Township and Microsoft's letter to Tyrone, Georgia. This is the largest uncertainty in this water. Loop top-up: a closed loop is filled once and loses a little to small leaks, typically under 5% of its volume a year ; the page samples 1 to 5% of a loop holding 2,000 to 12,000 gallons per MW of computing [estimate, from applicants' fills], all of it counted as lost. That is tens to a few hundred gallons a day. Outside air: the designs here cool with liquid loops, chillers or towers and recirculate the air inside the data halls, so outside air comes in only to pressurize and ventilate (model 1.5). The flow is sampled from 100 to 1,500 cfm per MW of computing capacity, an estimate: ASHRAE 62.1's 0.06 cfm per square foot for computer rooms at about 5,000 square feet per MW gives 300, and no published flow for large campuses was found. Above an indoor dew point of 15 °C a coil condenses the extra moisture; that condensate goes with the wastewater. It is clean water and would not go to a drainfield, so with a septic system the flow and Michigan's septic rules are worked out without it, and it is assumed to go to a site drain or stormwater [A]. Below −9 °C, humidifiers may add moisture, using water that is lost; how many campuses do this is not published, so the share is sampled from none to all . A design that cools with outside air directly would use far more air and is not modeled. Landscape watering is not counted, since it depends on the site and climate; ask how the site will be landscaped. Before model 1.2, this was one "base use" of 0.001 to 0.008 gallons per kWh of computing, 10 to 50% of it lost, which grew with the megawatts and counted humidification; at 300 MW it was about 26,000 gallons a day, four to seven times what Michigan applicants have projected (see the checks below).
  7. Cooling designs differ in when they evaporate: dry systems not at all; dry coolers with adiabatic pre-cooling evaporate water into the air ahead of the coil above a switch temperature (20 to 30 °C, an assumption: makers set it for each unit and publish none ), calculated from how far the air is above its wet-bulb temperature, pad effectiveness of 70 to 80% , a 9 to 13 K air temperature rise from makers' selection sheets , and fans slowing in wet mode, with bleed of 0 to 50% of evaporation by pad type ; hybrids in warm weather; cooling towers all year. These follow the system types in the national studies . The model runs the pads at full effectiveness above the switch temperature. A controller that wet the pads only enough to hold the air at the switch temperature would evaporate less: on central parameters, 12 to 41% less on average (West Michigan 41, Columbus 33, Ashburn 26, Austin 13, Houston 12) and 2 to 8% less on the peak day. Actual controls are not published, so the estimate is the higher of the two [A].
  8. Uncertainty. Real designs and operations vary, so every estimate is run 200 times across the published parameter ranges below. The calculator shows the middle result in bold and the middle 80% as the likely range.

Mass and energy balances

Energy, per kW of IT load, each hour

INTHROUGH THE CAMPUSOUTOutside airIts heat and moisture: adds heatwhen hot or humid, takes someaway when cool or dryElectricityComputers (IT load)Power losses and lightingAir handler fansChillersPumpsHeat rejection fansHeat in the water or coilAn economizer carries whatthe weather allows; chillerscarry the rest and add theirown power. Air handler fansand pumps end up here too.A coil colder than the indoordew point removes moisturefrom outside air.Evaporationwet share × evaporative ratioWarm air from a towerwet share × (1 − ratio)Warm air from a dry cooler1 − wet shareWarm air from the fansstraight to the exhaustElectricity + heat from outside air = evaporation + warm air

Water, per kWh of IT load, each hour

INTHROUGH THE CAMPUSOUTWater takenFrom a water system, wellsor a lakeMoisture in outside airWhat the coil condensesTower or padsEvaporation, drift, blowdownLoop top-ups (small leaks)Humidifiers, in very dry airStaff and maintenanceRestrooms, kitchens, cleaningDehumidifying coil, in humid airMakes condensateEvaporated or lostEvaporationDriftLeaks from the loopHumidifier vaporA small part of staff waterWastewaterBlowdownCondensateMost staff and maintenancewaterTo a sewer, a septic systemor a stream, by the siteWater taken + condensate = water evaporated or lost + wastewater
Diagrams, not to scale. They describe the air- and water-cooled designs. Which paths carry anything depends on the design and the hour: closed loop has no tower or pads, and assist evaporates at pads ahead of a dry cooler. These balances hold in every hour of every run. Ranges are percentiles, and the ends of a range need not add up, but the middle estimates do.

The equations

  • Energy: facility power + outside air heat = heat through the water or coil + heat rejection fans
  • Heat through the water or coil: H = q + air handler fans + outside air heat + chillers + pumps, with q = 1/UPS + 1/(1 − distribution loss) − 1 + lighting per kW of IT
  • Chillers: load × (1 − economizer share) × (w / COP water-cooled + (1 − w) / COP air-cooled)
  • Tower fans: design fan power × (air needed / design air)³, from 10% of design air to all of it, where air needed goes with the tower's water over the enthalpy the air can pick up. Design is the 78 °F rating wet-bulb [A]. Dry cooler fans follow the same law.
  • Outside air heat: air flow × (enthalpy outside − enthalpy indoors). A dehumidifying coil carries the latent part.
  • Evaporation: H × w × evaporative ratio / latent heat. Assist evaporates at pads instead, from the air's own energy balance: H × depression / (switch point + air rise − air temperature + depression) / latent heat, where depression is pad effectiveness × (air temperature − wet-bulb).
  • Drift: H × w / (8.34 × range) × drift share
  • Blowdown: evaporation / (cycles − 1) − drift, from the dissolved solids balance: makeup × solids = (blowdown + drift) × cycles × solids
  • Water: withdrawn + condensate = consumed + returned. The middle estimate takes withdrawn and returned at their medians, and consumed is the remainder.
  • Lake-source: flow × density × specific heat × rise = heat = electricity, since the lake water is colder than the loops and needs no chillers or heat rejection fans [A]. Withdrawn equals returned at the pipe. The added heat then drives evaporation from the lake surface, so that balance is the lake's.
  • Power plants, off site: generation = campus electricity / (1 − line loss). Plant water is generation × water per MWh generated, reported separately and never added to the campus's own water.

Terms

IT load, IT capacityThe power the computers draw, and the most they can draw. Utilization is load over capacity.
Facility power, PUEAll the electricity the campus uses. Power usage effectiveness (PUE) is facility power over IT load.
Sensible and latent heatSensible heat changes the temperature of air or water. Latent heat evaporates or condenses water without changing its temperature, about 1,050 BTU per pound.
EnthalpyThe heat air carries, sensible and latent together.
EconomizerCooling without running a chiller, when outside conditions are cold enough.
Chiller, COPA machine that moves heat from cool water to warmer surroundings using electricity. Its coefficient of performance (COP) is heat moved per unit of electricity.
Wet share (w)The share of the heat going through evaporation: 1 for towers, 0 for closed loop and assist coils, and rising with air temperature for hybrid.
Evaporative ratioThe share of a tower's heat that leaves by evaporation, the rest warming the air. It rises with air temperature (Rutberg et al. 2011, as in USGS SIR 2013-5188).
RangeHow much a tower cools its water, °F.
DriftDroplets carried out of a tower in the air.
BlowdownWater drained from a tower to keep dissolved minerals from building up. Pads drain a similar bleed.
Cycles of concentrationHow many times more concentrated the tower's water is than the water coming in.
Loop top-upWater replacing small leaks from a closed loop.
Outside airAir brought in to pressurize and ventilate the building. It is a small flow, 100–1,500 cfm per MW of IT capacity [A], not used for cooling.
Dew point, condensateAir cooled to its dew point starts to condense. Above the 15 °C indoor limit, a coil removes the extra moisture as condensate, water that comes from the air and not from the water system.
HumidifierAdds moisture when the air's dew point is below −9 °C. How many campuses do this is not published, so the share is sampled from none to all [A].
Withdrawn, consumed, returnedThe model's names for water taken; water evaporated or lost as droplets and leaks; and wastewater, sent to a sewer, septic system or stream.
Line lossElectricity lost between power plants and the campus, about 5% (EIA, U.S. average 2018–2022). The national figure is used in every state, and a campus on the transmission system may lose less [A].

Parameters

Results by region (a 100 MW campus)

Middle result with the likely range (10th–90th percentile), for 100 MW of computing capacity including staff water at that size. Staff water grows more slowly than the computers, so a 300 MW campus takes less than three times these amounts with closed loop. "Water per kWh" is per kilowatt-hour of computing energy, for the model's cooling and loop water without staff water: evaporated, and taken (the basis national studies report).

How the estimates compare with published and reported numbers

Most operators do not publish a site's size, so few site-by-site checks are possible. We are not aware of a published study that checks a site-level data center water model against metered use at named sites; we show what we can, with its limits.

Water at power plants

Electricity, and the water used to make it

Lake-source cooling and where wastewater goes

Rain, runoff and water quality

A screening estimate of what the campus does to runoff and to the streams it reaches, before and after. The same calculation runs in Water Ledger's Python models (waterledger_models.runoff), and every parameter comes from one file, so the page and any report agree.

Before and after

Starting assumptions and the notes under each setting

Each setting starts from what is known, and a short note says which: Known (published for a proposal), Your place (from public data for the place) or Assumed. Every setting can be changed.

Local facts for your place

Every Michigan city and township (1,541 places with land area in the Census list) has a profile built from public data only:

Limitations

About the data

Water Ledger is a free public resource from Northline Hydrology. It uses public data only; nothing from client work goes into it. It does not rate projects as good or bad; it shows what they could mean for water so people can decide with numbers instead of guesses.

Sources

    What has changed in the numbers, and when: changelog. See something wrong? Suggest a correction.