{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Anex D 1_PTA","Anex D.1.1_ Solar PTA","Anex D.2_ JHB","Anex D.3_DUR","Anex D.4_ Rosebank","Anex D.5_Stellenbosch"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[6,0,6,3],[7,0,7,3],[9,0,9,4],[10,2,10,3]]}
[]
["TABLE 1:"]
["Section Total Costings"]
["Description/Trade","Unit","Quantity ","Rate","Amount"]
["Testing, configuration and linking of devices to the new platform","Sum",{"$f":"('Anex D 1_PTA'!C88+'Anex D.1.1_ Solar PTA'!C16+'Anex D.2_ JHB'!C8+'Anex D.3_DUR'!C9+'Anex D.4_ Rosebank'!C13+'Anex D.5_Stellenbosch'!C11)","v":103}]
["Safety File","Item",1]
["Total (excl. vat.)"]
["Total (incl. 15% vat.)"]
[]
["TABLE 2:"]
["Section Total Costings",{"$nulls":3},"TOTAL"]
["Description/Trade","Unit","Quantity ","Rate","Amount"]
[" Year 1  Management  fees;\nReporting (As per section 3.1 of the RFP);\nOperations/Technical Support  (As per section 3.1 of the RFP)\n","Monthly",12]
[" Year 2  Management  fees;\nReporting (As per section 3.1 of the RFP);\nOperations/Technical Support  (As per section 3.1 of the RFP)\n","Monthly",12]
[" Year 3  Management  fees;\nReporting (As per section 3.1 of the RFP);\nOperations/Technical Support  (As per section 3.1 of the RFP)\n","Monthly",12]
[" Year 4  Management  fees;\nReporting (As per section 3.1 of the RFP);\nOperations/Technical Support  (As per section 3.1 of the RFP)\n","Monthly",12]
[" Year 5  Management  fees;\nReporting (As per section 3.1 of the RFP);\nOperations/Technical Support  (As per section 3.1 of the RFP)\n","Monthly",12]
["Safety File","Item",1]
["Total Contract Value (excl. vat.)"]
["Total (incl. 15% vat.)"]

{"sheet":"Anex D 1_PTA","index":1,"n_rows":180,"n_cols":5,"rows_kept":180,"merged":[[0,0,0,5]]}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Pta-Building 7 Air Handler Meter. No8070037","sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR-PTA-Building 3 Minisub Meter. No59522588","sum",1,null,{"$f":"C7*D7","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Building 13 Meter. No9070070","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 TH Meter. No9070009","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 32 Meter. No14260067","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building18 Mini Sub West Meter. No13250030","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR Paardefontein Meter. No58390818","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 21 Streetlight Meter. No9010073","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 6 Meter. No9070024","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 45 Meter. No9070067","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 49 Meter. No9050082","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 11 Wind Tunnel Meter. No44307233","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 7  Meter. No12150041","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 31 Meter. No11270020","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Food Pie Meter. No9060010","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 42 Meter. No9070003","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 32 Meter. No9060004","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building ICC hvac Meter. No9070069","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 8 Meter. No9050062","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 18 Workshop Meter. No9070060","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 Meter. No9050086","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14S Meter. No9050064","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 4 Meter. No9070032","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 37 Meter. No12310025","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 1 Meter. No13250032","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 36 Meter. No9070073","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 Offices Meter. No12450030","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 50 Newton's Restaurant Meter. No12330017","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Sub Station 21  Meter. No9070019","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  Denel c-block Meter. No9040048","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33 Meter. No9010067","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Entabeni Meter. No9050038","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR Building 11 - MSWT Office Meter. No11240037","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 18 Mini Sub East Meter. No11140066","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 38 Meter. No9010065","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 2 Meter. No8080026","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 17 Feeder 2 Meter. No60000353","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 Denel Meter. No9070042","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 40 Meter. No9070018","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33 Pump Meter. No9040095","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 20 Meter. No9070017","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 24 Gym Meter. No9070046","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 West Meter. No9070031","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR PTA Building 22 Meter. No9070010","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR PTA Building 22 Meter. No60000358","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 XYRIS Meter. No9050083","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 24  Meter. No9070057","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-CT-Rosebank HVAC A Meter. No56200820","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 34 Meter. No9070020","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14 North Meter. No9060019","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 23 Meter. No9060017","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  46F DB 60 Meter. No14170008","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 37 Meter. No9010038","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 17 Feeder 1 Meter. No60000354","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 5 Meter. No12150040","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 20 Meter. No12440018","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-CT-Rosebank HVAC B Meter. No65925164","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  46F DB 21 Meter. No14250021","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 19 Meter. No11110022","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Building 29 Meter. No12440047","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 HSWT  Meter. No9070037","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 44 Tower Meter. No56200822","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 East  Meter. No9070002","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14G Meter. No12150048","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 26  Meter. No9030049","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 Design Biologic Meter. No13250040","sum",1,null,{"$f":"C71*D71","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Building 10 Meter. No12250009","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 Chillers Meter. No12140042","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 15 Meter. No9070015","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 9  Meter. No9050061","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 30 Mini Sub Meter. No9050057","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 16 LSWT Meter. No57903083","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 35 Meter. No9070064","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 44 Meter. No8070057","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 MiniSub Meter. No9050059","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Knowledgecommons Meter. No12330018","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 26 132KV Meter. No9070065","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 28 Meter. No9010060","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 Meter. No9070056","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR Building 24 Energy Storage Meter. No60000357","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 Laser Meter. No9070059","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 41 Meter. No9070027","sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C6:C87)","v":82},null,{"$f":"SUM(E6:E87)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR-Pta-Building 7 Air Handler Meter. No8070037","monthly",{"$f":"12*3","v":36},null,{"$f":"C92*D92","v":{"v":0,"d":"R0.00"}}]
["CSIR-PTA-Building 3 Minisub Meter. No59522588","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 13 Meter. No9070070","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 TH Meter. No9070009","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 32 Meter. No14260067","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building18 Mini Sub West Meter. No13250030","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR Paardefontein Meter. No58390818","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 21 Streetlight Meter. No9010073","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 6 Meter. No9070024","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 45 Meter. No9070067","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 49 Meter. No9050082","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 11 Wind Tunnel Meter. No44307233","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 7  Meter. No12150041","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 31 Meter. No11270020","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Food Pie Meter. No9060010","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 42 Meter. No9070003","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 32 Meter. No9060004","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building ICC hvac Meter. No9070069","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 8 Meter. No9050062","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 18 Workshop Meter. No9070060","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 Meter. No9050086","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14S Meter. No9050064","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 4 Meter. No9070032","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 37 Meter. No12310025","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 1 Meter. No13250032","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 36 Meter. No9070073","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 Offices Meter. No12450030","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 50 Newton's Restaurant Meter. No12330017","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Sub Station 21  Meter. No9070019","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  Denel c-block Meter. No9040048","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33 Meter. No9010067","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Entabeni Meter. No9050038","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR Building 11 - MSWT Office Meter. No11240037","monthly",36,null,{"$f":"C124*D124","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Building 18 Mini Sub East Meter. No11140066","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 38 Meter. No9010065","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 2 Meter. No8080026","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 17 Feeder 2 Meter. No60000353","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 Denel Meter. No9070042","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 40 Meter. No9070018","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33 Pump Meter. No9040095","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 20 Meter. No9070017","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 24 Gym Meter. No9070046","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 West Meter. No9070031","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR PTA Building 22 Meter. No9070010","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR PTA Building 22 Meter. No60000358","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 XYRIS Meter. No9050083","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 24  Meter. No9070057","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-CT-Rosebank HVAC A Meter. No56200820","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 34 Meter. No9070020","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14 North Meter. No9060019","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 23 Meter. No9060017","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  46F DB 60 Meter. No14170008","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 37 Meter. No9010038","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 17 Feeder 1 Meter. No60000354","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 5 Meter. No12150040","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 DB 20 Meter. No12440018","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-CT-Rosebank HVAC B Meter. No65925164","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building  46F DB 21 Meter. No14250021","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 19 Meter. No11110022","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Building 29 Meter. No12440047","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 12 HSWT  Meter. No9070037","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 44 Tower Meter. No56200822","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 East  Meter. No9070002","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 14G Meter. No12150048","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 26  Meter. No9030049","monthly",{"$f":"12*3","v":36},null,{"$f":"C156*D156","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Building 43 Design Biologic Meter. No13250040","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 10 Meter. No12250009","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 43 Chillers Meter. No12140042","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 15 Meter. No9070015","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 9  Meter. No9050061","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 30 Mini Sub Meter. No9050057","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 16 LSWT Meter. No57903083","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 35 Meter. No9070064","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 44 Meter. No8070057","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 MiniSub Meter. No9050059","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building Knowledgecommons Meter. No12330018","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 26 132KV Meter. No9070065","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 28 Meter. No9010060","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 Meter. No9070056","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR Building 24 Energy Storage Meter. No60000357","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 46 Laser Meter. No9070059","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 41 Meter. No9070027","monthly",36,null,{"v":0,"d":"R0.00"}]
["Sub Total",{"$nulls":3},{"$f":"SUM(E92:E173)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C178*D178","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C178:C179)","v":2},null,{"$f":"SUM(E178:E179)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.1.1_ Solar PTA","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[0,0,0,4]]}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["Building 22 SolarMeter No.65925160","Sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR-PTA-Building 46 SolarMeter No.60000351","Sum",1,null,{"$f":"C7*D7","v":{"v":0,"d":"R0.00"}}]
["Building 17 Solar Check 1Meter No.59522584","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 10 SolarMeter No.60000350","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 23 SolarMeter No.60000348","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR Building 3 SolarMeter No.59522586","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 33 SolarMeter No.65925161","Sum",1,null,{"v":0,"d":"R0.00"}]
["Building 17 Solar Check 2Meter No.59522585","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Single Axle SolarMeter No.65925170","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 13 Solar Meter No. 60000349    ","Sum",1,null,{"$f":"C15*D15","v":{"v":0,"d":"R0.00"}}]
[null,null,{"$f":"SUM(C6:C15)","v":10}]
["Sub Total",{"$nulls":3},{"$f":"SUM(E6:E14)","v":{"v":0,"d":"R0.00"}}]
["Monthly Subscription fees (12x 5 years)"]
["To be adjusted based on Inflation% year on year"]
["Building 22 SolarMeter No.65925160","Monthly",60,null,{"$f":"C20*D20","v":{"v":0,"d":"R0.00"}}]
["CSIR-PTA-Building 46 SolarMeter No.60000351","Monthly",60,null,{"v":0,"d":"R0.00"}]
["Building 17 Solar Check 1Meter No.59522584","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 10 SolarMeter No.60000350","Monthly",60,null,{"v":0,"d":"R0.00"},{"$nulls":3},"`"]
["CSIR-PTA-Building 23 SolarMeter No.60000348","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR Building 3 SolarMeter No.59522586","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 33 SolarMeter No.65925161","Monthly",60,null,{"v":0,"d":"R0.00"}]
["Building 17 Solar Check 2Meter No.59522585","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Single Axle SolarMeter No.65925170","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-PTA-Building 13 Solar Meter No. 60000349    ","Monthly",60,null,{"$f":"C29*D29","v":{"v":0,"d":"R0.00"}}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E20:E28)","v":{"v":0,"d":"R0.00"}}]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","Sum",1,null,{"$f":"C34*D34","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","Sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C34:C35)","v":2},null,{"$f":"SUM(E34:E35)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.2_ JHB","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"merged":[[0,0,0,4]]}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Jhb-Cottlesloe   Meter No.11110031","Sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR-Jhb- Carlow Road  Meter No.12460019    ","Sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C6:C7)","v":2},null,{"$f":"SUM(E6:E7)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 5 years)"]
[]
["CSIR-Jhb-Cottlesloe   Meter No.11110031","Monthly",60,null,{"$f":"C12*D12","v":{"v":0,"d":"R0.00"}}]
["CSIR-Jhb- Carlow Road  Meter No.12460019    ","Monthly",60,null,{"v":0,"d":"R0.00"}]
["Sub Total",{"$nulls":3},{"$f":"SUM(E12:E13)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","Sum",1,null,{"$f":"C18*D18","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","Sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C18:C19)","v":2},null,{"$f":"SUM(E18:E19)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.3_DUR","index":4,"n_rows":24,"n_cols":5,"rows_kept":24}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Durban-Main Incomer    Meter No.11110081","Sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR-Durban-BIDF Building","Sum",1,null,{"$f":"C7*D7","v":{"v":0,"d":"R0.00"}}]
[]
["Sub Total",null,1,null,{"$f":"SUM(E6:E7)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Monthly Subscription fees (12x 5 years)"]
[]
["CSIR-Durban-Main Incomer    Meter No.11110081","Monthly",60,null,{"$f":"C14*D14","v":{"v":0,"d":"R0.00"}}]
["CSIR-Durban-BIDF Building","Monthly",60,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E14:E16)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","Sum",1,null,{"$f":"C21*D21","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","Sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C21:C22)","v":2},null,{"$f":"SUM(E22:E23)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.4_ Rosebank","index":5,"n_rows":30,"n_cols":5,"rows_kept":30}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR Rosebank Main Comer A  No.09050030        ","Sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR Rosebank Main Comer B  No.53887921"]
["CSIR-Rosebank HVAC A  Meter No.56200820    ","Sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Rosebank HVAC B  Meter No.65925164    ","Sum",1,null,{"$f":"C9*D9","v":{"v":0,"d":"R0.00"}}]
["CSIR-Rosebank  Building 1 Stables  Meter No.11110005    ","Sum",1,null,{"v":0,"d":"R0.00"}]
[]
[]
["Sub Total",null,{"$f":"SUM(C6:C10)","v":4},null,{"$f":"SUM(E6:E10)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 5 years)"]
[]
["CSIR Rosebank Main Comer A  No.09050030    ","Monthly",60,null,{"$f":"C17*D17","v":{"v":0,"d":"R0.00"}}]
["CSIR Rosebank Main Comer B  No.53887921","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-Rosebank HVAC A  Meter No.56200820    ","Monthly",60,null,{"$f":"C19*D19","v":{"v":0,"d":"R0.00"}}]
["CSIR-Rosebank HVAC B  Meter No.65925164    ","Monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-Rosebank  Building 1 Stables  Meter No.11110005    ","Monthly",60,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E17:E21)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C27*D27","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C27:C28)","v":2},null,{"$f":"SUM(E27:E28)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.5_Stellenbosch","index":6,"n_rows":27,"n_cols":5,"rows_kept":27}
["The provision of energy management services to the CSIR  for a period of five (5) years"]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR Stellenbosch Model Hall  No.09070033            ","sum",1,null,{"$f":"C6*D6","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-Block A & B No.11110023    ","sum",1,null,{"$f":"C7*D7","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-Main Incomer  Meter No.09070022        ","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Stellenbosch-TSO  Meter No.12270029        ","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C6:C9)","v":4},null,{"$f":"SUM(E6:E9)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 5 years)"]
[]
["CSIR Stellenbosch Model Hall  No.09070033            ","monthly",60,null,{"$f":"C15*D15","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-Block A & B No.11110023    ","monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-Stellenbosch-Main Incomer  Meter No.09070022        ","monthly",60,null,{"v":0,"d":"R0.00"}]
["CSIR-Stellenbosch-TSO  Meter No.12270029        ","monthly",60,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E15:E18)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C24*D24","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C24:C25)","v":2},null,{"$f":"SUM(E24:E25)","v":{"v":0,"d":"R0.00"}}]