{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sub Request - Group Summary","Travel Request & Reconciliation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Sub Request - Group Summary","index":0,"n_rows":105,"n_cols":17,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,16],[104,1,104,16],[3,6,3,11],[3,13,3,16],[4,6,4,11],[4,13,4,16],[3,1,3,4],[16,5,16,16],[6,11,6,16],[7,11,7,16],[9,1,9,16],[4,1,4,4],[6,1,6,9],[7,2,7,9],[18,1,18,3],[19,2,19,3],[20,2,20,3],[22,1,22,6],[73,2,73,5],[33,6,33,16],[19,8,20,14],[38,1,38,16],[39,1,44,16],[74,6,74,8],[22,8,22,13],[22,15,22,16],[23,8,23,13],[23,15,23,16],[74,2,74,5],[73,13,73,16],[74,13,74,16],[46,1,46,11],[47,1,47,11],[73,9,73,12],[73,6,73,8],[23,1,23,6],[30,1,32,4],[26,1,26,16],[47,13,47,16],[46,13,46,16],[72,4,72,16],[72,1,72,3],[28,6,29,11],[32,6,32,10],[28,2,29,4],[28,13,29,16],[30,6,31,10],[30,11,31,11],[30,13,32,16],[79,2,79,5],[79,6,79,8],[79,9,79,12],[79,13,79,16],[75,13,75,16],[76,2,76,5],[76,6,76,8],[76,9,76,12],[76,13,76,16],[77,2,77,5],[77,6,77,8],[77,9,77,12],[77,13,77,16],[75,2,75,5],[75,6,75,8],[75,9,75,12],[78,2,78,5],[78,6,78,8],[78,9,78,12],[78,13,78,16],[74,9,74,12],[82,2,82,5],[82,6,82,8],[82,9,82,12],[82,13,82,16],[83,2,83,5],[83,6,83,8],[83,9,83,12],[83,13,83,16],[80,2,80,5],[80,6,80,8],[80,9,80,12],[80,13,80,16],[81,2,81,5],[81,6,81,8],[81,9,81,12],[81,13,81,16],[87,13,87,16],[84,2,84,5],[84,6,84,8],[84,9,84,12],[84,13,84,16],[85,2,85,5],[85,6,85,8],[85,9,85,12],[85,13,85,16],[0,1,0,16],[97,10,97,15],[96,10,96,11],[96,1,96,9],[94,1,94,8],[100,1,102,16],[99,1,99,16],[94,9,94,12],[94,13,94,16],[10,1,11,3],[10,4,11,16],[88,2,88,5],[88,6,88,8],[88,9,88,12],[88,13,88,16],[91,2,91,5],[91,6,91,8],[91,9,91,12],[91,13,91,16],[89,2,89,5],[89,6,89,8],[89,9,89,12],[89,13,89,16],[86,2,86,5],[103,1,103,16],[19,15,19,16],[20,15,20,16],[90,2,90,5],[90,6,90,8],[90,9,90,12],[90,13,90,16],[92,2,92,5],[92,6,92,8],[92,9,92,12],[92,13,92,16],[93,2,93,5],[93,6,93,8],[93,9,93,12],[93,13,93,16],[96,13,96,16],[97,8,97,9],[49,1,49,16],[86,6,86,8],[86,9,86,12],[86,13,86,16],[87,2,87,5],[87,6,87,8],[87,9,87,12]]}
[null,"SANTA ANA UNIFIED SCHOOL DISTRICT"]
[null,"Conference Sub Request / Group Summary\n- Use this form when a sub is required and/or more than one employee is attending an event -"]
[]
[]
[null,"Office Admin. (Name)",null,null,null,null,"Dept./Site",null,null,null,null,null,null,"Phone Number"]
[]
[]
[null,null,"Event/Conference/Training Name",null,null,null,null,null,null,null,null,"Event Location"]
[null,false]
[null,"SUBSTITUTE REQUEST"]
[null,"Instructions:",null,null,"If subs are required, complete and submit this section of the form to the HR Sub Desk.   \nOnce sub approval is received, employee(s) can prepare travel/conference request form.  \nIf there is more than one traveler, continue to the Group Travel section below."]
[]
[]
[null,"Indicate Designated Programs with [ X ]:"]
[null,null,null,"Staff Development/Mentor"]
[null,null,null,"Special Education"]
[null,null,null,"Other - Specify"]
[]
[null,"Absence Info:",null,null,"Date",null,"Time"]
[null,null,"From:",null,null,null,null,null,"Anticipated Number of Substitutes Needed:"]
[null,null,"To:"]
[]
[]
[null,"Site/Dept. Administrator (Print)",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,"Date"]
[]
[]
[null,"SUBSTITUTE AVAILABILITY:  This section to be completed by the HR Sub Desk upon verifying sub availability"]
[]
[null,null,"Substitute Request\nApproved in Full",null,null,null,"Partial Approval Due to\nLimited Substitute Availability",null,null,null,null,null,null,"No Substitute\nAvailablility"]
[]
[null,"All requested subs have been reserved for this request.",null,null,null,null,"Number of substitutes available and reserved for this request:",null,null,null,null,null,null,"There are no substitutes available for your requested dates."]
[]
[null,null,null,null,null,null,"Number of unavailable substitutes:"]
[null,null,null,null,null,null,"For Limited or No Availability:"]
[]
[null,null,null,null,null,null,null,null,null,"Covering from within"]
[null,null,null,null,null,null,null,null,null,"Other - Detail in notes section below"]
[]
[null,"Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Signature",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,"GROUP SUMMARY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:",null,null,"Complete this section of the form if there is more than one traveler from your site/dept"]
[null,null,"Participant's Name:",null,null,null,"Participant's Title:",null,null,"Estimated Total Cost \nper Travel/Conference Request Form:",null,null,null,"Notes:"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,"Total Estimated Cost of Event Attendance and Travel:",null,null,null,null,null,null,null,{"$f":"SUM($J$75:$J$94)","v":0},null,null,null," (Enter this total on requisition)"]
[null,"-Select One-","Yes","No","N/A - no cost"]
[null,"Registration costs to be processed via Purchasing Dept. (preferred):",null,null,null,null,null,null,null,null,null,null,null,"-Select One-"]
[null,{"$f":"IF($N$97=\"YES\",\"What is the event registration cost per person?\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($N$97=\"YES\",\"Total Registration Cost:\",\"\")","v":""},null,null,null,null,null,{"$f":"(IF($N$97=\"YES\",COUNTA($C$75:$F$94)*$I$98,\"\"))","v":""}]
[]
[null,{"$f":"IF($N$97=\"NO\",\"If registration costs are not to be processed by the Purchasing Dept. an explanation is required below:\",\"Additional Notes:\")","v":"Additional Notes:"}]
[]
[]
[]
[]
[null,"The following items must be attached to the conference requisition:  This form (with approvals if subs are required), a Travel/Conference Request and Reconciliation Form for each traveler, registration info, and an agenda/itinerary."]

{"sheet":"Travel Request & Reconciliation","index":1,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,2,64,20],[22,3,22,5],[58,2,63,2],[58,3,58,19],[59,3,63,20],[53,4,54,8],[53,9,54,10],[56,4,56,16],[55,12,55,16],[53,12,54,18],[51,2,57,2],[51,4,51,19],[38,6,39,10],[31,4,31,12],[32,4,32,12],[33,16,33,17],[0,0,1,1],[53,19,54,19],[21,2,49,2],[52,12,52,16],[9,2,20,2],[3,0,37,1],[37,7,37,8],[37,12,37,19],[38,12,38,19],[7,16,7,19],[0,2,1,20],[2,2,8,2],[3,4,3,6],[3,8,3,11],[3,12,3,14],[3,16,3,19],[4,3,4,6],[4,8,4,11],[4,12,4,14],[4,16,4,19],[6,4,6,8],[6,10,6,14],[6,16,6,19],[7,3,7,8],[7,10,7,14],[15,4,15,5],[15,10,15,11],[10,4,10,14],[10,16,10,19],[11,3,11,14],[11,16,11,19],[13,4,13,16],[15,18,17,19],[16,4,16,5],[17,4,17,5],[16,10,16,11],[17,10,17,11],[19,10,19,11],[19,12,19,19],[19,4,19,9],[30,8,30,11],[28,4,28,12],[26,16,26,17],[26,10,26,11],[24,16,24,17],[23,16,23,17],[27,16,27,17],[28,16,28,17],[24,4,24,12],[22,16,22,17],[21,14,21,19],[35,16,35,17],[40,0,40,1],[47,16,47,17],[48,16,48,17],[31,16,31,17],[32,16,32,17],[41,0,50,1],[44,16,44,19],[45,16,45,19],[41,16,42,19],[43,16,43,19],[50,5,50,17]]}
["When opening this workbook, if prompted, ensure to “enable editing” and “enable content” in the yellow bar below the menu.\n\nThis form MUST be completed in Excel. \n",null,"SANTA ANA UNIFIED SCHOOL DISTRICT\nTravel/Conference Request and Reconciliation"]
[]
[null,null,"TRAVELER"]
["INSTRUCTIONS:\nTravel/Conference Request Portion:\n1)  Complete all of the blue pre-travel fields on the form (Traveler, Event/Travel Info, and Estimated Expenses).\n\n2)  Save and submit form to your Office Admin. for the conference requisition submission (due no less than 6 weeks prior to travel).  The following items must be attached to the conference requisition: \n- Conference Sub Request / Group Summmary Form (if applicable)\n- This form\n- Registration information \n- Agenda/itinerary\n\nTravel/Conference Reconciliation Portion (Post-Travel):\n3) Complete all of the orange post-travel fields on the form (actual and allowable expenses).\n\n4)  Submit completed form via iExpense (instructions on Accounting Dept. website) within 30 days upon return from travel, even if there are no reimbursable costs.  These items must be attached to the iExpense claim:\n- This form\n- All required travel backup:  receipts (not required for meals), mileage verification (GoogleMaps/MapQuest), GSA hotel rate verification (screenshot).\n*iExpense claims submitted later than 60 days may be taxable income to the employee in accordance with IRS regulations.\n\nIMPORTANT:\nFor any actual expenses that are significantly greater than original estimates or the actual nightly hotel rate exceeds the GSA rate (pre-tax), details must be provided in the Explanation Section, in order to explain the increased costs incurred.  The traveler may be responsible for any unjustified increases in cost between estimated and actual.\n"]
[null,null,null,"Employee ID",null,null,null,null,"Last Name",null,null,null,"First Name",null,null,null,"Job Title"]
[]
[]
[null,null,null,"Site/Department",null,null,null,null,null,null,"Work Email",null,null,null,null,null,"Work Phone"]
[]
[null,null,"EVENT/TRAVEL INFO"]
[]
[null,null,null,"Name of Event",null,null,null,null,null,null,null,null,null,null,null,null,"City, State of Event"]
[null,null,null,null,"Overview/Rationale:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Check box if sub required"]
[]
[null,null,null,null,"EVENT INFO:",null,"Date",null,"Time",null,"TRAVEL INFO:",null,"From/To:","select one:","Date",null,"Time",null,{"$f":"IF($S$14=TRUE,\"Subs must be pre-approved through the HR Sub Desk\",\"\")","v":""},null,"Select One:"]
[null,null,null,null,"Event Start:",null,null,null,null,null,"Depart:",null,"select one:","home",null,null,null,null,null,null,"Home"]
[null,null,null,null,"Event End:",null,null,null,null,null,"Return:",null,"select one:","worksite",null,null,null,null,null,null,"Work Site"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($O$17=\"\",$Q$17=\"\",$O$18=\"\",$Q$18=\"\"),\"\",TEXT(($O$18+$Q$18)-($O$17+$Q$17),\"[h]\"))","v":""}]
[null,null,null,{"$f":"TODAY()","v":"2017-03-21"},"Conference Requisition Submission Deadline:",null,null,null,null,null,{"$f":"IF($O$17=\"\",\"\",$O$17-42)","v":""},null,{"$f":"IF($D$20>$K$20,\"Less than 6 weeks prior to event - justification required\",\"Requisitions submitted after deadline require justification\")","v":"Requisitions submitted after deadline require justification"}]
[]
[null,null,"TRAVEL/CONFERENCE EXPENSES",null,null,null,null,null,null,null,null,null,null,null,"Allowable Expenses"]
[null,null,null,"1. Registration",null,null,"Once approved, how will registration be paid:",null,null,null,null,null,null,null,"Estimated:",null,"District Paid:",null,null,"Personal:"]
[null,null,null,null,false,null,null,null,false]
[null,null,null,null,{"$f":"IF(AND($I$24=TRUE,$E$24=FALSE),\"- Site/Dept. Cal-Card: explanation required below -\",IF(AND($E$24=TRUE,$I$24=FALSE),\"- Include all registration details in submission -\",IF(AND($E$24=TRUE,$I$24=TRUE),\"- Please only check one of the boxes above -\",\"\")))","v":""}]
[null,null,null,"2. Transportation",null,null,"Estimated:",null,"Actual:"]
[null,null,null,null,"   Mileage",null,null,null,null,null,"@",null,0.53500000000000003,null,{"$f":"+$G$27*$M$27","v":0},null,null,null,null,{"$f":"+$I$27*$M$27","v":0}]
[null,null,null,null,"   Airfare"]
[null,null,null,null,"   Ground Transportation - shuttle/ride service/train/rental car/etc."]
[null,null,null,"Total Transportation:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($O$27:$O$29)","v":0},null,{"$f":"SUM($Q$27:$Q$29)","v":0},null,null,{"$f":"SUM($T$27:$T$29)","v":0}]
[null,null,null,"3. Other Expenses"]
[null,null,null,null,"Enter other expenses here"]
[null,null,null,null,"Enter other expenses here"]
[null,null,null,null," Total Other Expenses:",null,null,null,null,null,null,null,null,null,{"$f":"SUM($O$32:$O$33)","v":0},null,{"$f":"SUM($Q$32:$Q$33)","v":0},null,null,{"$f":"SUM($T$32:$T$33)","v":0}]
[null,null,null,"4. Lodging",null,null,null,null,null,null,"GSA:",null,"Actual:",null,"(pre-tax)"]
[null,null,null,null,"# of Nights:",null,null,null,null,"Pre-Tax Nightly Rate:",null,null,null,null,{"$f":"+K36*$F$36","v":0}]
[]
[null,null,null,"5.  Meals per Diem (Max):",null,null,null,51,null,null,null,false,{"$f":"IF($L$38=TRUE,\"You have indicated that some meals are provided by the hotel\",\"Check box if ANY meals are provided by hotel and/or conference\")","v":"Check box if ANY meals are provided by hotel and/or conference"}]
[null,null,null,null,null,null,"Select full day OR individual meals below:",null,null,null,null,null,{"$f":"IF($L$38=TRUE,\"and/or conference; do not include those meals below.\",\"\")","v":""}]
[null,null,null,false]
["Meal Entitlements Based on Travel Status:",null,null,null,"Date:",null,51,null,{"$f":"ROUND($H$38*0.22222,0)","v":11},null,{"$f":"ROUND($H$38*0.3005,0)","v":15},null,{"$f":"ROUND($H$38*0.49,0)","v":25},null,"Entitlement:",null,false]
["An employee is considered in travel status for the required time period necessary to travel to and from home/worksite in order to attend the event.\n\nBreakfast - in travel status before 7 am and extending for at least 4 hrs.\n...   \nLunch - in travel status between 8 & 11 am and extending for at least 4 hrs.\n...\nDinner - in travel status after 3 pm and extending for at least 4 hrs.",null,null,null,{"$f":"IF(OR($O$17=\"\",$O$18=\"\",$Q$17=\"\",$Q$18=\"\",$Q$19<4),\"\",$O$17)","v":""},null,false,null,false,null,false,null,false,null,{"$f":"IF(E42=\"\",,IF(AND(G42=TRUE,OR(I42=TRUE,K42=TRUE,M42=TRUE)),\"Error\",IF(AND(G42=TRUE,I42=FALSE,K42=FALSE,J42=FALSE),$G$41,IF(G42=FALSE,SUMIF(I42:M42,\"TRUE\",$I$41:$M$41),\"\"))))","v":0},null,"advance of meal entitlement (due to hardship)"]
[null,null,null,null,{"$f":"IF($E$42=\"\",\"\",IF($E$42+1<=$O$18,$E$42+1,\"\"))","v":""},null,false,null,false,null,false,null,false,null,{"$f":"IF(E43=\"\",,IF(AND(G43=TRUE,OR(I43=TRUE,K43=TRUE,M43=TRUE)),\"Error\",IF(AND(G43=TRUE,I43=FALSE,K43=FALSE,J43=FALSE),$G$41,IF(G43=FALSE,SUMIF(I43:M43,\"TRUE\",$I$41:$M$41),\"\"))))","v":0}]
[null,null,null,null,{"$f":"IF($E$42=\"\",\"\",IF($E$42+2<=$O$18,$E$42+2,\"\"))","v":""},null,false,null,false,null,false,null,false,null,0,null,{"$f":"IF(AND($Q$41=TRUE,$O$49>100,$D$20<$K$20),\"Accounting Dept. Initials & Date\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($E$42=\"\",\"\",IF($E$42+3<=$O$18,$E$42+3,\"\"))","v":""},null,false,null,false,null,false,null,false,null,0]
[null,null,null,null,{"$f":"IF($E$42=\"\",\"\",IF($E$42+4<=$O$18,$E$42+4,\"\"))","v":""},null,false,null,false,null,false,null,false,null,0,null,{"$f":"IF(AND($Q$41=TRUE,$O$49>100,$D$20<$K$20),\"________________________________\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($E$42=\"\",\"\",IF($E$42+5<=$O$18,$E$42+5,\"\"))","v":""},null,false,null,false,null,false,null,false,null,0]
[null,null,null,null,null,null,false,null,false,null,false,null,null,null,0,null,"75% Advance:",null,null,"Personal:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total  Entitlement:",{"$f":"SUM($O$42:$O$48)","v":0},{"$f":"IF(AND(#REF!=TRUE,#REF!=\"Accounting Dept. Initials and Date_____________________________\"),$M$49*0.75,)","v":{"$error":"#REF!"}},{"$f":"IF(AND($Q$41=TRUE,$Q$44=\"Accounting Dept. Initials and Date\"),$O$49*0.75,)","v":0},null,null,{"$f":"+O49","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(AND($Q$41=TRUE,$O$49>100,$D$20<$K$20),\"Advance will be available for pick up from the Accounting Dept. 1 week prior to travel\",IF(AND($Q$41=TRUE,$O$49<=100),\"Ineligible for advance - total entitlement must exceed $100\",IF(AND($Q$41=TRUE,$D$20>$K$20),\"Ineligible for advance - less than 6 weeks prior to travel\",\"\")))","v":""}]
[null,null,"SUMMARY",null,"- Attach all required travel backup to this sheet and submit via iExpense (even if there are no reimbursable costs) -"]
[]
[null,null,null,null,"Total Estimated Cost:\n(Amount to be entered into requisition)",null,null,null,null,{"$f":"+$O$24+$O$30+$O$34+$O$36+$O$49","v":0},null,null,"Total iExpense Claim:\n(Amount to be entered into iExpense)",null,null,null,null,null,null,{"$f":"+$T$30+$T$34+$T$36+$T$49","v":0}]
[]
[]
[null,null,null,null,"Total Actual Cost of Attendance and Travel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$Q$24+$Q$30+$T$30+$Q$34+$T$34+$Q$36+$T$36+$T$49","v":0}]
[]
[null,null,"EXPLANATION","- Use this area to detail any items that require additional explanation/justification (see instructions) -"]
[]
[]
[]
[]
[]
[null,null,"-ALL TRAVEL EXPENSES MUST BE IN ACCORDANCE WITH DISTRICT TRAVEL GUIDELINES AND ANY UNALLOWABLE OR EXCESIVE COSTS MAY BE DISALLOWED DURING REVIEW OF THE CLAIM-"]