{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["VGM Template","Info","Declaration","Configuration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":1,"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":"VGM Template","index":0,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["SOLASVGM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kilograms",null,null,"Method 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pounds",null,null,"Method 2"]
[]
["VGM Template (Please keep uniqueness of Booking Number, Container Number in the records to avoid confusion.)"]
[]
["Shipments involved in this VGM submission will be loaded in "]
[null,false]
[null,false]
["HK Marine Dept Registration No.",null,null," <-- Mandatory if Hong Kong is checked",null,null,""]
[]
["* Required. "]
["Carrier *","Booking Number *","Container Number*","Verified Gross Mass*","Measurement Unit*","Responsible Party\n(Name on B/L)","AUTHORIZED PERSON SIGNATURE\n(IN CAPITAL LETTER)*","Weighing Method","Weighting Date (mm/dd/yyyy)","Seal Number","Authorized Person Email ","Responsible Party Address"]
["OOCL"]

{"sheet":"Info","index":1,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["RoutingCode","Action","Carrier"]
["MLB","N/A","ACL"]
["All Water","Add","APL"]
["IPI","Update","Alianca"]
["RIPI","Delete","ANL"]
[null,null,"CMA-CGM"]
[null,null,"COSCON"]
[null,null,"China Shipping"]
[null,null,"Evergreen Line"]
[null,null,"GEEST"]
[null,null,"HamburgSud"]
[null,null,"Hanjin"]
[null,null,"Hapag-Lloyd"]
[null,null,"Hyundai"]
[null,null,"K LINE"]
[null,null,"MATSON"]
[null,null,"MISC"]
[null,null,"MOL"]
[null,null,"MSC"]
[null,null,"MacAndrews"]
[null,null,"Maersk"]
[null,null,"NYK"]
[null,null,"OOCL"]
[null,null,"PIL"]
[null,null,"Safmarine"]
[null,null,"TS Line"]
[null,null,"Yang Ming"]

{"sheet":"Declaration","index":2,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Shipper should declare for shipment(s) which will be loaded in China or Hong Kong. ",null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
["For Port of Loading = China"]
[]
["Declaration 声明:"]
["For container(s) weighed by method 1 –"]
["I, the shipper, declare that the verified gross mass information of the packed container in this document is obtained based on the stated method in the International Convention for the Safety of Life at Sea (SOLAS) 1974 Chapter VI Regulation 2.4.1. The weighing instrument in the weighing station has received the certificate from the organizations of metrology techniques and the date receiving the verified weight is within the valid period of the certificate."]
["使用整体称重法的 - "]
["“本托运人声明：该文件资料所含载货集装箱重量信息系按照《1974年国际海上人命安全公约》第VI/2.4.1条所述方法获得，称重点的衡器已取得计量技术机构颁发的计量检定证书，且获得重量的日期在证书的有效期范围内。”"]
[]
["For container(s) weighed by method 2 -"]
["I, the shipper, declare that the verified gross mass information of the packed container in this document is obtained based on the stated method in the International Convention for the Safety of Life at Sea (SOLAS) 1974 Chapter VI Regulation 2.4.2. This method follows the requirements in the ‘Guidelines of Method 2 for Obtaining the Verified Gross Mass of a Packed Container’ published by the enforcement agency."]
["使用累加计算法的 –"]
["“本托运人声明：该文件资料所含载货集装箱重量信息系按照《1974年国际海上人命安全公约》第VI/2.4.2条所述方法获得，该方法符合主管机关制定并公布的《载货集装箱累加计算法重量验证指南》的要求。”"]
[]
[]
[]
["For Port of Loading = Hong Kong"]
[]
["Declaration 聲明:"]
["For container(s) weighed by method 1 - The gross mass of the packed container declared in the shipping document was obtained in accordance with Method 1 stipulated in SOLAS Chapter VI Regulation."]
["透過方法一而得到的經驗證載貨集裝箱總重量 - 裝運單據所聲明的載貨集裝箱總質量資料是本付運人按照《國際海上人命安全公約》第VI章第2條所述的方法一而取得的結果」，付運人簽署確認。"]
[]
[{"$f":"SUBSTITUTE(A31,\"GMVXXXXXXXXX\", 'VGM Template'!C10)","v":"For container(s) weighed by method 2 - The gross mass of packed container declared in the shipping document was obtained in accordance with Method 2 stipulated in SOLAS Chapter VI Regulation 2. The procedure of this method has been approved or recognized by MD with registration number ."}]
[{"$f":"SUBSTITUTE(A32,\"GMVXXXXXXXXX\", 'VGM Template'!C10)","v":"透過方法二而得到的經驗證載貨集裝箱總重量 - 裝運單據所聲明的載貨集裝箱總質量資料是本付運人按照《國際海上人命安全公約》第VI章第2條所述的方法二而取得的結果，該方法已獲得海事處批准或承認，註冊編號為，付運人簽署確認。"}]
[]
[]
[]
[]
[]
["For container(s) weighed by method 2 - The gross mass of packed container declared in the shipping document was obtained in accordance with Method 2 stipulated in SOLAS Chapter VI Regulation 2. The procedure of this method has been approved or recognized by MD with registration number GMVXXXXXXXXX.",1]
["透過方法二而得到的經驗證載貨集裝箱總重量 - 裝運單據所聲明的載貨集裝箱總質量資料是本付運人按照《國際海上人命安全公約》第VI章第2條所述的方法二而取得的結果，該方法已獲得海事處批准或承認，註冊編號為GMVXXXXXXXXX，付運人簽署確認。",1]

{"sheet":"Configuration","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["CarrierList"]
["OOCL","1st batch"]