{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"TA","index":0,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,4,9,6],[13,0,13,6],[24,1,24,2],[25,1,25,2],[19,0,19,6],[20,1,20,2],[21,1,21,2],[23,1,23,2],[1,0,1,6],[4,0,4,6],[15,0,15,6],[12,2,12,6],[12,0,12,1],[14,2,14,4],[14,5,14,6],[11,0,11,1],[6,4,6,6],[9,1,9,2],[7,4,7,6],[6,1,6,2],[8,4,8,6],[7,1,7,2],[8,1,8,2],[3,0,3,6],[31,1,31,2],[33,1,33,2],[34,1,34,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[32,1,32,2],[2,0,2,6],[50,1,50,2],[51,1,51,2],[43,1,43,2],[22,1,22,2],[35,1,35,2],[30,1,30,2],[48,1,48,2],[49,1,49,2],[46,1,46,2],[45,1,45,2],[39,1,39,2],[41,1,41,2],[44,1,44,2],[40,1,40,2],[38,1,38,2]]}
["(Revised 1/1/24)",null,null,null,null,"T",null,15,null,1,1,null,null,"yr","mo","da","fy","RAND",null,"HR"]
["College of Charleston\nTravel Authorization",null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(TODAY(),\"yy\")&TEXT((TODAY() -DATEVALUE(\"1/1/\"&TEXT(TODAY(),\"yy\"))+1),\"000\")","v":"24011"},{"$f":"IF(T2<12,RIGHT(L2,3),RIGHT(L2+500,3))","v":"511"},{"$f":"YEAR(NOW())","v":2024},{"$f":"MONTH(NOW())","v":1},{"$f":"DAY(NOW())","v":11},{"$f":"IF(O2<7,RIGHT(N2,1),RIGHT(N2+1,1))","v":"4"},{"$f":"INT(RAND()*(9-100)+100)","v":69},{"$f":"Q2&M2&R2","v":"451169"},{"$f":"HOUR(NOW())","v":12}]
["NOTE:  If you experience issues creating the TA number due to the macros in the form, the macros will need to be enabled in your Trust Center Settings .  Please see the following IT knowledge base article for instructions on how to enable macros: KB0010914: Macros are Blocked in Microsoft Office"]
["Important notice:  Please DO NOT email controllers@cofc.edu:\n\nThe approved Travel Authorization (TA) Form should be submitted to the Controller's Office as follows:\n\nInteroffice mail OR email (accountspayable@cofc.edu)"]
["Important notices:\n\n1.  Please read the College's Travel policy in full before scheduling any travel plans.\n2.  When booking flights, travelers should utilize AAA.  This allows for direct billing to the College and reduces personal risk in cases where plans change or are canceled.\n2.  In order to be reimbursed for travel related expenses, this form must be completed regardless of the index to be charged.\n3.  Once the traveler has obtained all approvals, the form should be received in the Controller's Office NOT LESS THAN ten (10) business days prior to the commencement of travel.\n4.  State of South Carolina regulations provide \"that in traveling on business of the State, employees are required to use the most economical mode of transportation.\"  This regulation applies regardless of funding source (E&G, Foundation, Grants, etc.).",null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Select one:","Select one:","Select one:",null,"Select one:",null,"Select one:"]
["Traveler's first name:  ",null,null,"Department name:  ",null,null,null,"Employee","In-State","AM","Allowable","Airline",1,"Yes"]
["Traveler's last name:  ",null,null,"Email:  ",null,null,null,"Non-State employee","Out-of-State","PM","Estimated","Personally owned vehicle",1,"No"]
["CWID #:  ",null,null,"Phone number:  ",null,null,null,"Board of Trustee's","Foreign",null,null,"Rental car",1]
["Date of request:  ",null,null,"Fax number:  ",null,null,null,"Athletic recruiting","Official visit",null,null,"Other (explain)"]
[null,null,null,null,null,null,null,"Student"]
["College of Charleston affiliation:  ",null,"Select one:","Travel type:  ","Select one:","Mode of transportation:  ","Select one:","Team travel"]
["Business purpose of trip: (Requirement of South Carolina State Auditors Office):  "]
["Student Travel Liability Form"]
["Are student(s) travelling or associated with this trip? ","Select one:","If YES, state which office or representative has collected \"Liability Release, Emergency Medical Authorization and Agreement\" for each student:"]
["Itinerary information"]
["Departing from:  ",null,"Departure date:  ",null,"Departure time:  ",null,"Select one:"]
["Destination:  ",null,"Return date:  ",null,"Return time:  ",null,"Select one:"]
[]
["Allowable or Estimated travel cost"]
[" Travel Expense","Description",null,"Index\n(6 digits)","Account code\n(6 digits)","Allowable or Estimated (Select one from list)","Amount"]
["Airfare"]
[]
["Lodging"]
[]
["Other transportation"]
[" "]
["Meals"]
[" "]
["Registration fees"]
[]
["Mileage (rate as of 1/1/24 is $0.67/ mile)"]
["$0.655 for travel 1/1/23 ~ 12/31/23"]
[]
["Miscellaneous travel expenses (explain)"]
[" "]
[null,null,null,null,null,"Total allowable or estimated travel expenses",{"$f":"SUM(G22:G36)","v":0}]
[]
["Approved by:  ",null,null,"Date:  "]
[null,"Chair / Director / Department Head"]
[]
[null,"(Please print or type name)"]
[]
["Approved by:  ",null,null,"Date:  "]
[null,"Vice President / Dean"]
[]
[null,"(Please print or type name)"]
[]
["Approved by:  ",null,null,"Date:  "]
[null,"President / Provost / Executive Vice President / Foundation"]
[]
[null,"(Please print or type name)"]
[]
["FOR REIMBURSEMENT OF TRAVEL EXPENSES:"]
["1.  Attach a copy of your approved Travel Authorization form when submitting your Travel Reimbursement form to Accounts Payable, by mail or by email (accountspayable@cofc.edu)."]
["2.  Attach transportation ticket stubs, registration receipts, itemized hotel receipts, parking receipts, etc. to your Travel Reimbursement form."]
["3.  Keep a copy of your Travel Authorization form, Travel Reimbursement form, and supporting documentation for your records."]