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

{"sheet":"Januar 2015","index":0,"n_rows":48,"n_cols":14,"rows_kept":48,"merged":[[3,0,3,5],[3,7,3,8],[4,11,4,12],[39,5,39,8],[40,5,40,8]]}
[{"$nulls":10},"Abwesenheit größer 8 h",null,null,12]
["Reisekostenaufstellung ",{"$nulls":4},"Januar",2015,{"$nulls":3},"Abwesenheit größer 24 h",null,null,24]
[{"$nulls":5},"Monat","Jahr"]
["Mustermann, Max",{"$nulls":6},"Kilometergeld",null,"Verpflegungs-mehraufwand"]
["Tag","Abreise","Rückkehr","Dauer","An / Abreisetag","Reiseziel","Anlass / Zweck der Reise","Kilometer","30 Cent/km","Euro",null,"Nur für Berechnung"]
[1,{"v":7,"d":"7.00"},{"v":15,"d":"15.00"},{"$f":"C6-B6","v":{"v":8,"d":"8.00"}},null,"Reutlingen","Beispiel 1 Keine Pauschale",100,{"$f":"H6*0.3","v":{"v":30,"d":"30.00"}},{"$f":"IF(SUM(L6:M6)<=0,0,SUM(L6:M6))","v":{"v":0,"d":"0.00"}},{"$f":"IF(H6>=8,IF(H6>=24,\"\",12),\"\")","v":""},{"$f":"IF(D6>8,IF(D6>=$N$2,\"\",$N$1),IF(E6=\"ja\",$N$1,0))","v":{"v":0,"d":"0.00"}},{"$f":"IF(D6>=$N$2,$N$2,0)","v":{"v":0,"d":"0.00"}}]
[2,{"v":7,"d":"7.00"},15.15,8.15,null,"Reutlingen","Beispiel 2 Pauschale von 12 Euro",100,{"$f":"H7*0.3","v":{"v":30,"d":"30.00"}},{"v":12,"d":"12.00"},null,{"$f":"IF(D7>8,IF(D7>=$N$2,\"\",$N$1),IF(E7=\"ja\",$N$1,0))","v":{"v":12,"d":"12.00"}},{"$f":"IF(D7>=$N$2,$N$2,0)","v":{"v":0,"d":"0.00"}}]
[3,{"v":7,"d":"7.00"},{"v":24,"d":"24.00"},{"v":17,"d":"17.00"},"ja","Düsseldorf","Beispiel 3 Mehrtägig",100,{"v":30,"d":"30.00"},{"v":12,"d":"12.00"},null,{"v":12,"d":"12.00"},{"v":0,"d":"0.00"}]
[4,{"v":0,"d":"0.00"},{"v":24,"d":"24.00"},{"v":24,"d":"24.00"},null,"Düsseldorf","Beispiel 4 Zwischentag",0,{"v":0,"d":"0.00"},{"v":24,"d":"24.00"},null,"",{"v":24,"d":"24.00"}]
[5,{"v":0,"d":"0.00"},{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},"ja","Düsseldorf","Beispiel 5 Abreisetag unter 8 Stunden",100,{"v":30,"d":"30.00"},{"v":12,"d":"12.00"},null,{"v":12,"d":"12.00"},{"v":0,"d":"0.00"}]
[6,{"v":20,"d":"20.00"},{"v":24,"d":"24.00"},{"v":4,"d":"4.00"},"ja","Italien, Rom","Beispiel 6 Anreisetag unter 8 Stunden",100,{"v":30,"d":"30.00"},{"v":12,"d":"12.00"},null,{"v":12,"d":"12.00"},{"v":0,"d":"0.00"}]
[7,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[8,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[9,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[10,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[11,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[12,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[13,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[14,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[15,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[16,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[17,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[18,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[19,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[20,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[21,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[22,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[23,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[24,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[25,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[26,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[27,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[28,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[29,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[30,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[31,null,null,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":11},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summen",null,null,{"$f":"SUM(D6:D33)","v":64.15},{"$nulls":3},{"$f":"SUM(H6:H37)","v":{"v":500,"d":"500.00"}},{"$f":"SUM(I6:I37)","v":{"v":150,"d":"150.00"}},{"$f":"SUM(J6:J37)","v":{"v":72,"d":"72.00"}}]
[]
[{"$nulls":5},"Verpflegungsmehraufwand:",{"$nulls":3},{"$f":"J38","v":{"v":72,"d":"72.00"}}]
[{"$nulls":5},"Kilometergeld:",{"$nulls":3},{"$f":"I38","v":{"v":150,"d":"150.00"}}]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"Ort/Datum",null,"Unterschrift"]