{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Titelblatt","Flümi","Forderungen","übr. Guthaben","Angef. Arbeiten","Materialvorräte","Hilfsmaterial","Halbfabrikate","Fertigfabrikate","Verbindlichkeiten","übr. Schulden","Ergänzung"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":11,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,7],[3,0,4,10],[2,0,2,4],[23,2,25,9],[16,5,16,8],[8,1,8,9],[26,2,26,6],[18,5,18,8],[19,5,19,8],[12,5,12,8],[13,5,13,8],[14,5,14,8],[15,5,15,8]]}
["Titelblatt",{"$nulls":9},"Inventar"]
[{"$f":"CONCATENATE(F13,\", \",F17)","v":", "},{"$nulls":9},"© Trewim AG, Romanshorn"]
[{"$f":"F19","v":"00:00:00"},{"$nulls":9},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"INVENTAR PER \",TEXT(F19,\"TT.MM.JJJJ\"))","v":"INVENTAR PER 00.01.1900"}]
[]
[]
[]
[null,null,"Firma:"]
[null,null,"Branche:"]
[null,null,"Strasse:"]
[null,null,"PLZ:"]
[null,null,"Ort:"]
[]
[null,null,"Abschlussdatum:"]
[null,null,"Stichtag der Inventur:"]
[]
[]
[]
[null,null,"Die nachstehenden Angaben stimmen mit unseren Unterlagen und Belegen überein und entsprechen der Wahrheit:"]
[]
[]
[null,null,{"$f":"CONCATENATE(F17,\", \",TEXT(F20,\"TT.MM.JJJJ\"),\":\")","v":", 00.01.1900:"}]
[]
[]
[]
[null,null,"Stempel und Unterschrift"]

{"sheet":"Flümi","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,4,5]]}
["Flüssige Mittel",{"$nulls":4},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":4},"© Trewim AG, Amriswil"]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":4},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["1. Tatsächlicher, kontrollierter Kassabestand:",null,null,null,"CHF"]
[]
[{"$f":"CONCATENATE(\"2. Saldo Post-/Bank-/WIR-Konti per \",TEXT(A3,\"TT.MM.JJJJ\"),\":\")","v":"2. Saldo Post-/Bank-/WIR-Konti per 00.01.1900:"}]
[]
["Währung","Art","Bank","Konto-Nr.","Limite","Saldo"]
{"$rows_empty":13}
["3. Wertschriften / Anteilscheine"]
[]
["Währung","Anzahl","Art","Firma / Schuldner","Einstand","Aktueller Wert"]

{"sheet":"Forderungen","index":2,"n_rows":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,4,6]]}
["Forderungen / Debitoren",{"$nulls":5},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":5},{"$f":"Flümi!F2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":5},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["4. Forderungen (offene Debitoren)"]
["Alle per Bilanzstichtag fakturierten und noch nicht bezahlten Forderungen, abzüglich der zu erwartenden Skonti"]
[]
["Name, Wohnort Kunde","RG-Datum","Betrag Brutto CHF","davon Gefährdete","MWSt %","MWSt-Betrag","Betrag netto CHF"]
[{"$nulls":4},7.6999999999999999E-2,{"$f":"((C11+-D11)/(E11+1))*E11","v":0},{"$f":"((C11-D11)/(E11+1))*1","v":0}]
[{"$nulls":4},{"$f":"E11","v":7.6999999999999999E-2},{"$f":"((C12+-D12)/(E12+1))*E12","v":0},{"$f":"((C12-D12)/(E12+1))*1","v":0}]
[{"$nulls":4},{"$f":"E12","v":7.6999999999999999E-2},0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,{"$f":"((C76+-D76)/(E76+1))*E76","v":0},{"$f":"((C76-D76)/(E76+1))*1","v":0}]
[{"$nulls":4},{"$f":"E76","v":7.6999999999999999E-2},0,0]
[{"$nulls":4},7.6999999999999999E-2,{"$f":"((C78+-D78)/(E78+1))*E78","v":0},{"$f":"((C78-D78)/(E78+1))*1","v":0}]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,{"$f":"((C86+-D86)/(E86+1))*E86","v":0},{"$f":"((C86-D86)/(E86+1))*1","v":0}]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
[{"$nulls":4},7.6999999999999999E-2,0,0]
["TOTAL Forderungen",null,{"$f":"SUM(C11:C93)","v":0},{"$f":"SUM(D11:D93)","v":0},null,{"$f":"SUM(F11:F93)","v":0},{"$f":"SUM(G11:G93)","v":0}]

{"sheet":"übr. Guthaben","index":3,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,4,6]]}
["Übrige Guthaben",{"$nulls":5},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":5},{"$f":"Flümi!F2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":5},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["5. Übrige Guthaben"]
["Das vergangene Geschäftsjahr betreffende Guthaben (Rückzahlungen, Anzahlungen, AHV, Umsatzvergüt., Boni, etc."]
[]
["Name, Wohnort Schuldner","Konto","Betrag Brutto CHF","davon Gefährdete","MWSt %","MWSt-Betrag","Betrag netto CHF"]
[null,null,null,0,null,{"$f":"(((C11+-D11)/(E11+1))*E11)","v":0},{"$f":"(((C11-D11)/(E11+1))*1)","v":0}]
[{"$nulls":4},{"$f":"E11","v":0},{"$f":"(((C12+-D12)/(E12+1))*E12)","v":0},{"$f":"(((C12-D12)/(E12+1))*1)","v":0}]
[{"$nulls":4},{"$f":"E12","v":0},0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
["TOTAL übrige Guthaben",null,{"$f":"SUM(C11:C36)","v":0},{"$f":"SUM(D11:D36)","v":0},null,0,0]

{"sheet":"Angef. Arbeiten","index":4,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,4,5]]}
["Angefangene Arbeiten",{"$nulls":4},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":4},{"$f":"'übr. Guthaben'!G2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":4},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["6. Angefangene Arbeiten"]
["Bis zum Inventar-Stichtag aufgelaufene Herstellkosten (Material, Löhne) oder Offertpreis abzgl. 20%"]
[]
["Name, Wohnort Kunde","Art der Leistung","Betrag Brutto CHF","MWSt %","MWSt-Betrag","Betrag netto CHF"]
[{"$nulls":4},{"$f":"(((C11)/(D11+1))*D11)","v":0},{"$f":"(((C11)/(D11+1))*1)","v":0}]
[null,null,null,{"$f":"D11","v":0},{"$f":"(((C12)/(D12+1))*D12)","v":0},{"$f":"(((C12)/(D12+1))*1)","v":0}]
[null,null,null,{"$f":"D12","v":0},0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
["TOTAL Angefangene Arbeiten",null,{"$f":"SUM(C11:C36)","v":0},null,{"$f":"SUM(E11:E36)","v":0},0]

{"sheet":"Materialvorräte","index":5,"n_rows":91,"n_cols":5,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,4,4]]}
["Material und Warenvorräte",null,null,null,"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},null,null,null,{"$f":"'Angef. Arbeiten'!F2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},null,null,null,"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["7. Material- und Warenvorräte"]
["Bewertet zu Einkaufspreisen exkl. MWSt, oder zum tieferen Marktwert per Inventarstichtag"]
[]
["Artikelbezeichnung","Lieferant","Anzahl, Gewicht, Mass","Einheitspreis CHF","Gesamtwert CHF"]
[{"$nulls":4},{"$f":"(C11*D11)","v":0}]
[{"$nulls":4},{"$f":"(C12*D12)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"(C76*D76)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL Material- und Warenvorräte",null,{"$f":"SUM(C11:C90)","v":0},{"$f":"SUM(D11:D90)","v":0},{"$f":"SUM(E11:E90)","v":0}]

{"sheet":"Hilfsmaterial","index":6,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,4,4]]}
["Material und Warenvorräte",null,null,null,"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},null,null,null,{"$f":"Materialvorräte!E2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},null,null,null,"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["8. Hilfs-/Verbrauchsmaterial"]
["Hilfs-/Pack-/Verbrauchsmaterial, welche bei der Herstellung oder beim Verkauf nicht in das Produkt eingehen."]
[]
["Artikelbezeichnung","Lieferant","Anzahl, Gewicht, Mass","Einheitspreis CHF","Gesamtwert CHF"]
[{"$nulls":4},{"$f":"(C11*D11)","v":0}]
[{"$nulls":4},{"$f":"(C12*D12)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"(C28*D28)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL Hilfs-/Verbrauchsmaterial",null,null,null,{"$f":"SUM(E11:E36)","v":0}]

{"sheet":"Halbfabrikate","index":7,"n_rows":91,"n_cols":5,"rows_kept":91,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,4,4]]}
["Material und Warenvorräte",null,null,null,"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},null,null,null,{"$f":"Hilfsmaterial!E2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},null,null,null,"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["9. Halbfabrikate"]
["Bewertung zu Herstellkosten nach aktuellem Fabrikationsstatus oder zu tieferem Marktwert"]
[]
["Artikelbezeichnung","Status","Anzahl, Gewicht, Mass","Einheitspreis CHF","Gesamtwert CHF"]
[{"$nulls":4},{"$f":"(C11*D11)","v":0}]
[{"$nulls":4},{"$f":"(C12*D12)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"(C76*D76)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL Halbfabrikate",null,null,null,{"$f":"SUM(E11:E90)","v":0}]

{"sheet":"Fertigfabrikate","index":8,"n_rows":91,"n_cols":5,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,4,4]]}
["Material und Warenvorräte",null,null,null,"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},null,null,null,{"$f":"Halbfabrikate!E2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},null,null,null,"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["10. Fertigfabrikate"]
["Bewertung zu Herstellkosten oder zu tieferem Marktwert."]
[]
["Artikelbezeichnung","Status","Anzahl, Gewicht, Mass","Einheitspreis CHF","Gesamtwert CHF"]
[{"$nulls":4},{"$f":"(C11*D11)","v":0}]
[{"$nulls":4},{"$f":"(C12*D12)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"(C76*D76)","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL Fertigfabrikate",null,null,null,{"$f":"SUM(E11:E90)","v":0}]

{"sheet":"Verbindlichkeiten","index":9,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,0,1,3],[2,0,2,3],[3,0,4,6]]}
["Verbindlichkeiten",{"$nulls":5},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":5},{"$f":"Fertigfabrikate!E2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":5},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["11. Verbindlichkeiten (offene Kreditoren)"]
["Unbezahlte, finanzielle Verbindlichkeiten gegenüber Lieferanten"]
[]
["Name, Wohnort Lieferant","Art der Leistung, Zeitperiode","Konto","Betrag Brutto CHF","MWSt %","MWSt-Betrag","Betrag netto CHF"]
[{"$nulls":5},{"$f":"(((D11)/(E11+1))*E11)","v":0},{"$f":"(((D11)/(E11+1))*1)","v":0}]
[{"$nulls":4},{"$f":"E11","v":0},0,0]
[{"$nulls":4},{"$f":"E12","v":0},0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,{"$f":"(((D76)/(E76+1))*E76)","v":0},{"$f":"(((D76)/(E76+1))*1)","v":0}]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
["TOTAL Verbindlichkeiten",null,null,{"$f":"SUM(D11:D90)","v":0},null,{"$f":"SUM(F11:F90)","v":0},0]

{"sheet":"übr. Schulden","index":10,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,1,30,2],[1,0,1,3],[2,0,2,3],[3,0,4,6],[28,1,28,2],[29,1,29,2],[27,1,27,2],[37,1,37,2],[38,1,38,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2]]}
["Übrige Schulden",{"$nulls":5},"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},{"$nulls":5},{"$f":"Verbindlichkeiten!G2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},{"$nulls":5},"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["12. Anzahlungen von Kunden"]
["Bereits geleistete Zahlungen von Kunden für Leistungen, die vom Unternehmen noch nicht erbracht sind"]
[]
["Name, Wohnort Kunde","Art der Leistung","Konto","Betrag Brutto CHF","MWSt %","MWSt-Betrag","Betrag netto CHF"]
[null,null,5655,null,null,{"$f":"(((D11)/(E11+1))*E11)","v":0},{"$f":"(((D11)/(E11+1))*1)","v":0}]
[{"$nulls":4},{"$f":"E11","v":0},{"$f":"(((D12)/(E12+1))*E12)","v":0},{"$f":"(((D12)/(E12+1))*1)","v":0}]
[{"$nulls":4},{"$f":"E12","v":0},0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
[{"$nulls":4},0,0,0]
["TOTAL Anzahlungen",null,null,{"$f":"SUM(D11:D20)","v":0},null,{"$f":"SUM(F11:F20)","v":0},0]
[]
[]
[]
["13. Darlehen / Hypotheken"]
["Bankvorschüsse, langfristig gewährte Darlehen, etc. mit Laufzeit über 12 Monate"]
[]
["Name, Wohnort Gläubiger","Art der Schuld / Sicherheit",null,"Ende der Laufzeit","Zins-satz","Zinstermin","Schuldbetrag CHF"]
{"$rows_empty":10}
["TOTAL Darlehen / Hypotheken",{"$nulls":5},{"$f":"SUM(G29:G38)","v":0}]

{"sheet":"Ergänzung","index":11,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[34,0,34,3],[35,0,35,3],[36,0,36,3],[1,0,1,1],[2,0,2,1],[3,0,4,3],[32,0,32,3],[33,0,33,3]]}
["Ergänzende Angaben",null,null,"Inventar"]
[{"$f":"Titelblatt!A2","v":", "},null,null,{"$f":"'übr. Schulden'!G2","v":"© Trewim AG, Amriswil"}]
[{"$f":"Titelblatt!A3","v":"00:00:00"},null,null,"info@trewim.ch  071 466 73 00"]
[]
[]
[]
["14. Ergänzende Angaben zur Inventaraufnahme"]
[]
[]
["Wieviele Personen sind in Ihrem Unternehmen tätig? Allfällige Mitarbeitende, die keinen Lohn"]
["beziehen (Inhaber Einzelfirma, Familienangehörige, etc.) sind separat zu Vermerken"]
["TOTAL Mitarbeiter",null,"Total Lehrlinge"]
["Davon unbezahlt",null,"Davon unbezahlt"]
[]
["Wieviele Personen, inkl. Eigene Familie, erhalten in Ihrem Unternehmer-Haushalt Kost/Logis?"]
["Total Kost Mitarbeiter/Lehrl.",null,"Total Logis Mitarbeiter / Lehrl."]
["Total Kost Familie",null,"Total Logis Familie"]
[]
["Fahren Sie ein Geschäftsfahrzeug?"]
["Kaufpreis Fahrzeug 1",null,"Geschätzte KM Privat:"]
["Kaufpreis Fahrzeug 2",null,"Geschätzte KM Privat:"]
[]
["Haben Sie im vergangenen Geschäftsjahr Eigenleistungen erbracht oder Eigenverbrauch"]
["geltend gemacht?"]
["Art der Eigenleistung","Geschätzter Betrag","Art des Eigenverbrauchs","Geschätzter Betrag"]
[]
[]
[]
[]
[]
[]
["Weitere Bemerkungen zur Inventaraufnahme:"]