Abstract
This report explores the potential for using responses from the Federal Energy Regulatory Commission’s (FERC’s) “Electric Utility Annual Report,” also known as FERC Form 1, as a cost database for conventional and pumped storage hydropower (PSH). The report outlines the process used to compile an easy-to-access database from the original FERC Form 1 data and discusses the historical cost/performance data. The steps for developing the database include downloading the annual FoxPro files from the FERC website (FERC, 2020), reading them into an Excel format, and reconciling naming issues across years, repeated entries, and shared assets, among others. The cleaned and compiled Form 1 database is available on Oak Ridge National Laboratory’s (ORNL’s) HydroSource website. For this report, the compiled Form 1 database was linked to two other hydropower databases, the National Inventory of Dams and the ORNL Existing Hydropower Assets, that provide additional information on the characteristics and other features of plants in the Form 1 data. Explorations of the plant characteristics, performance, capital costs, and operation and maintenance (O&M) cost data in the combined database were presented separately for conventional hydropower and PSH projects. Form 1 has several advantages as a hydropower cost database. First, the cost data is reported directly by plant owners. Second, Form 1 provides cost breakdowns of capital and operating costs for large conventional and PSH plants enabling more detailed tracking of hydropower costs compared with typical total cost estimates. Third, although the Form 1 data is not reported by all operational hydropower plants in the United States, the available data represents a wide range of plant characteristics and a sizable proportion of the hydropower fleet (61% of PSH plants and 22% of conventional hydropower plants by capacity). The lower proportion of the conventional hydropower fleet is because Form 1 reporting requirements apply only to private utilities that meet given size thresholds, leaving out federally owned facilities and many smaller hydropower plants. Overall, the Form 1 cost database represents a unique, publicly available database on hydropower asset capital and O&M costs. This report leads to a compiled database for the reporting years 1994 to 2020 that helps resolve issues with accessibility and use of the FERC Form 1 data by hydropower plant owners, project developers, technology developers, and regulators.
