{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Shipment Details","Criteria for Auto Approval","Form Information & Definitions","Data"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":1,"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":"Shipment Details","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[30,2,30,3],[2,5,4,7],[5,5,6,7],[7,5,8,7],[9,5,11,7],[12,5,16,7],[32,0,32,1],[39,0,39,1],[40,0,40,1],[0,0,0,8],[27,0,27,1],[28,0,28,1],[37,0,37,1],[38,0,38,1],[37,2,46,7],[2,0,2,1],[13,0,13,1],[17,0,17,1],[18,0,18,1],[21,0,21,1],[22,0,22,1],[30,0,30,1]]}
["In Gauge (IG) Cargo Request Form"]
[]
["Routing",null,"Origin",null,"-","Blue shaded boxes require information and Gray shaded boxes will auto populate."]
[null,null,"Port of Loading","select"]
[null,null,"Port of Discharge"]
[null,null,"Destination",null,"-","Measurements must be in Meters and Kilograms."]
[]
[null,null,"Intended Vessel",null,"*","Not including any holidays, subtract a day for each holiday."]
[null,null,"Voyage"]
[null,null,"Cutoff","mm/dd/yy","**","If multiple pieces of cargo the overall or greatest for each measurement should be provided"]
[null,null,"Todays Date",{"$f":"TODAY()","v":"2021-01-15"}]
[null,null,"Working Days Prior to Arrival *",{"$f":"NETWORKDAYS(D11,D10)-1","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"***","Assumption is the cargo will be centered so that any overhang is equal both ends and/or sides  if not equal please overtype the auto generated measurements. "]
["Equipment",null,"Type","select"]
[null,null,"Quantity","select"]
[null,null,"Flat Rack Ends UP","select"]
[]
["Cargo",null,"Length",null,"Meters",{"$f":"D18/0.01","v":0},"Centimeters"]
["Dimensions **",null,"Width",null,"Meters",{"$f":"D19/0.01","v":0},"Centimeters"]
[null,null,"Height",null,"Meters",0,"Centimeters"]
[]
["Over",null,"Over Front",{"$f":"IF((D18-Data!H9)>0,(D18-Data!H9)/2,\"0.00\")","v":{"$error":"#N/A"}},"Meters",{"$f":"IF(D22>0,(D22/0.01),\"\")","v":{"$error":"#N/A"}},"Centimeters"]
["Dimensions ***",null,"Over Rear",{"$f":"IF((D18-Data!H9)>0,(D18-Data!H9)/2,\"0.00\")","v":{"$error":"#N/A"}},"Meters",{"$f":"D23/0.01","v":{"$error":"#N/A"}},"Centimeters"]
[null,null,"Over Left",{"$f":"IF((D19-Data!I9)>0,(D19-Data!I9)/2,\"0.00\")","v":{"$error":"#N/A"}},"Meters",{"$error":"#N/A"},"Centimeters"]
[null,null,"Over Right",{"$f":"IF((D19-Data!I9)>0,(D19-Data!I9)/2,\"0.00\")","v":{"$error":"#N/A"}},"Meters",{"$error":"#N/A"},"Centimeters"]
[null,null,"Over Height",{"$f":"IF((D20-Data!J9)>0,(D20-Data!J9),\"0.00\")","v":{"$error":"#N/A"}},"Meters",{"$error":"#N/A"},"Centimeters"]
[]
["Weight",null,"Cargo",0,"Kilograms",{"$f":"D28*0.001","v":0},"Metric Tons"]
[null,null,"Gross",0,"Kilograms",{"$f":"D29*0.001","v":0},"Metric Tons"]
[]
["Survey",null,{"$f":"Data!H20","v":{"$error":"#N/A"}},null,"FR/FQ/SR require surveys, OT/OQ do not"]
[]
["conversion calculator"]
[null,0,"Feet and ",0,"Inches equals",null,{"$f":"(B34*0.3048)+((D34/12)*0.3048)","v":0},"Meters"]
[]
[null,0,"Pounds equals",null,{"$f":"B36*0.453592","v":0},"Kilograms"]
[]
["Special"]
["Requirements"]
["and"]
["notes"]

{"sheet":"Criteria for Auto Approval","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,7],[7,5,10,6],[13,5,18,6],[13,1,13,3]]}
["Criteria for Auto Approval"]
[]
[null,"OA (Ocean Alliance) Auto Approval Criteria for OOG shipments"]
[null,"Requirements to be met for AA","Shipment details","Auto Approval Status"]
[null,"At least 5 working days prior to vessel arrival",{"$f":"'Shipment Details'!D12","v":{"$error":"#VALUE!"}},{"$f":"IF(C5>=5,\"OK\", \"---\")","v":{"$error":"#VALUE!"}},null,"Container Type",{"$f":"IF('Shipment Details'!D14=\"Select\",\"---\",'Shipment Details'!D14)","v":"---"}]
[null,"Both Ends of FR Up ",{"$f":"IF('Shipment Details'!D16=\"select\",\"---\",'Shipment Details'!D16)","v":"---"},{"$f":"IF(C6=\"YES\",\"OK\", \"---\")","v":"---"},null,"Port of Loading",{"$f":"IF('Shipment Details'!D4=\"Select\",\"---\",'Shipment Details'!D4)","v":"---"}]
[null,"Max Payload of 38,000 KG",{"$f":"IF('Shipment Details'!D28=0,\"---\",'Shipment Details'!D28)","v":"---"},{"$f":"IF(AND(C7<=38000,C7>0),\"OK\", \"---\")","v":"---"}]
[null,"Max Overwidth 1.2 M per side",{"$f":"'Shipment Details'!D24","v":{"$error":"#N/A"}},{"$f":"IF(C8-1.2<=0,\"OK\", \"---\")","v":{"$error":"#N/A"}},null,"Note: If the ALL the approval statuses are \"Green/OK\" for the appropriate size, type and port the shipment falls under Auto Approval for the vessel operator. Space, Equipment and Port approvals are still require validation."]
[null,{"$f":"IF('Shipment Details'!D14=\"20FR\",\"Max Length of 5.2 M for 20FR *\",\"* Max Length of 5.2 M for 20FR\")","v":"* Max Length of 5.2 M for 20FR"},{"$f":"IF('Shipment Details'!D18=0,\"---\",'Shipment Details'!D18)","v":"---"},{"$f":"IF(AND(C9<=5.2,C9>0),\"OK for 20FR\", \"---\")","v":"---"}]
[null,"* Max Length of 11.2 M for 40FR",{"$f":"IF('Shipment Details'!D18=0,\"---\",'Shipment Details'!D18)","v":"---"},{"$f":"IF(AND(C10<=11.2,C10>0),\"OK for 40FR / 40FQ / 40SR\", \"---\")","v":"---"}]
[null,"Max Overheight of 1.7 M",{"$f":"'Shipment Details'!D26","v":{"$error":"#N/A"}},{"$f":"IF(C11-1.7<=0,\"OK\", \"---\")","v":{"$error":"#N/A"}}]
[null,"Survey Required for all Flat Racks",{"$f":"IF('Shipment Details'!C31=\"select\",\"---\",'Shipment Details'!C31)","v":{"$error":"#N/A"}},{"$f":"IF(C12=\"Survey Needed\",\"Survey Required\", \" No Survey for OT/OQ\")","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF('Shipment Details'!D4=\"Vancouver\",\"Centerm Vancouver/OA Combined Criteria\",\"Centerm Vancouver / OA Combined Criteria\")","v":"Centerm Vancouver / OA Combined Criteria"},null,null,null,"* For OOG which is overwidth or both overheight and overwidth, maximum length 11.2 meters on 40' FR & maximum length 5.2 meters on 20' FR including lashing materials, positioning of the cargo shall be evenly centered in the FR and both ends up. "]
[null,"Requirements to be met for AA","Shipment details","Auto Approval Status"]
[null,"At least 5 working days prior to vessel arrival",{"$f":"'Shipment Details'!D12","v":{"$error":"#VALUE!"}},{"$f":"IF(C16>=5,\"OK\", \"---\")","v":{"$error":"#VALUE!"}}]
[null,"Both Ends of FR Up ",{"$f":"IF('Shipment Details'!D16=\"select\",\"---\",'Shipment Details'!D16)","v":"---"},{"$f":"IF(C17=\"YES\",\"OK\", \"---\")","v":"---"}]
[null,"Max Payload of 37,000 KG",{"$f":"IF('Shipment Details'!D28=0,\"---\",'Shipment Details'!D28)","v":"---"},{"$f":"IF(AND(C18<=37000,C18>0),\"OK for VAN\", \"---\")","v":"---"}]
[null,"Max Overwidth 0.55 M per side",{"$f":"'Shipment Details'!D24","v":{"$error":"#N/A"}},{"$f":"IF(C19-0.55<=0,\"OK\", \"---\")","v":{"$error":"#N/A"}}]
[null,{"$f":"IF('Shipment Details'!D14=\"20FR\",\"Max Length of 5.2 M for 20FR *\",\"* Max Length of 5.2 M for 20FR\")","v":"* Max Length of 5.2 M for 20FR"},{"$f":"IF('Shipment Details'!D18=0,\"---\",'Shipment Details'!D18)","v":"---"},{"$f":"IF(AND(C20<=5.2,C20>0),\"OK for 20FR\", \"---\")","v":"---"}]
[null,"Max Length of 11.2 M for 40FR *",{"$f":"IF('Shipment Details'!D18=0,\"---\",'Shipment Details'!D18)","v":"---"},{"$f":"IF(AND(C10<=11.2,C10>0),\"OK for 40FR / 40FQ / 40SR\", \"---\")","v":"---"}]
[null,"Max Overheight of 1.7 M",{"$f":"'Shipment Details'!D26","v":{"$error":"#N/A"}},{"$f":"IF(C22-1.7<=0,\"OK\", \"---\")","v":{"$error":"#N/A"}}]
[null,"Survey Required for all Flat Racks",{"$f":"IF('Shipment Details'!C31=\"select\",\"---\",'Shipment Details'!C31)","v":{"$error":"#N/A"}},{"$f":"IF(C23=\"Survey Needed\",\"Survey Required\", \"No Survey for OT/OQ\")","v":{"$error":"#N/A"}}]

{"sheet":"Form Information & Definitions","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[13,5,14,8],[15,5,20,8],[23,5,23,8],[2,1,5,8],[0,0,0,9],[7,1,8,8]]}
["Form Information and Definitions"]
[]
[null,"Auto Approval means that Vessel Operator approval will not be required. The Auto Approval process still will require our customer service representative to verify space and equipment availability as well as port approvals. Our customer Service representative will be responding to this request ASAP."]
[]
[]
[]
[]
[null,"Surveys are required for all FR/FQ/SR bookings. Surveys are not needed for OT/OQ. Surveys are due by the gate cut off."]
[]
[]
[null,"20FR:","20' Flat Rack",null,null,"POL","Port Of Loading"]
[null,"40FR:","40' Flat Rack",null,null,"POD","Port Of Discharge"]
[null,"40FQ :","40' High Cube FR"]
[null,"40SR:","40' Super Rack",null,null,"Link to OOCL.com Vessel Schedule to obtain Vessel Voyage and Arrival Date."]
[null,"20OT:","20' Open Top"]
[null,"40OT:","40' Open Top",null,null,"To use enter the Origin and Destination Cities. Once the various schedules are provided choose one and click on the voyage number to obtain the Vessel Arrival which is needed for the Shipment Details Tab on this form."]
[null,"40OQ:","40' High Cube OT"]
[]
[]
[]
[]
[null,"Over "]
[null,"Height"]
[null,null,null,null,null,"Link to OOCL.com OOG Information"]
[]
[]
[]
[null,"Over"]
[null,"Width"]
[]
[]
[]
[]
[null,"Over"]
[null,"Height/"]
[null,"Width"]
[]
[]
[]
[]
[null,"Over"]
[null,"Length"]
[]
[]
[null,null,null,null,"Ends Folded Down"]
[]
[null,"Interior Dimensions in Meters"]
[null,null,"Length","Width","Height"]
[null,"20FR",5.6180000000000003,2.4380000000000002,2.21]
[null,"40FR",11.651999999999999,2.4380000000000002,1.9550000000000001]
[null,"40FQ ",11.651999999999999,2.4380000000000002,2.2639999999999998]
[null,"20OT",5.8970000000000002,2.3519999999999999,2.36]
[null,"40OT",12.32,2.3519999999999999,2.36]
[null,"40OQ",12.32,2.3519999999999999,2.65]
[null,"40SR",11.615,2.4380000000000002,3.4830000000000001]

{"sheet":"Data","index":3,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["select","select","select","select","select","select","If ","L","W","H"]
["Yes","20FR","Over Height",1,"Boston","Antwerp","20FR",5.6180000000000003,2.4380000000000002,2.21]
["No","40FR","Over Width",2,"Charleston","Bremerhaven","40FR",11.651999999999999,2.4380000000000002,1.9550000000000001]
[null,"40FQ ","Over Height/Wide",3,"Halifax","Cai Mep","40FQ ",11.651999999999999,2.4380000000000002,2.2639999999999998]
[null,"40SR","Over Length",4,"Houston","Da Chan Bay","20OT",5.8970000000000002,2.3519999999999999,2.36]
[null,"20OT","Over Height/Length",5,"Jacksonville","Dalian","40OT",12.32,2.3519999999999999,2.36]
[null,"40OT",null,6,"Long Beach","Dammam","40OQ",12.32,2.3519999999999999,2.65]
[null,"40OQ",null,7,"Los Angeles","Freemantle","40SR",11.615,2.4380000000000002,3.4830000000000001]
[null,null,null,8,"Miami","Fuqing",{"$f":"'Shipment Details'!D14","v":"select"},{"$f":"VLOOKUP(G9,G2:J8,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G9,G2:J8,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G9,G2:J8,4,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,9,"Mobile","Hamburg"]
[null,null,null,10,"Montreal","Hong Kong"]
[null,null,null,11,"New Orleans","Jakarta","If ","L"]
[null,null,null,12,"New York","Jebel Ali","20FR","Survey Needed"]
[null,null,null,15,"Norfolk","Kaohsiung","40FR","Survey Needed"]
[null,null,null,16,"Oakland","Kobe","40FQ ","Survey Needed"]
[null,null,null,17,"Prince Rupert","Kwangyang","20OT","Not Needed"]
[null,null,null,18,"Savannah","Laem Chabang","40OT","Not Needed"]
[null,null,null,22,"Seattle","Le Havre","40OQ","Not Needed"]
[null,null,null,25,"Tacoma","Lianyungang","40SR","Survey Needed"]
[null,null,null,27,"Vancouver","Nagoya",{"$f":"'Shipment Details'!D14","v":"select"},{"$f":"VLOOKUP(G20,G13:H19,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,32,null,"Nansha"]
[null,null,null,null,null,"Nhava Sheva "]
[null,null,null,null,null,"Ningbo"]
[null,null,null,null,null,"Osaka"]
[null,null,null,null,null,"Port Kelang"]
[null,null,null,null,null,"Pusan"]
[null,null,null,null,null,"Qingdao"]
[null,null,null,null,null,"Rotterdam"]
[null,null,null,null,null,"Shanghai"]
[null,null,null,null,null,"Shekou"]
[null,null,null,null,null,"Singapore"]
[null,null,null,null,null,"Southampton"]
[null,null,null,null,null,"Tianjin"]
[null,null,null,null,null,"Tokyo"]
["JB 4-25-18",null,null,null,null,"Xiamen"]
[null,null,null,null,null,"Yantian"]
[null,null,null,null,null,"Yokohama"]