{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Help","Travel Worksheet","Menu Data","password"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"Help","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["The purpose of this form is to ensure that we reimburse you for all travel expenses you are entitled to"]
[]
["Form Submission:"]
["Please put completed TER form and copies of receipts in the GROUP folder on the Share Drive - V:\\GROUP\\Requisition_TA-TER_Receipts\\1. New"]
[]
["Date:"]
["Enter dates traveled in mm/dd format. Contact Tami Ford for help if your trip lasted more than 10 days."]
[]
["Time Out and Time In:"]
["Please enter the time you started your trip under \"Time Out\" on day 1, and enter the time you returned from your trip under \"Time In\". There should be only one \"Time Out\" and one \"Time In\"."]
[]
["Meals:"]
["Please make a selection for each meal on each day of your trip. Select \"N/A\" for meals prior to the start of your trip, \"C\" for meals provided by the conference, or \"X\" for meals you should be reimbursed for. The form will automatically calculate the totals."]
[]
["Airfare, Lodging, etc:"]
["Please enter expense receipt amounts in the boxes for dates you were charged (use day 1 for charges paid prior to the start of your trip). Enter total if there were mutiple charges on the same day for the same service (i.e. Taxi, Tolls). If a P-card was used to pay the expense please higlight the box in which the expense was entered."]
[]
["Rental Car:"]
["If you rented a Class C (intermediate) or larger vehicle; please choose a reason from the drop down menu to justify the use of the larger vehicle. "]
[]
["Total P-Card  Charges:"]
["Please enter the total of all P-card charges (boxes you higlighted) on this line. The form will automatically subtract this total from the total expenses."]
[]
["Contact Us:"]
["Tami Ford - (352) 265-2505 or tford@ufl.edu"]

{"sheet":"Travel Worksheet","index":1,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,12],[3,1,3,6],[40,2,40,8],[41,2,41,8],[37,0,37,6],[37,7,37,8],[39,9,39,11],[41,9,41,11],[3,8,3,12],[5,1,5,12],[7,1,7,12],[37,9,37,12],[39,2,39,8],[14,0,14,1],[15,0,15,1],[16,0,16,12],[21,0,21,12],[22,0,22,1],[11,0,11,12],[12,0,12,1],[13,0,13,1],[9,3,9,9]]}
[]
["Traveler Name:"]
[]
["Travel Dates:",null,null,null,null,null,null,"TO"]
[]
["Destination:"]
[]
["Purpose of Trip:"]
[]
[null,null,null,"Agenda required if travel was to a conference on convention."]
[]
["ORIGINAL RECEIPTS SHOWING METHOD OF PAYMENT ARE REQUIRED BY THE STATE OF FLORIDA COMPTROLLER"]
[null,null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10"]
["Date (mm/dd)"]
["Time Out"]
["Time In"]
["Select \"x\" for meals to be reimbursed, or \"c\" for meals provided by the conference"]
["B (6am-8am)",6]
["L (12pm-2pm)",11]
["D (6pm-8pm)",19,null,null,null,null,null,null,null,null,null,null,"Total"]
["Per Diem",{"$f":"SUM(B18:B20)","v":36},{"$f":"(IF((C18=\"x\"),B18,\"0\")+IF((C19=\"x\"),B19,\"0\"))+IF((C20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((D18=\"x\"),B18,\"0\")+IF((D19=\"x\"),B19,\"0\"))+IF((D20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((E18=\"x\"),B18,\"0\")+IF((E19=\"x\"),B19,\"0\"))+IF((E20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((F18=\"x\"),B18,\"0\")+IF((F19=\"x\"),B19,\"0\"))+IF((F20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((G18=\"x\"),B18,\"0\")+IF((G19=\"x\"),B19,\"0\"))+IF((G20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((H18=\"x\"),B18,\"0\")+IF((H19=\"x\"),B19,\"0\"))+IF((H20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((I18=\"x\"),B18,\"0\")+IF((I19=\"x\"),B19,\"0\"))+IF((I20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((J18=\"x\"),B18,\"0\")+IF((J19=\"x\"),B19,\"0\"))+IF((J20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((K18=\"x\"),B18,\"0\")+IF((K19=\"x\"),B19,\"0\"))+IF((K20=\"x\"),B20,\"0\")","v":0},{"$f":"(IF((L18=\"x\"),B18,\"0\")+IF((L19=\"x\"),B19,\"0\"))+IF((L20=\"x\"),B20,\"0\")","v":0},{"$f":"SUM(C21:L21)","v":0}]
["Expenses"]
["Pcard Charges",null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10"]
["Airfare",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C24:L24)","v":0}]
["Agent Fee",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:L25)","v":0}]
["Lodging",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C26:L26)","v":0}]
["Internet / Com.",null,null,null,null,null,null,null,null,null,null,null,0]
["Reg. Fee",null,null,null,null,null,null,null,null,null,null,null,0]
["Parking",null,null,null,null,null,null,null,null,null,null,null,0]
["Fuel",null,null,null,null,null,null,null,null,null,null,null,0]
["Tolls",null,null,null,null,null,null,null,null,null,null,null,0]
["Taxi / Shuttle",null,null,null,null,null,null,null,null,null,null,null,0]
["Mileage",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C33:L33)*0.445","v":0}]
["Train / Ferry",null,null,null,null,null,null,null,null,null,null,null,0]
["Portage",null,null,null,null,null,null,null,null,null,null,null,0]
["Miscellaneous",null,null,null,null,null,null,null,null,null,null,null,0]
["Rental Car",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C37:L37)","v":0}]
["The state contract requires the rental of a subcompact (class A), compact (Class B), hybrid (class XG), or a justification signed by the traveler of the necessity for a larger vehicle.",null,null,null,null,null,null,"Justify Larger Car",null,"Choose reason for renting larger car."]
[]
["Notes:",null,null,null,null,null,null,null,null,"Total P-Card Charges =",null,null,{"$f":"SUM(B24:B37)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total Due Traveler =",null,null,{"$f":"SUM(M21,M24:M37)","v":0}]

{"sheet":"Menu Data","index":2,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["00:00:00","N/A","Choose reason for renting larger car."]
["00:30:00","X","No allowable class car available at time of rental."]
["01:00:00","C","Larger car needed to accommodate passengers/luggage (list passengers in notes)."]
["01:30:00",null,"No cars available with contract carrier."]
["02:00:00"]
["02:30:00"]
["03:00:00"]
["03:30:00"]
["04:00:00"]
["04:30:00"]
["05:00:00"]
["05:30:00"]
["06:00:00"]
["06:30:00"]
["07:00:00"]
["07:30:00"]
["08:00:00"]
["08:30:00"]
["09:00:00"]
["09:30:00"]
["10:00:00"]
["10:30:00"]
["11:00:00"]
["11:30:00"]
["12:00:00"]
["12:30:00"]
["13:00:00"]
["13:30:00"]
["14:00:00"]
["14:30:00"]
["15:00:00"]
["15:30:00"]
["16:00:00"]
["16:30:00"]
["17:00:00"]
["17:30:00"]
["18:00:00"]
["18:30:00"]
["19:00:00"]
["19:30:00"]
["20:00:00"]
["20:30:00"]
["21:00:00"]
["21:30:00"]
["22:00:00"]
["22:30:00"]
["23:00:00"]
["23:30:00"]

{"sheet":"password","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["password to edit is \"travel\""]