{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stand 2021.09.27","Daten","Historie"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":11,"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":"Stand 2021.09.27","index":0,"n_rows":74,"n_cols":18,"rows_kept":74,"cut":false,"hidden":false,"merged":[[74,1,74,18],[63,16,63,17],[69,16,69,17],[59,14,61,14],[52,14,53,14],[48,14,51,18],[1,16,1,17],[52,16,53,17],[59,16,61,17],[65,16,67,17],[21,13,21,14],[21,15,21,18],[19,15,19,18],[33,13,33,14],[33,15,33,18],[34,13,34,14],[34,15,34,18],[31,13,31,14],[31,15,31,18],[22,15,22,18],[56,11,58,18],[41,1,41,6],[38,14,38,18],[42,14,42,15],[39,14,39,15],[39,16,39,17],[40,16,40,17],[40,14,40,15],[42,7,42,8],[38,1,38,12],[41,14,41,15],[41,16,41,17],[42,16,42,17],[46,14,46,16],[43,14,43,18],[41,7,41,8],[41,9,41,10],[42,9,42,10],[43,1,43,12],[46,3,46,6],[44,3,44,8],[45,3,45,8],[42,1,42,6],[45,15,45,16],[44,15,44,16],[54,16,54,17],[33,1,33,2],[33,3,33,4],[33,9,33,11],[34,1,34,2],[34,3,34,4],[34,9,34,11],[31,1,31,2],[31,3,31,4],[31,9,31,11],[35,1,35,2],[35,3,35,4],[35,9,35,11],[35,13,35,14],[35,15,35,18],[36,9,36,11],[36,1,36,5],[36,13,36,18],[40,9,40,10],[39,7,39,8],[39,9,39,12],[40,7,40,8],[39,1,39,6],[40,1,40,6],[32,15,32,18],[29,1,29,2],[29,3,29,4],[29,9,29,11],[29,13,29,14],[29,15,29,18],[30,1,30,2],[30,3,30,4],[30,9,30,11],[30,13,30,14],[30,15,30,18],[32,9,32,11],[32,13,32,14],[23,1,23,2],[28,15,28,18],[26,1,26,2],[26,3,26,4],[26,9,26,11],[26,13,26,14],[26,15,26,18],[27,1,27,2],[27,3,27,4],[27,9,27,11],[27,13,27,14],[27,15,27,18],[18,15,18,18],[15,3,15,6],[16,15,16,18],[25,15,25,18],[20,15,20,18],[24,13,24,14],[23,13,23,14],[23,15,23,18],[20,3,20,4],[20,9,20,11],[23,3,23,4],[23,9,23,11],[25,3,25,4],[24,3,24,4],[24,9,24,11],[21,3,21,4],[21,9,21,11],[19,3,19,4],[18,9,18,11],[22,1,22,2],[15,1,16,2],[17,1,17,2],[17,9,17,11],[7,12,7,14],[16,13,16,14],[8,6,8,11],[12,1,12,5],[10,6,10,11],[18,13,18,14],[20,1,20,2],[7,15,7,18],[15,9,15,11],[16,9,16,11],[48,1,48,4],[48,10,48,12],[25,13,25,14],[28,1,28,2],[28,3,28,4],[28,9,28,11],[28,13,28,14],[32,1,32,2],[32,3,32,4],[10,15,11,18],[24,15,24,18],[12,6,12,11],[17,15,17,18],[11,1,11,5],[7,1,7,5],[10,1,10,5],[7,6,7,11],[22,3,22,4],[25,1,25,2],[24,1,24,2],[21,1,21,2],[59,3,59,7],[61,3,61,7],[68,1,68,9],[49,1,49,2],[52,1,52,2],[50,1,50,2],[51,1,51,2],[53,1,53,2],[48,5,48,9],[52,3,52,9],[53,3,53,9],[54,3,54,9],[65,3,65,7],[60,3,60,7],[62,3,62,7],[64,3,64,7],[58,1,58,9],[49,3,49,9],[57,1,57,6],[57,7,57,9],[56,1,56,9],[63,3,63,7],[73,1,73,5],[73,7,73,18],[63,11,63,13],[15,7,15,8],[50,10,50,12],[54,10,54,12],[50,3,50,9],[51,3,51,9],[67,11,67,13],[68,11,68,13],[69,11,69,13],[70,11,70,13],[54,1,54,2],[67,3,67,7],[66,3,66,7],[69,2,69,8],[70,1,70,9],[64,11,64,13],[65,11,65,13],[66,11,66,13],[20,13,20,14],[61,11,61,13],[65,14,67,14],[62,11,62,13],[51,10,51,12],[52,10,52,12],[53,10,53,12],[15,15,15,18],[8,15,8,18],[12,12,13,14],[12,15,13,18],[22,13,22,14],[19,9,19,11],[19,13,19,14],[49,10,49,12],[10,12,11,14],[9,1,9,11],[9,12,9,18],[11,6,11,11],[19,1,19,2],[15,12,15,14],[17,13,17,14],[16,3,16,4],[17,3,17,4],[22,9,22,11],[25,9,25,11],[18,1,18,2],[18,3,18,4],[2,15,2,18],[4,15,4,18],[5,15,5,18],[6,15,6,18],[5,1,5,5],[6,1,6,5],[4,12,4,14],[5,12,5,14],[3,12,3,14],[4,6,4,11],[4,1,4,5],[5,6,5,11],[6,12,6,14],[6,6,6,11],[2,6,2,13]]}
[]
[null,null,null,null,null,null,"Tischtennis Baden-Württemberg e.V."]
[null,null,null,null,null,null,"Abrechnung Lehrkräfte",null,null,null,null,null,null,null,null,"Kostenstelle"]
[]
[null,"Anschrift:",null,null,null,null,null,null,null,null,null,null,"Bankverbindung:"]
[null,"Name, Vorname:",null,null,null,null,null,null,null,null,null,null,"Bank:"]
[null,"PLZ, Wohnort:",null,null,null,null,null,null,null,null,null,null,"BIC:"]
[null,"Straße:",null,null,null,null,null,null,null,null,null,null,"IBAN:"]
[]
[]
[null,"Lehrgangsort:",null,null,null,null,null,null,null,null,null,null,"Lehrgangsbezeichnung:"]
[null,"Ort:"]
[null,"Straße:",null,null,null,null,null,null,null,null,null,null,"Zeitraum / Monat - Jahr:"]
[]
[]
[null,"\nDatum\nTT.MM",null,"Lehrgangszeit",null,null,null,"Fahrtkosten",null,"Tagegeld",null,null,"Sonstige Ausgaben (lt. Beleg)"]
[null,null,null,"von\nhh:mm",null,"bis\nhh:mm","Std.\nhh:mm","Pkw\nkm","öff.VkM\n€","(Tabellen s.u.)\n€",null,null,"Betrag\n€","Bezeichnung\n",null,"Bemerkungen"]
[null,null,null,null,null,null,{"$f":"IF(AND(F18=\"\",D18=\"\"),\"\",IF(OR(F18=\"\",D18=\"\"),\"Zeit ?\",((D18>F18)+F18-D18)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(F19=\"\",D19=\"\"),\"\",IF(OR(F19=\"\",D19=\"\"),\"Zeit ?\",((D19>F19)+F19-D19)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(F20=\"\",D20=\"\"),\"\",IF(OR(F20=\"\",D20=\"\"),\"Zeit ?\",((D20>F20)+F20-D20)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(F21=\"\",D21=\"\"),\"\",IF(OR(F21=\"\",D21=\"\"),\"Zeit ?\",((D21>F21)+F21-D21)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(F22=\"\",D22=\"\"),\"\",IF(OR(F22=\"\",D22=\"\"),\"Zeit ?\",((D22>F22)+F22-D22)))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(AND(F25=\"\",D25=\"\"),\"\",IF(OR(F25=\"\",D25=\"\"),\"Zeit ?\",((D25>F25)+F25-D25)))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,"Summe",null,null,null,null,{"$f":"SUM(G18:G36)","v":0},{"$f":"SUM(H18:H36)","v":0},{"$f":"SUM(I18:I36)","v":0},{"$f":"SUM(J18:J36)","v":0},null,null,{"$f":"SUM(M18:M36)","v":0}]
[]
[null,"TTBW Tagegeldsätze",null,null,null,null,null,null,null,null,null,null,null,null,"LSV-Tagegeldsätze"]
[null,"Abwesenheitsdauer",null,null,null,null,null," eintägige Reise",null,"mehrtägige Reise",null,null,null,null,"Abwesenheitsdauer",null," ein- und mehrtägige Reise"]
[null,"3 bis 8 Stunden",null,null,null,null,null,14,null,14,null,null,null,null,"8 bis 14 Stunden",null,6]
[null,"8 bis 24 Stunden",null,null,null,null,null,20,null,20,null,null,null,null,"14 bis 24 Stunden",null,12]
[null,"24 Stunden",null,null,null,null,null,null,null,24,null,null,null,null,"mindestens 24 Stunden",null,24]
[null,"Bei unentgeltlicher Verpflegung sind folgende Kürzungen vorzunehmen",null,null,null,null,null,null,null,null,null,null,null,null,"Bei unentgeltlicher Verpflegung sind folgende Kürzungen vorzunehmen"]
[null,null,"\u0097","Frühstück                           (20 %)  =",null,null,null,null,null,5.6,null,null,null,null,"  \u0097   Frühstück","(20 %)  =",null,4.8]
[null,null,"\u0097","Mittag- und Abendessen   (je 40 %)  =",null,null,null,null,null,11.2,null,null,null,null,"  \u0097   Mittag- und Abendessen","(je 40 %)  =",null,9.6]
[]
[]
[null,"Sachkonto",null,null,null,null,null,null,null,null,null,null,null,null,"Aufgrund der Selbstständigkeit bin ich verpflichtet, eigenständig für die Abführung der Einkommensteuer Sorge zu tragen. Auf die Möglichkeit einer Rentenversicherungspflicht gem. § 2 Nr. 1SGB VI wurde ich hingewiesen."]
[null,{"$f":"IF($G$74=1,(IF(C60=\"X\",2511,\"0\")+IF(C62=\"X\",2512,\"0\")+IF(C64=\"X\",2513,\"0\")+IF(C66=\"X\",2514,\"0\")+IF(C68=\"X\",2515,\"0\")),\"\")","v":""},null,"Honorar",null,null,null,null,null,null,{"$f":"IF(G74=1,(IF(C60=\"X\",I60,\"0\")+IF(C62=\"X\",I62,\"0\")+IF(C64=\"X\",I64,\"0\")+IF(C66=\"X\",I66,\"0\")+IF(C68=\"X\",I68,\"0\"))*(G37*24),\"Trainer ?\")","v":"Trainer ?"}]
[null,{"$f":"IF($G$74=1,\"2561\",\"\")","v":""},null,"Fahrtkosten Pkw      (0,30 €/km)",null,null,null,null,null,null,{"$f":"IF(G74=1,H37*0.3,\"Trainer ?\")","v":"Trainer ?"}]
[null,{"$f":"IF($G$74=1,\"2560\",\"\")","v":""},null,"Fahrtkosten öffentl. Verkehrsmittel",null,null,null,null,null,null,{"$f":"IF(G74=1,I37,\"Trainer ?\")","v":"Trainer ?"}]
[null,2569,null,"Tagegeld",null,null,null,null,null,null,{"$f":"IF($G$74=1,J$37,\"Trainer ?\")","v":"Trainer ?"}]
[null,null,null,"Sonstige Ausgaben  (lt. Beleg)",null,null,null,null,null,null,{"$f":"IF($G$74=1,M$37,\"Trainer ?\")","v":"Trainer ?"}]
[null,null,null,"Summe",null,null,null,null,null,null,{"$f":"SUM(K50:K54)","v":0},null,null,null,"(Datum)",null,"(Unterschrift)"]
[]
[]
[null,"Zutreffendes mit X markieren",null,null,null,null,null,"Stundensätze    €/Std."]
[]
[null,null,null,"Referenten in Aus-/Fortbildung ....",null,null,null,null,{"$f":"100/3","v":33.333333333333336},"(25 €/UE)"]
[]
[null,null,null,"TTBW-Trainer ................................",null,null,null,null,13,null,null,"Freigabe:"]
[]
[null,null,null,"Trainer, A-Lizenz ............................",null,null,null,null,11,null,null,null,null,null,"(Datum)",null,"(Unterschrift)"]
[]
[null,null,null,"Trainer, B-Lizenz *) ........................",null,null,null,null,8]
[]
[null,null,null,"Trainer, C-Lizenz *) ........................",null,null,null,null,4,null,null,"Überweisung:"]
[]
[null,null,"*) und in Ausbildung bis zum nächsten Prüfungstermin",null,null,null,null,null,null,null,null,null,null,null,"(Datum)",null,"(Unterschrift)"]
[]
[]
[]
[null,"Trainereingabe =",null,null,null,null,{"$f":"COUNTIF(C60:C68,\"X\")","v":0},"nicht löschen! wird in Formeln benötigt als Zwischenrechnung"]

{"sheet":"Daten","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,6,2,12],[6,6,6,13]]}
[]
[null,null,null,null,"Tischtennisverband Württemberg-Hohenzollern e.V."]
[null,null,null,null,null,null,"Abrechnung Lehrkräfte"]
[]
[]
[null,null,null,null,null,null,"Tischtennis Baden-Württemberg e.V."]
[null,null,null,null,null,null,"Abrechnung Lehrkräfte"]

{"sheet":"Historie","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,0,3,3]]}
["Veranstaltungs-Abrechnung"]
["Formular:","FO_TTBW-06e Abr-LehrK"]
[]
["Versionsdokumentation"]
[]
["Version","Datum","Autor","Aktion / Änderung"]
["0","2011-11-14","W. Renz","erste Version"]
["0.1","2013-02-21","W. Renz","Änderung Stundensatz für Referenten in Aus-/Fortbildung von 21,- auf 25,- €/UE;\nKilometersatz von 25 c/km auf 30 c/km erhöht"]
["0.2","2014-07-12","W. Renz","Für Blattschutz: Einfügemöglichkeit; Blattschutz ohne PW"]
["1.2","2014-08-21","W. Renz","BLZ und Konto-Nr. ersetzt durch BIC bzw. IBAN"]
["2","2021-09-27","F. Fürste","Spesensätze für TTBW angepasst"]