{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["One Week","Multiple Weeks"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"One Week","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[12,0,12,1],[11,2,14,5],[15,0,15,9],[13,6,13,9],[14,6,14,9],[13,0,13,1],[14,0,14,1],[6,0,7,0],[6,1,7,3],[54,0,54,3],[4,6,4,9],[5,6,5,9],[9,4,9,9],[8,7,8,9],[5,0,5,3],[8,1,8,3],[9,1,9,3],[36,0,36,4],[16,0,16,1],[11,0,11,1],[35,0,35,4],[11,6,11,9],[12,6,12,9]]}
[null,null,null,null,null,null,null,null,null,"Travel Expense Report"]
[null,null,null,null,null,null,null,"WE",{"$f":"+G8","v":"00:00:00"}]
[]
[]
[" Traveler's Name",null,null,null," Destination(s)"]
[null,null,null,null,"  Exchange Rate Used"]
["Mich Tech ID",null,null,null," Date of Departure",null,null," Time of Departure"]
[null,null,null,null," Date of Return",null,null," Time of Return"]
[" Department",null,null,null," Name(s) of others on trip"]
["  Index"]
[" Address to which check is to be sent",null," Purpose of trip & benefit to the University",null,null,null,"List Procurement Card charges and Amounts"]
[]
[]
[]
[]
["Meal per diem instructions: Enter the total per diem amount for the city, or if not claiming the entire amount, enter the amount for each individual meal. The first and last day of travel are reimbursed at 75% of the entire daily rate. Any day that per diem is claimed, $5 for tips and incidental expenses is included. To reduce 1st or last day per diem, enter a negative amount in Other."]
["WEEK 1",null,"1st Day","Last Day",null,null,"-----------------Additional Days of Travel-----------------",null,null,"TOTAL"]
[null,"Date >>"]
[null,"City for lodging >>"]
[null,"Daily meal per diem for city >>"]
["Breakfast",null,null,null,null,null,null,null,null,{"$f":"SUM(C21:I21)","v":0}]
["Lunch",null,null,null,null,null,null,null,null,{"$f":"SUM(C22:I22)","v":0}]
["Dinner",null,null,null,null,null,null,null,null,0]
["Incidental expenses",null,null,null,null,null,null,null,null,{"$f":"SUM(C24:I24)","v":0}]
["Meal per diem subtotal:",null,{"$f":"IF(C20>0, IF(C24>0, C24, (0.75*C20)), IF(C24>0, C24, 0))","v":0},{"$f":"IF(D20>0, IF(D24>0, D24, (0.75*D20)), IF(D24>0, D24, 0))","v":0},{"$f":"IF(E20>0, IF((E21+E22+E23+E24)<>0, (E21+E22+E23+E24), (E20)), IF((E21+E22+E23+E24)>0, (E21+E22+E23+E24), 0))","v":0},{"$f":"IF(F20>0, IF((F21+F22+F23+F24)<>0, (F21+F22+F23+F24), (F20)), IF((F21+F22+F23+F24)>0, (F21+F22+F23+F24), 0))","v":0},0,0,0,0]
["Lodging",null,null,null,null,null,null,null,null,0]
["Airline Tickets",null,null,null,null,null,null,null,null,0]
["Ground Transportation",null,null,null,null,null,null,null,null,0]
["Business Meals - Attachment",null,null,null,null,null,null,null,null,0]
["Conference Fees",null,null,null,null,null,null,null,null,0]
["Tolls/Parking",null,null,null,null,null,null,null,null,0]
["Telephone-International Travel",null,null,null,null,null,null,null,null,0]
["Car Rental/Gas",null,null,null,null,null,null,null,null,0]
["Other (Explain on receipt or memo)",null,null,null,null,null,null,null,null,0]
[null,"EXPENSES >>",{"$f":"SUM(C25:C34)","v":0},{"$f":"SUM(D25:D34)","v":0},0,0,0,0,0,0]
["PERSONAL CAR EXPENSES",null,null,null,null,null,null,"CASH SUMMARY"]
["Click here for distances from Houghton",null,null,null,null," Subtotal Expenses",null,null,null,{"$f":"+'Multiple Weeks'!K24+'Multiple Weeks'!K44+'Multiple Weeks'!K64+J35","v":0}]
[" From","To","Miles","Rate","Subtotal"," Personal Car Expenses",null,null,null,{"$f":"+E45","v":0}]
[null,null,null,{"$f":"IF(YEAR(G7)=2026,0.725,\"\")","v":""},{"$f":"C39*0.725","v":0}," Total expenses this trip",null,null,null,{"$f":"SUM(J37:J38)","v":0}]
[null,null,null,{"$f":"D39","v":""},{"$f":"C40*0.725","v":0}," Cash advances received"]
[null,null,null,{"$f":"D39","v":""},0]
[null,null,null,{"$f":"D39","v":""},0,"Due traveler",null,null,null,{"$f":"IF(J39-J40>0,+J39-J40,0)","v":0}]
["Vicinity Mileage",null,"Miles","Rate",null,"Due Michigan Tech - attach cash receipt",null,null,null,{"$f":"ABS(IF(+J39-J40<0,+J39-J40,0))","v":0}]
[null,null,null,{"$f":"D39","v":""},{"$f":"C44*0.725","v":0}," "]
["If greater than 100 miles, attach log",null,null,"Total",{"$f":"SUM(E39:E44)","v":0}]
[null,null,null,null,"CERTIFICATION AND APPROVAL"]
[" I, the undersigned, hereby certify that the above listed expenses were actually incurred by me for University purposes as allowed by "]
[" University policies and procedures.  No reimbursement has been received or is anticipated from any third party and if received, will be "]
[" immediately forwarded to the University.  I UNDERSTAND THAT CERTAIN EXPENSES MAY BE TAXABLE AND THAT THE APPLICABLE FICA,"]
[" FEDERAL, AND STATE TAXES WILL BE WITHHELD FROM A FUTURE PAYCHECK."]
[]
[]
["Signature of traveler",null," ","Date",null,"Signature of Department Chair or higher",null,null,null,"Date"]
[]
[]
["Signature of Financial Manager",null,null,"Date",null,"Prepared by"]

{"sheet":"Multiple Weeks","index":1,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[5,0,5,1],[25,0,25,1],[45,0,45,1]]}
[null,null,null,null,null,null,null,null,null,null,"MICHIGAN TECHNOLOGICAL UNIVERSITY"]
[null,null,null,null,null,null,null,null,null,null,"Travel Expense Voucher"]
[]
["Traveler's Name",null,null,null,null,null,null,null,"WE",{"$f":"+'One Week'!I2","v":"00:00:00"}]
[]
["WEEK 2",null,null,null,null,null,"Additional Dates in 2nd Week (Do Not Include Last Day of Travel)",null,null,null,"TOTAL"]
[null,null,"Date >>"]
[null,null,"City for lodging >>"]
[null,null,"Daily meal per diem for city >>"]
["Breakfast",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D10:J10)","v":0}]
["Lunch",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D11:J11)","v":0}]
["Dinner",null,null,null,null,null,null,null,null,null,0]
["Incidental expenses",null,null,null,null,null,null,null,null,null,0]
["Meal per diem subtotal:",null,null,{"$f":"IF(D9>0, IF((D10+D11+D12+D13)<>0, (D10+D11+D12+D13), (D9)), IF((D10+D11+D12+D13)>0, (D10+D11+D12+D13), 0))","v":0},{"$f":"IF(E9>0, IF((E10+E11+E12+E13)<>0, (E10+E11+E12+E13), (E9)), IF((E10+E11+E12+E13)>0, (E10+E11+E12+E13), 0))","v":0},0,0,0,0,0,0]
["Lodging",null,null,null,null,null,null,null,null,null,0]
["Airline Tickets",null,null,null,null,null,null,null,null,null,0]
["Ground Transportation",null,null,null,null,null,null,null,null,null,0]
["Business Meals - Attachment",null,null,null,null,null,null,null,null,null,0]
["Conference Fees",null,null,null,null,null,null,null,null,null,0]
["Tolls/Parking",null,null,null,null,null,null,null,null,null,0]
["Telephone-International Travel",null,null,null,null,null,null,null,null,null,0]
["Car Rental/Gas",null,null,null,null,null,null,null,null,null,0]
["Other (Explain on receipt or memo)",null,null,null,null,null,null,null,null,null,0]
["EXPENSES",null,null,{"$f":"SUM(D14:D23)","v":0},{"$f":"SUM(E14:E23)","v":0},0,0,0,0,0,0]
[]
["WEEK 3",null,null,null,null,null,"Additional Dates in 3rd Week (Do Not Include Last Day of Travel)",null,null,null,"TOTAL"]
[null,null,"Date >>"]
[null,null,"City for lodging >>"]
[null,null,"Daily meal per diem for city >>"]
["Breakfast",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:J30)","v":0}]
["Lunch",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D31:J31)","v":0}]
["Dinner",null,null,null,null,null,null,null,null,null,0]
["Incidental expenses",null,null,null,null,null,null,null,null,null,0]
["Meal per diem subtotal:",null,null,{"$f":"IF(D29>0, IF((D30+D31+D32+D33)<>0, (D30+D31+D32+D33), (D29)), IF((D30+D31+D32+D33)>0, (D30+D31+D32+D33), 0))","v":0},{"$f":"IF(E29>0, IF((E30+E31+E32+E33)<>0, (E30+E31+E32+E33), (E29)), IF((E30+E31+E32+E33)>0, (E30+E31+E32+E33), 0))","v":0},0,0,0,0,0,0]
["Lodging",null,null,null,null,null,null,null,null,null,0]
["Airline Tickets",null,null,null,null,null,null,null,null,null,0]
["Ground Transportation",null,null,null,null,null,null,null,null,null,0]
["Business Meals - Attachment",null,null,null,null,null,null,null,null,null,0]
["Conference Fees",null,null,null,null,null,null,null,null,null,0]
["Tolls/Parking",null,null,null,null,null,null,null,null,null,0]
["Telephone-International Travel",null,null,null,null,null,null,null,null,null,0]
["Car Rental/Gas",null,null,null,null,null,null,null,null,null,0]
["Other (Explain on receipt or memo)",null,null,null,null,null,null,null,null,null,0]
["EXPENSES",null,null,{"$f":"SUM(D30:D43)","v":0},0,0,0,0,0,0,{"$f":"SUM(D44:J44)","v":0}]
[]
["WEEK 4",null,null,null,null,null,"Additional Dates in 4th Week (Do Not Include Last Day of Travel)",null,null,null,"TOTAL"]
[null,null,"Date >>"]
[null,null,"City for lodging >>"]
[null,null,"Daily meal per diem for city >>"]
["Breakfast",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:J50)","v":0}]
["Lunch",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:J51)","v":0}]
["Dinner",null,null,null,null,null,null,null,null,null,0]
["Incidental expenses",null,null,null,null,null,null,null,null,null,0]
["Meal per diem subtotal:",null,null,{"$f":"IF(D49>0, IF((D50+D51+D52+D53)<>0, (D50+D51+D52+D53), (D49)), IF((D50+D51+D52+D53)>0, (D50+D51+D52+D53), 0))","v":0},{"$f":"IF(E49>0, IF((E50+E51+E52+E53)<>0, (E50+E51+E52+E53), (E49)), IF((E50+E51+E52+E53)>0, (E50+E51+E52+E53), 0))","v":0},0,0,0,0,0,0]
["Lodging",null,null,null,null,null,null,null,null,null,0]
["Airline Tickets",null,null,null,null,null,null,null,null,null,0]
["Ground Transportation",null,null,null,null,null,null,null,null,null,0]
["Business Meals - Attachment",null,null,null,null,null,null,null,null,null,0]
["Conference Fees",null,null,null,null,null,null,null,null,null,0]
["Tolls/Parking",null,null,null,null,null,null,null,null,null,0]
["Telephone-International Travel",null,null,null,null,null,null,null,null,null,0]
["Car Rental/Gas",null,null,null,null,null,null,null,null,null,0]
["Other (Explain on receipt or memo)",null,null,null,null,null,null,null,null,null,0]
["EXPENSES",null,null,{"$f":"SUM(D50:D63)","v":0},{"$f":"SUM(E50:E63)","v":0},0,0,0,0,0,{"$f":"SUM(D64:J64)","v":0}]