{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Titelblatt","Forderungen","Vorauszahlungen an Lieferanten","Angef. Arbeiten","Vorräte","Trans. Aktiven","Verbindlichkeiten","Anzahlungen von Kunden","Trans. Passiven","Modul2","Texte"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":24,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Modul2","index":9,"reason":"part_missing"}],"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":"Titelblatt","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[12,1,13,3],[13,0,14,0],[32,1,33,3],[33,0,34,0],[16,1,17,3],[20,1,21,3],[24,1,25,3],[28,1,29,3],[36,1,37,3],[17,0,18,0],[21,0,22,0],[25,0,26,0],[29,0,30,0],[37,0,38,0],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[9,0,10,0],[8,1,9,3]]}
[]
[{"$f":"Texte!A2","v":"Folgendes ist bei der Excel-Vorlage zu beachten"}]
[{"$f":"Texte!A3","v":"Um die Vorlage uneingeschränkt nutzen zu können, müssen Makros aktiviert sein. Die Datei muss immer als Excel-Arbeitsmappe mit Makros (.xlsm) gespeichert werden."}]
[{"$f":"Texte!A4","v":"Der Ausdruck sollte über die Schaltfläche «Liste drucken» erfolgen. Die Liste wird dabei nach Kunde/Lieferanten alphabetisch sortiert und Leerzeilen werden ausgeblendet. Der Druck erscheint immer zuerst in der Vorschau, wo allenfalls noch Anpassungen vorgenommen werden können (z. B. Seitenränder, Druckerauswahl, etc.)."}]
[{"$f":"Texte!A5","v":"Die Liste kann auch über die Schaltfläche «Zusammenfassung drucken» gedruckt werden. In der Liste werden dabei nur die Summen pro Konto abgebildet. Der Druck erscheint auch hier immer zuerst in der Vorschau."}]
[{"$f":"Texte!A6","v":"Name der Unternehmung:"},null,{"$f":"Texte!A7","v":"Abschlusslisten per:"}]
[null,null,{"$f":"Texte!A8","v":"Stichtag:"},"2025-12-31"]
[]
[{"$f":"Texte!A9","v":"Liste der Forderungen"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A10","v":"An Kunden ausgestellte Rechnungen, die zum Stichtag nicht bezahlt waren"}]
[]
[]
[{"$f":"Texte!A11","v":"Liste der Vorauszahlungen an Lieferanten"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A12","v":"Per Stichdatum verbuchte oder bezahlte Lieferantenrechnungen, bei denen die Lieferung erst nach dem Stichtag erfolgt"}]
[]
[]
[{"$f":"Texte!A13","v":"Liste der angefangenen Arbeiten"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A14","v":"Bis zum Stichtag geleistete, aber per Stichtag noch nicht fakturierte Leistungen, bewertet zu Einstandspreisen"}]
[]
[]
[{"$f":"Texte!A15","v":"Liste der Waren- und Materialvorräte"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A16","v":"Per Stichtag an Lager gehaltene Waren und Materialien, bewertet zu Anschaffungs- oder Herstellungskosten"}]
[]
[]
[{"$f":"Texte!A17","v":"Liste der transitorischen Aktiven"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A18","v":"Bis zum Stichtag bezahlte oder verbuchte Aufwendungen, die das nächste Geschäftsjahr betreffen oder noch nicht erhaltene Erträge für das aktuelle Geschäftsjahr"}]
[]
[]
[{"$f":"Texte!A19","v":"Liste der Verbindlichkeiten"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A20","v":"Per Stichdatum unbezahlte Lieferanten- und Unkostenrechnungen, die das aktuelle Geschäftsjahr betreffen"}]
[]
[]
[{"$f":"Texte!A21","v":"Liste der Anzahlungen von Kunden"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A22","v":"An Kunden ausgestellte Rechnungen oder von Kunden erhaltene Zahlungen, bei denen die Leistung erst nach dem Stichtag erbracht wird"}]
[]
[]
[{"$f":"Texte!A23","v":"Liste der transitorischen Passiven"},{"$f":"Texte!A$51","v":"Erstellen / Bearbeiten"}]
[{"$f":"Texte!A24","v":"Bis zum Stichtag nicht bezahlte oder nicht verbuchte Aufwendungen, die das aktuelle Geschäftsjahr betreffen oder erhaltene Erträge für das nächste Geschäftsjahr"}]

{"sheet":"Forderungen","index":1,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[3,0,3,4],[2,0,2,7],[3,9,4,9]]}
[]
[{"$f":"Texte!A9","v":"Liste der Forderungen"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A10","v":"An Kunden ausgestellte Rechnungen, die zum Stichtag nicht bezahlt waren"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A28","v":"Name des Kunden"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Vorauszahlungen an Lieferanten","index":2,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,0,3,4],[3,9,4,9]]}
[]
[{"$f":"Texte!A11","v":"Liste der Vorauszahlungen an Lieferanten"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A12","v":"Per Stichdatum verbuchte oder bezahlte Lieferantenrechnungen, bei denen die Lieferung erst nach dem Stichtag erfolgt"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A48","v":"Name des Lieferanten"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Angef. Arbeiten","index":3,"n_rows":203,"n_cols":11,"rows_kept":203,"cut":false,"hidden":false,"merged":[[3,0,3,3],[2,0,2,7],[3,10,4,10]]}
[]
[{"$f":"Texte!A13","v":"Liste der angefangenen Arbeiten"},null,null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A14","v":"Bis zum Stichtag geleistete, aber per Stichtag noch nicht fakturierte Leistungen, bewertet zu Einstandspreisen"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A28","v":"Name des Kunden"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A35","v":"Arbeitsanteil\nin CHF"},{"$f":"Texte!A36","v":"Materialanteil\nFremdarbeiten\nin CHF"},{"$f":"Texte!A37","v":"Gewinnanteil\nin CHF"},{"$f":"Texte!A38","v":"Total\nin CHF"},{"$f":"Texte!A39","v":"Datum der Rechnung im Folgejahr"},{"$f":"Texte!A40","v":"Betrag der Rechnung im Folgejahr"}]
[null,null,"-",null,null,null,{"$f":"SUM(D7:F7)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D39:F39)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D71:F71)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D103:F103)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D135:F135)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D167:F167)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,{"$f":"SUM(D199:F199)","v":0}]
[null,null,"-",null,null,null,0]
[null,null,"-",null,null,null,0]
[]
[null,null,null,{"$f":"SUBTOTAL(9,D7:D201)","v":0},{"$f":"SUBTOTAL(9,E7:E201)","v":0},{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},null,{"$f":"SUBTOTAL(9,I7:I201)","v":0}]

{"sheet":"Vorräte","index":4,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,9,4,9],[3,1,3,4]]}
[]
[null,{"$f":"Texte!A15","v":"Liste der Waren- und Materialvorräte"},null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A16","v":"Per Stichtag an Lager gehaltene Waren und Materialien, bewertet zu Anschaffungs- oder Herstellungskosten"}]
[null,{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
["Datum der Rechnung",{"$f":"Texte!A41","v":"Bezeichnung 1"},{"$f":"Texte!A42","v":"Bezeichnung 2"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A43","v":"Einheit"},{"$f":"Texte!A44","v":"Einheitspreis\nCHF"},{"$f":"Texte!A45","v":"Menge"},{"$f":"Texte!A46","v":"Inventarwert\nCHF"}]
[null,null,null,"-","Stk",null,null,{"$f":"+F7*G7","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F39*G39","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F71*G71","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F103*G103","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F135*G135","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F167*G167","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,{"$f":"+F199*G199","v":0}]
[null,null,null,"-","Stk",null,null,0]
[null,null,null,"-","Stk",null,null,0]
[]
[null,"Total",null,null,null,null,null,{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Trans. Aktiven","index":5,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[3,0,3,4],[2,0,2,7],[3,9,4,9]]}
[]
[{"$f":"Texte!A17","v":"Liste der transitorischen Aktiven"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A18","v":"Bis zum Stichtag bezahlte oder verbuchte Aufwendungen, die das nächste Geschäftsjahr betreffen oder noch nicht erhaltene Erträge für das aktuelle Geschäftsjahr"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A47","v":"Name des Lieferanten/Kunden"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Verbindlichkeiten","index":6,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[3,0,3,4],[2,0,2,7],[3,9,4,9]]}
[]
[{"$f":"Texte!A19","v":"Liste der Verbindlichkeiten"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A20","v":"Per Stichdatum unbezahlte Lieferanten- und Unkostenrechnungen, die das aktuelle Geschäftsjahr betreffen"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A48","v":"Name des Lieferanten"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Anzahlungen von Kunden","index":7,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[2,0,2,7],[3,0,3,4],[3,9,4,9]]}
[]
[{"$f":"Texte!A21","v":"Liste der Anzahlungen von Kunden"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A22","v":"An Kunden ausgestellte Rechnungen oder von Kunden erhaltene Zahlungen, bei denen die Leistung erst nach dem Stichtag erbracht wird"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A28","v":"Name des Kunden"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Trans. Passiven","index":8,"n_rows":203,"n_cols":10,"rows_kept":203,"cut":false,"hidden":false,"merged":[[3,0,3,4],[2,0,2,7],[3,9,4,9]]}
[]
[{"$f":"Texte!A23","v":"Liste der transitorischen Passiven"},null,null,null,null,null,null,null,null,{"$f":"Texte!A49","v":"Liste drucken"}]
[{"$f":"Texte!A24","v":"Bis zum Stichtag nicht bezahlte oder nicht verbuchte Aufwendungen, die das aktuelle Geschäftsjahr betreffen oder erhaltene Erträge für das nächste Geschäftsjahr"}]
[{"$f":"IF(Titelblatt!A7=\"\",Texte!A25,Titelblatt!A7)","v":"Name in Titelblatt eingeben"},null,null,null,null,null,{"$f":"Texte!A26","v":"Stichdatum:"},{"$f":"Titelblatt!$D$7","v":"2025-12-31"},null,{"$f":"Texte!A50","v":"Zusammenfassung drucken"}]
[]
[{"$f":"Texte!A27","v":"Datum der Rechnung"},{"$f":"Texte!A48","v":"Name des Lieferanten"},{"$f":"Texte!A29","v":"Betreff"},{"$f":"Texte!A30","v":"Konto"},{"$f":"Texte!A31","v":"MWST\n%"},{"$f":"Texte!A32","v":"Bruttobetrag\nCHF"},{"$f":"Texte!A33","v":"MWST\nCHF"},{"$f":"Texte!A34","v":"Nettobetrag\nCHF"}]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E7=100%,F7,ROUND((F7*E7/(100%+E7))*20,0)/20)","v":0},{"$f":"SUM(F7-G7)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E39=100%,F39,ROUND((F39*E39/(100%+E39))*20,0)/20)","v":0},{"$f":"SUM(F39-G39)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E71=100%,F71,ROUND((F71*E71/(100%+E71))*20,0)/20)","v":0},{"$f":"SUM(F71-G71)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E103=100%,F103,ROUND((F103*E103/(100%+E103))*20,0)/20)","v":0},{"$f":"SUM(F103-G103)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E135=100%,F135,ROUND((F135*E135/(100%+E135))*20,0)/20)","v":0},{"$f":"SUM(F135-G135)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,{"$f":"IF(E167=100%,F167,ROUND((F167*E167/(100%+E167))*20,0)/20)","v":0},{"$f":"SUM(F167-G167)","v":0}]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,"-",8.1000000000000003E-2,null,0,0]
[null,null,null,null,8.1000000000000003E-2,null,{"$f":"IF(E199=100%,F199,ROUND((F199*E199/(100%+E199))*20,0)/20)","v":0},{"$f":"SUM(F199-G199)","v":0}]
[null,null,null,null,8.1000000000000003E-2,null,0,0]
[null,null,null,null,8.1000000000000003E-2,null,0,0]
[]
[null,"Total",null,null,null,{"$f":"SUBTOTAL(9,F7:F201)","v":0},{"$f":"SUBTOTAL(9,G7:G201)","v":0},{"$f":"SUBTOTAL(9,H7:H201)","v":0}]

{"sheet":"Texte","index":10,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Texte verwendet / Texte utilisé","deutsch","français",1]
[{"$f":"IF($D$1=1,B2,C2)","v":"Folgendes ist bei der Excel-Vorlage zu beachten"},"Folgendes ist bei der Excel-Vorlage zu beachten","Attention de considérer les points suivants avant l'utilisation de ce modèle excel"]
[{"$f":"IF($D$1=1,B3,C3)","v":"Um die Vorlage uneingeschränkt nutzen zu können, müssen Makros aktiviert sein. Die Datei muss immer als Excel-Arbeitsmappe mit Makros (.xlsm) gespeichert werden."},"Um die Vorlage uneingeschränkt nutzen zu können, müssen Makros aktiviert sein. Die Datei muss immer als Excel-Arbeitsmappe mit Makros (.xlsm) gespeichert werden.","Afin de pouvoir utiliser ce modèle dans son intégralité, il est indispensable que les macros soient activées. Pour ce faire, le document doit être enregistré entant que fichier excel avec macros (.xlsm)."]
["Der Ausdruck sollte über die Schaltfläche «Liste drucken» erfolgen. Die Liste wird dabei nach Kunde/Lieferanten alphabetisch sortiert und Leerzeilen werden ausgeblendet. Der Druck erscheint immer zuerst in der Vorschau, wo allenfalls noch Anpassungen vorgenommen werden können (z. B. Seitenränder, Druckerauswahl, etc.).","Der Ausdruck sollte über die Schaltfläche «Liste drucken» erfolgen. Die Liste wird dabei nach Kunde/Lieferanten alphabetisch sortiert und Leerzeilen werden ausgeblendet. Der Druck erscheint immer zuerst in der Vorschau, wo allenfalls noch Anpassungen vorgenommen werden können (z. B. Seitenränder, Druckerauswahl, etc.).","L'impression doit se faire par le biais du bouton «Impression liste». Ceci permet de réorganiser automatiquement les données par nom de client/fournisseur et de rendre invisible les lignes vides. L'impression se présente ensuite sous la forme d'un apreçu, dans lequel il possible de faire des ajustements (ex: réglage des marges, choix de l'imprimante, etc.)."]
["Die Liste kann auch über die Schaltfläche «Zusammenfassung drucken» gedruckt werden. In der Liste werden dabei nur die Summen pro Konto abgebildet. Der Druck erscheint auch hier immer zuerst in der Vorschau.","Die Liste kann auch über die Schaltfläche «Zusammenfassung drucken» gedruckt werden. In der Liste werden dabei nur die Summen pro Konto abgebildet. Der Druck erscheint auch hier immer zuerst in der Vorschau.","Les listes peuvent également être imprimées en sélectionnant le bouton «Impression regroupée». Cette fonction, similaire à la précédente, ne va alors afficher que la somme des écritures pour chaques comptes. "]
["Name der Unternehmung:","Name der Unternehmung:","Nom de la société"]
["Abschlusslisten per:","Abschlusslisten per:","Liste de bouclement au :"]
["Stichtag:","Stichtag:","Date valeur :"]
["Liste der Forderungen","Liste der Forderungen","Liste des débiteurs"]
["An Kunden ausgestellte Rechnungen, die zum Stichtag nicht bezahlt waren","An Kunden ausgestellte Rechnungen, die zum Stichtag nicht bezahlt waren","Factures émises aux clients étant encore impayées à la date du bouclement"]
[{"$f":"IF($D$1=1,B11,C11)","v":"Liste der Vorauszahlungen an Lieferanten"},"Liste der Vorauszahlungen an Lieferanten","Liste des acomptes aux fournisseurs\n"]
["Per Stichdatum verbuchte oder bezahlte Lieferantenrechnungen, bei denen die Lieferung erst nach dem Stichtag erfolgt","Per Stichdatum verbuchte oder bezahlte Lieferantenrechnungen, bei denen die Lieferung erst nach dem Stichtag erfolgt","Paiements ou comptabilisations de factures fournisseurs avant la date de clôture pour lesquelles la prestation/livraison n’est fournie que dans le prochain exercice."]
["Liste der angefangenen Arbeiten","Liste der angefangenen Arbeiten","Liste des travaux en cours\n"]
["Bis zum Stichtag geleistete, aber per Stichtag noch nicht fakturierte Leistungen, bewertet zu Einstandspreisen","Bis zum Stichtag geleistete, aber per Stichtag noch nicht fakturierte Leistungen, bewertet zu Einstandspreisen","Travaux effectués durant l'année n'ayant pas encore été facturés à la date du bouclement. Considérer les valeurs au prix de revient."]
["Liste der Waren- und Materialvorräte","Liste der Waren- und Materialvorräte","Liste des stocks de marchandises et de matériels"]
["Per Stichtag an Lager gehaltene Waren und Materialien, bewertet zu Anschaffungs- oder Herstellungskosten","Per Stichtag an Lager gehaltene Waren und Materialien, bewertet zu Anschaffungs- oder Herstellungskosten","Marchandises et matériels en stock à la date du bouclement. Considérer les valeurs au prix d'achat ou aux coûts de fabrication."]
["Liste der transitorischen Aktiven","Liste der transitorischen Aktiven","Liste des actifs transitoires\n"]
["Bis zum Stichtag bezahlte oder verbuchte Aufwendungen, die das nächste Geschäftsjahr betreffen oder noch nicht erhaltene Erträge für das aktuelle Geschäftsjahr","Bis zum Stichtag bezahlte oder verbuchte Aufwendungen, die das nächste Geschäftsjahr betreffen oder noch nicht erhaltene Erträge für das aktuelle Geschäftsjahr","Produits se rapportant à l'exercice actuel n'ayant pas été perçus à la date du bouclement. Ainsi que les charges payées/comptabilisées durant l'année concernant l'exercice suivant."]
["Liste der Verbindlichkeiten","Liste der Verbindlichkeiten","Liste des créanciers\n"]
["Per Stichdatum unbezahlte Lieferanten- und Unkostenrechnungen, die das aktuelle Geschäftsjahr betreffen","Per Stichdatum unbezahlte Lieferanten- und Unkostenrechnungen, die das aktuelle Geschäftsjahr betreffen","Factures de fournisseurs et d'autres charges émisent avant la date du bouclement et se rapportant à l'exercice actuel n'ayant pas encore été payées."]
[{"$f":"IF($D$1=1,B21,C21)","v":"Liste der Anzahlungen von Kunden"},"Liste der Anzahlungen von Kunden","Liste des acomptes de clients\n"]
["An Kunden ausgestellte Rechnungen oder von Kunden erhaltene Zahlungen, bei denen die Leistung erst nach dem Stichtag erbracht wird","An Kunden ausgestellte Rechnungen oder von Kunden erhaltene Zahlungen, bei denen die Leistung erst nach dem Stichtag erbracht wird","Facturation à des clients ou paiements de la part de clients avant la date de clôture pour lesquels la prestation/livraison n’est fournie que dans le prochain exercice."]
["Liste der transitorischen Passiven","Liste der transitorischen Passiven","Liste des passifs transitoires\n"]
["Bis zum Stichtag nicht bezahlte oder nicht verbuchte Aufwendungen, die das aktuelle Geschäftsjahr betreffen oder erhaltene Erträge für das nächste Geschäftsjahr","Bis zum Stichtag nicht bezahlte oder nicht verbuchte Aufwendungen, die das aktuelle Geschäftsjahr betreffen oder erhaltene Erträge für das nächste Geschäftsjahr","Charges se rapportant à l'exercice actuel n'ayant pas été payées à la date du bouclement. Ainsi que les produits perçus/comptabilisés durant l'année concernant l'exercice suivant."]
[{"$f":"IF($D$1=1,B25,C25)","v":"Name in Titelblatt eingeben"},"Name in Titelblatt eingeben","Introduire le nom dans la page de titre"]
["Stichdatum:","Stichdatum:","Date valeur :"]
["Datum der Rechnung","Datum der Rechnung","Date de la facture"]
["Name des Kunden","Name des Kunden","Nom du client"]
["Betreff","Betreff","Descriptif"]
["Konto","Konto","Compte"]
["MWST\n%","MWST\n%","TVA\n%"]
["Bruttobetrag\nCHF","Bruttobetrag\nCHF","Montant brut\nCHF"]
["MWST\nCHF","MWST\nCHF","TVA\nCHF"]
["Nettobetrag\nCHF","Nettobetrag\nCHF","Montant net\nCHF"]
["Arbeitsanteil\nin CHF","Arbeitsanteil\nin CHF","Part travail\nen CHF"]
["Materialanteil\nFremdarbeiten\nin CHF","Materialanteil\nFremdarbeiten\nin CHF","Part matériel\nTravaux de tiers\nen CHF"]
["Gewinnanteil\nin CHF","Gewinnanteil\nin CHF","Marge\nen CHF"]
["Total\nin CHF","Total\nin CHF","Total\nen CHF"]
["Datum der Rechnung im Folgejahr","Datum der Rechnung im Folgejahr","Date de la facture dans l'année suivante"]
["Betrag der Rechnung im Folgejahr","Betrag der Rechnung im Folgejahr","Montant de la facture dans l'année suivante"]
["Bezeichnung 1","Bezeichnung 1","Descriptif 1"]
["Bezeichnung 2","Bezeichnung 2","Descriptif 2"]
["Einheit","Einheit","Unité"]
["Einheitspreis\nCHF","Einheitspreis\nCHF","Prix unitaire\nCHF"]
["Menge","Menge","Quantité"]
["Inventarwert\nCHF","Inventarwert\nCHF","Valeur d'inventaire\nCHF"]
["Name des Lieferanten/Kunden","Name des Lieferanten/Kunden","Nom du fournisseur/client"]
["Name des Lieferanten","Name des Lieferanten","Nom du fournisseur"]
["Liste drucken","Liste drucken","Impression liste"]
["Zusammenfassung drucken","Zusammenfassung drucken","Impression regroupée"]
[{"$f":"IF($D$1=1,B51,C51)","v":"Erstellen / Bearbeiten"},"Erstellen / Bearbeiten","établir / éditer"]