{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Request Form ","Form","Instructions","Example"],"not_rendered":{"charts":0,"images":32,"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":"Request Form ","index":0,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,4,4,5],[4,7,4,8],[31,6,31,8],[29,7,29,8],[5,6,5,8],[23,3,23,4],[26,3,26,4],[21,3,21,4],[22,3,22,4],[20,3,20,5],[29,1,29,2],[24,1,24,9],[26,8,26,9],[27,2,27,7],[56,1,56,9],[35,9,35,10],[37,9,37,10],[38,1,38,9],[34,2,34,9],[43,1,43,9],[42,4,42,5],[42,2,42,3],[40,1,40,9],[36,2,36,7],[37,2,37,7],[42,6,42,7],[41,2,41,3],[41,8,41,9],[42,8,42,9],[3,2,3,3],[5,2,5,4],[41,4,41,5],[41,6,41,7],[0,1,0,11],[18,1,18,9],[33,1,33,9],[39,1,39,9],[16,2,16,9],[19,5,19,8],[7,1,7,9],[8,2,8,9],[13,8,13,9],[14,2,14,9],[2,1,2,11],[5,9,5,10]]}
[null,"PBSC Travel Request"]
[]
[null,"Travelers' Information"]
[null,"Pay to Type:","Payee Name: Last",null,"First",null," ",null,"Traveler ID:"]
[null,null," ",null," ",null,null," "]
[null,null,null,null,null,"Campus:"]
[]
[null,"Travel Detail"]
[]
[null,"Dest ind:",null,null,null,"Destination:",null,null,"Student Travel:  "]
[]
[null,"Departure City:"," ",null,null,"Return City:"," ",null,"Funds Requested:"]
[null,"    Departure Date:"," ",null,null,"Return Date:"," ",null,"Ride with Others:"]
[null,"Departure Time:",null,null,null,"Return Time:"]
[null,"Travel Purpose:"]
[]
[null,"Other Staff Traveling:"]
[]
[null,"Projected Travel Expenses"]
[null,"College Car:"]
[null,"Personal Car:",null,null,null,null,"Official Miles:",null,"Cost:",{"$f":"+H21*0.445","v":0}]
[null,"*1 Rental Car:",null,"P-Card:",null,null,"Number of Days:",null,"Cost:",null,null,null,null,null," "]
[null,"Common Carrier:",null,"P-Card:",null,"Other Direct Payment:",null,null,"Cost:"]
[null,"Registration Fee:",null,"P-Card:",null,"Request Check:","Other:",null,"Cost:"]
[null,"           Hotel Information:"]
[null,"Rate per Night:",null,"No. of Nights:",null,"No. of  Rooms:",null,null,"Cost:",{"$f":"+C26*E26*G26","v":0}]
[null,null,"Payment Method for Hotel:","P-Card:",null,"Request Check:","Other:",null," "]
[null,"Meal Information- ","If Using Meal Per Diem  Enter Information In Meal Per Diem Calculation Box Below",null,null,null,null,null,"Meal Per Diem:",{"$f":"IF(G29>0,\"0\",(+C32*D32)+(C33*D33)+(C31*D31))","v":0}]
[null,"Flat Per Diem:",null,"Enter Number of Quarters if Using Flat Rate",null,null,null,null,"Flat Per Diem:",{"$f":"IF((C33+C32+C31)>0,\"0\",(+G29*20))","v":0}]
[null,"Meal Per Diem Calculation :",null,"Meal Rate"," ",null,null,"Tolls Cost:"]
[null,"Number Breakfasts ",0,6,null,null,null,null,"Luggage, Parking, Ground Transportation & Other Expenses Cost:"]
[null,"Number of Lunch",0,11,null,null,"Estimated Total Cost of Trip:",null,null,{"$f":"SUM(J21:J31)","v":0}]
[null,"Number of Dinners",0,19,null,null,null,null,"Authorized Total Cost if Applicable:"]
[null,"Additional Information"]
[null,"Travel Notes:","   "]
[null,"Payment Information if Requesting College Check:",null,null,null,null,null,null,"Pick up Check","Date Needed"]
[null,"Hotel & Address"," ",null,null,null,null,null,"Must be Picked Up  "," "]
[null,"Registration Vendor & Address:"," ",null,null,null,null,null,"Y            N"," "]
[null," Confirmation(s) Must be Attached for College Checks, Conference Agenda Must be Attached"]
[null,"Certification"]
[null,"I hereby certify that travel as shown above is to be incurred in connection with official business of the State"]
[]
[null,"Traveler Name","Traveler Signature",null,"Supervisor Name",null,"Supervisor Signature",null,"Budget Manager Signature"]
[null,"Account Information"]
[null,null,"*State Org Unit","*Qual1","*Loc","GLC","*Amount"]
[]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,"Total",null,null,null,{"$f":"SUM(G46:G48)","v":0}]
[]
[null,"Form: FIN-ACP-005-1"]
[]
[]
[]
[]
[]
[null,"Completed forms can be mailed to MS#59, scanned, or e-mailed to travel@palmbeachstate.edu. Please do not fax. Forms that are not legible will need to be resubmitted. Remember to have forms signed and to submit with the Conference Agenda. If a College check is requested, submit confirmation receipts for registration or hotel with Travel Request. 1Employees must use State Vehicle Rental Vendor"]

{"sheet":"Form","index":1,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[41,2,41,10],[54,2,54,10],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[40,3,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[38,2,38,10],[27,2,27,4],[27,8,27,9],[29,7,29,9],[31,2,31,10],[32,3,32,10],[33,10,33,11],[34,3,34,8],[35,3,35,8],[35,10,35,11],[36,2,36,10],[37,2,37,10],[25,6,25,8],[13,14,13,16],[14,3,14,10],[14,14,14,16],[16,3,16,10],[18,2,18,10],[19,6,19,9],[19,14,19,16],[21,4,21,5],[21,15,21,16],[22,4,22,5],[23,4,23,5],[24,4,24,5],[8,14,8,16],[0,2,0,12],[2,2,2,12],[3,3,3,4],[4,3,4,4],[4,5,4,6],[4,8,4,9],[5,3,5,5],[5,7,5,9],[5,10,5,11],[7,2,7,10],[8,3,8,10],[1,3,1,6]]}
[null,null,"PBSC Travel Request"]
[null,null,"Date of Request: "," "]
[null,null,"Travelers' Information"]
[null,null,"Pay to Type:","Payee Name: Last",null,"First",null,null,null,"Traveler ID:"]
[null,null,null," ",null," "]
[null,null,null,null,null,null,"Campus:"]
[]
[null,null,"Travel Detail"]
[]
[null,null,"Dest ind:",null,null,null,"Destination:"," ",null,"Student Travel:  "]
[]
[null,null,"Departure City:"," ",null,null,"Return City:"," ",null,"Funds Requested:"]
[null,null,"    Departure Date:"," ",null,null,"Return Date:"," ",null,"Ride with Others:"]
[null,null,"Departure Time:",null,null,null,"Return Time:"]
[null,null,"Travel Purpose:","Enter business reason for the travel. "]
[]
[null,null,"Other Staff Traveling:","none"]
[]
[null,null,"Projected Travel Expenses"]
[null,null,"College Car:"]
[null,null,"Personal Car:",null,null,null,null,"Official Miles:",null,"Cost:",{"$f":"+I21*0.445","v":0}]
[null,null,"Rental Car:",null,"P-Card:",null,null,"Number of Days:",null,"Cost:"]
[null,null,"Common Carrier:",null,"P-Card:",null,null,"Other:",null,"Cost:"]
[null,null,"Registration Fee:",null,"P-Card:",null,null,"Request Check:",null,"Cost:",0]
[null,null,"Room Cost:",null,"P-Card:",null,null,"Request Check:",null,"Cost:",0]
[null,null,"Meals:",null,null,"Calc Meals:",null,null,null,"Meal Per Diem:",{"$f":"IF(D27>0,\"0\",(+D30*E30)+(D31*E31)+(D29*E29))","v":0}]
[null,null,"Flat Per Diem:",null,"Enter Number of Quarters if Choosing this Option",null,null,null,null,"Per Diem Cost:",{"$f":"IF((D31+D30+D29)>0,\"0\",(+D27*20))","v":0}]
[null,null,"Enter number of meals for each category below:",null,null," ",null,null,"Tolls Cost:"]
[null,null,"Number Breakfasts ",null,6,null,null,null,null,"Luggage, Parking, Ground Transportation & Other Expenses Cost:",0]
[null,null,"Number of Lunch",null,11,null,null,"Estimated Total Cost of Trip:",null,null,{"$f":"SUM(K21:K29)","v":0}]
[null,null,"Number of Dinner ",null,19,null,null,null,null,"Authorized Total Cost if Applicable:"]
[null,null,"Additional Information"]
[null,null,"Travel Notes:"," "]
[null,null,"Payment Information if Requesting College Check:",null,null,null,null,null,null,"Pick up Check","Date Needed:"]
[null,null,"Hotel & Address","enter complete hotel name here, (vendor number ask since they can look up)",null,null,null,null,null,"Must be Picked Up  "," "]
[null,null,"Registration Vendor & Address:","enter registration information here",null,null,null,null,null,"Y            N"," "]
[null,null," Confirmation(s) Must be Attached for College Checks, Conference Agenda Must be Attached"]
[null,null,"Certification"]
[null,null,"I hereby certify that travel as shown above is to be incurred in connection with official business of the State"]
[]
[null,null,"Traveler Name","Traveler Signature",null,"Supervisor Name",null,"Supervisor Signature",null,"Budget Designee Signature"]
[null,null,"Account Information"]
[null,null,null,"*State Org Unit","*Qual1","*Loc","GLC","*Amount"]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,null,null,{"$f":"SUM(H44:H46)","v":0}]
[]
[null,null,"Form: FIN-ACP-005-1"]
[]
[]
[]
[]
[]
[null,null,"Completed forms can be mailed to MS#59, scanned, or e-mailed to travel@palmbeachstate.edu. Please do not fax. Forms that are not legible will need to be resubmitted.  Remember to have forms signed  and to submit with the Conference Agenda. If you are requesting a College check, submit confirmation receipts for registration or hotel with Travel Request. "]

{"sheet":"Instructions","index":2,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Instructions for Form FIN-ACP-005-1 Travel Request Form "]
["Requirement Prior to Travel  Ref  Travel Statute 112.061"]
["An approved authorization to travel is required prior to attendance at all conferences, conventions and out of state travel.  PBSC uses Travel Request Form FIN-ACP-005-1 for this purpose.  "]
["Section I.  Travelers’ Information "]
[" Provide the name of the traveler, employee ID and travelers’ campus, official headquarters."]
["Pay To Type – Select the payee type from drop down box. i.e. employee, student, applicant, or other."]
["Payee Name – Provide name of traveler. Last name, first name"]
["Payee ID – Provide traveler’s identification number, for employees use the employee ID number.  For non-employees use their ID number.  i.e. students, vendors, etc. Employee number is on back of employee's panthercard."]
["Campus – Designate the campus headquarters of the traveler.  "]
[]
["Section II.  Travel Detail "]
["Provide detail of the trip in this section such as the type of travel, the destination, where the employee is departing from, the date, time, travel purpose and whether other staff are traveling with you.  "]
["Dest ind. – Select the type of travel from the drop down box."]
["Destination – Enter the location you are traveling to (i.e. city)."]
["Student Travel – Select if traveling with a group of students. "]
["Departure City – Enter the city the traveler will leave from, i.e. location of airport or campus for car."]
["Return City – Enter the city the traveler will return to. "]
["Fund Request – Select if a check will be requested for registration or hotel.  "]
["Departure Date – Enter the date the trip starts  MM/DD/YYYY"]
["Return Date - Enter the return date.  MM/DD/YYYY"]
["Ride with Others – Select if there is no reimbursement for traveling to the location."]
["Departure Time – The departure time has three drop down boxes (hours, minutes, and AM/PM). Select the hour, the minutes (which are in 15 min increments) and if the travel begins on AM or PM). "]
["Return Time – The return time has three drop down boxes (hours, minutes, and AM/PM). Select the hour, the minutes (which are in 15 min increments) and if the travel ends on AM or PM). "]
["Travel Purpose – State the business purpose of the trip include the benefit to the College. "]
["Other Staff Traveling – If you are traveling with other staff, provide their name."]
["Section III.  Projected Travel Expenses"]
["College Car - Select if travel is in a College Car."]
["Personal Car - Select if travel is your personal vehicle.  Enter the estimated miles for the trip.  The cost is automatically calculated. "]
["Rental Car - Select if renting a car.  If paying by P-card select box for P-card.  Enter number of days for rental.  Enter estimated cost."]
["Common Carrier  – Select if traveling by plane, bus, train or other common carrier.  If paying by P-Card select the P-Card box. If paying by  other method select the Other direct payment box. Enter estimated cost. "]
["Registration Fee – Select if registration fee is required. If paying by P-Card select the P-Card box.  If a College check is requested select  the Request Check box. Enter the cost of the registration.  Enter Payment Information in Additional Information and attach confirmation to Travel Request."]
["Room Cost - If paying by P-Card select P-Card box.  If a check is being requested select  Request Check box.   Enter estimated cost of lodging including taxes if applicable. Note: PBSC is exempt from FL state tax. Enter Payment Information in Additional Information and attach confirmation to Travel Request."]
["Meals - Amount is automatically calculated once the number of individual meals is entered in the table Meal Allowance Calculation. If you opting for Straight Per Diem Method do not enter in the Meal Allowance Calculation Boxes."]
["Meals Allowance Calculation- Enter number of Breakfast, Lunches and Dinners in Meal Allowance Calculation in the respective box.  The chart below gives the time parameters for each allowance. The amount is automatically calculated. Do not count meals provided for by the conference."]
[]
[]
[]
[]
[]
["Flat Per Diem - If using this method, enter the number of quarters, the estimated cost will automatically calculate. Do not enter room cost or per diem  meals."]
["Other Expenses Cost – Total other expenses that do not fall under any other category. "]
["Estimated Total Cost – Total estimated cost of travel. This field is calculated and traveler is not able to modify it. "]
["Authorized Total Cost – If the amount that can be reimbursed is limited to a certain dollar amount,  enter in the amount in this box, otherwise leave blank."]
["Other Expense Cost - Enter any other costs not already listed, shuttle, taxis, parking, gratuities, etc."]
["Section IV.  Additional Information"]
["Travel Notes:  Enter any information that will aid in processing timely. Examples would include late for supervisor, designee or travel if any expenditure or lack of expenditure is outside of the ordinary. I.e. Traveling in someone else's car, trips booked past the early dates."]
["Registration Information:  Include the name of who the check is to be made payable to and their address. Select \"Y\" for Yes and \"N\" for No if check must be picked up with date check is needed. "]
["Hotel Information:  Include the name of who the check is to be made payable to and their address."]
["Section V.  Certification"]
["Accept Certification – Traveler must select this box when the document is sent for approval. This certifies that the traveler agrees with the certification statement above this field. This certification state is defined in the Travel Generic Table – Text to Appear on Travel Request."]
["Approval – Print, obtain signatures, and submit to Travel"]
["Section VI.  Account Information "]
["Enter the full Organization Unit Code in this section that will pay for the trip and the amount. Multiple orgs may be entered. There must be sufficient budget in the Org's Used."]
["Completed forms can be mailed to MS#59 or scanned and e-mailed to travel@palmbeachstate.edu. Please do not fax. Forms that are not legible will need to be resubmitted for payment. Remember to have forms signed  and to submit with the Conference Agenda. If a College check is requested, submit confirmation receipts for registration or hotel with Travel Request. "]

{"sheet":"Example","index":3,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[38,2,38,10],[2,2,2,12],[5,10,5,11],[4,3,4,4],[3,3,3,4],[5,3,5,5],[4,5,4,6],[4,8,4,9],[25,6,25,8],[23,4,23,5],[24,4,24,5],[21,4,21,5],[22,4,22,5],[7,2,7,10],[8,3,8,10],[14,3,14,10],[0,2,0,12],[18,2,18,10],[31,2,31,10],[37,2,37,10],[16,3,16,10],[19,6,19,9],[34,3,34,8],[35,3,35,8],[27,2,27,4],[33,10,33,11],[35,10,35,11],[36,2,36,10],[32,3,32,10],[29,7,29,9],[27,8,27,9],[5,7,5,9],[40,7,40,8],[39,3,39,4],[39,9,39,10],[40,9,40,10],[54,2,54,10],[41,2,41,10],[40,5,40,6],[40,3,40,4],[39,5,39,6],[39,7,39,8],[21,15,21,17],[8,14,8,17],[13,14,13,19],[14,14,14,20],[19,14,19,16]]}
[null,null,"PBSC Travel Request - Example"]
[]
[null,null,"Travelers' Information"]
[null,null,"Pay to Type:","Payee Name: Last",null,"First",null,null,null,"Traveler ID:"]
[null,null,null,"Doe ",null,"Jane",null,null,12356]
[null,null,null,null,null,null,"Campus:"]
[]
[null,null,"Travel Detail"]
[]
[null,null,"Dest ind:",null,null,null,"Destination:","Orlando",null,"Student Travel:  "]
[]
[null,null,"Departure City:","Lantana",null,null,"Return City:","Lake Worth ",null,"Funds Requested:"]
[null,null,"    Departure Date:","2016-10-28",null,null,"Return Date:","Oct 30,2016",null,"Ride with Others:"]
[null,null,"Departure Time:",null,null,null,"Return Time:"]
[null,null,"Travel Purpose:","To attend 2016 AAA Diversity Section Meeting Oct 28-30 @ Hyatt Regency Orlando, Fl to gain awareness of Diversity Issues."]
[]
[null,null,"Other Staff Traveling:","2 other people rode in my personal car, Donald Duck and Mickey Mouse"]
[]
[null,null,"Projected Travel Expenses"]
[null,null,"College Car:"]
[null,null,"Personal Car:",null,null,null,null,"Official Miles:",340,"Cost:",{"$f":"+I21*0.445","v":151.30000000000001}]
[null,null,"Rental Car:",null,"P-Card:",null,null,"Number of Days:",0,"Cost:"]
[null,null,"Common Carrier:",null,"P-Card:",null,null,"Other:",null,"Cost:"]
[null,null,"Registration Fee:",null,"P-Card:",null,null,"Request Check:",null,"Cost:",50]
[null,null,"Room Cost:",null,"P-Card:",null,null,"Request Check:",null,"Cost:",700]
[null,null,"Meals:",null,null,"Calc Meals:",null,null,null,"Meal Per Diem:",{"$f":"IF(D27>0,\"0\",(+D30*E30)+(D31*E31)+(D29*E29))","v":72}]
[null,null,"Flat Per Diem:",0,"Enter Number of Quarters if Choosing this Option",null,null,null,null,"Per Diem Cost:",{"$f":"IF((D31+D30+D29)>0,\"0\",(+D27*20))","v":"0"}]
[null,null,null,null,null," ",null,null,"Tolls Cost:",null,0]
[null,null,"Number Breakfasts ",2,6,null,null,null,null,"Luggage, Parking, Ground Transportation & Other Expenses Cost:",15]
[null,null,"Number of Lunch",2,11,null,null,"Estimated Total Cost of Trip:",null,null,{"$f":"SUM(K21:K29)","v":988.3}]
[null,null,"Number of Dinner ",2,19,null,null,null,null,"Authorized Total Cost if Applicable:"]
[null,null,"Additional Information"]
[null,null,"Travel Notes:","   "]
[null,null,"Payment Information if Requesting College Check:",null,null,null,null,null,null,"Pick up Check","Date Needed:"]
[null,null,"Hotel & Address","Hyatt Regency Orlando,  9801 International Drive, Orlando, FL 32819",null,null,null,null,null,"Must be Picked Up  ","2016-10-25"]
[null,null,"Registration Vendor & Address:"," ",null,null,null,null,null,"Y            N"," "]
[null,null," Confirmation(s) Must be Attached for College Checks, Conference Agenda Must be Attached"]
[null,null,"Certification"]
[null,null,"I hereby certify that travel as shown above is to be incurred in connection with official business of the State"]
[]
[null,null,"Traveler Name","Traveler Signature",null,"Supervisor Name",null,"Supervisor Signature",null,"Agency Head Designee Signature"]
[null,null,"Account Information"]
[null,null,null,"*State Org Unit","*Qual1","*Loc","GLC","*Amount"]
[null,null,null,99999999,999999,99," ",200]
[null,null,null,99999999,899999,99,null,681.5]
[null,null,null,null,null,null,null,0]
[null,null,null,"Total",null,null,null,{"$f":"SUM(H44:H46)","v":881.5}]
[]
[null,null,"Form: FIN-ACP-005-1"]
[]
[]
[]
[]
[]
[null,null,"Completed forms can be mailed to MS#59, scanned, or e-mailed to travel@palmbeachstate.edu. Please do not fax. Forms that are not legible will need to be resubmitted.  Remember to have forms signed  and to submit with the Conference Agenda. If a College check is requested, submit confirmation receipts for registration or hotel with Travel Request. "]