{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Anleitung+Historie","Stand20210927"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":9,"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":"Daten","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,1,5,17],[6,1,6,17],[1,1,1,17],[2,1,2,17]]}
[]
[null,"Tischtennisverband Württemberg-Hohenzollern e.V."]
[null,"Reisekosten-Abrechnung Ehrenamt"]
[]
[]
[null,"Tischtennis Baden-Württemberg e.V."]
[null,"Reisekosten-Abrechnung Ehrenamt"]

{"sheet":"Anleitung+Historie","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,2,12,4],[13,2,13,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[0,1,0,4],[18,1,18,4],[9,1,9,4],[8,1,8,3],[10,2,10,4],[1,2,1,4],[4,1,4,4],[14,2,14,4],[15,2,15,4],[3,1,3,3],[5,2,5,4],[6,2,6,4],[11,2,11,4]]}
[null,"Reisekosten-Abrechnung Ehrenamt"]
[null,"Formular:","FO_TTBW-04e RK-Abr"]
[]
[null,"Anleitung Blattschutz"]
[null,"Das Formular hat einen Blattschutz um versehentliches Löschen oder Überschreiben von Bezügen und Formeln zu verhindern. Aber ohne ein Kennwort/Passwort (PW)."]
[null,"Aufheben: ","Registerkarte ÜBERPRÜFEN > Gruppe Änderungen > Dialogfeld Blattschutz aufheben"]
[null,"Schützen:","Registerkarte ÜBERPRÜFEN > Gruppe Änderungen > Dialogfeld Blatt schützen > OK (kein Kennwort eingeben)"]
[]
[null,"Anleitung Berechnungen"]
[null,"Das Formular hat einige Felder mit Formeln. Wo dies nicht ausreicht, erfolgt die Berechnung in Nebentabellen, die in ausgeblendeten Bereichen des Blattes enthalten sind. Hier in den Zeilen 75 bis 81."]
[null,"Einblenden:","Im Zeilenlineal die beiden angegebenen Zeilen 74 .. 82 mit linke Maustaste ziehen und markieren > rechte Maustaste > im Kontextmenü Einblenden"]
[null,"Ausblenden:","Im Zeilenlineal die Zeilen 75 bis 81 mit linke Maustaste ziehen und markieren > rechte Maustaste > im Kontextmenü Ausblenden"]
[null,"Konstanten:","Die Beträge für Kilometergeld, Spesensätze und Abzüge sind auf dem sichtbaren Teil des Formulars aufgeführt und können dort verändert werden."]
[null,"D25","Kilometersatz"]
[null,"D61-D63","Spesensätze für eintägige Reise"]
[null,"G61-G64","Spesensätze für mehrtägige Reise"]
[null,"F68-F70","Abzugssätze für Frühstück, Mittagessen und Abendessen"]
[]
[null,"Versionsdokumentation"]
[]
[null,"Version","Datum","Autor","Aktion / Änderung"]
[null,"1","2011-03-14",null,"Versand an TTBW Präsidium, Spichal, Kaltenbach Wörner, Weiland"]
[null,"2","2013-06-05","W. Renz","Fahrkosten-Berechnung: km-Satz vom Eingabefeld"]
[null,"3.1","2014-06-13","W. Renz","PW im Blattschutz entfernt"]
[null,null,null,null,"Anleitung+Historie-Blatt dazu gefügt"]
[null,"3.2","2014-07-12","W. Renz","Für Blattschutz: Einfügemöglichkeit"]
[null,"3.3","2014-08-21","W. Renz","BLZ und Konto-Nr. ersetzt durch BIC bzw. IBAN\n           \n"]
[]
[null,"Planungen"]
[null,"Abzüge erweitern auf \"freie Eingabe\" des in der Hotel-Rechnung aufgeführten Betrages"]

{"sheet":"Stand20210927","index":2,"n_rows":82,"n_cols":24,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,1,1,17],[1,19,1,21],[2,1,2,17],[2,19,2,21],[4,1,4,12],[4,13,4,17],[4,18,4,21],[7,1,7,2],[7,3,7,12],[7,13,7,16],[7,17,7,21],[9,3,10,3],[9,5,10,7],[5,1,5,2],[5,3,5,12],[5,13,5,16],[5,17,5,21],[6,1,6,2],[6,3,6,12],[6,13,6,16],[6,17,6,21],[18,1,18,2],[18,4,18,21],[19,4,19,21],[20,4,20,21],[22,1,22,3],[25,4,25,13],[25,15,25,16],[25,1,25,2],[12,1,12,2],[12,5,12,6],[12,9,12,12],[12,13,12,21],[16,1,16,2],[16,5,16,6],[16,9,16,12],[16,13,16,21],[30,17,31,17],[31,4,31,12],[44,5,44,11],[46,1,46,3],[46,4,46,14],[46,15,46,16],[27,1,27,3],[27,4,27,14],[27,15,27,16],[29,1,29,3],[29,5,30,5],[29,7,29,11],[30,13,31,13],[30,14,31,14],[30,15,31,15],[30,16,31,16],[52,1,52,3],[52,4,52,14],[52,15,52,16],[55,4,55,17],[56,1,56,22],[58,1,58,10],[58,11,59,22],[59,1,59,10],[48,1,48,3],[48,4,48,14],[48,15,48,16],[50,1,50,3],[50,4,50,14],[50,15,50,16],[60,1,60,2],[60,3,60,9],[60,11,60,12],[60,13,61,17],[60,19,61,21],[60,22,61,22],[61,1,61,2],[61,6,61,9],[61,11,61,12],[64,1,64,10],[64,11,64,17],[64,18,64,22],[65,1,67,10],[65,13,66,17],[65,19,66,21],[67,13,67,17],[67,19,67,21],[62,1,62,2],[62,6,62,9],[62,13,62,17],[62,19,62,21],[63,1,63,2],[63,6,63,9],[63,11,63,22],[68,5,68,7],[68,11,68,17],[68,18,68,22],[77,14,77,15],[77,16,77,17],[77,19,77,20],[69,5,69,7],[69,13,70,17],[69,19,70,21],[70,5,70,7],[72,1,72,10],[72,11,72,22],[75,12,75,17],[75,19,75,23],[76,12,76,13],[71,1,71,10],[71,13,71,17],[71,19,71,21],[76,19,76,20],[81,4,81,8],[81,9,81,11],[81,16,81,17],[78,4,78,8],[78,9,78,11],[78,16,78,17],[79,4,79,8],[76,14,76,15],[76,16,76,17],[77,4,77,8],[77,9,77,11],[77,12,77,13],[79,9,79,11],[79,16,79,17],[80,4,80,8],[80,9,80,11],[80,16,80,17]]}
[]
[null,"Tischtennis Baden-Württemberg e.V."]
[null,"Reisekosten-Abrechnung Ehrenamt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kostenstelle"]
[]
[null,"für eine ein- oder mehrtägige Reise",null,null,null,null,null,null,null,null,null,null,null,"Bankverbindung:"]
[null,"Name, Vorname:",null,null,null,null,null,null,null,null,null,null,null,"Bank:"]
[null,"PLZ, Wohnort:",null,null,null,null,null,null,null,null,null,null,null,"BIC:"]
[null,"Straße:",null,null,null,null,null,null,null,null,null,null,null,"IBAN:"]
[]
[null,"Reisedaten",null,"Datum \n[TT.MM.JJ]",null,"Uhrzeit\n[hh:mm]"]
[]
[]
[null,"Beginn der Reise:",null,null,null,null,null,"Uhr",null,"Start:"]
[]
[null,null,null,null,null,null,"Zwischenstation(en):"]
[]
[null,"Ende der Reise:",null,null,null,null,null,"Uhr",null,"Ziel:"]
[]
[null,"Zweck der Reise:"]
[]
[]
[]
[null,"Reisekosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sachkonto"]
[]
[null,"Fahrtkosten: (je km)",null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,"km",null,{"$f":"IF(P26>0,P26*D26,\"\")","v":""},"€",2565]
[]
[null,"Fahrtkosten öffentl. Verkehrsmittel:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bel.-Nr.",null,null,null,null,"€",2560]
[]
[null,"Tagegeld:",null,null,null,"Tagegeld",null,"--- A b z ü g e ---"]
[null,null,null,null,null,null,null,"Frühstück",null,"Mittagessen",null,"Abendessen",null,"Tagegeld-\nSatz",null,"Abzüge",null,"Tagegeld-Betrag"]
[null,{"$f":"IF(OR(D13=\"\",D17=\"\"),\"Datum fehlt !\",IF(C76<1,\"Datum falsch !\",IF(C76>5,\"Tage >5\",\"\")))","v":"Datum fehlt !"},"Tag","Datum","(Zutreffendes mit X markieren)"]
[]
[null,{"$f":"IF(OR(F13=\"\",F17=\"\"),\"Zeit fehlt !\",IF(AND(D77<0,C76<2),\"Zeit falsch !\",\"\"))","v":"Zeit fehlt !"},{"$f":"IF($C$76=0,\"\",\"1. Tag\")","v":""},{"$f":"IF($C$76>0,$D$13+0,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($C$76>0,$C$76<6,F34=\"X\"), IF($C$76>1,IF(O$78=2,$J$80,IF(O$78=3,$J$81,IF(O$78=4,$J$82,0))),IF(C$78=2,$J$80,IF(C$78=3,$J$81,IF(C$78=4,$J$82,0)))),0)","v":0},null,{"$f":"IF(AND($B$32=\"\",$B$34=\"\",$C$76>0),((H34=\"x\")*$F$69)+((J34=\"x\")*$F$70)+((L34=\"x\")*$F$71),0)","v":0},null,{"$f":"IF(P34>N34,0,N34-P34)","v":0}]
[]
[null,null,{"$f":"IF($C$76>1,\"2. Tag\",\"\")","v":""},{"$f":"IF($C$76>1,$D$13+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($C$76>1,$C$76<6,F36=\"X\"), IF($C$76=2,IF(V$78=2,$J$80,IF(V$78=3,$J$81, IF(V$78=4,$J$82,0))),$G$64),0)","v":0},null,{"$f":"IF(AND($B$32=\"\",$B$34=\"\",$C$76>1),((H36=\"x\")*$F$69)+((J36=\"x\")*$F$70)+((L36=\"x\")*$F$71),0)","v":0},null,{"$f":"IF(P36>N36,0,N36-P36)","v":0}]
[]
[null,null,{"$f":"IF($C$76>2,\"3. Tag\",\"\")","v":""},{"$f":"IF($C$76>2,$D$13+2,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($C$76>2,$C$76<6,F38=\"X\"), IF($C$76=3,IF(V$78=2,$J$80,IF(V$78=3,$J$81, IF(V$78=4,$J$82,0))),$G$64),0)","v":0},null,{"$f":"IF(AND($B$32=\"\",$B$34=\"\",$C$76>2),((H38=\"x\")*$F$69)+((J38=\"x\")*$F$70)+((L38=\"x\")*$F$71),0)","v":0},null,{"$f":"IF(P38>N38,0,N38-P38)","v":0}]
[]
[null,null,{"$f":"IF($C$76>3,\"4. Tag\",\"\")","v":""},{"$f":"IF($C$76>3,$D$13+3,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($C$76>3,$C$76<6,F40=\"X\"), IF($C$76=4,IF(V$78=2,$J$80,IF(V$78=3,$J$81, IF(V$78=4,$J$82,0))),$G$64),0)","v":0},null,{"$f":"IF(AND($B$32=\"\",$B$34=\"\",$C$76>3),((H40=\"x\")*$F$69)+((J40=\"x\")*$F$70)+((L40=\"x\")*$F$71),0)","v":0},null,{"$f":"IF(P40>N40,0,N40-P40)","v":0}]
[]
[null,null,{"$f":"IF($C$76>4,\"5. Tag\",\"\")","v":""},{"$f":"IF($C$76>4,$D$13+4,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($C$76>4,$C$76<6,F42=\"X\"), IF($C$76=5,IF(V$78=2,$J$80,IF(V$78=3,$J$81, IF(V$78=4,$J$82,0))),$G$64),0)","v":0},null,{"$f":"IF(AND($B$32=\"\",$B$34=\"\",$C$76>4),((H42=\"x\")*$F$69)+((J42=\"x\")*$F$70)+((L42=\"x\")*$F$71),0)","v":0},null,{"$f":"IF(P42>N42,0,N42-P42)","v":0}]
[]
[]
[null,null,null,null,null,"Summe",null,null,null,null,null,null,null,{"$f":"SUM(N34,N36,N38,N40,N42)","v":0},null,{"$f":"SUM(P34,P36,P38,P40,P42)","v":0},null,{"$f":"SUM(R34,R36,R38,R40,R42)","v":0},null,{"$f":"IF(R45>0,R45,\"\")","v":""},"€",2569]
[]
[null,"Übernachtung  (lt. Beleg):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bel.-Nr.",null,null,null,null,"€",2567]
[]
[null,"Bewirtung  (lt. Beleg):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bel.-Nr.",null,null,null,null,"€",2570]
[]
[null,"Sonstige Auslagen  (lt. Beleg):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bel.-Nr.",null,null,null,null,"€",2571]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bel.-Nr.",null,null,null,null,"€"]
[]
[]
[null,null,null,null,"Summe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T26,T28,T45,T47,T49,T51,T53)","v":0},"€"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Mit der Unterschrift wird bestätigt, dass die steuerrechtlichen Vorschriften nach dem EStG beachtet werden."]
[null,"TTBW Tagegeldsätze"]
[null,"Abwesenheitsdauer",null," eintägige Reise     mehrtägige Reise"]
[null,"3 bis 8 Stunden",null,14,null,null,14]
[null,"8 bis 24 Stunden",null,20,null,null,20,null,null,null,null,null,null,"(Datum)",null,null,null,null,null,"(Unterschrift)"]
[null,"24 Stunden",null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,"Freigabe:"]
[null,"Bei unentgeltlicher Verpflegung werden folgende Kürzungen vorgenommen:\n(im Tagegeld-Abschnitt sind die entsprechenden Kreuze zu machen)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Datum)",null,null,null,null,null,"(Unterschrift)"]
[null,"\u0097","Frühstück","(20 %) aus 28,00 €",null,5.6,null,null,null,null,null,"Überweisung:"]
[null,"\u0097","Mittagessen","(40 %) aus 28,00 €",null,11.2]
[null,"\u0097","Abendessen","(40 %) aus 28,00 €",null,11.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Datum)",null,null,null,null,null,"(Unterschrift)"]
[]
[]
[]
[null,"Reisetage:",{"$f":"IF(OR(D13=\"\",D17=\"\"),0,D17-D13+1)","v":0},null,null,null,null,null,null,null,null,null,"1. Tag bei mehrtägiger Reise",null,null,null,null,null,null,"letzter Tag bei mehrtägiger Reise"]
[null,"Stunden:",{"$f":"F17-F13","v":0},{"$f":"C77","v":0},null,null,null,null,null,null,null,null,"Stunden",null,{"$f":"1-F13","v":1},null,{"$f":"O77","v":1},null,null,"Stunden",null,{"$f":"F17","v":0},null,{"$f":"V77","v":0}]
[null,"Zeitstufe:",{"$f":"IF(D77<0,0,IF(D77<3/24,1,IF(D77<8/24,2,IF(D77<24/24,3,4))))","v":1},0,"negativ",null,null,null,null,0,null,null,"Zeitstufe:",null,{"$f":"IF(Q77<0,0,IF(Q77<3/24,1,IF(Q77<8/24,2,IF(Q77<24/24,3,4))))","v":4},null,null,null,null,"Zeitstufe:",null,{"$f":"IF(X77<0,0,IF(X77<3/24,1,IF(X77<8/24,2,IF(X77<24/24,3,4))))","v":1}]
[null,null,null,1,"0 - 3 Stunden",null,null,null,null,0]
[null,null,null,2,"3 - 8 Stunden",null,null,null,null,{"$f":"IF($C$76>1,G62,D62)","v":14}]
[null,null,null,3,"8 - 24 Stunden",null,null,null,null,{"$f":"IF($C$76>1,G63,D63)","v":20}]
[null,null,null,4,"24 Stunden",null,null,null,null,{"$f":"IF($C$76>1,G64,D64)","v":0}]