{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["PRELIMINARY","SUPPLY & INSTALATION","SUMMARY"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"PRELIMINARY","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[2,1,2,5],[3,1,3,5],[4,1,4,5],[33,3,33,4]]}
[]
[]
[null,"NALA LOCAL MUNICIPALITY"]
[null,"APPOINTMENT OF A SERVICE PROVIDER FOR THE IMPLEMENTION OF ENERGY EFFICIENCY AND DEMAND SIDE MANAGEMENT (EEDSM)  WITHIN NALA LOCAL MUNICIPALITY FOR A PERIOD OF 36 MONTHS SUBJECT TO AVAILABILITY OF FUNDING FROM NATIONAL TREASURY"]
[null," SECTION 1: PRELIMINARY AND GENERAL"]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE      (ZAR)"]
[null,1,"PRELIMINARY AND GENERAL TASKS: "]
[]
[]
[null,"1.1","Compliance With OHS  And Contract Conditions","Sum",1]
[]
[null,null,"Safety File,Inductions,Insurances,etc"]
[]
[null,"1.2","Site Establishment",null,1]
[]
[null,null,"Allow for  site establishment, all associated services and for storage of plant,project board,crane hiring, materials and equipment including protection of the material,Transport","Sum"]
[]
[null,"1.3","Project Planning"]
[]
[null,null,"Compilation of Energy Consumption Baseline Reports, Businnes Plan and Work Plans","%",1,"Maximum 7%"]
[]
[null,"1.4","Project Management"]
[]
[null,null,"Recruitment of Local Technicians","%",1,"Maximum 5%"]
[]
[null,"1.5","Capacity Building and Training"]
[null,null,"Development of capacity building and training plan for local technicians","%",1,"Maximum 1%"]
[null,"1.6","Energy Efficiency Awareness Campaigns"]
[]
[null,null,"Development of a municipal energy efficiency awareness plan","%",1,"Maximum 1%"]
[null,"1.7","Metering & Online Monitoring"]
[{"$nulls":3},"%",1,"Maximum 8%"]
[]
[null,null,"TOTAL FOR SECTION 2: PRELIMINARY TO SUMMARY","Amount Carried Forward"]

{"sheet":"SUPPLY & INSTALATION","index":1,"n_rows":121,"n_cols":8,"rows_kept":121,"merged":[[1,1,1,7],[2,1,2,7],[3,1,3,7],[6,2,6,7],[7,2,7,7],[120,3,120,5]]}
[]
[null,"NALA LOCAL MUNICIPALITY"]
[null,"APPOINTMENT OF A SERVICE PROVIDER FOR THE IMPLEMENTION OF ENERGY EFFICIENCY AND DEMAND SIDE MANAGEMENT (EEDSM)  WITHIN NALA LOCAL MUNICIPALITY FOR A PERIOD OF 36 MONTHS SUBJECT TO AVAILABILITY OF FUNDING FROM NATIONAL TREASURY"]
[null,"SECTION 2: SUPPLY AND INSTALLATION"]
[null,"ITEM","DESCRIPTION","TASK","UNIT","QTY","RATE  (ZAR)","AMOUNT         (ZAR)"]
[null,2,"SUPPLY AND INSTALLATION"]
[null,null,"NOTE:   "]
[null,null,"The  complete  electrical  installations  shall  comply  with the  SANS10142  -  1:2003 - for  the Wiring  of  Premises.  All electrical equipment/material shall comply with the latest and relevant SANS/IEC Standards. Equipment/Material  Type Test Reports/Certification and Technical Datasheets to be submitted and approved by the municipality prior to ordering/purchase of material"]
[null,"2.1","30W LED Streetlight (100-277V AC. 4100 Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.2","50W LED Streetlight (100-277V AC. 7000 Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.3","60W LED Streetlight (100-277V AC. 7000 Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.4","110W LED Streetlight (100-277V AC. 14000 Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.5","180W LED Streetlight (100-277V AC. 24000 Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.6","200W LED Floodlight (100-277V AC. 32000 Lm. 4000K. Medium Beam)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.7","400W LED Floodlight (100-277V AC. 64000 Lm. 4000K. Medium Beam)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.8","20W Solar Streetlight (c/w 60W Solar Panel. 36AH. 12V Lithium Battery. 12 hour run time on full charge. 3000Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.9","40W Solar Streetlight (c/w 120W Solar Panel. 50AH Lithium Battery12V. 12 hour run time on full charge. 6000Lm. 4000K. Type II)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.10","9W T8 LED Tube (600mm. 230V AC. 1170 Lm. 4000K)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.11","18W T8 LED Tube (1200mm. 230V AC. 2400 Lm. 4000K)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.12","24W T8 LED Tube (1500mm. 230V AC. 3200 Lm. 4000K)","Supply","No",1]
[{"$nulls":3},"Install","No",1]
[null,"2.13","5 kWp PV, Grid-tie, roof mount (complete system) excluding battery storage","Supply & Install","No",1]
[null,"2.14","10 kWp PV, Grid-tie, roof mount (complete system) excluding battery storage","Supply & Install","No",1]
[null,"2.15","50 kWp PV, Grid-tie, Ground Mount Structure (complete system) including battery storage","Supply & Install","No",1]
[null,"2.16","50 kWp PV, Grid-tie, Ground Mount Structure (complete system) excluding battery storage","Supply & Install","No",1]
[null,"2.17","100 kWp PV, Grid-tie, Ground Mount Structure (complete system) excluding battery storage","Supply & Install","No",1]
[null,"2.18","100 kWp PV, Grid-tie, Ground Mount Structure (complete system) including battery storage","Supply & Install","No",1]
[null,"2.19","10kWh, 48V DC lithiun Ion Battery storage for Solar PV","Supply & Install","No",1]
[null,"2.20","0,5KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.21","1,1KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.22","1,5KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.23","2,2KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.24","3KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.25","4KW Motor 3ph IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.26","5.5KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.27","7.5KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.28","11KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.29","15KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.30","18.5KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.31","22.5KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.32","30KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.33","37KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.34","45KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.35","55KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.36","75KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.37","110KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.38","160KW Motor. 3ph. IE3","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.39","15KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.40","18KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.41","22KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.42","30KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.43","37KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.44","45KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.45","55KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.46","75KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.47","110KW VSD 3ph","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.48","160KW VSD 3ph ","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.49","Miscellaneous (cabling. clamps. and other accessories) for Motors","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.50","Miscellaneous (cabling. clamps. and other accessories) for VSDs","Supply","no",1]
[{"$nulls":3},"Install","no",1]
[null,"2.51","9000 BTU Interter Split Type AirConditioner","Supply & Install","no",1]
[null,"2.52","12000 BTU Interter Split Type AirConditioner","Supply & Install","no",1]
[null,"2.53","18000 BTU Interter Split Type AirConditioner","Supply & Install","no",1]
[null,"2.54","24000 BTU Interter Split Type AirConditioner","Supply & Install","no",1]
[null,"2.55","30000 BTU Interter Split Type AirConditioner","Supply & Install","no",1]
[null,"2.56","PLC Control Panel (incl. power supply, UPS)…(Enclosed control panel with industrial-grade PLC (Siemens/Schneider/AB/Equivalent), power supply, fuses, and UPS backup)","Supply & Install","no",1]
[null,"2.57","HMI Interface…(7\" – 10\" touchscreen panel with plant visualisation and alarm status)","Supply & Install","no",1]
[null,"2.58","SCADA SYSTEM…(Centralised SCADA software for supervisory monitoring, reporting, remote login)","Supply & Install","no",1]
[null,"2.59","Level Sensors…(Ultrasonic or radar-type level sensors in sump/pump stations)","Supply & Install","no",1]
[null,"2.60","Flow Sensors…(Electromagnetic or ultrasonic flow meters inline with pump outlets)","Supply & Install","no",1]
[null,"2.61","DO Sensors (aeration tanks)…(Online dissolved oxygen sensor with 4-20 mA output)","Supply & Install","no",1]
[null,"2.62","Control Logic…(Must include auto/manual override, scheduling, PID tuning, fault detection, interlocks)","Supply & Install","no",1]
[null,"2.63","Motor Starters & MCC…(Combination starters (DOL or Soft Starter); Switch gear; full motor protection)","Supply & Install","no",1]
[null,"2.64","Combination starters (DOL or Soft Starter where VSDs not used); full motor protection","Supply & Install","no",1]
[null,"2.65","AC Cabling and Trunking…(Industrial cable management (SWA cables, glands, trunking)","Supply & Install","no",1]
[null,"2.66","Fieldbus Cabling and Trunking…(digital communication management system ","Supply & Install","no",1]
[null,"2.67","Commissioning & Testing…(Site testing, simulation of conditions, operator training)","Supply & Install","no",1]
[null,null,"Post Installation Monitoring and Maintenance (12 months period)","Supply & Install","no",1]
[]
[null,null,"TOTAL FOR SECTION 3: SUPPLY AND INSTALLATION TO SUMMARY","Amount Carried Forward"]

{"sheet":"SUMMARY","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[11,0,12,1],[13,0,13,1],[14,0,14,1]]}
["NALA LOCAL MUNICIPALITY"]
["APPOINTMENT OF A SERVICE PROVIDER FOR THE IMPLEMENTION OF ENERGY EFFICIENCY AND DEMAND SIDE MANAGEMENT (EEDSM)  WITHIN NALA LOCAL MUNICIPALITY FOR A PERIOD OF 36 MONTHS SUBJECT TO AVAILABILITY OF FUNDING FROM NATIONAL TREASURY"]
["SUMMARY"]
[]
["BROUGHT FORWARD FROM SECTION NO.","DESCRIPTION","AMOUNT"]
[]
["Section 1","PRELIMINARY AND GENERAL","R"]
[]
[]
["Section 2","SUPPLY AND INSTALLATION","R"]
[]
["TOTAL: SECTION 1 + SECTION 2 "]
[null,null,"R"]
["VAT@ 15%",null,"R"]
["GRANT TOTAL",null,"R"]