{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Schedule of Works"],"read":"whole","date_system":"1904"}

{"sheet":"Schedule of Works","index":0,"n_rows":65,"n_cols":8,"rows_kept":65,"merged":[[56,2,56,3],[57,2,57,3],[59,2,59,3],[60,2,60,3],[61,2,61,3]]}
[null,"15/1395 The Public Hall, Liskeard (revision 2)",null,null,"Dayworks",null,null,"Rate"]
[{"$nulls":4},"Foreman",null,null,{"v":0,"d":"£0.00"}]
[{"$nulls":4},"Tradesman",null,null,{"v":0,"d":"£0.00"}]
[null,"Valuation no.:",1,null,"Groundworker",null,null,{"v":0,"d":"£0.00"}]
[null,"Valuation Date:","2024-03-05",null,"Unskilled",null,null,{"v":0,"d":"£0.00"}]
[null,"Valuation Issue Date:","2024-03-05",null,"Plant",null,null,"Cost + 0%"]
[{"$nulls":4},"Materials",null,null,"Cost + 0%"]
[{"$nulls":4},"Sub Contract",null,null,"Cost + 0%"]
[null,"(All figures are exclusive of VAT)"]
[null,"(Allow to make good for all works)"]
[null,"Element","Element Total","Notes","Weeks","Progress","Updated This Valuation?","Valuation"]
[{"v":1,"d":"1.00"},"Prelims",{"$nulls":5},{"$f":"ROUND(C12*F12,2)","v":0}]
[1.01,"Supervision ",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C13*F13,2)","v":0}]
[1.02,"Fuel ",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C14*F14,2)","v":0}]
[1.03,"Phone ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.04,"Toilet ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.05,"Small Plant / access equipment ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.06,"Deliveries ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.07,"Waste / Skips ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.08,"Clean ",0,null,null,{"v":0,"d":"0%"},null,0]
[1.09,"Site labourer ",0,null,null,{"v":0,"d":"0%"},null,0]
[{"v":1.1,"d":"1.10"},"Joint names insurance",0,null,null,{"v":0,"d":"0%"},null,0]
[1.11,"Office overheads ",0,null,null,{"v":0,"d":"0%"},null,0]
[{"v":2,"d":"2.00"},"Provisional Sums"]
[2.01,"Contingencies ",{"v":1000,"d":"£1,000.00"},null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C25*F25,2)","v":0}]
[2.02,"Light fitting supply (4 @ £100 ea.)",{"$f":"4*100","v":{"v":400,"d":"£400.00"}},null,null,{"v":0,"d":"0%"},null,0]
[2.03,"Door/window ironmongery supply",{"$f":"2*250","v":{"v":500,"d":"£500.00"}},null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C27*F27,2)","v":0}]
[2.04,"Floor finish supply (40m2  @ £50/m2) ",{"$f":"40*50","v":{"v":2000,"d":"£2,000.00"}},null,null,{"v":0,"d":"0%"},null,0]
[2.05,"Supply & fit blackout roller blinds with pelmet to windows, design TBA by supplier (3 @ £300 ea.)",{"$f":"3*300","v":{"v":900,"d":"£900.00"}},null,null,{"v":0,"d":"0%"},null,0]
[{"v":3,"d":"3.00"},"Works"]
[3.01,"Scaffold / access",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C31*F31,2)","v":0}]
[3.02,"Demolition (client to confirm if keeping Members' Room door for future use elsewhere)",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C32*F32,2)","v":0}]
[3.03,"Fit 4 new pendent lights in positions TBA with 2-way switches adjacent 2 entrance doors, disconnect redundant electrics, works to data by others direct to employer, emergency lighting/sign changes to regs, fit 5no. New recessed double sockets (white MK with outside rockers) & chase walls for cables with recessed conduit runs (1 on north wall west of radiator, 1 on east wall just south of new cupboard, 1 on east wall in SE corner, 2 on south wall each between windows)",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C33*F33,2)","v":0}]
[3.04,"Intruder alarm changes by Waldon Fire & Security to their design",0,null,null,{"v":0,"d":"0%"},null,0]
[3.05,"Fire alarm system changes by Waldon Fire & Security to their design",0,null,null,{"v":0,"d":"0%"},null,0]
[3.06,"Remove redundant cables ouside east window",0,null,null,{"v":0,"d":"0%"},null,0]
[3.07,"Strip wallpaper, make good, prep, hang lining paper & decorate",0,null,null,{"v":0,"d":"0%"},null,0]
[3.08,"Strip polystyrene detailing from Mayor's Parlor ceiling",0,null,null,{"v":0,"d":"0%"},null,0]
[3.09,"Remove & reinstate radiators",0,null,null,{"v":0,"d":"0%"},null,0]
[{"v":3.1,"d":"3.10"},"BWIC with M&E ",0,null,null,{"v":0,"d":"0%"},null,0]
[3.11,"Replace double glazed units in 3no. Vertical sash windows with clear safety glass (6 panes)",0,null,null,{"v":0,"d":"0%"},null,0]
[3.12,"Rehang existing internal door in new doorway & adjust to suit",0,null,null,{"v":0,"d":"0%"},null,0]
[3.13,"New SW boxing to cable at head of door in NE corner, decorated",0,null,null,{"v":0,"d":"0%"},null,0]
[3.14,"New SW cupboard to NE alcove below existing wall cupboard",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C44*F44,2)","v":0}]
[3.15,"Plasterboard/plastering",0,null,null,{"v":0,"d":"0%"},null,0]
[3.16,"Fit new carpet, supply / fit premium underlay / perimeter grippers / threshold trim to match existing in building to suit",0,null,null,{"v":0,"d":"0%"},null,{"$f":"ROUND(C46*F46,2)","v":0}]
[3.17,"Decoration including lining paper to walls",0,null,null,{"v":0,"d":"0%"},null,0]
[{"v":4,"d":"4.00"},"Contractor Profit"]
[4.01,{"v":0,"d":"0.0%"},{"$f":"ROUND(B49*SUM(C13:C47),2)","v":0},null,null,{"v":0,"d":"0.0%"},null,{"$f":"ROUND(C49*F49,2)","v":0}]
["AI 1",null,"NOTES","OMIT","ADD","Progress",null,"Valuation"]
["AI 1.01",null,null,0,0,{"v":0,"d":"0%"},null,{"$f":"ROUND((0-D51+E51)*F51,2)","v":0}]
["AI 1.02",null,null,0,0,{"v":0,"d":"0%"},null,{"$f":"ROUND((0-D52+E52)*F52,2)","v":0}]
["AI 2",null,"NOTES","OMIT","ADD","Progress",null,"Valuation"]
["AI 2.01",null,null,0,0,{"v":0,"d":"0%"},null,{"$f":"ROUND((0-D54+E54)*F54,2)","v":0}]
["AI 2.02",null,null,0,0,{"v":0,"d":"0%"},null,{"$f":"ROUND((0-D55+E55)*F55,2)","v":0}]
["Daywork Sheets",null,"NOTES",null,"ADD","Progress",null,"Valuation"]
[1,{"$nulls":3},0,{"v":0,"d":"0%"},null,{"$f":"ROUND(E57*F57,2)","v":0}]
[2,{"$nulls":3},0,{"v":0,"d":"0%"},null,{"$f":"ROUND(E58*F58,2)","v":0}]
["Materials On Site Not Yet Fixed",null,"NOTES",null,"ADD","Progress",null,"Valuation"]
[1,{"$nulls":3},0,{"v":0,"d":"0%"},null,{"$f":"ROUND(E60*F60,2)","v":0}]
[2,{"$nulls":3},0,{"v":0,"d":"0%"},null,{"$f":"ROUND(E61*F61,2)","v":0}]
[3,{"$nulls":3},0,{"v":0,"d":"0%"},null,{"$f":"ROUND(E62*F62,2)","v":0}]
[]
[null,null,"Contract Sum","OMIT","ADD","Variation",null,"Valuation"]
[null,"Totals (All figures are exclusive of VAT):",{"$f":"SUM(C12:C49)","v":{"v":4800,"d":"£4,800.00"}},{"$f":"SUM(D51:D64)","v":0},{"$f":"SUM(E51:E64)","v":0},{"$f":"E65+D65","v":0},null,{"$f":"SUM(H12:H64)","v":0}]