{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["B1200","B1300","B1500","B1800","B5500","Summary","Calc of Tender Sum"],"not_rendered":{"external_links":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"B1200","index":0,"n_rows":12,"n_cols":6,"rows_kept":12}
[]
["Item","Description","Unit","Quantity","Rate","Amount R"]
["B1200","GENERAL REQUIREMENTS AND PROVISION"]
["B12.03","Provision for direct costs incurred for obtaining all personal and vehicle permits:"]
[null,"(a) Airport personnel permits. ","Prov Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"(b) Airport Safety Induction. ","Prov Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"(c) Vehicle permits and branding.","Prov Sum",1,null,{"v":0,"d":"R0.00"}]
[]
["B 12.08","Compliance with occupational health and safety act (OHS and regulations including the construction regulations, 2014):"]
[null,"(a) Contractor's obligations in respect of the Occupational Health and Safety Act Construction Regulations (2014)","Lum Sum",1,null,{"$f":"D10*E10","v":{"v":0,"d":"R0.00"}}]
[]
["B1200","TOTAL CARRIED TO SUMMARY"]

{"sheet":"B1300","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[6,1,6,4]]}
[]
["Item","Description","Unit","Quantity","Rate","Amount R"]
["B1300","CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS"]
["B13.01","Contractor's general obligations"]
[null,"(a) Fixed Obligation","Lump Sum",1,null,{"$f":"D5*E5","v":{"v":0,"d":"R0.00"}}]
[null,"(b) Value-related Obligations","Lump Sum",1,null,{"$f":"D6*E6","v":{"v":0,"d":"R0.00"}}]
[" B1300"," TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F5:F6)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"B1500","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[8,1,8,4]]}
[]
["Item","Description","Unit","Quantity","Rate","Amount R"]
["B1500","ACCOMODATION OF TRAFFIC "]
["B15.01","Accomodating Traffic and maintaining deviation"]
[null,"Flagmen","Man-day",2,null,{"$f":"D5*E5","v":{"v":0,"d":"R0.00"}}]
[null,"Poratable STOP and GO-RY signs","Number ",2,null,{"v":0,"d":"R0.00"}]
[null,"Moveable barricade/ road sign combination","Number ",6,null,{"v":0,"d":"R0.00"}]
[null,"Traffic Cones TD4","Number ",4,null,{"$f":"D8*E8","v":{"v":0,"d":"R0.00"}}]
[" B1500"," TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F6:F8)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"B1800","index":3,"n_rows":22,"n_cols":6,"rows_kept":22}
[]
["Item","Description","Unit","Quantity","Rate","Amount R"]
["B1800","DAYWORKS "]
["B18:01","Personnel "]
["(a)","Labourer","Per Shift",1]
["(b)","Supervisor","Per Shift",1,null,{"$f":"IF(OR(AND(D6=\"Prov\",E6=\"Sum\"),(E6=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D6*E6),\"\",IF(D6*E6=0,\"\",ROUND(D6*E6,2))))","v":""}]
["B18:02","Plant, equipment, tools and accessories:",{"$nulls":3},{"$f":"IF(OR(AND(D7=\"Prov\",E7=\"Sum\"),(E7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(D7*E7),\"\",IF(D7*E7=0,\"\",ROUND(D7*E7,2))))","v":""}]
["(a)","Generators ","Per Shift",1,null,""]
["(b)","Welding equipment","Per Shift",1,null,""]
["(c)","Jack Hammer","Per Shift",1,null,""]
["(d)","Grinders","Per Shift",1,null,""]
["(e)","Cutting discs ","Per Shift",1,null,""]
["(f)","Welding rods","Per Shift",1,null,""]
["B18.03"," \tMaterials"]
["(a)","Procurement of materials ","Prov Sum",1,null,{"v":0,"d":"R0.00"}]
["(b)","Contractor's handling costs, profit and all other charges in respect of subitem B18.03(a) ","%",5,null,{"v":0,"d":"R0.00"}]
[null,"VALUE OF ITEM OR SERVICE"]
[null,"R0             -        R 2000",{"v":0.1,"d":"10%"}]
[null,"R 2001      -        R10000",{"v":0.08,"d":"8%"}]
[null,"R10 001    -        R50 000",{"v":0.07,"d":"7%"}]
[null,"Over R50 001",{"v":0.05,"d":"5%"}]
["B1800","TOTAL CARRIED TO SUMMARY"]

{"sheet":"B5500","index":4,"n_rows":59,"n_cols":6,"rows_kept":59}
[]
["Item","Description","Unit","Quantity","Rate","Amount R"]
["B5500 ","FENCING"]
[]
[null,"HIGH SECURITY CLEARVIEW FENCING OR SIMILAR APPROVED "]
[]
[null,"EARTHWORKS"]
[]
["B55.01 ","Clearing the fence line"]
["(i) ","Excavate for holes not exceeding 2m deep","m³",{"v":1,"d":"1.0"},null,{"$f":"D10*E10","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Risk of collapse of excavations ",{"$nulls":3},{"$f":"D12*E12","v":{"v":0,"d":"R0.00"}}]
["(ii)","Sides of trench and hole excavations not exceeding 1.5m deep","m²",{"v":1,"d":"1.0"}]
[]
[null,"Extra over all excavations for carting away"]
["(iii)","Surplus material from excavations and/or stockpiles on site ","m³",{"v":1,"d":"1.0"},null,{"$f":"D16*E16","v":{"v":0,"d":"R0.00"}}]
[null,"to a dumping side to be located by the contractor "]
["(v)","Remove temporary bollards","No",{"v":1,"d":"1.0"},null,{"v":0,"d":"R0.00"}]
[]
["(vi)","CONCRETE, FORMWORK AND REINFORCEMENT"]
[]
[null,"Concrete works"]
["(vii)","Class 15MPa/19mm concrete in bases ","m³",{"v":1,"d":"1.0"},null,{"$f":"D23*E23","v":{"v":0,"d":"R0.00"}}]
[]
["(viii)","Quality control and material testing ","Prov Sum",{"v":1,"d":"1.0"}]
["B55.02","Supply and erect new fencing material for new fences and for supplementing material in existing fences which are being removed"]
[]
["(a) ","METALWORK"]
[]
[null,"Panel Formation"]
[]
[null,"Supply and install:"]
[]
[null,"Panels "]
["(i) ","3.297 X 2.4m high fencing with coated (corrosion resistance and weather guard technology) wire at 25 x 12mm aperture centres, 650 Mpa tensile strength, panel shall be reinforced with a 4 x 50mm deep V horizontalorizonal hformation","No",{"v":1,"d":"1.0"},null,{"$f":"D35*E35","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Post"]
["(ii) ","85 x 85 mm x 3m high post with tapering 45mm on a concrete footing shall include locking recess clip to secure panel edge and be sealed with a UV polymer cap abd fitted a 12mm base pin. All according to the manufactures specification.","m",{"v":1,"d":"1.0"},null,{"$f":"D38*E38","v":{"v":0,"d":"R0.00"}}]
[]
["(b)","\tSupply and install galvanized security lock box of the following sizes:"]
["(i) ","200 x 150 x 150mm","No",{"v":1,"d":"1.0"},null,{"$f":"D41*E41","v":{"v":0,"d":"R0.00"}}]
[]
["B55.03 ","New Clearview Sliding Gates "]
["(c)   ","Supply and install a sliding gate (cart away from site, demolish/remove concrete/paving in preparation for new gate. "]
["(i) ","3800mm x 2400mm high","No",{"v":1,"d":"1.0"},null,{"v":0,"d":"R0.00"}]
["(ii) ","6000mm x 2400mm high","No",{"v":1,"d":"1.0"},null,{"v":0,"d":"R0.00"}]
["(iii)","Sliding rail including accessories","No",{"v":2,"d":"2.0"}]
[]
["(d)","Spike strips shall be placed over fence panels including gates and poles "]
[null,"Durable wall spikes","m",{"v":1,"d":"1.0"},null,{"$f":"D50*E50","v":{"v":0,"d":"R0.00"}}]
[]
["(e)","Adhoc Request "]
[null,"Extra over for night work","Per shift",1,null,{"$f":"D53*E53","v":{"v":0,"d":"R0.00"}}]
[null,"Extra over for holiday work","Per shift",1,null,{"$f":"D54*E54","v":{"v":0,"d":"R0.00"}}]
[null,"Standing time","Per shift",1,null,{"v":0,"d":"R0.00"}]
[]
["(f)","Gate motor"]
[null,"Spec"]
["B5500","TOTAL CARRIED FORWARD",{"$nulls":3},{"$f":"SUM(F39:F51)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Summary","index":5,"n_rows":9,"n_cols":3,"rows_kept":9}
[]
["Section","Description","Amount R"]
["B1200","GENERAL REQUIREMENTS AND PROVISION",{"$f":"'B1200'!F12","v":{"v":0,"d":"R0.00"}}]
["B1300","CONTRACTOR'S ESTABLISHMENT ON SITE AND GENERAL OBLIGATIONS",{"$f":"'B1300'!F7","v":{"v":0,"d":"R0.00"}}]
["B1500","ACCOMMODATION OF TRAFFIC",{"$f":"'B1500'!F9","v":{"v":0,"d":"R0.00"}}]
["B1800","DAYWORKS",{"$f":"'B1800'!F22","v":{"v":0,"d":"R0.00"}}]
["B5500","FENCING",{"$f":"'B5500'!F59","v":{"v":0,"d":"R0.00"}}]
[]
["TOTAL SCHEDULE \n(Carried over to Summary Page)",null,{"$f":"SUM(C3:C7)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Calc of Tender Sum","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[0,0,0,4],[1,0,1,2],[1,3,1,4],[2,3,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,4]]}
["Contractor"]
["CALCULATION OF TENDER SUM"]
["TOTAL SCHEDULE A: FENCING MAINTENANCE YEAR 1 "]
["TOTAL TENDER SUM EXCLUDING VAT ( YEAR 1)",null,null,{"$f":"Summary!C9","v":{"v":0,"d":"R0.00"}}]
["VALUE-ADDED TAX (VAT)\nThe tenderer shall add 15% of the subtotal for VAT",null,null,{"$f":"D4*15%","v":0}]
["TENDER SUM CARRIED TO FORM OF TENDER",null,null,{"$f":"D4+D5","v":0}]
["* Contract values will be increased/ decreased per current index stipulated in Statistic SA- Consumer Price Indices- all income groups. 6% escalation should be used for illustrative purposes."]