{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Auftragszettel","Datenbank"],"not_rendered":{"charts":0,"images":0,"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":"Auftragszettel","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,7],[22,1,22,3],[22,4,22,7],[18,1,18,7],[19,1,19,3],[19,4,19,7],[20,1,20,3],[20,4,20,7],[4,1,4,3],[4,5,4,7],[11,1,17,7],[0,6,0,7],[2,0,2,3],[2,4,2,7],[3,1,3,3],[3,5,3,7],[5,1,5,3],[5,5,5,7],[6,1,6,3],[6,5,6,7],[7,1,7,3],[7,5,7,7],[8,2,8,6],[10,1,10,7]]}
[null,null,null,null,null,"Datum:",{"$f":"TODAY()","v":"2024-11-11"}]
[]
["Kunde:",null,null,null,"Auftragsort:",null,null,null,"ID:",1]
["Name:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$H$199,ROW()+1,FALSE)","v":"Müller, Paul"},null,null,"Name:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$R$197,ROW()+6,FALSE)","v":"TEST"}]
["Straße:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$H$199,ROW()+1,FALSE)","v":"Südmauer"},null,null,"Straße:",{"$f":"IF(ISNUMBER(J3),VLOOKUP(J3,Daten[],11,FALSE),\"\")","v":"Südmauer"}]
["PLZ / Ort:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$H$199,ROW()+1,FALSE)","v":"33034 Brakel"},null,null,"PLZ / Ort:",{"$f":"IF(ISNUMBER(J3),VLOOKUP(J3,Daten[],12,FALSE),\"\")","v":33333}]
["Telefon:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$H$199,ROW()+1,FALSE)","v":"-"},null,null,"Telefon:",{"$f":"IF(ISNUMBER(J3),VLOOKUP(J3,Daten[],13,FALSE),\"\")","v":110}]
["Mail:",{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$I$199,ROW()+1,FALSE)","v":"ttt@web.de"},null,null,"Projekt:",{"$f":"IF(ISNUMBER(J4),VLOOKUP(J4,Daten[],13,FALSE),\"\")","v":""}]
["Termin:"]
[]
["Arbeiten:"]
[null,{"$f":"VLOOKUP($J$3,Datenbank!$A$2:$N$199,ROW()+2,FALSE)","v":"Kamerabefahrung des Fallrohres"}]
[]
[]
[]
[]
[]
[]
[]
["Material:"]

{"sheet":"Datenbank","index":1,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["ID","Datum","Bereich","Thema","Name Kunde","Straße Kunde","PLZ / Ort Kunde","Tel. Kunde","Mail Kunde","Name Baustelle","Straße Baustelle","PLZ / Ort Baustelle","Tel. Baustelle","Aufgabe"]
[{"$f":"ROW()-1","v":1},"2024-11-11","Sanitär","Regenabfluss","Müller, Paul","Südmauer","33034 Brakel","-","ttt@web.de","TEST","Südmauer",33333,110,"Kamerabefahrung des Fallrohres"]
[{"$f":"ROW()-1","v":2},"2024-11-11","Elektro","Fenster","Fischer, Alfred","Dreifeldweg 6","33034 Riesel","05272 / 5292","-","-","-","-","-","Fenster fährt nicht mehr zu"]
[{"$f":"ROW()-1","v":3},null,null,null,"Neu, Anne"]