{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,3,2,6],[40,7,40,8],[40,9,40,12],[44,2,44,8],[1,3,1,6],[19,0,19,12],[24,0,24,12],[25,0,25,1],[26,0,26,1],[27,0,27,1],[14,0,14,12],[15,0,15,1],[16,0,16,1],[17,0,17,1],[36,0,36,1],[37,0,37,1],[30,0,30,1],[38,0,38,1],[39,0,39,1],[40,0,40,6],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[24,13,24,18],[42,6,42,7],[42,3,42,4],[18,0,18,1],[0,0,0,12],[3,3,3,6],[4,2,4,3],[4,5,4,6],[1,10,1,12],[3,10,3,12],[8,4,8,12],[9,7,9,12],[11,4,11,12],[12,5,12,12],[28,0,28,1],[29,0,29,1]]}
["   CTSI Travel Request and Expense Report Worksheet"]
["Traveler Name:",null,null,null,null,null,null,null,null,"UFID:"]
[null,null,null,"as shown on drivers license"]
["Frequent Flyer #:"]
[null,"      Travel Dates:",null,null,"TO",null,null,null,null,null,"Domestic Travel"]
[null,null,null,null,null,null,null,null,null,null,"                   or"]
["Destination:",null,null,null,null,null,null,null,null,null,"International Travel"]
[]
[null,"        Purpose of Trip:"]
["         Sharing Expense Travel?                If yes, with whom?  "]
[null,null,null,null,null,null,null,null,"                            Name / UFID"]
["Contact Info for travel updates:"]
["Emergency Contact Person & Phone #: "]
[]
["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 (6-8)",6]
["L (12-2)",11]
["D (6-8)",19,null,null,null,null,null,null,null,null,null,null,"Total"]
["Per Diem",{"$f":"SUM(B21:B23)","v":36},{"$f":"(IF((C21=\"x\"),B21,\"0\")+IF((C22=\"x\"),B22,\"0\"))+IF((C23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((D21=\"x\"),B21,\"0\")+IF((D22=\"x\"),B22,\"0\"))+IF((D23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((E21=\"x\"),B21,\"0\")+IF((E22=\"x\"),B22,\"0\"))+IF((E23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((F21=\"x\"),B21,\"0\")+IF((F22=\"x\"),B22,\"0\"))+IF((F23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((G21=\"x\"),B21,\"0\")+IF((G22=\"x\"),B22,\"0\"))+IF((G23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((H21=\"x\"),B21,\"0\")+IF((H22=\"x\"),B22,\"0\"))+IF((H23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((I21=\"x\"),B21,\"0\")+IF((I22=\"x\"),B22,\"0\"))+IF((I23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((J21=\"x\"),B21,\"0\")+IF((J22=\"x\"),B22,\"0\"))+IF((J23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((K21=\"x\"),B21,\"0\")+IF((K22=\"x\"),B22,\"0\"))+IF((K23=\"x\"),B23,\"0\")","v":0},{"$f":"(IF((L21=\"x\"),B21,\"0\")+IF((L22=\"x\"),B22,\"0\"))+IF((L23=\"x\"),B23,\"0\")","v":0},{"$f":"SUM(C24:L24)","v":0}]
["Please highlight all expenses paid with a UF P-card",null,null,null,null,null,null,null,null,null,null,null,null,"UF P-Card Expense (Select \"x\" if true, else leave blank)"]
["Airfare",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C26:L26)","v":0}]
["Baggage Fee",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C27:L27)","v":0}]
["Agent Fee",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C28:L28)","v":0}]
["Lodging",null,null,null,null,null,null,null,null,null,null,null,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(C36:L36)*0.445","v":0}]
["Train / Ferry",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C37:L37)","v":0}]
["Portage",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C38:L38)","v":0}]
["Miscellaneous",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C39:L39)","v":0}]
["Rental Car",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C40:L40)","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,"      TA:",null,null,"       ER:",null,null,null,null,null,"Total P-Card Charges =",{"$f":"(IF(N26=\"x\",M26,0)+IF(N27=\"x\",M27,0)+IF(N28=\"x\",M28,0)+IF(N29=\"x\",M29,0)+IF(N30=\"x\",M30,0)+IF(N31=\"x\",M31,0)+IF(N32=\"x\",M32,0)+IF(N33=\"x\",M33,0)+IF(N34=\"x\",M34,0)+IF(N35=\"x\",M35,0)+IF(N36=\"x\",M36,0)+IF(N37=\"x\",M37,0)+IF(N38=\"x\",M38,0)+IF(N39=\"x\",M39,0)+IF(N40=\"x\",M40,0))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Due Traveler =",{"$f":"SUM(M24:M41)-M43","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}