{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Formular 2012"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Formular 2012","index":0,"n_rows":91,"n_cols":43,"rows_kept":91,"cut":false,"hidden":false,"merged":[[29,18,29,20],[11,7,11,9],[29,11,29,12],[44,16,44,17],[0,31,2,36],[22,31,22,33],[22,34,22,35],[32,31,32,35],[42,14,42,15],[26,11,26,12],[30,25,31,26],[40,7,40,9],[59,34,60,34],[44,26,44,27],[5,1,5,27],[13,1,13,27],[16,1,16,27],[28,18,28,20],[11,10,11,14],[26,7,26,9],[42,5,42,6],[44,14,44,15],[90,18,90,26],[87,18,87,26],[44,12,44,13],[42,26,42,27],[32,25,33,27],[32,14,33,20],[32,7,33,12],[55,25,55,26],[44,22,44,23],[40,16,40,17],[28,7,28,9],[38,14,38,15],[29,14,29,16],[30,14,31,20],[85,18,85,26],[46,26,46,27],[46,22,46,23],[49,17,49,23],[42,16,42,17],[57,3,57,13],[30,7,31,12],[0,0,2,14],[8,1,9,1],[40,5,40,6],[38,7,38,9],[38,5,38,6],[40,1,40,4],[28,11,28,12],[28,14,28,16],[46,12,46,13],[38,1,38,4],[46,5,46,6],[88,1,88,9],[46,16,46,17],[90,1,90,8],[90,10,90,16],[89,1,89,8],[89,10,89,16],[46,1,46,4],[40,22,40,23],[26,26,26,27],[42,7,42,9],[28,26,28,27],[26,18,26,20],[88,10,88,16],[40,26,40,27],[40,12,40,13],[42,12,42,13],[60,11,61,11],[46,7,46,9],[46,14,46,15],[44,5,44,6],[30,1,31,5],[32,1,32,3],[36,1,36,2],[42,1,42,4],[44,7,44,9],[36,7,36,26],[40,19,40,21],[20,7,20,27],[42,22,42,23],[51,3,52,27],[53,3,53,9],[55,3,55,6],[9,2,9,27],[38,22,38,23],[38,16,38,17],[38,12,38,13],[38,26,38,27],[49,3,49,14],[44,1,44,4],[7,18,7,27],[18,7,18,27],[22,7,22,27],[22,5,22,6],[7,2,7,6],[7,7,7,9],[7,10,7,14],[11,2,11,6],[49,25,49,26],[11,18,11,27],[88,25,88,26],[40,14,40,15],[86,1,86,8],[82,10,84,17],[79,1,80,27],[53,10,55,11],[82,1,84,9],[65,2,65,9],[57,15,57,16],[84,18,84,26],[49,15,49,16],[87,1,87,8],[85,10,85,16],[86,10,86,16],[87,10,87,16],[85,1,85,9],[74,25,74,26],[53,25,53,26],[82,18,83,27],[60,2,61,9],[57,17,57,23],[59,13,59,14],[53,17,56,23],[67,25,67,26],[71,25,71,26],[55,15,55,16],[68,2,70,10],[53,15,53,16],[69,25,69,26],[57,25,57,26],[76,14,76,26],[63,2,63,9],[89,18,89,26],[38,19,38,21],[88,18,88,24],[42,19,42,21],[44,19,44,21],[46,19,46,21]]}
["Dozenten-Vertrag Aus- und Fortbildung Schiedsrichter ab 07/2019",{"$nulls":14},"Datum",{"$nulls":4},"Beleg Nr."]
[{"$nulls":15},"Kto Soll",{"$nulls":4},"Kto Haben"]
[]
[]
[]
[null,"zwischen dem Sächsischen Sportverband Volleyball e.V.  - im folgenden SSVB genannt - und"]
[]
[null,"Name",{"$nulls":5},"Vorname",{"$nulls":8},"Funktion"]
[null,"Wohn-anschrift"]
[]
[]
[null,"Bank","                          ",{"$nulls":4},"BIC",{"$nulls":8},"IBAN"]
[]
[null,{"$f":"\"- im folgenden Dozent genannt - wird folgendes vereinbart:\"","v":"- im folgenden Dozent genannt - wird folgendes vereinbart:"}]
[]
[]
[null,"Der Dozent übernimmt einen Lehrauftrag für die aufgeführte Veranstaltung:"]
[]
[null,"Lehrgang","Trainer/Schiedsrichter"]
[null,null,"nicht zutreffendes streichen"]
[null,"Thematik"]
[]
[null,"Lehrgangsorte",{"$nulls":29},"Geltende Sätze",null,null,"ab 2017"]
[]
[]
[{"$nulls":31},"mit","ohne","Rad","Mitf"]
[null,"Beförderungsmittel",{"$nulls":5},"Bahn",null,null,null,"Flugzeug",null,null,"Dienst-Kfz",null,null,null,"Privat-Kfz",{"$nulls":12},0.3,0.17,0.05,0.02,"€/km","Wegstrecken- und Mitnahmeentschädigung"]
[]
[{"$nulls":7},"Bus/Tram",null,null,null,"Mitfahrer"]
[{"$nulls":14},"amtl. Kennzeichen",null,null,null,{"$f":"O30","v":"amtl. Kennzeichen"}]
[null,"triftige Gründe für die Benutzung eines Kfz ",{"$nulls":5},"Geschäftsort mit der Bahn nicht oder sehr schwer erreichbar",{"$nulls":6},"Erledigung von Dienstgeschäften an verschiedenen Geschäftsorten",{"$nulls":10},"Einsparung von Reisekosten"]
[]
[null,{"$f":"\"(ohne nur \"&TEXT(AH26,\"0,## €\")&\"/km)\"","v":"(ohne nur Rad/km)"},{"$nulls":5},"Mitnahme von weiteren Dienstreisenden",{"$nulls":6},"Mitnahme von dienstlichem Gepäck, umfangreichen Akten etc.",{"$nulls":10},"erhebliche Arbeitszeitersparnis"]
[]
[]
[]
[null,"Abrechnung",{"$nulls":4},"Fahrt von/nach"]
[]
[null,"Zeitraum des Lehrgangs",{"$nulls":9},"Datum","Uhrzeit",null,"Beginn",null,null,null,"Ende",{"$nulls":7},"UE",{"$nulls":4},"Anz","1.Tag","2.Tag","3.Tag","4.Tag","5.Tag","Summe"]
[]
[{"$nulls":11},"Datum","Uhrzeit",null,"Beginn",null,null,null,"Ende",{"$nulls":7},"UE",{"$nulls":4},"Tg",{"$f":"IF($H$39<>\"\",1,0)","v":0},{"$f":"IF($H$41<>\"\",1,0)","v":0},{"$f":"IF($H$43<>\"\",1,0)","v":0},{"$f":"IF($H$45<>\"\",1,0)","v":0},{"$f":"IF($H$47<>\"\",1,0)","v":0},{"$f":"SUM(AG41:AK41)","v":0},"","","","",""]
[]
[{"$nulls":11},"Datum","Uhrzeit",null,"Beginn",null,null,null,"Ende",{"$nulls":7},"UE",{"$nulls":4},"UE",{"$f":"IF(H39<>0,Z39,\"\")","v":""},{"$f":"IF(H41<>0,Z41,\"\")","v":""},{"$f":"IF(H43<>0,Z43,\"\")","v":""},{"$f":"IF(H45<>0,Z45,\"\")","v":""},{"$f":"IF(H47<>0,Z47,\"\")","v":""},{"$f":"SUM(AG43:AK43)","v":0},0,0,0,0,0]
[]
[{"$nulls":11},"Datum","Uhrzeit",null,"Beginn",null,null,null,"Ende",{"$nulls":7},"UE",{"$nulls":4},"Std","-","-","-","-","-","-","-","-","-","-","-"]
[]
[{"$nulls":11},"Datum","Uhrzeit",null,"Beginn",null,null,null,"Ende",{"$nulls":7},"UE",{"$nulls":4},0,"","","","","","","","","","",""]
[]
[null,"tatsächliche Ausgaben"]
[null,"Honorar",null,"Das Honorar beträgt 20 € pro Unterrichtseinheit (45 Minuten)",{"$nulls":11},{"$f":"IF(AL43<>0,AL43,\"\")","v":""},null,"    Unterrichtseinheiten",{"$nulls":7},{"$f":"IF(P50<>\"\",P50*20,\"\")","v":""},null,"€"]
[]
[null,"Fahrtkosten",null,"Die Fahrtkostenerstattung bzw. Wegstrecken- und Mitnahmeentschädigung erfolgt durch den SSVB vom Wohnort zum Lehrgsangsort und zurück."]
[]
[null,null,null,"Benutzung Deutsche Bahn laut Beleg",{"$nulls":11},"Erstattungs-km",null,{"$f":"\"(triftige Gründe: 0,30 €/km\n ohne: 0,17 €/km)\"","v":"(triftige Gründe: 0,30 €/km\n ohne: 0,17 €/km)"},{"$nulls":9},"€"]
[]
[null,null,null,"Benutzung Privat-Kfz",null,null,null,"Ges-km",{"$nulls":7},{"$f":"IF(J56<>\"\",J56,\"\")","v":""},{"$nulls":9},{"$f":"IF(P56<>\"\",P56*AF56,\"\")","v":""},null,"€",null,null,null,{"$f":"IF(COUNTA(G31,N31,W31,G33,N33,W33)=0,AG27,AF27)","v":0.17},"Erstattungsssatz"]
[]
[null,0.02,null,{"$f":"\"Mitnahmeentschädigung für \"&IF(COUNTA(C64:J66)>0,COUNTA(C64:J66),\"___\")&\" Person(en)\"","v":"Mitnahmeentschädigung für ___ Person(en)"},{"$nulls":11},{"$f":"IF(J56>0,IF(COUNTA(C64,L64)>0,SUM(L64:L66),\"\"),\"\")","v":""},null,{"$f":"\"(pro Person \"&TEXT(AI27,\"0,00\")&\" €/km)\"","v":"(pro Person 0,02 €/km)"},{"$nulls":7},{"$f":"IF(P58<>\"\",IF(P58>0,P58*AI27,\"\"),\"\")","v":""},null,"€"]
[{"$nulls":31},"Tagegeldkürzung"]
[{"$nulls":12},"(* mindestens jedoch der jeweilige Sachbezugswert für 2004:      F",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"M",{"$f":"#REF!","v":{"$error":"#REF!"}},")",{"$nulls":13},"F","M","A","von\n24,00"]
[null,null,"Namen der Mitfahrer ",{"$nulls":8},"Mitnahme-\nkilometer",{"$nulls":19},0.2,0.4,0.4]
[{"$nulls":31},"-","-","-","-"]
[]
[{"$nulls":31},"-","-","-","-"]
[]
[{"$nulls":31},"-","-","-","-"]
[]
[{"$nulls":14},"Kosten gesamt",{"$nulls":10},{"$f":"IF(SUM(Z50:AA59)<>0,SUM(Z50:AA59),\"\")","v":""},null,"€",null,null,null,"-","-","-","-"]
[]
[{"$nulls":22},"zzgl. Kraftstoffkosten für Dienst-Kfz (laut Beleg)",{"$nulls":4},"€"]
[]
[{"$nulls":22},"abzüglich Vorschuss",{"$nulls":4},"€"]
[]
[]
[{"$nulls":14},"noch zu überweisender Betrag",{"$nulls":10},{"$f":"IF(SUM(Z68,Z70,-Z72)<>0,SUM(Z68,Z70,-Z72),\"\")","v":""},null,"€"]
[{"$nulls":14},"Betrag in Worten:"]
[]
[]
[]
[null,"Die o. g. Person ist verpflichtet, die aus diesem Vertrag erzielten Einkünfte aus Honorartätigkeiten selbst zu versteuern und für eventuelle Abgaben zur Sozialversicherung zu sorgen."]
[]
[]
[null,"Einen Vorschuss habe ich erhalten / nicht erhalten.\nDie nachgewiesenen Ausgaben waren notwendig und unvermeidbar. Rechnungsbelege sind beigefügt. \nIch versichere die Richtigkeit meiner Angaben.",{"$nulls":8},"Ordnungsgemäße Durchführung des Lehrgangs und sachliche Richtigkeit der Abrechnung überprüft und bestätigt.\n",{"$nulls":7},"Rechnerische Richtigkeit überprüft und bestätigt.\nBanküberweisung / Auszahlung am: "]
[]
[]
[null,"Datum:",{"$nulls":8},"Datum:",{"$nulls":7},"Unterschrift zuständiger Finanzbearbeiter"]
[]
[null,"Unterschrift Dozent",{"$nulls":8},"Unterschrift zuständiger Landeslehrwart"]
[{"$nulls":10},"Datum:",{"$nulls":7},"Datum:"]
[]
[{"$nulls":10},"Unterschrift Geschäftsführer SSVB",{"$nulls":7},"Betrag bar erhalten / Unterschrift Dozent"]