[Equest-users] editing weather data
Claudia De Paula
claudia_dp at GroupVE.co.il
Thu Feb 10 00:30:13 PST 2011
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.
From: equest-users-bounces at lists.onebuilding.org [mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Varkie C Thomas
Sent: Thursday, February 10, 2011 1:29 AM
To: yashika agarwalla
Cc: equest-users at lists.onebuilding.org
Subject: Re: [Equest-users] editing weather data
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<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<http://bepan.info/> Under tab Weather open 11 or 12 template for Shanghai or Beijing.)
Hour
Mon
Day
Hour
WB
DB
Atm Pr
Cloud
Snow
Rain
Wind
Hum Rat
Density
Enthalpy
Solar
Solar
Cloud
Speed
Dew
RH
of
No.
of
of
deg F
deg F
" Hg
Cover
Flag
Flag
Dir.
lbs / lb
lbs/ft3
btu / lb
Horiz
Direct
Type
Knots
Point
r
Year
Mon
Day
t*
t
p
CC
W
D
H
I-h
I-d
td
%
1
1
1
1
71.0
75.0
29.8
1
0
0
5
0.0151
0.072
34.5
0
0
2
2
68.4
83
2
1
1
2
70.0
75.0
29.8
2
0
0
5
0.0148
0.072
34.0
0
0
2
2
66.9
78
3
1
1
3
70.0
74.0
29.8
2
0
0
5
0.0146
0.072
33.5
0
0
2
1
67.4
82
4
1
1
4
69.0
73.0
29.8
3
0
0
0
0.0143
0.073
33.0
0
0
2
0
66.3
82
5
1
1
5
68.0
72.0
29.8
3
0
0
0
0.0141
0.073
32.5
0
0
2
0
65.3
82
6
1
1
6
68.0
72.0
29.8
3
0
0
0
0.0136
0.073
32.0
0
0
2
0
65.3
82
Change DB, WB, AP, WS for new elevation
Hour
Mon
Day
Hour
WB
DB
Atm Pr
Cloud
Snow
Rain
Wind
Hum Rat
Density
Enthalpy
Solar
Solar
Cloud
Speed
of
No.
of
of
deg F
deg F
" Hg
Cover
Flag
Flag
Dir.
lbs / lb
lbs/ft3
btu / lb
Horiz
Direct
Type
Knots
Year
Mon
Day
t*
t
p
CC
W
D
H
I-h
I-d
9.9
1
1
1
1
61.5
69.2
28.1
1
0
0
5
0.0134
0.070
31.2
0
0
2
3
2
1
1
2
60.8
69.2
28.1
2
0
0
5
0.0127
0.070
30.5
0
0
2
3
3
1
1
3
60.8
68.2
28.1
2
0
0
5
0.0129
0.071
30.4
0
0
2
1
4
1
1
4
60.0
67.2
28.1
3
0
0
0
0.0124
0.071
29.7
0
0
2
0
5
1
1
5
59.3
66.2
28.1
3
0
0
0
0.0119
0.071
28.9
0
0
2
0
Convert Original NCDC data to Text Table
WBAN
DB
WB
DP
WD
WS
AP
W
CC
Rad
Blnk
YR
MO
DY
HR
41024
999
999
999
999
999
9999
9
99
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
0
41024
999
999
999
999
999
9999
9
99
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
1
41024
999
999
999
999
999
9999
9
99
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
2
41024
73
69
68
0
0
2982
0
3
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
3
41024
72
999
66
0
0
9999
0
3
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
4
41024
72
999
66
0
0
9999
0
3
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
5
41024
70
67
66
0
0
2983
0
3
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
6
41024
70
999
66
0
0
9999
0
3
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
7
41024
72
999
70
110
4
9999
0
5
99
9
999
99
9
999
99
99
9
999
99
99
9
999
2008
1
1
8
Insert revised DB, WB, AP, WS into NCDC. Change DB = 69 to 069 etc. using global replace .
1-5
6-8
9-11
12-14
15-17
18-20
21-24
25
26-27
28-29
30
31-33
34-35
36
37-39
40-41
42-43
44
45-47
48-49
50-51
52
53-55
56-59
60-69
70-73
74-75
76-77
78-79
5
3
3
3
3
3
4
1
2
2
1
3
2
1
3
2
2
1
3
2
2
1
3
4
10
4
2
2
2
N0.
DB
WB
DP
WD
WS
AP
W
CC
Rad
Blk
YR
M0
DY
HR
41024
069
062
999
005
003
2813
0
01
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
x
2008
01
01
00
41024
069
061
999
005
003
2813
0
02
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
01
41024
068
061
999
005
001
2812
0
02
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
02
41024
067
060
999
000
000
2812
0
03
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
03
41024
066
059
999
000
000
2812
0
03
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
04
41024
066
059
999
000
000
2812
0
03
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
05
41024
064
059
999
000
000
2811
0
03
99
9
999
99
9
999
99
99
9
999
99
99
9
999
x
2008
01
01
06
Convert Table to Text
4102406906299900500328130019999999999999999999999999999 2008010100
4102406906199900500328130029999999999999999999999999999 2008010101
4102406806199900500128120029999999999999999999999999999 2008010102
4102406706099900000028120039999999999999999999999999999 2008010103
4102406605999900000028120039999999999999999999999999999 2008010104
4102406605999900000028120039999999999999999999999999999 2008010105
4102406405999900000028110039999999999999999999999999999 2008010106
**********************************************************************************************
IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the
named recipient(s) only.
If you have received this email in error, please notify the system manager or the sender immediately and do
not disclose the contents to anyone or make copies thereof.
*** eSafe scanned this email for viruses, vandals, and malicious content. ***
**********************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110210/1f1eb089/attachment.htm>
More information about the Equest-users
mailing list