{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Abrechnungsformular"],"not_rendered":{"charts":0,"images":1,"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":"Abrechnungsformular","index":0,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":false,"merged":[[11,2,12,8],[11,0,12,1],[65,0,65,3],[60,1,60,2],[64,0,64,3],[64,4,65,6],[62,4,62,6],[60,4,60,6],[71,6,71,8],[70,6,70,7],[69,6,69,7],[70,0,72,2],[64,7,65,8],[68,0,68,2],[0,0,0,8],[1,0,1,8],[63,4,63,6],[63,1,63,2],[10,0,10,1],[56,6,56,7],[56,4,56,5],[59,1,59,2],[61,1,61,2],[62,1,62,2],[8,3,8,4],[9,7,9,8],[59,4,59,6],[61,4,61,6],[10,2,10,6],[56,1,56,2],[84,4,85,5],[84,6,85,8],[84,0,85,2],[77,6,78,8],[81,6,82,8],[81,4,82,5],[81,0,82,0],[81,1,82,2],[77,4,78,5]]}
["DLRG-Jugend Rhein-Neckar"]
["Abrechnungsformular/Rechnungsbegleitschein"]
["Version 3.1.2"]
[]
["Rechnung ",null,"siehe Rückseite / Anlage"]
["Nur Rechnungen, die direkt mit dem Jugendkonto verrechnet werden!"]
["Fahrtkosten",null,null,null,null,null,false]
["Beleg (Quittung/Rechnung)",null,"siehe Rückseite / Anlage"]
["Sonstiges",null,null,null,null,null,3]
["Telekommunikation (TK)",null,"pauschal max. 40 € / 20 €",null,null,null,"Monat:",{"$f":"IF(OR(G9=5,G9=6),TODAY(),IF(G9=7,\"\",\" - \"))","v":" - "}]
[null,null,"erhöhter Satz (Telekommunikation für 1./2. Vorsitzende/r)"]
["Beschreibung/Zweck:"]
[]
["Aufbaulehrgang (6002)",null,null,null,null,null,null,null,"Januar"]
["Beamer (6508)",null,null,null,"Roland Metzner",70301,null,null,"Februar"]
["BeJR (6307)",null,null,null,"Karsten Kropp",70303,null,null,"März"]
["BeJT (6304)",null,null,null,"Susanne Böttcher",70323,null,null,"April"]
["BeJV-Sitzungen (6301)",null,null,null,"Lena Maun",70305,null,null,"Mai"]
["Bezirksmeisterschaften (6201)",null,null,null,"Jessica Fischer",70309,null,null,"Juni"]
["Büromaterial (6401)",null,null,null,"Steffen Gärtner",70313,null,null,"Juli"]
["Fahrzeug Bus HD-RN9915 (6511)",null,null,null,"Marius Sauerborn ",70315,null,null,"August"]
["Fahrzeug Anhänger HD-RN9910 (6512)",null,null,null,"Simone Goll",70318,null,null,"September"]
["Freizeiten (6100)",null,null,null,"Patrik Ehrhard",70319,null,null,"Oktober"]
["Fusion (6309)",null,null,null,"Andrea Freisinger",70320,null,null,"November"]
["Geschäftsaustattung (650)",null,null,null,"Tobias Pogadl",70321,null,null,"Dezember"]
["Geschenke (6406)",null,null,null,"Thorsten Kilian",70321,null,null,{"$f":"\" - \"","v":" - "}]
["Gremien (6300)"]
["Grundlehrgang (6001)"]
["Hüttenwochenende (6101)"]
["Internetgebühren (6407)"]
["Jugendleiterlehrgang (6004)"]
["Kampfrichterlehrgang/-Fortbildungen (6003)"]
["Kinderzeltlager (6102)"]
["Landesmeisterschaften (6203)"]
["Lehrgänge und Seminare (6000)"]
["LJR/LJT (6308)"]
["Mieten (6506)"]
["Öffentlichkeitsarbeit (6404)"]
["Pfingstzeltlager (6103)"]
["Porto - Allgemein (6402)"]
["Quietscheentchen-Lehrgang (6005)"]
["Reisekosten - Allgemein (6405)"]
["Ressort KiGa (6306)"]
["Ressort SRuS (6302)"]
["Ressort WuF (6303)"]
["Sonstige Kosten (6501)"]
["Sportveranstaltungen (6200)"]
["Telefon - Allgemein (6403)"]
["Trainingsmethodiklehrgang (6007)"]
["Verwaltung - Allgemein (6400)"]
["Vorbereitungslehrgang Ausbildungsassistent (6008)"]
["Zuschüsse an Gruppen (6502)"]
[]
[]
[null,null,null,null,null,null,null,false,false]
[null,null,null,null,null,null,null,{"$f":"IF(H55=I55,0,IF(H55=TRUE,0.13,0.3))","v":0},{"$f":"IF(H55=I55,0,IF(H55=TRUE,0.01,0.02))","v":0}]
["Betrag:",{"$f":"IF(G9=5,IF(G7,40,20),C79)","v":0},null,null,"Belegnr.: \n(wird vom Leiter WuF ausgefüllt)",null,"Belegnr.",null,"Kürzel"]
[]
["Zahlungsempfänger: (bei Rechnungen nicht notwendig)",null,null,null,"Buchung: (bitte immer angeben)",null,null,"Anteil","Betrag"]
["Gliederung:",null,null,null,{"$f":"IF(G9=2,\"Reisekosten - Allgemein (6405)\",IF(G9=5,\"TK - Allgemein (6403)\",\"\"))","v":""},null,null,1,{"$f":"IF(SUM($H$60:$H$64)=0,0,$B$57/SUM($H$60:$H$64)*H60)","v":0}]
["Konto-Inhaber:",null,null,null,null,null,null,null,{"$f":"IF(SUM($H$60:$H$64)=0,0,$B$57/SUM($H$60:$H$64)*H61)","v":0}]
["Konto-Nr.:",null,null,null,null,null,null,null,{"$f":"IF(SUM($H$60:$H$64)=0,0,$B$57/SUM($H$60:$H$64)*H62)","v":0}]
["BLZ:",null,null,null,null,null,null,null,{"$f":"IF(SUM($H$60:$H$64)=0,0,$B$57/SUM($H$60:$H$64)*H63)","v":0}]
["Bank:",null,null,null,null,null,null,null,{"$f":"IF(SUM($H$60:$H$64)=0,0,$B$57/SUM($H$60:$H$64)*H64)","v":0}]
["Bitte die Kontodaten nur bei erstmaliger Abrechnung oder bei Änderung angeben!",null,null,null,"Habenkonto:\n(wird vom Leiter WuF ausgefüllt)",null,null,{"$f":"IF(ISERROR(VLOOKUP(B61,E15:F54,2,FALSE())),\"\",VLOOKUP(B61,E15:F54,2,FALSE()))","v":""}]
[]
[]
["Fahrtkostenabrechnung:",null,null,null,"Rechnungsbegleitschein:"]
["PKW: 0,30 €/km + 0,02 €/km je Mitfahrer; ab 200ten km 50%;                                 Motorrad: 0,13 €/km + 0,01 €/km je Mitfahrer; ab dem 200ten km 50 %",null,null,null,"Rechnungen sind alle Belege, die direkt mit dem Jugendkonto verrechnet werden"]
["Fahrstrecke:",null,null,null,"Rechnungsdatum:"]
[null,null,null,null,"Eingangsdatum:"]
[null,null,null,null,"Fremde R.-Nr:"]
[null,null,null,null,0]
["Namen der Mitfahrer:",null,null,null,null,"Barauszahlung"]
[null,null,null,null,null,"Überweisung"]
[null,null,null,null,null,"Lastschrift / EC-Cash"]
["gefahrene Kilometer:"]
["KM-Satz:",null,null,null,"Sachliche & rech-nerische Prüfung:",null,"Unterschrift"]
[" = Fahrtkosten:",null,{"$f":"IF(A71=\"\",0,IF(C77>=200.5,(200*(H56+COUNTA(A75:C76)*I56))+0.5*((C77-200)*(H56+(COUNTA(A75:C76)*I56))),C77*(H56+(COUNTA(A75:C76)*I56))))","v":0}]
[]
[]
["Datum:","Datum",null,null,"Unterschrift Antragsteller:",null,"Unterschrift"]
[]
[]
["Bitte Belege zeitnah an den \nLeiter WuF weiterleiten!",null,null,null,"Genehmigung:\n(1./2. Vorsitzende/r)",null,"Unterschrift"]