{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["COVER","MAIN BOQ","FORM OF TENDER","variation 1","CALCULATIONS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"COVER","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,5,0],[17,0,38,0]]}
[]
[]
[]
[]
[]
[]
["BILL OF QUANTITIES"]
[]
["FOR"]
[]
["THE PROPOSED CONSTRUCTION OF PIT LATRINES"]
["FOR THE RESETTLEMENT OFFICE"]
["IN"]
["MAYUKWAYUKWA"]
[]
[]
["THE UN HOUSE, ON PLOT No. 20842, ALICK NKATA ROAD, LONG ACRES, LUSAKA."]
[2019]

{"sheet":"MAIN BOQ","index":1,"n_rows":122,"n_cols":6,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["CLIENT","UNDP"]
[]
["ITEM NO","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[]
[null,"Note:"]
[]
[null,"The contractor shall take all due care to provide shoring, needling, strutting and all temporary works necessary for supporting the existing structure in the course of demolitions and construction until it becomes self supporting  All debris should be removed from site as soon as possible to an approved tipping location and levelled and made environmentally safe  The contractor shall hand over to the Employer on site all salvaged demolished materials"]
[]
[null,"Preambles"]
[]
[null,"The substructure has been measured up to and including the surface slab."]
[]
[null,"Unless otherwise stated all excavations shall be in \"pickable materials\" as described."]
[]
[]
[]
[]
[]
[1,"STRUCTURAL STEEL WORK "]
[]
[null,"GENERALLY"]
[]
[null,"All steel work to be done in accordance with SABS 1431 Grade 300W "]
[]
[null,"Before shop painting the steel shall be cleaned off all scale rust, welding slag , oil grease or other foreign material."]
[]
[null,"The contractor's rates should include for painting exposed structural steelwork with 3 coats of gloss paint"]
[]
[null,"Steel Grill gate with hinges fixed to brickwall approx No1 as per drawing detail","item",1,0,{"$f":"D30*E30","v":0}]
[]
[null,"SUPERSTRUCTURE CARRIED TO SUMMARY",null,null,null,{"$f":"SUM(F19:F31)","v":0}]
[]
[2,"CARPENTRY, JOINERY AND IRONMONGERY,METALWORK"]
[]
[null,"Joinery"]
[]
[null,"Solid core flush door with veneered finish as described,all doors to be supplied with monarch pressed steel single rebate as complete with frame "]
[]
[null,"44 mm thick External quality solid hardwood door leaf size 700 mm wide x 1960 mm high complete with all accessories","No",1,0,{"$f":"D40*E40","v":0}]
[]
[null,"Ironmongery"]
[]
[null,"Ironmongery and fixing as described"]
[]
[null,"Lockset as \"Dorma\" with brushed finish handles","No",1,0,{"$f":"D46*E46","v":0}]
[]
[null,"TOTAL CARPENTRY, JOINERY AND IRONMONGERY,METALWORK TO SUMMARY",null,null,null,{"$f":"SUM(F40:F47)","v":0}]
[]
[null,"Sizes are approximate only and measurements on site must be taken before fabrication. Due allowance must be made for tolerances in accordance with the Architec's details."]
[]
[null,"Protection:"]
[]
[null,"The contractor will be required to protect his work during the course of construction, which protection shall be adequate for the purpose and to the full approval of the Architect."]
[]
[null,"Such protection shall only be removed after a written instruction from the Architect."]
[]
[null,"Cleaning:"]
[]
[null,"All work must be cleaned down upon completion. Glazing as installed will not be accepted as clean glass and the contractor must allow for polishing glass as and when instructed by the Architect."]
[]
[3,"PLUMBING INSTALLATIONS"]
[]
[null,"Stainless Steel toilet roller holder","No",1,0,{"$f":"D64*E64","v":0}]
[]
[null,"Builders work in Connection with Plumbing Installations"]
[]
[null,"Include for cutting or forming holes, chases, mortices etc, in concrete, brickwork, blockwork etc, for plumbing installations covered in this section and for making good in all trades described","Item",1,0,0]
[]
[]
[null,"Complete tap system with all necessary connections to from water source to drop points as per draing detail ","item",1,0,{"$f":"D71*E71","v":0}]
[]
[null,"Wash hand basin complete with all fittings and pedastal","No",1,0,0]
[]
[null,"Pvc water closet complete with all fittings built around concrete blocks and pipe works to septic tank and soakaway","item",1,0,0]
[]
[null,"PLUMBING TOTAL CARRIED TO SUMMARY",null,null,null,{"$f":"SUM(F63:F76)","v":0}]
[]
[4,"FLOOR, WALL AND CEILING FINISHINGS"]
[]
[null,"In-situ Finishings"]
[]
[null,"One coat steel float finish cement sand (1:4) rough cast plaster"]
[]
[null,"15 mm to walls internally and externally","m2",60,0,{"$f":"D85*E85","v":0}]
[]
[]
[null,"FLOOR, WALL AND CEILING FINISHINGS CARRIED TO SUMMARY",null,null,null,{"$f":"SUM(F85:F87)","v":0}]
[]
[5,"PAINTING AND DECORATING"]
[]
[null,"'Dulux' or equal and approved One Plaster primer coat and Two finishing coats'Dulux Wash and Wear paint."]
[]
[null,"To plastered walls internally and externally","m2",20,0,{"$f":"D94*E94","v":0}]
[]
[null,"To Grill (0.80m wide x 2m)","item",1,0,{"$f":"D96*E96","v":0}]
[]
[]
[null,"PAINTING AND DECORATING TO SUMMARY",null,null,null,{"$f":"SUM(F94:F98)","v":0}]
[]
[6,"Soakaway Pit"]
[]
[null,"Excavation and construction of soak away pit for pit latrine","item",1]
[]
[null,"Soakaway Pit Summary",null,null,null,{"$f":"SUM(F100:F104)","v":0}]
[]
[1,"SUPERSTRUCTURE WORKS",null,null,null,{"$f":"F32","v":0}]
[]
[2,"CARPENTRY, JOINERY AND IRONMONGERY",null,null,null,{"$f":"F48","v":0}]
[]
[3,"PLUMBING INSTALLATIONS",null,null,null,{"$f":"F77","v":0}]
[]
[4,"FLOOR, WALL AND CEILING FINISHINGS",null,null,null,{"$f":"F88","v":0}]
[]
[5,"PAINTING AND DECORATING",null,null,null,{"$f":"F99","v":0}]
[]
[6,"SOAKAWAY PIT"]
[]
[]
[]
[]
[1,"PIT LATRINE  BILL ","Page",null,null,{"$f":"SUM(F102:F121)","v":0}]

{"sheet":"FORM OF TENDER","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["FORM OF TENDER"]
[]
[null,"SUMMARY","PAGE","DATE","AMOUNT"]
[]
[]
[1,"SUPERSTRUCTURE WORKS","Page","2019-12-07",{"$f":"'MAIN BOQ'!F32","v":0}]
[]
[2,"CARPENTRY, JOINERY AND IRONMONGERY","Page","2019-12-07",{"$f":"'MAIN BOQ'!F48","v":0}]
[]
[3,"PLUMBING INSTALLATIONS","Page","2019-12-07",{"$f":"'MAIN BOQ'!F77","v":0}]
[]
[4,"FLOOR, WALL AND CEILING FINISHINGS","Page","2019-12-07",{"$f":"'MAIN BOQ'!F88","v":0}]
[]
[5,"PAINTING AND DECORATING","Page","2019-12-07",{"$f":"'MAIN BOQ'!F99","v":0}]
[]
[null,"TOTAL BILL",null,null,{"$f":"SUM(E4:E15)","v":0}]
[]
[]
[null,"ADD Ps&Gs @5 %",null,null,{"$f":"5%*E16","v":0}]
[]
[]
[null,"ADD 12% CONTINGENCY",null,null,{"$f":"12%*(E19+E16)","v":0}]
[]
[]
[]
[null,"GRAND TOTAL AS TENDER",null,null,{"$f":"SUM(E16:E25)","v":0}]

{"sheet":"variation 1","index":3,"n_rows":172,"n_cols":7,"rows_kept":172,"cut":false,"hidden":true,"merged":[]}
[null,"Variation for Unicef Main Building to main works"]
[null,"Variation No.1"]
["NO","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["A","Cutting of the existing concrete strip of width 300mm top base and 250mm bottom base and depth 150mm to provide for concrete thickening to support the loadbearing superstructure along the main entrance walls and toilets","M",24.4,150,{"$f":"D4*E4","v":3660}]
["B","Cast concrete strip C25 of width 300mm top base and 250mm bottom base and depth 150mm to provide for concrete thickening to support  the loadbearing superstructure along the main entrance walls and toilets","M",24.4,85,{"$f":"D5*E5","v":2074}]
["C","Provide a 20mm thick expansion joint covering the entire side area of the joining point substructure block work  and filled with flexible material to be approved by the PM","M",10.35,85,879.75]
["D","Cut and dispose","M3",50,80,4000]
["E","Supply and re-route water pipe c/w accessories Excavation and","M",87,30,2610]
[null,"backfilling",null,null,null,0]
[]
["F","Construction of a greenhouse size 6.3m ×4m","item",1,25240,25240]
[]
[]
[null,"Subtotal",null,null,null,{"$f":"SUM(F4:F12)","v":38463.75}]
[]
[null,"Variation No.2"]
[]
["Item","DESCRIPTION","Unit","Qty","Rate","Amount"]
[{"$nulls":5},"K        N"]
[null,"MAIN BUILDING "]
[]
[null,"SUBSTRUCTURE - "]
[]
[null,"EXCAVATIONS AND EARTHWORKS (Returning wall)",null,null,null,{"$f":"IF(D24>0,D24*E24,\"\")","v":""}]
[{"$nulls":5},{"$f":"IF(D25>0,D25*E25,\"\")","v":""}]
[null,"Preambles"]
[]
["(i)","Scope of Work in the substructure section includes work in all trades"]
[null,"in foundations upto the top of the ground floor slab. "]
[]
["(ii)","Unless otherwise described  all excavations shall be in \"pickable"]
[null,"material\" as described"]
[]
[null,"SITE PREPARATIONS"]
[]
["A","Treat the surfaces of hardcore filling, sides and bottoms of"]
[null,"excavations with approved environmentally friendly  antproofing","m2",63,7,{"$f":"D37*E37","v":441}]
[null,"treatment as described"]
[]
["B","Excavate to remove soil  average 1200mm deep and wheel, spread","m3",25,47.5,{"$f":"D40*E40","v":1187.5}]
[null,"and level on site where directed."]
[]
["C","Load and transport surplus excavated materials to an authorized","m3",{"$f":"D40","v":25},57,1425]
[null,"disposal site."]
[]
[null,"Concrete"]
[]
[null,"Vibrated cement concrete grade 20/20mm maximum"]
[null,"aggregate as described"]
[]
["D","100mm thick to drain","m3",3,1235,3705]
[]
["E","100mm thick to Apron","m3",4,1235,4940]
[]
[null,"Walling"]
[]
[null,"Load bearing solid concrete block  walling filled with plain"]
[null,"concrete mix 15/20,3.5N/mm2 strength,bedded and "]
[null,"pointed in cement mortar 1:4 as described"]
[]
["F","150mm walls","m2",42,133,5586]
[]
[null,"Reinforcement to walling"]
[]
["G","Y12 Bars","Kg",998,17.100000000000001,17065.800000000003]
[]
["H","1.5m Brick force ","m",126,5.7,718.2]
[]
[null,"One coat 19mm cement and sand (1:4) rendering wood "]
[null,"float finished on the following:"]
[]
["J","Plinth walls","m2",42,33.25,1396.5]
[]
[{"$nulls":5},{"$f":"SUM(F37:F73)","v":36465}]
[]
[null,"ROOFING"]
[]
[null,"IBR Roof  (0.6gauge ) on 75 x 50 purlins approx 900 c/c  on"]
[null,"150 x 150mm sw trusses  according to manufacture's"]
[null,"instructions/ measured including laps and all labours to"]
[null,"roofing sheets, closers,etc"]
[]
["A","Flashing to roof ","m",180,125,22500]
[]
["B","Flashing to wall","m",{"$f":"41+40","v":81},125,10125]
[]
[{"$nulls":5},{"$f":"SUM(F82:F86)","v":32625}]
[null,"Walk way"]
[]
["A","Include for re-installation of steel support to walkway","item",1,22500,{"$f":"E90","v":22500}]
[]
[null,"ALUMINIUM WORK",null,null,null,{"$f":"SUM(F90)","v":22500}]
[]
["A","Demolition of 1200 x 1000mm blockwork  to create opening ","no.","1",{"$f":"1.2*1*50","v":60},{"$f":"D94*E94","v":60}]
[]
["B","1200 x 1000mm window","no.",1,{"$f":"1.2*1*2375","v":2850},{"$f":"D96*E96","v":2850}]
[]
[{"$nulls":5},{"$f":"SUM(F94:F96)","v":2910}]
[]
[null,"Electrical "]
[]
["A","4-CORE, 35mmsq. PVC/SWA/PVC + 35mmsq. BCEW, as ZAMEFA,"]
[null,"From Existing Main Electrical Panel to DB-E1 (installation shall only","m",67,398,{"$f":"D103*E103","v":26666}]
[null,"be upon approval from Electrical Engineer and Project Manager)"]
[]
["B","Reducing height for trunking","item",1,1200,{"$f":"D106*E106","v":1200}]
[]
["C","13A Double White Switched Socket Outlet to be place in existing floor box","No.",2,75,{"$f":"D108*E108","v":150}]
[]
["D","Rearranging of wiring to match new partition layout","item",1,2000,{"$f":"D110*E110","v":2000}]
[]
["E","2.5mmsq. Cu/PVC Red single core,  as Live","m","20",22.5,{"$f":"D112*E112","v":450}]
[]
["F","2.5mmsq. Cu/PVC Black single core, as Neutral","m","20",22.5,{"$f":"D114*E114","v":450}]
[]
["G","2.5mmsq. Cu/PVC Green single core, Earth","m","20",22.5,450]
[]
["H","25mmsq. Pvc conduit pipe ","m",10,10,100]
[]
["J","cutting concrete slab 150mm wide and 50mm deep to receive conduit per metre and making good all disturbed works","m",5,80,400]
[]
["K","cutting concrete slab 75mm wide and 50mm deep to receive conduit per metre and making good all disturbed works","m",5,80,400]
[]
["L","Cut to create opening in floor slab to receive floor box size to match existing and make good to all disturbed works","No.",2,80,160]
[]
["M","Cut wall to allow for installation of existing switch and wiring and make good to all disturbed works","m",2,100,{"$f":"D126*E126","v":200}]
[]
[]
[{"$nulls":5},{"$f":"SUM(F103:F127)","v":32626}]
[null,"as at 15.04.2019"]
[]
["A","Supply and installation of kitchen unit","item",1,9912.8700000000008,{"$f":"D132*E132","v":9912.8700000000008}]
[]
["B","supply and installation of mirrors","no. ",2,920,{"$f":"D134*E134","v":1840}]
[]
["C","Supply and installation of door closers","no.",23,1950,{"$f":"D136*E136","v":44850}]
[]
[{"$nulls":5},{"$f":"SUM(F132:F136)","v":56602.87}]
[]
[null,"as at 23.04.2019"]
[]
[null,"Demolition"]
[]
["A","Take down existing 900 x 2000mm door and reinstall on new","no.",2]
[null,"frames"]
[]
["B","Carefully take down existing 900 x 2000 mm door frame and","no.",2]
[null,"prepare to received new frames and make good to disturbed works"]
[]
["C","Carefully create 900 x 2800mm high door opening in dry wall and","no.",1]
[null,"make good to disturbed works "]
[]
[]
[null,"The following in Brick /dish drain"]
[]
["D","Storm water channel 600mm girth consisting  of three rows "]
[null,"concrete bricks laid flat on sand in cement  sand mortar (1:4) to"]
[null,"falls  with side rows set slightly sloping including angles  and end ","m",45]
[null,"flushings up joints  and pointing, excavating shallow  trenches to"]
[null,"falls,well packing   adjacent earth up to edges , wheeling and"]
[null,"depositing surplus excavated material as directed"]
{"$rows_empty":7}
[94,"RATE#",0,null,null,{"$f":"F74+F87+F92+F98+F129+F138","v":183728.87}]
[]
[]
[null,"TOTAL",null,null,null,{"$f":"F14+F169","v":222192.62},222192.62]

{"sheet":"CALCULATIONS","index":4,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
{"$rows_empty":18}
[null,null,null,"ADD","beams",{"$f":"16.46*2","v":32.92},67.099999999999994,{"$f":"F19*G19","v":2208.9319999999998},36,{"$f":"H19*I19","v":79521.551999999996}]
[{"$nulls":4},"column",4,73,{"$f":"F20*G20","v":292},36,{"$f":"H20*I20","v":10512}]
[]
[null,null,null,"cutting and moving canopy",{"$nulls":5},10000]
[{"$nulls":4},"bracings",{"$f":"8*2.504","v":20.032},15,{"$f":"F23*G23","v":300.48},36,{"$f":"H23*I23","v":10817.28}]
[{"$nulls":4},"IPE 200",{"$f":"9*1.23","v":11.07},22.4,{"$f":"F24*G24","v":247.96799999999999},36,{"$f":"H24*I24","v":8926.848}]
[]
[{"$nulls":8},"k",{"$f":"SUM(J19:J24)","v":119777.68}]
[]
[]
[]
[null,null,null,"OMISSION",null,null,null,"beams",null,{"$f":"'[1]Contract BOQ'!$F$70","v":65304}]
[{"$nulls":7},"foundation",null,{"$f":"'[1]Contract BOQ'!$I$54","v":30742.5}]
[{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":7},"254 X146 X31",null,{"$f":"'[1]Contract BOQ'!$F$74","v":14508}]
[{"$nulls":9},{"$f":"SUM(J30:J33)","v":{"$error":"#REF!"}}]
[{"$nulls":8},"k",{"$f":"J26-J34","v":{"$error":"#REF!"}}]