Spreadsheet: 710418d1608951928-how-to-display-a-mode-from-an-adjacent-set-of-values-april
Sheet: Apr

 |  | April 2020 Weather Data - Magrathea |  |  |  |  |  |  | Wind Bearing | Frequency
 |  |  |  |  |  |  |  |  | N
Rain Data |  |  | Temperature Data |  |  | Wind Data |  |  | NNE
Total Rain (mm) |  |  | Min Temp  (°C) |  |  | [NAME] (km/h) |  |  | NE
[NAME] (mm/h) |  |  | [NAME]  (°C) |  |  | [NAME] (km/h) |  |  | ENE
High Hourly Rain (mm) |  |  | [NAME] (°C) |  |  | High Wind (km/h) |  |  | E
High Daily Rain (mm) |  |  | Highest Low Temp  (°C) |  |  | [NAME] (km/h) |  |  | ESE
Rain Days |  |  | Lowest High Temp  (°C) |  |  | Wind Run (Km) |  |  | SE
Dry Days |  |  | Max Apparent Temp  (°C) |  |  | Avg Daily Wind Run (km) |  |  | SSE
Humidity Data |  |  | Min Apparent Temp  (°C) |  |  | [NAME] speed (km/h) |  |  | S
Avg Relative Humidity (%) |  |  | Low Wind Chill  (°C) |  |  | Direction Mode |  |  | SSW
Solar Data |  |  | High Dew Point  (°C) |  |  | Barometric Data |  |  | SW
Sunshine Hours |  |  | [NAME]  (°C) |  |  | Min Pressure (hPa) |  |  | WSW
[NAME] (w/m²) |  |  | Avg Heating Degree Days (°C) |  |  | [NAME] (hPa) |  |  | W
Average Max UV |  |  | [NAME] (°C) |  |  | Avg Pressure (hPa) |  |  | WNW
 |  |  |  |  |  |  |  |  | NW
 |  |  |  |  |  |  |  |  | NNW
Date | Highest wind gust | Bearing of highest wind gust | Time of highest wind gust | Minimum temperature | Time of minimum temperature | Maximum temperature | Time of maximum temperature | Minimum sea level pressure | Time of minimum pressure | Maximum sea level pressure | Time of maximum pressure | Maximum rainfall rate | Time of maximum rainfall rate | Total rainfall for the day | Average temperature for the day | Total wind run | Highest average wind speed | Time of highest average wind speed | Lowest humidity | Time of lowest humidity | Highest humidity | Time of highest humidity | Total evapotranspiration | Total hours of sunshine | High heat index | Time of high heat index | High apparent temperature | Time of high apparent temperature | Low apparent temperature | Time of low apparent temperature | High hourly rain | Time of high hourly rain | Low wind chill | Time of low wind chill | High dew point | Time of high dew point | Low dew point | Time of low dew point | Dominant wind bearing | Heating degree days | Cooling degree days | High solar radiation | Time of high solar radiation | High UV Index | Time of high UV Index
2020-04-01 00:00:00 | 20.9 | 90 | 17:27 | 11.3 | 00:27:00 | 23.1 | 14:27:00 | 1017.9 | 15:57:00 | 1021.8 | 08:57:00 | 0 | 00:27 | 0 | 16.6 | 145.8 | 15.8 | 15:57:00 | 43 | 14:27:00 | 98 | 07:58:00 | 0 | 4.5 | 23.1 | 14:27 | 20.7 | 14:27 | 9.6 | 00:27:00 | 0 | 00:27 | 10.9 | 00:27:00 | 13.6 | 23:27:00 | 8 | 00:27:00 | 58 | 4 | 0.7 | 1108 | 13:27 | 9 | 12:57
2020-04-02 00:00:00 | 36.7 | 180 | 14:27 | 10.1 | 06:57:00 | 21 | 13:57:00 | 1018.9 | 14:27:00 | 1022.9 | 21:57:00 | 0 | 00:27 | 0 | 14.2 | 241 | 30.6 | 14:27:00 | 43 | 14:27:00 | 99 | 02:27:00 | 0 | 7 | 21 | 13:57 | 16.9 | 12:27 | 7.8 | 22:27:00 | 0 | 00:27 | 8.9 | 22:27:00 | 13.5 | 00:27:00 | 7.1 | 15:27:00 | 185 | 4.3 | 0.2 | 905 | 14:27 | 9 | 12:27
2020-04-03 00:00:00 | 22 | 135 | 12:57 | 9.8 | 00:27:00 | 21 | 11:57:00 | 1021.7 | 12:57:00 | 1026.6 | 22:27:00 | 0 | 00:27 | 0 | 14.4 | 222.5 | 17.3 | 12:57:00 | 43 | 11:27:00 | 90 | 21:57:00 | 0 | 5.5 | 21 | 11:57 | 18.2 | 12:27 | 7.3 | 00:27:00 | 0 | 00:27 | 8.4 | 00:27:00 | 10.6 | 22:57:00 | 6.6 | 09:57:00 | 190 | 4.1 | 0.2 | 1211 | 12:27 | 10 | 12:27
2020-04-04 00:00:00 | 20.9 | 90 | 12:28 | 11.3 | 23:28:00 | 17.9 | 11:28:00 | 1026.3 | 00:27:00 | 1030.8 | 22:58:00 | 5.4 | 15:28 | 3.9 | 13.2 | 147.5 | 18.4 | 12:28:00 | 57 | 11:28:00 | 98 | 03:27:00 | 0 | 2 | 17.9 | 11:28 | 16.3 | 11:28 | 10.3 | 23:58:00 | 2.7 | 15:28 | 11.1 | 23:58:00 | 11.6 | 14:58:00 | 9.3 | 11:28:00 | 159 | 5.1 | 0 | 575 | 09:28 | 4 | 09:28
2020-04-05 00:00:00 | 19.4 | 90 | 15:29 | 8.6 | 22:59:00 | 18.8 | 13:58:00 | 1028.3 | 15:59:00 | 1031.7 | 07:54:00 | 0 | 00:28 | 0 | 13.2 | 125.4 | 17.3 | 15:29:00 | 41 | 14:54:00 | 93 | 00:28:00 | 0 | 5.5 | 18.8 | 13:58 | 16.5 | 13:58 | 7.6 | 22:59:00 | 0 | 00:28 | 8.6 | 22:59:00 | 10.3 | 00:28:00 | 4.6 | 14:54:00 | 30 | 5.3 | 0 | 711 | 14:59 | 5 | 09:28
2020-04-06 00:00:00 | 17.3 | 22 | 10:59 | 9.5 | 23:59:00 | 19.2 | 14:29:00 | 1022.3 | 16:59:00 | 1030.1 | 00:29:00 | 0 | 00:29 | 0 | 13.5 | 84.4 | 13.3 | 15:29:00 | 41 | 14:59:00 | 86 | 21:59:00 | 0 | 6 | 19.2 | 14:29 | 17.1 | 14:29 | 8.1 | 23:59:00 | 0 | 00:29 | 9.5 | 23:59:00 | 8.8 | 18:59:00 | 5 | 10:59:00 | 51 | 4.8 | 0.1 | 1269 | 12:29 | 10 | 12:29
2020-04-07 00:00:00 | 22 | 90 | 14:59 | 8.5 | 04:29:00 | 21.2 | 13:59:00 | 1012.5 | 15:29:00 | 1022.5 | 00:29:00 | 0 | 00:29 | 0 | 13.3 | 145.4 | 19.4 | 14:59:00 | 44 | 13:59:00 | 89 | 00:29:00 | 0 | 9.5 | 21.2 | 13:59 | 19 | 13:59 | 6.5 | 05:29:00 | 0 | 00:29 | 7.7 | 05:29:00 | 9.7 | 08:59:00 | 5.9 | 04:29:00 | 53 | 5.4 | 0.3 | 978 | 11:29 | 8 | 11:29
2020-04-08 00:00:00 | 12.2 | 135 | 12:29 | 9.6 | 01:29:00 | 20.1 | 11:29:00 | 1010.3 | 23:59:00 | 1013.1 | 00:59:00 | 1.2 | 17:29 | 2.7 | 14.4 | 78.8 | 9.7 | 12:29:00 | 53 | 11:29:00 | 99 | 21:29:00 | 0 | 1 | 20.1 | 11:29 | 19.5 | 11:29 | 7.8 | 01:29:00 | 0.6 | 17:29 | 9.3 | 01:29:00 | 13.6 | 21:29:00 | 6.7 | 01:29:00 | 88 | 4.1 | 0.1 | 405 | 11:29 | 5 | 11:29
2020-04-09 00:00:00 | 31.7 | 225 | 13:59 | 7.6 | 23:59:00 | 17.6 | 09:59:00 | 1009.2 | 02:59:00 | 1016.7 | 22:59:00 | 1.8 | 13:59 | 3.9 | 11.7 | 288.9 | 27 | 11:29:00 | 59 | 09:59:00 | 99 | 00:29:00 | 0 | 3.5 | 17.6 | 09:59 | 16.5 | 09:59 | 4.6 | 21:29:00 | 0.9 | 13:59 | 6.4 | 23:59:00 | 13.5 | 00:29:00 | 2.7 | 23:59:00 | 223 | 6.6 | 0 | 854 | 13:29 | 8 | 13:29
2020-04-10 00:00:00 | 37.8 | 225 | 12:29 | 6.9 | 02:29:00 | 16.9 | 12:29:00 | 1016.3 | 14:59:00 | 1019.6 | 21:29:00 | 0 | 00:29 | 0 | 12 | 336.6 | 35.6 | 12:29:00 | 52 | 13:29:00 | 85 | 23:29:00 | 0 | 5.5 | 16.9 | 12:29 | 13.1 | 15:59 | 3.9 | 02:29:00 | 0 | 00:29 | 5.2 | 02:29:00 | 8.5 | 21:29:00 | 2.7 | 00:29:00 | 221 | 6.3 | 0 | 805 | 12:29 | 8 | 11:59
2020-04-11 00:00:00 | 15.8 | 315 | 03:29 | 7.1 | 04:59:00 | 20 | 13:59:00 | 1013.8 | 16:29:00 | 1019.8 | 01:29:00 | 0 | 00:29 | 0 | 12.7 | 198.7 | 13.3 | 10:29:00 | 52 | 11:29:00 | 96 | 22:29:00 | 0 | 11.5 | 20 | 13:59 | 18.3 | 13:59 | 4.1 | 05:59:00 | 0 | 00:29 | 5.1 | 02:59:00 | 10.4 | 13:59:00 | 4.4 | 06:59:00 | 351 | 5.9 | 0.2 | 805 | 12:29 | 8 | 12:29
2020-04-12 00:00:00 | 36.7 | 315 | 15:30 | 7 | 05:59:00 | 23.3 | 13:30:00 | 1001.9 | 23:30:00 | 1015.5 | 00:29:00 | 0 | 00:29 | 0 | 15.5 | 225.3 | 29.5 | 14:00:00 | 32 | 13:00:00 | 99 | 04:29:00 | 0 | 11 | 23.3 | 13:30 | 20.6 | 11:59 | 5.5 | 06:59:00 | 0 | 00:29 | 6.6 | 06:59:00 | 11.7 | 22:30:00 | 5.3 | 13:00:00 | 323 | 3.6 | 0.9 | 838 | 12:30 | 8 | 12:30
2020-04-13 00:00:00 | 69.8 | 270 | 20:30 | 11.4 | 22:00:00 | 21.2 | 12:00:00 | 996.6 | 14:00:00 | 1003 | 22:00:00 | 0.6 | 04:00 | 0.3 | 16.7 | 584.1 | 52.6 | 20:30:00 | 30 | 12:00:00 | 83 | 04:00:00 | 0 | 9 | 21.2 | 12:00 | 19.5 | 08:00 | 2 | 23:00:00 | 0.3 | 04:00 | 9.6 | 21:30:00 | 12.9 | 01:00:00 | 2.8 | 13:00:00 | 290 | 2.1 | 0.5 | 801 | 10:30 | 7 | 11:30
2020-04-14 00:00:00 | 58.7 | 315 | 03:00 | 7.8 | 23:30:00 | 14.2 | 15:00:00 | 1001.7 | 03:00:00 | 1011.8 | 20:00:00 | 1.8 | 05:30 | 3.9 | 10.9 | 534.6 | 47.9 | 03:00:00 | 34 | 15:30:00 | 80 | 05:30:00 | 0 | 8.5 | 14.2 | 15:00 | 8.6 | 15:00 | 1.3 | 08:30:00 | 0.9 | 05:30 | 5.4 | 08:00:00 | 6.2 | 00:00:00 | -1.5 | 15:30:00 | 275 | 7.4 | 0 | 880 | 12:00 | 8 | 12:00
2020-04-15 00:00:00 | 31.7 | 270 | 13:00 | 3.9 | 06:00:00 | 16.8 | 14:30:00 | 1008.7 | 14:30:00 | 1013.3 | 07:00:00 | 0.6 | 00:00 | 1.2 | 10.6 | 183.1 | 27 | 12:30:00 | 37 | 14:00:00 | 95 | 02:30:00 | 0 | 7.7 | 16.8 | 14:30 | 14 | 10:30 | 1.7 | 06:00:00 | 0.3 | 00:00 | 3.9 | 06:00:00 | 6.5 | 23:49:00 | 1.4 | 14:00:00 | 259 | 7.9 | 0 | 761 | 12:00 | 7 | 11:30
2020-04-16 00:00:00 | 50 | 315 | 11:49 | 9.6 | 06:49:00 | 18.7 | 08:19:00 | 1004.1 | 16:19:00 | 1009.5 | 00:19:00 | 0 | 00:19 | 0 | 14.3 | 319.3 | 36.7 | 11:19:00 | 41 | 10:19:00 | 74 | 06:49:00 | 0 | 7.5 | 18.7 | 08:19 | 17.3 | 08:19 | 6 | 19:49:00 | 0 | 00:19 | 9.2 | 00:49:00 | 9.2 | 14:49:00 | 3.4 | 19:49:00 | 281 | 4 | 0 | 745 | 12:19 | 7 | 11:19
2020-04-17 00:00:00 | 42.8 | 270 | 00:19 | 14 | 00:19:00 | 21.3 | 15:19:00 | 999.7 | 20:49:00 | 1004.9 | 00:49:00 | 0.6 | 12:49 | 0.9 | 17.1 | 316.1 | 35.6 | 00:19:00 | 51 | 15:19:00 | 78 | 19:49:00 | 0 | 5 | 21.3 | 15:19 | 18.3 | 11:49 | 6.5 | 00:19:00 | 0.3 | 12:49 | 11.9 | 00:19:00 | 13 | 12:49:00 | 4.8 | 00:19:00 | 288 | 1.5 | 0.3 | 903 | 12:49 | 6 | 12:49
2020-04-18 00:00:00 | 60.1 | 270 | 22:49 | 14.5 | 23:19:00 | 22.7 | 14:20:00 | 998.5 | 04:19:00 | 1006.6 | 22:49:00 | 0 | 00:19 | 0 | 18.6 | 572.4 | 46.4 | 23:19:00 | 33 | 14:20:00 | 65 | 00:19:00 | 0 | 11.6 | 22.7 | 14:20 | 20.7 | 09:19 | 4 | 23:19:00 | 0 | 00:19 | 11.7 | 23:19:00 | 11.4 | 00:19:00 | 2.3 | 22:19:00 | 282 | 0.9 | 1.2 | 808 | 13:50 | 7 | 11:49
2020-04-19 00:00:00 | 58.7 | 270 | 12:49 | 14.2 | 01:49:00 | 22.1 | 08:19:00 | 1006.5 | 00:19:00 | 1015.6 | 23:20:00 | 0 | 00:19 | 0 | 17.5 | 549.5 | 51.5 | 12:49:00 | 40 | 09:49:00 | 58 | 05:49:00 | 0 | 10.1 | 22.1 | 08:19 | 20.6 | 08:19 | 7.1 | 00:49:00 | 0 | 00:19 | 12.8 | 00:19:00 | 9 | 14:50:00 | 2.7 | 00:19:00 | 279 | 1.6 | 0.8 | 720 | 13:03 | 7 | 13:03
2020-04-20 00:00:00 | 35.6 | 315 | 18:51 | 13.2 | 07:20:00 | 18.7 | 12:50:00 | 1015.3 | 00:20:00 | 1019 | 22:51:00 | 0 | 00:20 | 0 | 16 | 361.9 | 28.1 | 12:50:00 | 43 | 10:50:00 | 71 | 23:51:00 | 0 | 4 | 18.7 | 12:50 | 16.3 | 16:50 | 9.2 | 06:20:00 | 0 | 00:20 | 12.6 | 05:50:00 | 8.9 | 23:51:00 | 4.4 | 05:50:00 | 287 | 2.4 | 0 | 529 | 10:20 | 5 | 10:20
2020-04-21 00:00:00 | 15.8 | 112 | 13:51 | 9.1 | 22:21:00 | 19.1 | 13:51:00 | 1016.5 | 14:51:00 | 1020 | 22:51:00 | 0 | 00:21 | 0 | 13.8 | 145.5 | 14.8 | 13:51:00 | 47 | 13:51:00 | 89 | 21:21:00 | 0 | 5.5 | 19.1 | 13:51 | 17.7 | 11:51 | 7.5 | 22:21:00 | 0 | 00:21 | 8.7 | 22:21:00 | 9.7 | 20:21:00 | 6.3 | 04:51:00 | 185 | 4.7 | 0 | 550 | 13:21 | 5 | 12:51
2020-04-22 00:00:00 | 18.4 | 135 | 14:21 | 6.5 | 05:51:00 | 22.9 | 13:51:00 | 1017.2 | 14:21:00 | 1021 | 21:51:00 | 0 | 00:21 | 0 | 13.1 | 159.3 | 15.8 | 14:21:00 | 31 | 13:21:00 | 99 | 06:51:00 | 0 | 11 | 22.9 | 13:51 | 19.7 | 13:51 | 4.5 | 03:51:00 | 0 | 00:21 | 5.3 | 06:21:00 | 11.6 | 20:51:00 | 4.6 | 12:21:00 | 330 | 5.8 | 0.6 | 740 | 12:21 | 6 | 11:21
2020-04-23 00:00:00 | 22 | 315 | 14:21 | 7.2 | 05:51:00 | 20.5 | 13:21:00 | 1014.4 | 15:51:00 | 1020.9 | 00:51:00 | 0 | 00:21 | 0 | 13.8 | 139.3 | 18.4 | 14:21:00 | 30 | 13:21:00 | 92 | 00:21:00 | 0 | 4.5 | 20.5 | 13:21 | 17.5 | 12:21 | 4.9 | 07:21:00 | 0 | 00:21 | 6.6 | 05:51:00 | 7.8 | 21:21:00 | 2.3 | 13:21:00 | 305 | 4.8 | 0.3 | 405 | 12:21 | 4 | 10:21
2020-04-24 00:00:00 | 20.9 | 315 | 12:51 | 8.2 | 23:22:00 | 22.1 | 14:51:00 | 1012.5 | 14:51:00 | 1017.2 | 22:52:00 | 0 | 00:21 | 0 | 15.2 | 211.9 | 17.3 | 12:51:00 | 40 | 15:21:00 | 88 | 20:21:00 | 0 | 8.5 | 22.1 | 14:51 | 19.3 | 14:51 | 5.9 | 23:22:00 | 0 | 00:21 | 7.7 | 23:22:00 | 9.5 | 17:51:00 | 3.8 | 23:22:00 | 286 | 3.8 | 0.7 | 718 | 12:21 | 6 | 11:21
2020-04-25 00:00:00 | 31.7 | 270 | 15:22 | 7.2 | 04:52:00 | 20.1 | 13:52:00 | 1013.1 | 13:52:00 | 1018.8 | 23:52:00 | 0 | 00:22 | 0 | 13.3 | 271.8 | 29.5 | 15:22:00 | 30 | 13:22:00 | 86 | 04:52:00 | 0 | 9.5 | 20.1 | 13:52 | 14.8 | 12:52 | 4.4 | 04:22:00 | 0 | 00:22 | 5.9 | 04:22:00 | 7.2 | 18:52:00 | 1.8 | 13:22:00 | 279 | 5.2 | 0.2 | 713 | 12:52 | 6 | 12:22
2020-04-26 00:00:00 | 17.3 | 90 | 12:52 | 8.7 | 06:22:00 | 21.2 | 13:52:00 | 1018.8 | 00:22:00 | 1022.5 | 07:22:00 | 0 | 00:22 | 0 | 13.8 | 162.9 | 14.8 | 06:22:00 | 48 | 10:22:00 | 99 | 22:22:00 | 0 | 11 | 21.2 | 13:52 | 20.4 | 13:22 | 4.8 | 06:22:00 | 0 | 00:22 | 6.3 | 06:22:00 | 11.5 | 16:52:00 | 5.2 | 05:22:00 | 352 | 5 | 0.4 | 709 | 12:22 | 6 | 11:52
2020-04-27 00:00:00 | 31.7 | 292 | 22:52 | 6.7 | 02:22:00 | 23.3 | 11:52:00 | 1015.9 | 15:22:00 | 1021.5 | 00:22:00 | 0 | 00:22 | 0 | 15.2 | 248.9 | 25.6 | 23:52:00 | 23 | 10:52:00 | 99 | 00:22:00 | 0 | 7.5 | 23.3 | 11:52 | 20.9 | 12:52 | 5 | 06:52:00 | 0 | 00:22 | 6.1 | 05:22:00 | 9.5 | 00:22:00 | -0.6 | 10:52:00 | 298 | 3.9 | 0.8 | 804 | 12:52 | 6 | 12:22
2020-04-28 00:00:00 | 70.9 | 270 | 05:22 | 7.8 | 22:52:00 | 24.7 | 13:02:00 | 1016.7 | 00:52:00 | 1033.6 | 23:53:00 | 0 | 00:22 | 0 | 17 | 476.3 | 57.6 | 05:22:00 | 20 | 13:03:00 | 79 | 23:53:00 | 0 | 10.6 | 24.7 | 13:02 | 21 | 13:02 | 5.3 | 22:52:00 | 0 | 00:22 | 6.9 | 22:52:00 | 10.6 | 01:52:00 | -0.8 | 12:22:00 | 255 | 2.6 | 1.2 | 707 | 12:22 | 6 | 11:52
2020-04-29 00:00:00 | 18.4 | 45 | 14:53 | 5.9 | 03:23:00 | 20.4 | 13:53:00 | 1031.7 | 13:53:00 | 1035.5 | 07:23:00 | 0 | 00:23 | 0 | 11.5 | 201.4 | 15.8 | 14:53:00 | 34 | 11:53:00 | 90 | 23:23:00 | 0 | 11 | 20.4 | 13:53 | 17.7 | 13:53 | 3.3 | 03:23:00 | 0 | 00:23 | 4.7 | 03:23:00 | 7.9 | 16:23:00 | 2.9 | 11:53:00 | 331 | 6.9 | 0.2 | 688 | 12:23 | 6 | 12:23
2020-04-30 00:00:00 | 29.5 | 292 | 14:53 | 5.6 | 00:23:00 | 22.1 | 11:23:00 | 1027.1 | 16:53:00 | 1034.6 | 01:53:00 | 0 | 00:23 | 0 | 14.2 | 234 | 23.4 | 14:53:00 | 30 | 12:23:00 | 91 | 01:53:00 | 0 | 10.5 | 22.1 | 11:23 | 19.2 | 12:23 | 3.1 | 06:53:00 | 0 | 00:23 | 4.2 | 06:53:00 | 7 | 08:23:00 | 3.6 | 12:23:00 | 308 | 5 | 0.8 | 693 | 12:23 | 6 | 12:23