{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Ausbildungsgebühren","Abrechnung","Personenkosten"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Ausbildungsgebühren","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,3],[2,0,2,11],[3,0,3,11],[6,2,6,10],[8,1,8,2],[8,9,8,11],[14,0,14,1],[14,2,14,3],[14,4,14,5],[14,9,14,11],[15,0,15,1],[15,2,15,3],[15,4,15,5],[15,9,15,11],[10,9,11,11],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,9,12,11],[13,0,13,1],[13,2,13,3],[13,4,13,5],[13,9,13,11],[10,0,11,1],[10,2,11,3],[10,4,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,9,18,11],[19,0,19,1],[19,2,19,3],[19,4,19,5],[19,9,19,11],[16,0,16,1],[16,2,16,3],[16,4,16,5],[16,9,16,11],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,9,17,11],[22,0,22,1],[22,2,22,3],[22,4,22,5],[22,9,22,11],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,9,23,11],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,9,20,11],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,9,21,11],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,9,26,11],[27,0,27,1],[27,2,27,3],[27,4,27,5],[27,9,27,11],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,9,24,11],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,9,25,11],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,9,30,11],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,9,31,11],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,9,28,11],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,9,29,11],[34,0,34,5],[34,9,34,11],[36,0,36,11],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,9,32,11],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,9,33,11]]}
["Deutscher Retriever Club e.V."]
["             -Landesgruppe Südwest-"]
["Beiblatt Ausbildungsgebühren"]
[]
[null,null,null,"Ausbilder",null,{"$f":"TEXT(Abrechnung!B8,)","v":""}]
[]
["Veranstaltung:",null,{"$f":"TEXT(Abrechnung!B4,)","v":""}]
[]
["Ort:",{"$f":"TEXT(Abrechnung!B5,)","v":""},null,"Datum:",{"$f":"TEXT(Abrechnung!C6,\"TT.MM.JJJJ\")","v":"00.01.1900"},"bis",{"$f":"TEXT(Abrechnung!F6,\"TT.MM.JJJJ\")","v":"00.01.1900"},null,"Veranstalter:","DRC  LG Südwest"]
[]
["Name",null,null,null,null,null,null,"Gebühr","Bezahlt","Bemerkung"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ausbildungsgebühren:",null,null,null,null,null,null,{"$f":"SUM(H13:H34)","v":0}]
[]
["Z.Zt. Gültige Gebühren: Welpenprägung 90€, Jung- und Begleithunde 120€, Dummykurs 120€, BLP- Kurse 180€, JAS Infotag 65€,"]
["RGP Kurse 360€  zzgl. Gebühr für lebende Ente.            Weitere Gebühren nach Abrechnungsgrundsätze Ausbilder.",null,null,null,null,null,null,null,null,null,null,"Stand: 10.2025"]

{"sheet":"Abrechnung","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,5],[44,0,44,8],[45,0,45,8],[9,3,9,4],[43,3,43,6],[36,0,37,6],[11,1,11,2],[39,1,39,8],[40,1,40,8],[41,1,41,2],[41,4,41,8],[42,2,42,4],[42,5,42,8],[6,1,6,4],[6,7,6,8],[7,1,7,4],[7,6,7,8],[8,3,8,4],[3,1,3,4],[4,1,4,4],[5,2,5,3],[5,5,5,6],[0,1,0,5],[1,1,1,5]]}
[null,"Deutscher Retriever Club e.V."]
[null,"Kostenabrechnung für Ausbildung"]
[]
["Art der Ausbildung:"]
["Ort:"]
["Ausbildungszeitraum:","vom",null,null,"bis"]
["Veranstalter","Landesgruppe Südwest",null,null,null,"Kostenstelle:",null,"5002"]
["Ausbildungsleiter:",null,null,null,null,"Telefon:"]
["Anzahl der Ausbilder:",null,null,"Anzahl der Helfer:"]
["Anzahl der Hunde:",null,null,"gemeldet und bezahlt:"]
[]
["Einnahmen","Ausbildungsgebühren",null,null,null,"- 44 005 -","=",{"$f":"SUM(Ausbildungsgebühren!H35)","v":0}]
[null,"Bewirtung (Verkauf)",null,null,null,"- 44 010 -","="]
[null,"Spenden",null,null,null,"- 40 400 -","="]
[null,null,null,null,null,"gesamt","=",{"$f":"SUM(H12:I14)","v":0}]
["Ausgaben","Porto",null,null,null,"- 68 000 -","="]
[null,"Telefon",null,null,null,"- 68 050 -","="]
[null,"Bürobedarf (auch Kopien)",null,null,null,"- 68 150 -","="]
[null,"Platzmiete/Raumkosten",null,null,null,"- 63 100 -","="]
[null,"Honorare für Ausbilder/Referenten auf Rechnung",null,null,null,"- 64 323 -","="]
[null,"Verpflegung Referenten etc.",null,null,null,"- 64 402 -","="]
[null,"Pokale, Preise",null,null,null,"- 64 303 -","="]
[null,"Munition",null,null,null,"- 64 321 -","="]
[null,"Präsente",null,null,null,"- 66 250 -","="]
[null,"Personenkosten (Beiblatt einfügen)"]
[null,null,"Fahrtkosten",null,null,"- 66 680 -","=",{"$f":"SUM(Personenkosten!G36)","v":0}]
[null,null,"Tagegelder",null,null,"- 66 500 -","=",{"$f":"SUM(Personenkosten!H36)","v":0}]
[null,null,"Übernachtungskosten",null,null,"- 66 600 -","="]
[null,"Wareneinkauf (für Bewirtung gegen Bezahlung)",null,null,null,"- 52 000 -","="]
[null,"Sonstige Ausgaben",null,null,null,"- 68 500 -","="]
["akzeptiert",null,null,null,null,"gesamt","=",{"$f":"SUM(H16:H30)","v":0}]
["Einnahmen (gesamt)",null,null,null,null,null,"=",{"$f":"H15","v":0}]
["Ausgaben (gesamt)",null,null,null,null,null,"=",{"$f":"H31","v":0}]
["Endergebnis €",null,null,null,null,null,"=",{"$f":"SUM(H32-H33)","v":0}]
["Vorschuss (minus, wenn E = Verlust / plus, wenn E = Gewinn)",null,null,null,null,"-13 729 -","="]
["Überweisungsbetrag",null,null,null,null,"- Kto. Bank -","=",{"$f":"SUM(H34+H35)","v":0}]
["Überweisungsbetrag an                    Deutscher Retriever Club (DRC)                                                  IBAN:DE10 3007 0024 0977 7707 38     BIC:DEUTDEDBDUE    Deutsche Bank AG"]
[]
["Bitte überweisen Sie den Fehlbetrag an:"]
["Name:"]
["Straße:"]
["PLZ:",null,null,"Ort:"]
["Bankverbindung:","IBAN:",null,null,null,"BIC:"]
[null,null,"Kreditinstitut:"]
["Sämtliche Belege der Ausbildung sind hinter dieses Deckblatt einzuheften und die Summen der einzelnen Kostenarten gewissenhaft in"]
["die Positionen einzutragen. Der Kassenwart hat zu gewährleisten, dass keine Erstattung von Beträgen ohne Originalbeleg erfolgt.",null,null,null,null,null,null,null,null,"Sämtliche Belege der Schau sind hinter dieses Deckblatt einzuheften und die Summen der einzelnen Kostenarten gewissenhaft in die Positionen einzutragen. Der Kassenwart hat zu gewährleisten, dass keine Erstattung von Beträgen ohne Originalbeleg erfolgt. No"]
["Notfalls sind durch den Ausbildungsleiter Eigenbelege zu erstellen. ",null,null,null,null,null,null,"Stand 10.2025"]

{"sheet":"Personenkosten","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,10,11,11],[12,0,12,1],[14,0,14,1],[14,2,14,3],[14,4,14,5],[0,0,0,10],[2,0,2,11],[3,0,3,11],[10,0,11,1],[10,2,11,3],[10,4,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[8,1,8,2],[6,2,6,10],[8,9,8,10],[1,0,1,3],[12,2,12,3],[12,4,12,5],[12,10,12,11],[14,10,14,11],[13,0,13,1],[15,10,15,11],[16,10,16,11],[16,2,16,3],[17,0,17,1],[15,0,15,1],[15,2,15,3],[15,4,15,5],[16,4,16,5],[16,0,16,1],[17,10,17,11],[13,2,13,3],[13,4,13,5],[13,10,13,11],[26,0,26,1],[26,2,26,3],[22,0,22,1],[22,2,22,3],[23,0,23,1],[32,10,32,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[26,10,26,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[23,4,23,5],[24,4,24,5],[24,0,24,1],[18,0,18,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[21,0,21,1],[21,2,21,3],[21,4,21,5],[20,0,20,1],[20,2,20,3],[18,4,18,5],[18,2,18,3],[19,0,19,1],[19,2,19,3],[19,4,19,5],[31,4,31,5],[30,10,30,11],[31,10,31,11],[31,2,31,3],[17,2,17,3],[29,4,29,5],[33,10,33,11],[34,10,34,11],[34,4,34,5],[32,4,32,5],[30,4,30,5],[21,10,21,11],[17,4,17,5],[20,4,20,5],[22,4,22,5],[20,10,20,11],[19,10,19,11],[18,10,18,11],[23,2,23,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[31,0,31,1],[35,10,35,11],[38,3,38,10],[32,0,32,1],[33,0,33,1],[34,0,34,1],[34,2,34,3],[33,2,33,3],[35,0,35,5],[32,2,32,3],[37,0,37,11],[33,4,33,5]]}
["Deutscher Retriever Club e.V."]
["             -Landesgruppe Südwest-"]
["Beiblatt der Personenkosten"]
["für Ausbildung"]
[]
[]
["Veranstaltung:",null,{"$f":"TEXT(Abrechnung!B4,)","v":""}]
[]
["Ort:",{"$f":"TEXT(Abrechnung!B5,)","v":""},null,"Datum:",{"$f":"TEXT(Abrechnung!C6,\"TT.MM.JJJJ\")","v":"00.01.1900"},"bis",{"$f":"TEXT(Abrechnung!F6,\"TT.MM.JJJJ\")","v":"00.01.1900"},null,"Veranstalter:","DRC  LG Südwest"]
[]
["Funktion",null,"Name",null,"DSGVO zur Kentniss genommen",null,"Fahrtkosten km X 0,35 €","Tagegeld",null,"Summe Sp. 4 bis 6","Unterschrift Quittung"]
[]
[1,null,2,null,3,null,4,5,null,6,7]
["Ausbilder ",null,{"$f":"TEXT(Abrechnung!B8,)","v":""},null,"akzeptiert      ",null,null,null,null,{"$f":"SUM(G14:I14)","v":0}]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
[null,null,null,null,"akzeptiert      ",null,null,null,null,0]
["Gesamtbetrag",null,null,null,null,null,{"$f":"SUM(G14:G35)","v":0},{"$f":"SUM(H14:H35)","v":0},null,{"$f":"SUM(J14:J35)","v":0}]
[null,null,null,null,null,null,"66 680","66 500"]
["Zur Zeit gelten folgende Abrechnungssätze:        0,35 € pro Kilometer                  Übernachtungskosten nach Beleg"]
[null,null,null,"      50,00 € Tagegeld pro Tag;           25,00 € Tagegelg pro ½ Tag\u008f",null,null,null,null,null,null,null,"Stand: 10.2025"]