{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["daily_allowances_2024","list of daily allowances 2024","example"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"daily_allowances_2024","index":0,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,15],[2,1,2,6],[17,0,17,6],[25,0,25,15],[26,0,26,15],[27,0,27,15]]}
["Attachment to \"Clearance of travel costs (Reisekostenabrechnung)\":",null,null,null,null,null,null,"Daily Allowance 2024"]
[]
["Traveller"]
[]
["date of travel (DD.MM.YY)1)"]
["place of business2)"]
["daily allowance3)"]
["8-24 hrs (80 %)4)"]
["≥ 24 hrs (100 %)4)"]
["subtotal",{"$f":"IF(B8+B9>1,\"FEHLER\",IF(C7>0,IF(B6=\"D\",14+B9*14,B7*0.8+B9*B7*0.2),IF(B6=\"D\",14*B8+28*B9,(B8*0.8+B9)*B7)))","v":0},{"$f":"IF(C8+C9>1,\"FEHLER\",IF(AND(C8>0,D5=C5+1),\"FEHLER\",IF(AND(C8+C9=0,D5-1>C5),\"FEHLER\",IF(AND(C9=0,D5=C5+1),\"FEHLER\",IF(D7=0,IF(C6=\"D\",14+(C9*14),C7*0.8+C9*C7*0.2),IF(C6=\"D\",14*C8+28*C9,(C8*0.8+C9)*C7))))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["breakfast (20 %)5)"]
["lunch (40 %)5)"]
["dinner (40 %)5)"]
["cut-off amount",{"$f":"B7*(0.2*B11+0.4*B12+0.4*B13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["net pay",{"$f":"IF((B10-B14)<0,0,(B10-B14))","v":0},{"$f":"IF((C10-C14)<0,0,(C10-C14))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["final net pay:",{"$f":"SUM(B15:P15)","v":0}]
[]
[]
[null,"(place, date and signature)"]
[]
["1) Please list only business travel days, i.e. no private travel days"]
["2) Please fill in either \"D\" or \"d\" for Germany or the name of your international place of business. Acc. para 4.3 (3) of sequa's travel guideline the place of business has to be determined as follows:"]
["    - travel time touches 1 calendar only: On the outward trip, place of business is the place reached before midnight. On the return trip place of business of the place where you have finished your business before travelling home."]
["    - 2 consecutive travel days: On the day of departure \"place of business\" is the place of departure. On the day of arrival \"place of business\" is the final business (or home) destination, reached before midnight."]
["    - more than 2 consecutive travel days: On the day between day of departure and day of arrival \"place of business\" is Austria."]
["3) Please fill in the amount of the daily allowance. You find the respective amount in the country list of the daily allowances. Please make sure that you use the correct list since each list is valid for a specific \n"]
["   calender year, only. Please use the list that is applicable for your travel period. Starting on the 15th day of stay at the same international (domestic) place of business the daily allowance has to be reduced "]
["   by 10 % (50 %). The day of arrival is NOT to be counted as a day of stay."]
["4) Please mark relevant period of absence with \"1\". Remark: special regulation for Germany: an one-day trip in Germany (>8 h) results in a daily allownace of 14,00 EUR"]
["   In case of at least 2 consecutive travel days: On the day of departure and on the day of return a lumpsum  will be paid - not depending on your real travel time."]
["   (Germany: € 14,- other countries:80 % of full daily allowance of your international place of business)"]
["5) Please mark with \"1\", if you have enjoyed meals for free (also on flights), even if the final net pay is 0.\n  \n   "]

{"sheet":"list of daily allowances 2024","index":1,"n_rows":252,"n_cols":4,"rows_kept":252,"cut":false,"hidden":false,"merged":[[248,0,248,2],[249,0,249,2],[250,0,250,2],[251,0,251,2],[252,0,252,2]]}
["place of business","daily allowance \nacc. to BRKG \nin EUR","max. amount \nin EUR \nfor accomodation  \n(against receipt*)","lump-sum amount \nin EUR \nfor accomodation  \n(w/o receipt)"]
["Germany",28,70,20]
[]
["place of business","daily allowance \nacc. to ARV \nin EUR","max. amount \nin EUR \nfor accomodation  \n(against receipt*)","lump-sum amount \nin EUR \nfor accomodation  \n(w/o receipt)"]
["Afghanistan",25,95,{"$f":"IF(C5> 60, 30,C5*0.5)","v":30}]
["Ägypten",41,112,{"$f":"IF(C6> 60, 30,C6*0.5)","v":30}]
["Albanien",22,112,{"$f":"IF(C7> 60, 30,C7*0.5)","v":30}]
["Algerien",39,120,{"$f":"IF(C8> 60, 30,C8*0.5)","v":30}]
["Andorra",34,91,30]
["Angola",43,299,30]
["Äquatorialguinea",35,166,{"$f":"IF(C11> 60, 30,C11*0.5)","v":30}]
["Argentinien",29,113,30]
["Armenien",20,59,29.5]
["Aserbaidschan",36,88,30]
["Äthiopien",32,130,{"$f":"IF(C15> 60, 30,C15*0.5)","v":30}]
["Australien"]
["- Canberra",61,186,30]
["- Sydney",47,173,30]
["- im Übrigen",47,173,30]
["Bahrain",40,153,30]
["Bangladesch",41,165,30]
["Barbados",45,206,30]
["Belgien",49,141,30]
["Benin",43,115,30]
["Bolivien",38,108,30]
["Bosnien und Herzegowina",19,75,30]
["Botsuana",38,176,30]
["Brasilien"]
["- Brasilia",42,88,30]
["- Rio de Janeiro",57,140,30]
["- Sao Paulo",38,151,30]
["- im Übrigen",38,88,30]
["Brunei",43,106,30]
["Bulgarien",18,115,30]
["Burkina Faso",31,174,30]
["Burundi",30,138,30]
["Chile",36,154,30]
["China"]
["- Chengdu",34,131,30]
["- Hongkong",59,169,30]
["- Kanton",30,150,{"$f":"IF(C41> 60, 30,C41*0.5)","v":30}]
["- Peking",25,185,30]
["- Shanghai",48,217,30]
["- im Übrigen",40,112,30]
["Costa Rica",39,93,30]
["Côte d'Ivoire",49,166,30]
["Dänemark",62,183,30]
["Dominikanische Republik",41,167,30]
["Dschibuti",64,255,30]
["Ecuador",22,103,30]
["El Salvador",54,161,30]
["Eritrea",41,91,30]
["Estland",24,85,30]
["Fidschi",26,183,30]
["Finnland",45,171,30]
["Frankreich"]
["- Paris sowie die Départements der Ile de France**",48,159,30]
["- im Übrigen",44,105,30]
["Gabun",43,183,30]
["Gambia",33,161,30]
["Georgien",37,87,30]
["Ghana",38,148,30]
["Griechenland"]
["- Athen",33,139,{"$f":"IF(C64> 60, 30,C64*0.5)","v":30}]
["- im Übrigen",30,150,30]
["Guatemala",28,90,30]
["Guinea",49,140,30]
["Guinea-Bissau",26,113,30]
["Haiti",48,130,30]
["Honduras",47,198,30]
["Indien"]
["- Chennai",26,85,30]
["- Kalkutta",29,145,30]
["- Mumbai",41,146,30]
["- Neu Dehli",31,185,30]
["- im Übrigen",26,85,30]
["Indonesien",30,134,30]
["Iran",27,196,30]
["Irland",48,129,30]
["Island",51,187,30]
["Israel",55,190,30]
["Italien"]
["- Mailand",35,191,30]
["- Rom***",40,150,30]
["- im Übrigen",35,150,30]
["Jamaika",32,171,30]
["Japan"]
["- Tokio",41,285,30]
["- im Übrigen",43,190,30]
["Jemen",20,95,30]
["Jordanien",47,134,30]
["Kambodscha",31,94,30]
["Kamerun",46,275,30]
["Kanada"]
["- Ottawa",51,214,30]
["- Toronto",45,392,30]
["- Vancouver",52,304,30]
["- im Übrigen",45,214,30]
["Kap Verde",31,90,30]
["Kasachstan",37,111,30]
["Katar",46,149,30]
["Kenia",42,219,30]
["Kirgisistan",22,74,30]
["Kolumbien",38,115,30]
["Kongo, Demokratische Republik",58,190,{"$f":"IF(C105> 60, 30,C105*0.5)","v":30}]
["Kongo, Republik",51,215,30]
["Korea Demokratische Volksrepublik",23,92,30]
["Korea, Republik",40,108,30]
["Kosovo",20,71,30]
["Kroatien",29,107,30]
["Kuba",42,170,30]
["Kuwait",46,241,30]
["Laos",29,71,30]
["Lesotho",23,104,30]
["Lettland",29,76,30]
["Libanon",57,146,30]
["Libyen",52,135,30]
["Liechtenstein",46,190,30]
["Litauen",21,109,30]
["Luxemburg",52,139,30]
["Madagaskar",27,116,30]
["Malawi",34,109,30]
["Malaysia",30,86,30]
["Malediven",43,170,30]
["Mali",31,120,30]
["Malta",38,114,30]
["Marokko",34,87,30]
["Marschall Inseln",52,102,{"$f":"IF(C128> 60, 30,C128*0.5)","v":30}]
["Mauretanien",29,86,30]
["Mauritius",36,172,30]
["Mexiko",40,177,30]
["Moldau, Republik",21,73,30]
["Monaco",43,187,30]
["Mongolai",19,92,30]
["Montenegro",26,85,30]
["Mosambik",42,208,30]
["Myanmar",29,155,30]
["Namibia",25,112,30]
["Nepal",30,126,30]
["Neuseeland",48,148,30]
["Nicaragua",38,105,30]
["Niederlande",39,122,30]
["Niger",35,131,30]
["Nigeria",38,182,30]
["Nordmazedonien",22,89,30]
["Norwegen",62,139,30]
["Oman",53,141,{"$f":"IF(C147> 60, 30,C147*0.5)","v":30}]
["Österreich",41,117,30]
["Pakistan"]
["- Islamabad",19,238,30]
["- im Übrigen",28,122,30]
["Palau",42,179,30]
["Panama",34,82,30]
["Papua-Neuguinea",49,159,30]
["Paraguay",32,124,30]
["Peru",28,143,30]
["Philippinen ****",34,140,30]
["Polen"]
["- Breslau",27,117,30]
["- Danzig",25,84,30]
["- Krakau",22,86,30]
["- Warschau",24,109,30]
["- im Übrigen",24,60,30]
["Portugal",26,111,30]
["Ruanda",36,117,30]
["Rumänien"]
["- Bukarest",26,92,30]
["- im Übrigen",22,89,30]
["Russische Föderation"]
["- Jekaterinburg",23,84,30]
["- Moskau",25,110,{"$f":"IF(C171> 60, 30,C171*0.5)","v":30}]
["- St. Petersburg",21,114,30]
["- im Übrigen",20,58,29]
["Sambia",31,105,30]
["Samoa",32,105,30]
["San Marino",28,79,{"$f":"IF(C176> 60, 30,C176*0.5)","v":30}]
["Sao Tomé und  Principe",39,80,30]
["Saudi Arabien"]
["- Djidda",47,181,30]
["- Riad",46,186,30]
["- im Übrigen",46,181,30]
["Schweden",55,140,30]
["Schweiz"]
["- Genf",55,186,30]
["- im Übrigen",53,180,30]
["Senegal",35,190,30]
["Serbien",22,97,30]
["Sierra Leone",47,145,30]
["Simbabwe",37,140,30]
["Singapur",45,197,30]
["Slowakische Republik",27,121,30]
["Slowenien",31,126,30]
["Spanien"]
["- Barcelona",28,144,30]
["- Kanarische Inseln",30,103,30]
["- Madrid",35,131,{"$f":"IF(C196> 60, 30,C196*0.5)","v":30}]
["- Palma de Mallorca",36,142,30]
["- im Übrigen",28,103,30]
["Sri Lanka",30,112,30]
["Sudan",27,195,30]
["Südafrika"]
["- Kapstadt",27,130,30]
["- Johannesburg",30,129,{"$f":"IF(C203> 60, 30,C203*0.5)","v":30}]
["- im Übrigen",24,109,30]
["Südsudan",42,159,30]
["Syrien",31,140,30]
["Tadschikistan",22,118,30]
["Taiwan",38,143,30]
["Tansania",36,97,30]
["Thailand",31,110,30]
["Togo",32,118,30]
["Tonga",32,94,30]
["Trinidad und Tobago *****",55,203,30]
["Tschad",35,155,30]
["Tschechische Republik",26,77,30]
["Türkei"]
["- Istanbul",21,120,30]
["- Izmir",24,55,27.5]
["- im Übrigen",14,95,30]
["Tunesien",33,144,30]
["Turkmenistan",27,108,30]
["Uganda",34,143,30]
["Ukraine",21,98,30]
["Ungarn",26,85,30]
["Uruguay",40,90,30]
["Usbekistan",28,104,30]
["Venezuela",37,127,30]
["Vereinigte Arabische Emirate",54,156,30]
["Vereinigte Staaten von Amerika (USA)"]
["- Atlanta",64,182,30]
["- Boston",52,333,30]
["- Chicago",54,233,30]
["- Houston",51,204,30]
["- Los Angeles",53,262,30]
["- Miami",54,256,30]
["- New York City",55,308,30]
["- San Francisco",49,327,30]
["- Washington D.C.",55,203,30]
["- im Übrigen",49,182,30]
["Vereinigtes Königreich von Großbritannien und Nordirland"]
["- London",55,163,30]
["- im Übrigen",43,99,30]
["Vietnam",34,86,30]
["Weißrussland",16,98,30]
["Zentralafrikanische Republik",44,210,30]
["Zypern",35,125,30]
[]
["* Reimbursement of higher amounts is possible; however, the necessity must be justified in each individual case."]
["** These include the departments of 75-Paris, 77 -Seine-et-Marne,\n    78-Yvelines, 91-l'Essonne, 92-Hauts-de-Seine\n    93-Seine-Saint-Denis, 94-Val-de-Marne, 95-Val-d'Oise"]
["***   The amounts set for Rom also apply to Vatican City."]
["****  The amounts set for the Philippines also apply to Micronesia."]
["***** The amounts fixed for Trinidad and Tobago shall also apply to the States of Antigua and Barbuda,\n       Dominica, Grenada, Guyana, Saint Kitts and Nevis, Saint Lucia, Saint Vincent and the Grenadines and\n       Suriname, which are art of its jurisdiction."]

{"sheet":"example","index":2,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,6],[31,0,31,15],[26,0,26,15],[27,0,27,15]]}
["Attachment to \"Clearance of travel costs (Reisekostenabrechnung)\":",null,null,null,null,null,null,"Daily Allowance 2024"]
[]
["Traveller","Max Mustermann"]
[]
["date of travel (DD.MM.YY)1)","2024-01-01","2024-01-02","2024-01-03","2024-01-04","2024-01-05","2024-01-06","2024-01-08","2024-01-09","2024-01-10","2024-01-11","2024-01-12"]
["place of business2)","d","San Marino","Chisinev / Moldau","New York","New York","San Francisco","San Francisco","Hawai","Hawai","Austria","d"]
["daily allowance3)",28,28,21,55,55,49,49,49,49,41,28]
["8-24 hrs (80 %)4)",null,null,null,null,null,1]
["≥ 24 hrs (100 %)4)",null,1,1,1,1,null,1,1,1,1]
["subtotal",{"$f":"IF(B8+B9>1,\"FEHLER\",IF(C7>0,IF(B6=\"D\",14+B9*14,B7*0.8+B9*B7*0.2),IF(B6=\"D\",14*B8+28*B9,(B8*0.8+B9)*B7)))","v":14},{"$f":"IF(C8+C9>1,\"FEHLER\",IF(AND(C8>0,D5=C5+1),\"FEHLER\",IF(AND(C8+C9=0,D5-1>C5),\"FEHLER\",IF(AND(C9=0,D5=C5+1),\"FEHLER\",IF(D7=0,IF(C6=\"D\",14+(C9*14),C7*0.8+C9*C7*0.2),IF(C6=\"D\",14*C8+28*C9,(C8*0.8+C9)*C7))))))","v":28},21,55,55,39.200000000000003,49,49,49,41,14,0,0,0,0]
["breakfast (20 %)5)",null,1,1,null,1,1,1,1,1,1,1]
["lunch (40 %)5)",null,null,1,1,null,null,null,null,null,1]
["dinner (40 %)5)",1,1,null,1,null,null,1,null,1,1]
["cut-off amount",{"$f":"B7*(0.2*B11+0.4*B12+0.4*B13)","v":11.200000000000001},16.800000000000004,12.600000000000001,44,11,9.8000000000000007,29.400000000000006,9.8000000000000007,29.400000000000006,41,5.6000000000000005,0,0,0,0]
["net pay",{"$f":"IF((B10-B14)<0,0,(B10-B14))","v":2.7999999999999989},{"$f":"IF((C10-C14)<0,0,(C10-C14))","v":11.199999999999996},8.3999999999999986,11,44,29.400000000000002,19.599999999999994,39.200000000000003,19.599999999999994,0,8.3999999999999986,0,0,0,0]
["final net pay:",{"$f":"SUM(B15:P15)","v":193.6}]
[]
["Bonn, 16.07.2024"]
[null,"(place, date and signature)"]
[]
["1) Please list only business travel days, i.e. no private travel days"]
["2) Please fill in either \"D\" or \"d\" for Germany or the name of your international place of business. Acc. para 4.3 (3) of sequa's travel guideline the place of business has to be determined as follows:"]
["    - travel time touches 1 calendar only: On the outward trip, place of business is the place reached before midnight. On the return trip place of business of the place where you have finished your business before travelling home."]
["    - 2 consecutive travel days: On the day of departure \"place of business\" is the place of departure. On the day of arrival \"place of business\" is the final business (or home) destination, reached before midnight."]
["    - more than 2 consecutive travel days: On the day between day of departure and day of arrival \"place of business\" is Austria."]
["3) Please fill in the amount of the daily allowance. You find the respective amount in the country list of the daily allowances. Please make sure that you use the correct list since each list is valid for a specific "]
["   calender year, only. Please use the list that is applicable for your travel period. Starting on the 15th day of stay at the same international (domestic) place of business the daily allowance has to be reduced "]
["   by 10 % (50 %). The day of arrival is NOT to be counted as a day of stay."]
["4) Please mark relevant period of absence with \"1\". Remark: special regulation for Germany: an one-day trip in Germany (>8 h) results in a daily allownace of 14,00 EUR"]
["   In case of at least 2 consecutive travel days: On the day of departure and on the day of return a lumpsum will be paid - not depending on your real travel time."]
["   (Germany: € 14,- other countries:80 % of full daily allowance of your international place of business)"]
["5) Please mark with \"1\", if you have enjoyed meals for free (also on flights), even if the final net pay is 0.\n  \n   "]