Spreadsheet: 152670d1335466600-which-formula-would-work-weatherdata1
Sheet: Sensitive

 |  |  |  |  |  |  |  |  |  | START | END
 |  |  |  |  | Sensitive Receptor |  |  |  |  | 11:00:00 | 11:27:00
 |  | Temp | Temp | Out | Wind | Wind | Wind | Wind dir |  |  | Rain
Date | Time | Out | Out | Hum | Speed | Dir | Dir | Blows | Bar | Pressure | Rate | N Component | E Component
2012-03-21 00:00:00 | 11:00:00 | 51.9 | 11.05555555555556 | 68 | 5 | NNE | 22.5 | 202.5 | 30.53 | 103.4967 | 0 | -4.6193976625 | -1.913417162 |  | 2012-03-21 00:00:00 | 11:00:00
2012-03-21 00:00:00 | 11:01:00 | 51.9 | 11.05555555555556 | 69 | 4 | NE | 45 | 225 | 30.528 | 103.48992 | 0 | -2.8284271248 | -2.8284271248
2012-03-21 00:00:00 | 11:02:00 | 51.8 | 11 | 69 | 5 | NNE | 22.5 | 202.5 | 30.529 | 103.49331 | 0 | -4.6193976625 | -1.913417162
2012-03-21 00:00:00 | 11:03:00 | 51.8 | 11 | 68 | 5 | NNE | 22.5 | 202.5 | 30.53 | 103.4967 | 0 | -4.6193976625 | -1.913417162
2012-03-21 00:00:00 | 11:04:00 | 51.8 | 11 | 68 | 6 | NE | 45 | 225 | 30.53 | 103.4967 | 0 | -4.2426406872 | -4.2426406872
2012-03-21 00:00:00 | 11:05:00 | 51.8 | 11 | 68 | 4 | NNE | 22.5 | 202.5 | 30.53 | 103.4967 | 0 | -3.69551813 | -1.5307337296
2012-03-21 00:00:00 | 11:06:00 | 51.8 | 11 | 69 | 6 | NE | 45 | 225 | 30.53 | 103.4967 | 0 | -4.2426406872 | -4.2426406872
2012-03-21 00:00:00 | 11:07:00 | 51.8 | 11 | 69 | 3 | NE | 45 | 225 | 30.529 | 103.49331 | 0 | -2.1213203436 | -2.1213203436
2012-03-21 00:00:00 | 11:08:00 | 51.8 | 11 | 70 | 5 | NE | 45 | 225 | 30.529 | 103.49331 | 0 | -3.535533906 | -3.535533906
2012-03-21 00:00:00 | 11:09:00 | 51.8 | 11 | 70 | 5 | NNE | 22.5 | 202.5 | 30.53 | 103.4967 | 0 | -4.6193976625 | -1.913417162
2012-03-21 00:00:00 | 11:10:00 | 51.8 | 11 | 69 | 5 | NE | 45 | 225 | 30.53 | 103.4967 | 0 | -3.535533906 | -3.535533906
2012-03-21 00:00:00 | 11:11:00 | 51.8 | 11 | 69 | 4 | NNE | 22.5 | 202.5 | 30.532 | 103.50348 | 0 | -3.69551813 | -1.5307337296
2012-03-21 00:00:00 | 11:12:00 | 51.8 | 11 | 69 | 4 | ENE | 67.5 | 247.5 | 30.532 | 103.50348 | 0 | -1.5307337296 | -3.69551813
2012-03-21 00:00:00 | 11:13:00 | 51.8 | 11 | 70 | 6 | N | 0 | 180 | 30.532 | 103.50348 | 0 | -6 | 0
2012-03-21 00:00:00 | 11:14:00 | 51.8 | 11 | 69 | 5 | NNE | 22.5 | 202.5 | 30.531 | 103.50009 | 0 | -4.6193976625 | -1.913417162
2012-03-21 00:00:00 | 11:15:00 | 51.8 | 11 | 68 | 6 | N | 0 | 180 | 30.533 | 103.50687 | 0 | -6 | 0
2012-03-21 00:00:00 | 11:16:00 | 51.8 | 11 | 69 | 4 | N | 0 | 180 | 30.532 | 103.50348 | 0 | -4 | 0
2012-03-21 00:00:00 | 11:17:00 | 51.8 | 11 | 71 | 3 | NNE | 22.5 | 202.5 | 30.532 | 103.50348 | 0 | -2.7716385975 | -1.1480502972
2012-03-21 00:00:00 | 11:18:00 | 51.8 | 11 | 70 | 3 | N | 0 | 180 | 30.532 | 103.50348 | 0 | -3 | 0
2012-03-21 00:00:00 | 11:19:00 | 51.9 | 11.05555555555556 | 70 | 5 | N | 0 | 180 | 30.533 | 103.50687 | 0 | -5 | 0
2012-03-21 00:00:00 | 11:20:00 | 51.9 | 11.05555555555556 | 69 | 6 | NNE | 22.5 | 202.5 | 30.533 | 103.50687 | 0 | -5.543277195 | -2.2961005944
2012-03-21 00:00:00 | 11:21:00 | 51.8 | 11 | 69 | 6 | NNE | 22.5 | 202.5 | 30.532 | 103.50348 | 0 | -5.543277195 | -2.2961005944
2012-03-21 00:00:00 | 11:22:00 | 51.7 | 10.94444444444445 | 69 | 6 | NNE | 22.5 | 202.5 | 30.535 | 103.51365 | 0 | -5.543277195 | -2.2961005944
2012-03-21 00:00:00 | 11:23:00 | 51.6 | 10.88888888888889 | 69 | 6 | N | 0 | 180 | 30.535 | 103.51365 | 0 | -6 | 0
2012-03-21 00:00:00 | 11:24:00 | 51.6 | 10.88888888888889 | 69 | 5 | N | 0 | 180 | 30.536 | 103.51704 | 0 | -5 | 0
2012-03-21 00:00:00 | 11:25:00 | 51.6 | 10.88888888888889 | 70 | 4 | NNE | 22.5 | 202.5 | 30.536 | 103.51704 | 0 | -3.69551813 | -1.5307337296
2012-03-21 00:00:00 | 11:26:00 | 51.6 | 10.88888888888889 | 70 | 4 | NNE | 22.5 | 202.5 | 30.536 | 103.51704 | 0 | -3.69551813 | -1.5307337296
2012-03-21 00:00:00 | 11:27:00 | 51.6 | 10.88888888888889 | 71 | 4 | NNE | 22.5 | 202.5 | 30.535 | 103.51365 | 0 | -3.69551813 | -1.5307337296