{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Reisekostenabrechnung - 2015","Reisekostenabrechnung","data_fill","VMA14","VMA15","VMA2016","Tabelle1","Bearbeitungshinweise","Kürzung"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":12,"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":"Reisekostenabrechnung - 2015","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,16],[2,0,2,3],[29,0,29,8],[6,0,6,7],[6,14,6,15],[8,1,8,2],[4,0,4,3],[2,10,2,12],[2,13,2,16],[34,0,40,16],[31,0,31,2],[31,3,31,7],[33,9,33,10],[6,12,6,13],[7,4,7,6],[33,3,33,7],[31,12,31,13],[33,12,33,13],[33,0,33,2]]}
["Reisekostenabrechnung 2016 (Inland)"]
[]
["Reisekostenabrechnung",{"$nulls":6},"von",null,null,"Name:"]
[{"$nulls":7},"bis"]
["Ich bin Arbeitnehmer?",{"$nulls":7},"ja"]
[]
["Reisezeiten",{"$nulls":7},"Reiseziel","Reisezweck ",null,"Verpflegung","Fahrtkosten",null,"Übernachtung",null,"Sonstiges"]
["Reisetag","Beginn","Ende","Über-nachtung","Wurden bestimmte Mahlzeiten gestellt bzw. separat abgerechnet?",null,null,"Dauer","Reiseziel ","Reisezweck","Verpfle-gungspau-schale","Pauschale","gefahrene Strecke (gesamt)","Fahrt-kosten (PKW)","Pauschal","Nachweis","lt. Anlage (Bsp.: Parkkosten, Autobahnge-bühren)"]
["Datum","Zeit",null,null,"Frühstück","Mittag ","Abendessen","Std.","Ort","Erläuterungen","EUR",{"$f":"+K9","v":"EUR"},"km","EUR","EUR","EUR","EUR"]
["2016-08-23","07:00:00",1,{"$nulls":4},{"$f":"C10-B10","v":0.70833333333333326},"Berlin",null,{"$f":"IF($I$5=\"ja\",IF(H10<TIME(8,0,0),0,IF(H10<TIME(23,59,59),12,24)),\"\")","v":12},{"$f":"+K10+Kürzung!F5","v":12},null,{"$f":"M10*0.3","v":0},{"$f":"IF(AND($I$5=\"ja\",D10=\"ja\"),IF(P10=\"\",20,\"\"),\"\")","v":""}]
["2016-08-24","00:00:00",1,"ja","ja",null,null,1,"Berlin",null,{"$f":"IF($I$5=\"ja\",IF(H11<TIME(8,0,0),0,IF(H11<TIME(23,59,59),12,24)),\"\")","v":24},{"$f":"+K11+Kürzung!F6","v":24},null,0,{"$f":"IF(AND($I$5=\"ja\",D11=\"ja\"),IF(P11=\"\",20,\"\"),\"\")","v":20}]
["2016-08-25","00:00:00",1,"ja","ja",null,null,1,"Berlin",null,24,{"$f":"+K12+Kürzung!F7","v":24},null,0,20]
["2016-08-26","00:00:00",0.29166666666666669,"ja","ja",null,null,0.29166666666666669,"Berlin",null,0,{"$f":"+K13+Kürzung!F8","v":0},null,0,20]
[{"$nulls":7},0,null,null,0,{"$f":"+K14+Kürzung!F9","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K15+Kürzung!F10","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K16+Kürzung!F11","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K17+Kürzung!F12","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K18+Kürzung!F13","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K19+Kürzung!F14","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K20+Kürzung!F15","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K21+Kürzung!F16","v":0},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K22+Kürzung!F17","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K23+Kürzung!F18","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K24+Kürzung!F19","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K25+Kürzung!F20","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K26+Kürzung!F21","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K27+Kürzung!F22","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K28+Kürzung!F23","v":{"$error":"#REF!"}},null,0,""]
[{"$nulls":7},0,null,null,0,{"$f":"+K29+Kürzung!F24","v":{"$error":"#REF!"}},null,0,""]
["Summe",{"$nulls":9},{"$f":"SUM(K10:K29)","v":60},{"$f":"SUM(L10:L29)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N10:N29)","v":0},{"$f":"SUM(O10:O29)","v":60},{"$f":"SUM(P10:P29)","v":0},{"$f":"SUM(Q10:Q29)","v":0}]
[]
["Verpflegungsgeld",null,null,{"$f":"K30","v":60},{"$nulls":5},"Fahrtkosten Gesamt",null,null,{"$f":"N30","v":0}]
[]
["Übernachtungskosten",null,null,{"$f":"O30+P30","v":60},{"$nulls":5},"GESAMTSUMME",null,null,{"$f":"K30+N30+O30+P30+Q30","v":120}]

{"sheet":"Reisekostenabrechnung","index":1,"n_rows":41,"n_cols":31,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,12,40,16],[40,1,40,3],[40,4,40,6],[30,12,30,16],[34,12,34,16],[38,12,38,16],[30,1,30,2],[36,5,36,6],[36,7,36,8],[8,8,8,15],[28,12,28,16],[10,4,10,5],[28,1,28,11],[9,8,9,9],[9,10,9,12],[8,1,8,2],[8,3,8,7],[0,1,0,16],[2,4,2,6],[2,10,2,16],[6,1,6,8],[4,1,4,8],[2,1,2,3]]}
[null,"Reisekostenabrechnung (Inland) 2020"]
[]
[{"$f":"\"--> blaue Felder = Eingabefelder\"","v":"--> blaue Felder = Eingabefelder"},"für den Monat / Zeitraum",{"$nulls":7},"Name:"]
[]
[{"$f":"\"--> Roter Rahmen = Pflichteingabe\"","v":"--> Roter Rahmen = Pflichteingabe"},"Ich bin Arbeitnehmer?"]
[]
[null,"Ich erstelle die Abrechnung für meine Einkommensteuererklärung"]
[]
["Bearbeitungshinweise","Reisedaten",null,"Reisezeiten",{"$nulls":4},"Übernachtung",{"$nulls":7},"Fahrt-kosten"]
[null,"Reiseziel ","Reisezweck","Reisetag","Beginn","Ende","Dauer","Verpflegungs-pauschale","Übernachtung",null,"Wurden bestimmte Mahlzeiten gestellt bzw. separat abgerechnet?",null,null,"Verpflegungspauschale abzgl. F, M, A","Nachweis (z. B. Hotelrechnung lt. Anlage)","Pauschal \n(20,- EUR nur ohne Nachweis)","gefahrene Strecke (gesamt)"]
[null,"Ort","Erläuterungen","Datum","Zeit",null,"Std.","EUR",null,"Hotel (Name)","Frühstück","Mittagessen","Abendessen","EUR","EUR","EUR","km",null,"Frühstück","Mittagessen","Abendessen","Kürzung Gesamt","VMAabzgl. Kürzung","VMA","Max ","Erstattung"]
[{"$nulls":6},{"$f":"IF((AND($E$3<>\"\",ISNUMBER(D12),$J$5<>\"\",$J$7<>\"\")),(F12-E12),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D12),ISNUMBER(G12)),IF(G12>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G12>TIME(8,0,0),E12>TIME(0,0,0),F12<TIME(23,59,59)),AND(E12<TIME(0,0,1),F12<TIME(23,59,59),E12<>\"\",F12<>\"\"),AND(E12>TIME(0,0,0),F12>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},{"$f":"Z12","v":0},null,{"$f":"IF(AND($J$5=\"ja\",I12=\"ja\",$J$7=\"nein\"),IF(O12=\"\",20,\"\"),\"\")","v":""},null,null,{"$f":"IF(K12=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L12=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M12=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S12:U12)","v":0},{"$f":"H12-V12","v":0},{"$f":"H12","v":0},{"$f":"IF(((H12-V12)>0),(H12-V12),X12)","v":0},{"$f":"IF((W12<=0),0,Y12)","v":0},{"$f":"IF(Y12>=0,Y12,0)","v":0},{"$f":"IF(AND(S12=4.8,Z12>=0),S12,0)","v":0},{"$f":"IF(AND(T12=9.6,$Z12>=0),T12,0)","v":0},0,{"$f":"SUM(AB12:AD12)","v":0}]
[{"$nulls":6},{"$f":"IF((AND($E$3<>\"\",ISNUMBER(D13),$J$5<>\"\",$J$7<>\"\")),(F13-E13),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(D13),ISNUMBER(G13)),IF(G13>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G13>TIME(8,0,0),E13>TIME(0,0,0),F13<TIME(23,59,59)),AND(E13<TIME(0,0,1),F13<TIME(23,59,59),E13<>\"\",F13<>\"\"),AND(E13>TIME(0,0,0),F13>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},{"$f":"Z13","v":0},null,{"$f":"IF(AND($J$5=\"ja\",I13=\"ja\",$J$7=\"nein\"),IF(O13=\"\",20,\"\"),\"\")","v":""},null,null,{"$f":"IF(K13=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L13=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M13=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S13:U13)","v":0},{"$f":"H13-V13","v":0},{"$f":"H13","v":0},{"$f":"IF(((H13-V13)>0),(H13-V13),X13)","v":0},{"$f":"IF((W13<=0),0,Y13)","v":0},{"$f":"IF(Y13>=0,Y13,0)","v":0},{"$f":"IF(AND(S13=4.8,Z13>=0),S13,0)","v":0},0,0,{"$f":"SUM(AB13:AD13)","v":0}]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D14),ISNUMBER(G14)),IF(G14>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G14>TIME(8,0,0),E14>TIME(0,0,0),F14<TIME(23,59,59)),AND(E14<TIME(0,0,1),F14<TIME(23,59,59),E14<>\"\",F14<>\"\"),AND(E14>TIME(0,0,0),F14>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K14=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L14=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M14=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S14:U14)","v":0},{"$f":"H14-V14","v":0},{"$f":"H14","v":0},{"$f":"IF(((H14-V14)>0),(H14-V14),X14)","v":0},{"$f":"IF((W14<=0),0,Y14)","v":0},{"$f":"IF(Y14>=0,Y14,0)","v":0},{"$f":"IF(AND(S14=4.8,Z14>=0),S14,0)","v":0},0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D15),ISNUMBER(G15)),IF(G15>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G15>TIME(8,0,0),E15>TIME(0,0,0),F15<TIME(23,59,59)),AND(E15<TIME(0,0,1),F15<TIME(23,59,59),E15<>\"\",F15<>\"\"),AND(E15>TIME(0,0,0),F15>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K15=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L15=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M15=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S15:U15)","v":0},{"$f":"H15-V15","v":0},{"$f":"H15","v":0},{"$f":"IF(((H15-V15)>0),(H15-V15),X15)","v":0},{"$f":"IF((W15<=0),0,Y15)","v":0},{"$f":"IF(Y15>=0,Y15,0)","v":0},{"$f":"IF(AND(S15=4.8,Z15>=0),S15,0)","v":0},{"$f":"IF(AND(T15=9.6,$Z15>=0),T15,0)","v":0},{"$f":"IF(AND(U15=9.6,$Z15>=0),U15,0)","v":0},0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D16),ISNUMBER(G16)),IF(G16>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G16>TIME(8,0,0),E16>TIME(0,0,0),F16<TIME(23,59,59)),AND(E16<TIME(0,0,1),F16<TIME(23,59,59),E16<>\"\",F16<>\"\"),AND(E16>TIME(0,0,0),F16>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K16=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L16=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M16=\"ja\",Kürzung!$B$32,0)","v":0},0,{"$f":"H16-V16","v":0},{"$f":"H16","v":0},{"$f":"IF(((H16-V16)>0),(H16-V16),X16)","v":0},0,{"$f":"IF(Y16>=0,Y16,0)","v":0},0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D17),ISNUMBER(G17)),IF(G17>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G17>TIME(8,0,0),E17>TIME(0,0,0),F17<TIME(23,59,59)),AND(E17<TIME(0,0,1),F17<TIME(23,59,59),E17<>\"\",F17<>\"\"),AND(E17>TIME(0,0,0),F17>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K17=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L17=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M17=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D18),ISNUMBER(G18)),IF(G18>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G18>TIME(8,0,0),E18>TIME(0,0,0),F18<TIME(23,59,59)),AND(E18<TIME(0,0,1),F18<TIME(23,59,59),E18<>\"\",F18<>\"\"),AND(E18>TIME(0,0,0),F18>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K18=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L18=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M18=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D19),ISNUMBER(G19)),IF(G19>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G19>TIME(8,0,0),E19>TIME(0,0,0),F19<TIME(23,59,59)),AND(E19<TIME(0,0,1),F19<TIME(23,59,59),E19<>\"\",F19<>\"\"),AND(E19>TIME(0,0,0),F19>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K19=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L19=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M19=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D20),ISNUMBER(G20)),IF(G20>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G20>TIME(8,0,0),E20>TIME(0,0,0),F20<TIME(23,59,59)),AND(E20<TIME(0,0,1),F20<TIME(23,59,59),E20<>\"\",F20<>\"\"),AND(E20>TIME(0,0,0),F20>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K20=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L20=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M20=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D21),ISNUMBER(G21)),IF(G21>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G21>TIME(8,0,0),E21>TIME(0,0,0),F21<TIME(23,59,59)),AND(E21<TIME(0,0,1),F21<TIME(23,59,59),E21<>\"\",F21<>\"\"),AND(E21>TIME(0,0,0),F21>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K21=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L21=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M21=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D22),ISNUMBER(G22)),IF(G22>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G22>TIME(8,0,0),E22>TIME(0,0,0),F22<TIME(23,59,59)),AND(E22<TIME(0,0,1),F22<TIME(23,59,59),E22<>\"\",F22<>\"\"),AND(E22>TIME(0,0,0),F22>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K22=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L22=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M22=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D23),ISNUMBER(G23)),IF(G23>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G23>TIME(8,0,0),E23>TIME(0,0,0),F23<TIME(23,59,59)),AND(E23<TIME(0,0,1),F23<TIME(23,59,59),E23<>\"\",F23<>\"\"),AND(E23>TIME(0,0,0),F23>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K23=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L23=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M23=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D24),ISNUMBER(G24)),IF(G24>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G24>TIME(8,0,0),E24>TIME(0,0,0),F24<TIME(23,59,59)),AND(E24<TIME(0,0,1),F24<TIME(23,59,59),E24<>\"\",F24<>\"\"),AND(E24>TIME(0,0,0),F24>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K24=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L24=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M24=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S24:U24)","v":0},{"$f":"H24-V24","v":0},{"$f":"H24","v":0},{"$f":"IF(((H24-V24)>0),(H24-V24),0)","v":0},{"$f":"IF((W24<=0),0,Y24)","v":0},{"$f":"IF(Y24>=0,Y24,0)","v":0},{"$f":"IF(AND(S24=4.8,Z24>=0),S24,0)","v":0},{"$f":"IF(AND(T24=9.6,$Z24>=0),T24,0)","v":0},{"$f":"IF(AND(U24=9.6,$Z24>=0),U24,0)","v":0},0]
[{"$nulls":6},"",{"$f":"IF(AND(ISNUMBER(D25),ISNUMBER(G25)),IF(G25>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G25>TIME(8,0,0),E25>TIME(0,0,0),F25<TIME(23,59,59)),AND(E25<TIME(0,0,1),F25<TIME(23,59,59),E25<>\"\",F25<>\"\"),AND(E25>TIME(0,0,0),F25>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K25=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L25=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M25=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S25:U25)","v":0},{"$f":"H25-V25","v":0},{"$f":"H25","v":0},{"$f":"IF(((H25-V25)>0),(H25-V25),0)","v":0},{"$f":"IF((W25<=0),0,Y25)","v":0},{"$f":"IF(Y25>=0,Y25,0)","v":0},{"$f":"IF(AND(S25=4.8,Z25>=0),S25,0)","v":0},{"$f":"IF(AND(T25=9.6,$Z25>=0),T25,0)","v":0},{"$f":"IF(AND(U25=9.6,$Z25>=0),U25,0)","v":0},0]
[null,"Summe",{"$nulls":11},{"$f":"IF((AND($E$3<>\"\",$J$5<>\"\",$J$7<>\"\")),SUM(N12:N25),0)","v":0},{"$f":"IF((AND($E$3<>\"\",$J$5<>\"\",$J$7<>\"\")),SUM(O12:O25),0)","v":0},{"$f":"IF((AND($E$3<>\"\",$J$5<>\"\",$J$7<>\"\")),SUM(P12:P25),0)","v":0},{"$f":"IF((AND($E$3<>\"\",$J$5<>\"\",$J$7<>\"\")),SUM(Q12:Q25),0)","v":0},{"$nulls":8},{"$f":"SUM(Z12:Z25)","v":0},{"$f":"IF(Y26>=0,Y26,0)","v":0},{"$f":"(SUM(AB12:AB25))/Kürzung!$B$30","v":0},{"$f":"(SUM(AC12:AC25))/Kürzung!$B$31","v":0},{"$f":"(SUM(AD12:AD25))/Kürzung!$B$32","v":0}]
[]
[null,"Auszahlungen"]
[null,"Verpflegungsmehraufwendungen abzgl. Anzurechnender, gestellter Mahlzeiten",{"$nulls":10},{"$f":"Z26","v":0}]
[]
[null,"Übernachtungskosten",{"$nulls":10},{"$f":"SUM(J32:J33)","v":0}]
[null,null,"Hotel",{"$nulls":6},{"$f":"O26","v":0}]
[null,null,"Pauschal",{"$nulls":6},{"$f":"P26","v":0}]
[]
[null,"Fahrtkosten (Pkw)",{"$nulls":10},{"$f":"$H$37*$D$37","v":0}]
[]
[null,null,"Summe km:",{"$f":"$Q$26","v":0},null,"pauschal pro Kilometer:",null,{"$f":"Kürzung!$B$35","v":0.3}]
[]
[null,"sonstige Kosten lt. Nachweis (z. B. Parkkosten, Autobahngebühren)"]
[]
[null,"Auszahlung der Reisekosten für",null,null,{"$f":"IF((($E$3)=\"Bitte auswählen!\"),\" \",$E$3)","v":0},{"$nulls":7},{"$f":"SUM(M29+M31+M35+M39)","v":0}]

{"sheet":"data_fill","index":2,"n_rows":261,"n_cols":4,"rows_kept":261,"cut":false,"hidden":true,"merged":[]}
["Pauschalen"]
["Ab 8 Stunden ",null,null,14]
["Abwesenheit von 24 Stunden",null,null,28]
[]
[]
["Afghanistan",null,null,"Afghanistan"]
["Ägypten",null,null,"Ägypten"]
["Äthiopien",null,null,"Äthiopien"]
["Äquatorialguinea",null,null,"Äquatorialguinea"]
["Albanien",null,null,"Albanien"]
["Algerien",null,null,"Algerien"]
["Andorra",null,null,"Andorra"]
["Angola",null,null,"Angola"]
["Antigua und Barbuda",null,null,"Antigua und Barbuda"]
["Argentinien",null,null,"Argentinien"]
["Armenien",null,null,"Armenien"]
["Aserbaidschan",null,null,"Aserbaidschan"]
["Australien",null,null,"Australien"]
["- Canberra",null,null,"- Canberra"]
["- Sydney",null,null,"- Sydney"]
["- im Übrigen",null,null,"- im Übrigen"]
["Bahrain",null,null,"Bahrain"]
["Bangladesch",null,null,"Bangladesch"]
["Barbados",null,null,"Barbados"]
["Belgien",null,null,"Belgien"]
["Benin",null,null,"Benin"]
["Bolivien",null,null,"Bolivien"]
["Bosnien-Herzegowina",null,null,"Bosnien-Herzegowina"]
["Botsuana",null,null,"Botsuana"]
["Brasilien",null,null,"Brasilien"]
["- Brasilia",null,null,"- Brasilia"]
["- Rio de Janeiro",null,null,"- Rio de Janeiro"]
["- Sao Paulo",null,null,"- Sao Paulo"]
["- im Übrigen",null,null,"- im Übrigen"]
["Brunei (Darussalam)",null,null,"Brunei (Darussalam)"]
["Bulgarien",null,null,"Bulgarien"]
["Burkina Faso",null,null,"Burkina Faso"]
["Burundi",null,null,"Burundi"]
["Chile",null,null,"Cabo Verde"]
["China",null,null,"Chile"]
["- Chengdu",null,"ja","China"]
["- Hongkong",null,"nein","- Chengdu"]
["- Peking",null,null,"- Hongkong"]
["- Shanghai",null,null,"- Peking"]
["Costa Rica",null,null,"- Shanghai"]
["Côte d'Ivoire",null,null,"Costa Rica"]
["Deutschland",null,null,"Côte d'Ivoire"]
["Dänemark",null,null,"Dänemark"]
["Dominica",null,null,"Deutschland"]
["Dominikanische Republik",null,null,"Dominica"]
["Dschibuti",null,null,"Dominikanische Republik"]
["Ecuador",null,null,"Dschibuti"]
["El Salvador",null,null,"Ecuador"]
["Eritrea",null,null,"El Salvador"]
["Estland",null,null,"Eritrea"]
["Fidschi",null,null,"Estland"]
["Finnland",null,null,"Fidschi"]
["Frankreich",null,null,"Finnland"]
["- Lyon",null,null,"Frankreich                                                                                                                 "]
["- Marseille",null,null,"- Lyon"]
["- Paris *)",null,null,"- Marseille"]
["- Straßburg",null,null,"- Paris *)"]
["- im Übrigen",null,null,"- Straßburg"]
["Gabun",null,null,"- im Übrigen"]
["Gambia",null,null,"Gabun"]
["Georgien",null,null,"Gambia"]
["Ghana",null,null,"Georgien"]
["Grenada",null,null,"Ghana"]
["Griechenland",null,null,"Grenada"]
["- Athen",null,null,"Griechenland"]
["- im Übrigen",null,null,"- Athen"]
["Guatemala",null,null,"- im Übrigen"]
["Guinea",null,null,"Guatemala"]
["Guinea-Bissau",null,null,"Guinea"]
["Guyana",null,null,"Guinea-Bissau"]
["Haiti",null,null,"Guyana"]
["Honduras",null,null,"Haiti"]
["Indien",null,null,"Honduras"]
["- Chennai (Madras)",null,null,"Indien"]
["- Kalkutta (Kolkata)",null,null,"- Chennai (Madras)"]
["- Bombay (Mumbai)",null,null,"- Kalkutta (Kolkata)"]
["- Neu Delhi",null,null,"- Bombay (Mumbai)"]
["- im Übrigen",null,null,"- Neu Delhi"]
["Indonesien",null,null,"- im Übrigen"]
["Iran, Islamische Republik",null,null,"Indonesien"]
["Irland",null,null,"Iran, Islamische Republik"]
["Island",null,null,"Irland"]
["Israel",null,null,"Island"]
["Italien",null,null,"Israel"]
["- Mailand",null,null,"Italien"]
["- Rom",null,null,"- Mailand"]
["- im Übrigen",null,null,"- Rom"]
["Jamaika",null,null,"- im Übrigen"]
["Japan",null,null,"Jamaika"]
["- Tokio",null,null,"Japan"]
["- im Übrigen",null,null,"- Tokio"]
["Jemen",null,null,"- im Übrigen"]
["Jordanien",null,null,"Jordanien"]
["Kambodscha",null,null,"Kambodscha"]
["Kamerun",null,null,"Kamerun"]
["Kanada",null,null,"Kanada"]
["- Ottawa",null,null,"- Ottawa"]
["- Toronto",null,null,"- Toronto"]
["- Vancouver",null,null,"- Vancouver"]
["- im Übrigen",null,null,"- im Übrigen"]
["Kap Verde",null,null,"Kasachstan"]
["Kasachstan",null,null,"Katar"]
["Katar",null,null,"Kenia"]
["Kenia",null,null,"Kirgisistan"]
["Kirgisistan",null,null,"Kolumbien"]
["Kolumbien",null,null,"Kongo, Republik"]
["Kongo",null,null,"Kongo, Demokratische Republik (früher: Zaire)"]
["Kongo, Demokratische Republik",null,null,"Korea, Demokr. Volksrepublik"]
["(früher: Zaire)",null,null,"Korea, Republik"]
["Korea,\nDemokratische Volksrepublik",null,null,"Kosovo"]
["Korea,",null,null,"Kroatien"]
["Korea Republik",null,null,"Kuba"]
["Kosovo",null,null,"Kuwait"]
["Kroatien",null,null,"Laos"]
["Kuba",null,null,"Lesotho"]
["Kuwait",null,null,"Lettland"]
["Laos",null,null,"Libanon"]
["Lesotho",null,null,"Libyen"]
["Lettland",null,null,"Liechtenstein"]
["Libanon",null,null,"Litauen"]
["Libyen",null,null,"Luxemburg"]
["Liechtenstein",null,null,"Madagaskar"]
["Litauen",null,null,"Malawi"]
["Luxemburg",null,null,"Malaysia"]
["Madagaskar",null,null,"Malediven"]
["Malawi",null,null,"Mali"]
["Malaysia",null,null,"Malta"]
["Malediven",null,null,"Marokko"]
["Mali",null,null,"Marshall Inseln"]
["Malta",null,null,"Mauretanien"]
["Marokko",null,null,"Mauritius"]
["Marshall Inseln",null,null,"Mazedonien"]
["Mauretanien",null,null,"Mexiko"]
["Mauritius",null,null,"Mikronesien"]
["Mazedonien",null,null,"Moldawien"]
["Mexiko",null,null,"Monaco"]
["Mikronesien",null,null,"Mongolei"]
["Moldau, Republik",null,null,"Montenegro"]
["Monaco",null,null,"Mosambik"]
["Mongolei",null,null,"Myanmar (früher Burma)"]
["Montenegro",null,null,"Namibia"]
["Mosambik",null,null,"Nepal"]
["Myanmar (früher Burma)",null,null,"Nicaragua"]
["Namibia",null,null,"Niederlande"]
["Nepal",null,null,"Niger"]
["Neuseeland",null,null,"Nigeria"]
["Nicaragua",null,null,"Norwegen"]
["Niederlande",null,null,"Österreich"]
["Niger",null,null,"Oman"]
["Nigeria",null,null,"Pakistan"]
["Norwegen",null,null,"- Islamabad"]
["Österreich",null,null,"- Im Übrigen"]
["Oman",null,null,"Palau"]
["Pakistan",null,null,"Panama"]
["- Islamabad",null,null,"Papua-Neuguinea"]
["- Im Übrigen",null,null,"Paraguay"]
["Palau",null,null,"Peru"]
["Panama",null,null,"Philippinen"]
["Papua-Neuguinea",null,null,"Polen"]
["Paraguay",null,null,"- Breslau"]
["Peru",null,null,"- Danzig"]
["Philippinen",null,null,"- Krakau"]
["Polen",null,null,"- Warschau, Krakau"]
["- Breslau",null,null,"- im Übrigen"]
["- Danzig",null,null,"Portugal"]
["- Krakau",null,null,"Ruanda"]
["- Warschau, Krakau",null,null,"Rumänien"]
["- im Übrigen",null,null,"- Bukarest"]
["Portugal",null,null,"- im Übrigen"]
["- Lissabon",null,null,"Russische Föderation"]
["- im Übrigen",null,null,"- Moskau ²)"]
["Ruanda",null,null,"- St. Petersburg"]
["Rumänien",null,null,"- im Übrigen"]
["- Bukarest",null,null,"Sambia"]
["- im Übrigen",null,null,"Samoa"]
["Russische Föderation",null,null,"San Marino"]
["- Moskau ²)",null,null,"Sao Tomé und Principe"]
["- Moskau ³)",null,null,"Saudi-Arabien"]
["- St. Petersburg",null,null,"- Djidda"]
["- im Übrigen",null,null,"- Riad"]
["Sambia",null,null,"Schweden"]
["Samoa",null,null,"Schweiz"]
["San Marino",null,null,"- Genf"]
["Sao Tomé und Principe",null,null,"- im Übrigen"]
["Saudi-Arabien",null,null,"Senegal"]
["- Djidda",null,null,"Serbien"]
["- Riad",null,null,"Sierra Leone"]
["Schweden",null,null,"Simbabwe"]
["Schweiz",null,null,"Singapur"]
["- Genf",null,null,"Slowakei"]
["- im Übrigen",null,null,"Slowenien"]
["Senegal",null,null,"Spanien"]
["Serbien",null,null,"- Barcelona"]
["Sierra Leone",null,null,"- Kanarische Inseln"]
["Simbabwe",null,null,"- Madrid"]
["Singapur",null,null,"- Palma de Mallorca"]
["Slowakische Republik",null,null,"- im Übrigen"]
["Slowenien",null,null,"Sri Lanka"]
["Spanien",null,null,"St. Kitts und Nevis"]
["- Barcelona",null,null,"St. Lucia"]
["- Kanarische Inseln",null,null,"St. Vincent und die Grenadinen"]
["- Madrid",null,null,"Sudan"]
["- Palma de Mallorca",null,null,"Südafrika"]
["- im Übrigen",null,null,"- Kapstadt"]
["Sri Lanka",null,null,"- im Übrigen"]
["St. Kitts und Nevis",null,null,"Südsudan"]
["St. Lucia",null,null,"Suriname"]
["St. Vincent und die Grenadinen",null,null,"Syrien, arabische Republik"]
["Sudan",null,null,"Tadschikistan"]
["Südafrika",null,null,"Taiwan"]
["- Kapstadt",null,null,"Tansania"]
["- im Übrigen",null,null,"Thailand"]
["Südsudan",null,null,"Togo"]
["Suriname",null,null,"Tonga"]
["Syrien, Arabische Republik",null,null,"Trinidad und Tobago"]
["Tadschikistan",null,null,"Tschad"]
["Taiwan",null,null,"Tschechische Republik"]
["Tansania",null,null,"Türkei"]
["Thailand",null,null,"- Instanbul"]
["Togo",null,null,"- Izmir"]
["Tonga",null,null,"- Im Übrigen"]
["Trinidad und Tobago",null,null,"Tunesien"]
["Tschad",null,null,"Turkmenistan"]
["Tschechische Republik",null,null,"Uganda"]
["Türkei",null,null,"Ukraine"]
["- Instanbul",null,null,"Ungarn"]
["- Izmir",null,null,"Uruguay"]
["- Im Übrigen",null,null,"Usbekistan"]
["Tunesien",null,null,"Vatikanstadt"]
["Turkmenistan",null,null,"Venezuela"]
["Uganda",null,null,"Vereinigte Arabische Emirate"]
["Ukraine",null,null,"Vereinigte Staaten"]
["Ungarn",null,null,"- Atlanta"]
["Uruguay",null,null,"- Boston"]
["Usbekistan",null,null,"- Chicago"]
["Vatikanstadt",null,null,"- Houston"]
["Venezuela",null,null,"- Los Angeles"]
["Vereinigte Arabische Emirate",null,null,"- Miami"]
["Vereinigte Staaten",null,null,"- New York"]
["- Atlanta",null,null,"- San Francisco"]
["- Boston",null,null,"- Washington DC"]
["- Chicago",null,null,"- Im Übrigen"]
["- Houston",null,null,"Vereinigtes Königreich"]
["- Los Angeles",null,null,"- London"]
["- Miami",null,null,"- im Übrigen"]
["- New York",null,null,"Vietnam"]
["- San Francisco",null,null,"Weißrussland"]
["- Washington DC",null,null,"Zentralafrikanische Republik"]
["- Im Übrigen       Vereinigtes Königreich v. GB",null,null,"Zypern"]
["und Nordirland"]
["- London"]
["- im Übrigen"]
["Vietnam"]
["Weißrussland"]
["Zentralafrikanische Republik"]
["Zypern"]

{"sheet":"VMA14","index":3,"n_rows":267,"n_cols":5,"rows_kept":267,"cut":false,"hidden":true,"merged":[]}
["Achtung: ab 2014 neues Reisekostenrecht: geänderte vereinfachte Rechtsprechung !"]
[]
["Pauschbeträge für Verpflegungsmehraufwendungen"]
["bei einer Abwesenheitsdauer je Kalendertag im Ausland (Geltungsdauer 2014)"]
["Land         mind. 24 Std.                  mind. 8 Std.       Übernachtung"]
["---------------------------------------------------------------------------------------------------------------------------------"]
[]
["Afghanistan",30,20,null,95]
["Ägypten",40,27,null,113]
["Äthiopien",30,20,null,175]
["Äquatorialguinea",50,33,null,226]
["Albanien",23,16,null,110]
["Algerien",39,26,null,190]
["Andorra",32,21,null,82]
["Angola",77,52,null,265]
["Antigua und Barbuda",53,36,null,117]
["Argentinien",36,24,null,125]
["Armenien",24,16,null,90]
["Aserbaidschan",40,27,null,120]
["Australien",null,null,null,"_"]
["- Canberra",58,39,null,158]
["- Sydney",59,40,null,186]
["- im Übrigen",56,37,null,133]
["Bahrain",36,24,null,70]
["Bangladesch",30,20,null,75]
["Barbados",58,39,null,179]
["Belgien",41,28,null,135]
["Benin",41,28,null,90]
["Bolivien",24,16,null,70]
["Bosnien-Herzegowina",24,16,null,70]
["Botsuana",33,22,null,105]
["Brasilien",null,null,null,"_"]
["- Brasilia",53,36,null,160]
["- Rio de Janeiro",47,32,null,145]
["- Sao Paulo",53,36,null,120]
["- im Übrigen",54,36,null,110]
["Brunei (Darussalam)",36,24,null,85]
["Bulgarien",22,15,null,72]
["Burkina Faso",36,24,null,100]
["Burundi",47,32,null,98]
["Chile",40,27,null,130]
["China",33,22,null,80]
["- Chengdu",32,21,null,85]
["- Hongkong",62,41,null,170]
["- Peking",39,26,null,115]
["- Shanghai",42,28,null,140]
["Costa Rica",36,24,null,69]
["Côte d'Ivoire",54,36,null,145]
["Deutschland",24,12,null,20]
["Dänemark",60,40,null,150]
["Dominica",40,27,null,94]
["Dominikanische Republik",30,20,null,100]
["Dschibuti",48,32,null,160]
["Ecuador",39,26,null,55]
["El Salvador",46,31,null,75]
["Eritrea",30,20,null,58]
["Estland",27,18,null,85]
["Fidschi",32,21,null,57]
["Finnland",39,26,null,136]
["Frankreich",null,null,null,"_"]
["- Lyon",53,36,null,83]
["- Marseille",51,34,null,86]
["- Paris *)",58,39,null,135]
["- Straßburg",48,32,null,89]
["- im Übrigen",44,29,null,81]
["Gabun",60,40,null,135]
["Gambia",18,12,null,70]
["Georgien",30,20,null,80]
["Ghana",46,31,null,174]
["Grenada",51,34,null,121]
["Griechenland",null,null,null,"_"]
["- Athen",57,38,null,125]
["- im Übrigen",42,28,null,132]
["Guatemala",28,19,null,96]
["Guinea",38,25,null,110]
["Guinea-Bissau",30,20,null,60]
["Guyana",41,28,null,81]
["Haiti",50,33,null,111]
["Honduras",35,24,null,115]
["Indien",null,null,null,"_"]
["- Chennai (Madras)",30,20,null,135]
["- Kalkutta (Kolkata)",33,22,null,120]
["- Bombay (Mumbai)",35,24,null,150]
["- Neu Delhi",35,24,null,130]
["- im Übrigen",30,20,null,120]
["Indonesien",39,26,null,110]
["Iran, Islamische Republik",28,19,null,84]
["Irland",42,28,null,90]
["Island",53,36,null,105]
["Israel",59,40,null,175]
["Italien",null,null,null,"_"]
["- Mailand",39,26,null,156]
["- Rom",52,35,null,160]
["- im Übrigen",34,23,null,126]
["Jamaika",54,36,null,135]
["Japan",null,null,null,"_"]
["- Tokio",53,36,null,153]
["- im Übrigen",51,34,null,156]
["Jemen",24,16,null,95]
["Jordanien",36,24,null,85]
["Kambodscha",36,24,null,85]
["Kamerun",40,27,null,130]
["Kanada",null,null,null,"_"]
["- Ottawa",36,24,null,105]
["- Toronto",41,28,null,135]
["- Vancouver",36,24,null,125]
["- im Übrigen",36,24,null,100]
["Kap Verde",30,20,null,55]
["Kasachstan",39,26,null,109]
["Katar",56,37,null,170]
["Kenia",35,24,null,135]
["Kirgisistan",18,12,null,70]
["Kolumbien",41,28,null,126]
["Kongo",57,38,null,113]
["Kongo, Demokratische Republik"]
["(früher: Zaire)",60,40,null,155]
["Korea,\nDemokratische Volksrepublik",30,20,null,186]
["Korea,"]
["Korea Republik",66,44,null,180]
["Kosovo",26,17,null,65]
["Kroatien",29,20,null,57]
["Kuba",50,33,null,85]
["Kuwait",42,28,null,130]
["Laos",33,22,null,67]
["Lesotho",24,16,null,70]
["Lettland",18,12,null,80]
["Libanon",44,29,null,120]
["Libyen",45,30,null,100]
["Liechtenstein",47,32,null,82]
["Litauen",27,18,null,100]
["Luxemburg",47,32,null,102]
["Madagaskar",38,25,null,83]
["Malawi",39,26,null,110]
["Malaysia",36,24,null,100]
["Malediven",38,25,null,93]
["Mali",40,27,null,125]
["Malta",30,20,null,90]
["Marokko",42,28,null,105]
["Marshall Inseln",63,42,null,70]
["Mauretanien",48,32,null,89]
["Mauritius",48,32,null,140]
["Mazedonien",24,16,null,95]
["Mexiko",36,24,null,110]
["Mikronesien",56,37,null,74]
["Moldau, Republik",18,12,null,100]
["Monaco",41,28,null,52]
["Mongolei",29,20,null,84]
["Montenegro",29,20,null,95]
["Mosambik",42,28,null,147]
["Myanmar (früher Burma)",46,31,null,45]
["Namibia",29,20,null,85]
["Nepal",32,21,null,72]
["Neuseeland",47,32,null,98]
["Nicaragua",30,20,null,100]
["Niederlande",60,40,null,115]
["Niger",36,24,null,70]
["Nigeria",60,40,null,220]
["Norwegen",64,43,null,182]
["Österreich",29,20,null,92]
["Oman",48,32,null,120]
["Pakistan",null,null,null,"_"]
["- Islamabad",24,16,null,150]
["- Im Übrigen",24,16,null,70]
["Palau",51,34,null,166]
["Panama",34,23,null,101]
["Papua-Neuguinea",36,24,null,90]
["Paraguay",36,24,null,61]
["Peru",38,25,null,140]
["Philippinen",30,20,null,107]
["Polen",null,null,null,"_"]
["- Breslau",33,22,null,92]
["- Danzig",29,20,null,77]
["- Krakau",28,19,null,88]
["- Warschau, Krakau",30,20,null,105]
["- im Übrigen",27,18,null,50]
["Portugal",null,null,null,"_"]
["- Lissabon",36,24,null,95]
["- im Übrigen",33,22,null,95]
["Ruanda",36,24,null,135]
["Rumänien",null,null,null,"_"]
["- Bukarest",26,17,null,100]
["- im Übrigen",27,18,null,80]
["Russische Föderation",null,null,null,"_"]
["- Moskau ²)",48,32,null,135]
["- Moskau ³)",33,22,null,"0³)"]
["- St. Petersburg",36,24,null,110]
["- im Übrigen",36,24,null,80]
["Sambia",36,24,null,95]
["Samoa",29,20,null,57]
["San Marino",41,28,null,77]
["Sao Tomé und Principe",42,28,null,75]
["Saudi-Arabien",47,32,null,80]
["- Djidda",48,32,null,80]
["- Riad",48,32,null,95]
["Schweden",72,48,null,165]
["Schweiz",null,null,null,"_"]
["- Genf",62,41,null,174]
["- im Übrigen",48,32,null,139]
["Senegal",42,28,null,130]
["Serbien",30,20,null,90]
["Sierra Leone",39,26,null,82]
["Simbabwe",45,30,null,103]
["Singapur",53,36,null,188]
["Slowakische Republik",24,16,null,130]
["Slowenien",30,20,null,95]
["Spanien",null,null,null,"_"]
["- Barcelona",32,21,null,118]
["- Kanarische Inseln",32,21,null,98]
["- Madrid",41,28,null,113]
["- Palma de Mallorca",32,21,null,110]
["- im Übrigen",29,20,null,88]
["Sri Lanka",40,27,null,118]
["St. Kitts und Nevis",45,30,null,99]
["St. Lucia",54,36,null,129]
["St. Vincent und die Grenadinen",52,35,null,121]
["Sudan",32,21,null,120]
["Südafrika",null,null,null,"_"]
["- Kapstadt",38,25,null,94]
["- im Übrigen",36,24,null,72]
["Südsudan",46,31,null,134]
["Suriname",30,20,null,75]
["Syrien, Arabische Republik",38,25,null,140]
["Tadschikistan",26,17,null,67]
["Taiwan",39,26,null,110]
["Tansania",40,27,null,141]
["Thailand",32,21,null,120]
["Togo",33,22,null,80]
["Tonga",32,21,null,36]
["Trinidad und Tobago",54,36,null,164]
["Tschad",47,32,null,151]
["Tschechische Republik",24,16,null,97]
["Türkei","_"]
["- Instanbul",35,24,null,92]
["- Izmir",42,28,null,80]
["- Im Übrigen",40,27,null,78]
["Tunesien",33,22,null,80]
["Turkmenistan",33,22,null,108]
["Uganda",33,22,null,130]
["Ukraine",36,24,null,85]
["Ungarn",30,20,null,75]
["Uruguay",36,24,null,70]
["Usbekistan",30,20,null,60]
["Vatikanstadt",52,35,null,160]
["Venezuela",48,32,null,207]
["Vereinigte Arabische Emirate",42,28,null,145]
["Vereinigte Staaten",null,null,null,"_"]
["- Atlanta",57,38,null,122]
["- Boston",48,32,null,206]
["- Chicago",48,32,null,130]
["- Houston",57,38,null,136]
["- Los Angeles",48,32,null,153]
["- Miami",57,38,null,102]
["- New York",48,32,null,215]
["- San Francisco",48,32,null,110]
["- Washington DC",57,38,null,205]
["- Im Übrigen       Vereinigtes Königreich v. GB",48,32,null,102]
["und Nordirland",null,null,null,"_"]
["- London",57,38,null,160]
["- im Übrigen",42,28,null,119]
["Vietnam",38,25,null,86]
["Weißrussland",27,18,null,109]
["Zentralafrikanische Republik",29,20,null,52]
["Zypern",39,26,null,90]
["*"]
["1) einschl. der Departements Haute-Seine, Seine-Saint Denis und Val-de-Marne"]
["²) Außer Gästewohnungen der Deutschen Botschaft"]
["³) Gästewohnungen der Deutschen Botschaft. Soweit diese Wohnungen gegen Entgelt angemietet werden, können 135 € angesetzt werden."]

{"sheet":"VMA15","index":4,"n_rows":258,"n_cols":5,"rows_kept":258,"cut":false,"hidden":true,"merged":[]}
["Pauschbeträge für Verpflegungsmehraufwendungen"]
["bei einer Abwesenheitsdauer je Kalendertag im Ausland (Geltungsdauer 2015)"]
["Land               mind. 24 Std.            mind. 8 Std.     Übernachtung"]
["---------------------------------------------------------------------------------------------------------------------------------"]
["20% 80% 40%"]
["Afghanistan",30,20,null,95]
["Ägypten",40,27,null,113]
["Äthiopien",27,18,null,86]
["Äquatorialguinea",50,33,null,226]
["Albanien",23,16,null,110]
["Algerien",39,26,null,190]
["Andorra",32,21,null,82]
["Angola",77,52,null,265]
["Antigua und Barbuda",53,36,null,117]
["Argentinien",34,23,null,144]
["Armenien",23,16,null,63]
["Aserbaidschan",40,27,null,120]
["Australien",56,37,null,133]
["- Canberra",58,39,null,158]
["- Sydney",59,40,null,186]
["- im Übrigen",56,37,null,133]
["Bahrain",36,24,null,70]
["Bangladesch",30,20,null,111]
["Barbados",58,39,null,179]
["Belgien",41,28,null,135]
["Benin",40,27,null,101]
["Bolivien",24,16,null,70]
["Bosnien-Herzegowina",18,12,null,73]
["Botsuana",33,22,null,105]
["Brasilien",54,36,null,110]
["- Brasilia",53,36,null,160]
["- Rio de Janeiro",47,32,null,145]
["- Sao Paulo",53,36,null,120]
["- im Übrigen",54,36,null,110]
["Brunei (Darussalam)",48,32,null,106]
["Bulgarien",22,15,null,90]
["Burkina Faso",44,29,null,84]
["Burundi",47,32,null,98]
["Cabo Verde",30,20,null,55]
["Chile",40,27,null,130]
["China",33,22,null,80]
["- Chengdu",32,21,null,85]
["- Hongkong",62,41,null,170]
["- Peking",39,26,null,115]
["- Shanghai",42,28,null,140]
["Costa Rica",36,24,null,69]
["Côte d'Ivoire",51,34,null,146]
["Dänemark",60,40,null,150]
["Deutschland",24,12,null,20]
["Dominica",40,27,null,94]
["Dominikanische Republik",40,27,null,71]
["Dschibuti",48,32,null,160]
["Ecuador",39,26,null,55]
["El Salvador",46,31,null,75]
["Eritrea",30,20,null,58]
["Estland",27,18,null,71]
["Fidschi",32,21,null,57]
["Finnland",39,26,null,136]
["Frankreich                                                                                                                 "]
["- Lyon",53,36,null,83]
["- Marseille",51,34,null,86]
["- Paris *)",58,39,null,135]
["- Straßburg",48,32,null,89]
["- im Übrigen",44,29,null,81]
["Gabun",62,41,null,278]
["Gambia",18,12,null,70]
["Georgien",30,20,null,80]
["Ghana",46,31,null,174]
["Grenada",51,34,null,121]
["Griechenland",null,null,null,"_"]
["- Athen",57,38,null,125]
["- im Übrigen",42,28,null,132]
["Guatemala",28,19,null,96]
["Guinea",38,25,null,110]
["Guinea-Bissau",30,20,null,60]
["Guyana",41,28,null,81]
["Haiti",50,33,null,111]
["Honduras",44,29,null,104]
["Indien",null,null,null,"_"]
["- Chennai (Madras)",30,20,null,135]
["- Kalkutta (Kolkata)",33,22,null,120]
["- Bombay (Mumbai)",35,24,null,150]
["- Neu Delhi",35,24,null,130]
["- im Übrigen",30,20,null,120]
["Indonesien",38,25,null,130]
["Iran, Islamische Republik",28,19,null,84]
["Irland",42,28,null,90]
["Island",47,32,null,108]
["Israel",59,40,null,175]
["Italien",null,null,null,"_"]
["- Mailand",39,26,null,156]
["- Rom",52,35,null,160]
["- im Übrigen",34,23,null,126]
["Jamaika",54,36,null,135]
["Japan",null,null,null,"_"]
["- Tokio",53,36,null,153]
["- im Übrigen",51,34,null,156]
["Jordanien",36,24,null,85]
["Kambodscha",36,24,null,85]
["Kamerun",40,27,null,130]
["Kanada",null,null,null,"_"]
["- Ottawa",36,24,null,105]
["- Toronto",41,28,null,135]
["- Vancouver",36,24,null,125]
["- im Übrigen",36,24,null,100]
["Kasachstan",39,26,null,109]
["Katar",56,37,null,170]
["Kenia",35,24,null,135]
["Kirgisistan",29,20,null,91]
["Kolumbien",41,28,null,126]
["Kongo, Republik",57,38,null,113]
["Kongo, Demokratische Republik (früher: Zaire)",60,40,null,155]
["Korea, Demokr. Volksrepublik",39,26,null,132]
["Korea, Republik",66,44,null,180]
["Kosovo",26,17,null,65]
["Kroatien",28,19,null,75]
["Kuba",50,33,null,85]
["Kuwait",42,28,null,130]
["Laos",33,22,null,67]
["Lesotho",24,16,null,70]
["Lettland",30,20,null,80]
["Libanon",44,29,null,120]
["Libyen",45,30,null,100]
["Liechtenstein",47,32,null,82]
["Litauen",24,16,null,68]
["Luxemburg",47,32,null,102]
["Madagaskar",38,25,null,83]
["Malawi",39,26,null,110]
["Malaysia",36,24,null,100]
["Malediven",38,25,null,93]
["Mali",41,28,null,122]
["Malta",45,30,null,112]
["Marokko",42,28,null,105]
["Marshall Inseln",63,42,null,70]
["Mauretanien",48,32,null,89]
["Mauritius",48,32,null,140]
["Mazedonien",24,16,null,95]
["Mexiko",41,28,null,141]
["Mikronesien",56,37,null,74]
["Moldawien",18,12,null,100]
["Monaco",41,28,null,52]
["Mongolei",29,20,null,84]
["Montenegro",29,20,null,95]
["Mosambik",42,28,null,147]
["Myanmar (früher Burma)",46,31,null,45]
["Namibia",23,16,null,77]
["Nepal",28,19,null,86]
["Nicaragua",30,20,null,100]
["Niederlande",46,31,null,119]
["Niger",36,24,null,70]
["Nigeria",63,42,null,255]
["Norwegen",64,43,null,182]
["Österreich",36,24,null,104]
["Oman",48,32,null,120]
["Pakistan",null,null,null,"_"]
["- Islamabad",30,20,null,165]
["- Im Übrigen",27,18,null,68]
["Palau",51,34,null,166]
["Panama",34,23,null,101]
["Papua-Neuguinea",36,24,null,90]
["Paraguay",36,24,null,61]
["Peru",30,20,null,93]
["Philippinen",30,20,null,107]
["Polen",null,null,null,"_"]
["- Breslau",33,22,null,92]
["- Danzig",29,20,null,77]
["- Krakau",28,19,null,88]
["- Warschau, Krakau",30,20,null,105]
["- im Übrigen",27,18,null,50]
["Portugal",36,24,null,92]
["Ruanda",36,24,null,135]
["Rumänien",null,null,null,"_"]
["- Bukarest",26,17,null,100]
["- im Übrigen",27,18,null,80]
["Russische Föderation",null,null,null,"_"]
["- Moskau ²)",30,20,null,118]
["- St. Petersburg",24,16,null,104]
["- im Übrigen",21,14,null,78]
["Sambia",36,24,null,95]
["Samoa",29,20,null,57]
["San Marino",41,28,null,77]
["Sao Tomé und Principe",42,28,null,75]
["Saudi-Arabien",47,32,null,80]
["- Djidda",48,32,null,80]
["- Riad",48,32,null,95]
["Schweden",72,48,null,165]
["Schweiz",null,null,null,"_"]
["- Genf",62,41,null,174]
["- im Übrigen",48,32,null,139]
["Senegal",47,32,null,125]
["Serbien",30,20,null,90]
["Sierra Leone",39,26,null,82]
["Simbabwe",45,30,null,103]
["Singapur",53,36,null,188]
["Slowakei",24,16,null,130]
["Slowenien",30,20,null,95]
["Spanien",null,null,null,"_"]
["- Barcelona",32,21,null,118]
["- Kanarische Inseln",32,21,null,98]
["- Madrid",41,28,null,113]
["- Palma de Mallorca",32,21,null,110]
["- im Übrigen",29,20,null,88]
["Sri Lanka",40,27,null,118]
["St. Kitts und Nevis",45,30,null,99]
["St. Lucia",54,36,null,129]
["St. Vincent und die Grenadinen",52,35,null,121]
["Sudan",35,24,null,115]
["Südafrika",null,null,null,"_"]
["- Kapstadt",38,25,null,94]
["- im Übrigen",36,24,null,72]
["Südsudan",53,36,null,114]
["Suriname",30,20,null,108]
["Syrien, arabische Republik",38,25,null,140]
["Tadschikistan",26,17,null,67]
["Taiwan",39,26,null,110]
["Tansania",40,27,null,141]
["Thailand",32,21,null,120]
["Togo",35,24,null,108]
["Tonga",32,21,null,36]
["Trinidad und Tobago",54,36,null,164]
["Tschad",47,32,null,151]
["Tschechische Republik",24,16,null,97]
["Türkei","_"]
["- Instanbul",35,24,null,92]
["- Izmir",42,28,null,80]
["- Im Übrigen",40,27,null,78]
["Tunesien",33,22,null,80]
["Turkmenistan",33,22,null,108]
["Uganda",35,24,null,129]
["Ukraine",36,24,null,85]
["Ungarn",30,20,null,75]
["Uruguay",44,29,null,109]
["Usbekistan",34,23,null,123]
["Vatikanstadt",52,35,null,160]
["Venezuela",48,32,null,207]
["Vereinigte Arabische Emirate",45,30,null,155]
["Vereinigte Staaten",null,null,null,"_"]
["- Atlanta",57,38,null,122]
["- Boston",48,32,null,206]
["- Chicago",48,32,null,130]
["- Houston",57,38,null,136]
["- Los Angeles",48,32,null,153]
["- Miami",57,38,null,102]
["- New York",48,32,null,215]
["- San Francisco",48,32,null,110]
["- Washington DC",57,38,null,205]
["- Im Übrigen",48,32,null,102]
["Vereinigtes Königreich",null,null,null,"_"]
["- London",57,38,null,160]
["- im Übrigen",42,28,null,119]
["Vietnam",38,25,null,86]
["Weißrussland",27,18,null,109]
["Zentralafrikanische Republik",29,20,null,52]
["Zypern",39,26,null,90]
["*) einschl. der Departements Haute-Seine, Seine-Saint Denis und Val-de-Marne"]
["1) inkl. An- und Abreisetag"]
["²) Außer Gästewohnungen der Deutschen Botschaft"]
["³) Gästewohnungen der Deutschen Botschaft. Soweit diese Wohnungen gegen Entgelt angemietet werden, können 135 € angesetzt werden."]

{"sheet":"VMA2016","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tabelle1","index":6,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,20]

{"sheet":"Bearbeitungshinweise","index":7,"n_rows":38,"n_cols":31,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,16],[2,1,2,3],[2,4,2,6],[2,10,2,16],[4,1,4,8],[8,8,8,15],[6,1,6,8],[8,1,8,2],[8,3,8,7],[37,1,37,3],[37,4,37,6],[37,12,37,16],[35,1,35,11],[28,1,28,11],[29,2,29,3],[28,12,28,16],[35,12,35,16],[32,12,32,16],[10,4,10,5],[9,8,9,9],[9,10,9,12],[33,7,33,8],[33,5,33,6],[26,1,26,11],[26,12,26,16]]}
[null,"Reisekostenabrechnung (Inland) 2020"]
[]
[null,"für den Monat / Zeitraum",null,null,"Mai",{"$nulls":4},"Name:"]
[]
[null,"Ich bin Arbeitnehmer?",{"$nulls":7},"ja"]
[]
[null,"Ich erstelle die Abrechnung für meine Einkommensteuererklärung",{"$nulls":7},"nein"]
[]
["ZURÜCK","Reisedaten",null,"Reisezeiten",{"$nulls":4},"Übernachtung",{"$nulls":7},"Fahrt-kosten"]
[null,"Reiseziel ","Reisezweck","Reisetag","Beginn","Ende","Dauer","Verpflegungs-pauschale","Übernachtung",null,"Wurden bestimmte Mahlzeiten gestellt bzw. separat abgerechnet?",null,null,"Verpflegungspau-schale abzgl. F, M, A","Nachweis (z. B. Hotelrechnung lt. Anlage)","Pauschal \n(20,- EUR nur ohne Nachweis)","gefahrene Strecke (gesamt)"]
[null,"Ort","Erläuterungen","Datum","Zeit",null,"Std.","EUR",null,"Hotel (Name)","Frühstück ","Mittagessen","Abendessen","EUR","EUR","EUR","km",null,"Frühstück","Mittagessen","Abendessen","Kürzung Gesamt","VMAabzgl. Kürzung","VMA","Max ","Erstattung"]
[null,"Bremen","Messe","2020-05-15","18:00:00",1,{"$f":"IF((ISNUMBER(D12)),(F12-E12),\"\")","v":0.25},{"$f":"IF(AND(ISNUMBER(D12),ISNUMBER(G12)),IF(G12>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G12>TIME(8,0,0),E12>TIME(0,0,0),F12<TIME(23,59,59)),AND(E12<TIME(0,0,1),F12<TIME(23,59,59),E12<>\"\",F12<>\"\"),AND(E12>TIME(0,0,0),F12>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":14},"ja","Acer",null,null,null,{"$f":"Z12","v":14},100,{"$f":"IF(AND($J$5=\"ja\",I12=\"ja\",$J$7=\"nein\"),IF(O12=\"\",20,\"\"),\"\")","v":""},476,null,{"$f":"IF(K12=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L12=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M12=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S12:U12)","v":0},{"$f":"H12-V12","v":14},{"$f":"H12","v":14},{"$f":"IF(((H12-V12)>0),(H12-V12),X12)","v":14},{"$f":"IF((W12<=0),0,Y12)","v":14},{"$f":"IF(Y12>=0,Y12,0)","v":14},{"$f":"IF(AND(S12=4.8,Z12>=0),S12,0)","v":0},{"$f":"IF(AND(T12=9.6,$Z12>=0),T12,0)","v":0},0,{"$f":"SUM(AB12:AD12)","v":0}]
[null,"Bremen","Messe","2020-05-16","00:00:00",1,1,{"$f":"IF(AND(D13<>\"\",G13<>\"\"),IF(G13>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G13>TIME(8,0,0),E13>TIME(0,0,0),F13<TIME(23,59,59)),AND(E13<TIME(0,0,1),F13<TIME(23,59,59),E13<>\"\",F13<>\"\"),AND(E13>TIME(0,0,0),F13>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":28},"ja","Acer","ja","ja",null,{"$f":"Z13","v":11.200000000000003},null,{"$f":"IF(AND($J$5=\"ja\",I13=\"ja\",$J$7=\"nein\"),IF(O13=\"\",20,\"\"),\"\")","v":20},15,null,{"$f":"IF(K13=\"ja\",Kürzung!$B$30,0)","v":5.6},{"$f":"IF(L13=\"ja\",Kürzung!$B$31,0)","v":11.2},{"$f":"IF(M13=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S13:U13)","v":16.799999999999997},{"$f":"H13-V13","v":11.200000000000003},{"$f":"H13","v":28},{"$f":"IF(((H13-V13)>0),(H13-V13),X13)","v":11.200000000000003},{"$f":"IF((W13<=0),0,Y13)","v":11.200000000000003},{"$f":"IF(Y13>=0,Y13,0)","v":11.200000000000003},{"$f":"IF(AND(S13=4.8,Z13>=0),S13,0)","v":0},0,0,{"$f":"SUM(AB13:AD13)","v":0}]
[null,"Bremern","Messe","2020-05-17","00:00:00",0.75,{"$f":"IF((ISNUMBER(D14)),(F14-E14),\"\")","v":0.75},{"$f":"IF(AND(D14<>\"\",G14<>\"\"),IF(G14>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G14>TIME(8,0,0),E14>TIME(0,0,0),F14<TIME(23,59,59)),AND(E14<TIME(0,0,1),F14<TIME(23,59,59),E14<>\"\",F14<>\"\"),AND(E14>TIME(0,0,0),F14>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":14},{"$nulls":5},14,null,{"$f":"IF(AND($J$5=\"ja\",I14=\"ja\",$J$7=\"nein\"),IF(O14=\"\",20,\"\"),\"\")","v":""},476,null,{"$f":"IF(K14=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L14=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M14=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S14:U14)","v":0},{"$f":"H14-V14","v":14},{"$f":"H14","v":14},{"$f":"IF(((H14-V14)>0),(H14-V14),X14)","v":14},{"$f":"IF((W14<=0),0,Y14)","v":14},{"$f":"IF(Y14>=0,Y14,0)","v":14},{"$f":"IF(AND(S14=4.8,Z14>=0),S14,0)","v":0},0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D15<>\"\",G15<>\"\"),IF(G15>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G15>TIME(8,0,0),E15>TIME(0,0,0),F15<TIME(23,59,59)),AND(E15<TIME(0,0,1),F15<TIME(23,59,59),E15<>\"\",F15<>\"\"),AND(E15>TIME(0,0,0),F15>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K15=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L15=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M15=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S15:U15)","v":0},{"$f":"H15-V15","v":0},{"$f":"H15","v":0},{"$f":"IF(((H15-V15)>0),(H15-V15),X15)","v":0},{"$f":"IF((W15<=0),0,Y15)","v":0},{"$f":"IF(Y15>=0,Y15,0)","v":0},{"$f":"IF(AND(S15=4.8,Z15>=0),S15,0)","v":0},0,0,0]
[null,"Leipzig","Kundendienst","2020-05-20","08:00:00",0.78472222222222221,0.4513888888888889,{"$f":"IF(AND(D16<>\"\",G16<>\"\"),IF(G16>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G16>TIME(8,0,0),E16>TIME(0,0,0),F16<TIME(23,59,59)),AND(E16<TIME(0,0,1),F16<TIME(23,59,59),E16<>\"\",F16<>\"\"),AND(E16>TIME(0,0,0),F16>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":14},null,null,null,"ja",null,2.8000000000000007,null,"",244,null,{"$f":"IF(K16=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L16=\"ja\",Kürzung!$B$31,0)","v":11.2},{"$f":"IF(M16=\"ja\",Kürzung!$B$32,0)","v":0},11.2,{"$f":"H16-V16","v":2.8000000000000007},{"$f":"H16","v":14},{"$f":"IF(((H16-V16)>0),(H16-V16),X16)","v":2.8000000000000007},2.8000000000000007,{"$f":"IF(Y16>=0,Y16,0)","v":2.8000000000000007},0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D17<>\"\",G17<>\"\"),IF(G17>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G17>TIME(8,0,0),E17>TIME(0,0,0),F17<TIME(23,59,59)),AND(E17<TIME(0,0,1),F17<TIME(23,59,59),E17<>\"\",F17<>\"\"),AND(E17>TIME(0,0,0),F17>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K17=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L17=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M17=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Görlitz","Kundendienst","2020-05-29","08:00:00",0.64583333333333337,0.31250000000000006,{"$f":"IF(AND(D18<>\"\",G18<>\"\"),IF(G18>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G18>TIME(8,0,0),E18>TIME(0,0,0),F18<TIME(23,59,59)),AND(E18<TIME(0,0,1),F18<TIME(23,59,59),E18<>\"\",F18<>\"\"),AND(E18>TIME(0,0,0),F18>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",224,null,{"$f":"IF(K18=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L18=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M18=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D19<>\"\",G19<>\"\"),IF(G19>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G19>TIME(8,0,0),E19>TIME(0,0,0),F19<TIME(23,59,59)),AND(E19<TIME(0,0,1),F19<TIME(23,59,59),E19<>\"\",F19<>\"\"),AND(E19>TIME(0,0,0),F19>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K19=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L19=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M19=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D20<>\"\",G20<>\"\"),IF(G20>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G20>TIME(8,0,0),E20>TIME(0,0,0),F20<TIME(23,59,59)),AND(E20<TIME(0,0,1),F20<TIME(23,59,59),E20<>\"\",F20<>\"\"),AND(E20>TIME(0,0,0),F20>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K20=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L20=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M20=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D21<>\"\",G21<>\"\"),IF(G21>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G21>TIME(8,0,0),E21>TIME(0,0,0),F21<TIME(23,59,59)),AND(E21<TIME(0,0,1),F21<TIME(23,59,59),E21<>\"\",F21<>\"\"),AND(E21>TIME(0,0,0),F21>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K21=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L21=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M21=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D22<>\"\",G22<>\"\"),IF(G22>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G22>TIME(8,0,0),E22>TIME(0,0,0),F22<TIME(23,59,59)),AND(E22<TIME(0,0,1),F22<TIME(23,59,59),E22<>\"\",F22<>\"\"),AND(E22>TIME(0,0,0),F22>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K22=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L22=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M22=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},"",{"$f":"IF(AND(D23<>\"\",G23<>\"\"),IF(G23>TIME(23,59,59),data_fill!$D$3,IF(OR(AND(G23>TIME(8,0,0),E23>TIME(0,0,0),F23<TIME(23,59,59)),AND(E23<TIME(0,0,1),F23<TIME(23,59,59),E23<>\"\",F23<>\"\"),AND(E23>TIME(0,0,0),F23>TIME(23,59,59))),data_fill!$D$2,0)),0)","v":0},{"$nulls":5},0,null,"",null,null,{"$f":"IF(K23=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L23=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M23=\"ja\",Kürzung!$B$32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Summe",{"$nulls":11},{"$f":"SUM(N12:N23)","v":42},{"$f":"SUM(O12:O23)","v":100},{"$f":"SUM(P12:P23)","v":20},{"$f":"SUM(Q12:Q23)","v":1435},null,{"$f":"IF(K24=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L24=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M24=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S24:U24)","v":0},{"$f":"H24-V24","v":0},{"$f":"H24","v":0},{"$f":"IF(((H24-V24)>0),(H24-V24),0)","v":0},{"$f":"IF((W24<=0),0,Y24)","v":0},{"$f":"IF(Y24>=0,Y24,0)","v":0},{"$f":"IF(AND(S24=4.8,Z24>=0),S24,0)","v":0},{"$f":"IF(AND(T24=9.6,$Z24>=0),T24,0)","v":0},{"$f":"IF(AND(U24=9.6,$Z24>=0),U24,0)","v":0},0]
[{"$nulls":18},{"$f":"IF(K25=\"ja\",Kürzung!$B$30,0)","v":0},{"$f":"IF(L25=\"ja\",Kürzung!$B$31,0)","v":0},{"$f":"IF(M25=\"ja\",Kürzung!$B$32,0)","v":0},{"$f":"SUM(S25:U25)","v":0},{"$f":"H25-V25","v":0},{"$f":"H25","v":0},{"$f":"IF(((H25-V25)>0),(H25-V25),0)","v":0},{"$f":"IF((W25<=0),0,Y25)","v":0},{"$f":"IF(Y25>=0,Y25,0)","v":0},{"$f":"IF(AND(S25=4.8,Z25>=0),S25,0)","v":0},{"$f":"IF(AND(T25=9.6,$Z25>=0),T25,0)","v":0},{"$f":"IF(AND(U25=9.6,$Z25>=0),U25,0)","v":0},0]
[null,"Auszahlungen",{"$nulls":23},{"$f":"SUM(Z12:Z25)","v":42},{"$f":"IF(Y26>=0,Y26,0)","v":0},{"$f":"(SUM(AB12:AB25))/Kürzung!$B$30","v":0},{"$f":"(SUM(AC12:AC25))/Kürzung!$B$31","v":0},{"$f":"(SUM(AD12:AD25))/Kürzung!$B$32","v":0}]
[null,"Summe Verpflegungsmehraufwendungen abzgl. anzurechnende F, M, A",{"$nulls":10},{"$f":"Z26","v":42}]
[]
[null,"Übernachtungskosten",{"$nulls":10},{"$f":"SUM(J30:J31)","v":120}]
[null,null,"Hotel (mit Nachweis)",{"$nulls":6},{"$f":"O24","v":100}]
[null,null,"Pauschal",{"$nulls":6},{"$f":"P24","v":20}]
[]
[null,"Fahrtkosten (Pkw)",{"$nulls":10},{"$f":"$H$34*$D$34","v":430.5}]
[null,null,"Summe km:",{"$f":"$Q$24","v":1435},null,"pauschal pro Kilometer:",null,{"$f":"Kürzung!$B$35","v":0.3}]
[]
[null,"sonstige Kosten lt. Nachweis (z. B. Parkkosten, Autobahngebühren)",{"$nulls":10},5]
[]
[null,"Auszahlung der Reisekosten für",null,null,{"$f":"IF((($E$3)=\"Bitte auswählen!\"),\" \",$E$3)","v":"Mai"},{"$nulls":7},{"$f":"SUM(M27+M29+M33+M36)","v":597.5}]

{"sheet":"Kürzung","index":8,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"ja"]
[null,"nein","Frühstück","Mittag ","Abendessen","SUMME"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K11=\"ja\",Reisekostenabrechnung!$H11*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L11=\"ja\",Reisekostenabrechnung!$H11*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M11=\"ja\",Reisekostenabrechnung!$H11*-0.4,0)","v":0},{"$f":"SUM(C5:E5)","v":"00:00:00"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K12=\"ja\",Reisekostenabrechnung!$H12*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L12=\"ja\",Reisekostenabrechnung!$H12*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M12=\"ja\",Reisekostenabrechnung!$H12*-0.4,0)","v":0},{"$f":"SUM(C6:E6)","v":"00:00:00"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K13=\"ja\",Reisekostenabrechnung!$H13*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L13=\"ja\",Reisekostenabrechnung!$H13*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M13=\"ja\",Reisekostenabrechnung!$H13*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K14=\"ja\",Reisekostenabrechnung!$H14*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L14=\"ja\",Reisekostenabrechnung!$H14*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M14=\"ja\",Reisekostenabrechnung!$H14*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K16=\"ja\",Reisekostenabrechnung!$H16*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L16=\"ja\",Reisekostenabrechnung!$H16*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M16=\"ja\",Reisekostenabrechnung!$H16*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K17=\"ja\",Reisekostenabrechnung!$H17*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L17=\"ja\",Reisekostenabrechnung!$H17*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M17=\"ja\",Reisekostenabrechnung!$H17*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K20=\"ja\",Reisekostenabrechnung!$H20*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L20=\"ja\",Reisekostenabrechnung!$H20*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M20=\"ja\",Reisekostenabrechnung!$H20*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K21=\"ja\",Reisekostenabrechnung!$H21*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L21=\"ja\",Reisekostenabrechnung!$H21*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M21=\"ja\",Reisekostenabrechnung!$H21*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K23=\"ja\",Reisekostenabrechnung!$H23*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L23=\"ja\",Reisekostenabrechnung!$H23*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M23=\"ja\",Reisekostenabrechnung!$H23*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K24=\"ja\",Reisekostenabrechnung!$H24*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L24=\"ja\",Reisekostenabrechnung!$H24*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M24=\"ja\",Reisekostenabrechnung!$H24*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!K25=\"ja\",Reisekostenabrechnung!$H25*-0.2,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!L25=\"ja\",Reisekostenabrechnung!$H25*-0.4,0)","v":0},{"$f":"+IF(Reisekostenabrechnung!M25=\"ja\",Reisekostenabrechnung!$H25*-0.4,0)","v":0},"00:00:00"]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.2,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$f":"+IF(Reisekostenabrechnung!#REF!=\"ja\",Reisekostenabrechnung!#REF!*-0.4,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[]
[]
["Kürzungspauschalen Inland"]
["max. Erstattung:",{"$f":"data_fill!D3","v":28}]
["Frühstück",{"$f":"$B$29*20/100","v":5.6}]
["Mittag",{"$f":"$B$29*40/100","v":11.2}]
["Abend",{"$f":"$B$29*40/100","v":11.2}]
[]
[]
["Kilometerpauschale",0.3]
[]
["Januar"]
["Februar"]
["März"]
["April"]
["Mai"]
["Juni"]
["Juli"]
["August"]
["September"]
["Oktober"]
["November"]
["Dezember"]