{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["IDT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"IDT","index":0,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,3],[34,4,34,5],[31,4,31,5],[28,4,28,5],[1,0,1,7],[2,0,2,7],[7,6,7,7],[8,6,8,7],[9,6,9,7],[9,1,9,2],[3,0,3,7],[10,6,10,7],[7,1,7,2],[8,1,8,2],[30,4,30,5],[10,1,10,2],[24,0,24,2],[22,0,22,2],[23,0,23,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[28,1,28,3],[33,4,33,5],[33,2,33,3],[27,2,27,3],[30,2,30,3],[31,1,31,3],[27,4,27,5]]}
[null,null,null,null,null,"R",null,null,15,1,1,null,null,"yr","mo","da","fy","RAND",null,"HR"]
["College of Charleston\nIntradepartmental Transfer (IDT)\n(Submit to Controller's Office with proper support, after approval)",null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()&TEXT(TODAY(),\"yy\")&TEXT((TODAY() -DATEVALUE(\"1/1/\"&TEXT(TODAY(),\"yy\"))+1),\"000\")","v":"0.50864346103231617345"},{"$f":"IF(T2<12,RIGHT(L2,3),RIGHT(L2+500,3))","v":"032"},{"$f":"YEAR(NOW())","v":2017},{"$f":"MONTH(NOW())","v":12},{"$f":"DAY(NOW())","v":11},{"$f":"IF(O2<7,RIGHT(N2,1),RIGHT(N2+1,1))","v":"8"},{"$f":"INT(RAND()*(9-100)+100)","v":49},{"$f":"Q2&M2&R2","v":"803249"},{"$f":"HOUR(NOW())","v":16}]
["Reminder 1:  All IDT’s submitted for services related to Aramark require the Catered Meals Questionnaire Form (http://controller.cofc.edu/accounting-forms/index.php).\n\nIf the event is open to the campus community or general public, please also attach the Event Flyer.  If the event is open to the entire campus community or general public, please note this on the event flyers.\n\nIf the event is geared toward a Specific Club/Group, an Attendee List/Student Roster is required.  The Attendee List must include all attendees, including faculty, staff, students, external attendees, etc.  Please remember to attach this required support in all future submissions to avoid delays in processing.\n\nReminder 2 (Alcohol and related services):  In accordance with college policy for Payments to Vendors for Catered and Un-catered Meals at Statewide, Regional, or District Meetings, or Student Event/Activities (http://controller.cofc.edu/policies-and-procedures/index.php), any money administered by the College and held by the State Treasurer’s Office is considered State/College Funds, regardless of funding source (Tuition, Grants, etc.).  The payment for alcoholic beverages and related bar services (setup, bartending, corkage fees, liquor license, etc.) with State Funds or from any College index is strictly prohibited.  Invoices reflecting charges for alcoholic beverages and related bar services cannot be processed by the Controller’s Office and should not be billed via IDT.\n\nReminder 3 (Physical Plant work orders):  Effective 7/1/17, paper IDT's will no longer be accepted for Physical Plant work orders.  If you would like more information on the Physical Plant billable work order process, please visit: http://physicalplant.cofc.edu/services/chargeable-additional-services.php.",null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null," "]
["Note:  Data entry fields are in GREY, but will print WHITE to reduce toner usage  "]
[]
[null,"Date IDT prepared:",null,null,null,null,"Service date:"]
[]
["Service provider / payee / transferee (Credit):",null,null,null,null,"Service requestor / payer / transferor (Debit):"]
["Contact person:",null,null,null,null,"Contact person:"]
["email:",null,null,null,null,"email:"]
["Phone number:",null,null,null,null,"Phone number:"]
[]
[null,"Index","Account ","Amount",null,"Index","Account ","Amount"]
[]
[]
[]
[]
[null,null,"Should agree to total below",{"$f":"SUM(D14:D17)","v":0},null,null,"Should agree to total below",{"$f":"SUM(H14:H17)","v":0}]
[]
["Description of Goods or Services provided / Items / Special Instructions\n(Be as descriptive as possible - dates, etc.)",null,null,"Stock / Catalog number","Quantity","Unit price","Unit of issue (e.g. each, etc.)","Amount"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H21:H25)","v":0}]
[]
["Authorized Approver (REQUIRED):\n\nThis is a person who has the IDT Approver role checked on the Index/FOP Access Form for the Service requestor / payer / transferor index.\n\n(Proper supporting documentation is required):",null,null,null,null,null,"Date:  "]
[null,"Signature of authorized approver",null,null,"(Please print or type name)"]
[]
["IDT requested by:\n\nI certify that the items and/or services above have been ordered, and I will be held accountable once received:",null,null,null,null,null,"Date:  "]
[null,"Signature of receipt certification",null,null,"(Please print or type name)"]
[]
["Foundation Approval:\n\nFoundation Finance Office approval is required prior to submitting any IDT that is to be charged to the College of Charleston Foundation (990003).",null,null,null,null,null,"Date:  "]
[null,"Signature of authorized approver",null,null,"(Please print or type name)"]
["Revised 12/11/17"]