2) Download TMY3 data for Rochester, NY. Using this data develop a spreadsheet to calculate the total solar insolation on a PV array tilted at 40 facing directly South for June 30. Plot the beam, diffuse, reflected, and total solar radiation versus time. Note: The time given in the TMY3 is local time (not local day lights time nor solar time), which you must convert to solar time before doing your sun position calculations. The solar radiation data is the total radiation received from the sky during the 60-minute period ending at the timestamp. State all your assumptions and show hand calculations for the time between 11:00 am and noon. (Ans: 4.0 kWh/m2) 2) Download TMY3 data for Rochester, NY. Using this data develop a spreadsheet to calculate the total solar insolation on a PV array tilted at 40 facing directly South for June 30. Plot the beam, diffuse, reflected, and total solar radiation versus time. Note: The time given in the TMY3 is local time (not local day lights time nor solar time), which you must convert to solar time before doing your sun position calculations. The solar radiation data is the total radiation received from the sky during the 60-minute period ending at the timestamp. State all your assumptions and show hand calculations for the time between 11:00 am and noon. (Ans: 4.0 kWh/m2)