Body of post is at The Ergosphere.
XSLX version of the spreadsheet is here; WP will not let me upload the ODS version. Talk about discrimination! WP won’t let me insert links after the end of the table, either.
PV, $/kW(p) | 1000 | Carbon cost, $/ton | 40 | Wind CF | 0.32 | Coal CO2, g/kWH | 900 | ||||||
Wind, $/kW(p) | 1000 | Coal price, $/ton | 55 | PV CF | 0.2 | Gas CO2, g/kWh | 550 | ||||||
Coal, $/kW(p) | 2000 | Coal energy, mmBTU/t | 15 | Fuel-back RE frac | 0.7 | ||||||||
Nuclear, $/kW(p) | 5000 | Gas price, $/mmBTU | 10 | Fuel-back backup | 0.8 | Interest rate, % | 7 | ||||||
Gas, $/kW(p) | 1500 | HVDC cost, $million/mile | 2 | ||||||||||
RE + gas | RE + coal | RE + battery | Nuke + bat | ||||||||||
GW | bln$ | GW | bln$ | GW | bln$ | GW | bln$ | ||||||
GW wind | 729.2 | 729.2 | GW wind | 729.2 | 729.2 | GW wind | 1190.5 | 1190.5 | GW nuke | 631.6 | 3157.9 | ||
GW PV | 1166.7 | 1166.7 | GW PV | 1166.7 | 1166.7 | GW PV | 1904.8 | 1904.8 | |||||
GW gas | 480 | 720 | GW coal | 480 | 960 | GW bat | 600 | 43200.0 | GW bat | 180.0 | 180 | ||
Xmission, mi | 1421875 | 2843.75 | 1421875 | 2843.75 | 2321429 | 4642.9 | |||||||
Total generation capital, bln$ | 5459.6 | 5699.6 | 50938.1 | 3337.9 | |||||||||
Ann. Wind generation, TWH | 2044 | 2044 | 3337 | ||||||||||
Ann. PV generation, TWH | 2044 | 2044 | 3337 | ||||||||||
Ann. Gas generation, TWH | 1168 | Ann. Coal generation, TWH | 1168 | Ann. Bat loss | -1418 | ||||||||
Carbon emissions, mmTPY | 642.4 | 1051.2 | 0 | 0 | |||||||||
Amortization, bln$/yr | $507.94 | $530.27 | $4,739.07 | $266.49 | |||||||||
Fuel cost, $bln/yr | $66.46 | $66.46 | $0.00 | $0.00 | |||||||||
Carbon cost, bln$/yr | $25.70 | $42.05 | $0.00 | $0.00 | |||||||||
Total | $600.10 | $638.78 | $4,739.07 | $266.49 | |||||||||
$/Mwh | $114.17 | $121.53 | $901.65 | $50.70 | |||||||||
CO2, g/kWH | 122 | 200 | 0 | 0 |