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

{"sheet":"Travel Expense Report","index":0,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[0,0,0,4],[2,5,2,7],[2,9,2,11],[4,5,4,7],[4,9,4,11]]}
["Travel Expense Report"]
[]
["Name",{"$nulls":7},"Date Submitted"]
["Department"]
["Period",{"$f":"\"From \"&TEXT(MIN(A10:A21),\"m/d/yy\")&\" to \"&TEXT(MAX(A10:A21),\"m/d/yy\")","v":"From 3/12/16 to 3/12/16"},{"$nulls":6},"Authorized by"]
["Per Mile Reimbursement",0.32]
["Total Reimbursement Due",{"$f":"$M22","v":{"v":618.2,"d":"$618.20"}}]
[]
["Date","Description of Expense","Airfare","Lodging","Ground Transportation \n(Gas, Rental Car, Taxi)","Meals & Tips","Conferences \nand Seminars","Miles \n(Personal Car Only)","Mileage \nReimbursement","Miscellaneous","Currency \nExchange  Rate","Expense \nCurrency"," U.S. $"]
["2016-03-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"},35,{"$f":"H10*$B$6","v":{"v":11.200000000000001,"d":"$11.20"}},null,1,"USD",{"$f":"SUM(I10:J10,C10:G10)*K10","v":{"v":618.2,"d":"$618.20"}}]
[{"$nulls":8},{"$f":"H11*$B$6","v":{"v":0,"d":"$0.00"}},null,1,null,{"$f":"SUM(I11:J11,C11:G11)*K11","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
[{"$nulls":8},{"v":0,"d":"$0.00"},null,1,null,{"v":0,"d":"$0.00"}]
["Totals",{"$nulls":7},{"$f":"SUBTOTAL(109,[Mileage \nReimbursement])","v":{"v":11.200000000000001,"d":"$11.20"}},{"$nulls":3},{"$f":"SUBTOTAL(109,[ U.S. $])","v":{"v":618.2,"d":"$618.20"}}]