# Presentation: 919211

## Advanced Data Presentation Techniques via the Internet

**Session IB**
- _Presentation Graphics_
- Henry Weigel
- May 23, 2000
- Bangladesh Ministry of Energy and Mineral Resources

## EIS: 25th Anniversary Charts

- Special presentation for the 25th anniversary of the Organization of the Arab Petroleum Exporting Countries (OAPEC) – October 1998
- Press Briefings, brochures, and graphical presentation (slide show)

## Some Views of 1973

## Presentation Process

- Data identification
- Data preparation
- Graph development
- Graph descriptions (bullets)
- Slide show development
- Publish on Internet
- Press briefings and brochures

## Presentation Components

- Excel spreadsheet data tables
- Graphs
- Embed graphs in slides
- Add text describing the graphs
- Convert into HTML pages
- Convert into Word document

## Demonstration

- Excel data and graphs _[..\Session2\25YROPEC\XLS\All_25th_Anniversary.](file:///../Session2/25YROPEC/XLS/All_25th_Anniversary.xls)__[xls](file:///../Session2/25YROPEC/XLS/All_25th_Anniversary.xls)_
- PowerPoint slides _[..\ ](file:///../25YROPEC/PPT/All_25th_Anniversary.ppt)__[Session2\](file:///../Session2/25YROPEC/XLS/All_25th_Anniversary.xls)__[ 25YROPEC](file:///../25YROPEC/PPT/All_25th_Anniversary.ppt)_\PPT\All_25th_Anniversary.ppt
- HTML pages _[..\ ](file:///../25YROPEC/html/anniversary.html)__[Session2\](file:///../Session2/25YROPEC/XLS/All_25th_Anniversary.xls)__[ 25YROPEC](file:///../25YROPEC/html/anniversary.html)_\html\anniversary.html
- Word document _[..\ ](file:///../25YROPEC/DOC/WEC_All_25th_Anniversary_w_Gifs.doc)__[Session2\](file:///../Session2/25YROPEC/XLS/All_25th_Anniversary.xls)__[ 25YROPEC](file:///../25YROPEC/DOC/WEC_All_25th_Anniversary_w_Gifs.doc)_\DOC\WEC_All_25th_Anniversary_w_Gifs.doc

## Development

- Data – Excel spreadsheet
- Generate graphs
- Set PowerPoint Template
- Copy graphs into PPT slide
- Or, Copy link to graph into PPT slide
- Add text
- Save as a Web page
- Save as Word DOC file

## EIS – Presentation Graphics Example

- On the Occasion of the 25th Anniversary of the OAPEC Oil Embargo of 1973 EIA Administrator Jay Hakes had us develop a set of charts that effect the embargo had over the last 25 years.

## Energy Information Administration

**25th Anniversary of the **
**1973 Oil Embargo**

**  **

**    ****Energy Trends Since the First Major U. S. Energy Crisis**

**Notes:**

This marks the 25th anniversary of the energy crisis of 1973, in some ways the most pivotal year in energy history.  Anniversaries are often a time of reflection.  In this spirit, the Energy Information Administration presents here 30 major energy trends in the United States over this period.  Taken as a whole, these measures provide a picture of how this country has responded to the crisis a quarter century ago.

## Major Disruptions ofWorld Oil Supply

**Notes:**
  The 1973 Arab Oil Embargo was the first oil supply disruption to cause major price increases and a worldwide energy crisis.
  In Fifteen years during the last half of the 20th century major disruptions in world oil supplies have occurred.  Six of those instances decreased the world oil supply by at least 2 million barrels per day (see illustration above).
  In 1950, the United States provided 52 percent of the world’s crude oil production;  by 1997 that figure had dropped to 10 percent.
  Virtually all spare oil production capacity was in the Middle East when the Arab Oil Embargo began in October 1973.
  Supply disruptions increased in severity as world oil production increased and production shifted to less secure areas of the Middle East.

Source:  Energy Information Administration, Interagency Database and Projections Working Group.

## Imported Oil as a Percent of Total U. S. Consumption

**Notes:**
   The share of total U.S. consumption of imported oil declined significantly in the late 1970’s and early 1980’s.  High oil prices prompted consumers to conserve energy and to switch to other fuels.
  U. S. dependence on imported oil increased to record levels during the last 25 years.  Net imports provide 48 percent of U.S. oil consumption -- (net imports: imports minus exports).
  The share of total U.S. consumption of imported oil has grown since oil prices collapsed in 1986 -- Gross imports account for 53 percent of U.S oil consumption  (gross imports: no offsets for oil exports).

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Table 5.1.

## Percent of OPEC and Persian Gulf World Oil Production

**Notes:**
  The share of world oil production provided by members of the Organization of Petroleum Exporting Countries (OPEC) declined by 25 percentage Points between 1973 and 1985.
  OPEC’s market share was at it’s lowest prior to the major collapse in oil prices in 1986.
  OPEC’s market share has rebounded since the 1986 price collapse and now stands at about 43 percent of world oil production.
  Unlike most other countries, a major portion of OPEC’s oil is traded in international markets.  OPEC consumes very little of its own oil.
  The largest portion of OPEC’s oil production is in those countries that surround the Persian Gulf.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Table 11.4.

## U. S. Retail Price of Gasoline

**Notes:**
  During the past 25 years, the nominal price of gasoline (price not adjusted for inflation) has risen at an average annual rate of 5.2 percent;  the real price of gasoline (price adjusted for inflation) rose only one-fourth of a percent per year.
Gasoline prices (real and nominal) reached a peak in 1981.
  Gasoline prices declined after 1981 despite a steady rise in real taxes, a reflection of world crude oil market movement.
  The nominal price of gasoline dropped about 31 percent between 1981 and 1986, a post-embargo low.
  The real price of gasoline dropped 43 percent between 1981 and 1986, and continued a slow decline for  2 years more.  By 1988, the price of gasoline  had declined 45 percent, for a  post-embargo low.
  Gasoline price increases are strongly influenced by the price of crude oil.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Table 5.22.  
Note(s): 1972-1977:  price of leaded regular gasoline was used;  1978-1996:  price for all types of gasoline was used.

## U.S. Crude Oil Prices

**Notes:**
  The real price (inflation-adjusted) of crude oil paid by refiners (refiners acquisition costs) rose from $10.72 in 1972 to $16.98 in 1997, an increase of  58 percent.
  Prices peaked in 1981 during the Iranian revolution.  The Iran-Iraq war increased fears of another disruption.
  Since 1981 there has been a steady decline in oil prices due in part to the following:
-- supplies from non-OPEC sources increased and absorbed some of the demand for OPEC oil .
-- revenue requirements by members of OPEC led to a consistent overproduction above their established quotas.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 5.19.

## U. S. Natural Gas Prices

**Notes:**
  In an era of regulation and scarcity the inflation-adjusted natural gas wellhead prices increased  about 187 percent by 1997, from $0.57 to $2.15.
  In 1954 the Federal Power Commission (now the Federal Energy Regulatory Commission)  set controls on  wellhead prices for gas intended for interstate transmission to consumers.
  Beginning in 1980,  interstate transmission of  new gas (not under existing long-term contract) was decontrolled while interstate transmission  of  old gas (under existing long-term contracts) remained controlled.  All gas was decontrolled in 1993. 
  Once the marginal supply of interstate transmission of gas was decontrolled, the average wellhead price of  new gas  rose, prompting a boom in gas exploration and development.
  Average wellhead prices peaked in the early 1980’s as more gas entered the market.  Gas prices are now strongly seasonal, increasing in winter and falling in summer.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Table 6.8.

## U. S. Total Petroleum Consumption

**Notes:**
  The total petroleum consumption in the United States has grown at an average annual rate of  0.5 percent, during the past 25 years.
  Following the 1973 OPEC price increases, U.S. consumption of petroleum declined for 2 years to a level of 16 million barrels per day by 1975.  After which it rose until 1979 when the Iranian revolution caused the oil price to rise and consumption to decline.
  A marked decline in petroleum consumption in the United States continued into the early 1980’s.  By 1983, the United States was consuming a low of 15.2 million barrels per day—a decline of almost 20 percent from the record consumption level of 18.9 million barrels per day in 1978. 
  Since 1983, the United States has experienced a rather steady increase in petroleum consumption.   The present-day consumption level is nearly equal to the 1978 all-time high petroleum consumption  level.
  In 1990, another oil price increase during the Persian Gulf war caused a slight and temporary decline in  U.S. oil consumption.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Table 5.1.

## U. S. Per Capita Use of Petroleum

**Notes:**
  The per capita  (per person)  use of petroleum decreased at an average annual rate of 0.5 percent during the past 25 years.
  The U.S. per capita use of petroleum decreased for 2 years and then increased to a peak of 31 barrels in 1978.
  From 1978 to 1983, petroleum use per capita in the United States dropped 23 percent, from a peak of 31.0 barrels.  (During this period the population rose 5.5 percent.)
  From 1978 to 1983, the consumption of total petroleum in the United States declined almost 20 percent.
  From 1983 to 1988, crude prices declined in both real and nominal terms, and petroleum use per capita rose slightly.  After 1988, petroleum use per person declined, leveling off at about 25 barrels per capita.
  Expansion of gas availability and environmental considerations in recent years helped stabilize per capita oil use—especially oil used for industrial and electricity production.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA- 0384(97). (Washington, DC, July 1998), Tables 5.1 and 1.5.

## U. S. Government Owned Crude Oil Stocks

**Notes:**
  The U.S. Government initiated the Strategic Petroleum Reserve (SPR) in 1976.
  In 1977,  the SPR fill rate began with imported crude oil.  By 1994, the Reserve had reached its maximum storage of 592 million barrels.
  The SPR fill rate ended in 1994.  As of 1997, the Reserve storage is at 563 million barrels of crude—about 63 days of net U.S. petroleum imports.
  The United States has held two public sales of crude oil from the Reserve in 1990/91 and 1996/97.
  The first public sale – 21 million barrels at the time of the Gulf war—was intended to stabilize the price of crude oil, which had risen to more than $33 per barrel.  A second  public sale of 28 million barrels occurred in 1996/97.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 5.15.

## Cost of Finding Oil and Gas Reserves

**Notes:**
  The cost of finding  new oil and gas reserves has declined significantly since 1977 when EIA began collecting these data.
  A new barrel of  oil or gas reserves that cost about $15 to find in 1977 (inflation- adjusted price), costs less than $5 to find today.
  Reserve cost reductions occurred primarily because of significant improvements in exploration and development technology.

Source: Form EIA-28, “Financial Reporting System.” 
Note(s):  Costs are calculated as the ratio of total exploration and development expenditures to total oil and gas reserve additions (barrels of oil equivalent), for the major energy producers reporting to the Energy Information Administration.  All costs are expressed in 1996 dollars, excluding the purchases and sales of reserves, and are 3-year weighted averages centering on the year shown.

## U. S. MPG Ratings for New Vehicles

**Notes:**
  The average annual rate of increase in the miles per gallon (mpg) rating for automobiles is 2.7 percent.
  From 1975 to 1996, the average annual increase in the mpg rating for automobiles and light trucks is 2.3 percent.  (Light trucks includes minivans, sport utility vehicles and small pickup trucks.)
  In 1975, Congress authorized the Department of Transportation to set and enforce automobile efficiency standards (CAFE: Corporate Average Fuel Economy).  The miles per gallon rating for new automobiles increased steadily from 1975 through 1988.
  After 1988, new automobile operating efficiency leveled off at about 28.5 mpg.
  Today, CAFE standards are 27.5 mpg for passenger cars and 20.7 mpg for light trucks.
  From the late 1980’s to present,  light trucks gained market share and began to slowly pull the mpg-combined-average rating below the 1987 peak.

Source:  Environmental Protection Agency,  Light-Duty Automotive Technology and Fuel Economy Trends Through 1996, EPA/AA/TDSG/96-01, (Ann Arbor MI—August 1996), Table 1.

## U. S. Average Horsepower of a New  Vehicle

**Notes:**
  Average horsepower of cars and light trucks decreased from 137 horsepower in 1975 to a low of 102 in the 1981/82 period, then rose 63 percent by 1996.  (Light trucks includes minivans, sport utility vehicles and small pickup trucks.)
  New car efficiency standards became effective in 1978, stimulating development of smaller cars, more efficient engines and improvements in major vehicle components—all of which contributed to improved fuel efficiency.    With such changes, efficiency standards were achieved with progressively higher powered cars.
  Since 1982, the average horsepower of new vehicles has increased steadily, even as sales for high-powered cars and light trucks dominate the sales for lower horsepower.   Meanwhile, corporate average fleet efficiencies continue to meet the standard of 27.5 mpg for passenger cars.

Source:  Environmental Protection Agency,  Light-Duty Automotive Technology and Fuel Economy Trends Through 1996, EPA/AA/TDSG/96-01, (Ann Arbor, MI—August 1996), Table 1.

## Share of U. S. Homes Heated With Oil

**Notes:**
  The share of homes using oil heat has gradually fallen from 31.0 percent in 1972 to 15.3 percent in 1996.  The number of homes using oil heat has fallen by 23 percent.
  From 1973 to late 1980 -- after the Arab oil embargo and the subsequent increase in the price of oil heat—there was a moratorium on building new homes with natural gas heat in many northern regions.  As a result, the decline in oil heat was somewhat slower than it would have been.
  Oil heat was also displaced by electric heat, which is more readily available in outlying suburban areas where most new homes are built.  In addition, there has been a slightly higher population growth in the Southern and Western regions of the United States, where electric home heating (and cooling) is a frequent choice.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 2.6.
Note:  Oil heated homes can use either heating oil or liquefied petroleum gas (LPG) for forced air furnaces, hot water central heating, or small portable kerosene heaters.

## Share of U. S. Electricity Generated By Petroleum

**Notes:**
  The share of electric utility net generation from oil has decreased 14 percentage points since 1972, to about 2.5 percent of all electricity generation.
  Changes in the generating capacity are relatively slow and fuel choice is based on projections of future fuel prices.
  In the mid-1970’s, oil-fired generation represented 16 to 17 percent of the nation’s capability based on forecasts made in the 1960’s and early 1970’s of continued growth of  electricity demand and stable supplies of cheap fuel oil. 
  Oil has been displaced as the prime mover principally by the growth in coal generation spurred by higher oil prices in the 1970’s; and much more recently by flexible natural gas-fired generation.
  After 1978, oil-fired generation fell steadily to about 2.5 percent in 1997.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 8.3.

## U. S. Crude Oil Reserves

**Notes:**
  Since 1972, economic conditions and technological capability have varied dramatically. Crude oil reserve estimates have varied because improved technology has increased finding rates. Oil now can be economically produced in the United States from more marginal fields than was the case in 1972.
  In 1972 the American Petroleum Institute (API) estimates of crude oil reserves were 36.3 million barrels.
  EIA and API estimates differed by 2.3 million in 1977 -- when they first overlapped.  The differences were attributed principally to the different approaches to reserves estimation.
  In 1996 EIA’s estimates of crude oil reserves were 22.0 billion barrels.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 4.10.
Note(s):  Prior to 1977: A technical committee sponsored by the API assembled these data.  Beginning in 1977: EIA was solely responsible for assembling the crude reserves data.  Oil reserves:  The estimated quantities that can be recoverable with reasonable certainty in future years from known reservoirs under existing economic and operating conditions.

## U. S. Total Energy Consumption

**Notes:**
  From 1972 to 1997 energy consumption increased by 20 quadrillion Btu—to 94.2 quadrillion Btu—a compound growth rate of  about 1.0 percent.
  The reductions in growth rate correspond to the 1974/75 and 1981/82 changes in economic growth.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 1.3.
Note:  Data include an estimate of 3 quadrillion Btu for nonutility renewables prior to 1990.

## U. S. Per Capita Use of Energy

**Notes:**
  The per capita use of energy has declined 0.8 percent over the last 25 years. 
  The per capita use of energy decreased for 2 years immediately following the OPEC embargo.  
  In 1978, the per capita use of energy peaked at 365 million Btu—a level not since repeated.
  Although  the population rose 5.5 percent from 1978 to 1983, the energy use per person dropped 14 percent.
  The start of the decline in consumption of energy coincided with the onset and aftereffects of a second oil price increase.
  From 1983 to present, the energy use per person increased at a steady low rate of 0.8 percent per year.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Tables 1.3 and 1.5.
Note:  The total energy consumed shown in table 1.3 was increased by 3 quadrillion Btu for renewable energy not previously included for the years 1972 - 1989.

## U.S. Primary Energy Consumption per Dollar of GDP

**Notes:**
  Energy consumption per dollar of GDP has declined at an average annual rate of 1.7 percent during the past 25 years.
  In 1972, the energy consumed per dollar of GDP was 20.1 million Btu.   From that high point a steady decline began and lasted through 1986.  After 1986 the decline in energy consumption per dollar of GDP slowed significantly.
  The steady decline through 1986 is a reflection of the emphasis placed on conserving energy, and of  increasing energy efficiency in virtually all areas of energy consumption.  Although oil prices began dropping in the early 1980’s, the efficiency gains were by and large here to stay.   

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Tables 1.3 and 1.5.
Note 1:  The total energy consumed shown in table 1.3 was increased by 3 quadrillion Btu for renewable energy not previously included for the years 1972 - 1989.
Note 2: Energy consumption per dollar  of GDP is a measure of energy intensity.  Energy Intensity is the ratio of the amount of energy consumed to an indicator of the amount of goods produced or services provided.

## Share of U. S. Renewable Energy Consumption

**Notes:**
  Renewable energy was approximately 8.4 percent of  U.S. total consumption in 1972.  It declined slightly to 7.6 percent in 1997.
  Renewable energy comes from hydroelectric power, geothermal, biofuels, solar and wind-generated energy.
  Prior to 1990, about 3 quadrillion Btu of electricity generated from solar and wind energy was not counted in the statistics.  In addition, consumption statistics for renewable energy did not include residential use of renewable fuels such as solar heating and hot water.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Tables 1.3 and 10.2.

## U. S. Retail Price of Electricity

**Notes:**
  The nominal price (not inflation-adjusted) of electricity has risen at an average annual  rate of 5.3 percent during the past 25 years.  In contrast, the real price (inflation-adjusted) rose at a rate of 0.3 percent.
  Electricity prices (real cents per kilowatthour) have followed two broad trends: (1) growth throughout the 1970’s and into the early 1980’s; and  (2) a decline ( real dollars) since about 1982.  Increased competition in the electric power industry has created downward pressures on prices.
  The retail price of electricity, in real terms, rose 53 percent from a low 5.7 cents per kilowatthour (kWh)  in 1972 to 8.7 cents per kWh in 1982. Also, during that period the nominal price rose even more dramatically, 1.9 to 6.1 cents per kWh, a staggering 220 percent,  tripling the price.
  A rise in fossil fuel prices between 1972 and 1982 strongly influenced the price of electricity.
  The nominal price continued to rise after 1982, but at a much more gradual rate. Meanwhile the real price showed a steady decline of about 30 percent by 1996.

Source:  Energy Information Administration, Annual Energy Review 1997, DOE/EIA-0384(97). (Washington, DC, July 1998), Table 8.13.

## Percent of U. S. New Homes Built with Natural Gas Heat

**Notes:**
  The percent of new homes built with gas heat increased at an average annual rate of 0.9 percent during the past 25 years.
  A sharp drop in newly built gas-heated homes occurred following the oil embargo—from a pre-embargo level of 54 percent to a 1978 level of 37 percent.
  Concerns about the dependable availability of natural gas in the 1970’s led to restrictions on the use of natural gas in new homes.  Restrictions were in place in the northern region of the country until the late 1980’s.  
  Increases in nominal natural gas prices accelerated after the embargo, reaching a plateau in 1983.  Although the natural gas prices (in nominal terms) remained fairly constant after 1983, in real terms they declined. 
  New gas hookups increased with the 1985 decontrol of wellhead prices and the expansion of natural gas imports.
  Currently, two-thirds of new homes are built with natural gas heat.

Source:  U.S. Department of Commerce, Bureau of the Census,  Characteristics of New Housing: 1995, (Washington, DC, October 1996).

## Efficiency of an Average New Refrigerator in the United States

**Notes:**
  The efficiency of an average new refrigerator increased dramatically, from 3.84 cubic feet per kilowatthour per day in 1972 to 11.22  cubic feet per kilowatthour by 1996.
  New technology, increasing price of electricity, and anticipated energy efficiency standards contributed to increased efficiency in new refrigerators.
  The National Appliance Energy Conservation Act of 1987 set minimum efficiency standards for 13 product types, including refrigerators.  After 1993, no refrigerator could be sold that did not meet the standards.  Standards will be updated again in 2002.

Source:  Association of Home Appliance Manufacturers, Refrigerators Energy Efficiency and Consumption Trends, July 14, 1997.
Note(s):  The efficiency of a refrigerator is expressed in “volume cooled per unit electric energy per day.”  Volume is measured in cubic feet and electrical energy is measured in kilowatthours.  Increased efficiency compensates for the increasing size of refrigerators.  Average efficiency is the sales-weighted average over all models sold in the United States.

## Notes on Presentation Graphics Development

-   _Major Steps_
- Prepare data in Excel spreadsheet
- Develop graph
- Copy graph to clip board
- Paste into PPT slide (the graph or the link to the graph)
- Save as PPT and as a Web (html) file

## Data in Excel Spreadsheet

## Select Data and Graph Type

## Click “Series” and Select X-Axis

## Need Labels

## Define Title and Axes

## Graph (Chart) Location

## Graph Needs Dressing Up

## Final Graph with AnnotationsReady to Copy into PPT Chart

## Edit, Paste Special, Paste Link

## Convert to a Web Pageand/or Word Document

- _Under File Menu:_
- Save As Web Page
- Send To
- Microsoft Word