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

{"sheet":"Expenses Report","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"Travel Expenses Report"]
[]
[null,"Name","Kim Ambercrombie","Authorised by",null,null,"Yossi Banai",null,"Per-mile Reimbursement",null,null,{"v":0.32,"d":"£0.32"}]
[]
[null,"Department","Sales","Date Submitted",null,null,{"$f":"TODAY()","v":"2018-01-18"},null,"Total Reimbursement Due",null,null,{"$f":"TotalReimbursementDue","v":{"v":500.09906976744185,"d":"£500.10"}}]
[]
[null,"Period",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"d/m/yy\"),\"From \"&TEXT(MIN(B10:B13),\"d/m/yy\")&\" to \"&TEXT(MAX(B10:B13),\"d/m/yy\"))","v":"From 19/12/17 to 24/12/17"}]
[]
[null,"Date","Description of Expense","Airfare","Accommodation","Ground \nTransport \n(Fuel, Hire Car, Taxi)","Meals & Tips","Conferences and Seminars","Miles","Mileage Reimbursement","Miscellaneous","Currency Exchange Rate","Expense Currency","Total"]
[null,{"$f":"TODAY()-30","v":"2017-12-19"},"Travel to client office",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF('Expenses Report'!I10<>\"\",'Expenses Report'!I10*MileageRate,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,1.72,"CAD",{"$f":"IFERROR(IF(OR('Expenses Report'!$L10=\"\",'Expenses Report'!$L10=1),SUM('Expenses Report'!$J10:$K10,'Expenses Report'!$D10:$H10)*1,SUM('Expenses Report'!$J10:$K10,'Expenses Report'!$D10:$H10)/'Expenses Report'!$L10),\"\")","v":{"v":359.4186046511628,"d":"£359.42"}}]
[null,{"$f":"TODAY()-30","v":"2017-12-19"},"Lunch with client",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF('Expenses Report'!I11<>\"\",'Expenses Report'!I11*MileageRate,\"\")","v":3.84},null,1.72,"CAD",{"$f":"IFERROR(IF(OR('Expenses Report'!$L11=\"\",'Expenses Report'!$L11=1),SUM('Expenses Report'!$J11:$K11,'Expenses Report'!$D11:$H11)*1,SUM('Expenses Report'!$J11:$K11,'Expenses Report'!$D11:$H11)/'Expenses Report'!$L11),\"\")","v":{"v":16.36046511627907,"d":"£16.36"}}]
[null,"2017-12-19","Afternoon seminar",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF('Expenses Report'!I12<>\"\",'Expenses Report'!I12*MileageRate,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"GBP",{"$f":"IFERROR(IF(OR('Expenses Report'!$L12=\"\",'Expenses Report'!$L12=1),SUM('Expenses Report'!$J12:$K12,'Expenses Report'!$D12:$H12)*1,SUM('Expenses Report'!$J12:$K12,'Expenses Report'!$D12:$H12)/'Expenses Report'!$L12),\"\")","v":{"v":101.92,"d":"£101.92"}}]
[null,{"$f":"TODAY()-25","v":"2017-12-24"},"Travel to airport",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF('Expenses Report'!I13<>\"\",'Expenses Report'!I13*MileageRate,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"GBP",{"$f":"IFERROR(IF(OR('Expenses Report'!$L13=\"\",'Expenses Report'!$L13=1),SUM('Expenses Report'!$J13:$K13,'Expenses Report'!$D13:$H13)*1,SUM('Expenses Report'!$J13:$K13,'Expenses Report'!$D13:$H13)/'Expenses Report'!$L13),\"\")","v":{"v":22.400000000000002,"d":"£22.40"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Expenses[Airfare])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,Expenses[Accommodation])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Expenses[Ground \nTransport \n(Fuel, Hire Car, Taxi)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,Expenses[Meals & Tips])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,Expenses[Conferences and Seminars])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,Expenses[Miles])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,Expenses[Mileage Reimbursement])","v":39.36},{"$f":"SUBTOTAL(109,Expenses[Miscellaneous])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,Expenses[Total])","v":{"v":500.09906976744185,"d":"£500.10"}}]