{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Claim","Workings","personal claim record"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":5,"comments":1,"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":"Claim","index":0,"n_rows":60,"n_cols":22,"rows_kept":60,"cut":false,"hidden":false,"merged":[[15,1,15,4],[9,8,9,13],[50,9,50,10],[52,9,52,10],[11,11,11,13],[48,11,49,13],[45,1,45,9],[15,6,15,7],[15,9,15,10],[16,9,17,9],[16,10,17,10],[16,12,17,12],[13,1,13,10],[0,1,0,7],[1,1,1,7],[50,3,50,6],[52,3,52,6],[56,1,58,3],[56,5,58,5],[2,2,2,10],[7,2,7,6],[9,2,9,6],[52,1,52,2],[48,1,48,10],[49,1,49,10],[7,7,7,9],[7,10,7,13],[13,11,13,13],[11,2,11,3],[16,14,17,14],[59,11,59,13],[54,1,54,9],[54,10,54,13],[16,1,17,1],[16,2,17,2],[16,4,17,4],[16,6,17,6],[16,7,17,7],[50,1,50,2],[56,4,58,4],[55,11,55,13],[56,11,56,13],[57,11,57,13],[58,11,58,13]]}
[]
[null,"TRAVEL CLAIMS - BUSINESS MILEAGE USING OWN VEHICLE"]
[]
[]
[null,"FOR CHARGES INCURRED ON AUTHORISED UNIVERSITY BUSINESS ONLY.",null,null,null,null,null,"PARKING CHARGES MUST BE ACCOMPANIED BY VALID RECEIPTS."]
[null,"CLAIMS TO BE SUBMITTED WITHIN 5 WORKING DAYS FOLLOWING MONTH END.",null,null,null,null,null,"ENTER DETAILS ELECTRONICALLY, THEN PRINT FORM FOR SIGNATURES."]
[]
[null,"NAME:",null,null,null,null,null,"EMPLOYEE NO  (8 digits):            ",null,null,400]
[]
[null,"DEPT:",null,null,null,null,null,"JOB TITLE:"]
[]
[null,null,"CLAIM FOR MONTH:",null,null,null,null,"   (select from dropdowns)",null,null,"Tax Year"]
[]
[null,"Enter total mileage already claimed for CAR journeys in the current tax year (MANDATORY)   :"]
[]
[null,"COMPLETE ALL FIELDS BELOW FOR EACH JOURNEY",null,null,null,null,"IF TRIP WAS NON INTER CAMPUS",null,null,"IF TRIP WAS INTERCAMPUS"]
[null,"Date of Journey","Mode of Transport (select)","Folio/ Cost centre folder. If all claims the same enter in box below","Business Reason for Journey                   (mandatory for all trips)",null,"Non Inter Campus Journey                       From/To                                  (Home to work not allowed)","Non inter campus miles claimed (please key in)",null,"Select journey from drop down list (Inter campus only)","Select Single or Return Trip",null,"Total Miles claimed",null,"Claims for Parking (please attach receipts)"]
[null,null,null," "]
[null,null,null,{"$f":"IF(B19>0,D$18,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P18>0,Workings!P18,\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(J19>0,1,0)","v":0}]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P19>0,Workings!P19,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P20>0,Workings!P20,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P21>0,Workings!P21,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P22>0,Workings!P22,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P23>0,Workings!P23,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P24>0,Workings!P24,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P25>0,Workings!P25,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P26>0,Workings!P26,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P27>0,Workings!P27,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P28>0,Workings!P28,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P29>0,Workings!P29,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P30>0,Workings!P30,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P31>0,Workings!P31,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P32>0,Workings!P32,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P33>0,Workings!P33,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P34>0,Workings!P34,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P35>0,Workings!P35,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P36>0,Workings!P36,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P37>0,Workings!P37,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P38>0,Workings!P38,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P39>0,Workings!P39,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P40>0,Workings!P40,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P41>0,Workings!P41,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P42>0,Workings!P42,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P43>0,Workings!P43,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(Workings!P44>0,Workings!P44,\" \")","v":" "},null,null,null,null,null,null,null,null,0]
[null,"Please use a second sheet if all claims for the month cannot be accommodated on one sheet. DO NOT ADD ROWS TO THE TEMPLATE",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M19:M45)","v":0},null,{"$f":"O60","v":0}]
[]
[]
[null,"IN MAKING THIS CLAIM I HAVE ENSURED THAT THE VEHICLE WAS INSURED FOR USE ON UNIVERSITY BUSINESS"]
[null,"I ACKNOWLEDGE THAT I AM PERSONALLY RESPONSIBLE FOR DECLARING IF I HAVE EXCEEDED 10,000 MILES IN A TAX YEAR AND FOR ANY TAX CHARGE ARISING FROM MY NEGLECTING TO REFLECT THIS IN MY CLAIMS"]
[null,"Signature of Claimant :",null,{"$f":"IF(Workings!F12,\" \",\"DO NOT SIGN BEFORE ACCEPTING STATEMENTS ABOVE\")","v":"DO NOT SIGN BEFORE ACCEPTING STATEMENTS ABOVE"},null,null,null,"Date"]
[]
[null,"Authorised Signatory :",null,null,null,null,null,"Date"]
[]
["KEEP A COPY OF THIS & EVERY CLAIM FOR YOUR TAX RECORDS","KEEP A COPY OF THIS & EVERY CLAIM FOR YOUR TAX RECORDS",null,null,null,null,null,null,null,null,"MILEAGE",null,null,null,"PARKING"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Workings!S45","v":0},"miles @ 0.45"]
[null,"NEW CAR MILEAGE TOTAL FOR THIS TAX YEAR TO CARRY FORWARD TO NEXT MONTH ",null,null,{"$f":"L14+K56+K57","v":0},null,null,null,null,null,{"$f":"Workings!T45","v":0},"miles @ 0.25"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Workings!L45:M45)","v":0},"miles @ 0.24"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Workings!N45:O45)","v":0},"miles @ 0.20"]
[null,null,null,null,null,null,null,null,null,null,"Totals",{"$f":"(K56*0.45)+(K57*0.25)+(K58*0.24)+(K59*0.2)","v":0},null,null,{"$f":"SUM(O19:O45)","v":0}]

{"sheet":"Workings","index":1,"n_rows":54,"n_cols":23,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Car"]
["Motorbike"]
["Bicycle"]
[]
["Single"]
["Return"]
["  ",0]
["Bainfield to Craiglockhart",2.1]
["Bainfield to Merchiston",0.8]
["Bainfield to Sighthill",3.4]
["Colinton Road to Sighthill",3.6]
["Craiglockhart to Bainfield",2.1,null,null,null,false]
["Craiglockhart to Livingston",17]
["Craiglockhart to Merchiston",1.8,null,null,null,null,null,{"$f":"Claim!L14","v":0}]
["Craiglockhart to Sighthill",3]
["Merchiston to Bainfield",0.8,null,"i/c miles","single 1","total","TOTAL","ytd car",null,"non i/c","i/c ","non i/c","i/c","non i/c","i/c",null,null,"available","high","low",null,"Year","Month"]
["Merchiston to Craiglockhart",1.8,null,"all vehs","return 2","i/c miles","Car mls","miles",null,"car","car","m/cyc","m/cyc","bike","bike","TOTAL",null,null,null,null,null,2017,"January"]
["Merchiston to Sighthill",4.2,null,{"$f":"IF(Claim!J19>0,VLOOKUP(Claim!J19,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K19=\"Return\",2,1)","v":1},{"$f":"D18*E18","v":0},{"$f":"SUM(J18:K18)","v":0},{"$f":"SUM(J$18:K18)+H$14","v":0},null,{"$f":"IF(Claim!C19=\"car\",Claim!H19,0)","v":0},{"$f":"IF(Claim!C19=\"car\",F18,0)","v":0},{"$f":"IF(Claim!C19=\"Motorbike\",Claim!H19,0)","v":0},{"$f":"IF(Claim!C19=\"motorbike\",F18,0)","v":0},{"$f":"IF(Claim!C19=\"Bicycle\",Claim!H19,0)","v":0},{"$f":"IF(Claim!C19=\"bicycle\",F18,0)","v":0},{"$f":"SUM(J18:O18)","v":0},{"$f":"10000-H14","v":10000},{"$f":"IF(Q18>0,Q18,0)","v":10000},{"$f":"IF(R18>G18,G18,R18)","v":0},{"$f":"IF(G18>R18,G18-S18,0)","v":0},null,2018,"February"]
["Sighthill to Colinton Road",3.6,null,{"$f":"IF(Claim!J20>0,VLOOKUP(Claim!J20,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K20=\"Return\",2,1)","v":1},{"$f":"D19*E19","v":0},0,{"$f":"SUM(J$18:K19)+H$14","v":0},null,{"$f":"IF(Claim!C20=\"car\",Claim!H20,0)","v":0},{"$f":"IF(Claim!C20=\"car\",F19,0)","v":0},{"$f":"IF(Claim!C20=\"Motorbike\",Claim!H20,0)","v":0},{"$f":"IF(Claim!C20=\"motorbike\",F19,0)","v":0},{"$f":"IF(Claim!C20=\"Bicycle\",Claim!H20,0)","v":0},{"$f":"IF(Claim!C20=\"bicycle\",F19,0)","v":0},{"$f":"SUM(J19:O19)","v":0},{"$f":"10000-H18","v":10000},{"$f":"IF(Q19>0,Q19,0)","v":10000},0,0,null,2019,"March"]
["Sighthill to Craiglockhart",3,null,{"$f":"IF(Claim!J21>0,VLOOKUP(Claim!J21,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K21=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K20)+H$14","v":0},null,{"$f":"IF(Claim!C21=\"car\",Claim!H21,0)","v":0},{"$f":"IF(Claim!C21=\"car\",F20,0)","v":0},{"$f":"IF(Claim!C21=\"Motorbike\",Claim!H21,0)","v":0},{"$f":"IF(Claim!C21=\"motorbike\",F20,0)","v":0},{"$f":"IF(Claim!C21=\"Bicycle\",Claim!H21,0)","v":0},{"$f":"IF(Claim!C21=\"bicycle\",F20,0)","v":0},0,10000,10000,0,0,null,2020,"April"]
["Sighthill to Livingston",10.8,null,{"$f":"IF(Claim!J22>0,VLOOKUP(Claim!J22,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K22=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K21)+H$14","v":0},null,{"$f":"IF(Claim!C22=\"car\",Claim!H22,0)","v":0},{"$f":"IF(Claim!C22=\"car\",F21,0)","v":0},{"$f":"IF(Claim!C22=\"Motorbike\",Claim!H22,0)","v":0},{"$f":"IF(Claim!C22=\"motorbike\",F21,0)","v":0},{"$f":"IF(Claim!C22=\"Bicycle\",Claim!H22,0)","v":0},{"$f":"IF(Claim!C22=\"bicycle\",F21,0)","v":0},0,10000,10000,0,0,null,2021,"May"]
["Sighthill to Marchmont ",4.8,null,{"$f":"IF(Claim!J23>0,VLOOKUP(Claim!J23,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K23=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K22)+H$14","v":0},null,{"$f":"IF(Claim!C23=\"car\",Claim!H23,0)","v":0},{"$f":"IF(Claim!C23=\"car\",F22,0)","v":0},{"$f":"IF(Claim!C23=\"Motorbike\",Claim!H23,0)","v":0},{"$f":"IF(Claim!C23=\"motorbike\",F22,0)","v":0},{"$f":"IF(Claim!C23=\"Bicycle\",Claim!H23,0)","v":0},{"$f":"IF(Claim!C23=\"bicycle\",F22,0)","v":0},0,10000,10000,0,0,null,2022,"June"]
["Sighthill to Melrose",38.6,null,{"$f":"IF(Claim!J24>0,VLOOKUP(Claim!J24,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K24=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K23)+H$14","v":0},null,{"$f":"IF(Claim!C24=\"car\",Claim!H24,0)","v":0},{"$f":"IF(Claim!C24=\"car\",F23,0)","v":0},{"$f":"IF(Claim!C24=\"Motorbike\",Claim!H24,0)","v":0},{"$f":"IF(Claim!C24=\"motorbike\",F23,0)","v":0},{"$f":"IF(Claim!C24=\"Bicycle\",Claim!H24,0)","v":0},{"$f":"IF(Claim!C24=\"bicycle\",F23,0)","v":0},0,10000,10000,0,0,null,null,"July"]
["Sighthill to Merchiston",4.2,null,{"$f":"IF(Claim!J25>0,VLOOKUP(Claim!J25,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K25=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K24)+H$14","v":0},null,{"$f":"IF(Claim!C25=\"car\",Claim!H25,0)","v":0},{"$f":"IF(Claim!C25=\"car\",F24,0)","v":0},{"$f":"IF(Claim!C25=\"Motorbike\",Claim!H25,0)","v":0},{"$f":"IF(Claim!C25=\"motorbike\",F24,0)","v":0},{"$f":"IF(Claim!C25=\"Bicycle\",Claim!H25,0)","v":0},{"$f":"IF(Claim!C25=\"bicycle\",F24,0)","v":0},0,10000,10000,0,0,null,null,"August"]
["Sighthill to Bainfield",3.4,null,{"$f":"IF(Claim!J26>0,VLOOKUP(Claim!J26,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K26=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K25)+H$14","v":0},null,{"$f":"IF(Claim!C26=\"car\",Claim!H26,0)","v":0},{"$f":"IF(Claim!C26=\"car\",F25,0)","v":0},{"$f":"IF(Claim!C26=\"Motorbike\",Claim!H26,0)","v":0},{"$f":"IF(Claim!C26=\"motorbike\",F25,0)","v":0},{"$f":"IF(Claim!C26=\"Bicycle\",Claim!H26,0)","v":0},{"$f":"IF(Claim!C26=\"bicycle\",F25,0)","v":0},0,10000,10000,0,0,null,null,"September"]
["Livingston to Craiglockhart",17,null,{"$f":"IF(Claim!J27>0,VLOOKUP(Claim!J27,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K27=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K26)+H$14","v":0},null,{"$f":"IF(Claim!C27=\"car\",Claim!H27,0)","v":0},{"$f":"IF(Claim!C27=\"car\",F26,0)","v":0},{"$f":"IF(Claim!C27=\"Motorbike\",Claim!H27,0)","v":0},{"$f":"IF(Claim!C27=\"motorbike\",F26,0)","v":0},{"$f":"IF(Claim!C27=\"Bicycle\",Claim!H27,0)","v":0},{"$f":"IF(Claim!C27=\"bicycle\",F26,0)","v":0},0,10000,10000,0,0,null,"2017/2018","October"]
["Livingston to Merchiston",18,null,{"$f":"IF(Claim!J28>0,VLOOKUP(Claim!J28,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K28=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K27)+H$14","v":0},null,{"$f":"IF(Claim!C28=\"car\",Claim!H28,0)","v":0},{"$f":"IF(Claim!C28=\"car\",F27,0)","v":0},{"$f":"IF(Claim!C28=\"Motorbike\",Claim!H28,0)","v":0},{"$f":"IF(Claim!C28=\"motorbike\",F27,0)","v":0},{"$f":"IF(Claim!C28=\"Bicycle\",Claim!H28,0)","v":0},{"$f":"IF(Claim!C28=\"bicycle\",F27,0)","v":0},0,10000,10000,0,0,null,"2018/2019","November"]
["Livingston to Sighthill",10.8,null,{"$f":"IF(Claim!J29>0,VLOOKUP(Claim!J29,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K29=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K28)+H$14","v":0},null,{"$f":"IF(Claim!C29=\"car\",Claim!H29,0)","v":0},{"$f":"IF(Claim!C29=\"car\",F28,0)","v":0},{"$f":"IF(Claim!C29=\"Motorbike\",Claim!H29,0)","v":0},{"$f":"IF(Claim!C29=\"motorbike\",F28,0)","v":0},{"$f":"IF(Claim!C29=\"Bicycle\",Claim!H29,0)","v":0},{"$f":"IF(Claim!C29=\"bicycle\",F28,0)","v":0},0,10000,10000,0,0,null,"2019/2020","December"]
[null,null,null,{"$f":"IF(Claim!J30>0,VLOOKUP(Claim!J30,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K30=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K29)+H$14","v":0},null,{"$f":"IF(Claim!C30=\"car\",Claim!H30,0)","v":0},{"$f":"IF(Claim!C30=\"car\",F29,0)","v":0},{"$f":"IF(Claim!C30=\"Motorbike\",Claim!H30,0)","v":0},{"$f":"IF(Claim!C30=\"motorbike\",F29,0)","v":0},{"$f":"IF(Claim!C30=\"Bicycle\",Claim!H30,0)","v":0},{"$f":"IF(Claim!C30=\"bicycle\",F29,0)","v":0},0,10000,10000,0,0,null,"2020/2021"]
[null,null,null,{"$f":"IF(Claim!J31>0,VLOOKUP(Claim!J31,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K31=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K30)+H$14","v":0},null,{"$f":"IF(Claim!C31=\"car\",Claim!H31,0)","v":0},{"$f":"IF(Claim!C31=\"car\",F30,0)","v":0},{"$f":"IF(Claim!C31=\"Motorbike\",Claim!H31,0)","v":0},{"$f":"IF(Claim!C31=\"motorbike\",F30,0)","v":0},{"$f":"IF(Claim!C31=\"Bicycle\",Claim!H31,0)","v":0},{"$f":"IF(Claim!C31=\"bicycle\",F30,0)","v":0},0,10000,10000,0,0,null,"2021/2022"]
[null,null,null,{"$f":"IF(Claim!J32>0,VLOOKUP(Claim!J32,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K32=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K31)+H$14","v":0},null,{"$f":"IF(Claim!C32=\"car\",Claim!H32,0)","v":0},{"$f":"IF(Claim!C32=\"car\",F31,0)","v":0},{"$f":"IF(Claim!C32=\"Motorbike\",Claim!H32,0)","v":0},{"$f":"IF(Claim!C32=\"motorbike\",F31,0)","v":0},{"$f":"IF(Claim!C32=\"Bicycle\",Claim!H32,0)","v":0},{"$f":"IF(Claim!C32=\"bicycle\",F31,0)","v":0},0,10000,10000,0,0]
[null,null,null,{"$f":"IF(Claim!J33>0,VLOOKUP(Claim!J33,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K33=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K32)+H$14","v":0},null,{"$f":"IF(Claim!C33=\"car\",Claim!H33,0)","v":0},{"$f":"IF(Claim!C33=\"car\",F32,0)","v":0},{"$f":"IF(Claim!C33=\"Motorbike\",Claim!H33,0)","v":0},{"$f":"IF(Claim!C33=\"motorbike\",F32,0)","v":0},{"$f":"IF(Claim!C33=\"Bicycle\",Claim!H33,0)","v":0},{"$f":"IF(Claim!C33=\"bicycle\",F32,0)","v":0},0,10000,10000,0,0]
[null,null,null,{"$f":"IF(Claim!J34>0,VLOOKUP(Claim!J34,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K34=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K33)+H$14","v":0},null,{"$f":"IF(Claim!C34=\"car\",Claim!H34,0)","v":0},{"$f":"IF(Claim!C34=\"car\",F33,0)","v":0},{"$f":"IF(Claim!C34=\"Motorbike\",Claim!H34,0)","v":0},{"$f":"IF(Claim!C34=\"motorbike\",F33,0)","v":0},{"$f":"IF(Claim!C34=\"Bicycle\",Claim!H34,0)","v":0},{"$f":"IF(Claim!C34=\"bicycle\",F33,0)","v":0},0,10000,10000,0,0]
[null,null,null,{"$f":"IF(Claim!J35>0,VLOOKUP(Claim!J35,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K35=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K34)+H$14","v":0},null,{"$f":"IF(Claim!C35=\"car\",Claim!H35,0)","v":0},{"$f":"IF(Claim!C35=\"car\",F34,0)","v":0},{"$f":"IF(Claim!C35=\"Motorbike\",Claim!H35,0)","v":0},{"$f":"IF(Claim!C35=\"motorbike\",F34,0)","v":0},{"$f":"IF(Claim!C35=\"Bicycle\",Claim!H35,0)","v":0},{"$f":"IF(Claim!C35=\"bicycle\",F34,0)","v":0},0,10000,10000,0,0]
[null,null,null,{"$f":"IF(Claim!J36>0,VLOOKUP(Claim!J36,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K36=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K35)+H$14","v":0},null,{"$f":"IF(Claim!C36=\"car\",Claim!H36,0)","v":0},{"$f":"IF(Claim!C36=\"car\",F35,0)","v":0},{"$f":"IF(Claim!C36=\"Motorbike\",Claim!H36,0)","v":0},{"$f":"IF(Claim!C36=\"motorbike\",F35,0)","v":0},{"$f":"IF(Claim!C36=\"Bicycle\",Claim!H36,0)","v":0},{"$f":"IF(Claim!C36=\"bicycle\",F35,0)","v":0},0,10000,10000,0,0]
["Craiglockhart to Marchmont",2.75,null,{"$f":"IF(Claim!J37>0,VLOOKUP(Claim!J37,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K37=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K36)+H$14","v":0},null,{"$f":"IF(Claim!C37=\"car\",Claim!H37,0)","v":0},{"$f":"IF(Claim!C37=\"car\",F36,0)","v":0},{"$f":"IF(Claim!C37=\"Motorbike\",Claim!H37,0)","v":0},{"$f":"IF(Claim!C37=\"motorbike\",F36,0)","v":0},{"$f":"IF(Claim!C37=\"Bicycle\",Claim!H37,0)","v":0},{"$f":"IF(Claim!C37=\"bicycle\",F36,0)","v":0},0,10000,10000,0,0]
["Craiglockhart to Melrose",40,null,{"$f":"IF(Claim!J38>0,VLOOKUP(Claim!J38,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K38=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K37)+H$14","v":0},null,{"$f":"IF(Claim!C38=\"car\",Claim!H38,0)","v":0},{"$f":"IF(Claim!C38=\"car\",F37,0)","v":0},{"$f":"IF(Claim!C38=\"Motorbike\",Claim!H38,0)","v":0},{"$f":"IF(Claim!C38=\"motorbike\",F37,0)","v":0},{"$f":"IF(Claim!C38=\"Bicycle\",Claim!H38,0)","v":0},{"$f":"IF(Claim!C38=\"bicycle\",F37,0)","v":0},0,10000,10000,0,0]
["Livingston to Marchmont",19.25,null,{"$f":"IF(Claim!J39>0,VLOOKUP(Claim!J39,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K39=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K38)+H$14","v":0},null,{"$f":"IF(Claim!C39=\"car\",Claim!H39,0)","v":0},{"$f":"IF(Claim!C39=\"car\",F38,0)","v":0},{"$f":"IF(Claim!C39=\"Motorbike\",Claim!H39,0)","v":0},{"$f":"IF(Claim!C39=\"motorbike\",F38,0)","v":0},{"$f":"IF(Claim!C39=\"Bicycle\",Claim!H39,0)","v":0},{"$f":"IF(Claim!C39=\"bicycle\",F38,0)","v":0},0,10000,10000,0,0]
["Livingston to Melrose",60,null,{"$f":"IF(Claim!J40>0,VLOOKUP(Claim!J40,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K40=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K39)+H$14","v":0},null,{"$f":"IF(Claim!C40=\"car\",Claim!H40,0)","v":0},{"$f":"IF(Claim!C40=\"car\",F39,0)","v":0},{"$f":"IF(Claim!C40=\"Motorbike\",Claim!H40,0)","v":0},{"$f":"IF(Claim!C40=\"motorbike\",F39,0)","v":0},{"$f":"IF(Claim!C40=\"Bicycle\",Claim!H40,0)","v":0},{"$f":"IF(Claim!C40=\"bicycle\",F39,0)","v":0},0,10000,10000,0,0]
["Marchmont to Craiglockhart",2.75,null,{"$f":"IF(Claim!J41>0,VLOOKUP(Claim!J41,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K41=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K40)+H$14","v":0},null,{"$f":"IF(Claim!C41=\"car\",Claim!H41,0)","v":0},{"$f":"IF(Claim!C41=\"car\",F40,0)","v":0},{"$f":"IF(Claim!C41=\"Motorbike\",Claim!H41,0)","v":0},{"$f":"IF(Claim!C41=\"motorbike\",F40,0)","v":0},{"$f":"IF(Claim!C41=\"Bicycle\",Claim!H41,0)","v":0},{"$f":"IF(Claim!C41=\"bicycle\",F40,0)","v":0},0,10000,10000,0,0]
["Marchmont to Livingston",19.25,null,{"$f":"IF(Claim!J42>0,VLOOKUP(Claim!J42,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K42=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K41)+H$14","v":0},null,{"$f":"IF(Claim!C42=\"car\",Claim!H42,0)","v":0},{"$f":"IF(Claim!C42=\"car\",F41,0)","v":0},{"$f":"IF(Claim!C42=\"Motorbike\",Claim!H42,0)","v":0},{"$f":"IF(Claim!C42=\"motorbike\",F41,0)","v":0},{"$f":"IF(Claim!C42=\"Bicycle\",Claim!H42,0)","v":0},{"$f":"IF(Claim!C42=\"bicycle\",F41,0)","v":0},0,10000,10000,0,0]
["Marchmont to Melrose",41,null,{"$f":"IF(Claim!J43>0,VLOOKUP(Claim!J43,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K43=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K42)+H$14","v":0},null,{"$f":"IF(Claim!C43=\"car\",Claim!H43,0)","v":0},{"$f":"IF(Claim!C43=\"car\",F42,0)","v":0},{"$f":"IF(Claim!C43=\"Motorbike\",Claim!H43,0)","v":0},{"$f":"IF(Claim!C43=\"motorbike\",F42,0)","v":0},{"$f":"IF(Claim!C43=\"Bicycle\",Claim!H43,0)","v":0},{"$f":"IF(Claim!C43=\"bicycle\",F42,0)","v":0},0,10000,10000,0,0]
["Marchmont to Merchiston",1.25,null,{"$f":"IF(Claim!J44>0,VLOOKUP(Claim!J44,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K44=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K43)+H$14","v":0},null,{"$f":"IF(Claim!C44=\"car\",Claim!H44,0)","v":0},{"$f":"IF(Claim!C44=\"car\",F43,0)","v":0},{"$f":"IF(Claim!C44=\"Motorbike\",Claim!H44,0)","v":0},{"$f":"IF(Claim!C44=\"motorbike\",F43,0)","v":0},{"$f":"IF(Claim!C44=\"Bicycle\",Claim!H44,0)","v":0},{"$f":"IF(Claim!C44=\"bicycle\",F43,0)","v":0},0,10000,10000,0,0]
["Marchmont to Sighthill",4.8,null,{"$f":"IF(Claim!J45>0,VLOOKUP(Claim!J45,$A$7:$B$54,2,FALSE),0)","v":0},{"$f":"IF(Claim!K45=\"Return\",2,1)","v":1},0,0,{"$f":"SUM(J$18:K44)+H$14","v":0},null,{"$f":"IF(Claim!C45=\"car\",Claim!H45,0)","v":0},{"$f":"IF(Claim!C45=\"car\",F44,0)","v":0},{"$f":"IF(Claim!C45=\"Motorbike\",Claim!H45,0)","v":0},{"$f":"IF(Claim!C45=\"motorbike\",F44,0)","v":0},{"$f":"IF(Claim!C45=\"Bicycle\",Claim!H45,0)","v":0},{"$f":"IF(Claim!C45=\"bicycle\",F44,0)","v":0},0,10000,10000,0,0]
["Melrose to  Marchmont",41,null,null,null,{"$f":"SUM(F18:F44)","v":0},{"$f":"SUM(G18:G44)","v":0},null,null,{"$f":"SUM(J18:J44)","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(S18:S44)","v":0},{"$f":"SUM(T18:T44)","v":0}]
["Melrose to Craiglockhart",40]
["Melrose to Livingston",60]
["Melrose to Merchiston",42]
["Melrose to Sighthill",38.6]
["Merchiston to Livingston",18]
["Merchiston to Marchmont",1.25]
["Merchiston to Marchmont",1.25]
["Merchiston to Melrose",42]
["Merchiston to Melrose",42]

{"sheet":"personal claim record","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,6,2,8]]}
["TAX YEAR"]
[]
[null,null,"Inter Campus miles",null,null,null,"Non Intercampus miles"]
["Month claimed",null,"Car","Motorbike","Cycle",null,"Car","Motorbike","Cycle",null,"Car Total"]
["April",null,null,null,null,null,null,null,null,null,{"$f":"C5+G5","v":0}]
["May",null,null,null,null,null,null,null,null,null,{"$f":"C6+G6","v":0}]
["June",null,null,null,null,null,null,null,null,null,0]
["July",null,null,null,null,null,null,null,null,null,0]
["August",null,null,null,null,null,null,null,null,null,0]
["September",null,null,null,null,null,null,null,null,null,0]
["October",null,null,null,null,null,null,null,null,null,0]
["November",null,null,null,null,null,null,null,null,null,0]
["December",null,null,null,null,null,null,null,null,null,0]
["January",null,null,null,null,null,null,null,null,null,0]
["February",null,null,null,null,null,null,null,null,null,0]
["March",null,null,null,null,null,null,null,null,null,0]
[]
[null,null,{"$f":"SUM(C5:C16)","v":0},{"$f":"SUM(D5:D16)","v":0},0,null,0,0,0,null,{"$f":"SUM(K5:K16)","v":0}]