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

{"sheet":"Travel Expense Report","index":0,"n_rows":13,"n_cols":14,"rows_kept":13,"merged":[[1,3,1,9],[1,10,1,12],[2,3,2,9],[2,10,2,12]]}
[null,"Travel Expense Report"]
[null,"Name",null,"Date Submitted"]
[null,"Department",null,"Authorized by"]
[null,"Period",{"$f":"\"From \"&TEXT(MIN(B9:B12),\"m/d/yy\")&\" to \"&TEXT(MAX(B9:B12),\"m/d/yy\")","v":"From 8/12/17 to 8/12/17"}]
[null,"Per Mile Reimbursement",0.32]
[null,"Total Reimbursement Due",{"$f":"$N13","v":{"v":618.2,"d":"$618.20"}}]
[]
[null,"Date","Description of Expense","Airfare","Lodging","Ground Transportation (Gas, Rental Car, Taxi)","Meals & Tips","Conferences \nand Seminars","Miles (Personal Car Only)","Mileage \nReimbursement","Miscellaneous","Currency \nExchange  Rate","Expense \nCurrency","Total"]
[null,{"$f":"TODAY()","v":"2017-08-12"},"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.000"},{"$f":"IFERROR(I9*$C$5, \"\")","v":{"v":11.200000000000001,"d":"$11.20"}},null,{"v":1,"d":"1.000"},"USD",{"$f":"IFERROR(SUM(J9:K9,D9:H9)*L9,\"\")","v":{"v":618.2,"d":"$618.20"}}]
[{"$nulls":9},{"$f":"IFERROR(I10*$C$5, \"\")","v":{"v":0,"d":"$0.00"}},{"$nulls":3},{"$f":"IFERROR(SUM(J10:K10,D10:H10)*L10,\"\")","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[{"$nulls":9},{"v":0,"d":"$0.00"},{"$nulls":3},{"v":0,"d":"$0.00"}]
[null,"Totals",{"$nulls":7},{"$f":"SUBTOTAL(109,Expenses[Mileage \nReimbursement])","v":{"v":11.200000000000001,"d":"$11.20"}},{"$nulls":3},{"$f":"SUBTOTAL(109,Expenses[Total])","v":{"v":618.2,"d":"$618.20"}}]