Spreadsheet: 539677d1506331666-forecasting-seasonal-forecast-test-25092017
Sheet: PARASOLVOET

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 | 15.5 | 15.5 | 15.5 | 15.5 | 5.25 | 5.25 | 5.25 | 5.25 | 15 | 3 | 12 | 45 | 27 | 13 | 9 | 13 | 38 | 29 | 108 | 119 | 60 | 65 | 139 | 120 | 137 | 120 | 109 | 113 | 69 | 118 | 104 | 183 | 99 | 151 | 346 | 144 | 158 | 100 | 103 | 133 | 58 | 72 | 54 | 36 | 21 | 46 | 42 | 22 | 30 | 6 | 15 | 10 |  | 3414
 | 2016 | 4 | 6 | 6 | 5 | 2 | 8 | 7 | 25 | 18 | 10 | 30 | 35 | 22 | 36 | 30 | 60 | 47 | 80 | 131 | 47 | 92 | 159 | 118 | 138 | 128 | 150 | 333 | 321 | 245 | 132 | 175 | 230 | 131 | 109 | 78 | 170 | 179 | 342 | 193 | 146 | 103 | 119 | 178 | 105 | 76 | 75 | 49 | 47 | 50 | 70 | 52 | 23 |  | 5062
 | 2017 | 7 | 11 | 6 | 8 | 7 | 11 | 5 | 11 | 20 | 18 | 37 | 40 | 67 | 53 | 48 | 53 | 65 | 48 | 76 | 96 | 156 | 258 | 174 | 253 | 246 | 191 | 167 | 163 | 248 | 775 | 413 | 432 | 298 | 404 | 187 | 267 | 194 | 240 | 182 | 155 | 123 | 83 | 95 | 19 |  |  |  |  |  |  |  |  |  | 6410
 | 2018 | 15.14925974992897 | 18.72649794359673 | 15.97006659076135 | 16.67989437324919 | 8.404496230763765 | 14.41223494150149 | 10.33014049147202 | 24.8893623671037 | 32.21913667284096 | 18.98557789440337 | 48.74045257209151 | 74.579701387267 | 72.61916320910501 | 64.31681670580085 | 55.25255020894915 | 80.5916842282894 | 96.62194484667162 | 101.842140864418 | 205.7598313925842 | 172.3267197141785 | 203.9777213047768 | 321.3952316424205 | 289.3410077116395 | 345.3617012959638 | 347.676407370007 | 315.7454076276069 | 419.8713191517004 | 414.3022578835726 | 392.55890449392 | 720.6089749192342 | 489.6335293923137 | 601.7182987389854 | 378.3766370804741 | 478.8450449944558 | 443.3916614784312 | 424.2529925659184 | 390.147709231462 | 504.1829625808453 | 355.5368606073592 | 324.7755329561729 | 213.812375916897 | 207.5249246815562 | 249.1478378900404 | 122.631960164956 | 112.1775184888489 | 140.7549317786145 | 106.475326705201 | 81.20286882985438 | 94.69182461378728 | 90.47362573621126 | 80.2148843682204 | 39.73304663947965 |  | 10848.9589612259
 | Total | 26.5 | 32.5 | 27.5 | 28.5 | 14.25 | 24.25 | 17.25 | 41.25 | 53 | 31 | 79 | 120 | 116 | 102 | 87 | 126 | 150 | 157 | 315 | 262 | 308 | 482 | 431 | 511 | 511 | 461 | 609 | 597 | 562 | 1025 | 692 | 845 | 528 | 664 | 611 | 581 | 531 | 682 | 478 | 434 | 284 | 274 | 327 | 160 | 97 | 121 | 91 | 69 | 80 | 76 | 67 | 33 |  | 14886
 | Weekly Average | 8.833333333333334 | 10.83333333333333 | 9.166666666666666 | 9.5 | 4.75 | 8.083333333333334 | 5.75 | 13.75 | 17.66666666666667 | 10.33333333333333 | 26.33333333333333 | 40 | 38.66666666666666 | 34 | 29 | 42 | 50 | 52.33333333333334 | 105 | 87.33333333333333 | 102.6666666666667 | 160.6666666666667 | 143.6666666666667 | 170.3333333333333 | 170.3333333333333 | 153.6666666666667 | 203 | 199 | 187.3333333333333 | 341.6666666666667 | 230.6666666666667 | 281.6666666666667 | 176 | 221.3333333333333 | 203.6666666666667 | 193.6666666666667 | 177 | 227.3333333333333 | 159.3333333333333 | 144.6666666666667 | 94.66666666666667 | 91.33333333333333 | 109 | 53.33333333333334 | 48.5 | 60.5 | 45.5 | 34.5 | 40 | 38 | 33.5 | 16.5 |  | 4962
 | Seasonal Indices | 0.001780196157463389 | 0.002183259438398495 | 0.001847373370952573 | 0.001914550584441757 | 0.0009572752922208786 | 0.001629047427112723 | 0.001158806932688432 | 0.00277106005642886 | 0.003560392314926777 | 0.002082493618164719 | 0.005306999865645573 | 0.008061265618702136 | 0.007792556764745398 | 0.006852075775896816 | 0.005844417573559049 | 0.008464328899637243 | 0.01007658202337767 | 0.01054682251780196 | 0.02116082224909311 | 0.01760042993416633 | 0.02069058175466882 | 0.03237941690178691 | 0.0289533790138385 | 0.03432755609297326 | 0.03432755609297326 | 0.03096869541851404 | 0.04091092301491334 | 0.04010479645304313 | 0.03775359398092167 | 0.06885664382641409 | 0.04648663173451565 | 0.05676474539836088 | 0.0354695687222894 | 0.04460566975681849 | 0.04104527744189171 | 0.03902996103721618 | 0.03567110036275695 | 0.04581485959962381 | 0.03211070804783018 | 0.02915491065430606 | 0.01907832863092839 | 0.01840655649603654 | 0.02196694881096332 | 0.01074835415826952 | 0.00977428456267634 | 0.01219266424828698 | 0.00916968964127368 | 0.006952841596130592 | 0.008061265618702136 | 0.007658202337767029 | 0.006751309955663039 | 0.003325272067714631
 | 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 | 8706.905660377357 | 7099.476923076923 | 8390.29090909091 | 8095.894736842106 | 5484.315789473684 | 3222.742268041237 | 4530.521739130435 | 1894.581818181818 | 4213.018867924528 | 1440.58064516129 | 2261.164556962025 | 5582.25 | 3464.844827586207 | 1897.235294117647 | 1539.931034482759 | 1535.857142857143 | 3771.12 | 2749.643312101911 | 5103.771428571429 | 6761.198473282444 | 2899.87012987013 | 2007.448132780083 | 4800.821345707657 | 3495.73385518591 | 3990.962818003914 | 3874.880694143168 | 2664.325123152709 | 2817.618090452261 | 1827.640569395018 | 1713.705365853658 | 2237.202312138728 | 3223.831952662722 | 2791.125 | 3385.219879518072 | 8429.715220949263 | 3689.473321858864 | 4429.35593220339 | 2182.697947214076 | 3207.652719665272 | 4561.83870967742 | 3040.098591549295 | 3911.649635036497 | 2458.238532110092 | 3349.35 | 2148.494845360824 | 3772.760330578512 | 4580.307692307692 | 3164.173913043478 | 3721.5 | 783.4736842105264 | 2221.79104477612 | 3007.272727272727
 | 2016 | 2246.943396226415 | 2748.184615384615 | 3247.854545454546 | 2611.578947368421 | 2089.263157894737 | 4910.845360824742 | 6040.695652173914 | 9021.818181818182 | 5055.622641509433 | 4801.935483870968 | 5652.911392405063 | 4341.75 | 2823.206896551724 | 5253.882352941177 | 5133.103448275862 | 7088.571428571428 | 4664.28 | 7585.222929936305 | 6190.685714285714 | 2670.3893129771 | 4446.467532467533 | 4910.526970954357 | 4075.517401392111 | 4020.093933463796 | 3728.782778864971 | 4843.60086767896 | 8139.635467980295 | 8004.030150753769 | 6489.448398576512 | 1917.026341463415 | 3764.523121387283 | 4051.810650887574 | 3693.306818181818 | 2443.635542168674 | 1900.340425531915 | 4355.628227194492 | 5018.067796610169 | 7464.826979472141 | 6010.456066945606 | 5007.73271889401 | 5398.795774647887 | 6465.087591240876 | 8103.082568807339 | 9768.9375 | 7775.505154639175 | 6151.239669421488 | 5343.692307692308 | 6759.826086956522 | 6202.5 | 9140.526315789473 | 7702.208955223881 | 6916.727272727273
 | 2017 | 3932.150943396226 | 5038.338461538461 | 3247.854545454546 | 4178.526315789474 | 7312.421052631579 | 6752.41237113402 | 4314.782608695653 | 3969.6 | 5617.358490566037 | 8643.483870967742 | 6971.924050632912 | 4962 | 8597.948275862069 | 7734.882352941177 | 8212.96551724138 | 6261.571428571428 | 6450.6 | 4551.133757961783 | 3591.542857142857 | 5454.412213740458 | 7539.662337662337 | 7968.024896265561 | 6009.661252900232 | 7370.172211350294 | 7166.254403131115 | 6167.518438177874 | 4082.039408866995 | 4064.35175879397 | 6568.91103202847 | 11255.26829268293 | 8884.274566473989 | 7610.357396449704 | 8401.568181818182 | 9057.144578313253 | 4555.944353518822 | 6840.898450946644 | 5438.576271186441 | 5238.475073313783 | 5667.891213389121 | 5316.428571428572 | 6447.105633802817 | 4509.262773722628 | 4324.678899082569 | 1767.7125 | 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) | 8706.905660377357 | 7099.476923076923 | 8390.29090909091 | 8095.894736842106 | 5484.315789473684 | 3222.742268041237 | 4530.521739130435 | 1894.581818181818 | 4213.018867924528 | 1440.58064516129 | 2261.164556962025 | 5582.25 | 3464.844827586207 | 1897.235294117647 | 1539.931034482759 | 1535.857142857143 | 3771.12 | 2749.643312101911 | 5103.771428571429 | 6761.198473282444 | 2899.87012987013 | 2007.448132780083 | 4800.821345707657 | 3495.73385518591 | 3990.962818003914 | 3874.880694143168 | 2664.325123152709 | 2817.618090452261 | 1827.640569395018 | 1713.705365853658 | 2237.202312138728 | 3223.831952662722 | 2791.125 | 3385.219879518072 | 8429.715220949263 | 3689.473321858864 | 4429.35593220339 | 2182.697947214076 | 3207.652719665272 | 4561.83870967742 | 3040.098591549295 | 3911.649635036497 | 2458.238532110092 | 3349.35 | 2148.494845360824 | 3772.760330578512 | 4580.307692307692 | 3164.173913043478 | 3721.5 | 783.4736842105264 | 2221.79104477612 | 3007.272727272727
 | 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 | 75810206.17871127 | 50402572.58130176 | 70396981.53917357 | 65543511.59002771 | 30077719.67867036 | 10386067.72621958 | 20525627.22873346 | 3589440.265785124 | 17749527.98148807 | 2075272.595213319 | 5112865.153661271 | 31161515.0625 | 12005149.67925089 | 3599501.761245675 | 2371387.590963139 | 2358857.163265306 | 14221346.0544 | 7560538.343786767 | 26048482.79510205 | 45713804.79511685 | 8409246.770113004 | 4029848.005802242 | 23047885.59340228 | 12220155.18629295 | 15927784.21468974 | 15014700.39384344 | 7098628.3618627 | 7938971.703643846 | 3340270.050898545 | 2936786.080955621 | 5005074.185438872 | 10393092.45900914 | 7790378.765625 | 11459713.63268435 | 71060098.70630369 | 13612213.39270828 | 19619193.97414536 | 4764170.328772541 | 10289035.96997602 | 20810372.41311134 | 9242199.446340008 | 15301002.86728116 | 6042936.68075078 | 11218145.4225 | 4616030.100542033 | 14233720.51198689 | 20979218.55621302 | 10011996.55198488 | 13849562.25 | 613831.0138504156 | 4936355.446647361 | 9043689.256198348
 | sum x*y | 8706.905660377357 | 14198.95384615385 | 25170.87272727273 | 32383.57894736842 | 27421.57894736842 | 19336.45360824742 | 31713.65217391304 | 15156.65454545454 | 37917.16981132075 | 14405.8064516129 | 24872.81012658228 | 66987 | 45042.98275862069 | 26561.29411764706 | 23098.96551724138 | 24573.71428571429 | 64109.04 | 49493.5796178344 | 96971.65714285715 | 135223.9694656489 | 60897.27272727273 | 44163.85892116183 | 110418.8909512761 | 83897.61252446185 | 99774.07045009785 | 100746.8980477224 | 71936.77832512314 | 78893.30653266331 | 53001.57651245552 | 51411.16097560975 | 69353.27167630057 | 103162.6224852071 | 92107.125 | 115097.4759036145 | 295040.0327332242 | 132821.0395869191 | 163886.1694915254 | 82942.52199413489 | 125098.4560669456 | 182473.5483870968 | 124644.0422535211 | 164289.2846715329 | 105704.256880734 | 147371.4 | 96682.2680412371 | 173546.9752066116 | 215274.4615384615 | 151880.347826087 | 182353.5 | 39173.68421052632 | 113311.3432835821 | 156378.1818181818
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) | 2246.943396226415 | 2748.184615384615 | 3247.854545454546 | 2611.578947368421 | 2089.263157894737 | 4910.845360824742 | 6040.695652173914 | 9021.818181818182 | 5055.622641509433 | 4801.935483870968 | 5652.911392405063 | 4341.75 | 2823.206896551724 | 5253.882352941177 | 5133.103448275862 | 7088.571428571428 | 4664.28 | 7585.222929936305 | 6190.685714285714 | 2670.3893129771 | 4446.467532467533 | 4910.526970954357 | 4075.517401392111 | 4020.093933463796 | 3728.782778864971 | 4843.60086767896 | 8139.635467980295 | 8004.030150753769 | 6489.448398576512 | 1917.026341463415 | 3764.523121387283 | 4051.810650887574 | 3693.306818181818 | 2443.635542168674 | 1900.340425531915 | 4355.628227194492 | 5018.067796610169 | 7464.826979472141 | 6010.456066945606 | 5007.73271889401 | 5398.795774647887 | 6465.087591240876 | 8103.082568807339 | 9768.9375 | 7775.505154639175 | 6151.239669421488 | 5343.692307692308 | 6759.826086956522 | 6202.5 | 9140.526315789473 | 7702.208955223881 | 6916.727272727273
 | 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 | 5048754.625845495 | 7552518.680236687 | 10548559.14842975 | 6820344.598337951 | 4365020.542936289 | 24116402.15793389 | 36490003.96219283 | 81393203.30578512 | 25559320.29334282 | 23058584.3912591 | 31955407.21038295 | 18850793.0625 | 7970497.180737218 | 27603279.77854671 | 26348751.01070155 | 50247844.89795918 | 21755507.9184 | 57535606.89683151 | 38324589.61306123 | 7130979.082862305 | 19771073.51728791 | 24113275.13247018 | 16609842.08904991 | 16161155.23387242 | 13903821.01195997 | 23460469.36538037 | 66253665.5516028 | 64064498.6541754 | 42112940.51778726 | 3674989.993864604 | 14171634.33145946 | 16417169.55064599 | 13640515.2532283 | 5971354.662949991 | 3611293.732910819 | 18971497.25353343 | 25181004.41137604 | 55723641.83345517 | 36125582.13268324 | 25077386.98388159 | 29146995.81635588 | 41797357.56241675 | 65659947.11690935 | 95432139.87890625 | 60458480.40982039 | 37837749.47066458 | 28555047.47928994 | 45695248.72589792 | 38471006.25 | 83549221.32963988 | 59324022.78993095 | 47841116.16528926
 | sum x*y | 119088 | 148401.9692307692 | 178632 | 146248.4210526316 | 119088 | 284829.030927835 | 356401.0434782609 | 541309.0909090909 | 308392.9811320754 | 297720 | 356133.417721519 | 277872 | 183508.4482758621 | 346756.2352941177 | 343917.9310344828 | 482022.8571428572 | 321835.32 | 530965.6050955413 | 439538.6857142857 | 192268.0305343512 | 324592.1298701299 | 363378.9958506224 | 305663.8051044084 | 305527.1389432485 | 287116.2739726027 | 377800.8676789589 | 643031.2019704434 | 640322.4120603015 | 525645.3202846975 | 157196.16 | 312455.4190751445 | 340352.0946745562 | 313931.0795454545 | 210152.656626506 | 165329.6170212766 | 383295.2839931153 | 446608.0338983051 | 671834.4281524927 | 546951.5020920502 | 460711.4101382489 | 502088.0070422535 | 607718.2335766423 | 769792.8440366972 | 937818 | 754224 | 602821.4876033058 | 529025.5384615385 | 675982.6086956522 | 626452.5 | 932333.6842105263 | 793327.5223880598 | 719339.6363636364
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) | 3932.150943396226 | 5038.338461538461 | 3247.854545454546 | 4178.526315789474 | 7312.421052631579 | 6752.41237113402 | 4314.782608695653 | 3969.6 | 5617.358490566037 | 8643.483870967742 | 6971.924050632912 | 4962 | 8597.948275862069 | 7734.882352941177 | 8212.96551724138 | 6261.571428571428 | 6450.6 | 4551.133757961783 | 3591.542857142857 | 5454.412213740458 | 7539.662337662337 | 7968.024896265561 | 6009.661252900232 | 7370.172211350294 | 7166.254403131115 | 6167.518438177874 | 4082.039408866995 | 4064.35175879397 | 6568.91103202847 | 11255.26829268293 | 8884.274566473989 | 7610.357396449704 | 8401.568181818182 | 9057.144578313253 | 4555.944353518822 | 6840.898450946644 | 5438.576271186441 | 5238.475073313783 | 5667.891213389121 | 5316.428571428572 | 6447.105633802817 | 4509.262773722628 | 4324.678899082569 | 1767.7125 | 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 | 15461811.04165183 | 25384854.45301775 | 10548559.14842975 | 17460082.17174516 | 53471501.65096954 | 45595072.82984376 | 18617348.96030246 | 15757724.16 | 31554716.41153435 | 74709813.42767951 | 48607724.96779362 | 24621444 | 73924714.55439952 | 59828405.01384083 | 67452802.58739598 | 39207276.75510204 | 41610240.36000001 | 20712818.48285934 | 12899180.09469388 | 29750612.59740109 | 56846508.1659639 | 63489420.74750781 | 36116028.37461039 | 54319438.42496008 | 51355202.1703961 | 38038283.68526405 | 16663045.73554321 | 16518955.21921163 | 43150592.14670534 | 126681064.3402736 | 78930334.57249658 | 57917539.70169671 | 70586347.91373967 | 82031867.91246915 | 20756628.95236004 | 46797891.61616419 | 29578111.85751221 | 27441621.09372984 | 32124990.8068136 | 28264412.75510204 | 41565171.05341202 | 20333450.76248069 | 18702847.58017002 | 3124807.482656249 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 412875.8490566037 | 534063.8769230769 | 347520.4363636364 | 451280.8421052632 | 797053.8947368421 | 742765.3608247422 | 478940.8695652175 | 444595.2 | 634761.5094339622 | 985357.1612903227 | 801771.2658227849 | 575592 | 1005959.948275862 | 912716.1176470588 | 977342.8965517243 | 751388.5714285714 | 780522.6000000001 | 555238.3184713376 | 441759.7714285715 | 676347.1145038168 | 942457.7922077922 | 1003971.136929461 | 763226.9791183295 | 943382.0430528376 | 924446.8180039139 | 801777.3969631237 | 534747.1625615763 | 536494.4321608039 | 873665.1672597865 | 1508205.951219512 | 1199377.066473989 | 1035008.60591716 | 1151014.840909091 | 1249885.951807229 | 633276.2651391162 | 957725.78313253 | 766839.2542372881 | 743863.4604105571 | 810508.4435146443 | 765565.7142857143 | 934830.3169014084 | 658352.3649635038 | 635727.7981651376 | 261621.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 734376.0000000003 |  | 67.42996989864436 | -2076.622985881782
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 4331539063.365068
 | sum x*y | 60722654.835413
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) | 8509.882288205383 | 8577.312258104026 | 8644.742228002671 | 8712.172197901315 | 8779.60216779996 | 8847.032137698603 | 8914.462107597248 | 8981.892077495893 | 9049.322047394537 | 9116.752017293182 | 9184.181987191825 | 9251.61195709047 | 9319.041926989114 | 9386.471896887759 | 9453.901866786404 | 9521.331836685047 | 9588.761806583692 | 9656.191776482336 | 9723.62174638098 | 9791.051716279624 | 9858.48168617827 | 9925.911656076914 | 9993.341625975558 | 10060.7715958742 | 10128.20156577285 | 10195.63153567149 | 10263.06150557013 | 10330.49147546878 | 10397.92144536742 | 10465.35141526607 | 10532.78138516471 | 10600.21135506336 | 10667.641324962 | 10735.07129486065 | 10802.50126475929 | 10869.93123465794 | 10937.36120455658 | 11004.79117445522 | 11072.22114435387 | 11139.65111425251 | 11207.08108415116 | 11274.5110540498 | 11341.94102394844 | 11409.37099384709 | 11476.80096374573 | 11544.23093364438 | 11611.66090354302 | 11679.09087344167 | 11746.52084334031 | 11813.95081323895 | 11881.3807831376 | 11948.81075303624
 | Seasonal Indices | 0.001780196157463389 | 0.002183259438398495 | 0.001847373370952573 | 0.001914550584441757 | 0.0009572752922208786 | 0.001629047427112723 | 0.001158806932688432 | 0.00277106005642886 | 0.003560392314926777 | 0.002082493618164719 | 0.005306999865645573 | 0.008061265618702136 | 0.007792556764745398 | 0.006852075775896816 | 0.005844417573559049 | 0.008464328899637243 | 0.01007658202337767 | 0.01054682251780196 | 0.02116082224909311 | 0.01760042993416633 | 0.02069058175466882 | 0.03237941690178691 | 0.0289533790138385 | 0.03432755609297326 | 0.03432755609297326 | 0.03096869541851404 | 0.04091092301491334 | 0.04010479645304313 | 0.03775359398092167 | 0.06885664382641409 | 0.04648663173451565 | 0.05676474539836088 | 0.0354695687222894 | 0.04460566975681849 | 0.04104527744189171 | 0.03902996103721618 | 0.03567110036275695 | 0.04581485959962381 | 0.03211070804783018 | 0.02915491065430606 | 0.01907832863092839 | 0.01840655649603654 | 0.02196694881096332 | 0.01074835415826952 | 0.00977428456267634 | 0.01219266424828698 | 0.00916968964127368 | 0.006952841596130592 | 0.008061265618702136 | 0.007658202337767029 | 0.006751309955663039 | 0.003325272067714631
 | Forecast Sales | 15.14925974992897 | 18.72649794359673 | 15.97006659076135 | 16.67989437324919 | 8.404496230763765 | 14.41223494150149 | 10.33014049147202 | 24.8893623671037 | 32.21913667284096 | 18.98557789440337 | 48.74045257209151 | 74.579701387267 | 72.61916320910501 | 64.31681670580085 | 55.25255020894915 | 80.5916842282894 | 96.62194484667162 | 101.842140864418 | 205.7598313925842 | 172.3267197141785 | 203.9777213047768 | 321.3952316424205 | 289.3410077116395 | 345.3617012959638 | 347.676407370007 | 315.7454076276069 | 419.8713191517004 | 414.3022578835726 | 392.55890449392 | 720.6089749192342 | 489.6335293923137 | 601.7182987389854 | 378.3766370804741 | 478.8450449944558 | 443.3916614784312 | 424.2529925659184 | 390.147709231462 | 504.1829625808453 | 355.5368606073592 | 324.7755329561729 | 213.812375916897 | 207.5249246815562 | 249.1478378900404 | 122.631960164956 | 112.1775184888489 | 140.7549317786145 | 106.475326705201 | 81.20286882985438 | 94.69182461378728 | 90.47362573621126 | 80.2148843682204 | 39.73304663947965