{"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":19,"comments":4,"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":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions for Personal Reimbursement Form"]
[]
[null,"Click on the \"Reimbursement Form\" folder tab below to begin working on your travel 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 name"]
[null,"to a directory you are familiar with."]
[]
[null,"Please complete your departure and return date and time."]
[]
[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,"Per Diem is required unless an exception has been approved.  If you choose to claim less than the per diem rate,"]
[null,"ensure each day amount claimed is less than the Per Diem Allowance Daily Meal per Per Diem Rate."]

{"sheet":"Reimbursement Form","index":1,"n_rows":102,"n_cols":27,"rows_kept":102,"cut":false,"hidden":false,"merged":[[7,8,7,9],[8,7,8,10],[9,2,9,5],[15,14,15,19],[18,14,18,21],[47,2,47,9],[36,2,36,7],[37,2,37,7],[39,2,39,7],[38,2,38,7],[0,8,0,10],[0,1,0,6],[5,7,5,10],[6,7,6,10],[61,4,61,5],[61,6,61,10],[27,1,27,2],[10,2,10,5],[10,7,10,10],[4,8,4,9],[5,2,5,4],[6,2,6,4],[9,7,9,10],[8,2,8,5],[51,2,51,9],[40,2,40,7],[64,1,64,2],[48,2,48,9],[49,2,49,9],[100,2,100,4],[96,2,96,4],[65,1,65,2],[92,2,92,4],[50,2,50,9]]}
[null,"USNH Personal Reimbursement Form",null,null,null,null,null,"INV#"]
[]
[null,"UNH",null,"PSU",null,"KSC",null,"GSC",null,"USNH"]
[]
[null,"Employee/Trip Information",null,null,null,null,null,null,"Date:",null,{"$f":"TODAY()","v":"2019-01-25"},null,"X"]
[null,"Name:",null,null,null,null,"Position/Title:"]
[null,"Department:",null,null,null,null,"Phone:"]
[null,"Depart Date & Time:",null,null,null,null,"Return Date & Time:"]
[null,"Destination:",null,null,null,null,"USNH ID"]
[null,"Project/Grant:",null,null,null,null,"Address:"]
[null,"Bus. Purpose:"]
[]
[null,"Employee Paid Expenses",null,null,null,null,null,null,null,null,"TOTAL"]
[null,"Date (MM/DD/YY)",{"$f":"IF(ISBLANK(DepartDate),\"\",DepartDate)","v":""},{"$f":"IF(AND(ISBLANK(DepartDate),C14=\"\"),\"\",+C14+1)","v":""},{"$f":"IF(AND(ISBLANK(DepartDate),D14=\"\"),\"\",+D14+1)","v":""},"","","","",""]
[null,"Day",{"$f":"IF(C14<>\"\",TEXT(C14,\"dddd\"),\"\")","v":""},{"$f":"IF(D14<>\"\",TEXT(D14,\"dddd\"),\"\")","v":""},"","","","","","",null,null,null,"Milage reimbursement template line"]
[null,"Auto Rental",null,null,null,null,null,null,null,null,{"$f":"SUM(C16:J16)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N16=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N16,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N16,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N16,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"x\",VLOOKUP(DATEVALUE(TEXT(N16,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(N16,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(V16=\"\",\"\",(U16*V16))","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",null,null,null,null,null,null,null,null,"Percent Allocations - "]
[null,null," and do not complete the Adjusted Per Diem Rate section. (Amount claimed must be less than the Per Diem Allowance daily Meal per Per Diem Rate).",null,null,null,null,null,null,null,null,"Breakfast",0.2,null,null,null,null,"1994-01-01","Earliest allowable date"]
[]
[null,"Per Diem Allowance",null,null,null,null,null,null,null,null,null,"Lunch",0.25,null,null,null,null,"2019-12-31","Latest allowable date",null,"Updated to 2019 on 12/17/2018"]
[]
[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.55000000000000004]
[null,{"$f":"\"Breakfast - \"&TEXT($M$24,\"#%\")","v":"Breakfast - 20%"},null,null,null,null,null,null,null,null,null,false,{"$f":"IF(L29=TRUE,$M$24,0)","v":0},false,{"$f":"IF(N29=TRUE,0.2,0)","v":0},false,{"$f":"IF(P29=TRUE,0.2,0)","v":0},false,{"$f":"IF(R29=TRUE,0.2,0)","v":0},false,{"$f":"IF(T29=TRUE,0.2,0)","v":0},false,{"$f":"IF(V29=TRUE,0.2,0)","v":0},false,{"$f":"IF(X29=TRUE,0.2,0)","v":0},false,{"$f":"IF(Z29=TRUE,0.2,0)","v":0}]
[null,{"$f":"\"Lunch - \"&TEXT($M$26,\"#%\")","v":"Lunch - 25%"},null,null,null,null,null,null,null,null,null,false,{"$f":"IF(L30=TRUE,$M$26,0)","v":0},false,{"$f":"IF(N30=TRUE,0.25,0)","v":0},false,{"$f":"IF(P30=TRUE,0.25,0)","v":0},false,{"$f":"IF(R30=TRUE,0.25,0)","v":0},false,{"$f":"IF(T30=TRUE,0.25,0)","v":0},false,{"$f":"IF(V30=TRUE,0.25,0)","v":0},false,{"$f":"IF(X30=TRUE,0.25,0)","v":0},false,{"$f":"IF(Z30=TRUE,0.25,0)","v":0}]
[null,{"$f":"\"Dinner - \"&TEXT($M$28,\"#%\")","v":"Dinner - 55%"},null,null,null,null,null,null,null,null,null,false,{"$f":"IF(L31=TRUE,$M$28,0)","v":0},false,{"$f":"IF(N31=TRUE,0.55,0)","v":0},false,{"$f":"IF(P31=TRUE,0.55,0)","v":0},false,{"$f":"IF(R31=TRUE,0.55,0)","v":0},false,{"$f":"IF(T31=TRUE,0.55,0)","v":0},false,{"$f":"IF(V31=TRUE,0.55,0)","v":0},false,{"$f":"IF(X31=TRUE,0.55,0)","v":0},false,{"$f":"IF(Z31=TRUE,0.55,0)","v":0}]
[null,"Daily Meal Total",{"$f":"IF(M32=0, C26,ROUND(((1-M32)*C26),0))","v":0},{"$f":"IF(O32=0, D26,ROUND(((1-O32)*D26),0))","v":0},{"$f":"IF(Q32=0, E26,ROUND(((1-Q32)*E26),0))","v":0},{"$f":"IF(S32=0, F26,ROUND(((1-S32)*F26),0))","v":0},{"$f":"IF(U32=0, G26,ROUND(((1-U32)*G26),0))","v":0},{"$f":"IF(W32=0, H26,ROUND(((1-W32)*H26),0))","v":0},{"$f":"IF(Y32=0, I26,ROUND(((1-Y32)*I26),0))","v":0},{"$f":"IF(AA32=0, J26,ROUND(((1-AA32)*J26),0))","v":0},{"$f":"SUM(C32:J32)","v":0},null,{"$f":"SUM(M29:M31)","v":0},null,{"$f":"SUM(O29:O31)","v":0},null,{"$f":"SUM(Q29:Q31)","v":0},null,{"$f":"SUM(S29:S31)","v":0},null,{"$f":"SUM(U29:U31)","v":0},null,{"$f":"SUM(W29:W31)","v":0},null,{"$f":"SUM(Y29:Y31)","v":0},null,{"$f":"SUM(AA29:AA31)","v":0}]
[]
[null,"Mileage -","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,null,"To add additional mileage lines enter the number of lines, press tab, then click \"Add Mileage Lines\"."]
[null,"Date ","Departure, Destination & Purpose",null,null,null,null,null,"Miles","Mileage Rate"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",IF($E$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B37,\"mm/dd/yyyy\")),PSU_Mileage_Rate_Table,3),IF($G$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B37,\"mm/dd/yyyy\")),KSC_Mileage_Rate_table,3),IF($C$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B37,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($I$3=\"x\",VLOOKUP(DATEVALUE(TEXT(B37,\"mm/dd/yyyy\")),Milage_rate_table,3),IF($K$3=\"X\",VLOOKUP(DATEVALUE(TEXT(B37,\"mm/dd/yyyy\")),Milage_rate_table,3),\"\"))))))","v":""},{"$f":"IF(J37=\"\",\"\",(I37*J37))","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,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,null,null,"Total Mileage Expenses",null,null,{"$f":"SUM(K37:K42)","v":0}]
[null,"Business Expenses -"]
[]
[]
[null,"Date","Description of Expense",null,null,null,null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Business Expenses",null,null,{"$f":"SUM(K48:K53)","v":0}]
[]
[null,null,null,null,null,null,"Total Expenses Paid by Employee",null,null,null,{"$f":"SUM(K54,K43,K32,K16:K21)","v":0}]
[null,null,null,null,null,null,"Original Amount of Advance"]
[null,null,null,null,null,null,{"$f":"IF((K56-K57)>=0,\"Amount Due to Employee\",\"Amount Due to Cashier\")","v":"Amount Due to Employee"},null,null,null,{"$f":"IF((K56-K57)<0,((K56-K57)*-1),(K56-K57))","v":0}]
[]
[]
[null,"Accounting Information"]
[null,"USNH ID (Banner Vendor Code):",null,null,null,null," Expense Distribution"]
[null,null,null,"FUND","ORG","ACCOUNT","PROG","ACTIVITY","LOCATION","AMOUNT"]
[]
[null,"Advance "]
[null,"(To be completed by Travel Center.)"]
[]
[null,"Advance Number:"]
[]
[null,null,null,null,null,null,null,null,null,null,"Undistributed"]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J64:J70)","v":0},{"$f":"K56-J71","v":0}]
[]
[null,"Approvals/Signatures"]
[]
[null,"I certify that the above expenses were incurred by me in fulfillment of my duties to the University "]
[null,"System of New Hampshire, that the amounts shown conform to the travel regulations in the "]
[null,"University System policy manual, and that no amounts have been or will be submitted for"]
[null,"reimbursement elsewhere."]
[]
[]
[null,"Signed by:"]
[null,null,"Traveler",null,null,null,"Date"]
[]
[]
[null,"Signed by:"]
[null,null,"Dean, Director, Dept Head, Bus. Mgr.",null,null,null,"Date"]
[]
[]
[null,"Signed by:"]
[null,null,"Additional Dean, Director etc. (If needed)",null,null,null,"Date"]
[]
[]
[null,"Signed by:"]
[null,null,"Authorized BSC/FSC Representative",null,null,null,"Date"]
[]
[]
[null,"Signed by:"]
[null,null,"Sponsored Research (If Applicable)",null,null,null,"Date"]
[]
[]
[null,"Signed by:"]
[null,null,"Travel Coordinator/Entered by",null,null,null,"Date"]

{"sheet":"Variables USNH","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"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":"1994-01-01"},{"$f":"'Reimbursement Form'!S24","v":"Earliest allowable date"}]
["Period-begin","Period-End","Mileage Rate"]
["1925-01-01","1997-12-31",0.1,null,{"$f":"'Reimbursement Form'!R26","v":"2019-12-31"},{"$f":"'Reimbursement Form'!S26","v":"Latest allowable date"}]
["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",null,0.57999999999999996,"Mileage Rate Change per Faith 12/18/18"]

{"sheet":"Variables PSU","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,7],[4,2,4,9],[9,3,9,7],[10,3,10,7]]}
[]
[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":"Earliest allowable date"}]
["Period-begin","Period-End","Mileage Rate"]
["2015-09-15","2018-02-28",0.5,null,{"$f":"'Reimbursement Form'!R26","v":"2019-12-31"},{"$f":"'Reimbursement Form'!S26","v":"Latest allowable date"}]
["2018-03-01","2018-12-31",0.54500000000000004,"Changed mileage rate Per Thomas Weeks 3/21/18 email in AP folder"]
["2019-01-01",null,0.57999999999999996,"Changed mileage rate Per Thomas Weeks 1/18/19 email in AP folder"]

{"sheet":"Variables KSC","index":4,"n_rows":9,"n_cols":11,"rows_kept":9,"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":"Earliest allowable date"}]
["Period-begin","Period-End","Mileage Rate"]
["2011-01-01",null,0.51,null,{"$f":"'Reimbursement Form'!R26","v":"2019-12-31"},{"$f":"'Reimbursement Form'!S26","v":"Latest allowable date"}]