Weather Data for Bloemfontein South Africa

[Anonymous]

Dear collegues

The only weather files for South Africa available in Ecotect are Cape town and Johannesburg.

I want to do thermal analysis for building in Bloemfontein. I managed to get annual hourly temperature, humidity,wind data. I did not manage to get global or direct solar radiation and diffuse horizontal solar radiation.

My first question is: the data is in an exel format. How can i easily convert it into a format that is read by Ecotect.

My second question is: Is the data that i have sufficient for a thermal energy analysis.

The data in the exel format is as attached.

Your help will be greatly appreciated.

Regards

Tichaona Kumirai