{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Checklist","Travel Justication Memo","TR-1 Training & Travel Form","TR-2 Travel Exemption Request F","TR-3 Travel Reimbursement Form","TR-4 Personal Vehicle Form"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":10,"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":"Checklist","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Travel Checklist"]
["Attached","FORMS"]
["TR-1","TRAINING AND TRAVEL EXPENSE AUTHORIZATION FORM (Submit along with Required Supporting Documentation) "]
["TR-2","TRAVEL EXEMPTION REQUEST (When the travel-related lodging is greater than the per diem allowance)"]
["TR-3","TRAVEL REIMBURSEMENT FORM (When requesting an advance and/or reimbursement from agency)"]
["TR-4","PERSONAL VEHICLE REIMBURSEMENT FORM (Must be completed and submitted to agency with supporting information including odometer reading, maps showing distance travelled)"]
["Other","Agreement to Continue in Service (If Training Costs exceeds $2,500)"]
["Attached","REQUIRED SUPPORTING DOCUMENTATION"]
[null,"TRAVEL JUSTIFICATION MEMO "]
[null,"COPY OF BROCHURE, FLYER, LETTER OF INVITATION, ANNOUNCEMENT FOR EVENT"]
[null,"GSA CURRENT PER DIEM RATES FOR HOTEL AND MEALS"]
[null,"AIRLINE ESTIMATE WITH PRICING AND TAX RATE"]
[null,"HOTEL PRINTOUT WITH PRICING, TAX, ADDRESS, TELEPHONE NUMBER"]
[null,"REGISTRATION REQUEST WITH COST"]
[null,"IF GRANT FUNDED, PROVIDE SUPPORTING DOCUMENTATION"]
[null,"CONFERENCE AGENDA"]

{"sheet":"Travel Justication Memo","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,0,28,8],[1,0,1,8],[2,0,2,8]]}
[]
["GOVERNMENT OF THE DISTRICT OF COLUMBIA"]
["(Agency Name)"]
[]
[]
[]
[]
[]
[]
["MEMORANDUM"]
[]
["TO:"]
[]
[]
[]
["THRU:"]
[]
[]
["FROM:"," "]
[]
[]
["DATE:"]
[]
["SUBJECT:","TRAVEL/TRAINING JUSTIFICATION"]
[]
[]
["NOTE: This should include the description/purpose/justification of the travel.  Please refer to I-40-01, Processing Training and Travel Requests, for additional information. "]

{"sheet":"TR-1 Training & Travel Form","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,2,8],[36,0,36,1],[13,6,13,7],[14,6,14,7],[7,0,7,5],[7,6,7,7],[8,0,8,4],[14,0,14,5],[15,0,15,9],[23,0,23,5],[23,7,23,9],[17,0,17,5],[17,6,17,9],[18,0,18,2],[18,3,18,4],[8,8,8,9],[9,0,9,4],[9,8,9,9],[16,0,16,5],[16,6,16,9],[10,0,10,5],[10,6,10,9],[11,0,11,5],[13,8,13,9],[14,8,14,9],[13,0,13,5],[7,8,7,9],[3,0,3,9],[4,0,4,5],[4,6,4,7],[4,8,4,9],[5,0,5,5],[5,6,5,7],[5,8,5,9],[6,0,6,5],[6,6,6,9],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[19,3,19,4],[20,0,20,2],[20,3,20,4],[21,0,21,2],[21,3,21,4],[19,0,19,2],[26,0,26,9],[27,0,27,9],[28,0,28,1],[29,0,29,1],[30,0,30,1],[51,7,51,8],[52,1,52,4],[52,5,52,6],[52,7,52,8],[47,0,48,5],[47,6,48,9],[49,0,49,9],[50,1,50,4],[50,5,50,6],[50,7,50,8],[8,5,8,6],[9,5,9,6],[12,0,12,5],[51,1,51,4],[51,5,51,6],[38,0,38,9],[39,0,39,9],[42,0,42,9],[43,0,45,9],[46,0,46,5],[46,6,46,9],[22,0,22,9],[35,0,35,1],[24,0,24,5],[25,2,25,5],[25,7,25,9]]}
["GOVERNMENT OF THE DISTRICT OF COLUMBIA\nTR-1TRAINING AND TRAVEL EXPENSE AUTHORIZATION FORM"]
[]
[]
["I. Training/Travel Request Summary"]
["1. Name of Traveler",null,null,null,null,null,"2. Employee ID:",null,"3.. Agency/Department (Including Budget Code)"]
["John Smith ",null,null,null,null,null,12345,null,"Agency (GW0)"]
["4. Position Title                                                                                                                                                ",null,null,null,null,null,"5. Training or Conference Dates:                                                                                                     From:                                                                        To:    "]
["Director",null,null,null,null,null,"00/00/2016",null,"00/00/2016"]
["6. Description of Travel/Training",null,null,null,null,"7. Travel Origin",null,"Destination","8.  Total Cost (Travel,Training, or Conferencet)"]
["Training or Conference",null,null,null,null,"City, State",null,"City, State",0]
["9. Training, Conference or Seminar Event Location Address  ",null,null,null,null,null,"10. Training or Conference Vendor Name and Address (as it must appear on check)\n\n"]
[]
[]
["11. Sponsor (if applicable)",null,null,null,null,null,"12. Donation Application Request No.           ",null," 13. Sponsor’s Donation Amount"]
[]
["II. Transportation"]
["14. Mode of Transportation",null,null,null,null,null,"15. Method of Payment"]
[" Airline        Train         Other Private Vehicle",null,null,null,null,null,"       Advance            Travel Card                 Other      ___________"]
["Transportation to Destination",null,null,"16. Point of Departure",null,"17. Travel Date","18. Carrier Name","19. Flight or Train IDs","20. Departure Time","21. Arrival Time"]
[]
["Transportation to Return",null,null,"22. Point of Departure",null,"23. Travel Date","24. Carrier Name","25. Flight or Train IDs","26. Departure Time","27. Arrival Time"]
[]
["III. Lodging"]
["28. Hotel Name and Address",null,null,null,null,null,"29. Hotel Phone"]
[null,null,null,null,null,null,"30. Lodging Dates","From  ","To     "]
[null,null,null,null,null,null,"31. Length of Stay(Nights)"]
["Special Notes"]
["IV. Total Cost\n"]
["Item",null,"Quantity","Unit Cost","Subtotal","Tax Rate","Total Rate","Total Cost","P-Card","Advance"]
["Transportation (Airline, Train, etc.)",null,null,null,{"$f":"SUM(C30*D30)","v":0},0,{"$f":"F30","v":0},{"$f":"SUM(E30+G30)","v":0},0,0]
["Lodging (Government Rate)",null,null,null,0,0,{"$f":"SUM(C31*F31)","v":0},{"$f":"SUM(E31+G31)","v":0},0,0]
["Per Diem ",null,null,null,0,0,0,0,0,0]
["Per Diem  (First and Last Day of Travel)",null,null,null,0,0,0,0,0,0]
["Car Rental (Only If Approved)",null,null,null,0,0,{"$f":"E34","v":0},0,0,0]
["Training/Registration Fees/Tuition",null,null,null,{"$f":"SUM(C35*D35)","v":0},0,0,{"$f":"SUM(E35+G35)","v":0},0,0]
["Books/Materials",null,null,null,0,0,0,0,0,0]
["Other Expenses (Ground Travel including shuttles, Taxis, Car Rental, Parking Fees / Baggage fees)",null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I30:I37)","v":0},{"$f":"SUM(J30:J37)","v":0}]
[]
["V. Funding Attributes (Provided by Agency Budget Responsible Manager or Agency Fiscal Officer)"]
["Fund","Agency","Program","Cost Center","Account","Project","Award","Task","Future 1","Future 2"]
[]
["VI. Traveler Signature"]
["I certify that I am requesting authorization to travel on official District government business.  I will keep original receipts for all expenses and submit them, along with a properly completed travel reconciliation form, within ten (10) business days of the authorized travel completion date.  I understand that I will not be reimbursed for any expenses that are not associated with official business, not authorized by this form, or not authorized by 6-B DCMR Chapter 40 or other applicable District or federal law or regulations.  I understand that if expenses are incurred by the District (such as through an advance to me or through advance payments to third parties) and I fail to travel or attend the training, fail to submit a properly completed travel reconciliation form by the required date, or fail to reimburse the District for any advance in excess of actual and authorized expenses, the balance due may be withheld from my pay or from other District payments due to me now or in the future; I may also be subject to disciplinary action."]
[]
[]
["Signature",null,null,null,null,null,"Date"]
[]
[]
["VII. Authorizations"]
["Administration Representative","Name (Printed)  ",null,null,null,"Title  ",null,"Signature",null,"Date"]
["AFO or Budget Analyst","Name (Printed)  ",null,null,null,"Title: ",null,"Signature",null,"Date"]
["Agency Director or Designee","Name (Printed)  ",null,null,null,"Title: ",null,"Signature",null,"Date"]

{"sheet":"TR-2 Travel Exemption Request F","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,2,7],[16,1,16,5],[28,1,28,5],[31,1,31,5],[32,1,32,5],[32,7,32,8],[29,1,29,5],[29,7,29,8],[3,1,3,8],[5,0,5,9],[11,0,11,9],[13,1,13,8],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[6,4,6,8],[12,1,12,8],[14,1,14,5],[14,6,14,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[10,1,10,3],[34,1,34,8],[15,1,15,4],[15,6,15,7],[17,1,17,5],[19,0,19,9],[20,1,20,8],[27,1,27,8],[33,1,33,4],[23,2,23,8],[25,2,25,8],[24,2,24,8],[26,2,26,8],[21,2,21,8],[22,2,22,8]]}
["TR-2 Travel Exemption Request Form\nGovernment of the District of Columbia"]
[]
[]
[null,"PLEASE NOTE: This form must be completed when the travel-related lodging is greater than the per diem allowance set forth by the Federal Government's General Services Administration, when an employee is unable to obtain lower rates for early conference/training registration, or another item that requires exemption (if requested by the OCFO).  This form must be attached with the requested advance/reimbursement."]
[]
["AGENCY'S FISCAL OFFICER OR INDEPENDENT CFO"]
[null,"Name"]
[null,"Title"]
[null,"Agency/Department"]
[null,"Address "]
[null,"Phone Number"]
["EMPLOYEE/TRAVEL INFORMATION"]
[null,"Last Name, First Name, Middle Initial"]
[]
[null,"Phone Number",null,null,null,null,"Agency/Department & Agency Code"]
[]
[null,"Trip Destination and Dates of Travel "]
[null,null,null,null,null,null,null,"to"]
[]
["EXEMPTION REQUEST AND APPROVAL"]
[null,"The enclosed travel reimbursement and/or advance for the aforementioned employee has the following (please check all that apply):"]
[null,null,"Travel-related lodging expenses that are greater than the per diem allowance set forth by the Federal Government's General Services Administration (Please explain in lines below):"]
[]
[null,null,"Employee is unable to obtain lower rates for early conference/training registration (Please explain in lines below):"]
[]
[null,null,"Other items that require exemption (Please explain in lines below):"]
[]
[null,"I am authorizing the approval of this travel reimbursement and/or advance with the requested lodging costs, registration fees, or other item that requires an exemption."]
[null,"Supervisor's Name and Title",null,null,null,null,null,"Signature"]
[]
[]
[null,"Agency Head's Name and Title",null,null,null,null,null,"Signature"]
[]
[null,"Date"]

{"sheet":"TR-3 Travel Reimbursement Form","index":4,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,9,7,10],[12,0,16,5],[12,6,13,8],[12,9,13,10],[14,6,14,8],[8,0,8,4],[8,5,8,7],[8,9,8,10],[9,0,9,4],[9,5,9,7],[9,9,9,10],[0,0,2,9],[11,0,11,10],[10,0,10,10],[17,0,17,10],[18,5,18,10],[3,0,3,10],[5,6,5,8],[4,0,4,5],[4,6,4,8],[4,9,4,10],[5,0,5,5],[5,9,5,10],[6,0,6,5],[6,6,6,10],[7,0,7,5],[7,6,7,7],[19,0,19,3],[19,5,19,9],[14,9,14,10],[15,6,15,8],[15,9,15,10],[16,6,16,7],[16,8,16,10],[20,0,20,3],[20,5,20,9],[21,0,21,3],[21,5,21,9],[22,0,22,3],[22,5,22,9],[23,0,23,4],[23,5,24,10],[24,0,24,4],[31,0,31,10],[32,0,34,10],[28,0,28,5],[28,6,28,10],[29,0,30,5],[29,6,30,10],[26,0,27,10],[25,0,25,10],[35,0,35,6],[35,7,35,10],[37,0,37,4],[37,5,37,10],[44,0,44,3],[44,5,44,9],[45,0,45,3],[45,5,45,9],[46,0,46,3],[46,5,46,9],[50,0,50,3],[50,5,50,9],[47,0,47,3],[47,5,47,9],[48,0,48,3],[48,5,48,9],[49,0,49,3],[49,5,49,9]]}
["GOVERNMENT OF THE DISTRICT OF COLUMBIA\n(Agency Name)\nTR-3 REQUEST FOR TRAVEL REIMBURSEMENT FORM"]
[]
[]
["I. Travel Package Control"]
["1. Name of Traveler",null,null,null,null,null,"2. Employee ID:",null,null,"3.. Agency "]
[{"$f":"'TR-1 Training & Travel Form'!A6:F6","v":"John Smith "},null,null,null,null,null,{"$f":"'TR-1 Training & Travel Form'!G6:H6","v":12345},null,null,{"$f":"'TR-1 Training & Travel Form'!I6:J6","v":0}]
["4. Position Title                                                                                                                                                ",null,null,null,null,null,"5. Travel Date:                                                                                                              From:                                                                        To:    "]
[{"$f":"'TR-1 Training & Travel Form'!A8:F8","v":"Director"},null,null,null,null,null,{"$f":"'TR-1 Training & Travel Form'!G8:H8","v":"00/00/2016"},null,null,{"$f":"'TR-1 Training & Travel Form'!I8:J8","v":"00:00:00"}]
["6. Description of Travel/Training",null,null,null,null,"7. Travel Destination",null,null,null,"8. Training, Conference or Seminar Cost"]
[{"$f":"'TR-1 Training & Travel Form'!A10:E10","v":"Training or Conference"},null,null,null,null,{"$f":"'TR-1 Training & Travel Form'!F10:H10","v":"City, State"},null,null,null,{"$f":"'TR-1 Training & Travel Form'!I10:J10","v":0}]
[]
["II. Traveler Advance Request"]
["7. Traveler Home Address:",null,null,null,null,null,"9. Reimbursement Requested"]
[]
[null,null,null,null,null,null,"Reimbursement Owed to Traveler",null,null,"Complete section III not IV"]
[null,null,null,null,null,null,"Reimbursement Owed to the District",null,null,"Complete section IV no III"]
[null,null,null,null,null,null,"10. Phone Number"]
["11. Special Notes:    "]
["III. Owed to the Traveler",null,null,null,null,"IV. Owed to the District"]
["Item",null,null,null,"Dollar Amount","Item",null,null,null,null,"Dollar Amount"]
["Total Cost of Travel",null,null,null,0,"Total Cost of Travel",null,null,null,null,{"$f":"$E$21","v":0}]
["Advance Amount",null,null,null,0,"Advance Amount",null,null,null,null,0]
["Reimbursement Amount Owed",null,null,null,0,"Reimbursement Amount Owed",null,null,null,null,0]
["TOTAL Amount Requested for Reimbursement",null,null,null,null,{"$f":"$E$23","v":0}]
["Enter Amount either from Section III or Section IV"]
["VI. Traveler Signature"]
["I certify that I am requesting  expense reimbursement for travel on official District government business.  I will keep original receipts for all expenses and submit them, along with a properly completed travel reconciliation form, within ten (10) business days of the authorized travel completion date.  I understand that I will not be reimbursed for any expenses that are not associated with official business, not authorized by this form, or not authorized by 6-B DCMR Chapter 40 or other applicable District or federal law or regulations.  I understand that if expenses are incurred by the District (such as through an advance to me or through advance payments to third parties) and I fail to travel or attend the training, fail to submit a properly completed travel reconciliation form by the required date, or fail to reimburse the District for any advance in excess of actual and authorized expenses, the balance due may be withheld from my pay or from other District payments due to me now or in the future; I may also be subject to disciplinary action."]
[]
["Signature",null,null,null,null,null,"Date"]
[]
[]
["V. Review Checklist"]
["Travel Coordinator signs that the package is Complete, containing all required documentation: refer to SOP 890.100 for required documentation"]
[]
[]
[null,null,null,null,null,null,null,"Signature of Coordinator"]
["Line Item","Receipt    #1","Receipt    #2","Receipt    #3","Total Cost","Line Item","Receipt #1","Receipt  #2","Receipt #3  ",null,"Total Cost"]
["Reviewers must calculate each expense item and write total amounts by hand.",null,null,null,null,"Reviewers must calculate each expense item and write total amounts by hand."]
["Training/ Registration Fee",0,0,0,0,"Training/ Registration Fee",0,0,0,null,{"$f":"SUM(G39:I39)","v":0}]
["Transportation (Airlines, Train, Luggage, Fee)",0,0,0,{"$f":"SUM(B40:D40)","v":0},"Transportation (Airlines, Train, Luggage, Fee)",0,0,0,null,0]
["Lodging (Hotel, Tax)",0,0,0,{"$f":"SUM(B41:D41)","v":0},"Lodging (Hotel, Tax)",0,0,0,null,0]
["Food & Beverages (if more than 15 receipts are provided for food, reviewers should agree to use a combined per day calculation)",0,0,0,{"$f":"SUM(B42:D42)","v":0},"Food & Beverages (if more than 15 receipts are provided for food, reviewers should agree to use a combined per day calculation)",0,0,0,null,0]
["Personal Car (Milage x $0.535)",0,0,0,{"$f":"SUM(B43:D43)","v":0},"Personal Car (Milage x $0.535)",0,0,0,null,0]
["Ground Travel (Shuttles, Car Rental, Parking Fees)",0,0,0,{"$f":"SUM(B44:D44)","v":0},"Ground Travel (Shuttles, Car Rental, Parking Fees)",0,0,0,null,0]
["TOTAL COST",null,null,null,{"$f":"SUM(E39:E44)","v":0},"TOTAL COST",null,null,null,null,{"$f":"$E$45","v":0}]
["Paperwork Accuracy",null,null,null,null,"Paperwork Accuracy"]
["All receipts were provided",null,null,null,null,"All receipts were provided"]
["All Required Fields are Completed",null,null,null,null,"All Required Fields are Completed"]
["Dollar Amount calculate correctly",null,null,null,null,"Dollar Amount calculate correctly"]
["Information appears to be accurate",null,null,null,null,"Information appears to be accurate"]
["No Found Spelling Errors",null,null,null,null,"No Found Spelling Errors"]
["Reviewer # 1",null,null,null,null,"Reviewer #2"]
[]
["Print Name:",null,null,null,null,"Print Name:"]

{"sheet":"TR-4 Personal Vehicle Form","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["TR-4 Personal Vehicle Reimbursement Form"]
[" "]
["Name",null,null,null,"Date Submitted"]
["Department"]
["Period",null,null,null,"Authorized by",0]
["Per Mile Reimbursement",0.58499999999999996]
["Total Reimbursement Due"]
[]
["Date","Description of Expense (Origin and destination of travel)","Miles at Start (Odometer reading at start of trip)","Miles at End (Odometer reading at destination)","Total Miles","Mileage Reimbursement"]
[null,null,null,null,null,{"$f":"SUM(B6*E10)","v":0}]
[null,null,null,null,null,{"$f":"E11*$B$6","v":0}]
[null,null,null,null,null,{"$f":"E12*$B$6","v":0}]
[null,null,null,null,null,{"$f":"E13*$B$6","v":0}]
[null,null,null,null,null,{"$f":"E14*$B$6","v":0}]
[null,null,null,null,{"$f":"SUM(E10:E14)","v":0},{"$f":"E15*$B$6","v":0}]
[null,null,null,null,null,{"$f":"F15","v":0}]
[]
[null,null,null,null,null,"ADVANCE:"]
[null,null,null,null,null,"Expenses"]
[null,null,null,null,null,"Reimbursement"]