{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":70,"n_cols":39,"rows_kept":70,"merged":[[3,10,3,16],[5,10,5,16],[5,24,5,26],[5,31,5,34],[7,10,7,16],[7,24,7,26],[7,31,7,34],[9,10,9,16],[13,11,13,12],[13,30,13,32],[13,34,13,35],[17,30,17,32],[17,34,17,35],[19,30,19,32],[19,34,19,35],[20,4,20,13],[20,16,20,18],[20,23,20,26],[20,30,20,32],[20,34,20,35],[22,4,22,13],[22,16,22,18],[22,23,22,26],[22,30,22,32],[22,34,22,35],[23,4,23,10],[24,23,24,26],[24,30,24,32],[24,34,24,35],[29,30,29,32],[29,34,29,35],[31,4,31,13],[31,16,31,18],[31,23,31,26],[31,30,31,32],[31,34,31,35],[32,30,32,32],[32,34,32,35],[33,4,33,13],[33,16,33,18],[33,23,33,26],[33,30,33,32],[33,34,33,35],[35,4,35,13],[35,16,35,18],[35,23,35,26],[35,30,35,32],[35,34,35,35],[37,4,37,13],[37,16,37,18],[37,23,37,26],[37,30,37,32],[37,34,37,35],[39,4,39,13],[39,16,39,18],[39,23,39,26],[39,30,39,32],[39,34,39,35],[40,4,40,10],[41,23,41,26],[41,30,41,32],[41,34,41,35],[46,23,46,26],[46,30,46,32],[46,34,46,35],[49,1,55,19],[49,30,49,32],[49,34,49,35],[51,30,51,32],[51,34,51,35],[53,30,53,32],[53,34,53,35],[55,30,55,32],[55,34,55,35],[58,30,58,32],[58,34,58,35],[63,30,63,32],[63,34,63,35],[65,30,65,32],[65,34,65,35],[67,30,67,32],[67,34,67,35],[69,30,69,32],[69,34,69,35]]}
[null,null,"Reisekosten-Abrechnung für Reisen an einen Ort"]
[null,null,"Stand Januar 2021"]
[]
[null,null,"Name/Vorname:",{"$nulls":28},"Uhrzeit"]
[]
[null,null,"Projektleiter:",{"$nulls":15},"Reisebeginn:"]
[]
[null,null,"Reiseziel/-anlass:",{"$nulls":15},"Reiseende:"]
[{"$nulls":24},"."]
[]
[]
[]
[]
[{"$nulls":30},{"$f":"TRUNC(Z14)","v":0},{"$nulls":3},{"$f":"(Z14-TRUNC(Z14))*100","v":0},null,null,{"$f":"AE14+AI14/100","v":0}]
[]
[]
["1. Verpflegungskosten ( Inland)"]
[null,null,"Tage",null,null,"Dauer der Abwesenheit",{"$nulls":9},"Pauschbetrag",{"$nulls":4},"Summe der Pauschbeträge"]
[]
[{"$nulls":27},"="]
[{"$nulls":4},"weniger als 24 Stunden",{"$nulls":11},{"v":14,"d":"14.00 €"},{"$nulls":3},"DE",null,null,{"$f":"C21*Q21","v":0},{"$nulls":13},{"$f":"AE21+AI21/100","v":0}]
[]
[{"$nulls":4},"24 Stunden",{"$nulls":11},{"v":28,"d":"28.00 €"},{"$nulls":3},"DE",null,null,{"$f":"C23*Q23","v":0},{"$nulls":13},{"$f":"AE23+AI23/100","v":0}]
[]
[{"$nulls":14},"Gesamtsumme",{"$nulls":8},{"$f":"X21+X23","v":{"v":0,"d":"0.00"}},{"$nulls":3},"=",null,null,{"$f":"TRUNC(X25)","v":0},{"$nulls":3},{"$f":"(X25-TRUNC(X25))*100","v":0},null,null,{"$f":"AE25+AI25/100","v":0}]
[]
[]
[]
["2. Verpflegungskosten ( Ausland )"]
[null,null,"Tage",null,null,"Dauer der Abwesenheit",{"$nulls":8},"Land","Pauschbetrag",{"$nulls":4},"Summe der Pauschbeträge"]
[]
[{"$nulls":4},"weniger als 24 Stunden",{"$nulls":11},{"v":25,"d":"25.00 €"},{"$nulls":6},{"$f":"C32*Q32","v":0}]
[{"$nulls":27},"="]
[{"$nulls":23},{"$f":"C34*Q34","v":0}]
[]
[{"$nulls":4},"24 Stunden",{"$nulls":11},{"v":50,"d":"50.00 €"},{"$nulls":6},{"$f":"C36*Q36","v":0}]
[]
[{"$nulls":23},{"$f":"C38*Q38","v":0}]
[]
[{"$nulls":23},{"$f":"C40*Q40","v":0}]
[]
[{"$nulls":14},"Gesamtsumme",{"$nulls":8},{"$f":"X32+X34+X36+X37+X38+X40","v":{"v":0,"d":"0.00"}},{"$nulls":3},"=",null,null,{"$f":"TRUNC(X42)","v":0},{"$nulls":3},{"$f":"(X42-TRUNC(X42))*100","v":0},null,null,{"$f":"AE42+AI42/100","v":0}]
[]
[]
[]
[]
[{"$nulls":37},{"$f":"AE47+AI47/100","v":0},"  "]
[{"$nulls":34}," "]
[]
[null,"RK Übertarif:                                                                                                RK steuerfrei:                                                                                                    ",{"$nulls":20},"Summe Reisekosten",{"$nulls":7},{"$f":"AE42+AE47+AE25+AE14","v":0},{"$nulls":3},{"$f":"AI42+AI47+AI25+AI14","v":{"v":0,"d":"00"}},null,null,{"$f":"SUM(AL12:AL47)","v":0}]
[]
[{"$nulls":22},"./. Frühstück"]
[]
[]
[]
[{"$nulls":22},"./. Vorschuss"]
[]
[]
[{"$nulls":22},"Erstattung",{"$nulls":7},{"$f":"AE42+AE47+AE25+AE14-AE52-AE56","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"AI50","v":{"v":0,"d":"00"}}]
[]
[]
[]
[null,null,"Abrechnung geprüft und genehmigt:",{"$nulls":16},"Vermerk Buchhaltung:"]
[null,null,"Datum/Unterschrift",{"$nulls":16},"Bruttoreisekosten"]
[null,null,"2011-02-21"]
[{"$nulls":19},"Vorsteuer"]
[]
[null,null,"Betrag erhalten",{"$nulls":16},"Nettoreisekosten"]
[null,null,"Datum/Unterschrift"]
[{"$nulls":19},"Steuerpflichtiger Arbeitslohn"]