Energy Intensity Indicators: Indicators Data
The files listed below contain energy intensity data and documentation that supports the information presented on this website. The files are in Microsoft® Excel® format (2007 and later versions) and are available to view and/or download. The entire set of files is also available for download as a zipped* (compressed) file.
- Transportation Sector
- Industrial Sector
- Residential Buildings Sector
- Commercial Buildings Sector
- Electricity Sector
The first worksheet in each spreadsheet provides a directory to how the data are organized in other worksheets. The times series data are arranged by columns, with rows for years from 1949 forward, although actual data values are typically not available before 1970. Generally the key source data (energy consumption and activity measures) are in the left-most columns of each worksheet. The next set of columns contain the various intensity indicators, expressed in both nominal units and in index form. The yellow highlighted area in each worksheet shows the final set of activity, energy intensity and structural indexes. On the far right of the worksheet (to the right of the solid blue column) are the detailed formulas that embody the log-mean Divisia index methodology used to aggregate indexes (see Methodology).
Note: The Excel® spreadsheets are continually in the process of being updated. A date suffix in the form mmddyy is appended to the file names to identify the particular update of the data in the worksheet. An alert box may pop-up with a warning that the workbook is linked to other data sources. If this occurs," please select "No" or "Don't Update."
*The email firewalls used by many organizations will often quarantine files with the ".zip" extension. To overcome this difficulty, the extension of the zipped file available for download has been renamed ".zpi*. After downloading, the user must rename the file to one with extension ".zip" and then upzip the file using the standard Windows upzip feature.
The six energy intensity indicators files contains links among themselves to reflect the hierarchical structure of the system. The links will work seamlessly if the user loads the files into a folder labeled "C:\EERE_indicators\. However, it is not necessary to create this structure or linking capability to employ the data in the various files. In that case, when Excel informs the user that the file contains links to other files, simply click the "Don't Update" button at the bottom of the pop-up window.