{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Startseite","Eingaben","Berechnung","Beispiel","Hilfe","Stammdaten","Pauschalen","Parameter_Intern","__Goal_Metadata"],"not_rendered":{"images":5,"macros":1,"defined_names":22,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Startseite","index":0,"n_rows":41,"n_cols":14,"rows_kept":41,"merged":[[10,6,14,7],[11,12,11,13],[16,3,16,4]]}
[]
[]
[]
[{"$nulls":9},"Startseite"]
[null,"Reisekostenrechner 2026"]
[]
[]
[]
[{"$nulls":3},"Tabellenblätter",{"$nulls":8},"Tabellenblatt",2]
[{"$nulls":6},"Info"]
[{"$nulls":6},{"$f":"INDEX(Parameter_Intern!C5:D10,Startseite!N9,2)","v":"In diesem Arbeitsblatt wird die Reisekostenabrechnung erstellt"},{"$nulls":5},{"$f":"+N9/2","v":1},{"$f":"+ROUND(N9/2,0)","v":1}]
[{"$nulls":12},{"$f":"IF(M11=N11,1,2)","v":1}]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"\"Bei einem Klick auf \"&H17&\" kommen Sie direkt zum entsprechenden Arbeitsblatt\"","v":"Bei einem Klick auf Berechnung kommen Sie direkt zum entsprechenden Arbeitsblatt"},{"$nulls":3},{"$f":"+HYPERLINK(VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,4,FALSE),VLOOKUP($N$9,Parameter_Intern!$B$5:$E$30,2,FALSE))","v":"Berechnung"}]
{"$rows_empty":21}
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Eingaben","index":1,"n_rows":77,"n_cols":27,"rows_kept":77,"merged":[[1,1,1,13],[3,5,3,7],[11,4,13,12],[39,4,39,7],[40,4,40,7],[41,4,41,7],[42,4,42,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[47,4,47,7],[52,1,52,3],[52,6,52,8]]}
[{"$nulls":13},"Eingaben"]
[null,"Reisekostenrechner 2026 - Eingaben",{"$nulls":17},1.6]
[{"$nulls":18},1,4.8]
[{"$nulls":3},"Mitarbeiter auswählen:",null,"Mustermann, Max",{"$nulls":3},{"$f":"+IF(U5=\"Fehler\",\"<- Mitarbeiter wählen\",\"\")","v":""}]
[{"$nulls":18},"Mitarbeiter",null,{"$f":"IF(ISERROR(VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE)),\"Fehler\",VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE))","v":"Mustermann, Max, Musterstraße 11, 47111 Musterstadt"}]
[{"$nulls":3},"Beginn der Reise",{"$nulls":6},"USt-Satz ",{"$nulls":7},{"$f":"+IF(Stammdaten!G13=\"\",\"\",Stammdaten!G13)","v":"Mustermann, Max"}]
[{"$nulls":3},"Ende der Reise",{"$nulls":5},{"$f":"IF(F7<F6,\"Datum prüfen\",IF(AND(F7=F6,H7<H6),\"Zeiten prüfen\",\"\"))","v":""},{"$nulls":8},{"$f":"+IF(Stammdaten!G14=\"\",\"\",Stammdaten!G14)","v":"Müller, Hein-Otto"}]
[{"$nulls":3},{"$f":"+IF(AND(V12>=3,U35>90),\"Dreimonatsfrist beachten - Rechner nicht anwendbar\",\"\")","v":""},{"$nulls":14},{"$f":"+IF(Stammdaten!G15=\"\",\"\",Stammdaten!G15)","v":"Meier, Otti"}]
[{"$nulls":3},"Reiseland:",{"$nulls":14},{"$f":"+IF(Stammdaten!G16=\"\",\"\",Stammdaten!G16)","v":""},null,"Dreimonatsfrist"]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G17=\"\",\"\",Stammdaten!G17)","v":""},null,"Jahr/Monat",{"$f":"+YEAR(F6)&MONTH(F6)","v":"19001"}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G18=\"\",\"\",Stammdaten!G18)","v":""},null,"Jahr/Monat",{"$f":"+YEAR(F7)&MONTH(F7)","v":"19001"}]
[{"$nulls":3},"Reisezweck:",{"$nulls":14},{"$f":"+IF(Stammdaten!G19=\"\",\"\",Stammdaten!G19)","v":""},null,null,{"$f":"+V11-V10","v":0}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G20=\"\",\"\",Stammdaten!G20)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G21=\"\",\"\",Stammdaten!G21)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G22=\"\",\"\",Stammdaten!G22)","v":""}]
[{"$nulls":3},"Angaben zu Fahrkosten",{"$nulls":14},{"$f":"+IF(Stammdaten!G23=\"\",\"\",Stammdaten!G23)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G24=\"\",\"\",Stammdaten!G24)","v":""}]
[{"$nulls":3},"Bahnfahrten (brutto)",{"$nulls":7},{"$f":"IF(ISERROR(IF(ISNUMBER(J18),$L$6,0)),\"\",IF(ISNUMBER(J18),$L$6,0))","v":{"v":0,"d":"0.00%"}},{"$nulls":6},{"$f":"+IF(Stammdaten!G25=\"\",\"\",Stammdaten!G25)","v":""}]
[{"$nulls":3},"Flugkarten (brutto)",{"$nulls":7},{"$f":"IF(ISERROR(IF(ISNUMBER(J19),$L$6,0)),\"\",IF(ISNUMBER(J19),$L$6,0))","v":{"v":0,"d":"0.00%"}},{"$nulls":6},{"$f":"+IF(Stammdaten!G26=\"\",\"\",Stammdaten!G26)","v":""}]
[{"$nulls":3},"Autokosten (brutto)",{"$nulls":7},{"$f":"IF(ISERROR(IF(ISNUMBER(J20),$L$6,0)),\"\",IF(ISNUMBER(J20),$L$6,0))","v":{"v":0,"d":"0.00%"}},{"$nulls":6},{"$f":"+IF(Stammdaten!G27=\"\",\"\",Stammdaten!G27)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G28=\"\",\"\",Stammdaten!G28)","v":""}]
[{"$nulls":3},"Fahrten mit Privat-PKW",{"$nulls":14},{"$f":"+IF(Stammdaten!G29=\"\",\"\",Stammdaten!G29)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G30=\"\",\"\",Stammdaten!G30)","v":""}]
[{"$nulls":3},"Gefahrene km:",{"$nulls":14},{"$f":"+IF(Stammdaten!G31=\"\",\"\",Stammdaten!G31)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G32=\"\",\"\",Stammdaten!G32)","v":""}]
[{"$nulls":3},"Übernachtungskosten",{"$nulls":14},{"$f":"+IF(Stammdaten!G33=\"\",\"\",Stammdaten!G33)","v":""}]
[]
[{"$nulls":3},"Anzahl Übernachtungen",{"$nulls":7},{"$f":"IF(U32=1,0,IF(ISERROR(IF(ISNUMBER(J29),$L$6,0)),\"\",IF(ISNUMBER(J29),$L$6,0)))","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":3},{"$f":"+IF(U32=0,\"Kosten für Übernachtungen - gesamt brutto\",\"Pauschale Übernachtungskosten\")","v":"Pauschale Übernachtungskosten"},{"$nulls":5},{"v":370,"d":"370.00"},null,{"$f":"+IF(U32=0,\"\",J28*VLOOKUP($T$31,Pauschalen!$E$6:$M$221,9,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":6},"Pauschale Deutschland",{"$f":"+IF(S3=1,T2,T3)","v":1.6},{"$f":"+IF(ISERROR(T29*J28),0,T29*J28)","v":0}]
[{"$nulls":9},{"$f":"IF(U33=0,0,IF(U31=\"Deutschland\",-U29,J28*VLOOKUP($T$31,Pauschalen!$E$5:$M$221,7,FALSE)))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(U33=0,0,J28*VLOOKUP($T$31,Pauschalen!$E$5:$M$221,7,FALSE))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Mahlzeitengestellung",{"$nulls":3},"Frühstück",null,"Mittag",null,"Abend",{"$nulls":6},"Reiseziel",1,{"$f":"+VLOOKUP(T31,Pauschalen!E6:F221,2,FALSE)","v":"Deutschland"}]
[{"$nulls":18},"Mit Pauschalen abrechnen",true,{"$f":"+IF(T32=FALSE(),0,1)","v":1}]
[{"$nulls":3},{"$f":"+IF(U35>1,\"Anreisetag\",\"Reisetag\")","v":"Reisetag"},{"$nulls":14},"Inklus. Frühstück",true,{"$f":"+IF(T33=FALSE(),0,1)","v":1},{"$f":"+IF(U32=0,1,IF(U33=0,1,0))","v":0}]
[{"$nulls":3},"Zwischentag"]
[{"$nulls":3},"Rückreisetag",{"$nulls":14},"Anzahl Reisetage berechnen",null,{"$f":"+F7-F6+1","v":1}]
[]
[{"$nulls":3},"Belege",{"$nulls":14},"Erster Tag","Jahr","Monat","Tag","Stunde","Minute"]
[{"$nulls":19},{"$f":"+YEAR($F$6)","v":1900},{"$f":"MONTH($F$6)","v":1},{"$f":"DAY($F$6)","v":0},{"$f":"+HOUR(H6)","v":0},{"$f":"+MINUTE(H6)","v":0}]
[{"$nulls":3},"Datum","Belegart",{"$nulls":4},"Wert",null,"USt",{"$nulls":10},{"$f":"+IF(AND(W38=23,X38>0),W38,IF(AND(W38<24,X38>0),W38+1,W38))","v":0}]
[{"$nulls":11},{"$f":"IF(ISERROR(VLOOKUP(E40,$S$52:$T$77,2,FALSE)),\"\",VLOOKUP(E40,$S$52:$T$77,2,FALSE))","v":""},{"$nulls":6},"Abwesenheit in vollen Stunden",{"$nulls":3},{"$f":"IF(U35=1,ROUNDDOWN(24*(H7-H6),0),24-W39)","v":0},null,null,"Pauschale",{"$f":"+IF(W40>=14,VLOOKUP($T$31,Pauschalen!$E$6:$M$221,5,FALSE),IF(W40>=8,VLOOKUP($T$31,Pauschalen!$E$6:$M$221,4,FALSE),0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},{"$f":"IF(ISERROR(VLOOKUP(E41,$S$52:$T$77,2,FALSE)),\"\",VLOOKUP(E41,$S$52:$T$77,2,FALSE))","v":""}]
[{"$nulls":11},"",{"$nulls":6},"Letzter Tag","Jahr","Monat","Tag","Stunde","Minute"]
[{"$nulls":11},"",{"$nulls":7},{"$f":"+YEAR($F$7)","v":1900},{"$f":"MONTH($F$7)","v":1},{"$f":"DAY($F$7)","v":0},{"$f":"+HOUR(H7)","v":0},{"$f":"+MINUTE(H7)","v":0}]
[{"$nulls":11},"",{"$nulls":10},{"$f":"+IF(AND(W43=23,X43>0),23,IF(X43>0,W43+1,W43))","v":0}]
[{"$nulls":11},"",{"$nulls":6},"Abwesenheit in vollen Stunden",{"$nulls":3},{"$f":"+W44","v":0},null,null,"Pauschale",{"$f":"+IF(W45>=14,VLOOKUP($T$31,Pauschalen!$E$6:$M$221,5,FALSE),IF(W45>=8,VLOOKUP($T$31,Pauschalen!$E$6:$M$221,4,FALSE),0))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},""]
[{"$nulls":11},"",{"$nulls":6},"Anzahl volle Reisetage",null,null,{"$f":"IF(U35=1,0,U35-2)","v":0},{"$nulls":3},"Pauschale",{"$f":"VLOOKUP($T$31,Pauschalen!$E$6:$M$221,6,FALSE)","v":{"v":28,"d":"28.00"}}]
[{"$nulls":11},""]
[{"$nulls":18},"Sonderregelung bei 2tägiger Reise",null,null,{"$f":"+IF(AND(V47=0,W38>16,W43<8),1,0)","v":0}]
[{"$nulls":3},"./. Vorschüsse"]
[{"$nulls":18},"Weitere Belege","MwSt"]
[{"$nulls":18},{"$f":"IF(Stammdaten!T9=\"\",\"\",Stammdaten!T9)","v":"Mietwagen"},{"$f":"IF(Stammdaten!V9=\"\",\"\",Stammdaten!V9)","v":{"v":0.19,"d":"19.00%"}}]
[null,"<< Startseite",null,null,"Hilfe?","Beispiel","Stammdaten",{"$nulls":11},{"$f":"IF(Stammdaten!T10=\"\",\"\",Stammdaten!T10)","v":"Bewirtungskosten"},{"$f":"IF(Stammdaten!V10=\"\",\"\",Stammdaten!V10)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T11=\"\",\"\",Stammdaten!T11)","v":"öffentliche Verkehrsmittel"},{"$f":"IF(Stammdaten!V11=\"\",\"\",Stammdaten!V11)","v":{"v":0.19,"d":"19.00%"}}]
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG",{"$nulls":16},{"$f":"IF(Stammdaten!T12=\"\",\"\",Stammdaten!T12)","v":"Geschenke"},{"$f":"IF(Stammdaten!V12=\"\",\"\",Stammdaten!V12)","v":{"v":0.19,"d":"19.00%"}}]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und",{"$nulls":16},{"$f":"IF(Stammdaten!T13=\"\",\"\",Stammdaten!T13)","v":"Taxi 7%"},{"$f":"IF(Stammdaten!V13=\"\",\"\",Stammdaten!V13)","v":{"v":0.07,"d":"7.00%"}}]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet.",{"$nulls":16},{"$f":"IF(Stammdaten!T14=\"\",\"\",Stammdaten!T14)","v":"Taxi 19%"},{"$f":"IF(Stammdaten!V14=\"\",\"\",Stammdaten!V14)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T15=\"\",\"\",Stammdaten!T15)","v":"Kfz: Parkgebühren"},{"$f":"IF(Stammdaten!V15=\"\",\"\",Stammdaten!V15)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T16=\"\",\"\",Stammdaten!T16)","v":"Telefon / Handy"},{"$f":"IF(Stammdaten!V16=\"\",\"\",Stammdaten!V16)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T17=\"\",\"\",Stammdaten!T17)","v":"Kfz: sonstige Kosten"},{"$f":"IF(Stammdaten!V17=\"\",\"\",Stammdaten!V17)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T18=\"\",\"\",Stammdaten!T18)","v":"Kfz: Treibstoff"},{"$f":"IF(Stammdaten!V18=\"\",\"\",Stammdaten!V18)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T19=\"\",\"\",Stammdaten!T19)","v":""},{"$f":"IF(Stammdaten!V19=\"\",\"\",Stammdaten!V19)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T20=\"\",\"\",Stammdaten!T20)","v":""},{"$f":"IF(Stammdaten!V20=\"\",\"\",Stammdaten!V20)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T21=\"\",\"\",Stammdaten!T21)","v":""},{"$f":"IF(Stammdaten!V21=\"\",\"\",Stammdaten!V21)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T22=\"\",\"\",Stammdaten!T22)","v":""},{"$f":"IF(Stammdaten!V22=\"\",\"\",Stammdaten!V22)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T23=\"\",\"\",Stammdaten!T23)","v":""},{"$f":"IF(Stammdaten!V23=\"\",\"\",Stammdaten!V23)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T24=\"\",\"\",Stammdaten!T24)","v":""},{"$f":"IF(Stammdaten!V24=\"\",\"\",Stammdaten!V24)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T25=\"\",\"\",Stammdaten!T25)","v":""},{"$f":"IF(Stammdaten!V25=\"\",\"\",Stammdaten!V25)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T26=\"\",\"\",Stammdaten!T26)","v":""},{"$f":"IF(Stammdaten!V26=\"\",\"\",Stammdaten!V26)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T27=\"\",\"\",Stammdaten!T27)","v":""},{"$f":"IF(Stammdaten!V27=\"\",\"\",Stammdaten!V27)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T28=\"\",\"\",Stammdaten!T28)","v":""},{"$f":"IF(Stammdaten!V28=\"\",\"\",Stammdaten!V28)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T29=\"\",\"\",Stammdaten!T29)","v":""},{"$f":"IF(Stammdaten!V29=\"\",\"\",Stammdaten!V29)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T30=\"\",\"\",Stammdaten!T30)","v":""},{"$f":"IF(Stammdaten!V30=\"\",\"\",Stammdaten!V30)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T31=\"\",\"\",Stammdaten!T31)","v":""},{"$f":"IF(Stammdaten!V31=\"\",\"\",Stammdaten!V31)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T32=\"\",\"\",Stammdaten!T32)","v":""},{"$f":"IF(Stammdaten!V32=\"\",\"\",Stammdaten!V32)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T33=\"\",\"\",Stammdaten!T33)","v":""},{"$f":"IF(Stammdaten!V33=\"\",\"\",Stammdaten!V33)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T34=\"\",\"\",Stammdaten!T34)","v":""},{"$f":"IF(Stammdaten!V34=\"\",\"\",Stammdaten!V34)","v":""}]

{"sheet":"Berechnung","index":2,"n_rows":82,"n_cols":34,"rows_kept":82,"merged":[[1,1,1,19],[3,5,3,7],[11,14,11,15],[12,5,12,7],[14,4,16,18],[54,4,54,7],[55,4,55,7],[56,4,56,7],[57,4,57,7],[58,4,58,7],[59,4,59,7],[60,4,60,7],[61,4,61,7],[62,4,62,7],[77,1,77,3],[77,7,77,9],[77,11,77,13]]}
[{"$nulls":19},"Berechnung"]
[null,"Reisekostenrechner - Berechnung"]
[]
[{"$nulls":3},"Mitarbeiter:",null,{"$f":"+Eingaben!F4","v":"Mustermann, Max"},{"$nulls":3},{"$f":"+IF(AA5=\"Fehler\",\"<- Mitarbeiter wählen\",\"\")","v":""}]
[{"$nulls":24},"Mitarbeiter",null,{"$f":"IF(ISERROR(VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE)),\"Fehler\",VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE))","v":"Mustermann, Max, Musterstraße 11, 47111 Musterstadt"}]
[{"$nulls":3},"Beginn der Reise",null,{"$f":"+Eingaben!F6","v":"00:00:00"},"um",{"$f":"+Eingaben!H6","v":"00:00:00"},null,null,"USt-Satz ",{"$f":"+Eingaben!L6","v":{"v":0,"d":"0.00%"}},{"$nulls":12},{"$f":"+IF(Stammdaten!G13=\"\",\"\",Stammdaten!G13)","v":"Mustermann, Max"}]
[{"$nulls":3},"Ende der Reise",null,{"$f":"+Eingaben!F7","v":"00:00:00"},"um",{"$f":"+Eingaben!H7","v":"00:00:00"},null,{"$f":"IF(F7<F6,\"Datum prüfen\",IF(AND(F7=F6,H7<H6),\"Zeiten prüfen\",\"\"))","v":""},{"$nulls":14},{"$f":"+IF(Stammdaten!G14=\"\",\"\",Stammdaten!G14)","v":"Müller, Hein-Otto"}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G15=\"\",\"\",Stammdaten!G15)","v":"Meier, Otti"}]
[null," Reisekostenabrechnung 2026",{"$nulls":22},{"$f":"+IF(Stammdaten!G16=\"\",\"\",Stammdaten!G16)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G17=\"\",\"\",Stammdaten!G17)","v":""}]
[{"$nulls":3},{"$f":"IF(ISERROR(\"Name/Adresse des Mitarbeiters: \"&AA5),\"\",\"Name/Adresse des Mitarbeiters: \"&AA5)","v":"Name/Adresse des Mitarbeiters: Mustermann, Max, Musterstraße 11, 47111 Musterstadt"},{"$nulls":20},{"$f":"+IF(Stammdaten!G18=\"\",\"\",Stammdaten!G18)","v":""}]
[{"$nulls":3},"Beginn der Reise:",null,{"$f":"+F6","v":"00:00:00"},"um",{"$f":"+H6","v":"00:00:00"},"Uhr",null,"Ende",{"$f":"+F7","v":"00:00:00"},null,"um",{"$f":"+H7","v":"00:00:00"},null,"Uhr",{"$nulls":7},{"$f":"+IF(Stammdaten!G19=\"\",\"\",Stammdaten!G19)","v":""}]
[{"$nulls":3},"Reiseland:",null,{"$f":"+AA31","v":"Deutschland"},{"$nulls":3},{"$f":"+IF(AA32=1,\"mit Pauschalen abrechnen\",\"\")","v":"mit Pauschalen abrechnen"},{"$nulls":14},{"$f":"+IF(Stammdaten!G20=\"\",\"\",Stammdaten!G20)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G21=\"\",\"\",Stammdaten!G21)","v":""}]
[{"$nulls":3},"Reisezweck:",{"$f":"IF(Eingaben!E12=\"\",\"\",Eingaben!E12)","v":""},{"$nulls":19},{"$f":"+IF(Stammdaten!G22=\"\",\"\",Stammdaten!G22)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G23=\"\",\"\",Stammdaten!G23)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G24=\"\",\"\",Stammdaten!G24)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G25=\"\",\"\",Stammdaten!G25)","v":""}]
[{"$nulls":3},"Fahrkosten",{"$nulls":9},"Brutto",null,"VSt",null,"Netto",{"$nulls":6},{"$f":"+IF(Stammdaten!G26=\"\",\"\",Stammdaten!G26)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G27=\"\",\"\",Stammdaten!G27)","v":""}]
[{"$nulls":3},"Bahnfahrten (brutto)",{"$nulls":5},{"$f":"+IF(Eingaben!J18=\"\",\"\",Eingaben!J18)","v":""},null,{"$f":"+IF(Eingaben!L18=\"\",\"\",Eingaben!L18)","v":{"v":0,"d":"0.00%"}},null,{"$f":"+J21","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N21=\"\",N21=0),0,-ROUND(N21/(1+L21)*L21,2))),0,IF(OR(N21=\"\",N21=0),0,-ROUND(N21/(1+L21)*L21,2))))","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N21=0,N21=\"\"),0,N21+P21)),0,IF(OR(N21=0,N21=\"\"),0,N21+P21)))","v":""},{"$nulls":6},{"$f":"+IF(Stammdaten!G28=\"\",\"\",Stammdaten!G28)","v":""}]
[{"$nulls":3},"Flugkarten (brutto)",{"$nulls":5},{"$f":"+IF(Eingaben!J19=\"\",\"\",Eingaben!J19)","v":""},null,{"$f":"+IF(Eingaben!L19=\"\",\"\",Eingaben!L19)","v":{"v":0,"d":"0.00%"}},null,{"$f":"+J22","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N22=\"\",N22=0),0,-ROUND(N22/(1+L22)*L22,2))),0,IF(OR(N22=\"\",N22=0),0,-ROUND(N22/(1+L22)*L22,2))))","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N22=0,N22=\"\"),0,N22+P22)),0,IF(OR(N22=0,N22=\"\"),0,N22+P22)))","v":""},{"$nulls":6},{"$f":"+IF(Stammdaten!G29=\"\",\"\",Stammdaten!G29)","v":""}]
[{"$nulls":3},"Autokosten (brutto)",{"$nulls":5},{"$f":"+IF(Eingaben!J20=\"\",\"\",Eingaben!J20)","v":""},null,{"$f":"+IF(Eingaben!L20=\"\",\"\",Eingaben!L20)","v":{"v":0,"d":"0.00%"}},null,{"$f":"+J23","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N23=\"\",N23=0),0,-ROUND(N23/(1+L23)*L23,2))),0,IF(OR(N23=\"\",N23=0),0,-ROUND(N23/(1+L23)*L23,2))))","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(OR(N23=0,N23=\"\"),0,N23+P23)),0,IF(OR(N23=0,N23=\"\"),0,N23+P23)))","v":""},{"$nulls":6},{"$f":"+IF(Stammdaten!G30=\"\",\"\",Stammdaten!G30)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G31=\"\",\"\",Stammdaten!G31)","v":""}]
[{"$nulls":3},"Fahrten mit Privat-PKW",{"$nulls":20},{"$f":"+IF(Stammdaten!G32=\"\",\"\",Stammdaten!G32)","v":""}]
[{"$nulls":24},{"$f":"+IF(Stammdaten!G33=\"\",\"\",Stammdaten!G33)","v":""}]
[{"$nulls":3},"Gefahrene km:",{"$nulls":5},{"$f":"+IF(Eingaben!J24=\"\",\"\",Eingaben!J24)","v":""},{"$nulls":3},{"$f":"IF(Eingaben!F6=\"\",\"\",IF(ISERROR(IF(J27=0,\"\",ROUND(J27*0.3,2))),0,IF(J27=0,\"\",ROUND(J27*0.3,2))))","v":""},null,{"$f":"IF(ISERROR(IF(AND($F$13<>\"Deutschland\",$Z$79=0),0,IF(N27=\"\",\"\",0))),0,IF(AND($F$13<>\"Deutschland\",$Z$79=0),0,IF(N27=\"\",\"\",0)))","v":""},null,{"$f":"+IF(N27=\"\",\"\",IF(OR(N27=0,N27=\"\"),0,N27+P27))","v":""},{"$nulls":6},{"$f":"+IF(Stammdaten!G34=\"\",\"\",Stammdaten!G34)","v":""}]
[]
[{"$nulls":3},"Unterbringung",{"$nulls":20},"Frühstück Deutschland",{"$f":"+IF(F13<>\"Deutschland\",\"\",IF(Eingaben!S3=1,Eingaben!T2,Eingaben!T3))","v":1.6},{"$f":"IF(ISERROR(Z29*J31),0,Z29*J31)","v":0}]
[]
[{"$nulls":3},"Anzahl Übernachtungen",{"$nulls":5},{"$f":"+IF(Eingaben!J28=\"\",\"\",Eingaben!J28)","v":""},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF(AA32=1,0,IF(ISERROR(IF(ISNUMBER(J32),$L$6,0)),\"\",IF(ISNUMBER(J32),$L$6,0))))","v":""},{"$nulls":12},"Reiseziel",{"$f":"+Eingaben!T31","v":1},{"$f":"+VLOOKUP(Z31,Pauschalen!E6:F221,2,FALSE)","v":"Deutschland"}]
[{"$nulls":3},{"$f":"+IF(AA32=0,\"Kosten für Übernachtungen\",\"Pauschale Übernachtungskosten\")","v":"Pauschale Übernachtungskosten"},{"$nulls":5},{"$f":"IF(Eingaben!F6=\"\",\"\",IF(AA32=0,Eingaben!J29,\"\"))","v":""},null,{"$f":"IF(ISERROR(IF(AA32=0,\"\",J31*VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,9,FALSE))),0,IF(AA32=0,\"\",J31*VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,9,FALSE)))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(Eingaben!F6=\"\",\"\",IF($AA$32=1,L32,J32))","v":""},null,{"$f":"IF(AND($F$13<>\"Deutschland\",$Z$79=0),0,IF(AND(ISNUMBER(N32),AA32=0),ROUND(-N32/(1+L31)*L31,2),0))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(N32=\"\",\"\",IF(ISERROR(IF(OR(N32=0,N32=\"\"),0,IF(AND(ISNUMBER(N32),P32=\"\"),N32,N32+P32))),0,IF(OR(N32=0,N32=\"\"),0,IF(AND(ISNUMBER(N32),P32=\"\"),N32,N32+P32))))","v":""},{"$nulls":6},"Mit Pauschalen abrechnen",{"$f":"+Eingaben!T32","v":true},{"$f":"+IF(Z32=FALSE(),0,1)","v":1}]
[{"$nulls":24},"Inklus. Frühstück",true,{"$f":"+IF(Z33=FALSE(),0,1)","v":1},{"$f":"+Eingaben!V33","v":0}]
[{"$nulls":3},"Pauschalen für Verpflegungsmehraufwand"]
[{"$nulls":24},"Anzahl Reisetage berechnen",null,{"$f":"+F7-F6+1","v":1}]
[{"$nulls":3},{"$f":"IF(AB49=1,\"Pauschale für Sonderfall\",IF(AA35=1,\"Pauschale für den Reisetag\",\"Pauschale für den Anreisetag\"))","v":"Pauschale für den Reisetag"},{"$nulls":7},{"$f":"IF(Eingaben!F6=\"\",\"\",IF(AB49=1,AD49,AG40))","v":""}]
[{"$nulls":3},"Abzug Frühstück",{"$nulls":7},{"$f":"+IF(Eingaben!H33=\"\",\"  -\",Eingaben!H33*Berechnung!AH52)","v":"  -"},{"$nulls":12},"Erster Tag","Jahr","Monat","Tag","Stunde","Minute"]
[{"$nulls":3},"Abzug Mittagessen",{"$nulls":7},{"$f":"+IF(Eingaben!J33=\"\",\"  -\",Eingaben!J33*Berechnung!AH53)","v":"  -"},{"$nulls":13},{"$f":"+YEAR($F$6)","v":1900},{"$f":"MONTH($F$6)","v":1},{"$f":"DAY($F$6)","v":0},{"$f":"+HOUR(H6)","v":0},{"$f":"+MINUTE(H6)","v":0},null,null,{"$f":"(Eingaben!H7-Eingaben!H6)*24","v":{"v":0,"d":"0.00"}},{"$f":"+IF(AND(AA35=1,AG38<=8),0,+VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,5,FALSE))","v":0}]
[{"$nulls":3},"Abzug Abendessen",{"$nulls":7},{"$f":"+IF(Eingaben!L33=\"\",\"  -\",Eingaben!L33*Berechnung!AH54)","v":"  -"},null,{"$f":"IF(L36=\"\",\"\",IF(L36-SUM(L37:L39)<=0,\"0\",L36-SUM(L37:L39)))","v":""},{"$nulls":3},{"$f":"IF(L36=\"\",\"\",IF(OR(N39=0,N39=\"\"),0,N39+P39))","v":""},{"$nulls":10},{"$f":"+IF(AND(AC38=23,AD38>0),AC38,IF(AND(AC38<24,AD38>0),AC38+1,AC38))","v":0}]
[{"$nulls":24},"Abwesenheit in vollen Stunden",{"$nulls":3},{"$f":"IF(AA35=1,ROUNDDOWN(24*(H7-H6),0),24-AC39)","v":0},null,null,"Pauschale",{"$f":"+AH38","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Pauschale für  Zwischentage",{"$nulls":3},{"$f":"+IF(H42=\"\",\"\",\"Anzahl\")","v":""},null,{"$f":"+IF(H42=\"\",\"\",\"Pauschale\")","v":""},null,{"$f":"+IF(H42=\"\",\"\",\"Summe\")","v":""}]
[{"$nulls":3},"Pauschale für Zwischentage",{"$nulls":3},{"$f":"IF(AA35<3,\"\",IF(AA35=1,\"\",IF($AA$35=1,0,IF(AB49=1,\"\",AB47))))","v":""},null,{"$f":"IF(AA35<3,\"\",AG47)","v":""},null,{"$f":"IF(H42=\"\",\"\",IF(J42>1,ROUND(H42*J42,2),\"\"))","v":""},{"$nulls":12},"Letzter Tag","Jahr","Monat","Tag","Stunde","Minute"]
[{"$nulls":3},"Abzug Frühstück",{"$nulls":3},{"$f":"IF(H42=\"\",\"\",Eingaben!H34)","v":""},null,{"$f":"IF(H42=\"\",\"\",AH52)","v":""},null,{"$f":"IF(H42=\"\",\"\",ROUND(H43*J43,2))","v":""},{"$nulls":13},{"$f":"+YEAR($F$7)","v":1900},{"$f":"MONTH($F$7)","v":1},{"$f":"DAY($F$7)","v":0},{"$f":"+HOUR(H7)","v":0},{"$f":"+MINUTE(H7)","v":0}]
[{"$nulls":3},"Abzug Mittagessen",{"$nulls":3},{"$f":"IF(H42=\"\",\"\",Eingaben!J34)","v":""},null,{"$f":"IF(H42=\"\",\"\",AH53)","v":""},null,{"$f":"IF(H42=\"\",\"\",ROUND(H44*J44,2))","v":""},{"$nulls":16},{"$f":"+IF(AND(AC43=23,AD43>0),23,IF(AD43>0,AC43+1,AC43))","v":0}]
[{"$nulls":3},"Abzug Abendessen",{"$nulls":3},{"$f":"IF(H42=\"\",\"\",+Eingaben!L34)","v":""},null,{"$f":"IF(H42=\"\",\"\",AH54)","v":""},null,{"$f":"IF(H42=\"\",\"\",ROUND(H45*J45,2))","v":""},null,{"$f":"+IF(H42=\"\",\"\",IF(L42-SUM(L43:L45)<=0,\"0\",L42-SUM(L43:L45)))","v":""},{"$nulls":3},{"$f":"+IF(OR(N45=0,N45=\"\"),\"\",N45+P45)","v":""},{"$nulls":6},"Abwesenheit in vollen Stunden",{"$nulls":3},{"$f":"+AC44","v":0},null,null,"Pauschale",{"$f":"VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,5,FALSE)","v":{"v":14,"d":"14.00"}}]
[]
[{"$nulls":3},"Pauschale für  Rückreise-Tag",{"$nulls":7},{"$f":"IF(AA35=1,\"\",IF(AB49=1,\"\",AG45))","v":""},{"$nulls":12},"Anzahl volle Reisetage",null,null,{"$f":"IF(AA35=1,0,AA35-2)","v":0},{"$nulls":3},"Pauschale",{"$f":"VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,6,FALSE)","v":{"v":28,"d":"28.00"}}]
[{"$nulls":3},"Abzug Frühstück",{"$nulls":7},{"$f":"IF(L47=\"\",\"\",IF(Eingaben!H35=\"\",\"  -\",Eingaben!H35*Berechnung!AH52))","v":""}]
[{"$nulls":3},"Abzug Mittagessen",{"$nulls":7},{"$f":"IF(L47=\"\",\"\",IF(Eingaben!J35=\"\",\"  -\",Eingaben!J35*Berechnung!AH53))","v":""},{"$nulls":12},"Sonderregelung bei 2tägiger Reise",null,null,{"$f":"+IF(AND(AB47=0,AC38>16,AC43<8),1,0)","v":0},{"$f":"+AC45+AC40","v":0},{"$f":"+IF(AC49<=8,0,VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,5,FALSE))","v":0}]
[{"$nulls":3},"Abzug Abendessen",{"$nulls":7},{"$f":"IF(L47=\"\",\"\",IF(Eingaben!L35=\"\",\"  -\",Eingaben!L35*Berechnung!AH54))","v":""},null,{"$f":"IF(L47=\"\",\"\",IF(L47-SUM(L48:L50)<=0,\"\",L47-SUM(L48:L50)))","v":""},{"$nulls":3},{"$f":"+IF(OR(N50=0,N50=\"\"),\"\",N50+P50)","v":""},{"$nulls":10},","]
[{"$nulls":24},"Weitere Belege","MwSt",{"$nulls":5},"Mahrzeitengestellung",null,{"$f":"VLOOKUP($Z$31,Pauschalen!$E$6:$M$221,6,FALSE)","v":{"v":28,"d":"28.00"}}]
[{"$nulls":3},"Belege",{"$nulls":20},{"$f":"IF(Stammdaten!T9=\"\",\"\",Stammdaten!T9)","v":"Mietwagen"},{"$f":"IF(Stammdaten!V9=\"\",\"\",Stammdaten!V9)","v":{"v":0.19,"d":"19.00%"}},{"$nulls":5},"Abzug Frühstück",null,{"$f":"+ROUND(AH51*0.2,2)","v":5.6}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T10=\"\",\"\",Stammdaten!T10)","v":"Bewirtungskosten"},{"$f":"IF(Stammdaten!V10=\"\",\"\",Stammdaten!V10)","v":{"v":0.19,"d":"19.00%"}},{"$nulls":5},"Abzug Mittag",null,{"$f":"+AH52*2","v":11.2}]
[{"$nulls":3},"Datum","Belegart",{"$nulls":4},"Wert",null,"USt",{"$nulls":12},{"$f":"IF(Stammdaten!T11=\"\",\"\",Stammdaten!T11)","v":"öffentliche Verkehrsmittel"},{"$f":"IF(Stammdaten!V11=\"\",\"\",Stammdaten!V11)","v":{"v":0.19,"d":"19.00%"}},{"$nulls":5},"Abzug Abend",null,{"$f":"+AH53","v":11.2}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D40=\"\",\"\",Eingaben!D40)","v":""},{"$f":"+IF(Eingaben!E40=\"\",\"\",Eingaben!E40)","v":""},{"$f":"+IF(Eingaben!F40=\"\",\"\",Eingaben!F40)","v":""},{"$f":"+IF(Eingaben!G40=\"\",\"\",Eingaben!G40)","v":""},{"$f":"+IF(Eingaben!H40=\"\",\"\",Eingaben!H40)","v":""},null,{"$f":"+IF(Eingaben!J40=\"\",\"\",Eingaben!J40)","v":""},null,{"$f":"+IF(Eingaben!L40=\"\",\"\",Eingaben!L40)","v":""},null,{"$f":"+IF(J55=\"\",\"\",IF(ISNUMBER(J55),J55,0))","v":""},null,{"$f":"+IF(ISERROR(IF(OR(N55=\"\",N55=0),\"\",-ROUND(N55/(1+L55)*L55,2))),0,IF(OR(N55=\"\",N55=0),\"\",-ROUND(N55/(1+L55)*L55,2)))","v":""},null,{"$f":"IF(ISERROR(IF(ISNUMBER(N55),N55+P55,\"\")),0,IF(ISNUMBER(N55),N55+P55,\"\"))","v":""},{"$nulls":6},{"$f":"IF(Stammdaten!T12=\"\",\"\",Stammdaten!T12)","v":"Geschenke"},{"$f":"IF(Stammdaten!V12=\"\",\"\",Stammdaten!V12)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D41=\"\",\"\",Eingaben!D41)","v":""},{"$f":"+IF(Eingaben!E41=\"\",\"\",Eingaben!E41)","v":""},{"$f":"+IF(Eingaben!F41=\"\",\"\",Eingaben!F41)","v":""},{"$f":"+IF(Eingaben!G41=\"\",\"\",Eingaben!G41)","v":""},{"$f":"+IF(Eingaben!H41=\"\",\"\",Eingaben!H41)","v":""},null,{"$f":"+IF(Eingaben!J41=\"\",\"\",Eingaben!J41)","v":""},null,{"$f":"+IF(Eingaben!L41=\"\",\"\",Eingaben!L41)","v":""},null,{"$f":"+IF(J56=\"\",\"\",IF(ISNUMBER(J56),J56,0))","v":""},null,{"$f":"+IF(ISERROR(IF(OR(N56=\"\",N56=0),\"\",-ROUND(N56/(1+L56)*L56,2))),0,IF(OR(N56=\"\",N56=0),\"\",-ROUND(N56/(1+L56)*L56,2)))","v":""},null,{"$f":"IF(ISERROR(IF(ISNUMBER(N56),N56+P56,\"\")),0,IF(ISNUMBER(N56),N56+P56,\"\"))","v":""},{"$nulls":6},{"$f":"IF(Stammdaten!T13=\"\",\"\",Stammdaten!T13)","v":"Taxi 7%"},{"$f":"IF(Stammdaten!V13=\"\",\"\",Stammdaten!V13)","v":{"v":0.07,"d":"7.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D42=\"\",\"\",Eingaben!D42)","v":""},{"$f":"+IF(Eingaben!E42=\"\",\"\",Eingaben!E42)","v":""},{"$f":"+IF(Eingaben!F42=\"\",\"\",Eingaben!F42)","v":""},{"$f":"+IF(Eingaben!G42=\"\",\"\",Eingaben!G42)","v":""},{"$f":"+IF(Eingaben!H42=\"\",\"\",Eingaben!H42)","v":""},null,{"$f":"+IF(Eingaben!J42=\"\",\"\",Eingaben!J42)","v":""},null,{"$f":"+IF(Eingaben!L42=\"\",\"\",Eingaben!L42)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T14=\"\",\"\",Stammdaten!T14)","v":"Taxi 19%"},{"$f":"IF(Stammdaten!V14=\"\",\"\",Stammdaten!V14)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D43=\"\",\"\",Eingaben!D43)","v":""},{"$f":"+IF(Eingaben!E43=\"\",\"\",Eingaben!E43)","v":""},{"$f":"+IF(Eingaben!F43=\"\",\"\",Eingaben!F43)","v":""},{"$f":"+IF(Eingaben!G43=\"\",\"\",Eingaben!G43)","v":""},{"$f":"+IF(Eingaben!H43=\"\",\"\",Eingaben!H43)","v":""},null,{"$f":"+IF(Eingaben!J43=\"\",\"\",Eingaben!J43)","v":""},null,{"$f":"+IF(Eingaben!L43=\"\",\"\",Eingaben!L43)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T15=\"\",\"\",Stammdaten!T15)","v":"Kfz: Parkgebühren"},{"$f":"IF(Stammdaten!V15=\"\",\"\",Stammdaten!V15)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D44=\"\",\"\",Eingaben!D44)","v":""},{"$f":"+IF(Eingaben!E44=\"\",\"\",Eingaben!E44)","v":""},{"$f":"+IF(Eingaben!F44=\"\",\"\",Eingaben!F44)","v":""},{"$f":"+IF(Eingaben!G44=\"\",\"\",Eingaben!G44)","v":""},{"$f":"+IF(Eingaben!H44=\"\",\"\",Eingaben!H44)","v":""},null,{"$f":"+IF(Eingaben!J44=\"\",\"\",Eingaben!J44)","v":""},null,{"$f":"+IF(Eingaben!L44=\"\",\"\",Eingaben!L44)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T16=\"\",\"\",Stammdaten!T16)","v":"Telefon / Handy"},{"$f":"IF(Stammdaten!V16=\"\",\"\",Stammdaten!V16)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D45=\"\",\"\",Eingaben!D45)","v":""},{"$f":"+IF(Eingaben!E45=\"\",\"\",Eingaben!E45)","v":""},{"$f":"+IF(Eingaben!F45=\"\",\"\",Eingaben!F45)","v":""},{"$f":"+IF(Eingaben!G45=\"\",\"\",Eingaben!G45)","v":""},{"$f":"+IF(Eingaben!H45=\"\",\"\",Eingaben!H45)","v":""},null,{"$f":"+IF(Eingaben!J45=\"\",\"\",Eingaben!J45)","v":""},null,{"$f":"+IF(Eingaben!L45=\"\",\"\",Eingaben!L45)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T17=\"\",\"\",Stammdaten!T17)","v":"Kfz: sonstige Kosten"},{"$f":"IF(Stammdaten!V17=\"\",\"\",Stammdaten!V17)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D46=\"\",\"\",Eingaben!D46)","v":""},{"$f":"+IF(Eingaben!E46=\"\",\"\",Eingaben!E46)","v":""},{"$f":"+IF(Eingaben!F46=\"\",\"\",Eingaben!F46)","v":""},{"$f":"+IF(Eingaben!G46=\"\",\"\",Eingaben!G46)","v":""},{"$f":"+IF(Eingaben!H46=\"\",\"\",Eingaben!H46)","v":""},null,{"$f":"+IF(Eingaben!J46=\"\",\"\",Eingaben!J46)","v":""},null,{"$f":"+IF(Eingaben!L46=\"\",\"\",Eingaben!L46)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T18=\"\",\"\",Stammdaten!T18)","v":"Kfz: Treibstoff"},{"$f":"IF(Stammdaten!V18=\"\",\"\",Stammdaten!V18)","v":{"v":0.19,"d":"19.00%"}}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D47=\"\",\"\",Eingaben!D47)","v":""},{"$f":"+IF(Eingaben!E47=\"\",\"\",Eingaben!E47)","v":""},{"$f":"+IF(Eingaben!F47=\"\",\"\",Eingaben!F47)","v":""},{"$f":"+IF(Eingaben!G47=\"\",\"\",Eingaben!G47)","v":""},{"$f":"+IF(Eingaben!H47=\"\",\"\",Eingaben!H47)","v":""},null,{"$f":"+IF(Eingaben!J47=\"\",\"\",Eingaben!J47)","v":""},null,{"$f":"+IF(Eingaben!L47=\"\",\"\",Eingaben!L47)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T19=\"\",\"\",Stammdaten!T19)","v":""},{"$f":"IF(Stammdaten!V19=\"\",\"\",Stammdaten!V19)","v":""}]
[{"$nulls":3},{"$f":"+IF(Eingaben!D48=\"\",\"\",Eingaben!D48)","v":""},{"$f":"+IF(Eingaben!E48=\"\",\"\",Eingaben!E48)","v":""},{"$f":"+IF(Eingaben!F48=\"\",\"\",Eingaben!F48)","v":""},{"$f":"+IF(Eingaben!G48=\"\",\"\",Eingaben!G48)","v":""},{"$f":"+IF(Eingaben!H48=\"\",\"\",Eingaben!H48)","v":""},null,{"$f":"+IF(Eingaben!J48=\"\",\"\",Eingaben!J48)","v":""},null,{"$f":"+IF(Eingaben!L48=\"\",\"\",Eingaben!L48)","v":""},null,"",null,"",null,"",{"$nulls":6},{"$f":"IF(Stammdaten!T20=\"\",\"\",Stammdaten!T20)","v":""},{"$f":"IF(Stammdaten!V20=\"\",\"\",Stammdaten!V20)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T21=\"\",\"\",Stammdaten!T21)","v":""},{"$f":"IF(Stammdaten!V21=\"\",\"\",Stammdaten!V21)","v":""}]
[{"$nulls":3},"Abrechnung erstellt:",{"$nulls":7},"Summen:",null,{"$f":"SUM(N20:N64)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(P20:P64)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(R20:R64)","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF(Stammdaten!T22=\"\",\"\",Stammdaten!T22)","v":""},{"$f":"IF(Stammdaten!V22=\"\",\"\",Stammdaten!V22)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T23=\"\",\"\",Stammdaten!T23)","v":""},{"$f":"IF(Stammdaten!V23=\"\",\"\",Stammdaten!V23)","v":""}]
[{"$nulls":11},"./. Vorschüsse",null,{"$f":"+Eingaben!L50","v":{"v":0,"d":"0.00"}},null,"Buchungsvermerk:",{"$nulls":8},{"$f":"IF(Stammdaten!T24=\"\",\"\",Stammdaten!T24)","v":""},{"$f":"IF(Stammdaten!V24=\"\",\"\",Stammdaten!V24)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T25=\"\",\"\",Stammdaten!T25)","v":""},{"$f":"IF(Stammdaten!V25=\"\",\"\",Stammdaten!V25)","v":""}]
[{"$nulls":11},{"$f":"+IF(N69<0,\"Überzahlung\",\"Restzahlung\")","v":"Restzahlung"},null,{"$f":"+N65-N67","v":{"v":0,"d":"0.00"}},{"$nulls":10},{"$f":"IF(Stammdaten!T26=\"\",\"\",Stammdaten!T26)","v":""},{"$f":"IF(Stammdaten!V26=\"\",\"\",Stammdaten!V26)","v":""}]
[{"$nulls":3},"Datum",null,"Unterschrift Reisender",{"$nulls":18},{"$f":"IF(Stammdaten!T27=\"\",\"\",Stammdaten!T27)","v":""},{"$f":"IF(Stammdaten!V27=\"\",\"\",Stammdaten!V27)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T28=\"\",\"\",Stammdaten!T28)","v":""},{"$f":"IF(Stammdaten!V28=\"\",\"\",Stammdaten!V28)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T29=\"\",\"\",Stammdaten!T29)","v":""},{"$f":"IF(Stammdaten!V29=\"\",\"\",Stammdaten!V29)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T30=\"\",\"\",Stammdaten!T30)","v":""},{"$f":"IF(Stammdaten!V30=\"\",\"\",Stammdaten!V30)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T31=\"\",\"\",Stammdaten!T31)","v":""},{"$f":"IF(Stammdaten!V31=\"\",\"\",Stammdaten!V31)","v":""}]
[{"$nulls":3},"Datum",null,"Unterschrift Vorgesetzter",{"$nulls":18},{"$f":"IF(Stammdaten!T32=\"\",\"\",Stammdaten!T32)","v":""},{"$f":"IF(Stammdaten!V32=\"\",\"\",Stammdaten!V32)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T33=\"\",\"\",Stammdaten!T33)","v":""},{"$f":"IF(Stammdaten!V33=\"\",\"\",Stammdaten!V33)","v":""}]
[{"$nulls":24},{"$f":"IF(Stammdaten!T34=\"\",\"\",Stammdaten!T34)","v":""},{"$f":"IF(Stammdaten!V34=\"\",\"\",Stammdaten!V34)","v":""}]
[null,"<< Startseite",null,null,"Hilfe?","Beispiel",null,"Stammdaten",{"$nulls":3},"Pauschalen"]
[{"$nulls":24},"USt bei Auslandsreisen:",0]
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Beispiel","index":3,"n_rows":79,"n_cols":22,"rows_kept":79,"merged":[[52,1,52,3],[52,6,52,8]]}
[{"$nulls":13},"Beispiel"]
[{"$nulls":19},1.57]
[{"$nulls":18},1,4.8]
[]
[{"$nulls":18},"Mitarbeiter",null,{"$f":"IF(ISERROR(VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE)),\"Fehler\",VLOOKUP($F$4,Stammdaten!$C$13:$O$34,1,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,7,FALSE)&\", \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,8,FALSE)&\" \"&VLOOKUP($F$4,Stammdaten!$C$13:$O$34,9,FALSE))","v":"Fehler"}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G13=\"\",\"\",Stammdaten!G13)","v":"Mustermann, Max"}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G14=\"\",\"\",Stammdaten!G14)","v":"Müller, Hein-Otto"}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G15=\"\",\"\",Stammdaten!G15)","v":"Meier, Otti"}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G16=\"\",\"\",Stammdaten!G16)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G17=\"\",\"\",Stammdaten!G17)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G18=\"\",\"\",Stammdaten!G18)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G19=\"\",\"\",Stammdaten!G19)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G20=\"\",\"\",Stammdaten!G20)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G21=\"\",\"\",Stammdaten!G21)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G22=\"\",\"\",Stammdaten!G22)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G23=\"\",\"\",Stammdaten!G23)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G24=\"\",\"\",Stammdaten!G24)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G25=\"\",\"\",Stammdaten!G25)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G26=\"\",\"\",Stammdaten!G26)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G27=\"\",\"\",Stammdaten!G27)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G28=\"\",\"\",Stammdaten!G28)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G29=\"\",\"\",Stammdaten!G29)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G30=\"\",\"\",Stammdaten!G30)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G31=\"\",\"\",Stammdaten!G31)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G33=\"\",\"\",Stammdaten!G33)","v":""}]
[{"$nulls":18},{"$f":"+IF(Stammdaten!G34=\"\",\"\",Stammdaten!G34)","v":""}]
[]
[]
[{"$nulls":18},"Pauschale Deutschland",{"$f":"+IF(S3=1,T2,T3)","v":1.57},{"$f":"+IF(ISERROR(T29*J28),0,T29*J28)","v":0}]
[]
[{"$nulls":18},"Reiseziel",1,{"$f":"+VLOOKUP(T31,Pauschalen!E6:F221,2,FALSE)","v":"Deutschland"}]
[{"$nulls":18},"Mit Pauschalen abrechnen",true,{"$f":"+IF(T32=FALSE(),0,1)","v":1}]
[{"$nulls":18},"Inklus. Frühstück",true,{"$f":"+IF(T33=FALSE(),0,1)","v":1},{"$f":"+IF(U32=0,1,IF(U33=0,1,0))","v":0}]
[]
[{"$nulls":18},"Anzahl Reisetage berechnen",null,{"$f":"+F7-F6+1","v":1}]
{"$rows_empty":17}
[null,"<< Startseite",null,null,"Hilfe?","Beispiel","Stammdaten",{"$nulls":11},"Weitere Belege"]
[{"$nulls":18},{"$f":"IF(Stammdaten!T9=\"\",\"\",Stammdaten!T9)","v":"Mietwagen"}]
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG",{"$nulls":16},{"$f":"IF(Stammdaten!T10=\"\",\"\",Stammdaten!T10)","v":"Bewirtungskosten"}]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und",{"$nulls":16},{"$f":"IF(Stammdaten!T11=\"\",\"\",Stammdaten!T11)","v":"öffentliche Verkehrsmittel"}]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet.",{"$nulls":16},{"$f":"IF(Stammdaten!T12=\"\",\"\",Stammdaten!T12)","v":"Geschenke"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T13=\"\",\"\",Stammdaten!T13)","v":"Taxi 7%"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T14=\"\",\"\",Stammdaten!T14)","v":"Taxi 19%"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T15=\"\",\"\",Stammdaten!T15)","v":"Kfz: Parkgebühren"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T16=\"\",\"\",Stammdaten!T16)","v":"Telefon / Handy"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T17=\"\",\"\",Stammdaten!T17)","v":"Kfz: sonstige Kosten"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T18=\"\",\"\",Stammdaten!T18)","v":"Kfz: Treibstoff"}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T19=\"\",\"\",Stammdaten!T19)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T20=\"\",\"\",Stammdaten!T20)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T21=\"\",\"\",Stammdaten!T21)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T22=\"\",\"\",Stammdaten!T22)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T23=\"\",\"\",Stammdaten!T23)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T24=\"\",\"\",Stammdaten!T24)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T25=\"\",\"\",Stammdaten!T25)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T26=\"\",\"\",Stammdaten!T26)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T27=\"\",\"\",Stammdaten!T27)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T28=\"\",\"\",Stammdaten!T28)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T29=\"\",\"\",Stammdaten!T29)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T30=\"\",\"\",Stammdaten!T30)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T31=\"\",\"\",Stammdaten!T31)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T32=\"\",\"\",Stammdaten!T32)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T33=\"\",\"\",Stammdaten!T33)","v":""}]
[{"$nulls":18},{"$f":"IF(Stammdaten!T34=\"\",\"\",Stammdaten!T34)","v":""}]

{"sheet":"Hilfe","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[2,1,2,5],[14,1,14,3]]}
[]
[{"$nulls":5},"Hilfe"]
[null,"Reisekostenrechner 2026 - Hilfe"]
[]
[{"$nulls":3},"Allgemeine Hinweise"]
[]
[]
[]
[{"$nulls":3},"Hinweise zum Reisekostenrechner"]
[]
[]
[]
[]
[]
[null,"<< Startseite"]
[]
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Stammdaten","index":5,"n_rows":41,"n_cols":25,"rows_kept":41,"merged":[[36,8,36,9]]}
[]
[{"$nulls":15},"Stammdaten"]
[null,"Reisekosten 2026 - Stammdaten",{"$nulls":15},"Reisekosten - Stammdaten",{"$nulls":6},2]
[]
[]
[{"$nulls":3},"Abzurechnende Mitarbeiter",{"$nulls":14},"Belegarten"]
[]
[{"$nulls":3},"Auswahl des Mitarbeiters druch",{"$nulls":14},"Nr.","Bezeichnung - Deutsch -","Bezeichnung - Englisch -","MwSt"]
[{"$nulls":18},1,"Mietwagen","Rental Car",{"v":0.19,"d":"19.00%"}]
[{"$nulls":18},{"$f":"+IF(T10=\"\",\"\",MAX($S$9:S9)+1)","v":2},"Bewirtungskosten","Entertainment",{"v":0.19,"d":"19.00%"}]
[{"$nulls":18},{"$f":"+IF(T11=\"\",\"\",MAX($S$9:S10)+1)","v":3},"öffentliche Verkehrsmittel","Public Transportation",{"v":0.19,"d":"19.00%"}]
[null,null,"Aus-\nwahl","Pers.-\nNr","Name","Vorname","Listeneintrag","KST","Straße","PLZ",null,"Bank","BLZ","Konto-Nr.","Sonstiges",{"$nulls":3},{"$f":"+IF(T12=\"\",\"\",MAX($S$9:S11)+1)","v":4},"Geschenke","Gifts",{"v":0.19,"d":"19.00%"}]
[null,null,{"$f":"+IF(G13=\"\",\"\",G13)","v":"Mustermann, Max"},1,"Mustermann","Max",{"$f":"IF(ISERROR(IF(OR(E13=\"\",F13=\"\"),\"\",IF($Y$3=2,E13&\", \"&F13,F13&\", \"&E13))),\"\",IF(OR(E13=\"\",F13=\"\"),\"\",IF($Y$3=2,E13&\", \"&F13,F13&\", \"&E13)))","v":"Mustermann, Max"},4711,"Musterstraße 11",47111,"Musterstadt","Musterbank","0047114711","124578963",{"$nulls":4},{"$f":"+IF(T13=\"\",\"\",MAX($S$9:S12)+1)","v":5},"Taxi 7%","Taxi",{"v":0.07,"d":"7.00%"}]
[null,null,"Müller, Hein-Otto",2,"Müller","Hein-Otto",{"$f":"IF(ISERROR(IF(OR(E14=\"\",F14=\"\"),\"\",IF($Y$3=2,E14&\", \"&F14,F14&\", \"&E14))),\"\",IF(OR(E14=\"\",F14=\"\"),\"\",IF($Y$3=2,E14&\", \"&F14,F14&\", \"&E14)))","v":"Müller, Hein-Otto"},4712,"Berliner Platz 11",47111,"Musterstadt","Musterbank","123465678","1254896",{"$nulls":4},{"$f":"+IF(T14=\"\",\"\",MAX($S$9:S13)+1)","v":6},"Taxi 19%","Taxi",{"v":0.19,"d":"19.00%"}]
[null,null,"Meier, Otti",3,"Meier","Otti","Meier, Otti",4713,"Steinstraße 11",47111,"Musterstadt","Musterbank","987654","0006659985",{"$nulls":4},{"$f":"+IF(T15=\"\",\"\",MAX($S$9:S14)+1)","v":7},"Kfz: Parkgebühren","Automobile: Parking Fee",{"v":0.19,"d":"19.00%"}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T16=\"\",\"\",MAX($S$9:S15)+1)","v":8},"Telefon / Handy","Telephone / Mobile Phone",{"v":0.19,"d":"19.00%"}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T17=\"\",\"\",MAX($S$9:S16)+1)","v":9},"Kfz: sonstige Kosten","Automobile: Other Expenses",{"v":0.19,"d":"19.00%"}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T18=\"\",\"\",MAX($S$9:S17)+1)","v":10},"Kfz: Treibstoff","Automobile: Petrol",{"v":0.19,"d":"19.00%"}]
[null,null,"",{"$nulls":3},""]
[null,null,"",{"$nulls":3},""]
[null,null,"",{"$nulls":3},""]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T22=\"\",\"\",MAX($S$9:S21)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T23=\"\",\"\",MAX($S$9:S22)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T24=\"\",\"\",MAX($S$9:S23)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T25=\"\",\"\",MAX($S$9:S24)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T26=\"\",\"\",MAX($S$9:S25)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T27=\"\",\"\",MAX($S$9:S26)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T28=\"\",\"\",MAX($S$9:S27)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T29=\"\",\"\",MAX($S$9:S28)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T30=\"\",\"\",MAX($S$9:S29)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T31=\"\",\"\",MAX($S$9:S30)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T32=\"\",\"\",MAX($S$9:S31)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T33=\"\",\"\",MAX($S$9:S32)+1)","v":""}]
[null,null,"",{"$nulls":3},"",{"$nulls":11},{"$f":"+IF(T34=\"\",\"\",MAX($S$9:S33)+1)","v":""}]
[]
[]
[{"$nulls":8},"<< Startseite",null,"Hilfe?"]
[]
[null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Pauschalen","index":6,"n_rows":228,"n_cols":15,"rows_kept":228,"merged":[[3,4,3,12],[223,5,223,6]]}
[]
[null,null,"Pauschalen - Komplette Liste",{"$nulls":10},"Pauschalen"]
[]
[{"$nulls":4},"Pauschalen 2026"]
[{"$nulls":4},"Nr","Land","Land Englisch","8 - 14 Std.","Mehr als 8 Stunden","ganzer Tag","Abzug bei Frühstück","Leer","ÜP",null,"Nr"]
[{"$nulls":4},1,"Deutschland",null,null,{"v":14,"d":"14.00"},{"v":28,"d":"28.00"},{"v":-6,"d":"-6.00"},{"v":0,"d":"0.00"},{"v":20,"d":"20.00"},null,{"$f":"+E6","v":1}]
[{"$nulls":4},2,"Ägypten",null,null,{"v":33,"d":"33.00"},{"v":50,"d":"50.00"},{"v":-6,"d":"-6.00"},{"v":0,"d":"0.00"},{"v":112,"d":"112.00"}]
[{"$nulls":4},3,"Äthiopien",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":159,"d":"159.00"},null,{"$f":"+E8","v":3}]
[{"$nulls":4},4,"Äquatorialguinea",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":166,"d":"166.00"},null,4]
[{"$nulls":4},5,"Albanien",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":116,"d":"116.00"}]
[{"$nulls":4},6,"Algerien",null,null,{"v":32,"d":"32.00"},{"v":47,"d":"47.00"},null,null,{"v":120,"d":"120.00"}]
[{"$nulls":4},7,"Andorra",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":135,"d":"135.00"},null,7]
[{"$nulls":4},8,"Angola",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":368,"d":"368.00"}]
[{"$nulls":4},9,"Argentinien",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":119,"d":"119.00"},null,9]
[{"$nulls":4},10,"Armenien",null,null,{"v":20,"d":"20.00"},{"v":29,"d":"29.00"},null,null,{"v":107,"d":"107.00"},null,10]
[{"$nulls":4},11,"Aserbaidschan",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":88,"d":"88.00"},null,11]
[{"$nulls":4},12,"Australien – Canberra",null,null,{"v":49,"d":"49.00"},{"v":74,"d":"74.00"},null,null,{"v":186,"d":"186.00"},null,12]
[{"$nulls":4},13,"Australien –  Sydney",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":173,"d":"173.00"},null,13]
[{"$nulls":4},14,"Australien – im Übrigen",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":173,"d":"173.00"},null,14]
[{"$nulls":4},15,"Bahrain",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":153,"d":"153.00"},null,15]
[{"$nulls":4},16,"Bangladesch",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":189,"d":"189.00"},null,16]
[{"$nulls":4},17,"Barbados",null,null,{"v":36,"d":"36.00"},{"v":54,"d":"54.00"},null,null,{"v":206,"d":"206.00"},null,17]
[{"$nulls":4},18,"Belgien",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":141,"d":"141.00"},null,18]
[{"$nulls":4},19,"Benin",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":168,"d":"168.00"},null,19]
[{"$nulls":4},20,"Bhutan",null,null,{"v":18,"d":"18.00"},{"v":27,"d":"27.00"},null,null,{"v":176,"d":"176.00"},null,20]
[{"$nulls":4},21,"Bolivien",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":108,"d":"108.00"},null,21]
[{"$nulls":4},22,"Bosnien und Herzegowina",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":109,"d":"109.00"},null,22]
[{"$nulls":4},23,"Botsuana",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":105,"d":"105.00"},null,23]
[{"$nulls":4},24,"Brasilien –  Brasilia",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":88,"d":"88.00"},null,24]
[{"$nulls":4},25,"Brasilien – Rio de Janeiro",null,null,{"v":46,"d":"46.00"},{"v":69,"d":"69.00"},null,null,{"v":140,"d":"140.00"},null,25]
[{"$nulls":4},26,"Brasilien – Sao Paulo",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":151,"d":"151.00"},null,26]
[{"$nulls":4},27,"Brasilien – im Übrigen",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":88,"d":"88.00"},null,27]
[{"$nulls":4},28,"Brunei",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":110,"d":"110.00"},null,28]
[{"$nulls":4},29,"Bulgarien",null,null,{"v":25,"d":"25.00"},{"v":38,"d":"38.00"},null,null,{"v":109,"d":"109.00"},null,29]
[{"$nulls":4},30,"Burkina Faso",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":230,"d":"230.00"},null,30]
[{"$nulls":4},31,"Burundi",null,null,{"v":39,"d":"39.00"},{"v":58,"d":"58.00"},null,null,{"v":102,"d":"102.00"},null,31]
[{"$nulls":4},32,"Chile",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":154,"d":"154.00"},null,32]
[{"$nulls":4},33,"China – Hongkong",null,null,{"v":56,"d":"56.00"},{"v":83,"d":"83.00"},null,null,{"v":209,"d":"209.00"},null,33]
[{"$nulls":4},34,"China – Peking",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":184,"d":"184.00"},null,34]
[{"$nulls":4},35,"China – Shanghai",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":142,"d":"142.00"},null,35]
[{"$nulls":4},36,"China – im Übrigen",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":142,"d":"142.00"},null,36]
[{"$nulls":4},37,"Costa Rica",null,null,{"v":40,"d":"40.00"},{"v":60,"d":"60.00"},null,null,{"v":127,"d":"127.00"},null,37]
[{"$nulls":4},38,"Côte d’Ivoire",null,null,{"v":40,"d":"40.00"},{"v":60,"d":"60.00"},null,null,{"v":171,"d":"171.00"},null,38]
[{"$nulls":4},39,"Dänemark",null,null,{"v":50,"d":"50.00"},{"v":75,"d":"75.00"},null,null,{"v":183,"d":"183.00"},null,39]
[{"$nulls":4},40,"Dominikanische Republik",null,null,{"v":33,"d":"33.00"},{"v":50,"d":"50.00"},null,null,{"v":167,"d":"167.00"},null,40]
[{"$nulls":4},41,"Dschibuti",null,null,{"v":52,"d":"52.00"},{"v":77,"d":"77.00"},null,null,{"v":255,"d":"255.00"},null,41]
[{"$nulls":4},42,"Ecuador",null,null,{"v":18,"d":"18.00"},{"v":27,"d":"27.00"},null,null,{"v":103,"d":"103.00"},null,42]
[{"$nulls":4},43,"El Salvador",null,null,{"v":44,"d":"44.00"},{"v":65,"d":"65.00"},null,null,{"v":161,"d":"161.00"},null,43]
[{"$nulls":4},44,"Eritrea",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":78,"d":"78.00"},null,44]
[{"$nulls":4},45,"Estland",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":125,"d":"125.00"},null,45]
[{"$nulls":4},46,"Fidschi",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":183,"d":"183.00"}]
[{"$nulls":4},47,"Finnland",null,null,{"v":36,"d":"36.00"},{"v":54,"d":"54.00"},null,null,{"v":171,"d":"171.00"},null,47]
[{"$nulls":4},48,"Frankreich – Paris, Dep. 77, 78, 91 bis 95",null,null,{"v":39,"d":"39.00"},{"v":58,"d":"58.00"},null,null,{"v":159,"d":"159.00"},null,48]
[{"$nulls":4},49,"Frankreich – im Übrigen",null,null,{"v":36,"d":"36.00"},{"v":53,"d":"53.00"},null,null,{"v":105,"d":"105.00"},null,49]
[{"$nulls":4},50,"Gabun",null,null,{"v":43,"d":"43.00"},{"v":64,"d":"64.00"},null,null,{"v":263,"d":"263.00"},null,50]
[{"$nulls":4},51,"Gambia",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":161,"d":"161.00"},null,51]
[{"$nulls":4},52,"Georgien",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":87,"d":"87.00"},null,52]
[{"$nulls":4},53,"Ghana",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":203,"d":"203.00"},null,53]
[{"$nulls":4},54,"Griechenland – Athen",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":139,"d":"139.00"},null,54]
[{"$nulls":4},55,"Griechenland – im Übrigen",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":150,"d":"150.00"},null,55]
[{"$nulls":4},56,"Guatemala",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":124,"d":"124.00"}]
[{"$nulls":4},57,"Guinea",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":140,"d":"140.00"}]
[{"$nulls":4},58,"Guinea-Bissau",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":113,"d":"113.00"}]
[{"$nulls":4},59,"Honduras",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":198,"d":"198.00"}]
[{"$nulls":4},60,"Indien – Bangalore",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":155,"d":"155.00"},null,60]
[{"$nulls":4},61,"Indien – Chennai",null,null,{"v":15,"d":"15.00"},{"v":22,"d":"22.00"},null,null,{"v":80,"d":"80.00"},null,61]
[{"$nulls":4},62,"Indien – Kalkutta",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":167,"d":"167.00"}]
[{"$nulls":4},63,"Indien – Mumbai",null,null,{"v":36,"d":"36.00"},{"v":53,"d":"53.00"},null,null,{"v":218,"d":"218.00"},null,63]
[{"$nulls":4},64,"Indien – Neu Delhi",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":211,"d":"211.00"},null,64]
[{"$nulls":4},65,"Indien – im Übrigen",null,null,{"v":15,"d":"15.00"},{"v":22,"d":"22.00"},null,null,{"v":80,"d":"80.00"},null,65]
[{"$nulls":4},66,"Indonesien",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":179,"d":"179.00"},null,66]
[{"$nulls":4},67,"Iran",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":196,"d":"196.00"},null,67]
[{"$nulls":4},68,"Irland",null,null,{"v":43,"d":"43.00"},{"v":64,"d":"64.00"},null,null,{"v":164,"d":"164.00"},null,68]
[{"$nulls":4},69,"Island",null,null,{"v":41,"d":"41.00"},{"v":62,"d":"62.00"},null,null,{"v":187,"d":"187.00"},null,69]
[{"$nulls":4},70,"Israel",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":268,"d":"268.00"},null,70]
[{"$nulls":4},71,"Italien – Mailand",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":191,"d":"191.00"},null,71]
[{"$nulls":4},72,"Italien – Rom",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":150,"d":"150.00"},null,72]
[{"$nulls":4},73,"Italien – im Übrigen",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":150,"d":"150.00"},null,73]
[{"$nulls":4},74,"Jamaika",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":171,"d":"171.00"},null,{"$f":"+E79","v":74}]
[{"$nulls":4},75,"Japan – Tokio",null,null,{"v":33,"d":"33.00"},{"v":50,"d":"50.00"},null,null,{"v":285,"d":"285.00"},null,75]
[{"$nulls":4},76,"Japan – Osaka",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":141,"d":"141.00"},null,76]
[{"$nulls":4},77,"Japan – im Übrigen",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":141,"d":"141.00"},null,77]
[{"$nulls":4},78,"Jordanien",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":134,"d":"134.00"},null,78]
[{"$nulls":4},79,"Kambodscha",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":108,"d":"108.00"},null,79]
[{"$nulls":4},80,"Kamerun",null,null,{"v":37,"d":"37.00"},{"v":56,"d":"56.00"},null,null,{"v":275,"d":"275.00"},null,80]
[{"$nulls":4},81,"Kanada – Ottawa",null,null,{"v":41,"d":"41.00"},{"v":62,"d":"62.00"},null,null,{"v":214,"d":"214.00"},null,81]
[{"$nulls":4},82,"Kanada – Toronto",null,null,{"v":36,"d":"36.00"},{"v":54,"d":"54.00"},null,null,{"v":392,"d":"392.00"},null,82]
[{"$nulls":4},83,"Kanada – Vancouver",null,null,{"v":42,"d":"42.00"},{"v":63,"d":"63.00"},null,null,{"v":304,"d":"304.00"},null,83]
[{"$nulls":4},84,"Kanada – im Übrigen",null,null,{"v":36,"d":"36.00"},{"v":54,"d":"54.00"},null,null,{"v":214,"d":"214.00"},null,84]
[{"$nulls":4},85,"Kap Verde",null,null,{"v":25,"d":"25.00"},{"v":38,"d":"38.00"},null,null,{"v":90,"d":"90.00"},null,85]
[{"$nulls":4},86,"Kasachstan",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":108,"d":"108.00"},null,86]
[{"$nulls":4},87,"Katar",null,null,{"v":54,"d":"54.00"},{"v":81,"d":"81.00"},null,null,{"v":128,"d":"128.00"},null,87]
[{"$nulls":4},88,"Kenia",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":217,"d":"217.00"},null,88]
[{"$nulls":4},89,"Kirgisistan",null,null,{"v":24,"d":"24.00"},{"v":35,"d":"35.00"},null,null,{"v":80,"d":"80.00"},null,89]
[{"$nulls":4},90,"Kolumbien",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":123,"d":"123.00"},null,90]
[{"$nulls":4},91,"Kongo, Republik",null,null,{"v":36,"d":"36.00"},{"v":53,"d":"53.00"},null,null,{"v":215,"d":"215.00"},null,91]
[{"$nulls":4},92,"Kongo, Demokratische Republik",null,null,{"v":44,"d":"44.00"},{"v":65,"d":"65.00"},null,null,{"v":337,"d":"337.00"},null,92]
[{"$nulls":4},93,"Korea, Republik",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":130,"d":"130.00"},null,93]
[{"$nulls":4},94,"Kosovo",null,null,{"v":16,"d":"16.00"},{"v":24,"d":"24.00"},null,null,{"v":71,"d":"71.00"},null,94]
[{"$nulls":4},95,"Kroatien",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":191,"d":"191.00"}]
[{"$nulls":4},96,"Kuba",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":170,"d":"170.00"},null,96]
[{"$nulls":4},97,"Kuwait",null,null,{"v":42,"d":"42.00"},{"v":63,"d":"63.00"},null,null,{"v":224,"d":"224.00"},null,97]
[{"$nulls":4},98,"Laos",null,null,{"v":24,"d":"24.00"},{"v":35,"d":"35.00"},null,null,{"v":71,"d":"71.00"},null,98]
[{"$nulls":4},99,"Lesotho",null,null,{"v":19,"d":"19.00"},{"v":28,"d":"28.00"},null,null,{"v":104,"d":"104.00"},null,99]
[{"$nulls":4},100,"Lettland",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":119,"d":"119.00"},null,100]
[{"$nulls":4},101,"Libanon",null,null,{"v":46,"d":"46.00"},{"v":69,"d":"69.00"},null,null,{"v":146,"d":"146.00"},null,101]
[{"$nulls":4},102,"Liberia",null,null,{"v":44,"d":"44.00"},{"v":65,"d":"65.00"},null,null,{"v":173,"d":"173.00"},null,102]
[{"$nulls":4},103,"Liechtenstein",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":234,"d":"234.00"},null,103]
[{"$nulls":4},104,"Litauen",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":124,"d":"124.00"},null,104]
[{"$nulls":4},105,"Luxemburg",null,null,{"v":42,"d":"42.00"},{"v":63,"d":"63.00"},null,null,{"v":139,"d":"139.00"}]
[{"$nulls":4},106,"Madagaskar",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":116,"d":"116.00"},null,106]
[{"$nulls":4},107,"Malawi",null,null,{"v":28,"d":"28.00"},{"v":41,"d":"41.00"},null,null,{"v":109,"d":"109.00"},null,107]
[{"$nulls":4},108,"Malaysia",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":86,"d":"86.00"},null,108]
[{"$nulls":4},109,"Malediven",null,null,{"v":47,"d":"47.00"},{"v":70,"d":"70.00"},null,null,{"v":200,"d":"200.00"}]
[{"$nulls":4},110,"Mali",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":141,"d":"141.00"},null,110]
[{"$nulls":4},111,"Malta",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":191,"d":"191.00"},null,111]
[{"$nulls":4},112,"Marokko",null,null,{"v":28,"d":"28.00"},{"v":41,"d":"41.00"},null,null,{"v":87,"d":"87.00"},null,112]
[{"$nulls":4},113,"Marshall Inseln",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":112,"d":"112.00"},null,113]
[{"$nulls":4},114,"Mauretanien",null,null,{"v":24,"d":"24.00"},{"v":35,"d":"35.00"},null,null,{"v":86,"d":"86.00"},null,114]
[{"$nulls":4},115,"Mauritius",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":172,"d":"172.00"},null,115]
[{"$nulls":4},116,"Mexiko",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":337,"d":"337.00"},null,116]
[{"$nulls":4},117,"Moldau, Republik",null,null,{"v":17,"d":"17.00"},{"v":26,"d":"26.00"},null,null,{"v":73,"d":"73.00"},null,117]
[{"$nulls":4},118,"Monaco",null,null,{"v":35,"d":"35.00"},{"v":52,"d":"52.00"},null,null,{"v":187,"d":"187.00"},null,118]
[{"$nulls":4},119,"Mongolei",null,null,{"v":16,"d":"16.00"},{"v":23,"d":"23.00"},null,null,{"v":92,"d":"92.00"},null,119]
[{"$nulls":4},120,"Montenegro",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":85,"d":"85.00"},null,120]
[{"$nulls":4},121,"Mosambik",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":208,"d":"208.00"},null,121]
[{"$nulls":4},122,"Myanmar",null,null,{"v":16,"d":"16.00"},{"v":23,"d":"23.00"},null,null,{"v":103,"d":"103.00"},null,122]
[{"$nulls":4},123,"Namibia",null,null,{"v":19,"d":"19.00"},{"v":28,"d":"28.00"},null,null,{"v":146,"d":"146.00"},null,123]
[{"$nulls":4},124,"Nepal",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":125,"d":"125.00"}]
[{"$nulls":4},125,"Neuseeland",null,null,{"v":39,"d":"39.00"},{"v":58,"d":"58.00"},null,null,{"v":148,"d":"148.00"},null,125]
[{"$nulls":4},126,"Nicaragua",null,null,{"v":31,"d":"31.00"},{"v":46,"d":"46.00"},null,null,{"v":105,"d":"105.00"},null,126]
[{"$nulls":4},127,"Niederlande",null,null,{"v":39,"d":"39.00"},{"v":58,"d":"58.00"},null,null,{"v":167,"d":"167.00"},null,127]
[{"$nulls":4},128,"Niger",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":131,"d":"131.00"},null,128]
[{"$nulls":4},129,"Nigeria",null,null,{"v":35,"d":"35.00"},{"v":52,"d":"52.00"},null,null,{"v":202,"d":"202.00"}]
[{"$nulls":4},130,"Nordmazedonien",null,null,{"v":18,"d":"18.00"},{"v":27,"d":"27.00"},null,null,{"v":89,"d":"89.00"},null,130]
[{"$nulls":4},131,"Norwegen",null,null,{"v":50,"d":"50.00"},{"v":75,"d":"75.00"},null,null,{"v":139,"d":"139.00"},null,131]
[{"$nulls":4},132,"Österreich",null,null,{"v":33,"d":"33.00"},{"v":50,"d":"50.00"},null,null,{"v":117,"d":"117.00"},null,132]
[{"$nulls":4},133,"Oman",null,null,{"v":43,"d":"43.00"},{"v":64,"d":"64.00"},null,null,{"v":141,"d":"141.00"},null,133]
[{"$nulls":4},134,"Pakistan",null,null,{"v":28,"d":"28.00"},{"v":41,"d":"41.00"},null,null,{"v":199,"d":"199.00"},null,134]
[{"$nulls":4},135,"Palau",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":193,"d":"193.00"}]
[{"$nulls":4},136,"Panama",null,null,{"v":28,"d":"28.00"},{"v":41,"d":"41.00"},null,null,{"v":82,"d":"82.00"},null,136]
[{"$nulls":4},137,"Papua-Neuguinea",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":159,"d":"159.00"},null,137]
[{"$nulls":4},138,"Paraguay",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":124,"d":"124.00"},null,138]
[{"$nulls":4},139,"Peru",null,null,{"v":35,"d":"35.00"},{"v":52,"d":"52.00"},null,null,{"v":128,"d":"128.00"},null,139]
[{"$nulls":4},140,"Philippinen",null,null,{"v":28,"d":"28.00"},{"v":41,"d":"41.00"},null,null,{"v":140,"d":"140.00"}]
[{"$nulls":4},141,"Polen – Breslau",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":124,"d":"124.00"},null,141]
[{"$nulls":4},142,"Polen – Warschau",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":143,"d":"143.00"},null,142]
[{"$nulls":4},143,"Polen – im Übrigen",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":124,"d":"124.00"},null,143]
[{"$nulls":4},144,"Portugal",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":111,"d":"111.00"},null,{"$f":"+E149","v":144}]
[{"$nulls":4},145,"Ruanda",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":117,"d":"117.00"},null,145]
[{"$nulls":4},146,"Rumänien",null,null,{"v":25,"d":"25.00"},{"v":38,"d":"38.00"},null,null,{"v":103,"d":"103.00"},null,146]
[{"$nulls":4},147,"Russische Föderation – Moskau",null,null,{"v":20,"d":"20.00"},{"v":30,"d":"30.00"},null,null,{"v":235,"d":"235.00"},null,147]
[{"$nulls":4},148,"Russische Föderation – St. Petersburg",null,null,{"v":19,"d":"19.00"},{"v":28,"d":"28.00"},null,null,{"v":133,"d":"133.00"}]
[{"$nulls":4},149,"Russische Föderation – im Übrigen",null,null,{"v":19,"d":"19.00"},{"v":28,"d":"28.00"},null,null,{"v":133,"d":"133.00"},null,149]
[{"$nulls":4},150,"Sambia",null,null,{"v":25,"d":"25.00"},{"v":38,"d":"38.00"},null,null,{"v":105,"d":"105.00"},null,150]
[{"$nulls":4},151,"Samoa",null,null,{"v":26,"d":"26.00"},{"v":39,"d":"39.00"},null,null,{"v":105,"d":"105.00"},null,151]
[{"$nulls":4},152,"San Marino",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":79,"d":"79.00"},null,152]
[{"$nulls":4},153,"São Tomé – Príncipe",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":147,"d":"147.00"},null,153]
[{"$nulls":4},154,"Saudi-Arabien – Djidda",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":181,"d":"181.00"},null,154]
[{"$nulls":4},155,"Saudi-Arabien – Riad",null,null,{"v":37,"d":"37.00"},{"v":56,"d":"56.00"},null,null,{"v":186,"d":"186.00"},null,155]
[{"$nulls":4},156,"Saudi-Arabien – im Übrigen",null,null,{"v":37,"d":"37.00"},{"v":56,"d":"56.00"},null,null,{"v":181,"d":"181.00"},null,156]
[{"$nulls":4},157,"Schweden",null,null,{"v":44,"d":"44.00"},{"v":66,"d":"66.00"},null,null,{"v":140,"d":"140.00"},null,157]
[{"$nulls":4},158,"Schweiz – Bern",null,null,{"v":55,"d":"55.00"},{"v":82,"d":"82.00"},null,null,{"v":195,"d":"195.00"},null,158]
[{"$nulls":4},159,"Schweiz – Genf",null,null,{"v":47,"d":"47.00"},{"v":70,"d":"70.00"},null,null,{"v":197,"d":"197.00"},null,159]
[{"$nulls":4},160,"Schweiz – im Übrigen",null,null,{"v":47,"d":"47.00"},{"v":70,"d":"70.00"},null,null,{"v":195,"d":"195.00"}]
[{"$nulls":4},161,"Senegal",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":160,"d":"160.00"},null,161]
[{"$nulls":4},162,"Serbien",null,null,{"v":18,"d":"18.00"},{"v":27,"d":"27.00"},null,null,{"v":97,"d":"97.00"},null,162]
[{"$nulls":4},163,"Sierra Leone",null,null,{"v":38,"d":"38.00"},{"v":57,"d":"57.00"},null,null,{"v":145,"d":"145.00"},null,163]
[{"$nulls":4},164,"Simbabwe",null,null,{"v":42,"d":"42.00"},{"v":63,"d":"63.00"},null,null,{"v":198,"d":"198.00"},null,164]
[{"$nulls":4},165,"Singapur",null,null,{"v":48,"d":"48.00"},{"v":71,"d":"71.00"},null,null,{"v":277,"d":"277.00"},null,165]
[{"$nulls":4},166,"Slowakische Republik",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":121,"d":"121.00"},null,166]
[{"$nulls":4},167,"Slowenien",null,null,{"v":25,"d":"25.00"},{"v":38,"d":"38.00"},null,null,{"v":126,"d":"126.00"}]
[{"$nulls":4},168,"Spanien – Barcelona",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":144,"d":"144.00"}]
[{"$nulls":4},169,"Spanien – Kanarische Inseln",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":103,"d":"103.00"}]
[{"$nulls":4},170,"Spanien – Madrid",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":131,"d":"131.00"}]
[{"$nulls":4},171,"Spanien – Palma de Mallorca",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":142,"d":"142.00"},null,171]
[{"$nulls":4},172,"Spanien – im Übrigen",null,null,{"v":23,"d":"23.00"},{"v":34,"d":"34.00"},null,null,{"v":103,"d":"103.00"},null,172]
[{"$nulls":4},173,"Sri Lanka",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":112,"d":"112.00"}]
[{"$nulls":4},174,"Südafrika – Kapstadt",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":130,"d":"130.00"}]
[{"$nulls":4},175,"Südafrika – Johannesburg",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":129,"d":"129.00"}]
[{"$nulls":4},176,"Südafrika – im Übrigen",null,null,{"v":20,"d":"20.00"},{"v":29,"d":"29.00"},null,null,{"v":109,"d":"109.00"}]
[{"$nulls":4},177,"Südsudan",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":159,"d":"159.00"}]
[{"$nulls":4},178,"Tadschikistan",null,null,{"v":18,"d":"18.00"},{"v":27,"d":"27.00"},null,null,{"v":85,"d":"85.00"}]
[{"$nulls":4},179,"Taiwan",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":174,"d":"174.00"}]
[{"$nulls":4},180,"Tansania",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":97,"d":"97.00"}]
[{"$nulls":4},181,"Thailand",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":114,"d":"114.00"}]
[{"$nulls":4},182,"Togo",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":144,"d":"144.00"}]
[{"$nulls":4},183,"Tonga",null,null,{"v":20,"d":"20.00"},{"v":29,"d":"29.00"},null,null,{"v":102,"d":"102.00"}]
[{"$nulls":4},184,"Trinidad und Tobago",null,null,{"v":44,"d":"44.00"},{"v":66,"d":"66.00"},null,null,{"v":203,"d":"203.00"}]
[{"$nulls":4},185,"Tschad",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":155,"d":"155.00"}]
[{"$nulls":4},186,"Tschechische Republik",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":77,"d":"77.00"}]
[{"$nulls":4},187,"Türkei – Ankara",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":110,"d":"110.00"}]
[{"$nulls":4},188,"Türkei – Izmir",null,null,{"v":29,"d":"29.00"},{"v":44,"d":"44.00"},null,null,{"v":120,"d":"120.00"}]
[{"$nulls":4},189,"Türkei – im Übrigen",null,null,{"v":16,"d":"16.00"},{"v":24,"d":"24.00"},null,null,{"v":107,"d":"107.00"}]
[{"$nulls":4},190,"Tunesien",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":144,"d":"144.00"}]
[{"$nulls":4},191,"Turkmenistan",null,null,{"v":19,"d":"19.00"},{"v":28,"d":"28.00"},null,null,{"v":135,"d":"135.00"}]
[{"$nulls":4},192,"Uganda",null,null,{"v":30,"d":"30.00"},{"v":45,"d":"45.00"},null,null,{"v":207,"d":"207.00"}]
[{"$nulls":4},193,"Ukraine",null,null,{"v":22,"d":"22.00"},{"v":33,"d":"33.00"},null,null,{"v":180,"d":"180.00"}]
[{"$nulls":4},194,"Ungarn",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":85,"d":"85.00"}]
[{"$nulls":4},195,"Uruguay",null,null,{"v":27,"d":"27.00"},{"v":40,"d":"40.00"},null,null,{"v":113,"d":"113.00"}]
[{"$nulls":4},196,"Usbekistan",null,null,{"v":21,"d":"21.00"},{"v":32,"d":"32.00"},null,null,{"v":133,"d":"133.00"}]
[{"$nulls":4},197,"Vatikanstaat",null,null,{"v":32,"d":"32.00"},{"v":48,"d":"48.00"},null,null,{"v":150,"d":"150.00"}]
[{"$nulls":4},198,"Venezuela",null,null,{"v":34,"d":"34.00"},{"v":51,"d":"51.00"},null,null,{"v":178,"d":"178.00"}]
[{"$nulls":4},199,"Vereinigte Arabische Emirate",null,null,{"v":54,"d":"54.00"},{"v":81,"d":"81.00"},null,null,{"v":169,"d":"169.00"}]
[{"$nulls":4},200,"USA – Atlanta",null,null,{"v":52,"d":"52.00"},{"v":77,"d":"77.00"},null,null,{"v":182,"d":"182.00"}]
[{"$nulls":4},201,"USA – Boston",null,null,{"v":42,"d":"42.00"},{"v":63,"d":"63.00"},null,null,{"v":333,"d":"333.00"}]
[{"$nulls":4},202,"USA – Chicago",null,null,{"v":44,"d":"44.00"},{"v":65,"d":"65.00"},null,null,{"v":233,"d":"233.00"}]
[{"$nulls":4},203,"USA – Houston",null,null,{"v":41,"d":"41.00"},{"v":62,"d":"62.00"},null,null,{"v":204,"d":"204.00"}]
[{"$nulls":4},204,"USA – Los Angeles",null,null,{"v":43,"d":"43.00"},{"v":64,"d":"64.00"},null,null,{"v":262,"d":"262.00"}]
[{"$nulls":4},205,"USA – Miami",null,null,{"v":44,"d":"44.00"},{"v":65,"d":"65.00"},null,null,{"v":256,"d":"256.00"}]
[{"$nulls":4},206,"USA – New York City",null,null,{"v":44,"d":"44.00"},{"v":66,"d":"66.00"},null,null,{"v":308,"d":"308.00"}]
[{"$nulls":4},207,"USA – San Francisco",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":327,"d":"327.00"}]
[{"$nulls":4},208,"USA – Washington, D. C.",null,null,{"v":44,"d":"44.00"},{"v":66,"d":"66.00"},null,null,{"v":203,"d":"203.00"}]
[{"$nulls":4},209,"USA – im Übrigen",null,null,{"v":40,"d":"40.00"},{"v":59,"d":"59.00"},null,null,{"v":182,"d":"182.00"}]
[{"$nulls":4},210,"GB – London",null,null,{"v":44,"d":"44.00"},{"v":66,"d":"66.00"},null,null,{"v":163,"d":"163.00"}]
[{"$nulls":4},211,"GB – im Übrigen",null,null,{"v":35,"d":"35.00"},{"v":52,"d":"52.00"},null,null,{"v":99,"d":"99.00"}]
[{"$nulls":4},212,"Vietnam",null,null,{"v":24,"d":"24.00"},{"v":36,"d":"36.00"},null,null,{"v":111,"d":"111.00"}]
[{"$nulls":4},213,"Weißrussland",null,null,{"v":14,"d":"14.00"},{"v":21,"d":"21.00"},null,null,{"v":148,"d":"148.00"}]
[{"$nulls":4},214,"Zentralafrikanische Republik",null,null,{"v":36,"d":"36.00"},{"v":53,"d":"53.00"},null,null,{"v":210,"d":"210.00"}]
[{"$nulls":4},215,"Zypern",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":125,"d":"125.00"}]
[{"$nulls":4},216,"Zypern",null,null,{"v":28,"d":"28.00"},{"v":42,"d":"42.00"},null,null,{"v":125,"d":"125.00"}]
[{"$nulls":4},"Stand: 2023-11-23"]
[]
[{"$nulls":5},"<< Startseite",null,"Hilfe?"]
[]
[null,null,"© 2026 by mediaforwork - ein Unternehmensbereich der Verlag für die Deutsche Wirtschaft AG"]
[null,null,"Die Vervielfältigung, Verbreitung oder Veräußerung der Daten oder Texte ist unzulässig und"]
[null,null,"ausdrücklich nur mit Genehmigung des Verlags gestattet."]

{"sheet":"Parameter_Intern","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
[]
[]
[]
[null,"Nr","Tabellenblatt","Hinweise","Hyperlink"]
[null,1,"Eingaben","Hier geben Sie die Daten zur Erstellung der Reisekostenabrechnung ein","#Eingaben!E2"]
[null,2,"Berechnung","In diesem Arbeitsblatt wird die Reisekostenabrechnung erstellt","#Berechnung!B2"]
[null,3,"Beispiel","Hier finden Sie ein Beispiel für die Eingaben","#Beispiel!B2"]
[null,4,"Hilfe","Hier finden Sie nähere Informationen über die Anwendung.","#Hilfe!B3"]
[null,5,"Stammdaten","In diesem Arbeitsblatt pflegen Sie Mitarbeiter und Belegarten","#Stammdaten!D12"]
[null,6,"Pauschalen","Hier können Sie die Reisekostenpauschalen einpflegen","#Pauschalen!c2"]

{"sheet":"__Goal_Metadata","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"hidden":true}
["_KAW999934","J"]
["_KAW999929","e97c26fe-fa5a-4769-94df-cc203eff761b"]