Google Sheets · Excel

Data center data in your spreadsheet,
as live formulas.

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.

Get a key Download the Excel add-in
Google SheetsExcelReturns
=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.

Function reference

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.

Parameters
  • 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.
Examples
  • =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.

Parameters
  • market (text): market slug, such as "phoenix" or "northern-virginia".
  • field (text, optional): default verdict; "composite_score" returns the 0-100 composite score.
Examples
  • =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.

Parameters
  • query (text): free text, such as a city ("Ashburn") or an operator name.
  • limit (number, optional): rows to return, default 10, at most 100.
Example
  • =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.

Parameters
  • state (text): two-letter state code, such as "VA" or "TX".
  • field (text, optional): default retail_rate_kwh.
Example
  • =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.

Google Sheets

  1. Open a sheet, then Extensions → Apps Script.
  2. Paste Code.gs, add a script file named Cells with Cells.gs and an HTML file named Sidebar with Sidebar.html.
  3. Save, reload the sheet, then Extensions → DC Hub → Set API key.

Excel (web, Windows, Mac)

  1. Download manifest.xml.
  2. Home → Add-ins → More add-ins → My add-ins → Upload My Add-in, and choose the file.
  3. Home → DC Hub key, paste your key, then type =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.