Spreadsheet: 595076d1540233056-converting-half-hourly-data-to-hourly-data-sample-data
Sheet: Sheet1

TIMESTAMP | Radiation | Temperature |  |  |  | TIMESTAMP | Total Radiation | Average Temperature
2017-01-01 00:00:00 | 0.01618222 | 15.12476 |  |  |  | 2017-01-01 00:00:00
2017-01-01 00:30:00 | 0.01547009 | 15.13708 |  |  |  | 2017-01-01 01:00:00
2017-01-01 01:00:00 | 0.0159011 | 15.10651 |  |  |  | 2017-01-01 02:00:00
2017-01-01 01:30:00 | 0.01721303 | 15.08311 |  |  |  | 2017-01-01 03:00:00
2017-01-01 02:00:00 | 0.01742856 | 15.05615 |  |  |  | 2017-01-01 04:00:00
2017-01-01 02:30:00 | 0.01839368 | 15.05562 |  |  |  | 2017-01-01 05:00:00
2017-01-01 03:00:00 | 0.01963997 | 15.05596 |  |  |  | 2017-01-01 06:00:00
2017-01-01 03:30:00 | 0.02257742 | 15.08586 |  |  |  | 2017-01-01 07:00:00
2017-01-01 04:00:00 | 0.02577279 | 15.2297 |  |  |  | 2017-01-01 08:00:00
2017-01-01 04:30:00 | 0.03872677 | 15.34851 |  |  |  | 2017-01-01 09:00:00
2017-01-01 05:00:00 | 1.64669 | 15.44912 |  |  |  | 2017-01-01 10:00:00
2017-01-01 05:30:00 | 6.466292 | 15.51123 |  |  |  | 2017-01-01 11:00:00
2017-01-01 06:00:00 | 27.32836 | 15.66463 |  |  |  | 2017-01-01 12:00:00
2017-01-01 06:30:00 | 50.62226 | 15.97348 |  |  |  | 2017-01-01 13:00:00
2017-01-01 07:00:00 | 111.7593 | 16.55498 |  |  |  | 2017-01-01 14:00:00
2017-01-01 07:30:00 | 124.4923 | 17.17188 |  |  |  | 2017-01-01 15:00:00
2017-01-01 08:00:00 | 179.8985 | 17.79957 |  |  |  | 2017-01-01 16:00:00
2017-01-01 08:30:00 | 194.1421 | 18.67556 |  |  |  | 2017-01-01 17:00:00
2017-01-01 09:00:00 | 344.4934 | 19.77947 |  |  |  | 2017-01-01 18:00:00
2017-01-01 09:30:00 | 542.5287 | 21.99156 |  |  |  | 2017-01-01 19:00:00
2017-01-01 10:00:00 | 429.9761 | 22.85777 |  |  |  | 2017-01-01 20:00:00
2017-01-01 10:30:00 | 490.4171 | 24.11244 |  |  |  | 2017-01-01 21:00:00
2017-01-01 11:00:00 | 544.3955 | 24.86902 |  |  |  | 2017-01-01 22:00:00
2017-01-01 11:30:00 | 893.3516 | 25.96569 |  |  |  | 2017-01-01 23:00:00
2017-01-01 12:00:00 | 771.3709 | 25.99044 |  |  |  | 2017-01-02 00:00:00
2017-01-01 12:30:00 | 885.1194 | 27.00007 |  |  |  | 2017-01-02 01:00:00
2017-01-01 13:00:00 | 771.1644 | 27.093 |  |  |  | 2017-01-02 02:00:00
2017-01-01 13:30:00 | 389.8614 | 26.31731 |  |  |  | 2017-01-02 03:00:00
2017-01-01 14:00:00 | 532.9695 | 27.23928 |  |  |  | 2017-01-02 04:00:00
2017-01-01 14:30:00 | 347.2255 | 26.96586 |  |  |  | 2017-01-02 05:00:00
2017-01-01 15:00:00 | 492.7291 | 27.55861 |  |  |  | 2017-01-02 06:00:00
2017-01-01 15:30:00 | 212.0977 | 27.27824 |  |  |  | 2017-01-02 07:00:00
2017-01-01 16:00:00 | 395.0252 | 27.42845 |  |  |  | 2017-01-02 08:00:00
2017-01-01 16:30:00 | 225.1719 | 27.30119 |  |  |  | 2017-01-02 09:00:00
2017-01-01 17:00:00 | 131.9033 | 26.53191 |  |  |  | 2017-01-02 10:00:00
2017-01-01 17:30:00 | 94.26632 | 24.72894 |  |  |  | 2017-01-02 11:00:00
2017-01-01 18:00:00 | 22.66452 | 23.40685 |  |  |  | 2017-01-02 12:00:00
2017-01-01 18:30:00 | 7.093686 | 22.34272 |  |  |  | 2017-01-02 13:00:00
2017-01-01 19:00:00 | 0.5393091 | 21.50525 |  |  |  | 2017-01-02 14:00:00
2017-01-01 19:30:00 | 0.006133841 | 21.09677 |  |  |  | 2017-01-02 15:00:00
2017-01-01 20:00:00 | 0.006368365 | 20.6194 |  |  |  | 2017-01-02 16:00:00
2017-01-01 20:30:00 | 0.006452924 | 20.45465 |  |  |  | 2017-01-02 17:00:00
2017-01-01 21:00:00 | 0.006757516 | 20.22087 |  |  |  | 2017-01-02 18:00:00
2017-01-01 21:30:00 | 0.007385127 | 20.10865 |  |  |  | 2017-01-02 19:00:00
2017-01-01 22:00:00 | 0.009576863 | 20.01234 |  |  |  | 2017-01-02 20:00:00
2017-01-01 22:30:00 | 0.01052298 | 19.91034 |  |  |  | 2017-01-02 21:00:00
2017-01-01 23:00:00 | 0.01150184 | 19.9241 |  |  |  | 2017-01-02 22:00:00
2017-01-01 23:30:00 | 0.0149627 | 19.80059 |  |  |  | 2017-01-02 23:00:00
2017-01-02 00:00:00 | 0.01673765 | 19.68089 |  |  |  | 2017-01-03 00:00:00
2017-01-02 00:30:00 | 0.01879842 | 19.55551 |  |  |  | 2017-01-03 01:00:00
2017-01-02 01:00:00 | 0.01752474 | 19.47492 |  |  |  | 2017-01-03 02:00:00
2017-01-02 01:30:00 | 0.01955279 | 19.42702 |  |  |  | 2017-01-03 03:00:00
2017-01-02 02:00:00 | 0.02024601 | 19.32047 |  |  |  | 2017-01-03 04:00:00
2017-01-02 02:30:00 | 0.0218197 | 19.2835 |  |  |  | 2017-01-03 05:00:00
2017-01-02 03:00:00 | 0.02123913 | 19.33747 |  |  |  | 2017-01-03 06:00:00
2017-01-02 03:30:00 | 0.02039616 | 19.44822 |  |  |  | 2017-01-03 07:00:00
2017-01-02 04:00:00 | 0.02065383 | 19.40515 |  |  |  | 2017-01-03 08:00:00
2017-01-02 04:30:00 | 0.03020323 | 19.14393 |  |  |  | 2017-01-03 09:00:00
2017-01-02 05:00:00 | 1.318127 | 18.99326 |  |  |  | 2017-01-03 10:00:00
2017-01-02 05:30:00 | 6.642279 | 18.79366 |  |  |  | 2017-01-03 11:00:00
2017-01-02 06:00:00 | 21.80637 | 18.946 |  |  |  | 2017-01-03 12:00:00
2017-01-02 06:30:00 | 35.19458 | 19.0273 |  |  |  | 2017-01-03 13:00:00
2017-01-02 07:00:00 | 41.143 | 19.20551 |  |  |  | 2017-01-03 14:00:00
2017-01-02 07:30:00 | 61.9223 | 19.4549 |  |  |  | 2017-01-03 15:00:00
2017-01-02 08:00:00 | 92.76604 | 19.95637 |  |  |  | 2017-01-03 16:00:00
2017-01-02 08:30:00 | 108.2863 | 20.20805 |  |  |  | 2017-01-03 17:00:00
2017-01-02 09:00:00 | 175.4092 | 20.02255 |  |  |  | 2017-01-03 18:00:00
2017-01-02 09:30:00 | 282.0301 | 20.42009 |  |  |  | 2017-01-03 19:00:00
2017-01-02 10:00:00 | 252.3879 | 20.78287 |  |  |  | 2017-01-03 20:00:00
2017-01-02 10:30:00 | 236.4116 | 21.32411 |  |  |  | 2017-01-03 21:00:00
2017-01-02 11:00:00 | 307.2288 | 21.74416 |  |  |  | 2017-01-03 22:00:00
2017-01-02 11:30:00 | 461.869 | 22.41706 |  |  |  | 2017-01-03 23:00:00
2017-01-02 12:00:00 | 484.8789 | 22.65778 |  |  |  | 2017-01-04 00:00:00
2017-01-02 12:30:00 | 265.4983 | 22.54148 |  |  |  | 2017-01-04 01:00:00
2017-01-02 13:00:00 | 96.68262 | 21.51993 |  |  |  | 2017-01-04 02:00:00
2017-01-02 13:30:00 | 48.22958 | 20.55451 |  |  |  | 2017-01-04 03:00:00
2017-01-02 14:00:00 | 36.35166 | 20.24614 |  |  |  | 2017-01-04 04:00:00
2017-01-02 14:30:00 | 41.47598 | 19.6441 |  |  |  | 2017-01-04 05:00:00
2017-01-02 15:00:00 | 11.95795 | 18.98112 |  |  |  | 2017-01-04 06:00:00
2017-01-02 15:30:00 | 7.460404 | 18.64552 |  |  |  | 2017-01-04 07:00:00
2017-01-02 16:00:00 | 17.20143 | 18.34666 |  |  |  | 2017-01-04 08:00:00
2017-01-02 16:30:00 | 24.37172 | 18.06702 |  |  |  | 2017-01-04 09:00:00
2017-01-02 17:00:00 | 13.27099 | 17.49753 |  |  |  | 2017-01-04 10:00:00
2017-01-02 17:30:00 | 13.36531 | 17.552 |  |  |  | 2017-01-04 11:00:00
2017-01-02 18:00:00 | 5.790583 | 17.32024 |  |  |  | 2017-01-04 12:00:00
2017-01-02 18:30:00 | 2.297993 | 17.38797 |  |  |  | 2017-01-04 13:00:00
2017-01-02 19:00:00 | 0.1859287 | 17.49432 |  |  |  | 2017-01-04 14:00:00
2017-01-02 19:30:00 | 0.01042225 | 17.57681 |  |  |  | 2017-01-04 15:00:00
2017-01-02 20:00:00 | 0.01136379 | 17.38984 |  |  |  | 2017-01-04 16:00:00
2017-01-02 20:30:00 | 0.01646942 | 17.45616 |  |  |  | 2017-01-04 17:00:00
2017-01-02 21:00:00 | 0.0167878 | 17.45332 |  |  |  | 2017-01-04 18:00:00
2017-01-02 21:30:00 | 0.01677839 | 17.35377 |  |  |  | 2017-01-04 19:00:00
2017-01-02 22:00:00 | 0.01623968 | 17.27839 |  |  |  | 2017-01-04 20:00:00
2017-01-02 22:30:00 | 0.01531251 | 16.7822 |  |  |  | 2017-01-04 21:00:00
2017-01-02 23:00:00 | 0.01352801 | 16.53137 |  |  |  | 2017-01-04 22:00:00
2017-01-02 23:30:00 | 0.01325689 | 16.40187 |  |  |  | 2017-01-04 23:00:00
2017-01-03 00:00:00 | 0.01176284 | 16.41772 |  |  |  | 2017-01-05 00:00:00
2017-01-03 00:30:00 | 0.01047468 | 16.52082 |  |  |  | 2017-01-05 01:00:00
2017-01-03 01:00:00 | 0.009926558 | 16.66214 |  |  |  | 2017-01-05 02:00:00
2017-01-03 01:30:00 | 0.01165517 | 16.58475 |  |  |  | 2017-01-05 03:00:00
2017-01-03 02:00:00 | 0.0123906 | 16.54108 |  |  |  | 2017-01-05 04:00:00
2017-01-03 02:30:00 | 0.01005305 | 16.49457 |  |  |  | 2017-01-05 05:00:00
2017-01-03 03:00:00 | 0.00983288 | 16.45939 |  |  |  | 2017-01-05 06:00:00
2017-01-03 03:30:00 | 0.01044661 | 16.47232 |  |  |  | 2017-01-05 07:00:00
2017-01-03 04:00:00 | 0.01198312 | 16.47661 |  |  |  | 2017-01-05 08:00:00
2017-01-03 04:30:00 | 0.02414423 | 16.44718 |  |  |  | 2017-01-05 09:00:00
2017-01-03 05:00:00 | 2.121157 | 16.40598 |  |  |  | 2017-01-05 10:00:00
2017-01-03 05:30:00 | 9.922095 | 16.3849 |  |  |  | 2017-01-05 11:00:00
2017-01-03 06:00:00 | 25.98841 | 16.43404 |  |  |  | 2017-01-05 12:00:00
2017-01-03 06:30:00 | 34.9985 | 16.5495 |  |  |  | 2017-01-05 13:00:00
2017-01-03 07:00:00 | 53.9234 | 16.21015 |  |  |  | 2017-01-05 14:00:00
2017-01-03 07:30:00 | 97.32349 | 16.17418 |  |  |  | 2017-01-05 15:00:00
2017-01-03 08:00:00 | 119.1799 | 16.41822 |  |  |  | 2017-01-05 16:00:00
2017-01-03 08:30:00 | 107.1243 | 16.43719 |  |  |  | 2017-01-05 17:00:00
2017-01-03 09:00:00 | 109.4885 | 16.23937 |  |  |  | 2017-01-05 18:00:00
2017-01-03 09:30:00 | 116.0868 | 16.41079 |  |  |  | 2017-01-05 19:00:00
2017-01-03 10:00:00 | 126.2222 | 16.44674 |  |  |  | 2017-01-05 20:00:00
2017-01-03 10:30:00 | 184.2818 | 16.69023 |  |  |  | 2017-01-05 21:00:00
2017-01-03 11:00:00 | 100.9703 | 16.71859 |  |  |  | 2017-01-05 22:00:00
2017-01-03 11:30:00 | 110.5751 | 15.89108 |  |  |  | 2017-01-05 23:00:00
2017-01-03 12:00:00 | 131.3029 | 15.76377
2017-01-03 12:30:00 | 176.0619 | 16.49469
2017-01-03 13:00:00 | 261.9468 | 17.57124
2017-01-03 13:30:00 | 252.9539 | 17.82346
2017-01-03 14:00:00 | 218.5148 | 18.39132
2017-01-03 14:30:00 | 111.1292 | 17.75451
2017-01-03 15:00:00 | 238.7971 | 16.85804
2017-01-03 15:30:00 | 201.0447 | 17.82572
2017-01-03 16:00:00 | 85.43775 | 17.51769
2017-01-03 16:30:00 | 71.98696 | 16.74134
2017-01-03 17:00:00 | 42.32699 | 16.79539
2017-01-03 17:30:00 | 16.31545 | 16.66341
2017-01-03 18:00:00 | 13.36906 | 16.38564
2017-01-03 18:30:00 | 5.959368 | 16.37774
2017-01-03 19:00:00 | 0.4405364 | 16.42684
2017-01-03 19:30:00 | 0.01653071 | 16.2728
2017-01-03 20:00:00 | 0.01342061 | 16.09569
2017-01-03 20:30:00 | 0.01338801 | 15.91732
2017-01-03 21:00:00 | 0.01335075 | 15.70214
2017-01-03 21:30:00 | 0.01337441 | 15.81062
2017-01-03 22:00:00 | 0.01345882 | 15.90046
2017-01-03 22:30:00 | 0.01338857 | 15.84919
2017-01-03 23:00:00 | 0.01209096 | 15.72004
2017-01-03 23:30:00 | 0.01140231 | 15.51593
2017-01-04 00:00:00 | 0.01125248 | 15.33547
2017-01-04 00:30:00 | 0.01150566 | 15.12019
2017-01-04 01:00:00 | 0.009955196 | 15.13652
2017-01-04 01:30:00 | 0.009796056 | 15.08765
2017-01-04 02:00:00 | 0.009566644 | 15.09552
2017-01-04 02:30:00 | 0.009791676 | 15.0785
2017-01-04 03:00:00 | 0.009215464 | 15.07694
2017-01-04 03:30:00 | 0.009070309 | 15.08867
2017-01-04 04:00:00 | 0.009548157 | 15.11609
2017-01-04 04:30:00 | 0.1447634 | 15.20018
2017-01-04 05:00:00 | 3.227052 | 15.22129
2017-01-04 05:30:00 | 18.16454 | 15.40251
2017-01-04 06:00:00 | 35.22026 | 15.60911
2017-01-04 06:30:00 | 68.78862 | 15.80032
2017-01-04 07:00:00 | 152.2748 | 16.33085
2017-01-04 07:30:00 | 245.4019 | 17.4683
2017-01-04 08:00:00 | 273.4754 | 17.70639
2017-01-04 08:30:00 | 298.9085 | 18.25355
2017-01-04 09:00:00 | 373.6349 | 18.81647
2017-01-04 09:30:00 | 357.8723 | 18.31446
2017-01-04 10:00:00 | 286.4222 | 18.43646
2017-01-04 10:30:00 | 305.6111 | 18.20887
2017-01-04 11:00:00 | 573.1078 | 19.04451
2017-01-04 11:30:00 | 306.1039 | 17.99369
2017-01-04 12:00:00 | 480.6194 | 19.13935
2017-01-04 12:30:00 | 655.1763 | 20.32308
2017-01-04 13:00:00 | 245.336 | 20.04245
2017-01-04 13:30:00 | 82.22802 | 18.60972
2017-01-04 14:00:00 | 104.4873 | 17.87162
2017-01-04 14:30:00 | 264.8994 | 17.99525
2017-01-04 15:00:00 | 229.632 | 18.37355
2017-01-04 15:30:00 | 256.0447 | 18.55346
2017-01-04 16:00:00 | 97.72826 | 18.03362
2017-01-04 16:30:00 | 51.3632 | 17.18003
2017-01-04 17:00:00 | 32.05391 | 16.78285
2017-01-04 17:30:00 | 27.19812 | 16.36744
2017-01-04 18:00:00 | 10.43348 | 16.16753
2017-01-04 18:30:00 | 4.599472 | 15.97781
2017-01-04 19:00:00 | 0.7609764 | 15.7683
2017-01-04 19:30:00 | 0.009611017 | 15.34182
2017-01-04 20:00:00 | 0.00727054 | 14.96203
2017-01-04 20:30:00 | 0.008587142 | 15.0021
2017-01-04 21:00:00 | 0.009796048 | 15.00009
2017-01-04 21:30:00 | 0.009486935 | 15.0692
2017-01-04 22:00:00 | 0.009304197 | 15.05678
2017-01-04 22:30:00 | 0.009678939 | 15.00643
2017-01-04 23:00:00 | 0.009978794 | 15.00091
2017-01-04 23:30:00 | 0.01015227 | 15.00741
2017-01-05 00:00:00 | 0.01018044 | 15.03227
2017-01-05 00:30:00 | 0.01158578 | 15.0712
2017-01-05 01:00:00 | 0.01018499 | 15.12755
2017-01-05 01:30:00 | 0.01030202 | 15.05127
2017-01-05 02:00:00 | 0.01059241 | 14.95985
2017-01-05 02:30:00 | 0.01087355 | 15.05761
2017-01-05 03:00:00 | 0.01041909 | 15.01275
2017-01-05 03:30:00 | 0.01024107 | 14.88815
2017-01-05 04:00:00 | 0.0103255 | 14.94461
2017-01-05 04:30:00 | 0.0763723 | 15.0173
2017-01-05 05:00:00 | 3.10085 | 15.04528
2017-01-05 05:30:00 | 19.96194 | 15.11678
2017-01-05 06:00:00 | 40.4756 | 15.3037
2017-01-05 06:30:00 | 69.56729 | 15.52145
2017-01-05 07:00:00 | 126.5078 | 15.9919
2017-01-05 07:30:00 | 240.5026 | 16.84902
2017-01-05 08:00:00 | 520.6397 | 18.70295
2017-01-05 08:30:00 | 636.0394 | 20.68991
2017-01-05 09:00:00 | 753.1747 | 21.61644
2017-01-05 09:30:00 | 825.4799 | 23.05873
2017-01-05 10:00:00 | 882.1094 | 24.30252
2017-01-05 10:30:00 | 927.124 | 25.58857
2017-01-05 11:00:00 | 956.6508 | 26.48086
2017-01-05 11:30:00 | 972.7141 | 27.19074
2017-01-05 12:00:00 | 975.9792 | 27.66423
2017-01-05 12:30:00 | 969.3047 | 27.91328
2017-01-05 13:00:00 | 949.0584 | 28.16986
2017-01-05 13:30:00 | 915.2791 | 28.63948
2017-01-05 14:00:00 | 864.1266 | 28.75834
2017-01-05 14:30:00 | 801.3049 | 28.74475
2017-01-05 15:00:00 | 724.1138 | 29.05335
2017-01-05 15:30:00 | 633.081 | 28.61078
2017-01-05 16:00:00 | 527.0938 | 28.39389
2017-01-05 16:30:00 | 435.9014 | 27.81477
2017-01-05 17:00:00 | 329.3626 | 27.19731
2017-01-05 17:30:00 | 227.5743 | 26.44016
2017-01-05 18:00:00 | 104.326 | 25.03874
2017-01-05 18:30:00 | 34.9039 | 23.64225
2017-01-05 19:00:00 | 1.296528 | 22.24624
2017-01-05 19:30:00 | 0.01369917 | 21.51993
2017-01-05 20:00:00 | 0.00856911 | 20.4345
2017-01-05 20:30:00 | 0.008897751 | 19.09775
2017-01-05 21:00:00 | 0.007624522 | 19.37899
2017-01-05 21:30:00 | 0.007414087 | 18.5585
2017-01-05 22:00:00 | 0.002665084 | 20.44855
2017-01-05 22:30:00 | 0.001620564 | 20.95992
2017-01-05 23:00:00 | 0.002547772 | 19.83202