US Power Market Comparison

Compare electricity performance across US states and benchmark it against the national average. Drape state boundaries over an unlabelled basemap, then colour them by percentage change in retail price, market structure (competitive, traditionally regulated or hybrid), cost rank, current load, planned retirements or forecast load growth. Click a state and the whole right-hand inspector retargets to it — one record selection moves every readout, so the summary is wired rather than rewritten. Below the map: a price-change trend against the national average, new generation built broken out by builder type as a stacked bar and a percentage-share ring, and the replacement-versus-new-demand split kept as two distinct quantities rather than one blended need. Load your own figures as CSV from the Import dialog (drag and drop, from the asset library, or from a URL — including a published Google Sheet's CSV export link), so staff can refresh the data annually without touching code. LIMITS, STATED RATHER THAN DISCOVERED: the plate visualises, it does not compute — percentage change, cost rank and the replacement/additional split must arrive AS COLUMNS, because the derived-column, group-by and join tools are interactive dialogs and cannot be scripted, so the data template is where that arithmetic belongs. Charts have no hover tooltips: chart2d draws to a shared canvas with no hit-testing, so values are read from the map's own tooltip and from the selection-following inspector instead. There is no Excel or Google Sheets connector — Excel means save-as-CSV, and a Sheet means its published CSV export URL. Boundaries must be WGS84 lon/lat GeoJSON; projected input is refused with a message rather than plotted in the wrong hemisphere, and the plate ships with no boundaries and no rows at all. The colour ramp legend beside the map is LINKED to the fill rather than restating it, so it cannot drift, and it hides itself when you colour by a category instead of a number. There is deliberately no snapshot button, because map tiles cannot be captured and it would hand you a PNG with a hole in it.

Supported file formats: CSV, TSV