{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TravelReimbursement","parameters"],"not_rendered":{"images":1,"macros":1,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"TravelReimbursement","index":0,"n_rows":117,"n_cols":12,"rows_kept":117,"merged":[[5,3,5,4],[5,6,5,7],[6,3,6,4],[6,6,6,7],[7,6,7,7],[9,1,9,2],[9,3,9,10],[39,1,39,2],[39,3,39,9],[42,4,42,5],[87,1,87,2],[87,3,87,9],[116,1,116,2],[116,3,116,9]]}
[{"$nulls":10},"SPH Central Administrative Units"]
[{"$nulls":10},"Employee Travel Reimbursement Form"]
[{"$nulls":10},"Please only enter fields highlighted in yellow."]
[{"$nulls":10},"If Excel error appears, click \"Enable\" to properly use form."]
[{"$nulls":9},"Total Reimbursement",{"$f":"+K38+K86+K115","v":0}]
[null,null,"Traveler Name:",null,null,"Travel City:",null,null,{"$f":"IF(G7=\"North Carolina\",\"InState\",\"OutofState\")","v":"OutofState"},"Date","Time"]
[null,null,"Traveler PID:",null,null,"Travel State:",null,null,"Departure:"]
[{"$nulls":5},"Travel Country:","United States",null,"Return:"]
[]
[null,"Purpose and Description of Trip (flights from where to where, etc.):"]
[]
[]
[null,"Weekday:",null,"Sun.","Mon.","Tues.","Wed.","Thur.","Fri.","Sat.","Weekly","Running"]
[null,"Relevant Dates ®",null,{"$f":"IF(J7=\"\",\"m/d\",(J7-VLOOKUP(WEEKDAY(J7),t_weekday,2)))","v":"m/d"},{"$f":"IFERROR(D14+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(E14+1,\"m/d\")","v":"m/d"},"m/d","m/d","m/d","m/d","Total","Total"]
["Please enter amounts into the relevant category by dates:"]
[null,"Transportation"]
[null,"Airfare/Train",{"$nulls":8},{"$f":"SUM(D17:J17)","v":0},{"$f":"K17","v":0}]
[null,"Taxi/Tolls/Public",{"$nulls":8},{"$f":"SUM(D18:J18)","v":0},{"$f":"K18","v":0}]
[null,"Rental Car / Gas",{"$nulls":8},0,0]
[null,"Parking",{"$nulls":8},0,0]
[null,"Subtotal Transport",null,{"$f":"SUM(D17:D20)","v":0},{"$f":"SUM(E17:E20)","v":0},0,0,0,0,0,{"$f":"SUM(K17:K20)","v":0},{"$f":"SUM(L17:L20)","v":0}]
[null,"Mileage"]
[null,null,"Enter miles driven -->",{"$nulls":7},{"$f":"SUM(D23:J23)","v":0},{"$f":"K23","v":0}]
[{"$nulls":10},{"$f":"IF(r_totalmileage<=100,K23*r_mileage_higher,IF(f_car_higherrate=\"x\",K23*r_mileage_higher,K23*r_mileage_lower))","v":0},{"$f":"K24","v":0}]
[null,"Lodging & Other"]
[null,"Hotel",{"$nulls":8},{"$f":"SUM(D26:J26)","v":0},{"$f":"K26","v":0}]
[null,"Internet",{"$nulls":8},{"$f":"SUM(D27:J27)","v":0},0]
[null,"Telephone",{"$nulls":8},0,0]
[null,"Registration fees",{"$nulls":8},0,0]
[null,"Other",{"$nulls":8},0,0]
[null,"Subtotal Lodging & Other",null,{"$f":"SUM(D26:D30)","v":0},{"$f":"SUM(E26:E30)","v":0},0,0,0,0,0,0,0]
["Please enter \"x\" into the appropriate meal for each date charged:"]
[null,"Meals"]
[null,"Breakfast"]
[null,"Lunch"]
[null,"Dinner"]
[null,"Subtotal Meals",null,{"$f":"IF(toggle_state=\"InState\",SUMPRODUCT(--((D34:D36)=\"x\"),InState),SUMPRODUCT(--((D34:D36)=\"x\"),OutofState))","v":0},0,0,0,0,0,0,{"$f":"SUM(D37:J37)","v":0},{"$f":"K37","v":0}]
[null,"Total by Day",null,{"$f":"D21+D24+D31+D37","v":0},0,0,0,0,0,0,0,0]
[{"$nulls":10},{"$f":"IF(K38<>$K$5,\"Continued on next page\",\"\")","v":""}]
[null,"Notes (optional):\n(press alt+enter to add\nnew lines within a cell)"]
[]
["Please ensure all original receipts related to this trip are attached, print, sign off and obtain approval."]
[{"$nulls":3},"Enter appropriate cost code to charge:"]
[]
[{"$nulls":7},"Supplemental Info for Mileage: "]
[]
[null,"Signature of Traveler",{"$nulls":3},"Date",null,"Trip exceeded 100 miles - please \"X\" in appropriate case:"]
[{"$nulls":7},"1. A state car was not requested. Use state car rate:",{"$nulls":3},"x"]
[]
[{"$nulls":7},"2. I requested a state car but one was unavailable -"]
[null,"Signature of Unit Approver",{"$nulls":3},"Date",null,"        documentation of the request is attached:"]
[]
[]
[]
[null,"Chartfields (SPH Finance Use)"]
[]
[null,null,"Bus Unit","Fund","Source","Dept","Project ID","Program","Cost Code 1","Cost Code 2","Cost Code 3"]
[{"$nulls":8},{"$f":"f_costcode","v":0}]
[]
[]
[null,"Weekday:",null,"Sun.","Mon.","Tues.","Wed.","Thur.","Fri.","Sat.","Weekly","Running"]
[null,"Relevant Dates ®",null,{"$f":"IFERROR(J14+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(D62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(E62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(F62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(G62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(H62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(I62+1,\"m/d\")","v":"m/d"},"Total","Total"]
["Please enter amounts into the relevant category by dates:"]
[null,"Transportation"]
[null,"Airfare/Train",{"$nulls":8},{"$f":"SUM(D65:J65)","v":0},{"$f":"K65+L17","v":0}]
[null,"Taxi/Tolls/Public",{"$nulls":8},{"$f":"SUM(D66:J66)","v":0},{"$f":"K66+L18","v":0}]
[null,"Rental Car / Gas",{"$nulls":8},{"$f":"SUM(D67:J67)","v":0},{"$f":"K67+L19","v":0}]
[null,"Parking",{"$nulls":8},{"$f":"SUM(D68:J68)","v":0},{"$f":"K68+L20","v":0}]
[null,"Subtotal Transport",null,{"$f":"SUM(D65:D68)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(L65:L68)","v":0}]
[null,"Mileage"]
[null,null,"Enter miles driven -->",{"$nulls":7},{"$f":"SUM(D71:J71)","v":0},{"$f":"K71+L23","v":0}]
[{"$nulls":3},{"$f":"IF(r_totalmileage<=100,D71*r_mileage_higher,IF(f_car_higherrate=\"x\",D71*r_mileage_higher,D71*r_mileage_lower))","v":0},0,0,0,0,0,0,{"$f":"SUM(D72:J72)","v":0},{"$f":"K72+L24","v":0}]
[null,"Lodging & Other"]
[null,"Hotel",{"$nulls":8},{"$f":"SUM(D74:J74)","v":0},{"$f":"K74+L26","v":0}]
[null,"Internet",{"$nulls":8},{"$f":"SUM(D75:J75)","v":0},{"$f":"K75+L27","v":0}]
[null,"Telephone",{"$nulls":8},{"$f":"SUM(D76:J76)","v":0},{"$f":"K76+L28","v":0}]
[null,"Registration fees",{"$nulls":8},{"$f":"SUM(D77:J77)","v":0},{"$f":"K77+L29","v":0}]
[null,"Other",{"$nulls":8},{"$f":"SUM(D78:J78)","v":0},{"$f":"K78+L30","v":0}]
[null,"Subtotal Lodging & Other",null,{"$f":"SUM(D74:D78)","v":0},{"$f":"SUM(E74:E78)","v":0},0,0,0,0,0,0,{"$f":"SUM(L74:L78)","v":0}]
["Please enter \"x\" into the appropriate meal for each date charged:"]
[null,"Meals"]
[null,"Breakfast"]
[null,"Lunch"]
[null,"Dinner"]
[null,"Subtotal Meals",null,{"$f":"IF(toggle_state=\"InState\",SUMPRODUCT(--((D82:D84)=\"x\"),InState),SUMPRODUCT(--((D82:D84)=\"x\"),OutofState))","v":0},0,0,0,0,0,0,{"$f":"SUM(D85:J85)","v":0},{"$f":"K85+L37","v":0}]
[null,"Total by Day",null,{"$f":"D69+D72+D79+D85","v":0},0,0,0,0,0,0,0,{"$f":"L69+L72+L79+L85","v":0}]
[]
[null,"Notes (optional):\n(press alt+enter to add\nnew lines within a cell)"]
[]
[null,"Weekday:",null,"Sun.","Mon.","Tues.","Wed.","Thur.","Fri.","Sat.","Weekly","GRAND"]
[null,"Relevant Dates ®",null,{"$f":"IFERROR(J62+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(D91+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(E91+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(F91+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(G91+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(H91+1,\"m/d\")","v":"m/d"},{"$f":"IFERROR(I91+1,\"m/d\")","v":"m/d"},"Total","TOTAL"]
["Please enter amounts into the relevant category by dates:"]
[null,"Transportation"]
[null,"Airfare/Train",{"$nulls":8},{"$f":"SUM(D94:J94)","v":0},{"$f":"K94+L65","v":0}]
[null,"Taxi/Tolls/Public",{"$nulls":8},{"$f":"SUM(D95:J95)","v":0},{"$f":"K95+L66","v":0}]
[null,"Rental Car / Gas",{"$nulls":8},{"$f":"SUM(D96:J96)","v":0},{"$f":"K96+L67","v":0}]
[null,"Parking",{"$nulls":8},{"$f":"SUM(D97:J97)","v":0},{"$f":"K97+L68","v":0}]
[null,"Subtotal Transport",null,{"$f":"SUM(D94:D97)","v":0},0,0,0,0,0,0,0,0]
[null,"Mileage"]
[null,null,"Enter miles driven -->",{"$nulls":7},{"$f":"SUM(D100:J100)","v":0},{"$f":"K100+L71","v":0}]
[{"$nulls":3},{"$f":"IF(r_totalmileage<=100,D100*r_mileage_higher,IF(f_car_higherrate=\"x\",D100*r_mileage_higher,D100*r_mileage_lower))","v":0},0,0,0,0,0,0,{"$f":"SUM(D101:J101)","v":0},{"$f":"K101+L72","v":0}]
[null,"Lodging & Other"]
[null,"Hotel",{"$nulls":8},{"$f":"SUM(D103:J103)","v":0},{"$f":"K103+L74","v":0}]
[null,"Internet",{"$nulls":8},{"$f":"SUM(D104:J104)","v":0},{"$f":"K104+L75","v":0}]
[null,"Telephone",{"$nulls":8},{"$f":"SUM(D105:J105)","v":0},{"$f":"K105+L76","v":0}]
[null,"Registration fees",{"$nulls":8},{"$f":"SUM(D106:J106)","v":0},{"$f":"K106+L77","v":0}]
[null,"Other",{"$nulls":8},{"$f":"SUM(D107:J107)","v":0},{"$f":"K107+L78","v":0}]
[null,"Subtotal Lodging & Other",null,{"$f":"SUM(D103:D107)","v":0},{"$f":"SUM(E103:E107)","v":0},0,0,0,0,0,0,0]
["Please enter \"x\" into the appropriate meal for each date charged:"]
[null,"Meals"]
[null,"Breakfast"]
[null,"Lunch"]
[null,"Dinner"]
[null,"Subtotal Meals",null,{"$f":"IF(toggle_state=\"InState\",SUMPRODUCT(--((D111:D113)=\"x\"),InState),SUMPRODUCT(--((D111:D113)=\"x\"),OutofState))","v":0},0,0,0,0,0,0,{"$f":"SUM(D114:J114)","v":0},{"$f":"K114+L85","v":0}]
[null,"Total by Day",null,{"$f":"D98+D101+D108+D114","v":0},{"$f":"E98+E101+E108+E114","v":0},{"$f":"F98+F101+F108+F114","v":0},{"$f":"G98+G101+G108+G114","v":0},{"$f":"H98+H101+H108+H114","v":0},{"$f":"I98+I101+I108+I114","v":0},{"$f":"J98+J101+J108+J114","v":0},{"$f":"K98+K101+K108+K114","v":0},0]
[]
[null,"Notes (optional):\n(press alt+enter to add\nnew lines within a cell)"]

{"sheet":"parameters","index":1,"n_rows":198,"n_cols":12,"rows_kept":198}
[null,"a_states",null,"a_countries",null,null,"Updated 07/27/2017"]
[{"$nulls":3},"United States"]
[null,"North Carolina",null,"Afghanistan",null,null,"InState","OutofState",null,"a_cartype"]
[null,"Alabama",null,"Albania",null,"Breakfast",8.4,8.4,null,"Personal car rate",{"v":0.33,"d":"$0.330"},"r_mileage_lower"]
[null,"Alaska",null,"Algeria",null,"Lunch",11,11,null,"State car was unavailable (support required)",{"v":0.545,"d":"$0.545"},"r_mileage_higher"]
[null,"Arizona",null,"Andorra",null,"Dinner",18.9,21.6]
[null,"Arkansas",null,"Angola"]
[null,"California",null,"Antigua & Deps",null,null,"a_x",null,"a_yn"]
[null,"Colorado",null,"Argentina",{"$nulls":4},"Y"]
[null,"Connecticut",null,"Armenia",null,null,"x",null,"N"]
[null,"Delaware",null,"Australia"]
[null,"District of Columbia",null,"Austria",null,null,"t_weekday"]
[null,"Florida",null,"Azerbaijan",null,null,1,0]
[null,"Georgia",null,"Bahamas",null,null,2,1]
[null,"Hawaii",null,"Bahrain",null,null,3,2]
[null,"Idaho",null,"Bangladesh",null,null,4,3]
[null,"Illinois",null,"Barbados",null,null,5,4]
[null,"Indiana",null,"Belarus",null,null,6,5]
[null,"Iowa",null,"Belgium",null,null,7,6]
[null,"Kansas",null,"Belize"]
[null,"Kentucky",null,"Benin"]
[null,"Louisiana",null,"Bhutan"]
[null,"Maine",null,"Bolivia"]
[null,"Maryland",null,"Bosnia Herzegovina"]
[null,"Massachusetts",null,"Botswana"]
[null,"Michigan",null,"Brazil"]
[null,"Minnesota",null,"Brunei"]
[null,"Mississippi",null,"Bulgaria"]
[null,"Missouri",null,"Burkina"]
[null,"Montana",null,"Burundi"]
[null,"Nebraska",null,"Cambodia"]
[null,"Nevada",null,"Cameroon"]
[null,"New Hampshire",null,"Canada"]
[null,"New Jersey",null,"Cape Verde"]
[null,"New Mexico",null,"Central African Rep"]
[null,"New York",null,"Chad"]
[null,"North Carolina",null,"Chile"]
[null,"North Dakota",null,"China"]
[null,"Ohio",null,"Colombia"]
[null,"Oklahoma",null,"Comoros"]
[null,"Oregon",null,"Congo"]
[null,"Pennsylvania",null,"Congo {Democratic Rep}"]
[null,"Rhode Island",null,"Costa Rica"]
[null,"South Carolina",null,"Croatia"]
[null,"South Dakota",null,"Cuba"]
[null,"Tennessee",null,"Cyprus"]
[null,"Texas",null,"Czech Republic"]
[null,"Utah",null,"Denmark"]
[null,"Vermont",null,"Djibouti"]
[null,"Virginia",null,"Dominica"]
[null,"Washington",null,"Dominican Republic"]
[null,"West Virginia",null,"East Timor"]
[null,"Wisconsin",null,"Ecuador"]
[null,"Wyoming",null,"Egypt"]
[null,"American Samoa",null,"El Salvador"]
[null,"Guam",null,"Equatorial Guinea"]
[null,"Northern Mariana Islands",null,"Eritrea"]
[null,"Puerto Rico",null,"Estonia"]
[null,"United States Virgin Islands",null,"Ethiopia"]
[null,"OUT OF COUNTRY",null,"Fiji"]
[{"$nulls":3},"Finland"]
[{"$nulls":3},"France"]
[{"$nulls":3},"Gabon"]
[{"$nulls":3},"Gambia"]
[{"$nulls":3},"Georgia"]
[{"$nulls":3},"Germany"]
[{"$nulls":3},"Ghana"]
[{"$nulls":3},"Greece"]
[{"$nulls":3},"Grenada"]
[{"$nulls":3},"Guatemala"]
[{"$nulls":3},"Guinea"]
[{"$nulls":3},"Guinea-Bissau"]
[{"$nulls":3},"Guyana"]
[{"$nulls":3},"Haiti"]
[{"$nulls":3},"Honduras"]
[{"$nulls":3},"Hungary"]
[{"$nulls":3},"Iceland"]
[{"$nulls":3},"India"]
[{"$nulls":3},"Indonesia"]
[{"$nulls":3},"Iran"]
[{"$nulls":3},"Iraq"]
[{"$nulls":3},"Ireland {Republic}"]
[{"$nulls":3},"Israel"]
[{"$nulls":3},"Italy"]
[{"$nulls":3},"Ivory Coast"]
[{"$nulls":3},"Jamaica"]
[{"$nulls":3},"Japan"]
[{"$nulls":3},"Jordan"]
[{"$nulls":3},"Kazakhstan"]
[{"$nulls":3},"Kenya"]
[{"$nulls":3},"Kiribati"]
[{"$nulls":3},"Korea North"]
[{"$nulls":3},"Korea South"]
[{"$nulls":3},"Kosovo"]
[{"$nulls":3},"Kuwait"]
[{"$nulls":3},"Kyrgyzstan"]
[{"$nulls":3},"Laos"]
[{"$nulls":3},"Latvia"]
[{"$nulls":3},"Lebanon"]
[{"$nulls":3},"Lesotho"]
[{"$nulls":3},"Liberia"]
[{"$nulls":3},"Libya"]
[{"$nulls":3},"Liechtenstein"]
[{"$nulls":3},"Lithuania"]
[{"$nulls":3},"Luxembourg"]
[{"$nulls":3},"Macedonia"]
[{"$nulls":3},"Madagascar"]
[{"$nulls":3},"Malawi"]
[{"$nulls":3},"Malaysia"]
[{"$nulls":3},"Maldives"]
[{"$nulls":3},"Mali"]
[{"$nulls":3},"Malta"]
[{"$nulls":3},"Marshall Islands"]
[{"$nulls":3},"Mauritania"]
[{"$nulls":3},"Mauritius"]
[{"$nulls":3},"Mexico"]
[{"$nulls":3},"Micronesia"]
[{"$nulls":3},"Moldova"]
[{"$nulls":3},"Monaco"]
[{"$nulls":3},"Mongolia"]
[{"$nulls":3},"Montenegro"]
[{"$nulls":3},"Morocco"]
[{"$nulls":3},"Mozambique"]
[{"$nulls":3},"Myanmar, {Burma}"]
[{"$nulls":3},"Namibia"]
[{"$nulls":3},"Nauru"]
[{"$nulls":3},"Nepal"]
[{"$nulls":3},"Netherlands"]
[{"$nulls":3},"New Zealand"]
[{"$nulls":3},"Nicaragua"]
[{"$nulls":3},"Niger"]
[{"$nulls":3},"Nigeria"]
[{"$nulls":3},"Norway"]
[{"$nulls":3},"Oman"]
[{"$nulls":3},"Pakistan"]
[{"$nulls":3},"Palau"]
[{"$nulls":3},"Panama"]
[{"$nulls":3},"Papua New Guinea"]
[{"$nulls":3},"Paraguay"]
[{"$nulls":3},"Peru"]
[{"$nulls":3},"Philippines"]
[{"$nulls":3},"Poland"]
[{"$nulls":3},"Portugal"]
[{"$nulls":3},"Qatar"]
[{"$nulls":3},"Romania"]
[{"$nulls":3},"Russian Federation"]
[{"$nulls":3},"Rwanda"]
[{"$nulls":3},"St Kitts & Nevis"]
[{"$nulls":3},"St Lucia"]
[{"$nulls":3},"Saint Vincent & the Grenadines"]
[{"$nulls":3},"Samoa"]
[{"$nulls":3},"San Marino"]
[{"$nulls":3},"Sao Tome & Principe"]
[{"$nulls":3},"Saudi Arabia"]
[{"$nulls":3},"Senegal"]
[{"$nulls":3},"Serbia"]
[{"$nulls":3},"Seychelles"]
[{"$nulls":3},"Sierra Leone"]
[{"$nulls":3},"Singapore"]
[{"$nulls":3},"Slovakia"]
[{"$nulls":3},"Slovenia"]
[{"$nulls":3},"Solomon Islands"]
[{"$nulls":3},"Somalia"]
[{"$nulls":3},"South Africa"]
[{"$nulls":3},"South Sudan"]
[{"$nulls":3},"Spain"]
[{"$nulls":3},"Sri Lanka"]
[{"$nulls":3},"Sudan"]
[{"$nulls":3},"Suriname"]
[{"$nulls":3},"Swaziland"]
[{"$nulls":3},"Sweden"]
[{"$nulls":3},"Switzerland"]
[{"$nulls":3},"Syria"]
[{"$nulls":3},"Taiwan"]
[{"$nulls":3},"Tajikistan"]
[{"$nulls":3},"Tanzania"]
[{"$nulls":3},"Thailand"]
[{"$nulls":3},"Togo"]
[{"$nulls":3},"Tonga"]
[{"$nulls":3},"Trinidad & Tobago"]
[{"$nulls":3},"Tunisia"]
[{"$nulls":3},"Turkey"]
[{"$nulls":3},"Turkmenistan"]
[{"$nulls":3},"Tuvalu"]
[{"$nulls":3},"Uganda"]
[{"$nulls":3},"Ukraine"]
[{"$nulls":3},"United Arab Emirates"]
[{"$nulls":3},"United Kingdom"]
[{"$nulls":3},"United States"]
[{"$nulls":3},"Uruguay"]
[{"$nulls":3},"Uzbekistan"]
[{"$nulls":3},"Vanuatu"]
[{"$nulls":3},"Vatican City"]
[{"$nulls":3},"Venezuela"]
[{"$nulls":3},"Vietnam"]
[{"$nulls":3},"Yemen"]
[{"$nulls":3},"Zambia"]
[{"$nulls":3},"Zimbabwe"]