{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hinweise","Reise (Sammel)","Pauschalen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":"Hinweise","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reise (Sammel)","index":1,"n_rows":35,"n_cols":30,"rows_kept":35,"cut":false,"hidden":false,"merged":[[19,13,19,15],[9,10,10,10],[18,2,18,8],[9,2,10,2],[9,3,10,3],[9,8,10,8],[9,7,10,7],[9,4,10,4],[9,14,10,14],[18,14,18,15],[18,11,18,12],[8,9,8,15],[6,9,6,10],[3,9,3,10],[4,9,4,10],[8,19,8,24],[2,16,2,24],[3,16,3,24],[4,16,4,24],[5,16,5,24],[6,16,6,24],[6,4,6,6],[2,4,2,6],[3,4,3,6],[8,1,8,8],[4,4,4,6],[9,1,10,1],[9,6,10,6],[9,5,10,5],[21,9,25,15],[27,9,27,15],[9,9,10,9],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[19,9,19,12],[19,2,19,8],[20,16,20,24],[9,22,9,23],[8,16,8,18],[9,18,10,18],[27,19,27,25],[9,25,10,25],[9,24,10,24],[9,17,10,17],[9,16,10,16],[20,4,20,7],[24,4,24,7],[25,4,25,7],[26,4,26,7],[27,4,27,7]]}
[null,"Reisekostenabrechnung"]
[]
[null,null,"Name, Vorname",null,null,null,null,null,null,null,null,null,null,null,null,"Bank"]
[null,null,"Straße",null,null,null,null,null,"Mitgliedsnummer",null,null,null,null,null,null,"IBAN"]
[null,null,"PLZ und Ort",null,null,null,null,null,"Personalnummer",null,null,null,null,null,null,"BIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oder Konto-Nr."]
[null,null,"beschäftigt bei",null,null,null,null,null,"Kfz - Kennzeichen",null,null,null,null,null,null,"BLZ"]
[]
[null,"Anlass und Ablauf der Reise",null,null,null,null,null,null,null,"Beförderungskosten",null,null,null,null,null,null,"Verpflegungsmehrauf-wand (Tagegeld) 1) 2)\n(entfällt bei Vollverpflegung)",null,null,"Abzüge vom Tagegeld1) 2)",null,null,null,null,null,"Übernachtung"]
[null,null,"Auftrags-nummer","Datum","von Ort","Beginn (std:min)","nach Ort","Ende  (std:min)","Reisegrund ","Bahn/\n Flug","Taxi.\nÖPNV, Miet-wagen,\nsonstige Auslagen",0.3,{"$f":"Pausch_Pkw_ueber300","v":0.22},null,"bis 300 km 30ct je km\nüber 300 km 11ct je km",null,"Abwesenheit                                    in Stunden","Tagegeld in €","bei Auslandsreisen: \nvolle Tagespauschaule \nfür das jeweilige Land 2)",0.2,0.4,0.4,"des vollen Tagessatzes",null,"Tagegeld minus Abzüge","(inkl. Frühstück) oder Pausch-\nbetrag  € 20,-\n (ohne Extras)"]
[null,null,null,null,null,null,null,null,null,null,null,"eigenes Fahrzeug: Gesamt-strecke\npro Tag in km",null,"Mitfahrer/innen*",null,"Betrag",null,null,null,"Frühstück","Mittagessen","Abendessen ","Vollverpflegung","Summe Abzüge",null,null,null,null,null,"ReiseArt4"]
[null,"1.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($L12=\"\",\"\",$L$10+$N12*$N$10),\"\")","v":""},{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F12,$H12,$L12,$N12,$L$10,$M$10,$AD12),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F12,$H12,$AD12),\"\")","v":""},{"$f":"IFERROR(Tagegeld4($D$12:$D$18,$F12,$H12,$S12,$T12:$W12,$T$10:$V$10,$Z12,Tagegeld_24h,Tagegeld_8h,$AD12),\"\")","v":""},null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R12,$S12,$T$10:$V$10,$T12:$W12,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R12,$X12),\"?\")","v":""},null,null,null,null,{"$f":"ReiseArt4($D$12:$D$18,$F12,$H12,$Z12)","v":""}]
[null,"2.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF($L13=\"\",\"\",$L$10+$N13*$N$10),\"\")","v":""},{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F13,$H13,$L13,$N13,$L$10,$M$10,$AD13),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F13,$H13,$AD13),\"\")","v":""},{"$f":"Tagegeld4($D$12:$D$18,$F13,$H13,$S13,$T13:$W13,$T$10:$V$10,$Z13,Tagegeld_24h,Tagegeld_8h,$AD13)","v":""},null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R13,$S13,$T$10:$V$10,$T13:$W13,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R13,$X13),\"?\")","v":""},null,null,null,null,""]
[null,"3.",null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F14,$H14,$L14,$N14,$L$10,$M$10,$AD14),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F14,$H14,$AD14),\"\")","v":""},{"$f":"Tagegeld4($D$12:$D$18,$F14,$H14,$S14,$T14:$W14,$T$10:$V$10,$Z14,Tagegeld_24h,Tagegeld_8h,$AD14)","v":""},null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R14,$S14,$T$10:$V$10,$T14:$W14,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R14,$X14),\"?\")","v":""},null,null,null,null,""]
[null,"4.",null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F15,$H15,$L15,$N15,$L$10,$M$10,$AD15),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F15,$H15,$AD15),\"\")","v":""},"",null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R15,$S15,$T$10:$V$10,$T15:$W15,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R15,$X15),\"?\")","v":""},null,null,null,null,""]
[null,"5.",null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F16,$H16,$L16,$N16,$L$10,$M$10,$AD16),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F16,$H16,$AD16),\"\")","v":""},"",null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R16,$S16,$T$10:$V$10,$T16:$W16,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R16,$X16),\"?\")","v":""},null,null,null,null,""]
[null,"6.",null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F17,$H17,$L17,$N17,$L$10,$M$10,$AD17),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F17,$H17,$AD17),\"\")","v":""},"",null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R17,$S17,$T$10:$V$10,$T17:$W17,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R17,$X17),\"?\")","v":""},null,null,null,null,""]
[null,"7.",null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(BefEigKfz4($D$12:$D$18,$F18,$H18,$L18,$N18,$L$10,$M$10,$AD18),\"\")","v":""},{"$f":"IFERROR(Abwesenheit4($D$12:$D$18,$F18,$H18,$AD18),\"\")","v":""},"",null,false,false,false,false,{"$f":"IFERROR(SumAbz4($R18,$S18,$T$10:$V$10,$T18:$W18,Tagegeld_24h),\"?\")","v":""},{"$f":"IFERROR(TGnachAbz4($R18,$X18),\"?\")","v":""},null,null,null,null,""]
[null,null,"Einzelsummen",null,null,null,null,null,null,{"$f":"IF(SUM(J$12:J$18)=0,\"\",SUM(J$12:J$18))","v":""},{"$f":"IF(SUM(K$12:K$18)=0,\"\",SUM(K$12:K$18))","v":""},{"$f":"SUM($L$12:$L$18)","v":0},null,{"$f":"SUM(N$12:N$18)","v":0},{"$f":"IF(SUM(P$12:P$18)=0,\"\",SUM(P$12:P$18))","v":""},null,null,{"$f":"IF(SUMIF($X$12:$X$18,\"<>\"&\"---\",$R$12:$R$18)=0,\"\",SUMIF($X$12:$X$18,\"<>\"&\"---\",$R$12:$R$18))","v":""},null,null,null,null,null,{"$f":"IF(SUM(X$12:X$18)=0,\"\",SUM(X$12:X$18))","v":""},{"$f":"IF(SUM(Y$12:Y$18)=0,\"\",SUM(Y$12:Y$18))","v":""},{"$f":"IF(SUM(Z$12:Z$18)=0,\"\",SUM(Z$12:Z$18))","v":""}]
[null,null,"Zwischensumme (bitte in jedem Fall eintragen)",null,null,null,null,null,null,"Summe Beförderungskosten",null,null,null,{"$f":"IF(SUM($J$19,$K$19,$O$19)=0,\"\",SUM($J$19,$K$19,$O$19))","v":""},null,null,"Summe Verpflegungsmehraufwand",null,null,null,null,null,null,null,{"$f":"IF(SUM(Y$12:Y$18)=0,\"\",SUM(Y$12:Y$18))","v":""},{"$f":"$Z$19","v":""}]
[null,"*Mitfahrer/-innen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verdienstausfall (lt. beigefügter Bescheinigung)"]
[null,"Teilnahmebestätigung",null,null,null,null,null,null," ","Erklärung\nMir ist bekannt,  dass Verdienstausfall  steuerpflichtig ist. \nFür die Versteuerung bin ich selbst verantwortlich.\nIch versichere die Richtigkeit der obigen Angaben.\nOriginalbelege sind beigefügt, \ninsbesondere die Hotelreservierung(en).",null,null,null,null,null,null,"Gesamtsumme",null,null,null,null,null,null,null,null,{"$f":"IF(SUM($N$20,$Y$20,$Z$20,$Z$21)=0,\"\",SUM($N$20,$Y$20,$Z$20,$Z$21))","v":""}]
[null,"Die Dienstreise wird zu Lasten der oben genannten Stelle abgerechnet."]
[]
[null,"Veranstaltung:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empfangsbestätigung bei BARAUSZAHLUNG"]
[]
[null,"zur Zahlung angewiesen:"]
[null,null,null,null,"Ort, Datum, Unterschrift",null,null,null,null,"Datum, Unterschrift der/des Reisenden",null,null,null,null,null,null,null,null,null,"Datum, Unterschrift der/des Reisenden"]
[]
[]
[null,"1) Die Verpflegungsmehraufwendungen werden bis max. 0 Euro gekürzt. "]
[null,"2) Bei Auslandsreisen sind die Pauschbeträge der Anlage 1 der IG Metall Reisekostenregelung zu entnehmen. "]
[]
[null,null,"Datenschutzhinweis: Die zur Bearbeitung nötigen Angaben werden für die Dauer der gesetzlichen Aufbewahrungsfristen gespeichert."]

{"sheet":"Pauschalen","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Pauschalen und Tagessätze"]
[]
[null,"Verpflegungsmehraufwand je Tag nach Abwesenheit"]
[null,"über 8 Stunden",14]
[null,"voller Tagessatz bei 24 Std. ",28]
[null,"Übernachtung Pauschbetrag (ohne Extras)",20]
[]
[null,"Beförderungskosten","PKW","Motorrad","Fahrrad"]
[null,"Pauschale bis 300 km",0.3,0.2,0.05,"Motorrad-Pauschale angehoben auf 0,20 € ab 01.01.2025"]
[null,"Pauschale über 300 km",0.22,0.11,"-","Erhöhung ab 01.01.2025"]
[null,"Pauschale Mitnahme",0,"-","-","Mitnahmepauschale (0,02 €) entfällt ab 01.01.2014"]
[]
[null,"weitere Konstanten",null,"TEXT"]
[null,"Gültigkeit des Formulars ab","2025-01-01",{"$f":"\"gültig ab: \" & TEXT(gueltig_ab,\"TT.MM.JJJJ\")","v":"gültig ab: 01.01.2025"}]
[null,"Startzeitpunkt für Nachtfahrer-Regelung","16:00:00"]
[null,"Endzeitpunkt für Nachtfahrer-Regelung","08:00:00"]
[null,"Grenze für mehrtägige Reisen (16h dezimal)",{"$f":"2/3","v":0.66666666666666663}]
[]
[null,null,null,null,null," "]