{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ALTERNATIVE SANITATION BOQ","RATE BASED BOQ"],"read":"whole","date_system":"1900"}

{"sheet":"ALTERNATIVE SANITATION BOQ","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[0,0,0,7],[22,1,22,6],[23,1,23,6],[24,1,24,6]]}
["34026-5W ALTERNATIVE SANITATION TECHNOLOGY BILL OF QUANTITIES"]
[]
[{"$nulls":7},"Tendered"]
["Item","Description: Supply & Erect Community Cast ","Unit","Qty","YEAR 1","YEAR 2","YEAR 3","AVG Total"]
[{"$nulls":7},"(YEAR 1+ YEAR 2+YEAR 3)÷3"]
[1,"Top Structure with Door sill Columns","Each",1,{"$nulls":3},{"$f":"(E6+F6+G6)/3","v":0}]
[2," Eco Pit/s Set with corner joints & stay pipe","Each",1,{"$nulls":3},{"$f":"(E7+F7+G7)/3","v":0}]
[3,"Easy Switch Plumbing Outlet Set","Each",1,{"$nulls":3},0]
[4,"Agrément approved Easy Flush pedestal & flange set","Each",1,{"$nulls":3},0]
[5,"Agrément approved pedestal Babyseat ","Each",1,{"$nulls":3},0]
[6,"Agrément approved Polymer door & Latch","Each",1,{"$nulls":3},0]
[7,"25L Pour Flush bucket with lid & 5L scoop bucket","Each",1,{"$nulls":3},0]
[8,"10L Handwash unit with tip tap and mounting ","Each",1,{"$nulls":3},0]
[9,"40L Flushing reservoir / hand wash station upgrade","Each",1,{"$nulls":3},0]
[10,"Rain water harvester system","Each",1,{"$nulls":3},0]
[11,"Modify outflow system to a underground system & construct pits at 1050mm below NGL instead of 650mm","Each",1,{"$nulls":3},0]
[12,"Supply and Incorporate vent valve for pits","Each",1,{"$nulls":3},0]
[13,"Sub floor supply & install to raise floor surface to NGL + 100mm","Each",1,{"$nulls":3},0]
[14,"Upgrade of flush rope system to 5mm nylon pull rope & handle","Each",1,{"$nulls":3},0]
[15,"Attachment of lid to 10L hand wash reservoir to prevent loss","Each",1,{"$nulls":3},0]
[16,"Attachment of filler cap grill to 40L reservoir to prevent loss","Each",1,{"$nulls":3},0]
[17,"Deliver and construction component","Each",1,{"$nulls":3},0]
[null,"Sub total amount for the Unit",{"$nulls":5},{"$f":"SUM(H6:H22)","v":0}]
[null,"15% V.A.T ",{"$nulls":5},{"$f":"H23*15/100","v":0}]
[null,"*Total incl. V.A.T",{"$nulls":5},{"$f":"SUM(H23:H24)","v":0}]

{"sheet":"RATE BASED BOQ","index":1,"n_rows":60,"n_cols":6,"rows_kept":60,"merged":[[0,0,0,5],[24,1,24,2],[25,0,26,0],[25,1,25,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[43,1,43,2]]}
["GLOSSARY OF ITEMS THAT MAY BE REQUIRED (AS AND WHEN NECESSAY)"]
[]
["Item","Description","Unit","Qty","Rate"]
["B","SCHEDULE B: SITE CLEARANCE "," "," "," "," "]
["B1.1","Remove and grub large trees and tree stumps of girth"," "," "," "," "]
["B1.1.1","Over and Up to"," "," "," "," "]
[" ","a) 1,01 m 2,00 m","No",1," ","Rate Only "]
[" ","b) 2,01 m 3,00 m","No",1," ","Rate Only "]
["B1.2","Remove and grub all trees and tree stumps regardless of the girth (incl. bamboo)","No.",1," ","Rate Only "]
["B1.3","Take down existing fences","m",1," ","Rate Only "]
["B1.4","Demolish and remove structures/ buildings and dismantle to facilitate new works, etc","No.",1," ","Rate Only "]
["B1.5","Concrete Structures ","m³",1," ","Rate Only "]
["B1.6","Brickwork","m³",1," ","Rate Only "]
["B1.7","Provisional sum for the provision of VTS Trucks for the removal of waste from pits that are full and pose a health threat to the household","No.",1," ","Rate Only "]
["B1.8","Transport materials and debris to unspecified sites and dump (Provisional)","m³.km",1," ","Rate Only "]
["B1.9","Remove topsoil to nominal depth of 150 mm and stockpile","m³",1," ","Rate Only "]
["B1.10","Topsoiling","m³",1," ","Rate Only "]
["B1.11","Remove and re-erect existing fences ","m",1," ","Rate Only "]
[]
[" "]
[" "]
[" "]
[" "]
["ITEM","DESCRIPTION","UNIT","QTY","RATE"]
["  ","  ",null," "," "," "]
["C ","SCHEDULE C: TECHNOLOGY SPECIFIC ",null," "," "," "]
[null,"WORKS "]
["  ","  ",null,"  "," ","  "]
["C1.1 ","EXCAVATION ANCILLARIES ",null,"  "," ","  "]
["C1.1.1 ","Make up deficiency in backfill material",null," "," ","  "]
["  ","a) From other necessary excavations on site","m³",1,null,"Rate Only "]
["  ","b) From designated borrow pits","m³",1,null,"Rate Only "]
["  ","c) From commercial sources","m³",1,null,"Rate Only "]
["  ","  ",null,"  ",null,"  "]
["C1.1.2 ","EXISTING SERVICES ",null,"  ",null,"  "]
["  ","a) Services that intersect a trench",null," ",null,"  "]
["  ","(i) Water main pipes","No",1,null," Rate Only "]
["  ","(ii) Water erf connections","No",1,null," Rate Only "]
["  ","(iii) Low-voltage  electrical (underground) cables","No",1,null," Rate Only "]
["  ","b) Services that adjoin a trench"]
["  ","(i) Water erf connections","m",1,null," Rate Only "]
["  ","(ii) Low-voltage  electrical (underground) cables","m",1,null," Rate Only "]
["  ","  ",null,"  ",null,"  "]
["C3 ","MISCELLANEOUS SUNDRY SUPPLIES  ",null,"  ",null,"  "]
["  ","Supply and deliver, install into the works as  may be directed by the Engineer",null,"  ",null,"  "]
["C3.1","M150 Concrete Blocks delivered to each site","No.",1,null,"Rate only "]
["C3.2","Cement 50kg pkt","No.",1,null,"Rate only "]
["C3.3","Building Sand","No.",1,null,"Rate only "]
["C3.4","Brickforce","No.",1,null,"Rate only "]
["C3.5","River Sand","No.",1,null,"Rate only "]
["C3.6","Flushing mechanism with suitable omponents","No.",1,null,"Rate only "]
["C3.7","Approved Toilet Pedestal with Child Seat & Components","No.",1,null,"Rate only "]
["C3.8","5L Hand Wash Facility with Tip Tap","No.",1,null,"Rate only "]
["C3.9","20 litre bucket ","No.",1,null,"Rate only "]
["C3.10","2 litre jug","No.",1,null,"Rate only "]
["C3.11","110mm PVC Sewer Pipe AG (6m lengths)","No.",1,null,"Rate only "]
["C3.12","110mm 90° inspection eye horn bend","No.",1,null,"Rate only "]
[]
[" "]
[" "]