{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Abrechnung","Elternbeitrag Nachweis","Kassenbuch","Kassenbuch Seite 2","Kassenbuch Seite 3","Kassenbestandsaufnahme"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Abrechnung","index":0,"n_rows":58,"n_cols":15,"rows_kept":58,"hidden":true,"merged":[[0,13,0,15],[2,13,2,15],[5,0,5,11],[6,2,6,13],[9,0,9,2],[9,3,9,7],[9,9,9,13],[12,1,12,2],[15,6,15,7],[16,6,16,7],[17,6,17,7],[17,14,17,15],[18,0,19,0],[18,1,18,5],[18,6,19,7],[18,9,19,9],[18,10,19,13],[18,14,19,15],[19,1,19,5],[20,1,20,5],[20,6,20,7],[20,10,20,13],[20,14,20,15],[21,1,21,5],[21,6,21,7],[21,10,21,13],[21,14,21,15],[22,1,22,5],[22,6,22,7],[22,10,22,13],[22,14,22,15],[23,1,23,5],[23,6,23,7],[23,10,23,13],[23,14,23,15],[24,1,24,5],[24,6,24,7],[24,10,24,13],[24,14,24,15],[25,1,25,5],[25,6,25,7],[25,10,25,13],[25,14,25,15],[26,1,26,5],[26,6,26,7],[26,10,26,13],[26,14,26,15],[27,1,27,5],[27,6,27,7],[27,10,27,13],[27,14,27,15],[28,1,28,5],[28,6,28,7],[28,10,28,13],[28,14,28,15],[29,1,29,5],[29,6,29,7],[29,10,29,13],[29,14,29,15],[29,21,29,24],[30,1,30,5],[30,6,30,7],[30,10,30,13],[30,14,30,15],[30,21,30,24],[31,1,31,5],[31,6,31,7],[31,10,31,13],[31,14,31,15],[31,21,31,24],[32,1,32,5],[32,6,32,7],[32,10,32,13],[32,14,32,15],[32,21,32,24],[33,1,33,5],[33,6,33,7],[33,10,33,13],[33,14,33,15],[34,0,35,0],[34,1,34,5],[34,6,35,7],[34,10,34,13],[34,14,34,15],[35,1,35,5],[35,10,35,13],[35,14,35,15],[36,0,37,0],[36,1,36,5],[36,6,37,7],[36,10,36,13],[36,14,36,15],[37,1,37,5],[37,10,37,13],[37,14,37,15],[38,1,38,5],[38,6,38,7],[38,10,38,13],[38,14,38,15],[39,1,39,5],[39,6,39,7],[39,10,39,13],[39,14,39,15],[39,17,39,18],[40,6,40,7],[40,14,40,15],[41,6,41,7],[41,14,41,15],[42,6,42,7],[50,0,50,4],[50,10,50,11],[50,13,50,15],[52,10,52,15],[53,10,53,14],[55,10,55,15],[56,10,56,14],[57,10,57,14]]}
[{"$nulls":12},"Konto:"]
[]
[{"$nulls":12},"Beleg:"]
[]
[]
[]
[null,null,"Abrechnung"]
[]
[]
["Kath. Kindergarten",{"$nulls":7},"in"]
[]
[]
[null,"Januar",null,2013,{"$nulls":7},"blau unterlegte Felder sind Rechenfelder!"]
[]
[]
["Einnahmen",null,null,"bitte Belege beifügen",{"$nulls":5},"Ausgaben",null,null,"bitte Belege beifügen"]
[]
[{"$nulls":6},"€",{"$nulls":7},"€"]
[null,"Elternbeiträge",{"$nulls":8},"Summe Ausgaben lt. beigefügten Belegen\n lt. Kassenbuch "]
[null,"Summe aus Seite 2, Zeile 88"]
[null,"abzüglich Abschlag"]
[null,"Restbetrag",{"$nulls":4},{"$f":"SUM(G19-G21)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Erstattungen für Telefonkosten"]
[null,"Essengelder"]
[]
[]
[null,"Allgemeine Erstattungen"]
[]
[]
[]
[]
[]
[]
[null,"Spenden zur Anlage beim"]
[null,"Darlehensfonds"]
[null,"Erlöse aus Veranstaltungen zur "]
[null,"Anlage beim Darlehensfonds"]
[]
[null,"Rechenfehler aus Vormonat",{"$nulls":8},"Rechenfehler aus Vormonat"]
[null,"Summe der Einnahmen",{"$nulls":4},{"$f":"SUM(G22:H40)","v":{"v":0,"d":"0.00"}},null,null," "]
[null,"abzgl. Ausgaben",{"$nulls":4},{"$f":"O42","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Summe der Ausgaben",{"$nulls":3},{"$f":"SUM(O19:P41)","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(G43<0,\"Guthaben\",\"Restbetrag\")","v":"Restbetrag"},{"$nulls":4},{"$f":"G41-G42","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Bitte den Restbetrag vom Kindergartenkonto abbuchen."]
[null,null,"Der Restbetrag wird auf das Konto der VST überwiesen."]
[]
[]
[]
[{"$nulls":6},"Für die Richtigkeit:",{"$nulls":5},", den"]
["Verrechnungsstelle Durmersheim"]
["Hauptstr. 145"]
[{"$nulls":10},"Kindergartenleiterin"]
["76448 Durmersheim"]
[{"$nulls":6},"Angewiesen:"]
[{"$nulls":10},"Pfarrer / Kindergartenbeauftragte/r            "]
[{"$nulls":10},"Kiga-Geschäftsführung          "]

{"sheet":"Elternbeitrag Nachweis","index":1,"n_rows":88,"n_cols":10,"rows_kept":88,"hidden":true,"merged":[[0,3,0,6],[1,3,1,6],[87,6,87,8]]}
["Kath. Kindergarten:",null,null,"Name des Kiga, Ort"]
["Anlage zur Abrechnung für den Monat:",null,null,"Monat, Jahr"]
[]
["Nachweis für Elternbeiträge"]
[]
[null,null,"EURO","Anzahl","Summe",null,"Nachrichtlich:"]
[{"$nulls":6},"tatsächlich aufgenommene Kinder"]
["tatsächlich eingenommene Beiträge im laufenden Monat:",{"$nulls":5},"(zum Ende des Abrechnungsmonats)"]
["RG - Ü 3","1. Kind",null,null,{"$f":"SUM(C9*D9)","v":0}]
["RG - Ü 3","2. Kind",null,null,0,null,"Gruppenform","Alter","Kinder","Plätze"]
["RG - Ü 3","3. Kind",null,null,0,null,"RG","Ü 3",null,{"$f":"SUM(I11)","v":0}]
["RG - Ü 3","4. Kind ",null,null,0,null,"RG AM","unter 3",null,{"$f":"I12*2","v":0}]
["RG AM - unter 3","1. Kind",null,null,0,null,"VÖ","Ü 3",null,{"$f":"I13","v":0}]
["RG AM - unter 3","2. Kind",null,null,0,null,"VÖ AM","unter 3",null,{"$f":"I14*2","v":0}]
["RG AM - unter 3","3. Kind",null,null,0,null,"GT","Ü 3",null,{"$f":"I15","v":0}]
["RG AM - unter 3","4. Kind ",null,null,0,null,"GT AM","unter 3",null,{"$f":"I16*2","v":0}]
["VÖ - Ü 3","1. Kind",null,null,0,null,"HT","Ü 3",null,{"$f":"I17","v":0}]
["VÖ - Ü 3","2. Kind",null,null,0,null,"HT AM","unter 3",null,{"$f":"I18*2","v":0}]
["VÖ - Ü 3","3. Kind",null,null,0]
["VÖ - Ü 3","4. Kind ",null,null,0,null,"Krippe VÖ",null,null,{"$f":"I20","v":0}]
["VÖ AM - unter 3","1. Kind",null,null,0,null,"Krippe GT",null,null,{"$f":"I21","v":0}]
["VÖ AM - unter 3","2. Kind",null,null,0]
["VÖ AM - unter 3","3. Kind",null,null,0]
["VÖ AM - unter 3","4. Kind ",null,null,0]
["GT - Ü 3","1. Kind",null,null,0]
["GT - Ü 3","2. Kind",null,null,0]
["GT - Ü 3","3. Kind",null,null,0,null,"Summe",null,{"$f":"SUM(I11:I26)","v":0},{"$f":"SUM(J11:J26)","v":0}]
["GT - Ü 3","4. Kind ",null,null,0]
["GT AM - unter 3","1. Kind",null,null,0]
["GT AM - unter 3","2. Kind",null,null,0]
["GT AM - unter 3","3. Kind",null,null,0]
["GT AM - unter 3","4. Kind ",null,null,0]
["Krippe VÖ","1. Kind",null,null,0]
["Krippe VÖ","2. Kind",null,null,0]
["Krippe VÖ","3. Kind",null,null,0]
["Krippe VÖ","4. Kind ",null,null,0]
["Krippe GT","1. Kind",null,null,0]
["Krippe GT","2. Kind",null,null,0]
["Krippe GT","3. Kind",null,null,0]
["Krippe GT","4. Kind ",null,null,0]
["Halbtagsgruppe","1. Kind",null,null,0]
["Halbtagsgruppe","2. Kind",null,null,0]
["Halbtagsgruppe","3. Kind",null,null,0]
["Halbtagsgruppe","4. Kind ",null,null,0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["sonstige Angebote",{"$nulls":3},0]
["Summe Kinder/Beiträge laufender Monat",null,null,{"$f":"SUM(D9:D55)","v":0},{"$f":"SUM(E9:E55)","v":0}]
[]
["tatsächlich eingenommene Beiträge für weitere Angebote:"]
["(z. B. Zukauf-Stunden",{"$nulls":3},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Summe weitere Angebote",{"$nulls":3},{"$f":"SUM(E59:E64)","v":0}]
[]
["tatsächlich eingenommene Nachzahlungen "]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["Summe Nachzahlungen",{"$nulls":3},{"$f":"SUM(E68:E72)","v":0}]
[]
["Rückzahlungen/Storno (Minus-Betrag!!)"]
[{"$nulls":4},0]
[{"$nulls":4},{"$f":"SUM(C77*D77)","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]
["Summe Rückzahlungen",{"$nulls":3},{"$f":"SUM(E76:E85)","v":0}]
[]
["SUMME TATSÄCHLICH EINGENOMMENE ELTERNBEITRÄGE",{"$nulls":3},{"$f":"SUM(E56+E65+E73+E86)","v":0},"<","Bitte nur diese SUMME in die Monatsabrechnung übertragen"]

{"sheet":"Kassenbuch","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"merged":[[1,0,1,2],[1,3,1,7],[3,0,3,2],[3,3,3,7],[4,0,4,2],[4,3,4,7],[9,2,9,3],[9,5,9,6],[9,8,9,9],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[56,2,56,4],[58,2,58,4]]}
[]
["Kath. Kirchengemeinde:"]
[]
["Gruppierung:"]
["Kassenverantwortliche Person:"]
[]
[" "]
["Monat:",null,"Jahr:"]
[]
[{"$nulls":5},"BARKASSE",null,null,"GIROKONTO"]
[null,null,"Anfangsbestand/Endbestand aus letzter Abrechnung: "]
["Beleg-Nr.","Datum","Belegtext / Verwendungszweck",null,null,"Einnahme","Ausgabe",null,"Einnahme","Ausgabe"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[]
[]
[null,null,"Summe Einnahmen/Ausgaben",null,null,{"$f":"SUM(F13:F52)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G13:G52)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(I13:I52)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J13:J52)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"Rechnerische Summe Barkasse und des Girokontos                    (Anfangswerte + Einnahmen - Ausgaben)",null,null,{"$f":"SUM(F11+F55-G55)","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"SUM(I11-J11+I55-J55)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Barkasse",null,null,"Girokonto"]
[null,null,"Tatsächlicher Stand der Kasse/des Girokontos (automatischer Übertrag aus Kassenbestandsaufnahme)",null,null,{"$f":"Kassenbestandsaufnahme!B13","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Kassenbestandsaufnahme!B16","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Differenz zwischen rechnerischem u. tatsächlichen Bestand:",null,null,{"$f":"SUM(F59-F57)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!",null,{"$f":"SUM(I59-I57)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!"]
[]
[]
[]
[]
[]
["Für die Richtigkeit:"]
[null,null,"Datum",null,"Unterschrift"]

{"sheet":"Kassenbuch Seite 2","index":3,"n_rows":67,"n_cols":12,"rows_kept":67,"merged":[[1,0,1,2],[1,3,1,7],[3,0,3,2],[3,3,3,7],[7,2,7,3],[7,5,7,6],[7,8,7,9],[8,2,8,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,3],[54,2,54,4],[56,2,56,4]]}
[]
["Kath. Kirchengemeinde:",null,null,{"$f":"Kassenbuch!D2","v":0}]
[]
["Gruppierung:",null,null,{"$f":"Kassenbuch!D4","v":0}]
[" "]
["Monat",{"$f":"Kassenbuch!B8","v":0},"Jahr",{"$f":"Kassenbuch!D8","v":0}]
[]
[{"$nulls":5},"BARKASSE",null,null,"GIROKONTO"]
["Beleg-Nr.","Datum","Belegtext / Verwendungszweck",null,null,"Einnahme","Ausgabe",null,"Einnahme","Ausgabe"]
[{"$nulls":3},"Übertrag aus Seite 1",null,{"$f":"SUM(Kassenbuch!F57)","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"SUM(Kassenbuch!I57)","v":{"v":0,"d":"0.00 €"}}]
[41,{"$nulls":10},{"$f":"IF(C11=\"spende\",SUM(F11-G11+I11-J11),IF(C11=\"spenden\",SUM(F11-G11+I11-J11),\"\"))","v":""}]
[42,{"$nulls":10},{"$f":"IF(C12=\"spende\",SUM(F12-G12+I12-J12),IF(C12=\"spenden\",SUM(F12-G12+I12-J12),\"\"))","v":""}]
[43,{"$nulls":10},{"$f":"IF(C13=\"spende\",SUM(F13-G13+I13-J13),IF(C13=\"spenden\",SUM(F13-G13+I13-J13),\"\"))","v":""}]
[44,{"$nulls":10},{"$f":"IF(C14=\"spende\",SUM(F14-G14+I14-J14),IF(C14=\"spenden\",SUM(F14-G14+I14-J14),\"\"))","v":""}]
[45,{"$nulls":10},{"$f":"IF(C15=\"spende\",SUM(F15-G15+I15-J15),IF(C15=\"spenden\",SUM(F15-G15+I15-J15),\"\"))","v":""}]
[46,{"$nulls":10},""]
[47,{"$nulls":10},""]
[48,{"$nulls":10},""]
[49,{"$nulls":10},""]
[50,{"$nulls":10},""]
[51,{"$nulls":10},""]
[52,{"$nulls":10},""]
[53,{"$nulls":10},""]
[54,{"$nulls":10},""]
[55,{"$nulls":10},""]
[56,{"$nulls":10},""]
[57,{"$nulls":10},""]
[58,{"$nulls":10},""]
[59,{"$nulls":10},""]
[60,{"$nulls":10},""]
[61]
[62]
[63]
[64]
[65]
[66,{"$nulls":10},""]
[67,{"$nulls":10},""]
[68,{"$nulls":10},""]
[69,{"$nulls":10},""]
[70,{"$nulls":10},""]
[71]
[72]
[73]
[74]
[75,{"$nulls":10},{"$f":"IF(C45=\"spende\",SUM(F45-G45+I45-J45),IF(C45=\"spenden\",SUM(F45-G45+I45-J45),\"\"))","v":""}]
[76]
[77,{"$nulls":10},""]
[78,{"$nulls":10},""]
[79,{"$nulls":10},""]
[80,{"$nulls":10},""]
[]
[]
[null,null,"Summe Einnahmen/Ausgaben",null,null,{"$f":"SUM(F11:F50)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G11:G50)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(I11:I50)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J11:J50)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"Rechnerische Summe Barkasse und des Girokontos                    (Anfangswerte + Einnahmen - Ausgaben)",null,null,{"$f":"SUM(F10+F53-G53)","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"SUM(I10-J10+I53-J53)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Barkasse",null,null,"Girokonto"]
[null,null,"Tatsächlicher Stand der Kasse/des Girokontos zum Zeitpunkt der Abrechnung",null,null,{"$f":"Kassenbuch!F59","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"Kassenbuch!I59","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Differenz zwischen rechnerischem u. tatsächlichen Bestand:",null,null,{"$f":"SUM(F57-F55)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!",null,{"$f":"SUM(I57-I55)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!"]
{"$rows_empty":7}
["Für die Richtigkeit:"]
[null,null,"Datum",null,"Unterschrift"]

{"sheet":"Kassenbuch Seite 3","index":4,"n_rows":67,"n_cols":12,"rows_kept":67,"merged":[[1,0,1,2],[1,3,1,7],[3,0,3,2],[3,3,3,7],[7,2,7,3],[7,5,7,6],[7,8,7,9],[8,2,8,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,3],[54,2,54,4],[56,2,56,4]]}
[]
["Kath. Kirchengemeinde:",null,null,{"$f":"Kassenbuch!D2","v":0}]
[]
["Gruppierung:",null,null,{"$f":"Kassenbuch!D4","v":0}]
[" "]
["Monat:",{"$f":"Kassenbuch!B8","v":0},"Jahr:",{"$f":"Kassenbuch!D8","v":0}]
[]
[{"$nulls":5},"BARKASSE",null,null,"GIROKONTO"]
["Beleg-Nr.","Datum","Belegtext / Verwendungszweck",null,null,"Einnahme","Ausgabe",null,"Einnahme","Ausgabe"]
[{"$nulls":3},"Übertrag aus Seite 2",null,{"$f":"'Kassenbuch Seite 2'!F55","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"'Kassenbuch Seite 2'!I55","v":{"v":0,"d":"0.00 €"}}]
[81,{"$nulls":10},{"$f":"IF(C11=\"spende\",SUM(F11-G11+I11-J11),IF(C11=\"spenden\",SUM(F11-G11+I11-J11),\"\"))","v":""}]
[82,{"$nulls":10},{"$f":"IF(C12=\"spende\",SUM(F12-G12+I12-J12),IF(C12=\"spenden\",SUM(F12-G12+I12-J12),\"\"))","v":""}]
[83,{"$nulls":10},{"$f":"IF(C13=\"spende\",SUM(F13-G13+I13-J13),IF(C13=\"spenden\",SUM(F13-G13+I13-J13),\"\"))","v":""}]
[84,{"$nulls":10},{"$f":"IF(C14=\"spende\",SUM(F14-G14+I14-J14),IF(C14=\"spenden\",SUM(F14-G14+I14-J14),\"\"))","v":""}]
[85,{"$nulls":10},{"$f":"IF(C15=\"spende\",SUM(F15-G15+I15-J15),IF(C15=\"spenden\",SUM(F15-G15+I15-J15),\"\"))","v":""}]
[86,{"$nulls":10},""]
[87,{"$nulls":10},""]
[88,{"$nulls":10},""]
[89,{"$nulls":10},""]
[90,{"$nulls":10},""]
[91,{"$nulls":10},""]
[92,{"$nulls":10},""]
[93,{"$nulls":10},""]
[94,{"$nulls":10},""]
[95,{"$nulls":10},""]
[96,{"$nulls":10},""]
[97,{"$nulls":10},""]
[98,{"$nulls":10},""]
[99,{"$nulls":10},""]
[100,{"$nulls":10},""]
[101]
[102]
[103]
[104]
[105]
[106,{"$nulls":10},""]
[107,{"$nulls":10},""]
[108,{"$nulls":10},""]
[109,{"$nulls":10},""]
[110,{"$nulls":10},""]
[111]
[112]
[113]
[114]
[115,{"$nulls":10},{"$f":"IF(C45=\"spende\",SUM(F45-G45+I45-J45),IF(C45=\"spenden\",SUM(F45-G45+I45-J45),\"\"))","v":""}]
[116]
[117,{"$nulls":10},""]
[118,{"$nulls":10},""]
[119,{"$nulls":10},""]
[120,{"$nulls":10},""]
[]
[]
[null,null,"Summe Einnahmen/Ausgaben",null,null,{"$f":"SUM(F11:F50)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G11:G50)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(I11:I50)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J11:J50)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"Rechnerische Summe Barkasse und des Girokontos                    (Anfangswerte + Einnahmen - Ausgaben)",null,null,{"$f":"SUM(F10+F53-G53)","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"SUM(I10-J10+I53-J53)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},"Barkasse",null,null,"Girokonto"]
[null,null,"Tatsächlicher Stand der Kasse/des Girokontos zum Zeitpunkt der Abrechnung",null,null,{"$f":"'Kassenbuch Seite 2'!F57","v":{"v":0,"d":"0.00 €"}},null,null,{"v":0,"d":"0.00 €"}]
[null,null,"Differenz zwischen rechnerischem u. tatsächlichen Bestand:",null,null,{"$f":"SUM(F57-F55)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!",null,{"$f":"SUM(I57-I55)","v":{"v":0,"d":"0.00 €"}},"Differenz muss 0,00 € sein!"]
{"$rows_empty":7}
["Für die Richtigkeit:"]
[null,null,"Datum",null,"Unterschrift"]

{"sheet":"Kassenbestandsaufnahme","index":5,"n_rows":16,"n_cols":6,"rows_kept":16}
["Kassenbestandsaufnahme"]
[]
["Barkasse:"]
[{"v":500,"d":"500.00 €"},null,{"$f":"A4*B4","v":0},{"v":2,"d":"2.00 €"},null,{"$f":"D4*E4","v":0}]
[{"v":200,"d":"200.00 €"},null,{"$f":"A5*B5","v":0},{"v":1,"d":"1.00 €"},null,{"$f":"D5*E5","v":0}]
[{"v":100,"d":"100.00 €"},null,0,{"v":0.5,"d":"0.50 €"},null,0]
[{"v":50,"d":"50.00 €"},null,0,{"v":0.2,"d":"0.20 €"},null,0]
[{"v":20,"d":"20.00 €"},null,0,{"v":0.1,"d":"0.10 €"},null,0]
[{"v":10,"d":"10.00 €"},null,0,{"v":0.05,"d":"0.05 €"},null,0]
[{"v":5,"d":"5.00 €"},null,0,{"v":0.02,"d":"0.02 €"},null,0]
[{"$nulls":3},{"v":0.01,"d":"0.01 €"},null,0]
[]
["Endstand",{"$f":"SUM(C4:C10)+SUM(F4:F11)","v":0}]
[]
[]
["Girokonto"]