{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Mileage log and Expense report"],"not_rendered":{"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Mileage log and Expense report","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[]
[]
[null,"Employee name",null,"Rate Per Mile",{"v":0.27,"d":"£0.27"}]
[null,"Employee ID",null,"For Period",{"$f":"\"From \"&TEXT(MIN(B9:B19),\"d/m/yy\")&\" to \"&TEXT(MAX(B9:B19),\"d/m/yy\")","v":"From 9/5/18 to 9/5/18"}]
[null,"Vehicle Description",null,"Total Mileage",{"$f":"Mileage_Total","v":10}]
[null,"Authorised By",null,"Total Reimbursement",{"$f":"Reimbursement_Total","v":{"v":2.7,"d":"£2.70"}}]
[]
[null,"Date","Starting Location","Destination","Description/Notes","Odometer Start","Odometer End","Mileage","Reimbursement"]
[null,"2018-05-09","Home Office","Daisychain Toys","Client Meeting",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"£1.35"}}]
[null,"2018-05-09","Daisychain Toys","Home Office","Client Meeting",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"£1.35"}}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":7},0,{"v":0,"d":"£0.00"}]
[{"$nulls":6},"Totals",{"$f":"SUBTOTAL(109,Expense[Mileage])","v":10},{"$f":"SUBTOTAL(109,Expense[Reimbursement])","v":{"v":2.7,"d":"£2.70"}}]