{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Abrechnung-Muster"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Abrechnung-Muster","index":0,"n_rows":74,"n_cols":8,"rows_kept":74,"merged":[[0,0,0,1],[0,2,0,7],[3,0,3,1],[7,0,10,0],[12,0,17,0],[20,0,22,0],[25,0,26,0],[32,0,34,0],[40,0,43,0],[48,0,52,0],[57,0,58,0],[66,3,66,4]]}
["Kalkulation / Abrechnung",null,"Freizeitbezeichnung"]
["vom","bis","Ziel",{"v":0,"d":"0 Tage"},0,"Teilnehmer"]
[{"$nulls":4},0,"Mitarbeiter / Betreuer / Leitung"]
["Kirchengemeinde",{"$nulls":3},{"$f":"E2+E3","v":0},"Summe"]
[]
["Ausgaben","Bemerkung","Endbetrag","TN    (Teilnehmer)","Tage","Summe / Betrag","prozentual"]
["Unterkunft"]
["Übernachtung, Verpflegung, Nebenkosten - Endreinigung,    Wasser, Strom)",{"$nulls":4},{"$f":"IF(C8=\"\",\"\",C8)","v":""},{"$f":"IF(F8=\"\",\"\",(F8/($F$45/100)/100))","v":""},{"$f":"IF(G8=\"\",\"\",(IF(G8>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C9=\"\",\"\",C9)","v":""},{"$f":"IF(F9=\"\",\"\",(F9/($F$45/100)/100))","v":""},{"$f":"IF(G9=\"\",\"\",(IF(G9>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C10=\"\",\"\",C10)","v":""},{"$f":"IF(F10=\"\",\"\",(F10/($F$45/100)/100))","v":""},{"$f":"IF(G10=\"\",\"\",(IF(G10>0,\"!\",\" \")))","v":""}]
[]
["Fahrtkosten"]
["z.B. Bus, Bahn,       Flug, PKW, Fähre,    ggf. ist zu unter-scheiden in Kosten    für Teilnehmer und Team",{"$nulls":4},{"$f":"IF(C13=\"\",\"\",C13)","v":""},{"$f":"IF(F13=\"\",\"\",(F13/($F$45/100)/100))","v":""},{"$f":"IF(G13=\"\",\"\",(IF(G13>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[{"$nulls":5},"","",""]
[]
["Programmgestaltungen"]
["z.B. Ausflüge, Eintritt, Bastel-material u.a.",{"$nulls":4},{"$f":"IF(C21=\"\",\"\",C21)","v":""},{"$f":"IF(F21=\"\",\"\",(F21/($F$45/100)/100))","v":""},{"$f":"IF(G21=\"\",\"\",(IF(G21>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C22=\"\",\"\",C22)","v":""},{"$f":"IF(F22=\"\",\"\",(F22/($F$45/100)/100))","v":""},{"$f":"IF(G22=\"\",\"\",(IF(G22>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C23=\"\",\"\",C23)","v":""},{"$f":"IF(F23=\"\",\"\",(F23/($F$45/100)/100))","v":""},{"$f":"IF(G23=\"\",\"\",(IF(G23>0,\"!\",\" \")))","v":""}]
[]
["weitere Kosten",{"$nulls":6},{"$f":"IF(G25>0,\"!\",\" \")","v":" "}]
["z.B. 1. Hilfe Kasten u.a.",{"$nulls":4},{"$f":"IF(C26=\"\",\"\",C26)","v":""},{"$f":"IF(F26=\"\",\"\",(F26/($F$45/100)/100))","v":""},{"$f":"IF(G26=\"\",\"\",(IF(G26>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C27=\"\",\"\",C27)","v":""},{"$f":"IF(F27=\"\",\"\",(F27/($F$45/100)/100))","v":""},{"$f":"IF(G27=\"\",\"\",(IF(G27>0,\"!\",\" \")))","v":""}]
[{"$nulls":7},{"$f":"IF(G28>0,\"!\",\" \")","v":" "}]
["Versicherungen (z.B. Ausland)"]
[{"$nulls":5},{"$f":"IF(C30=\"\",\"\",C30)","v":""},{"$f":"IF(F30=\"\",\"\",(F30/($F$45/100)/100))","v":""},{"$f":"IF(G30=\"\",\"\",(IF(G30>0,\"!\",\" \")))","v":""}]
[]
["Vorbereitungstreffen"]
["ggf. Team und Teilnehmer unterscheiden",{"$nulls":4},{"$f":"IF(C33=\"\",\"\",C33)","v":""},{"$f":"IF(F33=\"\",\"\",(F33/($F$45/100)/100))","v":""},{"$f":"IF(G33=\"\",\"\",(IF(G33>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C34=\"\",\"\",C34)","v":""},{"$f":"IF(F34=\"\",\"\",(F34/($F$45/100)/100))","v":""},{"$f":"IF(G34=\"\",\"\",(IF(G34>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C35=\"\",\"\",C35)","v":""},{"$f":"IF(F35=\"\",\"\",(F35/($F$45/100)/100))","v":""},{"$f":"IF(G35=\"\",\"\",(IF(G35>0,\"!\",\" \")))","v":""}]
[]
["Ausfallgebühren für die Maßnahme"]
[{"$nulls":5},{"$f":"IF(C38=\"\",\"\",C38)","v":""},{"$f":"IF(F38=\"\",\"\",(F38/($F$45/100)/100))","v":""},{"$f":"IF(G38=\"\",\"\",(IF(G38>0,\"!\",\" \")))","v":""}]
[]
["Nachbereitungstreffen (einschl. Ausfallgebühren für dieses)"]
[" ggf. Team und Teilnehmer unterscheiden",{"$nulls":4},{"$f":"IF(C41=\"\",\"\",C41)","v":""},{"$f":"IF(F41=\"\",\"\",(F41/($F$45/100)/100))","v":""},{"$f":"IF(G41=\"\",\"\",(IF(G41>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C42=\"\",\"\",C42)","v":""},{"$f":"IF(F42=\"\",\"\",(F42/($F$45/100)/100))","v":""},{"$f":"IF(G42=\"\",\"\",(IF(G42>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C43=\"\",\"\",C43)","v":""},{"$f":"IF(F43=\"\",\"\",(F43/($F$45/100)/100))","v":""},{"$f":"IF(G43=\"\",\"\",(IF(G43>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C44=\"\",\"\",C44)","v":""},{"$f":"IF(F44=\"\",\"\",(F44/($F$45/100)/100))","v":""},{"$f":"IF(G44=\"\",\"\",(IF(G44>0,\"!\",\" \")))","v":""}]
[{"$nulls":4},"Summe Ausgaben",{"$f":"SUM(F7:F44)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G7:G44)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(G45>0,\"!\",\"\")","v":""}]
[]
["Einnahmen","Bemerkung","Einzelbetrag (oder Pauschale)","TN    (Teilnehmer)","Tage","Summe / Betrag","prozentual"]
["Zuschüsse"]
["z.B. Kirchenge- meinde, Kirchenkreis, sonstige kirchl. Träger, Landkreis, Gemeinde, Dritte ",{"$nulls":4},{"$f":"IF(C49=\"\",\"\",(IF(D49>0,C49*D49*E49,C49)))","v":""},{"$f":"IF(F49=\"\",\"\",(F49/($F$45/100)/100))","v":""},{"$f":"IF(G49=\"\",\"\",(IF(G49>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C50=\"\",\"\",(IF(D50>0,C50*D50*E50,C50)))","v":""},{"$f":"IF(F50=\"\",\"\",(F50/($F$45/100)/100))","v":""},{"$f":"IF(G50=\"\",\"\",(IF(G50>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C51=\"\",\"\",(IF(D51>0,C51*D51*E51,C51)))","v":""},{"$f":"IF(F51=\"\",\"\",(F51/($F$45/100)/100))","v":""},{"$f":"IF(G51=\"\",\"\",(IF(G51>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C52=\"\",\"\",(IF(D52>0,C52*D52*E52,C52)))","v":""},{"$f":"IF(F52=\"\",\"\",(F52/($F$45/100)/100))","v":""},{"$f":"IF(G52=\"\",\"\",(IF(G52>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C53=\"\",\"\",(IF(D53>0,C53*D53*E53,C53)))","v":""},{"$f":"IF(F53=\"\",\"\",(F53/($F$45/100)/100))","v":""},{"$f":"IF(G53=\"\",\"\",(IF(G53>0,\"!\",\" \")))","v":""}]
[{"$nulls":4},"Zwischensumme",{"$f":"SUM(F49:F53)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(F54=0,0,(F54/($F$45/100)/100))","v":{"v":0,"d":"0.00%"}},{"$f":"IF(G54>0,\"!\",\" \")","v":" "}]
["Spenden"]
[{"$nulls":5},{"$f":"IF(C56=\"\",\"\",C56)","v":""},{"$f":"IF(F56=\"\",\"\",(F56/($F$45/100)/100))","v":""},{"$f":"IF(G56=\"\",\"\",(IF(G56>0,\"!\",\" \")))","v":""}]
["Ersatzleistungen"]
["z.B. von Versicherungen",{"$nulls":4},{"$f":"IF(C58=\"\",\"\",(IF(D58>0,C58*D58*E58,C58)))","v":""},{"$f":"IF(F58=\"\",\"\",(F58/($F$45/100)/100))","v":""},{"$f":"IF(G58=\"\",\"\",(IF(G58>0,\"!\",\" \")))","v":""}]
[{"$nulls":5},{"$f":"IF(C59=\"\",\"\",(IF(D59>0,C59*D59*E59,C59)))","v":""},{"$f":"IF(F59=\"\",\"\",(F59/($F$45/100)/100))","v":""},{"$f":"IF(G59=\"\",\"\",(IF(G59>0,\"!\",\" \")))","v":""}]
["Teilnehmerbeitrag"]
[null,"zahlende TN",{"$nulls":3},{"$f":"IF(C61=\"\",\"\",C61*D61)","v":""},{"$f":"IF(F61=\"\",\"\",(F61/($F$45/100)/100))","v":""},{"$f":"IF(G61=\"\",\"\",(IF(G61>0,\"!\",\" \")))","v":""}]
[null,"TN mit anteiligem Beitrag",{"$nulls":3},"","",""]
[null,"TN ohne Beitrag",{"$nulls":3},"","",""]
[null,"TN - Unterstützung, Diakoniekasse",{"$nulls":3},"","",""]
[null,"Mitarbeiter / Betreuer",{"$nulls":3},"","",""]
[null,"Leiter",{"$nulls":3},"","",""]
[{"$nulls":3},{"$f":"IF((SUM(D61:D66))<0,\"\",(SUM(D61:D66)))","v":0},null,{"$f":"SUM(F61:F66)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"Summe Einnahmen",{"$f":"SUM(F54:F66)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G54:G66)","v":{"v":0,"d":"0.00%"}},{"$f":"IF(G68>0,\"!\",\" \")","v":" "}]
[]
["Rechnungsergebnis"]
["1.","Kosten pro Teilnehmer / in (ohne Leitungspersonal)",null,null,"Kosten",{"$f":"IF(E2=\"\",\"0,00 €\",(F45/E2))","v":{"$error":"#DIV/0!"}}]
["2.","Überschuss / Fehlbetrag",null,null,{"$f":"IF(F72>0,\"Überschuss\",\"Fehlbetrag\")","v":"Fehlbetrag"},{"$f":"F68-F45","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(F45>0,(F72/(F45/100)/100),\"0,00 %\")","v":"0,00 %"}]
[{"$nulls":6},"der Gesamtkosten"]
["3.","Überschuss / Fehlbetrag pro Teilnehmer/in (ohne Leitungspersonal)",null,null,{"$f":"IF(F74=\"\",\"\",(IF(F74>0,\"Überschuss\",\"Fehlbetrag\")))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E2=\"\",\"\",(F72/E2))","v":{"$error":"#DIV/0!"}}]