Spreadsheet: 731721d1620533032-rolling-average-cascading-spill-dynamic-range-formula-1d-spilled-range-formula-rolling-average-staggering-array-
Sheet: Rolling Avg Staggering 1DArrays

CPI (Consumer Price Index)
2018-2020 U.S. inflation data
Month | Index | Δ% | Rolling average
 |  | vs. prior month |  | vs. 12 months prior |  | Within year | Whole period
2018-01-01 00:00:00 | 4930.72
 | 4946.5 | 0.003200343965992669 |  | N/A |  | 0.003200343965992669 | 0.003200343965992669
2018-03-31 00:00:00 | 4950.95 | 0.0008996259981803867 |  | N/A |  | 0.004102849076808246 | 0.004102849076808246
2018-04-30 00:00:00 | 4961.84 | 0.002199577858794877 |  | N/A |  | 0.00631145147159029 | 0.00631145147159029
2018-05-31 00:00:00 | 4981.69 | 0.004000532060687068 |  | N/A |  | 0.01033723269623898 | 0.01033723269623898
2018-06-30 00:00:00 | 5044.46 | 0.01260014171897494 |  | N/A |  | 0.02306762501216864 | 0.02306762501216864
2018-07-31 00:00:00 | 5061.11 | 0.003300650614733724 |  | N/A |  | 0.02644441379757922 | 0.02644441379757922
2018-08-31 00:00:00 | 5056.56 | -0.0008990122720112792 |  | N/A |  | 0.02552162767303767 | 0.02552162767303767
2018-09-30 00:00:00 | 5080.83 | 0.004799705728795844 |  | N/A |  | 0.03044382970438386 | 0.03044382970438386
2018-10-31 00:00:00 | 5103.69 | 0.004499264883887077 |  | N/A |  | 0.03508006944219089 | 0.03508006944219089
2018-11-30 00:00:00 | 5092.97 | -0.002100441053433766 |  | N/A |  | 0.03290594477074338 | 0.03290594477074338
2018-12-31 00:00:00 | 5100.61 | 0.001500107010251162 |  | N/A |  | 0.03445541421942422 | 0.03445541421942422
2019-01-31 00:00:00 | 5116.93 | 0.003199617300675861 |  | 0.03776527565953858 |  | 0.003199617300675861 | 0.03776527565953858
2019-02-28 00:00:00 | 5138.93 | 0.004299452992321484 |  | 0.03890225411907422 |  | 0.00751282689717514 | 0.0422270986793003
2019-03-31 00:00:00 | 5177.47 | 0.007499615678750349 |  | 0.04575283531443475 |  | 0.01506878589031513 | 0.05004340136937402
2019-04-30 00:00:00 | 5206.98 | 0.005699695024790064 |  | 0.0494050594134432 |  | 0.02085436839907384 | 0.05602832851997253
2019-05-31 00:00:00 | 5213.75 | 0.001300177838209571 |  | 0.04658258542783678 |  | 0.02218166062490567 | 0.05740135314923567
2019-06-30 00:00:00 | 5214.27 | 9.973627427473097e-05 |  | 0.03366267152480162 |  | 0.02228360921536843 | 0.05750681442061212
2019-07-31 00:00:00 | 5224.18 | 0.001900553672901539 |  | 0.03222020465866193 |  | 0.02422651408360976 | 0.05951666288087742
2019-08-31 00:00:00 | 5229.93 | 0.001100651202676772 |  | 0.03428615501447618 |  | 0.0253538302281493 | 0.06068282117013335
2019-09-30 00:00:00 | 5227.84 | -0.0003996229395040185 |  | 0.02893424893176899 |  | 0.0249440753164818 | 0.06025894798325604
2019-10-31 00:00:00 | 5233.07 | 0.00100041317255295 |  | 0.02535028577362652 |  | 0.02596944287055858 | 0.06131964500113551
2019-11-30 00:00:00 | 5259.76 | 0.00510025663711744 |  | 0.03274906390573662 |  | 0.0312021503310389 | 0.06673264756465591
2019-12-31 00:00:00 | 5320.25 | 0.01150052473877139 |  | 0.04306151617159526 |  | 0.04306151617159526 | 0.07900063276762825
2020-01-31 00:00:00 | 5331.42 | 0.002099525398242541 |  | 0.04191771237832054 |  | 0.002099525398242541 | 0.08126602200084365
2020-02-29 00:00:00 | 5344.75 | 0.002500271972570189 |  | 0.04005113905034707 |  | 0.004605046755321585 | 0.0839694811305447
2020-03-31 00:00:00 | 5348.49 | 0.0006997520931755208 |  | 0.03303157719890204 |  | 0.005308021239603278 | 0.08472799104390427
2020-04-30 00:00:00 | 5331.91 | -0.003099940356997899 |  | 0.02399279428766787 |  | 0.002191626333349017 | 0.08136539896810202
2020-05-31 00:00:00 | 5311.65 | -0.003799764062034083 |  | 0.01877727163749698 |  | -0.001616465391664046 | 0.0772564655871757
2020-06-30 00:00:00 | 5325.46 | 0.002599945403029214 |  | 0.02132417385367447 |  | 0.0009792772896011215 | 0.08005727358276271
2020-07-31 00:00:00 | 5344.63 | 0.003599689040946652 |  | 0.0230562499760727 |  | 0.004582491424275137 | 0.08394514391407326
2020-08-31 00:00:00 | 5357.46 | 0.002400540355459668 |  | 0.02438464759566572 |  | 0.006994032235327241 | 0.08654719797514354
2020-09-30 00:00:00 | 5391.75 | 0.006400421095071218 |  | 0.03135329313827495 |  | 0.013439218081857 | 0.09350155758185408
2020-10-31 00:00:00 | 5438.12 | 0.008600176195112885 |  | 0.03918350031625795 |  | 0.02215497392039856 | 0.1029058636466884
2020-11-30 00:00:00 | 5486.52 | 0.00890013460534167 |  | 0.04311223325779134 |  | 0.03125229077580949 | 0.1127218742901646
2020-12-31 00:00:00 | 5560.59 | 0.01350036088449502 |  | 0.04517456886424509 |  | 0.04517456886424509 | 0.1277440211571534