{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Sample Output","Trend Curves Model Example"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":62,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sample Output","index":1,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Period","Sales, N(t)","Logistic","Gompertz",null,null,null,null,null,"Forecasting Information for Logistic Response",null,"Forecasting Information for Gompertz Response"]
[null,null,null,1,4.0899591508379907E-2,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*1)/(1+$N$28*EXP(-$N$27*1))))","v":9.7864492982793996E-2},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*1))","v":2.6923264676055028E-4}]
[null,null,null,2,8.0048076237159996E-2,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*2)/(1+$N$28*EXP(-$N$27*2))))","v":0.10011541946719292},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*2))","v":3.5638863999971683E-3},null,null,null,null,null,"Total Observations",20,"Total Observations",20]
[null,null,null,3,9.1068111793234915E-2,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*3)/(1+$N$28*EXP(-$N$27*3))))","v":0.1056825888153278},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*3))","v":2.0808904226632015E-2},null,null,null,null,null,"Holdout",0,"Holdout",0]
[null,null,null,4,0.13718935258429801,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*4)/(1+$N$28*EXP(-$N$27*4))))","v":0.119251284386082},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*4))","v":6.9461492922379145E-2},null,null,null,null,null,"Forecast Horizon",10,"Forecast Horizon",10]
[null,null,null,5,0.206905739497008,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*5)/(1+$N$28*EXP(-$N$27*5))))","v":0.15117241500368145},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*5))","v":0.15825440615882613}]
[null,null,null,6,0.17772878162495426,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*6)/(1+$N$28*EXP(-$N$27*6))))","v":0.22040388605455957},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*6))","v":0.27774662080030549},null,null,null,null,null,"In sample Error",null,"In sample Error"]
[null,null,null,7,0.28643049686583255,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*7)/(1+$N$28*EXP(-$N$27*7))))","v":0.34724991581371367},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*7))","v":0.40787873866762336},null,null,null,null,null,"Mean of Absolute Deviation",{"$f":"sF_MAD($E$6:$E$25, $F$6:$F$25)","v":4.2835699906787185E-2},"Mean of Absolute Deviation",{"$f":"sF_MAD($E$6:$E$25, $G$6:$G$25)","v":4.4770380203953339E-2}]
[null,null,null,8,0.56310898001108611,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*8)/(1+$N$28*EXP(-$N$27*8))))","v":0.52112603914020561},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*8))","v":0.5303130155891298},null,null,null,null,null,"Mean of Squared Residual",{"$f":"sF_MSE($E$6:$E$25, $F$6:$F$25)","v":2.2510315699121432E-3},"Mean of Squared Residual",{"$f":"sF_MSE($E$6:$E$25, $G$6:$G$25)","v":3.4881622594531772E-3}]
[null,null,null,9,0.76194465093335972,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*9)/(1+$N$28*EXP(-$N$27*9))))","v":0.68421442063529714},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*9))","v":0.63446724150073253},null,null,null,null,null,"Root Mean of Squared Residual",{"$f":"sF_RMSE($E$6:$E$25, $F$6:$F$25)","v":4.7445037358106727E-2},"Root Mean of Squared Residual",{"$f":"sF_RMSE($E$6:$E$25, $G$6:$G$25)","v":5.906066592456588E-2}]
[null,null,null,10,0.72602132537895736,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*10)/(1+$N$28*EXP(-$N$27*10))))","v":0.79097677279625156},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*10))","v":0.71714794834142326},null,null,null,null,null,"Mean of Absolute Percent Error",{"$f":"sF_MAPE($E$6:$E$25, $F$6:$F$25)","v":0.16920116739068197},"Mean of Absolute Percent Error",{"$f":"sF_MAPE($E$6:$E$25, $G$6:$G$25)","v":0.24551806972434354}]
[null,null,null,11,0.81306500134634796,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*11)/(1+$N$28*EXP(-$N$27*11))))","v":0.84543649252739628},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*11))","v":0.77974146624907015}]
[null,null,null,12,0.80442339766310056,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*12)/(1+$N$28*EXP(-$N$27*12))))","v":0.86970856221371751},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*12))","v":0.82561318083339463}]
[null,null,null,13,0.82368392056159478,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*13)/(1+$N$28*EXP(-$N$27*13))))","v":0.87987169781552443},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*13))","v":0.85849117384422813}]
[null,null,null,14,0.88206121534868132,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*14)/(1+$N$28*EXP(-$N$27*14))))","v":0.88401541757361046},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*14))","v":0.88170047532106599}]
[null,null,null,15,0.90098460118400614,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*15)/(1+$N$28*EXP(-$N$27*15))))","v":0.88568652085728072},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*15))","v":0.89791499756360682}]
[null,null,null,16,0.84189431123795577,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*16)/(1+$N$28*EXP(-$N$27*16))))","v":0.88635747749210958},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*16))","v":0.90916261296566425}]
[null,null,null,17,0.91902559749945023,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*17)/(1+$N$28*EXP(-$N$27*17))))","v":0.88662639123255715},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*17))","v":0.91692701460814219}]
[null,null,null,18,0.92853834763742138,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*18)/(1+$N$28*EXP(-$N$27*18))))","v":0.88673409272257198},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*18))","v":0.92226914654899395}]
[null,null,null,19,0.95514221363027951,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*19)/(1+$N$28*EXP(-$N$27*19))))","v":0.8867772154595106},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*19))","v":0.92593636456825235}]
[null,null,null,20,0.93189888006147681,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*20)/(1+$N$28*EXP(-$N$27*20))))","v":0.88679447945145395},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*20))","v":0.92844990708484643},null,null,null,null,null,"Paramters",null,"Paramters"]
[null,null,null,21,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*21)/(1+$N$28*EXP(-$N$27*21))))","v":0.88680139069560182},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*21))","v":0.93017088867853026},null,null,null,null,null,"b",1163.532839425967,"a",11.932746304950136]
[null,null,null,22,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*22)/(1+$N$28*EXP(-$N$27*22))))","v":0.88680415740331187},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*22))","v":0.93134836529552512},null,null,null,null,null,"c",0.91550385464385386,"b",0.38107953845235409]
[null,null,null,23,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*23)/(1+$N$28*EXP(-$N$27*23))))","v":0.88680526496299084},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*23))","v":0.93215358408501747},null,null,null,null,null,"d",1305.3655955994091,"M",0.93389184699136829]
[null,null,null,24,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*24)/(1+$N$28*EXP(-$N$27*24))))","v":0.88680570833647487},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*24))","v":0.93270404819074559},null,null,null,null,null,"M",0.88680600430707568]
[null,null,null,25,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*25)/(1+$N$28*EXP(-$N$27*25))))","v":0.88680588582561515},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*25))","v":0.93308027005169891}]
[null,null,null,26,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*26)/(1+$N$28*EXP(-$N$27*26))))","v":0.88680595687718033},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*26))","v":0.93333736330507522}]
[null,null,null,27,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*27)/(1+$N$28*EXP(-$N$27*27))))","v":0.8868059853201824},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*27))","v":0.93351303048429124}]
[null,null,null,28,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*28)/(1+$N$28*EXP(-$N$27*28))))","v":0.88680599670633975},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*28))","v":0.93363305187912737}]
[null,null,null,29,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*29)/(1+$N$28*EXP(-$N$27*29))))","v":0.88680600126438802},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*29))","v":0.93371505019186452}]
[null,null,null,30,null,{"$f":"$N$29*((1-$N$26*EXP(-$N$27*30)/(1+$N$28*EXP(-$N$27*30))))","v":0.88680600308904256},{"$f":"$P$28*EXP(-$P$26*EXP(-$P$27*30))","v":0.93377106931072895}]

{"sheet":"Trend Curves Model Example","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Period, t","Sales, N(t)"]
[null,1,4.0899591508379907E-2]
[null,2,8.0048076237159996E-2]
[null,3,9.1068111793234915E-2]
[null,4,0.13718935258429801]
[null,5,0.206905739497008]
[null,6,0.17772878162495426]
[null,7,0.28643049686583255]
[null,8,0.56310898001108611]
[null,9,0.76194465093335972]
[null,10,0.72602132537895736]
[null,11,0.81306500134634796]
[null,12,0.80442339766310056]
[null,13,0.82368392056159478]
[null,14,0.88206121534868132]
[null,15,0.90098460118400614]
[null,16,0.84189431123795577]
[null,17,0.91902559749945023]
[null,18,0.92853834763742138]
[null,19,0.95514221363027951]
[null,20,0.93189888006147681]