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 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
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.
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.
degree temperature bins, Normal Office occupancy hours.
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 email@example.com
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 firstname.lastname@example.org
Back to Main Page
Updated: Apr., 2015
send inquiries to email@example.com