Solar Uncertainty Analysis (P90, P95 etc.)

On this webpage I address uncertainty estimates in predicting the solar energy using P90, P99, P75 etc.  I have tried to take the mystery out of computing the different probabilities by explaining the statistical principles and providing some practical examples. Computing uncertainty with respect to historic weather data (e.g. cloud variation from year to year) is pretty easy.  Computing the variation to to modelling errors and estimation of uncertainty in the performance ratio is more difficult.  Putting the uncertainty estimates together can be done by understanding the mean square error concept.

I have separated the analysis of solar resource into computing capacity factor or solar yield and the evaluating uncertainty around the base solar resource estimate.  In analysing solar uncertainty, computation of P90, P95, P75 etc. is explained for solar power.  Hopefully, I explain the solar resource uncertainty analysis and computation of P90, P99, P75 etc. without unnecessary complex statistical or technical terms.


First Step: Computing Uncertainty from Historic Variation in Irradiation Data and Using NORMINV Function

In this section I have tried to take the mystery out of computing P90, P75 etc. The resource analysis section address issues with fundamental calculations of solar yield, performance ratios and temperature coefficients.  To compute uncertainty and P values from historic data, you should first compute the average and standard deviation in annual energy.  Then, you can use the NORMSINV function to compute the implied energy production that is given by different probability estimates.

The file that you can download below demonstrates how you can compute P90, P99, P75 etc. for weather uncertainty.  Data is taken from the EU website (that is better than the Canadian and US sites). A link to the EU website that allows you to download historic solar energy data over long periods is below.  A file that illustrates the calculation of standard deviation for weather variation and P values is available for download by clicking on the button below the link.

Excel File that Demostrates How to Compute Yield and Capacity Factor and Perfromance Ratio from Different Sources

The screenshot below demonstrates how to compute standard deviation and P levels from data in the EU website. This page is part of the file available for downloading below. By downloading data for different years (from the monthly option), you can compute the standard deviation of solar energy and capacity factor.  The P90 is computed with a value of 10% and the standard deviation and the mean.  The percent reduction from the mean (P50) and P90 is 11.99%.  This would justify a DSCR of 1.14.


The video below explains how to go to the EU website and convert data to excel so you can do analysis similar to the stuff in the above screenshot.



Second Step: Adding Uncertainty in Performance Ratio and Modelling Uncertainty

Uncertainty from modelling errors — maybe the solar estimation is biased; maybe the panels will not produce the correct output; maybe the PVSYST model has something wrong etc. are very different from uncertainty due to weather estimation.  Weather estimation is mean reverting.  This means when you have an error because of something like a long rainy season in one year, that the next year will probably move back to the average.

Putting the Uncertainties Together — You Cannot Add Uncertainty; Use Mean Squared Error Instead


You should be able to (1) find a base yield from looking at the websites; (2) review long-term hourly solar data and compute the P90 and P99 that arises from variation in solar irradiation from year to year (due to clouds and dust); (3) add uncertainty related to the performance ratio and use the mean squared error to develop final P90, P99 etc.; and, (4) examine historic data for actual projects and understand the difference between actual observed variation and variation that is possible before the project begins. A separate spreadsheet is provided if you want to evaluate your skills.


In the spreadsheet that you can download below, I prove that when you square the standard deviation (to get the variance) and then add up the variance and take the square root of the sum of variances that this does measure the standard deviation of the combined factors.  This works when the combination of factors is independent of each other.  Let’s put the stuff together separately:

  1. Compute the standard deviation of the variation in production from each of the factors. For example, assume the standard deviation of the gross production before accounting for the performance ratio is 1,000. Assume that this has a standard deviation of 2.5%.  Assume that the performance ratio is 80% and it has a standard deviation of 5%.  The standard deviation of the gross production is 25 and the standard deviation of the performance ratio is 200 x  5% or 10.

MSE Simulation.xlsm


Uncertainty Analysis from Variation in Actual Projects

I have created a database that contains actual historic production data on operating solar projects. In the U.S. the EIA collects data on every power plant production by month (some plants do not seem to report as well as others).

Subsequent lesson sets involve creating an analysing financial models. One deals with making a single project and another on making a portfolio of projects in a rooftop analysis.


Generation Database – Solar.xlsm


P99 etc Analysis.xlsx

Combined Analysis.xlsx

US Hourly Time Series Comparison.xlsm



Files with Historic Data to Compute Standard Deviation of Irradiation

I have also shown some data on historic solar data that is a good place to start. This was provided by NREL but they decided to stop providing the data.





Solar Resource Template.xlsm

Las Vegas.xlsm

Sources for Hourly Files with Details: Files: