{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Abrechnung","Ligen"],"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":"Abrechnung","index":0,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[[49,1,49,7],[47,11,47,15],[49,9,49,10],[30,0,30,16],[31,0,31,16383],[32,0,32,16383],[39,0,39,16],[40,0,40,16383],[38,0,38,7],[29,6,29,8],[17,0,18,7],[20,0,20,7],[21,0,21,16],[48,11,48,15],[4,11,4,15],[6,0,6,6],[6,11,6,15],[23,0,23,16383],[27,6,27,8],[52,0,52,1],[51,0,51,1],[8,3,8,6],[8,11,8,15],[10,1,10,6],[51,10,51,11],[49,11,49,15],[51,12,51,15],[42,0,42,7],[44,0,44,7],[47,1,47,7],[48,1,48,7],[13,0,13,16],[22,0,22,16383],[8,0,8,2],[15,0,15,1],[0,2,0,13],[52,12,52,15],[52,10,52,11],[51,2,51,7],[52,2,52,7],[15,2,15,7],[10,11,10,12],[10,14,10,15],[2,7,2,10],[4,7,4,10],[8,7,8,10],[6,7,6,10],[10,7,10,10],[2,0,2,6],[2,11,2,15],[4,0,4,6]]}
[null,null,"Reisekostenabrechnung für Schiedsrichter\n(blaue Felder benutzen - beim Eintragen von Hand grüne Felder)"]
[]
[null,null,null,null,null,null,null,"Name,Vorname"]
[]
[null,null,null,null,null,null,null,"Straße "]
[]
[null,null,null,null,null,null,null,"PLZ Wohnort"]
[]
["Spielnummer ",null,null,null,null,null,null,"Begegnung"]
[]
["Ort",null,null,null,null,null,null,"Datum",null,null,null,null,null,"Uhrzeit"]
[]
[]
["Spielleitungs-Entschädigung"]
[]
["Spielklasse: ",null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(C16,Ligen!$A$2:$A$11,Ligen!$B$2:$B$11,\"\")","v":""},null,{"$f":"J16","v":""}]
[]
["Zuschlag Wochentagsspiele: \n(außer Feiertage alle Ligen + 10,00 €)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($L$3<>\"\",J18,\"\")","v":""}]
[]
[]
["Freundschaftsspiel: ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($L$3<>\"\",J21,\"\")","v":""}]
[]
[]
["Spielleitungs-Entschädigung Turniere"]
[]
[null,"Anzahl Sp.",null,"Halbz.",null,"Dauer/Halbz.",null,null,null,null,null,null,null,"Euro",null,"Euro"]
[]
[null,null,"x",null,"x",null," Min.  = ",null,null,{"$f":"ROUNDUP($B$28*$D$28*$F$28/10,0)*6","v":0},null,{"$f":"IF($L$3<>\"\",$J$28,\"\")","v":""}]
[]
[null,null,"x",null,"x",null," Min.  = ",null,null,{"$f":"ROUNDUP($B$30*$D$30*$F$30/10,0)*6","v":0},null,{"$f":"IF($L$3<>\"\",$J$30,\"\")","v":""}]
[]
[]
["Fahrtkosten"]
[null,"Wert",null,"KM",null,"Wert",null,"KM",null,null,null,null,null,"Euro",null,"Euro"]
["SR A ",0.3,"x",null,{"$f":"\"+\"","v":"+"},0.05,"x",null,null,{"$f":"((B35*D35)+(F35*H35))","v":0}]
[]
["SR B ",0.3,"x",null,{"$f":"\"+\"","v":"+"},0.05,"x",null,null,null,null,{"$f":"((B37*D37)+(F37*H37))","v":0}]
[]
["ÖPNV: "]
[]
[]
[]
["Gesamtsumme SR A / SR B",null,null,null,null,null,null,null,null,{"$f":"SUM(J16,J18,J21,J28,J30,J35,J39)","v":0},null,{"$f":"SUM(L16,L18,L21,L28,L30,L37,L39)","v":0}]
[]
["Gesamt:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J43,L43)","v":0}]
[]
[]
[null,"Betrag bar erhalten",null,null,null,null,null,null,null,null,null,"Betrag soll überwiesen werden"]
[null,"IBAN",null,null,null,null,null,null,null,null,null,"IBAN"]
["SR A:",null,null,null,null,null,null,null,null,"SR B:"]
[]
[{"$f":"L11","v":"00:00:00"},null,null,null,null,null,null,null,null,null,{"$f":"L11","v":"00:00:00"}]
["Datum",null,"Unterschrift",null,null,null,null,null,null,null,"Datum",null,"Unterschrift"]
[]
[]
["Mit der Unterschrift wird die Korrektheit der Angaben & die Veranlassung der erforderlichen Steuererklärung bestätigt."]
["Erwachsene: RL = 70,00; OL = 55,00; VL =40,00; Pokal 45,00"]
["Jugend: A RL/OL = 35,00; B RL/OL = 30,00; C RL/OL = 25,00; Westf-Ms = 30,00; Turnier 6,00 /10 min."]

{"sheet":"Ligen","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Regionalliga Erwachsene",70]
["Oberliga Erwachsene",55]
["Verbandsliga Erwachsene",40]
["Regionalliga A-Jugend",35]
["Regionalliga B-Jugend",30]
["Regionalliga C-Jugend",25]
["Oberliga A-Jugend",35]
["Oberliga B-Jugend",30]
["Oberliga C-Jugend",25]
["Westfalen-Meisterschaft",30]
["Turnier","6,00 €/10 min"]