{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Equipment","Order","EData","OData"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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":"Equipment","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,0,18,7],[3,2,3,4],[5,2,5,3],[15,1,15,2],[16,1,16,2],[17,1,17,2],[14,1,14,2],[9,2,9,7],[11,2,11,7],[9,0,9,1],[11,0,11,1]]}
[null,"Equipment Request Form"]
[]
[]
["Home",null,{"$f":"VLOOKUP(EData!I10,EData!A2:B17,2,FALSE)","v":0}]
[]
["Nature of spend",null,{"$f":"VLOOKUP(EData!I20,EData!H12:I19,2,FALSE)","v":0}]
[]
["In Budget",null,{"$f":"VLOOKUP(EData!I26,EData!H22:I24,2,FALSE)","v":0},null,null,"Type",{"$f":"VLOOKUP(EData!I34,EData!H28:I32,2,FALSE)","v":0}]
[]
["Details of equipment being purchased or repaired"]
[]
["Justification for purchase or repair"]
[]
["Quote details"]
[null,"Supplier  Name",null,"Amount"]
[1]
[2]
[3]
["Three quotes should be obtained for all purchases.  The details of the preferred quote should be entered in row 1 of the table."]
["Please attach any additional supporting documentation to the email before sending for authorisation."]
[{"$f":"\"Approval is required from the \"&EData!F19","v":"Approval is required from the General Manager"}]
[]
[]
[]
[]
[]
["Ver 2025.1"]

{"sheet":"Order","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[13,0,13,1],[13,2,13,7],[15,0,15,1],[15,2,15,7],[3,2,3,4],[9,0,9,1],[9,2,9,7],[11,0,11,1],[11,2,11,7],[7,2,7,3]]}
[null,"Order Request Form"]
[]
[]
["Home",null,{"$f":"VLOOKUP(OData!I10,OData!A2:B20,2,FALSE)","v":"The Lodge"}]
[]
["In Budget",null,{"$f":"VLOOKUP(OData!I26,OData!H22:I24,2,FALSE)","v":"No"}]
[]
["Nature of spend",null,{"$f":"VLOOKUP(OData!I20,OData!H12:I19,2,FALSE)","v":0}]
[]
["Description of order"]
[]
["Justification for order"]
[]
["Supplier"]
[]
["Order Value (Incl VAT)",null,0]
[]
[{"$f":"+Equipment!A27","v":"Ver 2025.1"}]

{"sheet":"EData","index":2,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Lookup","Home","Regional Manager","General Manager","Admin","Chief Executive","Finance Director"]
[1,"Cotswold","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","rares.pop@efhl.co.uk","samantha.weller@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","RM",{"$f":"IF(I10>9,\"\",VLOOKUP($I$10,$A$2:$G$37,3,FALSE))","v":0},"Maint","anthony.barnes@efhl.co.uk"]
[{"$f":"+A2+1","v":2},"Eversfield","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","josephine.gabadmosi@elizabethfinn.co.uk","kate.mcdonald@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Manager",{"$f":"VLOOKUP($I$10,$A$2:$G$17,4,FALSE)","v":0},"Hotel","andrew.rowlands@efhl.co.uk"]
[{"$f":"+A3+1","v":3},"Grove Court","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","kelly.lockwood@efhl.co.uk","sarah.pettitt@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Admin",{"$f":"IF(I10>9,\"\",VLOOKUP($I$10,$A$2:$G$17,5,FALSE))","v":0},"IT","sophia.salem@turn2us.org.uk"]
[4,"Halliwell","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","karl.pay@elizabethfinn.co.uk","shonagh.walker@elizabethfinn.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","CEO",{"$f":"VLOOKUP($I$10,$A$2:$G$17,6,FALSE)","v":0}]
[5,"Merlewood","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","debbie.vellender@efhl.co.uk","claire.davis@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Finance",{"$f":"VLOOKUP($I$10,$A$2:$G$17,7,FALSE)","v":0}]
[6,"Rashwood","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","rachel.wilson@elizabethfinn.co.uk","lucy.reizlein@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk"]
[7,"Rush Court","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","nike.ajewole@elizabethfinn.co.uk","mary.middleton@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Notify",{"$f":"HLOOKUP(F19,A1:G17,(I10+1),FALSE)","v":"General Manager"}]
[8,"The Lodge","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","deborah.skinner@efhl.co.uk","nicola.cheriton@efhl.co.uk","olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","CC",{"$f":"IF(F19=\"General Manager\",I4,I3&\";\"&I4)&IF(I34=1,\";\"&K2,IF(I34=2,\";\"&K3,IF(I34=3,\";\"&K4,\"\")))","v":"0"}]
[9,"HO - Property",null,"anthony.barnes@efhl.co.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Link",0]
[10,"HO - Hotel Services",null,"andrew.rowlands@efhl.co.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk"]
[11,"HO - Finance",null,"olivia.curno@efhl.co.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",1,"New"]
[12,"HO - Homes",null,"jonathan.crisp@efhl.co.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",2,"Replacement"]
[13,"HO - HR",null,"peter.norgate@efhl.co.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",3,"Repair"]
[14,"HO - IT",null,"sophia.salem@turn2us.org.uk",null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",0]
[15,"HO - IT",null,null,null,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk"]
[0,0]
[]
[null,null,null,null,"Approval Route",{"$f":"IF(I26=1,IF(Amount1<=B22,\"General Manager\",IF(Amount1<=B23,\"Regional Manager\",IF(Amount1>B24,\"Chief Executive\",\"Finance Director\"))),IF(Amount1<=B27,\"General Manager\",IF(Amount1<=B28,\"Regional Manager\",IF(Amount1>B29,\"Chief Executive\",\"Finance Director\"))))","v":"General Manager"}]
[null,null,null,null,null,null,null,"Link",0]
[]
["Budget",500,"General Manager",null,null,null,null,1,"Yes"]
[null,1000,"Regional Manager",null,null,null,null,2,"No"]
[null,10000,"Finance Director",null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Link",0]
["No Budget",100,"General Manager"]
[null,500,"Regional Manager",null,null,null,null,1,"Maintenance"]
[null,10000,"Finance Director",null,null,null,null,2,"Hotel Services"]
[null,null,null,null,null,null,null,3,"IT"]
[null,null,null,null,null,null,null,4,"Other"]
[null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Link",0]

{"sheet":"OData","index":3,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Lookup","Home","Regional Manager","General Manager","Department Head","Chief Executive","Finance Director"]
[1,"Cotswold","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","rares.pop@efhl.co.uk",{"$f":"VLOOKUP($I$20,$H$12:$K$15,4,FALSE)","v":0},"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","RM",{"$f":"IF(I10>15,\"\",VLOOKUP($I$10,$A$2:$G$17,3,FALSE))","v":"helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk"}]
[{"$f":"+A2+1","v":2},"Eversfield","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","josephine.gabadmosi@elizabethfinn.co.uk",{"$f":"VLOOKUP($I$20,$H$12:$K$15,4,FALSE)","v":0},"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Manager",{"$f":"VLOOKUP($I$10,$A$2:$G$17,4,FALSE)","v":"deborah.skinner@efhl.co.uk"}]
[{"$f":"+A3+1","v":3},"Grove Court","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","kelly.lockwood@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Dept",{"$f":"IF(I10>15,\"\",VLOOKUP($I$10,$A$2:$G$17,5,FALSE))","v":0}]
[4,"Halliwell","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","karl.pay@elizabethfinn.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","CEO",{"$f":"VLOOKUP($I$10,$A$2:$G$17,6,FALSE)","v":"olivia.curno@efhl.co.uk"}]
[5,"Merlewood","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","debbie.vellender@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Finance",{"$f":"VLOOKUP($I$10,$A$2:$G$17,7,FALSE)","v":"jonathan.crisp@efhl.co.uk"}]
[6,"Rashwood","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","rachel.wilson@elizabethfinn.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk"]
[7,"Rush Court","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","nike.ajewole@elizabethfinn.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Notify",{"$f":"HLOOKUP(F19,A1:G17,(I10+1),FALSE)","v":"deborah.skinner@efhl.co.uk"}]
[8,"The Lodge","helen.grice@efhl.co.uk;james.hamilton@efhl.co.uk","deborah.skinner@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","CC",{"$f":"IF(F19=\"General Manager\",I4,I3&\";\"&I4)&IF(I33=1,\";\"&K2,IF(I33=2,\";\"&K3,\"\"))","v":"0"}]
[9,"HO - Property",null,"anthony.barnes@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk","Link",8]
[10,"HO - Hotel Services",null,"andrew.rowlands@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk"]
[11,"HO - Homes",null,"olivia.curno@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",1,"Marketing ",null,"olivia.curno@efhl.co.uk"]
[12,"HO - Finance",null,"jonathan.crisp@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",2,"Training",null,"emily.duncombe@elizabethfinn.co.uk"]
[13,"HO - HR",null,"peter.norgate@efhl.co.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",3,"Recruitment",null," dianne.giles@efhl.co.uk;james.hamilton@efhl.co.uk;peter.norgate@elizabethfinn.co.uk"]
[14,"HO - IT",null,"sophia.salem@turn2us.org.uk",0,"olivia.curno@efhl.co.uk","jonathan.crisp@efhl.co.uk",0]
[15]
[0,0]
[]
[null,null,null,null,"Approval Route",{"$f":"IF(I26=1,IF(OValue<=B22,\"General Manager\",IF(OValue<=B23,\"Department Head\",IF(OValue>B24,\"Chief Executive\",\"Finance Director\"))),IF(OValue<=B27,\"General Manager\",IF(OValue<=B28,\"Department Head\",IF(OValue>B29,\"Chief Executive\",\"Finance Director\"))))","v":"General Manager"}]
[null,null,null,null,null,null,null,"Link",0]
[]
["Budget",500,"General Manager",null,null,null,null,1,"Yes"]
[0,5000,"Department Head",null,null,null,null,2,"No"]
[null,7500,"Finance Director",null,null,null,null,0]
[]
[null,null,null,null,null,null,null,"Link",2]
["No Budget",100,"General Manager"]
[null,500,"Department Head"]
[null,7500,"Executive"]
[]
[]
[]
[null,null,null,null,null,null,null,null,0]