{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Introduction","Check applicability","Calculation","Start_Page","Input_FleetSize","FleetSizeOptimization","Output_FleetSize","OrderScenario_PortStayTime","Input_PortStayTime","Output_Routing_PortStayTime","Output_Scheduling_PortStayTime","Order_WeeklyRoutingScheduling","Input_WeeklyRoutingScheduling","Output_WeeklyRoutingScheduling"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":1,"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":"Introduction","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vessel Planning Tool"]

{"sheet":"Check applicability","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Port type","Ports","Abbr.",null,"Origin","Destination","Sailing Time (h)","Average port stay (h)","Sailing + port stay (h)"]
[null,"Home port","Rotterdam","A",null,{"$f":"Table8[[#This Row],[Ports]]","v":"Rotterdam"},{"$f":"C4","v":"Hamburg"},18,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":26}]
[null,"Port T","Hamburg","T",null,{"$f":"C3","v":"Rotterdam"},{"$f":"C5","v":"Immingham"},15,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":23}]
[null,"Port Z","Immingham","Z",null,{"$f":"C4","v":"Hamburg"},{"$f":"C3","v":"Rotterdam"},18,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":26}]
[null,null,null,null,null,{"$f":"C4","v":"Hamburg"},{"$f":"C5","v":"Immingham"},26,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":34}]
[null,null,null,null,null,{"$f":"C5","v":"Immingham"},{"$f":"C3","v":"Rotterdam"},15,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":23}]
[null,null,null,null,null,{"$f":"C5","v":"Immingham"},{"$f":"C4","v":"Hamburg"},26,8,{"$f":"Table310[[#This Row],[Sailing Time (h)]]+Table310[[#This Row],[Average port stay (h)]]","v":34}]
[]
[]
[]
[null,null,null,null,null,"The tool is ",{"$f":"IF(Calculation!B21=0,\"not applicable for these 3 ports since the sailing time exceeds 168 hours\",IF(Calculation!A21=1,\"applicable for these 3 ports and pre-defined building block set covers all the possibilities of vessel routing\",\"applicable for these 3 ports but pre-defined building block set does not cover all the possibilities of vessel routing\"))","v":"applicable for these 3 ports and pre-defined building block set covers all the possibilities of vessel routing"}]

{"sheet":"Calculation","index":2,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Abbreviation","Port",null,"Origin","Destination","Sailing Time (h)","Average port stay (h)","Sailing + port stay (h)"]
["A",{"$f":"'Check applicability'!C3","v":"Rotterdam"},null,{"$f":"'[1]Check applicability'!E3","v":"Rotterdam"},{"$f":"'[1]Check applicability'!F3","v":"Hamburg"},{"$f":"'Check applicability'!H3","v":18},{"$f":"'Check applicability'!I3","v":8},{"$f":"'[1]Check applicability'!I3","v":26}]
["T",{"$f":"'Check applicability'!C4","v":"Hamburg"},null,{"$f":"'[1]Check applicability'!E4","v":"Rotterdam"},{"$f":"'[1]Check applicability'!F4","v":"immingham"},{"$f":"'Check applicability'!H4","v":15},{"$f":"'Check applicability'!I4","v":8},{"$f":"'[1]Check applicability'!I4","v":23}]
["Z",{"$f":"'Check applicability'!C5","v":"Immingham"},null,{"$f":"'[1]Check applicability'!E5","v":"Hamburg"},{"$f":"'[1]Check applicability'!F5","v":"Rotterdam"},{"$f":"'Check applicability'!H5","v":18},{"$f":"'Check applicability'!I5","v":8},{"$f":"'[1]Check applicability'!I5","v":26}]
[null,null,null,{"$f":"'[1]Check applicability'!E6","v":"Hamburg"},{"$f":"'[1]Check applicability'!F6","v":"immingham"},{"$f":"'Check applicability'!H6","v":26},{"$f":"'Check applicability'!I6","v":8},{"$f":"'[1]Check applicability'!I6","v":34}]
["Abbreviation","Home terminal",null,{"$f":"'[1]Check applicability'!E7","v":"immingham"},{"$f":"'[1]Check applicability'!F7","v":"Rotterdam"},{"$f":"'Check applicability'!H7","v":15},{"$f":"'Check applicability'!I7","v":8},{"$f":"'[1]Check applicability'!I7","v":23}]
["A",{"$f":"B2","v":"Rotterdam"},null,{"$f":"'[1]Check applicability'!E8","v":"immingham"},{"$f":"'[1]Check applicability'!F8","v":"Hamburg"},{"$f":"'Check applicability'!H8","v":26},{"$f":"'Check applicability'!I8","v":8},{"$f":"'[1]Check applicability'!I8","v":34}]
[]
[]
["Check tool applicability"]
["Start terminal (home)","1ST Visit","2ND Visit","3RD Visit","4TH Visit","Total time (Sailing + port stay) (h)","Max nr. of repeatation","Max nr of repeation for non-home terminal legs","Check whether applicable","Check whether sailing + port stay too large",null,"Base repeatation nr. in current building block set","Base repeatation nr. of non-home terminal legs in current building block set"]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B3","v":"Hamburg"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},null,null,{"$f":"F2+G2+F4+G4","v":52},{"$f":"ROUNDDOWN(168/F12,0)","v":3},0,{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L12,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M12,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,4,0]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B4","v":"Immingham"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},null,null,{"$f":"F3+G3+F6+G6","v":46},{"$f":"ROUNDDOWN(168/F13,0)","v":3},0,{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L13,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M13,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,4,0]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B3","v":"Hamburg"},{"$f":"B4","v":"Immingham"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},null,{"$f":"F2+G2+F6+G6+F5+G5","v":83},2,{"$f":"ROUNDDOWN((168-F14)/($H$5),0)","v":2},{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L14,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M14,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,3,6]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B4","v":"Immingham"},{"$f":"B3","v":"Hamburg"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},null,{"$f":"F3+G3+F7+G7+F4+G4","v":83},{"$f":"ROUNDDOWN(168/F15,0)","v":2},{"$f":"ROUNDDOWN((168-F15)/($H$5),0)","v":2},{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L15,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M15,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,3,6]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B3","v":"Hamburg"},{"$f":"B4","v":"Immingham"},{"$f":"B3","v":"Hamburg"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"F2+G2+F5+G5+F7+G7+F4+G4","v":120},1,{"$f":"ROUNDDOWN((168-F16)/($H$5),0)","v":1},{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L16,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M16,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,2,5]
[{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"B4","v":"Immingham"},{"$f":"B3","v":"Hamburg"},{"$f":"B4","v":"Immingham"},{"$f":"Table4[Home terminal]","v":"Rotterdam"},{"$f":"F3+G3+F7+G7+F5+G5+F6+G6","v":114},1,{"$f":"ROUNDDOWN((168-F17)/($H$5),0)","v":1},{"$f":"IF(Table5[[#This Row],[Max nr. of repeatation]]>L17,0,IF(Table5[[#This Row],[Max nr of repeation for non-home terminal legs]]>M17,0,1))","v":1},{"$f":"IF(Table5[[#This Row],[Total time (Sailing + port stay) (h)]]>=168,0,1)","v":1},null,2,5]
[]
[]
["Applicable if equals to 1","Not usable","Column1"]
[{"$f":"IF(SUM(Table5[Check whether applicable])=6,1,0)","v":1},{"$f":"IF(SUM(Table5[Check whether sailing + port stay too large])=6,1,0)","v":1}]
["Note: If it is 0, it means the vessel routes created by the tool do not include all the possibility"]
[1,1,"The tool is applicable and pre-defined building block set is suitable"]
[0,1,"The tool is applicable but pre-defined building block set does not include all the possibility of vessel routing"]
[1,0,"The tool is not applicable since sailing time exceeds 168 hours"]
[0,0,"The tool is not applicable since sailing time exceeds 168 hours"]

{"sheet":"Start_Page","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Vessel Planning Tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Input_FleetSize","index":4,"n_rows":109,"n_cols":29,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total vessel operation time (h/week)",160,null,null,null,null,null,null,null,null,null,null,null,"Building blocks for routing","Cost (fuel cost + port fee) (€)","Sailing time (h)",null," #","Customers","Origin","Destination","Weekly demand volume (containers)","TEU factors (/container)","Average weight (ton/container)","Unit outsourcing cost (€/container)","Unit handling cost (€/container)","Unit price of own sailing (€/container)","Unit price of outsourcing (€/container)"]
[null,"Average terminal handling speed (container/h)",16,null,null,null,null,null,null,null,null,null,null,null,"1_A1->T1->A2",10000,36,null,1,"Full customer 1","T","A",510,2,35,300,50,300,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2_A1->T1->A2",10000,36,null,2,"Full customer 2","A","T",85,1,30,150,60,150,150]
[null,"Vessel Rent (€/week/vessel)",40000,null,null,null,null,null,null,null,null,null,null,null,"3_A1->T1->A2",10000,36,null,3,"Full customer 3","A","T",4,2,30,150,60,150,150]
[null,"Discount rate on vessel rent from 2nd vessel",0.05,null,null,null,null,null,null,null,null,null,null,null,"4_A1->T1->A2",10000,36,null,4,"Full customer 4","Z","T",100,1,30,150,60,150,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_A1->Z1->A2",9000,30,null,5,"Full customer 5","A","T",30,2,30,150,60,150,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6_A1->Z1->A2",9000,30,null,6,"Full customer 6","A","Z",24,1,35,150,60,150,150]
[null,"Vessel volume capacity (TEU)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"7_A1->Z1->A2",9000,30,null,7,"Full customer 7","A","T",2,2,30,150,60,150,150]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400,null,"8_A1->Z1->A2",9000,30,null,8,"Full customer 8","A","T",14,1,30,150,60,150,150]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400,null,"9_A1->T1->Z1->A2",11000,59,null,9,"Full customer 9","A","T",39,2,28,150,60,150,150]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400,null,"10_A1->T1->Z1->A2",11000,59,null,10,"Full customer 10","A","T",15,1,30,150,60,150,150]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400,null,"11_A1->T1->Z1->A2",11000,59,null,11,"Full customer 11","A","T",30,2,30,150,60,150,150]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400,null,"12_A1->T1->Z1->T2->Z2->A2",16000,111,null,12,"Full customer 12","Z","T",2,1,20,150,60,150,150]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400,null,"13_A1->T1->Z1->T2->Z2->A2",16000,111,null,13,"Full customer 13","A","T",1,2,30,150,60,150,150]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0,null,"14_A1->T1->Z1->T2->Z2->T3->Z3->A2",23000,163,null,14,"Full customer 14","A","T",1,1,30,150,60,150,150]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0,null,"15_A1->T1->Z1->T2->Z2->T3->Z3->T4->Z4->A2",28000,215,null,15,"Full customer 15","A","Z",27,2,30,150,60,150,150]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0,null,"16_A1->Z1->T1->A2",11000,59,null,16,"Full customer 16","A","T",5,1,25,150,60,150,150]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0,null,"17_A1->Z1->T1->A2",11000,59,null,17,"Full customer 17","A","Z",7,2,30,150,60,150,150]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0,null,"18_A1->Z1->T1->A2",11000,59,null,18,"Full customer 18","Z","T",14,1,30,180,80,180,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19_A1->Z1->T1->Z2->T2->A2",16000,111,null,19,"Full customer 19","Z","T",30,2,30,180,80,180,180]
[null,"Vessel weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"20_A1->Z1->T1->Z2->T2->A2",16000,111,null,20,"Full customer 20","Z","T",4,1,30,180,80,180,180]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"21_A1->Z1->T1->Z2->T2->Z3->T3->A2",24000,163,null,21,"Full customer 21","Z","T",1,2,30,180,80,180,180]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"22_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->A2",28000,215,null,22,"Full customer 22","Z","T",3,1,30,180,80,180,180]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"23_A1->T1->Z1->T2->A2",15000,88,null,23,"Full customer 23","Z","T",5,2,30,180,80,180,180]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"24_A1->T1->Z1->T2->A2",15000,88,null,24,"Full customer 24","A","T",4,2.25,30,300,60,300,300]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"25_A1->T1->Z1->T2->Z2->T3->A2",21000,140,null,25,"Full customer 25","A","T",5,2.25,30,300,60,300,300]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"26_A1->T1->Z1->T2->Z2->T3->Z3->T4->A2",28000,192,null,26,"Full customer 26","Z","T",11,2.25,30,300,80,300,300]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"27_A1->Z1->T1->Z2->A2",13000,82,null,27,"Full customer 27","Z","T",14,2,30,160,35,160,160]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"28_A1->Z1->T1->Z2->A2",13000,82,null,28,"Full customer 28","Z","A",20,1,30,120,51,120,120]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"29_A1->Z1->T1->Z2->A2",13000,82,null,29,"Empty customer 1","A","T",147,2,6,300,50,300,300]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"30_A1->Z1->T1->Z2->T2->Z3->A2",18000,134,null,30,"Empty customer 2","T","A",4,1,4,150,60,150,150]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"31_A1->Z1->T1->Z2->T2->Z3->A2",18000,134,null,31,"Empty customer 3","T","A",38,2,3,150,60,150,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32_A1->Z1->T1->Z2->T2->Z3->T3->Z4->A2",25000,186,null,32,"Empty customer 4","T","Z",40,1,4,150,80,150,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->Z5->A2",32000,238,null,33,"Empty customer 5","T","Z",23,2,4,150,80,150,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Empty customer 6","T","A",13,2.25,2,300,60,300,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Empty customer 7","T","A",5,2.25,4,300,60,300,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"Empty customer 8","T","Z",4,2.25,4.5,280,80,280,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"Empty customer 9","T","Z",6,2,4,160,35,160,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Empty customer 10","A","Z",2,1,4,120,51,120,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]

{"sheet":"FleetSizeOptimization","index":5,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Revenue of own sailing",249720,"€"]
[null,null,null,null,null,null,null,"Revenue of outsourcing",49650,"€"]
[null,null,null,null,null,null,null,"Vessel rent cost",-78000,"€"]
[null,null,null,null,null,null,null,"Route cost",-41000,"€"]
[null,null,null,null,null,null,null,"Outsourcing cost",-49650,"€"]
[null,null,null,null,null,null,null,"Handling Cost",-72772,"€"]
[null,null,null,null,null,null,null,"Total profit",57948,"€"]

{"sheet":"Output_FleetSize","index":6,"n_rows":43,"n_cols":42,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,40,2,41],[2,15,2,16],[2,18,2,20],[2,22,2,25],[2,27,2,32],[2,34,2,38]]}
[]
[null,null,null,null,null,null,"Profit per customer",null,null,null,null,null,null,null,null,"Vessel Route Container combination"]
[null,null,null,null,null,null,"Customers","Revenue of own sailing (€)","Revenue of outsourcing (€)","Share of vessel rent (€)","Share of sailing cost (€)","Outsoucing cost (€)","Handling cost (€)","Profit (€)",null,"Vessel selection",null,null,"Routes of each vessel",null,null,null,"Vessel operation time",null,null,null,null,"Volume of own sailing within a building block",null,null,null,null,null,null,"Volume of own sailing between successive building blocks",null,null,null,null,null,"Volume of outsourcing"]
[null,null,null,null,null,null,"Full customer 1",115800,37200,-27929.499072356215,-15609.821352463408,-37200,-25500,46760.679575180387,null,"Vessel 1",1,null,"Vessel #","Buidling blocks","Whether selected",null,"Vessel #","Total operation time","Total sailing time","Total handling time",null,"Customer","Vessel #","Building blocks","O","D","Container volume",null,"Customer","Vessel #","Building blocks","Successive building block","Container volume",null,"Customer","Container volume"]
[null,null,null,null,null,null,"Full customer 2",12750,null,-6150.2782931354359,-2534.8984771573605,null,-5100,-1035.1767702927964,null,"Vessel 2",null,null,"Vessel_1","2_A1->T1->A2",1,null,"Vessel_1",147.5,72,75.5,null,"Full customer 1","Vessel_1","2_A1->T1->A2","T1","A2",100,null,"Empty customer 4","Vessel_3","4_A1->T1->A2","16_A1->Z1->T1->A2",40,null,"Full customer 1",124]
[null,null,null,null,null,null,"Full customer 3",600,null,-289.42486085343228,-104.16666666666667,null,-240,-33.591527520098964,null,"Vessel 3",1,null,"Vessel_1","4_A1->T1->A2",1,null,"Vessel_3",154.25,95,59.25,null,"Full customer 1","Vessel_1","4_A1->T1->A2","T1","A2",95,null,"Empty customer 5","Vessel_3","4_A1->T1->A2","16_A1->Z1->T1->A2",23,null,"Full customer 4",67]
[null,null,null,null,null,null,"Full customer 4",4950,10050,-2387.7551020408164,-1310.4693140794225,-10050,-6000,-4748.2244161202398,null,null,null,null,"Vessel_3","4_A1->T1->A2",1,null,null,null,null,null,null,"Full customer 1","Vessel_3","4_A1->T1->A2","T1","A2",91,null,"Empty customer 8","Vessel_3","4_A1->T1->A2","16_A1->Z1->T1->A2",4,null,"Full customer 28",20]
[null,null,null,null,null,null,"Full customer 5",4500,null,-2170.6864564007419,-1363.6363636363635,null,-1800,-834.32282003710543,null,null,null,null,"Vessel_3","16_A1->Z1->T1->A2",1,null,null,null,null,null,null,"Full customer 1","Vessel_3","16_A1->Z1->T1->A2","T1","A2",100,null,"Empty customer 9","Vessel_3","4_A1->T1->A2","16_A1->Z1->T1->A2",6]
[null,null,null,null,null,null,"Full customer 6",3600,null,-1736.5491651205937,-953.06859205776186,null,-1440,-529.61775717835553,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 2","Vessel_1","4_A1->T1->A2","A1","T1",72]
[null,null,null,null,null,null,"Full customer 7",300,null,-144.71243042671614,-71.496212121212125,null,-120,-36.208642547928264,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 2","Vessel_3","4_A1->T1->A2","A1","T1",13]
[null,null,null,null,null,null,"Full customer 8",2100,null,-1012.987012987013,-636.36363636363637,null,-840,-389.35064935064941,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 3","Vessel_1","4_A1->T1->A2","A1","T1",4]
[null,null,null,null,null,null,"Full customer 9",5850,null,-2821.8923933209649,-1772.7272727272727,null,-2340,-1084.6196660482376,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 4","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",33]
[null,null,null,null,null,null,"Full customer 10",2250,null,-1085.343228200371,-761.42131979695432,null,-900,-496.76454799732528,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 5","Vessel_1","2_A1->T1->A2","A1","T1",30]
[null,null,null,null,null,null,"Full customer 11",4500,null,-2170.6864564007419,-1363.6363636363635,null,-1800,-834.32282003710543,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 6","Vessel_3","16_A1->Z1->T1->A2","A1","Z1",24]
[null,null,null,null,null,null,"Full customer 12",300,null,-144.71243042671614,-79.42238267148015,null,-120,-44.13481309819629,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 7","Vessel_1","2_A1->T1->A2","A1","T1",1]
[null,null,null,null,null,null,"Full customer 13",150,null,-72.35621521335807,-26.041666666666668,null,-60,-8.397881880024741,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 7","Vessel_1","4_A1->T1->A2","A1","T1",1]
[null,null,null,null,null,null,"Full customer 14",150,null,-72.35621521335807,-45.454545454545453,null,-60,-27.810760667903523,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 8","Vessel_1","2_A1->T1->A2","A1","T1",14]
[null,null,null,null,null,null,"Full customer 15",4050,null,-1953.6178107606679,-1072.2021660649821,null,-1620,-595.81997682564997,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 9","Vessel_1","2_A1->T1->A2","A1","T1",39]
[null,null,null,null,null,null,"Full customer 16",750,null,-361.78107606679032,-227.27272727272725,null,-300,-139.05380333951757,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 10","Vessel_3","4_A1->T1->A2","A1","T1",15]
[null,null,null,null,null,null,"Full customer 17",1050,null,-506.49350649350652,-277.97833935018053,null,-420,-154.47184584368705,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 11","Vessel_1","2_A1->T1->A2","A1","T1",30]
[null,null,null,null,null,null,"Full customer 18",2520,null,-1012.987012987013,-555.95667870036107,null,-1120,-168.9436916873741,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 12","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",2]
[null,null,null,null,null,null,"Full customer 19",5400,null,-2170.6864564007419,-1191.3357400722023,null,-2400,-362.02219647294419,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 13","Vessel_1","4_A1->T1->A2","A1","T1",1]
[null,null,null,null,null,null,"Full customer 20",720,null,-289.42486085343228,-158.8447653429603,null,-320,-48.269626196392551,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 14","Vessel_1","2_A1->T1->A2","A1","T1",1]
[null,null,null,null,null,null,"Full customer 21",180,null,-72.35621521335807,-39.711191335740075,null,-80,-12.067406549098138,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 15","Vessel_3","16_A1->Z1->T1->A2","A1","Z1",27]
[null,null,null,null,null,null,"Full customer 22",540,null,-217.06864564007421,-119.13357400722023,null,-240,-36.20221964729447,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 16","Vessel_1","2_A1->T1->A2","A1","T1",5]
[null,null,null,null,null,null,"Full customer 23",900,null,-361.78107606679032,-198.55595667870037,null,-400,-60.33703274549066,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 17","Vessel_3","16_A1->Z1->T1->A2","A1","Z1",7]
[null,null,null,null,null,null,"Full customer 24",1200,null,-289.42486085343228,-104.16666666666667,null,-240,566.40847247990109,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 18","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",14]
[null,null,null,null,null,null,"Full customer 25",1500,null,-361.78107606679032,-130.20833333333334,null,-300,708.01059059987631,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 19","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",30]
[null,null,null,null,null,null,"Full customer 26",3300,null,-795.91836734693879,-436.82310469314081,null,-880,1187.2585279599202,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 20","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",4]
[null,null,null,null,null,null,"Full customer 27",2240,null,-1012.987012987013,-555.95667870036107,null,-490,181.0563083126259,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 21","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",1]
[null,null,null,null,null,null,"Full customer 28",null,2400,null,null,-2400,-1020,-1020,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 22","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",3]
[null,null,null,null,null,null,"Empty customer 1",44100,null,-10636.363636363636,-3828.125,null,-7350,22285.511363636368,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 23","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",5]
[null,null,null,null,null,null,"Empty customer 2",600,null,-289.42486085343228,-203.04568527918781,null,-240,-132.47054613262009,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 24","Vessel_1","4_A1->T1->A2","A1","T1",4]
[null,null,null,null,null,null,"Empty customer 3",5700,null,-2749.5361781076067,-989.58333333333337,null,-2280,-319.11951144094019,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 25","Vessel_1","4_A1->T1->A2","A1","T1",5]
[null,null,null,null,null,null,"Empty customer 4",6000,null,-2894.2486085343226,-2030.4568527918782,null,-3200,-2124.7054613262007,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 26","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",11]
[null,null,null,null,null,null,"Empty customer 5",3450,null,-1664.1929499072355,-1167.5126903553298,null,-1840,-1221.7056402625653,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 27","Vessel_3","16_A1->Z1->T1->A2","Z1","T1",14]
[null,null,null,null,null,null,"Empty customer 6",3900,null,-940.63079777365488,-338.54166666666669,null,-780,1840.8275355596784,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 1","Vessel_1","4_A1->T1->A2","A1","T1",147]
[null,null,null,null,null,null,"Empty customer 7",1500,null,-361.78107606679032,-154.92808798646362,null,-300,683.29083594674603,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 2","Vessel_3","4_A1->T1->A2","T1","A2",4]
[null,null,null,null,null,null,"Empty customer 8",1120,null,-289.42486085343228,-203.04568527918781,null,-320,307.52945386737997,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 3","Vessel_1","4_A1->T1->A2","T1","A2",38]
[null,null,null,null,null,null,"Empty customer 9",960,null,-434.13729128014842,-304.56852791878168,null,-210,11.294180801069842,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 6","Vessel_1","4_A1->T1->A2","T1","A2",13]
[null,null,null,null,null,null,"Empty customer 10",240,null,-144.71243042671614,-79.42238267148015,null,-102,-86.13481309819629,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 7","Vessel_1","4_A1->T1->A2","T1","A2",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,"Empty customer 7","Vessel_3","4_A1->T1->A2","T1","A2",1]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H4:H41)","v":249720},{"$f":"SUM(I4:I41)","v":49650},-77999.999999999985,-41000.000000000007,-49650,-72772,57948.000000000007,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 10","Vessel_3","16_A1->Z1->T1->A2","A1","Z1",2]

{"sheet":"OrderScenario_PortStayTime","index":7,"n_rows":49,"n_cols":45,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,43,8,44],[38,1,47,1],[8,4,9,4],[8,5,8,10],[8,11,8,16],[8,17,8,22],[8,23,8,28],[8,29,8,34],[8,2,9,2],[8,3,9,3],[10,1,37,1]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Orders","Origin","Destination","Scenario 1 (Base)",null,null,null,null,null,"Scenario 2 (90%)",null,null,null,null,null,"Scenario 3 (80%)",null,null,null,null,null,"Scenario 4 (110%)",null,null,null,null,null,"Scenario 5 (120%)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Due time"]
[null,null,null,null,null,"Demand volume total","Demand volume Vessel 1","Demand volume Vessel 2","Demand volume Vessel 3","Available time at origin terminal","Due time at destination terminal","Demand volume total","Demand volume Vessel 1","Demand volume Vessel 2","Demand volume Vessel 3","Available time at origin terminal","Due time at destination terminal","Demand volume total","Demand volume Vessel 1","Demand volume Vessel 2","Demand volume Vessel 3","Available time at origin terminal","Due time at destination terminal","Demand volume total","Demand volume Vessel 1","Demand volume Vessel 2","Demand volume Vessel 3","Available time at origin terminal","Due time at destination terminal","Demand volume total","Demand volume Vessel 1","Demand volume Vessel 2","Demand volume Vessel 3","Available time at origin terminal","Due time at destination terminal",null,"TEU factor (/container)","Average weight (ton/container)","Unit outsourcing cost (€/container)","Unit handling cost (€/container)","Unit price of own sailing (€/container)","Unit price of outsourcing (€/container)","Order delay penalty (€/h)","Due date (days/ working days)","Number of days/ working days"]
[null,"Full","Full customer 1","T","A",400,98,172,130,76,168,360,194,82,84,76,168,320,91,99,130,42,144,440,165,81,194,0,120,480,197,80,203,76,168,null,2,35,450,50,300,300,2,"Days",5]
[null,null,"Full customer 2","A","T",85,0,0,85,44,96,77,0,77,0,1,96,68,64,0,4,6,96,94,64,0,30,42,96,102,0,0,102,5,96,null,1,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 3","A","T",4,0,0,4,9,96,4,0,4,0,69,264,3,0,3,0,31,96,4,0,0,4,64,264,5,5,0,0,45,96,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 4","A","T",100,43,49,8,10,96,90,4,0,86,25,96,80,0,80,0,3,96,110,1,73,36,51,264,120,27,18,75,28,96,null,1,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 5","A","T",30,0,30,0,88,120,27,27,0,0,87,120,24,23,0,1,34,96,33,25,0,8,41,96,36,36,0,0,11,96,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 6","A","T",24,0,0,24,71,264,22,0,22,0,15,96,19,0,0,19,19,96,26,0,0,26,52,264,29,0,29,0,52,264,null,1,35,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 7","A","T",2,0,2,0,74,120,2,2,0,0,68,264,2,0,0,2,8,96,2,0,2,0,51,264,2,0,0,2,48,264,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 8","A","T",14,0,0,14,55,264,13,13,0,0,25,96,11,0,0,11,15,96,15,0,0,15,1,96,17,17,0,0,76,120,null,1,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 9","A","T",39,39,0,0,92,120,35,35,0,0,31,96,31,31,0,0,57,264,43,0,0,43,69,264,47,47,0,0,66,264,null,2,28,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 10","A","T",15,0,0,15,64,264,14,10,4,0,36,96,12,0,0,12,57,264,17,17,0,0,95,120,18,18,0,0,43,96,null,1,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 11","A","T",30,0,30,0,13,96,27,27,0,0,68,264,24,0,0,24,2,96,33,0,33,0,32,96,36,0,0,36,69,264,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 12","A","T",2,2,0,0,10,96,2,2,0,0,61,264,2,0,0,2,24,96,2,0,0,2,62,264,2,2,0,0,65,264,null,1,20,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 13","A","T",1,0,0,1,52,264,1,0,1,0,77,120,1,0,0,1,3,96,1,0,0,1,34,96,1,0,0,1,44,96,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 14","A","T",1,0,0,1,6,96,1,0,1,0,89,120,1,0,1,0,27,96,1,0,0,1,40,96,1,1,0,0,19,96,null,1,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 15","A","T",27,27,0,0,93,120,24,24,0,0,71,264,22,0,22,0,39,96,30,0,0,30,67,264,32,32,0,0,80,120,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 16","A","T",5,5,0,0,42,96,5,0,0,5,90,120,4,0,0,4,93,120,6,6,0,0,18,96,6,6,0,0,91,120,null,1,25,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 17","A","T",7,0,0,7,48,264,6,6,0,0,20,96,6,0,0,6,30,96,8,0,8,0,10,96,8,8,0,0,54,264,null,2,30,450,60,150,150,2,"Working days",3]
[null,null,"Full customer 18","Z","T",14,0,14,0,38,96,13,13,0,0,18,96,11,0,0,11,70,264,15,15,0,0,3,96,17,0,17,0,10,96,null,1,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 19","Z","T",30,0,30,0,35,96,27,27,0,0,51,264,24,0,0,24,74,120,33,33,0,0,26,96,36,0,36,0,32,96,null,2,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 20","Z","T",4,0,4,0,5,96,4,4,0,0,35,96,3,0,0,3,79,120,4,4,0,0,30,96,5,0,5,0,76,120,null,1,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 21","Z","T",1,0,1,0,26,96,1,1,0,0,4,96,1,0,0,1,44,96,1,1,0,0,41,96,1,0,1,0,47,96,null,2,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 22","Z","T",3,0,3,0,39,96,3,3,0,0,51,264,2,0,0,2,76,120,3,3,0,0,48,264,4,0,4,0,51,264,null,1,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 23","Z","T",5,0,5,0,33,96,5,5,0,0,21,96,4,0,0,4,85,120,6,6,0,0,40,96,6,0,6,0,65,264,null,2,30,450,80,180,180,2,"Working days",3]
[null,null,"Full customer 24","A","T",4,4,0,0,30,48,4,4,0,0,26,48,3,0,0,3,6,24,4,4,0,0,64,168,5,4,1,0,63,168,null,2.25,30,450,60,300,300,2,"Days",1]
[null,null,"Full customer 25","A","T",5,0,5,0,31,96,5,5,0,0,62,264,4,0,0,4,25,96,6,6,0,0,58,264,6,0,6,0,48,264,null,2.25,30,450,60,300,300,2,"Working days",3]
[null,null,"Full customer 26","Z","T",11,0,11,0,24,96,10,10,0,0,27,96,9,0,0,9,33,96,12,12,0,0,44,96,13,0,13,0,53,264,null,2.25,30,450,80,300,300,2,"Working days",3]
[null,null,"Full customer 27","Z","T",14,0,14,0,15,96,13,13,0,0,49,264,11,0,0,11,23,96,15,15,0,0,96,264,17,0,17,0,34,96,null,2,30,450,35,160,160,2,"Working days",3]
[null,null,"Full customer 28","Z","A",20,0,20,0,2,96,18,0,0,18,76,120,16,0,0,16,4,96,22,0,22,0,31,96,24,0,24,0,48,264,null,1,30,450,51,120,120,2,"Working days",3]
[null,"Empty","Empty customer 1","A","T",147,0,0,147,76,168,132,0,0,132,76,168,118,0,0,118,76,168,162,3,0,159,76,168,176,138,0,38,76,168,null,2,6,450,50,300,300,2,"Days",5]
[null,null,"Empty customer 2","T","A",4,4,0,0,69,360,4,4,0,0,20,192,3,0,0,3,83,216,4,0,0,4,4,192,5,0,5,0,62,360,null,1,4,450,60,150,150,2,"Working days",5]
[null,null,"Empty customer 3","T","A",38,0,0,38,24,192,34,34,0,0,43,192,30,30,0,0,54,360,42,0,0,42,77,216,46,46,0,0,12,192,null,2,3,450,60,150,150,2,"Working days",5]
[null,null,"Empty customer 4","T","Z",40,0,40,0,34,192,36,0,0,36,90,216,32,0,0,32,27,192,44,0,44,0,66,360,48,0,48,0,53,360,null,1,4,450,80,150,150,2,"Working days",5]
[null,null,"Empty customer 5","T","Z",23,0,23,0,91,216,21,0,0,21,34,192,18,0,0,18,53,360,25,0,25,0,65,360,28,0,28,0,72,216,null,2,4,450,80,150,150,2,"Working days",5]
[null,null,"Empty customer 6","T","A",13,0,13,0,63,240,12,12,0,0,96,240,10,0,10,0,8,96,14,0,0,14,66,240,16,16,0,0,84,144,null,2.25,2,450,60,300,300,2,"Days",4]
[null,null,"Empty customer 7","T","A",5,5,0,0,70,360,5,5,0,0,3,192,4,4,0,0,92,216,6,0,0,6,57,360,6,1,5,0,65,360,null,2.25,4,450,60,300,300,2,"Working days",5]
[null,null,"Empty customer 8","T","Z",4,0,4,0,19,192,4,4,0,0,56,360,3,0,0,3,8,192,4,0,4,0,35,192,5,0,5,0,1,192,null,2.25,4.5,450,80,280,280,2,"Working days",5]
[null,null,"Empty customer 9","T","Z",6,0,6,0,47,192,5,0,0,5,3,192,5,0,0,5,35,192,7,0,7,0,5,192,7,0,7,0,67,360,null,2,4,450,35,160,160,2,"Working days",5]
[null,null,"Empty customer 10","A","Z",2,0,2,0,3,192,2,2,0,0,72,216,2,0,0,2,58,360,2,2,0,0,10,192,2,0,2,0,42,192,null,1,4,450,51,120,120,2,"Working days",5]
[null,null,null,null,null,null,null,null,null,null,null,0.9,null,null,null,null,null,0.8,null,null,null,null,null,1.1000000000000001,null,null,null,null,null,1.2]

{"sheet":"Input_PortStayTime","index":8,"n_rows":221,"n_cols":27,"rows_kept":221,"cut":false,"hidden":false,"merged":[[75,1,76,3],[75,5,75,26],[76,5,76,15],[76,16,76,26],[186,5,186,15],[186,16,186,26],[130,1,131,3],[130,5,130,26],[131,5,131,15],[131,16,131,26],[185,1,186,3],[185,5,185,26]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Inputs for Routing"]
[]
[null,"Total vessel operation time (h/week)",160,null,"Available vessel",null,null,null,null,null,null,null,null,null,"Building blocks for routing","Cost (fuel cost + port fee) (€)","Sailing time (h)"]
[null,"Average terminal handling speed (container/h)",16,null,"Vessel_1",1,null,null,null,null,null,null,null,null,"1_A1->T1->A2",10000,36]
[null,null,null,null,"Vessel_2",1,null,null,null,null,null,null,null,null,"2_A1->T1->A2",10000,36]
[null,"Vessel Rent (€/week)",40000,null,"Vessel_3",1,null,null,null,null,null,null,null,null,"3_A1->T1->A2",10000,36]
[null,"Discount rate on vessel rent from 2nd vessel",0.05,null,null,null,null,null,null,null,null,null,null,null,"4_A1->T1->A2",10000,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_A1->Z1->A2",9000,30]
[null,"Vessel volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"6_A1->Z1->A2",9000,30]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400,null,"7_A1->Z1->A2",9000,30]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400,null,"8_A1->Z1->A2",9000,30]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400,null,"9_A1->T1->Z1->A2",11000,59]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400,null,"10_A1->T1->Z1->A2",11000,59]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400,null,"11_A1->T1->Z1->A2",11000,59]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400,null,"12_A1->T1->Z1->T2->Z2->A2",16000,111]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0,null,"13_A1->T1->Z1->T2->Z2->A2",16000,111]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0,null,"14_A1->T1->Z1->T2->Z2->T3->Z3->A2",23000,163]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0,null,"15_A1->T1->Z1->T2->Z2->T3->Z3->T4->Z4->A2",28000,215]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0,null,"16_A1->Z1->T1->A2",11000,59]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0,null,"17_A1->Z1->T1->A2",11000,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18_A1->Z1->T1->A2",11000,59]
[null,"Vessel weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"19_A1->Z1->T1->Z2->T2->A2",16000,111]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"20_A1->Z1->T1->Z2->T2->A2",16000,111]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"21_A1->Z1->T1->Z2->T2->Z3->T3->A2",24000,163]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"22_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->A2",28000,215]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"23_A1->T1->Z1->T2->A2",15000,88]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"24_A1->T1->Z1->T2->A2",15000,88]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"25_A1->T1->Z1->T2->Z2->T3->A2",21000,140]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"26_A1->T1->Z1->T2->Z2->T3->Z3->T4->A2",28000,192]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"27_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"28_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"29_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"30_A1->Z1->T1->Z2->T2->Z3->A2",18000,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31_A1->Z1->T1->Z2->T2->Z3->A2",18000,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32_A1->Z1->T1->Z2->T2->Z3->T3->Z4->A2",25000,186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->Z5->A2",32000,238]
[null,"Terminals","Unit extra labor cost during weekends (Euro/h)","Average loading time at each terminal (h)","Average unloading time at each terminal (h)","Service early departure penalty (Euro/h)","Service late departure penalty (Euro/h)","Service early arrival penalty (Euro/h)","Service late arrival penalty (Euro/h)"]
[null,"A1",30,4,4,150,150,150,150]
[null,"A2",30,4,4,150,150,150,150]
[null,"T1",20,4,4,200,200,200,200]
[null,"T2",20,4,4,200,200,200,200]
[null,"T3",20,4,4,200,200,200,200]
[null,"T4",20,4,4,200,200,200,200]
[null,"Z1",15,4,4,100,100,100,100]
[null,"Z2",15,4,4,100,100,100,100]
[null,"Z3",15,4,4,100,100,100,100]
[null,"Z4",15,4,4,100,100,100,100]
[null,"Z5",15,4,4,100,100,100,100]
[]
[]
[null,"Input for Scheduling"]
[null,"Vessel 1"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Define Time slot (Separate a week to several time slots. There is a time window in each slot that the vessel can visit the terminal)",null,null,null,"Preferred port stay time window at each terminal "]
[null,null,null,null,null,"Begin port stay",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[]
[]
[null,"Vessel 2"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Define Time slot (Separate a week to several time slots. There is a time window in each slot that the vessel can visit the terminal)",null,null,null,"Preferred port stay time window at each terminal "]
[null,null,null,null,null,"Begin port stay ",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[]
[]
[null,"Vessel 3"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Define Time slot (Separate a week to several time slots. There is a time window in each slot that the vessel can visit the terminal)",null,null,null,"Preferred port stay time window at each terminal "]
[null,null,null,null,null,"Begin port stay",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]

{"sheet":"Output_Routing_PortStayTime","index":9,"n_rows":209,"n_cols":22,"rows_kept":209,"cut":false,"hidden":false,"merged":[[1,15,1,17],[1,19,1,21],[43,8,44,8],[43,9,44,9],[43,10,44,10],[43,11,44,11],[43,12,44,12],[43,13,44,13],[43,15,43,17],[43,19,43,21],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[85,15,85,17],[85,19,85,21],[127,8,128,8],[127,9,128,9],[127,10,128,10],[127,11,128,11],[127,12,128,12],[127,13,128,13],[127,15,127,17],[127,19,127,21],[85,8,86,8],[85,9,86,9],[85,10,86,10],[85,11,86,11],[85,12,86,12],[85,13,86,13],[169,15,169,17],[169,19,169,21],[169,8,170,8],[169,9,170,9],[169,10,170,10],[169,11,170,11],[169,12,170,12],[169,13,170,13]]}
[]
[null,null,null,null,null,null,null,"Scenario 1","Volume of Vessel 1 (container)","Volume of Vessel 2 (container)","Volume of Vessel 3 (container)","Total volume of own sailing (containers)","Oursourcing volume (container)","Total Volume",null,"% of customers demand delivered by each vessel",null,null,null,"Routes of each vessel"]
[null,null,null,null,null,null,null,"Customer",null,null,null,null,null,null,null,"Vessel 1","Vessel 2","Vessel 3",null,"Vessel #","Building blocks","Whether selected"]
[null,null,null,null,null,null,null,"Full customer 1",98,172,130,{"$f":"SUM(I4:K4)","v":400},0,{"$f":"SUM(L4:M4)","v":400},null,0.245,0.43,0.32500000000000001,null,"Vessel_1","4_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 2",0,0,85,{"$f":"SUM(I5:K5)","v":85},0,{"$f":"SUM(L5:M5)","v":85},null,0,0,1,null,"Vessel_2","3_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 3",0,0,4,4,0,4,null,0,0,1,null,"Vessel_2","17_A1->Z1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 4",43,49,8,100,0,100,null,0.43,0.49,0.08,null,"Vessel_3","1_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 5",0,30,0,30,0,30,null,0,1,0,null,"Vessel_3","4_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 6",0,0,24,24,0,24,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 7",0,2,0,2,0,2,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 8",0,0,14,14,0,14,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 9",39,0,0,39,0,39,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 10",0,0,15,15,0,15,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 11",0,30,0,30,0,30,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 12",2,0,0,2,0,2,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 13",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 14",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 15",27,0,0,27,0,27,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 16",5,0,0,5,0,5,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 17",0,0,7,7,0,7,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 18",0,14,0,14,0,14,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 19",0,30,0,30,0,30,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 20",0,4,0,4,0,4,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 21",0,1,0,1,0,1,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 22",0,3,0,3,0,3,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 23",0,5,0,5,0,5,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 24",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 25",0,5,0,5,0,5,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 26",0,11,0,11,0,11,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 27",0,14,0,14,0,14,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 28",0,20,0,20,0,20,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 1",0,0,147,147,0,147,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 2",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 3",0,0,38,38,0,38,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 4",0,40,0,40,0,40,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 5",0,23,0,23,0,23,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 6",0,13,0,13,0,13,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 7",5,0,0,5,0,5,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 8",0,4,0,4,0,4,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 9",0,6,0,6,0,6,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 10",0,2,0,2,0,2,null,0,1,0]
[]
[]
[null,null,null,null,null,null,null,"Scenario 2","Volume of Vessel 1 (container)","Volume of Vessel 2 (container)","Volume of Vessel 3 (container)","Total volume of own sailing (containers)","Oursourcing volume (container)","Total Volume",null,"% of customers demand delivered by each vessel",null,null,null,"Routes of each vessel"]
[null,null,null,null,null,null,null,"Customer",null,null,null,null,null,null,null,"Vessel 1","Vessel 2","Vessel 3",null,"Vessel #","Building blocks","Whether selected"]
[null,null,null,null,null,null,null,"Full customer 1",194,82,84,{"$f":"SUM(I46:K46)","v":360},0,{"$f":"SUM(L46:M46)","v":360},null,0.53888888888888886,0.22777777777777777,0.23333333333333334,null,"Vessel_1","1_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 2",0,77,0,{"$f":"SUM(I47:K47)","v":77},0,{"$f":"SUM(L47:M47)","v":77},null,0,1,0,null,"Vessel_1","16_A1->Z1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 3",0,4,0,4,0,4,null,0,1,0,null,"Vessel_2","10_A1->T1->Z1->A2",1]
[null,null,null,null,null,null,null,"Full customer 4",4,0,86,90,0,90,null,4.4444444444444446E-2,0,0.9555555555555556,null,"Vessel_3","10_A1->T1->Z1->A2",1]
[null,null,null,null,null,null,null,"Full customer 5",27,0,0,27,0,27,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 6",0,22,0,22,0,22,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 7",2,0,0,2,0,2,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 8",13,0,0,13,0,13,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 9",35,0,0,35,0,35,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 10",10,4,0,14,0,14,null,0.7142857142857143,0.2857142857142857,0]
[null,null,null,null,null,null,null,"Full customer 11",27,0,0,27,0,27,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 12",2,0,0,2,0,2,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 13",0,1,0,1,0,1,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 14",0,1,0,1,0,1,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 15",24,0,0,24,0,24,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 16",0,0,5,5,0,5,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 17",6,0,0,6,0,6,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 18",13,0,0,13,0,13,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 19",27,0,0,27,0,27,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 20",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 21",1,0,0,1,0,1,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 22",3,0,0,3,0,3,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 23",5,0,0,5,0,5,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 24",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 25",5,0,0,5,0,5,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 26",10,0,0,10,0,10,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 27",13,0,0,13,0,13,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 28",0,0,18,18,0,18,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 1",0,0,132,132,0,132,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 2",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 3",34,0,0,34,0,34,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 4",0,0,36,36,0,36,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 5",0,0,21,21,0,21,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 6",12,0,0,12,0,12,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 7",5,0,0,5,0,5,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 8",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 9",0,0,5,5,0,5,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 10",2,0,0,2,0,2,null,1,0,0]
[]
[]
[null,null,null,null,null,null,null,"Scenario 3","Volume of Vessel 1 (container)","Volume of Vessel 2 (container)","Volume of Vessel 3 (container)","Total volume of own sailing (containers)","Oursourcing volume (container)","Total Volume",null,"% of customers demand delivered by each vessel",null,null,null,"Routes of each vessel"]
[null,null,null,null,null,null,null,"Customer",null,null,null,null,null,null,null,"Vessel 1","Vessel 2","Vessel 3",null,"Vessel #","Building blocks","Whether selected"]
[null,null,null,null,null,null,null,"Full customer 1",91,99,130,{"$f":"SUM(I88:K88)","v":320},0,{"$f":"SUM(L88:M88)","v":320},null,0.28437499999999999,0.30937500000000001,0.40625,null,"Vessel_1","4_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 2",64,0,4,{"$f":"SUM(I89:K89)","v":68},0,{"$f":"SUM(L89:M89)","v":68},null,0.94117647058823528,0,5.8823529411764705E-2,null,"Vessel_2","2_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 3",0,3,0,3,0,3,null,0,1,0,null,"Vessel_3","2_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 4",0,80,0,80,0,80,null,0,1,0,null,"Vessel_3","11_A1->T1->Z1->A2",1]
[null,null,null,null,null,null,null,"Full customer 5",23,0,1,24,0,24,null,0.95833333333333337,0,4.1666666666666664E-2]
[null,null,null,null,null,null,null,"Full customer 6",0,0,19,19,0,19,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 7",0,0,2,2,0,2,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 8",0,0,11,11,0,11,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 9",31,0,0,31,0,31,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 10",0,0,12,12,0,12,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 11",0,0,24,24,0,24,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 12",0,0,2,2,0,2,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 13",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 14",0,1,0,1,0,1,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 15",0,22,0,22,0,22,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 16",0,0,4,4,0,4,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 17",0,0,6,6,0,6,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 18",0,0,11,11,0,11,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 19",0,0,24,24,0,24,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 20",0,0,3,3,0,3,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 21",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 22",0,0,2,2,0,2,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 23",0,0,4,4,0,4,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 24",0,0,3,3,0,3,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 25",0,0,4,4,0,4,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 26",0,0,9,9,0,9,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 27",0,0,11,11,0,11,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 28",0,0,16,16,0,16,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 1",0,0,118,118,0,118,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 2",0,0,3,3,0,3,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 3",30,0,0,30,0,30,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 4",0,0,32,32,0,32,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 5",0,0,18,18,0,18,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 6",0,10,0,10,0,10,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 7",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 8",0,0,3,3,0,3,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 9",0,0,5,5,0,5,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 10",0,0,2,2,0,2,null,0,0,1]
[]
[]
[null,null,null,null,null,null,null,"Scenario 4","Volume of Vessel 1 (container)","Volume of Vessel 2 (container)","Volume of Vessel 3 (container)","Total volume of own sailing (containers)","Oursourcing volume (container)","Total Volume",null,"% of customers demand delivered by each vessel",null,null,null,"Routes of each vessel"]
[null,null,null,null,null,null,null,"Customer",null,null,null,null,null,null,null,"Vessel 1","Vessel 2","Vessel 3",null,"Vessel #","Building blocks","Whether selected"]
[null,null,null,null,null,null,null,"Full customer 1",165,81,194,{"$f":"SUM(I130:K130)","v":440},0,{"$f":"SUM(L130:M130)","v":440},null,0.375,0.18409090909090908,0.44090909090909092,null,"Vessel_1","4_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 2",64,0,30,{"$f":"SUM(I131:K131)","v":94},0,{"$f":"SUM(L131:M131)","v":94},null,0.68085106382978722,0,0.31914893617021278,null,"Vessel_1","18_A1->Z1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 3",0,0,4,4,0,4,null,0,0,1,null,"Vessel_2","11_A1->T1->Z1->A2",1]
[null,null,null,null,null,null,null,"Full customer 4",1,73,36,110,0,110,null,9.0909090909090905E-3,0.66363636363636369,0.32727272727272727,null,"Vessel_3","2_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 5",25,0,8,33,0,33,null,0.75757575757575757,0,0.24242424242424243,null,"Vessel_3","3_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 6",0,0,26,26,0,26,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 7",0,2,0,2,0,2,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 8",0,0,15,15,0,15,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 9",0,0,43,43,0,43,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 10",17,0,0,17,0,17,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 11",0,33,0,33,0,33,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 12",0,0,2,2,0,2,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 13",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 14",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 15",0,0,30,30,0,30,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 16",6,0,0,6,0,6,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 17",0,8,0,8,0,8,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 18",15,0,0,15,0,15,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 19",33,0,0,33,0,33,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 20",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 21",1,0,0,1,0,1,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 22",3,0,0,3,0,3,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 23",6,0,0,6,0,6,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 24",4,0,0,4,0,4,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 25",6,0,0,6,0,6,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 26",12,0,0,12,0,12,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 27",15,0,0,15,0,15,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 28",0,22,0,22,0,22,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 1",3,0,159,162,0,162,null,1.8518518518518517E-2,0,0.98148148148148151]
[null,null,null,null,null,null,null,"Empty customer 2",0,0,4,4,0,4,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 3",0,0,42,42,0,42,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 4",0,44,0,44,0,44,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 5",0,25,0,25,0,25,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 6",0,0,14,14,0,14,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 7",0,0,6,6,0,6,null,0,0,1]
[null,null,null,null,null,null,null,"Empty customer 8",0,4,0,4,0,4,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 9",0,7,0,7,0,7,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 10",2,0,0,2,0,2,null,1,0,0]
[]
[]
[null,null,null,null,null,null,null,"Scenario 5","Volume of Vessel 1 (container)","Volume of Vessel 2 (container)","Volume of Vessel 3 (container)","Total volume of own sailing (containers)","Oursourcing volume (container)","Total Volume",null,"% of customers demand delivered by each vessel",null,null,null,"Routes of each vessel"]
[null,null,null,null,null,null,null,"Customer",null,null,null,null,null,null,null,"Vessel 1","Vessel 2","Vessel 3",null,"Vessel #","Building blocks","Whether selected"]
[null,null,null,null,null,null,null,"Full customer 1",195,79,200,{"$f":"SUM(I172:K172)","v":474},6,{"$f":"SUM(L172:M172)","v":480},null,0.41139240506329117,0.16666666666666666,0.4219409282700422,null,"Vessel_1","1_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 2",0,0,102,{"$f":"SUM(I173:K173)","v":102},0,{"$f":"SUM(L173:M173)","v":102},null,0,0,1,null,"Vessel_1","2_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 3",5,0,0,5,0,5,null,1,0,0,null,"Vessel_2","13_A1->T1->Z1->T2->Z2->A2",1]
[null,null,null,null,null,null,null,"Full customer 4",27,18,75,120,0,120,null,0.22500000000000001,0.15,0.625,null,"Vessel_3","1_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 5",36,0,0,36,0,36,null,1,0,0,null,"Vessel_3","2_A1->T1->A2",1]
[null,null,null,null,null,null,null,"Full customer 6",0,29,0,29,0,29,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 7",0,0,2,2,0,2,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 8",17,0,0,17,0,17,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 9",47,0,0,47,0,47,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 10",18,0,0,18,0,18,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 11",0,0,36,36,0,36,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 12",2,0,0,2,0,2,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 13",0,0,1,1,0,1,null,0,0,1]
[null,null,null,null,null,null,null,"Full customer 14",1,0,0,1,0,1,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 15",32,0,0,32,0,32,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 16",6,0,0,6,0,6,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 17",8,0,0,8,0,8,null,1,0,0]
[null,null,null,null,null,null,null,"Full customer 18",0,17,0,17,0,17,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 19",0,36,0,36,0,36,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 20",0,5,0,5,0,5,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 21",0,1,0,1,0,1,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 22",0,4,0,4,0,4,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 23",0,6,0,6,0,6,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 24",4,1,0,5,0,5,null,0.8,0.2,0]
[null,null,null,null,null,null,null,"Full customer 25",0,6,0,6,0,6,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 26",0,13,0,13,0,13,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 27",0,17,0,17,0,17,null,0,1,0]
[null,null,null,null,null,null,null,"Full customer 28",0,23,0,23,1,24,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 1",138,0,38,176,0,176,null,0.78409090909090906,0,0.21590909090909091]
[null,null,null,null,null,null,null,"Empty customer 2",0,5,0,5,0,5,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 3",46,0,0,46,0,46,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 4",0,48,0,48,0,48,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 5",0,28,0,28,0,28,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 6",16,0,0,16,0,16,null,1,0,0]
[null,null,null,null,null,null,null,"Empty customer 7",1,5,0,6,0,6,null,0.16666666666666666,0.83333333333333337,0]
[null,null,null,null,null,null,null,"Empty customer 8",0,5,0,5,0,5,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 9",0,7,0,7,0,7,null,0,1,0]
[null,null,null,null,null,null,null,"Empty customer 10",0,2,0,2,0,2,null,0,1,0]

{"sheet":"Output_Scheduling_PortStayTime","index":10,"n_rows":46,"n_cols":36,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Schedule of Vessel 1",null,null,null,null,null,null,null,null,null,null,null,"Schedule of Vessel 2",null,null,null,null,null,null,null,null,null,null,null,"Schedule of Vessel 3"]
[null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,"Scenario 1",null,null,null,null,null,null,null,null,null,null,null,"Scenario 1"]
[null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"4_A1->T1->A2","A1","T1",85.000000000000014,{"$f":"IF(E15=0,\"\",IF(E15<24,\"Sun\",IF(E15<48,\"Mon\",IF(E15<72,\"Tue\",IF(E15<96,\"Wed\",IF(E15<120,\"Thur\",IF(E15<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(F15=\"\",\"\",(E15-ROUNDDOWN(E15/24,0)*24))","v":13.000000000000014},103.00000000000001,{"$f":"IF(H15=0,\"\",IF(H15<24,\"Sun\",IF(H15<48,\"Mon\",IF(H15<72,\"Tue\",IF(H15<96,\"Wed\",IF(H15<120,\"Thur\",IF(H15<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(I15=\"\",\"\",(H15-ROUNDDOWN(H15/24,0)*24))","v":7.0000000000000142},0.47749999999999998,0.99342857142857144,null,"3_A1->T1->A2","A1","T1",9,{"$f":"IF(Q15=0,\"\",IF(Q15<24,\"Sun\",IF(Q15<48,\"Mon\",IF(Q15<72,\"Tue\",IF(Q15<96,\"Wed\",IF(Q15<120,\"Thur\",IF(Q15<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(R15=\"\",\"\",(Q15-ROUNDDOWN(Q15/24,0)*24))","v":9},27,{"$f":"IF(T15=0,\"\",IF(T15<24,\"Sun\",IF(T15<48,\"Mon\",IF(T15<72,\"Tue\",IF(T15<96,\"Wed\",IF(T15<120,\"Thur\",IF(T15<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(U15=\"\",\"\",(T15-ROUNDDOWN(T15/24,0)*24))","v":3},0.453125,0.99714285714285711,null,"1_A1->T1->A2","A1","T1",13,{"$f":"IF(AC15=0,\"\",IF(AC15<24,\"Sun\",IF(AC15<48,\"Mon\",IF(AC15<72,\"Tue\",IF(AC15<96,\"Wed\",IF(AC15<120,\"Thur\",IF(AC15<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(AD15=\"\",\"\",(AC15-ROUNDDOWN(AC15/24,0)*24))","v":13},31,{"$f":"IF(AF15=0,\"\",IF(AF15<24,\"Sun\",IF(AF15<48,\"Mon\",IF(AF15<72,\"Tue\",IF(AF15<96,\"Wed\",IF(AF15<120,\"Thur\",IF(AF15<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(AG15=\"\",\"\",(AF15-ROUNDDOWN(AF15/24,0)*24))","v":7},0.30249999999999999,0.45628571428571429]
[null,"4_A1->T1->A2","T1","A2",135.00000000000023,{"$f":"IF(E16=0,\"\",IF(E16<24,\"Sun\",IF(E16<48,\"Mon\",IF(E16<72,\"Tue\",IF(E16<96,\"Wed\",IF(E16<120,\"Thur\",IF(E16<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(F16=\"\",\"\",(E16-ROUNDDOWN(E16/24,0)*24))","v":15.000000000000227},153.00000000000023,{"$f":"IF(H16=0,\"\",IF(H16<24,\"Sun\",IF(H16<48,\"Mon\",IF(H16<72,\"Tue\",IF(H16<96,\"Wed\",IF(H16<120,\"Thur\",IF(H16<144,\"Fri\",\"Sat\")))))))","v":"Sat"},{"$f":"IF(I16=\"\",\"\",(H16-ROUNDDOWN(H16/24,0)*24))","v":9.0000000000002274},0.52812499999999996,0.99028571428571432,null,"3_A1->T1->A2","T1","A2",42.3125,{"$f":"IF(Q16=0,\"\",IF(Q16<24,\"Sun\",IF(Q16<48,\"Mon\",IF(Q16<72,\"Tue\",IF(Q16<96,\"Wed\",IF(Q16<120,\"Thur\",IF(Q16<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(R16=\"\",\"\",(Q16-ROUNDDOWN(Q16/24,0)*24))","v":18.3125},60.3125,{"$f":"IF(T16=0,\"\",IF(T16<24,\"Sun\",IF(T16<48,\"Mon\",IF(T16<72,\"Tue\",IF(T16<96,\"Wed\",IF(T16<120,\"Thur\",IF(T16<144,\"Fri\",\"Sat\")))))))","v":"Tue"},{"$f":"IF(U16=\"\",\"\",(T16-ROUNDDOWN(T16/24,0)*24))","v":12.3125},0.62624999999999997,0.99765714285714291,null,"1_A1->T1->A2","T1","A2",85,{"$f":"IF(AC16=0,\"\",IF(AC16<24,\"Sun\",IF(AC16<48,\"Mon\",IF(AC16<72,\"Tue\",IF(AC16<96,\"Wed\",IF(AC16<120,\"Thur\",IF(AC16<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(AD16=\"\",\"\",(AC16-ROUNDDOWN(AC16/24,0)*24))","v":13},103,{"$f":"IF(AF16=0,\"\",IF(AF16<24,\"Sun\",IF(AF16<48,\"Mon\",IF(AF16<72,\"Tue\",IF(AF16<96,\"Wed\",IF(AF16<120,\"Thur\",IF(AF16<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(AG16=\"\",\"\",(AF16-ROUNDDOWN(AF16/24,0)*24))","v":7},0.51500000000000001,0.8828571428571429]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"17_A1->Z1->T1->A2","A1","Z1",83.8125,"Wed",11.8125,98.8125,"Thur",2.8125,0.66,0.65780000000000005,null,"4_A1->T1->A2","A1","T1",111,"Thur",15,129,"Fri",9,8.2500000000000004E-2,0.21428571428571427]
[null,"Scenario 2",null,null,null,null,null,null,null,null,null,null,null,"17_A1->Z1->T1->A2","T1","A2",142.375,"Fri",22.375,160.375,"Sat",16.375,0.3175,0.49785714285714283,null,"4_A1->T1->A2","T1","A2",137.8125,"Fri",17.8125,155.8125,"Sat",11.8125,0.57999999999999996,0.99428571428571433]
[null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"17_A1->Z1->T1->A2","Z1","T1",101.8125,"Thur",5.8125,127.8125,"Fri",7.8125,0.80500000000000005,0.88842857142857146]
[null,"1_A1->T1->A2","A1","T1",108.9375,{"$f":"IF(E20=0,\"\",IF(E20<24,\"Sun\",IF(E20<48,\"Mon\",IF(E20<72,\"Tue\",IF(E20<96,\"Wed\",IF(E20<120,\"Thur\",IF(E20<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(F20=\"\",\"\",(E20-ROUNDDOWN(E20/24,0)*24))","v":12.9375},126.9375,{"$f":"IF(H20=0,\"\",IF(H20<24,\"Sun\",IF(H20<48,\"Mon\",IF(H20<72,\"Tue\",IF(H20<96,\"Wed\",IF(H20<120,\"Thur\",IF(H20<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(I20=\"\",\"\",(H20-ROUNDDOWN(H20/24,0)*24))","v":6.9375},0.50812500000000005,0.93428571428571427,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2"]
[null,"1_A1->T1->A2","T1","A2",140.125,"Fri",20.125,158.125,"Sat",14.125,0.51187499999999997,0.99228571428571433,null,"Scenario 2",null,null,null,null,null,null,null,null,null,null,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"16_A1->Z1->T1->A2","A1","Z1",12.875,"Sun",12.875,27.875,"Mon",3.875,0.22500000000000001,0.40514285714285714,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"10_A1->T1->Z1->A2","A1","T1",85.25,{"$f":"IF(AC22=0,\"\",IF(AC22<24,\"Sun\",IF(AC22<48,\"Mon\",IF(AC22<72,\"Tue\",IF(AC22<96,\"Wed\",IF(AC22<120,\"Thur\",IF(AC22<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(AD22=\"\",\"\",(AC22-ROUNDDOWN(AC22/24,0)*24))","v":13.25},103.25,{"$f":"IF(AF22=0,\"\",IF(AF22<24,\"Sun\",IF(AF22<48,\"Mon\",IF(AF22<72,\"Tue\",IF(AF22<96,\"Wed\",IF(AF22<120,\"Thur\",IF(AF22<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(AG22=\"\",\"\",(AF22-ROUNDDOWN(AF22/24,0)*24))","v":7.25},0.51249999999999996,0.8858571428571429]
[null,"16_A1->Z1->T1->A2","T1","A2",74.9375,"Wed",2.9375,92.9375,"Wed",20.9375,0.73375000000000001,0.99399999999999999,null,"10_A1->T1->Z1->A2","A1","T1",13,{"$f":"IF(Q23=0,\"\",IF(Q23<24,\"Sun\",IF(Q23<48,\"Mon\",IF(Q23<72,\"Tue\",IF(Q23<96,\"Wed\",IF(Q23<120,\"Thur\",IF(Q23<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(R23=\"\",\"\",(Q23-ROUNDDOWN(Q23/24,0)*24))","v":13},31,{"$f":"IF(T23=0,\"\",IF(T23<24,\"Sun\",IF(T23<48,\"Mon\",IF(T23<72,\"Tue\",IF(T23<96,\"Wed\",IF(T23<120,\"Thur\",IF(T23<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(U23=\"\",\"\",(T23-ROUNDDOWN(T23/24,0)*24))","v":7},7.2499999999999995E-2,0.24,null,"10_A1->T1->Z1->A2","T1","Z1",121.4375,"Fri",1.4375,147.4375,"Sat",3.4375,0.44500000000000001,0.72542857142857142]
[null,"16_A1->Z1->T1->A2","Z1","T1",32.3125,"Mon",8.3125,58.3125,"Tue",10.3125,0.53874999999999995,0.99428571428571433,null,"10_A1->T1->Z1->A2","T1","Z1",55,"Tue",7,81,"Wed",9,0.57999999999999996,0.99428571428571433,null,"10_A1->T1->Z1->A2","Z1","A2",147.75,"Sat",3.75,162.75,"Sat",18.75,0.42,0.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10_A1->T1->Z1->A2","Z1","A2",88,"Wed",16,103,"Thur",7,0.57999999999999996,0.99428571428571433]
[null,"Scenario 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 3"]
[null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"Scenario 3",null,null,null,null,null,null,null,null,null,null,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"4_A1->T1->A2","A1","T1",61,{"$f":"IF(E28=0,\"\",IF(E28<24,\"Sun\",IF(E28<48,\"Mon\",IF(E28<72,\"Tue\",IF(E28<96,\"Wed\",IF(E28<120,\"Thur\",IF(E28<144,\"Fri\",\"Sat\")))))))","v":"Tue"},{"$f":"IF(F28=\"\",\"\",(E28-ROUNDDOWN(E28/24,0)*24))","v":13},79,{"$f":"IF(H28=0,\"\",IF(H28<24,\"Sun\",IF(H28<48,\"Mon\",IF(H28<72,\"Tue\",IF(H28<96,\"Wed\",IF(H28<120,\"Thur\",IF(H28<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(I28=\"\",\"\",(H28-ROUNDDOWN(H28/24,0)*24))","v":7},0.43,0.99371428571428566,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"2_A1->T1->A2","A1","T1",96.3125,{"$f":"IF(AC28=0,\"\",IF(AC28<24,\"Sun\",IF(AC28<48,\"Mon\",IF(AC28<72,\"Tue\",IF(AC28<96,\"Wed\",IF(AC28<120,\"Thur\",IF(AC28<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(AD28=\"\",\"\",(AC28-ROUNDDOWN(AC28/24,0)*24))","v":0.3125},114.3125,{"$f":"IF(AF28=0,\"\",IF(AF28<24,\"Sun\",IF(AF28<48,\"Mon\",IF(AF28<72,\"Tue\",IF(AF28<96,\"Wed\",IF(AF28<120,\"Thur\",IF(AF28<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(AG28=\"\",\"\",(AF28-ROUNDDOWN(AF28/24,0)*24))","v":18.3125},0.79500000000000004,0.99285714285714288]
[null,"4_A1->T1->A2","T1","A2",109,"Thur",13,127,"Fri",7,0.62749999999999995,0.94028571428571428,null,"2_A1->T1->A2","A1","T1",61,{"$f":"IF(Q29=0,\"\",IF(Q29<24,\"Sun\",IF(Q29<48,\"Mon\",IF(Q29<72,\"Tue\",IF(Q29<96,\"Wed\",IF(Q29<120,\"Thur\",IF(Q29<144,\"Fri\",\"Sat\")))))))","v":"Tue"},{"$f":"IF(R29=\"\",\"\",(Q29-ROUNDDOWN(Q29/24,0)*24))","v":13},79,{"$f":"IF(T29=0,\"\",IF(T29<24,\"Sun\",IF(T29<48,\"Mon\",IF(T29<72,\"Tue\",IF(T29<96,\"Wed\",IF(T29<120,\"Thur\",IF(T29<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(U29=\"\",\"\",(T29-ROUNDDOWN(T29/24,0)*24))","v":7},0.3125,0.8828571428571429,null,"2_A1->T1->A2","T1","A2",135,"Fri",15,153,"Sat",9,0.57999999999999996,0.99428571428571433]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2_A1->T1->A2","T1","A2",109,"Thur",13,127,"Fri",7,0.53500000000000003,0.88142857142857145,null,"11_A1->T1->Z1->A2","A1","T1",19.125,"Sun",19.125,37.125,"Mon",13.125,0.31,0.55428571428571427]
[null,"Scenario 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11_A1->T1->Z1->A2","T1","Z1",43,"Mon",19,69,"Tue",21,0.13375000000000001,0.16442857142857142]
[null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"Scenario 4",null,null,null,null,null,null,null,null,null,null,null,"11_A1->T1->Z1->A2","Z1","A2",76,"Wed",4,91,"Wed",19,0.62375000000000003,0.9711428571428572]
[null,"4_A1->T1->A2","A1","T1",109,{"$f":"IF(E33=0,\"\",IF(E33<24,\"Sun\",IF(E33<48,\"Mon\",IF(E33<72,\"Tue\",IF(E33<96,\"Wed\",IF(E33<120,\"Thur\",IF(E33<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(F33=\"\",\"\",(E33-ROUNDDOWN(E33/24,0)*24))","v":13},127,{"$f":"IF(H33=0,\"\",IF(H33<24,\"Sun\",IF(H33<48,\"Mon\",IF(H33<72,\"Tue\",IF(H33<96,\"Wed\",IF(H33<120,\"Thur\",IF(H33<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(I33=\"\",\"\",(H33-ROUNDDOWN(H33/24,0)*24))","v":7},0.24625,0.69085714285714284,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"4_A1->T1->A2","T1","A2",138,"Fri",18,156,"Sat",12,0.46500000000000002,0.93,null,"11_A1->T1->Z1->A2","A1","T1",86.625,{"$f":"IF(Q34=0,\"\",IF(Q34<24,\"Sun\",IF(Q34<48,\"Mon\",IF(Q34<72,\"Tue\",IF(Q34<96,\"Wed\",IF(Q34<120,\"Thur\",IF(Q34<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(R34=\"\",\"\",(Q34-ROUNDDOWN(Q34/24,0)*24))","v":14.625},104.625,{"$f":"IF(T34=0,\"\",IF(T34<24,\"Sun\",IF(T34<48,\"Mon\",IF(T34<72,\"Tue\",IF(T34<96,\"Wed\",IF(T34<120,\"Thur\",IF(T34<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(U34=\"\",\"\",(T34-ROUNDDOWN(T34/24,0)*24))","v":8.625},0.7,0.99385714285714288,null,"Scenario 4"]
[null,"18_A1->Z1->T1->A2","A1","Z1",14,"Sun",14,29,"Mon",5,0.17499999999999999,0.36228571428571427,null,"11_A1->T1->Z1->A2","T1","Z1",121.25,"Fri",1.25,147.25,"Sat",3.25,0.45,0.70474285714285712,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"18_A1->Z1->T1->A2","T1","A2",81.3125,"Wed",9.3125,99.3125,"Thur",3.3125,0.36,0.72,null,"11_A1->T1->Z1->A2","Z1","A2",147.9375,"Sat",3.9375,162.9375,"Sat",18.9375,0.40500000000000003,0.69428571428571428,null,"2_A1->T1->A2","A1","T1",13,{"$f":"IF(AC36=0,\"\",IF(AC36<24,\"Sun\",IF(AC36<48,\"Mon\",IF(AC36<72,\"Tue\",IF(AC36<96,\"Wed\",IF(AC36<120,\"Thur\",IF(AC36<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(AD36=\"\",\"\",(AC36-ROUNDDOWN(AC36/24,0)*24))","v":13},31,{"$f":"IF(AF36=0,\"\",IF(AF36<24,\"Sun\",IF(AF36<48,\"Mon\",IF(AF36<72,\"Tue\",IF(AF36<96,\"Wed\",IF(AF36<120,\"Thur\",IF(AF36<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(AG36=\"\",\"\",(AF36-ROUNDDOWN(AF36/24,0)*24))","v":7},0.67500000000000004,0.99514285714285711]
[null,"18_A1->Z1->T1->A2","Z1","T1",33.75,"Mon",9.75,59.75,"Tue",11.75,0.49249999999999999,0.99428571428571433,null,null,null,null,null,null,null,null,null,null,null,null,null,"2_A1->T1->A2","T1","A2",54,"Tue",6,72,"Wed",0,0.63500000000000001,0.99365714285714291]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 5",null,null,null,null,null,null,null,null,null,null,null,"3_A1->T1->A2","A1","T1",85,"Wed",13,103,"Thur",7,0.14499999999999999,0.47142857142857142]
[null,"Scenario 5",null,null,null,null,null,null,null,null,null,null,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"3_A1->T1->A2","T1","A2",113.5625,"Thur",17.5625,131.5625,"Fri",11.5625,0.56999999999999995,0.97714285714285709]
[null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization",null,"13_A1->T1->Z1->T2->Z2->A2","A1","T1",13,{"$f":"IF(Q40=0,\"\",IF(Q40<24,\"Sun\",IF(Q40<48,\"Mon\",IF(Q40<72,\"Tue\",IF(Q40<96,\"Wed\",IF(Q40<120,\"Thur\",IF(Q40<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(R40=\"\",\"\",(Q40-ROUNDDOWN(Q40/24,0)*24))","v":13},31,{"$f":"IF(T40=0,\"\",IF(T40<24,\"Sun\",IF(T40<48,\"Mon\",IF(T40<72,\"Tue\",IF(T40<96,\"Wed\",IF(T40<120,\"Thur\",IF(T40<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(U40=\"\",\"\",(T40-ROUNDDOWN(T40/24,0)*24))","v":7},0.65500000000000003,0.99399999999999999]
[null,"1_A1->T1->A2","A1","T1",13,{"$f":"IF(E41=0,\"\",IF(E41<24,\"Sun\",IF(E41<48,\"Mon\",IF(E41<72,\"Tue\",IF(E41<96,\"Wed\",IF(E41<120,\"Thur\",IF(E41<144,\"Fri\",\"Sat\")))))))","v":"Sun"},{"$f":"IF(F41=\"\",\"\",(E41-ROUNDDOWN(E41/24,0)*24))","v":13},31,{"$f":"IF(H41=0,\"\",IF(H41<24,\"Sun\",IF(H41<48,\"Mon\",IF(H41<72,\"Tue\",IF(H41<96,\"Wed\",IF(H41<120,\"Thur\",IF(H41<144,\"Fri\",\"Sat\")))))))","v":"Mon"},{"$f":"IF(I41=\"\",\"\",(H41-ROUNDDOWN(H41/24,0)*24))","v":7},0.53,0.96457142857142852,null,"13_A1->T1->Z1->T2->Z2->A2","T1","Z1",40.5,"Mon",16.5,66.5,"Tue",18.5,0,0,null,"Scenario 5"]
[null,"1_A1->T1->A2","T1","A2",44.5,"Mon",20.5,62.5,"Tue",14.5,0.5,1,null,"13_A1->T1->Z1->T2->Z2->A2","T2","Z2",118,"Thur",22,144,"Sat",0,0.62,0.99822857142857147,null,"Buidling block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)","Volume Utilization","Weight Utilization"]
[null,"2_A1->T1->A2","A1","T1",90.0625,"Wed",18.0625,108.0625,"Thur",12.0625,1,0.97085714285714286,null,"13_A1->T1->Z1->T2->Z2->A2","Z1","T2",76.5,"Wed",4.5,102.5,"Thur",6.5,0.57250000000000001,0.99428571428571433,null,"1_A1->T1->A2","A1","T1",70.625,{"$f":"IF(AC43=0,\"\",IF(AC43<24,\"Sun\",IF(AC43<48,\"Mon\",IF(AC43<72,\"Tue\",IF(AC43<96,\"Wed\",IF(AC43<120,\"Thur\",IF(AC43<144,\"Fri\",\"Sat\")))))))","v":"Tue"},{"$f":"IF(AD43=\"\",\"\",(AC43-ROUNDDOWN(AC43/24,0)*24))","v":22.625},88.625,{"$f":"IF(AF43=0,\"\",IF(AF43<24,\"Sun\",IF(AF43<48,\"Mon\",IF(AF43<72,\"Tue\",IF(AF43<96,\"Wed\",IF(AF43<120,\"Thur\",IF(AF43<144,\"Fri\",\"Sat\")))))))","v":"Wed"},{"$f":"IF(AG43=\"\",\"\",(AF43-ROUNDDOWN(AF43/24,0)*24))","v":16.625},0.33250000000000002,0.83142857142857141]
[null,"2_A1->T1->A2","T1","A2",135,"Fri",15,153,"Sat",9,0.80062500000000003,0.99971428571428567,null,"13_A1->T1->Z1->T2->Z2->A2","Z2","A2",144,"Sat",0,159,"Sat",15,0.62,0.99822857142857147,null,"1_A1->T1->A2","T1","A2",109,"Thur",13,127,"Fri",7,0.57999999999999996,0.99428571428571433]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2_A1->T1->A2","A1","T1",13,"Sun",13,31,"Mon",7,0.05,0.14571428571428571]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2_A1->T1->A2","T1","A2",39.3125,"Mon",15.3125,57.3125,"Tue",9.3125,0.57999999999999996,0.99428571428571433]

{"sheet":"Order_WeeklyRoutingScheduling","index":11,"n_rows":49,"n_cols":31,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,27,10,27],[8,28,10,28],[8,29,9,30],[8,5,8,11],[8,12,10,12],[8,13,8,19],[8,20,10,20],[8,22,10,22],[8,23,10,23],[11,1,38,1],[39,1,48,1],[8,24,10,24],[8,25,10,25],[8,26,10,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Leftover demand of Week n-1",null,null,null,null,null,null,"Total leftover","Week n",null,null,null,null,null,null,"Total leftover",null,"TEU Factor","Avg weight (ton)","Handling Cost (E/container)","Outsourcing Cost (E/Container)","Order delay penalty (E/h)","Price own sailing (E/container)","Price of outsourcing (E/container)","Lead time"]
[]
[null,null,"CUSTOMERS","Origin","Destination","Sun","Mon","Tue","Wed","Thur","Fri","Sat",null,"Sun","Mon","Tue","Wed","Thur","Fri","Sat",null,null,null,null,null,null,null,null,null,"Days OR Working days","No."]
[null,"Full containers","Full customer 1","T","A",null,null,null,null,null,null,null,{"$f":"SUM(F12:L12)","v":0},null,120,120,120,120,30,null,{"$f":"SUM(N12:T12)","v":510},null,2,35,50,450,10,300,300,"Days",5]
[null,null,"Full customer 2","A","T",null,null,null,null,null,1,5,6,null,50,24,2,1,5,3,{"$f":"SUM(N13:T13)","v":85},null,1,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 3","A","T",null,null,null,null,null,null,null,0,null,null,null,4,null,null,null,{"$f":"SUM(N14:T14)","v":4},null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 4","Z","T",null,null,null,null,null,6,4,10,null,null,60,null,40,null,null,100,null,1,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 5","A","T",null,null,null,null,null,null,null,0,null,null,null,null,30,null,null,30,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 6","A","Z",null,null,null,null,null,null,null,0,null,24,null,null,null,null,null,24,null,1,35,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 7","A","T",null,null,null,null,null,null,null,0,null,null,1,null,null,1,null,2,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 8","A","T",null,null,null,null,null,null,null,0,null,null,null,13,null,1,null,14,null,1,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 9","A","T",null,null,null,null,null,null,null,0,null,null,null,33,null,6,null,39,null,2,28,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 10","A","T",null,null,null,null,null,null,null,0,null,null,15,null,null,null,null,15,null,1,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 11","A","T",null,null,null,null,null,null,null,0,null,null,null,30,null,null,null,30,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 12","Z","T",null,null,null,null,null,null,null,0,null,null,null,null,2,null,null,2,null,1,20,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 13","A","T",null,null,null,null,null,null,null,0,null,null,null,null,null,1,null,1,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 14","A","T",null,null,null,null,null,null,null,0,null,null,null,null,1,null,null,1,null,1,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 15","A","Z",null,null,null,null,null,null,null,0,null,27,null,null,null,null,null,27,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 16","A","T",null,null,null,null,null,null,null,0,null,null,null,5,null,null,null,5,null,1,25,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 17","A","Z",null,null,null,null,null,null,null,0,null,null,null,null,7,null,null,7,null,2,30,60,450,10,150,150,"Working days",3]
[null,null,"Full customer 18","Z","T",null,null,null,null,null,null,null,0,null,null,2,null,null,12,null,14,null,1,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 19","Z","T",null,null,null,null,null,null,null,0,null,null,null,30,null,null,null,30,null,2,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 20","Z","T",null,null,null,null,null,null,null,0,null,null,null,null,4,null,null,4,null,1,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 21","Z","T",null,null,null,null,null,null,null,0,null,null,null,null,null,null,1,1,null,2,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 22","Z","T",null,null,null,null,null,null,null,0,null,3,null,null,null,null,null,3,null,1,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 23","Z","T",null,null,null,null,null,null,null,0,null,null,5,null,null,null,null,5,null,2,30,80,450,10,180,180,"Working days",3]
[null,null,"Full customer 24","A","T",null,null,null,null,null,null,null,0,null,4,null,null,null,null,null,4,null,2.25,30,60,450,10,300,300,"Days",1]
[null,null,"Full customer 25","A","T",null,null,null,null,null,2,1,3,null,null,null,2,1,null,2,5,null,2.25,30,60,450,10,300,300,"Working days",3]
[null,null,"Full customer 26","Z","T",null,null,null,null,null,null,null,0,null,null,5,6,null,null,null,11,null,2.25,30,80,450,10,300,300,"Working days",3]
[null,null,"Full customer 27","Z","T",null,null,null,null,null,null,null,0,null,null,null,null,14,null,null,14,null,2,30,35,450,10,160,160,"Working days",3]
[null,null,"Full customer 28","Z","A",null,null,null,null,null,null,null,0,null,null,null,null,null,20,null,20,null,1,30,51,450,10,120,120,"Working days",3]
[null,"Empty containers","Empty customer 1","A","T",null,null,null,null,null,40,null,40,0,37,36,4,39,31,0,147,null,2,6,50,450,10,300,300,"Days",5]
[null,null,"Empty customer 2","T","A",null,null,null,null,null,null,2,2,0,0,0,1,0,1,2,4,null,1,4,60,450,10,150,150,"Working days",5]
[null,null,"Empty customer 3","T","A",null,null,null,null,null,null,null,0,0,0,38,0,0,0,0,38,null,2,3,60,450,10,150,150,"Working days",5]
[null,null,"Empty customer 4","T","Z",null,null,null,null,null,null,null,0,0,0,0,40,0,0,0,40,null,1,4,80,450,10,150,150,"Working days",5]
[null,null,"Empty customer 5","T","Z",null,null,null,null,null,null,null,0,0,0,0,0,23,0,0,23,null,2,4,80,450,10,150,150,"Working days",5]
[null,null,"Empty customer 6","T","A",null,null,null,null,null,null,null,0,0,0,0,13,0,0,0,13,null,2.25,2,60,450,10,300,300,"Days",4]
[null,null,"Empty customer 7","T","A",null,null,null,null,null,null,1,1,0,0,0,1,1,2,1,5,null,2.25,4,60,450,10,300,300,"Working days",5]
[null,null,"Empty customer 8","T","Z",null,null,null,null,null,null,null,0,0,0,0,1,3,0,0,4,null,2.25,4.5,80,450,10,280,280,"Working days",5]
[null,null,"Empty customer 9","T","Z",null,null,null,null,null,null,null,0,0,0,4,0,2,0,0,6,null,2,4,35,450,10,160,160,"Working days",5]
[null,null,"Empty customer 10","A","Z",null,null,null,null,null,null,null,0,0,1,0,1,0,0,0,2,null,1,4,51,450,10,120,120,"Working days",5]

{"sheet":"Input_WeeklyRoutingScheduling","index":12,"n_rows":225,"n_cols":27,"rows_kept":225,"cut":false,"hidden":false,"merged":[[189,1,190,3],[189,5,189,26],[190,5,190,15],[190,16,190,26],[79,1,80,3],[79,5,79,26],[80,5,80,15],[80,16,80,26],[134,1,135,3],[134,5,134,26],[135,5,135,15],[135,16,135,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Inputs for Routing"]
[]
[null,"Total vessel operation time (h/week)",160,null,"Available vessel",null,null,null,null,null,null,null,null,null,"Building blocks for routing","Cost (fuel cost + port fee) (€)","Sailing time (h)"]
[null,"Average terminal handling speed (container/h)",16,null,"Vessel_1",1,null,null,null,null,null,null,null,null,"1_A1->T1->A2",10000,36]
[null,null,null,null,"Vessel_2",1,null,null,null,null,null,null,null,null,"2_A1->T1->A2",10000,36]
[null,"Vessel Rent (€/week)",40000,null,"Vessel_3",1,null,null,null,null,null,null,null,null,"3_A1->T1->A2",10000,36]
[null,"Discount rate on vessel rent from 2nd vessel",0.05,null,null,null,null,null,null,null,null,null,null,null,"4_A1->T1->A2",10000,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_A1->Z1->A2",9000,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6_A1->Z1->A2",9000,30]
[null,"Vessel volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"7_A1->Z1->A2",9000,30]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400,null,"8_A1->Z1->A2",9000,30]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400,null,"9_A1->T1->Z1->A2",11000,59]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400,null,"10_A1->T1->Z1->A2",11000,59]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400,null,"11_A1->T1->Z1->A2",11000,59]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400,null,"12_A1->T1->Z1->T2->Z2->A2",16000,111]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400,null,"13_A1->T1->Z1->T2->Z2->A2",16000,111]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0,null,"14_A1->T1->Z1->T2->Z2->T3->Z3->A2",23000,163]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0,null,"15_A1->T1->Z1->T2->Z2->T3->Z3->T4->Z4->A2",28000,215]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0,null,"16_A1->Z1->T1->A2",11000,59]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0,null,"17_A1->Z1->T1->A2",11000,59]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0,null,"18_A1->Z1->T1->A2",11000,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19_A1->Z1->T1->Z2->T2->A2",16000,111]
[null,"Weight capacity due to the draft (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5",null,"20_A1->Z1->T1->Z2->T2->A2",16000,111]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"21_A1->Z1->T1->Z2->T2->Z3->T3->A2",24000,163]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500,null,"22_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->A2",28000,215]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"23_A1->T1->Z1->T2->A2",15000,88]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"24_A1->T1->Z1->T2->A2",15000,88]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"25_A1->T1->Z1->T2->Z2->T3->A2",21000,140]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500,null,"26_A1->T1->Z1->T2->Z2->T3->Z3->T4->A2",28000,192]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"27_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"28_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"29_A1->Z1->T1->Z2->A2",13000,82]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"30_A1->Z1->T1->Z2->T2->Z3->A2",18000,134]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0,null,"31_A1->Z1->T1->Z2->T2->Z3->A2",18000,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32_A1->Z1->T1->Z2->T2->Z3->T3->Z4->A2",25000,186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33_A1->Z1->T1->Z2->T2->Z3->T3->Z4->T4->Z5->A2",32000,238]
[]
[null,"Terminals","Unit extra labor cost during weekends (Euro/h)","Average loading time at each terminal (h)","Average unloading time at each terminal (h)","Service early departure penalty (Euro/h)","Service late departure penalty (Euro/h)","Service early arrival penalty (Euro/h)","Service late arrival penalty (Euro/h)"]
[null,"A1",30,4,4,150,150,150,150]
[null,"A2",30,4,4,150,150,150,150]
[null,"T1",20,4,4,200,200,200,200]
[null,"T2",20,4,4,200,200,200,200]
[null,"T3",20,4,4,200,200,200,200]
[null,"T4",20,4,4,200,200,200,200]
[null,"Z1",15,4,4,100,100,100,100]
[null,"Z2",15,4,4,100,100,100,100]
[null,"Z3",15,4,4,100,100,100,100]
[null,"Z4",15,4,4,100,100,100,100]
[null,"Z5",15,4,4,100,100,100,100]
[]
[]
[]
[null,"Input for Scheduling"]
[null,"Vessel 1"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Port stay time slot",null,null,null,"Preferred port stay at each terminal "]
[null,null,null,null,null,"Begin port stay",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[]
[]
[null,"Vessel 2"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Port stay time slot",null,null,null,"Preferred port stay at each terminal "]
[null,null,null,null,null,"Begin port stay",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[]
[]
[null,"Vessel 3"]
[null,"Total vessel operation time (h)",168]
[null,"Terminal handling speed (container/h)",16]
[]
[null,"Sailing Time (h)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,18,18,18,18,15,15,15,15,15]
[null,"A2",0,0,18,18,18,18,15,15,15,15,15]
[null,"T1",18,18,0,0,0,0,26,26,26,26,26]
[null,"T2",18,18,0,0,0,0,26,26,26,26,26]
[null,"T3",18,18,0,0,0,0,26,26,26,26,26]
[null,"T4",18,18,0,0,0,0,26,26,26,26,26]
[null,"Z1",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z2",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z3",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z4",15,15,26,26,26,26,0,0,0,0,0]
[null,"Z5",15,15,26,26,26,26,0,0,0,0,0]
[]
[null,"Port stay time slot",null,null,null,"Preferred port stay at each terminal "]
[null,null,null,null,null,"Begin port stay",null,null,null,null,null,null,null,null,null,null,"End port stay"]
[null,null,"Begin slot time","End slot time",null,"A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"Slot 1",0,24,null,9,9,8,8,8,8,9,9,9,9,9,14,14,13,13,13,13,14,14,14,14,14]
[null,"Slot 2",24,48,null,31,31,31,30,30,30,31,31,31,31,31,43,43,42,42,42,42,43,43,43,43,43]
[null,"Slot 3",48,72,null,55,55,55,54,54,54,55,55,55,55,55,67,67,66,66,66,66,67,67,67,67,67]
[null,"Slot 4",72,96,null,79,79,79,78,78,78,79,79,79,79,79,91,91,90,90,90,90,91,91,91,91,91]
[null,"Slot 5",96,120,null,103,103,103,102,102,102,103,103,103,103,103,115,115,114,114,114,114,115,115,115,115,115]
[null,"Slot 6",120,144,null,127,127,127,126,126,126,127,127,127,127,127,139,139,138,138,138,138,139,139,139,139,139]
[null,"Slot 7",144,168,null,153,153,153,152,152,152,153,153,153,153,153,158,158,157,157,157,157,158,158,158,158,158]
[]
[null,"Volume capacity (TEUs)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,400,400,400,400,400,400,400,400,400]
[null,"A2",0,0,400,400,400,400,400,400,400,400,400]
[null,"T1",400,400,0,0,0,0,400,400,400,400,400]
[null,"T2",400,400,0,0,0,0,400,400,400,400,400]
[null,"T3",400,400,0,0,0,0,400,400,400,400,400]
[null,"T4",400,400,0,0,0,0,400,400,400,400,400]
[null,"Z1",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z2",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z3",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z4",400,400,400,400,400,400,0,0,0,0,0]
[null,"Z5",400,400,400,400,400,400,0,0,0,0,0]
[]
[null,"Weight capacity (ton)","A1","A2","T1","T2","T3","T4","Z1","Z2","Z3","Z4","Z5"]
[null,"A1",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"A2",0,0,3500,3500,3500,3500,3500,3500,3500,3500,3500]
[null,"T1",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T2",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T3",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"T4",3500,3500,0,0,0,0,3500,3500,3500,3500,3500]
[null,"Z1",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z2",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z3",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z4",3500,3500,3500,3500,3500,3500,0,0,0,0,0]
[null,"Z5",3500,3500,3500,3500,3500,3500,0,0,0,0,0]

{"sheet":"Output_WeeklyRoutingScheduling","index":13,"n_rows":61,"n_cols":33,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null," "]
[]
[]
[]
[null,"Schedule of Vessel 1",null,null,null,null,null,null,null,null,null,null,"Schedule of Vessel 2",null,null,null,null,null,null,null,null,null,null,"Schedule of Vessel 3"]
[null,"Buiding block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)",null,null,"Buiding block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)",null,null,"Building block","O","D","Estimate time departure (ETD)","ETD (DAY)","ETD (HOUR)","Estimated time arrival (ETA)","ETA (DAY)","ETA (HOUR)"]
[null,"1_A1->T1->A2","A1","T1",109.81,{"$f":"IF(E13=0,\"\",IF(E13<24,\"Sun\",IF(E13<48,\"Mon\",IF(E13<72,\"Tue\",IF(E13<96,\"Wed\",IF(E13<120,\"Thur\",IF(E13<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(F13=\"\",\"\",(E13-ROUNDDOWN(E13/24,0)*24))","v":13.810000000000002},127.81,{"$f":"IF(H13=0,\"\",IF(H13<24,\"Sun\",IF(H13<48,\"Mon\",IF(H13<72,\"Tue\",IF(H13<96,\"Wed\",IF(H13<120,\"Thur\",IF(H13<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(I13=\"\",\"\",(H13-ROUNDDOWN(H13/24,0)*24))","v":7.8100000000000023},null,null,"3_A1->T1->A2","A1","T1",109.06,{"$f":"IF(P13=0,\"\",IF(P13<24,\"Sun\",IF(P13<48,\"Mon\",IF(P13<72,\"Tue\",IF(P13<96,\"Wed\",IF(P13<120,\"Thur\",IF(P13<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(Q13=\"\",\"\",(P13-ROUNDDOWN(P13/24,0)*24))","v":13.060000000000002},127.06,{"$f":"IF(S13=0,\"\",IF(S13<24,\"Sun\",IF(S13<48,\"Mon\",IF(S13<72,\"Tue\",IF(S13<96,\"Wed\",IF(S13<120,\"Thur\",IF(S13<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(T13=\"\",\"\",(S13-ROUNDDOWN(S13/24,0)*24))","v":7.0600000000000023},null,null,"3_A1->T1->A2","A1","T1",106.63,{"$f":"IF(AA13=0,\"\",IF(AA13<24,\"Sun\",IF(AA13<48,\"Mon\",IF(AA13<72,\"Tue\",IF(AA13<96,\"Wed\",IF(AA13<120,\"Thur\",IF(AA13<144,\"Fri\",\"Sat\")))))))","v":"Thur"},{"$f":"IF(AB13=\"\",\"\",(AA13-ROUNDDOWN(AA13/24,0)*24))","v":10.629999999999995},124.63,{"$f":"IF(AD13=0,\"\",IF(AD13<24,\"Sun\",IF(AD13<48,\"Mon\",IF(AD13<72,\"Tue\",IF(AD13<96,\"Wed\",IF(AD13<120,\"Thur\",IF(AD13<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(AE13=\"\",\"\",(AD13-ROUNDDOWN(AD13/24,0)*24))","v":4.6299999999999955}]
[null,"1_A1->T1->A2","T1","A2",138,{"$f":"IF(E14=0,\"\",IF(E14<24,\"Sun\",IF(E14<48,\"Mon\",IF(E14<72,\"Tue\",IF(E14<96,\"Wed\",IF(E14<120,\"Thur\",IF(E14<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(F14=\"\",\"\",(E14-ROUNDDOWN(E14/24,0)*24))","v":18},156,{"$f":"IF(H14=0,\"\",IF(H14<24,\"Sun\",IF(H14<48,\"Mon\",IF(H14<72,\"Tue\",IF(H14<96,\"Wed\",IF(H14<120,\"Thur\",IF(H14<144,\"Fri\",\"Sat\")))))))","v":"Sat"},{"$f":"IF(I14=\"\",\"\",(H14-ROUNDDOWN(H14/24,0)*24))","v":12},null,null,"3_A1->T1->A2","T1","A2",142.06,{"$f":"IF(P14=0,\"\",IF(P14<24,\"Sun\",IF(P14<48,\"Mon\",IF(P14<72,\"Tue\",IF(P14<96,\"Wed\",IF(P14<120,\"Thur\",IF(P14<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(Q14=\"\",\"\",(P14-ROUNDDOWN(P14/24,0)*24))","v":22.060000000000002},160.06,{"$f":"IF(S14=0,\"\",IF(S14<24,\"Sun\",IF(S14<48,\"Mon\",IF(S14<72,\"Tue\",IF(S14<96,\"Wed\",IF(S14<120,\"Thur\",IF(S14<144,\"Fri\",\"Sat\")))))))","v":"Sat"},{"$f":"IF(T14=\"\",\"\",(S14-ROUNDDOWN(S14/24,0)*24))","v":16.060000000000002},null,null,"3_A1->T1->A2","T1","A2",141.69,{"$f":"IF(AA14=0,\"\",IF(AA14<24,\"Sun\",IF(AA14<48,\"Mon\",IF(AA14<72,\"Tue\",IF(AA14<96,\"Wed\",IF(AA14<120,\"Thur\",IF(AA14<144,\"Fri\",\"Sat\")))))))","v":"Fri"},{"$f":"IF(AB14=\"\",\"\",(AA14-ROUNDDOWN(AA14/24,0)*24))","v":21.689999999999998},159.69,{"$f":"IF(AD14=0,\"\",IF(AD14<24,\"Sun\",IF(AD14<48,\"Mon\",IF(AD14<72,\"Tue\",IF(AD14<96,\"Wed\",IF(AD14<120,\"Thur\",IF(AD14<144,\"Fri\",\"Sat\")))))))","v":"Sat"},{"$f":"IF(AE14=\"\",\"\",(AD14-ROUNDDOWN(AD14/24,0)*24))","v":15.689999999999998}]
[null,"4_A1->T1->A2","A1","T1",37,"Mon",13,55,"Tue",7,null,null,"16_A1->Z1->T1->A2","A1","Z1",31,"Mon",7,46,"Mon",22,null,null,"4_A1->T1->A2","A1","T1",37,"Mon",13,55,"Tue",7]
[null,"4_A1->T1->A2","T1","A2",82.38,"Wed",10.379999999999995,100.38,"Thur",4.3799999999999955,null,null,"16_A1->Z1->T1->A2","T1","A2",82.25,"Wed",10.25,100.25,"Thur",4.25,null,null,"4_A1->T1->A2","T1","A2",68.25,"Tue",20.25,86.25,"Wed",14.25]
[null,null,null,null,null,null,null,null,null,null,null,null,"16_A1->Z1->T1->A2","Z1","T1",53,"Tue",5,79,"Wed",7]
[null,"Container Assignment of Vessel 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Container Assignment of Vessel 1"]
[null,"Customer","Building block","O","D","Container volume","Departure time","Departure day","Arrival time","Arrival day",null,null,"Container Assignment of Vessel 1",null,null,null,null,null,null,null,null,null,null,"Customer","Building block","O","D","Container volume","Departure time","Departure day","Arrival time","Arrival day"]
[null,"Full customer 1_n_Mon._(full)","4_A1->T1->A2","T1","A2",47,82.38,"Wed",100.38,"Thur",null,null,"Customer","Buiding block","O","D","Container volume","Departure time","Departure day","Arrival time","Arrival day",null,null,"Full customer 1_n_Mon._(full)","4_A1->T1->A2","T1","A2",47,68.25,"Tue",86.25,"Wed"]
[null,"Full customer 1_n_Tue._(full)","1_A1->T1->A2","T1","A2",41,138,"Fri",156,"Sat",null,null,"Full customer 1_n_Mon._(full)","16_A1->Z1->T1->A2","T1","A2",26,82.25,"Wed",100.25,"Thur",null,null,"Full customer 1_n_Tue._(full)","4_A1->T1->A2","T1","A2",47,68.25,"Tue",86.25,"Wed"]
[null,"Full customer 1_n_Tue._(full)","4_A1->T1->A2","T1","A2",6,82.38,"Wed",100.38,"Thur",null,null,"Full customer 1_n_Tue._(full)","3_A1->T1->A2","T1","A2",26,142.06,"Fri",160.06,"Sat",null,null,"Full customer 1_n_Wed._(full)","3_A1->T1->A2","T1","A2",47,141.69,"Fri",159.69,"Sat"]
[null,"Full customer 1_n_Wed._(full)","4_A1->T1->A2","T1","A2",47,82.38,"Wed",100.38,"Thur",null,null,"Full customer 1_n_Wed._(full)","3_A1->T1->A2","T1","A2",26,142.06,"Fri",160.06,"Sat",null,null,"Full customer 1_n_Thur._(full)","3_A1->T1->A2","T1","A2",47,141.69,"Fri",159.69,"Sat"]
[null,"Full customer 1_n_Thur._(full)","1_A1->T1->A2","T1","A2",46,138,"Fri",156,"Sat",null,null,"Full customer 1_n_Thur._(full)","3_A1->T1->A2","T1","A2",26,142.06,"Fri",160.06,"Sat",null,null,"Full customer 1_n_Fri._(full)","3_A1->T1->A2","T1","A2",5,141.69,"Fri",159.69,"Sat"]
[null,"Full customer 1_n_Fri._(full)","1_A1->T1->A2","T1","A2",12,138,"Fri",156,"Sat",null,null,"Full customer 1_n_Fri._(full)","3_A1->T1->A2","T1","A2",7,142.06,"Fri",160.06,"Sat",null,null,"Full customer 5_n_Thur._(full)","3_A1->T1->A2","A1","T1",30,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 2_n-1_Fri._(full)","4_A1->T1->A2","A1","T1",1,37,"Mon",55,"Tue",null,null,"Full customer 3_n_Wed._(full)","3_A1->T1->A2","A1","T1",4,109.06,"Thur",127.06,"Fri",null,null,"Full customer 6_n_Mon._(full)","4_A1->T1->A2","A1","T1",24,37,"Mon",55,"Tue"]
[null,"Full customer 2_n-1_Sat._(full)","4_A1->T1->A2","A1","T1",5,37,"Mon",55,"Tue",null,null,"Full customer 4_n-1_Fri._(full)","16_A1->Z1->T1->A2","A1","T1",6,31,"Mon",79,"Wed",null,null,"Full customer 8_n_Wed._(full)","3_A1->T1->A2","A1","T1",13,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 2_n_Mon._(full)","4_A1->T1->A2","A1","T1",50,37,"Mon",55,"Tue",null,null,"Full customer 4_n-1_Sat._(full)","16_A1->Z1->T1->A2","A1","T1",4,31,"Mon",79,"Wed",null,null,"Full customer 9_n_Wed._(full)","3_A1->T1->A2","A1","T1",33,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 2_n_Tue._(full)","1_A1->T1->A2","A1","T1",24,109.81,"Thur",127.81,"Fri",null,null,"Full customer 4_n_Tue._(full)","3_A1->T1->A2","A1","T1",60,109.06,"Thur",127.06,"Fri",null,null,"Full customer 11_n_Wed._(full)","3_A1->T1->A2","A1","T1",19,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 2_n_Wed._(full)","1_A1->T1->A2","A1","T1",2,109.81,"Thur",127.81,"Fri",null,null,"Full customer 4_n_Thur._(full)","3_A1->T1->A2","A1","T1",40,109.06,"Thur",127.06,"Fri",null,null,"Full customer 15_n_Mon._(full)","4_A1->T1->A2","A1","T1",27,37,"Mon",55,"Tue"]
[null,"Full customer 2_n_Thur._(full)","1_A1->T1->A2","A1","T1",1,109.81,"Thur",127.81,"Fri",null,null,"Full customer 11_n_Wed._(full)","3_A1->T1->A2","A1","T1",10,109.06,"Thur",127.06,"Fri",null,null,"Full customer 16_n_Wed._(full)","3_A1->T1->A2","A1","T1",1,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 7_n_Tue._(full)","1_A1->T1->A2","A1","T1",1,109.81,"Thur",127.81,"Fri",null,null,"Full customer 18_n_Tue._(full)","16_A1->Z1->T1->A2","Z1","T1",2,53,"Tue",79,"Wed",null,null,"Full customer 17_n_Thur._(full)","3_A1->T1->A2","A1","T1",7,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 11_n_Wed._(full)","1_A1->T1->A2","A1","T1",1,109.81,"Thur",127.81,"Fri",null,null,"Full customer 22_n_Mon._(full)","16_A1->Z1->T1->A2","Z1","T1",3,53,"Tue",79,"Wed",null,null,"Full customer 25_n-1_Fri._(full)","4_A1->T1->A2","A1","T1",2,37,"Mon",55,"Tue"]
[null,"Full customer 12_n_Thur._(full)","1_A1->T1->A2","A1","T1",2,109.81,"Thur",127.81,"Fri",null,null,"Full customer 23_n_Tue._(full)","16_A1->Z1->T1->A2","Z1","T1",5,53,"Tue",79,"Wed",null,null,"Full customer 25_n-1_Sat._(full)","4_A1->T1->A2","A1","T1",1,37,"Mon",55,"Tue"]
[null,"Full customer 14_n_Thur._(full)","1_A1->T1->A2","A1","T1",1,109.81,"Thur",127.81,"Fri",null,null,"Full customer 26_n_Tue._(full)","16_A1->Z1->T1->A2","Z1","T1",5,53,"Tue",79,"Wed",null,null,"Full customer 25_n_Wed._(full)","3_A1->T1->A2","A1","T1",2,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 16_n_Wed._(full)","1_A1->T1->A2","A1","T1",4,109.81,"Thur",127.81,"Fri",null,null,"Empty customer 2_n-1_Sat._(empty)","3_A1->T1->A2","T1","A2",1,142.06,"Fri",160.06,"Sat",null,null,"Full customer 25_n_Thur._(full)","3_A1->T1->A2","A1","T1",1,106.63,"Thur",124.63,"Fri"]
[null,"Full customer 24_n_Mon._(full)","4_A1->T1->A2","A1","T1",4,37,"Mon",55,"Tue",null,null,"Empty customer 2_n-1_Sat._(empty)","16_A1->Z1->T1->A2","T1","A2",1,82.25,"Wed",100.25,"Thur",null,null,"Empty customer 1_n-1_Fri._(empty)","4_A1->T1->A2","A1","T1",33,37,"Mon",55,"Tue"]
[null,"Empty customer 1_n-1_Fri._(empty)","4_A1->T1->A2","A1","T1",7,37,"Mon",55,"Tue",null,null,"Empty customer 2_n_Wed._(empty)","3_A1->T1->A2","T1","A2",1,142.06,"Fri",160.06,"Sat",null,null,"Empty customer 1_n_Mon._(empty)","4_A1->T1->A2","A1","T1",30,37,"Mon",55,"Tue"]
[null,"Empty customer 1_n_Mon._(empty)","4_A1->T1->A2","A1","T1",7,37,"Mon",55,"Tue",null,null,"Empty customer 2_n_Fri._(empty)","3_A1->T1->A2","T1","A2",1,142.06,"Fri",160.06,"Sat",null,null,"Empty customer 1_n_Tue._(empty)","3_A1->T1->A2","A1","T1",29,106.63,"Thur",124.63,"Fri"]
[null,"Empty customer 1_n_Tue._(empty)","1_A1->T1->A2","A1","T1",7,109.81,"Thur",127.81,"Fri",null,null,"Empty customer 3_n_Tue._(empty)","3_A1->T1->A2","T1","A2",38,142.06,"Fri",160.06,"Sat",null,null,"Empty customer 1_n_Wed._(empty)","3_A1->T1->A2","A1","T1",3,106.63,"Thur",124.63,"Fri"]
[null,"Empty customer 1_n_Wed._(empty)","1_A1->T1->A2","A1","T1",1,109.81,"Thur",127.81,"Fri",null,null,"Empty customer 10_n_Mon._(empty)","16_A1->Z1->T1->A2","A1","Z1",1,31,"Mon",46,"Mon",null,null,"Empty customer 1_n_Thur._(empty)","3_A1->T1->A2","A1","T1",32,106.63,"Thur",124.63,"Fri"]
[null,"Empty customer 1_n_Thur._(empty)","1_A1->T1->A2","A1","T1",7,109.81,"Thur",127.81,"Fri",null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 7_n-1_Sat._(empty)","4_A1->T1->A2","T1","A2",1,68.25,"Tue",86.25,"Wed"]
[null,"Empty customer 6_n_Wed._(empty)","1_A1->T1->A2","T1","A2",13,138,"Fri",156,"Sat",null,null,"Customer","Building block 1","Successive building block","Container volume","O","D","Departure time","Departure day","Arrival time","Arrival day",null,"Empty customer 7_n_Wed._(empty)","3_A1->T1->A2","T1","A2",1,141.69,"Fri",159.69,"Sat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 7_n_Thur._(empty)","3_A1->T1->A2","T1","A2",1,141.69,"Fri",159.69,"Sat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 7_n_Fri._(empty)","3_A1->T1->A2","T1","A2",2,141.69,"Fri",159.69,"Sat"]
[null,"Customer","Building block 1","Successive building block","Container volume","O","D","Departure time","Departure day","Arrival time","Arrival day",null,"Customer","Volume of outsoucing"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 18_n_Fri._(full)",12,null,null,null,null,null,null,null,null,null,"Customer","Building block 1","Successive building block","Container volume","O","D","Departure time","Departure day","Arrival time","Arrival day"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 19_n_Wed._(full)",30]
[null,null,null,null,null,null,null,null,null,null,null,null,"Full customer 20_n_Thur._(full)",4]
[null,"Customer","Volume of outsoucing",null,null,null,null,null,null,null,null,null,"Full customer 21_n_Sat._(full)",1,null,null,null,null,null,null,null,null,null,"Customer","Volume of outsoucing"]
[null,"Full customer 1_n_Thur._(full)",1,null,null,null,null,null,null,null,null,null,"Full customer 26_n_Wed._(full)",6,null,null,null,null,null,null,null,null,null,"Full customer 1_n_Fri._(full)",6]
[null,"Full customer 2_n_Fri._(full)",5,null,null,null,null,null,null,null,null,null,"Full customer 27_n_Thur._(full)",14,null,null,null,null,null,null,null,null,null,"Full customer 8_n_Fri._(full)",1]
[null,"Full customer 2_n_Sat._(full)",3,null,null,null,null,null,null,null,null,null,"Full customer 28_n_Fri._(full)",20,null,null,null,null,null,null,null,null,null,"Full customer 9_n_Fri._(full)",6]
[null,"Full customer 7_n_Fri._(full)",1,null,null,null,null,null,null,null,null,null,"Empty customer 2_n_Sat._(empty)",2,null,null,null,null,null,null,null,null,null,"Full customer 10_n_Tue._(full)",15]
[null,"Empty customer 1_n_Fri._(empty)",6,null,null,null,null,null,null,null,null,null,"Empty customer 4_n_Wed._(empty)",40,null,null,null,null,null,null,null,null,null,"Full customer 13_n_Fri._(full)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 5_n_Thur._(empty)",23,null,null,null,null,null,null,null,null,null,"Full customer 25_n_Sat._(full)",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 8_n_Wed._(empty)",1,null,null,null,null,null,null,null,null,null,"Empty customer 1_n_Fri._(empty)",25]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 8_n_Thur._(empty)",3,null,null,null,null,null,null,null,null,null,"Empty customer 7_n_Sat._(empty)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 9_n_Tue._(empty)",4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 9_n_Thur._(empty)",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empty customer 10_n_Wed._(empty)",1]