{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["PRICING SCHEDULE","PRICELIST CONSUMABLES & REPAIR "],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":54,"n_cols":25,"rows_kept":54,"merged":[[0,0,0,7],[1,0,1,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,2,24]]}
["RT29-2024 PRICING SCHEDULE"]
["AUDIT AND TID CONVERSION OF EXISTING PREPAYMENT METERS AND THE SUPPLY, DELIVERY, INSTALLATION, MANAGEMENT, AND MAINTENANCE OF SMART METERING SOLUTION FOR A PERIOD OF THIRTY-SIX (36) MONTHS"]
["ITEM #","CATEGORY #","CATEGORY NAME","SERVICE/ ITEM DESCRIPTION","UNIT OF MEASURE","OFFER OPTION","NAME OF BIDDER","PRICE OFFERED  INCL. VAT (OUTRIGHT PURCHASE)","RENTAL PRICE OFFERED INCL. VAT (PER MONTH)","HDI SHARE-HOLDING %","FEMALE SHARE-HOLDING %","BRAND NAME","PRODUCT SUPPLIER CODE","NAME OF ORIGINAL PRODUCT MANUFACTURER","COUNTRY OF ORIGIN","LOCAL CONTENT AND PRODUCT COMPONENT %","IMPORT CONTENT AND PRODUCT COMPONENT %","FOREIGN CURRENCY NAME","LEAD TIME IN CALENDAR DAYS","MINIMUM ORDER QUANTITY ","COST BREAKDOWN %"]
[{"$nulls":20},"D1 -Imported Raw Material / Finished product (if applicable) (%)","D2 - Local Raw Material / Finished product (if applicable) (%)","D3 – Labour (%)","D4 – Transport (%)","D5 – Overheads (%)"]
["RT29-01-001","RT29-01SM","TID compliance and readiness ","Audit and TID conversion of existing electricity or water prepayment meter and submission of a detailed audit report, per meter","Per Meter","Offer 1"]
["RT29-01-002","RT29-01SM","TID compliance and readiness ","Create a third party TID vending change token with no physical site audit, price per TID conversion token issued","Per Meter","Offer 1"]
["RT29-01-003","RT29-01SM","TID compliance and readiness ","Create a USSD platform for a customer self-help service, price per TID token issued","Per Meter","Offer 1"]
["RT29-01-004","RT29-01SM","TID compliance and readiness ","Create a TID customer self-help web page on the existing service provider’s official web site, with direct links to a customer self-help USSD platform and direct access to the existing service providers vending platform ","Per web platform","Offer 1"]
["RT29-01-005","RT29-01SM","TID compliance and readiness ","Design and print a customer TID awareness flyer to accompany monthly accounts sent to customers, price for one customer account awareness flyer   ","Per flyer","Offer 1"]
["RT29-01-006","RT29-01SM","TID compliance and readiness ","Price to upgrade Supply Authority vending systems to STS Edition 2, per vending point software upgrade "," Per vending point","Offer 1"]
["RT29-01-007","RT29-01SM","TID compliance and readiness ","Third-party vending services cost only per vending point software upgrade ","Per vending point","Offer 1"]
["RT29-02-001","RT29-002SM","Smart meter solution","Site Establishment ",null,"Offer 1"]
["RT29-02-002","RT29-002SM","Smart meter solution","Project Public Participation/Awareness to include newsprint, billboards, fliers. At least one main billboard for the main municipal town,a one page black and white TID flier attached to all billable customer accounts for the municipalities customer base and one half page black and white newsprint article four times a week ending November 2024","Per advertising campaign","Offer 1"]
["RT29-02-003","RT29-002SM","Smart meter solution","Network Densification – Sigfox Base stations","Per base station","Offer 1"]
["RT29-02-004","RT29-002SM","Smart meter solution","Supply, Setup, Installation, Commissioning, Data Migration, and Configuration inclusive of Web Portal as detailed in the Scope of Services, over a period of three (3) years ","Once off cost","Offer 1"]
["RT29-02-005","RT29-002SM","Smart meter solution","Smart Metering Licenses ","Once-off annual fee","Offer 1"]
["RT29-02-006","RT29-002SM","Smart meter solution","Support and Maintenance for three (3) years for all technical related faults and in compliance to the contractual repair restoration times","Per month, per team","Offer 1"]
["RT29-02-007","RT29-002SM","Smart meter solution","Project Management for supply, installation, and configuration ONLY, for the duration of the project",null,"Offer 1"]
["RT29-02-008","RT29-002SM","Smart meter solution","Training of functional users (estimated at 50 users)","Per training session","Offer 1"]
["RT29-02-009","RT29-002SM","Smart meter solution","Provision of training and transfer of skills to ICT staff (Estimated at 15 staff members)","Per training session","Offer 1"]
["RT29-02-010","RT29-002SM","Smart meter solution","Prepaid Bulk SMSs for all consumers: Estimated at 100 000 000 SMS p.a. for smart meter data communication to the main data collector using cellular modems installed at each metering point","Per 100 000 000 required","Offer 1"]
["RT29-02-011","RT29-002SM","Smart meter solution","Onsite Staff – full-time (36 months), as detailed in the technical conditions of tender","Per team per month","Offer 1"]
["RT29-02-012","RT29-002SM","Smart meter solution","Price to supply a single phase smart “split type meter”  with communication module ","Per meter ","Offer 1"]
["RT29-02-013","RT29-002SM","Smart meter solution","Price to supply Customer Interface Unit as a replacement to a faulty interface unit","Per interface unit ","Offer 1"]
["RT29-02-014","RT29-002SM","Smart meter solution","Price to install a single-phase smart “split type”, electricity meter, customer interface unit and provide a detailed commissioning report and the associated guaranteed monthly billing for a period of three years, post smart meter installation, per smart meter, by making use of cellular communication.","Price per meter (outright purchase)/ Price per meter per month (Rental option)","Offer 1"]
["RT29-02-015","RT29-002SM","Smart meter solution","Price to supply a single-phase smart “split type meter” for communication to Concentrator Unit","Per meter","Offer 1"]
["RT29-02-016","RT29-002SM","Smart meter solution","Price to supply Data Concentrator Unit","Per data concentrator","Offer 1"]
["RT29-02-017","RT29-002SM","Smart meter solution","Price to install a single-phase smart “split type”, electricity meter and customer interface and provide a detailed commissioning report and the associated guaranteed monthly billing for a period of three years, post smart meter installation, per smart meter, by making use of a smart metering device and cellular communication between the data concentrator at each local transformer position and the main data collector ","Per meter ","Offer 1"]
["RT29-02-018","RT29-002SM","Smart meter solution","Price to supply a three-phase smart “ split type meter”  with a communication module and sim card","Per meter ","Offer 1"]
["RT29-02-019","RT29-002SM","Smart meter solution","Price to install a three-phase smart “split type”, electricity meter, customer interface unit and provide a detailed commissioning report and the associated guaranteed monthly billing for a period of three years, post smart meter installation, per smart meter, by making use of cellular communication.","Per meter ","Offer 1"]
["RT29-02-020","RT29-002SM","Smart meter solution","Price to supply a three-phase smart “split type meter” for communication to Concentrator Unit","Per Meter","Offer 1"]
["RT29-02-021","RT29-002SM","Smart meter solution","Price to install a three-phase smart “split type”, electricity meter and customer interface and provide a detailed commissioning report and the associated guaranteed monthly billing for a period of three years, post smart meter installation, per smart meter, by making use of a  smart metering device and cellular communication between the data concentrator at each local transformer position and the main data collector","Per Meter","Offer 1"]
["RT29-02-022","RT29-002SM","Smart meter solution","Price to supply a CT/VT smart 5A meter with communication module,","Per Meter","Offer 1"]
["RT29-02-023","RT29-002SM","Smart meter solution","Price to install a CT/VT smart meter, to include the hard wiring of the meter to the CT/VT metering panel but excludes the metering panel hard wiring ","Per meter ","Offer 1"]
["RT29-02-024","RT29-002SM","Smart meter solution","Price  to  supply  ultrasonic  smart  water  meter (20mm/25mm)","Per meter/device","Offer 1"]
["RT29-02-025","RT29-002SM","Smart meter solution","Price to supply Sigfox or LoRA enabled pulse device  ","Per device","Offer 1"]
["RT29-02-026","RT29-002SM","Smart meter solution","Price to re-program a new electricity tariff into an installed electricity smart meter in either prepayment or post-paid mode ","Per meter ","Offer 1"]
["RT29-02-027","RT29-002SM","Smart meter solution","Install smart water meter or similar device and provide a detailed commissioning report and the associated guaranteed monthly billing for a period of three years, post installation, per meter","Per meter ","Offer 1"]
["RT29-02-028","RT29-002SM","Smart meter solution","Price to install smart water meter with 220V electrical mains connection to the municipal grid in compliance with SANS10142. All electrical equipment must be suitably rated to withstand the ingress of water. The 220V supply will be used to supply the smart water meter with a continuous electrical supply independent of the installed smart meter backup battery life span. Price to include all hard wiring, electrical equipment, and weatherproof enclosures for a connection to the municipal electricity grid","Per meter","Offer 1"]
["RT29-02-029","RT29-002SM","Smart meter solution","Fixed price to integrate smart metering system to existing SCADA network for DEMAND load control application, per Supply authority site SCADA location","Per software interface development between SCADA and the smart metering system","Offer 1"]
["RT29-02-030","RT29-002SM","Smart meter solution","Price to perform a smart metering integrity inspection and to re-commision a new smart meter to replace a faulty smart meter where the fault does not fall under the warranty conditions","Per new smart meter installation ","Offer 1"]
["RT29-03-001","RT29-003SM","Smart Load Management Solution","C – SMART LOAD MANAGEMENT SOLUTION "," ","Offer 1"]
["RT29-03-002","RT29-003SM","Smart Load Management Solution","Site Establishment "," ","Offer 1"]
["RT29-03-003","RT29-003SM","Smart Load Management Solution","Project Public Participation/Awareness  "," ","Offer 1"]
["RT29-03-004","RT29-003SM","Smart Load Management Solution","Project Management for supply, installation, and configuration ONLY, for the duration of the project "," ","Offer 1"]
["RT29-03-005","RT29-003SM","Smart Load Management Solution","Training of functional users (estimated at 50 users) ","Per training session","Offer 1"]
["RT29-03-006","RT29-003SM","Smart Load Management Solution","Provision of training and transfer of skills to ICT staff (Estimated at 15 staff members)","Per training session","Offer 1"]
["RT29-03-007","RT29-003SM","Smart Load Management Solution","Onsite Staff – full-time (36 months), as detailed in the Scope of Services ","Per team per month","Offer 1"]
["RT29-03-008","RT29-003SM","Smart Load Management Solution","Price to supply a load management device for geysers integrated to the smart metering system functionality (whereby this load can be disconnected from the municipal grid at any given time) . ","Per Device","Offer 1"]
["RT29-03-009","RT29-003SM","Smart Load Management Solution","Fixed price to integrate smart metering system to existing SCADA network software for DEMAND load control application, per Supply authority site SCADA location\n(NB - The intent is to limit installed capacity from a60 A supply to a 40/30/20/10 A supply for each installed smart meter)",null,"Offer 1"]
["RT29-03-010","RT29-004SM","On-site management oversite","D - On-site management oversite /maintenance team (for either part A, B or C above) and as per Supply Authority’s requirements","Maintenance team per month","Offer 1"]
["RT29-03-011","RT29-004SM","On-site management oversite","Price for on-site management engineer to oversee project completion, per Engineer required, per month "," Per Engineer required, per month ","Offer 1"]
["RT29-03-012","RT29-004SM","On-site management oversite","Price for one on-site maintenance electrician to maintain the installed smart metering equipment, post 20000 smart meter/device installations, per electrician required, per month. ","Per electrician required, per month. ","Offer 1"]
["RT29-03-013","RT29-004SM","On-site management oversite","Price to supply and install a 60-inch TV monitor in a control room set up to manage, display and manage smart meter alarm signals and to display a dashboard of all installed smart meters. Dashboard to include, but not limited to:\nA.\tGraphical representation of installed smart meters with GPS location. \nB.\tNumber of smart meters installed. \nC.\tColour coding of correct functioning smart meters \nD.\tDifferent colour coding of non-functioning smart meters and respective reasons \nE.\tColour coding of demand-managed smart meters and respective limited amperage "," Price per monitor","Offer 1"]

{"sheet":"PRICELIST CONSUMABLES & REPAIR ","index":1,"n_rows":13,"n_cols":25,"rows_kept":13,"merged":[[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,20,1,24]]}
["RT29-2024 PRICING FOR CONSUMABLES AND REPAIR PARTS"]
["LINE # ","SUPPLIER ITEM NUMBER ","ITEM DESCRIPTION","NAME OF BIDDER","DELIVERY PRICE INCL. VAT","UNIT OF MEASURE","OFFER OPTION","PRICE OFFERED  INCL. VAT (OUTRIGHT PURCHASE)","RENTAL PRICE OFFERED INCL. VAT (PER MONTH)","HDI SHARE-HOLDING %","FEMALE SHARE-HOLDING %","BRAND NAME","PRODUCT SUPPLIER CODE","NAME OF ORIGINAL PRODUCT MANUFACTURER","COUNTRY OF ORIGIN","LOCAL CONTENT AND PRODUCT COMPONENT %","IMPORT CONTENT AND PRODUCT COMPONENT %","FOREIGN CURRENCY NAME","LEAD TIME IN CALENDAR DAYS","MINIMUM ORDER QUANTITY ","COST BREAKDOWN %"]
[{"$nulls":20},"D1 -Imported Raw Material / Finished product (if applicable)","D2 - Local Raw Material / Finished product (if applicable)","D3 – Labour","D4 – Transport","D5 – Overheads"]
[1,{"$nulls":5},"Offer 1"]
[2,{"$nulls":5},"Offer 1"]
[3,{"$nulls":5},"Offer 1"]
[4,{"$nulls":5},"Offer 1"]
[5,{"$nulls":5},"Offer 1"]
[6,{"$nulls":5},"Offer 1"]
[7,{"$nulls":5},"Offer 1"]
[8,{"$nulls":5},"Offer 1"]
[9,{"$nulls":5},"Offer 1"]
[10,{"$nulls":5},"Offer 1"]