The PVM – Solar collector calculator is an MS Excel file sized 9 MB which calculates the solar radiation reaching an 1 m2 surface part of Earth and the annual energy production of Solar cells and collectors with certain tilting angle, orientation, efficiency, using the spherical trigonometry cosines to a certain latitude without internet connection. The file consists of 4 sheets. You can select your language by the correct number and provide the necessary data to the calculation on the "input – adatbevitel" sheet in the correct unit. Modify only the cells with yellow background! The green cells show the calculated results in the correct units.
The sheet "táblázatok-tables" analizes, illustrates and provides more detailed information about the calculated results in 3 large tables. The first table shows the sun elevation angle in the assigned date from hour to hour. The colors illustrate the light ambiances suited to the sun elevation angles.
The second table illustrates the heat radiation reaching an 1 m2 part of Earth. The last 2 columns show the 24 hours average and the daytime average (effective) radiation. The colors help you to way around the table. The grey color (Q<250 W/m2) shows the insignificant, the yellow color shows the usage heat radiation. The light yellow color (Q>800 W/m2) shows the radiation that you call "dangerous sun exposure" when the UV light is strong too!
The 3rd table shows the energy produced by the PV module or solar collector from hour to hour in Watts. In the end, you can read the daily amount of the energy produced both in MJ and kWh.
The table counts with the surface constant q=1102 W/m2 instead of the q=1361 W/m2 space solar radiation constant in order to use the atmosphere absorbed heat radiation immediately in the calculations. Do not modify the cells to prevent damage of the sheet! The sheet "ábra – diagram" summarizes these tables to the astrological remarkable days of Earth (equonixes, solstices) and shows the units of the results showed in the diagram.
'Zoomed out' images:
Pécel, 9th of January 2016