{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Deckblatt","Colli Liste","Packliste 1XA4","Packliste 2XA5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"Deckblatt","index":0,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[0,4,0,9],[0,1,0,2],[1,1,1,2],[2,1,2,2],[4,1,4,2],[3,1,3,2],[1,4,1,9],[42,3,43,3],[11,5,11,7],[0,11,1,13],[4,11,4,12],[4,13,4,14],[5,11,5,12],[5,13,5,14],[6,8,6,9],[7,8,7,9],[7,11,7,12],[7,13,7,14],[6,11,6,12],[6,13,6,14],[8,11,8,12],[8,13,8,14],[2,11,2,13]]}
["Aktueller Kunde:","Musterkunde",null,"Beschreibung:",null,null,null,null,null,null,"Logo:",null,null,null,"Projekt Pfad:"]
["Straße:","Musterstraße",null,"Projekt:"]
["PLZ/ Ort:","Musterstadt 12345",null,"Anlagennummer: ","CXXXX"]
["Land:","Musterland",null,null,null,"Nr.:","Bez:"]
["Neuer Kunde:","Max Mustermann",null,null,"Auftragsnummer/n:","1",null,"Baustellenleiter:",null,"Projektleitung Vertrieb:",null,"Kundenansprechpartner:",null,"Mustermann Max"]
["Straße:","Musterweg",null,"Projektnummer:",null,"2",null,"Abteilung:",null,"Projektleitung Service:",null,"Kundentelefonnummer:"]
["PLZ/Ort:","Musterhausen",null,"Nummer:",null,"3",null,"Plan-Nr.",null,null,null,"Kundenmailadrsse:",null,null,null,null,"Personal:"]
["Land:","Sample",null,null,null,"4",null,"Projektbeginn:",null,null,null,"Kundenprojektleiter:"]
[null,null,null,null,null,"5",null,null,null,null,null,"Auftraggeber:",null,"Musterfirma",null,null,"Mitarbeiternamen","Typ","Firma"]
["Hersteller","Maschine","Typ","Kommisionsnummer",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Sichtbar:",null,null,null,null,null,null,2]
[null,null,null,null,null,"Kundendaten sichtbar schalten:",null,null,"Ja",null,null,null,null,"Projektjahr","Monat",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"Januar",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"Februar",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"März",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"April",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"Mai",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"Juni",9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"Juli",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"August",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2025,"September",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2024,"Oktober",13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2024,"November",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2024,"Dezember",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,"Mann-Tage Auftragsbezogen",null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,"Summen Auftragsnummern:","Nr.:","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",36]
[null,{"$f":"SUM(D46+E46+F46+G46+H46+I46+J46+K46+L46+M46+N46+O46)","v":{"$error":"#REF!"}},{"$f":"_xlfn.CONCAT(\"Auftrag \",F5)","v":"Auftrag 1"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},37]
[null,{"$f":"SUM(D47+E47+F47+G47+H47+I47+J47+K47+L47+M47+N47+O47)","v":{"$error":"#REF!"}},{"$f":"_xlfn.CONCAT(\"Auftrag \",F6)","v":"Auftrag 2"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},38]
[null,{"$f":"SUM(D48+E48+F48+G48+H48+I48+J48+K48+L48+M48+N48+O48)","v":{"$error":"#REF!"}},"Auftrag 3",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},39]
[null,{"$f":"SUM(D49+E49+F49+G49+H49+I49+J49+K49+L49+M49+N49+O49)","v":{"$error":"#REF!"}},"Auftrag 4",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},40]
[null,{"$f":"SUM(D50+E50+F50+G50+H50+I50+J50+K50+L50+M50+N50+O50)","v":{"$error":"#REF!"}},"Auftrag 5",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},41]
[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,43]
[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,45]
[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,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,"Formle und Formatierung kontrolliiert",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,50]
[null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember",null,51]
[null,null,null,null,null,null,null,null,null,null,"JA","JA","JA","JA",null,52]

{"sheet":"Colli Liste","index":1,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,9,0,11],[0,4,0,6]]}
[null,null,null,null,"Markieren sie die Kennzeichnungen oder Collinummer für die sie Ordner erstellen wollen und Drücken die Schaltfläche.",null,null,null,"Ordner Pfad:"]
["6 Kennzeichen  ","7 Anzahl","Art","neu / gebraucht","11 Gewicht","12 Abmessungen","8 Verpackung","9 Bezeichnung","Komissionsnummer","Maschine","Inhalt 1","Inhalt2","Inhalt3","Inhalt4","Inhalt5","Inhalt6","Inhalt7","Inhalt8","Inhalt9","Länge","Breite","Höhe","LKW NR.:","Maschinentyp eindeutig","Packstück Maschinen bezogen","Packstück Gesamtanteil"]
["1","1","Stück","gebr","800","220X200X200","Podest","Colli 1","KPT-2014-30","Preformkipper","Tanner Preformsilo","Schutzzaun Silo"]
["2","1","Stück","gebr","1400","440X240X240","Podest","Colli 2","K995U4U","Behältertransport","Transportband B22-20, B22-4,-5,-6,-14","Transportband B24-5","3 Tauschkurven (Garnituren)","Transportbandfüße"]
["3","1","Stück","gebr","1500","440X240X240","Podest","Colli 3","K995U4U,K82710R","Behältertransport,Preformzuführung","Tanner Preform Zuführung und Rückführung","Transportband B24-2, B22-16,-17","Transportbandfüße"]
["4","1","Stück","gebr","1700","440X240X240","Podest","Colli 4","KR67R37","Gebindetransport","Transportband G21-1,-5;G21-8,-9","Transportband G22-1,-2,-3,-4,-5,-6,-7,-8,-9,-10","Transportband G22-11,-12,-13,-14,-15","Transportband G23-5, G23-22","Kabelkanäle Anlage"]
["5","1","Stück","gebr","1700","440X240X240","Podest","Colli 5","K9954U4","Behältertransport","Transportband B70-1 (AccuLoop)","Transportband B21-17, B21-22, B22-18","Transportband B23-1,-2,-3,-4,-5,-6,-7,-8","Kabelkanäle Anlage + Deckel"]
["6","1","Stück","gebr","1600","440X240X240","Podest","Colli 6","KR67R37,K9954U4","Gebindetransport,Behältertransport","Transportband G23-15, G23-31,-32,-33,-34,-35,-36,-37,-38","Transportband B24-1, B23-9,-10,-11"]
["7","1","Stück","gebr","1600","440X240X240","Podest","Colli 7","K9954U4","Behältertransport","Transportband B70-6,-7,-10 (AccuLoop)","Transportband B21-13,-15,-22,-23,-24","Transportband B21-33,-34,-35,-36,-37","Transportband B21-39,-40,-41,-42","Transportbandfüße"]
["8","1","Stück","gebr","1700","440X240X240","Podest","Colli 8","K9944U4","Behältertransport","Transportband B23-1,-3,-6,-8,-9,-11,-12,-13,-14,-15,-16,-17","Transportband B23-18,-19,-20,-21,-23,-24,-25,-27,-28,-29"]
["9","1","Stück","gebr","2500","197X230X150","Podest","Colli 9","K919G6T","Energie Unterverteiler","Zuleitungskabel 1"]
["10","1","Stück","gebr","1600","440X240X240","Podest","Colli 10","K9954U4","Behältertransport","Transportband B70-2,-3,-4,-5 (AccuLoop)","Transportband B21-21,-20,-19,-18","Transportband B21-43","Kabelkanäle"]
["11","1","Stück","gebr","500","130X100X100","Palette","Colli 11","K919G6T","Energie Unterverteiler","Zuleitungskabel 2"]
["12","1","Stück","gebr","2000","240X197X320","Podest","Colli 12","KPT-2014-30","Preformkipper","Preformfipper Tanner "]
["13","1","Stück","gebr","900","195X150X220","Lose","Colli 13","KR57R73","Palettentransport","Transportband P21-02,-13,-01,-12,-09"]
["14","1","Stück","gebr","1000","230X150X220","Lose","Colli 14","KR57R73","Palettentransport","Transportband P21-04,-03,-11,-18,-10"]
["15","1","Stück","gebr","550","400X197X140","Podest","Colli 15","K9954U4","Behältertransport","Transportband B24-6","Bandschmierleitungen Behältertransport Anlage"]
["16","1","Stück","gebr","700","170X170X200","Lose","Colli 16","KR57R73","Palettentransport","Transportband P21-24, P21-16 (Drehsegmente)"]
["17","1","Stück","gebr","750","220X150X220","Lose","Colli 17","KR57R73","Palettentransport","Transportband P21-20,-19,-17,-08,-23"]
["18","1","Stück","gebr","800","220X150X200","Lose","Colli 18","KR57R73","Palettentransport","Transportband P21-25,-15,-22,-06"]

{"sheet":"Packliste 1XA4","index":2,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,0,27,0],[0,0,0,1],[1,0,2,0],[1,1,2,1],[24,1,25,11],[12,1,13,11],[10,1,11,11],[8,9,9,10],[8,11,9,11],[16,1,17,11],[20,1,21,11],[8,4,9,6],[8,7,9,7],[8,8,9,8],[28,5,29,6],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[24,0,25,0],[27,1,27,11],[28,7,29,9],[28,10,29,11],[18,1,19,11],[14,1,15,11],[22,1,23,11],[28,3,29,4],[28,0,29,2],[0,21,1,21],[0,22,2,25],[10,0,11,0],[8,0,9,0],[0,4,2,7],[0,8,2,11],[5,0,5,2],[5,3,5,4],[5,9,5,11],[6,0,6,2],[6,3,6,4],[5,5,5,8],[8,1,9,3],[6,5,6,8],[6,9,6,10],[0,2,2,3]]}
[{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,24,FALSE)","v":0},null,"Vorheriger Kunde/                     previous customer",null,{"$f":"_xlfn.CONCAT(Deckblatt!B1,\" , \",Deckblatt!B2,\" , \",Deckblatt!B3,\" , \",Deckblatt!B4)","v":"Musterkunde , Musterstraße , Musterstadt 12345 , Musterland"},null,null,null,{"$f":"Deckblatt!$N$9","v":"Musterfirma"},null,null,null,null,null,null,null,null,null,null,null,null,"Ordner Pfad:"]
[{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,25,FALSE)","v":0},{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,26,FALSE)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Der Pfad muss mit einem Backslash enden!"]
[" Auftrags-Nr./Order no..",null,null,"Kunde / Customer",null,"Ziel Ort/Destination ",null,null,null,"Maschinentyp",null,null,null,null,null,null,null,null,null,null,null,"Der Pfad muss mit einem Backslash enden!"]
[null,null,null,{"$f":"Deckblatt!$B$5","v":"Max Mustermann"},null,{"$f":"_xlfn.CONCAT(Deckblatt!B6,\" , \",Deckblatt!B7,\" , \",Deckblatt!B8)","v":"Musterweg , Musterhausen , Sample"},null,null,null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,9,FALSE)","v":"KPT-2014-30"},null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,10,FALSE)","v":"Preformkipper"}]
[]
["Pos. Nr.:","Bezeichnung / Description:",null,null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,9,FALSE)","v":"KPT-2014-30"},null,null,"Gewicht/weight",{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,5,FALSE)","v":"800"},"Abmaße/ measuarment:",null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,6,FALSE)","v":"220X200X200"}]
[]
[1,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,11,FALSE)","v":"Tanner Preformsilo"}]
[]
[2,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,12,FALSE)","v":"Schutzzaun Silo"},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}}]
[3,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,13,FALSE)","v":0}]
[]
[4,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,14,FALSE)","v":0}]
[]
[5,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,15,FALSE)","v":0}]
[]
[6,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,16,FALSE)","v":0}]
[]
[7,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,17,FALSE)","v":0}]
[]
[8,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,18,FALSE)","v":0}]
[]
[9,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,20,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,19,FALSE)","v":0}]
[null,null,null,"Verpackungsart/ Packing type:",null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,7,FALSE)","v":"Podest"},null,"Colli Nummer",null,null,"1"]

{"sheet":"Packliste 2XA5","index":3,"n_rows":65,"n_cols":22,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,2,2,3],[0,0,0,1],[1,0,2,0],[1,1,2,1],[38,2,40,3],[38,0,38,1],[39,0,40,0],[39,1,40,1],[26,0,27,0],[27,1,27,11],[20,0,21,0],[20,1,21,11],[22,0,23,0],[22,1,23,11],[24,0,25,0],[8,1,9,3],[8,0,9,0],[60,0,61,0],[60,1,61,11],[58,1,59,11],[41,0,41,2],[41,3,41,4],[41,5,41,8],[41,9,41,11],[42,0,42,2],[42,3,42,4],[54,0,55,0],[54,1,55,11],[56,0,57,0],[56,1,57,11],[58,0,59,0],[48,0,49,0],[62,0,63,0],[64,5,65,6],[64,7,65,9],[64,10,65,11],[62,1,63,11],[64,3,65,4],[64,0,65,2],[48,1,49,11],[50,0,51,0],[50,1,51,11],[52,0,53,0],[52,1,53,11],[46,1,47,11],[46,0,47,0],[44,4,45,6],[44,7,45,7],[44,8,45,8],[44,9,45,10],[44,11,45,11],[44,0,45,0],[42,5,42,8],[42,9,42,10],[44,1,45,3],[28,5,29,6],[28,7,29,9],[28,10,29,11],[38,4,40,7],[38,8,40,11],[28,3,29,4],[28,0,29,2],[24,1,25,11],[16,0,17,0],[16,1,17,11],[18,0,19,0],[18,1,19,11],[14,0,15,0],[14,1,15,11],[5,0,5,2],[5,3,5,4],[5,5,5,8],[5,9,5,11],[12,1,13,11],[12,0,13,0],[6,9,6,10],[6,5,6,8],[6,3,6,4],[6,0,6,2],[8,9,9,10],[8,8,9,8],[10,1,11,11],[10,0,11,0],[8,11,9,11],[8,7,9,7],[0,20,1,20],[0,21,1,25],[0,4,2,7],[0,8,2,11],[8,4,9,6]]}
[{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,24,FALSE)","v":0},null,"Vorheriger Kunde/                     previous customer",null,{"$f":"_xlfn.CONCAT(Deckblatt!B1,\" , \",Deckblatt!B2,\" , \",Deckblatt!B3,\" , \",Deckblatt!B4)","v":"Musterkunde , Musterstraße , Musterstadt 12345 , Musterland"},null,null,null,{"$f":"Deckblatt!$N$9","v":"Musterfirma"},null,null,null,null,null,null,null,null,null,null,null,"Ordner Pfad:"]
[{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,25,FALSE)","v":0},{"$f":"VLOOKUP(K29,'Colli Liste'!A3:Z304,26,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Der Pfad muss mit einem Backslash enden!"]
[]
[]
[" Auftrags-Nr./Order no..",null,null,"Kunde / Customer",null,"Ziel Ort/Destination ",null,null,null,"Maschinentyp"]
[null,null,null,{"$f":"Deckblatt!$B$5","v":"Max Mustermann"},null,{"$f":"_xlfn.CONCAT(Deckblatt!B6,\" , \",Deckblatt!B7,\" , \",Deckblatt!B8)","v":"Musterweg , Musterhausen , Sample"},null,null,null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,9,FALSE)","v":"K995U4U"},null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,10,FALSE)","v":"Behältertransport"}]
[]
["Pos. Nr.:","Bezeichnung / Description:",null,null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,9,FALSE)","v":"K995U4U"},null,null,"Gewicht /weight",{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,5,FALSE)","v":"1400"},"Abmaße/ measuarment:",null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,6,FALSE)","v":"440X240X240"}]
[]
[1,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,11,FALSE)","v":"Transportband B22-20, B22-4,-5,-6,-14"}]
[]
[2,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,12,FALSE)","v":"Transportband B24-5"}]
[]
[3,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,13,FALSE)","v":"3 Tauschkurven (Garnituren)"}]
[]
[4,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,14,FALSE)","v":"Transportbandfüße"}]
[]
[5,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,15,FALSE)","v":0}]
[]
[6,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,16,FALSE)","v":0}]
[]
[7,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,17,FALSE)","v":0}]
[]
[8,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,18,FALSE)","v":0}]
[]
[9,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,20,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(ISNA(VLOOKUP(#REF!,Tabelle13[],2,FALSE)),\" \",VLOOKUP(#REF!,Tabelle13[],2,FALSE))","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,19,FALSE)","v":0}]
[{"$f":"Deckblatt!$L$1","v":0},null,null,"Verpackungsart/ Packing type:",null,{"$f":"VLOOKUP(K29,'Colli Liste'!A3:S304,7,FALSE)","v":"Podest"},null,"Colli Nummer",null,null,"2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A1","v":0},null,"Vorheriger Kunde/                     previous customer",null,{"$f":"$E$1","v":"Musterkunde , Musterstraße , Musterstadt 12345 , Musterland"},null,null,null,{"$f":"$I$1","v":"Musterfirma"}]
[{"$f":"$A$2","v":0},{"$f":"$B$2","v":0}]
[]
[" Auftrags-Nr./Order no..",null,null,"Kunde / Customer",null,"Ziel Ort/Destination ",null,null,null,"Maschinentyp"]
[{"$f":"$A$7","v":0},null,null,{"$f":"$D$7","v":"Max Mustermann"},null,{"$f":"$F$7","v":"Musterweg , Musterhausen , Sample"},null,null,null,{"$f":"J7","v":"K995U4U"},null,{"$f":"$L$7","v":"Behältertransport"}]
[]
["Pos. Nr.:","Bezeichnung / Description:",null,null,{"$f":"$E$9","v":"K995U4U"},null,null,"Gewicht /weight",{"$f":"$I$9","v":"1400"},"Abmaße/ measuarment:",null,{"$f":"$L$9","v":"440X240X240"}]
[]
[1,{"$f":"B11","v":"Transportband B22-20, B22-4,-5,-6,-14"}]
[]
[2,{"$f":"$B$13","v":"Transportband B24-5"}]
[]
[3,{"$f":"$B$15","v":"3 Tauschkurven (Garnituren)"}]
[]
[4,{"$f":"$B$17","v":"Transportbandfüße"}]
[]
[5,{"$f":"$B$19","v":0}]
[]
[6,{"$f":"$B$21","v":0}]
[]
[7,{"$f":"$B$23","v":0}]
[]
[8,{"$f":"$B$25","v":0}]
[]
[9,{"$f":"$B$28","v":0}]
[]
[{"$f":"Deckblatt!$L$1","v":0},null,null,"Verpackungsart/ Packing type:",null,{"$f":"$F$29","v":"Podest"},null,"Colli Nummer",null,null,{"$f":"$K$29","v":"2"}]