Create a quot;Clear Sky Insolation Calculatorquot; for direct and diffuse radiation using the following spreadsheet as a guide.

Create a "Clear Sky Insolation Calculator" for direct and diffuse radiation using the following spreadsheet as a guide. In this example, the insolation has been computed to be 964 W/m2 for a South-facing collector tipped up at 45◦ at noon on November 7 at latitude 37.5◦. Note the third column simply adjusts angles measured in degrees to radians. Use the calculator to compute clear sky insolation under the following conditions:

a. January 1, latitude 40◦, horizontal insolation, solar noon

b. March 21, latitude 20◦, South-facing collector with tilt 20◦, 11:00 A.M. (solar time)

c. July 1, latitude 48◦, South-East facing collector (azimuth 45◦), tilt 20◦, 2 P.M. (solar time)