{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Muster"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":66,"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":"Muster","index":0,"n_rows":51,"n_cols":21,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,15,2,16],[25,14,26,14],[36,14,36,15]]}
[null,null,null,"Musterfrau",null,null,null,19,null,null,null,null,null,null,null,null,{"$f":"YEAR(TODAY())","v":2025},{"$f":"MONTH(TODAY())","v":1}]
[]
[null,null,null,null,null,null,null,null,"Dieser Bereich ist "]
[null,null,null,null,null,null,null,null,"außerhalb des "]
[null,null,null,null,null,null,null,null,"Druckbereiches und "]
[null,null,null,null,null,null,null,null,"muss eingeblendet sein !"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,"2500002","< Kundennummer",null,"",null,null,""]
[null,{"$f":"IF($O$12=\"\",\"\",$O$12)","v":"Frau"}," ",null,null,null,"< Zeile 12 Schrift Anfang",null,{"$f":"+H28","v":"2025-01-22"},"Reverse Charge",null,null,null,null,"Frau","< Anrede oder Firmenname"]
[null,{"$f":"IF($O$12=\"\",\"\",IF(AND($O$13>0,$O$15>0),$O$13&\" \"&$O$14&\" \"&$O$15,IF(AND($O$13=\"\",$O$14=\"\"),$O$15,IF(AND($O$13=\"\",$O$14>0),$O$14&\" \"&$O$15))))","v":"sigrid Musterfrau"},null,null,null,null,null,null,null,null,null,null,null,null,null,"< Titel-       Prof./Dr. "]
[null,{"$f":"IF($O$16>0,+$O$16,IF($O$17>0,+$O$17,$O$18&\" \"&$O$19))","v":"Muster str. 1"},null,null,null,null,null,null,null,null,null,null,null,null,"sigrid","< VORNAME"]
[null,{"$f":"IF(AND($O$16>0,$O$17>0),$O$17,IF(AND($O$16>0,$O$17=\"\"),$O$18&\" \"&$O$19,IF(AND($O$16=\"\",$O$17>0),$O$18&\" \"&$O$19,IF(AND($O$16=\"\",$O$17=\"\"),$O$20&\" \"&$O$21))))","v":"12345 Musterstadt"},null,null,null,null,null,null,null,null,null,null,null,null,"Musterfrau","< Kundenname oder 1. Firmenname "]
[null,{"$f":"IF(AND($O$16>0,$O$17>0),$O$18&\" \"&$O$19,IF(AND($O$16>0,$O$17=\"\"),$O$20&\" \"&$O$21,IF(AND($O$16=\"\",$O$17>0),$O$20&\" \"&$O$21,IF(AND($O$16=\"\",$O$17=\"\"),\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"< 2. Firmenname"]
[null,{"$f":"IF(AND($O$16>0,$O$17>0),$O$20&\" \"&$O$21,IF(AND($O$16>0,$O$17=\"\"),\"\",IF(AND($O$16=\"\",$O$17>0),\"\",IF(AND($O$16=\"\",$O$17=\"\"),\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"< Ansprechpartner / Hinweise / Postfach"]
[null,{"$f":"IF($O$22=\"\",\"\",$O$22)","v":""},null,null,null,null,"< Zeile 18",null,null,null,null,null,null,null,"Muster str.","< Straße"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"< Straße Nummer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12345","< Postleitzahl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Musterstadt","< Ort"]
[null,null,null,null,null,null,"<<< Seite 1",null,null,null,null,null,null,null,null,"< LAND "]
[null,{"$f":"TEXT(\"Rechnungs-Nr.   \",)&G23&\" - \"&TEXT(H23,\"0000\")","v":"Rechnungs-Nr.   25 - 9123"},null,{"$f":"\"Datum \"&TEXT(H29,\"TT.MM.JJJJ\")","v":"Datum 21.01.2025"},"AN",null,25,9123,null,null,null,null,null,null,null,"< Kunde erfasst: DATUM"]
[null,null,null,"Kunden-Nr.:",{"$f":"+O11","v":"2500002"},null,null,{"$f":"G23&\" - \"&TEXT(H23,\"0000\")","v":"25 - 9123"},null,null,null,null,null,null,"w","< Mailadresse muss bei Firmen !"]
[null,"Lieferungen und Leistungen","Menge / Std.","Einzelpreis","Netto-Preis"]
[null,null,null,null,{"$f":"IF(D26=\"\",\"\",+C26*D26)","v":""}]
[null,"",null,null,"",null,"<<< anfang text","Heute ist:"]
[null,"",null,null,"",null,null,{"$f":"TODAY()","v":"2025-01-22"}]
[null,"",null,null,"",null,"Rg.-Datum >","2025-01-21",null,null,null,null,null,null,"Straße und Nr.:",{"$f":"+O18 &\" \"& O19","v":"Muster str. 1"}]
[null,"",null,null,"",null,null,{"$f":"YEAR(TODAY())","v":2025},null,null,null,null,null,null,"Name der aktuellen Tabelle:",{"$f":"MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,255)","v":"Muster"}]
[null,null,null,null,"",null,null,{"$f":"RIGHT(H30,2)","v":"25"},null,null,null,null,null,null,"Bearbeitung durch Firma:",{"$f":"MID(P30,9,11)","v":""}]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"Firmen-Nachname zum Speichern:",{"$f":"LEFT(+O15,30)","v":"Musterfrau"}]
[null,"kompl.Wanne",1,1250,1250,null,null,null,null,null,null,null,null,null,"Version der Rechnungsvorlage:","Muster1"]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"Rechnungskorrektur wird automatisch hier eingesetzt:"]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"letzte Aktualisierung:","2025-01-21"]
[null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"Nur zur Info, kontrolle"]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"ist Endpreis Netto:"]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"ist MwSt:"]
[null,null,null,null,"",null,null,null,null,null,null,null,null,null,"ist Endpreis Brutto:"]
[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,{"$f":"SUM($E$26:$E$50)","v":1250},null,"<<< Seite 1"]