{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Travel Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Travel Log","index":0,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,10],[5,0,5,1],[2,0,2,1],[3,4,3,5],[8,2,8,3],[9,2,9,3],[40,0,40,1],[19,6,28,6],[36,3,36,4],[40,9,40,10],[38,1,38,10],[39,0,39,10],[33,5,34,5],[10,2,10,3],[18,0,18,9],[31,1,31,5],[33,6,34,10],[35,6,35,8],[14,2,14,3],[42,5,43,5],[43,2,43,3],[41,1,41,2],[40,4,40,5],[43,6,43,8],[42,0,42,3],[41,6,41,8],[0,1,0,10],[33,0,34,4],[35,0,35,1],[36,0,36,2],[4,0,4,1],[2,6,2,10],[32,1,32,5],[31,8,32,9],[31,6,32,7],[13,2,13,3],[17,2,17,3],[16,2,16,3],[11,2,11,3],[12,2,12,3],[15,2,15,3],[6,0,7,10]]}
[null,"MILEAGE/PARKING LOG FOR REIMBURSEMENT"]
["Instructions: Complete this form to request mileage and/or parking expense reimbursement for official UTSA business expenses incurred while traveling within Bexar County. Parking reimbursement for local area events may be requested when authorized or can be combined on a Business Expense Form (BEF) when meal costs are being reimbursed. Submit this request in-person to Fiscal Services (Downtown or Main Campus). Only the traveler or authorized proxy may pick up the reimbursement after showing a photo ID. All other reimbursements (including traveling to/from the airport) must be tied to a Travel Authorization (TA) and submitted to Disbursements & Travel Services or to the appropriate Research Service Center (RSC) (reimbursements charged to Sponsored Programs. See Mileage rate for Personal Vehicle Use, a section of the Travel Reimbursement Financial Guideline, for more information. "]
[" Traveler's Name:",null,null,null,null,"2019-01-01","Reimbursement Rates (per mile)"]
[null,"Department :",null,"Prepared by:",null,null,0.67,"for travel from: ","2024-01-01","to: ","2024-12-31"]
["Voucher ID: ",null,null,"Date Submitted: ",null,null,0.65500000000000003,"for travel from: ","2023-01-01","to: ","2023-12-31"]
["Travel Begin Date:",null,null,"Travel End Date:",null,null,0.625,"for travel from: ","2022-07-01","to: ","2022-12-31"]
["*Reimbursement requests for travel related expenses must be directly related to, or associated with, the active conduct of official university business. As a public institution, UTSA employees must ensure reimbursement requests for travel related expenses support UTSA's mission and purpose. Please fill out the appropriate Chartfield number with the correct date.  #1 travel must match #1 chartfield number."]
[]
["#","Date","Purpose of Event (Business Reason) /Event Name",null,"Parking Amount","Traveled From","Traveled To                         ","Total Miles (verified via MapQuest)","Rate Per Mile","Total "]
[1,null,null,null,null,null,null,null,{"$f":"IF(B10=\"\",\"\",IF(B10<DATE(2022,6,1),\"\",IF(B10<DATE(2023,1,1),$G$6,IF(B10<DATE(2024,1,1),$G$5,$G$4))))","v":""},{"$f":"IF(B10=\"\",\"\",E10+(H10*I10))","v":""}]
[{"$f":"A10+1","v":2},null,null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",IF(B11<DATE(2022,1,1),\"\",IF(B11<DATE(2022,7,1),$G$6,IF(B11<DATE(2024,1,1),$G$5,$G$4))))","v":""},""]
[{"$f":"A11+1","v":3},null,null,null,null,null,null,null,"",""]
[4,null,null,null,null,null,null,null,"",""]
[5,null,null,null,null,null,null,null,"",""]
[6,null,null,null,null,null,null,null,"",""]
[7,null,null,null,null,null,null,null,"",""]
[8,null,null,null,null,null,null,null,"",""]
[9,null,null,null,null,null,null,null,"",""]
["Chartfield Number"]
["#","Fund","Department","Cost Center","Function","Account","Grants and Projects ONLY listed to the Right.","PC Business Unit","Project","Activity ID"]
[1]
[{"$f":"A21+1","v":2}]
[{"$f":"A22+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[null,null,null,null,null,"TOTAL MILES CLAIMED:",{"$f":"SUM(H10:H18)","v":0},null," "]
[null,null,"TOTAL PARKING COST:",{"$f":"SUM(E10:E18)","v":0},null,"TOTAL MILEAGE COST:",{"$f":"I32-D31","v":0},null," "]
["Comments:",null,null,null,null,null," Total Reimbursement:",null,{"$f":"SUM(J10:J18)","v":0}]
[]
["Certification: I certify the information above is accurate. If requesting mileage reimbursement, I also certify that the point-to-point mileage has been verified using MapQuest. ",null,null,null,null,"Department Manager/ Supervisor Name:"]
[]
["Traveler Signature: ",null,null,"Date: ",null,"Signature: ",null,null,null,"Date:"]
["Proxy Funds Pickup Authorization (optional): I authorize",null,null,null,null,"to pickup the corresponding reimbursement from Fiscal Services on my behalf."]
[null,"FOR FISCAL SERVICES USE ",null,null,null,"Cash Disbursed by:"]
[]
["Office Use Only"]
["RSC Approved By\n(print name):",null,null,"Signature: ",null,null,null,null,"Date: "]
[" ","FOR FISCAL SERVICES USE",null,null,"Amount","Cash Disbursed By: "]
[" Parking Fees: Use Account Coding: 62109 (62310 or 62350 for Athletics)",null,null,null,{"$f":"D31","v":0}," Signature:"]
[" "," ","Mileage: Use Account Coding: 62102",null,{"$f":"G31","v":0},null,null,null,null,"Date:"]
[" "]