{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","HistData","DemoData","Method","Parameters","BestMethod"],"not_rendered":{"charts":2,"images":40,"macros":1,"external_links":0,"defined_names":143,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["©2011 Eksioglu, Seref, Ahuja, and Winston"]

{"sheet":"HistData","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Period","Demand"]
[null,1,23]
[null,2,24]
[null,3,34]
[null,4,45]
[null,5,67]
[null,6,89]
[null,7,97]
[null,8,99]
[null,9,70]
[null,10,60]

{"sheet":"DemoData","index":2,"n_rows":418,"n_cols":9,"rows_kept":418,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Period","Sales",null,"Period","Sales",null,"Period","Sales"]
[null,1,1646,null,1,12639,null,1,80]
[null,2,1738,null,2,11023,null,2,130]
[null,3,1883,null,3,12961,null,3,230]
[null,4,4868,null,4,12067,null,4,340]
[null,5,1924,null,5,12910,null,5,100]
[null,6,1989,null,6,14301,null,6,180]
[null,7,2142,null,7,14665,null,7,230]
[null,8,4383,null,8,15450,null,8,380]
[null,9,2043,null,9,12519,null,9,120]
[null,10,2020,null,10,12254,null,10,130]
[null,11,2171,null,11,11674,null,11,320]
[null,12,4338,null,12,13136,null,12,410]
[null,13,2186,null,13,12495,null,13,78.085521189804069]
[null,14,2204,null,14,11052,null,14,138.84513925742078]
[null,15,2465,null,15,12661,null,15,238.66741193013289]
[null,16,5027,null,16,13867,null,16,336.06915828933575]
[null,17,2319,null,17,13063,null,17,96.47791187542775]
[null,18,1994,null,18,13961,null,18,187.10350724268531]
[null,19,2220,null,19,14944,null,19,230.34479122307391]
[null,20,4200,null,20,15542,null,20,387.5458388101444]
[null,21,2061,null,21,12790,null,21,102.27769390684905]
[null,22,2021,null,22,13248,null,22,119.98899778292164]
[null,23,4074,null,23,12457,null,23,326.79264107456817]
[null,24,2644,null,24,14044,null,24,419.87191081735955]
[null,25,2874,null,25,13551,null,25,75.244016430191408]
[null,26,3714,null,26,12341,null,26,113.42387501630022]
[null,27,4292,null,27,14491,null,27,215.67680027340728]
[null,28,2953,null,28,14641,null,28,351.61483100599708]
[null,29,3605,null,29,14510,null,29,123.85097607766701]
[null,30,3093,null,30,15896,null,30,167.57814037290805]
[null,31,2987,null,31,16366,null,31,223.15620061445557]
[null,32,4292,null,32,17660,null,32,378.12603580097493]
[null,33,2905,null,33,14415,null,33,111.28404225189639]
[null,34,3995,null,34,14992,null,34,120.48402253274102]
[null,35,3653,null,35,14450,null,35,321.88100574882708]
[null,36,4256,null,36,15499,null,36,416.38580024974107]
[null,37,2351,null,37,14817]
[null,38,2327,null,38,13573]
[null,39,3115,null,39,15839]
[null,40,3257,null,40,16069]
[null,41,4080,null,41,15804]
[null,42,2552,null,42,17082]
[null,43,2329,null,43,17600]
[null,44,3744,null,44,18941]
[null,45,4256,null,45,15099]
[null,46,3111,null,46,15624]
[null,47,2703,null,47,15187]
[null,48,2446,null,48,15582]
[null,null,null,null,49,15334]
[null,null,null,null,50,14394]
[null,null,null,null,51,17190]
[null,null,null,null,52,17039]
[null,null,null,null,53,16631]
[null,null,null,null,54,17683]
[null,null,null,null,55,17726]
[null,null,null,null,56,19059]
[null,null,null,null,57,14981]
[null,null,null,null,58,15613]
[null,null,null,null,59,14055]
[null,null,null,null,60,15735]
[null,null,null,null,61,14773]
[null,null,null,null,62,13394]
[null,null,null,null,63,16199]
[null,null,null,null,64,15152]
[null,null,null,null,65,15745]
[null,null,null,null,66,17352]
[null,null,null,null,67,17996]
[null,null,null,null,68,19332]
[null,null,null,null,69,15188]
[null,null,null,null,70,16349]
[null,null,null,null,71,15154]
[null,null,null,null,72,16256]
[null,null,null,null,73,16025]
[null,null,null,null,74,15418]
[null,null,null,null,75,17297]
[null,null,null,null,76,17721]
[null,null,null,null,77,17414]
[null,null,null,null,78,18600]
[null,null,null,null,79,19663]
[null,null,null,null,80,20241]
[null,null,null,null,81,16631]
[null,null,null,null,82,17231]
[null,null,null,null,83,16087]
[null,null,null,null,84,17896]
[null,null,null,null,85,17306]
[null,null,null,null,86,15691]
[null,null,null,null,87,18784]
[null,null,null,null,88,18524]
[null,null,null,null,89,18325]
[null,null,null,null,90,19627]
[null,null,null,null,91,21054]
[null,null,null,null,92,21849]
[null,null,null,null,93,18221]
[null,null,null,null,94,19120]
[null,null,null,null,95,18225]
[null,null,null,null,96,19753]
[null,null,null,null,97,18741]
[null,null,null,null,98,17289]
[null,null,null,null,99,21904]
[null,null,null,null,100,20660]
[null,null,null,null,101,21131]
[null,null,null,null,102,23073]
[null,null,null,null,103,24207]
[null,null,null,null,104,25754]
[null,null,null,null,105,21163]
[null,null,null,null,106,21600]
[null,null,null,null,107,20993]
[null,null,null,null,108,21841]
[null,null,null,null,109,21721]
[null,null,null,null,110,20814]
[null,null,null,null,111,25927]
[null,null,null,null,112,23717]
[null,null,null,null,113,23562]
[null,null,null,null,114,26372]
[null,null,null,null,115,27980]
[null,null,null,null,116,29915]
[null,null,null,null,117,23394]
[null,null,null,null,118,24107]
[null,null,null,null,119,23391]
[null,null,null,null,120,23259]
[null,null,null,null,121,22428]
[null,null,null,null,122,21703]
[null,null,null,null,123,25388]
[null,null,null,null,124,23703]
[null,null,null,null,125,23093]
[null,null,null,null,126,25038]
[null,null,null,null,127,25603]
[null,null,null,null,128,26661]
[null,null,null,null,129,21058]
[null,null,null,null,130,22375]
[null,null,null,null,131,20290]
[null,null,null,null,132,22364]
[null,null,null,null,133,20869]
[null,null,null,null,134,19112]
[null,null,null,null,135,22549]
[null,null,null,null,136,22680]
[null,null,null,null,137,23600]
[null,null,null,null,138,23884]
[null,null,null,null,139,25178]
[null,null,null,null,140,23946]
[null,null,null,null,141,20732]
[null,null,null,null,142,22053]
[null,null,null,null,143,20693]
[null,null,null,null,144,22117]
[null,null,null,null,145,20919]
[null,null,null,null,146,19755]
[null,null,null,null,147,23919]
[null,null,null,null,148,23593]
[null,null,null,null,149,23542]
[null,null,null,null,150,25248]
[null,null,null,null,151,25814]
[null,null,null,null,152,26492]
[null,null,null,null,153,21606]
[null,null,null,null,154,23173]
[null,null,null,null,155,22173]
[null,null,null,null,156,23727]
[null,null,null,null,157,23114]
[null,null,null,null,158,22283]
[null,null,null,null,159,28320]
[null,null,null,null,160,25113]
[null,null,null,null,161,25549]
[null,null,null,null,162,27446]
[null,null,null,null,163,27345]
[null,null,null,null,164,27927]
[null,null,null,null,165,23642]
[null,null,null,null,166,25229]
[null,null,null,null,167,23917]
[null,null,null,null,168,24849]
[null,null,null,null,169,23408]
[null,null,null,null,170,22667]
[null,null,null,null,171,27563]
[null,null,null,null,172,26690]
[null,null,null,null,173,27490]
[null,null,null,null,174,28894]
[null,null,null,null,175,28709]
[null,null,null,null,176,30791]
[null,null,null,null,177,25634]
[null,null,null,null,178,27302]
[null,null,null,null,179,26169]
[null,null,null,null,180,26573]
[null,null,null,null,181,25619]
[null,null,null,null,182,24195]
[null,null,null,null,183,31520]
[null,null,null,null,184,30120]
[null,null,null,null,185,31143]
[null,null,null,null,186,31652]
[null,null,null,null,187,32834]
[null,null,null,null,188,33760]
[null,null,null,null,189,26593]
[null,null,null,null,190,28849]
[null,null,null,null,191,26852]
[null,null,null,null,192,30403]
[null,null,null,null,193,28168]
[null,null,null,null,194,27087]
[null,null,null,null,195,34032]
[null,null,null,null,196,31810]
[null,null,null,null,197,33292]
[null,null,null,null,198,34389]
[null,null,null,null,199,36311]
[null,null,null,null,200,38476]
[null,null,null,null,201,30573]
[null,null,null,null,202,32644]
[null,null,null,null,203,30913]
[null,null,null,null,204,33334]
[null,null,null,null,205,30692]
[null,null,null,null,206,31633]
[null,null,null,null,207,39613]
[null,null,null,null,208,38391]
[null,null,null,null,209,38363]
[null,null,null,null,210,38357]
[null,null,null,null,211,40886]
[null,null,null,null,212,41951]
[null,null,null,null,213,33352]
[null,null,null,null,214,35639]
[null,null,null,null,215,33687]
[null,null,null,null,216,34393]
[null,null,null,null,217,32141]
[null,null,null,null,218,32953]
[null,null,null,null,219,39852]
[null,null,null,null,220,36848]
[null,null,null,null,221,37788]
[null,null,null,null,222,39081]
[null,null,null,null,223,40576]
[null,null,null,null,224,42618]
[null,null,null,null,225,34908]
[null,null,null,null,226,37554]
[null,null,null,null,227,35829]
[null,null,null,null,228,35401]
[null,null,null,null,229,33246]
[null,null,null,null,230,31588]
[null,null,null,null,231,38387]
[null,null,null,null,232,35448]
[null,null,null,null,233,36956]
[null,null,null,null,234,40259]
[null,null,null,null,235,40809]
[null,null,null,null,236,43317]
[null,null,null,null,237,34684]
[null,null,null,null,238,37679]
[null,null,null,null,239,36177]
[null,null,null,null,240,35998]
[null,null,null,null,241,34137]
[null,null,null,null,242,33249]
[null,null,null,null,243,40164]
[null,null,null,null,244,37986]
[null,null,null,null,245,38033]
[null,null,null,null,246,40485]
[null,null,null,null,247,41739]
[null,null,null,null,248,44489]
[null,null,null,null,249,35470]
[null,null,null,null,250,38030]
[null,null,null,null,251,35840]
[null,null,null,null,252,35846]
[null,null,null,null,253,33323]
[null,null,null,null,254,30822]
[null,null,null,null,255,35947]
[null,null,null,null,256,36332]
[null,null,null,null,257,37277]
[null,null,null,null,258,38973]
[null,null,null,null,259,41114]
[null,null,null,null,260,42930]
[null,null,null,null,261,34636]
[null,null,null,null,262,37170]
[null,null,null,null,263,33801]
[null,null,null,null,264,36957]
[null,null,null,null,265,32493]
[null,null,null,null,266,31895]
[null,null,null,null,267,37389]
[null,null,null,null,268,35084]
[null,null,null,null,269,37136]
[null,null,null,null,270,42499]
[null,null,null,null,271,46150]
[null,null,null,null,272,47235]
[null,null,null,null,273,37825]
[null,null,null,null,274,37640]
[null,null,null,null,275,35393]
[null,null,null,null,276,36288]
[null,null,null,null,277,33678]
[null,null,null,null,278,32363]
[null,null,null,null,279,38771]
[null,null,null,null,280,38300]
[null,null,null,null,281,39071]
[null,null,null,null,282,40625]
[null,null,null,null,283,42659]
[null,null,null,null,284,43836]
[null,null,null,null,285,37737]
[null,null,null,null,286,40278]
[null,null,null,null,287,37450]
[null,null,null,null,288,37945]
[null,null,null,null,289,34888]
[null,null,null,null,290,33808]
[null,null,null,null,291,42244]
[null,null,null,null,292,40004]
[null,null,null,null,293,41589]
[null,null,null,null,294,43554]
[null,null,null,null,295,46157]
[null,null,null,null,296,46659]
[null,null,null,null,297,40267]
[null,null,null,null,298,42905]
[null,null,null,null,299,40926]
[null,null,null,null,300,41408]
[null,null,null,null,301,38200]
[null,null,null,null,302,35966]
[null,null,null,null,303,43632]
[null,null,null,null,304,41893]
[null,null,null,null,305,42447]
[null,null,null,null,306,44709]
[null,null,null,null,307,45403]
[null,null,null,null,308,46644]
[null,null,null,null,309,39612]
[null,null,null,null,310,42487]
[null,null,null,null,311,40630]
[null,null,null,null,312,40850]
[null,null,null,null,313,37859]
[null,null,null,null,314,39171]
[null,null,null,null,315,46336]
[null,null,null,null,316,43767]
[null,null,null,null,317,45261]
[null,null,null,null,318,47139]
[null,null,null,null,319,48453]
[null,null,null,null,320,49980]
[null,null,null,null,321,41858]
[null,null,null,null,322,45465]
[null,null,null,null,323,40916]
[null,null,null,null,324,44886]
[null,null,null,null,325,41244]
[null,null,null,null,326,39501]
[null,null,null,null,327,48726]
[null,null,null,null,328,45178]
[null,null,null,null,329,46496]
[null,null,null,null,330,48427]
[null,null,null,null,331,50446]
[null,null,null,null,332,50945]
[null,null,null,null,333,42930]
[null,null,null,null,334,46142]
[null,null,null,null,335,43293]
[null,null,null,null,336,45084]
[null,null,null,null,337,40826]
[null,null,null,null,338,40887]
[null,null,null,null,339,48495]
[null,null,null,null,340,47261]
[null,null,null,null,341,47875]
[null,null,null,null,342,49662]
[null,null,null,null,343,51889]
[null,null,null,null,344,51010]
[null,null,null,null,345,42669]
[null,null,null,null,346,46964]
[null,null,null,null,347,44540]
[null,null,null,null,348,45434]
[null,null,null,null,349,41488]
[null,null,null,null,350,40514]
[null,null,null,null,351,49787]
[null,null,null,null,352,47875]
[null,null,null,null,353,48023]
[null,null,null,null,354,50690]
[null,null,null,null,355,53517]
[null,null,null,null,356,52366]
[null,null,null,null,357,45096]
[null,null,null,null,358,49371]
[null,null,null,null,359,47581]
[null,null,null,null,360,45792]
[null,null,null,null,361,41776]
[null,null,null,null,362,43497]
[null,null,null,null,363,52601]
[null,null,null,null,364,50285]
[null,null,null,null,365,51599]
[null,null,null,null,366,54110]
[null,null,null,null,367,55312]
[null,null,null,null,368,54111]
[null,null,null,null,369,45988]
[null,null,null,null,370,49720]
[null,null,null,null,371,48311]
[null,null,null,null,372,46108]
[null,null,null,null,373,43743]
[null,null,null,null,374,42285]
[null,null,null,null,375,52014]
[null,null,null,null,376,50191]
[null,null,null,null,377,50492]
[null,null,null,null,378,53069]
[null,null,null,null,379,55350]
[null,null,null,null,380,55717]
[null,null,null,null,381,30418]
[null,null,null,null,382,38505]
[null,null,null,null,383,39037]
[null,null,null,null,384,39920]
[null,null,null,null,385,37762]
[null,null,null,null,386,37416]
[null,null,null,null,387,46948]
[null,null,null,null,388,43770]
[null,null,null,null,389,45366]
[null,null,null,null,390,47620]
[null,null,null,null,391,49648]
[null,null,null,null,392,50058]
[null,null,null,null,393,39043]
[null,null,null,null,394,43161]
[null,null,null,null,395,40056]
[null,null,null,null,396,44469]
[null,null,null,null,397,39035]
[null,null,null,null,398,36877]
[null,null,null,null,399,44347]
[null,null,null,null,400,41026]
[null,null,null,null,401,42690]
[null,null,null,null,402,45706]
[null,null,null,null,403,49175]
[null,null,null,null,404,47674]
[null,null,null,null,405,38327]
[null,null,null,null,406,42756]
[null,null,null,null,407,40522]
[null,null,null,null,408,43061]
[null,null,null,null,409,38610]
[null,null,null,null,410,39196]
[null,null,null,null,411,46795]
[null,null,null,null,412,45901]

{"sheet":"Method","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":true,"merged":[[11,4,11,5],[22,1,22,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Method",null,null,"Parameters"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mean Square Errors"]
[null,"Moving Averages",1106.0625]
[null,"Exponential Smoothing",773.29279699816186]
[null,"Holt's Method with Trends",399.37357823840631]
[null,"Winter's Method with Seasonality",529.29256455179404]

{"sheet":"Parameters","index":4,"n_rows":78,"n_cols":17,"rows_kept":78,"cut":false,"hidden":true,"merged":[[5,13,5,16]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For Holt's and Winter's Methods"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Winter's)","Base","Trend","Seasonal SF","Est S-Bar"]
[null,"MOVING AVERAGE",null,null,"Min MSE",null,null,null,"Period","Historical Demand","Forecast","Square Error","DeSeas",22.199999999999996,7.0181818181818185]
[null,"Number of Historical Periods to Average",4,null,1106.0625,null,null,null,1,23,{"$f":"(N8 + O8)","v":29.218181818181815},{"$f":"(J9-K9)^2","v":38.665785123966906},20.788095238095242,{"$f":"HAlpha * J9 + (1 - HAlpha) * (N8 + O8)","v":28.596363636363634},{"$f":"HBeta*(N9-N8)+(1-HBeta)*O8","v":6.8938181818181832},1.135242339348008,1.1064024739434197]
[null,"Tinit",{"$f":"1+C9","v":5},null,null,null,null,null,2,24,{"$f":"(N9 + O9)","v":35.490181818181817},{"$f":"(J10-K10)^2","v":132.02427821487601},31.31666666666667,{"$f":"HAlpha * J10 + (1 - HAlpha) * (N9 + O9)","v":34.341163636363639},{"$f":"HBeta*(N10-N9)+(1-HBeta)*O9","v":6.6640145454545472},0.99906607101090472,0.76636508781266621]
[null,"Tfin",10,null,null,null,null,null,3,34,{"$f":"(N10 + O10)","v":41.005178181818188},49.072521359021572,41.845238095238102,{"$f":"HAlpha * J11 + (1 - HAlpha) * (N10 + O10)","v":40.304660363636366},{"$f":"HBeta*(N11-N10)+(1-HBeta)*O10","v":6.5239109818181831},0.78713455473721561,0.81251778093883342]
[null,null,null,null,null,null,null,null,4,45,{"$f":"(N11 + O11)","v":46.828571345454549},3.3436731654174583,52.373809523809527,{"$f":"HAlpha * J12 + (1 - HAlpha) * (N11 + O11)","v":46.645714210909098},{"$f":"HBeta*(N12-N11)+(1-HBeta)*O11","v":6.4873395549090933},0.76278364530552167,0.85920807382824926]
[null,"EXPONENTIAL SMOOTHING",null,null,"Min MSE",null,null,null,5,67,{"$f":"(N12 + O12)","v":53.13305376581819},192.29219786168909,62.902380952380952,{"$f":"HAlpha * J13 + (1 - HAlpha) * (N12 + O12)","v":54.519748389236376},{"$f":"HBeta*(N13-N12)+(1-HBeta)*O12","v":6.7646784795927308},{"$f":"WGamma * ($J$9/ $N$9) + (1 - WGamma) * $P$9","v":1.1021479121273476},1.0651425110715773]
[null,"Smoothing Constant",0.1,null,{"$f":"AVERAGE($L$9:$L$18)","v":399.37357823840631},null,null,null,6,89,{"$f":"(N13 + O13)","v":61.284426868829108},768.15299398928187,73.430952380952391,{"$f":"HAlpha * J14 + (1 - HAlpha) * (N13 + O13)","v":64.055984181946201},{"$f":"HBeta*(N14-N13)+(1-HBeta)*O13","v":7.3189899422161506},{"$f":"WGamma * ($J$10/ $N$10) + (1 - WGamma) * $P$10","v":0.96904643761325204},1.2120229564540708]
[null,"Tinit",2,null,null,null,null,null,7,97,{"$f":"(N14 + O14)","v":71.37497412416235},656.64195113734911,83.959523809523816,{"$f":"HAlpha * J15 + (1 - HAlpha) * (N14 + O14)","v":73.937476711746115},{"$f":"HBeta*(N15-N14)+(1-HBeta)*O14","v":7.8314904597329038},{"$f":"WGamma * ($J$11/ $N$11) + (1 - WGamma) * $P$11","v":0.79277858967091963},1.1553186059042055]
[null,"Tfin",10,null,null,null,null,null,8,99,{"$f":"(N15 + O15)","v":81.768967171479019},296.90849233756774,94.488095238095241,{"$f":"HAlpha * J16 + (1 - HAlpha) * (N15 + O15)","v":83.492070454331127},{"$f":"HBeta*(N16-N15)+(1-HBeta)*O15","v":8.1761111163033249},{"$f":"WGamma * ($J$12/ $N$12) + (1 - WGamma) * $P$12","v":0.78297716626595382},1.0477510394355549]
[null,null,null,null,null,null,null,null,9,70,{"$f":"(N16 + O16)","v":91.668181570634459},469.51009257798285,105.01666666666667,{"$f":"HAlpha * J17 + (1 - HAlpha) * (N16 + O16)","v":89.501363413571013},{"$f":"HBeta*(N17-N16)+(1-HBeta)*O16","v":7.7427474848906375},{"$f":"WGamma * ($J$13/ $N$13) + (1 - WGamma) * $P$13","v":1.1148243703783165},0.66656086335502307]
[null,"HOLT'S METHOD FOR TRENDS",null,null,null,null,null,null,10,60,{"$f":"(N17 + O17)","v":97.244110898461656},1387.1237966169103,115.54523809523809,{"$f":"HAlpha * J18 + (1 - HAlpha) * (N17 + O17)","v":93.519699808615499},{"$f":"HBeta*(N18-N17)+(1-HBeta)*O17","v":6.9978652669214068},{"$f":"WGamma * ($J$14/ $N$14) + (1 - WGamma) * $P$14","v":1.011082754851296},0.5192771332605246]
[null,"Base Smoothing Constant",0.1,null,"Min MSE",null,null,null,null,null,null,0,null,null,null,{"$f":"WGamma * ($J$15/ $N$15) + (1 - WGamma) * $P$15","v":0.84469265706367069}]
[null,"Trend Smoothing Constant",0.2,null,{"$f":"AVERAGE($L$9:$L$18)","v":399.37357823840631},null,null,null,null,null,null,0,null,null,null,{"$f":"WGamma * ($J$16/ $N$16) + (1 - WGamma) * $P$16","v":0.82325358423834594}]
[null,"Tinit",1,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"WGamma * ($J$17/ $N$17) + (1 - WGamma) * $P$17","v":1.0815530324011122}]
[null,"Tfin",10,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"WGamma * ($J$18/ $N$18) + (1 - WGamma) * $P$18","v":0.97413208479345892}]
[null,"Starting Base",7.0181818181818185,null,null,null,null,null,null,null,null,0]
[null,"Starting Trend",17,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"WINTER'S METHOD FOR SEASONALITY",null,null,"Min MSE",null,null,null,null,null,null,0]
[null,"Base Smoothing Constant",0.05,null,{"$f":"AVERAGE($L$9:$L$17)","v":289.62355397412807},null,null,null,null,null,null,0]
[null,"Trend Smoothing Contant",0.1,null,null,null,null,null,null,null,null,0]
[null,"Seasonal Smoothing Constant",0.1,null,null,null,null,null,null,null,null,0]
[null,"Tinit",1,null,null,null,null,null,null,null,null,0]
[null,"Tfin",10,null,null,null,null,null,null,null,null,0]
[null,"Periods per Season",4,null,null,null,null,null,null,null,null,0]
[null,"Starting Base",10.528571428571428,null,null,null,null,null,null,null,null,0]
[null,"Starting Trend",10.259523809523813,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J74-K74)^2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J75-K75)^2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J76-K76)^2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J77-K77)^2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J78-K78)^2","v":0}]

{"sheet":"BestMethod","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Method","Holt's Method with Trends"]
[]
[null,"MSE",399.37357823840631]
[]
[null,"Parameters"]
[null,"Base Smoothing Constant",0.1]
[null,"Trend Smoothing Constant",0.2]
[null,"Tinit",1]
[null,"Tfin",10]
[null,"Starting Base",7.0181818181818185]
[null,"Starting Trend",17]
[null,"Starting Base",6.0957838766353224E-2]
[null,"Starting Trend",218.44012536507327]