TMY2 hourly weather data to bin weather data conversion

$ 25.00 US

This program converts TMY2 (hourly) weather files to bin weather data for quick energy calulations. It converts the dry bulb temperature only. And currently, only US imperial units. You can choose to create 2 degree, 4 degree, 5 degree, or 10 degree temperature bins. There is also an 8760 hourly output option so you can perform more detailed studies. The 8760 hourly output also includes the relative humidity for each hour. Use this to analyze total energy heat wheels, etc.

Screen Shot

Screen shot of TMY2BIN

Included with this software is the TM2 file for Spokane, WA so you can test the software. You will need to download the TM2 file for your locations. Do not use the binary versions of the TMY2 data files that are used by DOE2. Real TM2 files will be exactly 1,261,501 bytes in length.   When you click the "Generate" button, it will read the TM2 file and create a .CSV file. The .CSV file that it creates is openable by Excel, OpenOffice and many other spreadsheet programs.

You can choose your cities and download TMY2 8760 hour per year weather data for 239 US cities from:

Be sure the use the DOS (or Windows) versions...the Unix or Mac versions do not work with TMY2BIN.


Q: So, how come you don't include a Mean Coincident Wet Bulb (MCWB) for each bin?

A: Each bin contains a number of hours out of the year that the outdoor air temperature was within the temperature range of that bin. The hours in that bin may come from almost any time of the year. That means that if you were to calculate the MCWB for each bin, the resulting MCWB would always be very close to the annual average web bulb for that city. The engineering validity of using MCWB with bin weather data is questionable, in my opinion, so I do not calculate it.

If you want to do calculations that consider the water vapor in the air, use the "8760 Hourly" output option, which outputs the DB temperature for each hour as well as the RH.

Q: Does TMY2BIN work with TMY3 hourly weather files?

A: No. TMY3 hourly weather files are in a completely different format. TMY2BIN cannot read them. However, NREL provides a conversion program what will convert a TMY3 file into a TMY2 file. TMY3 files that have been converted to TMY2 files using the NREL tool seem to work just fine with TMY2BIN. This opens up many more weather stations for use with TMY2BIN.

Downloadable Samples
Below are some sample output files created with TMY2BIN for Spokane WA. Click on the link below to have the file downloaded to your computer.

Spokane_5F_bins.csv 5 degree temperature bins, no unoccupied hours.
Spokane_5F_bins_Office.csv 5 degree temperature bins, Normal Office occupancy hours.
Spokane_5F_bins_School.csv 5 degree temperature bins, School occupancy hours.
Spokane_8760_Hourly.csv All hours output, Degrees DB and RH.

After you have saved one of these file on your computer, open it with your favorite spreadsheet program to see the bin weather information.

How to send payment by check
If you are within the USA, you can send a personal or company check, drawn from a US bank. Outside the USA, send a certified check or bank money order. I will process your order after the check clears. Make Checks payable to Randall C. Wilkinson.
Send check payments in the amount of $25.00 US to:

Randall C. Wilkinson
9721 S Cheney St
Cheney, WA 99004-9113

How to send payment by credit card
You may also pay, using your credit card, by way of a service called PayPal. When you pay using PayPal your payment is transferred directly into my account. I will then process your order and send the software to you, usually within two business days. Sorry, it is not possible to download the software immediatley after making payment.

Click the PayPal link below to send your $25.00 payment using your credit card. If you are asked for the email address of the payment receipient, then enter

Pay me securely with your Visa, MasterCard, Discover, or American Express card through PayPal! Visa ,MasterCard, Discover, and American Express

The software is available for electronic delivery only. After I receive your payment, I will email the software to you. If your email system bounces the message with the attached software (happens a lot), I will send a link for downloading the software.

If you have additional questions, send email to

Back to Main Page

Updated: Apr., 2015
Email:send inquiries to