{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2020"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"2020","index":0,"n_rows":92,"n_cols":42,"rows_kept":92,"cut":false,"hidden":false,"merged":[[91,1,91,9],[91,12,91,18],[91,20,91,29],[89,1,89,11],[89,12,89,18],[89,20,89,29],[90,1,90,9],[90,12,90,18],[90,20,90,29],[82,1,82,2],[82,3,82,7],[82,8,82,11],[83,1,85,13],[83,16,83,28],[86,1,88,11],[86,12,88,18],[86,20,87,29],[88,20,88,29],[79,1,79,2],[79,3,79,7],[79,8,79,11],[79,27,79,28],[80,1,80,2],[80,3,80,7],[80,8,80,11],[81,1,81,2],[81,3,81,7],[81,8,81,11],[81,27,81,28],[73,8,75,14],[74,33,75,38],[75,27,75,28],[76,1,77,2],[76,3,77,7],[76,8,77,10],[76,11,77,12],[76,13,77,13],[77,27,77,28],[66,12,66,13],[66,15,66,16],[66,20,66,21],[66,22,66,24],[66,25,66,26],[66,27,66,28],[68,8,72,14],[68,15,68,16],[68,20,68,21],[68,22,68,24],[68,25,68,26],[68,27,68,28],[70,15,70,16],[70,20,70,21],[70,22,70,24],[70,25,70,26],[70,27,70,28],[72,15,72,16],[72,20,72,21],[72,22,72,24],[72,25,72,26],[72,27,72,28],[61,37,62,37],[61,38,62,38],[62,5,62,7],[62,9,62,11],[62,12,62,14],[62,15,62,16],[62,20,62,21],[64,12,64,13],[64,15,64,16],[64,20,64,21],[64,22,64,24],[64,25,64,26],[64,27,64,28],[60,1,60,7],[60,8,60,14],[60,15,60,25],[56,3,56,11],[56,12,56,13],[56,14,56,16],[56,18,56,20],[60,34,60,36],[61,0,61,1],[61,5,61,7],[61,8,61,14],[61,15,61,16],[61,20,61,21],[61,22,62,24],[61,33,62,33],[56,21,56,22],[56,25,56,26],[49,27,49,28],[51,3,51,13],[51,25,51,26],[51,27,51,28],[56,27,56,28],[57,3,57,11],[57,17,57,22],[52,34,52,38],[54,3,54,13],[54,25,54,26],[54,27,54,28],[49,3,49,11],[49,13,50,13],[49,14,50,16],[49,17,50,19],[49,20,51,24],[49,25,49,26],[42,1,42,4],[42,6,42,7],[42,8,42,11],[42,16,42,17],[42,20,42,22],[42,26,42,27],[46,1,46,4],[46,6,46,7],[46,8,46,11],[46,16,46,17],[46,20,46,22],[46,26,46,27],[37,3,38,7],[37,17,38,18],[37,28,38,29],[38,1,38,2],[38,8,38,16],[38,19,38,27],[39,8,39,16],[39,19,39,27],[40,9,40,11],[40,13,40,14],[40,20,40,22],[40,26,40,28],[32,33,32,37],[32,38,33,43],[33,34,33,37],[34,1,34,2],[34,3,34,13],[34,14,35,18],[34,19,34,28],[35,3,35,13],[35,19,35,28],[29,13,29,14],[29,16,29,18],[29,20,29,22],[30,1,31,4],[30,9,31,14],[30,16,31,22],[30,26,31,28],[32,1,32,6],[32,9,33,14],[32,16,33,22],[32,26,33,29],[26,1,26,4],[26,9,26,11],[26,13,26,14],[26,21,26,22],[28,9,28,11],[28,13,28,14],[28,16,28,18],[28,20,28,22],[24,1,24,4],[21,1,21,4],[21,6,21,7],[21,8,21,11],[21,16,21,17],[21,20,21,22],[21,26,21,27],[24,6,24,7],[24,8,24,11],[24,16,24,17],[24,18,24,19],[24,20,24,22],[23,9,23,11],[23,13,23,14],[23,21,23,22],[24,26,24,27],[14,6,14,7],[14,8,14,29],[16,9,16,11],[16,13,16,17],[16,18,16,19],[16,22,18,29],[23,26,23,28],[23,33,23,35],[23,36,23,37],[6,1,7,1],[7,2,7,16],[7,20,7,29],[7,33,9,39],[9,2,9,16],[9,20,9,29],[11,28,12,29],[12,1,12,2],[12,8,12,16],[12,17,12,18],[12,19,12,27],[12,36,12,37],[0,2,2,17],[0,19,0,21],[0,26,0,29],[0,33,2,38],[1,19,1,21],[1,26,1,29],[3,2,3,17],[5,2,5,7],[5,8,5,11],[5,12,5,16],[5,20,5,29]]}
[null,null,{"$f":"\"Antrag auf Genehmigung und Abrechnung einer Dienstreise (\" &AK13 &\")\"","v":"Antrag auf Genehmigung und Abrechnung einer Dienstreise (ab 01.2020)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Datum",null,null,null,"Beleg Nr.",null,null,null,null,null,null,null,null,null,null,"nach SäRKG gemäß Artikel 11 des HGB 2009/10 vom 12.12.2008 und \nVwV SäRKG vom 22.09.2009"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Kto Soll",null,null,null,"Kto Haben"]
[]
[]
[]
[null,"Name",null,null,null,null,null,null,"Vorname",null,null,null,null,null,null,null,null,null,"Funktion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"angepasst/überarbeitet 01.2020"]
[null,"Wohn-anschrift"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dienstort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Landessportbund\nSachsen e.V."]
[]
[null,"IBAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIC"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"und\nzurück"]
[null,"Antrag",null,null,null,null,null,"Dienstreise von",null,null,null,null,null,null,null,null,null,"nach",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr","ab 01.2020"]
[null,null,null,null,null,null,null,null,"Beginn der Reise (PLZ Ort)",null,null,null,null,null,null,null,null,null,null,"Reiseziel/e (PLZ Ort)"]
[null,"Reisezweck/ggf. Einladung"]
[]
[null,"Übernachtung notwendig ?",null,null,null,null,null,null,null,"nein",null,null,null,"ja      Preis pro Nacht",null,null,null,null,null,null,"€",null,"Erklärung notwendig, wenn Preis für eine Ü/ohne Frühstück > 70,00 € bzw. für Ü/mit Frühstück >74,80 €"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mit Frühstück"," ","ohne"]
[]
[]
[null,"Beginn der Dienstreise",null,null,null,null,"am ",null,null,null,null,null,null,null," Uhr",null,"Ende",null,"am",null,null,null,null,null,{"$f":"IF(U22<I22,\"!\",\"\")","v":""},null,null,null," Uhr"]
[]
[null,null,null,null,null,null,"von",null,null,"Dienststelle",null,null,null,"Wohnung",null,null,null,null,"an  ",null,null,{"$f":"J24","v":"Dienststelle"},null,null,null,null,{"$f":"N24","v":"Wohnung"},null,null,null,null,null,null,"Geltende Sätze",null,null,"ab 2020",null,"ab 01.01.2020"]
[null,"Beginn des Dienstgeschäftes",null,null,null,null,"am",null,null,null,null,null,null,null,"Uhr",null,{"$f":"Q22","v":"Ende"},null,null,null,null,null,null,null,null,null,null,null," Uhr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mit","ohne","Rad"]
[null,"Beförderungsmittel",null,null,null,null,null,null,null,"Bahn",null,null,null,"Flugzeug",null,null,"Dienst-Kfz",null,null,null," ","Privat-Kfz",null,null,"x",null,null,null,null,null,null,null,null,0.3,0.17,0.05,null,"€/km","Wegstreckenentschädigung"]
[]
[null,null,null,null,null,null,null,null,null,"Bus/Tram",null,null,null,"Mitfahrer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"³ 8","³14","= 24",null,"Std","Dauer der Abwesenheit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"amtl. Kennzeichen",null,null,null,{"$f":"Q30","v":"amtl. Kennzeichen"},null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"AH30","v":14},28,null,"TG","mögliches Tagegeld (ab 01.01.2014 geändert: auf 12/24€)"]
[null,"triftige Gründe für Benutzung eines Kfz ",null,null,null,null,null,null," ","Geschäftsort mit Bahn/ÖPNV nicht oder nicht zeitgerecht erreichbar",null,null,null,null,null,null,"Erledigung von Dienstgeschäften an verschiedenen Geschäftsorten",null,null,null,null,null,null,null,null,null,"Einsparung von Reisekosten",null,null,null,null,null,null,"F","M","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.77,-3.3,-3.3,null,"SBZ","Sachbezugswerte 2018 (vgl. http://www.aok-business.de/tools-service/beitraege-und-rechengroessen/sachbezugswerte-2018/)"]
[null,{"$f":"\"(triftige Gründe: \"&TEXT(AH27,\"0,00\")&\" €/km, ohne \"&TEXT(AI27,\"0,00\")&\" €/km)\"","v":"(triftige Gründe: 0,30 €/km, ohne 0,17 €/km)"},null,null,null,null,null,null,null,"Mitnahme von weiteren Dienstreisenden",null,null,null,null,null,null,"Mitnahme von größerem dienstlichen Gepäck, umfangreichen Akten etc.",null,null,null,null,null,null,null,null,null,"erhebliche Arbeitszeitersparnis",null,null,null,null,null,null,"Abzug Frühstück (Hotel m. Ü/F)",null,null,null,null,"Kostenanteil 'Frühstück' lt. Rechnung\noder pauschal 4,80"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V57<>\"\",\"lt. Übernachtungsechng.\",\"pauschal\")","v":"pauschal"}]
[null,"beantragt ",null,null,null,null,null,null,null,null,null,null,null,null," genehmigt\n wie beantragt"]
[null,null,null,"Datum/Unterschrift Dienstreisender",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum/Unterschrift zuständiger Leiter"]
[]
[null,null,null,"Dienstreise von\n(PLZ Ort)",null,null,null,null,null,null,null,null,null,null,null,null,null,"nach\n(PLZ Ort)",null,null,null,null,null,null,null,null,null,null,"und\nzurück"]
[null,"Abrechnung"]
[]
[null,null,null,null,null,null,{"$f":"G24","v":"von"},null,null,{"$f":"J24","v":"Dienststelle"},null,null,null,{"$f":"N24","v":"Wohnung"},null,null,null,null,{"$f":"S24","v":"an  "}," ",{"$f":"V24","v":"Dienststelle"},null,null,null,null,null,{"$f":"AA24","v":"Wohnung"},null,null,null,null,null,null,"Tagegeldanspruch ein-/mehrtägige DR",null,null,null,null,null,null,"DR über Nacht"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AI47:AM47,\">6\")","v":0},"1.Tag","2.Tag","3.Tag","4.Tag","5.Tag"]
[null,{"$f":"B22","v":"Beginn der Dienstreise"},null,null,null,null,{"$f":"G22","v":"am "},null,null,null,null,null,null,null,{"$f":"O22","v":" Uhr"},null,{"$f":"Q22","v":"Ende"},null,{"$f":"S22","v":"am"},null,null,null,null,null,{"$f":"IF(U43<I43,\"!\",\"\")","v":""},null,null,null,{"$f":"AC22","v":" Uhr"},null,null,null,null,"Tg",{"$f":"IF($I$43<>\"\",1,\"-\")","v":"-"},{"$f":"IF($U$43>$I$43,1,\"-\")","v":"-"},{"$f":"IF($U$43>($I$43+1),1,\"-\")","v":"-"},{"$f":"IF($U$43>($I$43+2),1,\"-\")","v":"-"},{"$f":"IF($U$43>($I$43+3),1,\"-\")","v":"-"},null,{"$f":"IF(SUM($AI$43:$AM$43)=2,\"x\",\"-\")","v":"-"}]
[]
[]
[]
[null,{"$f":"B25","v":"Beginn des Dienstgeschäftes"},null,null,null,null,"am",null,null,null,null,null,null,null,{"$f":"O25","v":"Uhr"},null,{"$f":"Q25","v":"Ende"},null,"am",null,null,null,null,null,null,null,null,null,{"$f":"AC25","v":" Uhr"},null,null,null,null,"Std",{"$f":"IF(AI43<>\"-\",IF(U43=I43,(AA43-N43)*24,24-N43*24),\"-\")","v":"-"},{"$f":"IF(AJ43<>\"-\",IF(AK43=1,24,IF($U43>$I43,0+($AA43)*24,0)),\"-\")","v":"-"},{"$f":"IF(AK43<>\"-\",IF(AL43=1,24,IF($U43>$I43,0+($AA43)*24,0)),\"-\")","v":"-"},{"$f":"IF(AL43<>\"-\",IF(AM43=1,24,IF($U43>$I43,0+($AA43)*24,0)),\"-\")","v":"-"},{"$f":"IF(AM43<>\"-\",IF(AO45=1,24,IF($U43>$I43,0+($AA43)*24,0)),\"-\")","v":"-"},null,{"$f":"IF(SUM($AI$43:$AM$43)=2,SUM($AI$47:$AM$47),\"-\")","v":"-"}]
[]
[null,"tatsächliche Ausgaben",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI49:AM49)","v":0},{"$f":"IF(AI$47=\"-\",0,IF(AI$47=24,$AJ$30,IF(AI$47>8,$AH$30,IF(AI$47<=8,IF(SUM($AI$43:$AM$43)>2,$AH$30,IF($M$57>0,$AH$30,0))))))","v":0},{"$f":"IF(AJ$47=\"-\",0,IF(AJ$47=24,$AJ$30,IF(AJ$47>8,$AH$30,IF(AJ$47<=8,IF(SUM($AI$43:$AM$43)>2,$AH$30,IF($M$57>0,$AH$30,0))))))","v":0},{"$f":"IF(AK$47=\"-\",0,IF(AK$47=24,$AJ$30,IF(AK$47>8,$AH$30,IF(AK$47<=8,IF(SUM($AI$43:$AM$43)>2,$AH$30,0)))))","v":0},{"$f":"IF(AL$47=\"-\",0,IF(AL$47=24,$AJ$30,IF(AL$47>8,$AH$30,IF(AL$47<=8,IF(SUM($AI$43:$AM$43)>2,$AH$30,0)))))","v":0},{"$f":"IF(AM$47=\"-\",0,IF(AM$47=24,$AJ$30,IF(AM$47>8,$AH$30,IF(AM$47<=8,IF(SUM($AI$43:$AM$43)>2,$AH$30,0)))))","v":0},null,{"$f":"IF(SUM($AI$43:$AM$43)=2,IF(COUNTA(G65,G67)=0,IF(AO47>8,$AH$30,0),\"-\"),\"-\")","v":"-"}]
[null,"Fahrkosten",null,"Benutzung Bahn/Flugzeug laut Beleg",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamt-km",null,null,{"$f":"\"(\"&TEXT(AH27,\"0,00\")&\" € pro Fahr-km\nbei triftigen Gründen\nsonst: \"&TEXT(AI27,\"0,00\")&\" €/km)\"","v":"(0,30 € pro Fahr-km\nbei triftigen Gründen\nsonst: 0,17 €/km)"},null,null,null,null,"=",null,null,null,"€"]
[]
[null,null,null,"Benutzung Privat-Kfz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,{"$f":"IF(S52<>\"\",S52*AH52,\"\")","v":""},null,"€",null,null,null,{"$f":"IF(COUNTA(I31,P31,Y31,I33,P33,Y33)=0,$AI$27,$AH$27)","v":0.3},"Erstattungsssatz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(I31,P31,Y31,I33,P33,Y33)=0,\"(weil kein triftiger Grund angegeben)\",\"\")","v":""}]
[]
[null,null,null,"sonstige Fahrkosten laut Beleg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Taxi mit Begründung)",null,null,null,null,"=",null,null,null,"€"]
[]
[null,"Übernachtung",null,"Betrag laut beigefügter Rechnung",null,null,null,null,null,null,null,null,null,null,"enthält",null,null,null," x Frühstück je ",null,null,null,null,null,null,"=",null,{"$f":"IF(M57<>\"\",M57-(R57*IF(V57<>\"\",V57,)),\"\")","v":""},null,"€",null,null,null,{"$f":"R57*V57","v":0},{"$f":"IF(R57>0,IF(V57>0,\"Minderung Übernachtungsrechnung\",\"Kürzung Tagegeld\"),\"\")","v":""}]
[null,null,null,"übernachtet ohne Abrechnung",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Kostenanteil Frühstück lt. Rechnung)"]
[]
[null,"Tagegeld entsprechend Abwesenheit",null,null,null,null,null,null,null,null,null,null,null,null,null,"Abzüge vom  Tagegeld"]
[null,"a) ein- und mehrtägige DR - mit/ohne Übern.",null,null,null,null,null,null,"b) DR über Nacht - ohne Übern.",null,null,null,null,null,null,"für unentgeltlich erhaltene Mahlzeit(en)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tagegeldkürzung*"]
["Abwesenheit",null,"< 8 Std.1)","> 8 Std.","= 24 Std.","mit",null,null,"Dauer des Dienstgeschäfts > 8 Std.",null,null,null,null,null,null,"Früh2)",null,null,"Mittag",null,"Abend",null,"Abzüge\ngesamt",null,null,null,null,null,null,null,null,null,null,"TG\npro Tg","F","M","A",{"$f":"\"von\n\"&TEXT($AJ$30,\"#,00\")","v":"von\n28,00"},"bleibt"]
[null,null,null,{"$f":"AH30","v":14},{"$f":"AJ30","v":28},"Übern",null,null,null,"Dauer (Std.)",null,null,"Tagegeld",null,null,{"$f":"$AJ$30*20%*-1","v":-5.6000000000000005},null,null,{"$f":"$AJ$30*40%*-1","v":-11.200000000000001},null,{"$f":"$AJ$30*40%*-1","v":-11.200000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4,0.4,null,null,"ein","zwei","mehr"]
[]
[null,"1.Tag",{"$f":"IF(AI47<>0,IF($AI$47<=8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF(AI$47<24,IF(AI$47>8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF($AI$47=24,\"ü\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=2,IF($AI$47<24,IF($AI$47<=8,$AI$47,IF($AO$47>8,AI$47,\"\")),\"\"),\"\")","v":""},null,{"$f":"IF(COUNTA($G$65,$G$67)=0,IF($AO$47>8,IF(MAX($K$65,$K$67)=$K$65,$AH$30,\"\"),\"\"),\"\")","v":""},null,"€",null,null,null,null,null,null,null,{"$f":"IF(AH65<>\"\",IF(COUNTA(P65:U65)>0,IF(AL65<AH65,AL65*-1,AH65*-1),\"\"),\"\")","v":""},null,null,"=",null,{"$f":"IF(AH65>0,AH65-IF(AL65>AH65,AH65,AL65),\"\")","v":""},null,"€",null,null,null,{"$f":"IF(SUM($AI$43:$AI$43)=1,$AN65,IF(SUM($AI$43:$AM$43)=2,$AO65,$AP65))","v":0},{"$f":"IF($P65<>\"\",IF(($AJ$30*AI$63)<-$AH$32,-$AH$32,$AJ$30*AI$63),\"-\")","v":"-"},{"$f":"IF($S65<>\"\",IF(($AJ$30*AJ$63)<-$AI$32,-$AI$32,$AJ$30*AJ$63),\"-\")","v":"-"},{"$f":"IF($U65<>\"\",IF(($AJ$30*AK$63)<-$AJ$32,-$AJ$32,$AJ$30*AK$63),\"-\")","v":"-"},{"$f":"IF(SUM(AI65:AK65)>0,SUM(AI65:AK65),0)","v":0},{"$f":"IF(AH65<>\"-\",AH65-IF(AL65<>\"\",AL65,0),\"\")","v":0},{"$f":"IF(SUM($AI$43:$AI$43)=1,AI49,0)","v":0},{"$f":"IF(SUM($AI$43:$AM$43)=2,IF(M65<>\"\",M65,0)+IF(COUNTA($G$65,$G$67)>0,IF($AO$47>8,12,0),0),0)","v":0},{"$f":"IF(SUM($AI$43:$AM$43)>2,$AI$49,0)","v":0}]
[]
[null,"2.Tag",{"$f":"IF($AJ$47<=8,\"ü\",\"\")","v":""},{"$f":"IF(AJ$47<24,IF(AJ$47>8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF($AJ$47=24,\"ü\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=2,IF($AI$47<24,IF($AI$47<=8,$AJ$47,IF($AO$47>8,AJ$47,\"\")),\"\"),\"\")","v":""},null,{"$f":"IF(COUNTA($G$65,$G$67)=0,IF($M$57=0,IF($AO$47>8,IF(MAX($K$65,$K$67)=$K$67,$AH$30,\"\"),\"\"),\"\"),\"\")","v":""},null,"€",null,null,null,null,null,null,null,{"$f":"IF(AH67<>\"\",IF(COUNTA(P67:U67)>0,IF(AL67<AH67,AL67*-1,AH67*-1),\"\"),\"\")","v":""},null,null,"=",null,{"$f":"IF(AH67>0,AH67-IF(AL67>AH67,AH67,AL67),\"\")","v":""},null,"€",null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=1,$AN67,IF(SUM($AI$43:$AM$43)=2,$AO67,$AP67))","v":0},{"$f":"IF($P67<>\"\",IF(($AJ$30*AI$63)<-$AH$32,-$AH$32,$AJ$30*AI$63),\"-\")","v":"-"},{"$f":"IF($S67<>\"\",IF(($AJ$30*AJ$63)<-$AI$32,-$AI$32,$AJ$30*AJ$63),\"-\")","v":"-"},{"$f":"IF($U67<>\"\",IF(($AJ$30*AK$63)<-$AJ$32,-$AJ$32,$AJ$30*AK$63),\"-\")","v":"-"},{"$f":"IF(SUM(AI67:AK67)>0,SUM(AI67:AK67),0)","v":0},{"$f":"IF(AH67<>\"-\",AH67-IF(AL67<>\"\",AL67,0),\"\")","v":0},null,{"$f":"IF(SUM($AI$43:$AM$43)=2,IF(M67<>\"\",M67,0)+IF(COUNTA($G$65,$G$67)>0,IF($AO$47>8,12,0),0),0)","v":0},{"$f":"IF(SUM($AI$43:$AM$43)>2,$AJ$49,0)","v":0}]
[]
[null,"3.Tag",{"$f":"IF($AK$47<=8,\"ü\",\"\")","v":""},{"$f":"IF(AK$47<24,IF(AK$47>8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF($AK$47=24,\"ü\",\"\")","v":""},null,null,null,"1) bei mehrtägigen DR mit Übernachtung\nkeine Mindestabwesenheitsdauer\nam Anfangs- und am Endtag",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH69<>\"\",IF(COUNTA(P69:U69)>0,IF(AL69>AH69,AH69*-1,AL69*-1),\"\"),\"\")","v":""},null,null,"=",null,{"$f":"IF(AH69>0,AH69-IF(AL69>AH69,AH69,AL69),\"\")","v":""},null,"€",null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=1,$AN69,IF(SUM($AI$43:$AM$43)=2,$AO69,$AP69))","v":0},{"$f":"IF($P69<>\"\",IF(($AJ$30*AI$63)<-$AH$32,-$AH$32,$AJ$30*AI$63),\"-\")","v":"-"},{"$f":"IF($S69<>\"\",IF(($AJ$30*AJ$63)<-$AI$32,-$AI$32,$AJ$30*AJ$63),\"-\")","v":"-"},{"$f":"IF($U69<>\"\",IF(($AJ$30*AK$63)<-$AJ$32,-$AJ$32,$AJ$30*AK$63),\"-\")","v":"-"},{"$f":"IF(SUM(AI69:AK69)>0,SUM(AI69:AK69),0)","v":0},{"$f":"IF(AH69<>\"-\",AH69-IF(AL69<>\"\",AL69,0),\"\")","v":0},null,null,{"$f":"IF(SUM($AI$43:$AM$43)>2,$AK$49,0)","v":0}]
[]
[null,"4.Tag",{"$f":"IF($AL$47<=8,\"ü\",\"\")","v":""},{"$f":"IF(AL$47<24,IF(AL$47>8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF($AL$47=24,\"ü\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH71<>\"\",IF(COUNTA(P71:U71)>0,IF(AL71>AH71,AH71*-1,AL71*-1),\"\"),\"\")","v":""},null,null,"=",null,{"$f":"IF(AH71>0,AH71-IF(AL71>AH71,AH71,AL71),\"\")","v":""},null,"€",null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=1,$AN71,IF(SUM($AI$43:$AM$43)=2,$AO71,$AP71))","v":0},{"$f":"IF($P71<>\"\",IF(($AJ$30*AI$63)<-$AH$32,-$AH$32,$AJ$30*AI$63),\"-\")","v":"-"},{"$f":"IF($S71<>\"\",IF(($AJ$30*AJ$63)<-$AI$32,-$AI$32,$AJ$30*AJ$63),\"-\")","v":"-"},{"$f":"IF($U71<>\"\",IF(($AJ$30*AK$63)<-$AJ$32,-$AJ$32,$AJ$30*AK$63),\"-\")","v":"-"},{"$f":"IF(SUM(AI71:AK71)>0,SUM(AI71:AK71),0)","v":0},{"$f":"IF(AH71<>\"-\",AH71-IF(AL71<>\"\",AL71,0),\"\")","v":0},null,null,{"$f":"IF(SUM($AI$43:$AM$43)>2,$AL$49,0)","v":0}]
[]
[null,"5.Tag",{"$f":"IF($AM$47<=8,\"ü\",\"\")","v":""},{"$f":"IF(AM$47<24,IF(AM$47>8,\"ü\",\"\"),\"\")","v":""},{"$f":"IF($AM$47=24,\"ü\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH73<>\"\",IF(COUNTA(P73:U73)>0,IF(AL73>AH73,AH73*-1,AL73*-1),\"\"),\"\")","v":""},null,null,"=",null,{"$f":"IF(AH73>0,AH73-IF(AL73>AH73,AH73,AL73),\"\")","v":""},null,"€",null,null,null,{"$f":"IF(SUM($AI$43:$AM$43)=1,$AN73,IF(SUM($AI$43:$AM$43)=2,$AO73,$AP73))","v":0},{"$f":"IF($P73<>\"\",IF(($AJ$30*AI$63)<-$AH$32,-$AH$32,$AJ$30*AI$63),\"-\")","v":"-"},{"$f":"IF($S73<>\"\",IF(($AJ$30*AJ$63)<-$AI$32,-$AI$32,$AJ$30*AJ$63),\"-\")","v":"-"},{"$f":"IF($U73<>\"\",IF(($AJ$30*AK$63)<-$AJ$32,-$AJ$32,$AJ$30*AK$63),\"-\")","v":"-"},{"$f":"IF(SUM(AI73:AK73)>0,SUM(AI73:AK73),0)","v":0},{"$f":"IF(AH73<>\"-\",AH73-IF(AL73<>\"\",AL73,0),\"\")","v":0},null,null,{"$f":"IF(SUM($AI$43:$AM$43)>2,$AM$49,0)","v":0}]
[null,null,null,null,null,null,null,null,"2) Frühstück nur eintragen, wenn nicht in Übernachtungsrechnung enthalten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% vom für 24 Std zu gewährenden TG,\njedoch mindestens SBZ-Wert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reisekosten gesamt",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AB50:AC57)+SUM(AB65:AC74)<>0,SUM(AB50:AC57)+SUM(AB65:AC74),\"\")","v":""},null,"€"]
[null,"Mitfahrer\n(Name, Vorname)",null,"Mitnahme von\n(PLZ Ort)",null,null,null,null,"Mitnahme bis\n(PLZ Ort)",null,null,"und\nzurück"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zzgl. Kraftstoffkosten für Dienst-Kfz (laut Beleg)",null,null,null,"€"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"abzüglich Reisekostenvorschuss",null,null,null,"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"noch zu überweisender Betrag",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AB76,AB78,-AB80)<>0,SUM(AB76,AB78,-AB80),\"\")","v":""},null,"€"]
[null,null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"Betrag in Worten:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB76=\"\",\"\",_xll.SmartTools_ZahlInWorten.ZahlInWorten(AB82,1))","v":""}]
[]
[]
[null,"Einen Reisekostenvorschuss habe ich erhalten/nicht erhalten.\nDie nachgewiesenen Ausgaben waren notwendig und unvermeidbar. Rechnungsbelege sind beigefügt. \nIch versichere die Richtigkeit meiner Angaben.",null,null,null,null,null,null,null,null,null,null,"Ordnungsgemäße Durchführung des Dienstreiseauftrages und sachliche Richtigkeit der Abrechnung überprüft und bestätigt.\nBetrag zur Zahlung angewiesen.",null,null,null,null,null,null,null,"Rechnerische Richtigkeit überprüft und bestätigt.\nBanküberweisung / Auszahlung am: "]
[]
[]
[null,"Datum:",null,null,null,null,null,null,null,null,null,null,"Datum:",null,null,null,null,null,null,null,"Unterschrift zuständiger Finanzbearbeiter"]
[null,{"$f":"NOW()","v":"2020-03-20T17:46:14.420"},null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2020-03-20T17:46:14.420"}]
[null,"Unterschrift Dienstreisender",null,null,null,null,null,null,null,null,null,null,"Unterschrift zuständiger Leiter",null,null,null,null,null,null,null,"Betrag bar erhalten / Unterschrift Dienstreisender"]