{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Pricing Assumptions","P&G","Alterations","cctv","Sheet1"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[3,1,3,2]]}
[]
["CLIENT:","FREEDOM PARK HERITAGE SITE & MUSEUM"]
[]
["PROJECT:","APPOINTMENT OF SERVICE PROVIDER TO PROVIDE SERVICES OF SUPPLY, DELIVERY, WIRING, INSTALLATION, CERTIFICATION AND MAINTENANCE OF CCTV SYSTEM"]
[]
["Item \nNo.","DESCRIPTION","AMOUNT"]
[]
[null,"FINAL SUMMARY PAGE"]
[]
["A",{"$f":"'P&G'!$C$7","v":"BILL No. 01: PRELIMINARIES AND GENERAL"},{"$f":"'P&G'!G37","v":0}]
[]
["B",{"$f":"Alterations!$C$7","v":"BILL No. 02: ALTERATIONS"},{"$f":"Alterations!G41","v":0}]
[]
["C",{"$f":"cctv!$C$7","v":"BILL No. 03: CCTV"},{"$f":"cctv!J54","v":0}]
[]
[]
[]
[]
[null,"SUB TOTAL"]
[]
[null,"ADD CONTIGENCIES OF R100 000",{"v":100000,"d":"R100,000.00"}]
[]
[null,"SUB TOTAL (EXCL VAT)",{"$f":"SUM(C10:C22)","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,"ADD 15% VAT",{"$f":"SUM(C23)*15%","v":{"v":15000,"d":"R15,000.00"}}]
[]
[null,"TOTAL TENDER VALUE OFFERED",{"$f":"SUM(C23:C26)","v":{"v":115000,"d":"R115,000.00"}}]

{"sheet":"Pricing Assumptions","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[0,0,0,3],[1,2,1,3],[2,0,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[18,0,18,3]]}
["FREEDOM PARK HERITAGE SITE & MUSEUM"]
[]
["SUPPLY, DELIVERY, WIRING, INSTALLATION, CERTIFICATION AND MAINTENANCE OF CCTV SYSTEM"]
[]
["PAGE","ITEM","DESCRIPTION",null,"UOM","QTY","RATE","AMOUNT"]
[]
["1",null,"PRICING ASSUMPTIONS"]
["1"]
["1","A","The Bills of Quantities have been drawn up in accordance with the Standard System of Measuring Building Work Seventh Edition (Revised 2015)\" published by the South African Association of Quantity Surveyors",null,"Note"]
["1","B","The agreement is based on the JBCC© Minor Works Agreement, prepared by the Joint Building Contracts Committee, Edition 5.2, May 2018",null,"Note"]
[null,"C","The JBCC Minor Works Agreement contract data form an integral part of this agreement",null,"Note"]
["1","D","Descriptions in the Bills of Quantities are abbreviated and comply generally with those in the \"General Preambles for Trades 2017\"",null,"Note"]
["1","E","Unless otherwise stated, items are measured net in accordance with the drawings and no allowance is made for waste The tenderer's price or rate shall allow for such waste where deemed necessary",null,"Note"]
["1","F","The prices and rates to be inserted in the Bills of Quantities are to be the full inclusive prices for the work described under the several items. Such prices and rates shall cover all costs and expenses that may be required in and for the execution of the work described and shall cover the cost of all general risks, liabilities and obligations set forth or implied in the documents on which the tender is based as well as overhead charges and profit. Reasonable prices shall be inserted as these will be used as a basis for assessment of payment for additional work that may have to be carried out",null,"Note"]
["1","G","A price or rate is to be entered against each item in the Bills of Quantities whether the quantities are stated or not. An item against which no price is entered will be considered to be covered by the other prices or rates in the Bill",null,"Note"]
["1","H","A price or rate is to be entered against each item in the Bills of Quantities whether the quantities are stated or not. An item against which no price is entered will be considered to be covered by the other prices or rates in the Bill",null,"Note"]
["1","I","The units of measurement described in the Bills of Quantities are metric units. Abbreviations which may be used in these Bills of Quantities are as follows:",null,"Note"]
["1","J","mm = millimeter                                                      \nm2 = square meter                                       \nkm = kilometer                                              \nkg = kilogram                                                  \nl = litre                                                               \nMN = meganewton                                     \nkW = kilowatt                                                \nNo. = number                                               \nPC Sum = Prime Cost Sum                       ","m = meter           \nm3 = cubic meter\nh = hour\nt = ton\nkl = kilolitre\nMPa = megapascal\n% = percent\nsum = lump sum\nProv Sum = Provisional Sum",{"$nulls":5},{"$f":"12.6-5.3-0.9","v":6.3999999999999995}]
["TOTAL CARRIED TO SUMMARY",{"$nulls":6},{"$f":"SUM(H9:H18)","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":7},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$nulls":7},{"$f":"'[1]Fire Doors'!G20","v":{"v":46775.619999999995,"d":"46,775.62"}}]
[]
[{"$nulls":7},{"$f":"SUM(H25:H27)","v":{"$error":"#REF!"}}]

{"sheet":"P&G","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"merged":[[36,0,36,5]]}
[{"$f":"'Pricing Assumptions'!$A$1","v":"FREEDOM PARK HERITAGE SITE & MUSEUM"}]
[]
[{"$f":"'Pricing Assumptions'!$A$3:$D$3","v":"SUPPLY, DELIVERY, WIRING, INSTALLATION, CERTIFICATION AND MAINTENANCE OF CCTV SYSTEM"}]
[]
["PAGE","ITEM","DESCRIPTION","UOM","QTY","RATE","AMOUNT"]
[]
["2",null,"BILL No. 01: PRELIMINARIES AND GENERAL"]
["2"]
["2",null,"BUILDING AGREEMENT"]
["2","A","The JBCC General Preliminaries (May 2018)\npublished by the Joint Building Contracts\nCommittee for use with the JBCC Minor Works\nAgreement (Edition 5.2 - May 2018) shall be\ndeemed to be incorporated in these bills of\nquantities, amended as hereinafter described","Note"]
["2","B","The contractor is deemed to have referred to the\nabovementioned documents for the full intent and\nmeaning of each clause","Note"]
["2",null,"PREAMBLES FOR TRADES AND PRELIMINARIES"]
["2","A","\"The General Preambles for Trades (2017 edition)\", as published by the Association of South African Quantity Surveyors, shall be deemed to be incorporated in these bills of quantities and no claims arising from brevity of description of items, fully described in the said General Preambles, will be entertained ","Note"]
["2","B","The contractor's price for all items throughout these schedule of quantities must take account of and include for all of the obligations, requirements and specifications given.","Note"]
["2","C","Any items left unpriced shall be deemed to be covered by rates and prices elsewhere incorporated throughout these schedule of quantities.  Rates are to be priced gross including profit.","Note"]
["2","D","Water will be supplied by the 'client' for the duration of the project","Note"]
["2","E","Electricity will be supplied by the 'client' for the duration of the project","Note"]
["2","F","Contractor to provide a full risk assessment, programme of works and methodology prior to the commencment of work. ","Note"]
["2","G","The awarded contractor is deemed to provided a 2 years workmanship guarantee as well as a 10 year product guarantee from a reputible supplier/manufacturer.","Note"]
["2","H","All contractors work force must at all times wear a reflector vest representing the company name as well as the individuals name card prior to being on site and will comply to the rules and rugulations by the Freedom Park.","Note"]
["3","I","The contractor shall be liable for and hereby indemnifies the employer against any and all liability, loss, claim or proceeding consequent upon loss of or damage to any moveable or immovable or personal property or property contiguous to the site, whether belonging to or under the control of the employer or any other body or person whomsoever arising out of or caused by a catastrophic ground movement, as mentioned above, which occurred during the period of the contract","Note"]
["3","J","Contractor is liable for the remeasuring of the areas.","Note"]
[]
["3",null,"PRELIMINARIES AND GENERALS"]
["3","A","Contractor to allow for site establishment","item",1]
["3","B","Contractor to suppy ablution facilities for all the contractors work force","item",1]
["3","C","The contractor to do a full Inspection of adjoining properties  A full photographic survey must be done by the contractor of adjoining premises, this must be handed over to the 'client' prior to construction.","item",1]
["3","D","Purchase of Original  JBCC® Minor Works Agreement: Edition 5.2 May 2018","item",1]
["3","E","Contractor to allow for Full time site supervision for the duration of the project for the standard working hours of 'Freedom Park' unless otherwise stated.","item",1]
["3","F","Contractor to make allowance for storage container/containers. An area will be indicated by the client prior to comencement of the works.","item",1]
["3","G","Contractor to allow for a full Health and Safety file, including all necessary site inspection meetings where required (project specific to this project in mention)","item",1]
["3","H","Contractor to make allowance for hoarding off areas where rubble is to be removed.","item",1]
["3","I","Contractor to allow for signage where needed.","item",1]
["3","J","Contractor to allow for rubble removal, including all necessary shoots and skips etc","item",1]
["3","K","Contractor to allow for Insurances","item",1]
[]
["TOTAL CARRIED TO SUMMARY"]

{"sheet":"Alterations","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"merged":[[40,0,40,5]]}
[{"$f":"'Pricing Assumptions'!$A$1","v":"FREEDOM PARK HERITAGE SITE & MUSEUM"}]
[]
[{"$f":"'Pricing Assumptions'!$A$3:$D$3","v":"SUPPLY, DELIVERY, WIRING, INSTALLATION, CERTIFICATION AND MAINTENANCE OF CCTV SYSTEM"}]
[]
["PAGE","ITEM","DESCRIPTION","UOM","QTY","RATE","AMOUNT"]
[]
["4",null,"BILL No. 02: ALTERATIONS"]
["4"]
["4",null,"PREAMBLES"]
["4",null,"Before pricing this schedule, Tenderers are advised to study \"The General Preambles for Trades (2017 edition)\", as published by the Association of South African Quantity Surveyors, shall be deemed to be incorporated in these bills of quantities and no claims arising from brevity of description of items, fully described in the said General Preambles, will be entertained "]
["4",null,"The following \"Supplementary Preambles\" are\nincorporated in this bill to satisfy the requirements of the project and shall take precedence over the provisions of the said General Preambles"]
["4",null,"SUPPLEMENTARY PREAMBLES"]
["4"]
["4",null,"View site:"]
["4",null,"Before submitting his tender, the Contractor shall visit the site and satisfy himself as to the nature and extent of the work to be done and the value of the materials contained in the buildings or portions of the buildings to be demolished. "]
["4",null,"No claim for any variations of the contract sum in\nrespect of the nature and extent of the work or of inferior or damaged materials will be entertained"]
["4",null,"Old materials to become property of the Contractor:"]
["4",null,"Old materials from alterations, except where described as to be re-used or handed over, become the property of the Contractor, who must allow credit for same in the last item of the \"Alterations\" trade\n"]
["4",null,"Old materials to be carted away:"]
["4",null,"Old materials from the alterations, except where\ndescribed as to be re-used or handed over, as well as all rubbish, etc must be regularly carted from the site and not be allowed to accumulate on or around the site\n"]
[]
[]
["5",null,"Old materials to be re-used:"]
["5",null,"None of the old materials are to be used for new work, except where specifically described as being set aside for re-use\n"]
["5",null,"Handing over of materials:"]
["5",null,"Where certain materials or articles from demolitions or alterations are described as to be \"handed over to the Employer\", it shall be taken to mean \"handed over by the Contractor to the Principal Agent\" and such materials or articles shall be properly stored by the Contractor until handing over thereof and shall include all necessary transport"]
["5",null,"The Contractor must obtain an official receipt from the Principal Agent listing the materials or articles and dates of handing over"]
["5",null,"Should the Contractor fail to submit the receipt when requested to do so, it shall be deemed that the materials or articles are still in his possession and he will be held liable to the Employer for the full replacement value thereof, which amount will be deducted from any monies due to the Contractor\n"]
["5",null,"Explosives:"]
["5",null,"No explosives whatsoever may be used for demolition purposes, unless otherwise stated\n"]
["5",null,"General:"]
["5",null,"The Contractor shall carry out the whole of the works with as little mess and noise as possible and with a minimum of disturbance to adjoining premises and their tenants. He shall provide proper protection and provide, erect and remove when directed, any temporary tarpaulins that may be necessary during the progress of the works, all to the satisfaction of the Principal Agent"]
["5",null,"The Contractor will be required to take all dimensions affecting the works on the site and will be held solely responsible for the accuracy of all such dimensions where used in the manufacture of new items\n"]
["5",null,"REMOVAL OF EXISTING WORK"]
["5"]
["5",null,"Taking up and removing floor coverings, etc from\nscreeded floors:"]
["5"]
["5","A","Removal of existing cameras, cables, DVR/NVR, monitors, biometrics ,and any related equipment. Including Patch/make good any holes or damages caused by the removal of the old system,including all cables","no",{"$f":"159+145","v":304},null,{"$f":"F38*E38","v":0}]
[]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":5},{"$f":"SUM(G38:G38)","v":0}]

{"sheet":"cctv","index":4,"n_rows":54,"n_cols":16384,"rows_kept":54,"merged":[[53,0,53,5]]}
[{"$f":"'Pricing Assumptions'!$A$1","v":"FREEDOM PARK HERITAGE SITE & MUSEUM"}]
[]
[{"$f":"'Pricing Assumptions'!$A$3:$D$3","v":"SUPPLY, DELIVERY, WIRING, INSTALLATION, CERTIFICATION AND MAINTENANCE OF CCTV SYSTEM"}]
[]
["PAGE","ITEM","DESCRIPTION","UOM","QTY","MATERIAL RATE","LABOUR RATE","MATERIAL TOTAL","LABOUR TOTAL","TOTAL AMOUNT"]
[]
["6",null,"BILL No. 03: CCTV"]
[]
["6",null,"SPECIALIST INSTALLATION"]
[]
["6",null,"Supply, Delivery, Wiring, Installation, Certification and Maintenance of CCTV System"]
[]
["6","1","64 channel NVR","no",3,null,null,{"$f":"E13*F13","v":0},{"$f":"E13*G13","v":0},{"$f":"SUM(H13:I13)","v":0}]
["6","2","8TB hardrives","no",6,null,null,{"$f":"E14*F14","v":0},{"$f":"E14*G14","v":0},{"$f":"SUM(H14:I14)","v":0}]
["6","3","2.8mm 4MP IP dome cameras","no",81,null,null,0,0,0]
["6","4","2.8mm 4MP IP bullet cameras","no",22,null,null,0,0,0]
["6","5","2.8mm to 12 IP bullet cameras","no",48,null,null,0,0,0]
["6","6","PTZ cameras","no",5,null,null,0,0,0]
["6","7","Long range nano stations","no",4,null,null,0,0,0]
["6","8","12 volt solar panels","no",10,null,null,0,0,0]
["6","9","Batteries","no",10,null,null,0,0,0]
["6","10","Solar-Prod MPPT Charge Controller","no",10,null,null,0,0,0]
["6","11","5 KM fiber cable for perimeter cameras, including all accessories i.e 90 x joints, 8000m micro duct ( 8/5 - 4 way ) ,3 x 48 fibre  patch panels, 1000m micro duct ( 8/5 - 1 way), 4 x 50mm galvinised pipes, 200 x patchleads","m",{"v":8000,"d":"8,000"},null,null,0,0,0]
["6","12","70 junction boxes","no",70,null,null,0,0,0]
["6","13","25mm PVC pipes ","m",400,null,null,0,0,0]
["6","14","2mm saddles","no",100,null,null,0,0,0]
["6","15","25mm couplings","no",100,null,null,0,0,0]
["6","16","25 x 40mm trunking","m",120,null,null,0,0,0]
["6","17","30x 500 meters cat5 cable","m",{"v":15000,"d":"15,000"},null,null,0,0,0]
["6","18","24 port POE network switches","no",4,null,null,0,0,0]
["6","19","16 port POE network switches","no",6,null,null,0,0,0]
["6","20","8 port POE network switches ","no",2,null,null,0,0,0]
["6","21","Network points","no",159,null,null,0,0,0]
[]
["6",null,"Supply, Delivery, Wiring, Installation, Certification and Maintenance of biometrics"]
["6",null,"Biometric Reader"]
["6","22","Biometric -Dual Reader","no",145,null,null,{"$f":"E37*F37","v":0},{"$f":"E37*G37","v":0},{"$f":"SUM(H37:I37)","v":0}]
["6",null,"Access Controllers - Biometric"]
["6","23","Inbio160 Door Controller 1 Door Fp & Rf","no",75,null,null,0,0,0]
["6",null,"Access Control Pc"]
["6","24","Windows Based Pc I7 16gb Ram 512gb Ssd","no",1,null,null,0,0,0]
["6",null,"Management Software"]
["6","25","Biosecurity Cv Security 145 Doors","no",1,null,null,0,0,0]
["6",null,"Switches, Patch Panels"]
["6","26","24 Port Poe Switches","no",7,null,null,0,0,0]
["6",null,"Monitor"]
["6","27","Mecer Monitor Led 23.8\" (1920x1080) Vga And","no",1,null,null,0,0,0]
["6",null,"Take -0n Reader"]
["6","28","Biometric Take-On-Reader","no",1,null,null,0,0,0]
[]
["6","22","Testing, Licences, Training and Comissioning","Sum",1,null,null,0,0,0,{"$nulls":16373},{"$f":"SUM(H51:XFC51)","v":0}]
["6","23","Monthly maintenance for a period of 24 months","months",24,null,null,0,0,0,{"$nulls":16373},{"$f":"SUM(XFD51)","v":0}]
[]
["TOTAL CARRIED TO SUMMARY",{"$nulls":8},{"$f":"SUM(J9:J53)","v":0}]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}