{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Summary ","P&G ","BOQ","Sheet1","PERIMETER","INTERNAL ","Measured works","MEASURED GATES (PARAMETE)","MEASURED GATES (INTERNAL)"],"not_rendered":{"images":2,"external_links":115,"defined_names":3703},"read":"whole","date_system":"1900"}

{"sheet":"Summary ","index":0,"n_rows":227,"n_cols":6,"rows_kept":227,"merged":[[51,1,51,3]]}
[null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
[]
["ITEM NO.","TRADE",null,null,"AMOUNT"]
[]
[]
[null,"SUMMARY"]
[]
[null,"SECTION 1 - PRELIMINARIES"]
[]
[null,"PRELIMINARIES AND GENERALS"]
[]
[null,"SECTION 2 -  SECURITY FENCING"]
[]
[null,"PERIMETER FENCE"]
{"$rows_empty":36}
[null,"Total Carried Forward to Form of Offer"]
{"$rows_empty":156}
[{"$nulls":5},1]
[]
[{"$nulls":5},2]
[]
[{"$nulls":5},3]
[]
[{"$nulls":5},4]
[]
[]
[]
[]
[]
[{"$nulls":5},8]
[]
[{"$nulls":5},9]
[]
[{"$nulls":5},10]
[]
[{"$nulls":5},11]

{"sheet":"P&G ","index":1,"n_rows":278,"n_cols":8,"rows_kept":278,"merged":[[1,1,1,5],[3,1,3,2],[4,6,4,7],[65,1,65,5],[117,1,117,5],[180,1,180,5]]}
[]
[null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
[{"$nulls":3},"                                                                                                                                                                                                                                                        "]
[]
[null,"Item \nNo","Payment Reference","Description","Unit","Qty","Rate","Amount"]
[null,null,"SANS 1200","SECTION 1: PRELIMINARIES AND GENERALS"]
[]
[{"$nulls":3},"FIXED CHARGED AND VALUE RELATED ITEMS"]
[]
[{"$nulls":3},"Contractual requirements:"]
[]
[null,"1.1.1","A 8.3.1","Contractual requirements.","Sum",1]
[]
[{"$nulls":3},"Establishment of facilities for engineer:"]
[]
[null,"1.1.2","A 8.3.2.1","(a) Furnished offices .","Sum",1]
[]
[null,"1.1.3","A 8.3.2.1","(b) Telephone.","Sum",1]
[]
[null,"1.1.4","A 8.3.2.1","(c) Nameboards.","Sum",1]
[]
[{"$nulls":3},"Establishment of facilities for contractor:"]
[]
[null,"1.1.5","A 8.3.2.2","(a) Offices and storage sheds.","Sum",1]
[]
[null,"1.1.9","A 8.3.2.2","(b) Ablution and latrine facilities.","Sum",1]
[]
[null,"1.1.10","A 8.3.2.2","(c) Tools and equipment.","Sum",1]
[]
[null,"1.1.11","A 8.3.2.2","(d) Water supplies, electric power and communications.","Sum",1]
[]
[null,"1.1.12","A 8.3.2.2","(e) Dealing with water.","Sum",1]
[]
[null,"1.1.13","A 8.3.2.2","(f) Access.","Sum",1]
[]
[null,"1.1.14","A 8.3.2.2","(j) Plant.","Sum",1]
[]
[{"$nulls":3},"Other Fixed-charge Obligations:"]
[]
[null,"1.1.15","A 8.3.3","Survey, setting out  and preparation of as-built drawings.","Sum",1]
[]
[null,"1.1.16","A 8.3.3","Soil testing equipment.","Sum",1]
[]
[null,"1.1.17","A 8.3.3","Environmental  management.","Sum",1]
[]
[null,"1.1.18","A 8.3.3","Occupational Health and Safety.","Sum",1]
[]
[null,"1.1.19","A 8.3.3","Items in terms of the Industrial Relations Act and Employment conditions for tender purposes.","Sum",1]
[]
[{"$nulls":3},"Removal of site establishment:"]
[]
[null,"1.1.20","A.8.3.4","Removal of site establishment.","Sum",1]
{"$rows_empty":10}
[{"$nulls":3},"Carried to Collections"]
[]
[null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
[]
[]
[null,"Item \nNo","Payment Reference","Description","Unit","Qty","Rate","Amount"]
[null,null,"SANS 1200","SECTION 1: PRELIMINARIES AND GENERAL"]
[]
[{"$nulls":3},"TIME RELATED ITEMS "]
[]
[{"$nulls":3},"Contractual requirements:"]
[]
[null,"1.1.21","A 8.4.1","Contractual requirements.","Months",9]
[]
[{"$nulls":3},"Establishment of facilities for engineer:"]
[]
[null,"1.1.22","A 8.4.2.1","(a) Furnished offices.","Months",9]
[]
[null,"1.1.23","A 8.4.2.1","(b) Telephone.","Months",9]
[]
[null,"1.1.24","A 8.4.2.1","(c) Nameboards.","Months",9]
[]
[{"$nulls":3},"Establishment of Facilities for contractor:"]
[]
[null,"1.1.26","A 8.4.2.2","(a) Offices and storage sheds.","Months",9]
[]
[null,"1.1.27","A 8.4.2.2","(b) Workshops.","Months",9]
[]
[null,"1.1.30","A 8.4.2.2","(c) Ablution and latrine facilities.","Months",9]
[]
[null,"1.1.31","A 8.4.2.2","(d) Tools and equipment.","Months",9]
[]
[null,"1.1.32","A 8.4.2.2","(e) Water supplies, electric power and communications.","Months",9]
[]
[null,"1.1.33","A 8.4.2.2","(f) Dealing with water.","Months",9]
[]
[null,"1.1.34","A 8.4.2.2","(g) Access.","Months",9]
[]
[null,"1.1.35","A 8.4.2.2","(h) Plant.","Months",9]
[]
[{"$nulls":3},"Supervision:"]
[]
[null,"1.1.36","A 8.4.3","Supervision for the duration of Construction.","Months",9]
[{"$nulls":4},"Months"]
[{"$nulls":3},"Company and Head office Overhead Cost:"]
[]
[null,"1.1.37","A 8.4.4","Company and Head office Overhead Cost for the duration for the contract.","Months",9]
[]
[]
[]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
[]
[null,"Item \nNo","Payment Reference","Description","Unit","Qty","Rate","Amount"]
[{"$nulls":3},"Other time related obligations:"]
[]
[null,"1.1.38","A 8.4.5","Survey, setting out and preparation of as-built drawings.","Months",9]
[]
[null,"1.1.40","A 8.4.5","Environmental management.","Months",9]
[]
[null,"1.1.41","A 8.4.5","Occupational Health and Safety.","Months",9]
[]
[null,"1.1.42","A 8.4.5","Items in terms of the Industrial Relations Act and Employment conditions for tender purposes.","Months",9]
{"$rows_empty":48}
[{"$nulls":3},"Carried to Collections"]
[]
[null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
[]
[{"$nulls":3},"COLLECTIONS"]
[]
[{"$nulls":3},"SECTION NO. 1"]
[]
[]
[{"$nulls":3},"Page",null,1]
[]
[{"$nulls":3},"Page",null,2]
[]
[{"$nulls":3},"Page",null,3]
{"$rows_empty":56}
[{"$nulls":3},"Total Collections Carried to Section Summary"]
{"$rows_empty":9}
[{"$nulls":5},1]
[]
[{"$nulls":5},2]
[]
[{"$nulls":5},3]
[]
[{"$nulls":5},4]
[]
[]
[]
[]
[]
[{"$nulls":5},8]
[]
[{"$nulls":5},9]
[]
[{"$nulls":5},10]
[]
[{"$nulls":5},11]

{"sheet":"BOQ","index":2,"n_rows":238,"n_cols":14,"rows_kept":238,"merged":[[1,2,1,6]]}
[]
[null,null,"Tender number: TNPA/2023/10/0005/44110/RFP\nTender Description: Security Fencing Upgrade at the Port of East London"]
[]
["Page","Item \nNo","Payment Reference","Description","Unit","Qty","Rate","Amount"]
[{"$nulls":7},{"$f":"G5*F5","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":3},"SECTION NO. 2 : SECURITY FENCE (PROVISIONAL)",{"$nulls":3},{"$f":"G6*F6","v":{"v":0,"d":"R 0.00"}}]
[{"$nulls":7},{"$f":"G7*F7","v":{"v":0,"d":"R 0.00"}}]
[]
[{"$nulls":3},"DEMOLITIONS ETC (PROVISIONAL)"]
[]
[{"$nulls":3},"Taking down and removing"]
[]
[null,"1",null,"2,4 m high Steel Pallisade Fencing including breaking removing any concrete bases then backfill and make good","m",16.73]
[]
[null,"2",null,"2,4 m high Precast concrete fencing including removing all foundations comple","m",{"v":255,"d":"255.00"}]
[]
[null,"3",null,"2,4 m high Mesh fencing including removing all foundations complete","m",{"v":3500,"d":"3,500.00"}]
[]
[null,"4",null,"2,4 m high Facebrick Fence including removing all foudantions complete","m",{"v":200,"d":"200.00"}]
[]
[{"$nulls":3},"SITE CLEARANCE ETC"]
[]
[{"$nulls":3},"Site clearance"]
[]
[null,"5",null,"Digging up and removing rubbish, debris, vegetation, hedges, shrubs, bush, etc. and trees not exceeding 200mmm girth and cart away to prescribed stock piles on site within 3.5km radius","m²",{"v":100354,"d":"100,354.00"}]
[]
[null,"6",null,"Stripping average 150mm thick layer of topsoil and depositing material in prescribed stock piles on site within 3.5km radius","m²",{"$f":"F25*10%","v":{"v":10035.400000000001,"d":"10,035.40"}}]
[]
[{"$nulls":3},"EXCAVATION, FILLING, ETC."]
[]
[{"$nulls":3},"EXCAVATIONS, ETC"]
[]
[{"$nulls":3},"Excavation in earth not exceeding 2m deep including shaping and trimming for "]
[]
[null,"7",null,"Plinths","m³",{"v":1298.3011896000005,"d":"1,298.30"}]
[{"$nulls":13},"Gate poles"]
[null,"8",null,"Bases","m³",{"$f":"(PERIMETER!C16*0.4*0.4*0.75)+('INTERNAL '!C19*0.4*0.4*0.75)+(PERIMETER!C17*0.4*0.4*0.9)+('INTERNAL '!C20*0.4*0.4*0.4)+(PERIMETER!C18*0.4*0.4*0.9)","v":{"v":597.6130862323541,"d":"597.61"}},{"$nulls":7},"No of Poles"]
[]
[{"$nulls":3},"Extra over trench and hole excavations in earth for excavation in"]
[]
[null,"9",null,"Soft rock","m³",327.44]
[]
[null,"10",null,"Hard rock","m³",163.72]
[]
[{"$nulls":3},"Extra over all excavation for carting away"]
[]
[null,"11",null,"Surplus material from excavations to prescribed stock piles on site within 3.5km radius","m³",{"$f":"SUM(F34:F39)","v":{"v":1895.9142758323546,"d":"1,895.91"}}]
[]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[{"$nulls":3},"Risk of collapse of excavations"]
[]
[null,"12",null,"Sides of trench and hole excavations not exceeding 1,5m deep","m²",{"v":48686.29461000001,"d":"48,686.29"}]
[]
[{"$nulls":3},"UNREINFORCED CONCRETE CAST IN EXCAVATED SURFACES"]
[]
[{"$nulls":3},"25 MPa/19mm Concrete"]
[]
[null,"13",null,"Plinths","m³",{"v":1298.3011896000005,"d":"1,298.30"}]
[]
[null,"14",null,"Bases","m³",{"$f":"F37","v":{"v":597.6130862323541,"d":"597.61"}}]
[]
[{"$nulls":3},"TEST CUBES"]
[]
[null,"15",null,"Making and testing 150 x 150 x 150mm concrete strength test cubes, 3 cubes per load","No.",{"$f":"(SUM(F59:F62)/6)*3","v":{"v":947.9571379161773,"d":"948"}}]
[]
[{"$nulls":3},"ROUGH FORMWORK (PROVISIONAL)"]
[]
[{"$nulls":3},"Rough Formwork to:"]
[]
[null,"16",null,"Sides of plinths ","m²",{"v":6491.505948000002,"d":"6,491.51"}]
[]
[{"$nulls":3},"FENCING, GATES, ETC (PROVISIONAL)"]
[]
[{"$nulls":3},"Steel Weld Mesh Fence "]
[]
[null,"17",null,"Supply, deliver and install complete including 3,82 m high Intermwdiate posts, 3,00 m High Reinforced Steel Welded Mesh Fence comprising of Bonded Mesh Fence 2,70 m high and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","m",{"$f":"PERIMETER!C5","v":{"v":9396.135020000003,"d":"9,396"}}]
[]
[null,"18",null,"Supply, deliver and install complete  including 3,82 m high Gate Posts, 2,7 m High Reinforced  Steel Welded Mesh Fence Automated Sliding Gate 9,9 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",3]
[]
[null,"19",null,"Supply, deliver and install complete  including 3,82 m high  Gate Posts 2,7 m High Reinforced  Steel Welded Mesh Fence Sliding Gate 8,49 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"20",null,"Supply, deliver and install complete  including 3,82m  Gate Posts, 2,7 m High Reinforced  Steel Welded Mesh Fence Atomated Sliding Gate 7,55 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"21",null,"Supply, deliver and install complete  including 3,82 m high Gate Posts, 2,7 m High Reinforced Steel Welded Mesh Fence Sliding Gate 6,2 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wirel added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[null,"22",null,"Supply, deliver and install complete  including 3,82 m high Gate Posts, new 2,7 m High Reinforced  Steel Welded Mesh Fence Automated Double Leaf Swing Gate 6 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"23",null,"Supply,deliver and install complete  including 3,82 m high Gate Posts, 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 8,6 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wirel added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"24",null,"Supply,deliver and install complete  including  Gate Posts new 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,8 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",2]
[]
[null,"25",null,"Supply,deliver and install complete  including  Gate Posts new 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,78 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wirel added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"26",null,"Supply,deliver and install complete  including  Gate Posts new 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4,59 m wide comprising of Bonded Mesh Fence and 300 mm high Electric razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"27",null,"Supply,deliver and install complete  including  Gate Posts new 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4,2 m wide comprising of Bonded Mesh Fence and 300 mm high Electric razor Wire added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"28",null,"Supply,deliver and install complete  including  Gate Posts new 2,7 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 2,9 m wide comprising of Bonded Mesh Fence and 300 mm high Electric Razor Wirel added to the top of fence (Galvenised to suit Marine Conditions)","No",1]
[]
[null,"29",null,"Supply, deliver and install complete including 3,00 m high Intermwdiate posts new 2,4 m High Reinforced  Steel Welded Mesh Fence comprising of Bonded Mesh Fence 2,4 m high with Spikes added to the top","m",{"$f":"'INTERNAL '!C5","v":{"v":6832.629849999999,"d":"6,833"}}]
[]
[null,"30",null,"Supply, deliver and install complete  including  Gate Posts new 2,4 m High Reinforced  Steel Welded Mesh Fence Automated Sliding Gate 10 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"31",null,"Supply, deliver and install complete  including  Gate Posts new 2,4 m High Reinforced  Steel Welded Mesh Fence Automated Sliding Gate 9 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[null,"32",null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced  Steel Welded Mesh Fence Sliding Gate 9 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,33,null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced  Steel Welded Mesh Fence Automated Sliding Gate 8,3 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,34,null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Automated Sliding Gate 8 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,35,null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Sliding Gate 6,52 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"36",null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Sliding Gate 6 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,37,null,"Supply, deliver and install complete  including 3,00 m high Gate Posts,2,4 m High Reinforced  Steel Welded Mesh Fence Automated double Swing Gate 5,9 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,38,null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4m High Reinforced Steel Welded Mesh Fence Automated Sliding Gate 5,86 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"39",null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced  Steel Welded Mesh Fence Automated Sliding Gate 4,99 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"40",null,"Supply, deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Automated Sliding Gate 4,2 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"41",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 9,7 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"42",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 8,8 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[{"$nulls":3},"Carried to Collections"]
[]
[null,"43",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 7,57 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"44",null,"Supply,deliver and install complete  including  3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 6,9 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"45",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 6,87 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"46",null,"Supply,deliver and install complete  including 3,00 high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 6 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"47",null,"Supply,deliver and install complete  including3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,8m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"48",null,"Supply,deliver and install complete  including 3,00 m Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,71m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"49",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,6 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"50",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 5,48 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"51",null,"Supply,deliver and install complete  including  Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4,8 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"52",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4,5 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"53",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4,3 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[null,"54",null,"Supply,deliver and install complete  including  3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 4 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"55",null,"Supply,deliver and install complete  including  3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 3,66 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",1]
[]
[null,"56",null,"Supply,deliver and install complete  including  3,00 mm high Gate Posts,2,4 m High Reinforced Steel Welded Mesh Fence Double Leaf Swing Gate 3 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"57",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Pedestrian Gate 1,7 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"58",null,"Supply,deliver and install complete  including 3,00 high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Pedestrian Gate 1,7 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"59",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts, 2,4 m High Reinforced Steel Welded Mesh Fence Pedestrian Gate 1,14 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[null,"60",null,"Supply,deliver and install complete  including 3,00 m high Gate Posts new 2,4 m High Reinforced Steel Welded Mesh Fence Pedestrian Gate 1 m wide comprising of Bonded Mesh Fence with Spikes added to the top of fence","No",2]
[]
[{"$nulls":3},"High-Security Large Panel Wall"]
[]
[null,"61",null,"Supply and erect new 3.6 m high concrete panel perimeter secuirty fence including the accessories, anti-climb, anti-burrow, etc, as per the typical drawings","m",{"$f":"PERIMETER!C6","v":{"v":496.92823999999996,"d":"497"}}]
[]
[{"$nulls":3},"Padlocks"]
[]
[null,"68",null,"Provide padlocks with long shackles and keys as per Drawing No. XELE00014-C-DE-0001-02-0A.","No",54]
[]
[{"$nulls":3},"Turnstile"]
[]
[{"$nulls":3},"Remove and Store for Re-Use 2.4m high turnstile complete with all the fittings.","No",6]
[]
[{"$nulls":3},"Supply, deliver and install a 2.4m high turnstile complete with all the fittings.","No",6]
[]
[]
[]
[]
[{"$nulls":3},"Carried to Collections"]
[]
[]
[{"$nulls":3},"COLLECTIONS"]
[]
[{"$nulls":3},"SECTION NO. 2 "]
[]
[]
[]
[]
[]
[{"$nulls":3},"Page",null,5]
[]
[{"$nulls":3},"Page",null,6]
[]
[{"$nulls":3},"Page",null,7]
[]
[{"$nulls":3},"Page",null,8]
[]
[{"$nulls":3},"Page",null,9]
[]
[{"$nulls":3},"Page",null,10]
{"$rows_empty":26}
[{"$nulls":3},"Total Collections Carried to Section Summary"]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"PERIMETER","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"hidden":true}
[]
[]
[null,"CAD MEASUREMENTS","DISTANCE","UNITS"]
[]
[null,"MESH FENCE",{"$f":"63.74733+421.13859+1079.37987+8.84032+1071.63976+29.53055+1.13553+78.36768+0.59424+0.65149+10.75625+122.53615+337.91978+0.22671+0.44815+70.50533+213.4842+304.33413+50.25525+70.99909+83.69451+146.48879+22.96352+173.86365+36.68808+22.39569+194.79996+6.47028+12.91092+38.61716+246.53591+4.25233+214.07689+34.01007+133.60142+109.21712+29.37345+31.47088+96.33785+157.47641+2.20522+2.29891+2.44546+198.17779+478.7641+122.73166+367.64583+218.85671+52.81412+180.55067+16.22396+24.6463+36.19183+55.47299+25.29407+41.3954+117.92321+243.14966+460.58924+33.01387+21.74897+4.12635+3.06585+277.36007+156.44927+39.011+2.96362+45.24257+24.27105+9.70938+102.28701+0.67046+0.78992+2.11749+99.8151+31.88762+104.95066+57.54234","v":9396.135020000003},"m"]
[null,"CONCRETE WALL",{"$f":"180.62553+1.35616+10.70647+50.44849+148.78912+105.00247","v":496.92823999999996},"m"]
[null,"SWING GATES",14,"no"]
[null,"SLIDING GATES ",3,"no"]
[]
[]
[null,"total length of fence",{"$f":"C5+C6","v":9893.063260000003},"m",{"$f":"C11/1000","v":9.893063260000003},"km"]
[null,"clear - 6*9893.06326",{"$f":"C11*6","v":59358.379560000016},"m2",{"$f":"C12/10000","v":5.935837956000001},"ha","assume 6m wide strips"]
[null,"take down",{"$f":"E11","v":9.893063260000003},"km"]
[null,"MESH",{"$f":"C5","v":9396.135020000003},"M"]
[null,"CONCRETE",{"$f":"C6","v":496.92823999999996},"M"]
[null,"MESH fence poles",{"$f":"C14/3.39+1","v":2772.721244837759},"no"]
[null,"Gate poles",{"$f":"(C7*2)+(C8*3)","v":37},"no"]
[null,"CONCRET POLES",{"$f":"C6/5","v":99.38564799999999},"NO"]
[null,"MESH fence poles",{"$f":"C16*0.6*0.4","v":665.4530987610622},"M3"]
[null,"Gate poles",{"$f":"C17*0.4*1.2","v":17.76},"M3"]
[null,"CONCRET POLES",{"$f":"C18*0.9*1.2","v":107.33649983999999},"M3"]
[null,"plinth-400*200",{"$f":"(C11*0.4*0.2)-(C19-C20-C21)","v":251.08846187893812},"M3"]
[null,"TOTAL EVA.",{"$f":"SUM(C19:C22)","v":1041.6380604800001}]

{"sheet":"INTERNAL ","index":5,"n_rows":26,"n_cols":12,"rows_kept":26,"hidden":true}
[]
[]
[null,"CAD MEASUREMENTS"]
[]
[null,"MESH FENCE",{"$f":"12.22128+5.85349+6.13151+531.68731+9.50687+3.10896+8.41316+22.1572+52.58038+92.8243+118.71202+4.0841+1.56841+18.0625+5.21519+10.8935+62.6295+74.60521+4.54603+7.24424+7.81121+19.05787+158.0083+35.958+259.67162+46.59915+375.00939+231.91567+6.35037+5.24024+72.23237+102.6533+0.9102+74.82385+98.61622+14.40974+8.9735+5.73526+4.24248+2.99138+3.14032+4.98091+20.08704+100.92313+359.17861+23.15248+159.4503+325.38913+11.01326+31.06229+20.22568+77.18396+25.88776+25.88776+2.26341+73.06955+48.48006+56.18225+84.29817+18.62191+18.12313+3.60424+1.14608+64.52159+10.0275+3.41238+2.33009+41.73778+72.67128+75.06976+305.21081+59.88674+15.48651+40.68073+78.38517+119.39749+60.1938+117.99498+47.19209+1.80077+0.87772+50.13927+30.66278+21.94614+297.99479+76.61396+62.14974+165.28279+22.09131+38.49214+83.874+183.81133+101.99201+12.35141+12.47276+7.34115+25.26952+2.38367+39.15873+4.99961+21.0646+40.32974+13.36446+325.36004","v":6832.629849999999},"m"]
[null,"CONCRETE WALL",null,"m"]
[null,"SWING GATES",7,"no"]
[null,"SLIDING GATES ",7,"no"]
[null,"PED GATE",2,"no"]
[null,"TURNSTILE GATE",6,"no"]
[]
[]
[]
[null,"total length of fence",{"$f":"C5+C6","v":6832.629849999999},"m",{"$f":"C14/1000","v":6.832629849999999},"km"]
[null,"clear - 6*9893.06326",{"$f":"C14*6","v":40995.7791},"m2",{"$f":"C15/10000","v":4.09957791},"ha","assume 6m wide strips"]
[null,"take down",{"$f":"E14","v":6.832629849999999},"km"]
[null,"MESH",{"$f":"C5","v":6832.629849999999},"M",null,null,{"$f":"F17+C19","v":2016.5250294985249}]
[null,"CONCRETE",{"$f":"C9","v":2},"M"]
[null,"MESH fence poles",{"$f":"C17/3.39+1","v":2016.5250294985249},"no"]
[null,"Gate poles",{"$f":"(C7*2)+(C8*3)+(C9*2)+(C10*2)","v":51},"no"]
[null,"CONCRET POLES",{"$f":"C6/5","v":0},"NO"]
[null,"MESH fence poles",{"$f":"C19*0.6*0.4","v":483.96600707964603},"M3"]
[null,"Gate poles",{"$f":"C20*0.4*1.2","v":24.48},"M3",{"$nulls":7},{"$f":"0.4*0.2*10000","v":800.0000000000001}]
[null,"CONCRET POLES",{"$f":"C21*0.9*1.2","v":0},"M3"]
[null,"plinth-400*200",{"$f":"(C14*0.4*0.2)-(C22-C23-C24)","v":87.12438092035393},"M3"]
[null,"TOTAL EVA.",{"$f":"SUM(C22:C25)","v":595.570388},"M3"]

{"sheet":"Measured works","index":6,"n_rows":48,"n_cols":7,"rows_kept":48,"hidden":true}
[]
[]
["Item","Payment ref.","Description","Unit","Quantity","Rate","Amount"]
[]
[null,"SANS 1200 C","Site Clearance"]
[]
[null,"8.2.3","Remove and grub large trees and tree stumps of girth","ha",{"$f":"PERIMETER!E12+'INTERNAL '!E15","v":{"v":10.035415866000001,"d":"10.04"}},null,{"$f":"F7*E7","v":0}]
[]
[null,"8.2.5","Take down existing fence","km",{"$f":"PERIMETER!E11+'INTERNAL '!E14","v":{"v":16.72569311,"d":"16.73"}},null,{"$f":"F9*E9","v":0}]
[]
[null,"SANS 1200D","Earthworks"]
[]
[null,"8.3.1","Site Prepaparation"]
[null,"8.3.1.1","Clear and strip site","m2",{"$f":"PERIMETER!C12+'INTERNAL '!C15","v":{"v":100354.15866000002,"d":"100354.16"}},null,{"$f":"F14*E14","v":0}]
[]
[null,"8.3.3","Restricted Excavation"]
[null,"a)","Excavate for restricted foudations, footings and pipe trenchs in all materials and use for backfill or dispose.","m3",{"$f":"PERIMETER!C23+'INTERNAL '!C26","v":{"v":1637.2084484800002,"d":"1637.21"}},null,{"$f":"F17*E17","v":0}]
[null,"b)","Extra-over for"]
[null,"1)","intermediate excavation","m3",{"$f":"E17*0.2","v":{"v":327.4416896960001,"d":"327.44"}},null,{"$f":"F19*E19","v":0}]
[null,"2)","hard rock excavation ","m3",{"$f":"E17*0.1","v":{"v":163.72084484800004,"d":"163.72"}},null,{"$f":"F20*E20","v":0}]
[]
[]
[null,"SANS ","Fence"]
[null,null,"Steel Weld Mesh Fence "]
[]
[null,null,"1500 x 1800m swing pedestrian gate including Union 3122 or similar approved padlock (Internal)","no",{"$f":"'INTERNAL '!C9","v":2},null,{"$f":"F26*E26","v":0}]
[]
[null,null,"4500 x 1800m swing double leaf vehicle gate including Union 3122 or similar approved padlock (Internal)","no",{"$f":"'INTERNAL '!C7","v":{"v":7,"d":"7.00"}},null,{"$f":"F28*E28","v":0}]
[]
[null,null,"4500 x 2900m swing double leaf vehicle gate including Union 3122 or similar approved padlock (Perimeter) ","no",{"$f":"PERIMETER!C7","v":{"v":14,"d":"14.00"}}]
[]
[null,null,"4500 x 1800m sliding vehicle gate including Union 3122 or similar approved padlock (Internal)","no",{"$f":"'INTERNAL '!C8","v":{"v":7,"d":"7.00"}},null,{"$f":"F32*E32","v":0}]
[]
[null,null,"4500 x 2700m sliding vehicle gate including Union 3122 or similar approved padlock (Perimter)","no",{"$f":"PERIMETER!C8","v":{"v":3,"d":"3.00"}},null,{"$f":"F34*E34","v":0}]
[]
[null,null,"1500 x 1800mm turnstile gate ","no",{"$f":"'INTERNAL '!C10","v":{"v":6,"d":"6.00"}},null,{"$f":"F36*E36","v":0}]
[]
[null,null,"Supply and erect new 2.7 m high mesh perimeter secuirty fence including the accessories, anti-climb, anti-burrow, etc, as per the typical drawings","m",{"$f":"PERIMETER!C14","v":{"v":9396.135020000003,"d":"9,396.14"}},null,{"$f":"F38*E38","v":0}]
[]
[null,null,"Supply and erect new 1.8 m high mesh internal secuirty fence including the accessories as per the typical drawings","m",{"$f":"'INTERNAL '!C17","v":{"v":6832.629849999999,"d":"6,832.63"}},null,{"$f":"F40*E40","v":0}]
[]
[null,null,"High-Security Large Panel Wall"]
[]
[null,null,"Supply and erect new 3.6 m high concrete panel perimeter secuirty fence including the accessories, anti-climb, anti-burrow, etc, as per the typical drawings","m",{"$f":"PERIMETER!C15","v":{"v":496.92823999999996,"d":"496.93"}},null,{"$f":"F44*E44","v":0}]
[]
[]
[]
[{"$nulls":6},{"$f":"SUM(G4:G46)","v":0}]

{"sheet":"MEASURED GATES (PARAMETE)","index":7,"n_rows":14,"n_cols":9,"rows_kept":14,"hidden":true}
["NAMES","LENGTH","UNITS","GATE TYPE"]
["FORESHORE GATES",2.9,"M","SWING GATE",null,null,"AUTOMATIC"]
["WEST BANK MAIN ENTRANCE ",8.6,"M","SWING GATE",null,null,"NON-AUTOMATIC"]
["ENTRANCE TO BLACK TANK",5.78,"M","SWING GATE"]
["DR ZAHN RAIL WAY GATE",5.8,"M","SWING GATE"]
["DR ZAHN GATE",4.59,"M","SWING GATE"]
["EMD BUILDING ",5.8,"M","SWING GATE"]
["ELBA",4.2,"M","SWING GATE"]
["SEA SPIRIT MAIN ENTRANCE",6,"M","SLIDING GATE",{"$nulls":3},"NOTE: SWING GATE","SWING GATE TO DIVIDE BY TWO TO GET SINGLE SWING GATE LENGTH "]
["PONTOON MAIN ENTRANCE",8.49,"M","SLIDING GATE"]
["PORT CONTROL ENTRANCE ",7.55,"M","SLIDING GATE"]
["TPT ONTAINER TERMINAL",9.9,"M","SLIDING GATE"]
["TPT ONTAINER TERMINAL",9.9,"M","SLIDING GATE"]
["TPT BEHIND COMBI BUILDING",6.2,"M","SLIDING GATE"]

{"sheet":"MEASURED GATES (INTERNAL)","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"hidden":true}
["NAMES","LENGTH","UNITS","GATE TYPE"]
["GANTEAUME CRESCENT PEDESTRIAN GATE",1.6,"M","PEDESTRIAN GATE",null,null,"AUTOMATIC"]
["GANTEAUME CRESCENT PEDESTRIAN GATE",5.8,"M","SWING GATE",null,null,"NON-AUTOMATIC"]
["PORT ADMIN ",6.9,"M","SWING GATE"]
["PORT ADMIN ",5.71,"M","SWING GATE"]
["PORT ADMIN ",1.1,"M","PEDESTRIAN GATE "]
["EAST LONDON YACHT CLUB",4.2,"M","SLIDING GATE"]
["TRAINING COLLEGE FRONT GATE",3.66,"M","SWING GATE"]
["HELY HUTCHINSON ROAD ",5.9,"M","SLIDING GATE",{"$nulls":3},"NOTE: SWING GATE","SWING GATE TO DIVIDE BY TWO TO GET SINGLE SWING GATE LENGTH "]
["DRY DOCK NEXT TO SUBSTATION ",8,"M","SLIDING GATE"]
["POLICE STATION INSIDE GATE",4.99,"M","SLIDING GATE"]
["DRY DOCK MAIN ENTRANCE ",7.57,"M","SWING GATE"]
["ADDITIONAL GATE NEAR DR DOCK",4.8,"M","SWING GATE"]
["POLICE STATION INSIDE GATE",5.86,"M","SLIDING GATE"]
["POLICE STATION INSIDE GATE",5.8,"M","SWING GATE"]
["PORT REX FIRE BUILDING ",4.3,"M","SWING GATE"]
["BUFFALO RIVER YACHT CLUB",4,"M","SWING GATE"]
["BUFFALO RIVER YACHT CLUB",1,"M","PEDESTRIAN GATE"]
["BUFFALO RIVER YACHT CLUB",1,"M","PEDESTRIAN GATE"]
["BUFFALO RIVER YACHT CLUB",6,"M","SLIDING GATE"]
["FORESHORE SERVICE ",3.02,"M","SWING GATE"]
["FORESHORE SERVICE ",3,"M","SWING GATE"]
["ENTRANCE AT FORESHORE GRAIN SILO",5.5,"M","SWING GATE"]
["FORESHORE SERVICE ",6.52,"M","SLIDING GATE"]
["FORESHORE SERVICE ",9.7,"M","SWING GATE"]
["FORESHORE SERVICE ",5.6,"M","SWING GATE"]
["FORESHORE SERVICE ",6.87,"M","SWING GATE"]
["MBSA ENTRANCE ",5.48,"M","SWING GATE"]
["MBSA ENTRANCE ",10,"M","SLIDING GATE"]
["MBSA ENTRANCE ",4.5,"M","SWING GATE"]
["MBSA ENTRANCE ",9,"M","SLIDING GATE"]
["CAR STATIONING OPPOSITE MBSA ENTRANCE ",10,"M","SLIDING GATE"]
["CAR STATIONING OPPOSITE MBSA ENTRANCE ",8.8,"M","SWING GATE"]
["C-BERTH ENTRANCE ",6.52,"M","SLIDING GATE"]
["C-BERTH ENTRANCE ",1.14,"M","PEDESTRAIN GATE"]
["C-BERTH ENTRANCE ",6,"M","SWING GATE"]
["C-BERTH ENTRANCE ",1.7,"M","PEDESTRAIN GATE"]
["QUAY 3&4 ENTRANCES",6,"M","SWING GATE"]
["QUAY 3&4 ENTRANCES",8.3,"M","SLIDING GATE"]
["CONTAINER TERMINAL ENTRANCE ",9,"M","SLIDING GATE"]
["CONTAINER TERMINAL ENTRANCE ",4.4,"M","SWING GATE"]