{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Linear Regression","Linear-LeastSq Regression","Moving Average","Exponential","MAD and Tracking Signals"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":1,"defined_names":176,"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":"Linear Regression","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Exhibit 18.8 - Excel Regression Tool"]
[]
[null,"Quarter","Sales"]
[null,1,600]
[null,2,1550]
[null,3,1500]
[null,4,1500]
[null,5,2400]
[null,6,3100]
[null,7,2600]
[null,8,2900]
[null,9,3800]
[null,10,4500]
[null,11,4000]
[null,12,4900]
[]
[]
[null,"SUMMARY OUTPUT"]
[]
[null,"Regression Statistics"]
[null,"Multiple R",0.96601558039069868]
[null,"R Square",0.93318610155757853]
[null,"Adjusted R Square",0.92650471171333637]
[null,"Standard Error",363.87779718203643]
[null,"Observations",12]
[]
[null,"ANOVA"]
[null,null,"df","SS","MS","F","Significance F"]
[null,"Regression",1,18493221.153846152,18493221.153846152,139.66945849773668,3.3720241192852534E-7]
[null,"Residual",10,1324070.5128205125,132407.05128205125]
[null,"Total",11,19817291.666666664]
[]
[null,null,"Coefficients","Standard Error","t Stat","P-value","Lower 95%","Upper 95%","Lower 95.0%","Upper 95.0%"]
[null,"Intercept",441.66666666666703,223.95130294706053,1.9721549321419749,7.686869451877118E-2,-57.328018732126452,940.66135206546051,-57.328018732126452,940.66135206546051]
[null,"X Variable 1",359.61538461538458,30.428990051245869,11.818183383995049,3.3720241192852518E-7,291.81535792291322,427.41541130785595,291.81535792291322,427.41541130785595]

{"sheet":"Linear-LeastSq Regression","index":1,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Please enter 19 numbers in the blue shaded cells. ",null,null,null,null,null,null,null,null,null,null,"https://www.random.org/integers/"]
[null,"Least Squares Regression Template",null,null,null,"These numbers will be automatially added to the Moving Average and Exponential woksheets"]
[null,null,null,null,null,"Do not change any other numbers."]
[]
[]
[null,"(1)","(2)","(3)","(4)","(5)","(6)"]
[null,"x","y","xy","x2","y2","Ŷ"]
[null,"Period","Metric",null,null,null,null,null,"DESEASONALIZED",null,null,"SEASONALIZED"]
[null,1,62,{"$f":"IF(B9=\"\",\"\",B9*C9)","v":62},{"$f":"IF(B9=\"\",\"\",B9^2)","v":1},{"$f":"IF(B9=\"\",\"\",C9^2)","v":3844},{"$f":"IF(B9=\"\",\"\",$C$34+(B9*$C$33))","v":70.568421052631592},null,"FORECAST",null,null,"FORECAST"]
[null,2,65,{"$f":"IF(B10=\"\",\"\",B10*C10)","v":130},{"$f":"IF(B10=\"\",\"\",B10^2)","v":4},{"$f":"IF(B10=\"\",\"\",C10^2)","v":4225},70.856140350877197]
[null,3,67,201,9,4489,71.143859649122817,null,"x",null,null,"Seasonal"]
[null,4,68,272,16,4624,71.431578947368422,null,"Period","yd",null,"Factor","ys"]
[null,5,71,355,25,5041,71.719298245614041,null,9,{"$f":"IF(I13=\"\",\"\",$C$34+$C$33*I13)","v":72.870175438596505},null,0.52700000000000002,{"$f":"IF(L13=\"\",\"\",J13*L13)","v":38.402582456140358}]
[null,6,73,438,36,5329,72.007017543859661,null,10,73.15789473684211,null,0.95699999999999996,{"$f":"IF(L14=\"\",\"\",J14*L14)","v":70.012105263157892}]
[null,7,76,532,49,5776,72.294736842105266,null,11,73.445614035087729,null,1.5289999999999999,112.29834385964914]
[null,8,78,624,64,6084,72.582456140350885,null,12,73.733333333333348,null,0.98699999999999999,72.774800000000013]
[null,9,78,702,81,6084,72.870175438596505,null,null,"",null,null,""]
[null,10,80,800,100,6400,73.15789473684211,null,null,"",null,null,""]
[null,11,84,924,121,7056,73.445614035087729,null,null,"",null,null,""]
[null,12,85,{"$f":"IF(B20=\"\",\"\",B20*C20)","v":1020},{"$f":"IF(B20=\"\",\"\",B20^2)","v":144},{"$f":"IF(B20=\"\",\"\",C20^2)","v":7225},{"$f":"IF(B20=\"\",\"\",$C$34+(B20*$C$33))","v":73.733333333333348}]
[null,13,72,936,169,5184,74.021052631578954]
[null,14,84,1176,196,7056,74.308771929824573]
[null,15,67,1005,225,4489,74.596491228070178]
[null,16,82,1312,256,6724,74.884210526315798]
[null,17,62,1054,289,3844,75.171929824561417]
[null,18,63,1134,324,3969,75.459649122807022]
[null,19,73,1387,361,5329,{"$f":"IF(B27=\"\",\"\",$C$34+(B27*$C$33))","v":75.747368421052641},null,null,{"$f":"IF(I27=\"\",\"\",$C$34+$C$33*I27)","v":""},null,null,""]
[]
[null,{"$f":"SUM(B9:B27)","v":190},{"$f":"SUM(C9:C27)","v":1390},{"$f":"SUM(D9:D27)","v":14064},{"$f":"SUM(E9:E27)","v":2470},{"$f":"SUM(F9:F27)","v":102772}]
[]
[null,null,{"$f":"B29/COUNT(C9:C27)","v":10},"= X-bar"]
[null,null,{"$f":"C29/COUNT(C9:C27)","v":73.15789473684211},"= Y-bar"]
[null,null,{"$f":"(D29-(COUNT(C9:C27)*C31*C32))/(E29-(COUNT(C9:C27)*C31^2))","v":0.28771929824561404},"= b"]
[null,null,{"$f":"C32-(C33*C31)","v":70.280701754385973},"= a"]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Regression Equation is Y = \",FIXED(C33,2),\"*X\",IF(C34<0,\" - \",\" + \"),C34)","v":"Regression Equation is Y = 0.29*X + 70.280701754386"}]

{"sheet":"Moving Average","index":2,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Do not change any number."]
[null,null,"Moving Average",null,null,null,null,null,"It's OK to adjust the small black arrows next to the Big Yellow arrow"]
[]
[]
[]
[null,null,"Period","Metric","Forecast",null,null,null,null,null,null,null,null,null,null,null,null,"Forecast",null,null,"Error","Erro^2"]
[null,null,1,{"$f":"'Linear-LeastSq Regression'!C9","v":62},{"$f":"IF(ISNA(R8),\"\",R8)","v":""},{"$f":"IF(C8=Time_Period,\"«««\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(OR(ISBLANK(D8),ISNA(R8)),#N/A,D8-R8)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(S8),\"\",S8)","v":""},{"$f":"IF(ISNA(S8),\"\",ABS(S8))","v":""},{"$f":"IF(ISNA(S8),\"\",S8^2)","v":""}]
[null,null,{"$f":"IF(D9=\"\",\"\",C8+1)","v":2},{"$f":"'Linear-LeastSq Regression'!C10","v":65},"","",null,null,null,null,"Number of Periods in MA",3,null,null,null,null,null,{"$f":"IF(ISBLANK(D8),#N/A,IF($L$9=1,D8,#N/A))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"","",""]
[null,null,3,{"$f":"'Linear-LeastSq Regression'!C11","v":67},"","",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D9),#N/A,IF($L$9=1,D9,IF($L$9=2,AVERAGE(D8:D9),#N/A)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},"","",""]
[null,null,4,{"$f":"'Linear-LeastSq Regression'!C12","v":68},64.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D10),#N/A,IF($L$9=1,D10,IF($L$9=2,AVERAGE(D9:D10),IF($L$9=3,AVERAGE(D8:D10),#N/A))))","v":64.666666666666671},3.3333333333333286,3.3333333333333286,3.3333333333333286,11.111111111111079]
[null,null,5,{"$f":"'Linear-LeastSq Regression'!C13","v":71},66.666666666666671,"",null,null,"MAD",{"$f":"U28/COUNT(U8:U27)","v":6.2083333333333321},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D11),#N/A,IF($L$9=1,D11,IF($L$9=2,AVERAGE(D10:D11),IF($L$9=3,AVERAGE(D9:D11),IF($L$9=4,AVERAGE(D8:D11),#N/A)))))","v":66.666666666666671},4.3333333333333286,4.3333333333333286,4.3333333333333286,18.777777777777736]
[null,null,6,{"$f":"'Linear-LeastSq Regression'!C14","v":73},68.666666666666671,"",null,null,"MSE",{"$f":"V28/(COUNT(V8:V27)-1)","v":56.325925925925922},null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D12),#N/A,IF($L$9=1,D12,IF($L$9=2,AVERAGE(D11:D12),IF($L$9=3,AVERAGE(D10:D12),IF($L$9=4,AVERAGE(D9:D12),IF($L$9=5,AVERAGE(D8:D12),#N/A))))))","v":68.666666666666671},4.3333333333333286,4.3333333333333286,4.3333333333333286,18.777777777777736]
[null,null,7,{"$f":"'Linear-LeastSq Regression'!C15","v":76},70.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D13),#N/A,IF($L$9=1,D13,IF($L$9=2,AVERAGE(D12:D13),IF($L$9=3,AVERAGE(D11:D13),IF($L$9=4,AVERAGE(D10:D13),IF($L$9=5,AVERAGE(D9:D13),IF($L$9=6,AVERAGE(D8:D13),\"\")))))))","v":70.666666666666671},5.3333333333333286,5.3333333333333286,5.3333333333333286,28.444444444444393]
[null,null,8,{"$f":"'Linear-LeastSq Regression'!C16","v":78},73.333333333333329,"",null,null,null,null,null,null,null,null,null,null,null,73.333333333333329,4.6666666666666714,4.6666666666666714,4.6666666666666714,21.777777777777821]
[null,null,9,{"$f":"'Linear-LeastSq Regression'!C17","v":78},75.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,75.666666666666671,2.3333333333333286,2.3333333333333286,2.3333333333333286,5.4444444444444224]
[null,null,10,{"$f":"'Linear-LeastSq Regression'!C18","v":80},77.333333333333329,"",null,null,null,null,null,null,null,null,null,null,null,77.333333333333329,2.6666666666666714,2.6666666666666714,2.6666666666666714,7.1111111111111365]
[null,null,11,{"$f":"'Linear-LeastSq Regression'!C19","v":84},78.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,78.666666666666671,5.3333333333333286,5.3333333333333286,5.3333333333333286,28.444444444444393]
[null,null,12,{"$f":"'Linear-LeastSq Regression'!C20","v":85},80.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,80.666666666666671,4.3333333333333286,4.3333333333333286,4.3333333333333286,18.777777777777736]
[null,null,13,{"$f":"'Linear-LeastSq Regression'!C21","v":72},83,"",null,null,null,null,null,null,null,null,null,null,null,83,-11,-11,11,121]
[null,null,14,{"$f":"'Linear-LeastSq Regression'!C22","v":84},80.333333333333329,"",null,null,null,null,"X","Y",null,null,null,null,null,80.333333333333329,3.6666666666666714,3.6666666666666714,3.6666666666666714,13.444444444444478]
[null,null,15,{"$f":"'Linear-LeastSq Regression'!C23","v":67},80.333333333333329,"",null,null,null,null,{"$f":"Time_Period","v":19},0,null,null,null,null,null,80.333333333333329,-13.333333333333329,-13.333333333333329,13.333333333333329,177.77777777777766]
[null,null,16,{"$f":"'Linear-LeastSq Regression'!C24","v":82},74.333333333333329,"",null,null,null,null,{"$f":"Time_Period","v":19},{"$f":"L10","v":0},null,null,null,null,null,74.333333333333329,7.6666666666666714,7.6666666666666714,7.6666666666666714,58.77777777777785]
[null,null,17,{"$f":"'Linear-LeastSq Regression'!C25","v":62},77.666666666666671,"",null,null,null,null,null,null,null,null,null,null,null,77.666666666666671,-15.666666666666671,-15.666666666666671,15.666666666666671,245.4444444444446]
[null,null,18,{"$f":"'Linear-LeastSq Regression'!C26","v":63},70.333333333333329,"",null,null,null,null,null,null,null,null,null,null,null,70.333333333333329,-7.3333333333333286,-7.3333333333333286,7.3333333333333286,53.777777777777708]
[null,null,19,{"$f":"'Linear-LeastSq Regression'!C27","v":73},69,"«««",null,null,null,null,"Smoothing Constant:",null,1,null,null,null,null,69,4,4,4,16]
[null,null,"",null,66,"",null,null,null,null,"Time Period",19,null,null,null,null,null,66,{"$error":"#N/A"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum",null,{"$f":"SUM(U8:U27)","v":99.333333333333314},{"$f":"SUM(V8:V27)","v":844.8888888888888}]

{"sheet":"Exponential","index":3,"n_rows":50,"n_cols":63,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Do not change any number."]
[null,"Exponential Smoothing",null,null,null,null,null,null,"It's OK to adjust the small black arrows next to the Big Yellow arrow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,2.5000000000000001E-2]
[null,"Period","Metric'","Forecast",null,null,null,null,null,null,null,null,null,null,null,"t","Sales","Forecast",null,"Error","Error^2","Error","Error^2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Sigmas equal?",1,null,null,0.05,0.05]
[null,1,{"$f":"'Linear-LeastSq Regression'!C9","v":62},{"$f":"C5","v":62},"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C5","v":62},{"$f":"D5","v":62},null,{"$f":"IF(OR(Q5=\"\",R5=\"\"),\"\",ABS(Q5-R5))","v":0},{"$f":"IF(T5=\"\",\"\",T5^2)","v":0},{"$f":"IF(ISNA(T5),\"\",T5)","v":0},{"$f":"IF(ISNA(U5),\"\",U5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Significance level",0.1,null,null,0.1,0.1]
[null,{"$f":"IF(C6=\"\",\"\",B5+1)","v":2},{"$f":"'Linear-LeastSq Regression'!C10","v":65},{"$f":"IF(ISNA(R6),\"\",R6)","v":62},"",null,null,null,"Smoothing Constant:",{"$f":"K24/100","v":0.43},null,null,null,null,null,null,65,{"$f":"IF(ISBLANK(C6),#N/A,R5+Smoothing_Constant*(Q5-R5))","v":62},null,3,9,3,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Randomizer",0.92968642711639404]
[null,3,{"$f":"'Linear-LeastSq Regression'!C11","v":67},63.29,"",null,null,null,null,null,null,null,null,null,null,null,67,63.29,null,3.7100000000000009,13.764100000000006,3.7100000000000009,13.764100000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confidence_level",{"$f":"1-Significance_level","v":0.9}]
[null,4,{"$f":"'Linear-LeastSq Regression'!C12","v":68},64.885300000000001,"",null,null,null,null,null,null,null,null,null,null,null,68,64.885300000000001,null,3.1146999999999991,9.7013560899999938,3.1146999999999991,9.7013560899999938,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer allowance",0.01]
[null,5,{"$f":"'Linear-LeastSq Regression'!C13","v":71},66.224620999999999,"",null,null,null,"MAD",{"$f":"$V$25/COUNT($V$5:$V$23)","v":6.0091359293263533},null,null,null,null,null,null,71,66.224620999999999,null,4.7753790000000009,22.804244593641009,4.7753790000000009,22.804244593641009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PlannedAdExpense",10313]
[null,6,{"$f":"'Linear-LeastSq Regression'!C14","v":73},68.278033969999996,"",null,null,null,"MSE",{"$f":"$W$25/(COUNT($W$5:$W$23)-1)","v":52.506209101334534},null,null,null,null,null,null,73,68.278033969999996,null,4.7219660300000044,22.296963188474002,4.7219660300000044,22.296963188474002]
[null,7,{"$f":"'Linear-LeastSq Regression'!C15","v":76},70.308479362900002,"",null,null,null,null,null,null,null,null,null,null,null,76,70.308479362900002,null,5.6915206370999982,32.393407162535169,5.6915206370999982,32.393407162535169,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y_hat_UL",{"$f":"Y_hat+TINV(Significance_level,dfE)*s*SQRT(1+(1/COUNT(x))+((PlannedAdExpense-AVERAGE(x))^2)/SSx)","v":{"$error":"#REF!"}}]
[null,8,{"$f":"'Linear-LeastSq Regression'!C16","v":78},72.755833236853007,"",null,null,null,null,null,null,null,null,null,null,null,78,72.755833236853007,null,5.2441667631469926,27.501285039695606,5.2441667631469926,27.501285039695606,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y_hat_LL",{"$f":"Y_hat-TINV(Significance_level,dfE)*s*SQRT(1+(1/COUNT(x))+((PlannedAdExpense-AVERAGE(x))^2)/SSx)","v":{"$error":"#REF!"}}]
[null,9,{"$f":"'Linear-LeastSq Regression'!C17","v":78},75.01082494500622,"",null,null,null,null,null,null,null,null,null,null,null,78,75.01082494500622,null,2.9891750549937797,8.9351675093970648,2.9891750549937797,8.9351675093970648]
[null,10,{"$f":"'Linear-LeastSq Regression'!C18","v":80},76.296170218653543,"",null,null,null,null,null,null,null,null,null,null,null,80,76.296170218653543,null,3.7038297813464567,13.718355049188942,3.7038297813464567,13.718355049188942]
[null,11,{"$f":"'Linear-LeastSq Regression'!C19","v":84},77.888817024632516,"",null,null,null,null,null,null,null,null,null,null,null,84,77.888817024632516,null,6.111182975367484,37.346557358421371,6.111182975367484,37.346557358421371]
[null,12,{"$f":"'Linear-LeastSq Regression'!C20","v":85},80.516625704040536,"",null,null,null,null,null,null,null,null,null,null,null,85,80.516625704040536,null,4.4833742959594645,20.100645077670023,4.4833742959594645,20.100645077670023]
[null,13,{"$f":"'Linear-LeastSq Regression'!C21","v":72},82.444476651303106,"",null,null,null,null,null,null,null,null,null,null,null,72,82.444476651303106,null,10.444476651303106,109.08709251961574,10.444476651303106,109.08709251961574]
[null,14,{"$f":"'Linear-LeastSq Regression'!C22","v":84},77.953351691242773,"",null,null,null,null,null,null,null,null,null,null,null,84,77.953351691242773,null,6.0466483087572271,36.561955769796633,6.0466483087572271,36.561955769796633]
[null,15,{"$f":"'Linear-LeastSq Regression'!C23","v":67},80.55341046400838,"",null,null,null,"X","Y",null,null,null,null,null,null,67,80.55341046400838,null,13.55341046400838,183.69493520589185,13.55341046400838,183.69493520589185]
[null,16,{"$f":"'Linear-LeastSq Regression'!C24","v":82},74.725443964484782,"",null,null,null,{"$f":"Time_Period1","v":6},0,null,null,null,null,null,null,82,74.725443964484782,null,7.2745560355152179,52.919165513850885,7.2745560355152179,52.919165513850885,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"AVERAGE(y)-B*(AVERAGE(x))","v":{"$error":"#REF!"}}]
[null,17,{"$f":"'Linear-LeastSq Regression'!C25","v":62},77.853503059756321,"",null,null,null,{"$f":"Time_Period1","v":6},{"$f":"J7","v":0},null,null,null,null,null,null,62,77.853503059756321,null,{"$f":"IF(OR(Q21=\"\",R21=\"\"),\"\",ABS(Q21-R21))","v":15.853503059756321},{"$f":"IF(T21=\"\",\"\",T21^2)","v":251.33355926570303},{"$f":"IF(ISNA(T21),\"\",T21)","v":15.853503059756321},{"$f":"IF(ISNA(U21),\"\",U21)","v":251.33355926570303},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"SSxy/SSx","v":{"$error":"#REF!"}}]
[null,18,{"$f":"'Linear-LeastSq Regression'!C26","v":63},71.036496744061097,"",null,null,null,null,null,null,null,null,null,null,null,63,71.036496744061097,null,8.0364967440610968,64.585279917304604,8.0364967440610968,64.585279917304604,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSxy",{"$f":"SUM(XY)-(SUM(x)*SUM(y)/COUNT(x))","v":{"$error":"#REF!"}}]
[null,19,{"$f":"'Linear-LeastSq Regression'!C27","v":73},67.580803144114824,null,null,null,null,null,null,null,null,null,null,null,null,73,67.580803144114824,null,5.4191968558851755,29.367694562835773,5.4191968558851755,29.367694562835773,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSx",{"$f":"SUM(x2_)-((SUM(x)*SUM(x))/COUNT(x))","v":{"$error":"#REF!"}}]
[null,"",null,0,null,null,null,null,"Smoothing Constant:",null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Your pvalue",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",0,IF(AND(AQ25<0.0001,AQ24<0.0001),1,0))","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!=\"\",0,IF(AND(#REF!>#REF!*(1-Answer_allowance),#REF!<#REF!*(1+Answer_allowance)),1,0))","v":{"$error":"#REF!"}},"SSy",{"$f":"SUM(y2_)-SUM(y)^2/COUNT(y)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Time Period",6,null,null,null,null,null,null,null,null,null,null,"Sum",{"$f":"SUM(V5:V23)","v":114.17358265720071},{"$f":"SUM(W5:W23)","v":945.11176382402164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correct pvalue",{"$f":"p_value_t","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","y","x2","y2","XY","Ybar","y-ybar","x-xbar","Forecast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5=\"\",\"\",B5)","v":1},{"$f":"IF(C5<>\"\",C5,\"\")","v":62},{"$f":"IF(AU31<>\"\",AU31^2,\"\")","v":1},{"$f":"IF(AU31<>\"\",AV31^2,\"\")","v":3844},{"$f":"IF(AU31<>\"\",AU31*AV31,\"\")","v":62},{"$f":"IF(AU31<>\"\",AVERAGE(y),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(AZ31=\"\",\"\",y-Ybar)","v":{"$error":"#REF!"}},{"$f":"IF(x=\"\",\"\",x-AVERAGE(x))","v":{"$error":"#REF!"}},{"$f":"A+B5*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C6=\"\",\"\",B6)","v":2},{"$f":"IF(C6<>\"\",C6,\"\")","v":65},4,4225,130,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+B6*B","v":{"$error":"#REF!"}},null,"SUMMARY OUTPUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",B7)","v":3},{"$f":"IF(C7<>\"\",C7,\"\")","v":67},9,4489,201,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+B7*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C8=\"\",\"\",B8)","v":4},{"$f":"IF(C8<>\"\",C8,\"\")","v":68},16,4624,272,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+B8*B","v":{"$error":"#REF!"}},null,"Regression Statistics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C9=\"\",\"\",B9)","v":5},{"$f":"IF(C9<>\"\",C9,\"\")","v":71},25,5041,355,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+B9*B","v":{"$error":"#REF!"}},null,"Multiple R",{"$f":"(SSxy/SQRT(SSx*SSy))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",B24)","v":""},{"$f":"IF(C24<>\"\",C24,\"\")","v":""},"","","","","","",{"$f":"A+B24*B","v":{"$error":"#REF!"}},null,"Advertising Exp",{"$f":"B","v":{"$error":"#REF!"}},{"$f":"s/SQRT(SSx)","v":{"$error":"#REF!"}},{"$f":"Slope/BG36","v":{"$error":"#REF!"}},{"$f":"TDIST(BH36,Observations-2,2)","v":{"$error":"#REF!"}},{"$f":"Slope-TINV(Significance_level,Observations-2)*BG36","v":{"$error":"#REF!"}},{"$f":"Slope+TINV(Significance_level,Observations-2)*BG36","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}},null,{"$f":"CONCATENATE(Confidence_level*100,\"% Prediction Interval Estimate\")","v":"90% Prediction Interval Estimate"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}},null,"   Upper Limit",{"$f":"Y_hat_UL","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}},null,"   Lower Limit",{"$f":"n","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",B25)","v":""},{"$f":"IF(C25<>\"\",C25,\"\")","v":""},"","","","","","",{"$f":"A+B25*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"A+#REF!*B","v":{"$error":"#REF!"}}]

{"sheet":"MAD and Tracking Signals","index":4,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,"MAD and Tracking Signal"]
[]
[null,"Period","Actual ","Forecast"]
[null,1,700,660]
[null,2,760,840]
[null,3,780,750]
[null,4,790,835]
[null,5,850,910]
[null,6,950,890]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Solution"]
[null,null,"Actual Demand","Forecast Demand","Actual Deviation","Cumulative Deviation (RSFE)","Absolute Deviation","Sum of Abs. Dev.","MAD*","TS=RSFE/MAD"]
[null,{"$f":"IF(C5=\"\",\"\",B5)","v":1},{"$f":"IF(C5=\"\",\"\",C5)","v":700},660,{"$f":"IF(B5=\"\",\"\",C22-D22)","v":40},{"$f":"IF(B22=\"\",\"\",E22)","v":40},{"$f":"IF(B5=\"\",\"\",ABS(E22))","v":40},{"$f":"IF(C5=\"\",\"\",G22)","v":40},{"$f":"IF(C5=\"\",\"\",H22/B22)","v":40},{"$f":"IF(C5=\"\",\"\",F22/I22)","v":1}]
[null,{"$f":"IF(C6=\"\",\"\",B6)","v":2},760,840,{"$f":"IF(B6=\"\",\"\",C23-D23)","v":-80},{"$f":"IF(B23=\"\",\"\",E23+F22)","v":-40},{"$f":"IF(B6=\"\",\"\",ABS(E23))","v":80},{"$f":"IF(G23=\"\",\"\",H22+G23)","v":120},{"$f":"IF(C6=\"\",\"\",H23/B23)","v":60},{"$f":"IF(C6=\"\",\"\",F23/I23)","v":-0.66666666666666663}]
[null,{"$f":"IF(C7=\"\",\"\",B7)","v":3},780,750,30,{"$f":"IF(B24=\"\",\"\",E24+F23)","v":-10},30,{"$f":"IF(G24=\"\",\"\",H23+G24)","v":150},50,-0.2]
[null,4,790,835,-45,-55,45,195,48.75,-1.1282051282051282]
[null,5,850,910,-60,-115,60,255,51,-2.2549019607843137]
[null,6,950,890,60,-55,60,315,52.5,-1.0476190476190477]
[null,"","","","","","","","",""]
[null,"","","","",{"$f":"IF(B29=\"\",\"\",E29+F28)","v":""},"","","",""]
[null,"","","","","","","","",""]
[null,"","","","","","","","",""]
[null,"","","","","","","","",""]
[null,"","","","","","","","",""]
[null,"","","","","","","","",""]
[null,{"$f":"IF(B18=\"\",\"\",B18)","v":""},"","",null,{"$f":"SUM(E22:E34)","v":-55},{"$f":"SUM(G22:G34)","v":315}]
[]
[]
[null,null,null,null,null,"MAD =",{"$f":"CONCATENATE(G35,\" / \",COUNT(G22:G34),\" = \",FIXED(G35/COUNT(G22:G34),1))","v":"315 / 6 = 52.5"}]
[]
[null,null,null,null,null,"Tracking Signal =",{"$f":"CONCATENATE(F35,\" / \",FIXED(G35/COUNT(G22:G34),1),\" = \",FIXED(F35/(G35/COUNT(G22:G34)),1))","v":"-55 / 52.5 = -1.0"}]