{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Reisekostenantrag","Reisekostenabrechnung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Reisekostenantrag","index":0,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Name, Vorname:"]
[]
["I. Dienstreiseantrag"]
[]
["Zweck der Dienstreise:"]
[]
[]
["am / vom - bis:"]
[]
["Zielort:"]
[]
["Name(n) der mitfahrenden Person(en)"]
[]
[]
["Beförderung mit:",null,null,null,null,"Zwingende Gründe für die Benutzung "]
[null,"Bundesbahn",null,null,null,"des privaten Pkw:"]
[null,"Dienst-Pkw",null,null,null,null,"  Keine oder schlechte Verkehrsverbindungen"]
[null,"Privat-Pkw",null,null,null,null,"  Mitnahme umfangreichen Gepäcks"]
[null,"Mitfahrt Privat-/Dienst-Pkw",null,null,null,null,"  Mitnahme von mindestens einem Mitarbeiter"]
[null,"Sonstiges",null,null,null,null,"  Aufsuchen mehrerer Stellen am Geschäftsort"]
[]
[]
["(Ort),",null,null,"(Datum)"]
[null,null,null,null,null,null,"Unterschrift"]
[]
["II. Erteilung der Genehmigung"]
[]
["Genehmigung:"]
[null,"Dienstreise genehmigt"]
[null,"Benutzung des privaten Pkw angeordnet"]
[null,"Zwingende Gründe anerkannt"]
[null,"Bericht ist vorzulegen"]
[]
["(Ort)",null,null,{"$f":"D25","v":"(Datum)"}]
[null,null,null,null,null,null,"Unterschrift des Anordnenden"]
[]
["III. Kostenzusammenstellung"]
[null,null,null,"Datum","Uhrzeit",null," Fahrtkosten",null,null,"€"]
["Reisebeginn:",null,null,null,null,null," Wegstrecken",null,null,"km"]
["Reiseende:",null,null,null,null,null," Unterbringungskosten",null,null,"€"]
[null,null,null,null,null,null," Nebenkosten",null,null,"€"]
[]
[" unentgeltliches Frühstück am / vom – bis"]
[" unentgeltliches Mittagessen am / vom – bis"]
[" unentgeltliches Abendessen am / vom – bis"]
[" unentgeltliche Unterkunft am / vom – bis"]
[null,"Übernahme der Teilnahmegebühren/Verpflegung/Unterkunft durch den Dienstgeber"]
[]
[" 1.","Ich versichere pflichtgemäß die Richtigkeit meiner Angaben."]
[" 2.","Die eingesetzten Kosten sind mir wirklich entstanden.",null,null,null,null,null,"*","Belege bitte"]
[" 3.","Hinweis auf Mängel am Dienstfahrzeug.",null,null,null,null,null,null,"beifügen"]
[]
[]
["(Ort),",null,null,{"$f":"Reisekostenabrechnung!K55","v":""}]
[null,null,null,null,null,null,"Unterschrift"]

{"sheet":"Reisekostenabrechnung","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,10,57,11]]}
[null,"Reisekostenabrechnung"]
[null,null,null,null,null,null,null,null,null,null,null,"Betrag €"]
[null,"Name, Vorname:"]
[]
[null,null,null,"Datum","Uhrzeit",null,null,null,null,"Datum","Uhrzeit"]
[null,"Reisebeginn:",null,"00.01.2013",{"$f":"Reisekostenantrag!E41","v":"00:00:00"},null," Reiseende:",null,null,"00.01.2013",{"$f":"Reisekostenantrag!E42","v":"00:00:00"}]
[]
[null,"Reiseziel:",null,{"$f":"Reisekostenantrag!E12","v":0}]
[]
[null,"Reisezweck:",null,{"$f":"Reisekostenantrag!E7","v":0}]
[]
[]
[null,"Verpflegungskosten:"]
[null,true]
[]
[null,null,"Datum","Stunden","Tagessatz","Unentgeltliche Verpflegung",null,null,null,"Kürzung Tagessatz","Tagessatz"]
[null,null,null,null,null,null,"F  ","M","A"]
[null,null,{"$f":"IF(B14=TRUE,D6,\"\")","v":"00.01.2013"},{"$f":"IF(C18=\"\",\"\",IF(J6=D6,K6-E6,\"24:00\"-E6))","v":"00:00:00"},null,null,false,false,false,null,{"$f":"E18-J18","v":0}]
[null,null,{"$f":"IF(B14=TRUE,IF(J6>D6,D6+1,\"\"),\"\")","v":""},{"$f":"IF(C19=\"\",\"\",IF(J6=C19,K6,\"24:00\"))","v":""},null,null,false,false,false,null,{"$f":"E19-J19","v":0}]
[null,null,{"$f":"IF(J6>C19,C19+1,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C20=\"\",\"\",IF(J6=C20,K6,\"24:00\"))","v":{"$error":"#VALUE!"}},null,null,false,false,false,null,{"$f":"E20-J20","v":0}]
[null,null,{"$f":"IF(J6>C20,C20+1,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C21=\"\",\"\",IF(J6=C21,K6,\"24:00\"))","v":{"$error":"#VALUE!"}},null,null,false,false,false,null,{"$f":"E21-J21","v":0}]
[null,null,{"$f":"IF(J6>C21,C21+1,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C22=\"\",\"\",IF(J6=C22,K6,\"24:00\"))","v":{"$error":"#VALUE!"}},null,null,false,false,null,null,{"$f":"E22-J22","v":0},{"$f":"IF(B14=TRUE,SUM(K18:K22),\"\")","v":0}]
[null,null,"  Abwesenheit",null,null,null,"abzüglich unentgeltliche Verpflegung"]
[null,null,"  mindestens 8 Stunden",null,6,null,"Frühstück Sachbezug",null,null,null,1.4]
[null,null,"  mindestens 14 Stunden",null,12,null,"Mittagessen 35 %",null,null,"mind.",2.5099999999999998]
[null,null,"  24 Stunden",null,24,null,"Abendessen 35 %",null,null,"mind.",2.5099999999999998]
[]
[]
[]
[]
[null,"Fahrtkosten:"]
[null,false,"lt. Belegen (s. Anlage)",null,null,null,null,null,null,null,{"$f":"Reisekostenantrag!I40","v":0},{"$f":"IF(B32=TRUE,IF(K32=\"\",\"\",K32),\"\")","v":""}]
[]
[null,false,"pauschales km-Geld",null,null,null,{"$f":"Reisekostenantrag!I41","v":0}," km à",null,0.35,{"$f":"IF(G34=\"\",\"\",G34*J34)","v":0}]
[null,null,"ggf. Anzahl und Namen",null,null,null,null," Anz. à",null,0.02,{"$f":"IF(G35=\"\",\"\",G34*J35*G35)","v":""},{"$f":"IF(B34=TRUE,IF(K34=\"\",\"\",SUM(K34:K35)),\"\")","v":""}]
[null,null,"der Mitfahrer"]
[]
[]
[]
[]
[]
[null,"Unterbringungskosten:"]
[null,false,"lt. Belegen (s.Anlage)",null,null,null,null,null,null,null,{"$f":"Reisekostenantrag!I42","v":0},{"$f":"IF(B43=TRUE,IF(K43=\"\",\"\",K43),\"\")","v":""}]
[]
[null,null,"Übernachtungen pauschal",null,null,null,null,{"$f":"\"Anz. à\"","v":"Anz. à"},null,20]
[]
[]
[null,"Nebenkosten"]
[null,false,"lt. Belegen (s. Anlage)",null,null,null,null,null,null,null,{"$f":"Reisekostenantrag!I43","v":0},{"$f":"IF(B49=TRUE,IF(K49=\"\",\"\",K49),\"\")","v":""}]
[]
[null,false,"ohne Beleg für",null,null,null,null,null,null,null,null,{"$f":"IF(B51=TRUE,IF(K51=\"\",\"\",K51),\"\")","v":""}]
[]
[null,"Empfangsbestätigung",null,null,null,null,null,null,null,null,"Gesamt:",{"$f":"IF(SUM(L3:L52)=0,\"\",SUM(L3:L52))","v":""}]
[null,"Hiermit bestätige ich den Empfang der mir nach der"]
[null,"Reisekostenabrechnung zustehenden Reisekosten",null,null,null,null,null,null,"(Ort),",null,{"$f":"IF(L53=\"\",\"\",TODAY())","v":""}]
[null,"in Höhe von",null,{"$f":"L53","v":""},"€."]
[null,null,null,null,null,null,null,null,"   Festgestellt:"]
[null,"(Ort),",null,{"$f":"IF(L53=\"\",\"\",TODAY())","v":""},null,null,null,null,null,null,"Unterschrift"]
[]
[null,null,null,null,null,null,null,null,"   Sachlich richtig:"]
[null,null,null,"Unterschrift",null,null,null,null,null,null,"Unterschrift"]