Solar radiation calculation spreadsheet basic

With date, longitude and latitude, assuming clearness of 1, calculate normal direct irradiation, direct irradiation and diffuse irradiation onto a horizontal plane, as well as the total solar irradiation onto a horizontal surface.