[Equest-users] editing weather data

[Varkie C Thomas]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110209/ff6247cc/attachment-0002.htm>
-------------- next part --------------
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110209/ff6247cc/attachment-0003.htm>
-------------- next part --------------
_______________________________________________
Equest-users mailing list
http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org
To unsubscribe from this mailing list send  a blank message to EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG