Weather xls to TMY2

This program converts data defined in a particular format in an excel file to TMY2 data format

The program converts measured data comprising of temperature, RH, GHI, DHI, DNI, wind speed and wind direction into TMY2 format. The TMY2 fields comprising of Illuminance components, atmospheric pressure, precipitable water and broad-band aerosol optical depth are modeled based on tested models available in open literature. Their references are provided in the m-file.
The zip file contains:
1. converter m-file
2. sample data excel files present in yearly and monthly folder
3. TMY2 output from the m-file for the yearly data

Details about TMY2 format can be found at:
http://rredc.nrel.gov/solar/pubs/tmy2/tmy2_index.html

The TMY2 data generated by the m-file can then be converted into .epw and .csv using energy plus weather utility and then to .bin using eQuest weather processor available at http://doe2.com/index_wth.html.

I have tried to comment the m-file so that the user can understand and be able modify it.