{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Exponential Smoothing Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":36,"comments":1,"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":"Exponential Smoothing Macro","index":0,"n_rows":224,"n_cols":18,"rows_kept":224,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Period, t","WFJ Sales",null,"Period, t","Qsales",null,null,"Year","Month","Temperature",null,"Obs","Year.Qtr","Walmart Quarterly",null,"Obs","Air Passenger"]
[null,1,23056.130494239998,null,1,641,null,null,1991,"JAN",29.9,null,1,"4/30/1995",20.399999999999999,null,1,112]
[null,2,24817.3190961,null,2,728.09199999999998,null,null,1991,"FEB",40.9,null,2,"7/31/1995",22.7,null,2,118]
[null,3,24299.548847159997,null,3,920.43100000000004,null,null,1991,"MAR",42.8,null,3,"10/31/1995",22.9,null,3,132]
[null,4,23242.465683079998,null,4,1078.6110000000001,null,null,1991,"APR",47.8,null,4,"1/31/1996",27.6,null,4,129]
[null,5,22862.30052664,null,5,1427.471,null,null,1991,"MAY",58.2,null,5,"4/30/1996",22.8,null,5,121]
[null,6,22862.682151019995,null,6,1602.37,null,null,1991,"JUN",66.599999999999994,null,6,"7/31/1996",25.6,null,6,135]
[null,7,23391.023208620001,null,7,1928.1389999999999,null,null,1991,"JUL",70.5,null,7,"10/31/1996",25.6,null,7,148]
[null,8,22469.44865102,null,8,1869.194,null,null,1991,"AUG",69.2,null,8,"1/31/1997",30.9,null,8,148]
[null,9,22241.379764400001,null,9,1881.33,null,null,1991,"SEP",61.7,null,9,"4/30/1997",25.4,null,9,136]
[null,10,24366.535204779997,null,10,1992.4259999999999,null,null,1991,"OCT",52.1,null,10,"7/31/1997",28.4,null,10,119]
[null,11,29456.552932800001,null,11,2083.1039999999998,null,null,1991,"NOV",36.799999999999997,null,11,"10/31/1997",28.8,null,11,104]
[null,12,31293.508734059997,null,12,2004.2650000000001,null,null,1991,"DEC",35.299999999999997,null,12,"1/31/1998",35.4,null,12,118]
[null,13,38713.468027940005,null,13,2000.4860000000001,null,null,1992,"JAN",35.9,null,13,"4/30/1998",29.8,null,13,115]
[null,14,35749.31099328,null,14,2251.09,null,null,1992,"FEB",40.6,null,14,"7/31/1998",33.5,null,14,126]
[null,15,39768.377207279998,null,15,2267.3130000000001,null,null,1992,"MAR",43.3,null,15,"10/31/1998",33.5,null,15,141]
[null,16,32418.750829880002,null,16,2518.2069999999999,null,null,1992,"APR",54.3,null,16,"1/31/1999",40.799999999999997,null,16,135]
[null,17,37502.863298959994,null,17,2857.578,null,null,1992,"MAY",59.1,null,17,"4/30/1999",34.700000000000003,null,17,125]
[null,18,31473.982766319998,null,18,2086.2139999999999,null,null,1992,"JUN",62.9,null,18,"7/31/1999",38.5,null,18,149]
[null,19,35625.090819700003,null,19,1888.556,null,null,1992,"JUL",68.3,null,19,"10/31/1999",40.4,null,19,170]
[null,20,33159.210465440003,null,20,2247.6019999999999,null,null,1992,"AUG",66.3,null,20,"1/31/2000",51.4,null,20,170]
[null,21,34305.663066920002,null,21,2651.1469999999999,null,null,1992,"SEP",64.400000000000006,null,21,"4/30/2000",43,null,21,158]
[null,22,33630.574426359999,null,22,3136.2469999999998,null,null,1992,"OCT",54.1,null,22,"7/31/2000",46.1,null,22,133]
[null,23,32899.710042239996,null,23,4538.4459999999999,null,null,1992,"NOV",34.1,null,23,"10/31/2000",45.7,null,23,114]
[null,24,34426.158488479996,null,24,8394.0460000000003,null,null,1992,"DEC",29.2,null,24,"1/31/2001",56.6,null,24,140]
[null,25,33777.481421659999,null,25,9980.1460000000006,null,null,1993,"JAN",28.3,null,25,"4/30/2001",48.1,null,25,145]
[null,26,34848.681941339994,null,26,8649.91,null,null,1993,"FEB",30.6,null,26,"7/31/2001",52.8,null,26,150]
[null,27,30986.251326319998,null,27,9224.2900000000009,null,null,1993,"MAR",42.4,null,27,"10/31/2001",52.7,null,27,178]
[null,28,33321.094384119999,null,28,9042.8289999999997,null,null,1993,"APR",47.6,null,28,"1/31/2002",64.2,null,28,163]
[null,29,34002.676170219995,null,29,9406.4069999999992,null,null,1993,"MAY",57.5,null,29,"4/30/2002",55,null,29,172]
[null,30,35417.160951520003,null,30,9408.027,null,null,1993,"JUN",64.5,null,30,"7/31/2002",59.7,null,30,178]
[null,31,33822.059468319996,null,31,8500.7170000000006,null,null,1993,"JUL",69.5,null,31,"10/31/2002",58.8,null,31,199]
[null,32,32723.198200939998,null,32,8946.5879999999997,null,null,1993,"AUG",67.3,null,32,"1/31/2003",71.099999999999994,null,32,199]
[null,33,34925.046737999997,null,33,9652.8580000000002,null,null,1993,"SEP",58.8,null,33,"4/30/2003",56.7,null,33,184]
[null,34,33459.645519199999,null,34,10095.34,null,null,1993,"OCT",48.7,null,34,"7/31/2003",62.6,null,34,162]
[null,35,30998.869210159995,null,35,10697.388999999999,null,null,1993,"NOV",35.6,null,35,"10/31/2003",62.5,null,35,146]
[null,36,31286.16466292,null,36,12444.662,null,null,1993,"DEC",35.4,null,36,"1/31/2004",74.5,null,36,166]
[null,37,35030.337913879994,null,37,16054.958000000001,null,null,1994,"JAN",35.5,null,37,"4/30/2004",64.8,null,37,171]
[null,38,34259.509149000005,null,38,15872.66,null,null,1994,"FEB",31.9,null,38,"7/31/2004",69.7,null,38,180]
[null,39,35000.998686919993,null,39,14020.71,null,null,1994,"MAR",43.9,null,39,"10/31/2004",68.5,null,39,193]
[null,40,36040.211766799992,null,40,13145.607,null,null,1994,"APR",47.6,null,40,"1/31/2005",82.2,null,40,181]
[null,41,36056.222165799991,null,41,12928.047,null,null,1994,"MAY",60.8,null,41,"4/30/2005",70,null,41,183]
[null,42,31397.490801459997,null,42,18213,null,null,1994,"JUN",70,null,42,"7/31/2005",75.900000000000006,null,42,218]
[null,43,32187.016273519999,null,43,22129,null,null,1994,"JUL",71.2,null,43,"10/31/2005",74.599999999999994,null,43,230]
[null,44,30321.833260560001,null,44,17787,null,null,1994,"AUG",70.900000000000006,null,44,"1/31/2006",88.4,null,44,242]
[null,45,34588.431703819995,null,45,18792,null,null,1994,"SEP",65,null,45,"4/30/2006",78.8,null,45,209]
[null,46,38878.643277360003,null,null,null,null,null,1994,"OCT",50.6,null,46,"7/31/2006",84.5,null,46,191]
[null,47,37165.953582659997,null,null,null,null,null,1994,"NOV",36.6,null,47,"10/31/2006",83.5,null,47,172]
[null,48,37111.353645160001,null,null,null,null,null,1994,"DEC",36.1,null,48,"1/31/2007",98.1,null,48,194]
[null,49,39021.156809039996,null,null,null,null,null,1995,"JAN",34.5,null,49,"4/30/2007",85.4,null,49,196]
[null,50,40737.187188079995,null,null,null,null,null,1995,"FEB",38.299999999999997,null,50,"7/31/2007",92,null,50,196]
[null,51,42358.349452859999,null,null,null,null,null,1995,"MAR",42.1,null,51,"10/31/2007",90.9,null,51,236]
[null,52,51914.080723119994,null,null,null,null,null,1995,"APR",45.1,null,52,"1/31/2008",106.3,null,52,235]
[null,53,35403.962397559997,null,null,null,null,null,1995,"MAY",50.9,null,null,null,null,null,53,229]
[null,54,30554.713527459997,null,null,null,null,null,1995,"JUN",62.4,null,null,null,null,null,54,243]
[null,55,30420.912801459999,null,null,null,null,null,1995,"JUL",70.5,null,null,null,null,null,55,264]
[null,56,30972.321850420001,null,null,null,null,null,1995,"AUG",74,null,null,null,null,null,56,272]
[null,57,32336.009937120001,null,null,null,null,null,1995,"SEP",60.4,null,null,null,null,null,57,237]
[null,58,28193.997179820006,null,null,null,null,null,1995,"OCT",50.5,null,null,null,null,null,58,211]
[null,59,29202.850057699998,null,null,null,null,null,1995,"NOV",45,null,null,null,null,null,59,180]
[null,60,28155.163889019997,null,null,null,null,null,1995,"DEC",36.299999999999997,null,null,null,null,null,60,201]
[null,61,28404.087652359998,null,null,null,null,null,1996,"JAN",29.7,null,null,null,null,null,61,204]
[null,62,34128.205685480003,null,null,null,null,null,1996,"FEB",37.700000000000003,null,null,null,null,null,62,188]
[null,null,null,null,null,null,null,null,1996,"MAR",37.9,null,null,null,null,null,63,235]
[null,null,null,null,null,null,null,null,1996,"APR",50.4,null,null,null,null,null,64,227]
[null,null,null,null,null,null,null,null,1996,"MAY",58.9,null,null,null,null,null,65,234]
[null,null,null,null,null,null,null,null,1996,"JUN",66.900000000000006,null,null,null,null,null,66,264]
[null,null,null,null,null,null,null,null,1996,"JUL",71.5,null,null,null,null,null,67,302]
[null,null,null,null,null,null,null,null,1996,"AUG",69.5,null,null,null,null,null,68,293]
[null,null,null,null,null,null,null,null,1996,"SEP",60.8,null,null,null,null,null,69,259]
[null,null,null,null,null,null,null,null,1996,"OCT",53.1,null,null,null,null,null,70,229]
[null,null,null,null,null,null,null,null,1996,"NOV",40.6,null,null,null,null,null,71,203]
[null,null,null,null,null,null,null,null,1996,"DEC",36.5,null,null,null,null,null,72,229]
[null,null,null,null,null,null,null,null,1997,"JAN",31.3,null,null,null,null,null,73,242]
[null,null,null,null,null,null,null,null,1997,"FEB",32.799999999999997,null,null,null,null,null,74,233]
[null,null,null,null,null,null,null,null,1997,"MAR",45.5,null,null,null,null,null,75,267]
[null,null,null,null,null,null,null,null,1997,"APR",42.8,null,null,null,null,null,76,269]
[null,null,null,null,null,null,null,null,1997,"MAY",57.4,null,null,null,null,null,77,270]
[null,null,null,null,null,null,null,null,1997,"JUN",66.5,null,null,null,null,null,78,315]
[null,null,null,null,null,null,null,null,1997,"JUL",71.400000000000006,null,null,null,null,null,79,364]
[null,null,null,null,null,null,null,null,1997,"AUG",68.7,null,null,null,null,null,80,347]
[null,null,null,null,null,null,null,null,1997,"SEP",64,null,null,null,null,null,81,312]
[null,null,null,null,null,null,null,null,1997,"OCT",52.7,null,null,null,null,null,82,274]
[null,null,null,null,null,null,null,null,1997,"NOV",37.9,null,null,null,null,null,83,237]
[null,null,null,null,null,null,null,null,1997,"DEC",33.9,null,null,null,null,null,84,278]
[null,null,null,null,null,null,null,null,1998,"JAN",36.5,null,null,null,null,null,85,284]
[null,null,null,null,null,null,null,null,1998,"FEB",36.4,null,null,null,null,null,86,277]
[null,null,null,null,null,null,null,null,1998,"MAR",38.700000000000003,null,null,null,null,null,87,317]
[null,null,null,null,null,null,null,null,1998,"APR",46.5,null,null,null,null,null,88,313]
[null,null,null,null,null,null,null,null,1998,"MAY",58.8,null,null,null,null,null,89,318]
[null,null,null,null,null,null,null,null,1998,"JUN",62.1,null,null,null,null,null,90,374]
[null,null,null,null,null,null,null,null,1998,"JUL",72.8,null,null,null,null,null,91,413]
[null,null,null,null,null,null,null,null,1998,"AUG",70.7,null,null,null,null,null,92,405]
[null,null,null,null,null,null,null,null,1998,"SEP",67.099999999999994,null,null,null,null,null,93,355]
[null,null,null,null,null,null,null,null,1998,"OCT",50.4,null,null,null,null,null,94,306]
[null,null,null,null,null,null,null,null,1998,"NOV",44,null,null,null,null,null,95,271]
[null,null,null,null,null,null,null,null,1998,"DEC",32.200000000000003,null,null,null,null,null,96,306]
[null,null,null,null,null,null,null,null,1999,"JAN",36.4,null,null,null,null,null,97,315]
[null,null,null,null,null,null,null,null,1999,"FEB",42.1,null,null,null,null,null,98,301]
[null,null,null,null,null,null,null,null,1999,"MAR",46,null,null,null,null,null,99,356]
[null,null,null,null,null,null,null,null,1999,"APR",44.5,null,null,null,null,null,100,348]
[null,null,null,null,null,null,null,null,1999,"MAY",55.6,null,null,null,null,null,101,355]
[null,null,null,null,null,null,null,null,1999,"JUN",64.8,null,null,null,null,null,102,422]
[null,null,null,null,null,null,null,null,1999,"JUL",73.5,null,null,null,null,null,103,465]
[null,null,null,null,null,null,null,null,1999,"AUG",69.3,null,null,null,null,null,104,467]
[null,null,null,null,null,null,null,null,1999,"SEP",58.5,null,null,null,null,null,105,404]
[null,null,null,null,null,null,null,null,1999,"OCT",51.9,null,null,null,null,null,106,347]
[null,null,null,null,null,null,null,null,1999,"NOV",48,null,null,null,null,null,107,305]
[null,null,null,null,null,null,null,null,1999,"DEC",36.9,null,null,null,null,null,108,336]
[null,null,null,null,null,null,null,null,2000,"JAN",36.4,null,null,null,null,null,109,340]
[null,null,null,null,null,null,null,null,2000,"FEB",41,null,null,null,null,null,110,318]
[null,null,null,null,null,null,null,null,2000,"MAR",42.9,null,null,null,null,null,111,362]
[null,null,null,null,null,null,null,null,2000,"APR",51.2,null,null,null,null,null,112,348]
[null,null,null,null,null,null,null,null,2000,"MAY",61,null,null,null,null,null,113,363]
[null,null,null,null,null,null,null,null,2000,"JUN",67.400000000000006,null,null,null,null,null,114,435]
[null,null,null,null,null,null,null,null,2000,"JUL",74.7,null,null,null,null,null,115,491]
[null,null,null,null,null,null,null,null,2000,"AUG",73,null,null,null,null,null,116,505]
[null,null,null,null,null,null,null,null,2000,"SEP",63.1,null,null,null,null,null,117,404]
[null,null,null,null,null,null,null,null,2000,"OCT",49.6,null,null,null,null,null,118,359]
[null,null,null,null,null,null,null,null,2000,"NOV",31.4,null,null,null,null,null,119,310]
[null,null,null,null,null,null,null,null,2000,"DEC",31.2,null,null,null,null,null,120,337]
[null,null,null,null,null,null,null,null,2001,"JAN",33,null,null,null,null,null,121,360]
[null,null,null,null,null,null,null,null,2001,"FEB",32.299999999999997,null,null,null,null,null,122,342]
[null,null,null,null,null,null,null,null,2001,"MAR",40.799999999999997,null,null,null,null,null,123,406]
[null,null,null,null,null,null,null,null,2001,"APR",50.7,null,null,null,null,null,124,396]
[null,null,null,null,null,null,null,null,2001,"MAY",58.4,null,null,null,null,null,125,420]
[null,null,null,null,null,null,null,null,2001,"JUN",68.900000000000006,null,null,null,null,null,126,472]
[null,null,null,null,null,null,null,null,2001,"JUL",75,null,null,null,null,null,127,548]
[null,null,null,null,null,null,null,null,2001,"AUG",71.8,null,null,null,null,null,128,559]
[null,null,null,null,null,null,null,null,2001,"SEP",65,null,null,null,null,null,129,463]
[null,null,null,null,null,null,null,null,2001,"OCT",53.8,null,null,null,null,null,130,407]
[null,null,null,null,null,null,null,null,2001,"NOV",43.9,null,null,null,null,null,131,362]
[null,null,null,null,null,null,null,null,2001,"DEC",35,null,null,null,null,null,132,405]
[null,null,null,null,null,null,null,null,2002,"JAN",33.1,null,null,null,null,null,133,417]
[null,null,null,null,null,null,null,null,2002,"FEB",36,null,null,null,null,null,134,391]
[null,null,null,null,null,null,null,null,2002,"MAR",37.5,null,null,null,null,null,135,419]
[null,null,null,null,null,null,null,null,2002,"APR",52.9,null,null,null,null,null,136,461]
[null,null,null,null,null,null,null,null,2002,"MAY",56.2,null,null,null,null,null,137,472]
[null,null,null,null,null,null,null,null,2002,"JUN",70.5,null,null,null,null,null,138,535]
[null,null,null,null,null,null,null,null,2002,"JUL",76.8,null,null,null,null,null,139,622]
[null,null,null,null,null,null,null,null,2002,"AUG",71.3,null,null,null,null,null,140,606]
[null,null,null,null,null,null,null,null,2002,"SEP",64,null,null,null,null,null,141,508]
[null,null,null,null,null,null,null,null,2002,"OCT",45.9,null,null,null,null,null,142,461]
[null,null,null,null,null,null,null,null,2002,"NOV",40.299999999999997,null,null,null,null,null,143,390]
[null,null,null,null,null,null,null,null,2002,"DEC",36.6,null,null,null,null,null,144,432]
[null,null,null,null,null,null,null,null,2003,"JAN",40.200000000000003]
[null,null,null,null,null,null,null,null,2003,"FEB",31.6]
[null,null,null,null,null,null,null,null,2003,"MAR",43.7]
[null,null,null,null,null,null,null,null,2003,"APR",50.6]
[null,null,null,null,null,null,null,null,2003,"MAY",57.4]
[null,null,null,null,null,null,null,null,2003,"JUN",62.8]
[null,null,null,null,null,null,null,null,2003,"JUL",75.900000000000006]
[null,null,null,null,null,null,null,null,2003,"AUG",72.900000000000006]
[null,null,null,null,null,null,null,null,2003,"SEP",60.5]
[null,null,null,null,null,null,null,null,2003,"OCT",57.4]
[null,null,null,null,null,null,null,null,2003,"NOV",39]
[null,null,null,null,null,null,null,null,2003,"DEC",36.4]
[null,null,null,null,null,null,null,null,2004,"JAN",35.4]
[null,null,null,null,null,null,null,null,2004,"FEB",33.6]
[null,null,null,null,null,null,null,null,2004,"MAR",48.2]
[null,null,null,null,null,null,null,null,2004,"APR",49.2]
[null,null,null,null,null,null,null,null,2004,"MAY",59.9]
[null,null,null,null,null,null,null,null,2004,"JUN",62.7]
[null,null,null,null,null,null,null,null,2004,"JUL",69.2]
[null,null,null,null,null,null,null,null,2004,"AUG",66.400000000000006]
[null,null,null,null,null,null,null,null,2004,"SEP",62.9]
[null,null,null,null,null,null,null,null,2004,"OCT",51.9]
[null,null,null,null,null,null,null,null,2004,"NOV",39.700000000000003]
[null,null,null,null,null,null,null,null,2004,"DEC",36.5]
[null,null,null,null,null,null,null,null,2005,"JAN",35.5]
[null,null,null,null,null,null,null,null,2005,"FEB",37.9]
[null,null,null,null,null,null,null,null,2005,"MAR",42]
[null,null,null,null,null,null,null,null,2005,"APR",48.4]
[null,null,null,null,null,null,null,null,2005,"MAY",57.6]
[null,null,null,null,null,null,null,null,2005,"JUN",65.400000000000006]
[null,null,null,null,null,null,null,null,2005,"JUL",75.099999999999994]
[null,null,null,null,null,null,null,null,2005,"AUG",69.7]
[null,null,null,null,null,null,null,null,2005,"SEP",66.5]
[null,null,null,null,null,null,null,null,2005,"OCT",52.6]
[null,null,null,null,null,null,null,null,2005,"NOV",45]
[null,null,null,null,null,null,null,null,2005,"DEC",33.299999999999997]
[null,null,null,null,null,null,null,null,2006,"JAN",40.700000000000003]
[null,null,null,null,null,null,null,null,2006,"FEB",33.700000000000003]
[null,null,null,null,null,null,null,null,2006,"MAR",39.4]
[null,null,null,null,null,null,null,null,2006,"APR",53.9]
[null,null,null,null,null,null,null,null,2006,"MAY",61]
[null,null,null,null,null,null,null,null,2006,"JUN",71.599999999999994]
[null,null,null,null,null,null,null,null,2006,"JUL",74.400000000000006]
[null,null,null,null,null,null,null,null,2006,"AUG",71.599999999999994]
[null,null,null,null,null,null,null,null,2006,"SEP",58.4]
[null,null,null,null,null,null,null,null,2006,"OCT",51]
[null,null,null,null,null,null,null,null,2006,"NOV",43.4]
[null,null,null,null,null,null,null,null,2006,"DEC",35.299999999999997]
[null,null,null,null,null,null,null,null,2007,"JAN",27.2]
[null,null,null,null,null,null,null,null,2007,"FEB",34.6]
[null,null,null,null,null,null,null,null,2007,"MAR",47.6]
[null,null,null,null,null,null,null,null,2007,"APR",47.9]
[null,null,null,null,null,null,null,null,2007,"MAY",58]
[null,null,null,null,null,null,null,null,2007,"JUN",67.7]
[null,null,null,null,null,null,null,null,2007,"JUL",74.8]
[null,null,null,null,null,null,null,null,2007,"AUG",73.7]
[null,null,null,null,null,null,null,null,2007,"SEP",64.5]
[null,null,null,null,null,null,null,null,2007,"OCT",55.2]
[null,null,null,null,null,null,null,null,2007,"NOV",44.9]
[null,null,null,null,null,null,null,null,2007,"DEC",30.2]
[null,null,null,null,null,null,null,null,2008,"JAN",31.6]
[null,null,null,null,null,null,null,null,2008,"FEB",36.1]
[null,null,null,null,null,null,null,null,2008,"MAR",40.799999999999997]
[null,null,null,null,null,null,null,null,2008,"APR",47.8]
[null,null,null,null,null,null,null,null,2008,"MAY",57.1]
[null,null,null,null,null,null,null,null,2008,"JUN",66.099999999999994]
[null,null,null,null,null,null,null,null,2008,"JUL",75]
[null,null,null,null,null,null,null,null,2008,"AUG",69.599999999999994]
[null,null,null,null,null,null,null,null,2008,"SEP",60.9]