{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Reisekostenabrechnung","Länder","Versionshinweise"],"not_rendered":{"images":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Reisekostenabrechnung","index":0,"n_rows":60,"n_cols":29,"rows_kept":60,"merged":[[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,4,28],[5,1,5,28],[6,1,6,28],[8,0,8,28],[10,1,10,3],[11,1,11,3],[13,0,13,1],[13,2,13,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,16,14,16],[13,17,14,17],[13,18,14,18],[13,20,13,22],[13,24,13,28],[53,0,53,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1]]}
["Kurzanleitung Reisekostenabrechnung"]
["1.","Tragen Sie Ihre Werte nur in den grün hinterlegten Feldern ein."]
["2.","Wählen Sie das Land aus dem Listenfeld in der Spalte Land aus."]
["3.","Tages- und Nächtigungsgelder können nur angesetzt werden, wenn die Reise über drei Stunden betragen hat und der Zielort über 25 Kilometer entfernt ist."]
["4.","Nächtigungskosten: Hotelrechnungen etc. sind als Belege in die Buchhaltung oder mit den Jahresunterlagen an den Steuerberater zu übergeben. Nächtigungsgeld wird vom Steuerberater bei der Steuererklärung berechnet."]
["5.","Befindet man sich regelmäßig am Zielort, können maximal 5 Taggelder angesetzt werden. Ist man unregelmäßig am Zielort, können 15 Taggelder angesetzt werden. Dies kann in der Spalte \"selber Ort in kurzer Zeit\" \nmanuell gesetzt werden."]
["6.","Können im Ausland keine Taggelder mehr angesetzt werden, weil man sich über 5 oder 15 Tage am gleichen Ort befindet, kann trotzdem die Differenz zum österreichischen Taggeld berücksichtigt werden."]
[]
[{"$f":"\"Reisekostenabrechnung \"&B12","v":"Reisekostenabrechnung "}]
[]
["für",{"$nulls":3},"Firma oder Name",{"$nulls":4},"ja"]
["Zeitraum",{"$nulls":3},"MM/JJJJ oder JJJJ",{"$nulls":4},"nein"]
[]
["Datum\n(Eingabe: TT/MM/JJ)",null,"Uhrzeit\n(Eingabe: SS:MM)",null,"Ausgangsort/Reiseziel\n(Eingabe: Adressen)","Land\n(Eingabe: aus Listenfeld)","Länder-code","selber Ort in kurzer Zeit","Reisezweck","ganze Tage","Tage gesamt","Std\nein Tag","Std\naufge-rundet","Tagsatz","Tagsatz\nDifferenz",null,"Diff.aufw.\n> 5 Tage\noder\nselber Ort","Taggeld\n <= 5 Tage","Summe Taggeld",null,"Nächtigungskosten\npauschal mit Nächtigungssatz oder Echtkosten (sind Belege in Buchhaltung, als Echtkosten 0,00 eintragen)",{"$nulls":3},"Fahrtkosten\npauschal KM-Geld"]
["am/von","bis","Abfahrt","Rückkehr",{"$nulls":16},"pauschal","Echtkosten","Nächt.kosten",null,"KM","Beifahrer","KM-Geld","Echtkosten","Fahrtkosten"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F16,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,{"$f":"IF(A16<>\"\",MAX(IF(B16-A16<0,0,B16-A16-1),0),\"n/a\")","v":"n/a"},{"$f":"IF(A16<>\"\",IF(B16=\"\",1,B16-A16+1),\"n/a\")","v":"n/a"},{"$f":"IF(K16=1,MIN(MAX((D16-C16)*24,0),12),\"n/a\")","v":"n/a"},{"$f":"IF(K16=1,ROUNDUP(L16,0),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP($G16,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N16<>\"\",IF(OR(H16=\"ja\",AND(K16>5,K16<>\"n/a\")),N16-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,{"$f":"IF(H16=\"ja\",ROUND((J16*O16)+(MIN(24-ROUNDUP(C16*24,0),12)/12*O16)+(ROUNDUP(MIN(D16*24,12),0)/12*O16),2),IF(ISNUMBER(O16),ROUND(((K16-5-1)+(ROUNDUP(MIN(D16*24,12),0)/12))*(O16),2),\"n/a\"))","v":"n/a"},{"$f":"IFERROR(IF(H16=\"ja\",\"n/a\",IF(K16=1,IF(ROUNDUP((D16-C16)*24,0)>3,ROUND(M16/12*N16,2),\"< 3h\"),IF(ISNUMBER(O16),ROUND((MIN(24-ROUNDUP(C16*24,0),12)/12+4)*N16,2),ROUND((J16*N16)+(MIN(24-ROUNDUP(C16*24,0),12)/12*N16)+(ROUNDUP(MIN(D16*24,12),0)/12*N16),2)))),\"n/a\")","v":"n/a"},{"$f":"IF(AND(ISNUMBER(Q16),ISNUMBER(R16)),Q16+R16,IF(H16=\"ja\",Q16,IF(ISNUMBER(R16),R16,\"n/a\")))","v":"n/a"},null,{"$f":"IFERROR(IF(K16>1,ROUND(VLOOKUP($G16,Länder!$C$2:$E$174,3,FALSE)*(K16-1),2),\"n/a\"),\"\")","v":""},null,{"$f":"IF(V16<>\"\",V16,IF(ISNUMBER(U16),U16,\"n/a\"))","v":"n/a"},{"$nulls":3},{"$f":"IF(Y16<>\"\",ROUND(Y16*(0.42+Z16*0.02),2),\"n/a\")","v":"n/a"},null,{"$f":"IF(AB16<>\"\",AB16,IF(ISNUMBER(AA16),AA16,\"n/a\"))","v":"n/a"}]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F17,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,{"$f":"IF(A17<>\"\",MAX(IF(B17-A17<0,0,B17-A17-1),0),\"n/a\")","v":"n/a"},{"$f":"IF(A17<>\"\",IF(B17=\"\",1,B17-A17+1),\"n/a\")","v":"n/a"},{"$f":"IF(K17=1,MIN(MAX((D17-C17)*24,0),12),\"n/a\")","v":"n/a"},{"$f":"IF(K17=1,ROUNDUP(L17,0),\"n/a\")","v":"n/a"},{"$f":"IFERROR(VLOOKUP($G17,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N17<>\"\",IF(OR(H17=\"ja\",AND(K17>5,K17<>\"n/a\")),N17-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,{"$f":"IF(H17=\"ja\",ROUND((J17*O17)+(MIN(24-ROUNDUP(C17*24,0),12)/12*O17)+(ROUNDUP(MIN(D17*24,12),0)/12*O17),2),IF(ISNUMBER(O17),ROUND(((K17-5-1)+(ROUNDUP(MIN(D17*24,12),0)/12))*(O17),2),\"n/a\"))","v":"n/a"},{"$f":"IFERROR(IF(H17=\"ja\",\"n/a\",IF(K17=1,IF(ROUNDUP((D17-C17)*24,0)>3,ROUND(M17/12*N17,2),\"< 3h\"),IF(ISNUMBER(O17),ROUND((MIN(24-ROUNDUP(C17*24,0),12)/12+4)*N17,2),ROUND((J17*N17)+(MIN(24-ROUNDUP(C17*24,0),12)/12*N17)+(ROUNDUP(MIN(D17*24,12),0)/12*N17),2)))),\"n/a\")","v":"n/a"},{"$f":"IF(AND(ISNUMBER(Q17),ISNUMBER(R17)),Q17+R17,IF(H17=\"ja\",Q17,IF(ISNUMBER(R17),R17,\"n/a\")))","v":"n/a"},null,{"$f":"IFERROR(IF(K17>1,ROUND(VLOOKUP($G17,Länder!$C$2:$E$174,3,FALSE)*(K17-1),2),\"n/a\"),\"\")","v":""},null,{"$f":"IF(V17<>\"\",V17,IF(ISNUMBER(U17),U17,\"n/a\"))","v":"n/a"},{"$nulls":3},{"$f":"IF(Y17<>\"\",ROUND(Y17*(0.42+Z17*0.02),2),\"n/a\")","v":"n/a"},null,{"$f":"IF(AB17<>\"\",AB17,IF(ISNUMBER(AA17),AA17,\"n/a\"))","v":"n/a"}]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F18,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G18,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N18<>\"\",IF(OR(H18=\"ja\",AND(K18>5,K18<>\"n/a\")),N18-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K18>1,ROUND(VLOOKUP($G18,Länder!$C$2:$E$174,3,FALSE)*(K18-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F19,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G19,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N19<>\"\",IF(OR(H19=\"ja\",AND(K19>5,K19<>\"n/a\")),N19-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K19>1,ROUND(VLOOKUP($G19,Länder!$C$2:$E$174,3,FALSE)*(K19-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F20,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G20,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N20<>\"\",IF(OR(H20=\"ja\",AND(K20>5,K20<>\"n/a\")),N20-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K20>1,ROUND(VLOOKUP($G20,Länder!$C$2:$E$174,3,FALSE)*(K20-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F21,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G21,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N21<>\"\",IF(OR(H21=\"ja\",AND(K21>5,K21<>\"n/a\")),N21-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K21>1,ROUND(VLOOKUP($G21,Länder!$C$2:$E$174,3,FALSE)*(K21-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F22,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G22,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N22<>\"\",IF(OR(H22=\"ja\",AND(K22>5,K22<>\"n/a\")),N22-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K22>1,ROUND(VLOOKUP($G22,Länder!$C$2:$E$174,3,FALSE)*(K22-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F23,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G23,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N23<>\"\",IF(OR(H23=\"ja\",AND(K23>5,K23<>\"n/a\")),N23-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K23>1,ROUND(VLOOKUP($G23,Länder!$C$2:$E$174,3,FALSE)*(K23-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F24,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G24,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N24<>\"\",IF(OR(H24=\"ja\",AND(K24>5,K24<>\"n/a\")),N24-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K24>1,ROUND(VLOOKUP($G24,Länder!$C$2:$E$174,3,FALSE)*(K24-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F25,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G25,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N25<>\"\",IF(OR(H25=\"ja\",AND(K25>5,K25<>\"n/a\")),N25-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K25>1,ROUND(VLOOKUP($G25,Länder!$C$2:$E$174,3,FALSE)*(K25-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F26,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G26,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N26<>\"\",IF(OR(H26=\"ja\",AND(K26>5,K26<>\"n/a\")),N26-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K26>1,ROUND(VLOOKUP($G26,Länder!$C$2:$E$174,3,FALSE)*(K26-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F27,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G27,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N27<>\"\",IF(OR(H27=\"ja\",AND(K27>5,K27<>\"n/a\")),N27-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K27>1,ROUND(VLOOKUP($G27,Länder!$C$2:$E$174,3,FALSE)*(K27-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F28,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G28,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N28<>\"\",IF(OR(H28=\"ja\",AND(K28>5,K28<>\"n/a\")),N28-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K28>1,ROUND(VLOOKUP($G28,Länder!$C$2:$E$174,3,FALSE)*(K28-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F29,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G29,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N29<>\"\",IF(OR(H29=\"ja\",AND(K29>5,K29<>\"n/a\")),N29-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K29>1,ROUND(VLOOKUP($G29,Länder!$C$2:$E$174,3,FALSE)*(K29-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F30,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G30,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N30<>\"\",IF(OR(H30=\"ja\",AND(K30>5,K30<>\"n/a\")),N30-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K30>1,ROUND(VLOOKUP($G30,Länder!$C$2:$E$174,3,FALSE)*(K30-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F31,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G31,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N31<>\"\",IF(OR(H31=\"ja\",AND(K31>5,K31<>\"n/a\")),N31-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K31>1,ROUND(VLOOKUP($G31,Länder!$C$2:$E$174,3,FALSE)*(K31-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F32,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G32,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N32<>\"\",IF(OR(H32=\"ja\",AND(K32>5,K32<>\"n/a\")),N32-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K32>1,ROUND(VLOOKUP($G32,Länder!$C$2:$E$174,3,FALSE)*(K32-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F33,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G33,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N33<>\"\",IF(OR(H33=\"ja\",AND(K33>5,K33<>\"n/a\")),N33-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K33>1,ROUND(VLOOKUP($G33,Länder!$C$2:$E$174,3,FALSE)*(K33-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F34,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G34,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N34<>\"\",IF(OR(H34=\"ja\",AND(K34>5,K34<>\"n/a\")),N34-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K34>1,ROUND(VLOOKUP($G34,Länder!$C$2:$E$174,3,FALSE)*(K34-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F35,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G35,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N35<>\"\",IF(OR(H35=\"ja\",AND(K35>5,K35<>\"n/a\")),N35-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K35>1,ROUND(VLOOKUP($G35,Länder!$C$2:$E$174,3,FALSE)*(K35-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F36,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G36,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N36<>\"\",IF(OR(H36=\"ja\",AND(K36>5,K36<>\"n/a\")),N36-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K36>1,ROUND(VLOOKUP($G36,Länder!$C$2:$E$174,3,FALSE)*(K36-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F37,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G37,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N37<>\"\",IF(OR(H37=\"ja\",AND(K37>5,K37<>\"n/a\")),N37-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K37>1,ROUND(VLOOKUP($G37,Länder!$C$2:$E$174,3,FALSE)*(K37-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F38,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G38,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N38<>\"\",IF(OR(H38=\"ja\",AND(K38>5,K38<>\"n/a\")),N38-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K38>1,ROUND(VLOOKUP($G38,Länder!$C$2:$E$174,3,FALSE)*(K38-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F39,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G39,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N39<>\"\",IF(OR(H39=\"ja\",AND(K39>5,K39<>\"n/a\")),N39-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K39>1,ROUND(VLOOKUP($G39,Länder!$C$2:$E$174,3,FALSE)*(K39-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F40,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G40,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N40<>\"\",IF(OR(H40=\"ja\",AND(K40>5,K40<>\"n/a\")),N40-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K40>1,ROUND(VLOOKUP($G40,Länder!$C$2:$E$174,3,FALSE)*(K40-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F41,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G41,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N41<>\"\",IF(OR(H41=\"ja\",AND(K41>5,K41<>\"n/a\")),N41-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K41>1,ROUND(VLOOKUP($G41,Länder!$C$2:$E$174,3,FALSE)*(K41-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F42,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G42,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N42<>\"\",IF(OR(H42=\"ja\",AND(K42>5,K42<>\"n/a\")),N42-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K42>1,ROUND(VLOOKUP($G42,Länder!$C$2:$E$174,3,FALSE)*(K42-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F43,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G43,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N43<>\"\",IF(OR(H43=\"ja\",AND(K43>5,K43<>\"n/a\")),N43-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K43>1,ROUND(VLOOKUP($G43,Länder!$C$2:$E$174,3,FALSE)*(K43-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F44,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G44,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N44<>\"\",IF(OR(H44=\"ja\",AND(K44>5,K44<>\"n/a\")),N44-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K44>1,ROUND(VLOOKUP($G44,Länder!$C$2:$E$174,3,FALSE)*(K44-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F45,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G45,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N45<>\"\",IF(OR(H45=\"ja\",AND(K45>5,K45<>\"n/a\")),N45-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K45>1,ROUND(VLOOKUP($G45,Länder!$C$2:$E$174,3,FALSE)*(K45-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F46,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G46,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N46<>\"\",IF(OR(H46=\"ja\",AND(K46>5,K46<>\"n/a\")),N46-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K46>1,ROUND(VLOOKUP($G46,Länder!$C$2:$E$174,3,FALSE)*(K46-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F47,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G47,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N47<>\"\",IF(OR(H47=\"ja\",AND(K47>5,K47<>\"n/a\")),N47-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K47>1,ROUND(VLOOKUP($G47,Länder!$C$2:$E$174,3,FALSE)*(K47-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F48,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G48,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N48<>\"\",IF(OR(H48=\"ja\",AND(K48>5,K48<>\"n/a\")),N48-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K48>1,ROUND(VLOOKUP($G48,Länder!$C$2:$E$174,3,FALSE)*(K48-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F49,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G49,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N49<>\"\",IF(OR(H49=\"ja\",AND(K49>5,K49<>\"n/a\")),N49-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K49>1,ROUND(VLOOKUP($G49,Länder!$C$2:$E$174,3,FALSE)*(K49-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F50,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G50,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N50<>\"\",IF(OR(H50=\"ja\",AND(K50>5,K50<>\"n/a\")),N50-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K50>1,ROUND(VLOOKUP($G50,Länder!$C$2:$E$174,3,FALSE)*(K50-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F51,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G51,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N51<>\"\",IF(OR(H51=\"ja\",AND(K51>5,K51<>\"n/a\")),N51-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K51>1,ROUND(VLOOKUP($G51,Länder!$C$2:$E$174,3,FALSE)*(K51-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F52,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G52,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N52<>\"\",IF(OR(H52=\"ja\",AND(K52>5,K52<>\"n/a\")),N52-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K52>1,ROUND(VLOOKUP($G52,Länder!$C$2:$E$174,3,FALSE)*(K52-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
[null,null,"00:00:00","00:00:00",null,null,{"$f":"IFERROR(VLOOKUP(F53,Länder!$B$2:$C$174,2,FALSE),\"\")","v":""},"nein",null,"n/a","n/a","n/a","n/a",{"$f":"IFERROR(VLOOKUP($G53,Länder!$C$2:$E$174,2,FALSE),\"\")","v":""},{"$f":"IF(N53<>\"\",IF(OR(H53=\"ja\",AND(K53>5,K53<>\"n/a\")),N53-Länder!$D$2,\"kein Diff\"),\"\")","v":""},null,"n/a","n/a","n/a",null,{"$f":"IFERROR(IF(K53>1,ROUND(VLOOKUP($G53,Länder!$C$2:$E$174,3,FALSE)*(K53-1),2),\"n/a\"),\"\")","v":""},null,"n/a",{"$nulls":3},"n/a",null,"n/a"]
["Gesamt",{"$nulls":17},{"$f":"SUM(S16:S53)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"SUM(W16:W53)","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"SUM(AA16:AA53)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AC16:AC53)","v":{"v":0,"d":"0.00"}}]
[null,null,"Inland","Ausland","Gesamt"]
["Taggeld",null,{"$f":"SUMIF($G$16:$G$53,1,$S$16:$S$53)","v":{"v":0,"d":"0.00"}},{"$f":"S54-C56","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C56:D56)","v":{"v":0,"d":"0.00"}}]
["Fahrkosten",null,{"$f":"SUMIF($G$16:$G$53,1,$AC$16:$AC$53)","v":{"v":0,"d":"0.00"}},{"$f":"AC54-C57","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C57:D57)","v":{"v":0,"d":"0.00"}}]
["Zwischensumme",null,{"$f":"SUM(C56:C57)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D56:D57)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E56:E57)","v":{"v":0,"d":"0.00"}}]
["Nächtigungskosten",null,{"$f":"SUMIF($G$16:$G$53,1,$W$16:$W$53)","v":{"v":0,"d":"0.00"}},{"$f":"W54-C59","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C59:D59)","v":{"v":0,"d":"0.00"}}]
["Summe Reisekosten",null,{"$f":"C58+C59","v":{"v":0,"d":"0.00"}},{"$f":"D58+D59","v":{"v":0,"d":"0.00"}},{"$f":"SUM(E58:E59)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Länder","index":1,"n_rows":174,"n_cols":5,"rows_kept":174}
[null,"Land","Ländercode","Tagesgebühr","Nächtigungsgebühr"]
["I. EUROPA","Österreich",1,26.4,15]
["I. EUROPA","Albanien",2,27.9,20.9]
["I. EUROPA","Belarus",3,36.8,31]
["I. EUROPA","Belgien",4,35.3,22.7]
["I. EUROPA","Brüssel",5,41.4,32]
["I. EUROPA","Bosnien und Herzegowina",6,31,23.3]
["I. EUROPA","Bulgarien",7,31,22.7]
["I. EUROPA","Dänemark",8,41.4,41.4]
["I. EUROPA","Deutschland",9,35.3,27.9]
["I. EUROPA","Grenzorte Deutschland",10,30.7,18.1]
["I. EUROPA","Estland",11,36.8,31]
["I. EUROPA","Finnland",12,41.4,41.4]
["I. EUROPA","Frankreich",13,32.7,24]
["I. EUROPA","Paris und Straßburg",14,35.8,32.7]
["I. EUROPA","Griechenland",15,28.6,23.3]
["I. EUROPA","Großbritannien und Nordirland",16,36.8,36.4]
["I. EUROPA","London",17,41.4,41.4]
["I. EUROPA","Irland",18,36.8,33.1]
["I. EUROPA","Island",19,37.9,31.4]
["I. EUROPA","Italien",20,35.8,27.9]
["I. EUROPA","Rom und Mailand",21,40.6,36.4]
["I. EUROPA","Grenzorte Italien",22,30.7,18.1]
["I. EUROPA","Kroatien",23,31,23.3]
["I. EUROPA","Lettland",24,36.8,31]
["I. EUROPA","Liechtenstein",25,30.7,18.1]
["I. EUROPA","Litauen",26,36.8,31]
["I. EUROPA","Luxemburg",27,35.3,22.7]
["I. EUROPA","Malta",28,30.1,30.1]
["I. EUROPA","Moldau",29,36.8,31]
["I. EUROPA","Niederlande",30,35.3,27.9]
["I. EUROPA","Norwegen",31,42.9,41.4]
["I. EUROPA","Polen",32,32.7,25.1]
["I. EUROPA","Portugal",33,27.9,22.7]
["I. EUROPA","Rumänien",34,36.8,27.3]
["I. EUROPA","Russische Föderation",35,36.8,31]
["I. EUROPA","Moskau",36,40.6,31]
["I. EUROPA","Schweden",37,42.9,41.4]
["I. EUROPA","Schweiz",38,36.8,32.7]
["I. EUROPA","Grenzorte Schweiz",39,30.7,18.1]
["I. EUROPA","Slowakei",40,27.9,15.9]
["I. EUROPA","Preßburg",41,31,24.4]
["I. EUROPA","Slowenien",42,31,23.3]
["I. EUROPA","Grenzorte Slowenien",43,27.9,15.9]
["I. EUROPA","Spanien",44,34.2,30.5]
["I. EUROPA","Tschechien",45,31,24.4]
["I. EUROPA","Grenzorte Tschechien",46,27.9,15.9]
["I. EUROPA","Türkei",47,31,36.4]
["I. EUROPA","Ukraine",48,36.8,31]
["I. EUROPA","Ungarn",49,26.6,26.6]
["I. EUROPA","Budapest",50,31,26.6]
["I. EUROPA","Grenzorte Ungarn",51,26.6,18.1]
["I. EUROPA","Zypern",52,28.6,30.5]
["II. AFRIKA","Ägypten",53,37.9,41.4]
["II. AFRIKA","Algerien",54,41.4,27]
["II. AFRIKA","Angola",55,43.6,41.4]
["II. AFRIKA","Äthiopien",56,37.9,41.4]
["II. AFRIKA","Benin",57,36.2,26.6]
["II. AFRIKA","Burkina Faso",58,39.2,21.1]
["II. AFRIKA","Burundi",59,37.9,37.9]
["II. AFRIKA","Côte d'Ivoire",60,39.2,32]
["II. AFRIKA","Demokratische Rep. Kongo",61,47.3,33.1]
["II. AFRIKA","Dschibuti",62,45.8,47.3]
["II. AFRIKA","Gabun",63,45.8,39.9]
["II. AFRIKA","Gambia",64,43.6,30.1]
["II. AFRIKA","Ghana",65,43.6,30.1]
["II. AFRIKA","Guinea",66,43.6,30.1]
["II. AFRIKA","Kamerun",67,45.8,25.3]
["II. AFRIKA","Kap Verde",68,27.9,19.6]
["II. AFRIKA","Kenia",69,34.9,32]
["II. AFRIKA","Liberia",70,39.2,41.4]
["II. AFRIKA","Libyen",71,43.6,36.4]
["II. AFRIKA","Madagaskar",72,36.4,36.4]
["II. AFRIKA","Malawi",73,32.7,32.7]
["II. AFRIKA","Mali",74,39.2,31.2]
["II. AFRIKA","Marokko",75,32.7,21.8]
["II. AFRIKA","Mauretanien",76,33.8,31.2]
["II. AFRIKA","Mauritius",77,36.4,36.4]
["II. AFRIKA","Mosambik",78,43.6,41.4]
["II. AFRIKA","Namibia",79,34.9,34]
["II. AFRIKA","Niger",80,39.2,21.1]
["II. AFRIKA","Nigeria",81,39.2,34.2]
["II. AFRIKA","Republik Kongo",82,39.2,26.8]
["II. AFRIKA","Ruanda",83,37.9,37.9]
["II. AFRIKA","Sambia",84,37.1,34]
["II. AFRIKA","Senegal",85,49.3,31.2]
["II. AFRIKA","Seychellen",86,36.4,36.4]
["II. AFRIKA","Sierra Leone",87,43.6,34.2]
["II. AFRIKA","Simbabwe",88,37.1,34]
["II. AFRIKA","Somalia",89,32.7,29]
["II. AFRIKA","Südafrika",90,34.9,34]
["II. AFRIKA","Sudan",91,43.6,41.4]
["II. AFRIKA","Tansania",92,43.6,32]
["II. AFRIKA","Togo",93,36.2,26.6]
["II. AFRIKA","Tschad",94,36.2,26.6]
["II. AFRIKA","Tunesien",95,36.2,29.2]
["II. AFRIKA","Uganda",96,41.4,32]
["II. AFRIKA","Zentralafrikanische Republik",97,39.2,29]
["III. AMERIKA","Argentinien",98,33.1,47.3]
["III. AMERIKA","Bahamas",99,48,30.5]
["III. AMERIKA","Barbados",100,51,43.6]
["III. AMERIKA","Bolivien",101,26.6,25.1]
["III. AMERIKA","Brasilien",102,33.1,36.4]
["III. AMERIKA","Chile",103,37.5,36.4]
["III. AMERIKA","Costa Rica",104,31.8,31.8]
["III. AMERIKA","Dominikanische Republik",105,39.2,43.6]
["III. AMERIKA","Ecuador",106,26.6,21.6]
["III. AMERIKA","El Salvador",107,31.8,26.2]
["III. AMERIKA","Guatemala",108,31.8,31.8]
["III. AMERIKA","Guyana",109,39.2,34.2]
["III. AMERIKA","Haiti",110,39.2,27.7]
["III. AMERIKA","Honduras",111,31.8,27]
["III. AMERIKA","Jamaika",112,47.1,47.1]
["III. AMERIKA","Kanada",113,41,34.2]
["III. AMERIKA","Kolumbien",114,33.1,35.1]
["III. AMERIKA","Kuba",115,54.1,27.7]
["III. AMERIKA","Mexiko",116,41,36.4]
["III. AMERIKA","Nicaragua",117,31.8,36.4]
["III. AMERIKA","Niederländische Antillen",118,43.6,27.7]
["III. AMERIKA","Panama",119,43.6,36.4]
["III. AMERIKA","Paraguay",120,33.1,25.1]
["III. AMERIKA","Peru",121,33.1,25.1]
["III. AMERIKA","Suriname",122,39.2,25.1]
["III. AMERIKA","Trinidad und Tobago",123,51,43.6]
["III. AMERIKA","Uruguay",124,33.1,25.1]
["III. AMERIKA","USA",125,52.3,42.9]
["III. AMERIKA","New York und Washington",126,65.4,51]
["III. AMERIKA","Venezuela",127,39.2,35.1]
["IV. ASIEN","Afghanistan",128,31.8,27.7]
["IV. ASIEN","Armenien",129,36.8,31]
["IV. ASIEN","Aserbaidschan",130,36.8,31]
["IV. ASIEN","Bahrain",131,54.1,37.5]
["IV. ASIEN","Bangladesch",132,31.8,34.2]
["IV. ASIEN","Brunei",133,33.1,42.1]
["IV. ASIEN","China",134,35.1,30.5]
["IV. ASIEN","Georgien",135,36.8,31]
["IV. ASIEN","Hongkong",136,46.4,37.9]
["IV. ASIEN","Indien",137,31.8,39.9]
["IV. ASIEN","Indonesien",138,39.2,32]
["IV. ASIEN","Irak",139,54.1,36.4]
["IV. ASIEN","Iran",140,37.1,29]
["IV. ASIEN","Israel",141,37.1,32.5]
["IV. ASIEN","Japan",142,65.6,42.9]
["IV. ASIEN","Jemen",143,54.1,37.5]
["IV. ASIEN","Jordanien",144,37.1,32.5]
["IV. ASIEN","Kambodscha",145,31.4,31.4]
["IV. ASIEN","Kasachstan",146,36.8,31]
["IV. ASIEN","Katar",147,54.1,37.5]
["IV. ASIEN","Kirgisistan",148,36.8,31]
["IV. ASIEN","Korea, Demokratische Volksrepublik",149,32.5,32.5]
["IV. ASIEN","Korea, Republik",150,45.3,32.5]
["IV. ASIEN","Kuwait",151,54.1,37.5]
["IV. ASIEN","Laos",152,31.4,31.4]
["IV. ASIEN","Libanon",153,31.8,35.1]
["IV. ASIEN","Malaysia",154,43.6,45.1]
["IV. ASIEN","Mongolei",155,29.4,29.4]
["IV. ASIEN","Myanmar",156,29.4,29.4]
["IV. ASIEN","Nepal",157,31.8,34.2]
["IV. ASIEN","Oman",158,54.1,37.5]
["IV. ASIEN","Pakistan",159,27.7,25.1]
["IV. ASIEN","Philippinen",160,32.5,32.5]
["IV. ASIEN","Saudi-Arabien",161,54.1,37.5]
["IV. ASIEN","Singapur",162,43.6,44.7]
["IV. ASIEN","Sri Lanka",163,31.8,32.7]
["IV. ASIEN","Syrien",164,32.7,29]
["IV. ASIEN","Tadschikistan",165,36.8,31]
["IV. ASIEN","Taiwan",166,39.2,37.5]
["IV. ASIEN","Thailand",167,39.2,42.1]
["IV. ASIEN","Turkmenistan",168,36.8,31]
["IV. ASIEN","Usbekistan",169,36.8,31]
["IV. ASIEN","Vereinigte Arabische Emirate",170,54.1,37.5]
["IV. ASIEN","Vietnam",171,31.4,31.4]
["V. AUSTRALIEN","Australien",172,47.3,39.9]
["V. AUSTRALIEN","Neuseeland",173,32.5,36.4]

{"sheet":"Versionshinweise","index":2,"n_rows":4,"n_cols":1,"rows_kept":4}
["v1 26/4/18 CH: Formeln von Klient erweitert"]
["v2 1/8/18 MW: Fehlerkorrektur in Formel für Tagesdiäten; rechnet nun korrekt für nicht volle Tage, volle Tage und Diff.taggeld; Blattschutz Passwort ist nur ein Leerzeichen; Layoutänderungen"]
["v3 14/8/18 MW: Fehlerkorrekturen, Anpassung Summen für Verbuchung"]
["v4 17/1/19 MW/CH: Spalten ausgeblendet für Nächtigungsgelder und Berechnung Tagesdiäten sowie Echtkosten bei den Fahrtkosten; Druckbereich angepasst; Änderung Kurzanleitung Punkt 4; Anpassung Summenformeln"]