{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BOQ"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"BOQ","index":0,"n_rows":44,"n_cols":8,"rows_kept":44}
["Grootvlei Power Station"]
["Boiler Torsion Bar Safety Valves Refurbishment"]
[]
["Item","Description","Unit","Quantity "," Rate","Total","No of Years","Total in 4 Years"]
[null,"Section 1"]
[null,"Preliminaries and General"]
[null,"Section 1"]
[]
[null,"Safety"]
["a","Safety File","Sum",{"v":1,"d":"1.00"},null,{"$f":"+E10*D10","v":0},4,{"$f":"+G10*F10","v":0}]
["b","Induction And Medicals","Each",{"v":16,"d":"16.00"},null,{"$f":"+E11*D11","v":0},4,{"$f":"+G11*F11","v":0}]
["c","PPE","Sum",{"v":16,"d":"16.00"},null,{"$f":"+E12*D12","v":0},1,0]
[]
[null,"Facilities"]
["d","Staff Accommodation (As and when required)","Sum",{"v":16,"d":"16.00"},null,{"$f":"+E15*D15","v":0},4,{"$f":"+G15*F15","v":0}]
["e","Consumables (Bolts,Nuts,Gaskets and Seats)","sum",{"v":1,"d":"1.00"},null,{"$f":"+E16*D16","v":0},1,{"$f":"+G16*F16","v":0}]
[]
[]
[null,"Time-Related P&G","Unit","Quantity "," Rate","Total","No of Months","Total in 4 Years"]
["f","Travelling","km",800,null,{"$f":"+E20*D20","v":0},48,{"$f":"+G20*F20","v":0}]
[null,"Sub Total ",{"$nulls":5},{"$f":"+H20+H16+H15+H12+H11+H10","v":0}]
[]
[null,"Description","Unit","Quantity "," Rate","Total per year","No of years","Total in 4 Years"]
[null,"Section 2"]
[null,"Maintenance,Installation and Testing"]
[null,"Boiler Drum Torsion Bar Safety Valve-3 inch"]
[1,"Refurbishment of Boiler Drum torsion Bar Safety Valves (15) per year","No",15,null,{"$f":"+E27*D27","v":0},4,{"$f":"+G27*F27","v":0}]
[2,"Installation of Boiler Drum Torsion Bar Safety Valves (15) per year","No",15,null,{"$f":"+E28*D28","v":0},4,{"$f":"+G28*F28","v":0}]
[3,"Testing Of Boiler Torsion Bar Drum Safety Valves (15) per year","No",15,null,{"$f":"+E29*D29","v":0},4,{"$f":"+G29*F29","v":0}]
[]
[null,"Boiler Super Heat Torsion Bar Safety Vale - 2,5 inch"]
[4,"Refurbishment of Boiler Drum torsion Bar Superheater Safety Valves(6)per year","No",6,null,{"$f":"+E32*D32","v":0},4,{"$f":"+G32*F32","v":0}]
[5,"Installation of Boiler Drum Torsion Bar Safety Valves (15) per year","No",6,null,{"$f":"+E33*D33","v":0},4,0]
[6,"Floating Of Boiler Torsion Bar Superheater Safety Valve (6) per year","No",6,null,{"$f":"+E34*D34","v":0},4,0]
[]
[]
[null,"Lubrications and Inspections"]
[7,"Unit 1- Four times a year","No",4,null,{"$f":"+E38*D38","v":0},4,{"$f":"+G38*F38","v":0}]
[8,"Unit 2 - Four Times a year","No",4,null,{"$f":"+E39*D39","v":0},4,{"$f":"+G39*F39","v":0}]
[9,"Unit 3- Four Times a year","No",4,null,{"$f":"+E40*D40","v":0},4,0]
[]
[null,"Sub Total ",{"$nulls":5},{"$f":"SUM(H24:H41)","v":0}]
[]
[null,"Total",{"$nulls":5},{"$f":"H21+H42","v":0}]