{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet3","Sheet2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[70,0,103,8],[65,0,66,5]]}
["PERSONAL EXPENSE CLAIM FORM"]
[]
["Employee Name:",null,null,null,null,"Lease Car:  ","No"]
["Claim Date:",null,{"$f":"NOW()","v":"2025-09-08T14:26:23.840"},null,null,"Opening Mileage:  ",0,"Fuel:"]
["Default Home\\HO:",null,"Head Office",null,null,"Closing Mileage:  ",{"$f":"G4+SUM(G9:G65)","v":0},"Engine:"]
["Default Department:",null,"HO - Finance",null,null,null,null,"Engine:"]
[null,null,null,null,null,null,null,null,"Ver 2025.1"]
["Date","Type","Account","Home","Dept","Description","Miles","Claim","Amount",null,"Cumulative"]
[null,null,{"$f":"IF(B9>0,VLOOKUP(B9,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},{"$f":"VLOOKUP($C$5,Sheet2!$D$2:$E$11,2,FALSE)","v":"HO"},{"$f":"VLOOKUP($C$6,Sheet2!$G$2:$H$18,1,FALSE)","v":"HO - Finance"},null,null,{"$f":"IF(K8<=10000,IF(K9<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G9,((10000-K8)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K9-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G9)+IF(J9=\"x\",0.05*G9,0)","v":0},null,null,{"$f":"+G4","v":0}]
[null,null,{"$f":"IF(B10>0,VLOOKUP(B10,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K9<=10000,IF(K10<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G10,((10000-K9)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K10-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G10)+IF(J10=\"x\",0.05*G10,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G10)","v":0}]
[null,null,{"$f":"IF(B11>0,VLOOKUP(B11,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K10<=10000,IF(K11<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G11,((10000-K10)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K11-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G11)+IF(J11=\"x\",0.05*G11,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G11)","v":0},null,"Additional Rows"]
[null,null,{"$f":"IF(B12>0,VLOOKUP(B12,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K11<=10000,IF(K12<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G12,((10000-K11)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K12-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G12)+IF(J12=\"x\",0.05*G12,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G12)","v":0}]
[null,null,{"$f":"IF(B13>0,VLOOKUP(B13,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K12<=10000,IF(K13<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G13,((10000-K12)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K13-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G13)+IF(J13=\"x\",0.05*G13,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G13)","v":0}]
[null,null,{"$f":"IF(B14>0,VLOOKUP(B14,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K13<=10000,IF(K14<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G14,((10000-K13)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K14-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G14)+IF(J14=\"x\",0.05*G14,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G14)","v":0}]
[null,null,{"$f":"IF(B15>0,VLOOKUP(B15,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K14<=10000,IF(K15<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G15,((10000-K14)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K15-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G15)+IF(J15=\"x\",0.05*G15,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G15)","v":0}]
[null,null,{"$f":"IF(B16>0,VLOOKUP(B16,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K15<=10000,IF(K16<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G16,((10000-K15)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K16-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G16)+IF(J16=\"x\",0.05*G16,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G16)","v":0}]
[null,null,{"$f":"IF(B17>0,VLOOKUP(B17,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K16<=10000,IF(K17<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G17,((10000-K16)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K17-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G17)+IF(J17=\"x\",0.05*G17,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G17)","v":0},"1.  When using for the first time click on the 'New Claim, New Employee' button above."]
[null,null,{"$f":"IF(B18>0,VLOOKUP(B18,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K17<=10000,IF(K18<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G18,((10000-K17)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K18-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G18)+IF(J18=\"x\",0.05*G18,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G18)","v":0},null," - Enter your name and select your default Home and Department when requested."]
[null,null,{"$f":"IF(B19>0,VLOOKUP(B19,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K18<=10000,IF(K19<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G19,((10000-K18)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K19-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G19)+IF(J19=\"x\",0.05*G19,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G19)","v":0},"2.  Complete the details of your claim."]
[null,null,{"$f":"IF(B20>0,VLOOKUP(B20,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K19<=10000,IF(K20<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G20,((10000-K19)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K20-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G20)+IF(J20=\"x\",0.05*G20,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G20)","v":0},"3.  If you need more rows click on 'Show'.  To revert to basic form click 'Hide'."]
[null,null,{"$f":"IF(B21>0,VLOOKUP(B21,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K20<=10000,IF(K21<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G21,((10000-K20)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K21-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G21)+IF(J21=\"x\",0.05*G21,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G21)","v":0},"3.  Once completed click on the 'Submit Claim' button."]
[null,null,{"$f":"IF(B22>0,VLOOKUP(B22,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K21<=10000,IF(K22<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G22,((10000-K21)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K22-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G22)+IF(J22=\"x\",0.05*G22,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G22)","v":0},null,"- this will create an email with your claim attached.  You will need to click on 'Send'"]
[null,null,{"$f":"IF(B23>0,VLOOKUP(B23,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K22<=10000,IF(K23<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G23,((10000-K22)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K23-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G23)+IF(J23=\"x\",0.05*G23,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G23)","v":0},null,"within the email when you're ready."]
[null,null,{"$f":"IF(B24>0,VLOOKUP(B24,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K23<=10000,IF(K24<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G24,((10000-K23)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K24-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G24)+IF(J24=\"x\",0.05*G24,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G24)","v":0},"4.  Click on the 'New Claim, Same Employee' button.  This will;"]
[null,null,{"$f":"IF(B25>0,VLOOKUP(B25,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K24<=10000,IF(K25<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G25,((10000-K24)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K25-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G25)+IF(J25=\"x\",0.05*G25,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G25)","v":0},null,"- clear all the claim lines"]
[null,null,{"$f":"IF(B26>0,VLOOKUP(B26,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K25<=10000,IF(K26<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G26,((10000-K25)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K26-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G26)+IF(J26=\"x\",0.05*G26,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G26)","v":0},null,"- keep your name, department and car data"]
[null,null,{"$f":"IF(B27>0,VLOOKUP(B27,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K26<=10000,IF(K27<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G27,((10000-K26)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K27-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G27)+IF(J27=\"x\",0.05*G27,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G27)","v":0},null,"- update the opening mileage"]
[null,null,{"$f":"IF(B28>0,VLOOKUP(B28,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K27<=10000,IF(K28<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G28,((10000-K27)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K28-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G28)+IF(J28=\"x\",0.05*G28,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G28)","v":0}]
[null,null,{"$f":"IF(B29>0,VLOOKUP(B29,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K28<=10000,IF(K29<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G29,((10000-K28)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K29-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G29)+IF(J29=\"x\",0.05*G29,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G29)","v":0}]
[null,null,{"$f":"IF(B30>0,VLOOKUP(B30,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K29<=10000,IF(K30<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G30,((10000-K29)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K30-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G30)+IF(J30=\"x\",0.05*G30,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G30)","v":0}]
[null,null,{"$f":"IF(B31>0,VLOOKUP(B31,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K30<=10000,IF(K31<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G31,((10000-K30)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K31-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G31)+IF(J31=\"x\",0.05*G31,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G31)","v":0}]
[null,null,{"$f":"IF(B32>0,VLOOKUP(B32,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K31<=10000,IF(K32<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G32,((10000-K31)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K32-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G32)+IF(J32=\"x\",0.05*G32,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G32)","v":0}]
[null,null,{"$f":"IF(B33>0,VLOOKUP(B33,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K32<=10000,IF(K33<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G33,((10000-K32)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K33-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G33)+IF(J33=\"x\",0.05*G33,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G33)","v":0}]
[null,null,{"$f":"IF(B34>0,VLOOKUP(B34,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K33<=10000,IF(K34<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G34,((10000-K33)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K34-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G34)+IF(J34=\"x\",0.05*G34,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G34)","v":0}]
[null,null,{"$f":"IF(B35>0,VLOOKUP(B35,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K34<=10000,IF(K35<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G35,((10000-K34)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K35-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G35)+IF(J35=\"x\",0.05*G35,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G35)","v":0}]
[null,null,{"$f":"IF(B36>0,VLOOKUP(B36,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K35<=10000,IF(K36<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G36,((10000-K35)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K36-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G36)+IF(J36=\"x\",0.05*G36,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G36)","v":0}]
[null,null,{"$f":"IF(B37>0,VLOOKUP(B37,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K36<=10000,IF(K37<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G37,((10000-K36)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K37-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G37)+IF(J37=\"x\",0.05*G37,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G37)","v":0}]
[null,null,{"$f":"IF(B38>0,VLOOKUP(B38,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K37<=10000,IF(K38<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G38,((10000-K37)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K38-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G38)+IF(J38=\"x\",0.05*G38,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G38)","v":0}]
[null,null,{"$f":"IF(B39>0,VLOOKUP(B39,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K38<=10000,IF(K39<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G39,((10000-K38)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K39-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G39)+IF(J39=\"x\",0.05*G39,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G39)","v":0}]
[null,null,{"$f":"IF(B40>0,VLOOKUP(B40,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K39<=10000,IF(K40<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G40,((10000-K39)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K40-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G40)+IF(J40=\"x\",0.05*G40,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G40)","v":0}]
[null,null,{"$f":"IF(B41>0,VLOOKUP(B41,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K40<=10000,IF(K41<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G41,((10000-K40)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K41-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G41)+IF(J41=\"x\",0.05*G41,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G41)","v":0}]
[null,null,{"$f":"IF(B42>0,VLOOKUP(B42,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K41<=10000,IF(K42<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G42,((10000-K41)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K42-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G42)+IF(J42=\"x\",0.05*G42,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G42)","v":0}]
[null,null,{"$f":"IF(B43>0,VLOOKUP(B43,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K42<=10000,IF(K43<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G43,((10000-K42)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K43-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G43)+IF(J43=\"x\",0.05*G43,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G43)","v":0}]
[null,null,{"$f":"IF(B44>0,VLOOKUP(B44,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K43<=10000,IF(K44<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G44,((10000-K43)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K44-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G44)+IF(J44=\"x\",0.05*G44,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G44)","v":0}]
[null,null,{"$f":"IF(B45>0,VLOOKUP(B45,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K44<=10000,IF(K45<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G45,((10000-K44)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K45-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G45)+IF(J45=\"x\",0.05*G45,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G45)","v":0}]
[null,null,{"$f":"IF(B46>0,VLOOKUP(B46,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K45<=10000,IF(K46<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G46,((10000-K45)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K46-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G46)+IF(J46=\"x\",0.05*G46,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G46)","v":0}]
[null,null,{"$f":"IF(B47>0,VLOOKUP(B47,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K46<=10000,IF(K47<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G47,((10000-K46)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K47-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G47)+IF(J47=\"x\",0.05*G47,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G47)","v":0}]
[null,null,{"$f":"IF(B48>0,VLOOKUP(B48,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K47<=10000,IF(K48<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G48,((10000-K47)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K48-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G48)+IF(J48=\"x\",0.05*G48,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G48)","v":0}]
[null,null,{"$f":"IF(B49>0,VLOOKUP(B49,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K48<=10000,IF(K49<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G49,((10000-K48)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K49-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G49)+IF(J49=\"x\",0.05*G49,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G49)","v":0}]
[null,null,{"$f":"IF(B50>0,VLOOKUP(B50,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K49<=10000,IF(K50<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G50,((10000-K49)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K50-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G50)+IF(J50=\"x\",0.05*G50,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G50)","v":0}]
[null,null,{"$f":"IF(B51>0,VLOOKUP(B51,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K50<=10000,IF(K51<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G51,((10000-K50)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K51-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G51)+IF(J51=\"x\",0.05*G51,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G51)","v":0}]
[null,null,{"$f":"IF(B52>0,VLOOKUP(B52,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K51<=10000,IF(K52<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G52,((10000-K51)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K52-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G52)+IF(J52=\"x\",0.05*G52,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G52)","v":0}]
[null,null,{"$f":"IF(B53>0,VLOOKUP(B53,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K52<=10000,IF(K53<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G53,((10000-K52)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K53-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G53)+IF(J53=\"x\",0.05*G53,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G53)","v":0}]
[null,null,{"$f":"IF(B54>0,VLOOKUP(B54,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K53<=10000,IF(K54<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G54,((10000-K53)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K54-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G54)+IF(J54=\"x\",0.05*G54,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G54)","v":0}]
[null,null,{"$f":"IF(B55>0,VLOOKUP(B55,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K54<=10000,IF(K55<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G55,((10000-K54)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K55-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G55)+IF(J55=\"x\",0.05*G55,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G55)","v":0}]
[null,null,{"$f":"IF(B56>0,VLOOKUP(B56,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K55<=10000,IF(K56<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G56,((10000-K55)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K56-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G56)+IF(J56=\"x\",0.05*G56,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G56)","v":0}]
[null,null,{"$f":"IF(B57>0,VLOOKUP(B57,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K56<=10000,IF(K57<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G57,((10000-K56)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K57-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G57)+IF(J57=\"x\",0.05*G57,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G57)","v":0}]
[null,null,{"$f":"IF(B58>0,VLOOKUP(B58,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K57<=10000,IF(K58<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G58,((10000-K57)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K58-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G58)+IF(J58=\"x\",0.05*G58,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G58)","v":0}]
[null,null,{"$f":"IF(B59>0,VLOOKUP(B59,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K58<=10000,IF(K59<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G59,((10000-K58)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K59-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G59)+IF(J59=\"x\",0.05*G59,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G59)","v":0}]
[null,null,{"$f":"IF(B60>0,VLOOKUP(B60,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K59<=10000,IF(K60<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G60,((10000-K59)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K60-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G60)+IF(J60=\"x\",0.05*G60,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G60)","v":0}]
[null,null,{"$f":"IF(B61>0,VLOOKUP(B61,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K60<=10000,IF(K61<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G61,((10000-K60)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K61-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G61)+IF(J61=\"x\",0.05*G61,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G61)","v":0}]
[null,null,{"$f":"IF(B62>0,VLOOKUP(B62,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K61<=10000,IF(K62<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G62,((10000-K61)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K62-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G62)+IF(J62=\"x\",0.05*G62,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G62)","v":0}]
[null,null,{"$f":"IF(B63>0,VLOOKUP(B63,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K62<=10000,IF(K63<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G63,((10000-K62)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K63-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G63)+IF(J63=\"x\",0.05*G63,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G63)","v":0}]
[null,null,{"$f":"IF(B64>0,VLOOKUP(B64,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},"HO","HO - Finance",null,null,{"$f":"IF(K63<=10000,IF(K64<=10000,VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE)*G64,((10000-K63)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,2,FALSE))+((K64-10000)*VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE))),VLOOKUP($G$3,Sheet2!$J$2:$L$3,3,FALSE)*G64)+IF(J64=\"x\",0.05*G64,0)","v":0},null,null,{"$f":"+$G$4+SUM($G$10:G64)","v":0}]
[null,null,{"$f":"IF(B65>0,VLOOKUP(B65,Sheet2!$A$2:$B$39,2,FALSE),\"-\")","v":"-"},null,null,null,null,null,{"$f":"SUM(I9:I64)","v":0}]
["By submitting this claim I confirm that the above expenses have been wholly, necessarily and exclusively incurred in connection with EFHL business.",null,null,null,null,null,"Total Mileage",null,{"$f":"SUM(H9:H64)","v":0}]
[null,null,null,null,null,null,"Total Claim",null,{"$f":"+I65+I66","v":0}]
[]
[]
[]
["Paste copies of your receipts in this box"]

{"sheet":"Sheet3","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":2,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":true,"merged":[[10,13,18,13]]}
["A.Lookup","Account",null,"C.Lookup","Cost Centre",null,"D.Lookup","Department",null,"Lease","Rate1","Rate2",null,"Date"]
["Cleaning Materials",27160,null,"Head Office","HO",null,"HO - Finance","03",null,"Yes",{"$f":"IF(L8=0,0,IF(L9=0,0,IF(L9=1,VLOOKUP(Sheet1!I5,Sheet2!J12:K14,2,FALSE),IF(L9=2,VLOOKUP(Sheet1!I6,Sheet2!J17:K19,2,FALSE),0))))","v":0},{"$f":"+K2","v":0},null,{"$f":"NOW()-95","v":"2025-06-05T14:26:23.840"}]
["Conferences",20220,null,"Cotswold","CW",null,"HO - Homes","04",null,"No",0.45,0.25]
["Data Communications",26010,null,"Eversfield","EF",null,"HO - HR","10"]
["Disposables",27150,null,"Grove Court","GC",null,"HO - Property","11"]
["Dry Cleaning",27140,null,"Halliwell","HW",null,"HO - Premises","12"]
["Equipment - IT H/W",24040,null,"Hampden House","HH",null,"HO - IT","13",null,"Diesel"]
["Equipment - IT S/W",24030,null,"Merlewood","MW",null,"Management","25",null,"Petrol",null,{"$f":"IF(Sheet1!G3=\"Yes\",1,0)","v":0}]
["Equipment Hire",27200,null,"Rashwood","RW",null,"RN","30",null,null,null,{"$f":"IF(Sheet1!I4=\"Diesel\",1,IF(Sheet1!I4=\"Petrol\",2,0))","v":0}]
["Equipment Purchases",24020,null,"Rush Court","RC",null,"CA","32"]
["Fixtures & Fittings",24000,null,"The Lodge","LD",null,"Medical","38",null,"Diesel",null,null,null,"Updated with effect from 01.09.22"]
["Food",27070,null,null,null,null,"Catering","40",null,"<=1600cc",0.12]
["Fuel",27250,null,null,null,null,"Domestic","44",null,"1601-2000cc",0.13]
["Furniture",24010,null,null,null,null,"Laundry","48",null,">2000cc",0.18]
["H&S - First Aid",27170,null,null,null,null,"Premises","55"]
["Hospitality",20290,null,null,null,null,"Employees","70",null,"Petrol"]
["Kitchen supplies",26070,null,null,null,null,"Residents","72",null,"<=1400cc",0.12]
["Materials - General Items",27130,null,null,null,null,"Visitors","74",null,"1401-2000cc",0.14000000000000001]
["Meetings & Events",27230,null,null,null,null,null,null,null,">2000cc",0.22]
["Mobile phones",20260]
["Newspapers etc",27080]
["Organisational Subscriptions",26020]
["Postage",26030]
["Professional memberships",20270]
["Property - Other",21030]
["Residents Drinks",27030]
["Residents Flowers",27020]
["Residents Xmas Fare",27060]
["Residents Xmas Gift",27050]
["Staff Training",20210]
["Stationery (Office Supplies)",26040]
["Sub. - Food & Bev.",20253]
["Sub. - Hotel/Accomd.",20252]
["Sundry",27000]
["Supplies - Other",27120]
["Telephone",26000]
["Training Materials",20211]
["Travel - Other",20250]
["Travel - Own Car Mileage",20251]