WEATHER DATA
|
![[Link Map]](../../icons/smartnav.gif)
|
To get this data into Excel, choose File > Save frame as.. in Netscape 4
or similar for other browsers. Change the option for the Format of the saved document to Text.
Save it to a local file on your system and start Excel.
Then, in Excel, click on Open and choose the file. Once the Text Wizard comes up, change the
'Start Import at row' option to 12 or whatever row the column names are in and click Finish.
Day hour cloud rad temp humidity rain windsp windir
1 0 1 0 3.7 80 0 11 4
1 1 6 0 3.5 78 0 11 4
1 2 3 0 2.6 82 0 8 4
1 3 4 0 2.9 74 0 13 4
1 4 1 6 2.5 68 0 15 4
1 5 1 56 2.0 69 0 14 4
1 6 4 130 2.9 69 0 16 4
1 7 7 166 3.1 76 0 16 4
1 8 6 300 1.0 96 1 9 4
1 9 6 527 2.8 89 0 12 4
1 10 3 651 5.0 67 0 18 1
1 11 3 680 5.9 57 0 16 1
1 12 4 578 7.2 53 0 15 1
1 13 6 416 6.5 59 0 11 4
1 14 7 337 5.9 67 0 8 4
1 15 6 354 3.9 85 0 12 4
1 16 7 304 1.9 96 1 19 1
1 17 6 173 2.0 94 1 9 4
1 18 8 108 1.6 91 1 19 4
1 19 3 47 1.8 89 1 12 4
1 20 2 8 0.9 86 0 7 4
1 21 3 0 0.4 92 0 9 4
1 22 2 0 0.5 86 0 12 4
1 23 3 0 0.4 85 0 11 4
2 0 3 0 0.6 84 0 9 4
2 1 1 0 0.3 89 0 10 4
2 2 5 0 -0.1 90 0 7 4
2 3 2 0 0.4 90 0 5 4
2 4 2 9 -0.2 96 0 7 4
2 5 7 48 -0.5 93 0 6 3
2 6 7 100 0.2 81 0 5 4
2 7 7 157 1.2 75 0 5 3
2 8 7 210 2.2 75 0 10 3
2 9 7 184 3.5 73 0 10 3
2 10 8 121 2.3 89 1 11 3
2 11 8 104 2.8 95 1 15 3
2 12 8 94 2.8 96 1 20 3
2 13 8 86 3.0 98 1 24 3
2 14 8 101 4.4 97 1 24 3
2 15 8 85 5.0 97 0 19 3
2 16 8 59 6.2 95 1 15 3
2 17 8 48 4.8 94 1 13 4
2 18 7 66 4.4 92 0 5 3
2 19 7 59 4.6 90 0 12 3
2 20 7 12 3.5 88 0 11 3
2 21 7 0 3.4 86 0 9 3
2 22 1 0 2.2 87 0 14 3
2 23 4 0 1.6 93 0 8 3
3 0 7 0 3.9 87 0 16 3
3 1 7 0 4.0 88 0 13 3
3 2 7 0 3.8 92 0 6 3
3 3 4 0 3.0 93 1 6 4
3 4 5 4 2.6 86 0 15 4
3 5 2 56 1.9 87 0 12 4
3 6 1 187 2.8 81 0 12 4
3 7 1 326 4.4 74 0 13 4
3 8 4 385 6.7 65 0 14 4
3 9 6 367 7.2 64 0 14 4
3 10 7 399 7.8 60 0 20 4
3 11 7 398 8.3 61 0 19 4
3 12 7 362 7.4 65 0 20 4
3 13 7 475 6.2 82 1 22 4
3 14 7 484 4.7 87 1 23 4
3 15 7 381 5.6 85 1 19 4
3 16 7 259 5.4 84 0 15 4
3 17 7 137 5.5 81 0 12 4
3 18 7 76 5.2 87 1 13 4
3 19 7 32 3.9 90 1 12 4
3 20 6 7 3.7 90 0 11 4
3 21 3 0 3.2 90 0 5 4
3 22 3 0 3.3 88 0 9 4
3 23 4 0 3.5 86 0 10 4
4 0 7 0 3.4 90 0 12 4
4 1 5 0 3.1 90 0 12 4
4 2 3 0 2.9 88 0 11 4
4 3 4 0 2.8 88 0 12 4
4 4 7 2 3.3 86 0 19 4
4 5 8 20 2.1 93 1 16 4
4 6 7 70 2.6 93 1 16 4
4 7 7 122 3.7 88 1 22 4
4 8 7 139 4.9 82 0 20 4
4 9 7 219 5.8 80 0 23 4
4 10 7 377 5.9 79 0 22 4
4 11 7 362 5.4 78 0 20 4
4 12 7 365 5.6 82 0 21 4
4 13 7 473 6.7 75 0 22 4
4 14 7 298 6.8 72 0 25 4
4 15 7 261 5.5 84 1 23 4
4 16 7 284 6.6 76 0 18 4
4 17 7 166 6.3 72 0 20 4
4 18 7 85 5.9 73 0 18 4
4 19 7 34 5.6 74 0 15 4
4 20 7 6 5.5 72 0 15 4
4 21 7 0 5.5 69 0 16 4
4 22 7 0 4.7 79 0 12 4
4 23 7 0 4.3 82 0 13 4
5 0 6 0 4.4 80 0 13 4
5 1 7 0 4.1 82 0 9 4
5 2 4 0 3.6 85 0 10 4
5 3 7 0 3.6 85 0 10 4
5 4 7 5 3.6 85 0 9 4
5 5 6 40 3.5 86 0 9 4
5 6 6 106 3.7 85 0 9 4
5 7 6 171 5.3 81 0 10 4
5 8 7 170 6.2 80 0 13 1
5 9 7 130 5.5 86 0 14 4
5 10 7 190 5.8 89 1 8 4
5 11 7 238 7.8 84 0 9 4
5 12 7 193 5.8 86 1 3 4
5 13 7 181 6.6 87 1 16 1
5 14 7 156 5.6 91 1 16 1
5 15 7 124 6.5 89 1 14 1
5 16 7 159 6.3 91 0 14 1
5 17 7 136 5.6 89 1 16 1
5 18 7 96 6.4 83 0 17 1
5 19 7 42 5.5 83 0 14 1
5 20 7 8 4.8 84 0 15 1
5 21 7 0 4.3 83 0 14 1
5 22 7 0 4.0 78 0 11 1
5 23 7 0 3.0 79 0 10 4
6 0 7 0 2.3 80 0 12 4
6 1 7 0 2.1 84 0 10 4
6 2 7 0 2.0 89 0 11 4
6 3 7 0 1.7 85 0 10 4
6 4 7 8 1.3 87 0 9 4
6 5 5 67 1.2 85 0 7 4
6 6 6 150 2.0 80 0 9 4
6 7 5 209 2.5 75 0 11 4
6 8 6 291 3.6 71 0 11 4
6 9 6 434 4.4 69 0 12 1
6 10 7 571 5.3 60 0 8 1
6 11 6 522 5.9 57 0 9 1
6 12 6 409 6.8 56 0 6 1
6 13 7 329 6.7 58 0 6 1
6 14 7 295 6.8 56 0 8 1
6 15 7 219 6.1 68 0 6 2
6 16 7 112 5.4 77 0 9 2
6 17 7 71 4.3 85 1 7 2
6 18 7 47 2.9 95 1 5 2
6 19 7 30 3.0 91 0 2 2
6 20 6 5 2.7 91 1 0 *
6 21 3 0 1.9 93 0 0 *
6 22 3 0 1.2 96 0 0 *
6 23 1 0 0.1 98 0 0 *
7 0 1 0 -0.7 97 0 0 *
7 1 0 0 -1.6 98 0 0 *
7 2 0 0 -1.9 96 0 0 *
7 3 1 0 -2.9 95 0 0 *
7 4 1 13 -3.6 94 0 0 *
7 5 1 103 -3.2 95 0 0 *
7 6 1 268 -1.2 97 0 0 *
7 7 1 393 1.0 81 0 5 1
7 8 1 501 3.6 86 0 4 1
7 9 2 640 6.1 79 0 4 2
7 10 3 752 7.4 69 0 5 2
7 11 4 813 8.1 67 0 6 2
7 12 3 818 9.1 64 0 7 2
7 13 2 773 9.8 65 0 6 2
7 14 1 703 9.5 66 0 7 2
7 15 2 605 9.4 70 0 9 2
7 16 3 480 8.1 74 0 7 2
7 17 2 341 8.0 76 0 8 2
7 18 2 203 7.6 74 0 8 2
7 19 3 89 6.5 84 0 7 2
7 20 5 19 5.4 86 0 2 2
7 21 5 0 4.8 90 0 0 *
7 22 3 0 3.2 93 0 0 *
7 23 4 0 2.8 95 0 0 *