{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["COVER PAGE","INDEX","02NOTES TO TENDERER","03PRELIMINARY AND GENERAL","04FIRST FLOOR NORTH","05FIRST FLOOR SOUTH","06BUILDERS WORK","07COLLECTION"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"COVER PAGE","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[1,2,1,4],[15,0,15,4],[17,0,17,4],[19,0,19,4],[25,1,25,2],[28,1,28,2],[31,1,31,2]]}
[]
[null,null,"SECTION 400 - 00 - BILL OF QUANTITIES"]
{"$rows_empty":13}
["SECTION  400 - BILL OF QUANTITIES"]
[]
["REV - 0"]
[]
["HVAC ADDITIONS & ALTERATIONS - NECSA AREA 26 FIRST FLOOR OFFICES"]
[]
[]
[]
[]
[]
[null,"The tendered rates shall include full compensation for the installation as specified inclusive of profit and mark-up. "]
[]
[]
[null,"The tender shall be for a fixed price contract."]
[]
[]
[null,"Tender prices should include an allowance for work to commence after hours and on weekends (site is an addition to an existing hospital)"]

{"sheet":"INDEX","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[0,0,0,4],[2,0,2,4],[4,0,4,4]]}
["INDEX"]
[]
["HVAC INSTALLATION"]
[]
["SECTION 400 - BILL OF QUANTITIES"]
[{"$nulls":4},"PAGE"]
[null,"400-02","GENERAL NOTES TO TENDERER",null,1]
[]
[null,"400-03","PRELIMINARY AND GENERAL",null,6]
[]
[null,"400-04","FIRST FLOOR NORTH",null,10]
[]
[null,"400-04","FIRST FLOOR SOUTH",null,10]
[]
[null,"400-05","COLLECTION",null,17]

{"sheet":"02NOTES TO TENDERER","index":2,"n_rows":217,"n_cols":4,"rows_kept":217,"merged":[[0,0,0,5],[3,0,3,5],[5,0,5,5],[7,0,7,5],[9,0,9,5],[11,0,11,5],[13,0,13,5],[15,0,15,5],[17,0,17,5],[19,0,19,5],[21,0,21,5],[23,0,23,5],[25,0,25,5],[27,0,27,5],[29,0,29,5],[31,0,31,5],[33,0,33,5],[35,0,35,5],[37,0,37,5],[133,0,133,5],[135,0,135,5],[137,0,137,5],[146,0,146,5],[148,0,148,5],[150,0,150,5],[161,0,161,5],[163,0,163,5],[171,0,171,5],[173,0,173,5],[175,0,175,5],[184,0,184,5],[186,0,186,5],[197,0,197,5],[199,0,199,5],[201,0,201,5],[212,0,212,5],[214,0,214,5],[216,0,216,5]]}
["SECTION 400-02 - BILL OF QUANTITIES"]
["GENERAL NOTES TO TENDERER"]
[]
["GENERAL NOTES FOR BILLS OF QUANTITIES FOR THE UPGRADE AND ADDITIONS TO NECSA AREA 26"]
[]
["The Bills of Quantities form part of, and must be read in conjunction with, the specification and drawings, which document contains the full descriptions of the work to be done and material and equipment to be used and, unless otherwise described in the Bills of Quantities, reference should be made to the Specification for the full meaning of descriptions of work to be done and materials and equipment to be used in this service."]
[]
["No alteration, erasure or addition is to be made in the typed text of the Bills of Quantities.  Should any alteration, erasure or addition be made other than in the areas allowed for this, it will not be recognised but the original wording of the Bill of Quantities will be adhered to."]
[]
["The Priced Bills of Quantities of the successful Tenderer will be checked and the Engineer reserves the right to call for adjustments to any individual price and to rectify any discrepancy whilst the total Tender Price, as submitted, remains unaltered."]
[]
["The responsibility for the accuracy of the quantities written into the Bills by the tenderer remains with the Tenderer.  The Tenderer shall not be relieved of responsibility for measuring quantities at the Tender stage, and the Tender Sum submitted shall be in respect of the quantities set out in the Bills of Quantities.  The Tenderer shall be required to make his assessment of components such as brackets, fixing, etc., from details stated in the Bills and shall include in the item prices for such small installation materials as are required for complete installation in accordance with the Specification."]
[]
["The successful Tenderer and the Employer or his Agent may agree that the total of the Bill or Bills, including any variations by way of additions thereto or deductions therefrom, represents a fair and accurate quantification of the items set out in the Bills and the parties may agree to final payment on that basis.  In the event of any dispute as to the quantities, then the disputed item or items shall be adjusted where necessary by the Engineer."]
[]
["The quantities in these Bills of Quantities are not to be used for ordering materials."]
[]
["Variations in the scope and extent of the work included in the Bills shall be allowed to meet the Employer's requirements and shall be measured and costed at rates entered in the Bills, where appropriate, and shall form an addition to or deduction from the total of the Bills.  Any items or variation for which rates have not been included in the Bills shall be agreed and priced as non-scheduled items, in accordance with the provisions of the Contract."]
[]
["The rules governing the extent and costing of the variation shall be those provided for in the Conditions of Contract form."]
[]
["Variations to the planning before the work has been executed shall be priced as above.  Alterations to work already executed cannot necessarily be priced as above and must be reviewed on their merits."]
[]
["Unless a separate rate for the supply and for the installation of any item is specifically called for, the supply and installation costs of any item shall be fully included in the unit price."]
[]
["The description of each item shall, unless otherwise stated herein, be held to include making, conveying and delivering, unloading, storing, unpacking, hoisting, setting, fitting and fixing in position, cutting and waste, patterns, models and templates, plant, temporary works, return of packings, establishment charges, profit and all other obligations arising out of the Conditions of Contract."]
[]
["All measurements are net, unless otherwise stated, and Tenderers must allow in the rate for wastage."]
[]
["All provisional sums shall be expended as directed by the Engineer and any balance remaining shall be deducted from the amount of the Contract Sum."]
[]
["All items described as \"Provisional\" shall be measured as executed and paid for according to prices in the Bills of Quantities and any unexpended amounts shall be deducted from the amount of the Contract Sum.  No work for which \"Provisional\" items are provided shall be commenced without written instructions from the Engineer."]
[]
["It is a requirement of the Contract that the work shall be carried out in the manner, which is most economical on materials.  Unless detailed by the Engineer, the electrician is required to use the shortest practical route for conduits and cables, subject to the restrictions of the specification and good electrical practice."]
[]
["Any work for which a budgetary allowance has been made, shall be priced in terms of the n/s agreement. Any balance remaining shall be deducted from the budgetary allowance in the n/s contract sum."]
[]
["Where escalation is calculated in terms of the JBCC formula all non-scheduled item prices must be de-escalated to the base date."]
[]
["400.0.00.0","Preliminaries",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all preliminaries"]
[]
["Item",null,null,"Unit"]
[".00.02","Site establishment costs",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all site establishment cost for the duration of the entire project. "]
[]
["Item",null,null,"Unit"]
[".00.03","Programming of the works co-ordination and attending progress meetings",null,"lump sum"]
[null,"The tendered sum shall include full compensation for programming of the works co-ordination and attending progress meetings for the duration of the entire project. "]
[]
["Item",null,null,"Unit"]
[".00.04","Management and programming of the works",null,"lump sum"]
[null,"The tendered sum shall include full compensation for management and programming of the works as specified for the duration of the entire project. "]
[]
["Item",null,null,"Unit"]
[".00.05","Insurances as required by the contract",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all required rigging and hoisting."]
[]
["Item",null,null,"Unit"]
[".00.06","3 complete sets of operating and maintenance manuals",null,"lump sum"]
[null,"The tendered sum shall include full compensation for complete O&M manuals as per the specifications. "]
[]
["Item",null,null,"Unit"]
[".00.07","Testing, balancing, commissioning and handover",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all testing and commissioning. "]
[]
["Item",null,null,"Unit"]
[".00.08","Protection against possible damage to equipment",null,"lump sum"]
[null,"The tendered sum shall include full compensation for possible damage to equipment as per the specifications. "]
[]
[]
[]
[]
["Item",null,null,"Unit"]
[".00.09","Cleaning and start-up of the installation",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all cleaning and start-up. "]
[]
["Item",null,null,"Unit"]
[".00.10","Providing and implementing an approved quality insurance/quality control system",null,"lump sum"]
[null,"The tendered sum shall include full compensation for a quality insurance system approved by the engineer."]
[]
["Item",null,null,"Unit"]
[".00.11","One year comprehensive maintenance and guarantees",null,"lump sum"]
[null,"The tendered sum shall include full compensation for a 12 month guarantee and maintenance on the entire system. "]
[]
["Item",null,null,"Unit"]
[".00.12","Training of personnel",null,"lump sum"]
[null,"The tendered sum shall include full compensation for training of personal as specified. "]
[]
["Item",null,null,"Unit"]
[".00.13","Performance security costs",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all performance security costs. "]
[]
["Item",null,null,"Unit"]
[".00.14","Preparation of shop drawings, equipment submissions",null,"lump sum"]
[null,"The tendered sum shall include full compensation for complete shop drawings and equipment submissions as specified. "]
[]
["Item",null,null,"Unit"]
[".00.15","Submission of samples",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all submission of samples"]
[]
["Item",null,null,"Unit"]
[".00.16","Preparation and submission of \"As built\" drawings",null,"lump sum"]
[null,"The tendered sum shall include full compensation for complete as built drawings as specified. "]
[]
["Item",null,null,"Unit"]
[".00.17","Labelling",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all required labelling as per the specifications and the drawings. "]
[]
["Item",null,null,"Unit"]
[".00.18","Traveling",null,"lump sum"]
[null,"The tendered sum shall include full compensation for traveling for the duration of the entire project. "]
[]
["Item",null,null,"Unit"]
[".00.19","Hoisting and Rigging",null,"lump sum"]
[null,"The tendered sum shall include full compensation for all required rigging and hoisting."]
[]
[]
[]
[]
["Item",null,null,"Unit"]
[".00.20","Safety File",null,"lump sum"]
[null,"The tendered sum shall include full compensation for a safety file as per Life Healthcare standard."]
[]
["Item",null,null,"Unit"]
["400.0.01.00","Ducting"]
[".01.01","(Rectangular Ducting)"]
[".01.01","(Ducting Category)",null,"square meters (m²)"]
[".01.02","(Round Ducting)"]
[".01.02","(Ducting Category)",null,"length (m)"]
[".01.03","etc. for other duct categories",null,"square meters (m²) / length (m)"]
[".01.03","etc. for other duct types"]
[]
["The unit of measurement for rectangular ducting shall be the square meters of each type and category constructed and completed as shown on the Drawings and as specified.  The unit of measurement for round ducting shall be the length in meters of each type and category constructed and completed as shown on the Drawings and as specified.\n"]
[]
["The assignment of categories is per the SMACNA standard.  The quantity represents the total duct area/length for a particular type of ducting and category, measured over bends, transformations and other fittings.  The tendered rate should not allow for fitting extra-over’s, these are itemised separately.  "]
[]
["The tendered rates shall include full compensation for the installation of the ducting, including the supply of all materials, cutting, installing, jointing, and brackets. "]
[]
["Item",null,null,"Unit"]
["400.0.02.00","Duct Fittings"]
[".02.01","(Ducting Category)"]
[".02.01","(Type of Duct Fitting)",null,"number (No)"]
[".02.02","etc. for other duct fittings",null,"number (No)"]
[".02.02","etc. for other duct categories"]
[]
["The unit of measurement shall be the number of each fitting (type and category) constructed and completed as shown on the Drawings and as specified."]
[]
["The assignment of categories is per the SMACNA standard.  The quantity represents the total number of fittings extra-over’s for a particular type of ducting and category.  The fitting-duct area is allowed for in the ducting section."]
[]
["The tendered rate is an extra-over and should include full compensation for additional labour, vanes, etc. relating to the particular fitting. "]
[]
["Item",null,null,"Unit"]
["400.0.03.00","Duct Insulation"]
[".03.01","(External Insulation)"]
[".03.01","(Insulation Thickness)",null,"square meters (m²)"]
[".03.02","(Internal Insulation)"]
[".03.02","(Insulation Thickness)",null,"square meters (m²)"]
[".03.03","etc. for other thicknesses",null,"square meters (m²)"]
[".03.03","etc. for other insulation types"]
[]
["The unit of measurement for duct insulation shall be the square meters of each type and thickness constructed and completed as shown on the Drawings and as specified.  "]
[]
["The tendered rates shall include full compensation for the installation of the insulation, including the supply of all materials, cutting, installing, jointing, and fastening."]
["Item",null,null,"Unit"]
["400.0.04.00","Duct Accessories"]
[".04.01","(Type of Duct Accessory)"]
[".04.01","(Size of the Duct Accessory)",null,"number (No)"]
[".04.02","etc. for other duct accessory sizes",null,"number (No)"]
[".04.02","etc. for other duct accessory types"]
[]
["The unit of measurement shall be the number of each duct accessory constructed and completed as shown on the Drawings and as specified."]
[]
["The quantity represents the total number of duct accessories for a particular type and size."]
[]
["The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each accessory, as specified and approved by the Engineer."]
[]
["Item",null,null,"Unit"]
["400.0.05.00","Condensate Piping"]
[".05.01","(Type of Piping Material)"]
[".05.01","(Nominal Diameter of the Piping)",null,"length (m)"]
[".05.02","etc. for other pipe nominal diameters",null,"length (m)"]
[".05.02","etc. for other pipe materials"]
[]
["The unit of measurement shall be the metre of each size of condensate pipe installed as shown on the Drawings and as specified."]
[]
["The tendered rates shall include full compensation for the installation of the condensate pipes, including the supply of all materials, cutting, installing, jointing, and brackets. The tendered rate shall also include full compensation for stop ends, elbow, tees, reducers, etc., and any other work necessary for installing the condensate piping as specified."]
[]
["Item",null,null,"Unit"]
["400.0.06.00","Air Terminals"]
[".06.01","(Type of Air Terminal)"]
[".06.01.01","(Sub Type of Air Terminal)"]
[".06.01","(Size of the Air Terminal)",null,"number (No)"]
[".06.02","etc. for other air terminal sizes",null,"number (No)"]
[".06.02.01","etc. for other air terminal sub types"]
[".06.02","etc. for other air terminal types"]
[]
["The unit of measurement shall be the number of each air terminal constructed and completed as shown on the Drawings and as specified."]
[]
["The quantity represents the total number of air terminals for a particular type, sub type and size."]
[]
["The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each terminal, as specified and approved by the Engineer."]
[]
["Item",null,null,"Unit"]
["400.0.07.00","Mechanical Equipment"]
[".07.01","(Type of Mechanical Equipment)"]
[".07.01.01","(Sub Type of Mechanical Equipment)"]
[".07.01","(Size of the Mechanical Equipment)",null,"number (No)"]
[".07.02","etc. for other mechanical equipment sizes",null,"number (No)"]
[".07.02.01","etc. for other mechanical equipment sub types"]
[".07.02","etc. for other mechanical equipment types"]
[]
["The unit of measurement shall be the number of each piece of mechanical equipment constructed and completed as shown on the Drawings and as specified."]
[]
["The quantity represents the total number of mechanical equipment items for a particular type, sub type and size."]
[]
["The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each piece of mechanical equipment, as specified and approved by the Engineer."]

{"sheet":"03PRELIMINARY AND GENERAL","index":3,"n_rows":209,"n_cols":6,"rows_kept":209,"merged":[[0,0,0,5],[1,0,1,5]]}
["SECTION 400-03 - BILL OF QUANTITIES"]
["PRELIMINARY AND GENERAL"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[null,"PRELIMINARY AND GENERAL"]
[]
[null,"NOTE:"]
[]
[]
[".00.01","Main Contractor P&G's if applicable","Item",1,null,{"$f":"E11*D11","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.02","Allow for total site establishment costs.","Item",1,null,{"$f":"E13*D13","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C14<>\"\",MAX(A9:A13)+1,\"\")","v":""}]
[".00.03","Allow for the programming of the works co-ordination and attending progress meetings.","Item",1,null,{"$f":"E15*D15","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C16<>\"\",MAX(A11:A15)+1,\"\")","v":""}]
[".00.04","Allow for management and programming of the works during the entire contract period.","Item",1,null,{"$f":"E17*D17","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C18<>\"\",MAX(A13:A17)+1,\"\")","v":""}]
[".00.05","Allow for costs related to all insurances as required by the contract.","Item",1,null,{"$f":"E19*D19","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C20<>\"\",MAX(A14:A19)+1,\"\")","v":""}]
[".00.06","Allow for 3 complete sets of operating and maintenance manuals for all and any equipment of the entire HVAC installation. This will include an electronic version of the entire document.","Item",1,null,{"$f":"E21*D21","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C22<>\"\",MAX(A16:A21)+1,\"\")","v":""}]
[".00.07","Allow for testing, balancing, commissioning and handover of all equipment.","Item",1,null,{"$f":"E23*D23","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C24<>\"\",MAX(A6:A23)+1,\"\")","v":""}]
[".00.08","Allow for any and all protection against possible damage to equipment, installations, testing equipment, gear, etc.","Item",1,null,{"$f":"E25*D25","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C26<>\"\",MAX(A9:A25)+1,\"\")","v":""}]
[".00.09","Allow for cleaning and start-up of the installation.","Item",1,null,{"$f":"E27*D27","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C28<>\"\",MAX(A11:A27)+1,\"\")","v":""}]
[".00.10","Allow for providing and implementing an approved quality insurance/quality control system to international standards.","Item",1,null,{"$f":"E29*D29","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C30<>\"\",MAX(A13:A29)+1,\"\")","v":""}]
[".00.11","Allow for one year comprehensive maintenance and guarantees.","Item",1,null,{"$f":"E31*D31","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C32<>\"\",MAX(A14:A31)+1,\"\")","v":""}]
[".00.12","Allow for training of personnel.","Item",1,null,{"$f":"E33*D33","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.13","Allow for performance security costs.","Item",1,null,{"$f":"E35*D35","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C36<>\"\",MAX(A9:A35)+1,\"\")","v":""}]
[".00.14","Allow for preparation of shop drawings, equipment submissions and detail  engineering","Item",1,null,{"$f":"E37*D37","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.15","Allow for the submission of samples","Item",1,null,{"$f":"E39*D39","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.16","Allow for the preparation and submission of \"As built\" drawings of the works","Item",1,null,{"$f":"E41*D41","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C42<>\"\",MAX(A15:A41)+1,\"\")","v":""}]
[{"$f":"IF(C43<>\"\",MAX(A19:A42)+1,\"\")","v":""},"SECTION 400-03"]
[null,"PRELIMINARY AND GENERAL"]
[null,"Carried to summary",{"$nulls":3},{"$f":"SUM(F11:F44)","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$f":"IF(C47<>\"\",MAX(A18:A45)+1,\"\")","v":""},"SECTION 400-03"]
[{"$f":"IF(C48<>\"\",MAX(A19:A47)+1,\"\")","v":""},"PRELIMINARY AND GENERAL"]
[{"$f":"IF(C49<>\"\",MAX(A26:A48)+1,\"\")","v":""}]
[".00.17","Labelling (inclusive of labels on ceiling to indicate mechancal equiment positions)","Item",1,null,{"$f":"E50*D50","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C51<>\"\",MAX(A17:A50)+1,\"\")","v":""}]
[".00.18","Traveling","Item",1,null,{"$f":"E52*D52","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C53<>\"\",MAX(A27:A49)+1,\"\")","v":""}]
[".00.19","Allow for hoisting and rigging of all equipment to first floor roof","Item",1,null,{"$f":"E54*D54","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C55<>\"\",MAX(A33:A54)+1,\"\")","v":""}]
[".00.20","Safety file ","Item",1,null,{"$f":"E56*D56","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.21","Allow for protective covering to floor tiles and all necessary measures to prevent damage during the works to existing building and furniture, including removal upon completion.","Item",1,null,{"$f":"E58*D58","v":{"v":0,"d":"R 0.00"}}]
[]
[".00.22","Destructive VRF Pipe Testing","Lot",2,null,{"$f":"E60*D60","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":36}
[null,"SECTION 400-03"]
[{"$f":"IF(C98<>\"\",MAX(A58:A65)+1,\"\")","v":""},"PRELIMINARY AND GENERAL"]
[{"$f":"IF(C99<>\"\",MAX(A59:A98)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F50:F98)","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C100<>\"\",MAX(A62:A99)+1,\"\")","v":""},"SECTION 400-03"]
[{"$f":"IF(C101<>\"\",MAX(A63:A100)+1,\"\")","v":""},"PRELIMINARY AND GENERAL - Line items"]
[]
[]
[{"$f":"IF(C104<>\"\",MAX(A53:A103)+1,\"\")","v":1},"Item2","Item",1,null,{"$f":"E104*D104","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[{"$f":"IF(C107<>\"\",MAX(A99:A106)+1,\"\")","v":2},"Item3","Item",1,null,{"$f":"E107*D107","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$f":"IF(C109<>\"\",MAX(A103:A105)+1,\"\")","v":""}]
[{"$f":"IF(C110<>\"\",MAX(A99:A109)+1,\"\")","v":3},"Item4","Item",1,null,{"$f":"E110*D110","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C111<>\"\",MAX(A105:A110)+1,\"\")","v":""}]
[{"$f":"IF(C112<>\"\",MAX(A105:A111)+1,\"\")","v":""}]
[{"$f":"IF(C113<>\"\",MAX(A101:A112)+1,\"\")","v":4},"Item5","Item",1,null,{"$f":"E113*D113","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[{"$f":"IF(C116<>\"\",MAX(A102:A115)+1,\"\")","v":5},"Item6","Item",1,null,{"$f":"E116*D116","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[{"$f":"IF(C119<>\"\",MAX(A105:A118)+1,\"\")","v":6},"Item7","Item",1,null,{"$f":"E119*D119","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[{"$f":"IF(C123<>\"\",MAX(A108:A122)+1,\"\")","v":7},"Item8","Item",1,null,{"$f":"E123*D123","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[{"$f":"IF(C127<>\"\",MAX(A112:A126)+1,\"\")","v":8},"Item9","Item",1,null,{"$f":"E127*D127","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[{"$f":"IF(C131<>\"\",MAX(A116:A130)+1,\"\")","v":9},"Item10","Item",1,null,{"$f":"E131*D131","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[{"$f":"IF(C135<>\"\",MAX(A119:A134)+1,\"\")","v":10},"Item11","Item",1,null,{"$f":"E135*D135","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":16}
[null,"SECTION 400-03"]
[{"$f":"IF(C153<>\"\",MAX(A105:A112)+1,\"\")","v":""},"PRELIMINARY AND GENERAL"]
[{"$f":"IF(C154<>\"\",MAX(A106:A153)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F104:F153)","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$f":"IF(C156<>\"\",MAX(A109:A154)+1,\"\")","v":""},"SECTION 400-03"]
[{"$f":"IF(C157<>\"\",MAX(A110:A156)+1,\"\")","v":""},"PRELIMINARY AND GENERAL"]
[]
[null,"SUMMARY","Page"]
[]
[null,{"$f":"B6","v":"PRELIMINARY AND GENERAL"},6,null,null,{"$f":"F45","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B161","v":"PRELIMINARY AND GENERAL"},7,null,null,{"$f":"F99","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B101","v":"PRELIMINARY AND GENERAL - Line items"},8,null,null,{"$f":"F154","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":41}
[null,"SECTION 400-03"]
[{"$f":"IF(C208<>\"\",MAX(A180:A188)+1,\"\")","v":""},"PRELIMINARY AND GENERAL"]
[{"$f":"IF(C209<>\"\",MAX(A181:A208)+1,\"\")","v":""},"Carried to collection",{"$nulls":3},{"$f":"SUM(F160:F200)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"04FIRST FLOOR NORTH","index":4,"n_rows":338,"n_cols":6,"rows_kept":338,"merged":[[0,0,0,4],[1,0,1,4]]}
["SECTION 400-04 - BILL OF QUANTITIES"]
["FIRST FLOOR NORTH"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[{"$f":"IF(C5<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C6<>\"\",MAX(A5:A5)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR DUCT SYSTEM (NORTH)"]
[]
["400.0.01.00","Straight Ducting"]
[null,"Straight Ducting in accordance with Sections 300"]
[".01.01","Category 1 - (up to 750mm with semi perimeter < 1150mm)","m²",100,null,{"$f":"D10*E10","v":{"v":0,"d":"R 0.00"}}]
[".01.02","Category 6-(Round/Spiral Ducting < Ø450)","m²",5,null,{"$f":"D11*E11","v":{"v":0,"d":"R 0.00"}}]
[]
["400.0.02.00","Duct Fittings"]
[null,"Duct Fittings in accordance with Sections 300"]
[]
[null,"Bends"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.01","400x400 (90° Bend)","No",2,null,{"$f":"D18*E18","v":{"v":0,"d":"R 0.00"}}]
[".02.02","400x400 (30° Bend)","No",2,null,{"v":0,"d":"R 0.00"}]
[".02.03","300x200 (90° Horisontal Bend)","No",3,null,{"v":0,"d":"R 0.00"}]
[".02.04","300x200 (90° Vertical Bend)","No",2,null,{"v":0,"d":"R 0.00"}]
[".02.05","200x300 (90° Vertical Bend)","No",2,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Transformations"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.06","500x500 - 500x700","No",1,null,{"$f":"D26*E26","v":{"v":0,"d":"R 0.00"}}]
[".02.07","500x500 - 500x700","No",1,null,{"$f":"D27*E27","v":{"v":0,"d":"R 0.00"}}]
[".02.08","400x400 - 400x300","No",1,null,{"v":0,"d":"R 0.00"}]
[".02.09","400x300 - 300x300","No",1,null,{"v":0,"d":"R 0.00"}]
[".02.10","300x300 - 300x200","No",1,null,{"v":0,"d":"R 0.00"}]
[".02.11","300x200 - 150x200","No",1,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Trouser Piece"]
[null,"Category 2-(up to 750mm with semi perimeter > 1150mm)"]
[".02.12","400x700 - 400x400&300x200","No",1,null,{"$f":"D35*E35","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Square to Rounds"]
[null,"Category 6-(Round/Spiral Ducting < Ø450)"]
[".02.13","Ø560 - 1200x600","No",1,null,{"$f":"D39*E39","v":{"v":0,"d":"R 0.00"}}]
[".02.14","Ø560 - 500x400","No",1,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Shoes"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.15","150x150 (45°)","No",18,null,{"$f":"D44*E44","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Stop Ends"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.16","200x300","No",1,null,{"$f":"D48*E48","v":{"v":0,"d":"R 0.00"}}]
[".02.17","150x200","No",1,null,{"$f":"D49*E49","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Spigots"]
[null,"Category 6-(Round/Spiral Ducting < Ø450)"]
[".02.18","Ø150","No",2,null,{"$f":"D53*E53","v":{"v":0,"d":"R 0.00"}}]
[]
["400.0.04.00","Duct Accessories"]
[{"$f":"IF(C56<>\"\",MAX(A55:A55)+1,\"\")","v":""},"Duct Accessories in accordance with Sections 300"]
[]
[{"$f":"IF(C58<>\"\",MAX(A53:A57)+1,\"\")","v":""},"Butterfly Dampers"]
[{"$f":"IF(C59<>\"\",MAX(A53:A58)+1,\"\")","v":""},"Balancing dampers in accordance with Section 300"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".04.01","300x200","No",1,null,{"$f":"D61*E61","v":{"v":0,"d":"R 0.00"}}]
[".04.02","150x150","No",18,null,{"$f":"D62*E62","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":38}
[{"$f":"IF(C101<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C102<>\"\",MAX(A101:A101)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR DUCT SYSTEM (NORTH)"]
[{"$f":"IF(C103<>\"\",MAX(A101:A102)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F5:F101)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-04"]
[null,"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (NORTH)"]
[]
["400.0.06.00","Air Terminals"]
[{"$f":"IF(C108<>\"\",MAX(A107:A107)+1,\"\")","v":""},"Air Terminals in accordance with Sections 300"]
[]
[{"$f":"IF(C110<>\"\",MAX(#REF!)+1,\"\")","v":""},"Disc Valves"]
[{"$f":"IF(C111<>\"\",MAX(A110:A110)+1,\"\")","v":""},"(Including mounting frame, connection screws, paintwork,1.5 m each acoustic flexible connection,etc.)"]
[".06.01","Ø150, Ø150 Spigot","No",2,null,{"$f":"D112*E112","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Fresh Air Grilles"]
[null,"(Fixed blade grille for Fresh Air supply to offices including connections, clamps, mountings, paintwork etc. )"]
[".06.02","150x150","No",18,null,{"$f":"D116*E116","v":{"v":0,"d":"R 0.00"}}]
[".06.03","200x200","No",8,null,{"$f":"D117*E117","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Dampers"]
[null,"(Opposed Blade Damper fitted on inside of fresh air grille. Including connections, clamps, mounting etc.)"]
[".06.04","150x150","No",18,null,{"$f":"D121*E121","v":{"v":0,"d":"R 0.00"}}]
[null,"200x200","No",8,null,{"$f":"D122*E122","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Weather Louvres"]
[null,"(Fixed blade including connections, clamps, mountings etc. )"]
[".06.05","1200x600","No",1,null,{"$f":"D126*E126","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Filters"]
[null,"(To be installed as filter bank 1200x600 in accordance with Axial Flow Fans, inlcluding filter bank frame rectangular position to form 1200x600 WxH Filter Bank)"]
[null,"1200x600","No",1,null,{"$f":"D130*E130","v":{"v":0,"d":"R 0.00"}}]
[]
[]
["400.0.07.00","Mechanical Equipment"]
[null,"Fans in accordance with Section 300"]
[]
[null,"Ventilation Fans"]
[null,"Axial flow fan, C/W steel mounting frame ,mounting feet, spring mounts, flanges as specified, suitable electrical connection wiring (1,5m long) between isolator and fan terminals, including vibration isolators, tested, commissioned and installed in position. "]
[".07.01","Axial Flow Fan: 1 m3/s @300 Pa","No",1,null,{"$f":"D138*E138","v":{"v":0,"d":"R 0.00"}}]
[".07.02","Circular Sound Attenuator","No",2,null,{"v":0,"d":"R 0.00"}]
[]
[]
[]
[{"$f":"IF(C143<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C144<>\"\",MAX(A143:A143)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (NORTH)"]
[{"$f":"IF(C145<>\"\",MAX(A143:A144)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F106:F143)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-04"]
[null,"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (NORTH)"]
[]
["400.0.07.00","Mechanical Equipment"]
[]
[null,"VRF Air-Conditioning System supplied by Mitsubishi"]
[]
[null,"VRF Indoor Air-Conditioning Units"]
[]
[null,"VRF type indoor  Air-conditioning  units, to specification, tested and installed. Including all necessary refrigerant piping including thermal insulation, trunking, final electrical connections between isolator and indoor unit, HARD WIRED CONTROLLER with daisy-chained control wiring, unit strut brackets, mounting accessories and supply air sound attenuators (for hide away units). All Outdoor Units to come with a suitable mounting frame."]
[]
[null,"Length of refrigerant piping distance between indoor and condensing unit is measured in one way.  "]
[]
[{"$f":"IF(C159<>\"\",MAX(A157:A157)+1,\"\")","v":""},"Actual Cooling Capacity required is  referred to as ACC."]
[null,"(Deration of units by contractor)"]
[]
[null,"Midwall Unit "]
[".07.01","MW1.1.01: 4.5 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D163*E163","v":{"v":0,"d":"R 0.00"}}]
[".07.02","MW1.1.02: 3.4 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.03","MW1.1.03: 3.4 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.04","MW1.1.04: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.05","MW1.1.05: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.06","MW1.1.06: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.07","MW1.1.07: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.08","MW1.1.08: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.09","MW1.1.09: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D171*E171","v":{"v":0,"d":"R 0.00"}}]
[".07.10","MW1.1.10: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.11","MW1.1.11: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.12","MW2.1.01: 3.9 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.13","MW2.1.02: 3.9 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.14","MW2.1.03: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.15","MW2.1.04: 4.5 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.16","MW2.1.05: 5.0 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.17","MW2.1.06: 2.2 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.18","MW2.1.07: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D180*E180","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Ceiling Cassette"]
[".07.19","CC1.1.01: 4.6 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D183*E183","v":{"v":0,"d":"R 0.00"}}]
[".07.20","CC1.1.02: 4.6 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[]
[null,"VRF central controller "]
[null,"VRF central controller connected to all indoor units (allows for auto restart of all AC indoor units to previous setpoint and settings of the users. Controller to be installed in the office entrance.","Lot ",1,null,{"$f":"D187*E187","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Quantities of equipment highlighted in red should by completed by tenderer as per supplier's quantities"]
[]
[null,"Refrigerant Piping - Base pipe route as per drawing"]
[null,"Length of refrigerant pipe to be supplied by supplier."]
[null,"1/2\"","m",null,null,{"$f":"D193*E193","v":{"v":0,"d":"R 0.00"}}]
[null,"1/4\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"3/4\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"3/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"5/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"7/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"11/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[]
[null,"VRF Heat Recovery Condensing Unit"]
[null,"22.4 kW Nominal cooling capacity","No",null,null,{"$f":"D202*E202","v":{"v":0,"d":"R 0.00"}}]
[null,"28 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"33.5 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"40 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"45 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"50 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"56 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"63 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"69 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"73 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Refrigerant Controller Units (MCU/ BS/BC box)"]
[null,"Including all accessories, fittings, installation, etc. to ensure a fully functioning system as per the specifications and relevant standards."]
[]
[null,"Refrigerant control box quantity by suppliers:"]
[null,"2 Port","No",null,null,{"$f":"D217*E217","v":{"v":0,"d":"R 0.00"}}]
[null,"4 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"6 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"8 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"10 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"13 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"16 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[]
[]
[null,"uPVC Piping and Fittings "]
[null,"Ø22 mm ","m",100,null,{"$f":"D227*E227","v":{"v":0,"d":"R 0.00"}}]
[null,"Insulation as specified","m",{"$f":"D227","v":100},null,{"$f":"D228*E228","v":{"v":0,"d":"R 0.00"}}]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(C235<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C236<>\"\",MAX(A235:A235)+1,\"\")","v":""},"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (NORTH)"]
[{"$f":"IF(C237<>\"\",MAX(A235:A236)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F148:F235)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-04"]
[null,"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (NORTH)"]
[]
["400.0.07.00","Mechanical Equipment"]
[null,"Fans in accordance with Section 300"]
[]
[null,"Wall Fans"]
[null,"(Including mounting frame, connection screws, paintwork, electrical connection etc.)"]
[null,"EF1.1.01: > 90 l/s @ 50 Pa","No",1,null,{"$f":"D246*E246","v":{"v":0,"d":"R 0.00"}}]
[null,"EF2.1.01: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.02: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.03: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.04: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.05: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.06: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
{"$rows_empty":32}
[null,"SECTION 400-04"]
[null,"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (NORTH)"]
[{"$f":"IF(C287<>\"\",MAX(A285:A286)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F169:F285)","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C288<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C289<>\"\",MAX(A288:A288)+1,\"\")","v":""},"FIRST FLOOR NORTH - SUMMARY"]
[{"$f":"IF(C290<>\"\",MAX(#REF!)+1,\"\")","v":""}]
[null,"SUMMARY","Page"]
[]
[null,{"$f":"B102","v":"FIRST FLOOR - FRESH AIR DUCT SYSTEM (NORTH)"},"10",null,null,{"$f":"F103","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B144","v":"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (NORTH)"},"12",null,null,{"$f":"F145","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B236","v":"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (NORTH)"},"13",null,null,{"$f":"F237","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B286","v":"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (NORTH)"},"14",null,null,{"$f":"F287","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":36}
[{"$f":"IF(C336<>\"\",MAX(A288:A335)+1,\"\")","v":""},"SECTION 400-04"]
[{"$f":"IF(C337<>\"\",MAX(A288:A336)+1,\"\")","v":""},"FIRST FLOOR NORTH - SUMMARY"]
[null,"Carried to collection",{"$nulls":3},{"$f":"SUM(F289:F336)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"05FIRST FLOOR SOUTH","index":5,"n_rows":290,"n_cols":6,"rows_kept":290,"merged":[[0,0,0,4],[1,0,1,4]]}
["SECTION 400-05 - BILL OF QUANTITIES"]
["FIRST FLOOR SOUTH"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[{"$f":"IF(C5<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C6<>\"\",MAX(A5:A5)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR DUCT SYSTEM (SOUTH)"]
[]
["400.0.01.00","Straight Ducting"]
[null,"Straight Ducting in accordance with Sections 300"]
[".01.01","Category 1 - (up to 750mm with semi perimeter < 1150mm)","m²",35,null,{"$f":"D10*E10","v":{"v":0,"d":"R 0.00"}}]
[".01.02","Category 6-(Round/Spiral Ducting < Ø450)","m²",5,null,{"$f":"D11*E11","v":{"v":0,"d":"R 0.00"}}]
[]
[]
["400.0.02.00","Duct Fittings"]
[null,"Duct Fittings in accordance with Sections 300"]
[]
[null,"Bends"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.01","300x300 (90° Vertical Bend)","No",2,null,{"$f":"D19*E19","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Transformations"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.10","300x300 - 200x200","No",1,null,{"$f":"D23*E23","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Square to Rounds"]
[null,"Category 6-(Round/Spiral Ducting < Ø450)"]
[".02.13","Ø400 - 600x600","No",1,null,{"$f":"D27*E27","v":{"v":0,"d":"R 0.00"}}]
[".02.14","Ø400 - 300x300","No",1,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Shoes"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.15","150x150 (45°)","No",13,null,{"$f":"D32*E32","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Stop Ends"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".02.16","200x200","No",1,null,{"$f":"D36*E36","v":{"v":0,"d":"R 0.00"}}]
[]
["400.0.04.00","Duct Accessories"]
[{"$f":"IF(C39<>\"\",MAX(A38:A38)+1,\"\")","v":""},"Duct Accessories in accordance with Sections 300"]
[]
[{"$f":"IF(C41<>\"\",MAX(A35:A40)+1,\"\")","v":""},"Butterfly Dampers"]
[{"$f":"IF(C42<>\"\",MAX(A35:A41)+1,\"\")","v":""},"Balancing dampers in accordance with Section 300"]
[null,"Category 1 - (up to 750mm with semi perimeter < 1150mm)"]
[".04.01","150x150","No",13,null,{"$f":"D44*E44","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":7}
[{"$f":"IF(C52<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C53<>\"\",MAX(A52:A52)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR DUCT SYSTEM (SOUTH)"]
[{"$f":"IF(C54<>\"\",MAX(A52:A53)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F5:F52)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-05"]
[null,"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (SOUTH)"]
[]
["400.0.06.00","Air Terminals"]
[{"$f":"IF(C59<>\"\",MAX(A58:A58)+1,\"\")","v":""},"Air Terminals in accordance with Sections 300"]
[]
[null,"Fresh Air Grilles"]
[null,"(Fixed blade grille for Fresh Air supply to offices including connections, clamps, mountings, paintwork etc. )"]
[".06.02","150x150","No",12,null,{"$f":"D63*E63","v":{"v":0,"d":"R 0.00"}}]
[".06.03","200x200","No",1,null,{"$f":"D64*E64","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Dampers"]
[null,"(Opposed Blade Damper fitted on inside of fresh air grille. Including connections, clamps, mounting etc.)"]
[".06.04","150x150","No",12,null,{"$f":"D68*E68","v":{"v":0,"d":"R 0.00"}}]
[null,"200x200","No",1,null,{"$f":"D69*E69","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Weather Louvres"]
[null,"(Fixed blade including connections, clamps, mountings etc. )"]
[".06.05","600x600","No",1,null,{"$f":"D73*E73","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Filters"]
[null,"(To be installed as filter bank 600x600 in accordance with Axial Flow Fans, inlcluding filter bank frame rectangular position to form 600x600 WxH Filter Bank)"]
[null,"600x600","No",1,null,{"$f":"D77*E77","v":{"v":0,"d":"R 0.00"}}]
[]
["400.0.07.00","Mechanical Equipment"]
[null,"Fans in accordance with Section 300"]
[]
[null,"Ventilation Fans"]
[null,"Axial flow fan, C/W steel mounting frame ,mounting feet, spring mounts, flanges as specified, suitable electrical connection wiring (1,5m long) between isolator and fan terminals, including vibration isolators, tested, commissioned and installed in position. "]
[".07.01","Axial Flow Fan:  > 0.32 m3/s @250 Pa","No",1,null,{"$f":"D84*E84","v":{"v":0,"d":"R 0.00"}}]
[".07.02","Circular Sound Attenuator","No",2,null,{"v":0,"d":"R 0.00"}]
{"$rows_empty":9}
[{"$f":"IF(C95<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C96<>\"\",MAX(A95:A95)+1,\"\")","v":""},"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (SOUTH)"]
[{"$f":"IF(C97<>\"\",MAX(A95:A96)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F56:F95)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-05"]
[null,"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (SOUTH)"]
[]
["400.0.07.00","Mechanical Equipment"]
[]
[null,"VRF Air-Conditioning System supplied by Mitsubishi"]
[]
[null,"VRF Indoor Air-Conditioning Units"]
[]
[null,"VRF type indoor  Air-conditioning  units, to specification, tested and installed. Including all necessary refrigerant piping including thermal insulation, trunking, final electrical connections between isolator and indoor unit, HARD WIRED CONTROLLER with daisy-chained control wiring, unit strut brackets, mounting accessories and supply air sound attenuators (for hide away units). All Outdoor Units to come with a suitable mounting frame."]
[]
[null,"Length of refrigerant piping distance between indoor and condensing unit is measured in one way.  "]
[]
[{"$f":"IF(C111<>\"\",MAX(A109:A109)+1,\"\")","v":""},"Actual Cooling Capacity required is  referred to as ACC."]
[null,"(Deration of units by contractor)"]
[]
[null,"Midwall Unit "]
[".07.01","MW3.1.01: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D115*E115","v":{"v":0,"d":"R 0.00"}}]
[".07.02","MW3.1.02: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.03","MW3.1.03: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.04","MW3.1.04: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.05","MW3.1.05: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.06","MW3.1.06: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.07","MW3.1.07: 2.7 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.08","MW4.1.01: 2.2 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.09","MW4.1.02: 2.2 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.10","MW4.1.03: 2.4 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.11","MW4.1.04: 2.4 kW (ACC) inclusive all accessories","No",1,null,{"v":0,"d":"R 0.00"}]
[".07.12","MW4.1.05: 3.5 kW (ACC) inclusive all accessories","No",1,null,{"$f":"D126*E126","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"VRF central controller "]
[null,"VRF central controller connected to all indoor units (allows for auto restart of all AC indoor units to previous setpoint and settings of the users. Controller to be installed in the office entrance.","Lot ",1,null,{"$f":"D129*E129","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Quantities of equipment highlighted in red should by completed by tenderer as per supplier's quantities"]
[]
[null,"Refrigerant Piping - Base pipe route as per drawing"]
[null,"Length of refrigerant pipe to be supplied by supplier."]
[null,"1/2\"","m",null,null,{"$f":"D135*E135","v":{"v":0,"d":"R 0.00"}}]
[null,"1/4\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"3/4\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"3/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"5/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"7/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[null,"11/8\"","m",null,null,{"v":0,"d":"R 0.00"}]
[]
[null,"VRF Heat Recovery Condensing Unit"]
[null,"22.4 kW Nominal cooling capacity","No",null,null,{"$f":"D144*E144","v":{"v":0,"d":"R 0.00"}}]
[null,"28 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"33.5 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"40 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"45 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"50 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"56 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"63 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"69 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"73 kW Nominal cooling capacity","No",null,null,{"v":0,"d":"R 0.00"}]
[]
[null,"Refrigerant Controller Units (MCU/ BS/BC box)"]
[null,"Including all accessories, fittings, installation, etc. to ensure a fully functioning system as per the specifications and relevant standards."]
[]
[null,"Refrigerant control box quantity by suppliers:"]
[null,"2 Port","No",null,null,{"$f":"D159*E159","v":{"v":0,"d":"R 0.00"}}]
[null,"4 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"6 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"8 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"10 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"13 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[null,"16 Port","No",null,null,{"v":0,"d":"R 0.00"}]
[]
[null,"uPVC Piping and Fittings "]
[null,"Ø22 mm ","m",60,null,{"$f":"D168*E168","v":{"v":0,"d":"R 0.00"}}]
[null,"Insulation as specified","m",{"$f":"D168","v":60},null,{"$f":"D169*E169","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":17}
[{"$f":"IF(C187<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C188<>\"\",MAX(A187:A187)+1,\"\")","v":""},"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (SOUTH)"]
[{"$f":"IF(C189<>\"\",MAX(A187:A188)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F100:F187)","v":{"v":0,"d":"R 0.00"}}]
[null,"SECTION 400-05"]
[null,"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (SOUTH)"]
[]
["400.0.07.00","Mechanical Equipment"]
[null,"Fans in accordance with Section 300"]
[]
[null,"Wall Fans"]
[null,"(Including mounting frame, connection screws, paintwork, electrical connection etc.)"]
[null,"EF1.1.01: > 90 l/s @ 50 Pa","No",1,null,{"$f":"D198*E198","v":{"v":0,"d":"R 0.00"}}]
[null,"EF2.1.01: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.02: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.03: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.04: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.05: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
[null,"EF2.1.06: > 50 l/s @ 50 Pa","No",1,null,{"v":0,"d":"R 0.00"}]
{"$rows_empty":32}
[null,"SECTION 400-05"]
[null,"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (SOUTH)"]
[{"$f":"IF(C239<>\"\",MAX(A237:A238)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F192:F237)","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C240<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C241<>\"\",MAX(A240:A240)+1,\"\")","v":""},"FIRST FLOOR SOUTH - SUMMARY"]
[{"$f":"IF(C242<>\"\",MAX(#REF!)+1,\"\")","v":""}]
[null,"SUMMARY","Page"]
[]
[null,{"$f":"B53","v":"FIRST FLOOR - FRESH AIR DUCT SYSTEM (SOUTH)"},"10",null,null,{"$f":"F54","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B96","v":"FIRST FLOOR - FRESH AIR MECHANICAL EQUIPMENT (SOUTH)"},"12",null,null,{"$f":"F97","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B188","v":"FIRST FLOOR - AIR CONDITIONING MECHANICAL EQUIPMENT (SOUTH)"},"13",null,null,{"$f":"F189","v":{"v":0,"d":"R 0.00"}}]
[]
[null,{"$f":"B238","v":"FIRST FLOOR - EXTRACT AIR MECHANICAL EQUIPMENT (SOUTH)"},"14",null,null,{"$f":"F239","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":36}
[{"$f":"IF(C288<>\"\",MAX(A240:A287)+1,\"\")","v":""},"SECTION 400-05"]
[{"$f":"IF(C289<>\"\",MAX(A240:A288)+1,\"\")","v":""},"FIRST FLOOR SOUTH - SUMMARY"]
[null,"Carried to collection",{"$nulls":3},{"$f":"SUM(F241:F288)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"06BUILDERS WORK","index":6,"n_rows":100,"n_cols":6,"rows_kept":100,"merged":[[0,0,0,4],[1,0,1,4]]}
["SECTION 400-06 - BILL OF QUANTITIES"]
["BUILDERS WORK"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[{"$f":"IF(C5<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-06"]
[{"$f":"IF(C6<>\"\",MAX(A5:A5)+1,\"\")","v":""},"FIRST FLOOR - BUILDERS WORK"]
[]
[1,"Builders Work Openings"]
[null,"Builders Work Openings for all air terminals installed in wall"]
[null,"200x200 Opening","No",32,null,{"$f":"D10*E10","v":{"v":0,"d":"R 0.00"}}]
[]
[2,"Stripping of Existing"]
[null,"Neat stripping of existing items and removal from site as specified below"]
[null,"Stripping of Lay in Ceiling","m²",160,null,{"$f":"D14*E14","v":{"v":0,"d":"R 0.00"}}]
[null,"Stripping of Bulkheads","m²",200,null,{"$f":"D15*E15","v":{"v":0,"d":"R 0.00"}}]
[null,"Stripping of Existing Ducting","m ",150,null,{"$f":"D16*E16","v":{"v":0,"d":"R 0.00"}}]
[]
[3,"Flashing and Weather Proofing"]
[null,"Flashing and Weather Proofing and existing openings in slab. New fresh air duct to run through existing opening. Remainder of opening to be closed"]
[null,"Slab Openings","No",3,null,{"$f":"D20*E20","v":{"v":0,"d":"R 0.00"}}]
[]
[4,"Repainting of Walls"]
[null,"Rate for repainting of walls to match existing colour "]
[null,"Painting","m²",600,null,{"$f":"D24*E24","v":{"v":0,"d":"R 0.00"}}]
[]
[5,"Ceiling"]
[null,"Supply and Install of new lay in ceiling c/w insulated tiles. 1200x600 grid required"]
[null,"Ceiling","m²",160,null,{"$f":"D28*E28","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":18}
[{"$f":"IF(C47<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-06"]
[{"$f":"IF(C48<>\"\",MAX(A47:A47)+1,\"\")","v":""},"FIRST FLOOR - BUILDERS WORK"]
[{"$f":"IF(C49<>\"\",MAX(A47:A48)+1,\"\")","v":""},"Carried to summary",{"$nulls":3},{"$f":"SUM(F5:F47)","v":{"v":0,"d":"R 0.00"}}]
[{"$f":"IF(C50<>\"\",MAX(#REF!)+1,\"\")","v":""},"SECTION 400-06"]
[{"$f":"IF(C51<>\"\",MAX(A50:A50)+1,\"\")","v":""},"FIRST FLOOR - BUILDERS WORK"]
[{"$f":"IF(C52<>\"\",MAX(#REF!)+1,\"\")","v":""}]
[null,"SUMMARY","Page"]
[]
[null,{"$f":"B48","v":"FIRST FLOOR - BUILDERS WORK"},"10",null,null,{"$f":"F49","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"CONTRACTORS ALLOWANCE FOR ALL BUILDERS WORK NOT INCLUDED ABOVE","10",null,null,{"$f":"F51","v":{"v":0,"d":"R 0.00"}}]
{"$rows_empty":40}
[{"$f":"IF(C98<>\"\",MAX(A50:A97)+1,\"\")","v":""},"SECTION 400-06"]
[{"$f":"IF(C99<>\"\",MAX(A50:A98)+1,\"\")","v":""},"FIRST FLOOR - BUILDERS WORK"]
[null,"Carried to collection",{"$nulls":3},{"$f":"SUM(F51:F98)","v":{"v":0,"d":"R 0.00"}}]

{"sheet":"07COLLECTION","index":7,"n_rows":52,"n_cols":4,"rows_kept":52,"merged":[[0,0,0,3],[1,0,1,3],[51,0,52,0],[51,1,52,1],[51,2,52,2],[51,3,52,3]]}
["SECTION 400-07 - BILL OF QUANTITIES"]
["COLLECTION"]
[]
["NO","SUMMARY COLLECTION","PAGE","AMOUNT"]
[]
["400-03","PRELIMINARY AND GENERAL",null,{"$f":"'03PRELIMINARY AND GENERAL'!F209","v":{"v":0,"d":"R 0.00"}}]
[]
["400-04","FIRST FLOOR NORTH",null,{"$f":"'04FIRST FLOOR NORTH'!F338","v":{"v":0,"d":"R 0.00"}}]
[]
["400-05","FIRST FLOOR SOUTH",null,{"$f":"'05FIRST FLOOR SOUTH'!F290","v":{"v":0,"d":"R 0.00"}}]
[]
["400-06","BUILDERS WORK",null,{"$f":"'06BUILDERS WORK'!F100","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"Engineering Contingency  - Do Not Modify ",null,{"v":150000,"d":"R 150,000.00"}]
[null,"To be expended with explicite permission of the engineer*"]
{"$rows_empty":36}
[null,"ESTIMATED TENDER PRICE EXCLUDING VAT",null,{"$f":"SUM(D6:D17)","v":{"v":150000,"d":"R 150,000.00"}}]