Spreadsheet: 733586d1621632141-average-hours-using-drop-downs-2-d-average
Sheet: Sheet1

 |  | Start Month | End Month | Start Hour | End Hour | Average Price
 | Example | 2021-06-01 00:00:00 | 2021-12-01 00:00:00 | 18 | 22
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
2021-02-01 00:00:00 | 23.36994810000004 | 18.56102760000003 | 17.55506970000003 | 17.90042850000003 | 18.49476690000003 | 19.14131070000003 | 37.91002499999997 | 36.50594999999997 | 35.10187499999997 | 33.69779999999997 | 29.48557499999998 | 14.04074999999999 | 16.84889999999999 | 16.84889999999999 | 16.84889999999999 | 21.06112499999998 | 26.67742499999998 | 26.67742499999998 | 35.10187499999997 | 34.54024499999997 | 34.25942999999997 | 33.69779999999997 | 24.28755840000004 | 21.31988220000004
2021-03-01 00:00:00 | 20.4603555 | 19.25146875 | 17.1860235 | 17.35269375 | 18.82107975 | 20.50887975 | 23.6292 | 23.6292 | 25.10602499999999 | 25.10602499999999 | 25.10602499999999 | 29.53649999999999 | 29.53649999999999 | 29.53649999999999 | 29.53649999999999 | 32.49014999999999 | 36.92062499999999 | 36.92062499999999 | 36.92062499999999 | 32.49014999999999 | 29.53649999999999 | 26.58284999999999 | 32.17368750000001 | 23.02370175
2021-04-01 00:00:00 | 18.7674921 | 17.1486882 | 15.674715 | 15.1650576 | 15.9332103 | 19.0131543 | 23.45459999999997 | 25.25879999999996 | 27.06299999999996 | 28.86719999999996 | 28.86719999999996 | 28.86719999999996 | 32.47559999999995 | 39.69239999999994 | 45.10499999999993 | 46.90919999999993 | 54.12599999999992 | 55.93019999999992 | 45.10499999999993 | 37.88819999999995 | 28.86719999999996 | 28.86719999999996 | 24.4397223 | 20.5219602
2021-05-01 00:00:00 | 18.46324349999999 | 16.96529249999999 | 14.4336465 | 13.4253405 | 14.185197 | 15.574338 | 16.81874999999998 | 16.81874999999998 | 16.81874999999998 | 20.18249999999998 | 21.86437499999998 | 23.54624999999998 | 26.90999999999998 | 42.04687499999996 | 49.78349999999995 | 68.95687499999993 | 85.7756249999999 | 62.22937499999994 | 37.67399999999996 | 16.81874999999998 | 16.81874999999998 | 15.13687499999999 | 31.74531749999999 | 20.28943799999999
2021-06-01 00:00:00 | 19.27397759999999 | 18.39306239999999 | 17.6946624 | 17.2309248 | 17.245824 | 17.55870719999999 | 15.76637999999998 | 16.49969999999998 | 18.33299999999998 | 15.58304999999999 | 19.24964999999998 | 20.16629999999998 | 20.53295999999998 | 23.83289999999998 | 60.49889999999994 | 107.0647199999999 | 117.3311999999999 | 62.33219999999993 | 42.16589999999995 | 17.23301999999998 | 15.39971999999998 | 14.66639999999999 | 21.5367936 | 20.05804799999999
2021-07-01 00:00:00 | 20.3362054 | 19.5455071 | 18.7904794 | 17.954202 | 17.260607 | 17.7461235 | 11.50279999999992 | 11.50279999999992 | 11.50279999999992 | 13.22821999999991 | 13.22821999999991 | 14.3784999999999 | 12.65307999999991 | 33.35811999999977 | 92.02239999999937 | 184.0447999999987 | 210.5012399999985 | 157.0132199999989 | 69.01679999999952 | 28.7569999999998 | 28.7569999999998 | 28.7569999999998 | 25.0704867 | 21.8284255
2021-08-01 00:00:00 | 20.62662 | 19.82462999999999 | 19.05882 | 18.2106 | 17.50709999999999 | 17.99955 | 16.37999999999988 | 16.37999999999988 | 16.37999999999988 | 18.83699999999986 | 18.83699999999986 | 20.47499999999985 | 18.01799999999987 | 47.50199999999965 | 131.0399999999991 | 262.0799999999981 | 299.7539999999978 | 223.5869999999984 | 98.27999999999929 | 40.9499999999997 | 40.9499999999997 | 40.9499999999997 | 25.42850999999999 | 22.14014999999999
2021-09-01 00:00:00 | 19.83599718 | 18.90201525000001 | 18.48240018 | 17.71278360000001 | 18.09372447 | 18.74538474 | 19.93670000000001 | 25.91771000000001 | 27.91138000000001 | 19.73733300000001 | 22.92720500000001 | 23.92404000000001 | 22.32910400000001 | 25.91771000000001 | 65.79111000000003 | 90.91135200000004 | 127.5948800000001 | 67.78478000000003 | 45.85441000000002 | 18.74049800000001 | 16.74682800000001 | 15.94936000000001 | 22.13904579 | 20.78544879
2021-10-01 00:00:00 | 30.371689458 | 20.200436938 | 16.691972506 | 15.608960598 | 16.10105156 | 17.28495241 | 25.14826999999999 | 25.14826999999999 | 25.14826999999999 | 25.14826999999999 | 26.94457499999999 | 28.74087999999999 | 34.12979499999998 | 41.31501499999998 | 48.50023499999998 | 50.29653999999997 | 53.88914999999997 | 48.50023499999998 | 46.70392999999998 | 39.51870999999998 | 30.53718499999999 | 25.14826999999999 | 27.668277604 | 20.789298926
2021-11-01 00:00:00 | 19.80922960799998 | 18.81494395199998 | 17.76631474799999 | 17.94544718399998 | 19.26378140399998 | 21.18995827199998 | 25.3134 | 25.3134 | 26.8954875 | 26.8954875 | 26.8954875 | 31.64175 | 31.64175 | 31.64175 | 31.64175 | 34.805925 | 39.5521875 | 39.5521875 | 39.5521875 | 34.805925 | 31.64175 | 28.477575 | 24.30968047199998 | 21.91856435999998
2021-12-01 00:00:00 | 20.89049451499998 | 19.39697912499998 | 19.03088064499998 | 18.99551885999998 | 19.65491214499998 | 20.96745839999998 | 34.93901249999996 | 34.93901249999996 | 31.90083749999997 | 25.82448749999998 | 25.82448749999998 | 24.30539999999998 | 24.30539999999998 | 24.30539999999998 | 28.86266249999997 | 30.38174999999997 | 33.41992499999997 | 37.97718749999996 | 37.97718749999996 | 33.41992499999997 | 30.38174999999997 | 27.34357499999998 | 25.27327574999997 | 22.19888055999997
2022-01-01 00:00:00 | 27.78010950000002 | 26.67637830000002 | 26.84021340000002 | 27.51854820000002 | 28.41532980000002 | 31.24076670000002 | 64.40280000000008 | 62.10270000000008 | 59.80260000000008 | 48.30210000000007 | 48.30210000000007 | 23.00100000000003 | 27.60120000000003 | 27.60120000000003 | 27.60120000000003 | 34.50150000000004 | 43.70190000000005 | 43.70190000000005 | 57.50250000000008 | 56.58246000000007 | 56.12244000000007 | 55.20240000000007 | 33.07169580000002 | 28.40383260000002
2022-02-01 00:00:00 | 32.73421030100002 | 25.99837099600002 | 24.58932903700002 | 25.07307198500002 | 25.90555984900002 | 26.81117164700002 | 63.10757600000006 | 60.85373400000007 | 58.59989200000006 | 47.33068200000005 | 47.33068200000005 | 22.53842000000002 | 27.04610400000003 | 27.04610400000003 | 27.04610400000003 | 33.80763000000003 | 42.82299800000004 | 42.82299800000004 | 56.34605000000006 | 55.44451320000006 | 54.99374480000006 | 54.09220800000006 | 34.01950406400002 | 29.86268966200002
2022-03-01 00:00:00 | 19.550236992 | 18.395124 | 16.421553984 | 16.5808104 | 17.983879584 | 19.596602784 | 33.00132000000003 | 31.35125400000003 | 31.35125400000003 | 28.05112200000002 | 28.05112200000002 | 28.05112200000002 | 28.05112200000002 | 28.05112200000002 | 33.00132000000003 | 36.30145200000003 | 37.95151800000003 | 41.25165000000003 | 39.60158400000003 | 37.95151800000003 | 36.30145200000003 | 29.70118800000003 | 30.74253599999999 | 21.999560352
2022-04-01 00:00:00 | 17.540403384 | 16.027442928 | 14.6498436 | 14.173509504 | 14.891437512 | 17.770003272 | 25.54882400000001 | 25.54882400000001 | 24.04595200000001 | 22.54308000000001 | 22.54308000000001 | 22.54308000000001 | 25.54882400000001 | 28.55456800000001 | 33.06318400000002 | 33.06318400000002 | 33.06318400000002 | 46.58903200000002 | 39.07467200000002 | 36.06892800000001 | 36.06892800000001 | 27.05169600000001 | 22.841761992 | 19.180157808
2022-05-01 00:00:00 | 17.31604841999999 | 15.9111711 | 13.53682638 | 12.59117046 | 13.30381404 | 14.60664216 | 14.882175 | 14.882175 | 14.882175 | 17.85861 | 19.3468275 | 20.835045 | 23.81148 | 37.2054375 | 44.051238 | 61.01691749999999 | 75.89909249999998 | 55.06404749999999 | 33.336072 | 14.882175 | 14.882175 | 13.3939575 | 29.77285409999999 | 19.02877415999999
2022-06-01 00:00:00 | 18.07028540999999 | 17.24438483999999 | 16.58960108999999 | 16.15482467999999 | 16.16879339999999 | 16.46213651999999 | 14.14097999999998 | 14.79869999999998 | 16.44299999999998 | 13.97654999999999 | 17.26514999999998 | 18.08729999999998 | 18.41615999999998 | 21.37589999999998 | 54.26189999999993 | 81.22841999999991 | 98.65799999999987 | 62.48339999999992 | 49.32899999999994 | 18.74501999999998 | 13.81211999999998 | 13.15439999999998 | 20.19178475999999 | 18.80538929999999
2022-07-01 00:00:00 | 18.70152010999999 | 17.97438051499999 | 17.28004420999999 | 16.51098929999999 | 15.87314754999999 | 16.31963677499999 | 10.07744999999992 | 10.07744999999992 | 10.07744999999992 | 11.5890674999999 | 11.5890674999999 | 12.5968124999999 | 11.08519499999991 | 29.22460499999976 | 80.61959999999934 | 161.2391999999986 | 184.4173349999984 | 137.5571924999988 | 60.4646999999995 | 25.19362499999979 | 25.19362499999979 | 25.19362499999979 | 23.05524565499998 | 20.07379107499998
2022-08-01 00:00:00 | 19.00881569999999 | 18.26972804999998 | 17.56398269999999 | 16.78229099999999 | 16.13396849999999 | 16.58779424999998 | 16.11199999999989 | 16.11199999999989 | 16.11199999999989 | 18.52879999999987 | 18.52879999999987 | 20.13999999999986 | 25.77919999999982 | 56.3919999999996 | 136.951999999999 | 265.8479999999981 | 302.9055999999978 | 202.2055999999986 | 96.67199999999931 | 32.22399999999978 | 32.22399999999978 | 32.22399999999978 | 23.43407984999998 | 20.40363524999998
2022-09-01 00:00:00 | 18.116366576 | 17.2633538 | 16.880116176 | 16.17721952 | 16.525135704 | 17.120301968 | 17.108 | 22.2404 | 23.9512 | 16.93692 | 19.67420000000001 | 20.52960000000001 | 19.16096000000001 | 22.2404 | 56.45640000000001 | 78.01248000000001 | 99.22640000000003 | 68.43200000000002 | 39.34840000000001 | 16.08152 | 14.37072 | 13.6864 | 20.219758328 | 18.983507928
2022-10-01 00:00:00 | 26.52465816000001 | 17.64174776 | 14.57768312 | 13.63185096 | 14.0616112 | 15.0955532 | 23.24175000000001 | 23.24175000000001 | 21.69230000000001 | 20.14285000000001 | 21.69230000000001 | 24.79120000000002 | 29.43955000000001 | 35.63735000000002 | 41.83515000000003 | 40.28570000000003 | 43.38460000000002 | 41.83515000000003 | 40.28570000000003 | 37.18680000000002 | 29.43955000000001 | 21.69230000000001 | 24.16367408000001 | 18.15602152
2022-11-01 00:00:00 | 17.93452544799998 | 17.03433691199999 | 16.08494778799999 | 16.24712750399998 | 17.44069732399998 | 19.18458483199998 | 21.41888000000001 | 21.41888000000001 | 22.75756000000001 | 22.75756000000001 | 22.75756000000001 | 26.77360000000001 | 26.77360000000001 | 26.77360000000001 | 26.77360000000001 | 29.45096000000002 | 33.46700000000001 | 33.46700000000001 | 33.46700000000001 | 29.45096000000002 | 26.77360000000001 | 24.09624000000001 | 22.00906303199998 | 19.84423715999998
2022-12-01 00:00:00 | 19.10538139399998 | 17.73948834999998 | 17.40467334199998 | 17.37233325599998 | 17.97538074199998 | 19.17576863999998 | 29.7873 | 29.7873 | 27.19710000000001 | 22.0167 | 22.0167 | 20.72160000000001 | 20.72160000000001 | 20.72160000000001 | 24.6069 | 25.902 | 28.49220000000001 | 32.3775 | 32.3775 | 28.49220000000001 | 25.902 | 23.31180000000001 | 23.11364969999997 | 20.30196457599997
2023-01-01 00:00:00 | 25.45215893999998 | 24.44091951599998 | 24.59102536799998 | 25.21251626399998 | 26.03414829599998 | 28.62281588399998 | 58.64180928260881 | 56.5550197826088 | 54.4682302826088 | 47.78445521739138 | 41.52408671739137 | 18.56940221739133 | 22.74298121739134 | 22.74298121739134 | 22.74298121739134 | 29.00334971739135 | 37.35050771739136 | 41.94749328260878 | 54.4682302826088 | 53.6335144826088 | 53.2161565826088 | 52.38144078260879 | 30.30031461599998 | 26.02361455199998
2023-02-01 00:00:00 | 30.16698443199998 | 23.95941267199998 | 22.66087678399998 | 23.10668151999998 | 23.87388036799998 | 24.70846830399999 | 57.59302104347835 | 55.54355304347835 | 53.49408504347834 | 46.92984695652179 | 40.78144295652179 | 18.23729495652175 | 22.33623095652176 | 22.33623095652176 | 22.33623095652176 | 28.48463495652177 | 36.68250695652178 | 41.19727704347832 | 53.49408504347834 | 52.67429784347834 | 52.26440424347834 | 51.44461704347834 | 31.35147724799998 | 27.52066678399999
2023-03-01 00:00:00 | 19.15566416399999 | 18.02386424999999 | 16.09012582799999 | 16.24616804999999 | 17.62091977799999 | 19.20109417799999 | 23.80532000000003 | 23.80532000000003 | 25.19732600000003 | 22.13087800000002 | 22.13087800000002 | 26.30689600000002 | 26.30689600000002 | 26.30689600000002 | 26.30689600000002 | 29.09090800000003 | 33.26692600000003 | 36.33337400000005 | 36.33337400000005 | 32.15735600000004 | 29.37334400000004 | 26.58933200000003 | 30.12207449999999 | 21.55555403399999
2023-04-01 00:00:00 | 17.4561324 | 15.9504408 | 14.57946 | 14.1054144 | 14.8198932 | 17.68462919999999 | 17.63930547826089 | 18.89019147826089 | 20.14107747826089 | 18.63638852173914 | 18.63638852173914 | 18.63638852173914 | 21.13816052173914 | 26.14170452173915 | 29.89436252173915 | 31.14524852173915 | 36.14879252173915 | 40.1552534782609 | 32.6499374782609 | 27.6463934782609 | 21.39196347826089 | 21.39196347826089 | 22.73202119999999 | 19.08800879999999
2023-05-01 00:00:00 | 17.044063005 | 15.661252275 | 13.324201695 | 12.393399315 | 13.09484931 | 14.37721374 | 13.89221485507246 | 13.89221485507246 | 13.89221485507246 | 13.63831014492752 | 14.88969764492753 | 16.14108514492752 | 18.64386014492753 | 29.90634764492752 | 35.66273014492752 | 49.92854764492751 | 62.4424226449275 | 47.67967735507245 | 29.40941985507246 | 13.89221485507246 | 13.89221485507246 | 12.64082735507246 | 29.305208025 | 18.72988674
2023-06-01 00:00:00 | 18.17652824399999 | 17.34577185599999 | 16.68713835599999 | 16.24980571199999 | 16.26385655999999 | 16.55892436799999 | 5.99467826086957 | 6.57931826086957 | 8.040918260869569 | 10.08292173913043 | 13.00612173913043 | 14.46772173913043 | 17.68324173913043 | 18.85252173913042 | 44.38180173913044 | 77.99860173913044 | 89.6914017391305 | 74.68987826086956 | 42.82699826086957 | 16.22587826086957 | 13.88731826086957 | 13.30267826086957 | 20.31050078399999 | 18.91595411999999
2023-07-01 00:00:00 | 19.00330500599998 | 18.26443161899998 | 17.55889086599998 | 16.77742577999998 | 16.12929122999999 | 16.58298541499998 | 5.714306972463722 | 5.714306972463722 | 5.714306972463722 | 9.134283277536133 | 9.134283277536133 | 15.75903892753607 | 18.95719682753603 | 23.98287352753599 | 66.16809916086893 | 127.8468586608683 | 155.2596406608681 | 150.0882921724623 | 60.08299127246319 | 26.73077317246352 | 25.36013407246353 | 25.36013407246353 | 23.42728626299997 | 20.39772019499998
2023-08-01 00:00:00 | 19.00555238399998 | 18.26659161599997 | 17.56096742399998 | 16.77940991999998 | 16.13119871999998 | 16.58494655999998 | 9.187482991304295 | 9.187482991304295 | 9.187482991304295 | 14.68613300869553 | 14.68613300869553 | 25.33743860869545 | 30.47944820869541 | 38.55974900869535 | 106.3853042086949 | 205.5526322086941 | 249.6270002086938 | 241.3124877913026 | 96.60164619130364 | 42.97783179130405 | 40.77411339130406 | 40.77411339130406 | 23.43005683199997 | 20.40013247999997
2023-09-01 00:00:00 | 18.50756566399999 | 17.63613319999999 | 17.24462006399999 | 16.52654527999999 | 16.88197425599999 | 17.48999235199999 | 13.18804321739131 | 13.18804321739131 | 14.73931321739131 | 9.770752782608687 | 12.25278478260869 | 13.80405478260868 | 15.66557878260869 | 16.90659478260868 | 59.51481078260868 | 58.27379478260868 | 93.64275078260867 | 79.2721452173913 | 50.1082692173913 | 17.22134521739131 | 14.73931321739131 | 14.11880521739131 | 20.65637739199999 | 19.39343179199999
2023-10-01 00:00:00 | 27.02442203999997 | 17.97414443999998 | 14.85234827999999 | 13.88869523999999 | 14.32655279999999 | 15.37997579999998 | 19.4557695652174 | 19.4557695652174 | 19.4557695652174 | 20.5555304347826 | 21.9352304347826 | 21.93523043478261 | 24.6946304347826 | 30.2134304347826 | 34.35253043478261 | 38.49163043478261 | 42.6307304347826 | 36.0121695652174 | 34.6324695652174 | 31.8730695652174 | 24.9745695652174 | 20.8354695652174 | 24.61895351999998 | 18.49810787999998
2023-11-01 00:00:00 | 18.11715359999998 | 17.20779839999998 | 16.24874159999998 | 16.41257279999998 | 17.61829679999998 | 19.37994239999998 | 20.94243478260869 | 20.94243478260869 | 22.16703478260869 | 19.46936521739129 | 19.46936521739129 | 23.14316521739129 | 23.14316521739129 | 23.14316521739129 | 23.14316521739129 | 25.59236521739129 | 29.26616521739129 | 31.96383478260869 | 31.96383478260869 | 28.29003478260869 | 25.84083478260869 | 23.39163478260869 | 22.23318239999997 | 20.04631199999997
2023-12-01 00:00:00 | 19.76167135799997 | 18.34885844999997 | 18.00254219399998 | 17.96909119199998 | 18.59285399399997 | 19.83447647999997 | 24.14715440579711 | 24.14715440579711 | 25.4113074057971 | 18.83404759420289 | 18.83404759420289 | 22.62650659420289 | 22.62650659420289 | 22.62650659420289 | 22.62650659420289 | 25.15481259420289 | 28.94727159420289 | 34.26037840579711 | 34.26037840579711 | 29.20376640579711 | 26.67546040579711 | 24.14715440579711 | 23.90762789999997 | 20.99935843199997