Spreadsheet: 539661d1506324400-forecasting-seasonal-forecast-test-22092017
Sheet: VUURHAARD

Sales | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 |  | Total
 | 2015 | 7 | 7 | 7 | 7 | 2.25 | 2.25 | 2.25 | 2.25 | 2 | 9 | 8 | 10 | 10 | 1 | 3 | 10 | 25 | 29 | 37 | 28 | 34 | 24 | 63 | 51 | 49 | 91 | 57 | 43 | 41 | 90 | 50 | 52 | 40 | 47 | 38 | 25 | 56 | 43 | 61 | 25 | 48 | 47 | 11 | 9 | 11 | 34 | 40 | 19 | 17 | 12 | 0 | 1 |  | 1401
 | 2016 | 5 | 4 | 1 | 7 | 6 | 4 | 0 | 10 | 3 | 6 | 3 | 1 | 8 | 8 | 4 | 9 | 13 | 20 | 17 | 13 | 25 | 28 | 25 | 36 | 24 | 42 | 38 | 27 | 50 | 26 | 16 | 33 | 36 | 31 | 36 | 36 | 44 | 43 | 48 | 35 | 30 | 24 | 26 | 22 | 11 | 17 | 22 | 33 | 33 | 36 | 34 | 17 |  | 1089
 | 2017 | 5 | 2 | 3 | 1 | 3 | 3 | 13 | 5 | 8 | 10 | 12 | 14 | 6 | 8 | 5 | 21 | 8 | 3 | 14 | 13 | 31 | 26 | 47 | 31 | 52 | 37 | 18 | 21 | 28 | 54 | 45 | 35 | 31 | 25 | 23 | 21 | 32 | 23 | 28 | 27 | 20 | 30 | 29 | 4 |  |  |  |  |  |  |  |  |  | 875
 | 2018 | 9.200390237250609 | 7.097744512978291 | 6.058373954421014 | 8.333132850229212 | 6.303635003776872 | 5.227212304125064 | 8.690745553226545 | 9.912986356540697 | 7.532808363249544 | 14.60569296511486 | 13.54719872083137 | 14.84473903669247 | 14.36569158958202 | 10.25697387362366 | 7.297587909148266 | 24.51652988775631 | 28.41393175677116 | 32.36870468296463 | 42.65340878122238 | 34.12999437768629 | 57.3136068916502 | 50.04470451109125 | 87.2612591239944 | 76.83695300026643 | 81.99269250973472 | 112.3228184566031 | 75.201882272331 | 60.99587169790064 | 80.33276187068631 | 115.5738450300586 | 75.99360462205824 | 82.72895881184922 | 74.27821353374165 | 71.99389279507035 | 68.26382317615985 | 58.09959741764609 | 94.15726283785862 | 78.27219353699822 | 99.03379829638645 | 63.30601645495105 | 71.77875573230594 | 74.45893764584086 | 48.971876305824 | 26.13726665470797 | 24.80147896739445 | 57.86007809574633 | 70.78432847619852 | 59.74041317427919 | 57.80127408263487 | 55.83344946240123 | 39.79252036221004 | 21.19571330570429 |  | 2478.517331829475
 | Total | 17 | 13 | 11 | 15 | 11.25 | 9.25 | 15.25 | 17.25 | 13 | 25 | 23 | 25 | 24 | 17 | 12 | 40 | 46 | 52 | 68 | 54 | 90 | 78 | 135 | 118 | 125 | 170 | 113 | 91 | 119 | 170 | 111 | 120 | 107 | 103 | 97 | 82 | 132 | 109 | 137 | 87 | 98 | 101 | 66 | 35 | 22 | 51 | 62 | 52 | 50 | 48 | 34 | 18 |  | 3365
 | Weekly Average | 5.666666666666667 | 4.333333333333333 | 3.666666666666667 | 5 | 3.75 | 3.083333333333333 | 5.083333333333333 | 5.75 | 4.333333333333333 | 8.333333333333334 | 7.666666666666667 | 8.333333333333334 | 8 | 5.666666666666667 | 4 | 13.33333333333333 | 15.33333333333333 | 17.33333333333333 | 22.66666666666667 | 18 | 30 | 26 | 45 | 39.33333333333334 | 41.66666666666666 | 56.66666666666666 | 37.66666666666666 | 30.33333333333333 | 39.66666666666666 | 56.66666666666666 | 37 | 40 | 35.66666666666666 | 34.33333333333334 | 32.33333333333334 | 27.33333333333333 | 44 | 36.33333333333334 | 45.66666666666666 | 29 | 32.66666666666666 | 33.66666666666666 | 22 | 11.66666666666667 | 11 | 25.5 | 31 | 26 | 25 | 24 | 17 | 9 |  | 1121.666666666667
 | Seasonal Indices | 0.005052005943536404 | 0.003863298662704308 | 0.003268945022288261 | 0.004457652303120356 | 0.003343239227340267 | 0.00274888558692422 | 0.004531946508172362 | 0.00512630014858841 | 0.003863298662704308 | 0.007429420505200594 | 0.006835066864784547 | 0.007429420505200594 | 0.00713224368499257 | 0.005052005943536404 | 0.003566121842496285 | 0.01188707280832095 | 0.01367013372956909 | 0.01545319465081723 | 0.02020802377414562 | 0.01604754829123328 | 0.02674591381872214 | 0.02317979197622585 | 0.04011887072808321 | 0.03506686478454681 | 0.03714710252600296 | 0.05052005943536404 | 0.03358098068350669 | 0.02704309063893016 | 0.03536404160475482 | 0.05052005943536404 | 0.03298662704309064 | 0.03566121842496285 | 0.03179791976225854 | 0.03060921248142645 | 0.02882615156017831 | 0.02436849925705795 | 0.03922734026745914 | 0.03239227340267459 | 0.04071322436849925 | 0.02585438335809807 | 0.02912332838038633 | 0.0300148588410104 | 0.01961367013372957 | 0.01040118870728083 | 0.009806835066864784 | 0.02273402674591382 | 0.02763744427934621 | 0.02317979197622585 | 0.02228826151560178 | 0.02139673105497771 | 0.01515601783060921 | 0.008023774145616641
 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 2015 | 1385.588235294118 | 1811.923076923077 | 2141.363636363636 | 1570.333333333333 | 673 | 818.5135135135135 | 496.4754098360656 | 438.9130434782609 | 517.6923076923077 | 1211.4 | 1170.434782608696 | 1346 | 1402.083333333333 | 197.9411764705882 | 841.25 | 841.25 | 1828.804347826087 | 1876.634615384616 | 1830.955882352941 | 1744.814814814815 | 1271.222222222222 | 1035.384615384615 | 1570.333333333333 | 1454.364406779661 | 1319.08 | 1801.264705882353 | 1697.389380530974 | 1590.054945054945 | 1159.36974789916 | 1781.470588235294 | 1515.765765765766 | 1458.166666666667 | 1257.943925233645 | 1535.485436893204 | 1318.247422680412 | 1025.914634146342 | 1427.575757575758 | 1327.477064220183 | 1498.284671532847 | 966.9540229885058 | 1648.163265306123 | 1565.891089108911 | 560.8333333333334 | 865.2857142857143 | 1121.666666666667 | 1495.555555555556 | 1447.311827956989 | 819.6794871794873 | 762.7333333333335 | 560.8333333333334 | 0 | 124.6296296296296
 | 2016 | 989.7058823529411 | 1035.384615384615 | 305.9090909090909 | 1570.333333333333 | 1794.666666666667 | 1455.135135135135 | 0 | 1950.724637681159 | 776.5384615384617 | 807.6 | 438.9130434782609 | 134.6 | 1121.666666666667 | 1583.529411764706 | 1121.666666666667 | 757.125 | 950.9782608695652 | 1294.23076923077 | 841.25 | 810.0925925925927 | 934.7222222222223 | 1207.948717948718 | 623.1481481481482 | 1026.610169491525 | 646.0800000000002 | 831.3529411764707 | 1131.592920353982 | 998.4065934065935 | 1413.865546218488 | 514.6470588235295 | 485.045045045045 | 925.375 | 1132.14953271028 | 1012.766990291262 | 1248.865979381443 | 1477.317073170732 | 1121.666666666667 | 1327.477064220183 | 1178.978102189781 | 1353.735632183908 | 1030.102040816327 | 799.6039603960397 | 1325.606060606061 | 2115.142857142857 | 1121.666666666667 | 747.7777777777778 | 796.0215053763441 | 1423.653846153846 | 1480.6 | 1682.5 | 2243.333333333333 | 2118.703703703704
 | 2017 | 989.7058823529411 | 517.6923076923077 | 917.7272727272729 | 224.3333333333333 | 897.3333333333334 | 1091.351351351351 | 2868.524590163935 | 975.3623188405797 | 2070.769230769231 | 1346 | 1755.652173913043 | 1884.4 | 841.25 | 1583.529411764706 | 1402.083333333333 | 1766.625 | 585.2173913043479 | 194.1346153846154 | 692.7941176470588 | 810.0925925925927 | 1159.055555555556 | 1121.666666666667 | 1171.518518518519 | 884.0254237288135 | 1399.84 | 732.3823529411766 | 536.0176991150443 | 776.5384615384617 | 791.7647058823532 | 1068.882352941177 | 1364.189189189189 | 981.4583333333334 | 974.9065420560748 | 816.747572815534 | 797.8865979381443 | 861.7682926829269 | 815.7575757575758 | 710.0458715596329 | 687.7372262773723 | 1044.310344827586 | 686.7346938775511 | 999.5049504950496 | 1478.560606060606 | 384.5714285714286 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2015 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Sales (Y) | 1385.588235294118 | 1811.923076923077 | 2141.363636363636 | 1570.333333333333 | 673 | 818.5135135135135 | 496.4754098360656 | 438.9130434782609 | 517.6923076923077 | 1211.4 | 1170.434782608696 | 1346 | 1402.083333333333 | 197.9411764705882 | 841.25 | 841.25 | 1828.804347826087 | 1876.634615384616 | 1830.955882352941 | 1744.814814814815 | 1271.222222222222 | 1035.384615384615 | 1570.333333333333 | 1454.364406779661 | 1319.08 | 1801.264705882353 | 1697.389380530974 | 1590.054945054945 | 1159.36974789916 | 1781.470588235294 | 1515.765765765766 | 1458.166666666667 | 1257.943925233645 | 1535.485436893204 | 1318.247422680412 | 1025.914634146342 | 1427.575757575758 | 1327.477064220183 | 1498.284671532847 | 966.9540229885058 | 1648.163265306123 | 1565.891089108911 | 560.8333333333334 | 865.2857142857143 | 1121.666666666667 | 1495.555555555556 | 1447.311827956989 | 819.6794871794873 | 762.7333333333335 | 560.8333333333334 | 0 | 124.6296296296296
 | sum x^2 | 1 | 4 | 9 | 16 | 25 | 36 | 49 | 64 | 81 | 100 | 121 | 144 | 169 | 196 | 225 | 256 | 289 | 324 | 361 | 400 | 441 | 484 | 529 | 576 | 625 | 676 | 729 | 784 | 841 | 900 | 961 | 1024 | 1089 | 1156 | 1225 | 1296 | 1369 | 1444 | 1521 | 1600 | 1681 | 1764 | 1849 | 1936 | 2025 | 2116 | 2209 | 2304 | 2401 | 2500 | 2601 | 2704
 | sum y^2 | 1919854.757785467 | 3283065.236686392 | 4585438.223140497 | 2465946.777777778 | 452929 | 669964.3718042367 | 246487.8325718893 | 192644.6597353497 | 268005.325443787 | 1467489.96 | 1369917.580340265 | 1811716 | 1965837.673611111 | 39180.70934256055 | 707701.5625 | 707701.5625 | 3344525.342627599 | 3521757.479659765 | 3352399.443122837 | 3044378.737997257 | 1616005.938271605 | 1072021.301775148 | 2465946.777777778 | 2115175.827707556 | 1739972.0464 | 3244554.54065744 | 2881130.709139322 | 2528274.728293685 | 1344138.212343761 | 3173637.456747406 | 2297545.856667478 | 2126250.027777778 | 1582422.91903223 | 2357715.526911113 | 1737776.26740355 | 1052500.836555622 | 2037972.543617998 | 1762195.356030637 | 2244856.956950291 | 935000.0825736559 | 2716442.14910454 | 2452014.902950692 | 314534.0277777778 | 748719.3673469388 | 1258136.111111111 | 2236686.419753087 | 2094711.527344201 | 671874.4617028272 | 581762.137777778 | 314534.0277777778 | 0 | 15532.54458161866
 | sum x*y | 1385.588235294118 | 3623.846153846155 | 6424.09090909091 | 6281.333333333334 | 3365 | 4911.081081081082 | 3475.32786885246 | 3511.304347826087 | 4659.23076923077 | 12114 | 12874.78260869565 | 16152 | 18227.08333333333 | 2771.176470588235 | 12618.75 | 13460 | 31089.67391304348 | 33779.42307692309 | 34788.16176470588 | 34896.2962962963 | 26695.66666666667 | 22778.46153846154 | 36117.66666666667 | 34904.74576271186 | 32977.00000000001 | 46832.88235294118 | 45829.51327433628 | 44521.53846153847 | 33621.72268907564 | 53444.11764705883 | 46988.73873873874 | 46661.33333333334 | 41512.14953271028 | 52206.50485436893 | 46138.65979381443 | 36932.9268292683 | 52820.30303030302 | 50444.12844036697 | 58433.10218978103 | 38678.16091954023 | 67574.69387755104 | 65767.42574257427 | 24115.83333333334 | 38072.57142857143 | 50475 | 68795.55555555556 | 68023.6559139785 | 39344.61538461539 | 37373.93333333334 | 28041.66666666667 | 0 | 6480.740740740742
2016 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104
 | Sales (Y) | 989.7058823529411 | 1035.384615384615 | 305.9090909090909 | 1570.333333333333 | 1794.666666666667 | 1455.135135135135 | 0 | 1950.724637681159 | 776.5384615384617 | 807.6 | 438.9130434782609 | 134.6 | 1121.666666666667 | 1583.529411764706 | 1121.666666666667 | 757.125 | 950.9782608695652 | 1294.23076923077 | 841.25 | 810.0925925925927 | 934.7222222222223 | 1207.948717948718 | 623.1481481481482 | 1026.610169491525 | 646.0800000000002 | 831.3529411764707 | 1131.592920353982 | 998.4065934065935 | 1413.865546218488 | 514.6470588235295 | 485.045045045045 | 925.375 | 1132.14953271028 | 1012.766990291262 | 1248.865979381443 | 1477.317073170732 | 1121.666666666667 | 1327.477064220183 | 1178.978102189781 | 1353.735632183908 | 1030.102040816327 | 799.6039603960397 | 1325.606060606061 | 2115.142857142857 | 1121.666666666667 | 747.7777777777778 | 796.0215053763441 | 1423.653846153846 | 1480.6 | 1682.5 | 2243.333333333333 | 2118.703703703704
 | sum x^2 | 2809 | 2916 | 3025 | 3136 | 3249 | 3364 | 3481 | 3600 | 3721 | 3844 | 3969 | 4096 | 4225 | 4356 | 4489 | 4624 | 4761 | 4900 | 5041 | 5184 | 5329 | 5476 | 5625 | 5776 | 5929 | 6084 | 6241 | 6400 | 6561 | 6724 | 6889 | 7056 | 7225 | 7396 | 7569 | 7744 | 7921 | 8100 | 8281 | 8464 | 8649 | 8836 | 9025 | 9216 | 9409 | 9604 | 9801 | 10000 | 10201 | 10404 | 10609 | 10816
 | sum y^2 | 979517.7335640137 | 1072021.301775148 | 93580.37190082646 | 2465946.777777778 | 3220828.444444444 | 2117418.261504748 | 0 | 3805326.612056291 | 603011.982248521 | 652217.76 | 192644.6597353497 | 18117.16 | 1258136.111111111 | 2507565.397923875 | 1258136.111111111 | 573238.265625 | 904359.652646503 | 1675033.284023669 | 707701.5625 | 656250.0085733884 | 873705.6327160496 | 1459140.105193951 | 388313.6145404664 | 1053928.440103418 | 417419.3664000002 | 691147.7128027683 | 1280502.537395254 | 996815.725757759 | 1999015.782783702 | 264861.5951557094 | 235268.6957227497 | 856318.890625 | 1281762.564416107 | 1025696.976623622 | 1559666.234456371 | 2182465.734681738 | 1258136.111111111 | 1762195.356030637 | 1389989.365443018 | 1832600.161844366 | 1061110.214493961 | 639366.4934810315 | 1757231.427915519 | 4473829.30612245 | 1258136.111111111 | 559171.6049382717 | 633650.237021621 | 2026790.27366864 | 2192176.36 | 2830806.250000001 | 5032544.444444445 | 4488905.384087793
 | sum x*y | 52454.41176470588 | 55910.76923076923 | 16825 | 87938.66666666667 | 102296 | 84397.83783783784 | 0 | 117043.4782608696 | 47368.84615384616 | 50071.2 | 27651.52173913044 | 8614.4 | 72908.33333333334 | 104512.9411764706 | 75151.66666666667 | 51484.5 | 65617.5 | 90596.15384615387 | 59728.75 | 58326.66666666668 | 68234.72222222223 | 89388.20512820514 | 46736.11111111111 | 78022.37288135593 | 49748.16000000001 | 64845.52941176471 | 89395.84070796461 | 79872.52747252748 | 114523.1092436975 | 42201.05882352942 | 40258.73873873874 | 77731.5 | 96232.71028037384 | 87097.96116504855 | 108651.3402061856 | 130003.9024390244 | 99828.33333333334 | 119472.9357798165 | 107287.0072992701 | 124543.6781609195 | 95799.48979591839 | 75162.77227722773 | 125932.5757575758 | 203053.7142857143 | 108801.6666666667 | 73282.22222222223 | 78806.12903225806 | 142365.3846153847 | 149540.6 | 171615 | 231063.3333333333 | 220345.1851851852
2017 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156
 | Sales (Y) | 989.7058823529411 | 517.6923076923077 | 917.7272727272729 | 224.3333333333333 | 897.3333333333334 | 1091.351351351351 | 2868.524590163935 | 975.3623188405797 | 2070.769230769231 | 1346 | 1755.652173913043 | 1884.4 | 841.25 | 1583.529411764706 | 1402.083333333333 | 1766.625 | 585.2173913043479 | 194.1346153846154 | 692.7941176470588 | 810.0925925925927 | 1159.055555555556 | 1121.666666666667 | 1171.518518518519 | 884.0254237288135 | 1399.84 | 732.3823529411766 | 536.0176991150443 | 776.5384615384617 | 791.7647058823532 | 1068.882352941177 | 1364.189189189189 | 981.4583333333334 | 974.9065420560748 | 816.747572815534 | 797.8865979381443 | 861.7682926829269 | 815.7575757575758 | 710.0458715596329 | 687.7372262773723 | 1044.310344827586 | 686.7346938775511 | 999.5049504950496 | 1478.560606060606 | 384.5714285714286 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x^2 | 11025 | 11236 | 11449 | 11664 | 11881 | 12100 | 12321 | 12544 | 12769 | 12996 | 13225 | 13456 | 13689 | 13924 | 14161 | 14400 | 14641 | 14884 | 15129 | 15376 | 15625 | 15876 | 16129 | 16384 | 16641 | 16900 | 17161 | 17424 | 17689 | 17956 | 18225 | 18496 | 18769 | 19044 | 19321 | 19600 | 19881 | 20164 | 20449 | 20736 | 21025 | 21316 | 21609 | 21904 | 22201 | 22500 | 22801 | 23104 | 23409 | 23716 | 24025 | 24336
 | sum y^2 | 979517.7335640137 | 268005.325443787 | 842223.3471074383 | 50325.44444444445 | 805207.1111111111 | 1191047.772096421 | 8228433.324375169 | 951331.6530140728 | 4288085.207100593 | 1811716 | 3082314.555765596 | 3550963.36 | 707701.5625 | 2507565.397923875 | 1965837.673611111 | 3120963.890625 | 342479.3950850662 | 37688.24889053256 | 479963.6894463667 | 656250.0085733884 | 1343409.780864198 | 1258136.111111111 | 1372455.639231825 | 781500.9497989083 | 1959552.025600001 | 536383.9108996541 | 287314.9737645861 | 603011.982248521 | 626891.3494809692 | 1142509.484429066 | 1861012.143900657 | 963260.4600694445 | 950442.7657437333 | 667076.597700066 | 636623.0231693059 | 742644.5902736468 | 665460.4224058769 | 504165.1397188787 | 472982.4924076936 | 1090584.096313912 | 471604.5397750938 | 999010.1460641115 | 2186141.465794307 | 147895.1836734694 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 103919.1176470588 | 54875.38461538462 | 98196.81818181819 | 24228 | 97809.33333333334 | 120048.6486486487 | 318406.2295081968 | 109240.5797101449 | 233996.9230769231 | 153444 | 201900 | 218590.4 | 98426.25 | 186856.4705882353 | 166847.9166666667 | 211995 | 70811.3043478261 | 23684.42307692308 | 85213.67647058822 | 100451.4814814815 | 144881.9444444445 | 141330 | 148782.8518518519 | 113155.2542372881 | 180579.36 | 95209.70588235295 | 70218.3185840708 | 102503.0769230769 | 105304.705882353 | 143230.2352941177 | 184165.5405405405 | 133478.3333333333 | 133562.1962616823 | 112711.1650485437 | 110906.2371134021 | 120647.5609756098 | 115021.8181818182 | 100826.5137614679 | 98346.42335766424 | 150380.6896551724 | 99576.53061224491 | 145927.7227722773 | 217348.4090909091 | 56916.57142857143 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 166006.6666666667 |  | 16.0878006171733 | -704.6486293463075
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 221798393.9712366
 | sum x*y | 11925708.74836646
2018 | Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | Cumulative Season (X) | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208
 | Sales (Y) | 1821.1360675499 | 1837.223868167073 | 1853.311668784247 | 1869.39946940142 | 1885.487270018593 | 1901.575070635767 | 1917.66287125294 | 1933.750671870113 | 1949.838472487286 | 1965.92627310446 | 1982.014073721633 | 1998.101874338806 | 2014.18967495598 | 2030.277475573153 | 2046.365276190326 | 2062.4530768075 | 2078.540877424673 | 2094.628678041846 | 2110.716478659019 | 2126.804279276193 | 2142.892079893366 | 2158.979880510539 | 2175.067681127713 | 2191.155481744886 | 2207.243282362059 | 2223.331082979233 | 2239.418883596406 | 2255.506684213579 | 2271.594484830752 | 2287.682285447926 | 2303.770086065099 | 2319.857886682272 | 2335.945687299446 | 2352.033487916619 | 2368.121288533792 | 2384.209089150965 | 2400.296889768138 | 2416.384690385312 | 2432.472491002485 | 2448.560291619659 | 2464.648092236832 | 2480.735892854005 | 2496.823693471179 | 2512.911494088352 | 2528.999294705525 | 2545.087095322698 | 2561.174895939871 | 2577.262696557045 | 2593.350497174218 | 2609.438297791392 | 2625.526098408565 | 2641.613899025738
 | Seasonal Indices | 0.005052005943536404 | 0.003863298662704308 | 0.003268945022288261 | 0.004457652303120356 | 0.003343239227340267 | 0.00274888558692422 | 0.004531946508172362 | 0.00512630014858841 | 0.003863298662704308 | 0.007429420505200594 | 0.006835066864784547 | 0.007429420505200594 | 0.00713224368499257 | 0.005052005943536404 | 0.003566121842496285 | 0.01188707280832095 | 0.01367013372956909 | 0.01545319465081723 | 0.02020802377414562 | 0.01604754829123328 | 0.02674591381872214 | 0.02317979197622585 | 0.04011887072808321 | 0.03506686478454681 | 0.03714710252600296 | 0.05052005943536404 | 0.03358098068350669 | 0.02704309063893016 | 0.03536404160475482 | 0.05052005943536404 | 0.03298662704309064 | 0.03566121842496285 | 0.03179791976225854 | 0.03060921248142645 | 0.02882615156017831 | 0.02436849925705795 | 0.03922734026745914 | 0.03239227340267459 | 0.04071322436849925 | 0.02585438335809807 | 0.02912332838038633 | 0.0300148588410104 | 0.01961367013372957 | 0.01040118870728083 | 0.009806835066864784 | 0.02273402674591382 | 0.02763744427934621 | 0.02317979197622585 | 0.02228826151560178 | 0.02139673105497771 | 0.01515601783060921 | 0.008023774145616641
 | Forecast Sales | 9.200390237250609 | 7.097744512978291 | 6.058373954421014 | 8.333132850229212 | 6.303635003776872 | 5.227212304125064 | 8.690745553226545 | 9.912986356540697 | 7.532808363249544 | 14.60569296511486 | 13.54719872083137 | 14.84473903669247 | 14.36569158958202 | 10.25697387362366 | 7.297587909148266 | 24.51652988775631 | 28.41393175677116 | 32.36870468296463 | 42.65340878122238 | 34.12999437768629 | 57.3136068916502 | 50.04470451109125 | 87.2612591239944 | 76.83695300026643 | 81.99269250973472 | 112.3228184566031 | 75.201882272331 | 60.99587169790064 | 80.33276187068631 | 115.5738450300586 | 75.99360462205824 | 82.72895881184922 | 74.27821353374165 | 71.99389279507035 | 68.26382317615985 | 58.09959741764609 | 94.15726283785862 | 78.27219353699822 | 99.03379829638645 | 63.30601645495105 | 71.77875573230594 | 74.45893764584086 | 48.971876305824 | 26.13726665470797 | 24.80147896739445 | 57.86007809574633 | 70.78432847619852 | 59.74041317427919 | 57.80127408263487 | 55.83344946240123 | 39.79252036221004 | 21.19571330570429