Spreadsheet: 41672d1240235846-copy-formulas-or-using-the-auto-fill-need-to-have-the-count-inc-by-5-instead-of-1-testdata
Sheet: sheet 2

Date | Statistic | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
2009-04-10 00:00:00 | [NAME] | 6.77607 | 6.51159 | 4.59061 | 5.78158 | 8.96197 | 9.9079 | 5.95885 | 9.19443 | 13.2446 | 17.525 | 19.2699 | 17.5924 | 17.5695 | 16.1755 | 14.9496 | 12.0336 | 8.05134 | 6.21167 | 6.75756 | 22.8776 | 19.6713 | 15.5998 | 25.8978 | 8.60512
2009-04-10 00:00:00 | data 2 | 16.5553 | 11.2157 | 6.31126 | 9.51813 | 11.1834 | 16.3261 | 7.70007 | 10.1289 | 15.9595 | 22.1295 | 23.2268 | 22.5014 | 30.1759 | 19.472 | 19.6988 | 16.1336 | 12.6002 | 9.39577 | 13 | 84.5022 | 69.8155 | 46.0379 | 50.9509 | 15.5287
2009-04-10 00:00:00 | data 3 | 4.90946 | 2.30047 | 1.89841 | 2.15217 | 2.15695 | 2.03861 | 5.91418 | 20.2685 | 47.6802 | 66.9196 | 88.306 | 90.768 | 92.9118 | 84.3829 | 74.8325 | 44.0457 | 27.4094 | 18.9333 | 12.98 | 4.93966 | 4.09113 | 5.21225 | 3.98125 | 3.12298
2009-04-10 00:00:00 | data4 | 8.2142 | 3.05274 | 2.35964 | 2.80206 | 2.41413 | 2.87703 | 12.0016 | 31.7985 | 54.5388 | 82.9668 | 95.4239 | 98.2242 | 97.247 | 90.0264 | 92.5154 | 57.7575 | 32.2912 | 29.6944 | 22.7459 | 9.84687 | 6.15226 | 8.92903 | 4.95553 | 3.65522
2009-04-10 00:00:00 | data 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-11 00:00:00 | data 1 | 4.51732 | 5.55619 | 4.13227 | 8.99514 | 7.43075 | 3.76068 | 3.83036 | 4.22857 | 8.81738 | 7.71768 | 9.03539 | 6.94666 | 7.63366 | 7.86303 | 11.2306 | 7.14026 | 5.82238 | 8.54836 | 7.71983 | 46.9835 | 33.1095 | 16.0493 | 22.0182 | 9.84617
2009-04-11 00:00:00 | data 2 | 8.84274 | 10.2906 | 6.75784 | 13.3223 | 13.4799 | 5.37953 | 6.87291 | 6.44851 | 20.9095 | 11.0172 | 26.0242 | 11.1876 | 9.42887 | 10.8148 | 30.5279 | 13.278 | 7.32523 | 27.1566 | 11.0633 | 99.9434 | 99.5293 | 58.3772 | 67.6054 | 14.8118
2009-04-11 00:00:00 | data 3 | 1.42839 | 1.4922 | 1.19988 | 1.48318 | 1.5081 | 0.987452 | 1.06353 | 2.54054 | 2.09319 | 4.40765 | 5.02781 | 5.33496 | 4.83541 | 4.47151 | 4.73844 | 2.14739 | 1.6998 | 1.89592 | 2.85309 | 2.88538 | 2.2111 | 1.26531 | 1.46311 | 1.02302
2009-04-11 00:00:00 | data 4 | 2.43761 | 1.71864 | 1.32973 | 1.99187 | 3.4127 | 1.53624 | 1.68434 | 9.28913 | 3.44757 | 5.3383 | 8.1822 | 9.95774 | 5.73769 | 6.7609 | 9.30088 | 3.81377 | 4.17071 | 4.22759 | 6.11487 | 5.69544 | 4.59443 | 2.93141 | 2.94475 | 1.28724
2009-04-11 00:00:00 | data 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-12 00:00:00 | data 1 | 5.65403 | 6.55115 | 5.46587 | 12.7422 | 5.33816 | 4.74441 | 3.70078 | 4.61408 | 4.53962 | 3.86814 | 3.97569 | 5.35561 | 11.3664 | 8.09347 | 4.6735 | 5.42219 | 7.23365 | 6.56112 | 7.01562 | 12.0721 | 12.3705 | 16.9737 | 11.376 | 7.60322
2009-04-12 00:00:00 | data 2 | 16.3772 | 10.3104 | 7.56663 | 17.9575 | 9.62956 | 7.42283 | 4.88734 | 6.58155 | 5.75806 | 7.66394 | 4.97045 | 8.78032 | 18.6946 | 18.3184 | 6.92035 | 6.19342 | 9.38387 | 12.4352 | 8.46607 | 49.5752 | 35.0115 | 35.7467 | 35.0864 | 13.52
2009-04-12 00:00:00 | data 3 | 0.754424 | 0.825202 | 0.749501 | 1.05704 | 1.15737 | 1.08682 | 0.69891 | 0.732696 | 0.926068 | 2.26214 | 2.08545 | 2.44514 | 2.41817 | 2.33207 | 3.13765 | 1.8644 | 2.18785 | 1.7886 | 1.32219 | 1.87905 | 1.61366 | 1.62898 | 1.95091 | 0.886717
2009-04-12 00:00:00 | data 4 | 1.10409 | 0.930001 | 0.848345 | 1.25631 | 2.60401 | 1.59113 | 0.871715 | 0.844793 | 1.39383 | 3.21017 | 2.23761 | 3.09304 | 3.37244 | 2.77071 | 5.32153 | 3.03549 | 2.4779 | 4.78727 | 2.35591 | 4.65789 | 2.99629 | 2.19087 | 5.96603 | 1.07595
2009-04-12 00:00:00 | data 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-13 00:00:00 | data 1 | 7.90895 | 7.66875 | 6.6348 | 14.1723 | 7.29114 | 5.89457 | 7.42087 | 9.47394 | 17.1084 | 20.2032 | 21.996 | 19.3186 | 19.5458 | 18.4392 | 18.5651 | 19.778 | 17.532 | 13.0678 | 9.43597 | 57.979 | 41.9265 | 29.5678 | 38.1125 | 20.9994
2009-04-13 00:00:00 | data 2 | 10.0621 | 9.35279 | 8.77075 | 18.6034 | 13.7507 | 7.73486 | 9.8282 | 12.8267 | 35.9722 | 27.4256 | 34.7889 | 23.3453 | 23.8609 | 23.4862 | 21.3074 | 22.6342 | 25.8157 | 17.9467 | 16.6924 | 99.7389 | 99.6821 | 76.4904 | 73.8608 | 31.2437
2009-04-13 00:00:00 | data 3 | 1.01052 | 0.928764 | 0.952749 | 1.12235 | 0.920963 | 1.43548 | 7.60127 | 22.881 | 55.8148 | 78.2813 | 83.5303 | 87.2943 | 97.2886 | 96.5423 | 98.4991 | 91.0064 | 77.2929 | 49.2475 | 26.7769 | 16.1568 | 7.21288 | 5.55247 | 3.92029 | 3.03922
2009-04-13 00:00:00 | data 4 | 1.52693 | 1.09877 | 1.14559 | 1.28187 | 1.16866 | 2.22186 | 14.1936 | 41.4305 | 71.2965 | 89.5619 | 90.1084 | 98.0534 | 99.8946 | 100 | 99.9327 | 99.2021 | 91.6818 | 55.7946 | 38.6543 | 45.8463 | 10.0486 | 9.31193 | 6.40731 | 3.94056
2009-04-13 00:00:00 | data 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0