Pull live grid demand, DCPI power verdicts, facility lists and retail electricity rates straight into a cell. Every value comes from DC Hub with its source; anything withheld says so instead of guessing.
| Google Sheets | Excel | Returns |
|---|---|---|
=DCHUB_GRID("PJM") | =DCHUB.GRID("PJM") | Live grid demand in MW. A second argument picks another field, such as "day_ahead_price_usd_mwh". |
=DCHUB_DCPI("phoenix") | =DCHUB.DCPI("phoenix") | BUILD, CAUTION or AVOID for the market; "composite_score" for the score (CC BY 4.0). |
=DCHUB_FACILITIES("Ashburn", 10) | =DCHUB.FACILITIES("Ashburn",10) | A table of facilities with a header row. |
=DCHUB_ENERGY_RATE("VA") | =DCHUB.ENERGY_RATE("VA") | Retail electricity rate for the state, from EIA. |
Each function below is the target of the Help link for that function in Excel. In Google Sheets the same function is named with an underscore, for example DCHUB_GRID.
=DCHUB.GRID(iso, [field])Live grid data for one ISO or grid code. By default it returns the current demand in MW.
iso (text): grid code, such as "PJM", "ERCOT", "CAISO", "MISO".field (text, optional): the field to return, as a dotted path. Default demand_mw; for example "day_ahead_price_usd_mwh" for the day-ahead price where the ISO publishes one.=DCHUB.GRID("PJM") returns PJM demand in MW.=DCHUB.GRID("ERCOT", "day_ahead_price_usd_mwh") returns ERCOT's day-ahead price in $/MWh.=DCHUB.DCPI(market, [field])The Data Center Power Index (DCPI) verdict for a data center market: BUILD, CAUTION or AVOID. DCPI scores are CC BY 4.0.
market (text): market slug, such as "phoenix" or "northern-virginia".field (text, optional): default verdict; "composite_score" returns the 0-100 composite score.=DCHUB.DCPI("phoenix") returns the verdict for Phoenix.=DCHUB.DCPI("northern-virginia", "composite_score") returns the composite score.=DCHUB.FACILITIES(query, [limit])Data center facilities that match a search, as a table that spills into the cells below. The first row is a header: name, provider, city, state, country, as_of, profile_url. When more facilities match than are shown, a last row says so and links to the rest.
query (text): free text, such as a city ("Ashburn") or an operator name.limit (number, optional): rows to return, default 10, at most 100.=DCHUB.FACILITIES("Ashburn", 10) returns up to 10 Ashburn facilities.=DCHUB.ENERGY_RATE(state, [field])The retail electricity rate for a US state, sourced from EIA.
state (text): two-letter state code, such as "VA" or "TX".field (text, optional): default retail_rate_kwh.=DCHUB.ENERGY_RATE("VA") returns Virginia's retail rate in dollars per kWh.A value DC Hub does not give out without a key shows as withheld: <link>, never as an estimate. A value the source does not report shows as not reported.
Cells with Cells.gs and an HTML file named Sidebar with Sidebar.html.=DCHUB.GRID("PJM") in a cell.Without a key the formulas return previews, and a withheld value shows as withheld: <link>. A key opens more. Your key is stored for your account (Sheets) or on your device (Excel) and is sent only to dchub.cloud. Cite figures as DC Hub (dchub.cloud), as of <date>. Source code: integrations/spreadsheets.