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

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 | 22 | 22 | 22 | 22 | 13.25 | 13.25 | 13.25 | 13.25 | 18 | 30 | 44 | 31 | 45 | 26 | 31 | 74 | 59 | 88 | 209 | 254 | 185 | 129 | 301 | 215 | 227 | 236 | 190 | 236 | 186 | 254 | 139 | 163 | 164 | 144 | 176 | 168 | 237 | 240 | 179 | 176 | 177 | 167 | 133 | 123 | 93 | 89 | 57 | 70 | 61 | 39 | 33 | 39 |  | 5935
 | 2016 | 33 | 15 | 30 | 17 | 14 | 17 | 18 | 89 | 37 | 69 | 75 | 93 | 97 | 78 | 109 | 123 | 107 | 165 | 248 | 107 | 200 | 436 | 365 | 358 | 318 | 348 | 630 | 379 | 565 | 356 | 285 | 295 | 268 | 246 | 206 | 299 | 326 | 339 | 420 | 299 | 269 | 253 | 254 | 209 | 160 | 162 | 123 | 142 | 109 | 126 | 86 | 71 |  | 10210
 | 2017 | 33 | 41 | 29 | 21 | 20 | 23 | 35 | 11 | 76 | 80 | 62 | 66 | 85 | 82 | 90 | 151 | 192 | 162 | 208 | 278 | 415 | 532 | 468 | 492 | 553 | 376 | 320 | 293 | 288 | 538 | 310 | 473 | 260 | 264 | 203 | 327 | 276 | 341 | 317 | 308 | 246 | 225 | 182 | 40 |  |  |  |  |  |  |  |  |  | 9792
 | 2018 | 50.43182148502839 | 45.05334162747314 | 47.15212559715147 | 35.19858424815105 | 27.93236359249955 | 31.71991727555857 | 39.76306854743436 | 68.48401050230063 | 79.8095738219613 | 109.8615097977682 | 111.9067821814168 | 118.3296398664995 | 142.3983806602276 | 117.5192091495837 | 146.3586067631801 | 223.0192215241132 | 231.0452865518109 | 269.7068229129547 | 435.1853248006882 | 421.0576027539618 | 530.7601192937826 | 732.7611291646134 | 762.5994369588053 | 721.0096214695834 | 748.3115983164936 | 658.5988476178692 | 787.2367238567356 | 631.1295465612845 | 726.8788481652633 | 808.3214025482011 | 520.1349950302795 | 663.9415764176073 | 496.6255019141429 | 472.3089728068832 | 425.121276727548 | 580.5895538536795 | 617.2851585973943 | 681.0366492373838 | 682.2141664297899 | 586.6966964110221 | 521.6375010641569 | 489.1225153437156 | 434.0602528679116 | 285.4600061810598 | 292.9298533129519 | 292.3152531801197 | 210.8483455421969 | 249.7692400316378 | 201.4387609170717 | 196.6323121773279 | 142.6200812865591 | 132.57916905021 |  | 19034.90830599304
 | Total | 88 | 78 | 81 | 60 | 47.25 | 53.25 | 66.25 | 113.25 | 131 | 179 | 181 | 190 | 227 | 186 | 230 | 348 | 358 | 415 | 665 | 639 | 800 | 1097 | 1134 | 1065 | 1098 | 960 | 1140 | 908 | 1039 | 1148 | 734 | 931 | 692 | 654 | 585 | 794 | 839 | 920 | 916 | 783 | 692 | 645 | 569 | 372 | 253 | 251 | 180 | 212 | 170 | 165 | 119 | 110 |  | 25937
 | Weekly Average | 29.33333333333333 | 26 | 27 | 20 | 15.75 | 17.75 | 22.08333333333333 | 37.75 | 43.66666666666666 | 59.66666666666666 | 60.33333333333334 | 63.33333333333334 | 75.66666666666667 | 62 | 76.66666666666667 | 116 | 119.3333333333333 | 138.3333333333333 | 221.6666666666667 | 213 | 266.6666666666667 | 365.6666666666667 | 378 | 355 | 366 | 320 | 380 | 302.6666666666667 | 346.3333333333333 | 382.6666666666667 | 244.6666666666667 | 310.3333333333333 | 230.6666666666667 | 218 | 195 | 264.6666666666667 | 279.6666666666667 | 306.6666666666667 | 305.3333333333333 | 261 | 230.6666666666667 | 215 | 189.6666666666667 | 124 | 126.5 | 125.5 | 90 | 106 | 85 | 82.5 | 59.5 | 55 |  | 8645.666666666666
 | Seasonal Indices | 0.003392836488414235 | 0.003007286887458072 | 0.003122951767744921 | 0.002313297605736978 | 0.00182172186451787 | 0.002053051625091568 | 0.00255426610633458 | 0.004366349230828547 | 0.005050699772525736 | 0.006901337857115318 | 0.006978447777306551 | 0.007325442418167098 | 0.008751975941704902 | 0.007171222577784632 | 0.00886764082199175 | 0.01341712611327447 | 0.01380267571423064 | 0.01600030843968077 | 0.02563904846358484 | 0.02463661950109882 | 0.03084396807649304 | 0.04229479122489109 | 0.04372132474842889 | 0.04106103250183137 | 0.0423333461849867 | 0.03701276169179165 | 0.04395265450900258 | 0.03500790376681961 | 0.04005860353934534 | 0.04426109418976752 | 0.02829934071018237 | 0.03589466784901878 | 0.02668003238616648 | 0.02521494390253306 | 0.02255465165593554 | 0.03061263831591935 | 0.03234761152022208 | 0.035470563287967 | 0.03531634344758453 | 0.03018853375486756 | 0.02668003238616648 | 0.02486794926167252 | 0.02193777229440567 | 0.01434244515556926 | 0.01463160735628639 | 0.01451594247599954 | 0.0104098392258164 | 0.01226047731040598 | 0.009831514824382158 | 0.009542352623665035 | 0.006882060377067511 | 0.00636156841577669
 | 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 | 6484.25 | 7315.564102564103 | 7044.617283950616 | 9510.233333333334 | 7273.338624338624 | 6453.807511737089 | 5187.4 | 3034.571743929359 | 3563.862595419847 | 4346.983240223463 | 6305.127071823204 | 4231.826315789473 | 5141.69603524229 | 3625.602150537634 | 3495.85652173913 | 5515.33908045977 | 4274.533519553072 | 5499.893975903613 | 8151.628571428571 | 10309.85602503912 | 5997.93125 | 3050.020966271649 | 6884.512345679012 | 5236.107981220656 | 5362.203096539162 | 6376.179166666667 | 4322.833333333333 | 6741.334801762113 | 4643.197305101058 | 5738.674216027874 | 4911.775204359673 | 4541.064446831364 | 6146.919075144508 | 5710.899082568807 | 7803.268376068376 | 5487.929471032745 | 7326.661501787842 | 6766.173913043477 | 5068.474890829694 | 5830.02809706258 | 6634.174855491329 | 6715.471317829457 | 6062.602811950791 | 8575.943548387097 | 6356.102766798419 | 6131.189907038512 | 5475.588888888889 | 5709.40251572327 | 6204.53725490196 | 4087.042424242424 | 4795.0756302521 | 6130.563636363637
 | 2016 | 9726.375 | 4987.884615384615 | 9606.296296296296 | 7348.816666666667 | 7685.037037037036 | 8280.356807511736 | 7047.033962264151 | 20383.16114790287 | 7325.717557251908 | 9998.061452513966 | 10747.37569060773 | 12695.47894736842 | 11083.21145374449 | 10876.8064516129 | 12291.88260869565 | 9167.387931034482 | 7752.120111731843 | 10312.30120481927 | 9672.745864661654 | 4343.128325508607 | 6484.249999999999 | 10308.59799453054 | 8348.328924162257 | 8718.728638497652 | 7511.808743169398 | 9402.1625 | 14333.6052631579 | 10826.12665198238 | 14104.33589990375 | 8043.181184668988 | 10070.90599455041 | 8218.490870032223 | 10044.96531791908 | 9756.119266055046 | 9133.37094017094 | 9767.20780856423 | 10078.02383790226 | 9557.220652173912 | 11892.51091703057 | 9904.422733077905 | 10082.44653179191 | 10173.73798449612 | 11578.20386643234 | 14572.13172043011 | 10935.23056653491 | 11160.14342629482 | 11815.74444444444 | 11581.93081761006 | 11086.79607843137 | 13204.29090909091 | 12496.25770308123 | 11160.7696969697
 | 2017 | 9726.375 | 13633.55128205128 | 9286.086419753086 | 9077.949999999999 | 10978.62433862434 | 11202.83568075117 | 13702.56603773585 | 2519.26710816777 | 15047.41984732824 | 11591.95530726257 | 8884.49723756906 | 9009.694736842104 | 9712.092511013214 | 11434.59139784946 | 10149.26086956522 | 11254.27298850575 | 13910.34636871508 | 10124.80481927711 | 8112.625563909774 | 11284.01564945227 | 13454.81875 | 12578.38103919781 | 10704.15873015873 | 11982.16338028169 | 13062.98816029144 | 10158.65833333333 | 7280.561403508772 | 8369.538546255506 | 7189.466794995187 | 12155.14459930313 | 10954.31880108992 | 13177.44468313641 | 9745.115606936417 | 10469.98165137615 | 9000.360683760684 | 10681.86272040302 | 8532.314660309892 | 9613.605434782608 | 8976.014192139737 | 10202.54916985951 | 9220.378612716762 | 9047.790697674418 | 8296.193321616873 | 2788.924731182796 | 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) | 6484.25 | 7315.564102564103 | 7044.617283950616 | 9510.233333333334 | 7273.338624338624 | 6453.807511737089 | 5187.4 | 3034.571743929359 | 3563.862595419847 | 4346.983240223463 | 6305.127071823204 | 4231.826315789473 | 5141.69603524229 | 3625.602150537634 | 3495.85652173913 | 5515.33908045977 | 4274.533519553072 | 5499.893975903613 | 8151.628571428571 | 10309.85602503912 | 5997.93125 | 3050.020966271649 | 6884.512345679012 | 5236.107981220656 | 5362.203096539162 | 6376.179166666667 | 4322.833333333333 | 6741.334801762113 | 4643.197305101058 | 5738.674216027874 | 4911.775204359673 | 4541.064446831364 | 6146.919075144508 | 5710.899082568807 | 7803.268376068376 | 5487.929471032745 | 7326.661501787842 | 6766.173913043477 | 5068.474890829694 | 5830.02809706258 | 6634.174855491329 | 6715.471317829457 | 6062.602811950791 | 8575.943548387097 | 6356.102766798419 | 6131.189907038512 | 5475.588888888889 | 5709.40251572327 | 6204.53725490196 | 4087.042424242424 | 4795.0756302521 | 6130.563636363637
 | 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 | 42045498.0625 | 53517478.13872452 | 49626632.67733575 | 90444538.05444445 | 52901454.74429607 | 41651631.39855408 | 26909118.76 | 9208625.669054473 | 12701116.59903269 | 18896263.29078368 | 39754627.39183784 | 17908353.96700831 | 26437038.11882629 | 13144990.95398312 | 12221012.82058601 | 30418965.17244682 | 18271636.80978278 | 30248833.74618085 | 66449048.36653061 | 106293131.2570355 | 35975179.27972656 | 9302627.894696645 | 47396510.23780674 | 27416826.79100266 | 28753222.04853418 | 40655660.76543403 | 18686888.02777778 | 45445594.90944903 | 21559281.21409773 | 32932381.75770313 | 24125535.65816251 | 20621266.31027584 | 37784614.11637542 | 32614368.33128524 | 60890997.34894878 | 30117369.87902974 | 53679968.76178008 | 45781109.42155008 | 25689437.71897108 | 33989227.61253913 | 44012276.0132334 | 45097555.0205901 | 36755152.85547364 | 73546807.74512227 | 40400042.38210252 | 37591489.67617092 | 29982073.68012345 | 32597277.0865472 | 38496282.54746635 | 16703915.77755739 | 22992750.29983758 | 37583810.49950413
 | sum x*y | 6484.25 | 14631.12820512821 | 21133.85185185185 | 38040.93333333333 | 36366.69312169312 | 38722.84507042253 | 36311.8 | 24276.57395143488 | 32074.76335877862 | 43469.83240223464 | 69356.39779005524 | 50781.91578947369 | 66842.04845814977 | 50758.43010752688 | 52437.84782608695 | 88245.42528735632 | 72667.06983240224 | 98998.09156626504 | 154880.9428571429 | 206197.1205007825 | 125956.55625 | 67100.46125797629 | 158343.7839506173 | 125666.5915492958 | 134055.0774134791 | 165780.6583333333 | 116716.5 | 188757.3744493392 | 134652.7218479307 | 172160.2264808362 | 152265.0313351499 | 145314.0622986036 | 202848.3294797688 | 194170.5688073394 | 273114.3931623931 | 197565.4609571788 | 271086.4755661502 | 257114.6086956521 | 197670.5207423581 | 233201.1238825032 | 272001.1690751445 | 282049.7953488372 | 260691.920913884 | 377341.5161290322 | 286024.6245059288 | 282034.7357237715 | 257352.6777777777 | 274051.320754717 | 304022.3254901961 | 204352.1212121212 | 244548.8571428571 | 318789.3090909091
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) | 9726.375 | 4987.884615384615 | 9606.296296296296 | 7348.816666666667 | 7685.037037037036 | 8280.356807511736 | 7047.033962264151 | 20383.16114790287 | 7325.717557251908 | 9998.061452513966 | 10747.37569060773 | 12695.47894736842 | 11083.21145374449 | 10876.8064516129 | 12291.88260869565 | 9167.387931034482 | 7752.120111731843 | 10312.30120481927 | 9672.745864661654 | 4343.128325508607 | 6484.249999999999 | 10308.59799453054 | 8348.328924162257 | 8718.728638497652 | 7511.808743169398 | 9402.1625 | 14333.6052631579 | 10826.12665198238 | 14104.33589990375 | 8043.181184668988 | 10070.90599455041 | 8218.490870032223 | 10044.96531791908 | 9756.119266055046 | 9133.37094017094 | 9767.20780856423 | 10078.02383790226 | 9557.220652173912 | 11892.51091703057 | 9904.422733077905 | 10082.44653179191 | 10173.73798449612 | 11578.20386643234 | 14572.13172043011 | 10935.23056653491 | 11160.14342629482 | 11815.74444444444 | 11581.93081761006 | 11086.79607843137 | 13204.29090909091 | 12496.25770308123 | 11160.7696969697
 | 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 | 94602370.640625 | 24878992.93639053 | 92280928.53223592 | 54005106.40027778 | 59059794.260631 | 68564308.85970595 | 49660687.66530439 | 415473258.381377 | 53666137.72862887 | 99961232.80824569 | 115506084.2350661 | 161175185.7030748 | 122837576.1284131 | 118304918.5858481 | 151090378.0659546 | 84041001.47807668 | 60095366.22671732 | 106343556.1389171 | 93562012.56232913 | 18862763.6518352 | 42045498.06249999 | 106267192.612839 | 69694595.82600415 | 76016229.07175912 | 56427270.59395622 | 88400659.67640625 | 205452239.8400277 | 117205018.2847631 | 198932291.1773138 | 64692763.56941322 | 101423147.5510714 | 67543592.180803 | 100901328.2381971 | 95181863.13349044 | 83418464.73075901 | 95398348.37567806 | 101566564.4773263 | 91340466.59433953 | 141431815.9116912 | 98097589.67551039 | 101655728.0664427 | 103504944.5771792 | 134054804.7726687 | 212347022.8775653 | 119579267.5432795 | 124548801.2954715 | 139611816.7764197 | 134141121.4639057 | 122917047.2847212 | 174353298.4119008 | 156156456.581817 | 124562780.2287971
 | sum x*y | 515497.875 | 269345.7692307692 | 528346.2962962963 | 411533.7333333333 | 438047.1111111111 | 480260.6948356807 | 415775.0037735849 | 1222989.668874172 | 446868.7709923664 | 619879.8100558659 | 677084.6685082873 | 812510.6526315789 | 720408.744493392 | 717869.2258064516 | 823556.1347826086 | 623382.3793103448 | 534896.2877094971 | 721861.0843373492 | 686764.9563909775 | 312705.2394366197 | 473350.2499999999 | 762836.2515952596 | 626124.6693121693 | 662623.3765258216 | 578409.2732240437 | 733368.675 | 1132354.815789474 | 866090.1321585901 | 1142451.207892204 | 659540.857142857 | 835885.197547684 | 690353.2330827067 | 853822.0520231214 | 839026.256880734 | 794603.2717948718 | 859514.2871536522 | 896944.1215733014 | 860149.8586956521 | 1082218.493449782 | 911206.8914431672 | 937667.5274566474 | 956331.3705426356 | 1099929.367311072 | 1398924.64516129 | 1060717.364953887 | 1093694.055776892 | 1169758.7 | 1158193.081761006 | 1119766.403921569 | 1346837.672727273 | 1287114.543417367 | 1160720.048484849
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) | 9726.375 | 13633.55128205128 | 9286.086419753086 | 9077.949999999999 | 10978.62433862434 | 11202.83568075117 | 13702.56603773585 | 2519.26710816777 | 15047.41984732824 | 11591.95530726257 | 8884.49723756906 | 9009.694736842104 | 9712.092511013214 | 11434.59139784946 | 10149.26086956522 | 11254.27298850575 | 13910.34636871508 | 10124.80481927711 | 8112.625563909774 | 11284.01564945227 | 13454.81875 | 12578.38103919781 | 10704.15873015873 | 11982.16338028169 | 13062.98816029144 | 10158.65833333333 | 7280.561403508772 | 8369.538546255506 | 7189.466794995187 | 12155.14459930313 | 10954.31880108992 | 13177.44468313641 | 9745.115606936417 | 10469.98165137615 | 9000.360683760684 | 10681.86272040302 | 8532.314660309892 | 9613.605434782608 | 8976.014192139737 | 10202.54916985951 | 9220.378612716762 | 9047.790697674418 | 8296.193321616873 | 2788.924731182796 | 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 | 94602370.640625 | 185873720.5603221 | 86231400.9951227 | 82409176.20249999 | 120530192.3686347 | 125503527.2899116 | 187760316.0185119 | 6346706.762295999 | 226424844.0617679 | 134373427.8455729 | 78934291.16437225 | 81174599.25108032 | 94324740.94247895 | 130749880.4357729 | 103007496.1984877 | 126658660.4998101 | 193497736.0976249 | 102511672.6284569 | 65814693.54020237 | 127329009.1770837 | 181032147.5953515 | 158215669.567251 | 114579014.1204333 | 143572239.2717635 | 170641659.6759143 | 103198339.1334028 | 53006574.35026162 | 70049175.47725673 | 51688432.79633837 | 147747540.2299681 | 119997100.3959121 | 173645048.3771201 | 94967278.19255573 | 109620515.7801532 | 81006492.43778509 | 114102191.1775358 | 72800393.4625391 | 92421409.45568171 | 80568830.77749398 | 104092009.5634011 | 85015381.76184468 | 81862516.50892372 | 68826823.6296404 | 7778101.15620303 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | sum x*y | 1021269.375 | 1445156.435897436 | 993611.2469135802 | 980418.5999999999 | 1196670.052910053 | 1232311.924882629 | 1520984.830188679 | 282157.9161147902 | 1700358.442748091 | 1321482.905027933 | 1021717.182320442 | 1045124.589473684 | 1136314.823788546 | 1349281.784946237 | 1207762.043478261 | 1350512.75862069 | 1683151.910614525 | 1235226.187951807 | 997852.9443609022 | 1399217.940532081 | 1681852.34375 | 1584876.010938924 | 1359428.158730159 | 1533716.912676056 | 1685125.472677596 | 1320625.583333333 | 953753.5438596491 | 1104779.088105727 | 956199.0837343599 | 1628789.37630662 | 1478833.038147139 | 1792132.476906552 | 1335080.838150289 | 1444857.467889908 | 1251050.135042735 | 1495460.780856423 | 1203056.367103695 | 1365131.97173913 | 1283570.029475982 | 1469167.08045977 | 1336954.898843931 | 1320977.441860465 | 1219540.41827768 | 412760.8602150538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  | Total
 | Cumulative Season (X) | 12246 |  | b | a
 | Sales (Y) | 1279558.666666667 |  | 117.1850111910971 | -3533.840463170639
 | sum x^2 | 1277666 |  | Sales=b(Season)+a
 | sum y^2 | 12415562535.69686
 | sum x*y | 106447894.1964966
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) | 14864.2062938316 | 14981.3913050227 | 15098.5763162138 | 15215.7613274049 | 15332.94633859599 | 15450.13134978709 | 15567.31636097819 | 15684.50137216928 | 15801.68638336038 | 15918.87139455148 | 16036.05640574258 | 16153.24141693367 | 16270.42642812477 | 16387.61143931587 | 16504.79645050696 | 16621.98146169806 | 16739.16647288916 | 16856.35148408026 | 16973.53649527135 | 17090.72150646245 | 17207.90651765355 | 17325.09152884464 | 17442.27654003574 | 17559.46155122684 | 17676.64656241794 | 17793.83157360903 | 17911.01658480013 | 18028.20159599123 | 18145.38660718232 | 18262.57161837342 | 18379.75662956452 | 18496.94164075562 | 18614.12665194671 | 18731.31166313781 | 18848.49667432891 | 18965.68168552 | 19082.8666967111 | 19200.0517079022 | 19317.2367190933 | 19434.42173028439 | 19551.60674147549 | 19668.79175266659 | 19785.97676385769 | 19903.16177504878 | 20020.34678623988 | 20137.53179743098 | 20254.71680862207 | 20371.90181981317 | 20489.08683100427 | 20606.27184219537 | 20723.45685338646 | 20840.64186457756
 | Seasonal Indices | 0.003392836488414235 | 0.003007286887458072 | 0.003122951767744921 | 0.002313297605736978 | 0.00182172186451787 | 0.002053051625091568 | 0.00255426610633458 | 0.004366349230828547 | 0.005050699772525736 | 0.006901337857115318 | 0.006978447777306551 | 0.007325442418167098 | 0.008751975941704902 | 0.007171222577784632 | 0.00886764082199175 | 0.01341712611327447 | 0.01380267571423064 | 0.01600030843968077 | 0.02563904846358484 | 0.02463661950109882 | 0.03084396807649304 | 0.04229479122489109 | 0.04372132474842889 | 0.04106103250183137 | 0.0423333461849867 | 0.03701276169179165 | 0.04395265450900258 | 0.03500790376681961 | 0.04005860353934534 | 0.04426109418976752 | 0.02829934071018237 | 0.03589466784901878 | 0.02668003238616648 | 0.02521494390253306 | 0.02255465165593554 | 0.03061263831591935 | 0.03234761152022208 | 0.035470563287967 | 0.03531634344758453 | 0.03018853375486756 | 0.02668003238616648 | 0.02486794926167252 | 0.02193777229440567 | 0.01434244515556926 | 0.01463160735628639 | 0.01451594247599954 | 0.0104098392258164 | 0.01226047731040598 | 0.009831514824382158 | 0.009542352623665035 | 0.006882060377067511 | 0.00636156841577669
 | Forecast Sales | 50.43182148502839 | 45.05334162747314 | 47.15212559715147 | 35.19858424815105 | 27.93236359249955 | 31.71991727555857 | 39.76306854743436 | 68.48401050230063 | 79.8095738219613 | 109.8615097977682 | 111.9067821814168 | 118.3296398664995 | 142.3983806602276 | 117.5192091495837 | 146.3586067631801 | 223.0192215241132 | 231.0452865518109 | 269.7068229129547 | 435.1853248006882 | 421.0576027539618 | 530.7601192937826 | 732.7611291646134 | 762.5994369588053 | 721.0096214695834 | 748.3115983164936 | 658.5988476178692 | 787.2367238567356 | 631.1295465612845 | 726.8788481652633 | 808.3214025482011 | 520.1349950302795 | 663.9415764176073 | 496.6255019141429 | 472.3089728068832 | 425.121276727548 | 580.5895538536795 | 617.2851585973943 | 681.0366492373838 | 682.2141664297899 | 586.6966964110221 | 521.6375010641569 | 489.1225153437156 | 434.0602528679116 | 285.4600061810598 | 292.9298533129519 | 292.3152531801197 | 210.8483455421969 | 249.7692400316378 | 201.4387609170717 | 196.6323121773279 | 142.6200812865591 | 132.57916905021