[Bldg-sim] Converting TMY, BIN and CSV files

Karen Walkerman kwalkerman at gmail.com
Tue Dec 9 09:14:36 PST 2008


Bill,

my file looks like this:

14742 BURLINGTON             VT  -5 N 44 28 W  73  9   104
 86010101000000000000?00000?00000?00000?00000?00000?00000?010A710A70011A7-028A7076A70994A7190A7036A70080A701006A70999099999009E7036F8015A700E7
 86010102000000000000?00000?00000?00000?00000?00000?00000?010A710A70006A7-022A7082A70995A7210A7015A70080A700823A70999099999009E7036F8015A700E7
 86010103000000000000?00000?00000?00000?00000?00000?00000?010A710A70017A7-067A7054A70995A7260A7062A70113A701829A70999999999007E7036F8015A700E7
 86010104000000000000?00000?00000?00000?00000?00000?00000?010A710A70011A7-067A7057A70996A7260A7077A70113A701829A70999999999007E7036F8015A700E7
 86010105000000000000?00000?00000?00000?00000?00000?00000?010A710A7-017A7-056A7075A70996A7320A7077A70113A700975A70999099999008E7036F8015A700E7
 86010106000000000000?00000?00000?00000?00000?00000?00000?010A710A7-028A7-067A7075A70998A7340A7052A70097A701219A70999099999007E7036F8015A700E7
 86010107000000000000?00000?00000?00000?00000?00000?00000?010A710A7-033A7-044A7092A70999A7320A7057A70012A700213A70999099099008E7036F8015A700E7

... etc.  The file I'm trying to convert is simply the downloaded version
from the nrel website.  I can get my weather data into this sort of text
format, so I just need to be able to get it back to bin!!!

However, I keep getting the following error:

--- ERROR --- END OF FILE READ.  TAPE TYPE TMY2

Some solutions others have suggested that have not worked so far...

1.  Try using energy plus to convert the file to an energy plus format, just
to make sure that the source file is valid--Energy Plus had no problem with
the file

2.  Is the INPUT.TM2 text in exactly the right format (correct number of
spaces and station ID numbers)--Yes, this is exactly as demonstrated here (
http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/2008-May/007524.html),
with two spaces between the "TMY2" and station ID on line 3, and a 5-digit
station ID which matches the WEATHER.TMP file.

3.  When the files are saved as TMP files, are they WEATHER.TMP.TXT and
INPUT.TMP.TXT, or are they truly TMP files--They are truly TMP files.  In
the explorer, under "TYPE" they are identified as TMP files.

Thanks everyone for your suggestions please let me know if you have any
others.

--
Karen



On Tue, Dec 9, 2008 at 11:59 AM, Bill Talbert <btalbert at aeieng.com> wrote:

>  Karen,
> Is your data in TMY format or is it a standard text file? Attached is a
> sample text file that I created for custom weather data that can then be
> packed into a .bin format with the PKAFT.bat in the DOE weather utilities.
> The TMY format file looks a little different. Below are a few lines from a
> tmy file:
>
>  93721 BALTIMORE              MD  -5 N 39 11 W  76 40    47
>
>  65010101000000000000?00000?00000?00000?000000000000000000A700A70000A7067A7061A71026A7290A7041A70322A777777A70999999999007E7061F8000A710E7
>
>  65010102000000000000?00000?00000?00000?000000000000000000A700A70000A7067A7061A71026A7290A7041A70322A777777A70999999999007E7061F8000A710E7
>
>  65010103000000000000?00000?00000?00000?00000?0000000000000A700A7011A7061A7069A71027A7280A7021A70322A777777A70999999999008E7061F8000A710E7
> If your TMY file does not look similar, I don't think the tm2 to bin tool
> will work.
>
> If your data is not in valid tmy format, you can arrange it using a
> spreadsheet tool with 'concatenate' function so that everything is in one
> column with appropriate spacing and then save it as a text file. Rename the
> file with a .ft extension and edit the PKAFT.bat to referenced the
> appropriate file.
> Regards,
> Bill
>
>
>  Bill Talbert, PE, LEED(R) AP
> Mechanical Systems
> Phone: (608) 441-6677
> E-mail: btalbert at aeieng.com
>
> Affiliated Engineers Inc.
> 5802 Research Park Blvd.
> Madison, WI. 53719
> Tel. (608) 238-2616
> Fax. (608) 238-2614
>
> >>> "Karen Walkerman" <kwalkerman at gmail.com> 12/9/2008 10:29 AM >>>
>
> Hi Scott,
>
> Thanks for your response.  I tried your method (on both Vista and XP
> machines), and the files are created, but the NEWTH.TMP file has no info in
> it (0KB) any thoughts?
>
> Thanks again,
>
> --
> Karen
>
> On Tue, Dec 9, 2008 at 11:16 AM, Horowitz, Scott <Scott_Horowitz at nrel.gov>wrote:
>
>>  Karen,
>>
>>
>>
>> See if my past instructions on the matter help:
>>
>>
>> http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/2008-May/007524.html
>>
>>
>>
>> Scott
>>
>>
>>
>> --
>>
>> Scott Horowitz
>>
>> Center for Buildings & Thermal Systems
>>
>> National Renewable Energy Laboratory
>>
>> 1617 Cole Blvd.
>>
>> Golden, CO 80401
>>
>> 303.384.7560
>>
>>
>>   ------------------------------
>>
>> *From:* bldg-sim-bounces at lists.onebuilding.org [mailto:
>> bldg-sim-bounces at lists.onebuilding.org] *On Behalf Of *Karen Walkerman
>> *Sent:* Tuesday, December 09, 2008 9:09 AM
>> *To:* bldg-sim at lists.onebuilding.org
>> *Subject:* [Bldg-sim] Converting TMY, BIN and CSV files
>>
>>
>>
>> Hi All,
>>
>> I've seen a bunch of questions on the list-serve about creating custom
>> weather files, but never figured out how to do it myself.
>>
>> I've been able to create a custom CSV file (and then removed all commas),
>> so I should now have a custom TMY file.  How do I get it into BIN format so
>> eQuest can read it?  I downloaded the conversion files from DOE2 (
>> http://doe2.com/index_Wth.html), but can't get them to work so far.  Does
>> anyone have a more complete description of how to make them work?  Also, I
>> am running Vista... not sure if this is a problem as the conversion programs
>> are DOS based.
>>
>> Thanks,
>>
>> --
>> Karen
>>
>> _______________________________________________
>> Bldg-sim mailing list
>> http://lists.onebuilding.org/listinfo.cgi/bldg-sim-onebuilding.org
>> To unsubscribe from this mailing list send  a blank message to
>> BLDG-SIM-UNSUBSCRIBE at ONEBUILDING.ORG
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/bldg-sim-onebuilding.org/attachments/20081209/da859fa9/attachment-0002.htm>


More information about the Bldg-sim mailing list