Demonstration video of a spreadsheet for calculating the hourly solar irradiation on a surface of given tilt and azimuth angles for any day of the year. The other video mentioned at about 4:43 is https://youtu.be/feCEQoTFa18
No download links available.