How to Calculate Solar Insolation (kWh/m2) for a Solar Power Plant using Solar Radiation (W/m2)

You are here:
← All Topics
Solar Insolation is the amount of solar energy received on a unit surface over a period of time. It is expressed in units of kWh/m2.

To calculate it you will need to integrate your solar radiation (w/m2) data over a time interval.

Monitoring platforms calculates the area of the graph accurately by integrating the available radiation with time. Higher the data frequency more accurate will be the calculated Solar Insolation

However, to calculate it manually in excel we’ll start it by breaking the region into multiple rectangular strips of the same width

where

Width of rectangle = Data Frequency (for example 10 mins)
10 mins= 10/60 hrs

Height of rectangle = Solar Radiation (in kW/m2)

Note: solar radiation value is received in W/m2 via pyranometer and can be converted to kW/m2 by dividing it with 1000

Area of 1 smaller rectangle= Length * Width

Height = Solar radiation in kW/m2
Width= Data frequency in hr

Now to calculate the solar insolation we will need to calculate the area of each rectangle and add the results together to have the area of the region under the graph

Solar Insolation = Sum of area of all rectangles

Sample Excel having similar calculation with 10 min data frequency is available below for reference