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.
Yashika
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%
111171.075.029.810050.01510.07234.5002268.483
211270.075.029.820050.01480.07234.0002266.978
311370.074.029.820050.01460.07233.5002167.482
411469.073.029.830000.01430.07333.0002066.382
511568.072.029.830000.01410.07332.5002065.382
611668.072.029.830000.01360.07332.0002065.382
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
111161.569.228.110050.01340.07031.20023
211260.869.228.120050.01270.07030.50023
311360.868.228.120050.01290.07130.40021
411460.067.228.130000.01240.07129.70020
511559.366.228.130000.01190.07128.90020
Convert Original NCDC data to Text Table
WBANDBWBDPWDWSAPWCCRadBlnkYRMODYHR
41024999999999999999999999999999999999999999999999999992008110
41024999999999999999999999999999999999999999999999999992008111
41024999999999999999999999999999999999999999999999999992008112
410247369680029820399999999999999999999999999992008113
4102472999660099990399999999999999999999999999992008114
4102472999660099990399999999999999999999999999992008115
410247067660029830399999999999999999999999999992008116
4102470999660099990399999999999999999999999999992008117
410247299970110499990599999999999999999999999999992008118
Insert revised DB, WB, AP, WS into NCDC. Change DB = 69 to 069 etc. using global replace .
1-56-89-1112-1415-1718-2021-242526-2728-293031-3334-353637-3940-4142-434445-4748-4950-515253-5556-5960-6970-7374-7576-7778-79
533333412213213221322134104222
N0.DBWBDPWDWSAPWCC RadBlkYRM0DYHR
4102406906299900500328130019999999999999999999999999999xx2008010100
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
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,
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