After importing comma-delimited hourly weather data, Weather Tool shows totally incorrect rainfall figures.
It may be a result of the way I worked the data: I started with typical hourly air-met (airport) weather data. This data does not show the actual amount of precipitation, instead an indicator – RA (rain), DZ (drizzle), etc – is shown in the precipitation column. I found the total rainfall for the year from another source, then simply divided this by the number of hours that showed a precipitation indicator. In my case the region had 540mm for the year, and there were 720 precipitation hours in the same period; resulting in 0.76mm per hour. I then replaced any precipitation indicator with 0.75, and used that column as input to the rainfall field. Now, when I look at the hourly data in Weather Tool, I get completely different (and substantially larger) values. Any ideas why? It's probably something obvious that I cannot see!
Sample data...
Station -- FACT
FACT CAPE TOWN SOUTH AFRICA + 02 00 S 33 59 018 36 E + 0042 +
Mth, Day, Hr, TDbC, TdewC, WndDirDg, WndSpdKm, WndGstKm, Prc-mm, CldCv%
00, 06, 07, 18, 18, 280, 12.5, , 0.00, 57
00, 06, 08, 18, 18, 260, 12.5, , 0.75, 52
00, 06, 09, 18, 17, 240, 12.5, , 0.75, 57
00, 06, 10, 18, 18, 180, 14.2, , 0.75, 62
00, 06, 11, 19, 17, 190, 21.5, , 0.75, 52
00, 06, 12, 19, 17, 180, 15.9, , 0.00, 62
Edit Hourly Data Window attached...