{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Spreadsheet Info","Data Collection","Monthly Info","Booked Volume Accuracy","Booking Submission Delay","Carrier Booking Allocation","Cargo On-Time Delivery"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Spreadsheet Info","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,4,21,6],[7,0,8,1],[0,4,1,6],[0,0,2,0],[0,1,2,1],[3,3,4,3],[6,3,14,3]]}
["Year",2010,null,null,"Spreadsheet Data Location Section"]
[]
[null,null,null,null,"Data Type","Value","Description"]
[null,null,null,"\"Spreadsheet Info\"","\"Carrier List\" Column",1,"column number containing the carrier list in \"Basic Info\""]
[null,null,null,null,"\"Required Allocation\" Column",2,"column number containing the carrier allocation in \"Basic Info\""]
["Total Carrier Number",{"$f":"COUNTA(A11:A31)","v":3}]
[null,null,null,"\"Data Collection\"","First Row of Data Entry",3,"Row value containing the first set of data "]
["Carrier Information",null,null,null,"\"Carrier Name\" Column",2,"Column in data entries containing the name of the carrier involved"]
[null,null,null,null,"\"Actual Booked Volume\" Column",5,"Column containing forecast volume information per PO"]
["Carrier List","MQC",null,null,"\"Booking Submission Date\" Column",6,"Column containing booking submission date per PO"]
["MAEU",5000,null,null,"\"Actual Shipped Volume\" Column",7,"Column containing booked volume data per PO"]
["APL",3000,null,null,"\"ETD\" Column",4,"Column containing the estimated time of departure per vessel"]
["CSC",2000,null,null,"\"LSD\" Column",8,"Column containing the lastest ship date per PO"]
[null,null,null,null,"\"Booking Delay\" Column",9,"Column containing whether booking form was submitted late per PO"]
[null,null,null,null,"\"Cargo Delay\" Column",10,"Column containing whether cargo was shipped late"]
[]
[]
[]
[]
[]
[null,null,null,null,"Note: The data inputs is solely for demonstration purposes"]

{"sheet":"Data Collection","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,1,0,3],[0,6,0,7]]}
["Purchase Order","Vessel Information",null,null,"Booking Information",null,"Delivery Information",null,"Booking Delay","Cargo Delayed"]
["PO Number","Carrier Name","Vessel Voyage","ETD","Actual Booked Volume","Booking Submission Date","Actual Shipped Volume ","LSD"]
[null,"MAEU",null,{"$f":"DATE(2010,1,7)","v":"2010-01-07"},300,{"$f":"DATE(2010,1,5)","v":"2010-01-05"},300,{"$f":"F3+7","v":"2010-01-12"},{"$f":"IF(OR(F3=\"\",D3=\"\"),\"\",IF(F3-D3+7<=0,\"NO\",\"YES\"))","v":"YES"},{"$f":"IF(OR(D3=\"\",H3=\"\"),\"\",IF(D3<=H3,\"NO\",\"YES\"))","v":"NO"}]
[null,"APL",null,"2010-01-18",100,"2010-01-03",100,"2010-01-14","NO","YES"]
[null,"MAEU",null,"2010-01-18",400,{"$f":"DATE(2010,1,20)","v":"2010-01-20"},400,{"$f":"F5+7","v":"2010-01-27"},"YES","NO"]
[null,"APL",null,null,200,"2010-02-11",100,"2010-02-18","",""]
[null,"MAEU",null,null,200,{"$f":"DATE(2010,2,20)","v":"2010-02-20"},200,"2010-02-27","",""]
[null,"APL",null,null,100,{"$f":"DATE(2010,3,10)","v":"2010-03-10"},100,"2010-03-17","",""]
[null,"APL",null,null,500,{"$f":"DATE(2010,4,18)","v":"2010-04-18"},500,"2010-04-25","",""]
[null,"APL",null,null,600,{"$f":"DATE(2010,5,30)","v":"2010-05-30"},600,"2010-06-06","",""]
[null,"MAEU",null,null,800,{"$f":"DATE(2010,6,20)","v":"2010-06-20"},800,"2010-06-27",""]
[null,"APL",null,null,700,{"$f":"DATE(2010,7,10)","v":"2010-07-10"},700,"2010-07-17",""]
[null,"MAEU",null,null,900,{"$f":"DATE(2010,7,10)","v":"2010-07-10"},900,"2010-07-17",""]
[null,"APL",null,null,900,{"$f":"DATE(2010,7,10)","v":"2010-07-10"},900,"2010-07-17",""]
[null,"MAEU",null,null,500,{"$f":"DATE(2010,7,10)","v":"2010-07-10"},500,"2010-07-17",""]
[null,"MAEU",null,null,350,{"$f":"DATE(2010,7,12)-7","v":"2010-07-05"},350,"2010-07-12",""]
[null,"APL",null,null,200,{"$f":"DATE(2010,7,21)","v":"2010-07-21"},200,"2010-07-28",""]
[null,"MAEU",null,null,700,{"$f":"DATE(2010,7,18)","v":"2010-07-18"},700,"2010-07-25",""]
[null,"MAEU",null,null,560,{"$f":"DATE(2010,7,17)","v":"2010-07-17"},560,"2010-07-24",""]
[null,"APL",null,null,230,{"$f":"DATE(2010,7,8)","v":"2010-07-08"},230,"2010-07-15",""]
[null,"APL",null,null,120,{"$f":"DATE(2010,7,11)","v":"2010-07-11"},120,"2010-07-18",""]
[null,"APL",null,null,50,{"$f":"DATE(2010,8,2)","v":"2010-08-02"},50,"2010-08-09",""]
[null,"MAEU",null,null,100,"2010-08-05",100,"2010-08-12",""]
[null,null,null,null,null,"2010-08-07",null,"2010-08-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,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]

{"sheet":"Monthly Info","index":2,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,6],[15,0,15,6],[30,0,30,6],[46,0,46,6]]}
["Total Booked"]
["Month",{"$f":"IF('Spreadsheet Info'!A11=\"\",\"\",'Spreadsheet Info'!A11)","v":"MAEU"},{"$f":"IF('Spreadsheet Info'!A12=\"\",\"\",'Spreadsheet Info'!A12)","v":"APL"},{"$f":"IF('Spreadsheet Info'!A13=\"\",\"\",'Spreadsheet Info'!A13)","v":"CSC"},{"$f":"IF('Spreadsheet Info'!A14=\"\",\"\",'Spreadsheet Info'!A14)","v":""},{"$f":"IF('Spreadsheet Info'!A15=\"\",\"\",'Spreadsheet Info'!A15)","v":""},{"$f":"IF('Spreadsheet Info'!A16=\"\",\"\",'Spreadsheet Info'!A16)","v":""}]
["January",700,100,0]
["February",200,800,0]
["March",0,100,0]
["April",0,500,0]
["May",0,600,0]
["June",800,0,0]
["July",3010,2150,0]
["August",100,50,0]
["September",0,0,0]
["October",0,0,0]
["November",0,0,0]
["December",0,0,0]
[]
["Total Shipped"]
["Month",{"$f":"B2","v":"MAEU"},{"$f":"C2","v":"APL"},"CSC","","",""]
["January",700,100,0]
["February",200,800,0]
["March",0,100,0]
["April",0,500,0]
["May",0,600,0]
["June",800,0,0]
["July",3010,2150,0]
["August",100,50,0]
["September",0,0,0]
["October",0,0,0]
["November",0,0,0]
["December",0,0,0]
[]
["Total Bookings Delayed"]
["Monthly for All Carriers","Delayed #","Total #"]
["January",2,3]
["February",0,2]
["March",0,1]
["April",0,1]
["May",0,1]
["June",0,1]
["July",0,10]
["August",0,3]
["September",0,0]
["October",0,0]
["November",0,0]
["December",0,0]
[]
[]
["Total Cargo Delivery Delays"]
["Monthly for All Carriers","Delayed #","Total #"]
["January",1,3]
["February",0,2]
["March",0,1]
["April",0,1]
["May",0,1]
["June",0,1]
["July",0,10]
["August",0,3]
["September",0,0]
["October",0,0]
["November",0,0]
["December",0,0]

{"sheet":"Booked Volume Accuracy","index":3,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,1,29,1],[16,1,17,1],[16,2,16,5],[0,1,1,5]]}
[null,"Booked Volume V.S. Shipped Volume"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year","Monthly Data"]
[null,null,"Monthly Data","Booked Volume","Shipped Volume","KPI (%)"]
[null,2010,"January",{"$f":"SUM('Monthly Info'!B3:M3)","v":800},{"$f":"SUM('Monthly Info'!B18:M18)","v":800},{"$f":"IF(E19=0, \"N/A\",1-((D19-E19)/D19))","v":1}]
[null,null,"February",{"$f":"SUM('Monthly Info'!B4:M4)","v":1000},{"$f":"SUM('Monthly Info'!B19:M19)","v":1000},{"$f":"IF(E20=0, \"N/A\",1-((D20-E20)/D20))","v":1}]
[null,null,"March",{"$f":"SUM('Monthly Info'!B5:M5)","v":100},{"$f":"SUM('Monthly Info'!B20:M20)","v":100},1]
[null,null,"April",{"$f":"SUM('Monthly Info'!B6:M6)","v":500},{"$f":"SUM('Monthly Info'!B21:M21)","v":500},1]
[null,null,"May",{"$f":"SUM('Monthly Info'!B7:M7)","v":600},{"$f":"SUM('Monthly Info'!B22:M22)","v":600},1]
[null,null,"June",{"$f":"SUM('Monthly Info'!B8:M8)","v":800},{"$f":"SUM('Monthly Info'!B23:M23)","v":800},1]
[null,null,"July",{"$f":"SUM('Monthly Info'!B9:M9)","v":5160},{"$f":"SUM('Monthly Info'!B24:M24)","v":5160},1]
[null,null,"August",{"$f":"SUM('Monthly Info'!B10:M10)","v":150},{"$f":"SUM('Monthly Info'!B25:M25)","v":150},1]
[null,null,"September",{"$f":"SUM('Monthly Info'!B11:M11)","v":0},{"$f":"SUM('Monthly Info'!B26:M26)","v":0},"N/A"]
[null,null,"October",{"$f":"SUM('Monthly Info'!B12:M12)","v":0},{"$f":"SUM('Monthly Info'!B27:M27)","v":0},"N/A"]
[null,null,"November",{"$f":"SUM('Monthly Info'!B13:M13)","v":0},{"$f":"SUM('Monthly Info'!B28:M28)","v":0},"N/A"]
[null,null,"December",{"$f":"SUM('Monthly Info'!B14:M14)","v":0},{"$f":"SUM('Monthly Info'!B29:M29)","v":0},"N/A",null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Booking Submission Delay","index":4,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[19,1,20,1],[19,2,19,5],[0,1,1,5],[21,1,32,1]]}
[null,"Monthly Booking Delay Ratio"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Year","Monthly Data"]
[null,null,null,"Delayed Times","Total Times","KPI"]
[null,2010,"January",{"$f":"'Monthly Info'!B33","v":2},{"$f":"'Monthly Info'!C33","v":3},{"$f":"IF(E22=0, \"N/A\",1-(D22/E22))","v":0.33333333333333337}]
[null,null,"February",{"$f":"'Monthly Info'!B34","v":0},{"$f":"'Monthly Info'!C34","v":2},{"$f":"IF(E23=0, \"N/A\",1-(D23/E23))","v":1}]
[null,null,"March",{"$f":"'Monthly Info'!B35","v":0},{"$f":"'Monthly Info'!C35","v":1},1]
[null,null,"April",{"$f":"'Monthly Info'!B36","v":0},{"$f":"'Monthly Info'!C36","v":1},1]
[null,null,"May",{"$f":"'Monthly Info'!B37","v":0},{"$f":"'Monthly Info'!C37","v":1},1]
[null,null,"June",{"$f":"'Monthly Info'!B38","v":0},{"$f":"'Monthly Info'!C38","v":1},1]
[null,null,"July",{"$f":"'Monthly Info'!B39","v":0},{"$f":"'Monthly Info'!C39","v":10},1]
[null,null,"August",{"$f":"'Monthly Info'!B40","v":0},{"$f":"'Monthly Info'!C40","v":3},1]
[null,null,"September",{"$f":"'Monthly Info'!B41","v":0},{"$f":"'Monthly Info'!C41","v":0},"N/A"]
[null,null,"October",{"$f":"'Monthly Info'!B42","v":0},{"$f":"'Monthly Info'!C42","v":0},"N/A"]
[null,null,"November",{"$f":"'Monthly Info'!B43","v":0},{"$f":"'Monthly Info'!C43","v":0},"N/A"]
[null,null,"December",{"$f":"'Monthly Info'!B44","v":0},{"$f":"'Monthly Info'!C44","v":0},"N/A"]

{"sheet":"Carrier Booking Allocation","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[0,0,0,3],[7,0,8,1],[7,2,8,3],[9,0,10,1],[9,2,10,3]]}
["Volume Allocation"]
["Year",{"$f":"'Spreadsheet Info'!B1","v":2010}]
[null,{"$f":"'Monthly Info'!B2","v":"MAEU"},{"$f":"'Monthly Info'!C2","v":"APL"},{"$f":"'Monthly Info'!D2","v":"CSC"},{"$f":"'Monthly Info'!E2","v":""},{"$f":"'Monthly Info'!F2","v":""},{"$f":"'Monthly Info'!G2","v":""}]
["Actual Allocation",{"$f":"IF(B3=\"\",\"\",SUM('Monthly Info'!B18:B29))","v":4810},{"$f":"IF(C3=\"\",\"\",SUM('Monthly Info'!C18:C29))","v":4300},{"$f":"IF(D3=\"\",\"\",SUM('Monthly Info'!D18:D29))","v":0},{"$f":"IF(E3=\"\",\"\",SUM('Monthly Info'!E18:E29))","v":""},{"$f":"IF(F3=\"\",\"\",SUM('Monthly Info'!F18:F29))","v":""},{"$f":"IF(G3=\"\",\"\",SUM('Monthly Info'!G18:G29))","v":""}]
["MQC",{"$f":"IF('Spreadsheet Info'!B11=\"\",\"\",'Spreadsheet Info'!B11)","v":5000},{"$f":"IF('Spreadsheet Info'!B12=\"\",\"\",'Spreadsheet Info'!B12)","v":3000},{"$f":"IF('Spreadsheet Info'!B13=\"\",\"\",'Spreadsheet Info'!B13)","v":2000},{"$f":"IF('Spreadsheet Info'!B14=\"\",\"\",'Spreadsheet Info'!B14)","v":""},{"$f":"IF('Spreadsheet Info'!B15=\"\",\"\",'Spreadsheet Info'!B15)","v":""},{"$f":"IF('Spreadsheet Info'!B16=\"\",\"\",'Spreadsheet Info'!B16)","v":""}]
["KPI",{"$f":"IF(OR(B4=\"\",B5=\"\"), \"\",B4-B5)","v":-190},{"$f":"IF(OR(C4=\"\",C5=\"\"), \"\",C4-C5)","v":1300},-2000,"","",""]
[]
["Yearly KPI",null,{"$f":"SUM(B6:G6)","v":-890}]
[]
["Deviation from MQC",null,{"$f":"(SUM(B4:G4)-SUM(B5:G5))/SUM(B5:G5)","v":-8.8999999999999996E-2}]

{"sheet":"Cargo On-Time Delivery","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,3,5],[3,1,4,1],[5,1,16,1],[0,1,1,15]]}
[null,"Monthly Cargo Delivery Delay Ratio"]
[]
[]
[null,"Year","Monthly Data"]
[null,null,null,"Total delayed #","Total PO #","KPI"]
[null,2010,"January",{"$f":"'Monthly Info'!B49","v":1},{"$f":"'Monthly Info'!C49","v":3},{"$f":"IF(E6=0,\"N/A\",(1-D6/E6))","v":0.66666666666666674}]
[null,null,"February",{"$f":"'Monthly Info'!B50","v":0},{"$f":"'Monthly Info'!C50","v":2},{"$f":"IF(E7=0,\"N/A\",(1-D7/E7))","v":1}]
[null,null,"March",{"$f":"'Monthly Info'!B51","v":0},{"$f":"'Monthly Info'!C51","v":1},1]
[null,null,"April",{"$f":"'Monthly Info'!B52","v":0},{"$f":"'Monthly Info'!C52","v":1},1]
[null,null,"May",{"$f":"'Monthly Info'!B53","v":0},{"$f":"'Monthly Info'!C53","v":1},1]
[null,null,"June",{"$f":"'Monthly Info'!B54","v":0},{"$f":"'Monthly Info'!C54","v":1},1]
[null,null,"July",{"$f":"'Monthly Info'!B55","v":0},{"$f":"'Monthly Info'!C55","v":10},1]
[null,null,"August",{"$f":"'Monthly Info'!B56","v":0},{"$f":"'Monthly Info'!C56","v":3},1]
[null,null,"September",{"$f":"'Monthly Info'!B57","v":0},{"$f":"'Monthly Info'!C57","v":0},"N/A"]
[null,null,"October",{"$f":"'Monthly Info'!B58","v":0},{"$f":"'Monthly Info'!C58","v":0},"N/A"]
[null,null,"November",{"$f":"'Monthly Info'!B59","v":0},{"$f":"'Monthly Info'!C59","v":0},"N/A"]
[null,null,"December",{"$f":"'Monthly Info'!B60","v":0},{"$f":"'Monthly Info'!C60","v":0},"N/A"]