editing weather data

4 posts / 0 new
Last post

Dear all

I am using equest 3.64 and i want to edit weather data. So, in order to do
that i downloaded .bin weather files from the doe site and using a doe
processor i converted the file into text format, editted it . Now, i am
having problems regarding how to change the edited file back into .bin form
so that it can be fed into equest as an input data. please help !! Also, i
wantes to know if we could run the energy simulation process for a a day or
an hour only instead of one whole year and how to give in onlya few selected
parameters instead of all the parameters.


aquarianyashika's picture
Joined: 2011-02-03
Reputation: 0

I just managed to (nearly - failed because I could not run DOE2 weather processors on 64-bit computer) do this for someone. It is not easy. It can't taught over the internet
Convert the NOAA/NCDC ?location.dat? to ?location.bin?. Convert the ?location.bin? to an Excel file. (See website http://bepan.info Under tab Weather open 11 or 12 template for Shanghai or Beijing.)
The someone changed the DB, WB, Atmos.Press.(AP) & Wind Speed (WS) in the Excel columns for values that occur at a much higher location near to the original NCDC location.
In the Excel file, the DB & WB have to be rounded off (no decimal). The Wind-Speed has also changed. The whole file has to be made Text. The decimal in Atmos. Press. has to be removed. For columns have changed.
The original NOAA/NCDC text has to be converted text file table with columns. Replace the Columns for DB, WB, WS, & AP with your revised data columns. Insert 0s before numbers to make them the required number characters long. Ex. DB = 95 becomes 095 and WS = 7 becomes 007.
Convert text file columnar table into text again.
Replace spaces between the columns with nothing (no space).
Insert 14 spaces before the year 2008.
Save as text file.
Change the file extension from ".txt" to ".ft".
Locate the .ft file in directory weather/unpacked
Locate the .inp file in directory weather/input

This I could not do because my 64-bit computer will not run DOE21E programs
Run PKAFT (.bat) in DOS (command prompt) to convert NCDC to BIN
Original NCDC

Original NCDC
4102499999999999999999999999999999999999999999999999999 2008010100
4102499999999999999999999999999999999999999999999999999 2008010101
4102499999999999999999999999999999999999999999999999999 2008010102
4102407306906800000029820039999999999999999999999999999 2008010103
4102407299906600000099990039999999999999999999999999999 2008010104
4102407299906600000099990039999999999999999999999999999 2008010105
Convert NCDC to BIN.
Convert BIN to Excel (See website http://bepan.info Under tab Weather open 11 or 12 template for Shanghai or Beijing.)
HourMonDayHourWBDBAtm PrCloudSnowRainWindHum RatDensityEnthalpySolarSolarCloudSpeedDewRH
ofNo.ofofdeg Fdeg F" HgCoverFlagFlagDir.lbs / lblbs/ft3btu / lbHorizDirectTypeKnotsPointr
Year MonDayt*tpCC WDHI-hI-d td%

Change DB, WB, AP, WS for new elevation
HourMonDayHourWBDBAtm PrCloudSnowRainWindHum RatDensityEnthalpySolarSolarCloudSpeed
ofNo.ofofdeg Fdeg F" HgCoverFlagFlagDir.lbs / lblbs/ft3btu / lbHorizDirectTypeKnots
Year MonDayt*tpCC WDHI-hI-d 9.9

Convert Original NCDC data to Text Table

Insert revised DB, WB, AP, WS into NCDC. Change DB = 69 to 069 etc. using global replace .

4102406906199900500328130029999999999999999999999999999x 2008010101
4102406806199900500128120029999999999999999999999999999x 2008010102
4102406706099900000028120039999999999999999999999999999x 2008010103
4102406605999900000028120039999999999999999999999999999x 2008010104
4102406605999900000028120039999999999999999999999999999x 2008010105
4102406405999900000028110039999999999999999999999999999x 2008010106

Convert Table to Text
4102406906299900500328130019999999999999999999999999999 2008010100
4102406906199900500328130029999999999999999999999999999 2008010101
4102406806199900500128120029999999999999999999999999999 2008010102
4102406706099900000028120039999999999999999999999999999 2008010103
4102406605999900000028120039999999999999999999999999999 2008010104
4102406605999900000028120039999999999999999999999999999 2008010105
4102406405999900000028110039999999999999999999999999999 2008010106

Varkie Thomas's picture
Joined: 2011-09-30
Reputation: 0

I have just done something like this.
I took an EPW file and renamed it to csv, then I could open it in excel. (Renaming a BIN file did not work).
I changed whatever I needed to change in the csv file and saved it.
Then I renamed it to EPW again and used the weather processor to convert it to BIN.
It worked.

Claudia De Paula's picture
Joined: 2011-09-30
Reputation: 0

I will try it. Until now I have been converting a .bin file into text file with DOE2 weather processor MKAFT, and opening the text file with Excel. The changes were made in Excel for a different elevation (affects AP, DB, WB, WS). The converted .bin file text file and the original NOAA/NCDC have different formats. Converting back to the NOAA/NCDC was tedious but I managed this once. I will not try doing it again. Your method seems easier.

Varkie Thomas's picture
Joined: 2011-09-30
Reputation: 0