{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Zusammenfassung","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":13,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Zusammenfassung","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,6,32,8],[33,6,33,8],[0,0,0,4],[0,6,0,8],[16,0,16,7],[30,6,30,8],[31,6,31,8]]}
["Jahreszusammenfassung",null,null,null,null,"V13","Nebenkosten Vereinsarbeit"]
[]
["Anzahl Tage für Verein (max. 70)",{"$f":"Dezember!H63+November!H63+Oktober!H63+September!H63+August!H63+Juli!H63+Juni!H63+Mai!H63+April!H63+März!H63+Februar!H63+Januar!H63","v":0},null,"zzgl.unbezahlt incl. NK",{"$f":"Dezember!H64+November!H64+Oktober!H64+September!H64+August!H64+Juli!H64+Juni!H64+Mai!H64+April!H64+März!H64+Februar!H64+Januar!H64","v":0},null,{"$f":"Januar!A64","v":"Umlage U1"},{"$f":"Januar!B64","v":1.0999999999999999E-2},{"$f":"Dezember!E64+November!E64+Oktober!E64+September!E64+August!E64+Juli!E64+Juni!E64+Mai!E64+April!E64+März!E64+Februar!E64+Januar!E64","v":0}]
["Anzahl abgerechnete Stunden",{"$f":"Dezember!H62+November!H62+Oktober!H62+September!H62+August!H62+Juli!H62+Juni!H62+Mai!H62+April!H62+März!H62+Februar!H62+Januar!H62","v":0},null,"Stunden geschenkt",{"$f":"Dezember!H66+November!H66+Oktober!H66+September!H66+August!H66+Juli!H66+Juni!H66+Mai!H66+April!H66+März!H66+Februar!H66+Januar!H66","v":0},null,{"$f":"Januar!A65","v":"Umlage U2"},{"$f":"Januar!B65","v":2.3999999999999998E-3},{"$f":"Dezember!E65+November!E65+Oktober!E65+September!E65+August!E65+Juli!E65+Juni!E65+Mai!E65+April!E65+März!E65+Februar!E65+Januar!E65","v":0}]
[null,null,null,null,null,null,{"$f":"Januar!A66","v":"Umlage U3"},{"$f":"Januar!B66","v":5.9999999999999995E-4},{"$f":"Dezember!E66+November!E66+Oktober!E66+September!E66+August!E66+Juli!E66+Juni!E66+Mai!E66+April!E66+März!E66+Februar!E66+Januar!E66","v":0}]
[null,null,null,null,null,null,{"$f":"Januar!A67","v":"EK-Steuer"},{"$f":"Januar!B67","v":0.25},{"$f":"Dezember!E67+November!E67+Oktober!E67+September!E67+August!E67+Juli!E67+Juni!E67+Mai!E67+April!E67+März!E67+Februar!E67+Januar!E67","v":0}]
["Lohnabrechnung (zu versteuern)",{"$f":"Dezember!K64+November!K64+Oktober!K64+September!K64+August!K64+Juli!K64+Juni!K64+Mai!K64+April!K64+März!K64+Februar!K64+Januar!K64","v":0},null,null,null,null,{"$f":"Januar!A68","v":"Kirchensteuer"},{"$f":"Januar!B68","v":0.05},{"$f":"Dezember!E68+November!E68+Oktober!E68+September!E68+August!E68+Juli!E68+Juni!E68+Mai!E68+April!E68+März!E68+Februar!E68+Januar!E68","v":0}]
["Wert abgerechnetes Fahrtgeld",{"$f":"Dezember!K65+November!K65+Oktober!K65+September!K65+August!K65+Juli!K65+Juni!K65+Mai!K65+April!K65+März!K65+Februar!K65+Januar!K65","v":0}]
["Wert abgerechnetes Telefon",{"$f":"Dezember!K66+November!K66+Oktober!K66+September!K66+August!K66+Juli!K66+Juni!K66+Mai!K66+April!K66+März!K66+Februar!K66+Januar!K66","v":0}]
["Wert abgerechnetes Porto",{"$f":"Dezember!K67+November!K67+Oktober!K67+September!K67+August!K67+Juli!K67+Juni!K67+Mai!K67+April!K67+März!K67+Februar!K67+Januar!K67","v":0}]
["Wert abgerechnetes Auslagen",{"$f":"Dezember!K68+November!K68+Oktober!K68+September!K68+August!K68+Juli!K68+Juni!K68+Mai!K68+April!K68+März!K68+Februar!K68+Januar!K68","v":0}]
["gefahrene Kilometer",{"$f":"Dezember!H65+November!H65+Oktober!H65+September!H65+August!H65+Juli!H65+Juni!H65+Mai!H65+April!H65+März!H65+Februar!H65+Januar!H65","v":0}]
["Kosten für Verein ohne NK",{"$f":"B7+B8+B9+B10+B11","v":0}]
[]
["Gesamtkosten Vereinsarbeit incl. NK",{"$f":"B13+I15","v":0},null,"Verein spart unbezahlt und NK",{"$f":"E3","v":0},null,{"$f":"Januar!A69","v":"Gesamt"},{"$f":"Januar!B69","v":0.314},{"$f":"Dezember!E69+November!E69+Oktober!E69+September!E69+August!E69+Juli!E69+Juni!E69+Mai!E69+April!E69+März!E69+Februar!E69+Januar!E69","v":0}]
[]
["Fahrten mit PKW:"]
[]
["Fahrt Startpunkt (Adresse)","Fahrtnummer",null,"Fahrt Zielpunkt (Adresse)","Hin-Rückfahrt",null,"Gesamtkilometer"]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[]
["Bitte beachten:",null,null,null,"Name Vorname"]
["Die üblichen Fahrten für den Verein in dieser Seite befüllen (grauer Bereich).",null,null,null,"IBAN"]
["Nur die Fahrten, die auch abgerechnet werden sollen! ",null,"ggf. leer lassen!",null,"Name der Bank"]
[null,null,null,null,"Jahr",null,2024]
["Im jeweiligen abzurechnenden Monat nur die farbigen Zellen befüllen."]
["Siehe Hinweise und Kommentare in den Zellen!",null,null,null,null,null,"Namen, IBAN, Bank hier ausfüllen."]
["Beispieleingaben befinden sich in den Überschriften der Monatsblätter."]
["Den Dateinahmen nicht ändern, da die Daten automatisch ausgelesen werden!"]

{"sheet":"Januar","index":1,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[11,1,11,5],[15,9,15,10],[17,4,17,5],[19,4,19,5],[18,7,18,8],[23,7,23,8],[24,7,24,8],[19,7,19,8],[16,4,16,5],[18,4,18,5],[17,7,17,8],[16,7,16,8],[20,4,20,5],[21,4,21,5],[13,3,15,3],[21,7,21,8],[13,7,13,8],[14,7,14,8],[22,4,22,5],[23,4,23,5],[24,4,24,5],[22,7,22,8],[22,0,24,0],[34,4,34,5],[9,9,9,10],[0,0,0,10],[16,0,18,0],[19,0,21,0],[20,7,20,8],[8,9,8,10],[10,9,10,10],[7,9,7,10],[13,9,13,10],[9,1,9,5],[7,1,7,5],[15,7,15,8],[8,1,8,5],[10,1,10,5],[15,4,15,5],[13,4,13,5],[14,4,14,5],[14,9,14,10],[25,0,27,0],[25,7,25,8],[26,7,26,8],[27,7,27,8],[49,0,51,0],[49,7,49,8],[50,7,50,8],[51,7,51,8],[40,0,42,0],[40,7,40,8],[41,7,41,8],[42,7,42,8],[37,0,39,0],[37,7,37,8],[42,4,42,5],[45,4,45,5],[59,4,59,5],[60,4,60,5],[59,7,59,8],[58,7,58,8],[55,7,55,8],[57,4,57,5],[53,7,53,8],[56,4,56,5],[68,9,68,10],[60,7,60,8],[63,4,63,5],[68,4,68,5],[61,0,61,5],[66,4,66,5],[67,4,67,5],[64,4,64,5],[65,4,65,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[58,4,58,5],[28,0,30,0],[28,4,28,5],[31,0,33,0],[31,4,31,5],[34,0,36,0],[52,0,54,0],[32,7,32,8],[43,0,45,0],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,0,48,0],[46,7,46,8],[47,7,47,8],[48,7,48,8],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[47,4,47,5],[43,4,43,5],[38,7,38,8],[39,7,39,8],[37,4,37,5],[34,7,34,8],[36,4,36,5],[36,7,36,8],[56,7,56,8],[57,7,57,8],[44,4,44,5],[38,4,38,5],[35,4,35,5],[54,7,54,8],[35,7,35,8],[46,4,46,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[52,4,52,5],[52,7,52,8],[27,4,27,5],[25,4,25,5],[26,4,26,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[33,4,33,5],[33,7,33,8],[32,4,32,5],[31,7,31,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Januar 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,{"$f":"IF(C47-B47=0,\"\",IF(D47<>\"ü\",0,((C47-B47)*24)))","v":""},null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Januar!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,0,null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,0,null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Januar 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Februar","index":2,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[62,5,62,6],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Februar 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Februar!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Februar 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"März","index":3,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"März 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(März!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"März 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"April","index":4,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"April 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(April!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"April 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Mai","index":5,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Mai 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Mai!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Mai 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Juni","index":6,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Juni 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juni!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Juni 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Juli","index":7,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Juli 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Juli!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Juli 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"August","index":8,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"August 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(August!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"August 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"September","index":9,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"September 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(September!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"September 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Oktober","index":10,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Oktober 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Oktober!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Oktober 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"November","index":11,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"November 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(November!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"November 2024"},{"$f":"SUM(J64:K68)","v":0}]

{"sheet":"Dezember","index":12,"n_rows":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,10],[7,1,7,5],[7,9,7,10],[8,1,8,5],[8,9,8,10],[9,1,9,5],[9,9,9,10],[10,1,10,5],[10,9,10,10],[13,3,15,3],[13,4,13,5],[13,7,13,8],[13,9,13,10],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,4,15,5],[15,7,15,8],[15,9,15,10],[16,0,18,0],[16,4,16,5],[16,7,16,8],[17,4,17,5],[17,7,17,8],[18,4,18,5],[18,7,18,8],[19,0,21,0],[19,4,19,5],[19,7,19,8],[20,4,20,5],[20,7,20,8],[21,4,21,5],[21,7,21,8],[22,0,24,0],[22,4,22,5],[22,7,22,8],[23,4,23,5],[23,7,23,8],[24,4,24,5],[24,7,24,8],[25,0,27,0],[25,4,25,5],[25,7,25,8],[26,4,26,5],[26,7,26,8],[27,4,27,5],[27,7,27,8],[28,0,30,0],[28,4,28,5],[28,7,28,8],[29,4,29,5],[29,7,29,8],[30,4,30,5],[30,7,30,8],[31,0,33,0],[31,4,31,5],[31,7,31,8],[32,4,32,5],[32,7,32,8],[33,4,33,5],[33,7,33,8],[34,0,36,0],[34,4,34,5],[34,7,34,8],[35,4,35,5],[35,7,35,8],[36,4,36,5],[36,7,36,8],[37,0,39,0],[37,4,37,5],[37,7,37,8],[38,4,38,5],[38,7,38,8],[39,4,39,5],[39,7,39,8],[40,0,42,0],[40,4,40,5],[40,7,40,8],[41,4,41,5],[41,7,41,8],[42,4,42,5],[42,7,42,8],[43,0,45,0],[43,4,43,5],[43,7,43,8],[44,4,44,5],[44,7,44,8],[45,4,45,5],[45,7,45,8],[46,0,48,0],[46,4,46,5],[46,7,46,8],[47,4,47,5],[47,7,47,8],[48,4,48,5],[48,7,48,8],[49,0,51,0],[49,4,49,5],[49,7,49,8],[50,4,50,5],[50,7,50,8],[51,4,51,5],[51,7,51,8],[52,0,54,0],[52,4,52,5],[52,7,52,8],[53,4,53,5],[53,7,53,8],[54,4,54,5],[54,7,54,8],[55,4,55,5],[55,7,55,8],[56,4,56,5],[56,7,56,8],[57,4,57,5],[57,7,57,8],[67,4,67,5],[68,4,68,5],[68,9,68,10],[61,0,61,5],[63,4,63,5],[66,4,66,5],[58,4,58,5],[58,7,58,8],[59,4,59,5],[59,7,59,8],[60,4,60,5],[60,7,60,8]]}
["Abrechnungsbogen über Vereinsarbeit"]
[]
[]
[]
["Bungalow-Siedlung-Rodlera e.V.",null,null,null,null,null,null,null,null,"Mindestlohn",12.41]
[null,null,null,null,null,null,null,null,null,"Fahrtkosten",0.3]
[]
["Name:",{"$f":"Zusammenfassung!G31","v":0},null,null,null,null,null,null,"Monat: ",{"$f":"MID(CELL(\"Dateiname\",$A$1),FIND(\"]\",CELL(\"Dateiname\",$A$1))+1,31)& \" \" &Zusammenfassung!G34","v":"Dezember 2024"}]
[]
["IBAN: ",{"$f":"Zusammenfassung!G32","v":0},null,null,null,null,null,null,"Bank:  ",{"$f":"Zusammenfassung!G33","v":0}]
[]
[]
[]
[null,null,null,"Spende"]
["Datum","von","bis",null,"Stunden",null,null,"ausgeführte Arbeiten",null,"Fahrtkilometer"]
["2021-01-01","15:30:00","17:30:00",null,null,null,null,"Text eingeben",null,"Fahrtnummer  eingeben"]
[null,null,null,null,{"$f":"IF(D17=\"a\",\"\",IF(C17-B17=0,\"\",IF(D17=\"ü\",0,((C17-B17)*24))))","v":""},null,{"$f":"IF(C17-B17=0,\"\",IF(D17<>\"ü\",0,((C17-B17)*24)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K17,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"a\",\"\",IF(C18-B18=0,\"\",IF(D18=\"ü\",0,((C18-B18)*24))))","v":""},null,{"$f":"IF(C18-B18=0,\"\",IF(D18<>\"ü\",0,((C18-B18)*24)))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K18,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K19=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K19,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K20=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K20,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K21=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K21,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K22=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K22,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K23=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K23,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K24=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K24,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K25=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K25,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K26=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K26,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K27=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K27,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K28=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K28,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K29=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K29,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K30=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K30,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K31=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K31,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K32=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K32,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K33=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K33,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K34=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K34,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K35=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K35,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K36=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K36,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K37=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K37,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K38=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K38,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K39=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K39,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K40=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K40,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K41=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K41,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K42=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K42,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K43=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K43,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K44=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K44,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K45=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K45,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K46=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K46,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K47=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K47,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K48=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K48,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K49=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K49,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K50=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K50,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K51=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K51,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K52=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K52,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K53=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K53,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K54=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K54,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K55=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K55,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K56=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K56,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K57=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K57,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K58=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K58,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K59=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K59,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K60=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K60,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
[null,null,null,null,"",null,"",null,null,{"$f":"IF(K61=\"\",\"\",(INDEX(Zusammenfassung!$G$20:$G$29,MATCH(Dezember!K61,Zusammenfassung!$B$20:$B$29,0),1)))","v":""}]
["Abgaben Verein:",null,null,null,null,null,null,{"$f":"SUM(E17:F61)","v":0},"Gesamtstunden"]
[null,null,null,null,null,null,null,{"$f":"COUNT(A17:A61)","v":0},"Tage Vereinsarbeit (Ø 6)"]
["Umlage U1",1.0999999999999999E-2,null,null,{"$f":"B64*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)*K5*(1+B69)","v":0},"dem Verein geschenkt","Lohn",{"$f":"K5*H62","v":0}]
["Umlage U2",2.3999999999999998E-3,null,null,{"$f":"B65*$K$64","v":0},null,null,{"$f":"SUM(J17:J61)","v":0},"Fahrtkilometer","km Geld",{"$f":"H65*K6","v":0}]
["Umlage U3",5.9999999999999995E-4,null,null,{"$f":"B66*$K$64","v":0},null,null,{"$f":"SUM(G17:G61)","v":0},"Stunden geschenkt","Telefon"]
["EK-Steuer",0.25,null,null,{"$f":"B67*$K$64","v":0},null,null,null,null,"Porto"]
["Kirchensteuer",0.05,null,null,{"$f":"B68*$E$67","v":0},null,null,null,null,"Auslagen"]
["Gesamt",{"$f":"SUM(B64:B68)","v":0.314},null,null,{"$f":"SUM(E64:E68)","v":0},null,null,"Zahlung",{"$f":"IF(J8=\"\",\"\",J8)","v":"Dezember 2024"},{"$f":"SUM(J64:K68)","v":0}]