{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Übersicht","Listenansicht","Sätze"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Übersicht","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Reisekosten-Formular 2016"]
[]
[]
[]
[null,"Übersicht"]
[]
[]
[null,null,null,null,null,"Euro"]
[null,"Fahrtkosten"]
[null,"Kilometerpauschale",{"$f":"Listenansicht!G7","v":10},"km",{"$f":"Listenansicht!I7","v":3}]
[null,"Öffentliche Verkehrsmittel",null,null,{"$f":"Listenansicht!L7+Listenansicht!K7+Listenansicht!J7","v":27}]
[null,"Summe Fahrtkosten",{"$f":"F12","v":30},null,null,{"$f":"SUM(E10:E11)","v":30},null,null,null,null,null,null,"Mit unserer Software wird Ihre Buchhaltung zum Kinderspiel: www.ms-buchhalter.de"]
[null,null,null,null,null,null,null,null,null,null,null,null,"http://ms-buchhalter.de/"]
[null,"Verpflegungsmehraufwand"]
[null,"eintägig > 8 Stunden",null,null,{"$f":"Listenansicht!M7","v":12}]
[null,"mehrtätig Anreisetag",null,null,{"$f":"Listenansicht!N7","v":0}]
[null,"mehrtätig Zwischentage",null,null,{"$f":"Listenansicht!P7","v":0}]
[null,"mehrtätig Abreisetag",null,null,{"$f":"Listenansicht!Q7","v":0}]
[null,"Summe Verpflegungsmehraufwand",{"$f":"F19","v":12},null,null,{"$f":"SUM(E15:E18)","v":12}]
[]
[null,"Unterbringung"]
[null,"Hotel"]
[null,"ohne Frühstück",null,null,{"$f":"Listenansicht!T7","v":45}]
[null,"Hotel"]
[null,"mit Frühstück",null,null,{"$f":"Listenansicht!V7","v":50}]
[null,"Anzahl Tage Kürzung Frühstück",null,{"$f":"Listenansicht!X7","v":1}]
[null,"Kürzung Frühstück brutto",null,null,{"$f":"Listenansicht!Y7*-1","v":-4.8000000000000007}]
[null,"Pauschale"]
[null,"Übernachtungstage",null,{"$f":"Listenansicht!Z12","v":0}]
[null,"Übernachtungspauschale",null,null,{"$f":"Listenansicht!AA7","v":0}]
[null,"Summe Unterbringung",{"$f":"F31","v":90.2},null,null,{"$f":"SUM(E21:E30)","v":90.2}]
[]
[null,"Gesamtsumme: Reisekosten",null,null,null,{"$f":"E10+E11+F19","v":42}]
[]
[]
[]
[]
[]
[]
["© 2016 Cyberlab GmbH: Mit der Benutzung der Excel-Tabelle erklären Sie sich mit unseren Nutzungsbedingungen auf einverstanden."]
["http://cyberlab-gmbh.de/agb.html"]
[]
["In Zusammenarbeit mit Steuerberater Dipl.-Kfm. Michael Schröder (www.steuerschroeder.de)"]
["Weitere Infos auf:"]
["Reisekosten"]
["Reisekosten - Dreimonatsfrist"]
["Reisekosten - Übersicht"]
["Reisekosten - Vorsteuerabzug"]
["Reisekosten im Ausland"]

{"sheet":"Listenansicht","index":1,"n_rows":8,"n_cols":28,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,25,0,26],[3,13,5,13],[3,15,5,15],[4,16,5,16],[2,27,5,27],[3,14,5,14],[2,24,5,24],[2,17,5,17],[1,25,1,26],[2,23,5,23],[2,25,5,25],[2,26,5,26],[2,21,5,21],[1,17,1,24],[2,19,5,19],[2,18,5,18],[2,20,5,20],[2,22,5,22],[0,6,0,11],[0,12,0,16],[0,17,0,24],[1,6,1,11],[1,12,1,16],[2,12,5,12],[2,13,2,16],[2,6,2,8],[2,9,2,11]]}
[null,null,null,null,null,null,"Fahrtkosten",null,null,null,null,null,"Verpflegungsmehraufwand",null,null,null,null,"Übernachtung Hotel",null,null,null,null,null,null,null,"Übern. Pauschale"]
[null,null,null,null,null,null,{"$f":"I7+L7","v":22},null,null,null,null,null,{"$f":"M7+N7+P7+Q7","v":12},null,null,null,null,{"$f":"T7+V7+Y7","v":99.8},null,null,null,null,null,null,null,{"$f":"AA7","v":0}]
[null,null,null,null,null,null,"Privat PKW",null,null,"Bus, Taxi, Bahn, Flug",null,null,"Eintägig > 8 Std.","Mehrtägig",null,null,null,"Frühstück €","mit 19% VSt.","Zimmer €","mit 7% VSt.","mit Frühstück €","mit 7% VSt.","Kürzung Tage","Kürzung €","Pauschal Tage","Pauschale Euro","Land"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Anreisetag","Zwischentage","Zwischentage €"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Abreisetag"]
["Beginn","Ende","Name","AN","Anlass","Reiseziel","km","€/km","Summe","0% VSt.","7% VSt.","19% VSt."]
[null,null,null,null,null,null,{"$f":"SUM(G8:G501)","v":10},null,{"$f":"SUM(I8:I501)","v":3},1,7,19,12,0,null,{"$f":"SUM(P8:P501)","v":0},{"$f":"SUM(Q8:Q501)","v":0},{"$f":"SUM(R8:R501)","v":5},{"$f":"SUM(S8:S501)","v":0},{"$f":"SUM(T8:T501)","v":45},null,{"$f":"SUM(V8:V501)","v":50},{"$f":"SUM(W8:W501)","v":0},1,4.8000000000000007,0,0]
["01.02.2016","01.02.2016","Max Mustermann",true,"Beruflich","Kunde 1",10,"0,30",3,1,7,19,12,null,null,null,null,5,true,45,true,50,true,1,4.8000000000000007,null,null,"Deutschland"]

{"sheet":"Sätze","index":2,"n_rows":234,"n_cols":4,"rows_kept":234,"cut":false,"hidden":true,"merged":[]}
["land","24 h","an-/ab/>8h","Üb"]
["Afghanistan ",30,20,95]
["Ägypten ",40,27,113]
["Äthiopien ",27,18,86]
["Äquatorialguinea ",36,24,166]
["Albanien ",29,20,90]
["Algerien ",39,26,190]
["Andorra ",34,23,45]
["Angola ",77,52,265]
["Antigua und Barbuda ",53,36,117]
["Argentinien ",34,23,144]
["Armenien ",23,16,63]
["Aserbaidschan ",40,27,120]
["Australien – Canberra ",58,39,158]
["Australien – Sydney ",59,40,186]
["Australien – im Übrigen ",56,37,133]
["Bahrain ",45,30,180]
["Bangladesch ",30,20,111]
["Barbados ",58,39,179]
["Belgien ",41,28,135]
["Benin ",40,27,101]
["Bolivien ",24,16,70]
["Bosnien und Herzegowina ",18,12,73]
["Botsuana ",40,27,102]
["Brasilien – Brasilia ",53,36,160]
["Brasilien – Rio de Janeiro ",47,32,145]
["Brasilien – Sao Paulo ",53,36,120]
["Brasilien – im Übrigen ",54,36,110]
["Brunei ",48,32,106]
["Bulgarien ",22,15,90]
["Burkina Faso ",44,29,84]
["Burundi ",47,32,98]
["Chile ",40,27,130]
["China – Chengdu ",35,24,105]
["China – Hongkong ",74,49,145]
["China – Peking ",46,31,142]
["China – Shanghai ",50,33,128]
["China – im Übrigen ",40,27,113]
["Costa Rica ",36,24,69]
["Côte d’Ivoire ",51,34,146]
["Dänemark ",60,40,150]
["Deutschland",24,12,20]
["Dominica ",40,27,94]
["Dominikanische Republik ",40,27,71]
["Dschibuti ",48,32,160]
["Ecuador ",39,26,55]
["El Salvador ",44,29,119]
["Eritrea ",46,31,81]
["Estland ",27,18,71]
["Fidschi ",32,21,57]
["Finnland ",39,26,136]
["Frankreich – Lyon",53,36,83]
["Frankreich – Marseille ",51,34,86]
["Frankreich – Paris sowie die Departments 92, 93 und 94 ",58,39,135]
["Frankreich – Straßburg ",48,32,89]
["Frankreich – im Übrigen ",44,29,81]
["Gabun ",62,41,278]
["Gambia ",30,20,125]
["Georgien ",30,20,80]
["Ghana ",46,31,174]
["Grenada ",51,34,121]
["Griechenland – Athen ",57,38,125]
["Griechenland – im Übrigen ",42,28,132]
["Guatemala ",28,19,96]
["Guinea ",38,25,110]
["Guinea-Bissau ",24,16,86]
["Guyana ",41,28,81]
["Haiti ",50,33,111]
["Honduras ",44,29,104]
["Indien – Chennai ",34,23,87]
["Indien – Kalkutta ",41,28,117]
["Indien – Mumbai ",32,21,125]
["Indien – Neu Delhi ",50,33,144]
["Indien – im Übrigen ",36,24,145]
["Indonesien ",38,25,130]
["Iran ",28,19,84]
["Irland ",44,29,92]
["Island ",47,32,108]
["Israel ",56,37,191]
["Italien – Mailand ",39,26,156]
["Italien – Rom ",52,35,160]
["Italien – im Übrigen ",34,23,126]
["Jamaika ",54,36,135]
["Japan – Tokio ",53,36,153]
["Japan– im Übrigen ",51,34,156]
["Jemen ",24,16,95]
["Jordanien ",36,24,85]
["Kambodscha ",36,24,85]
["Kamerun ",40,27,130]
["Kanada – Ottawa ",35,24,110]
["Kanada – Toronto ",52,35,142]
["Kanada – Vancouver ",48,32,106]
["Kanada – im Übrigen ",44,29,111]
["Kap Verde ",30,20,105]
["Kasachstan ",39,26,109]
["Katar ",56,37,170]
["Kenia ",42,28,223]
["Kirgisistan ",29,20,91]
["Kolumbien ",41,28,126]
["Kongo, Republik ",50,33,200]
["Kongo, Demokratische Republik ",68,45,171]
["Korea, Demokratische Volksrepublik ",39,26,132]
["Korea, Republik ",58,39,112]
["Kosovo ",26,17,65]
["Kroatien ",28,19,75]
["Kuba ",50,33,85]
["Kuwait ",42,28,185]
["Laos ",33,22,67]
["Lesotho ",24,16,103]
["Lettland ",30,20,80]
["Libanon ",44,29,120]
["Libyen ",45,30,100]
["Liechtenstein ",53,36,180]
["Litauen ",24,16,68]
["Luxemburg ",47,32,102]
["Madagaskar ",38,25,83]
["Malawi ",47,32,123]
["Malaysia ",36,24,100]
["Malediven ",38,25,93]
["Mali ",41,28,122]
["Malta ",45,30,112]
["Marokko ",42,28,105]
["Marshall Inseln ",63,42,70]
["Mauretanien ",39,26,105]
["Mauritius ",48,32,140]
["Mazedonien ",24,16,95]
["Mexiko ",41,28,141]
["Mikronesien ",56,37,74]
["Moldau, Republik ",18,12,100]
["Monaco ",41,28,52]
["Mongolei ",29,20,84]
["Montenegro ",29,20,95]
["Mosambik ",42,28,147]
["Myanmar ",46,31,45]
["Namibia ",23,16,77]
["Nepal ",28,19,86]
["Neuseeland ",47,32,98]
["Nicaragua ",36,24,81]
["Niederlande ",46,31,119]
["Niger ",36,24,70]
["Nigeria ",63,42,255]
["Norwegen ",64,43,182]
["Österreich ",36,24,104]
["Oman ",48,32,120]
["Pakistan – Islamabad ",30,20,165]
["Pakistan – im Übrigen ",27,18,68]
["Palau ",51,34,166]
["Panama ",34,23,101]
["Papua-Neuguinea ",36,24,90]
["Paraguay ",36,24,61]
["Peru ",30,20,93]
["Philippinen ",30,20,107]
["Polen – Breslau ",33,22,92]
["Polen – Danzig ",29,20,77]
["Polen – Krakau ",28,19,88]
["Polen – Warschau ",30,20,105]
["Polen – im Übrigen ",27,18,50]
["Portugal ",36,24,92]
["Ruanda ",46,31,141]
["Rumänien – Bukarest ",26,17,100]
["Rumänien – im Übrigen ",27,18,80]
["Russische Föderation – Moskau ",30,20,118]
["Russische Föderation – St. Petersburg ",24,16,104]
["Russische Föderation – im Übrigen ",21,14,78]
["Sambia ",36,24,95]
["Samoa ",29,20,57]
["São Tomé – Príncipe ",42,28,75]
["San Marino ",41,28,77]
["Saudi-Arabien – Djidda ",38,25,234]
["Saudi-Arabien – Riad ",48,32,179]
["Saudi-Arabien – im Übrigen ",48,32,80]
["Schweden ",50,33,168]
["Schweiz – Genf ",64,43,195]
["Schweiz – im Übrigen ",62,41,169]
["Senegal ",45,30,128]
["Serbien ",30,20,90]
["Sierra Leone ",39,26,82]
["Simbabwe ",45,30,103]
["Singapur ",53,36,188]
["Slowakische Republik ",24,16,130]
["Slowenien ",30,20,95]
["Spanien – Barcelona ",32,21,118]
["Spanien – Kanarische Inseln ",32,21,98]
["Spanien – Madrid ",41,28,113]
["Spanien – Palma de Mallorca ",32,21,110]
["Spanien – im Übrigen ",29,20,88]
["Sri Lanka ",40,27,118]
["St. Kitts und Nevis ",45,30,99]
["St. Lucia ",54,36,129]
["St. Vincent und die Grenadinen ",52,35,121]
["Sudan ",35,24,115]
["Südafrika – Kapstadt ",27,18,112]
["Südafrika – Johannisburg ",29,20,124]
["Südafrika – im Übrigen ",22,15,94]
["Südsudan ",53,36,114]
["Suriname ",41,28,108]
["Syrien ",38,25,140]
["Tadschikistan ",26,17,67]
["Taiwan ",39,26,110]
["Tansania ",47,32,201]
["Thailand ",32,21,120]
["Togo ",35,24,108]
["Tonga ",32,21,36]
["Trinidad und Tobago ",54,36,164]
["Tschad ",47,32,151]
["Tschechische Republik ",24,16,97]
["Türkei – Istanbul ",35,24,104]
["Türkei – Izmir ",42,28,80]
["Türkei – im Übrigen ",40,27,78]
["Tunesien ",33,22,80]
["Turkmenistan ",33,22,108]
["Uganda ",35,24,129]
["Ukraine ",36,24,85]
["Ungarn ",30,20,75]
["Uruguay ",44,29,109]
["Usbekistan ",34,23,123]
["Vatikanstaat ",52,35,160]
["Venezuela ",48,32,207]
["Vereinigte Arabische Emirate ",45,30,155]
["Vereinigte Staaten von Amerika (USA)"]
["USA – Atlanta ",57,38,122]
["USA – Boston ",48,32,206]
["USA – Chicago ",48,32,130]
["USA – Houston ",57,38,136]
["USA – Los Angeles ",48,32,153]
["USA – Miami ",57,38,102]
["USA – New York City ",48,32,215]
["USA – San Francisco ",48,32,110]
["USA – Washington, D. C. ",57,38,205]
["USA – im Übrigen ",48,32,102]
["Vereinigtes Königreich von Großbritannien und Nordirland"]
["England – London ",62,41,224]
["England – im Übrigen ",45,30,115]
["Vietnam ",38,25,86]