I am trying to present the weather data (wind speed, wind direction, temperature, humidity, rain precipitation) in some simple charts using MS excel. The interval of data is 1 minute. So we need to apply some adaptive function of excel. Critics and suggestions are welcome to armanadi@gmail.com
1 of 1
Download to read offline
More Related Content
Weather report 2013 june
1. Weather Station: Suzuki Project Site Office
Location: 6属 23' 15.2124" S Report Monthly Jun 2013
107属 10' 47.8488" E Date: 12-Jun 1-Jul 2013
Altitude 25 masl Time: 12:00 AM until 11:59 PM
Wind speed: average 1.4_______ m/s
max 9.4_______ m/s @
Humidity: average 83.0______ %
max 98.0______ % @
lowest 45.0______ % @
Temperature: average 27.1______ 属C
max 34.1______ 属C @
lowest 22.2______ 属C @
Precipitation rate 0.0______ mm/hr
Number of Rainy Days: 4 max 60.0_____ mm/hr @15-Jun 16:45
Total Rainfall: 10.6 mm Temperature 27.1_____ 属C
max 34.1_____ 属C @24-Jun 14:25
lowest 22.2_____ 属C @28-Jun 05:36
Humidity average 83.0_____ %
max 98.0_____ % @18-Jun 02:37
lowest 45.0_____ % @24-Jun 14:16
27 Jun 15:57
18 Jun 02:37
24 Jun 14:16
24 Jun 14:25
28 Jun 05:36
0 0 0 0 0 0 0 0 0 0 0 0
8.2
0 1.6 0 0 0 0.2 0.6 0 0 0 0 0 0 0 0 0 0
28.3
31.8 31.8
32.6 32.4
27.2
32.4 31.9 31.3 31.8 31.8 32.4
34.1 34.1
32.4
33.4
31.7 32.2 32.6
属C
5属C
10属C
15属C
20属C
25属C
30属C
35属C
40属C
%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
1-Jun
2-Jun
3-Jun
4-Jun
5-Jun
6-Jun
7-Jun
8-Jun
9-Jun
10-Jun
11-Jun
12-Jun
13-Jun
14-Jun
15-Jun
16-Jun
17-Jun
18-Jun
19-Jun
20-Jun
21-Jun
22-Jun
23-Jun
24-Jun
25-Jun
26-Jun
27-Jun
28-Jun
29-Jun
30-Jun
Rain Humidity Mean Temp Max Temp Min Temp Ave Wind Speed
N
NNE
NE
ENE
E
ESE
SE
SSE
S
SSW
SW
WSW
W
WNW
NW
NNW
Wind Speed and Direction
Speed Weighted
Unweighted
Rain Precipitation and Humidity
属
90属
180属
270属
360属
12-Jun
13-Jun
14-Jun
15-Jun
16-Jun
17-Jun
18-Jun
19-Jun
20-Jun
21-Jun
22-Jun
23-Jun
24-Jun
25-Jun
26-Jun
27-Jun
28-Jun
29-Jun
30-Jun
1-Jul
Wind Speed