{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["RKA V3","Kopie"],"not_rendered":{"macros":1,"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"RKA V3","index":0,"n_rows":60,"n_cols":18,"rows_kept":60,"merged":[[0,7,0,10],[1,1,1,4],[1,7,1,10],[7,1,7,2],[16,23,18,27],[20,23,21,27],[54,9,54,10],[58,0,58,3]]}
[{"$f":"\"Fahrtkostenabrechnung  Nr.:  \"&P7&\" / \"&P6&\"   vom  \"&P1&\"  bis  \"&P2","v":"Fahrtkostenabrechnung  Nr.:  1 / 2024   vom  01.01.2024  bis  01.01.2024"},{"$nulls":5},"Name:","Name",{"$nulls":3},1,null,null,2,{"$f":"IF(A9=\"\",\"-\",TEXT(A9,\"TT.MM.JJJJ\"))","v":"01.01.2024"},0]
["Einrichtung / Kirchengemeinde",{"$nulls":5},"Dienststelle :",{"$nulls":4},1,null,null,{"$f":"Q1+1","v":1},{"$f":"IF(A9=\"\",\"-\",TEXT(MAX(A9:A52),\"TT.MM.JJJJ\"))","v":"01.01.2024"},44562]
[{"$nulls":11},1]
["Datum","Dauer",null,"gefahrene","gefahrene","Ziel ","Zweck","Neben-","Bemerkungen:","bei Mitnahme:",null,1,null,null,{"$f":"MAX(A9:A52)","v":"2024-01-01"},{"$f":"TODAY()","v":"2024-04-09"}]
["Tag ","(Uhrzeit)",null,"Strecke","Strecke","der Reise","der Reise","kosten","Dienstreisegenehmig.","Anzahl","abweich.",1,null,null,"2022-01-01",{"$f":"YEAR(O7)-YEAR(O5)","v":2}]
["der ","von","bis","PKW","Rad",null,null,"(DB etc.)","Namen und DRG der","Pers.","von Sp.3",1,null,null,{"$f":"IF(N6=0,0,H6)","v":0},{"$f":"(YEAR(O4))","v":2024}]
["Dienstreise",null,null,"km","km",null,null,"EUR","mitgenommenen Pers.","1,2usw.","km",1,null,null,{"$f":"MIN(A9:A52)","v":"2024-01-01"},{"$f":"IF(P5=1,1,O2)","v":1}]
[1,2,null,{"$f":"B8+1","v":3},{"$f":"D8+1","v":4},5,6,7,8,9,10,1,null,null,{"$f":"IF(P5=1,1,O3)","v":0}]
["2024-01-01",{"$nulls":9},{"$f":"IF(J9=0,0,D9)","v":0},{"$f":"IF(A9>0,1,0)","v":1},{"$nulls":3},{"$f":"IF(M9>0,$O$9,\"\")","v":""},null,{"$f":"K9*J9*0.02","v":0}]
[{"$nulls":10},{"$f":"IF(J10=0,0,D10)","v":0},{"$f":"IF(A10>0,1,0)","v":0},{"$nulls":3},"",null,{"$f":"K10*J10*0.02","v":0}]
[{"$nulls":10},0,{"$f":"IF(A11>0,1,0)","v":0},{"$nulls":3},"",null,0]
[{"$nulls":10},0,{"$f":"IF(A12>0,1,0)","v":0},{"$nulls":3},"",null,0]
[{"$nulls":10},0,{"$f":"IF(A13>0,1,0)","v":0},{"$nulls":3},"",null,0]
[{"$nulls":10},0,{"$f":"IF(A14>0,1,0)","v":0},{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":10},0,0,{"$nulls":3},"",null,0]
[{"$nulls":3},{"$f":"SUM(D9:D52)","v":0},{"$f":"SUM(E9:E52)","v":0},null,null,{"$f":"SUM(H9:H52)","v":{"v":0,"d":"0.00"}},{"$nulls":3},1,{"$nulls":5},{"$f":"SUM(R9:R52)","v":{"v":0,"d":"0.00"}}]
[null,null,"PKW  km = ",{"$f":"SUM(D9:D52)","v":0},{"v":0.38,"d":"km      x 0.38 EUR  ="},{"$f":"D54*E54","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":5},1]
[{"$nulls":3},"Mitnahme pro Person je",{"v":0.02,"d":"km      x 0.02 EUR  ="},{"$f":"R53","v":0},null,null,"Abgerechnet am:",{"$f":"TODAY()","v":"2024-04-09"},null,1]
[null,null,"Rad km =",{"$f":"SUM(E9:E52)","v":0},{"v":0.1,"d":"km      x 0.10 EUR  ="},{"$f":"D56*E56","v":{"v":0,"d":"0.00 EUR"}},null,"Für die Richtigkeit der Eintragungen :",{"$nulls":3},1]
[{"$nulls":4},"Fahrtkosten :",{"$f":"SUM(F54:F56)","v":0},{"$nulls":5},1]
[{"$nulls":4},"Nebenkosten :",{"$f":"SUM(H9:H52)","v":0},{"$nulls":5},1]
[{"$f":"F1","v":0},{"$nulls":3},"GESAMT :",{"$f":"F57+F58","v":{"v":0,"d":"0.00 EUR"}},{"$nulls":5},1]
[{"$nulls":7},"(Unterschrift)",{"$nulls":3},1]

{"sheet":"Kopie","index":1,"n_rows":60,"n_cols":15,"rows_kept":60,"merged":[[0,1,0,4],[1,1,1,4],[54,9,54,10]]}
["Name :",{"$f":"'RKA V3'!H1","v":"Name"},{"$nulls":5},"Kirchengemeinde :",{"$f":"'RKA V3'!C2","v":0}]
[{"$nulls":7},"Dienststelle :",{"$f":"'RKA V3'!H2","v":0}]
[]
["Datum","Dauer",null,"gefahrene","Ziel ","Zweck","Begründung ","Neben-","Bemerkungen:","bei Mitnahme:"]
["Tag ","(Uhrzeit)",null,"Strecke","der Reise","der Reise","für die","kosten","Dienstreisegenehmigung","Anzahl","abweich."]
["der ","von","bis",{"$nulls":3},"Kfz.-Benutzung","(DB etc.)","Namen und DRG der","Pers.","von Sp.3"]
["Dienstreise",null,null,"km",{"$nulls":3},"EUR","mitgenommenen Pers.","1,2od.3","km"]
[1,2,null,{"$f":"B8+1","v":3},{"$f":"D8+1","v":4},5,6,7,8,9,10]
["2022-01-01",null,null,50,{"$nulls":10},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":10},0,{"$nulls":3},"WeVo § 2 Abs.1- 3 "]
[{"$nulls":3},{"$f":"SUM(D9:D52)","v":50},{"$nulls":3},{"$f":"SUM(H9:H51)","v":{"v":0,"d":"0.00"}}]
[null,null,"Gesamt  KM = ",{"$f":"SUM(D9:D51)","v":50},{"v":0.3,"d":"km      x 0.30 EUR  ="},{"$f":"D54*E54","v":{"v":15,"d":"15.00 EUR"}}]
[null,null,"Mitnahme 1 Pers. = ",{"$f":"SUMIF($J$9:$J$51,1,$K$9:$K$51)","v":0},{"v":0.02,"d":"km      x 0.02 EUR  ="},{"$f":"D55*E55","v":0},null,null,"Abgerechnet am:",{"$f":"TODAY()","v":"2024-04-09"}]
[{"$nulls":3},{"$f":"SUMIF($J$9:$J$51,\">1\",$K$9:$K$51)","v":0},null,{"$f":"D56*E56","v":0},null,"Für die Richtigkeit der Eintragungen :"]
[{"$nulls":4},"Fahrtkosten :",{"$f":"SUM(F54:F56)","v":{"v":15,"d":"15.00 EUR"}}]
[{"$nulls":4},"Nebenkosten :",{"$f":"SUM(H9:H51)","v":0}]
[{"$nulls":4},"GESAMT :",{"$f":"F57+F58","v":{"v":15,"d":"15.00 EUR"}}]
[{"$nulls":7},"(Unterschrift)"]