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

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 | 11.5 | 11.5 | 11.5 | 11.5 | 7 | 7 | 7 | 7 | 5 | 5 | 12 | 18 | 16 | 13 | 10 | 13 | 40 | 31 | 118 | 118 | 72 | 61 | 159 | 160 | 147 | 123 | 119 | 151 | 91 | 135 | 159 | 193 | 111 | 157 | 316 | 160 | 182 | 115 | 124 | 163 | 72 | 66 | 73 | 45 | 31 | 54 | 47 | 23 | 26 | 20 | 10 | 8 |  | 3772
 | 2016 | 6 | 9 | 7 | 5 | 3 | 9 | 6 | 28 | 19 | 11 | 28 | 34 | 20 | 33 | 27 | 48 | 38 | 74 | 114 | 38 | 82 | 144 | 117 | 137 | 115 | 139 | 318 | 291 | 229 | 131 | 150 | 227 | 124 | 102 | 76 | 147 | 178 | 322 | 186 | 142 | 102 | 116 | 162 | 94 | 92 | 75 | 53 | 46 | 52 | 76 | 51 | 21 |  | 4781
 | 2017 | 7 | 7 | 5 | 7 | 6 | 9 | 10 | 9 | 17 | 17 | 33 | 34 | 59 | 37 | 43 | 43 | 53 | 40 | 56 | 91 | 132 | 221 | 168 | 216 | 197 | 160 | 140 | 144 | 207 | 689 | 361 | 363 | 276 | 333 | 156 | 240 | 172 | 209 | 155 | 135 | 104 | 71 | 81 | 18 |  |  |  |  |  |  |  |  |  | 5531
 | 2018 | 13.85344157542679 | 15.67576043226343 | 13.50330466735699 | 13.61095951077977 | 9.3403331773294 | 14.70879701875037 | 13.63745757208966 | 26.29061578369022 | 24.68589714228263 | 20.02031161078486 | 44.62177316067944 | 52.96208724263562 | 58.93983168725788 | 51.87502806109078 | 50.36651162018865 | 65.95289505160565 | 83.6753997557938 | 93.2820621792052 | 186.5968196889791 | 161.1642102284874 | 187.9213731406213 | 281.8623868492811 | 295.8060545489719 | 344.125996704162 | 310.0049128170276 | 286.9486161653705 | 394.9877048844137 | 403.8331911155322 | 365.5884350755806 | 666.8738763822321 | 470.9284676485381 | 553.9406844315625 | 363.8526567953501 | 424.2399170029917 | 395.2189911478129 | 397.003626879531 | 388.5539953559688 | 474.7749287192256 | 343.8799467752525 | 327.4074427472352 | 208.1355090827043 | 190.5772945061253 | 239.4809147127158 | 119.7018323356391 | 141.5139188430013 | 149.3034713971433 | 116.4262836891036 | 80.80827516225843 | 91.88446865456174 | 113.7482490376519 | 72.6966999734485 | 34.76000220364668 |  | 10251.55362195134
 | Total | 24.5 | 27.5 | 23.5 | 23.5 | 16 | 25 | 23 | 44 | 41 | 33 | 73 | 86 | 95 | 83 | 80 | 104 | 131 | 145 | 288 | 247 | 286 | 426 | 444 | 513 | 459 | 422 | 577 | 586 | 527 | 955 | 670 | 783 | 511 | 592 | 548 | 547 | 532 | 646 | 465 | 440 | 278 | 253 | 316 | 157 | 123 | 129 | 100 | 69 | 78 | 96 | 61 | 29 |  | 14084
 | Weekly Average | 8.166666666666666 | 9.166666666666666 | 7.833333333333333 | 7.833333333333333 | 5.333333333333333 | 8.333333333333334 | 7.666666666666667 | 14.66666666666667 | 13.66666666666667 | 11 | 24.33333333333333 | 28.66666666666667 | 31.66666666666667 | 27.66666666666667 | 26.66666666666667 | 34.66666666666666 | 43.66666666666666 | 48.33333333333334 | 96 | 82.33333333333333 | 95.33333333333333 | 142 | 148 | 171 | 153 | 140.6666666666667 | 192.3333333333333 | 195.3333333333333 | 175.6666666666667 | 318.3333333333333 | 223.3333333333333 | 261 | 170.3333333333333 | 197.3333333333333 | 182.6666666666667 | 182.3333333333333 | 177.3333333333333 | 215.3333333333333 | 155 | 146.6666666666667 | 92.66666666666667 | 84.33333333333333 | 105.3333333333333 | 52.33333333333334 | 61.5 | 64.5 | 50 | 34.5 | 39 | 48 | 30.5 | 14.5 |  | 4694.666666666667
 | Seasonal Indices | 0.001739562624254473 | 0.001952570292530531 | 0.001668560068162454 | 0.001668560068162454 | 0.001136040897472309 | 0.001775063902300483 | 0.001633058790116444 | 0.003124112468048849 | 0.002911104799772792 | 0.002343084351036637 | 0.005183186594717409 | 0.006106219823913661 | 0.006745242828741834 | 0.005893212155637603 | 0.005680204487361545 | 0.007384265833570007 | 0.009301334848054529 | 0.0102953706333428 | 0.02044873615450156 | 0.01753763135472877 | 0.02030673104231752 | 0.03024708889520022 | 0.03152513490485657 | 0.03642431127520591 | 0.03259017324623686 | 0.02996307867083215 | 0.04096847486509515 | 0.04160749786992331 | 0.03741834706049418 | 0.06780744106787844 | 0.04757171258165294 | 0.05559500142005112 | 0.03628230616302187 | 0.04203351320647544 | 0.03890940073842658 | 0.03883839818233456 | 0.03777335984095427 | 0.04586765123544447 | 0.03301618858278898 | 0.03124112468048849 | 0.01973871059358137 | 0.01796364669128088 | 0.0224368077250781 | 0.01114740130644703 | 0.01309997159897756 | 0.01373899460380574 | 0.0106503834138029 | 0.007348764555523998 | 0.00830729906276626 | 0.01022436807725078 | 0.006496733882419767 | 0.00308861119000284
 | 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 | 6610.857142857144 | 5889.672727272728 | 6892.170212765958 | 6892.170212765958 | 6161.750000000001 | 3943.52 | 4286.434782608696 | 2240.636363636364 | 1717.560975609756 | 2133.939393939394 | 2315.178082191781 | 2947.813953488372 | 2372.042105263158 | 2205.927710843373 | 1760.5 | 1760.5 | 4300.458015267176 | 3011.062068965517 | 5770.527777777778 | 6728.388663967612 | 3545.622377622378 | 2016.723004694836 | 5043.594594594595 | 4392.670565302144 | 4510.562091503268 | 4105.052132701422 | 2904.672443674177 | 3629.153583617748 | 2431.962049335863 | 1990.931937172775 | 3342.322388059702 | 3471.535121328225 | 3059.342465753425 | 3735.114864864865 | 8121.430656934307 | 4119.63436928702 | 4818.21052631579 | 2507.213622291022 | 3755.733333333334 | 5217.481818181819 | 3647.654676258993 | 3674.08695652174 | 3253.582278481013 | 4036.815286624204 | 2366.417344173442 | 3930.418604651163 | 4412.986666666667 | 3129.777777777778 | 3129.777777777778 | 1956.111111111111 | 1539.234972677596 | 2590.16091954023
 | 2016 | 3449.142857142858 | 4609.309090909092 | 4195.234042553192 | 2996.595744680852 | 2640.75 | 5070.24 | 3674.086956521739 | 8962.545454545456 | 6526.731707317073 | 4694.666666666667 | 5402.082191780823 | 5568.093023255814 | 2965.052631578948 | 5599.662650602409 | 4753.35 | 6500.307692307693 | 4085.435114503817 | 7187.696551724138 | 5574.916666666667 | 2166.769230769231 | 4038.06993006993 | 4760.788732394367 | 3711.324324324324 | 3761.224171539961 | 3528.671023965142 | 4639.042654028436 | 7762.065857885615 | 6993.931740614335 | 6119.992409867173 | 1931.941361256545 | 3153.134328358209 | 4083.100893997446 | 3417.643835616439 | 2426.635135135135 | 1953.255474452555 | 3784.91407678245 | 4712.315789473685 | 7020.198142414862 | 5633.6 | 4545.29090909091 | 5167.510791366907 | 6457.486166007906 | 7220.278481012659 | 8432.458598726114 | 7022.915989159892 | 5458.914728682171 | 4976.346666666667 | 6259.555555555557 | 6259.555555555556 | 7433.222222222224 | 7850.098360655738 | 6799.172413793103
 | 2017 | 4024.000000000001 | 3585.018181818182 | 2996.595744680852 | 4195.234042553192 | 5281.500000000001 | 5070.24 | 6123.478260869565 | 2880.818181818182 | 5839.707317073171 | 7255.393939393939 | 6366.739726027398 | 5568.093023255814 | 8746.905263157896 | 6278.409638554217 | 7570.150000000001 | 5823.192307692309 | 5698.106870229009 | 3885.241379310345 | 2738.555555555556 | 5188.842105263158 | 6500.307692307692 | 7306.488262910799 | 5329.081081081081 | 5930.105263157895 | 6044.76688453159 | 5339.905213270143 | 3417.261698440208 | 3460.914675767918 | 5532.045540796964 | 10161.12670157068 | 7588.54328358209 | 6529.36398467433 | 7607.013698630138 | 7922.25 | 4009.313868613139 | 6179.451553930531 | 4553.473684210527 | 4556.588235294118 | 4694.666666666667 | 4321.227272727273 | 5268.834532374101 | 3952.426877470356 | 3610.139240506329 | 1614.726114649681 | 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) | 6610.857142857144 | 5889.672727272728 | 6892.170212765958 | 6892.170212765958 | 6161.750000000001 | 3943.52 | 4286.434782608696 | 2240.636363636364 | 1717.560975609756 | 2133.939393939394 | 2315.178082191781 | 2947.813953488372 | 2372.042105263158 | 2205.927710843373 | 1760.5 | 1760.5 | 4300.458015267176 | 3011.062068965517 | 5770.527777777778 | 6728.388663967612 | 3545.622377622378 | 2016.723004694836 | 5043.594594594595 | 4392.670565302144 | 4510.562091503268 | 4105.052132701422 | 2904.672443674177 | 3629.153583617748 | 2431.962049335863 | 1990.931937172775 | 3342.322388059702 | 3471.535121328225 | 3059.342465753425 | 3735.114864864865 | 8121.430656934307 | 4119.63436928702 | 4818.21052631579 | 2507.213622291022 | 3755.733333333334 | 5217.481818181819 | 3647.654676258993 | 3674.08695652174 | 3253.582278481013 | 4036.815286624204 | 2366.417344173442 | 3930.418604651163 | 4412.986666666667 | 3129.777777777778 | 3129.777777777778 | 1956.111111111111 | 1539.234972677596 | 2590.16091954023
 | 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 | 43703432.16326533 | 34688244.83438017 | 47502010.24173836 | 47502010.24173836 | 37967163.06250001 | 15551349.9904 | 18373523.14555766 | 5020451.314049589 | 2950015.704937538 | 4553697.337006428 | 5360049.552261213 | 8689607.104380747 | 5626583.749141276 | 4866117.065466686 | 3099360.25 | 3099360.250000001 | 18493939.1410757 | 9066494.783162903 | 33298990.83410494 | 45271214.01340787 | 12571438.04469656 | 4067171.677665367 | 25437846.43462382 | 19295554.69527186 | 20345170.38130633 | 16851453.01219649 | 8437122.005040113 | 13170755.73348554 | 5914439.409409893 | 3963809.978454539 | 11171118.94572511 | 12051556.09861537 | 9359576.322762245 | 13951083.05373448 | 65957635.91539241 | 16971387.33661087 | 23215152.67590028 | 6286120.147801666 | 14105532.87111111 | 27222116.52305786 | 13305384.6372341 | 13498914.96408318 | 10585797.6428457 | 16295877.65832285 | 5599931.046804886 | 15448190.407788 | 19474451.32017778 | 9795508.938271608 | 9795508.938271604 | 3826370.679012347 | 2369244.301113799 | 6708933.589113489
 | sum x*y | 6610.857142857144 | 11779.34545454546 | 20676.51063829787 | 27568.68085106383 | 30808.75 | 23661.12 | 30005.04347826087 | 17925.09090909091 | 15458.04878048781 | 21339.39393939394 | 25466.95890410959 | 35373.76744186047 | 30836.54736842106 | 30882.98795180723 | 26407.5 | 28168 | 73107.78625954199 | 54199.11724137932 | 109640.0277777778 | 134567.7732793522 | 74458.06993006993 | 44367.90610328639 | 116002.6756756757 | 105424.0935672515 | 112764.0522875817 | 106731.355450237 | 78426.15597920277 | 101616.3003412969 | 70526.89943074004 | 59727.95811518325 | 103611.9940298507 | 111089.1238825032 | 100958.301369863 | 126993.9054054054 | 284250.0729927007 | 148306.8372943327 | 178273.7894736842 | 95274.11764705883 | 146473.6 | 208699.2727272728 | 149553.8417266187 | 154311.6521739131 | 139904.0379746836 | 177619.872611465 | 106488.7804878049 | 180799.2558139535 | 207410.3733333333 | 150229.3333333334 | 153359.1111111111 | 97805.55555555556 | 78500.98360655739 | 134688.367816092
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) | 3449.142857142858 | 4609.309090909092 | 4195.234042553192 | 2996.595744680852 | 2640.75 | 5070.24 | 3674.086956521739 | 8962.545454545456 | 6526.731707317073 | 4694.666666666667 | 5402.082191780823 | 5568.093023255814 | 2965.052631578948 | 5599.662650602409 | 4753.35 | 6500.307692307693 | 4085.435114503817 | 7187.696551724138 | 5574.916666666667 | 2166.769230769231 | 4038.06993006993 | 4760.788732394367 | 3711.324324324324 | 3761.224171539961 | 3528.671023965142 | 4639.042654028436 | 7762.065857885615 | 6993.931740614335 | 6119.992409867173 | 1931.941361256545 | 3153.134328358209 | 4083.100893997446 | 3417.643835616439 | 2426.635135135135 | 1953.255474452555 | 3784.91407678245 | 4712.315789473685 | 7020.198142414862 | 5633.6 | 4545.29090909091 | 5167.510791366907 | 6457.486166007906 | 7220.278481012659 | 8432.458598726114 | 7022.915989159892 | 5458.914728682171 | 4976.346666666667 | 6259.555555555557 | 6259.555555555556 | 7433.222222222224 | 7850.098360655738 | 6799.172413793103
 | 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 | 11896586.4489796 | 21245730.2955372 | 17599988.6717972 | 8979586.057039388 | 6973560.562500003 | 25707333.6576 | 13498914.96408317 | 80327221.02479342 | 42598226.77929804 | 22039895.11111112 | 29182492.0067555 | 31003659.91563007 | 8791537.108033242 | 31356221.8005516 | 22594336.2225 | 42254000.09467457 | 16690780.07482082 | 51662981.71966706 | 31079695.84027778 | 4694888.899408285 | 16306008.76013497 | 22665109.35449316 | 13773928.2403214 | 14146807.26857647 | 12451519.1953712 | 21520716.7458952 | 60249666.38215354 | 48915081.19237266 | 37454307.09683181 | 3732397.423333791 | 9942256.092670975 | 16671712.91056274 | 11680289.38712704 | 5888558.079072315 | 3815206.948478875 | 14325574.56862595 | 22205920.099723 | 49283181.95876507 | 31737448.96 | 20659669.44826447 | 26703167.77889344 | 41699127.58418348 | 52132421.34337447 | 71106358.01922998 | 49321348.99079766 | 29799750.01502314 | 24764026.14684445 | 39182035.75308643 | 39182035.75308642 | 55252792.60493829 | 61624044.27196991 | 46228745.51248513
 | sum x*y | 182804.5714285714 | 248902.6909090909 | 230737.8723404256 | 167809.3617021277 | 150522.75 | 294073.92 | 216771.1304347826 | 537752.7272727273 | 398130.6341463415 | 291069.3333333334 | 340331.1780821918 | 356357.9534883721 | 192728.4210526316 | 369577.734939759 | 318474.45 | 442020.9230769231 | 281895.0229007634 | 503138.7586206896 | 395819.0833333334 | 156007.3846153846 | 294779.1048951049 | 352298.3661971831 | 278349.3243243243 | 285853.037037037 | 271707.6688453159 | 361845.327014218 | 613203.2027729636 | 559514.5392491468 | 495719.385199241 | 158419.1916230367 | 261710.1492537314 | 342980.4750957855 | 290499.7260273973 | 208690.6216216216 | 169933.2262773723 | 333072.4387568556 | 419396.105263158 | 631817.8328173376 | 512657.6 | 418166.7636363637 | 480578.5035971224 | 607003.6996047432 | 685926.4556962026 | 809516.0254777069 | 681222.8509485095 | 534973.6434108528 | 492658.3200000001 | 625955.5555555556 | 632215.1111111111 | 758188.6666666667 | 808560.1311475411 | 707113.9310344828
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) | 4024.000000000001 | 3585.018181818182 | 2996.595744680852 | 4195.234042553192 | 5281.500000000001 | 5070.24 | 6123.478260869565 | 2880.818181818182 | 5839.707317073171 | 7255.393939393939 | 6366.739726027398 | 5568.093023255814 | 8746.905263157896 | 6278.409638554217 | 7570.150000000001 | 5823.192307692309 | 5698.106870229009 | 3885.241379310345 | 2738.555555555556 | 5188.842105263158 | 6500.307692307692 | 7306.488262910799 | 5329.081081081081 | 5930.105263157895 | 6044.76688453159 | 5339.905213270143 | 3417.261698440208 | 3460.914675767918 | 5532.045540796964 | 10161.12670157068 | 7588.54328358209 | 6529.36398467433 | 7607.013698630138 | 7922.25 | 4009.313868613139 | 6179.451553930531 | 4553.473684210527 | 4556.588235294118 | 4694.666666666667 | 4321.227272727273 | 5268.834532374101 | 3952.426877470356 | 3610.139240506329 | 1614.726114649681 | 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 | 16192576.00000001 | 12852355.36396695 | 8979586.057039388 | 17599988.6717972 | 27894242.25000001 | 25707333.6576 | 37496986.01134215 | 8299113.396694219 | 34102181.54907794 | 52640741.2157943 | 40535374.73897543 | 31003659.91563007 | 76508351.6826593 | 39418427.5894905 | 57307171.02250001 | 33909568.65236688 | 32468421.90455103 | 15095100.57550535 | 7499686.530864201 | 26924082.3933518 | 42254000.09467456 | 53384770.73605326 | 28399105.1687363 | 35166148.43213297 | 36539206.68832975 | 28514587.68670965 | 11677677.51562645 | 11977930.39294576 | 30603527.86545157 | 103248495.8453727 | 57585989.16679885 | 42632594.04436224 | 57866657.41114657 | 62762045.0625 | 16074597.69705365 | 38185621.50737446 | 20734122.59279779 | 20762496.34602077 | 22039895.11111112 | 18673005.14256199 | 27760617.32953782 | 15621678.22175007 | 13033105.33584362 | 2607340.425331656 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 422520.0000000001 | 380011.9272727273 | 320635.7446808511 | 453085.2765957447 | 575683.5000000001 | 557726.4 | 679706.0869565217 | 322651.6363636364 | 659886.9268292683 | 827114.9090909091 | 732175.0684931508 | 645898.7906976744 | 1023387.915789474 | 740852.3373493976 | 900847.8500000001 | 698783.076923077 | 689470.93129771 | 473999.4482758621 | 336842.3333333334 | 643416.4210526317 | 812538.4615384615 | 920617.5211267606 | 676793.2972972973 | 759053.4736842106 | 779774.9281045751 | 694187.6777251186 | 447661.2824956672 | 456840.7372013652 | 735762.0569259962 | 1361590.978010471 | 1024453.343283582 | 887993.5019157089 | 1042160.876712329 | 1093270.5 | 557294.6277372263 | 865123.2175502743 | 642039.7894736843 | 647035.5294117648 | 671337.3333333334 | 622256.7272727273 | 763981.0071942447 | 577054.324110672 | 530690.4683544304 | 238979.4649681529 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 694810.6666666666 |  | 64.51960913900068 | -2165.828792034903
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 3746872786.305652
 | sum x*y | 55911771.54293106
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) | 7963.749842788204 | 8028.269451927204 | 8092.789061066205 | 8157.308670205206 | 8221.828279344207 | 8286.347888483207 | 8350.867497622208 | 8415.387106761209 | 8479.90671590021 | 8544.42632503921 | 8608.94593417821 | 8673.46554331721 | 8737.985152456211 | 8802.504761595212 | 8867.024370734212 | 8931.543979873213 | 8996.063589012214 | 9060.583198151215 | 9125.102807290215 | 9189.622416429216 | 9254.142025568217 | 9318.661634707218 | 9383.181243846218 | 9447.70085298522 | 9512.22046212422 | 9576.74007126322 | 9641.259680402221 | 9705.779289541222 | 9770.298898680223 | 9834.818507819224 | 9899.338116958224 | 9963.857726097225 | 10028.37733523623 | 10092.89694437523 | 10157.41655351423 | 10221.93616265323 | 10286.45577179223 | 10350.97538093123 | 10415.49499007023 | 10480.01459920923 | 10544.53420834823 | 10609.05381748723 | 10673.57342662623 | 10738.09303576523 | 10802.61264490423 | 10867.13225404323 | 10931.65186318223 | 10996.17147232124 | 11060.69108146024 | 11125.21069059924 | 11189.73029973824 | 11254.24990887724
 | Seasonal Indices | 0.001739562624254473 | 0.001952570292530531 | 0.001668560068162454 | 0.001668560068162454 | 0.001136040897472309 | 0.001775063902300483 | 0.001633058790116444 | 0.003124112468048849 | 0.002911104799772792 | 0.002343084351036637 | 0.005183186594717409 | 0.006106219823913661 | 0.006745242828741834 | 0.005893212155637603 | 0.005680204487361545 | 0.007384265833570007 | 0.009301334848054529 | 0.0102953706333428 | 0.02044873615450156 | 0.01753763135472877 | 0.02030673104231752 | 0.03024708889520022 | 0.03152513490485657 | 0.03642431127520591 | 0.03259017324623686 | 0.02996307867083215 | 0.04096847486509515 | 0.04160749786992331 | 0.03741834706049418 | 0.06780744106787844 | 0.04757171258165294 | 0.05559500142005112 | 0.03628230616302187 | 0.04203351320647544 | 0.03890940073842658 | 0.03883839818233456 | 0.03777335984095427 | 0.04586765123544447 | 0.03301618858278898 | 0.03124112468048849 | 0.01973871059358137 | 0.01796364669128088 | 0.0224368077250781 | 0.01114740130644703 | 0.01309997159897756 | 0.01373899460380574 | 0.0106503834138029 | 0.007348764555523998 | 0.00830729906276626 | 0.01022436807725078 | 0.006496733882419767 | 0.00308861119000284
 | Forecast Sales | 13.85344157542679 | 15.67576043226343 | 13.50330466735699 | 13.61095951077977 | 9.3403331773294 | 14.70879701875037 | 13.63745757208966 | 26.29061578369022 | 24.68589714228263 | 20.02031161078486 | 44.62177316067944 | 52.96208724263562 | 58.93983168725788 | 51.87502806109078 | 50.36651162018865 | 65.95289505160565 | 83.6753997557938 | 93.2820621792052 | 186.5968196889791 | 161.1642102284874 | 187.9213731406213 | 281.8623868492811 | 295.8060545489719 | 344.125996704162 | 310.0049128170276 | 286.9486161653705 | 394.9877048844137 | 403.8331911155322 | 365.5884350755806 | 666.8738763822321 | 470.9284676485381 | 553.9406844315625 | 363.8526567953501 | 424.2399170029917 | 395.2189911478129 | 397.003626879531 | 388.5539953559688 | 474.7749287192256 | 343.8799467752525 | 327.4074427472352 | 208.1355090827043 | 190.5772945061253 | 239.4809147127158 | 119.7018323356391 | 141.5139188430013 | 149.3034713971433 | 116.4262836891036 | 80.80827516225843 | 91.88446865456174 | 113.7482490376519 | 72.6966999734485 | 34.76000220364668