Independent Data Tools for
Public Interest Energy Regulation

T-01 · T-02 · T-03 · T-04 · T-07

Gas Procurement Analytics Platform

Five-tab platform: utility rankings, national dashboard, hedging monitor, state explorer, and seasonal analysis. 252 utilities · 18 years · $26.4B above-peer finding. Purchase Mechanism and Contract Pricing listed separately below.

EIA Form 923 Page 5 · 2008–2025

T-08

Coal-to-Gas Switching Economics

At what gas price does coal become uneconomic? 91 coal operators ranked by switching threshold. 50 of 91 uneconomic at current prices. Nebraska Public Power cheapest coal at $1.13/MMBtu.

EIA Form 923 · 2008–2025

T-09

Year-over-Year Procurement Cost Change

Annual change in gas procurement cost per MMBtu by utility. Which utilities saw the largest cost increases and decreases each year. 252 utilities · 2009–2025.

EIA Form 923 Page 5 · 2009–2025

T-10

Fuel Mix Monitor

Gas vs coal vs nuclear vs renewables generation share by utility and state. Coal: 42.6%→15.2% in 13 years. Solar: 0%→5.1%. 237 utilities · 2011–2025.

EIA Form 923 Page 1 · 2011–2025

T-11

Gas Dependency Risk Index

Two-tab analysis: Gas Exposure Score (generation % + spot %) and Ratepayer Cost at Risk per $1/MMBtu gas price shock. Mississippi Power: $70.52/mo CAR. 171 utilities · 2011–2024.

EIA Form 923 + Form 861 · 2011–2024

T-12

Ratepayer Impact Calculator

Above-peer gas procurement cost translated to dollars per residential customer per month. FPL: +$7.03/mo · Duke Energy Progress: +$17.15/mo · Mississippi Power: -$64.99/mo best performer. 2 tabs.

EIA Form 923 + Form 861 · 2008–2024

T-13

Rate Trajectory by Customer Class

Effective electricity rates for residential, commercial, and industrial customers. Res/ind ratio rising from 1.45x in 2008 to 1.60x in 2024. 221 utilities · 17 years.

EIA Form 861 · 2008–2024

T-14

Sales Volume & Load Trends

Electricity sales and load trajectories. Entergy Louisiana +117%. San Diego G&E -19% total load · -44% per customer. Appalachian Power -25%. 246 utilities · 17 years.

EIA Form 861 · 2008–2024

T-15

Revenue per Customer Monitor

Annual revenue collected per residential, commercial, and industrial customer. Median residential: $1,447/yr in 2024 vs $1,048 in 2008. PG&E +82%. Dayton P&L -21%. 245 utilities.

EIA Form 861 · 2008–2024

T-16

Peak Demand Monitor

Summer and winter peak demand trends. TVA: 31,096 MW summer peak. National median up 42% since 2008. Winter peaks rising faster than summer as electrification grows. 218 utilities.

EIA Form 861 Operational Data · 2008–2024

T-17

Self-Generation vs Purchases

Share of supply from own generation vs wholesale purchases. National self-gen fell from 60.8% to 48.2% — below 50% for the first time. FPL 97% vs ConEd 7.5%. 218 utilities.

EIA Form 861 Operational Data · 2008–2024

T-18

Reliability Monitor

SAIDI, SAIFI, and CAIDI grid reliability metrics. Duke Carolinas SC: 7,804 min in 2024 (Hurricane Helene). Black Hills Power WY: 2 min best performer. 134 utilities · 2013–2024.

EIA Form 861 Reliability · 2013–2024

T-19

Outage Cost Calculator

Economic cost of outages per residential customer using VOLL methodology. Duke Carolinas SC: $1,561/customer · $887M total in 2024. Median $41.78/customer. 134 utilities.

EIA Form 861 Reliability · VOLL $10/kWh · 2013–2024

T-20

Grid Resilience Tracker

Long-run SAIDI trend — improving vs deteriorating utilities. Tampa Electric +4,161%. Black Hills Power -99.9% most improved. 134 utilities · first year to 2024.

EIA Form 861 Reliability · 2013–2024

T-21

Renewable Penetration Tracker

Actual renewable generation share by utility. National renewables: 10.5%→31.3% in 13 years. Manitowoc WI +83pp. Montana-Dakota ND +79pp. Rochester NY 100% hydro. 237 utilities.

EIA Form 923 Page 1 · 2011–2025

T-22

Demand Response Capacity Monitor

DR program enrollment and actual peak savings. NSP Minnesota: 971,100 enrolled · 882 MW saved. FPL: 649,428 enrolled · zero dispatched. Median enrollment doubled since 2013. 134 utilities.

EIA Form 861 Demand Response · 2013–2024

T-23

DR Cost Efficiency Monitor

Demand response cost per enrolled customer. Otter Tail Power $16/customer vs ConEd $928/customer. Median fell from $234 to $159 since 2013. 134 utilities · 2013–2024.

EIA Form 861 Demand Response · 2013–2024

T-24

Energy Efficiency Program Performance

Annual MWh saved and % of sales by utility EE programs. PG&E: 1.58M MWh · 2.12% of sales. Salt River Project: $77/MWh most cost-efficient large program. 155 utilities.

EIA Form 861 Energy Efficiency · 2013–2024

T-25

EE Cost Efficiency Monitor

Cost per MWh saved by utility EE programs. Median rose from $187 to $244 since 2013 — easy savings exhausted. Salt River $77/MWh vs Consumers Energy $319/MWh. 155 utilities.

EIA Form 861 Energy Efficiency · 2013–2024

T-26

Net Metering Growth Tracker

Net metering customers and penetration rate. 100x growth since 2008. SDG&E 24.4% penetration · PG&E 895,161 customers · SCE 697,053. 197 utilities · 2008–2024.

EIA Form 861 Net Metering · 2008–2024

T-27

Distributed Generation Tracker

Installed rooftop solar capacity under net metering. PG&E: 8,889 MW installed. Median grew from zero to 33 MW. SDG&E: 2,317 MW · 24.4% penetration. 197 utilities.

EIA Form 861 Net Metering · 2008–2024