{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Total Cost"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Total Cost","index":0,"n_rows":98,"n_cols":8,"rows_kept":98,"merged":[[0,1,1,1],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7]]}
[null,"#","Description","Unit","Qty","Supply R/Unit","Install R/Unit","R Total"]
[null,null,"Note: Rates must be supplied with site conditions in mind and as per the requirements in the scope of works"]
[]
[]
[null,1,"EXCAVATION"]
[]
[null,"1.1","Excavate a trench 450 mm wide x 700 mm deep to lay cable, marker tape, backfill, compaction and reinstatement of surface. Excavate a trench 450 mm wide x 700 mm deep to lay cable, marker tape, backfill, compaction and reinstatement of surface.","m3",80]
[]
[null,"1.2","Excavation of 600 mm deep holes for planting of GRP poles. (according to Annexure A)","no.",50]
[]
[null,1.3,"Excavation of 1200 mm deep holes for planting of galvanized poles. (according to Annexure A)","no.",23]
[]
[null,null,"Note: All street lighting supports to be supplied complete with poles, switchgear compartment & cover plates, base plates where applicable etc."]
[]
[null,2,"Existing Post top luminaires (38W 4000K LED) - See lighting schedule"]
[null,"2.1","Post top luminaires.","no.",26]
[null,"2.2","GRP Poles (color as specified)","no.",26]
[]
[null,3,"New Post top luminaires (38W 4000K LED) - See lighting schedule"]
[null,"3.1","Post top luminaires","no.",24]
[null,"3.2","GRP Poles (see Scope of Works)","no.",24]
[null,"3.3","2,5mm² conductor PVC (Red)","m",600]
[null,"3.4","2,5mm² conductor PVC (black)","m",600]
[null,"3.5","20mm PVC conduit (per 4m length)","no.",20]
[]
[]
[null,4,"Replace Undercover Parking Lighting (LED 4ft 27W 4000K) - See lighting schedule","no.",50]
[]
[null,null,"New Shaded Parking Luminaires (with all fittings)"]
[null,"4.1","New Luminaire (LED 4ft 27W 4000K)","no.",14]
[null,"4.2","20mm PVC conduit (per 4m length)","no.",14]
[null,"4.3","2,5mm² conductor PVC (Red)","m",600]
[null,"4.4","2,5mm² conductor PVC (black)","m",600]
[]
[]
[null,5,"Replacement of Flood lights (LED 4000K 81W) - See lighting schedule (External Building Lighting","no.",30]
[]
[null,6,"Additional Flood Lights"]
[null,"6.1","New Luminaires (LED 4000K 81W) (fitted at 90 degrees)","no.",2]
[null,"6.2","11.6m Hot-dipped Galvanised Poles (see Scope of Works)","no.",1]
[null,"6.3","2,5mm² conductor PVC (Red)","m",200]
[null,"6.4","2,5mm² conductor PVC (black)","m",200]
[]
[]
[null,7,"Perimeter Street lights: replacement of the existing luminaires"]
[null,"7.1","Single Luminaire only - High Mast LED 72W 4000K - See lighting schedule","no.",12]
[null,"7.2","Double Luminaire Positoned @ 90 degrees on single mast - High Mast LED 72W 4000K","no.",2]
[]
[null,8,"New Perimeter Streetlights"]
[null,"8.1","New Luminaire only - High Mast LED 72W 4000K - See lighting schedule","no.",19]
[null,"8.2","Hot-dipped Galvanised steel streetlight poles. 150mm spigot (see Scope of Works)","no.",19]
[null,"8.3","2,5mm² conductor PVC (Red)","m",600]
[null,"8.4","2,5mm² conductor PVC (black)","m",600]
[null,"8.5","20mm PVC conduit (per 4m length)","no.",50]
[]
[]
[null,9,"Entrance to building (main reception)"]
[null,null,"Replacement of up/down lights (7W LED 50 degrees)","no.",4]
[]
[null,10,"New bulkheads"]
[null,"10.1","BULKHEAD 15W BLACK 4000K WHITE LED","no.",16]
[null,"10.2","2,5mm² conductor PVC (Red)","m",400]
[null,"10.3","2,5mm² conductor PVC (black)","m",400]
[null,"10.4","20mm PVC conduit (per 4m length)","no.",20]
[]
[]
[null,11,"New Area Lighting (Satelite area - C-band)"]
[null,"11.1","New Luminaires (LED 4000K 116W) - Luminaires to be fitted fitted at 90 degrees on a single pole","no.",12]
[null,"11.2","Hot-dipped Galvanised steel streetlight poles. 4 way bracket/sprigot (see Scope of Works)","no.",3]
[null,"11.3","2,5mm² conductor PVC (Red)","m",200]
[null,"11.4","2,5mm² conductor PVC (black)","m",200]
[null,"11.5","20mm PVC conduit (per 4m length)","no.",25]
[]
[]
[null,12,"Replacement of all photocells. Timer switches to be replaced with Photocells","no.",6]
[]
[null,13,"STREETLIGHTING CONTROL PANEL CONNECTIONS"]
[]
[null,"13.1","Connect street light poles into streetlight circuits.","Sum",1]
[]
[null,"13.2","Labeling for this section","Sum",1]
[]
[null,14,"Provisional Sum Items"]
[]
[null,"14.1","Damaged cabling","Sum",1,"R 20 000.00"]
[null,"14.2","Lamps","Sum",1,"R 20 000.00"]
[]
[null,14,"Commissioning and Testing (see scope of works)","Sum",1]
[]
[null,15,"Subtotal"]
[]
[null,16,"CONTINGENCY @10%"]
[]
[null,17,"ADD 15 % VAT (15+16)"]
[]
[]
[null,18,"TENDER TOTAL INCLUDING VAT (Items 15+16+17)"]
[null,"*","Note: \n1. See Lighting Schedule in Annexure A of Scope of Works to comply with Luminaire Technical Requirements.\n2. All luminaires and poles must be supplied complete with all necessary fittings and accessories required to ensure full and proper installation and operation."]