{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Start","Ladeliste","Liste 1","Liste 2","Liste 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Start","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,"E:\\Forum Herber Jan 2026\\Ladeliste",null,null,"Verify"]
[null,null,null,null,null,"#"]
[]
[null,1,"179952.xlsx",17221,"2026-01-05T22:32:19","#"]
[null,2,"179953.xlsx",15367,"2026-01-05T23:41:52","#"]
[null,3,"179954.xlsx",15648,"2026-01-05T23:43:06","#"]

{"sheet":"Ladeliste","index":1,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,18,10,20],[10,0,10,1],[10,2,10,10],[10,11,10,17],[4,0,4,1],[4,2,4,10],[4,11,4,17],[4,18,4,20],[1,19,1,20],[1,15,1,17],[0,18,0,20],[1,0,1,9],[0,0,0,1],[1,10,1,14],[0,2,0,10],[0,11,0,17]]}
["IMPORT",null,"Zug am xxxxx nach Werk   |   Verladung am xxxxx",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
["Containerdaten",null,null,null,null,null,null,null,null,null,"Transportparameter",null,null,null,null,"Daten Hafensystem",null,null,null,"Freistellung"]
["TEU","Containernummer","TYP","BRT [to]","AGL","Zoll","Shipper","Reeder","NET [kg]","BRT [kg]","Abgangshafen","Schiffsname","ETA","Terminal","Port","Positionsnummer","TA Nr.","Wagen",null,"Referenz"]
[]
["Liste 1  /  Liste 2",null,"Zug am 10.02.2026 nach Werk   |   Verladung am 07.02.2026 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12345]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C6)),2,IF(ISNUMBER(FIND(\"45\",C6)),2,IF(ISNUMBER(FIND(\"20\",C6)),1,\"\")))","v":2},"ABCD1234567","40HC",{"$f":"J6/1000","v":16.058199999999999},"Werk","GW","Kunde","Tobias Line",12058.2,16058.2,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"DACD1425566","40HC",{"$f":"J7/1000","v":17.5},"Werk","GW","Kunde","Tobias Line",13500,17500,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C8)),2,IF(ISNUMBER(FIND(\"45\",C8)),2,IF(ISNUMBER(FIND(\"20\",C8)),1,\"\")))","v":""},null,null,{"$f":"J8/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[]
[]
["Liste 1  /  Liste 3",null,"Zug am 12.02.2026 nach Werk   |   Verladung am 09.02.2026 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12345]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C12)),2,IF(ISNUMBER(FIND(\"45\",C12)),2,IF(ISNUMBER(FIND(\"20\",C12)),1,\"\")))","v":2},"AAAA1112223","40HC",{"$f":"J12/1000","v":17.260000000000002},"Werk","GW","Kunde","Tobias Line",13260,17260,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"BBBB4446553","40HC",{"$f":"J13/1000","v":15.9086},"Werk","GW","Kunde","Tobias Line",11908.6,15908.6,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]

{"sheet":"Liste 1","index":2,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,2],[32,4,32,16],[0,0,0,1],[0,2,0,10],[0,11,0,17],[0,18,0,20],[1,0,1,9],[1,10,1,14],[1,15,1,17],[1,19,1,20]]}
["IMPORT",null,"Zug am 09.02.2026 nach Werk   |   Verladung am 06.02.2026 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12345]
["Containerdaten",null,null,null,null,null,null,null,null,null,"Transportparameter",null,null,null,null,"Daten Hafensystem",null,null,null,"Freistellung"]
["TEU","Containernummer","TYP","BRT [to]","AGL","Zoll","Shipper","Reeder","NET [kg]","BRT [kg]","Abgangshafen","Schiffsname","ETA","Terminal","Port","Positionsnummer","TA Nr.","Wagen",null,"Referenz"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C4)),2,IF(ISNUMBER(FIND(\"45\",C4)),2,IF(ISNUMBER(FIND(\"20\",C4)),1,\"\")))","v":""},null,null,{"$f":"J4/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C5)),2,IF(ISNUMBER(FIND(\"45\",C5)),2,IF(ISNUMBER(FIND(\"20\",C5)),1,\"\")))","v":""},null,null,0,"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A4:A5)","v":0},null,null,{"$f":"SUM(D4:D5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A6/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C8)),2,IF(ISNUMBER(FIND(\"45\",C8)),2,IF(ISNUMBER(FIND(\"20\",C8)),1,\"\")))","v":""},null,null,{"$f":"J8/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C9)),2,IF(ISNUMBER(FIND(\"45\",C9)),2,IF(ISNUMBER(FIND(\"20\",C9)),1,\"\")))","v":""},null,null,0,"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A8:A9)","v":0},null,null,{"$f":"SUM(D8:D9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A10/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C12)),2,IF(ISNUMBER(FIND(\"45\",C12)),2,IF(ISNUMBER(FIND(\"20\",C12)),1,\"\")))","v":""},null,null,{"$f":"J12/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C13)),2,IF(ISNUMBER(FIND(\"45\",C13)),2,IF(ISNUMBER(FIND(\"20\",C13)),1,\"\")))","v":""},null,null,0,"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A12:A13)","v":0},null,null,{"$f":"SUM(D12:D13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A14/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C16)),2,IF(ISNUMBER(FIND(\"45\",C16)),2,IF(ISNUMBER(FIND(\"20\",C16)),1,\"\")))","v":""},null,null,{"$f":"J16/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[2,"ABCD1234567","40HC",{"$f":"J17/1000","v":16.058199999999999},"Werk","GW","Kunde","Tobias Line",12058.2,16058.2,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"DACD1425566","40HC",{"$f":"J18/1000","v":17.5},"Werk","GW","Kunde","Tobias Line",13500,17500,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"DGDS3251653","40HC",{"$f":"J19/1000","v":14.1469},"Werk","GW","Kunde","Tobias Line",10146.9,14146.9,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"AAAA1112223","40HC",{"$f":"J20/1000","v":17.260000000000002},"Werk","GW","Kunde","Tobias Line",13260,17260,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"BBBB4446553","40HC",{"$f":"J21/1000","v":15.9086},"Werk","GW","Kunde","Tobias Line",11908.6,15908.6,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
["",null,null,{"$f":"J22/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A16:A22)","v":10},null,null,{"$f":"SUM(D16:D22)","v":80.873700000000014},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A23/4,0)","v":3}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C25)),2,IF(ISNUMBER(FIND(\"45\",C25)),2,IF(ISNUMBER(FIND(\"20\",C25)),1,\"\")))","v":""},null,null,{"$f":"J25/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C26)),2,IF(ISNUMBER(FIND(\"45\",C26)),2,IF(ISNUMBER(FIND(\"20\",C26)),1,\"\")))","v":""},null,null,{"$f":"J26/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A25:A26)","v":0},null,null,{"$f":"SUM(D25:D26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A27/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C29)),2,IF(ISNUMBER(FIND(\"45\",C29)),2,IF(ISNUMBER(FIND(\"20\",C29)),1,\"\")))","v":""},null,null,{"$f":"J29/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C30)),2,IF(ISNUMBER(FIND(\"45\",C30)),2,IF(ISNUMBER(FIND(\"20\",C30)),1,\"\")))","v":""},null,null,{"$f":"J30/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A29:A30)","v":0},null,null,{"$f":"SUM(D29:D30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A31/4,0)","v":0}]
[]
[{"$f":"SUM(A6,A10,A14,A23,A27,A31)","v":10},null,null,{"$f":"SUM(D6,D10,D14,D23,D27,D31)","v":80.873700000000014},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wagen Total:  ",{"$f":"SUM(S6,S10,S14,S23,S27,S31)","v":3}]

{"sheet":"Liste 2","index":3,"n_rows":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,1,20,2],[20,4,20,16],[0,0,0,1],[0,2,0,10],[0,11,0,17],[0,18,0,20],[1,0,1,9],[1,10,1,14],[1,15,1,17],[1,19,1,20]]}
["IMPORT",null,"Zug am 10.02.2026 nach Werk   |   Verladung am 07.02.2026 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12345]
["Containerdaten",null,null,null,null,null,null,null,null,null,"Transportparameter",null,null,null,null,"Daten Hafensystem",null,null,null,"Freistellung"]
["TEU","Containernummer","TYP","BRT [to]","AGL","Zoll","Shipper","Reeder","NET [kg]","BRT [kg]","Abgangshafen","Schiffsname","ETA","Terminal","Port","Positionsnummer","TA Nr.","Wagen",null,"Referenz"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C4)),2,IF(ISNUMBER(FIND(\"45\",C4)),2,IF(ISNUMBER(FIND(\"20\",C4)),1,\"\")))","v":""},null,null,{"$f":"J4/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C5)),2,IF(ISNUMBER(FIND(\"45\",C5)),2,IF(ISNUMBER(FIND(\"20\",C5)),1,\"\")))","v":""},null,null,0,"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A4:A5)","v":0},null,null,{"$f":"SUM(D4:D5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A6/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C8)),2,IF(ISNUMBER(FIND(\"45\",C8)),2,IF(ISNUMBER(FIND(\"20\",C8)),1,\"\")))","v":""},null,null,{"$f":"J8/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[2,"ABCD1234567","40HC",{"$f":"J9/1000","v":16.058199999999999},"Werk","GW","Kunde","Tobias Line",12058.2,16058.2,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"DACD1425566","40HC",{"$f":"J10/1000","v":17.5},"Werk","GW","Kunde","Tobias Line",13500,17500,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[{"$f":"SUM(A8:A10)","v":4},null,null,{"$f":"SUM(D8:D10)","v":33.558199999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A11/4,0)","v":1}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C13)),2,IF(ISNUMBER(FIND(\"45\",C13)),2,IF(ISNUMBER(FIND(\"20\",C13)),1,\"\")))","v":""},null,null,{"$f":"J13/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C14)),2,IF(ISNUMBER(FIND(\"45\",C14)),2,IF(ISNUMBER(FIND(\"20\",C14)),1,\"\")))","v":""},null,null,{"$f":"J14/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A13:A14)","v":0},null,null,{"$f":"SUM(D13:D14)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A15/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C17)),2,IF(ISNUMBER(FIND(\"45\",C17)),2,IF(ISNUMBER(FIND(\"20\",C17)),1,\"\")))","v":""},null,null,{"$f":"J17/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C18)),2,IF(ISNUMBER(FIND(\"45\",C18)),2,IF(ISNUMBER(FIND(\"20\",C18)),1,\"\")))","v":""},null,null,{"$f":"J18/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A17:A18)","v":0},null,null,{"$f":"SUM(D17:D18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A19/4,0)","v":0}]
[]
[{"$f":"SUM(#REF!,#REF!,A6,A11,A15,A19)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!,#REF!,D6,D11,D15,D19)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wagen Total:  ",{"$f":"SUM(#REF!,#REF!,S6,S11,S15,S19)","v":{"$error":"#REF!"}}]

{"sheet":"Liste 3","index":4,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,4,22,16],[0,0,0,1],[0,2,0,10],[0,11,0,17],[0,18,0,20],[1,0,1,9],[1,10,1,14],[1,15,1,17],[1,19,1,20]]}
["IMPORT",null,"Zug am 12.02.2026 nach Werk   |   Verladung am 09.02.2026 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12345]
["Containerdaten",null,null,null,null,null,null,null,null,null,"Transportparameter",null,null,null,null,"Daten Hafensystem",null,null,null,"Freistellung"]
["TEU","Containernummer","TYP","BRT [to]","AGL","Zoll","Shipper","Reeder","NET [kg]","BRT [kg]","Abgangshafen","Schiffsname","ETA","Terminal","Port","Positionsnummer","TA Nr.","Wagen",null,"Referenz"]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C5)),2,IF(ISNUMBER(FIND(\"45\",C5)),2,IF(ISNUMBER(FIND(\"20\",C5)),1,\"\")))","v":""},null,null,{"$f":"J5/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C6)),2,IF(ISNUMBER(FIND(\"45\",C6)),2,IF(ISNUMBER(FIND(\"20\",C6)),1,\"\")))","v":""},null,null,0,"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A5:A6)","v":0},null,null,{"$f":"SUM(D5:D6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A7/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C9)),2,IF(ISNUMBER(FIND(\"45\",C9)),2,IF(ISNUMBER(FIND(\"20\",C9)),1,\"\")))","v":""},null,null,{"$f":"J9/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[2,"AAAA1112223","40HC",{"$f":"J10/1000","v":17.260000000000002},"Werk","GW","Kunde","Tobias Line",13260,17260,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
[2,"BBBB4446553","40HC",{"$f":"J11/1000","v":15.9086},"Werk","GW","Kunde","Tobias Line",11908.6,15908.6,"Shanghai","MV Tobias","2026-02-03T08:00:00","XX","HH"]
["",null,null,{"$f":"J12/1000","v":0},"Werk","GW","Kunde",null,null,null,null,null,null,"XX","HH"]
[{"$f":"SUM(A9:A12)","v":4},null,null,{"$f":"SUM(D9:D12)","v":33.168599999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A13/4,0)","v":1}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C15)),2,IF(ISNUMBER(FIND(\"45\",C15)),2,IF(ISNUMBER(FIND(\"20\",C15)),1,\"\")))","v":""},null,null,{"$f":"J15/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C16)),2,IF(ISNUMBER(FIND(\"45\",C16)),2,IF(ISNUMBER(FIND(\"20\",C16)),1,\"\")))","v":""},null,null,{"$f":"J16/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A15:A16)","v":0},null,null,{"$f":"SUM(D15:D16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A17/4,0)","v":0}]
[]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C19)),2,IF(ISNUMBER(FIND(\"45\",C19)),2,IF(ISNUMBER(FIND(\"20\",C19)),1,\"\")))","v":""},null,null,{"$f":"J19/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"IF(ISNUMBER(FIND(\"40\",C20)),2,IF(ISNUMBER(FIND(\"45\",C20)),2,IF(ISNUMBER(FIND(\"20\",C20)),1,\"\")))","v":""},null,null,{"$f":"J20/1000","v":0},"Werk","ATD","Kunde",null,null,null,null,null,null,"XX","BHV"]
[{"$f":"SUM(A19:A20)","v":0},null,null,{"$f":"SUM(D19:D20)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(A21/4,0)","v":0}]
[]
[{"$f":"SUM(#REF!,#REF!,A7,A13,A17,A21)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(#REF!,#REF!,D7,D13,D17,D21)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Wagen Total:  ",{"$f":"SUM(#REF!,#REF!,S7,S13,S17,S21)","v":{"$error":"#REF!"}}]