{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Abrechnung Apéro","Muster extern"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Abrechnung Apéro","index":0,"n_rows":50,"n_cols":12,"rows_kept":50,"merged":[[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[12,11,13,16],[19,0,19,1],[19,2,19,3],[20,0,20,1],[20,2,20,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[47,1,47,3]]}
["Name Vorname",{"$nulls":8},"Bitte Text von Adressvorlage überschreiben"]
["Adresse"]
["PLZ Ortschaft"]
["Telefonnummer"]
["Email"]
[{"$nulls":5},"Reformierte Kirche Steinmaur-Neerach"]
[{"$nulls":5},"c/o Gemeinde Neerach"]
[{"$nulls":5},"Binzmühlestrasse 14"]
[{"$nulls":5},"8173 Neerach"]
[]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\n(z.B. Technik, Essen)"]
["Apéro",null,"Verbrauchsmaterial",{"$nulls":6},"bitte ausfüllen",null,"Achtung: Mit Alt+Enter kann die Spalte auf zwei Zeilen erweitert werden, falls der Text zu lang ist."]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo gekauft","Was gekauft","Betrag"]
[3500,{"v":3101,"d":"3101.00"},6601,{"$nulls":6},"bitte ausfüllen"]
[]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H15:H17)","v":0}]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\n(z.B. Technik, Essen)"]
["Apéro",null,"Lebensmittel",{"$nulls":6},"bitte ausfüllen"]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo gekauft","Was gekauft","Betrag"]
[3500,{"v":3105,"d":"3105.00"},6601,{"$nulls":6},"bitte ausfüllen"]
[]
[]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H23:H26)","v":0}]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\nVerkauf, Rückerstattung"]
["Apéro",null,"Einnahmen",{"$nulls":6},"bitte ausfüllen"]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo erhalten","Was bekommen","Betrag"]
[3500,{"v":4250,"d":"4250.00"},6601,{"$nulls":6},"bitte ausfüllen"]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H32:H33)","v":0}]
[]
["Total Ausgaben",{"$nulls":6},{"$f":"H18+H27","v":0},null,"automatisch"]
["Total Einnahmen",{"$nulls":6},{"$f":"H34","v":0},null,"automatisch"]
[{"$f":"IF(H38<0,\"Ausgabenüberschuss\",\"Einnahmenüberschuss\")","v":"Einnahmenüberschuss"},{"$nulls":5},"Haben  1002.01",{"$f":"H37-H36","v":{"v":0,"d":"0.00"}},null,"automatisch"]
[]
[]
["Einzahlung auf    ",null,"Raiffeisenbank Bülach, IBAN CH36 8080 8008 1968 3944 1",{"$nulls":4},{"$f":"IF($H$38>0,$H$38,\"-\")","v":"-"},null,"oder auf Bezirks-Sparkasse Dielsdorf, IBAN-Nr. CH02 0838 9016 0044 6350 1 "]
[null,null,"Reformierte Kirche Steinmaur-Neerach, Steinmaur",{"$nulls":6},"Kirchengut Steinmaur-Neerach, 8162 Steinmaur"]
[]
["Überweisung an",{"$nulls":6},{"$f":"IF(H38<0,-H38,\"\")","v":""}]
["Bank/Post, IBAN-Nr."]
["Kontoinhaber"]
[]
["Datum",{"$nulls":4},"Unterschrift"]
[]
["Visum"]

{"sheet":"Muster extern","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"merged":[[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[12,10,13,15],[21,0,21,1],[21,2,21,3],[22,0,22,1],[22,2,22,3],[31,0,31,1],[31,2,31,3],[32,0,32,1],[32,2,32,3]]}
["Muster Hans",{"$nulls":7},"Bitte Text von Adressvorlage überschreiben"]
["Dorfstrasse 4"]
["8162 Steinmaur"]
["044 888 44 55"]
["hans.muster@email.com"]
[{"$nulls":5},"Reformierte Kirche Steinmaur-Neerach"]
[{"$nulls":5},"c/o Gemeinde Neerach"]
[{"$nulls":5},"Binzmühlestrasse 14"]
[{"$nulls":5},"8173 Neerach"]
[]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\n(z.B. Technik, Essen)"]
["Chinderchile",null,"Essen",{"$nulls":5},"bitte ausfüllen",null,"Achtung: Mit Alt+Enter kann die Spalte auf zwei Zeilen erweitert werden, falls der Text zu lang ist."]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo gekauft","Was gekauft","Betrag"]
[{"$nulls":3},"2021-11-16",1,"Migros","Mandarinen",{"v":8,"d":"8.00"},"bitte ausfüllen"]
[]
[]
[]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H15:H19)","v":{"v":8,"d":"8.00"}}]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\n(z.B. Technik, Essen)"]
["Kirchgemeindehaus",null,"Technik",{"$nulls":5},"bitte ausfüllen"]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo gekauft","Was gekauft","Betrag"]
[{"$nulls":3},"2021-11-16",2,"Digitec","Kabel",{"v":15,"d":"15.00"},"bitte ausfüllen"]
[]
[]
[]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H25:H29)","v":{"v":15,"d":"15.00"}}]
[]
["Kostenträger \n(z.B. Chinderchilä, KGH)",null,"Kostenart\n(z.B. Technik, Essen)"]
["RPG"," ","Abo",{"$nulls":5},"bitte ausfüllen"]
["Funktion\nleer lassen","Konto-Nr.\nleer lassen","KSt\nleer lassen","Datum","Beleg\nNr.","Wo gekauft","Was gekauft","Betrag"]
[{"$nulls":3},"2021-11-16",3,"Verlag","Abo 11.21-10.22",{"v":22,"d":"22.00"},"bitte ausfüllen"]
[]
[]
[]
[]
[{"$nulls":4},"Total",null,null,{"$f":"SUM(H35:H39)","v":{"v":22,"d":"22.00"}}]
[]
["Total zu Überweisen",{"$nulls":6},{"$f":"H20+H30+H40","v":{"v":45,"d":"45.00"}}]
[]
["Bank/Post und IBAN-Nr.",null,"CH04 0000 0000 0000 0000 1",{"$nulls":5},"bitte ausfüllen"]
["Kontoinhaber",null,"Hans Muster, 8162 Steinmaur"]
[]
["Datum","2021-11-16",null,"Unterschrift"]