[go: up one dir, main page]
Scribd
Upload
18 views5 pages

US Energy Spreadsheet Activity

The document presents historical data on energy consumption in the U.S. from 1850 to 2020, detailing the consumption of various energy sources including coal, natural gas, petroleum, and renewable sources. It also outlines future energy policies aimed at reducing emissions and increasing renewable energy usage by 2100. Additionally, it includes projections for energy consumption and population growth through 2100.

Uploaded by

luke.harris26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views5 pages

US Energy Spreadsheet Activity

The document presents historical data on energy consumption in the U.S. from 1850 to 2020, detailing the consumption of various energy sources including coal, natural gas, petroleum, and renewable sources. It also outlines future energy policies aimed at reducing emissions and increasing renewable energy usage by 2100. Additionally, it includes projections for energy consumption and population growth through 2100.

Uploaded by

luke.harris26
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Year 1850 1900 1920 1940 1960 1970 1980 1990 1995 2000 2005 2010 2020

Energy Consumption per Year (Quintillion Joules)


Coal - U.S. 0.3 6.6 15.7 12.6 10.3 13.4 17.0 20.8 20.8 22.4 23.1 21.2 13.7
Coal - Imported 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.1 0.3 0.3 0.8 0.6 0.2
Natural Gas - U.S. 0.0 0.4 1.6 5.1 13.3 22.8 21.0 19.2 20.0 20.5 18.8 21.5 32.7
Natural Gas - Imported 0.0 0.0 0.0 0.0 0.2 0.9 1.1 1.6 3.1 4.1 4.7 4.1 0.0
Petroleum - U.S. 0.0 0.0 1.6 6.3 16.8 23.6 20.4 16.7 15.1 13.5 11.4 10.1 23.0
Petroleum - Imported 0.0 0.0 0.0 0.0 4.2 7.9 15.5 18.1 19.9 25.9 30.8 26.6 13.2
Nuclear Fission 0.0 0.0 0.0 0.0 0.0 0.3 2.9 6.4 7.5 8.2 8.6 8.8 8.4
Biomass 2.4 1.8 2.1 1.3 1.4 1.5 2.6 2.9 3.3 3.2 3.3 4.1 5.1
Hydroelectric 0.0 0.0 0.0 0.0 1.7 2.8 3.1 3.2 3.4 3.0 2.8 2.8 2.6
Geothermal 0.0 0.0 0.0 0.0 0.00 0.01 0.12 0.39 0.37 0.36 0.36 0.39 0.2
Solar 0.0 0.0 0.0 0.0 0.00 0.00 0.00 0.06 0.07 0.07 0.07 0.12 0.9
Wind 0.0 0.0 0.0 0.0 0.00 0.00 0.00 0.03 0.03 0.06 0.19 0.74 2.5
Atmosphere Extraction
Spacial Solar
Total Energy Consumption (J^18) 2.6 8.74 20.9 25.2 48.0 73.0 83.7 89.5 93.7 101.5 105.0 101.0 102.6
Coal - Exported (J^18) 0.0 0.0 0.0 0.0 1.1 2.1 2.6 2.9 2.5 1.6 1.3 1.6 2.4
Natural Gas - Exported (J^18) 0.0 0.0 0.0 0.0 0.0 0.1 0.1 0.1 0.2 0.3 0.9 1.1 3.1
Petroleum - Exported (J^18) 0.0 0.0 0.0 0.0 0.5 0.6 1.2 1.9 2.1 2.3 2.3 4.4 9.6
U.S. Coal Resources (J^18) 10906 10735 10513 10230 9990 9858 9688 9478 9361 9240 9117 8999 8805
U.S. Natural Gas Resources (J^18) 1263 1262 1262 1260 1256 1225 1182 1143 1043 941 837 731 1113
U.S. Petroleum Resources (J^18) 1806 1806 1790 1711 1474 1269 1041 835 740 650 569 498 297
Annual Population % Growth Rate 2.3 1.75 1.05 1.55 1.21 1.1 0.95 1.2 1.24 1.05 0.85 0.85 0.7
Population (million) 24 75 107 132 179 203 226 249 264 281 296 309 327
Energy/Capita (Billions of Joules) 110 117 195 191 268 360 370 359 355 361 355 327 314

This spreadsheet may be Protected

To unprotect the sheet, select


Protection from Tools. The
password is: energy
Main Policy: Have farmers double their wind turbines every ten years but 75% paid by gov.
Have volcanoes harnessed increasingly
Learn to extract co2 from the atmosphere
Learn to get solar energy from outside the atmosphere
By 2100 no man made emissions
At the beginning rely on fission
2030 2040 2050 2060 2070 2080 2090 2100

10.0 7.5 5.0 0.0 0.0 0.0 0.0 0.0


0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
21.5 10.0 5.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
5.0 5.0 0.5 0.0 0.0 0.0 0.0 0.0
15.0 15.0 10.0 0.0 0.0 0.0 0.0 0.0
20.0 20.0 10.0 10.0 10.0 5.0 0.0 0.0
6.0 7.5 10.0 10.0 5.0 0.0 0.0 0.0
5.0 5.0 5.0 10.0 12.5 15.0 15.0 15.0
10.0 30.0 40.0 50.0 50.0 50.0 50.0 50.0
2.5 5.0 10.0 20.0 20.0 30.0 35.0 40.0
5.0 7.5 10.0 12.5 12.5 15.0 20.0 25.0
0.5 1.0 5.0 15.0 25.0 30.0 20.0
10.0 15.0 25.0 50.0 60.0 65.0
100.0 113 116.5 132.5 150.0 190.0 210.0 215.0

8674 8587 8524 8499 8499 8499 8499 8499


826 669 594 569 569 569 569 569
109 59 31 29 29 29 29 29

350.71 350.71 350.71 350.71 350.71 350.71 350.71 350.71


285 322 332 378 428 542 599 613
700

600

500

400
Energy/Capita

300

200

100

0
1800 1850 1900 1950 2000 2050 2100 2150

Year
US Energy Consumption

140

120

100
Wind
Solar
Geothermal
Quintillion Joules

80 Hydroelectric
Biomass
Nuclear Fission
Petroleum - Imported
60 Petroleum - U.S.
Natural Gas - Imported
Natural Gas - U.S.
Coal - Imported
40
Coal - U.S.

20

0
850 900 920 940 960 970 980 990 995 000 005 010 020 030 040 050 060 070 080 090 100
1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2

Year

You might also like