{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Reimbursement Form","Variables USNH","Variables PSU","Variables KSC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Instructions","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,1,15,8],[28,1,28,8],[20,1,21,9],[22,1,22,9],[23,1,23,9],[2,1,2,9],[9,2,9,6],[10,2,10,5],[14,1,14,9],[8,2,8,6],[7,2,7,6],[11,2,11,8],[12,2,12,7],[34,1,34,8],[27,1,27,9],[16,1,17,9],[18,1,18,4],[24,1,24,9],[26,1,26,2],[31,1,31,9],[32,1,32,9],[33,1,33,8],[25,1,25,9],[29,1,29,8]]}
[null,"Instructions for Personal Reimbursement Form"]
[]
[null,"Click on the \"Reimbursement Form\" folder tab below to begin working on your reimbursement form."]
[]
[null,"The Personal Reimbursement Form is an Excel spreadsheet that has been formatted to allow "]
[null,"you to easily complete your travel reimbursements. Its features include:"]
[]
[null,null,"1.  Automatically performs all math calculations."]
[null,null,"2.  Generates day of week based on date entered."]
[null,null,"3.  Determines mileage rate based on dates traveled."]
[null,null,"4.  Calculates reduced meal per diems."]
[null,null,"5.  Allows traveler to add additional mileage lines for multiple day trips."]
[null,null,"6.  Allows traveler to add additional business expense lines."]
[]
[null,"The easiest way to move around the reimbursement form is to use your \"tab\" key.  The spreadsheet"]
[null,"has been formatted to guide you to the cells you need to complete."]
[null,"When you are completed with your reimbursement form, you will need to save the file with a new "]
[]
[null,"name to a directory you are familiar with."]
[]
[null,"Please place an X in the box next to your campus. It will allow the form to update the mileage rate for your campus."]
[]
[null,"Please complete your departure and return date. The form will not allow you to save or print before these fields are completed"]
[]
[null,"Per Diem is required unless an exception has been approved.  If you choose to claim less than the "]
[null,"per diem rate, ensure each day amount claimed is less than the Per Diem Allowance Daily Meal "]
[null,"per Per Diem Rate."]
[null,"To find incidental Per Diem for outside of the Contiguous (lower) 48 states please visit the Defense \nTravel Management Office and select your destination. Incidental Per Diem for inside the  \nContiguous 48 states is currently listed at $5.00 Per day. The form should input the $5.00 for you. "]
[null,"https://www.travel.dod.mil/Travel-Transportation-Rates/Per-Diem/Per-Diem-Rate-Lookup/"]
[null,"The site may give an unsafe error but this is okay go to advanced setting to advance."]
[]
[null,"Send the Reimbursement Form including required approval to the USNH Travel & Expense"]
[null,"Department along will all of the receipts and documentation to substantiate the reimbursement "]
[null,"to the following email address: "]
[null,"foc.expense@usnh.edu"]

{"sheet":"Reimbursement Form","index":1,"n_rows":118,"n_cols":650,"rows_kept":118,"cut":false,"hidden":false,"merged":[[59,1,59,7],[60,2,60,3],[61,2,61,3],[61,4,61,9],[51,2,51,6],[52,2,52,6],[53,2,53,6],[43,2,43,10],[35,1,35,2],[9,2,9,5],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[117,6,117,7],[108,1,109,4],[108,6,109,7],[10,2,10,5],[110,2,110,3],[110,6,110,7],[55,1,55,6],[55,7,55,8],[56,2,58,10],[28,1,30,1],[28,2,30,10],[9,6,10,6],[9,7,10,10],[44,2,44,10],[45,1,45,7],[46,2,46,6],[0,8,0,10],[0,1,0,6],[4,1,4,2],[4,8,4,9],[8,7,8,10],[5,7,5,10],[7,7,7,10],[5,2,5,4],[5,5,5,6],[7,5,7,6],[6,7,6,10],[6,5,6,6],[8,2,8,5],[6,2,6,4],[24,14,24,15],[11,2,11,10],[13,1,13,5],[14,1,14,10],[17,1,17,10],[21,14,21,18],[24,16,24,21],[72,7,72,9],[73,0,73,5],[75,1,75,2],[69,7,69,9],[66,2,66,3],[67,2,67,3],[67,4,67,9],[66,4,66,9],[63,4,63,9],[64,2,64,3],[64,4,64,9],[65,2,65,3],[65,4,65,9],[63,2,63,3],[76,1,76,2],[76,4,76,5],[76,6,76,10],[108,9,109,9],[107,1,107,9],[91,1,97,9],[114,1,114,3],[70,7,70,9],[71,6,71,9],[115,1,116,4],[115,6,116,7],[115,9,116,9],[78,1,83,2],[85,1,85,3],[89,1,89,2],[105,1,105,4],[99,1,100,4],[99,6,100,7],[103,1,104,4],[103,6,104,7],[103,9,104,9],[111,1,111,3]]}
[null,"USNH Personal Reimbursement Form",null,null,null,null,null,"INV#"]
[]
[null,"check campus: UNH",null,"PSU",null,"KSC",null,"USNH",null," "," ",null,"X"]
[]
[null,"Employee/Trip Information",null,null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2023-12-18"}]
[null,"Name:",null,null,null,"Position/Title:"]
[null,"Department:",null,null,null,"Flexible Working Arrangement Status:"]
[null,"Depart Date:",null,"Return Date:",null,"Phone:"]
[null,"Destination:",null,null,null,null,"USNH ID#",null,null,null,null,null,"Yes"]
[null,"Project/Grant:",null,null,null,null,"Mailing Address:",null,null,null,null,null,"No"]
[]
[null,"Business Purpose*:"]
[]
[null,"Was this trip combined with vacation or personal travel time?",null,null,null,null,null,"Yes",null,"No"]
[null,"      If yes, please attach a statement and documentation that support the period and cost of the business portion of the trip. "]
[]
[null,"Is this trip/expense related to a sponsored program or grant, other than AES?",null,null,null,null,null,null,"Yes",null,"No"]
[null,"     If yes, please route this form to your STAR GCA."]
[null,"Employee Paid Expenses",null,null,null,null,null,null,null,null,"TOTAL"]
[null,"Date (MM/DD/YY)",{"$f":"IF(ISBLANK(C8),\"\",C8)","v":""},{"$f":"IF(C8=\"\",\"\",IF(C20=\"\",\"\",IF(C20+1>E8,\"\",C20+1)))","v":""},{"$f":"IF($C$8=\"\",\"\",IF(D20=\"\",\"\",IF(D20+1>E8,\"\",D20+1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(E20=\"\",\"\",IF(E20+1>E8,\"\",E20+1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(F20=\"\",\"\",IF(F20+1>E8,\"\",F20+1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(G20=\"\",\"\",IF(G20+1>E8,\"\",G20+1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(H20=\"\",\"\",IF(H20+1>E8,\"\",H20+1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(I20=\"\",\"\",IF(I20+1>E8,\"\",I20+1)))","v":""}]
[null,"Day",{"$f":"IF(C20<>\"\",TEXT(C20,\"dddd\"),\"\")","v":""},{"$f":"IF(D20<>\"\",TEXT(D20,\"dddd\"),\"\")","v":""},"","","","","","",null,null,null,"Mileage reimbursement template line"]
[null,"Auto Rental",null,null,null,null,null,null,null,null,{"$f":"SUM(C22:J22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N22=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N22,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N22,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"X\",VLOOKUP(DATEVALUE(TEXT(N22,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"X\",VLOOKUP(DATEVALUE(TEXT(N22,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(N22,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(V22=\"\",\"\",(U22*V22))","v":""}]
[null,"Taxi/Tolls/Parking",null,null,null,null,null,null,null,null,0]
[null,"Air/Bus Fare",null,null,null,null,null,null,null,null,0,null,null,"Business Expense template line"]
[null,"Telephone/Fax",null,null,null,null,null,null,null,null,0]
[null,"Lodging",null,null,null,null,null,null,null,null,0]
[null,"Other",null,null,null,null,null,null,null,null,0,null,null,"Moved to this page as validations will not work across tabs in versions < 2010."]
[]
[null,"Meals -","Per Diem is required unless an exception has been approved.  If you choose to claim less than the per diem rate, enter that amount in Per Diem Allowance\n and do not complete the Adjusted Per Diem Rate section. (Amount claimed must be less than the Per Diem Allowance daily Meal Per Diem Rate).",null,null,null,null,null,null,null,null,"Percent Allocations - "]
[null,null,null,null,null,null,null,null,null,null,null,"First and Last Day",0.75]
[null,null,null,null,null,null,null,null,null,null,null,true,0.25,0.25,null,null,null,"1994-01-01","Earliest allowable date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"Per Diem Allowance",null,null,null,null,null,null,null,null,null,"Lunch",0.28000000000000003,null,null,null,null,null,"Latest allowable date",null,"Updated to 202 on 01/6/22"]
[null,"Incidental",{"$f":"IF(C33=\"\",\"\",5)","v":""},{"$f":"IF(D33=\"\",\"\",5)","v":""},"","","","","",""]
[null,"Meals Allowance",{"$f":"IF(C33=\"\",\"\",C33-C34)","v":""},"","","","","","","",null,null,null,null,null,true,null,null,null,null,null,null,null,true]
[null,"Adjusted Per Diem Rate",null,"Indicate if meals were provided by other sources - included with conference, provided by a colleague or vendor, etc.",null,null,null,null,null,null,null,"Dinner",0.47]
[null,{"$f":"\"First or Last Day - \"&TEXT($M$30,\"#%\")","v":"First or Last Day - 75%"},null,null,null,null,null,null,null,null,null,{"$f":"IF($C$37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(L37=TRUE,$M$30,0)","v":0},{"$f":"IF($D$37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(N37=TRUE,$M$30,0)","v":0},{"$f":"IF(E37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(P37=TRUE,$M$30,0)","v":0},{"$f":"IF(F37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(R37=TRUE,$M$30,0)","v":0},{"$f":"IF(G37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(T37=TRUE,$M$30,0)","v":0},{"$f":"IF(H37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(V37=TRUE,$M$30,0)","v":0},{"$f":"IF(I37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(X37=TRUE,$M$30,0)","v":0},{"$f":"IF(J37=\"\",FALSE,TRUE)","v":false},{"$f":"IF(Z37=TRUE,$M$30,0)","v":0}]
[null,"Other than the first or last day:"]
[null,{"$f":"\"Breakfast - \"&TEXT($M$31,\"#%\")","v":"Breakfast - 25%"},null,null,null,null,null,null,null,null,null,{"$f":"IF($C$39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(L$39=TRUE,$M$31,0)","v":0},{"$f":"IF(D39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(N$39=TRUE,$M$31,0)","v":0},{"$f":"IF(E39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(P$39=TRUE,$M$31,0)","v":0},{"$f":"IF(F39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(R$39=TRUE,$M$31,0)","v":0},{"$f":"IF(G39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(T$39=TRUE,$M$31,0)","v":0},{"$f":"IF(H39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(V$39=TRUE,$M$31,0)","v":0},{"$f":"IF(I39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(X$39=TRUE,$M$31,0)","v":0},{"$f":"IF(J39=\"\",FALSE,TRUE)","v":false},{"$f":"IF(Z$39=TRUE,$M$31,0)","v":0}]
[null,{"$f":"\"Lunch - \"&TEXT($M$33,\"#%\")","v":"Lunch - 28%"},null,null,null,null,null,null,null,null,null,{"$f":"IF($C$40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(L$40=TRUE,$M$33,0)","v":0},{"$f":"IF(D40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(N$40=TRUE,$M$33,0)","v":0},{"$f":"IF(E40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(P$40=TRUE,$M$33,0)","v":0},{"$f":"IF(F40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(R$40=TRUE,$M$33,0)","v":0},{"$f":"IF(G40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(T$40=TRUE,$M$33,0)","v":0},{"$f":"IF(H40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(V$40=TRUE,$M$33,0)","v":0},{"$f":"IF(I40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(X$40=TRUE,$M$33,0)","v":0},{"$f":"IF(J40=\"\",FALSE,TRUE)","v":false},{"$f":"IF(Z$40=TRUE,$M$33,0)","v":0}]
[null,{"$f":"\"Dinner - \"&TEXT($M$36,\"#%\")","v":"Dinner - 47%"},null,null,null,null,null,null,null,null,null,{"$f":"IF($C$41=\"\",FALSE,TRUE)","v":false},{"$f":"IF(L41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(N$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(P$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(R$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(T$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(V$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(X$41=TRUE,$M$36,0)","v":0},false,{"$f":"IF(Z$41=TRUE,$M$36,0)","v":0}]
[null,"Daily Allowance Total",{"$f":"IF(L37=TRUE,(C33*0.75),IF(M42=0,C33,(C35)*(1-M42)+C34))","v":0},{"$f":"IF(N37=TRUE,(D33*0.75),IF(O42=0,D33,(D35)*(1-O42)+D34))","v":0},{"$f":"IF(P37=TRUE,(E33*0.75),IF(Q42=0,E33,(E35)*(1-Q42)+E34))","v":0},{"$f":"IF(R37=TRUE,(F33*0.75),IF(S42=0,F33,(F35)*(1-S42)+F34))","v":0},{"$f":"IF(T37=TRUE,(G33*0.75),IF(U42=0,G33,(G35)*(1-U42)+G34))","v":0},{"$f":"IF(V37=TRUE,(H33*0.75),IF(W42=0,H33,(H35)*(1-W42)+H34))","v":0},{"$f":"IF(X37=TRUE,(I33*0.75),IF(Y42=0,I33,(I35)*(1-Y42)+I34))","v":0},{"$f":"IF(Z37=TRUE,(J33*0.75),IF(AA42=0,J33,(J35)*(1-AA42)+J34))","v":0},{"$f":"SUM(C42:J42)","v":0},null,{"$f":"SUM(M37:M41)","v":0},null,{"$f":"SUM(O37:O41)","v":0},null,{"$f":"SUM(Q37:Q41)","v":0},null,{"$f":"SUM(S37:S41)","v":0},null,{"$f":"SUM(U37:U41)","v":0},null,{"$f":"SUM(W37:W41)","v":0},null,{"$f":"SUM(Y37:Y41)","v":0},null,{"$f":"SUM(AA37:AA41)","v":0}]
[]
[null,"Mileage -","Enter only allowable reimbursable mileage in this section.  Refer to USNH policy 07-009."]
[null,null,"The mileage rate and total amount will be calculated based on the date and number of miles. Enter dates in MM/DD/YY format."]
[null,"To add additional mileage expense lines enter the number of lines, press tab, then click \"Add Mileage Lines\"."]
[null,"Date ","Departure, Destination, Business Purpose",null,null,null,null,"Round Trip?","Total Miles","Mileage Rate"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B48,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B48,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B48,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B48,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B48,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(J48=\"\",\"\",(I48*J48))","v":""}]
[null,null," ",null,null,null,null,null,null,"",""]
[null,null," ",null,null,null,null,null," ","",""]
[null,null," ",null,null,null,null,null," ","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B52=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B52,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B52,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B52,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B52,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B52,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(J52=\"\",\"\",(I52*J52))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B53=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B53,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B53,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B53,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B53,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B53,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(J53=\"\",\"\",(I53*J53))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B54,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B54,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B54,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B54,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B54,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(J54=\"\",\"\",(I54*J54))","v":""}]
[]
[null,"If multiple trips included above please include business purpose for each trip.",null,null,null,null,null,"Total Mileage Expenses",null,null,{"$f":"SUM(K48:K55)","v":0}]
[null,"Business Expenses -","Business purpose must be explained on each receipt.  Business meals must include a brief description of business purpose including who, what, where, when and why, a detailed receipt, agenda, attendees, and approximate meeting times should be provided. List each item below."]
[]
[]
[null," To add additional business expense lines, enter number of lines, press tab, then click \"Add Bus. Exp. Lines\"."]
[null,"Date","Vendor",null,"Description of Expense",null,null,null,null,null,"Amount"]
[null," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Business Expenses",null,null,{"$f":"SUM(K62:K69)","v":0}]
[null,null,null,null,null,null,null,"Total Expenses Paid by Employee",null,null,{"$f":"SUM(K70,K56,K42,K22:K27)","v":0}]
[null,null,null,null,null,null,"           Original Amount of Advance, if applicable",null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"IF(C6=\"\",\"Amount Due to Employee\",IF(AND(OR(G14=\"X\",I14=\"X\"),OR(H17=\"X\",J17=\"X\")),IF((K71-K72)>=0,\"Amount Due to Employee\",\"Amount Due to Cashier\"),\"Answer The Required Questions\"))","v":"Amount Due to Employee"},null,null,{"$f":"IF(C6=\"\",\"\",IF(H73=\"Answer The Required Questions\",\"Answer Questions at lines 14 and 17\",IF((K71-K72)<0,((K71-K72)*-1),(K71-K72))))","v":""}]
["USNH Personal Reimbursement Form (continued)"]
[]
[null,"Accounting Information"]
[null,"USNH ID (Banner Vendor Code):",null,null,{"$f":"H9","v":0}]
[null,null,null,null,"FUND","ORG","PROG","ACCOUNT","ACTIVITY","LOCATION","AMOUNT"]
[null,"Employees are required to enter the correct fund(s), org(s), and, when applicable, program(s) / activity(s) / location(s); otherwise, the default employee fund / org will be used. Please contact foc.expense@usnh.edu with any questions on this process."]
[]
[]
[]
[]
[]
[]
[null,"Amount Advanced (UNH Central Admin Use Only)"]
[null,null,"Advance Number:",null,null,null,null,null,null,null,{"$f":"K72","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"IF(C6=\"\",\"\",IF(H73=\"Answer The Required Questions\",\"Answer Questions at lines 14 and 17\",SUM(K79:K85)))","v":""}]
[]
[null,"Approvals/Signatures"]
[]
[null,"I certify that the above expenses were incurred in fulfillment of my duties to the University System of New Hampshire; and that all expenses included conform to USNH Financial Services Policies and Procedures related to business travel and business expenditures.  In addition, \n1. All expenses are appropriate and reasonable;  \n2. Where applicable, no expenses above were included in the registration fees of the conference attended;\n3. No expenses above were paid by any other entity;\n4. No expenses above have been submitted for reimbursement elsewhere, nor will they be in the future; \n5. Where applicable, scanned or imaged receipts provided to support these expenses are true copies of the original receipts; and                                                                                         \n6. The Flexible Working Arrangement Status indicated is consistent with the form on file with Human Resources."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Traveler/Payee","Signature",null,null,null,"Date"]
[]
[]
[]
[null,"Name and Title",null,null,null,null,"Signature",null,null,"Date"]
[null,"Expense Approver (Direct supervisor or designee senior to the direct supervisor, Principal Investigator, or SPA) "]
[null," "]
[]
[]
[null,null,"Name and Title",null,null,null,"Signature",null,null,"Date"]
[null,"Exception Approver (if applicable)"]
[]
[]
[null,"Financial Operations Center Staff"]
[]
[]
[null,null,"Name and Title",null,null,null,"Signature",null,null,"Date"]

{"sheet":"Variables USNH","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,2,1,7],[4,2,4,9]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B2=\"\",\"\",VLOOKUP(DATEVALUE(TEXT(B2,\"mm/dd/yyyy\")),Milage_rate_table,3))","v":""},{"$f":"IF(J2=\"\",\"\",(I2*J2))","v":""}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"'Reimbursement Form'!R24","v":"00:00:00"},{"$f":"'Reimbursement Form'!S24","v":0}]
["Period-begin","Period-End","Mileage Rate"]
["1925-01-01","1997-12-31",0.1,null,{"$f":"'Reimbursement Form'!R26","v":"00:00:00"},{"$f":"'Reimbursement Form'!S26","v":0}]
["1998-01-01","1999-03-31",0.33]
["1999-04-01","1999-12-31",0.31,"Changed 11/30/99 AMS - IRS rate to be effective as of 1/1/2000"]
["2000-01-01","2000-12-31",0.33,"Added and correct formulas in cells 'Reimbursement Form!I35:I39' 11/30/99 AMS - IRS rate to be effective as of 1/1/2000"]
["2001-01-01","2001-12-31",0.35]
["2002-01-01","2002-12-31",0.37,"Mileage rate changed per S. McCarthy, Travel Coordinator - svd"]
["2003-01-01","2003-12-31",0.36,"Mileage rate changed per S. McCarthy, Travel Coordinator - svd 12/30/02"]
["2004-01-01","2004-12-31",0.38,"Mileage rate changed per C.Sendak, Tax consultant - ams 01/05/2004"]
["2005-01-01","2005-08-31",0.41,"Mileage rate changed per C. Sendak, Tax consultant - svd 11/24/04"]
["2005-09-01","2005-12-31",0.49,"Mileage rate changed per C. Sendak, Tax consultant - svd 09/12/05"]
["2006-01-01","2006-12-31",0.45,"Mileage rate changed per C. Sendak, Tax consultant - svd 12/06/05"]
["2007-01-01","2007-12-31",0.49,"Mileage rate changed per C. Sendak, Tax consultant - svd 12/06/05",null,null,null,"2006-11-03"]
["2008-01-01","2008-06-30",0.51,"Mileage rate changed per D. Zarembo, Tax consultant - svd 12/06/05",null,null,null,"2007-11-27"]
["2008-07-01","2008-12-31",0.59,"Mileage rate changed per D. Zarembo, Tax consultant - AMS 6/27/2008"]
["2009-01-01","2009-12-31",0.55000000000000004,"Mileage rate changed per D. Zarembo, Tax consultant - AMS 12/1/2008"]
["2010-01-01","2010-12-31",0.5,"Mileage rate changed per D. Zarembo, Tax consultant - AMS 12/24/2009"]
["2011-01-01","2011-06-30",0.51,"Milage rate changed per Steph and CM - AMS 12/21/2010"]
["2011-07-01","2012-12-31",0.55500000000000005,"Milage rate changed per Steph - AMS 6/30/2011"]
["2013-01-01","2013-12-31",0.56499999999999995,"Milage Rate changed per Steph - AMS 12/31/2012"]
["2014-01-01","2014-12-31",0.56000000000000005,"Milage Rate changed per Steph - AMS 12/18/2013"]
["2015-01-01","2015-12-31",0.57499999999999996,"Milage Rate changed per Steph - AMS 12/22/2014"]
["2016-01-01","2016-12-31",0.54,"Milage Rate Changed per Faith - AMS 12/21/2015"]
["2017-01-01","2017-12-31",0.53500000000000003,"Milage Rate Changed per Jay - 12/14/2016"]
["2018-01-01","2018-12-31",0.54500000000000004,"Mileage Rate Changed  by Jay 12/14/17"]
["2019-01-01","2019-12-31",0.57999999999999996,"Mileage Rate Changed per Faith 12/17/18"]
["2020-01-01","2020-12-31",0.57499999999999996,"Mileage Rate Changed per Faith and IRS new release 12/31/19 & 1/2/20"]
["2021-01-01","2021-12-31",0.56000000000000005,"Per IRS new release 12/22/2020 and Jay"]
["2022-01-01","2022-06-30",0.58499999999999996,"Per IRS new release 12/22/2020 and Francine. "]
["2022-07-01","2022-12-31",0.625,"Per IRS news release on 6/9/22 and Francine"]
["2023-01-01","2023-12-31",0.65500000000000003,"Note, no rate change as of 12/22/22, rate changed on 12/31/22"]
["2024-01-01","9999-12-31",0.67,"Per IRS news release on 12/14/23 and Christine Heise."]

{"sheet":"Variables PSU","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,2,1,7],[4,2,4,9]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B2=\"\",\"\",VLOOKUP(DATEVALUE(TEXT(B2,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3))","v":""},{"$f":"IF(J2=\"\",\"\",(I2*J2))","v":""}]
[]
[]
[]
[]
[null,null,null,null,"2015-09-15",{"$f":"'Reimbursement Form'!S24","v":0}]
["Period-begin","Period-End","Mileage Rate"]
["2015-09-15","2018-02-28",0.5,null,{"$f":"'Reimbursement Form'!R26","v":"00:00:00"},{"$f":"'Reimbursement Form'!S26","v":0}]
["2018-03-01","2018-12-31",0.54500000000000004,"Per email in AP folder from Thomas Weeks"]
["2019-01-01","2019-12-31",0.57999999999999996,"Per email in AP folder from Thomas Weeks 1/18/19"]
["2020-01-01","2020-12-31",0.57499999999999996,"Per IRS new release 12/31/19 and email from Thomas Weeks."]
["2021-01-01","2021-12-31",0.56000000000000005,"Per IRS new release 12/22/2020 and email from Thomas Weeks 1/5/2021."]
["2022-01-01","2022-06-30",0.58499999999999996,"Per IRS news release 12/17/2021 and phone call with Thomas Weeks 1/6/2022."]
["2022-07-01","2022-12-31",0.625,"Per IRS news release on 6/9/22 and per email from Thomas Weeks 6/11/22"]
["2023-01-01","2023-12-31",0.65500000000000003,"Note, no rate change as of 12/22/22, rate changed on 12/31/22"]
["2024-01-01","9999-12-31",0.67,"Per IRS news release on 12/14/23 and Christine Heise."]

{"sheet":"Variables KSC","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,2,1,7],[4,2,4,9]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B2=\"\",\"\",VLOOKUP(DATEVALUE(TEXT(B2,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3))","v":""},{"$f":"IF(J2=\"\",\"\",(I2*J2))","v":""}]
[]
[]
[]
[]
[null,null,null,null,"2011-01-01",{"$f":"'Reimbursement Form'!S24","v":0}]
["Period-begin","Period-End","Mileage Rate",null,{"$f":"'Reimbursement Form'!R26","v":"00:00:00"},{"$f":"'Reimbursement Form'!S26","v":0}]
["2011-01-01","2021-10-15",0.51,"Remaining at current rate Per Liane Wiley 1/2/2020 & 1/5/2021"]
["2021-10-21","2021-12-31",0.56000000000000005,"Per Michele Stone 10/26/21 KSC will be following IRS rate."]
["2022-01-01","2022-06-30",0.58499999999999996,"Per Michele Stone teams message on 1/6/21 KSC will follow IRS rate"]
["2022-07-01","2022-12-31",0.625,"Per IRS news release on 6/9/22 and email notice from Brian Downing on 6/10/22"]
["2023-01-01","2023-12-31",0.65500000000000003,"Note, no rate change as of 12/22/22, rate changed on 12/31/22"]
["2024-01-01","9999-12-31",0.67,"Per IRS news release on 12/14/23 and Christine Heise."]