{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cover page Annexure D","PART 2  PRICING PROPOSAL","Table 3 Network HW population","Validation"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Cover page Annexure D","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"PART 2  PRICING PROPOSAL","index":1,"n_rows":340,"n_cols":14,"rows_kept":340,"merged":[[3,0,3,5],[5,0,5,6],[6,0,6,6],[7,0,7,6],[9,0,9,6],[11,0,11,6],[12,0,12,6],[16,8,16,13],[19,0,20,0],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[19,11,20,11],[19,12,20,12],[19,13,20,13],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[21,13,22,13],[23,0,24,0],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,10,24,10],[23,11,24,11],[23,12,24,12],[23,13,24,13],[27,0,28,0],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[27,10,28,10],[27,11,28,11],[27,12,28,12],[27,13,28,13],[29,0,30,0],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[29,13,30,13],[33,0,34,0],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,8,34,8],[33,9,34,9],[33,10,34,10],[33,11,34,11],[33,12,34,12],[33,13,34,13],[35,0,36,0],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[35,9,36,9],[35,10,36,10],[35,11,36,11],[35,12,36,12],[35,13,36,13],[38,0,38,1],[38,2,38,11],[41,2,41,10],[43,0,46,0]]}
["Instructions to complete:"]
["1. Please complete only the yellow cells"]
["2. Costs must be inclusive of VAT"]
["     3. The bidder must indicate the yearly escalation percentage (%) where applicable. However, the cost must be inclusive of the escalation %."]
["Once off costs"]
["3. Training: Please provide the associated costs to train three staff members on planning, deployment, management, maintenance,  integration, and support of all aspects of the networking features deployed. Certification training is staggered over the 3 phases "]
["4. Design: Please record the costs associated with the Low-level design, depicting the configuration of all infrastructure hardware and software"]
["5. Hardware: Please record all the hardware costs, across the respective phases, according to the distribution and quantities articulated in \"Table 3: Network hardware population\""]
["6. Software licensing: Please record all the software licensing costs, across the respective phases"]
["7. Phase 1 - 3 costs associated with network hardware, must be completed in \"Table 3 Network HW population\", of which the sub-totals will be\n    transferred into the Hardware column cells marked in blue."]
["Annual costs"]
["     8. Annual costs shall cover all associated costs to support and maintain the new network. The following components shall be included: Labor cost,\n         3rd party cost, Licensing cost, all associated support cost, hardware cost. These costs are calculated over a five year period."]
["  Support tokens\n     9. The bidder must provide a five (5) year support and maintenance service to ensure availability, security, and operability of the equipment,  \n         configuration, and services. The scope covers all equipment deployed as part of this project. In addition, the Bidder must also provide support\n         credits to the CSIR, which will be used on an ad-hoc basis, in the event of small projects, advisory, design services, which will add or change\n         potential network services. These credits must be supplied in bundles of, 1 – 250 hours, 251 – 500 hours, 501 – 1000 hours and >1000 hours"]
[]
[]
[]
[null,null,"Once off costs",{"$nulls":5},"Annual costs (Including VAT)"]
["Phases and deliverables","Year","Certification training ","Design","Hardware","Licensing","Implementation (all associated cost)","Total once off cost","Year 1\n2024/2025","Year 2\n2025/2026","Year 3\n2026/2027","Year 4\n2027/2028","Year 5\n2028/2029","Total cost over 5 years"]
["Phase 1 Pricing (VAT Inclusive)"]
["Low-level design, depicting the configuration of all infrastructure hardware and software","2023/2024",{"$nulls":5},{"$f":"SUM(C20:G21)","v":0}]
[null,"Q3-Q4"]
["Core, Internet and Data centre","2023/2024",null,null,{"$f":"'Table 3 Network HW population'!J20","v":0},null,null,{"$f":"SUM(C22:G23)","v":0},{"$nulls":5},{"$f":"SUM(I22:M23)","v":0}]
[]
["Certification training (Basic), covering design, configuration, implementation, support, and troubleshooting (based on 5 Network Engineers).","2023/2024",{"$nulls":5},{"$f":"SUM(C24:G25)","v":0}]
[null,"Q3-Q4"]
["Phase 2 Pricing (VAT Inclusive)"]
["Yearly Escalation % included in pricing","2024/2025"]
["Regional core switches and distribution/aggregation layer and core switches at all regional sites. (Preliminary)","2024/2025",null,null,{"$f":"'Table 3 Network HW population'!J40","v":0},null,null,{"$f":"SUM(C28:G29)","v":0},{"$nulls":5},{"$f":"SUM(J28:M29)","v":0}]
[null,"Q1-Q4"]
["Certification training (Intermediate), covering design, configuration, implementation, support and troubleshooting (based on 5 Network Engineers).","2024/2025",0,{"$nulls":4},{"$f":"SUM(C30:G31)","v":0}]
[null,"Q1-Q4"]
["Phase 3 Pricing (VAT Inclusive)"]
["Yearly Escalation % included in pricing","2024/2025"]
["Access layer and Wireless","2025/2026",null,null,{"$f":"'Table 3 Network HW population'!J70","v":0},null,null,{"$f":"SUM(C34:G35)","v":0},{"$nulls":5},{"$f":"SUM(K34:M35)","v":0}]
[null,"Q1-Q4"]
["Certification training (Advanced), covering design, configuration, implementation, support and troubleshooting (based on 5 Network Engineers).","2025/2026",{"$nulls":5},{"$f":"SUM(C36:G37)","v":0}]
[null,"Q1-Q4"]
["Sub total per section",null,{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0},{"$f":"SUM(E20:E37)","v":0},0,0,{"$f":"SUM(H20:H37)","v":0},0,0,0,0,0,{"$f":"N22+N28+N34","v":0}]
["Total bid price inclusive of VAT (Phase 1 + Phase 2 + Phase 3)",{"$nulls":12},{"$f":"N38+H38","v":0}]
[{"$nulls":13},{"$f":"SUM(C38:G38,I38:M38)","v":0}]
[]
[null,null,"Ad-hoc support (Including VAT)"]
[null,null,"Selected options (Select one row only)","Price per hour","Hours over 5 years","Year 1","Year 2","Year 3","Year 4","Year 5","Total cost over 5 years"]
["Support Tokens\n\nIndicate price per hour \nper bundle size i.e.\n1-500 hours = R150/hour\n501-2000 hours = R130/hour","1 – 250 hours",1,null,500,{"$f":"$D44*($E44/5)*$C44","v":0},{"$f":"$D44*($E44/5)*$C44","v":0},0,0,0,{"$f":"SUM(F44:J44)*C44","v":0}]
[null,"251 – 500 hours",1,null,{"v":1000,"d":"1,000"},{"$f":"$D45*($E45/5)*$C45","v":0},{"$f":"$D45*($E45/5)*$C45","v":0},0,0,0,{"$f":"SUM(F45:J45)*C45","v":0}]
[null,"501 – 1000 hours",1,null,{"v":1500,"d":"1,500"},{"$f":"$D46*($E46/5)*$C46","v":0},0,0,0,0,{"$f":"SUM(F46:J46)*C46","v":0}]
[null,">1000 hours",1,null,{"v":2000,"d":"2,000"},{"$f":"$D47*($E47/5)*$C47","v":0},0,0,0,0,{"$f":"SUM(F47:J47)*C47","v":0}]
[]
[]
["*Settlement Discount %"," "," "]
["*Trade Discount %"," "," "]
[" "," "," "," "," "," "]
["Definition of discounts "]
["•      A settlement discount is where a business offers the CSIR a discount when an invoice is paid on time or within 45 days from receipt of statement."]
["•      A trade discount is defined as a type of discount that is cut off the retail or proposal price of an item. The discount is immediately deducted from the proposal price."]
{"$rows_empty":284}
[10]

{"sheet":"Table 3 Network HW population","index":2,"n_rows":71,"n_cols":11,"rows_kept":71,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,6,5,9],[6,1,6,9],[20,1,20,9],[40,1,40,9]]}
[null,"Instructions to complete:"]
[null,"1. Please complete only the yellow cells"]
[null,"2. Costs must be inclusive of VAT"]
[null,"3. Phase 1 - 3 costs will automatically be transferred to \"PART 2 PRICING PROPOSAL\""]
[null,"4. \"Other\" indicates other components that the bidder deem necessary"]
[{"$nulls":6},"Bidder response"]
["#","Core and Data center switches"]
[null,"Network infrastructure models ","QTY ","Model numbers ","To be replaced in Phase 1,2 or 3 ","Location ","Replacement model","Replacement model quantity","Unit cost (Including VAT)","Total cost"]
[1,"Core switch (DC) ",1,"VSP 8284XSQ ","Phase 1","Pretoria ",{"$nulls":3},{"$f":"I9*H9","v":0}]
[2,"Core switch (DR) ",1,"VSP 8284XSQ ","Phase 1","Pretoria ",{"$nulls":3},0]
[3,"Internet switch (DC) ",1,"VSP 7254XSQ ","Phase 1","Pretoria ",{"$nulls":3},0]
[4,"Internet switch (DR) ",1,"VSP 7254XSQ ","Phase 1","Pretoria ",{"$nulls":3},0]
[5,"Data Center ",12,"ERS 4826GTS-PWR ","Phase 1","Pretoria ",{"$nulls":3},0]
[6,"Data Center ",31,"VSP 7024XLS ","Phase 1","Pretoria ",{"$nulls":3},0]
[7,"Data Center ",2,"VSP 7254XSQ ","Phase 1","Pretoria ",{"$nulls":3},0]
[8,"Other",null,null,"Phase 1","Pretoria ",{"$nulls":3},0]
[9,"Other",null,null,"Phase 1","Pretoria ",{"$nulls":3},0]
[10,"Other",null,null,"Phase 1","Pretoria ",{"$nulls":3},0]
[11,"Other",null,null,"Phase 1","Pretoria ",{"$nulls":3},0]
[null,null,{"$f":"SUM(C9:C19)","v":49},{"$nulls":5},"Sub-total for Phase 1",{"$f":"SUM(J9:J19)","v":0},"Transferred to PART 2: Phase 1"]
[null,"Aggregation/Distribution Switch"]
[8,"Core switch (region) ",1,"ERS 5530-24TFD ","Phase 2","Durban ",{"$nulls":3},{"$f":"I22*H22","v":0}]
[9,"Core switch (region) ",2,"ERS 5530-24TFD ","Phase 2","Cape Town ",{"$nulls":3},0]
[10,"Core switch (region) ",1,"ERS 5632-FD ","Phase 2","Stellenbosch ",{"$nulls":3},0]
[11,"Core switch (region) ",1,"ERS 4524GT-PWR ","Phase 2","Carlow Road ",{"$nulls":3},0]
[12,"Core switch (region) ",1,"ERS 4850GTS-PWR ","Phase 2","Cottesloe ",{"$nulls":3},0]
[13,"Building 9 ",2,"VSP 7024XLS ","Phase 2","Pretoria ",{"$nulls":3},0]
[14,"Building 14 ",1,"ERS 5632FD ","Phase 2","Pretoria ",{"$nulls":3},0]
[15,"Building 16 ",2,"VSP 7024XLS ","Phase 2","Pretoria ",{"$nulls":3},0]
[16,"Building 20 ",4,"VSP 7024XLS ","Phase 2","Pretoria ",{"$nulls":3},0]
[17,"Building 35 ",2,"VSP 7024XLS ","Phase 2","Pretoria ",{"$nulls":3},0]
[18,"Building 38 ",2,"VSP 7024XLS ","Phase 2","Pretoria ",{"$nulls":3},0]
[19,"Building 43 ",1,"ERS 5632FD ","Phase 2","Pretoria ",{"$nulls":3},0]
[20,"Building 44 ",2,"ERS 5632FD ","Phase 2","Pretoria ",{"$nulls":3},0]
[21,"Entabeni ",1,"VSP 4450GSP-PWR ","Phase 2","Pretoria ",{"$nulls":3},0]
[22,"Other",null,null,"Phase 2","Pretoria ",{"$nulls":3},0]
[23,"Other",null,null,"Phase 2","Pretoria ",{"$nulls":3},0]
[24,"Other",null,null,"Phase 2","Pretoria ",{"$nulls":3},0]
[25,"Other",null,null,"Phase 2","Pretoria ",{"$nulls":3},0]
[null,null,{"$f":"SUM(C22:C35)","v":23},{"$nulls":5},"Sub-total for Phase 2",{"$f":"SUM(J22:J39)","v":0},"Transferred to PART 2: Phase 2"]
[null,"Access switches and Wireless"]
[22,"All buildings ",47,"ERS 3510GT-PWR ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town ",{"$nulls":3},{"$f":"I42*H42","v":0}]
[23,"Building 9 ",1,"ERS 3549GTS-PWR ","Phase 3","Pretoria ",{"$nulls":3},0]
[24,"All buildings ",68,"ERS 4524GT-PWR ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town, Stellenbosch ",{"$nulls":3},0]
[25,"All buildings ",14,"ERS 4526GT-PWR ","Phase 3","Pretoria ",{"$nulls":3},0]
[26,"All buildings ",182,"ERS 4548GT-PWR ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town, Stellenbosch ",{"$nulls":3},0]
[27,"All buildings ",46,"ERS 4850GTS-PWR ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town, Stellenbosch ",{"$nulls":3},0]
[28,"Entabeni ",1,"ERS 4926GTS-PWR ","Phase 3","Pretoria ",{"$nulls":3},0]
[29,"All buildings ",10,"ERS 4950GTS-PWR ","Phase 3","Pretoria ",{"$nulls":3},0]
[30,"Building 9 ",5,"MSM760 ","Phase 3","Pretoria ",{"$nulls":3},0]
[31,"Building 9 ",2,"Aruba7010 ","Phase 3","Pretoria ",{"$nulls":3},0]
[32,"Building 37 ",1,"MSM430 ","Phase 3","Pretoria ",{"$nulls":3},0]
[33,"Building 2 - 46 ",425,"MSM460 ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town, Stellenbosch ",{"$nulls":3},0]
[34,"Building 50, Stellenbosch, ICC ",3,"MSM466-R ","Phase 3","Pretoria, Stellenbosch ",{"$nulls":3},0]
[35,"Building 2 - 46 ",25,"HP560 ","Phase 3","Pretoria, Johannesburg, Durban, Cape Town, Stellenbosch ",{"$nulls":3},0]
[36,"Building 1 ",1,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[37,"Building 9 ",21,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[38,"Building 3 ",20,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[39,"Building 39 ",28,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[40,"Building 43 ",41,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[41,"Building 44 ",66,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[42,"Entabeni ",20,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[43,"Carlow Road ",14,"Aruba IAP-325 ","Phase 3","Johannesburg ",{"$nulls":3},0]
[44,"Paardefontein ",3,"Aruba IAP-325 ","Phase 3","Pretoria ",{"$nulls":3},0]
[45,"Kloppersbos ",6,"Aruba IAP-325 ","Phase 3","Pretoria",{"$nulls":3},0]
[46,"Other",null,null,"Phase 3","Pretoria",{"$nulls":3},0]
[47,"Other",null,null,"Phase 3","Pretoria",{"$nulls":3},0]
[48,"Other",null,null,"Phase 3","Pretoria",{"$nulls":3},0]
[49,"Other",null,null,"Phase 3","Pretoria",{"$nulls":3},0]
[null,"Sub-total",{"$f":"SUM(C42:C65)","v":1050},{"$nulls":5},"Sub-total for Phase 3",{"$f":"SUM(J42:J70)","v":0},"Transferred to PART 2: Phase 3"]
[null,"Grand total",{"$f":"C70+C40+C20","v":1122}]

{"sheet":"Validation","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[]
[null,"Support token selection"]
[null,0]
[null,1]