{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Expense claim form","Rates","Mileage rates and intercampus ","Form amendments"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Expense claim form","index":0,"n_rows":101,"n_cols":59,"rows_kept":101,"cut":false,"hidden":false,"merged":[[53,4,53,7],[53,9,53,15],[52,17,52,25],[51,27,51,30],[51,32,51,35],[51,37,51,40],[41,10,41,20],[41,21,41,26],[41,27,41,37],[61,1,61,5],[57,12,57,16],[58,26,60,45],[61,26,61,30],[61,31,61,45],[63,11,63,24],[63,31,63,45],[70,1,70,45],[66,1,66,45],[67,1,67,45],[69,1,69,5],[69,6,69,19],[69,20,69,22],[62,26,62,30],[62,31,62,45],[63,26,63,30],[58,1,60,24],[61,6,61,24],[63,1,63,10],[69,37,69,45],[69,30,69,36],[69,23,69,29],[64,1,64,45],[68,1,68,36],[56,42,56,45],[56,27,56,41],[54,27,54,30],[54,32,54,35],[54,4,54,7],[54,9,54,15],[54,37,54,40],[54,42,54,45],[55,1,55,45],[54,17,54,25],[21,38,21,40],[21,42,21,45],[53,17,53,25],[53,27,53,30],[53,32,53,35],[53,37,53,40],[53,42,53,45],[51,42,51,45],[47,42,47,45],[48,27,48,30],[41,42,41,45],[41,38,41,41],[42,42,42,45],[43,1,43,21],[43,22,43,33],[43,42,43,45],[50,4,50,7],[50,27,50,30],[50,32,50,35],[50,37,50,40],[50,9,50,15],[51,4,51,7],[51,9,51,15],[51,17,51,25],[10,55,10,61],[52,42,52,45],[49,27,49,30],[49,32,49,35],[49,37,49,40],[49,42,49,45],[50,17,50,25],[48,17,48,25],[49,17,49,25],[52,27,52,30],[52,32,52,35],[52,37,52,40],[17,38,17,40],[17,42,17,45],[18,42,18,45],[42,1,42,33],[40,1,40,4],[40,42,40,45],[40,38,40,41],[49,4,49,7],[49,9,49,15],[43,34,43,41],[21,1,21,4],[50,42,50,45],[20,1,20,4],[20,5,20,29],[20,30,20,33],[20,34,20,37],[20,38,20,41],[20,42,20,45],[52,9,52,15],[52,4,52,7],[47,4,47,7],[47,9,47,15],[47,17,47,25],[47,27,47,30],[47,32,47,35],[47,37,47,40],[44,42,44,45],[45,42,45,45],[44,38,44,41],[44,32,44,37],[44,28,44,31],[44,1,44,27],[48,32,48,35],[21,5,21,29],[21,30,21,33],[21,34,21,36],[29,1,29,4],[39,1,39,4],[39,42,39,45],[39,38,39,41],[41,1,41,4],[30,1,30,4],[30,5,30,37],[30,38,30,41],[30,42,30,45],[31,1,31,4],[31,5,31,37],[31,38,31,41],[31,42,31,45],[32,1,32,4],[32,5,32,37],[32,38,32,41],[32,42,32,45],[33,1,33,4],[35,1,35,4],[35,5,35,37],[35,38,35,41],[41,5,41,9],[40,5,40,33],[39,5,39,37],[28,42,28,45],[23,42,23,45],[24,1,24,45],[25,1,25,9],[25,10,25,45],[26,1,26,4],[26,42,26,45],[23,34,23,41],[27,5,27,37],[28,5,28,37],[23,30,23,33],[27,1,27,4],[26,5,26,29],[26,38,26,41],[27,38,27,41],[23,23,23,29],[23,1,23,22],[1,1,1,45],[2,1,2,45],[4,20,4,22],[4,37,4,45],[8,1,8,5],[6,6,6,24],[6,37,6,45],[8,37,8,45],[6,31,6,36],[8,31,8,36],[4,1,4,5],[4,6,4,19],[3,39,3,45],[4,23,4,29],[4,30,4,36],[15,1,15,4],[15,5,15,29],[19,42,19,45],[8,6,10,24],[5,1,5,45],[6,1,6,5],[10,37,10,45],[10,31,10,36],[11,1,11,45],[12,1,12,18],[12,19,12,25],[12,26,12,37],[12,38,12,45],[15,30,15,33],[15,34,15,37],[15,38,15,41],[15,42,15,45],[16,42,16,45],[19,5,19,29],[19,30,19,33],[19,34,19,36],[19,38,19,40],[18,5,18,29],[18,30,18,33],[18,34,18,36],[18,38,18,40],[16,1,16,4],[16,5,16,29],[16,30,16,33],[16,34,16,36],[16,38,16,40],[19,1,19,4],[18,1,18,4],[17,1,17,4],[17,5,17,29],[17,30,17,33],[17,34,17,36],[22,42,22,45],[29,42,29,45],[29,38,29,41],[29,5,29,37],[48,4,48,7],[48,9,48,15],[45,1,45,41],[48,42,48,45],[48,37,48,40],[28,38,28,41],[22,1,22,4],[22,5,22,29],[22,30,22,33],[22,34,22,36],[22,38,22,40],[33,5,33,37],[33,38,33,41],[33,42,33,45],[34,1,34,4],[34,5,34,37],[34,38,34,41],[34,42,34,45],[27,42,27,45],[28,1,28,4],[71,1,71,45],[72,1,72,18],[72,19,72,25],[72,26,72,37],[72,38,72,45],[73,1,73,2],[73,3,73,11],[73,12,73,13],[73,14,73,23],[73,24,73,27],[73,28,73,33],[73,34,73,37],[73,38,73,41],[74,1,74,10],[74,11,74,13],[74,15,74,23],[74,24,74,26],[74,27,74,33],[74,34,74,45],[75,1,75,4],[75,5,75,29],[75,30,75,33],[75,34,75,37],[75,38,75,41],[75,42,75,45],[76,1,76,4],[76,5,76,29],[76,30,76,33],[76,34,76,36],[76,38,76,40],[76,42,76,45],[77,1,77,4],[77,5,77,29],[77,30,77,33],[77,34,77,36],[77,38,77,40],[77,42,77,45],[78,1,78,4],[78,5,78,29],[78,30,78,33],[78,34,78,36],[78,38,78,40],[78,42,78,45],[89,1,89,4],[89,5,89,29],[89,30,89,33],[89,34,89,36],[89,38,89,40],[89,42,89,45],[79,1,79,4],[79,5,79,29],[79,30,79,33],[79,34,79,36],[79,38,79,40],[79,42,79,45],[80,1,80,4],[80,5,80,29],[80,30,80,33],[80,34,80,36],[80,38,80,40],[80,42,80,45],[90,30,90,33],[90,34,90,37],[90,38,90,41],[90,42,90,45],[91,1,91,4],[91,5,91,29],[91,30,91,33],[91,34,91,36],[91,38,91,40],[91,42,91,45],[90,1,90,29],[94,1,94,4],[94,5,94,29],[94,30,94,33],[94,34,94,36],[94,38,94,40],[94,42,94,45],[95,22,95,29],[95,30,95,33],[95,34,95,41],[95,42,95,45],[81,1,81,4],[81,5,81,29],[81,30,81,33],[81,34,81,36],[81,38,81,40],[81,42,81,45],[82,1,82,4],[82,5,82,29],[82,30,82,33],[82,34,82,36],[82,38,82,40],[82,42,82,45],[83,1,83,4],[83,5,83,29],[83,30,83,33],[83,34,83,36],[83,38,83,40],[83,42,83,45],[84,1,84,4],[84,5,84,29],[84,30,84,33],[84,34,84,36],[84,38,84,40],[84,42,84,45],[88,34,88,36],[88,38,88,40],[88,42,88,45],[85,1,85,4],[85,5,85,29],[85,30,85,33],[85,34,85,36],[85,38,85,40],[85,42,85,45],[86,1,86,4],[86,5,86,29],[86,30,86,33],[86,34,86,36],[86,38,86,40],[86,42,86,45],[88,1,88,4],[88,5,88,29],[13,38,13,41],[13,34,13,37],[13,28,13,33],[13,24,13,27],[13,14,13,23],[13,12,13,13],[13,3,13,11],[13,1,13,2],[92,1,92,4],[92,5,92,29],[92,30,92,33],[92,34,92,36],[92,38,92,40],[36,1,36,4],[36,5,36,37],[36,38,36,41],[37,1,37,4],[37,5,37,37],[37,38,37,41],[38,1,38,4],[38,5,38,37],[38,38,38,41],[87,1,87,4],[87,5,87,29],[98,1,99,45],[101,1,103,45],[14,34,14,45],[14,27,14,33],[14,24,14,26],[14,15,14,23],[14,11,14,13],[14,1,14,10],[92,42,92,45],[93,1,93,4],[93,5,93,29],[35,42,35,45],[93,30,93,33],[93,34,93,36],[93,38,93,40],[93,42,93,45],[36,42,36,45],[37,42,37,45],[38,42,38,45],[87,30,87,33],[87,34,87,36],[87,38,87,40],[87,42,87,45],[88,30,88,33]]}
[]
[null,"MILEAGE AND EXPENSE CLAIM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engine size:","Petrol","LPG","Diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 - 1400 cc",11,7,9]
[null,null,null,{"$f":"IF(X5=\"student\",\"STUDENTS MUST MAKE SURE THAT THEIR BANK DETAILS ARE IN RISIS OR THIS CLAIM CANNOT BE PAID\",IF(X5=\"campus jobs employee\",\"CAMPUS JOBS EMPLOYEES MUST MAKE SURE THAT THEIR BANK DETAILS ARE IN RISIS OR THIS CLAIM CANNOT BE PAID\",\"\"))","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,"Version 2.36 Sept 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1401-1600 cc",14,9,9]
[null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a",null,null,null,null,null,null,null,null,null,{"$f":"IF(X5=\"member of staff\", \"Employee number :\",IF(OR(X5=\"student\",X5=\"campus jobs employee\"),\"Student Enrolment number:\",IF(X5=\"visitor\",\"National Insurance number:\",\"ID Number\")))","v":"ID Number"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1601-2000 cc",14,9,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"over 2000 cc",21,14,13]
[null,"E-Mail",null,null,null,null,null,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(X5=\"visitor\",\"Sort code/BIC\",\" \")","v":" "},null,null,null,null,null,{"$f":"IF(X5=\"member of staff\",\"For staff\",IF(X5=\"student\",\"For students\",IF(X5=\"campus jobs employee\",\"For campus jobs employees\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric",4,4,4]
[]
[null,"Address",null,null,null,null,null,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(X5=\"visitor\",\"Account code/IBAN\",\" \")","v":" "},null,null,null,null,null,{"$f":"IF(X5=\"member of staff\",\"your Trent\",IF(OR(X5=\"student\",X5=\"campus jobs employee\"),\"your RISIS\",\"\"))","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(X5=\"visitor\",\"Bldg society roll\",\" \")","v":" "},null,null,null,null,null,{"$f":"IF(OR(X5=\"visitor\",X5=0),\" \",\"bank details will be used\")","v":" "}]
[]
[null,"BUSINESS MILEAGE CLAIM "]
[null,"Make",null,null,null,null,null,null,null,null,null,null,"Model",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA13=\"Personal/ Not a UoR salary exchange car\",AA13=\"Motorcycle\"),\"Engine size\",\"*Engine size\")","v":"*Engine size"},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA13=\"Personal/ Not a UoR salary exchange car\",AA13=\"Motorcycle\"),\"Fuel type\",\"*Fuel type\")","v":"*Fuel type"}]
[null,"*Mileage claimed since 6 April up to last claim",null,null,null,null,null,null,null,null,null,1E-10,null,null,null,"Mileage since 6 April including this claim",null,null,null,null,null,null,null,null,{"$f":"L15+AE24","v":1E-10},null,null,"Calculate distance",null,null,null,null,null,null,"Allowable rates and intercampus distances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y15=0,0,IF(Y15>10000,\"Yes\", \"No\"))","v":"No"}]
[null,"DATE",null,null,null,"DETAILS OF JOURNEY; To, from, reason for travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND TRIP MILES",null,null,null,"Pence per first 70 miles",null,null,null,"Pence after first 70 miles",null,null,null,"AMOUNT £"]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD17,Rates,7,FALSE)),0,(VLOOKUP($BD17,Rates,7,FALSE)))","v":0},null,null,"p",{"$f":"IF(ISNA(VLOOKUP($BD17,Rates,8,FALSE)),0,(VLOOKUP($BD17,Rates,8,FALSE)))","v":0},null,null,"p",{"$f":"IF(AE17=0,0,IF(AE17<71,AE17*AI17/100,IF(AE17>70,70*(AI17/100)+(AE17-70)*AM17/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD18,Rates,7,FALSE)),0,(VLOOKUP($BD18,Rates,7,FALSE)))","v":0},null,null,"p",{"$f":"IF(ISNA(VLOOKUP($BD18,Rates,8,FALSE)),0,(VLOOKUP($BD18,Rates,8,FALSE)))","v":0},null,null,"p",{"$f":"IF(AE18=0,0,IF(AE18<71,AE18*AI18/100,IF(AE18>70,70*(AI18/100)+(AE18-70)*AM18/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD19,Rates,7,FALSE)),0,(VLOOKUP($BD19,Rates,7,FALSE)))","v":0},null,null,"p",{"$f":"IF(ISNA(VLOOKUP($BD19,Rates,8,FALSE)),0,(VLOOKUP($BD19,Rates,8,FALSE)))","v":0},null,null,"p",{"$f":"IF(AE19=0,0,IF(AE19<71,AE19*AI19/100,IF(AE19>70,70*(AI19/100)+(AE19-70)*AM19/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD20,Rates,7,FALSE)),0,(VLOOKUP($BD20,Rates,7,FALSE)))","v":0},null,null,"p",{"$f":"IF(ISNA(VLOOKUP($BD20,Rates,8,FALSE)),0,(VLOOKUP($BD20,Rates,8,FALSE)))","v":0},null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,null,null,null,null,"PASSENGER ALLOWANCE; Name of member of staff, Journey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," MILES Claimed for"]
[null,null,null,null,null,{"$f":"IF(AA13=\"Motorcycle\",\"Not available for motorcycle journeys\",\" \")","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,{"$f":"IF(OR(AE22=0,$AA$13=\"Motorcycle\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI22","v":0},null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,null,null,null,null,{"$f":"IF(AA13=\"Motorcycle\",\"Not available for motorcycle journeys\",\" \")","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,{"$f":"IF(OR(AE23=0,$AA$13=\"Motorcycle\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI23","v":0},null,null,"p",{"$f":"IF(AE23=0,0,IF(AE23<71,AE23*AI23/100,IF(AE23>70,70*(AI23/100)+(AE23-70)*AM23/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$13,$AC$14,$AM$14,$BD$15)","v":"No"}]
[null,"Full details of all journeys to be given on page 2 and appended to this claim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miles travelled this claim, from page 2",null,null,null,null,null,null,{"$f":"AE96","v":0},null,null,null,"Mileage claim from page 2",null,null,null,null,null,null,null,{"$f":"AQ96","v":0}]
[]
[null,"EXPENSE CLAIM",null,null,null,null,null,null,null,null,"FOR TRAVEL, SUBSISTENCE, ACCOMMODATION, PARKING, PETROL FOR HIRE CARS ETC."]
[null,"DATE",null,null,null,"DETAILS OF EXPENSE; Event, Location,Type, Reason for expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voucher ",null,null,null,"AMOUNT £"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,"In the event of query with the completed form, who should finance contact?"]
[null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone"]
[null,"If you are claiming subsistence for day trips, please tick this box to confirm that each trip lasted more than 10 hours.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expense claim",{"$f":"SUM(AQ28:AT42)","v":0}]
[null,null,null,null,null,null,null,null,null,null,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 and expenses",null,null,null,null,null,null,null,{"$f":"AQ24+AQ43","v":0}]
[null,"This claim relates to an advance of expenses amounting to ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"received by me on",null,null,null,null,null,null,null,null,null,{"$f":"AC45","v":0}]
[null,{"$f":"IF(AQ44>AQ45,\"Please reimburse me\",IF(AQ45>AQ44,\"I enclose a cheque made out to The University of Reading for\",\"Amount to be paid by BACS transfer\"))","v":"Amount to be paid by BACS transfer"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AQ45>AQ44,AQ45-AQ44,AQ44-AQ45)","v":0}]
[]
[null,null,null,null,"Account",null,null,null,null,"Project",null,null,null,null,null,null,null,"Wren/Other",null,null,null,null,null,null,null,null,null,"VAT code",null,null,null,null,"Net",null,null,null,null,"VAT",null,null,null,null,"Gross"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AG49+AL49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ44=AQ57,\" \",\"Please complete the accounting analysis\")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ49:AT55)","v":0}]
[null,"DECLARATION - Claimant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DECLARATION - Head of School/Service or approved nominee"]
[null,"I certify that the expenses detailed on this claim have been actually and necessarily incurred by me on the business of the University and are in accordance with the Financial Regulations and the policies on Travel, Other Expenses, Benefits, Hospitality and Gifts.  Any mileage allowance is claimed in respect of a vehicle for which the necessary insurance requirements are met. I agree that any discrepancies will be reimbursed by salary deduction.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I have checked the supporting documentation of the items claimed and find them to be in accordance with the Financial Regulations and the policies on Travel, Other Expenses, Benefits, Hospitality and Gifts."]
[]
[]
[null,"Claimant's signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of authorisor:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print name"]
[null,"Research Supervisor or grant/contract holder's signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE AUTHORISED:"]
[null,"The claimant must attach RECEIPTS FOR ALL ITEMS CLAIMED (AND PAGE 2 IF USED) and sign the form. Completed forms must be correctly authorised and sent to        Accounts Payable, Room 100, Whiteknights House, Whiteknights. Unauthorised and incorrectly completed forms will be returned and may delay payment of the claim."]
[]
[null,"Page 2 - Details of mileage claims",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engine size:","Petrol","LPG","Diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0 - 1400 cc",11,7,9]
[null,"The vehicle used, engine size and fuel type fields must be completed before the pence per mile field is populated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN4","v":"Version 2.36 Sept 2023"},null,null,null,null,null,null,null,null,null,"1401-1600 cc",14,9,9]
[null,"Name",null,null,null,null,{"$f":"IF(G5=\"\",\"\",G5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a",null,null,{"$f":"IF(X5=\"\",\"\",X5)","v":""},null,null,null,null,null,null,{"$f":"IF(X70=\"member of staff\", \"Employee number :\",IF(X70=\"student\",\"Student Enrolment number:\",IF(X70=\"visitor\",\"National Insurance number:\",\"ID Number\")))","v":"ID Number"},null,null,null,null,null,null,{"$f":"IF(AL5=\"\",\"\",AL5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1601-2000 cc",14,9,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"over 2000 cc",21,14,13]
[]
[null,"BUSINESS MILEAGE CLAIM ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*VEHICLE USED",null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car",null,null,null,null,null,null,null,null,null,null,null,"* mandatory"]
[null,"Make",null,null,null,null,null,null,null,null,null,null,"Model",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA73=\"Personal/ Not a UoR salary exchange car\",AA73=\"Motorcycle\"),\"Engine size\",\"*Engine size\")","v":"Engine size"},null,null,null,"0 - 1400 cc",null,null,null,null,null,{"$f":"IF(OR(AA73=\"Personal/ Not a UoR salary exchange car\",AA73=\"Motorcycle\"),\"Fuel type\",\"*Fuel type\")","v":"Fuel type"},null,null,null,"Diesel"]
[null,"*Mileage claimed since 6 April up to last claim",null,null,null,null,null,null,null,null,null,0,null,null,null,"Mileage since 6 April including this claim",null,null,null,null,null,null,null,null,{"$f":"L75+AE96","v":0},null,null,"Calculate distance",null,null,null,null,null,null,"Allowable rates and intercampus distances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y75=0,0,IF(Y75>10000,\"Yes\", \"No\"))","v":0}]
[null,"DATE",null,null,null,"DETAILS OF JOURNEY; To, from, reason for travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND TRIP MILES",null,null,null,"Pence per first 70 miles",null,null,null,"Pence after first 70 miles",null,null,null,"AMOUNT £"]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD77,Rates,7,FALSE)),0,(VLOOKUP($BD77,Rates,7,FALSE)))","v":0},null,null,"p",{"$f":"IF(ISNA(VLOOKUP($BD77,Rates,8,FALSE)),0,(VLOOKUP($BD77,Rates,8,FALSE)))","v":0},null,null,"p",{"$f":"IF(AE77=0,0,IF(AE77<71,AE77*AI77/100,IF(AE77>70,70*(AI77/100)+(AE77-70)*AM77/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$73,$AC$74,$AM$74,$BD$75)","v":"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"}]
[null,null,null,null,null,null,null,null,null,null,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(ISNA(VLOOKUP($BD78,Rates,7,FALSE)),0,(VLOOKUP($BD78,Rates,7,FALSE)))","v":0},null,null,"p",0,null,null,"p",{"$f":"IF(AE78=0,0,IF(AE78<71,AE78*AI78/100,IF(AE78>70,70*(AI78/100)+(AE78-70)*AM78/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AA$73,$AC$74,$AM$74,$BD$75)","v":"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"},null,null,"           "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",{"$f":"IF(AE79=0,0,IF(AE79<71,AE79*AI79/100,IF(AE79>70,70*(AI79/100)+(AE79-70)*AM79/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",{"$f":"IF(AE80=0,0,IF(AE80<71,AE80*AI80/100,IF(AE80>70,70*(AI80/100)+(AE80-70)*AM80/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"p",0,null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,"PASSENGER ALLOWANCE; Name of member of staff, Journey",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," MILES Claimed for"]
[null,null,null,null,null,{"$f":"IF($AA$73=\"Motorcycle\",\"Not available for motorcycle journeys\",IF(OR($AC$74=\"Electric\",$AM$74=\"Electric\"),\"Not available for electric cars\",\" \"))","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,{"$f":"IF(OR(AE92=0,$AA$73=\"Motorcycle\",$AC$74=\"Electric\",$AM$74=\"Electric\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI92","v":0},null,null,"p",{"$f":"IF(AE92=0,0,IF(AE92<71,AE92*AI92/100,IF(AE92>70,70*(AI92/100)+(AE92-70)*AM92/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,{"$f":"IF($AA$73=\"Motorcycle\",\"Not available for motorcycle journeys\",IF(OR($AC$74=\"Electric\",$AM$74=\"Electric\"),\"Not available for electric cars\",\" \"))","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,{"$f":"IF(OR(AE93=0,$AA$73=\"Motorcycle\",$AC$74=\"Electric\",$AM$74=\"Electric\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI93","v":0},null,null,"p",{"$f":"IF(AE93=0,0,IF(AE93<71,AE93*AI93/100,IF(AE93>70,70*(AI93/100)+(AE93-70)*AM93/100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null," ",null,null,null,null,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(OR(AE94=0,$AA$73=\"Motorcycle\",$AC$74=\"Electric\",$AM$74=\"Electric\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI94","v":0},null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null," ",null,null,null,null,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(OR(AE95=0,$AA$73=\"Motorcycle\",$AC$74=\"Electric\",$AM$74=\"Electric\"),0,'Mileage rates and intercampus '!$E$20)","v":0},null,null,"p",{"$f":"AI95","v":0},null,null,"p",0,null,null,null,null,null,null,null,null,null,null,null,null,"Personal/ Not a UoR salary exchange car0 - 1400 ccDiesel0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miles travelled this claim",null,null,null,null,null,null,null,{"$f":"SUM(AE77:AH90)","v":0},null,null,null,"Mileage claim",null,null,null,null,null,null,null,{"$f":"SUM(AQ77:AT95)","v":0}]
[]
[null,"Identifying text or reference for Agresso - maximum 50 characters"]
[]
[]
[null,"Additional notes - to allow the authorisor and Finance to better understand your claim"]

{"sheet":"Rates","index":1,"n_rows":107,"n_cols":20,"rows_kept":107,"cut":false,"hidden":true,"merged":[[17,12,17,13],[17,10,17,11],[1,1,1,3],[1,4,1,6],[1,7,1,9],[0,1,0,9],[0,11,0,19],[1,11,1,13],[1,14,1,16],[1,17,1,19]]}
["Schedule of Rates","Up to 70 miles",null,null,null,null,null,null,null,null,null,"Over 70 miles"]
["Rates for Under 10,000 claimed in tax year","UoR salary exchange vehicle",null,null,"Personal/ Not a UoR salary exchange vehicle",null,null,"Motorcycle",null,null,null,"UoR salary exchange vehicle",null,null,"Personal/ Not a UoR salary exchange vehicle",null,null,"Motorcycle"]
["Engine size:","Petrol","LPG","Diesel","Petrol","LPG","Diesel","Petrol","LPG","Diesel",null,"Petrol","LPG","Diesel","Petrol","LPG","Diesel","Petrol","LPG","Diesel"]
["0 - 1400 cc",14,9,13,45,45,45,24,24,24,null,{"$f":"B4","v":14},{"$f":"C4","v":9},{"$f":"D4","v":13},25,25,25,15,15,15]
["1401-1600 cc",17,11,13,45,45,45,24,24,24,null,{"$f":"B5","v":17},{"$f":"C5","v":11},{"$f":"D5","v":13},25,25,25,15,15,15]
["1601-2000 cc",17,11,16,45,45,45,24,24,24,null,{"$f":"B6","v":17},11,16,25,25,25,15,15,15]
["over 2000 cc",25,16,19,45,45,45,24,24,24,null,{"$f":"B7","v":25},16,19,25,25,25,15,15,15]
[]
["Rates for over 10,000 claimed in the tax year"]
["0 - 1400 cc",{"$f":"B4","v":14},{"$f":"C4","v":9},13,25,25,25,{"$f":"H4","v":24},{"$f":"I4","v":24},24,null,{"$f":"L4","v":14},{"$f":"M4","v":9},13,{"$f":"O4","v":25},{"$f":"P4","v":25},25,{"$f":"R4","v":15},{"$f":"S4","v":15},15]
["1401-1600 cc",{"$f":"B5","v":17},11,13,25,25,25,{"$f":"H5","v":24},24,24,null,{"$f":"L5","v":17},11,13,25,25,25,{"$f":"R5","v":15},15,15]
["1601-2000 cc",{"$f":"B6","v":17},11,16,25,25,25,{"$f":"H6","v":24},24,24,null,{"$f":"L6","v":17},11,16,25,25,25,{"$f":"R6","v":15},15,15]
["over 2000 cc",{"$f":"B7","v":25},16,19,25,25,25,{"$f":"H7","v":24},24,24,null,{"$f":"L7","v":25},16,19,25,25,25,{"$f":"R7","v":15},15,15]
[]
["Electric",4]
[]
[]
["All possible combinations allowable by the expense claim - do not amend below this line"]
["Vehicle","Engine","Fuel","Over 10k miles?","Concatenated",null,null,null,null,null,"up to 70 miles","Over 70 miles"]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","Petrol","No",{"$f":"CONCATENATE(A20,B20,C20,D20)","v":"Personal/ Not a UoR salary exchange car0 - 1400 ccPetrolNo"},null,null,null,null,null,{"$f":"E4","v":45},{"$f":"O4","v":25}]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","LPG","No",{"$f":"CONCATENATE(A21,B21,C21,D21)","v":"Personal/ Not a UoR salary exchange car0 - 1400 ccLPGNo"},null,null,null,null,null,{"$f":"F4","v":45},{"$f":"P4","v":25}]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","Diesel","No","Personal/ Not a UoR salary exchange car0 - 1400 ccDieselNo",null,null,null,null,null,{"$f":"G4","v":45},{"$f":"Q4","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","Petrol","No","Personal/ Not a UoR salary exchange car1401-1600 ccPetrolNo",null,null,null,null,null,{"$f":"E5","v":45},{"$f":"O5","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","LPG","No","Personal/ Not a UoR salary exchange car1401-1600 ccLPGNo",null,null,null,null,null,{"$f":"F5","v":45},{"$f":"P5","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","Diesel","No","Personal/ Not a UoR salary exchange car1401-1600 ccDieselNo",null,null,null,null,null,{"$f":"G5","v":45},{"$f":"Q5","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","Petrol","No","Personal/ Not a UoR salary exchange car1601-2000 ccPetrolNo",null,null,null,null,null,{"$f":"E6","v":45},{"$f":"O6","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","LPG","No","Personal/ Not a UoR salary exchange car1601-2000 ccLPGNo",null,null,null,null,null,{"$f":"F6","v":45},{"$f":"P6","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","Diesel","No","Personal/ Not a UoR salary exchange car1601-2000 ccDieselNo",null,null,null,null,null,{"$f":"G6","v":45},{"$f":"Q6","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","Petrol","No","Personal/ Not a UoR salary exchange carover 2000 ccPetrolNo",null,null,null,null,null,{"$f":"E7","v":45},{"$f":"O7","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","LPG","No","Personal/ Not a UoR salary exchange carover 2000 ccLPGNo",null,null,null,null,null,{"$f":"F6","v":45},{"$f":"P7","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","Diesel","No","Personal/ Not a UoR salary exchange carover 2000 ccDieselNo",null,null,null,null,null,{"$f":"G6","v":45},{"$f":"Q7","v":25}]
["Personal/ Not a UoR salary exchange car","Electric","Electric","No","Personal/ Not a UoR salary exchange carElectricElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car","Electric",null,"No","Personal/ Not a UoR salary exchange carElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car",null,"Electric","No","Personal/ Not a UoR salary exchange carElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car",null,null,"No","Personal/ Not a UoR salary exchange carNo",null,null,null,null,null,{"$f":"K20","v":45},{"$f":"L20","v":25},"inserted to allow for non mandatory engine size  and fuel type cells on the form"]
["UoR salary exchange car","0 - 1400 cc","Petrol","No","UoR salary exchange car0 - 1400 ccPetrolNo",null,null,null,null,null,{"$f":"B4","v":14},{"$f":"L4","v":14}]
["UoR salary exchange car","0 - 1400 cc","LPG","No","UoR salary exchange car0 - 1400 ccLPGNo",null,null,null,null,null,{"$f":"C4","v":9},{"$f":"M4","v":9}]
["UoR salary exchange car","0 - 1400 cc","Diesel","No","UoR salary exchange car0 - 1400 ccDieselNo",null,null,null,null,null,{"$f":"D4","v":13},{"$f":"N4","v":13}]
["UoR salary exchange car","1401-1600 cc","Petrol","No","UoR salary exchange car1401-1600 ccPetrolNo",null,null,null,null,null,{"$f":"B5","v":17},{"$f":"L5","v":17}]
["UoR salary exchange car","1401-1600 cc","LPG","No","UoR salary exchange car1401-1600 ccLPGNo",null,null,null,null,null,{"$f":"C5","v":11},{"$f":"M5","v":11}]
["UoR salary exchange car","1401-1600 cc","Diesel","No","UoR salary exchange car1401-1600 ccDieselNo",null,null,null,null,null,{"$f":"D5","v":13},{"$f":"N5","v":13}]
["UoR salary exchange car","1601-2000 cc","Petrol","No","UoR salary exchange car1601-2000 ccPetrolNo",null,null,null,null,null,{"$f":"B6","v":17},{"$f":"L6","v":17}]
["UoR salary exchange car","1601-2000 cc","LPG","No","UoR salary exchange car1601-2000 ccLPGNo",null,null,null,null,null,{"$f":"C6","v":11},{"$f":"M6","v":11}]
["UoR salary exchange car","1601-2000 cc","Diesel","No","UoR salary exchange car1601-2000 ccDieselNo",null,null,null,null,null,{"$f":"D6","v":16},{"$f":"N6","v":16}]
["UoR salary exchange car","over 2000 cc","Petrol","No","UoR salary exchange carover 2000 ccPetrolNo",null,null,null,null,null,{"$f":"B7","v":25},{"$f":"L7","v":25}]
["UoR salary exchange car","over 2000 cc","LPG","No","UoR salary exchange carover 2000 ccLPGNo",null,null,null,null,null,{"$f":"C7","v":16},{"$f":"M7","v":16}]
["UoR salary exchange car","over 2000 cc","Diesel","No","UoR salary exchange carover 2000 ccDieselNo",null,null,null,null,null,{"$f":"D7","v":19},{"$f":"N7","v":19}]
["UoR salary exchange car","Electric","Electric","No","UoR salary exchange carElectricElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["UoR salary exchange car","Electric",null,"No","UoR salary exchange carElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["UoR salary exchange car",null,"Electric","No","UoR salary exchange carElectricNo",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Motorcycle","0 - 1400 cc","Petrol","No","Motorcycle0 - 1400 ccPetrolNo",null,null,null,null,null,{"$f":"H4","v":24},{"$f":"R4","v":15}]
["Motorcycle","0 - 1400 cc","LPG","No","Motorcycle0 - 1400 ccLPGNo",null,null,null,null,null,{"$f":"I4","v":24},{"$f":"S4","v":15}]
["Motorcycle","0 - 1400 cc","Diesel","No","Motorcycle0 - 1400 ccDieselNo",null,null,null,null,null,{"$f":"J4","v":24},{"$f":"T4","v":15}]
["Motorcycle","1401-1600 cc","Petrol","No","Motorcycle1401-1600 ccPetrolNo",null,null,null,null,null,{"$f":"H5","v":24},{"$f":"R5","v":15}]
["Motorcycle","1401-1600 cc","LPG","No","Motorcycle1401-1600 ccLPGNo",null,null,null,null,null,{"$f":"I5","v":24},{"$f":"S5","v":15}]
["Motorcycle","1401-1600 cc","Diesel","No","Motorcycle1401-1600 ccDieselNo",null,null,null,null,null,{"$f":"J5","v":24},{"$f":"T5","v":15}]
["Motorcycle","1601-2000 cc","Petrol","No","Motorcycle1601-2000 ccPetrolNo",null,null,null,null,null,{"$f":"H6","v":24},{"$f":"R6","v":15}]
["Motorcycle","1601-2000 cc","LPG","No","Motorcycle1601-2000 ccLPGNo",null,null,null,null,null,{"$f":"I6","v":24},{"$f":"S6","v":15}]
["Motorcycle","1601-2000 cc","Diesel","No","Motorcycle1601-2000 ccDieselNo",null,null,null,null,null,{"$f":"J6","v":24},{"$f":"T6","v":15}]
["Motorcycle","over 2000 cc","Petrol","No","Motorcycleover 2000 ccPetrolNo",null,null,null,null,null,{"$f":"H7","v":24},{"$f":"R7","v":15}]
["Motorcycle","over 2000 cc","LPG","No","Motorcycleover 2000 ccLPGNo",null,null,null,null,null,{"$f":"I7","v":24},{"$f":"S7","v":15}]
["Motorcycle","over 2000 cc","Diesel","No","Motorcycleover 2000 ccDieselNo",null,null,null,null,null,{"$f":"J7","v":24},{"$f":"T7","v":15}]
["Motorcycle",null,null,"No","MotorcycleNo",null,null,null,null,null,{"$f":"K51","v":24},{"$f":"L51","v":15},"inserted to allow for non mandatory engine size  and fuel type cells on the form"]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","Petrol","Yes","Personal/ Not a UoR salary exchange car0 - 1400 ccPetrolYes",null,null,null,null,null,{"$f":"E10","v":25},{"$f":"O10","v":25}]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","LPG","Yes","Personal/ Not a UoR salary exchange car0 - 1400 ccLPGYes",null,null,null,null,null,{"$f":"F10","v":25},{"$f":"P10","v":25}]
["Personal/ Not a UoR salary exchange car","0 - 1400 cc","Diesel","Yes","Personal/ Not a UoR salary exchange car0 - 1400 ccDieselYes",null,null,null,null,null,{"$f":"G10","v":25},{"$f":"Q10","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","Petrol","Yes","Personal/ Not a UoR salary exchange car1401-1600 ccPetrolYes",null,null,null,null,null,{"$f":"E11","v":25},{"$f":"O11","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","LPG","Yes","Personal/ Not a UoR salary exchange car1401-1600 ccLPGYes",null,null,null,null,null,{"$f":"F11","v":25},{"$f":"P11","v":25}]
["Personal/ Not a UoR salary exchange car","1401-1600 cc","Diesel","Yes","Personal/ Not a UoR salary exchange car1401-1600 ccDieselYes",null,null,null,null,null,{"$f":"G11","v":25},{"$f":"Q11","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","Petrol","Yes","Personal/ Not a UoR salary exchange car1601-2000 ccPetrolYes",null,null,null,null,null,{"$f":"E12","v":25},{"$f":"O12","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","LPG","Yes","Personal/ Not a UoR salary exchange car1601-2000 ccLPGYes",null,null,null,null,null,{"$f":"F12","v":25},{"$f":"P12","v":25}]
["Personal/ Not a UoR salary exchange car","1601-2000 cc","Diesel","Yes","Personal/ Not a UoR salary exchange car1601-2000 ccDieselYes",null,null,null,null,null,{"$f":"G12","v":25},{"$f":"Q12","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","Petrol","Yes","Personal/ Not a UoR salary exchange carover 2000 ccPetrolYes",null,null,null,null,null,{"$f":"E13","v":25},{"$f":"O13","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","LPG","Yes","Personal/ Not a UoR salary exchange carover 2000 ccLPGYes",null,null,null,null,null,{"$f":"F13","v":25},{"$f":"P13","v":25}]
["Personal/ Not a UoR salary exchange car","over 2000 cc","Diesel","Yes","Personal/ Not a UoR salary exchange carover 2000 ccDieselYes",null,null,null,null,null,{"$f":"G13","v":25},{"$f":"Q13","v":25}]
["Personal/ Not a UoR salary exchange car","Electric","Electric","Yes",{"$f":"CONCATENATE(A76,B76,C76,D76)","v":"Personal/ Not a UoR salary exchange carElectricElectricYes"},null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car","Electric",null,"Yes","Personal/ Not a UoR salary exchange carElectricYes",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car",null,"Electric","Yes","Personal/ Not a UoR salary exchange carElectricYes",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Personal/ Not a UoR salary exchange car",null,null,"Yes","Personal/ Not a UoR salary exchange carYes",null,null,null,null,null,{"$f":"K64","v":25},{"$f":"L64","v":25},"inserted to allow for non mandatory engine size  and fuel type cells on the form"]
["UoR salary exchange car","0 - 1400 cc","Petrol","Yes","UoR salary exchange car0 - 1400 ccPetrolYes",null,null,null,null,null,{"$f":"B10","v":14},{"$f":"L10","v":14}]
["UoR salary exchange car","0 - 1400 cc","LPG","Yes","UoR salary exchange car0 - 1400 ccLPGYes",null,null,null,null,null,{"$f":"C10","v":9},{"$f":"M10","v":9}]
["UoR salary exchange car","0 - 1400 cc","Diesel","Yes","UoR salary exchange car0 - 1400 ccDieselYes",null,null,null,null,null,{"$f":"D10","v":13},{"$f":"N10","v":13}]
["UoR salary exchange car","1401-1600 cc","Petrol","Yes","UoR salary exchange car1401-1600 ccPetrolYes",null,null,null,null,null,{"$f":"B11","v":17},{"$f":"L11","v":17}]
["UoR salary exchange car","1401-1600 cc","LPG","Yes","UoR salary exchange car1401-1600 ccLPGYes",null,null,null,null,null,{"$f":"C11","v":11},{"$f":"M11","v":11}]
["UoR salary exchange car","1401-1600 cc","Diesel","Yes","UoR salary exchange car1401-1600 ccDieselYes",null,null,null,null,null,{"$f":"D11","v":13},{"$f":"N11","v":13}]
["UoR salary exchange car","1601-2000 cc","Petrol","Yes","UoR salary exchange car1601-2000 ccPetrolYes",null,null,null,null,null,{"$f":"B12","v":17},{"$f":"L12","v":17}]
["UoR salary exchange car","1601-2000 cc","LPG","Yes","UoR salary exchange car1601-2000 ccLPGYes",null,null,null,null,null,{"$f":"C12","v":11},{"$f":"M12","v":11}]
["UoR salary exchange car","1601-2000 cc","Diesel","Yes","UoR salary exchange car1601-2000 ccDieselYes",null,null,null,null,null,{"$f":"D12","v":16},{"$f":"N12","v":16}]
["UoR salary exchange car","over 2000 cc","Petrol","Yes","UoR salary exchange carover 2000 ccPetrolYes",null,null,null,null,null,{"$f":"B13","v":25},{"$f":"L13","v":25}]
["UoR salary exchange car","over 2000 cc","LPG","Yes","UoR salary exchange carover 2000 ccLPGYes",null,null,null,null,null,{"$f":"C13","v":16},{"$f":"M13","v":16}]
["UoR salary exchange car","over 2000 cc","Diesel","Yes","UoR salary exchange carover 2000 ccDieselYes",null,null,null,null,null,{"$f":"D13","v":19},{"$f":"N13","v":19}]
["UoR salary exchange car","Electric","Electric","Yes",{"$f":"CONCATENATE(A92,B92,C92,D92)","v":"UoR salary exchange carElectricElectricYes"},null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["UoR salary exchange car","Electric",null,"Yes","UoR salary exchange carElectricYes",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["UoR salary exchange car",null,"Electric","Yes","UoR salary exchange carElectricYes",null,null,null,null,null,{"$f":"B15","v":4},{"$f":"B15","v":4}]
["Motorcycle","0 - 1400 cc","Petrol","Yes","Motorcycle0 - 1400 ccPetrolYes",null,null,null,null,null,{"$f":"H10","v":24},{"$f":"R10","v":15}]
["Motorcycle","0 - 1400 cc","LPG","Yes","Motorcycle0 - 1400 ccLPGYes",null,null,null,null,null,{"$f":"I10","v":24},{"$f":"S10","v":15}]
["Motorcycle","0 - 1400 cc","Diesel","Yes","Motorcycle0 - 1400 ccDieselYes",null,null,null,null,null,{"$f":"J10","v":24},{"$f":"T10","v":15}]
["Motorcycle","1401-1600 cc","Petrol","Yes","Motorcycle1401-1600 ccPetrolYes",null,null,null,null,null,{"$f":"H11","v":24},{"$f":"R11","v":15}]
["Motorcycle","1401-1600 cc","LPG","Yes","Motorcycle1401-1600 ccLPGYes",null,null,null,null,null,{"$f":"I11","v":24},{"$f":"S11","v":15}]
["Motorcycle","1401-1600 cc","Diesel","Yes",{"$f":"CONCATENATE(A100,B100,C100,D100)","v":"Motorcycle1401-1600 ccDieselYes"},null,null,null,null,null,{"$f":"J11","v":24},{"$f":"T11","v":15}]
["Motorcycle","1601-2000 cc","Petrol","Yes","Motorcycle1601-2000 ccPetrolYes",null,null,null,null,null,{"$f":"H12","v":24},{"$f":"R12","v":15}]
["Motorcycle","1601-2000 cc","LPG","Yes","Motorcycle1601-2000 ccLPGYes",null,null,null,null,null,{"$f":"I12","v":24},{"$f":"S12","v":15}]
["Motorcycle","1601-2000 cc","Diesel","Yes","Motorcycle1601-2000 ccDieselYes",null,null,null,null,null,{"$f":"J12","v":24},{"$f":"T12","v":15}]
["Motorcycle","over 2000 cc","Petrol","Yes","Motorcycleover 2000 ccPetrolYes",null,null,null,null,null,{"$f":"H13","v":24},{"$f":"R13","v":15}]
["Motorcycle","over 2000 cc","LPG","Yes","Motorcycleover 2000 ccLPGYes",null,null,null,null,null,{"$f":"I13","v":24},{"$f":"S13","v":15}]
["Motorcycle","over 2000 cc","Diesel","Yes","Motorcycleover 2000 ccDieselYes",null,null,null,null,null,{"$f":"J13","v":24},{"$f":"T13","v":15}]
["Motorcycle",null,null,"Yes","MotorcycleYes",null,null,null,null,null,{"$f":"K95","v":24},{"$f":"L95","v":15},"inserted to allow for non mandatory engine size  and fuel type cells on the form"]

{"sheet":"Mileage rates and intercampus ","index":2,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,14,0,21],[1,14,1,20]]}
["Mileage rates for personal/non UoR salary exchange cars",null,null,null,null,null,null,null,null,null,null,null,null,null,"I would like to claim passenger allowances for the following persons who accompanied me for business purposes"]
[null,null,null,null,"UK","UK","UK","Finland","Germany",null,null,null,null,null,"(these must be employees who are normally eligible to claim expenses from the University)"]
[null,null,null,null,"pence","pence","pence","cents","cents"]
[]
["Car/Van","up to 10,000 miles",null,"first 70 miles of a return journey",45,null,null,45,30]
[null,null,null,"remaining miles of that journey",15,null,null,15,10]
[null,"over 10,000 miles",null,"first 70 miles of a return journey",25,null,null,45,30]
[null,null,null,"remaining miles of that journey",15,null,null,15,10]
["Motorcycle",null,null,"first 70 miles of a return journey",24,null,null,33,"nil"]
[null,null,null,"remaining miles of that journey",15,null,null,20,"nil"]
[]
["Mileage rates for UoR salary exchange cars"]
[]
[null,null,null,"Engine size:","Petrol","LPG","Diesel"]
[null,null,null,"0 - 1400 cc",12,8,10]
[null,null,null,"1401-1600 cc",14,10,10]
[null,null,null,"1601-2000 cc",14,10,13]
[null,null,null,"over 2000 cc",22,14,14]
[]
["Passenger allowance",null,null,null,5]
["available in respect of employees who have accompanied you and who can normally claim expenses from the University"]
[]
["Fixed claimable distances between campuses (UK only)",null,null,null,"miles"]
["From any Reading campus to another Reading campus",null,null,null,1]
["Between any Reading campus and the Henley campus",null,null,null,12]
["Between any Reading campus and the Centre for Dairy Research (CEDAR)",null,null,null,4]
["Between any Reading campus and Sonning Farm",null,null,null,4]
["Between CEDAR and Sonning Farm",null,null,null,8]
["Between Whiteknights campus and Worton Grange",null,null,null,4]
["Between any Reading campus and TVSP-Shinfield",null,null,null,3]
[]
["The mileage applies regardless of the direction of the journey."]

{"sheet":"Form amendments","index":3,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Version"]
["1.0","Original form"]
["1.1","Format account field for number with no decimal places"]
[null,"Format sort code field to custom 99-99-99"]
[null,"Change text in bank account section for staff and students"]
[null,"change Whitekigts to Whiteknights"]
["1.2","Format bank account/IBAN field to text (from numeric) to deal with IBANs starting with a zero"]
["1.3","Format Building society roll field to text to deal with roll numbers starting with a zero"]
["1.4","New leased car mileage rates from 1 Sept 2014"]
["2.0","Additional wording on mileage sheet","2014-10-01"]
["2.1","Larger, purple, print buttons","2014-10-01"]
["2.2","Move print buttons as they were covering \"Bldg society roll\" text for visitors","2014-11-01"]
["2.3","New leased car mileage rates from 1 Dec 2014","2014-12-04"]
["2.4","New leased car mileage rates from 1 Mar 2015","2015-03-01"]
["2.5","New leased car mileage rates from 1 Apr 2015","2015-04-01"]
["2.6","Ticket box for over 10 hours","2015-04-01"]
["2.7","New leased car mileage rates from 1 June 2015","2015-06-01"]
["2.8","New leased car mileage rates from 1 September 2015","2015-09-01"]
["2.9","New leased car mileage rates from 1 December 2015","2015-12-01"]
[null,"Fix issue with IBAN field","2015-12-02"]
["2.10","New leased car mileage rates from 1 March 2016","2016-03-01"]
["2.11","New leased car mileage rates from 1 June 2016","2016-06-01"]
["2.19","Campus jobs option added to \"I am a\" dropdown. Mileage rates sheet - added Any Reading campus to TVSP = 3 miles.","2018-03-01"]
["2.22","New leased car mileage rates from 1 March 2019","2019-03-01"]
["2.22","Add electric cars at 4p a mile","2019-03-01"]
["2.22","Change default print area to be both pages, not page 2 for people where the macros do not work","2019-04-29"]