{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Rechnung"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Rechnung","index":0,"n_rows":56,"n_cols":28,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,15,1,16],[2,12,2,13],[2,15,2,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,{"$f":"YEAR(TODAY())","v":2025},{"$f":"MONTH(TODAY())","v":1},null,null,null,{"$f":"V5&CHAR(10)&V6&CHAR(10)&V7&CHAR(10)&V8&CHAR(10)&V9&CHAR(10)&V10&CHAR(10)&V11","v":"Stadtsparkasse\nMönchengladbach\nIBAN: DE 22 3105 0000 0000 092155\nBIC:   MGLSDE33\n\n\nUst-ID.:    DE 225 291 931"},null,{"$f":"X5&CHAR(10)&X6&CHAR(10)&X7&CHAR(10)&X8&CHAR(10)&X9&CHAR(10)&X10&CHAR(10)&X11","v":"Commerzbank\nMönchengladbach\nIBAN: DE 12 3108 0015 0953 479900\nBIC:   DRESDEFF310\n\n\nSt-Nr.:        121 / 5284 / 6245 "},null,{"$f":"Z5&CHAR(10)&Z6&CHAR(10)&Z7&CHAR(10)&Z8&CHAR(10)&Z9&CHAR(10)&Z10&CHAR(10)&Z11","v":"Deutsche Bank AG\nMönchengladbach\nIBAN: DE 80 3107 0024 0715 575700\nBIC:  DEUTDEDB310\n\n\nHRA-Nr.:       8568  "},null,{"$f":"AB5&CHAR(10)&AB6&CHAR(10)&AB7&CHAR(10)&AB8&CHAR(10)&AB9&CHAR(10)&AB10&CHAR(10)&AB11","v":"Inhaber:\nMichael Nöhlen e.K.\n\n\n\nMailadresse:  info@kluettermann-markisen.de\nInternet:    www.kluettermann-markisen.de "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mönchengladbach/Düsseldorf",null,"Mönchengladbach/Düsseldorf",null,"Mönchengladbach/Düsseldorf",null,"Mönchengladbach/Düsseldorf"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nur in dieser Zeile ändern >",null,"Stadtsparkasse",null,"Commerzbank",null,"Deutsche Bank AG",null,"Inhaber:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nur in dieser Zeile ändern >",null,"Mönchengladbach",null,"Mönchengladbach",null,"Mönchengladbach",null,"Michael Nöhlen e.K."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nur in dieser Zeile ändern >",null,"IBAN: DE 22 3105 0000 0000 092155",null,"IBAN: DE 12 3108 0015 0953 479900",null,"IBAN: DE 80 3107 0024 0715 575700"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nur in dieser Zeile ändern >",null,"BIC:   MGLSDE33",null,"BIC:   DRESDEFF310",null,"BIC:  DEUTDEDB310"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mailadresse:  info@kluettermann-markisen.de"]
[null,null,null,null,null,null,null,null,null,null,2500003,null,null,null,null,null,null,null,null,"Nur in dieser Zeile ändern >",null,"Ust-ID.:    DE 225 291 931",null,"St-Nr.:        121 / 5284 / 6245 ",null,"HRA-Nr.:       8568  ",null,"Internet:    www.kluettermann-markisen.de "]
[null,null,null,null,null,null,null,null,null,null,"Herrn"]
[null,null,null,null,null,null,null,null,null,null,"Dr."]
[null,{"$f":"IF($K$16>0,+$K$16,IF($K$17>0,+$K$17,$K$18&\" \"&$K$19))","v":"Muster Str. 2"},null,null,null,null,null,null,null,null,"Alfred"]
[null,{"$f":"IF(AND($K$16>0,$K$17>0),$K$17,IF(AND($K$16>0,$K$17=\"\"),$K$18&\" \"&$K$19,IF(AND($K$16=\"\",$K$17>0),$K$18&\" \"&$K$19,IF(AND($K$16=\"\",$K$17=\"\"),$K$20&\" \"&$K$21))))","v":"12345 Muster-Ort"},null,null,null,null,null,null,null,null,"E. Neumann"]
[null,{"$f":"IF(AND($K$16>0,$K$17>0),$K$18&\" \"&$K$19,IF(AND($K$16>0,$K$17=\"\"),$K$20&\" \"&$K$21,IF(AND($K$16=\"\",$K$17>0),$K$20&\" \"&$K$21,IF(AND($K$16=\"\",$K$17=\"\"),\"\"))))","v":""},null,null,null,null,null,null,null,"Heute ist:"]
[null,{"$f":"IF(AND($K$16>0,$K$17>0),$K$20&\" \"&$K$21,IF(AND($K$16>0,$K$17=\"\"),\"\",IF(AND($K$16=\"\",$K$17>0),\"\",IF(AND($K$16=\"\",$K$17=\"\"),\"\"))))","v":""},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-01-23"}]
[null,{"$f":"IF($K$22=\"\",\"\",$K$22)","v":""},null,null,null,null,null,null,null,"2025-01-23","Muster Str."]
[null,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())","v":2025},"2"]
[null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(J19,2)","v":"25"},"12345"]
[null,null,null,null,null,null,null,null,null,null,"Muster-Ort"]
[]
[null,{"$f":"TEXT(\"Rechnungs-Nr.   \",)&I23&\" - \"&TEXT(J23,\"0000\")","v":"Rechnungs-Nr.   25 - 2222"},null,{"$f":"\"Datum \"&TEXT(J18,\"TT.MM.JJJJ\")","v":"Datum 23.01.2025"},"kk",null,null,null,{"$f":"TEXT(J18,\"JJ\")","v":"25"},2222]
[]
[null,"Lieferungen und Leistungen","Menge / Std.","Einzelpreis","Gesamtpreis"]
[null,null,null,null,{"$f":"IF(D26=\"\",\"\",+C26*D26)","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"IF(IFERROR(FIND(\"Rechnungskorrektur-Nr.\",#REF!,1),0),LEFT(#REF!,18),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,"Waschbecken",1,485,485]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,"Netto",{"$f":"SUM($E$26:$E$50)","v":485}]
[null,null,null,{"$f":"+$O$1","v":19},{"$f":"SUM(E51)*$O$1/100","v":92.15}]
[null,null,null,"Brutto",{"$f":"SUM(E51:E52)","v":577.15}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]