{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Antrag Reisekostenerstattung"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Antrag Reisekostenerstattung","index":0,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[31,1,31,2],[33,1,33,2],[31,4,31,12],[33,4,33,12],[40,3,40,6],[40,8,40,14],[38,3,38,14],[32,1,32,2],[35,13,35,14],[39,3,39,14],[44,3,44,6],[44,8,44,14],[45,1,45,14],[43,3,43,6],[43,7,43,14],[17,18,17,20],[18,18,18,20],[32,4,32,12],[27,4,27,5],[27,7,27,10],[27,11,27,12],[26,4,26,5],[26,7,26,10],[26,11,26,12],[17,17,22,17],[19,6,19,7],[19,18,19,20],[20,18,20,20],[19,11,19,12],[25,4,25,5],[20,6,20,7],[1,11,1,14],[2,11,2,14],[5,11,5,14],[9,2,9,4],[9,8,9,10],[3,12,3,14],[7,2,7,6],[7,8,7,14],[8,2,8,14],[21,18,21,20],[24,4,24,5],[28,4,28,5],[28,7,28,10],[22,18,22,20],[23,13,23,14],[24,18,24,21],[30,13,30,14],[18,13,18,14],[12,13,12,14],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[20,11,20,12],[21,11,21,12],[24,11,24,12],[25,11,25,12],[28,11,28,12]]}
[]
[{"$nulls":10},"Antragssteller/-in"]
[{"$nulls":10},"Straße"]
[{"$nulls":10},"PLZ, Ort"]
[]
[null,"Antrag auf Reisekostenerstattung",{"$nulls":8},"Datum"]
[]
[null,"von",{"$nulls":5},"nach (via)"]
[null,"zwecks"]
[null,"vom",null,null,null,"um",null,"Uhr bis",null,null,null,"um",null,"Uhr (Reiseende)"]
[null,null,"T.M.JJ",null,null,null,"h:m",null,"T.M.JJ",null,null,null,"h:m"]
[]
[null,"1. Tagegeld",{"$nulls":11},{"$f":"SUM(L14:L17)","v":0}]
[null,"Anreisetag / 1. Tag:",null,null,{"$f":"IF((I10-C10)=0,(M10-G10)*24,24-G10*24)","v":0},"Stunden",{"$nulls":5},{"$f":"IF(E14<8,S18,S19)","v":0}]
[null,"Anzahl ganze Tage:",null,null,{"$f":"IF((I10-C10)>1,I10-C10-1,0)","v":0},"Tage",{"$nulls":5},{"$f":"E15*S20","v":0}]
[null,"Rückreisetag",null,null,{"$f":"IF((I10-C10)>0,M10*24,0)","v":0},"Stunden",{"$nulls":5},{"$f":"IF(E16<8,0,14)","v":0}]
[null,"Abzug für Essen:",null,null,null,"Mittag-/Abendessen",{"$nulls":5},{"$f":"E17*S21*-1","v":0}]
[{"$nulls":17},"Sätze für Tagegeld und Verpflegung:",0]
[null,"2. Übernachtungsgeld",{"$nulls":11},{"$f":"SUM(L20:L22)","v":0},{"$nulls":4},14]
[null,"Anzahl Nächte:",null,null,null,"zu je",null,null,"für Übernachtung u. Frühstück",null,null,{"$f":"E20*G20","v":0},{"$nulls":6},28]
[{"$nulls":5},"zu je",null,null,"für Übernachtung u. Frühstück",null,null,{"$f":"E21*G21","v":0},{"$nulls":6},3.8]
[null,"Abzug Frühstück:",null,null,null,"Frühstück",{"$nulls":5},{"$f":"E22*S22*-1","v":0},{"$nulls":6},2]
[{"$nulls":18},0.35]
[null,"3. Fahrtkosten",{"$nulls":11},{"$f":"SUM(L25:L29)","v":0}]
[null,"Bahnfahrkarte:",{"$nulls":4},"(1. Klasse, einschl. Zuschläge)",{"$nulls":4},{"$f":"E25","v":0},{"$nulls":5},"Stand:","2023-01-01"]
[null,"Mit eigenem Pkw:",{"$nulls":4},"(gesamte Fahrstrecke)",{"$nulls":4},{"$f":"E26*S23","v":0}]
[null,"Sonstige Kosten:",{"$nulls":4},"für",{"$nulls":4},{"$f":"E27","v":0}]
[{"$nulls":6},"für",{"$nulls":4},{"$f":"E28","v":0}]
[{"$nulls":6},"für",{"$nulls":4},{"$f":"E29","v":0}]
[]
[null,"4. Weitere Auslagen",{"$nulls":11},{"$f":"SUM(B32:B34)","v":0}]
[null,null,null,"für"]
[null,null,null,"für"]
[null,null,null,"für"]
[]
[null,"5. Beantragte Erstattungssumme",{"$nulls":11},{"$f":"SUM(N13:O35)","v":0}]
[]
[null,"6. Überweisung"]
[null,"Kontoinhaber"]
[null,"IBAN"]
[null,"BIC",{"$nulls":5},"Institut:"]
[]
[null,"7. Unterschrift "]
[null,"Antragssteller/-in",null,{"$f":"IF(ISBLANK(L2),\"\",L2)","v":""}]
[null,"Ort",null,{"$f":"IF(ISBLANK(M4),\"\",M4)","v":""},null,null,null,"Datum",{"$f":"L6","v":"00:00:00"}]
[null,"Sämtliche Reisekosten sind durch Belege nachzuweisen."]