{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Adressen","Rechnungen"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":42,"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":"Adressen","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"✔",{"$f":"COUNTIF(B6:B297,E1)","v":3}]
[]
[{"$f":"COUNTIF(A6:A8,\"X\")","v":3},{"$f":"A3+A4","v":3},{"$f":"I4-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"C3/35000","v":{"$error":"#REF!"}},null,{"$f":"#REF!+I4","v":{"$error":"#REF!"}},{"$f":"I4-52167","v":-52167},null,"inkl. MWSt"]
[]
["Auftrag","Status","Firma","Straße","PLZ","Ort","Ansprech-partner","Paket","Auftrag netto ","Mwst","Re.-Betrag","Re Nr","Re Datum"]
["X","✔","Musterfirma","Musterweg 3",99999,"Musterstadt","Max Mustermann","Exklusiv",250,{"$f":"I6*19%","v":47.5},{"$f":"I6+J6","v":297.5},"2025-0001","2025-02-10"]
["X","✔","Muster AG","Musterstraße 5",99990,"Musterort","Moritz ","Premium",500,{"$f":"I7*19%","v":95},{"$f":"I7+J7","v":595},"2025-0002","2025-02-10"]
["X","✔","Muster","Mustergasse 7",99992,"Musterdorf","Gustav Schatz","Spezial",1000,{"$f":"I8*19%","v":190},{"$f":"I8+J8","v":1190},"2025-0003","2025-02-10"]

{"sheet":"Rechnungen","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[41,0,41,6],[17,2,17,3],[15,0,15,6],[0,2,1,6],[34,0,34,6],[35,0,35,6],[4,0,4,4],[40,0,40,6],[18,1,18,3]]}
[]
[]
[]
["Firma Test - Teststrasse 1 - 76767 Testhausen"]
["Musterfirma"]
[{"$f":"VLOOKUP(A5,Adressen!C6:M97,5,0)","v":"Max Mustermann"}]
[{"$f":"VLOOKUP(A5,Adressen!C6:M97,2,0)","v":"Musterweg 3"}]
[{"$f":"VLOOKUP(A5,Adressen!C6:M97,3,0)&\" \"&VLOOKUP(A5,Adressen!C6:M97,4,0)","v":"99999 Musterstadt"}]
[]
[]
[]
[null,null,null,null,null,"Rechnungs-Nr","Datum"]
[null,null,null,null,null,{"$f":"VLOOKUP(A5,Adressen!C6:M10,10,0)","v":"2025-0001"},"2025-01-15"]
[]
["Wie vereinbart, berechnen wir folgende Positionen"]
[]
[]
["Menge",null,null,null,null,"Einzelpreis","Gesamt"]
[1,{"$f":"VLOOKUP(A5,Adressen!C6:M10,6,0)","v":"Exklusiv"},null,null,null,{"$f":"VLOOKUP(A5,Adressen!C6:M10,7,0)","v":250},{"$f":"IF(A19=\"\",\"\",A19*F19)","v":250}]
[null,null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",F20*$G$18)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",F21*$G$18)","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G19:G19)","v":250}]
[null,null,null,null,null,"+19% UST",{"$f":"G22*19%","v":47.5}]
[null,null,null,null,null,"Rechnungsbetrag",{"$f":"SUM(G22:G23)","v":297.5}]
[]
[]
["Bitte überweisen Sie den Rechnungsbetrag innerhalb 10 Tage, ohne Abzug, auf folgendes Konto:"]
[{"$f":"IF(G18=0,\"Gemäß §13b USTG geht die Umsatzsteuerschuld auf den Auftraggeber bzw. Rechnungsempfänger über.\",\"\")","v":""}]
["Test"]
["Sparkasse"]
["IBAN: ","DE99 0000 0000 9999 99"]
["BIC: ","BLTESTAK"]