Council model resource buildouts (draft Ninth Power Plan)

The resources the Northwest Power and Conservation Council's capital expansion model (OptGen) adds to the existing system under each of the 13 sensitivities of its draft Ninth Power Plan scenario analysis, read row by row from the Council's model buildouts workbook: by snapshot year (2028, 2030, 2032, 2034, 2038, 2042 and 2046), the year each resource was built, the Council's model zone, the resource and its resource type. In 2028 the only generating resources open to the model were those regional entities had already planned; demand-side resources were all available. This is a planning scenario: not the plan's recommended resource strategy, not a utility's plan and not a forecast of what will be built. Each sensitivity's portfolio is optimized over the same sampled futures of demand, gas prices, hydro, wind and solar, so there is no future pathway or climate model here; sensitivities are the Council's alternatives and are never averaged or summed. Conservation (resource type EE) is annual energy in average megawatts, as the plan draws it (the Council writes aMW; the dictionary unit here is MWa); every other type is nameplate capacity in MW; the two are never added. A snapshot lists what the model holds in that year, including resources built earlier, and some earlier decisions were not locked, so snapshots are never added together. Zones are the Council's model zones, and a supply-side resource may be built in one zone for another zone's demand; they are not the atlas frame or service territories. The Council's own pivot of one sensitivity is reconciled against the rows. The plan is a draft open for public comment.

At a glance

Period
2028–2046
One row is
Sensitivity x snapshot year x build year x Council zone x resource
Built from source rows of
sensitivity x snapshot year x build year x Council zone x resource
Evidence and method
modeled · directThe resources the Council's model selects under each sensitivity of its draft Ninth Plan scenario analysis: a planning scenario, not the plan's recommended resource strategy, not a utility's plan and not a forecast of what will be built. Each sensitivity's portfolio is optimized over the same sampled futures (demand, gas prices, hydro, wind and solar; Appendix K, all-appendices PDF page 480), so there is no future pathway or climate model in the workbook. Units: the Data sheet heads its value column 'Nameplate Cap. (MW)' ('Size in nameplate MW', Glossary!D10), but the plan draws conservation (resource type EE) in average megawatts (Figure 4-1 axis 'Nameplate MW / Conservation aMW', plan PDF page 92; Figure N-6 'average MW', all-appendices PDF page 559), and the EE rows summed over zones reproduce Figure N-6's bars; EE is recorded here in MWa and every other type in MW nameplate. A snapshot lists what the model holds in that simulated year, including resources built in an earlier year; snapshots are never added together, sensitivities are never averaged, and conservation in MWa is never added to capacity in MW. Zones are the Council's own model zones (Glossary!D7: supply-side resources may be built in one zone for another zone's demand), not the atlas frame or a service territory. The plan is draft 2026-3, open for comment through October 16, 2026.
Edition in this release
2026-3-draft; retrieved 2026-09-29T04:58:47Z · · retrieved 2026-09-29
Download
The Council's own model buildouts workbook (9th Plan Model Buildouts.xlsx) ↗The atlas reads this workbook and describes what it holds; it publishes no copy of it and no table of its rows. Download the file from the Council, whose Box page is the published original.

Measures

ColumnUnitWhat it measures
valueMWNameplate capacity of every resource type but conservation, as the workbook heads its value column, 'Nameplate Cap. (MW)' ("Size in nameplate MW.", Glossary!D10): generating, storage, hybrid, demand-response, voltage-regulation and behind-the-meter resources. Nameplate is not accredited or peak capacity, and a megawatt of one type does not serve the system like a megawatt of another.
valueMWaConservation (resource type EE) in average megawatts of energy. The workbook's header says MW, but the plan draws conservation in aMW (Figure 4-1, axis "Nameplate MW / Conservation aMW", plan PDF page 92; Appendix N Figure N-6, axis "average MW", all-appendices PDF page 559), and the EE rows summed over zones reproduce Figure N-6's bars for every sensitivity in 2032 and 2046. Never added to capacity in MW.

Coverage 2028–2046

27,969 values · 18 council zones
Rows per year as the source dates them; a row without a date is its own line. For each measure: rows with a value, rows listed without one, rows where it does not apply. Counts are values, not quantities.
Yearcouncil zonesvaluesnameplate capacityMWconservation energyMWa
2028176,6651,8100 without · 0 n/a4,8550 without · 0 n/a
2030182,7369510 without · 0 n/a1,7850 without · 0 n/a
2032183,1471,1090 without · 0 n/a2,0380 without · 0 n/a
2034183,4081,3670 without · 0 n/a2,0410 without · 0 n/a
2038183,5401,4280 without · 0 n/a2,1120 without · 0 n/a
2042184,1111,7750 without · 0 n/a2,3360 without · 0 n/a
2046184,3621,9550 without · 0 n/a2,4070 without · 0 n/a
By metricper year
Yearconservation energynameplate capacity
20284,8551,810
20301,785951
20322,0381,109
20342,0411,367
20382,1121,428
20422,3361,775
20462,4071,955
By sensitivityper year
YearBiOpConstWorldDelStorageET25DnET50UpFedPolicyLimDSMLimFlexNewMopRCBATxMaxTxMinTxPlus
2028132725783680352353486875127124676676676
2030167749196163160138190183139152162172165
2032181750222202197181227207179176224198203
2034201762242224207219240233201200242215222
2038215767246249232214256242215215239226224
2042270782277282269271292300275274277275267
2046279802301302309282324291279278321299295
By resource_typeper year
YearBTMBatteryDRDVR/CVREEHybridThermalSolarWindLDESGeothermalPumpedStorageH2ECBOffWind
2028307821,2301564,8552312————————
203044823791561,785299919143——————
203244824211562,038281314214362—————
203444864611562,0413323345165118251———
203844824491442,112522489819886261———
204244854501562,3366827211731919332138——
2046441194531562,407752821153302613717291

What is missing, and why

  • Listed without a reported value · nameplate capacityRows with no value for this measure; published as null, never zero
    0 values
  • Listed without a reported value · conservation energyRows with no value for this measure; published as null, never zero
    0 values
  • In the source, not yet includedThe existing system the resources are added to, which the Council publishes in its own existing-resources workbook, is not read. The reserve margins the model must meet are read in their own dataset (council-needs-assessment) and never set against these rows.
    Not computedthe existing-resources workbook is not adapted

How often it changes

Checked 2026-09-28
Publisher
The Council posts supporting workbooks as the plan is developed and states no schedule for them. The workbook dates itself "Last updated July 28th, 2026 / Initial upload" (READ ME!E14).www.nwcouncil.org/energy/ninthpowerplan/technical-elements/ ↗nwcouncil.box.com/v/NinthPlanModelBuildouts ↗
Delay
The plan this workbook supports is a draft: Council document 2026-3, cover date August 12, 2026, published August 13, 2026 and open for public comment through October 16, 2026. The workbook is the model's selection under each sensitivity; the plan's recommended resource strategy for 2027 to 2032 is set out in its Chapter 4.www.nwcouncil.org/reports/ninthplan/ ↗www.nwcouncil.org/energy/ninthpowerplan/ ↗
This atlas
The workbook is pinned by its SHA-256 in the source registry: a changed byte fails acquisition rather than becoming a new edition silently, so the table changes only when the pin is reviewed and moved. No timed refresh.www.nwcouncil.org/energy/ninthpowerplan/technical-elements/ ↗

Checks and corrections

  • keys.council_buildout_unique{"distinct":27969,"rows":27969}
    Passed
  • council_buildout.rows_valid{"negative_values":0,"rows":27969,"unit_locators":{"MW":"Data!G1 'Nameplate Cap. (MW)'; Glossary!C10:D10 'Size in nameplate MW.'","MWa":"resource type EE only: draft plan Figure 4-1, axis 'Nameplate MW / Conservation aMW' (ninthplan_2026-3.pdf, PDF page 92), and Appendix N Figure N-6 'Conservation Build by 2032 and 2046', axis 'average MW' (ninthplan_Appendices.pdf, PDF page 559), whose bars the EE rows summed over zones reproduce; the workbook's own header says MW"},"unit_or_metric_not_the_resource_types":0,"unknown_missing_reason":0,"unknown_sensitivity_snapshot_year_or_resource_type":0,"value_and_reason_inconsistent":0}
    Passed
  • council_buildout.pivot_reconciles{"compared":73,"disagreement_count":0,"disagreements":[],"printed_cells":73,"sensitivity":["TxMin"],"tolerance":0.001,"types_with_rows_not_in_pivot":[]}
    Passed

No corrections apply to this dataset in this release. Earlier editions: not available (earlier releases did not retain per-dataset edition comparisons).

Release 20260929T050546Z-51ae0f7d3c78