Variation in the Production of Actual Plants
As with wind and solar, I have put together the database of actual plants in order to evaluate the variation in production from plants. This data comes from the a US EIA database that tracks month by month generation (I understand that S&P tracks the data and charges you something like 50K USD). In another page I explain in detail how you can update the database. The hydro database includes three pages — one for the data from EIA and two other pages that put together analysis for individual plants. As with any other excel stuff, I mainly use INDEX, MATCH and SUMIF to make all of the analysis. You can download the database by clicking on the button below. Below the button I have put a couple of screenshots that illustrate the summary analysis and the analysis for a single project.
These files are on the resource library. Get the library by e-mailing firstname.lastname@example.org