{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Angebot erstellen","Rechnung erstellen","Stammdaten Kunden","Stammdaten Leistungen","Historie Angebote","Historie Rechnungen"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"comments":2,"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":"Angebot erstellen","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,1,5,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ihr Name • Ihre Strasse • Ihre PLZ / Ort"]
[]
[null,{"$f":"IF(C24=\"\",\"Anrede\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,2,0))","v":"Herr"}]
[null,{"$f":"IF(C24=\"\",\"Name\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,3,0))","v":"Michael Meier"}]
[null,{"$f":"IF(C24=\"\",\"Strasse\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,4,0))","v":"Badstrasse 12b"}]
[null,{"$f":"IF(C24=\"\",\"Plz\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,5,0))","v":"12345 Badstadt"}]
[null,{"$f":"IF(C24=\"\",\"Plz\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,6,0))","v":"040 - 555 123"}]
[null,{"$f":"IF(C24=\"\",\"Plz\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,7,0))","v":"meier@online.de"}]
[]
[]
[null,242,100,null,null,null,{"$f":"TODAY()","v":"2022-08-14"}]
[]
[null,"Position","Bezeichnung","Anzahl","Einheit","Betrag","Summe"]
[null,1,"Service 1",5,{"$f":"IF(ISBLANK(Tabelle104[[#This Row],[Bezeichnung]]),\"\",VLOOKUP(Tabelle104[[#This Row],[Bezeichnung]],'Stammdaten Leistungen'!$B$5:$D$1128,2,0))","v":"Std."},{"$f":"IF(ISBLANK(Tabelle104[[#This Row],[Bezeichnung]]),\"\",VLOOKUP(Tabelle104[[#This Row],[Bezeichnung]],'Stammdaten Leistungen'!$B$5:$D$627,3,0))","v":79.8},{"$f":"IF(Tabelle104[[#This Row],[Anzahl]]=\"\",Tabelle104[[#This Row],[Betrag]],Tabelle104[[#This Row],[Anzahl]]*Tabelle104[[#This Row],[Betrag]])","v":399}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Tabelle104[Summe])","v":399}]

{"sheet":"Rechnung erstellen","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,1,11,3],[23,3,23,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ihr Name • Ihre Strasse • Ihre PLZ / Ort"]
[]
[null,{"$f":"IF(C24=\"\",\"Anrede\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,2,0))","v":"Herr"}]
[null,{"$f":"IF(C24=\"\",\"Name\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,3,0))","v":"Michael Meier"}]
[null,{"$f":"IF(C24=\"\",\"Strasse\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,4,0))","v":"Badstrasse 12b"}]
[null,{"$f":"IF(C24=\"\",\"PLZ\",VLOOKUP(C24,Tabelle2[],5,0))","v":"12345 Badstadt"}]
[null,{"$f":"IF(C24=\"\",\"Plz\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,6,0))","v":"040 - 555 123"}]
[null,{"$f":"IF(C24=\"\",\"Plz\",VLOOKUP(C24,'Stammdaten Kunden'!B5:H1104,7,0))","v":"meier@online.de"}]
[]
[]
[null,163,100,14,null,null,{"$f":"(TODAY())","v":"2022-08-14"}]
[]
[null,"Position","Bezeichnung","Anzahl","Einheit","Summe","Betrag"]
[null,1,"Service 1",5,{"$f":"IF(ISBLANK(Tabelle10[[#This Row],[Bezeichnung]]),\"\",VLOOKUP(Tabelle10[[#This Row],[Bezeichnung]],'Stammdaten Leistungen'!$B$5:$D$1128,2,0))","v":"Std."},{"$f":"IF(ISBLANK(Tabelle10[[#This Row],[Bezeichnung]]),\"\",VLOOKUP(Tabelle10[[#This Row],[Bezeichnung]],'Stammdaten Leistungen'!$B$5:$D$627,3,0))","v":79.8},{"$f":"IF(Tabelle10[[#This Row],[Anzahl]]=\"\",Tabelle10[[#This Row],[Summe]],Tabelle10[[#This Row],[Anzahl]]*Tabelle10[[#This Row],[Summe]])","v":399}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Tabelle10[Betrag])","v":399}]

{"sheet":"Stammdaten Kunden","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,1,2,7],[0,1,0,7]]}
[]
[]
[null,"Stammdatentabelle Kundenverzeichnis"]
[null,"Kundennummer","Anrede","Name","Strasse","PLZ/Ort","Telefon","E-Mail"]
[null,100,"Herr","Michael Meier","Badstrasse 12b","12345 Badstadt","040 - 555 123","meier@online.de"]
[null,101,"Frau","Sabine Schüler","Poststrasse 34","56556 Poststadt","0123 - 666 555","Schüler@vodafone.de"]

{"sheet":"Stammdaten Leistungen","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,1,2,3],[0,1,0,3]]}
[]
[]
[null,"Stammdatentabelle Produkte |  Material &  Leistungen"]
[null,"Bezeichnung","Einheitencode","Preis je Einheit"]
[null,"Service 1","Std.",79.8]
[null,"Service 2","Std.",79.8]

{"sheet":"Historie Angebote","index":4,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,10],[0,1,0,10]]}
[]
[]
[null,"Übersichtsliste der erstellten Angebote"]
[null,"Angebots Nr.:","Angebotsdatum","KD.Nr.:","Name","Anschrift ","PLZ / Ort","Telefon","E-Mail","Angebot Summe","Angebote"]
[null,null,null,null,null,null,null,null,null,null,"Angebot ansehen"]

{"sheet":"Historie Rechnungen","index":5,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,1,2,13],[0,1,0,13]]}
[]
[]
[null,"Übersichtsliste der geschriebenen Rechnungen"]
[null,"RE-Nr.:","RE-Datum","KD.Nr.:","Name","Anschrift ","PLZ/Ort","Telefon","E-Mail","RE-Betrag","Zahlungsziel","Eingangsdatum","Status","Rechnung ansehen"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($C5),\"\",$C5+'Rechnung erstellen'!$D$24)","v":""},null,{"$f":"IF(ISBLANK($C5),\"\",IF($L5<>\"\",\"BEZAHLT\",IF(TODAY()>$K5,\"ÜBERFÄLLIG\",IF(TODAY()<=$K5,\"AUSSTEHEND\",\"\"))))","v":""},"PDF Rechnung"]