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 | |||||||||
The Ergosphere 