{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Preambles","HVAC","Summary"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Preambles","index":0,"n_rows":20,"n_cols":2,"rows_kept":20}
["ITEM NO","PREAMBLE DESCRIPTION"]
[]
[null,"Supply and Installation Rates to include the following:"]
[]
[{"v":1,"d":"1.00"},"Ducting- Fabricated sheet metal, delivered to site including all flanges, fire dampers, volume dampers, spigots, stiffeners, bends, offsets, tees, reduce pieces, jointing materials, sealants, and hanging material and thermal insulation where required and to comply with the specifications referred to in the general specification. Where transformations occur, the larger size ductwork has been measured through the fitting"]
[{"v":2,"d":"2.00"},"Dampers - smoke and fire dampers shall be deemed to include fusible links with manual overrides and resets, sleeves, frames, supports and flexible connections"]
[{"v":3,"d":"3.00"},"Butterfly dampers - rates for diffusers and grilles to include volume control dampers"]
[{"v":4,"d":"4.00"},"Fresh air and extraction fans are to be supplied complete with fans, sound attenuators, flexible collars, spring supports, all hanging material, a manual five-step transformers for speed control, diffusers, grilles and filters where applicable as per tender drawings and to comply with the specifications refereed to in the general specification"]
[{"v":5,"d":"5.00"},"Fresh air and extraction fans - (All fans to be electro commutated or approved)"]
[{"v":6,"d":"6.00"},"Diffusers and grilles to be VAV and to have a maximum pressure drop of 50Pa (pref 30Pa) unless otherwise specified. These are to be submitted to the architect for final approval"]
[{"v":7,"d":"7.00"},"AC units to be supplied complete with matching refrigeration tubing, wire mesh for refrigeration tubing, refrigerant gas (R410A), tubing support, electrical connections, uPVC drains terminated as per detailed drawings, controls, commissioning and testing."]
[{"v":8,"d":"8.00"},"All AC units to (unless specified) to have a minimum COP of 4. Use one brand for the whole project. "]
[{"v":9,"d":"9.00"},"Testing and commissioning of all air systems. refer to specifications for types of tests to be carried out"]
[{"v":10,"d":"10.00"},"All Ceiling concealed units to be high static pressure of 200Pa or higher and associated ducting to be wrapped with Insulation"]
[{"v":11,"d":"11.00"},"All filters are classified as per EN779 class"]
[{"v":12,"d":"12.00"},"The use of trade names serves to indicate a standard acceptable to the Principal Agent. Any other brand may be used."]
[{"v":13,"d":"13.00"},"For preambles, please refer to attached Mechanical specification. The specification forms an integral part of this document and shall be red in conjuction with this BOQ"]
[{"v":14,"d":"14.00"},"Any discrepancies between the BoQ and the specification, Equipmement data sheets and drawings must be brought to the attentionof the Engineers. Any unpriced items will be assumed as forming part of the overall price and will therefore be deemed included."]
[{"v":15,"d":"15.00"}]
[{"v":16,"d":"16.00"},"Tenderers are instructed to refer to the drawings, specification documentation, associated reference material and equipment data sheets when pricing the respective bills of quantity items and descriptions"]

{"sheet":"HVAC","index":1,"n_rows":231,"n_cols":6,"rows_kept":231,"merged":[[0,0,0,5],[1,0,1,5],[51,0,51,4],[52,0,52,4]]}
["HVAC BOQ"]
["THE BOQ MUST BE READ IN CONJUCTION WITH THE TECHNICAL SPECIFICATION AND DRAWINGS"]
["ITEM NO","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[{"v":1,"d":"1.0"},"Supply and install the following inverter type DX split AC units, complete with matching refrigerant tubing, condensate drainage, mounting brackets, thermostats, remote controllers, electronic and electrical wiring up to isolator and ALL MOUNTING ACCESSORIES NECESSARY"]
[1.1,"Ducted split unit, cooling load 30kW with heating","no",1]
[1.2,"Ducted split unit, cooling load 22kW with heating","no",1]
[1.3,"Refrigerant piping as per manufacturers recommendation","Item",1]
[1.4,"dia 32 uPVC drainage piping including bends","m",12]
[1.5,"200 wide heavy duty welded wire mesh including supports","m",8]
[]
[{"v":2,"d":"2.0"},"Humidifier"]
[2.1,"0.55kg/hr Ultrasonic humidifier +/-1% Precision wall mounted and complete with filter, isolation valve, automatic water inlet mode and humidity sensor.","no",1]
[]
[{"v":3,"d":"3.0"},"Air Terminals"]
[3.1,"500mm x 250mm  aluminium duct mounted supply air diffusers complete with opposed blade dampers","no",10]
[3.2,"350mm x 200mm  aluminium duct mounted supply air diffusers complete with opposed blade dampers","no",8]
[]
[{"v":4,"d":"4.0"},"Supply and install the following insulated galvanised mild steel ducting as per ANSI/SMACNA (sheet metal and air conditioning contractors national associations) and technical specification, complete with hangers, duct sealing and all mounting accessories and fittings"]
[4.1,"600x600mm","m",3]
[4.2,"600mmø","m",4]
[4.3,"500mmø","m",9]
[4.4,"450mmø","m",5]
[4.5,"400mmø","m",10]
[4.6,"350mmø","m",8]
[4.7,"300mmø","m",3]
[4.8,"250mmø","m",3]
[4.9,"Duct fittings and accessories as per drawings provided","lumpsum",1]
[]
[{"v":4,"d":"4.0"},"Electrical Installation for HVAC"]
[null,"Supply and install Electrical installation and wiring, etc., complete for HVAC units, including local starter/isolator switches and fire alarm interface","Item",1]
[]
[{"v":5,"d":"5.0"},"Building Up Openings"]
[null,"Brickwork in NFP bricks in class II mortar in building up openings"]
[5.1,"One brick wall including plaster","m2",8.3]
[]
[{"v":6,"d":"6.0"},"Glazing"]
[6.1,"Panes exceeding 0,1m² and not exceeding 0,5m² ","m2",45]
[]
[{"v":7,"d":"7.0"},"Demolition"]
[7.1,"Remove 4 (four) window mounted fans located in the CSIR Archive and prepare window frame for installationof window panes.","No",4]
[]
[{"v":8,"d":"8.0"},"Decommission existing HVAC system and remove all associated components and store them in storage provided by Client","Item",1]
[]
[{"v":9,"d":"9.0"},"General"]
[9.1,"Testing and commisioning of the above system to the complete satisfaction of the Mechanical engineer and Client","item",1]
[9.2,"Preparation and supply of handover documents","item",1]
[9.3,"Production of shop drawings and schematics","item",1]
[9.4,"Allow for defects and maintenance of the installation works after practical completion for a period of 12 months","item",1]
[9.5,"Allow for the submittal of test schedules as stated in the specification","item",1]
[]
["Total Carried Over to the Summary",{"$nulls":4},{"$f":"SUM(F6:F51)","v":0}]
{"$rows_empty":178}
[{"$nulls":5},{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Summary","index":2,"n_rows":21,"n_cols":3,"rows_kept":21}
["CLIENT:","COUNCIL FOR SCIENTIFIC AND INDUSTRIAL RESEARCH"]
["PROJECT:","BUILDING 3 HVAC INSTALLATION"]
["CONTRACT:","MECHANICAL SERVICES"]
["ITEM NO","DESCRIPTION","AMOUNT "]
[]
[null," FINAL SUMMARY PAGE"]
[]
[null,"PRELIMINARIES AND GENERAL CONDITIONS OF THE CONTRACT"]
[]
["A","Ps and Gs"]
[]
[null,"MAIN BUILDING MECHANICAL SERVICES INSTALLATION"]
[]
[]
["B","HVAC BLOCK A ICU",{"$f":"HVAC!F52","v":0}]
[]
[null,"TOTAL FOR HVAC",{"$f":"C15+C10","v":0}]
[]
[null,"ADD VAT @ 15 %",{"$f":"C17*0.15","v":0}]
[]
[null,"TOTAL",{"$f":"C19+C17","v":0}]