{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Servicing BOQ","5Y Pressure testing BOQ"],"read":"whole","date_system":"1900"}

{"sheet":"Servicing BOQ","index":0,"n_rows":43,"n_cols":16,"rows_kept":43,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[7,0,10,0],[7,1,10,1],[12,0,13,0],[12,1,13,1],[23,1,23,4],[24,1,24,4],[25,1,25,4],[27,0,27,8],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4]]}
["BILL OF QUANTITIES"]
["PROJECT NAME - ANNUAL SERVICE ON FIRE PROTECTION EQUIPMENT AT CSIR"]
["DEPARTMENT    -  FACILITIES DEPARTMENT"]
["Item ","Description","Capacity  ","Unit of measure","Quantity","Unit Price\n(Excl. VAT)(Year 1)","Total Price\n(Excl. VAT)(Year 1)","Unit Price (Excl. VAT)(Year 2)","Total Price\n(Excl. VAT) (Year 2)","Unit Price (Excl. VAT)(Year 3)","Total Price\n(Excl. VAT) (Year 3)","Unit Price (Excl. VAT)(Year 4)","Total Price\n(Excl. VAT) (Year 4)","Unit Price (Excl. VAT)(Year 5)","Total Price\n(Excl. VAT) (Year 5)","Service delivery lead times (In working days)"]
[1,"Only noted types of fire protection equipment on the list can be quoted for."]
[2,"Safety File Once off fee"]
[3,"Annual service on fire extinguishers"]
["3.a","Perform annual service on DCP Fire extinguishers","4.5 kg","Ea",1596]
[null,null,"9 kg","Ea",958]
[null,null,"25 kg","Ea",24]
[null,null,"50 kg","Ea",17]
["3.b","Perform annual service on Class D Fire extinguishers","9 kg","Ea",36]
["3.c ","Perform annual service on CO2 Fire extinguishers","2.5 kg","Ea",45]
[null,null,"5 kg","Ea",76]
["3.d","Perform annual service on ceiling units-  DCP ","4.5 kg","Ea",38]
["3.e","Perform annual service on carbinet auto units-  DCP ","2.5 kg","Ea",10]
[4,"Annual service on hose reels"]
["4.a","Perform annual service on hose reels","30m","Ea",411]
[5,"Annual service on fire hydrants"]
["5.a","Perform annual service on  fire hydrants","65mm","Ea",180]
[6,"Annual service on portable fire alarms/horns"]
["6.a","Perform annual service on portable fire alarms/horns",null,"Ea",85]
[7,"Supply and attachment of inspection stickers",null,"Ea",3476]
[null,"SUB-TOTAL",{"$nulls":4},{"$f":"SUM(G5:G23)","v":0},null,{"$f":"SUM(I5:I23)","v":0},null,0,null,{"$f":"SUM(M5:M23)","v":0},null,{"$f":"SUM(O5:O23)","v":0}]
[null,"VAT (15%)",{"$nulls":4},{"$f":"G24*15%","v":0},null,{"$f":"I24*15%","v":0},null,0,null,{"$f":"M24*15%","v":0},null,{"$f":"O24*15%","v":0}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G24:G25)","v":0},null,{"$f":"SUM(I24:I25)","v":0},null,0,null,{"$f":"SUM(M24:M25)","v":0},null,{"$f":"SUM(O24:O25)","v":0}]
[]
["PROVIDE RATE ONLY FOR THE FOLLOWING ITEMS"]
["Item","Description","Unit of measure","Rate per unit (Year 1)",null,"Rate per unit (Year 2)","Rate per unit (Year 3)","Rate per unit (Year 4)","Rate per unit (Year 5)"]
[1,"Travelling cost","KM"]
[2,"Fire Extuinguishers"]
["2.a","Gas recharge/refilling"]
["2.b","Major service which include powder and gas refill/recharge  on used/discharged fire equipment"]
["2.c ","Replacement of discharge pipe/ nozzle"]
["2.d ","5.Replacement of pressure gauge"]
[3,"Fire Hose Reels"]
["3.a","1. Hose reel leak repairs/seal replacement"]
["3.b","2. Hose reel nozzle repairs/ replacement"]
["3.c","3. Hose reel replacement (Condemned/scraped unit)- labour rate"]
[4,"Fire Hydrants"]
["4.a","Leak repairs/seal replacement"]
["4.b","Hydrant valve replacement (Condemned/scraped valve)"]
["4.c","Nozzle/pumper cap replacement"]

{"sheet":"5Y Pressure testing BOQ","index":1,"n_rows":24,"n_cols":16,"rows_kept":24,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[6,0,9,0],[6,1,9,1],[11,0,12,0],[11,1,12,1],[16,1,16,4],[17,1,17,4],[18,1,18,4],[21,0,21,6],[22,3,22,4],[23,3,23,4]]}
["BILL OF QUANTITIES"]
["PROJECT NAME - PRESSURE TESTING ON FIRE PROTECTION EQUIPMENT AT CSIR "]
["DEPARTMENT    -  FACILITIES DEPARTMENT"]
["Item ","Description","Capacity  ",null,"Unit of measure","Rate per unit (Year 1)","Amount (Year 1)","Rate per unit (Year 2)","Amount (Year 2)","Rate per unit (Year 3)","Amount (Year 3)","Rate per unit (Year 4)","Amount (Year 4)","Rate per unit (Year 5)","Amount (Year 5)","Service delivery lead times (In working days)"]
[1,"Only noted types of fire protection equipment on the list can be quoted for."]
[2,"5Yearly pressure testing on fire extinguishers"]
["2.a","Perform 5 yearly pressure testing on DCP Fire extinguishers","4.5 kg",1357,"Ea"]
[null,null,"9 kg",814,"Ea"]
[null,null,"25 kg",20,"Ea"]
[null,null,"50 kg",14,"Ea"]
["2.b","Perform 5 yearly pressure testing on Class D Fire extinguishers","9 kg",30,"Ea"]
["2.c ","Perform 5 yearly pressure testing on CO2 Fire extinguishers","2.5 kg",38,"Ea"]
[null,null,"5 kg",64,"Ea"]
["2.d","Perform 5 yearly pressure testing on ceiling units-  DCP ","4.5 kg",32,"Ea"]
["2.e","Perform 5 yearly pressure testing on carbinet auto units-  DCP ","2.5 kg",8,"Ea"]
[3,"Supply and attachment of inspection stickers",null,2377,"Ea"]
[null,"SUB-TOTAL",{"$nulls":4},{"$f":"SUM(G5:G15)","v":0},null,{"$f":"SUM(I5:I15)","v":0},null,{"$f":"SUM(K5:K15)","v":0},null,{"$f":"SUM(M5:M15)","v":0},null,{"$f":"SUM(O5:O15)","v":0}]
[null,"VAT (15%)",{"$nulls":4},{"$f":"G17*15%","v":0},null,{"$f":"I17*15%","v":0},null,{"$f":"K17*15%","v":0},null,{"$f":"M17*15%","v":0},null,{"$f":"O17*15%","v":0}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G17:G18)","v":0},null,{"$f":"SUM(I17:I18)","v":0},null,{"$f":"SUM(K17:K18)","v":0},null,{"$f":"SUM(M17:M18)","v":0},null,{"$f":"SUM(O17:O18)","v":0}]
[]
[]
["TRAVELLING- Provide rate only"]
["Item","Description","Unit of measure","Rate per unit (Year 1)",null,"Rate per unit (Year 2)","Rate per unit (Year 3)","Rate per unit (Year 4)","Rate per unit (Year 5)"]
[1,"Travelling cost","KM"]