{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["User Guide","Dashboard TR_Operational ","Dashboard WH_Operational","Dashboard CC_Operational","Dashboard TACTICAL","Dashboard STRATEGIC","Parameters","Data_WH_outb","TR_summary","WH_summary","CC_summary","Summary Tactical","Summary Strategic"],"not_rendered":{"charts":56,"images":8,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":1},"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":"User Guide","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Een dashboard voor logistiek kritische processen"]
[]
["In deze excel sheet vindt u een voorbeeld van een dashboard voor logistiek kritische processen."]
[]
["Een korte toelichting:"]
["De groene tabbladen geven de dashboards weer voor een drietal building blocks, plus een dashboard op tactisch en strategisch niveau."]
["De waarden die worden weergegeven in de verschillene grafieken worden gehaald uit de oranje tabbladen (zie onderaan). Alle data is gefingeerd."]
[]
["Ter illustratie is voor het Dashboard_WH_Operational de link met de achterliggende parameters te zien. Hierdoor is te zien hoe getallen"]
["uit een achterliggende excelsheet met parameters kan worden afgeleid."]
["Door middel van pivot tables wordt (de gefingeerde data in het tabblad Data_WH_outb) samengevat weergegeven in tabblad WH_Summary."]
[]
["Door het aanpassen van getallen in de oranje tabbladen kunnen de waarden in de dashboards worden veranderd."]
[]
["Wilt u meer weten over welke KPI's OneLogistics hanteert in de verschillende building blocks, neem dan gerust contact op."]
[]
[]
[]
[]
["Dit product is een resultaat van de Dinalog Conversion Factory (uitgevoerd door de Technische Universiteit Eindhoven)."]

{"sheet":"Dashboard TR_Operational ","index":1,"n_rows":74,"n_cols":28,"rows_kept":74,"cut":false,"hidden":false,"merged":[[7,1,28,2],[73,21,94,22],[101,13,103,14],[29,1,49,2],[50,1,71,2],[73,1,94,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email","XXXXXXXXXXXXXXXXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date",null,2012]
[null,"Delivery Performance Summary"]
[null,"Shipment Performance"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Shipment Quantity/Quality"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sustainability"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Order Processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation"]

{"sheet":"Dashboard WH_Operational","index":2,"n_rows":36,"n_cols":28,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,1,12,2],[35,1,56,2],[13,1,33,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email","XXXXXXXXXXXXXXXXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date",null,2012]
[null,"Delivery Performance Summary"]
[null,"Order Fulfilment"]
[]
[]
[]
[]
[]
[null,"Order Quantity/Quality"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Order Completeness"]

{"sheet":"Dashboard CC_Operational","index":3,"n_rows":36,"n_cols":28,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,1,12,2],[13,1,33,2],[35,1,56,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email","XXXXXXXXXXXXXXXXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date",null,2012]
[null,"Delivery Performance Summary"]
[null,"Order Fulfilment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Order Completeness"]

{"sheet":"Dashboard TACTICAL","index":4,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Contact","XXXXXXXXXXXXXXXXXXX"]
[null,null,"Phone","XXXXXXXXXXXXXXXXXXX"]
[null,null,"Email","XXXXXXXXXXXXXXXXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date",2012]
[null,"Delivery Performance Summary"]

{"sheet":"Dashboard STRATEGIC","index":5,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Contact","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,"Phone","XXXXXXXXXXXXXXXXXXX"]
[null,null,null,null,null,null,"Email","XXXXXXXXXXXXXXXXXXX"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year to Date",2012]
[null,null,"Delivery Performance Summary"]

{"sheet":"Parameters","index":6,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
[null,null,"Overall Target","Montly Target",null,null,null,null,null,null,null,null,null,null,null,null,"Ranges needed for the speedometers in the dashboard [Upper bound]"]
[null,null,null,"Jan","Feb","Mrt","Apr","Mei","Jun","Jul","Aug","Sep","Okt","Nov","Dec","Representation","OK","Acceptable","NOK"]
[null,"Strategic","Overall"]
[null,"On time",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"a KPI",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[]
[null,"Tactical","Overall"]
[null,"Delivery Location Accuracy",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"On time",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"Average delay",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pie Chart"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"---"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"---"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"---"]
[null,"a KPI",0.9,0.9,0.9,0.9,0.9,null,null,null,null,null,null,null,null,"Line Chart"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"Total Logistics Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Chart"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area Chart"]
[null,"Operational","Target"]
[null,"Transportation"]
[null,"Shipments arriving to the correct location",0.95,0.95,0.95,0.95,0.95]
[null,"On Time Pickup",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"Avg Lead Time",2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"On Time Delivery",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"Avg Delivery Delay",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pie Chart"]
[null,"Confirmation Delay",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pie Chart"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"a KPI",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Line Chart"]
[null,"a KPI",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"a KPI",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"Shipment completeness",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"a KPI"]
[null,"Invoice Accuracy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Area chart"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Line chart"]
[null,"Warehousing","Target"]
[null,"On Time Dispatching",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"Avg Dispatching Delay",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pie chart"]
[null,"Picking Accuracy",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar chart"]
[null,"Transferred shipments with proper packing",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar chart"]
[null,"WH volume/weight Accuracy",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar chart"]
[null,"WH transfer completeness",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar chart"]
[null,"WH Order compliance",0.98,0.98,0.98,0.98,0.98,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"Total storage cost"]
[null,"Packaging","Target"]
[null,"a KPI",0.95,0.95,0.95,0.95,0.95]
[null,"a KPI",0.95,0.95,0.95,0.95,0.95]
[null,"Compliance Inspection","Target"]
[null,"a KPI"]
[null,"a KPI"]
[null,"a KPI"]
[null,"Compliance Documentation Accuracy"]
[null,"Economic penalizations"]
[null,"Clearing Customs","Target"]
[null,"CC On Time",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Speedometer",100,80,70]
[null,"a KPI"]
[null,"CC Documentation Accuracy",0.95,0.95,0.95,0.95,0.95,null,null,null,null,null,null,null,null,"Bar Chart"]
[null,"a KPI"]
[null,"a KPI",null,null,null,null,null,null,null,null,null,null,null,null,null,"Line Chart"]
[null,"a KPI"]
[null,"a KPI"]
[]
[null,"Tab color coded legend"]
[null,"Input Data and Calculations"]
[null,"Data Summary (per Building Block)"]
[null,"Dashboard"]
[]
[null,"Assumptions"]
[null,"Export Market - All shipments have to clear customs"]
[null,"Expected time to clear customs [hrs]",12]
[null,"The promised delivery date is 3 days after receiving the sales order"]
[null,"If the shipment has the category of emergency, the agreed date is 2 days"]
[null,"Storage cost is 15% of the transportation cost"]

{"sheet":"Data_WH_outb","index":7,"n_rows":139,"n_cols":26,"rows_kept":139,"cut":false,"hidden":false,"merged":[[7,5,7,6],[7,7,7,8]]}
["FICTIVE DATA FOR DEMONSTRATION PURPOSES"]
[]
["The cut off time is 12 or 16"]
["Input Data TR"]
["Input Data WH"]
["Calculation"]
["if the order is received before 12. the dispatch time is at 16, if not, it would be the following day at 12."]
[null,null,null,null,null,"Agreed dispatching date",null,"Real Dispatching Date"]
["Shipment ID","Month","Date","Time","Storage cost","Day","Time","Day","Time","On Time \nDispatching","Packing Complaints  from TR/customer","volume/weight discrepancies","Quantity discrepancies","LeadTime \n[Hrs]","Dispatching Delay\n [hrs]","Transferred orders with proper packing","Volume/Weight Accuracy","Entry location mistake","Entry Location accuracy","Picking accuracy","Damaged \norders","Undamaged orders","Packaging \nmistakes","Orders with proper packaging","WH transfer completeness","WH completeness"]
["XXXXX1","Jan","2012-01-01",9,54,{"$f":"IF(D10<=12,C10,C10+1)","v":"2012-01-01"},{"$f":"IF(F10-C10=0,16,12)","v":16},{"$f":"IF(J10=1,F10,IF(F10=C10,F10+1,F10))","v":"2012-01-01"},{"$f":"IF(J10=1,G10,IF(F10=H10,16,12))","v":16},{"$f":"IF(RAND()<=0.8,1,0)","v":1},{"$f":"IF(RAND()<=0.2,1,0)","v":0},{"$f":"IF(RAND()<=0.3,1,0)","v":0},{"$f":"IF(RAND()<=0.95,0,1)","v":0},{"$f":"IF(H10=C10,I10-D10,(H10-C10)*24+IF(D10-I10=0,0,I10-D10))","v":7},{"$f":"IF(J10=1,\"\",IF(F10=H10,I10-G10,20))","v":""},{"$f":"IF(K10=1,0,1)","v":1},{"$f":"IF(L10=1,0,1)","v":1},{"$f":"IF(RAND()<=0.95,0,1)","v":0},{"$f":"IF(R10=1,0,1)","v":1},{"$f":"IF(M10=1,0,1)","v":1},{"$f":"IF(RAND()<=0.95,0,1)","v":0},{"$f":"IF(U10=1,0,1)","v":1},{"$f":"IF(RAND()<=0.9,0,1)","v":0},{"$f":"IF(W10=1,0,1)","v":1},{"$f":"AVERAGE(P10,Q10)","v":1},{"$f":"AVERAGE(T10,S10,Y10)","v":1}]
["XXXXX2","Jan","2012-01-02",8,108,"2012-01-02",16,"2012-01-02",16,{"$f":"IF(RAND()<=0.8,1,0)","v":1},{"$f":"IF(RAND()<=0.2,1,0)","v":1},{"$f":"IF(RAND()<=0.3,1,0)","v":0},{"$f":"IF(RAND()<=0.95,0,1)","v":0},8,"",0,1,0,{"$f":"IF(R11=1,0,1)","v":1},1,{"$f":"IF(RAND()<=0.95,0,1)","v":0},{"$f":"IF(U11=1,0,1)","v":1},{"$f":"IF(RAND()<=0.9,0,1)","v":0},{"$f":"IF(W11=1,0,1)","v":1},0.5,{"$f":"AVERAGE(T11,S11,Y11)","v":0.83333333333333337}]
["XXXXX3","Jan","2012-01-03",15,81,"2012-01-04",12,"2012-01-04",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX4","Jan","2012-01-04",8,54,"2012-01-04",16,"2012-01-04",16,1,0,1,0,8,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX5","Jan","2012-01-05",14,63,"2012-01-06",12,"2012-01-06",12,1,0,1,0,22,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX6","Jan","2012-01-06",15,108,"2012-01-07",12,"2012-01-07",16,0,0,0,0,25,4,1,1,1,0,1,0,1,0,1,1,0.66666666666666663]
["XXXXX7","Jan","2012-01-07",11,108,"2012-01-07",16,"2012-01-07",16,1,1,0,0,5,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX8","Jan","2012-01-08",9,45,"2012-01-08",16,"2012-01-09",12,0,0,0,0,27,20,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX9","Jan","2012-01-09",18,81,"2012-01-10",12,"2012-01-10",12,1,0,0,0,18,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX10","Jan","2012-01-10",12,108,"2012-01-10",16,"2012-01-10",16,1,0,1,0,4,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX11","Jan","2012-01-11",7,108,"2012-01-11",16,"2012-01-11",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX12","Jan","2012-01-12",10,108,"2012-01-12",16,"2012-01-12",16,1,1,1,0,6,"",0,0,0,1,1,0,1,0,1,0,0.66666666666666663]
["XXXXX13","Jan","2012-01-13",19,45,"2012-01-14",12,"2012-01-14",12,1,0,0,0,17,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX14","Jan","2012-01-14",10,90,"2012-01-14",16,"2012-01-15",12,0,0,0,0,26,20,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX15","Jan","2012-01-15",18,108,"2012-01-16",12,"2012-01-16",16,0,0,0,0,22,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX16","Jan","2012-01-16",16,63,"2012-01-17",12,"2012-01-17",16,0,0,0,0,24,4,1,1,1,0,1,0,1,0,1,1,0.66666666666666663]
["XXXXX17","Jan","2012-01-17",12,54,"2012-01-17",16,"2012-01-17",16,1,0,1,0,4,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX18","Jan","2012-01-18",19,63,"2012-01-19",12,"2012-01-19",16,0,0,0,0,21,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX19","Jan","2012-01-19",14,108,"2012-01-20",12,"2012-01-20",12,1,0,1,0,22,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX20","Jan","2012-01-20",16,90,"2012-01-21",12,"2012-01-21",12,1,1,1,0,20,"",0,0,0,1,1,0,1,0,1,0,0.66666666666666663]
["XXXXX21","Jan","2012-01-21",15,63,"2012-01-22",12,"2012-01-22",16,0,0,0,0,25,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX22","Jan","2012-01-22",17,63,"2012-01-23",12,"2012-01-23",12,1,0,0,0,19,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX23","Jan","2012-01-23",18,45,"2012-01-24",12,"2012-01-24",12,1,1,1,0,18,"",0,0,0,1,1,0,1,0,1,0,0.66666666666666663]
["XXXXX24","Jan","2012-01-24",11,90,"2012-01-24",16,"2012-01-24",16,1,1,1,0,5,"",0,0,0,1,1,0,1,0,1,0,0.66666666666666663]
["XXXXX25","Jan","2012-01-25",18,36,"2012-01-26",12,"2012-01-26",12,1,0,1,0,18,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX26","Jan","2012-01-26",17,108,"2012-01-27",12,"2012-01-27",16,0,0,0,0,23,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX27","Jan","2012-01-27",16,36,"2012-01-28",12,"2012-01-28",12,1,0,1,0,20,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX28","Jan","2012-01-28",18,63,"2012-01-29",12,"2012-01-29",12,1,0,1,0,18,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX29","Jan","2012-01-29",14,63,"2012-01-30",12,"2012-01-30",12,1,0,1,0,22,"",1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX30","Jan","2012-01-30",7,90,"2012-01-30",16,"2012-01-30",16,1,0,0,1,9,"",1,1,0,1,0,0,1,1,0,1,0.66666666666666663]
["XXXXX31","Jan","2012-01-31",15,36,"2012-02-01",12,"2012-02-01",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX32","Feb","2012-02-01",19,108,"2012-02-02",12,"2012-02-02",12,1,0,0,0,17,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX33","Feb","2012-02-02",9,81,{"$f":"IF(D42<=12,C42,C42+1)","v":"2012-02-02"},{"$f":"IF(F42-C42=0,16,12)","v":16},{"$f":"IF(J42=1,F42,IF(F42=C42,F42+1,F42))","v":"2012-02-02"},{"$f":"IF(J42=1,G42,IF(F42=H42,16,12))","v":16},1,0,0,0,{"$f":"IF(H42=C42,I42-D42,(H42-C42)*24+IF(D42-I42=0,0,I42-D42))","v":7},{"$f":"IF(J42=1,\"\",IF(F42=H42,I42-G42,20))","v":""},{"$f":"IF(K42=1,0,1)","v":1},{"$f":"IF(L42=1,0,1)","v":1},0,1,{"$f":"IF(M42=1,0,1)","v":1},0,1,0,1,{"$f":"AVERAGE(P42,Q42)","v":1},1]
["XXXXX34","Feb","2012-02-03",7,81,"2012-02-03",16,"2012-02-03",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX35","Feb","2012-02-04",12,18,"2012-02-04",16,"2012-02-04",16,1,0,0,0,4,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX36","Feb","2012-02-05",16,36,"2012-02-06",12,"2012-02-06",16,0,0,0,0,24,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX37","Feb","2012-02-06",14,108,"2012-02-07",12,"2012-02-07",12,1,0,0,0,22,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX38","Feb","2012-02-07",8,108,"2012-02-07",16,"2012-02-07",16,1,0,0,0,8,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX39","Feb","2012-02-08",15,108,"2012-02-09",12,"2012-02-09",12,1,0,1,0,21,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX40","Feb","2012-02-09",9,63,"2012-02-09",16,"2012-02-09",16,1,0,0,0,7,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX41","Feb","2012-02-10",7,63,"2012-02-10",16,"2012-02-10",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX42","Feb","2012-02-11",16,81,"2012-02-12",12,"2012-02-12",12,1,1,0,0,20,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX43","Feb","2012-02-12",10,90,"2012-02-12",16,"2012-02-13",12,0,0,0,0,26,20,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX44","Feb","2012-02-13",7,63,"2012-02-13",16,"2012-02-13",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX45","Feb","2012-02-14",15,63,"2012-02-15",12,"2012-02-15",12,1,0,0,0,21,"",1,1,0,1,1,1,0,0,1,1,1]
["XXXXX46","Feb","2012-02-15",12,36,"2012-02-15",16,"2012-02-15",16,1,0,0,0,4,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX47","Feb","2012-02-16",15,90,"2012-02-17",12,"2012-02-17",12,1,1,0,0,21,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX48","Feb","2012-02-17",15,108,"2012-02-18",12,"2012-02-18",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX49","Feb","2012-02-18",18,63,"2012-02-19",12,"2012-02-19",16,0,0,0,0,22,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX50","Feb","2012-02-19",8,90,"2012-02-19",16,"2012-02-19",16,1,0,1,0,8,"",1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX51","Feb","2012-02-20",7,90,"2012-02-20",16,"2012-02-20",16,1,0,1,0,9,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX52","Feb","2012-02-21",7,81,"2012-02-21",16,"2012-02-21",16,1,1,1,0,9,"",0,0,0,1,1,0,1,0,1,0,0.66666666666666663]
["XXXXX53","Feb","2012-02-22",15,126,"2012-02-23",12,"2012-02-23",12,1,0,0,0,21,"",1,1,0,1,1,1,0,0,1,1,1]
["XXXXX54","Feb","2012-02-23",17,90,"2012-02-24",12,"2012-02-24",12,1,0,0,0,19,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX55","Feb","2012-02-24",15,63,"2012-02-25",12,"2012-02-25",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX56","Feb","2012-02-25",15,36,"2012-02-26",12,"2012-02-26",16,0,0,0,0,25,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX57","Feb","2012-02-26",9,81,"2012-02-26",16,"2012-02-26",16,1,1,0,1,7,"",0,1,0,1,0,0,1,0,1,0.5,0.5]
["XXXXX58","Feb","2012-02-27",8,81,"2012-02-27",16,"2012-02-27",16,1,0,0,0,8,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX59","Feb","2012-02-28",7,63,"2012-02-28",16,"2012-02-28",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX60","Feb","2012-02-29",17,54,"2012-03-01",12,"2012-03-01",16,0,0,0,0,23,4,1,1,1,0,1,0,1,0,1,1,0.66666666666666663]
["XXXXX61","Mar","2012-03-01",18,90,"2012-03-02",12,"2012-03-02",16,0,0,0,0,22,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX62","Mar","2012-03-02",8,45,"2012-03-02",16,"2012-03-02",16,1,0,1,0,8,"",1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX63","Mar","2012-03-03",15,63,"2012-03-04",12,"2012-03-04",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX64","Mar","2012-03-04",16,81,"2012-03-05",12,"2012-03-05",16,0,1,0,0,24,4,0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX65","Mar","2012-03-05",9,54,{"$f":"IF(D74<=12,C74,C74+1)","v":"2012-03-05"},{"$f":"IF(F74-C74=0,16,12)","v":16},{"$f":"IF(J74=1,F74,IF(F74=C74,F74+1,F74))","v":"2012-03-06"},{"$f":"IF(J74=1,G74,IF(F74=H74,16,12))","v":12},0,0,1,0,{"$f":"IF(H74=C74,I74-D74,(H74-C74)*24+IF(D74-I74=0,0,I74-D74))","v":27},{"$f":"IF(J74=1,\"\",IF(F74=H74,I74-G74,20))","v":20},{"$f":"IF(K74=1,0,1)","v":1},{"$f":"IF(L74=1,0,1)","v":0},1,0,{"$f":"IF(M74=1,0,1)","v":1},0,1,0,1,{"$f":"AVERAGE(P74,Q74)","v":0.5},0.5]
["XXXXX66","Mar","2012-03-06",8,81,"2012-03-06",16,"2012-03-06",16,{"$f":"IF(RAND()<=0.8,1,0)","v":1},{"$f":"IF(RAND()<=0.2,1,0)","v":0},{"$f":"IF(RAND()<=0.3,1,0)","v":0},{"$f":"IF(RAND()<=0.95,0,1)","v":0},8,"",1,1,0,{"$f":"IF(R75=1,0,1)","v":1},1,{"$f":"IF(RAND()<=0.95,0,1)","v":0},{"$f":"IF(U75=1,0,1)","v":1},{"$f":"IF(RAND()<=0.9,0,1)","v":0},{"$f":"IF(W75=1,0,1)","v":1},1,{"$f":"AVERAGE(T75,S75,Y75)","v":1}]
["XXXXX67","Mar","2012-03-07",9,63,"2012-03-07",16,"2012-03-07",16,1,0,0,0,7,"",1,1,0,1,1,1,0,1,0,1,1]
["XXXXX68","Mar","2012-03-08",18,108,"2012-03-09",12,"2012-03-09",12,1,0,0,0,18,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX69","Mar","2012-03-09",11,36,"2012-03-09",16,"2012-03-09",16,1,0,0,0,5,"",1,1,0,1,1,1,0,0,1,1,1]
["XXXXX70","Mar","2012-03-10",14,108,"2012-03-11",12,"2012-03-11",12,1,0,0,0,22,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX71","Mar","2012-03-11",8,108,"2012-03-11",16,"2012-03-12",12,0,0,0,0,28,20,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX72","Mar","2012-03-12",7,90,"2012-03-12",16,"2012-03-12",16,1,0,1,0,9,"",1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX73","Mar","2012-03-13",17,63,"2012-03-14",12,"2012-03-14",12,1,0,0,0,19,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX74","Mar","2012-03-14",8,81,"2012-03-14",16,"2012-03-14",16,1,0,0,0,8,"",1,1,1,0,1,0,1,1,0,1,0.66666666666666663]
["XXXXX75","Mar","2012-03-15",15,81,"2012-03-16",12,"2012-03-16",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX76","Mar","2012-03-16",13,108,"2012-03-17",12,"2012-03-17",12,1,0,0,0,23,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX77","Mar","2012-03-17",12,63,"2012-03-17",16,"2012-03-17",16,1,0,1,0,4,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX78","Mar","2012-03-18",15,90,"2012-03-19",12,"2012-03-19",12,1,0,0,1,21,"",1,1,0,1,0,0,1,1,0,1,0.66666666666666663]
["XXXXX79","Mar","2012-03-19",13,81,"2012-03-20",12,"2012-03-20",12,1,0,1,0,23,"",1,0,0,1,1,1,0,1,0,0.5,0.83333333333333337]
["XXXXX80","Mar","2012-03-20",16,54,"2012-03-21",12,"2012-03-21",16,0,0,0,0,24,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX81","Mar","2012-03-21",19,81,"2012-03-22",12,"2012-03-22",12,1,1,0,0,17,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX82","Mar","2012-03-22",12,126,"2012-03-22",16,"2012-03-23",12,0,0,0,0,24,20,1,1,0,1,1,1,0,0,1,1,1]
["XXXXX83","Mar","2012-03-23",8,54,"2012-03-23",16,"2012-03-23",16,1,0,0,1,8,"",1,1,0,1,0,0,1,1,0,1,0.66666666666666663]
["XXXXX84","Mar","2012-03-24",14,63,"2012-03-25",12,"2012-03-25",12,1,1,0,0,22,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX85","Mar","2012-03-25",10,81,"2012-03-25",16,"2012-03-25",16,1,0,0,0,6,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX86","Mar","2012-03-26",9,108,"2012-03-26",16,"2012-03-26",16,1,0,0,0,7,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX87","Mar","2012-03-27",14,45,"2012-03-28",12,"2012-03-28",12,1,0,0,0,22,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX88","Mar","2012-03-28",17,54,"2012-03-29",12,"2012-03-29",12,1,0,0,0,19,"",1,1,1,0,1,0,1,0,1,1,0.66666666666666663]
["XXXXX89","Mar","2012-03-29",12,126,"2012-03-29",16,"2012-03-29",16,1,0,0,0,4,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX90","Mar","2012-03-30",7,81,"2012-03-30",16,"2012-03-30",16,1,1,0,0,9,"",0,1,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX91","Mar","2012-03-31",18,36,"2012-04-01",12,"2012-04-01",12,1,0,0,0,18,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX92","Apr","2012-04-01",15,81,"2012-04-02",12,"2012-04-02",12,1,0,1,0,21,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX93","Apr","2012-04-02",14,108,"2012-04-03",12,"2012-04-03",12,1,0,0,0,22,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX94","Apr","2012-04-03",8,81,"2012-04-03",16,"2012-04-03",16,1,0,0,0,8,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX95","Apr","2012-04-04",10,90,"2012-04-04",16,"2012-04-04",16,1,0,1,0,6,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX96","Apr","2012-04-05",9,108,"2012-04-05",16,"2012-04-05",16,1,0,0,0,7,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX97","Apr","2012-04-06",13,108,{"$f":"IF(D106<=12,C106,C106+1)","v":"2012-04-07"},{"$f":"IF(F106-C106=0,16,12)","v":12},{"$f":"IF(J106=1,F106,IF(F106=C106,F106+1,F106))","v":"2012-04-07"},{"$f":"IF(J106=1,G106,IF(F106=H106,16,12))","v":16},0,0,1,0,{"$f":"IF(H106=C106,I106-D106,(H106-C106)*24+IF(D106-I106=0,0,I106-D106))","v":27},{"$f":"IF(J106=1,\"\",IF(F106=H106,I106-G106,20))","v":4},{"$f":"IF(K106=1,0,1)","v":1},{"$f":"IF(L106=1,0,1)","v":0},0,1,{"$f":"IF(M106=1,0,1)","v":1},0,1,0,1,{"$f":"AVERAGE(P106,Q106)","v":0.5},0.83333333333333337]
["XXXXX98","Apr","2012-04-07",12,108,"2012-04-07",16,"2012-04-08",12,0,0,0,1,24,20,1,1,0,1,0,0,1,0,1,1,0.66666666666666663]
["XXXXX99","Apr","2012-04-08",11,54,"2012-04-08",16,"2012-04-08",16,1,1,0,0,5,"",0,1,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX100","Apr","2012-04-09",18,108,"2012-04-10",12,"2012-04-10",12,1,0,0,0,18,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX101","Apr","2012-04-10",14,108,"2012-04-11",12,"2012-04-11",12,1,0,0,1,22,"",1,1,0,1,0,0,1,1,0,1,0.66666666666666663]
["XXXXX102","Apr","2012-04-11",17,108,"2012-04-12",12,"2012-04-12",16,0,0,0,0,23,4,1,1,0,1,1,0,1,0,1,1,1]
["XXXXX103","Apr","2012-04-12",16,36,"2012-04-13",12,"2012-04-13",12,1,0,1,0,20,"",1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX104","Apr","2012-04-13",15,63,"2012-04-14",12,"2012-04-14",12,1,0,1,0,21,"",1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX105","Apr","2012-04-14",15,108,"2012-04-15",12,"2012-04-15",12,1,1,0,1,21,"",0,1,0,1,0,0,1,0,1,0.5,0.5]
["XXXXX106","Apr","2012-04-15",15,90,"2012-04-16",12,"2012-04-16",16,0,0,1,0,25,4,1,0,0,1,1,0,1,0,1,0.5,0.83333333333333337]
["XXXXX107","Apr","2012-04-16",16,90,"2012-04-17",12,"2012-04-17",12,1,0,0,0,20,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX108","Apr","2012-04-17",8,36,"2012-04-17",16,"2012-04-17",16,1,0,0,1,8,"",1,1,0,1,0,0,1,0,1,1,0.66666666666666663]
["XXXXX109","Apr","2012-04-18",19,45,"2012-04-19",12,"2012-04-19",12,1,0,0,0,17,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX110","Apr","2012-04-19",15,63,"2012-04-20",12,"2012-04-20",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX111","Apr","2012-04-20",11,108,"2012-04-20",16,"2012-04-20",16,1,0,0,0,5,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX112","Apr","2012-04-21",19,126,"2012-04-22",12,"2012-04-22",16,0,0,1,0,21,4,1,0,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX113","Apr","2012-04-22",7,36,"2012-04-22",16,"2012-04-22",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX114","Apr","2012-04-23",7,63,"2012-04-23",16,"2012-04-23",16,1,0,0,0,9,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX115","Apr","2012-04-24",13,81,"2012-04-25",12,"2012-04-25",12,1,0,0,0,23,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX116","Apr","2012-04-25",16,108,"2012-04-26",12,"2012-04-26",12,1,1,0,0,20,"",0,1,0,1,1,0,1,1,0,0.5,0.83333333333333337]
["XXXXX117","Apr","2012-04-26",11,90,"2012-04-26",16,"2012-04-26",16,1,0,0,0,5,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX118","Apr","2012-04-27",15,63,"2012-04-28",12,"2012-04-28",12,1,0,0,0,21,"",1,1,0,1,1,0,1,1,0,1,1]
["XXXXX119","Apr","2012-04-28",15,63,"2012-04-29",12,"2012-04-29",12,1,0,0,0,21,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX120","Apr","2012-04-29",14,90,"2012-04-30",12,"2012-04-30",12,1,0,0,0,22,"",1,1,0,1,1,0,1,0,1,1,1]
["XXXXX121","Apr","2012-04-30",16,54,"2012-05-01",12,"2012-05-01",12,1,1,0,0,20,"",0,1,0,1,1,0,1,1,0,0.5,0.83333333333333337]
[]
[]
["Delays"]
["1 hr",null,{"$f":"COUNTIF($O$10:$O$131,\"=1\")","v":0},{"$f":"C134/(COUNTA($O$10:$O$131) + COUNTBLANK($O$10:$O$131))","v":0}]
["2 hrs",null,{"$f":"COUNTIF($O$10:$O$131,\"=2\")","v":0},{"$f":"C135/(COUNTA($O$10:$O$131) + COUNTBLANK($O$10:$O$131))","v":0}]
["3 hrs",null,{"$f":"COUNTIF($O$10:$O$131,\"=3\")","v":0},{"$f":"C136/(COUNTA($O$10:$O$131) + COUNTBLANK($O$10:$O$131))","v":0}]
["12 hrs",null,{"$f":"COUNTIF($O$10:$O$131,\"=12\")","v":0},{"$f":"C137/(COUNTA($O$10:$O$131) + COUNTBLANK($O$10:$O$131))","v":0}]
[null,null,{"$f":"SUM(C134:C137)","v":0}]
[null,null,{"$f":"COUNT($O$10:$O$131)","v":24}]

{"sheet":"TR_summary","index":8,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,29,3,30],[3,0,3,1],[47,0,47,1]]}
[]
["Data Ranges for the speedometers"]
["On Time Deliveries",null,"Shipment completeness",null,"Invoice Accuracy"]
["Ranges",null,"Ranges",null,"Ranges"]
["Start",0,"Start",0,"Start",0]
["Red",{"$f":"Parameters!$S$23","v":70},"Red",{"$f":"Parameters!$S$30","v":70},"Red",{"$f":"Parameters!$S$32","v":70}]
["Yellow",{"$f":"Parameters!$R$23-B6","v":10},"Yellow",{"$f":"Parameters!R30-Parameters!S30","v":10},"Yellow",{"$f":"Parameters!R32-Parameters!S32","v":10}]
["Green",{"$f":"Parameters!$Q$23-Parameters!$R$23","v":20},"Green",{"$f":"Parameters!$Q$30-Parameters!$R$30","v":20},"Green",{"$f":"Parameters!Q32-Parameters!R32","v":20}]
["End",100,"End",100,"End",100]
["Current Value",{"$f":"E32*100","v":68.59504132231406},"Current Value",{"$f":"J32*100","v":90.909090909090907},"Current Value",{"$f":"K32*100","v":88.429752066115711}]
["Pointer",1.5,"Pointer",1.5,"Pointer",1.5]
["End",{"$f":"200-(B10+B11)","v":129.90495867768595},"End",{"$f":"200-(D10+D11)","v":107.59090909090909},"End",{"$f":"200-(F10+F11)","v":110.07024793388429}]
[]
[]
[]
[]
["Data for the pie charts"]
["Confirmation delay [days]","Count","Average Delay [days]","Count"]
[1,53,1,0]
[2,32,2,16]
[3,36,3,14]
[4,0,4,0]
[]
[]
["Data for bar/line charts"]
[]
["Row Labels","Average of Shipments arriving to the correct location"," On time pickup","Average of Avg Lead Time [days]","Average of On time Deliveries","Average of Confirmation Delay [days]","a KPI","a KPI","a KPI","a KPI","Average of Invoice Accuracy","a KPI","a KPI","a KPI","a KPI"]
["jan",0.90322580645161288,0.967741935483871,3.3548387096774199,0.74193548387096775,1.7459677419354838,56,0.97849462365591411,0.89247311827956977,0.93548387096774188,0.87096774193548387,503.22580645161293,9.6774193548387094E-2,0.90322580645161288,170533.44689285717]
["feb",0.89655172413793105,0.93103448275862066,3.2873563218390802,0.75862068965517238,1.6681034482758621,72,0.97701149425287348,0.93678160919540232,0.82758620689655171,0.82758620689655171,511.0344827586207,0.13793103448275862,0.86206896551724133,155724.30333333334]
["mrt",0.967741935483871,0.83870967741935487,3.9623655913978495,0.61290322580645162,1.8723118279569892,62,1,0.93548387096774188,0.967741935483871,0.90322580645161288,516.77419354838707,3.2258064516129031E-2,0.967741935483871,163100.49942857143]
["apr",0.83333333333333337,0.9,3.5944444444444437,0.6333333333333333,1.7722222222222224,65.142857142857139,0.98888888888888893,0.97777777777777775,0.9,0.93333333333333335,550,6.6666666666666666E-2,0.93333333333333335,162427.08964285714]
["Grand Total",0.90082644628099173,0.90909090909090906,3.553719008264463,0.68595041322314054,1.7661845730027552,62.896551724137929,0.98622589531680438,0.93526170798898078,0.90909090909090906,0.88429752066115708,520.16528925619832,8.2644628099173556E-2,0.9173553719008265,651785.33929761883]

{"sheet":"WH_summary","index":9,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Data Ranges for the speedometers"]
[]
["On Time Dispatching",null,"Order Completeness"]
["Start",0,0]
["Red",{"$f":"Parameters!S36","v":70},{"$f":"Parameters!S42","v":70}]
["Yellow",{"$f":"Parameters!$R$36-Parameters!$S$36","v":10},{"$f":"Parameters!R42-Parameters!S42","v":10}]
["Green",{"$f":"Parameters!Q36-Parameters!R36","v":20},{"$f":"Parameters!Q42-Parameters!R42","v":20}]
["End",100,100]
["Current Value",{"$f":"B29*100","v":80.165289256198349},{"$f":"G29*100","v":78.512396694214885}]
["Pointer",1.5,1.5]
["End",{"$f":"200-(B9+B10)","v":118.33471074380165},119.98760330578511]
[]
[]
[]
["Data for the pie charts"]
["Dispatching Delay [hrs]"]
[4,{"$f":"COUNTIF(Data_WH_outb!$O$10:$O$131,\"=\"&A17)","v":17}]
[20,{"$f":"COUNTIF(Data_WH_outb!$O$10:$O$131,\"=\"&A18)","v":7}]
[]
[]
["Data for bar/line charts"]
[]
[]
["Row Labels","Average of On Time ","Average of Dispatching Delay","Average of Transferred orders with proper packing","Average of Picking accuracy","Average of Volume/Weight Accuracy","Average of WH transfer completeness"]
["Jan",0.83870967741935487,7.2,0.70967741935483875,0.967741935483871,0.80645161290322576,0.75806451612903225]
["Feb",0.7931034482758621,14.666666666666666,0.86206896551724133,0.96551724137931039,0.72413793103448276,0.7931034482758621]
["Apr",0.76666666666666672,4,0.8,0.96666666666666667,0.9,0.85]
["Mar",0.80645161290322576,12,0.74193548387096775,1,0.74193548387096775,0.74193548387096775]
["Grand Total",0.80165289256198347,9.3333333333333339,0.77685950413223137,0.97520661157024791,0.79338842975206614,0.78512396694214881]

{"sheet":"CC_summary","index":10,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Data Ranges for the speedometers"]
[]
["Clearing Customs On Time"]
["Start",0]
["Red",{"$f":"Parameters!S54","v":70}]
["Yellow",{"$f":"Parameters!R54-Parameters!S54","v":10}]
["Green",{"$f":"Parameters!Q54-Parameters!R54","v":20}]
["End",100]
["Current Value",{"$f":"E20*100","v":59.663865546218489}]
["Pointer",1.5]
["End",{"$f":"200-(B10+B11)","v":138.83613445378151}]
[]
[]
["Row Labels","a KPI","Average of CC Documentation Accuracy","a KPI","Average of Clearing Customs On Time  [1 = on time / 0 = delayed]","a KPI"]
["jan",431.0344827586207,0.89655172413793105,0.58620689655172409,0.58620689655172409,0.97916666666666685]
["feb",433.33333333333331,0.9,0.6,0.6,1.0798611111111109]
["mrt",435.48387096774195,0.83870967741935487,0.61290322580645162,0.61290322580645162,1.1458333333333333]
["apr",413.79310344827587,0.87931034482758619,0.58620689655172409,0.58620689655172409,1.239583333333333]
["Grand Total",428.57142857142856,0.87815126050420167,0.59663865546218486,0.59663865546218486,1.1111111111111114]
[]
[]
[]
["a KPI","Count"]
[0.5,15]
[1,62]
[1.5,11]
[2,17]
[2.5,9]

{"sheet":"Summary Tactical","index":11,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Data Ranges for the speedometers"]
[]
[null,"On Time","Shipment Completeness"]
["Start",0,0]
["Red",{"$f":"Parameters!S9","v":70},{"$f":"Parameters!S15-Parameters!T15","v":70}]
["Yellow",{"$f":"Parameters!R9-Parameters!S9","v":10},{"$f":"Parameters!R15-Parameters!S15","v":10}]
["Green",{"$f":"Parameters!Q9-Parameters!R9","v":20},{"$f":"Parameters!Q15-Parameters!R15","v":20}]
["End",100,100]
["Current Value",{"$f":"C29*100","v":56.862745098039191},{"$f":"D29*100","v":87.394957983193279}]
["Pointer",1.5,1.5]
["End",{"$f":"200-(B9+B10)","v":141.6372549019608},{"$f":"200-(C9+C10)","v":111.10504201680672}]
[]
[]
["Average Delay [days]","Count"]
[1,73]
[2,13]
[3,11]
[4,11]
[5,10]
[6,1]
[]
[]
[]
["Row Labels","Average of Shipment arriving to the correct location","a KPI","a KPI","a KPI","a KPI","a KPI","a KPI","Storage Cost","Transp. Cost","Clearing Customs Cost","a KPI","a KPI"]
["jan",0.90322580645161288,0.60215053763440851,0.88172043010752699,0.93279569892473124,0.907258064516129,1.5497311827956988,0.94982078853046603,2340,15600,15000,1062.5806451612902,178581.26725000003]
["feb",0.96551724137931039,0.57471264367816088,0.83908045977011492,0.9568965517241379,0.89798850574712652,1.610632183908046,0.9578544061302684,2223,14820,13000,1035.9655172413793,162406.54833333334]
["mrt",0.80645161290322576,0.5698924731182794,0.90322580645161288,0.93010752688172038,0.91666666666666674,1.502688172043011,0.95698924731182811,2403,16020,14000,1045.9032258064517,166817.45133333333]
["apr",0.8928571428571429,0.52380952380952384,0.86904761904761918,0.89880952380952384,0.8839285714285714,1.8586309523809523,0.96428571428571441,2331,15540,11000,1031.1071428571429,164522.25390476189]
["Grand Total",0.89075630252100846,0.56862745098039191,0.87394957983193278,0.92997198879551835,0.90196078431372573,1.6249999999999993,0.95704948646125065,9297,61980,53000,1044.3445378151262,672327.52082142816]

{"sheet":"Summary Strategic","index":12,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Data Ranges for the speedometers"]
[]
["On Time",null,"a KPI"]
["Start",0,0]
["Red",{"$f":"Parameters!S4","v":70},{"$f":"Parameters!S5","v":70}]
["Yellow",{"$f":"Parameters!R4-Parameters!S4","v":10},{"$f":"Parameters!R5-Parameters!S5","v":10}]
["Green",{"$f":"Parameters!Q4-Parameters!R4","v":20},{"$f":"Parameters!Q5-Parameters!R5","v":20}]
["End",100,100]
["Current Value",{"$f":"D20*100","v":35.294117647058826},{"$f":"E20*100","v":56.862745098039191}]
["Pointer",1.5,1.5]
["End",{"$f":"200-(B9+B10)","v":163.20588235294116},141.6372549019608]
[]
[]
[]
["Row Labels","Average of On Time Dispatching","Average of On Time Delivery","Average of On Time Clearing","a KPI","a KPI","*","*","Sum of Total Logistics Cost","Clearing Customs Cost","Transp. Cost","Storage Cost","*","*","*"]
["jan",0.77419354838709675,0.67741935483870963,0.35483870967741937,0.60215053763440851,0.907258064516129,0.93279569892473124,0.88172043010752699,32940,15000,15600,2340,0.967741935483871,0.989247311827957,0.89247311827956988]
["feb",0.68965517241379315,0.72413793103448276,0.31034482758620691,0.57471264367816088,0.89798850574712652,0.9568965517241379,0.83908045977011492,30043,13000,14820,2223,0.96551724137931039,1,0.90804597701149437]
["mrt",0.77419354838709675,0.61290322580645162,0.32258064516129031,0.5698924731182794,0.91666666666666674,0.93010752688172038,0.90322580645161288,32423,14000,16020,2403,1,0.97849462365591389,0.89247311827956988]
["apr",0.6428571428571429,0.5,0.42857142857142855,0.52380952380952384,0.8839285714285714,0.89880952380952384,0.86904761904761918,28871,11000,15540,2331,1,0.98809523809523814,0.90476190476190477]
["Grand Total",0.72268907563025209,0.63025210084033612,0.35294117647058826,0.56862745098039191,0.90196078431372573,0.92997198879551835,0.87394957983193278,124277,53000,61980,9297,0.98319327731092432,0.98879551820728306,0.89915966386554658]