U.S. energy budget spreadsheet

Download a copy of this Excel spreadsheet. Here's the spreadsheet orientation (Orientation.doc in MS-word format) we'll do.

You will need to determine the amounts of each source of energy to be used in the U.S. (blue numbers) starting in 2010 and thereafter in 5-year intervals through the year 2060. Also fill in what you anticipate for exports (red numbers).

As you do this, keep an eye on:

• The U.S. resources of coal, natural gas, and petroleum, indicated in green. These numbers may not become negative.
• The total population, determined by the annual percentage growth rate in orange. I've filled in for you the projections of the U.S. Census Bureau. But if you think one of your policies will have an effect on these numbers you can change the numbers in the "Annual Population % Growth Rate" row starting in 2010.