{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Expense report","References","Per Diem References"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Expense report","index":0,"n_rows":50,"n_cols":28,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,23,3,23],[1,6,1,17],[2,26,2,27],[4,2,4,5],[4,26,4,27],[5,3,5,7],[5,8,5,10],[5,11,5,13],[5,16,5,22],[5,23,5,27],[13,3,13,8],[13,11,13,12],[13,13,13,14],[13,15,13,19],[13,20,13,22],[13,23,13,27],[7,3,7,7],[7,11,7,14],[9,3,9,7],[9,11,9,12],[9,13,9,14],[11,5,11,27],[15,16,15,19],[15,20,16,22],[15,23,16,23],[15,24,16,26],[15,27,16,27],[16,13,16,14],[16,17,16,19],[15,1,16,2],[15,3,16,5],[15,6,16,9],[15,10,16,10],[15,11,16,12],[15,13,15,15],[17,20,17,22],[17,24,17,26],[18,1,18,2],[18,3,18,5],[18,6,18,9],[18,11,18,12],[18,13,18,14],[18,17,18,19],[18,20,18,22],[18,24,18,26],[17,1,17,2],[17,3,17,5],[17,6,17,9],[17,11,17,12],[17,13,17,14],[17,17,17,19],[19,20,19,22],[19,24,19,26],[20,1,20,2],[20,3,20,5],[20,6,20,9],[20,11,20,12],[20,13,20,14],[20,17,20,19],[20,20,20,22],[20,24,20,26],[19,1,19,2],[19,3,19,5],[19,6,19,9],[19,11,19,12],[19,13,19,14],[19,17,19,19],[21,20,21,22],[21,24,21,26],[22,1,22,2],[22,3,22,5],[22,6,22,9],[22,11,22,12],[22,13,22,14],[22,17,22,19],[22,20,22,22],[22,24,22,26],[21,1,21,2],[21,3,21,5],[21,6,21,9],[21,11,21,12],[21,13,21,14],[21,17,21,19],[23,20,23,22],[23,24,23,26],[24,1,24,2],[24,3,24,5],[24,6,24,9],[24,11,24,12],[24,13,24,14],[24,17,24,19],[24,20,24,22],[24,24,24,26],[23,1,23,2],[23,3,23,5],[23,6,23,9],[23,11,23,12],[23,13,23,14],[23,17,23,19],[25,20,25,22],[25,24,25,26],[26,1,26,2],[26,3,26,5],[26,6,26,9],[26,11,26,12],[26,13,26,14],[26,17,26,19],[26,20,26,22],[26,24,26,26],[25,1,25,2],[25,3,25,5],[25,6,25,9],[25,11,25,12],[25,13,25,14],[25,17,25,19],[27,20,27,22],[27,24,27,26],[28,1,28,2],[28,3,28,5],[28,6,28,9],[28,11,28,12],[28,13,28,14],[28,17,28,19],[28,20,28,22],[28,24,28,26],[27,1,27,2],[27,3,27,5],[27,6,27,9],[27,11,27,12],[27,13,27,14],[27,17,27,19],[29,20,29,22],[29,24,29,26],[30,1,30,2],[30,3,30,5],[30,6,30,9],[30,11,30,12],[30,13,30,14],[30,17,30,19],[30,20,30,22],[30,24,30,26],[29,1,29,2],[29,3,29,5],[29,6,29,9],[29,11,29,12],[29,13,29,14],[29,17,29,19],[31,20,31,22],[31,24,31,26],[32,1,32,2],[32,3,32,5],[32,6,32,9],[32,11,32,12],[32,13,32,14],[32,17,32,19],[32,20,32,22],[32,24,32,26],[31,1,31,2],[31,3,31,5],[31,6,31,9],[31,11,31,12],[31,13,31,14],[31,17,31,19],[33,20,33,22],[33,24,33,26],[34,1,34,2],[34,3,34,5],[34,6,34,9],[34,11,34,12],[34,13,34,14],[34,17,34,19],[34,20,34,22],[34,24,34,26],[33,1,33,2],[33,3,33,5],[33,6,33,9],[33,11,33,12],[33,13,33,14],[33,17,33,19],[35,24,35,26],[36,1,36,2],[36,3,36,5],[36,6,36,9],[36,11,36,12],[36,13,36,14],[36,17,36,19],[36,20,36,22],[36,24,36,26],[35,1,35,2],[35,3,35,5],[35,6,35,12],[35,13,35,14],[35,17,35,19],[35,20,35,22],[39,17,39,18],[40,4,40,7],[40,8,40,9],[40,12,40,13],[37,1,37,9],[37,10,37,14],[37,15,37,19],[38,4,38,7],[38,8,38,9],[38,12,38,13],[38,15,38,16],[38,17,38,18],[41,4,41,7],[41,8,41,9],[41,12,41,13],[42,4,42,7],[42,8,42,9],[42,10,42,13],[39,4,39,7],[39,8,39,9],[39,12,39,13],[45,4,45,7],[45,8,45,9],[45,12,45,13],[45,16,45,24],[46,4,46,7],[46,8,46,9],[46,16,46,24],[43,4,43,7],[43,8,43,9],[43,10,43,14],[43,16,43,24],[44,4,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[44,16,44,24],[49,11,49,15],[47,1,47,7],[47,8,47,9],[47,11,47,13],[47,14,47,15],[47,16,47,24],[48,11,48,13],[48,14,48,15],[48,16,48,20],[48,21,48,23],[48,24,48,27]]}
[]
[null,null,null,null,null,null,"BUSINESS TRAVEL EXPENSE REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VOUCHER #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RECEIPT #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INVOICE #"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFICE"]
[null,null,"NAME: ","",null,null,null,null,"WABASH ID #: ",null,null,"",null,null,null,"TYPE OF TRAVEL: "]
[]
[null,null,"ADDRESS: ","",null,null,null,null,null,null,"DEPARTMENT: ",""]
[]
[null,null,"CITY: ","",null,null,null,null,null,"STATE: ","",null,null,"",null,null,null,null,null,null,null,"","-","","-BELOW","-",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUND",null,"DEPARTMENT","OBJECT",null,"COURSE"]
[null,null,null,null,"PURPOSE OF TRAVEL: "]
[]
[null,null,"LOCATION:","",null,null,null,null,null,null,"PER DIEM RATE: ",null,null,"TRAVEL DATES:",null,"",null,null,null,null,"VEHICLE: ",null,null,""]
[]
[null,"DATE",null,"DAY OF TRAVEL\nFULL (F)        PARTIAL (P)        SAME DAY (S) (More than 12 Hours)",null,null,"DESCRIPTION / LOCATION",null,null,null,"AIRFARE\n5811","HOTEL\n5615",null,"MILEAGE  (62.5¢/MILE)                                                                      5812",null,null,"MEALS  (PER DIEM)\n5634",null,null,null,"BUSINESS MEALS & HOSTING\n5635",null,null,"GROUND TRANSPORT\n5813","OTHER",null,null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NUMBER OF MILES",null,"AMOUNT","RATE","AMOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(N18*0.625,2)","v":0},{"$f":"IF(D18=0,0,$L$14)","v":0},{"$f":"IF(LEFT(D18,1)=\"F\",Q18*1,IF(LEFT(D18,1)=\"P\",Q18*0.75,IF(LEFT(D18,1)=\"S\",Q18*0.75,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"K18+L18+P18+R18+U18+X18+Y18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(D19=0,0,$L$14)","v":0},{"$f":"IF(LEFT(D19,1)=\"F\",Q19*1,IF(LEFT(D19,1)=\"P\",Q19*0.75,IF(LEFT(D19,1)=\"S\",Q19*0.75,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"K19+L19+P19+R19+U19+X19+Y19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Reduction for Meals Provided (See Below)",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(L400-1*O43),\" \")","v":0},null,null,null,null,null,null,null,null,null,{"$f":"R36","v":0}]
[null,null,null,null,null,null,"Total Cost of Travel",null,null,null,{"$f":"SUM(K18:K36)","v":0},{"$f":"SUM(L18:M35)","v":0},null,{"$f":"IF(SUM(N18:O35)=0,\"\",)","v":""},null,0,null,{"$f":"SUM(R18:R36)","v":0},null,null,{"$f":"SUM(U18:W36)","v":0},null,null,{"$f":"SUM(X18:X36)","v":0},{"$f":"SUM(Y18:AA36)","v":0},null,null,{"$f":"SUM(AB18:AB36)","v":0}]
[null,"ACCOUNTING INFORMATION",null,null,null,null,null,null,null,null,"MEALS PROVIDED BY REGISTRATION/HOTEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Cash Advance "]
[null,"FUND","DEPT","COURSE","OBJECT CODES",null,null,null,"AMOUNT",null,"MEALS","#","RATE",null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,"Less Purchasing Card and Prepaid Expenses "]
[null,{"$f":"V10","v":""},{"$f":"X10","v":""},{"$f":"AA10","v":""},"5812-Mileage",null,null,null,{"$f":"P37","v":0},null,"Breakfast:",null,{"$f":"IFERROR(VLOOKUP($L$14,'Per Diem References'!$A$1:$D$6,2,FALSE),\" \")","v":" "},null,{"$f":"IFERROR(SUM(L40*M40),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,"Less Reimbursed Expenses "]
[null,{"$f":"V10","v":""},{"$f":"$C40","v":""},{"$f":"$D40","v":""},"5634-Per Diem",null,null,null,{"$f":"R37","v":0},null,"Lunch:",null,{"$f":"IFERROR(VLOOKUP($L$14,'Per Diem References'!$A$1:$D$6,3,FALSE),\" \")","v":" "},null,{"$f":"IFERROR(SUM(L41*M41),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,"Less Credit for Excess Over Cap Allowed by Department"]
[null,{"$f":"$B41","v":""},"","",null,null,null,null,null,null,"Dinner:",null,{"$f":"IFERROR(VLOOKUP($L$14,'Per Diem References'!$A$1:$D$6,4,FALSE),\" \")","v":" "},null," ",null,null,null,null,null,null,null,null,null,null,null,"Total to be Paid to Traveler (+) or Due to the College (-) ",{"$f":"AB37-AB38-AB39-AB40+AB41","v":0}]
[null,"","","",null,null,null,null,null,null,"Reduction:",null,null,null,{"$f":"SUM(O40:O42)","v":0}]
[null,"","","",null,null,null,null,null,null,"TRAVEL EXPENSE CAPPED BY DEPARTMENT"]
[null,"","","",null,null,null,null,null,null,"DEPARTMENTAL CAP",null,"TRIP EXPENSE",null,"OVER CAP",null,"   EMPLOYEE SIGNATURE",null,null,null,null,null,null,null,null,null,null,"DATE"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L46>0,AB37,0)","v":0},null,{"$f":"IF((M46-L46)>0,L46-M46,0)","v":0}]
[]
[null,"Total Paid to Employee/Business Traveler  ",null,null,null,null,null,null,{"$f":"SUM(I40:J47)","v":0},null,null,null,null,null,null,null,"  BUDGET MANAGER SIGNATURE",null,null,null,null,null,null,null,null,null,null,"DATE"]
[null,"v 01/01/2022",null,null,null,null,null,null,null,null,null,"US Per Diem Rates",null,null,"Foreign Per Diem Rates",null,"Foreign PD Components",null,null,null,null,"Mileage Calculator",null,null,"Foreign Currency Exchange Rates"]
[null,null,null,null,null,null,null,null,null,null,null,"             *Mobile App Available "]

{"sheet":"References","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Frequently-Used Object Codes for Business Travel"]
[]
["Category","Item","Description","Object Codes"]
["Food & Lodging","Hotel","Hotel, Motel, Air BNB","5615-Lodging",null,null,null,"  "]
["Food & Lodging","Meal Per Diem","GSA Meal Per Diem","5634-Meal Per Diem"]
["Food & Lodging","Business Meals","Business Guest Meals (Hosting)","5635-Business Meals"]
["Travel","Airfare","Airfare","5811-Airfare"]
["Travel","Mileage","Personal Auto Miles ","5812-Mileage"]
["Travel","Ground Transportation","Rental Cars, Taxis, Tolls, Metro, Shuttles, Parking, Other","5813-Ground Transportation",null,null,null,"  "]
["Travel","Fuel","Fuel for Rental Car Only","5814-Fuel",null,null,null,"  "]
["Travel","Registration Fees","Conference & Seminar Registration","5860-Registration Fees"]
["Travel","Baggage Fees","Baggage Fees","5870-Other Travel Expenses"]
[]
[]
[]
["Purpose of Travel","Vehicle Use"]
["T01-College Business","Motor Pool - Recharged Separately"]
["T02-Professional Meetings","Personal Vehicle-Mileage"]
["T03-Professional Development","Rental Vehicle-Purchasing Card"]
["T04-Student Recruiting","Personal and Rental Vehicles (Mix)"]
["T05-Athletics Recruiting","None"]
["T06-Donor Relations"]
["T07-Immersion"]
["T08-Student Activities"]
["T09-Other Travel"]
[]
["Travel Day Category"]
["F - Full Day"]
["P - Partial Day"]
["S - Same Day"]

{"sheet":"Per Diem References","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[59,13,15,26,5,44.25]
[64,14,16,29,5,48]
[69,16,17,31,5,51.75]
[74,17,18,34,5,55.5]
[79,18,20,36,5,59.25]