{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Travel Expense Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Travel Expense Form","index":0,"n_rows":67,"n_cols":30,"rows_kept":67,"cut":false,"hidden":false,"merged":[[30,0,30,11],[32,0,32,11],[33,0,33,11],[34,0,34,11],[31,0,31,11],[60,0,60,1],[66,0,66,4],[62,0,62,5],[64,0,64,3],[2,0,2,4],[2,5,2,8],[41,0,41,24],[49,8,49,10],[4,3,4,4],[4,8,4,9],[4,17,4,21],[19,0,19,4],[40,0,40,24],[42,0,42,24],[28,0,28,9],[24,0,24,4],[2,21,2,24],[3,0,3,4],[3,5,3,8],[3,9,3,10],[3,21,3,24],[0,21,0,24],[1,0,1,4],[1,5,1,8],[1,9,1,10],[1,21,1,24],[23,0,23,4],[25,0,25,4],[0,0,0,4],[0,5,0,8],[0,9,0,10],[2,9,2,10]]}
["     WASHBURN UNIVERSITY    ",null,null,null,null,"NAME (Please type in yellow space)",null,null,null,"WIN NUMBER",null,"DEPARTMENT",null,"REIMBURSEMENT DELIVERY METHOD (please select one)",null,null,null,null,null,null,null,"TOTAL APPROVED AMOUNT (all funding)"]
["     WASHBURN TECH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERSONAL",null,null,null,{"$f":"IF(ISBLANK(V2),\"ADD APPROVED AMOUNT\",\"\")","v":"ADD APPROVED AMOUNT"}]
["Travel Expense Report (2024)",null,null,null,null,"STREET ADDRESS",null,null,null,"CITY",null,"STATE",null,"ZIP CODE",null,null,null,null,null,null,null,"VEHICLE(S) USED (check all that apply)",null,null,null,"WASHBURN"]
["SAME DAY TRAVEL        Depart/return time in Purpose of Trip Field & Select the \"Depart 12 AM - 5:59 AM\" on row 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"***Check meal box, if meal was provided at no cost",null,null,null,null,null,null,"      Personal       Rental      WU",null,null,null,"RENTAL"]
[null,"Departure Time/",null,"Travel Itinerary",null,"Airplane","Lodging Per Diem/","Auto","Auto Mileage",null,"Auto","Conference","Membership","Tolls, Taxi","M&IE","M&IE",null,"***Meal Reductions",null,null,null,null,null,"Internet"]
["Date","Return Time*",null,"From","To","Expense","Conference Rate","Rental","Miles","Allowance","Gas","Fees","Dues","Parking, etc.","Daily Rate","Reduced Rate",null,"B'fast",null,"Lunch",null,"Dinner",null,"& Other**","Total by Date"]
[null,null,{"$f":"IF(B7=\"Depart 12 AM - 5:59 AM\",$O$7*$Z$9,IF(B7=\"Depart 6 AM - 11:59 AM\",$O$7*$Z$10,IF(B7=\"Depart 12 PM - 5:59 PM\",$O$7*$Z$11,IF(B7=\"Depart 6 PM - 11:59 PM\",$O$7*$Z$12,0))))","v":0},null,null,null,null,null,null,{"$f":"ROUND(I7*IF((A7)<45292,0.655,0.67),2)","v":0},null,null,null,null,null,{"$f":"C7-S7-U7-W7","v":0},null,false,{"$f":"IF(R7=TRUE,$C$7*$Z$7,0)","v":0},false,{"$f":"IF(T7=TRUE,$C$7*$AA$7,0)","v":0},false,{"$f":"IF(V7=TRUE,$C$7*$AB$7,0)","v":0},null,{"$f":"SUM(F7:H7,J7:N7,P7,X7)","v":0},0.15,0.35,0.5,"Conference Reductions"]
[null,null,{"$f":"IF(B8=\"Return 12 AM - 5:59 AM\",$O$8*$Z$12,IF(B8=\"Return 6 AM - 11:59 AM\",$O$8*$Z$11,IF(B8=\"Return 12 PM - 5:59 PM\",$O$8*$Z$10,IF(B8=\"Return 6 PM - 11:59 PM\",$O$8*$Z$9,0))))","v":0},null,null,null,null,null,null,{"$f":"ROUND(I8*IF((A8)<45292,0.655,0.67),2)","v":0},null,null,null,null,null,{"$f":"IF(C8=0,O8-S8-U8-W8,C8-S8-U8-W8)","v":0},{"$f":"IF($C$8>0,$C$8,$O$8)","v":0},false,{"$f":"IF(R8=TRUE,$Q$8*$Z$7,0)","v":0},false,{"$f":"IF(T8=TRUE,$Q$8*$AA$7,0)","v":0},false,{"$f":"IF(V8=TRUE,$Q$8*$AB$7,0)","v":0},null,{"$f":"SUM(F8:H8,J8:N8,P8,X8)","v":0}]
[null,null,{"$f":"IF(B9=\"Return 12 AM - 5:59 AM\",$O$9*$Z$12,IF(B9=\"Return 6 AM - 11:59 AM\",$O$9*$Z$11,IF(B9=\"Return 12 PM - 5:59 PM\",$O$9*$Z$10,IF(B9=\"Return 6 PM - 11:59 PM\",$O$9*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$9>0,$C$9,$O$9)","v":0},false,{"$f":"IF(R9=TRUE,$Q$9*$Z$7,0)","v":0},false,{"$f":"IF(T9=TRUE,$Q$9*$AA$7,0)","v":0},false,{"$f":"IF(V9=TRUE,$Q$9*$AB$7,0)","v":0},null,0,1,"Depart 12 AM - 5:59 AM & Return 6 PM - 11:59 PM"]
[null,null,{"$f":"IF(B10=\"Return 12 AM - 5:59 AM\",$O$10*$Z$12,IF(B10=\"Return 6 AM - 11:59 AM\",$O$10*$Z$11,IF(B10=\"Return 12 PM - 5:59 PM\",$O$10*$Z$10,IF(B10=\"Return 6 PM - 11:59 PM\",$O$10*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$10>0,$C$10,$O$10)","v":0},false,{"$f":"IF(R10=TRUE,$Q$10*$Z$7,0)","v":0},false,{"$f":"IF(T10=TRUE,$Q$10*$AA$7,0)","v":0},false,{"$f":"IF(V10=TRUE,$Q$10*$AB$7,0)","v":0},null,0,0.75,"Depart 6 AM - 11:59 AM & Return 12 PM - 5:59 PM"]
[null,null,{"$f":"IF(B11=\"Return 12 AM - 5:59 AM\",$O$11*$Z$12,IF(B11=\"Return 6 AM - 11:59 AM\",$O$11*$Z$11,IF(B11=\"Return 12 PM - 5:59 PM\",$O$11*$Z$10,IF(B11=\"Return 6 PM - 11:59 PM\",$O$12*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$11>0,$C$11,$O$11)","v":0},false,{"$f":"IF(R11=TRUE,$Q$11*$Z$7,0)","v":0},false,{"$f":"IF(T11=TRUE,$Q$11*$AA$7,0)","v":0},false,{"$f":"IF(V11=TRUE,$Q$11*$AB$7,0)","v":0},null,0,0.5,"Depart 12 PM - 5:59 PM & Return 6 AM - 11:59 AM"]
[null,null,{"$f":"IF(B12=\"Return 12 AM - 5:59 AM\",$O$12*$Z$12,IF(B12=\"Return 6 AM - 11:59 AM\",$O$12*$Z$11,IF(B12=\"Return 12 PM - 5:59 PM\",$O$12*$Z$10,IF(B12=\"Return 6 PM - 11:59 PM\",$O$12*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$12>0,$C$12,$O$12)","v":0},false,{"$f":"IF(R12=TRUE,$Q$12*$Z$7,0)","v":0},false,{"$f":"IF(T12=TRUE,$Q$12*$AA$7,0)","v":0},false,{"$f":"IF(V12=TRUE,$Q$12*$AB$7,0)","v":0},null,0,0.25,"Depart 6 PM - 11:59 PM & Return 12 AM - 5:59 AM"]
[null,null,{"$f":"IF(B13=\"Return 12 AM - 5:59 AM\",$O$13*$Z$12,IF(B13=\"Return 6 AM - 11:59 AM\",$O$13*$Z$11,IF(B13=\"Return 12 PM - 5:59 PM\",$O$13*$Z$10,IF(B13=\"Return 6 PM - 11:59 PM\",$O$13*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$13>0,$C$13,$O$13)","v":0},false,{"$f":"IF(R13=TRUE,$Q$13*$Z$7,0)","v":0},false,{"$f":"IF(T13=TRUE,$Q$13*$AA$7,0)","v":0},false,{"$f":"IF(V13=TRUE,$Q$13*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B14=\"Return 12 AM - 5:59 AM\",$O$14*$Z$12,IF(B14=\"Return 6 AM - 11:59 AM\",$O$14*$Z$11,IF(B14=\"Return 12 PM - 5:59 PM\",$O$14*$Z$10,IF(B14=\"Return 6 PM - 11:59 PM\",$O$14*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$14>0,$C$14,$O$14)","v":0},false,{"$f":"IF(R14=TRUE,$Q$14*$Z$7,0)","v":0},false,{"$f":"IF(T14=TRUE,$Q$14*$AA$7,0)","v":0},false,{"$f":"IF(V14=TRUE,$Q$14*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B15=\"Return 12 AM - 5:59 AM\",$O$15*$Z$12,IF(B15=\"Return 6 AM - 11:59 AM\",$O$15*$Z$11,IF(B15=\"Return 12 PM - 5:59 PM\",$O$15*$Z$10,IF(B15=\"Return 6 PM - 11:59 PM\",$O$15*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$15>0,$C$15,$O$15)","v":0},false,{"$f":"IF(R15=TRUE,$Q$15*$Z$7,0)","v":0},false,{"$f":"IF(T15=TRUE,$Q$15*$AA$7,0)","v":0},false,{"$f":"IF(V15=TRUE,$Q$15*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B16=\"Return 12 AM - 5:59 AM\",$O$16*$Z$12,IF(B16=\"Return 6 AM - 11:59 AM\",$O$16*$Z$11,IF(B16=\"Return 12 PM - 5:59 PM\",$O$16*$Z$10,IF(B16=\"Return 6 PM - 11:59 PM\",$O$16*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$16>0,$C$16,$O$16)","v":0},false,{"$f":"IF(R16=TRUE,$Q$16*$Z$7,0)","v":0},false,{"$f":"IF(T16=TRUE,$Q$16*$AA$7,0)","v":0},false,{"$f":"IF(V16=TRUE,$Q$16*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B17=\"Return 12 AM - 5:59 AM\",$O$17*$Z$12,IF(B17=\"Return 6 AM - 11:59 AM\",$O$17*$Z$11,IF(B17=\"Return 12 PM - 5:59 PM\",$O$17*$Z$10,IF(B17=\"Return 6 PM - 11:59 PM\",$O$17*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$17>0,$C$17,$O$17)","v":0},false,{"$f":"IF(R17=TRUE,$Q$17*$Z$7,0)","v":0},false,{"$f":"IF(T17=TRUE,$Q$17*$AA$7,0)","v":0},false,{"$f":"IF(V17=TRUE,$Q$17*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B18=\"Return 12 AM - 5:59 AM\",$O$18*$Z$12,IF(B18=\"Return 6 AM - 11:59 AM\",$O$18*$Z$11,IF(B18=\"Return 12 PM - 5:59 PM\",$O$18*$Z$10,IF(B18=\"Return 6 PM - 11:59 PM\",$O$18*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$18>0,$C$18,$O$18)","v":0},false,{"$f":"IF(R18=TRUE,$Q$18*$Z$7,0)","v":0},false,{"$f":"IF(T18=TRUE,$Q$18*$AA$7,0)","v":0},false,{"$f":"IF(V18=TRUE,$Q$18*$AB$7,0)","v":0},null,0]
[null,null,{"$f":"IF(B19=\"Return 12 AM - 5:59 AM\",$O$19*$Z$12,IF(B19=\"Return 6 AM - 11:59 AM\",$O$19*$Z$11,IF(B19=\"Return 12 PM - 5:59 PM\",$O$19*$Z$10,IF(B19=\"Return 6 PM - 11:59 PM\",$O$19*$Z$9,0))))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,0,{"$f":"IF($C$19>0,$C$19,$O$19)","v":0},false,{"$f":"IF(R19=TRUE,$Q$19*$Z$7,0)","v":0},false,{"$f":"IF(T19=TRUE,$Q$19*$AA$7,0)","v":0},false,{"$f":"IF(V19=TRUE,$Q$19*$AB$7,0)","v":0},null,0]
["Reduction of travel expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F20:X20)","v":0}]
["Total Travel Expense for Entire Trip",null,null,null,null,{"$f":"SUM(F7:F20)","v":0},{"$f":"SUM(G7:G20)","v":0},{"$f":"SUM(H7:H20)","v":0},null,{"$f":"ROUND(SUM(J7:J20),2)","v":0},{"$f":"SUM(K7:K20)","v":0},{"$f":"SUM(L7:L20)","v":0},0,0,null,{"$f":"SUM(P7:P20)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(X7:X20)","v":0},{"$f":"SUM(Y7:Y20)","v":0},null,null,null,null,"If total expenses exceed approved amount, "]
["EXPENSES NOT CURRENTLY DUE TO EMPLOYEE - enter as a positive number ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F22:H22,J22:P22,X22)-SUM(R22:V22)","v":0},null,null,null,null,"add reductions on line 20."]
["***attach receipts with notation of payment type"]
["Paid with PCard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F24:H24,J24:N24,P24,X24)","v":0}]
["Previously reimbursed to traveler prior to July 1, 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F25:H25,J25:N25,P25,X25)","v":0}]
["Direct Billed to the University",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F26:H26,J26:N26,P26,X26)","v":0}]
["Total expenses paid with a Pcard, previously reimbursed, paid personally, or direct billed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y24:Y26)","v":0}]
["Total Amount of current reimbursement",null,null,null,null,{"$f":"F21-SUM(F24:F26)","v":0},{"$f":"G21-SUM(G24:G26)","v":0},{"$f":"H21-SUM(H24:H26)","v":0},null,{"$f":"J21-SUM(J24:J26)","v":0},{"$f":"K21-SUM(K24:K26)","v":0},{"$f":"L21-SUM(L24:L26)","v":0},{"$f":"M21-SUM(M24:M26)","v":0},{"$f":"N21-SUM(N24:N26)","v":0},null,{"$f":"P21-SUM(P24:P26)","v":0},null,null,null,null,null,null,null,{"$f":"X21-SUM(X24:X26)","v":0},{"$f":"Y21-Y27","v":0}]
["Travel/Expense Details (must document business purpose, if additional space is needed, add a separate sheet)",null,null,null,null,null,null,null,null,null,null,null,"FUND","ORG","ACCT","PROG",null,"ACTV"]
["Attending a conference?           Yes              No  (If yes, attach the conference agenda and conference hotel info)",null,null,null,null,null,null,null,null,null,null,null,null,null,700500,null,null,null,null,"Transportation",null,null,null,null,{"$f":"+F28+H28+J28+K28+N28-SUMIF(O36:O39,O30,Y36:Y39)","v":0}]
["Purpose of trip / Explanation of \"Internet & Other\" Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,700510,null,null,null,null,"Hotel/Lodging",null,null,null,null,{"$f":"+G28-SUMIF(O36:O39, O31, Y36:Y39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,700520,null,null,null,null,"Meals",null,null,null,null,{"$f":"P28-SUMIF(O36:O39, O32, Y36:Y39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,700530,null,null,null,null,"Other Travel",null,null,null,null,{"$f":"+X28-SUMIF(O36:O39, O33, Y36:Y39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,700600,null,null,null,null,"Registration",null,null,null,null,{"$f":"L28-SUMIF(O36:O39, O34, Y36:Y39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,700900,null,null,null,null,"Membership Dues",null,null,null,null,{"$f":"M28-SUMIF(O36:O39, O35, Y36:Y39)","v":0}]
["*If multiple FOAPALs are being used, include the additional FOAPAL information in the white box to the right."]
["If additional space is needed, add more FOAPAL information here:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Reimbursement (must agree with \"Total Amount of current reimbursement\" line above)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y40<>Y28,\"OUT OF BALANCE\",\"\")","v":""},{"$f":"SUM(Y30:AC39)","v":0}]
["ORIGINAL receipts, with details, are required for expenditures except for Meals"]
["*Departure Time should only be listed for the first day of travel and Return Time should only be listed for the last day of travel."]
["** Detail of entertainment expenses, including meals, must be explained on supporting documentation."]
["TRAVELER SIGNATURE AND DATE",null,null,null,null,null,null,null,"APPROVAL NAME (Please print or type)",null,null,null,"APPROVAL SIGNATURE AND DATE"]
[null,null,null,null,null,null,null,null,"Obtain appropriate approval(s) for all FOAPALs indicated above.  Approval signature represents these are official business expenses as per University policies and procedures and "]
[null,null,null,null,null,null,null,null,"are accurate to the best of my ability."]
["If an organizational membership is included in the cost of a conferecnce seminar",null,null,null,null,null,null,1]
["noted above, my signature certifies the membership was approved as per Section T",null,null,null,null,null,null,2]
["of the WUPRM.",null,null,null,null,null,null,3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["(Revised Jan 5, 2024)"]
[]
["https://www.gsa.gov/travel/plan-book/per-diem-rates",null,null,"Contiguous United States (CONUS).  The U.S. General Services Administration (GSA) maintains the M&IE rates for travel location in the contiguous United States.  ",null,null,null,null,null,null,null,null,null,null,null,null,"https://www.gsa.gov/travel/plan-book/per-diem-rates"]
[]
["https://www.travel.dod.mil/Travel-Transportation-Rates/Per-Diem/Per-Diem-Rate-Lookup/",null,null,null,null,null,"Outside Contiguous United States (OCONUS).  The U.S. Department of Defense (DOD) maintains the M&IE rates for travel locations within Alaska, Hawaii and U.S. Territories/Possessions.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.travel.dod.mil/Travel-Transportation-Rates/Per-Diem/Per-Diem-Rate-Lookup/"]
[]
["https://aoprals.state.gov/web920/per_diem.asp",null,null,null,"International Locations.  The U.S. Department of State (DOS) is the source for M&IE rates for international travel locations.  If the city is not listed for the country use the Post Name \"Other\" as the rate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If the city is not listed for the country use the Post Name \"Other\" as the rate."]
[]
["https://www.oanda.com/currency-converter/en/?from=EUR&to=USD&amount=1",null,null,null,null,"Currency Converter"]