{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sample-TA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Sample-TA","index":0,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,0,11,1],[11,2,11,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,1,5,2],[5,4,5,6],[6,1,6,2],[6,4,6,6],[7,1,7,2],[7,4,7,6],[8,1,8,2],[8,4,8,6],[10,0,10,1],[25,1,25,2],[12,0,12,6],[13,2,13,4],[13,5,13,6],[14,0,14,6],[18,0,18,6],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[39,1,39,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[37,1,37,2],[38,1,38,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[40,1,40,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[47,1,47,2]]}
["(Revised 7/1/22)",null,null,null,null,"T","321032",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":"22210"},{"$f":"IF(T2<12,RIGHT(L2,3),RIGHT(L2+500,3))","v":"210"},{"$f":"YEAR(NOW())","v":2022},{"$f":"MONTH(NOW())","v":7},{"$f":"DAY(NOW())","v":29},{"$f":"IF(O2<7,RIGHT(N2,1),RIGHT(N2+1,1))","v":"3"},{"$f":"INT(RAND()*(9-100)+100)","v":48},{"$f":"Q2&M2&R2","v":"321048"},{"$f":"HOUR(NOW())","v":11}]
["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:  ","Joe",null,"Department name:  ","Campus Recreation Services",null,null,"Employee","In-State","AM","Allowable","Airline",1,"Yes"]
["Traveler's last name:  ","Samples",null,"Email:  ","your_email@g.cofc.edu",null,null,"Non-State employee","Out-of-State","PM","Estimated","Personally owned vehicle",1,"No"]
["CWID #:  ",20000111,null,"Phone number:  ","555-555-5555",null,null,"Board of Trustee's","Foreign",null,null,"Rental car",1]
["Date of request:  ","2022-08-22",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,"Team travel","Travel type:  ","Out-of-State","Mode of transportation:  ","Personally owned vehicle","Team travel"]
["Business purpose of trip: (Requirement of South Carolina State Auditors Office):  ",null,"Windsurfing club participating in the Kitty Hawk Surf Trials."]
["Student Travel Liability Form"]
["Are student(s) travelling or associated with this trip? ","Yes","If YES, state which office or representative has collected \"Liability Release, Emergency Medical Authorization and Agreement\" for each student:",null,null,"Campus Recreation Services"]
["Itinerary information"]
["Departing from:  ","Charleston","Departure date:  ","2022-09-03","Departure time:  ",null,"Select one:"]
["Destination:  ","Kitty Hawk, NC","Return date:  ","2022-09-05","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 - To minimize personal risk, please"]
["utilize AAA for direct billing to the College."]
["Lodging","5 rooms at Hampton Inn, Outer Banks",null,360001,730511,"Estimated",1200]
[]
["Other transportation","Enterprise van",null,360001,730514,"Estimated",325]
[" "]
["Meals"]
[" "]
["Registration fees","Tournament entry fee",null,360001,730517,"Estimated",450]
[]
["Mileage (rate as of 7/1/22 is $0.625/ mile)"]
[]
[]
["Miscellaneous travel expenses (explain)","Gas",null,360001,730515,"Estimated",225]
[" "]
[null,null,null,null,null,"Total allowable or estimated travel expenses",{"$f":"SUM(G21:G35)","v":2200}]
[]
["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."]