{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","INPUT","OutputCategorization","OutputAggregation","Regression","InputLevel1","InputLevel2-Pareto","InputLevel2-Rest","InputLevel3-Smooth","SmoothCoefficients","AllVariables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Introduction","index":0,"n_rows":45,"n_cols":103,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please select a level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level3"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,147]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,null,4]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]

{"sheet":"INPUT","index":1,"n_rows":409,"n_cols":14,"rows_kept":409,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["Lane Name","Customer","Resources","Sum","Cumulative sum","Cumulative Percentage","Category","Weekly Average Demand","Origin Country","Destination Country","Period 1","Period 2","Period 3","Period 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"54/396","v":0.13636363636363635},null,"smooth",{"$f":"COUNTIF(G8:G61,\"Smooth\")","v":0}]
[null,null,null,null,"erratic",{"$f":"COUNTIF(G8:G61,\"Erratic\")","v":0}]
[null,null,null,null,"lumpy",{"$f":"COUNTIF(G8:G61,\"Lumpy\")","v":0}]
[null,null,null,null,"intermittent",{"$f":"COUNTIF(G8:G61,\"Intermittent\")","v":0}]

{"sheet":"OutputCategorization","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["GreenCat-Lanes","Customers","Resources","Category"]

{"sheet":"OutputAggregation","index":3,"n_rows":75,"n_cols":99,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["All Agg. Real Orders","Period 1","Period 2","Period 3","Period 4"]
[]
[]
[]
["All Agg. Forecast Orders","Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7"]
["Forecast"]
["All Aggregated Accuracy (MAPE %)"]
[]
[]
[]
["Pareto Agg. Real Orders","Period 1","Period 2","Period 3","Period 4"]
[]
[]
[]
["Pareto Agg. Forecast Orders","Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7"]
["Forecast"]
["Pareto Accuracy (MAPE %)"]
[]
[]
["Non-Pareto Agg. Real Orders","Period 1","Period 2","Period 3","Period 4"]
[]
[]
[]
["Non-Pareto Agg. Forecast Orders","Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7"]
["Forecast"]
["Non-Pareto Accuracy (MAPE %)"]
[]
[]
["Smooth Lane Name","Customer","Resources","Sum","Cumulative sum","Cumulative Percentage","Category","Origin Country","Destination Country","Period 1","Period 2","Period 3","Period 4"]
[]
[]
[]
[]
[]
[]
[]
["Lane Number","Column1","Resources","Sum","Cumulative sum","Cumulative Percentage","Category","Origin Country","Destination Country","Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7"]
["Forecast SmoothLane1","Error (MAE)"]
["Error SmoothLane1"]
["Forecast SmoothLane2"]
["Error SmoothLane2"]
["Forecast SmoothLane3"]
["Error SmoothLane3"]
["Forecast SmoothLane4"]
["Error SmoothLane4"]
["Forecast SmoothLane5"]
["Error SmoothLane5"]
["Forecast SmoothLane6"]
["Error SmoothLane6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]

{"sheet":"Regression","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,8,2,9],[11,8,11,9],[20,8,20,9],[29,8,29,9],[38,8,38,9]]}
[]
[]
[null,null,null,null,null,null,null,null,"Prediction Intervals"]
[null,null,null,null,null,"Lane/Company/Resource","Week","Forecasting Result","Lower Value","Upper Value"]
[null,null,null,null,null,null,"t+1"]
[null,null,null,null,null,null,"t+2"]
[null,null,null,null,null,null,"t+3"]
[null,null,null,null,null,null,"t+4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Prediction Intervals"]
[null,null,null,null,null,"Lane","Week","Forecasting Result","Lower Value","Upper Value"]
[null,null,null,null,null,null,"t+1"]
[null,null,"Confidence",null,null,null,"t+2"]
[null,null,1.96,null,null,null,"t+3"]
[null,null,null,null,null,null,"t+4"]

{"sheet":"InputLevel1","index":5,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,10,0,11],[0,18,0,19],[0,26,0,27]]}
["All network Aggregated",null,"t+1",null,null,null,null,null,null,null,"t+2",null,null,null,null,null,null,null,"t+3",null,null,null,null,null,null,null,"t+4"]
["Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2"]
[1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant"]
[2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak"]
[3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak"]
[4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas"]
[5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1"]
[6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2"]
[7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3"]
[8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4"]
[9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear"]
[10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend"]
[11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter"]
[12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay"]
[13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)"]
[14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary"]
[15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay"]
[16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany"]
[17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday"]

{"sheet":"InputLevel2-Pareto","index":6,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,18,0,19],[0,26,0,27],[0,2,0,3],[0,10,0,11]]}
["Pareto",null,"t+1",null,null,null,null,null,null,null,"t+2",null,null,null,null,null,null,null,"t+3",null,null,null,null,null,null,null,"t+4"]
["Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2"]
[1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant"]
[2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak"]
[3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak"]
[4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas"]
[5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1"]
[6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2"]
[7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3"]
[8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4"]
[9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear"]
[10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend"]
[11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter"]
[12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay"]
[13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)"]
[14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary"]
[15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay"]
[16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany"]
[17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday"]

{"sheet":"InputLevel2-Rest","index":7,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,10,0,11],[0,18,0,19],[0,26,0,27]]}
["The Rest",null,"t+1",null,null,null,null,null,null,null,"t+2",null,null,null,null,null,null,null,"t+3",null,null,null,null,null,null,null,"t+4"]
["Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2"]
[1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant"]
[2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak"]
[3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak"]
[4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas"]
[5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1"]
[6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2"]
[7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3"]
[8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4"]
[9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear"]
[10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend"]
[11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter"]
[12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay"]
[13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)"]
[14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary"]
[15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay"]
[16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany"]
[17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday"]

{"sheet":"InputLevel3-Smooth","index":8,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,10,0,11],[0,18,0,19],[0,26,0,27]]}
[null,null,null,null,"t+1",null,null,null,null,null,"t+2",null,null,null,null,null,null,null,"t+3",null,null,null,null,null,null,null,"t+4"]
["Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2",null,null,"Variable No","Variables","Variable Values","Coefficients","Error Term","adjusted R2"]
[1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant",null,null,null,null,null,null,1,"Constant"]
[2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak",null,null,null,null,null,null,2,"ExpectedPeak"]
[3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak",null,null,null,null,null,null,3,"Bouwvak"]
[4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas",null,null,null,null,null,null,4,"AroundNewYearChristmas"]
[5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1",null,null,null,null,null,null,5,"Lag1"]
[6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2",null,null,null,null,null,null,6,"Lag2"]
[7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3",null,null,null,null,null,null,7,"Lag3"]
[8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4",null,null,null,null,null,null,8,"Lag4"]
[9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear",null,null,null,null,null,null,9,"NewYear"]
[10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend",null,null,null,null,null,null,10,"Trend"]
[11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter",null,null,null,null,null,null,11,"Easter"]
[12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay",null,null,null,null,null,null,12,"AscensionDay"]
[13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)",null,null,null,null,null,null,13,"Carnival(South)"]
[14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary",null,null,null,null,null,null,14,"AssumptionofMary"]
[15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay",null,null,null,null,null,null,15,"AllSaintsDay"]
[16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany",null,null,null,null,null,null,16,"Epiphany"]
[17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday",null,null,null,null,null,null,17,"GoodFriday"]

{"sheet":"SmoothCoefficients","index":9,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Smooth Lanes","Customers","Resources","Error Term","adjusted R2","Constant","ExpectedPeak","Bouwvak","AroundNewYearChristmas","Lag1","Lag2","Lag3","Lag4","NewYear","Trend","Easter","AscensionDay","Carnival(South)","AssumptionofMary","AllSaintsDay","Epiphany","GoodFriday"]

{"sheet":"AllVariables","index":10,"n_rows":163,"n_cols":17,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
["Period","ExpectedPeak","Bouwvak","AroundNewYearChristmas","Lag1","Lag2","Lag3","Lag4","NewYear","Trend","Easter","AscensionDay","Carnival(South)","AssumptionofMary","AllSaintsDay","Epiphany","GoodFriday"]
["2012-47",null,null,null,null,null,null,null,0,1,0,0,0,0,0,0,0]
["2012-48",null,null,null,null,null,null,null,0,2,0,0,0,0,0,0,0]
["2012-49",null,null,null,null,null,null,null,0,3,0,0,0,0,0,0,0]
["2012-50",null,null,null,null,null,null,null,0,4,0,0,0,0,0,0,0]
["2012-51",null,null,null,null,null,null,null,0,5,0,0,0,0,0,0,0]
["2012-52",null,null,null,null,null,null,null,1,6,0,0,0,0,0,0,0]
["2013-1",null,null,null,null,null,null,null,0,7,0,0,0,0,0,1,0]
["2013-2",null,null,null,null,null,null,null,0,8,0,0,0,0,0,0,0]
["2013-3",null,null,null,null,null,null,null,0,9,0,0,0,0,0,0,0]
["2013-4",null,null,null,null,null,null,null,0,10,0,0,0,0,0,0,0]
["2013-5",null,null,null,null,null,null,null,0,11,0,0,0,0,0,0,0]
["2013-6",null,null,null,null,null,null,null,0,12,0,0,0,0,0,0,0]
["2013-7",null,null,null,null,null,null,null,0,13,0,0,1,0,0,0,0]
["2013-8",null,null,null,null,null,null,null,0,14,0,0,0,0,0,0,0]
["2013-9",null,null,null,null,null,null,null,0,15,0,0,0,0,0,0,0]
["2013-10",null,null,null,null,null,null,null,0,16,0,0,0,0,0,0,0]
["2013-11",null,null,null,null,null,null,null,0,17,0,0,0,0,0,0,0]
["2013-12",null,null,null,null,null,null,null,0,18,0,0,0,0,0,0,0]
["2013-13",null,null,null,null,null,null,null,0,19,0,0,0,0,0,0,1]
["2013-14",null,null,null,null,null,null,null,0,20,1,0,0,0,0,0,0]
["2013-15",null,null,null,null,null,null,null,0,21,0,0,0,0,0,0,0]
["2013-16",null,null,null,null,null,null,null,0,22,0,0,0,0,0,0,0]
["2013-17",null,null,null,null,null,null,null,0,23,0,0,0,0,0,0,0]
["2013-18",null,null,null,null,null,null,null,0,24,0,0,0,0,0,0,0]
["2013-19",null,null,null,null,null,null,null,0,25,0,1,0,0,0,0,0]
["2013-20",null,null,null,null,null,null,null,0,26,0,0,0,0,0,0,0]
["2013-21",null,null,null,null,null,null,null,0,27,0,0,0,0,0,0,0]
["2013-22",null,null,null,null,null,null,null,0,28,0,0,0,0,0,0,0]
["2013-23",null,null,null,null,null,null,null,0,29,0,0,0,0,0,0,0]
["2013-24",null,null,null,null,null,null,null,0,30,0,0,0,0,0,0,0]
["2013-25",null,null,null,null,null,null,null,0,31,0,0,0,0,0,0,0]
["2013-26",null,null,null,null,null,null,null,0,32,0,0,0,0,0,0,0]
["2013-27",null,null,null,null,null,null,null,0,33,0,0,0,0,0,0,0]
["2013-28",null,null,null,null,null,null,null,0,34,0,0,0,0,0,0,0]
["2013-29",null,null,null,null,null,null,null,0,35,0,0,0,0,0,0,0]
["2013-30",null,null,null,null,null,null,null,0,36,0,0,0,0,0,0,0]
["2013-31",null,null,null,null,null,null,null,0,37,0,0,0,0,0,0,0]
["2013-32",null,null,null,null,null,null,null,0,38,0,0,0,0,0,0,0]
["2013-33",null,null,null,null,null,null,null,0,39,0,0,0,1,0,0,0]
["2013-34",null,null,null,null,null,null,null,0,40,0,0,0,0,0,0,0]
["2013-35",null,null,null,null,null,null,null,0,41,0,0,0,0,0,0,0]
["2013-36",null,null,null,null,null,null,null,0,42,0,0,0,0,0,0,0]
["2013-37",null,null,null,null,null,null,null,0,43,0,0,0,0,0,0,0]
["2013-38",null,null,null,null,null,null,null,0,44,0,0,0,0,0,0,0]
["2013-39",null,null,null,null,null,null,null,0,45,0,0,0,0,0,0,0]
["2013-40",null,null,null,null,null,null,null,0,46,0,0,0,0,0,0,0]
["2013-41",null,null,null,null,null,null,null,0,47,0,0,0,0,0,0,0]
["2013-42",null,null,null,null,null,null,null,0,48,0,0,0,0,0,0,0]
["2013-43",null,null,null,null,null,null,null,0,49,0,0,0,0,0,0,0]
["2013-44",null,null,null,null,null,null,null,0,50,0,0,0,0,1,0,0]
["2013-45",null,null,null,null,null,null,null,0,51,0,0,0,0,0,0,0]
["2013-46",null,null,null,null,null,null,null,0,52,0,0,0,0,0,0,0]
["2013-47",null,null,null,null,null,null,null,0,53,0,0,0,0,0,0,0]
["2013-48",null,null,null,null,null,null,null,0,54,0,0,0,0,0,0,0]
["2013-49",null,null,null,null,null,null,null,0,55,0,0,0,0,0,0,0]
["2013-50",null,null,null,null,null,null,null,0,56,0,0,0,0,0,0,0]
["2013-51",null,null,null,null,null,null,null,0,57,0,0,0,0,0,0,0]
["2013-52",null,null,null,null,null,null,null,1,58,0,0,0,0,0,0,0]
["2014-1",null,null,null,null,null,null,null,0,59,0,0,0,0,0,0,0]
["2014-2",null,null,null,null,null,null,null,0,60,0,0,0,0,0,1,0]
["2014-3",null,null,null,null,null,null,null,0,61,0,0,0,0,0,0,0]
["2014-4",null,null,null,null,null,null,null,0,62,0,0,0,0,0,0,0]
["2014-5",null,null,null,null,null,null,null,0,63,0,0,0,0,0,0,0]
["2014-6",null,null,null,null,null,null,null,0,64,0,0,0,0,0,0,0]
["2014-7",null,null,null,null,null,null,null,0,65,0,0,0,0,0,0,0]
["2014-8",null,null,null,null,null,null,null,0,66,0,0,0,0,0,0,0]
["2014-9",null,null,null,null,null,null,null,0,67,0,0,0,0,0,0,0]
["2014-10",null,null,null,null,null,null,null,0,68,0,0,1,0,0,0,0]
["2014-11",null,null,null,null,null,null,null,0,69,0,0,0,0,0,0,0]
["2014-12",null,null,null,null,null,null,null,0,70,0,0,0,0,0,0,0]
["2014-13",null,null,null,null,null,null,null,0,71,0,0,0,0,0,0,0]
["2014-14",null,null,null,null,null,null,null,0,72,0,0,0,0,0,0,0]
["2014-15",null,null,null,null,null,null,null,0,73,0,0,0,0,0,0,0]
["2014-16",null,null,null,null,null,null,null,0,74,0,0,0,0,0,0,1]
["2014-17",null,null,null,null,null,null,null,0,75,1,0,0,0,0,0,0]
["2014-18",null,null,null,null,null,null,null,0,76,0,0,0,0,0,0,0]
["2014-19",null,null,null,null,null,null,null,0,77,0,0,0,0,0,0,0]
["2014-20",null,null,null,null,null,null,null,0,78,0,0,0,0,0,0,0]
["2014-21",null,null,null,null,null,null,null,0,79,0,0,0,0,0,0,0]
["2014-22",null,null,null,null,null,null,null,0,80,0,1,0,0,0,0,0]
["2014-23",null,null,null,null,null,null,null,0,81,0,0,0,0,0,0,0]
["2014-24",null,null,null,null,null,null,null,0,82,0,0,0,0,0,0,0]
["2014-25",null,null,null,null,null,null,null,0,83,0,0,0,0,0,0,0]
["2014-26",null,null,null,null,null,null,null,0,84,0,0,0,0,0,0,0]
["2014-27",null,null,null,null,null,null,null,0,85,0,0,0,0,0,0,0]
["2014-28",null,null,null,null,null,null,null,0,86,0,0,0,0,0,0,0]
["2014-29",null,null,null,null,null,null,null,0,87,0,0,0,0,0,0,0]
["2014-30",null,null,null,null,null,null,null,0,88,0,0,0,0,0,0,0]
["2014-31",null,null,null,null,null,null,null,0,89,0,0,0,0,0,0,0]
["2014-32",null,null,null,null,null,null,null,0,90,0,0,0,0,0,0,0]
["2014-33",null,null,null,null,null,null,null,0,91,0,0,0,1,0,0,0]
["2014-34",null,null,null,null,null,null,null,0,92,0,0,0,0,0,0,0]
["2014-35",null,null,null,null,null,null,null,0,93,0,0,0,0,0,0,0]
["2014-36",null,null,null,null,null,null,null,0,94,0,0,0,0,0,0,0]
["2014-37",null,null,null,null,null,null,null,0,95,0,0,0,0,0,0,0]
["2014-38",null,null,null,null,null,null,null,0,96,0,0,0,0,0,0,0]
["2014-39",null,null,null,null,null,null,null,0,97,0,0,0,0,0,0,0]
["2014-40",null,null,null,null,null,null,null,0,98,0,0,0,0,0,0,0]
["2014-41",null,null,null,null,null,null,null,0,99,0,0,0,0,0,0,0]
["2014-42",null,null,null,null,null,null,null,0,100,0,0,0,0,0,0,0]
["2014-43",null,null,null,null,null,null,null,0,101,0,0,0,0,0,0,0]
["2014-44",null,null,null,null,null,null,null,0,102,0,0,0,0,1,0,0]
["2014-45",null,null,null,null,null,null,null,0,103,0,0,0,0,0,0,0]
["2014-46",null,null,null,null,null,null,null,0,104,0,0,0,0,0,0,0]
["2014-47",null,null,null,null,null,null,null,0,105,0,0,0,0,0,0,0]
["2014-48",null,null,null,null,null,null,null,0,106,0,0,0,0,0,0,0]
["2014-49",null,null,null,null,null,null,null,0,107,0,0,0,0,0,0,0]
["2014-50",null,null,null,null,null,null,null,0,108,0,0,0,0,0,0,0]
["2014-51",null,null,null,null,null,null,null,0,109,0,0,0,0,0,0,0]
["2014-52",null,null,null,null,null,null,null,1,110,0,0,0,0,0,0,0]
["2015-1",null,null,null,null,null,null,null,0,111,0,0,0,0,0,0,0]
["2015-2",null,null,null,null,null,null,null,0,112,0,0,0,0,0,1,0]
["2015-3",null,null,null,null,null,null,null,0,113,0,0,0,0,0,0,0]
["2015-4",null,null,null,null,null,null,null,0,114,0,0,0,0,0,0,0]
["2015-5",null,null,null,null,null,null,null,0,115,0,0,0,0,0,0,0]
["2015-6",null,null,null,null,null,null,null,0,116,0,0,0,0,0,0,0]
["2015-7",null,null,null,null,null,null,null,0,117,0,0,0,0,0,0,0]
["2015-8",null,null,null,null,null,null,null,0,118,0,0,1,0,0,0,0]
["2015-9",null,null,null,null,null,null,null,0,119,0,0,0,0,0,0,0]
["2015-10",null,null,null,null,null,null,null,0,120,0,0,0,0,0,0,0]
["2015-11",null,null,null,null,null,null,null,0,121,0,0,0,0,0,0,0]
["2015-12",null,null,null,null,null,null,null,0,122,0,0,0,0,0,0,0]
["2015-13",null,null,null,null,null,null,null,0,123,0,0,0,0,0,0,0]
["2015-14",null,null,null,null,null,null,null,0,124,0,0,0,0,0,0,1]
["2015-15",null,null,null,null,null,null,null,0,125,1,0,0,0,0,0,0]
["2015-16",null,null,null,null,null,null,null,0,126,0,0,0,0,0,0,0]
["2015-17",null,null,null,null,null,null,null,0,127,0,0,0,0,0,0,0]
["2015-18",null,null,null,null,null,null,null,0,128,0,0,0,0,0,0,0]
["2015-19",null,null,null,null,null,null,null,0,129,0,0,0,0,0,0,0]
["2015-20",null,null,null,null,null,null,null,0,130,0,1,0,0,0,0,0]
["2015-21",null,null,null,null,null,null,null,0,131,0,0,0,0,0,0,0]
["2015-22",null,null,null,null,null,null,null,0,132,0,0,0,0,0,0,0]
["2015-23",null,null,null,null,null,null,null,0,133,0,0,0,0,0,0,0]
["2015-24",null,null,null,null,null,null,null,0,134,0,0,0,0,0,0,0]
["2015-25",null,null,null,null,null,null,null,0,135,0,0,0,0,0,0,0]
["2015-26",null,null,null,null,null,null,null,0,136,0,0,0,0,0,0,0]
["2015-27",null,null,null,null,null,null,null,0,137,0,0,0,0,0,0,0]
["2015-28",null,null,null,null,null,null,null,0,138,0,0,0,0,0,0,0]
["2015-29",null,null,null,null,null,null,null,0,139,0,0,0,0,0,0,0]
["2015-30",null,null,null,null,null,null,null,0,140,0,0,0,0,0,0,0]
["2015-31",null,null,null,null,null,null,null,0,141,0,0,0,0,0,0,0]
["2015-32",null,null,null,null,null,null,null,0,142,0,0,0,0,0,0,0]
["2015-33",null,null,null,null,null,null,null,0,143,0,0,0,1,0,0,0]
["2015-34",null,null,null,null,null,null,null,0,144,0,0,0,0,0,0,0]
["2015-35",null,null,null,null,null,null,null,0,145,0,0,0,0,0,0,0]
["2015-36",null,null,null,null,null,null,null,0,146,0,0,0,0,0,0,0]
["2015-37",null,null,null,null,null,null,null,0,147,0,0,0,0,0,0,0]
["2015-38",null,null,null,null,null,null,null,0,148,0,0,0,0,0,0,0]
["2015-39",null,null,null,null,null,null,null,0,149,0,0,0,0,0,0,0]
["2015-40",null,null,null,null,null,null,null,0,150,0,0,0,0,0,0,0]
["2015-41",null,null,null,null,null,null,null,0,151,0,0,0,0,0,0,0]
["2015-42",null,null,null,null,null,null,null,0,152,0,0,0,0,0,0,0]
["2015-43",null,null,null,null,null,null,null,0,153,0,0,0,0,0,0,0]
["2015-44",null,null,null,null,null,null,null,0,154,0,0,0,0,1,0,0]
["2015-45",null,null,null,null,null,null,null,0,155,0,0,0,0,0,0,0]
["2015-46",null,null,null,null,null,null,null,0,156,0,0,0,0,0,0,0]
["2015-47",null,null,null,null,null,null,null,0,157,0,0,0,0,0,0,0]
["2015-48",null,null,null,null,null,null,null,0,158,0,0,0,0,0,0,0]
["2015-49",null,null,null,null,null,null,null,0,159,0,0,0,0,0,0,0]
["2015-50",null,null,null,null,null,null,null,0,160,0,0,0,0,0,0,0]
["2015-51",null,null,null,null,null,null,null,0,161,0,0,0,0,0,0,0]
["2015-52",null,null,null,null,null,null,null,1,162,0,0,0,0,0,0,0]