{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["General Information","Summary","Functional"," Non Functional ","Integration and Testing","Cloud","Security"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":15,"comments":0,"pivot_tables":10},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Information","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,1,3,2],[0,0,0,2],[0,3,0,12],[1,1,1,2],[1,3,1,12],[2,1,2,2],[2,3,2,12]]}
["Structured SMS Data",null,null,"Important Notes: "]
[{"$f":"'[2]Technical evaluation'!A2","v":"CORP xxxx Tender"},null,null,"1. Please indicate location of answers to the criteria and where required answer yes or no. To be included in Comments tab per sheet."]
[{"$f":"'[2]Technical evaluation'!A3","v":"Tenderer:"},null,null,"2. The qualified solution service provider shall do a product demo of the proposed product to be presented to Eskom.  This is mandatory. "]
[{"$f":"'[2]Technical evaluation'!$A$4","v":"Evaluated by:"}]
["TENDERER: Critical instructions for filling out this worksheet"]
["1. Tenderer to fill out all excel fields of this colour in all worksheets of this document"]
["2. The tenderer will provide the elimination(mandatory) information that is required for the Gatekeepers in the \"Summary\" worksheet. indicate where in the submission documents the evidence can be found to evaluate the respective evaluation criteria. "]
["3.  In the \"Functional\" worksheet, the vendor response fields, the Tenderer has to indicate the Compliance and any applicable response based on Compliance.Any field that has not been filled out, will be scored with 0%."]
["4.  In the \"Non Functional\" worksheet, the vendor response fields, the Tenderer has to indicate the Compliance and any applicable response based on Compliance. Any field that has not been filled out, will be scored with 0%. "]
["5. The tenderer will complete the \"Integration and Testing\" worksheet in the vendor response fields,the Tenderer has to indicate the Compliance and any applicable response based on Compliance..Any fields that has not been filled out, will be scored with 0%.  "]
["6. In the \"Cloud\" worksheet ,  the vendor response fields, the Tenderer has to indicate the Compliance and any applicable response based on Compliance. Any field that has not been filled out, will be scored with 0%. "]
["7. In the \"Security\" worksheet , the vendor response fields, the Tenderer has to indicate the Compliance and any applicable response based on Compliance. Any field that has not been filled out, will be scored with 0%. ."]
["8. Evaluation criteria will all have pre-defined weights . The weighting of the sub criteria that lead to the score on the criteria  are pre-defined by Eskom, but not published."]
["Acronyms:"]
["1. USSD - Unstructured Supplemantary Service Data"]
["2. BOT - Robot layer"]
["3. CC&B - Customer Care and Billings"]
["4. CC&I - Customer Care and I (CRM System)"]
["5. CRM - Customer Relationship Management"]
["6. CSP - Cloud Service Provider "]
["7. OU - Organizational Unit"]
["8. SLA - Service Level Agreement"]
["9. SFTP - Secure File Transfer Protocol"]
["10. SOAP - Simple Object Access Protocol"]
["11. REST - Representational State Transfer"]
["12. POPI - Protection of Personal Information Act"]
[13]

{"sheet":"Summary","index":1,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,12],[1,1,1,2],[1,3,1,12],[2,1,2,2],[2,3,2,12],[15,0,15,3],[3,1,3,2],[5,0,5,4],[6,0,6,4],[10,0,10,1],[10,2,10,3],[13,0,13,3],[7,0,7,3],[8,0,8,1],[9,0,9,1],[8,2,8,3],[9,2,9,3],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[14,0,14,3],[13,10,13,13]]}
["Structured SMS Data",null,null,"Important Notes: "]
[{"$f":"'[2]Technical evaluation'!A2","v":"CORP xxxx Tender"},null,null,"1. Please indicate location of answers to the criteria and where required answer yes or no. To be included in Comments tab per sheet."]
[{"$f":"'[2]Technical evaluation'!A3","v":"Tenderer:"},null,null,"2. The qualified solution service provider shall do a product demo of the proposed product to be presented to Eskom.  This is mandatory. "]
[{"$f":"'[2]Technical evaluation'!$A$4","v":"Evaluated by:"}]
[]
["Evaluation on Elimination (Mandatory) Criteria             "]
["If any of these mandatory criteria are not met, the tenderer will be disqualified.",null,null,null,null,null,null,null,null,null,null,null,null,null,"RFP:100%  \n",null,"Please Note:"]
["Criteria (Gate Keepers)",null,null,null,"Met?",null,null,null,null,null,"RFP","Weighting",null,"Total","RFP ","Final Score"]
["Question / Evaluation Criteria",null,"Evidence provided by tenderer",null,"Choose from Drop Down list",null,null,null,null,null,null,"Functional",0.4,{"$f":"E21*M9","v":0},{"$f":"(N9+N10+N11+N12) *0.5","v":0},{"$f":"O9+O13","v":0},"Functional weighting is highest at 40%,Non-Functional and Security is 15% and 20% Cloud,Integration & Testing is 10% . The total for the RFP evaluation is 100%"]
["Tenderer or via joint venture partner does have prior or past experience in implemention of a USSD solution/product. ",null," Evidence would be reference letter from client/s. ",null,null,null,null,null,null,null,null,"Non Functional",0.15,{"$f":"E29*M10","v":0}]
["The request is for the USSD solution/channel ONLY not a BOT,with menu items that will display text on an enquiry and re-use existing integration messages that have been  developed already as part of the BOT implemented. The tenderer proposed USSD solution must comply to 100% of the scope of work, attached on Annexure A",null,"Critical Functional Requirements  and Scope of work (High level, Detailed  and Technical requirements) in Annexure A ",null,null,null,null,null,null,null,null,"Integration &Testing",0.1,{"$f":"E35*M11","v":0},null,null,"The threshold for the Final score is 70% (Cell )"]
["Team has the required certifications for the  USSD solution/product  (Provide Certificate) aquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technologies. At least two certified local proposed USSD resources for implementation and two certified local support resources with local support footprint in SA. ",null,"Evidence would be CV's with copies of certificates of resources.",null,null,null,null,null,null,null,null,"Cloud",0.2,{"$f":"E42*M12","v":0}]
["The USSD solution and data hosting should be in a private off premise cloud environment hosted within the borders of South Africa.",null,"Evidence regarding the data hosting including backups",null,null,null,null,null,null,null,null,"Security",0.15,{"$f":"E47*M13","v":0},null,null,"Weighting for Final score: 100% of the RFP "]
[null,null,null,null,{"$f":"IF(OR(E10=\"No\",E11=\"No\",E12=\"No\",E13=\"No\",ISBLANK(E10),ISBLANK(E11),ISBLANK(#REF!),ISBLANK(E12),ISBLANK(E13)),\"Disqualified\",\"Qualified\")","v":"Disqualified"},null,null,null,null,null,"RFP (100%) score",null,null,null,{"$f":"SUM(N9:N13)","v":0}]
[]
[null,null,null,"Tenderer Disqualified? "]
["Evaluation on Weighted Criteria"]
["Sum of Weighted Question (Functional)",null,null,"Sum of Weighted Answer (Functional)"]
["Type","Total",null,"Type","Total"]
["Meeting the Scope of Work Required",0.99999999999999944,null,"Meeting the Scope of Work Required",0]
["Total",0.99999999999999944,null,"Total",0]
[]
[]
[]
[]
["Sum of Weighted Question (Non Functional)",null,null,"Sum of Weighted Answer(Non Fuctional"]
["Type","Total",null,"Type","Total"]
["Meeting the Scope of Work Required",1.1599999999999997,null,"Meeting the Scope of Work Required",0]
["Total",1.1599999999999997,null,"Total",0]
[]
["Sum of Weighted Question (Integration and Testing)",null,null,"Sum of Weighted Answer (Integration and Testing)"]
["Type","Total",null,"Type","Total"]
["Meeting the Scope of Work Required",0.90909090909090884,null,"Meeting the Scope of Work Required",0]
["Team Organisation and Member Requirements",9.0909090909090912E-2,null,"Team Organisation and Member Requirements",0]
["Total",0.99999999999999978,null,"Total",0]
[]
[]
["Sum of Weighted Question (Cloud)",null,null,"Sum of Weighted Answer (Cloud)"]
["Type","Total",null,"Type","Total"]
["Meeting the Scope of Work Required",1.2499999999999993,null,"Meeting the Scope of Work Required",0]
["(blank)",0.13157894736842105,null,"(blank)"]
["Grand Total",1.3815789473684204,null,"Grand Total",0]
[]
["Sum of Weighted Question (Security))",null,null,"Sum of Weighted Answer (Security)"]
["Type","Total",null,"Type","Total"]
["Meeting the Scope of Work Required",1.4571428571428573,null,"Meeting the Scope of Work Required",0]
["Grand Total",1.4571428571428573,null,"Grand Total",0]

{"sheet":"Functional","index":2,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,2],[6,13,7,13]]}
["Structured SMS Data"]
["CORP xxxx Tender",null,null,null,null,null,null,null,null,null,null,"Scoring (Sliding scale)"]
["Tenderer:",null,null,null,null,null,null,null,null,null,null,"100% - Fully compliant"]
["Evaluated by:",null,null,null,null,null,null,null,null,null,null,"50%-Partially compliant"]
[null,null,null,null,null,null,null,null,null,null,null,"0%-Non compliance"]
["Evaluation Criteria"]
[null,null,null,null,null,"Vendor Compliance\nFull Compliance - Y\nPartial Compliance - P\nNon Compliance - N","Vendor to indicate any applicable response based on Compliance","Priority\nRequirement priority as determined by Eskom","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score",null,"Comments (Internal) for scorer"]
["ID","Type","Criterion","Functional Requirement","Requirement description","Vendor Compliance","Vendor Response","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Service Categories","Service Categories","The USSD Channel solution should cater for the following Use Cases:1. Customer identification: ID Number,Account number,Meter number,Cell phone number",null,null,"Critical",{"$f":"IF(H9='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H9='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H9='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H9='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H9='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H9='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H9='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I9/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Service Categories","Service Categories","Log a fault: Log a new fault,Follow up on existing fault,Follow up on fault without reference number",null,null,"Critical",{"$f":"IF(H10='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H10='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H10='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H10='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H10='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H10='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H10='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I10/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"J10*L10","v":0}]
[3,"Meeting the Scope of Work Required","Service Categories","Service Categories","Log a token issue",null,null,"Critical",{"$f":"IF(H11='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H11='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H11='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H11='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H11='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H11='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H11='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I11/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[4,"Meeting the Scope of Work Required","Service Categories","Service Categories","Receive feedback on Reference number",null,null,"Critical",{"$f":"IF(H12='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H12='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H12='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H12='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H12='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H12='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H12='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I12/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[5,"Meeting the Scope of Work Required","Service Categories","Service Categories","View customer information:phone, email , account",null,null,"Critical",{"$f":"IF(H13='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H13='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H13='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H13='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H13='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H13='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H13='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I13/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[6,"Meeting the Scope of Work Required","Service Categories","Service Categories","View Alerts: Proactively display alerts,Also alerts after customer has identified himself",null,null,"Critical",{"$f":"IF(H14='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H14='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H14='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H14='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H14='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H14='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H14='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I14/I$40","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[7,"Meeting the Scope of Work Required","Service Categories","Service Categories","Vendor to indicate what Use cases are provided as standard, out of the box",null,null,"Very important",{"$f":"IF(H15='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H15='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H15='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H15='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H15='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H15='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H15='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I15/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[8,"Meeting the Scope of Work Required","Service Categories","Service Categories","Vendor to indicate what use cases can be provided through development",null,null,"Very important",{"$f":"IF(H16='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H16='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H16='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H16='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H16='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H16='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H16='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I16/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[9,"Meeting the Scope of Work Required","Service Categories","Service Categories","Sensitive transactions ie Bill request, will be responded to via other existing channels i.e. email",null,null,"Very important",{"$f":"IF(H17='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H17='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H17='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H17='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H17='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H17='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H17='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I17/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[10,"Meeting the Scope of Work Required","Case Base Reasoning","Case Base Reasoning","Ability to provide case-based reasoning. Can use case-based reasoning to resolve faults. Ask pertinent questions. Have you got enough tokens, Does your neighbours have power. Provide immediate feedback. Idea is to resolve faults/ handle at multimedia level- to prevent calling Contact Centre.",null,null,"Important",{"$f":"IF(H18='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H18='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H18='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H18='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H18='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H18='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H18='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I18/I$40","v":2.4E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[11,"Meeting the Scope of Work Required","Notifications / Messages","Notifications / Messages","Response must be immediate, and no interaction should require the customer to wait longer than 3 seconds before the requested information is sent back to the mobile device. Especially Case Based Reasoning– Should be instant",null,null,"Very important",{"$f":"IF(H19='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H19='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H19='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H19='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H19='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H19='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H19='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I19/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[12,"Meeting the Scope of Work Required","Notifications / Messages","Notifications / Messages","Ability to display default message in USSD before listing menu options. i.e. Network outage in your area (based on Customer Telephone number). ",null,null,"Very important",{"$f":"IF(H20='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H20='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H20='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H20='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H20='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H20='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H20='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I20/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[13,"Meeting the Scope of Work Required","Notifications / Messages","Notifications / Messages","All assumptions and dependencies should be noted i.e. If a service is dependent on the Network Operator, it should be noted.",null,null,"Very important",{"$f":"IF(H21='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H21='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H21='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H21='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H21='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H21='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H21='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I21/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[14,"Meeting the Scope of Work Required","Notifications / Messages","Notifications / Messages","An auto-response should be provided. ",null,null,"Very important",{"$f":"IF(H22='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H22='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H22='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H22='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H22='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H22='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H22='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I22/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[15,"Meeting the Scope of Work Required","Notifications / Messages","Notifications / Messages","Ability to customize response based on analysis, All transactions should communicate a friendly, meaningful response to the customer",null,null,"Very important",{"$f":"IF(H23='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H23='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H23='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H23='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H23='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H23='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H23='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I23/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[16,"Meeting the Scope of Work Required","Authentication","Authentication","Validation should be based on Cell number verification against Customer Data (CC&B) – It is preferred that registration should NOT be an option",null,null,"Very important",{"$f":"IF(H24='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H24='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H24='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H24='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H24='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H24='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H24='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I24/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[17,"Meeting the Scope of Work Required","Device independent","Device independent","The solution must be mobile independent, so that any mobile device may be used to perform the self-service functionality.  Not limited to the capabilities or sophistication of the type of mobile device used by the customer",null,null,"Very important",{"$f":"IF(H25='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H25='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H25='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H25='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H25='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H25='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H25='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I25/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[18,"Meeting the Scope of Work Required","Language","Language","Interactions can be received and must be responded to in English",null,null,"Very important",{"$f":"IF(H26='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H26='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H26='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H26='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H26='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H26='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H26='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I26/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[19,"Meeting the Scope of Work Required","Analysis of SMS","Analysis of SMS","The following should be determined from the USSD Interaction:OU,Service Category (So that the Agent can filter in the worklist. The Supervisor wants to see how many requests in order to adjust resources etc.),language, Ref Number Sent (Can determine what was logged in CRM),Meter Number,Name & Address",null,null,"Very important",{"$f":"IF(H27='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H27='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H27='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H27='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H27='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H27='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H27='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I27/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[20,"Meeting the Scope of Work Required","Worklist","Worklist","Interactions, once analysed, should be made available to the CRM Worklist",null,null,"Very important",{"$f":"IF(H28='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H28='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H28='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H28='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H28='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H28='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H28='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I28/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"J28*L28","v":0}]
[21,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The functionality must be cost effective, easy to use, user friendly",null,null,"Very important",{"$f":"IF(H29='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H29='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H29='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H29='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H29='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H29='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H29='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I29/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[22,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The customer should select features from a menu system",null,null,"Very important",{"$f":"IF(H30='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H30='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H30='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H30='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H30='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H30='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H30='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I30/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[23,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The menu system should allow for quick access via a structured route to feature functionality. The product shall be easy to use with logical and simple navigation where applicable.",null,null,"Very important",{"$f":"IF(H31='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H31='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H31='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H31='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H31='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H31='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H31='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I31/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[24,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The system must have an easy way for the customer to know for certain that he is submitting a reading for the correct meter",null,null,"Very important",{"$f":"IF(H32='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H32='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H32='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H32='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H32='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H32='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H32='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I32/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[25,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The solution shall be used by people with no training",null,null,"Very important",{"$f":"IF(H33='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H33='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H33='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H33='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H33='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H33='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H33='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I33/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[26,"Meeting the Scope of Work Required","Ease of Use Requirements","Ease of Use Requirements","The product shall provide help if required by the customer",null,null,"Very important",{"$f":"IF(H34='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H34='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H34='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H34='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H34='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H34='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H34='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I34/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[27,"Meeting the Scope of Work Required","Performance","Performance","It is essential that the solution maximises the number of customers that can utilise it.",null,null,"Very important",{"$f":"IF(H35='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H35='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H35='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H35='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H35='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H35='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H35='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I35/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[28,"Meeting the Scope of Work Required","Performance","Performance","There must be no limitation to the number of accounts, premises and meters that can be accessed by the customer",null,null,"Very important",{"$f":"IF(H36='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H36='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H36='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H36='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H36='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H36='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H36='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I36/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[29,"Meeting the Scope of Work Required","Performance","Performance","The solution must be able to handle concurrent user interactions",null,null,"Very important",{"$f":"IF(H37='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H37='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H37='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H37='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H37='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H37='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H37='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I37/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[30,"Meeting the Scope of Work Required","Customer distribution","Customer distribution","Solution should cater for the Geographic distribution of users: the users are distributed nationwide",null,null,"Very important",{"$f":"IF(H38='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H38='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H38='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H38='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H38='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H38='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H38='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I38/I$40","v":3.2000000000000001E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I38)","v":125},{"$f":"SUM(J9:J38)","v":1.0000000000000007},null,null,{"$f":"SUM(M9:M38)","v":0}]

{"sheet":" Non Functional ","index":3,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,13,7,13],[0,0,0,2]]}
["Structured SMS Data"]
["CORP xxxx Tender",null,null,null,null,null,null,null,null,null,null,"Scoring (Sliding scale)"]
["Tenderer:",null,null,null,null,null,null,null,null,null,null,"100% - Fully compliant"]
["Evaluated by:",null,null,null,null,null,null,null,null,null,null,"50%-Partially compliant"]
[null,null,null,null,null,null,null,null,null,null,null,"0%-Non compliance"]
["Evaluation Criteria"]
[null,null,null,null,null,"Vendor Compliance\nFull Compliance - Y\nPartial Compliance - P\nNon Compliance - N","Vendor to indicate any applicable response based on Compliance","Priority\nRequirement priority as determined by Eskom","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score",null,"Comments (Internal) for scorer"]
["ID","Type","Criterion","Functional Requirement","Requirement description","Vendor Compliance","Vendor Response","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Software Licensing & Costing","Licensing ","Provision of the necessary software licences with maintenance & support for at least 5-year period\n",null,null,"Critical",{"$f":"IF(H9='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H9='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H9='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H9='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H9='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H9='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H9='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I9/I$34","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Software Licensing and Costing","Licensing ","Commercial Model (Fixed Contract, Subscription or Consumptive)?",null,null,"Critical",{"$f":"IF(H10='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H10='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H10='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H10='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H10='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H10='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H10='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I10/I$34","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[3,"Meeting the Scope of Work Required","Software Licensing & Costing","Licensing ","Please supply a costing model for all elements of the service? ",null,null,"Critical",{"$f":"IF(H11='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H11='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H11='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H11='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H11='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H11='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H11='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I11/I$34","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[4,"Meeting the Scope of Work Required","Solution Design","Design","Prepare and Quality Assure the functional specifications for the solution",null,null,"Very important",{"$f":"IF(H12='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H12='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H12='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H12='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H12='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H12='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H12='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I12/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[5,"Meeting the Scope of Work Required","Solution Design","Design","Prepare the solution design",null,null,"Very important",{"$f":"IF(H13='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H13='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H13='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H13='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H13='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H13='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H13='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I13/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[6,"Meeting the Scope of Work Required","Solution Design","Design","Prepare and quality assure the physical design of the solution",null,null,"Very important",{"$f":"IF(H14='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H14='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H14='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H14='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H14='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H14='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H14='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I14/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[7,"Meeting the Scope of Work Required","Solution Design","Design","Prepare solution monitoring and SLA reporting design",null,null,"Important",{"$f":"IF(H15='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H15='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H15='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H15='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H15='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H15='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H15='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I15/I$34","v":0.04},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[8,"Meeting the Scope of Work Required","Solution Design","Design","All designs must be approved at the relevant Eskom Architecture Design Governance committee",null,null,"Critical",{"$f":"IF(H16='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H16='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H16='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H16='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H16='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H16='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H16='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I16/I$34","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[9,"Meeting the Scope of Work Required","Solution Configuration and Development","Configuration and Development","Configuration - Configure all required functional and non-functional settings in the solution to ensure optimal and secure operations",null,null,"Very important",{"$f":"IF(H17='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H17='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H17='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H17='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H17='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H17='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H17='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I17/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[10,"Meeting the Scope of Work Required","Solution Configuration and Development","Configuration and Development","Custom development as required to meet the business requirements (specific functionality and integration that is required).",null,null,"Very important",{"$f":"IF(H18='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H18='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H18='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H18='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H18='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H18='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H18='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I18/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[11,"Meeting the Scope of Work Required","Solution Configuration and Development","Configuration and Development","Development must be modular (add-ons) to not compromise upgrades of the commercial application",null,null,"Very important",{"$f":"IF(H19='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H19='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H19='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H19='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H19='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H19='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H19='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I19/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[12,"Meeting the Scope of Work Required","Deploy the solution into Production","Deployment","Obtain pre-transfer Architecture Governance approval",null,null,"Very important",{"$f":"IF(H20='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H20='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H20='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H20='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H20='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H20='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H20='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I20/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[13,"Meeting the Scope of Work Required","Deploy the solution into Production","Deployment","Complete all required documents and obtain approval for the go-live",null,null,"Very important",{"$f":"IF(H21='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H21='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H21='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H21='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H21='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H21='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H21='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I21/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[14,"Meeting the Scope of Work Required","Deploy the solution into Production","Deployment","Deploy the solution in the production environment",null,null,"Very important",{"$f":"IF(H22='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H22='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H22='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H22='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H22='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H22='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H22='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I22/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[15,"Meeting the Scope of Work Required","Stabilisation of the solution","Stabilisation ","Once the solution is implemented in production a 3 month stabilisation period is required by the Vendor.",null,null,"Very important",{"$f":"IF(H23='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H23='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H23='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H23='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H23='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H23='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H23='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I23/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[16,"Meeting the Scope of Work Required","Stabilisation of the solution","Stabilisation ","During this time Vendor must produce the monthly reports that will be submitted to Eskom reporting on the SLA metrics achieved",null,null,"Very important",{"$f":"IF(H24='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H24='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H24='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H24='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H24='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H24='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H24='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I24/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[17,"Meeting the Scope of Work Required","Support and Maintenance","Support and Maintenance","Ensure SLA is concluded and includes all SLA metrics/requirements. SLA kicks in during the stabilisation period and thereafter.",null,null,"Very important",{"$f":"IF(H25='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H25='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H25='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H25='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H25='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H25='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H25='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I25/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[18,"Meeting the Scope of Work Required","Support and Maintenance","Support and Maintenance","During this time Vendor must produce the agreed Monthly reporting of SLA metrics achieved. Contract will be drawn up with penalties for not meeting SLA metrics.",null,null,"Very important",{"$f":"IF(H26='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H26='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H26='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H26='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H26='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H26='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H26='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I26/I$34","v":5.3333333333333337E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[19,null,"Implementation","Implementation","USSD implementation capability on proposed USSD solution for SaaS option:The tenderer need to provide a short description of each implementation using the proposed USSD solution\nImplementation details to be provided:  \nCustomer/Site reference: \nProject Methodology used \nDuration of the implementation\nOption ( SaaS)"]
[20,null,"Project Management competency and methodology","Project Management competency and methodology","Project implementation experience, specifically using agile methodology (with trained and certified Project manager/s in Agile Methodolgy)"]
[21,null,"USSD product certification & expertise for implementation, support and custom development","USSD product certification & expertise for implementation, support and custom development","Proposed USSD product certifications (Individuals part of Implementation Team)"]
[22,null,"Implement of USSD platform that enables the solution","Implement of USSD platform that enables the solution","Resource Model and Capacity.The  proposed USSD implementation must be implemented within 4 months.Full managed service including the enrollment of the solution within  the first 2 months"]
[23,null,"Support Model","Support Model","Support and Maintenance support model for 5 years"]
[24,null,"Support Model","Support Model","Full Managed service model for 5 years"]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I26)","v":75},{"$f":"SUM(J9:J26)","v":1},null,null,{"$f":"SUM(M9:M26)","v":0}]

{"sheet":"Integration and Testing","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,14,7,14],[0,0,0,2]]}
["Structured SMS Data"]
["CORP xxxx Tender",null,null,null,null,null,null,null,null,null,null,null,"Scoring (Sliding scale)"]
["Tenderer:",null,null,null,null,null,null,null,null,null,null,null,"100% - Fully compliant"]
["Evaluated by:",null,null,null,null,null,null,null,null,null,null,null,"50%-Partially compliant"]
[null,null,null,null,null,null,null,null,null,null,null,null,"0%-Non compliance"]
["Evaluation Criteria"]
[null,null,null,null,null,null,"Vendor Compliance\nFull Compliance - Y\nPartial Compliance - P\nNon Compliance - N","Vendor to indicate any applicable response based on Compliance","Priority\nRequirement priority as determined by Eskom","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score",null,"Comments (Internal) for scorer"]
["ID","Type","Category","Criterion","Functional Requirement","Requirement description","Vendor Compliance","Vendor Response","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Non Functional","Solid Testing capability (reference projects & sites and methodologies used)","Testing ","Provide reference customers and sites",null,null,"Very important",{"$f":"IF(I9='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I9='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I9='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I9='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I9='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I9='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I9='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J9/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"K9*M9","v":0}]
[2,"Team Organisation and Member Requirements","Non Functional","Previous involvement in the end to end testing of a similar system","Testing ","Provide reference customers and sites",null,null,"Very important",{"$f":"IF(I10='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I10='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I10='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I10='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I10='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I10='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I10='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J10/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"K10*M10","v":0}]
[3,"Meeting the Scope of Work Required","Non Functional","Resource model. It is a requirement that sufficient dedicated testers are allocated the project, independent of the development team","Testing ","Experienced Test Manager must be provided\n",null,null,"Very important",{"$f":"IF(I11='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I11='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I11='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I11='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I11='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I11='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I11='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J11/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[4,"Meeting the Scope of Work Required","Non Functional","Resource Experience with Eskoms Testing tools","Testing ","Must be HP ALM, UFT and Load Runner ",null,null,"Very important",{"$f":"IF(I12='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I12='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I12='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I12='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I12='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I12='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I12='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J12/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[5,"Meeting the Scope of Work Required","Non Functional","Your testing approach specific to the project.","Testing ","Provide the approach\n",null,null,"Very important",{"$f":"IF(I13='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I13='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I13='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I13='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I13='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I13='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I13='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J13/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[6,"Team Organisation and Member Requirements","Non Functional","Tenderer's proposed testing resources must have the required ISTQB(International Software Testing Qualifications Board) qualifications accredited by SATQB(Southern African Software Testing Qualifications Board). ","Testing ","Provide Certificates of resources. Evidence required: CV's together with respective copies of acquired certificates.",null,null,"Very important",{"$f":"IF(I14='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I14='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I14='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I14='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I14='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I14='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I14='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J14/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[7,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of Oracle Fusion and Datapower integration solutions in a enterprise (reference projects & sites and pattern)","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,null,"Very important",{"$f":"IF(I15='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I15='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I15='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I15='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I15='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I15='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I15='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J15/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[8,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of IBM Datapower integration solutions in a enterprise (reference projects & sites and pattern)","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,null,"Very important",{"$f":"IF(I16='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I16='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I16='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I16='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I16='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I16='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I16='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J16/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[9,"Meeting the Scope of Work Required","Non Functional","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions.\n\nProvide references\n","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,null,"Very important",{"$f":"IF(I17='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I17='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I17='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I17='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I17='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I17='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I17='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J17/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[10,"Meeting the Scope of Work Required","Non Functional","The solution to provide SOAP or REST  services capabilities for core functionalities (Message to create case in CRM environment)","Integration","The vendor will be required to develop a message to create a case for the customer interaction in the CRM environment. ",null,null,"Very important",{"$f":"IF(I18='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I18='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I18='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I18='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I18='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I18='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I18='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J18/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[11,"Meeting the Scope of Work Required","Non Functional","The product shall be capable of processing 45,000 customers on a monthly basis or at least 1 500 conversations a day, which is equivalent.","Integration","Provide technical proof of message capabilities.",null,null,"Very important",{"$f":"IF(I19='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I19='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I19='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I19='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I19='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I19='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I19='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J19/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[12,"Meeting the Scope of Work Required","Non Functional","Tenderer must provide approach and confirmation that the product can be supportable by internal resources with minimal involvement of the supplier","Integration","Indicate how changes and enhancements can be done. Concentrate on access to the application and integration architecture.",null,null,"Very important",{"$f":"IF(I20='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I20='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I20='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I20='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I20='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I20='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I20='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J20/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[13,"Meeting the Scope of Work Required","Non Functional","The capability of the solution to make available  authentication security types to use Basic Authentication for Web Services, Database or SFTP?","Integration","Indicate technical capabilities in terms of authentication protocols ",null,null,"Very important",{"$f":"IF(I21='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I21='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I21='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I21='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I21='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I21='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I21='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J21/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[14,"Meeting the Scope of Work Required","Non Functional","Is it important for Integration to present the message unit of order (preserving the sequence of how the message have been received from the Source to the Target)?","Integration","Indicate exposure  using the JMS functionality with various options",null,null,"Very important",{"$f":"IF(I22='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I22='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I22='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I22='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I22='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I22='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I22='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J22/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[15,"Meeting the Scope of Work Required","Non Functional","The experience acquired  to use integration patterns  like Synchronous Request-Reply, Asynchronous Fire-and-Forget, Guaranteed Delivery Pattern, Pub-Sub","Integration","Indicate experience in using the mentioned integration desgn patterns.",null,null,"Very important",{"$f":"IF(I23='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(I23='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(I23='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(I23='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(I23='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(I23='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(I23='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J23/J$25","v":6.6666666666666666E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,0]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(J9:J23)","v":60},{"$f":"SUM(K9:K23)","v":0.99999999999999989},null,null,{"$f":"SUM(N9:N23)","v":0}]

{"sheet":"Cloud","index":5,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,13,7,13],[0,0,0,2]]}
["Structured SMS Data"]
["CORP xxxx Tender",null,null,null,null,null,null,null,null,null,null,"Scoring (Sliding scale)"]
["Tenderer:",null,null,null,null,null,null,null,null,null,null,"100% - Fully compliant"]
["Evaluated by:",null,null,null,null,null,null,null,null,null,null,"50%-Partially compliant"]
[null,null,null,null,null,null,null,null,null,null,null,"0%-Non compliance"]
["Evaluation Criteria"]
[null,null,null,null,null,"Vendor Compliance\nFull Compliance - Y\nPartial Compliance - P\nNon Compliance - N","Vendor to indicate any applicable response based on Compliance","Priority\nRequirement priority as determined by Eskom","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score",null,"Comments (Internal) for scorer"]
["ID","Type","Criterion","Functional Requirement","Requirement description","Vendor Compliance","Vendor Response","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Eskom will only agree to suspension on an emergency basis in the event of Supplier having to prevent or mitigate the effects of disabling code, subject to Supplier then escalating to ESKOM and agreeing to a timeframe for restoration of services.","Contractual and Licencing Models","Please provide an explanation of circumstances in which the services could be suspended.",null,null,"Very important",4,{"$f":"I9/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Contractual and Licencing Models","Contractual and Licencing Models","Please provide an explanation of circumstances in which the services could be terminated. ",null,null,"Very important",4,{"$f":"I10/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation",null,0]
[3,"Meeting the Scope of Work Required","Contractual and Licencing Models","Contractual and Licencing Models","Commercial Contractual and Licencing Model (Fixed Contract, Subsciption or Cunsumptive)?",null,null,"Very important",{"$f":"IF(H11='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H11='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H11='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H11='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H11='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H11='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H11='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I11/I$37","v":5.2631578947368418E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J11*L11","v":0}]
[4,"Meeting the Scope of Work Required","ESKOM is looking for a Private SaaS cloud service offering in order to fulfill the solution requirements as set out in the RFP.","Architecture","Please specify your Cloud Service Model (e.g.IaaS, PaaS or SaaS) and Deployment Model (Private,Public or Hybrid)?",null,null,"Very important",{"$f":"IF(H12='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H12='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H12='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H12='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H12='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H12='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H12='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I12/I$37","v":5.2631578947368418E-2},"Private SaaS as determined by the Cloud Risk Assessment",null,{"$f":"J12*L12","v":0}]
[5,"Meeting the Scope of Work Required","Architecture","Architecture","A complete solution Architecture diagram to be provided, indicating all components of the solution including information around data hosting location",null,null,"Very important",4,{"$f":"I13/I$37","v":5.2631578947368418E-2}," Evaluation subjective"]
[6,null,"Architecture","Architecture","Indicate what components are provided by the vendor and what components the client will need to provide"]
[7,"Meeting the Scope of Work Required","Integration mechanisms and models need to support secure and complete data exchange for hybrid solutions (on-premise and cloud) that align to the performance requirements of the solution ecosystem","Architecture","Do you provide an Integration Model between on-premise environments and cloud environments to ensure secure, complete and performing data exchange and workloads?",null,null,"Very important",{"$f":"IF(H15='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H15='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H15='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H15='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H15='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H15='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H15='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I15/I$37","v":5.2631578947368418E-2},"This is dependant on the solution.  Evaluation subjective",null,{"$f":"J15*L15","v":0}]
[8,"Meeting the Scope of Work Required","ESKOM requires to retain ownership of the data that ESKOM is stored, transmited, and/or created with the cloud service.  The ownership includes all copies of data available with the CSP, including backups.","Data Ownership and Use","Please confirm that ESKOM retains ownership of the data that ESKOM stores, transmits, and/or creates with the cloud service.",null,null,"Very important",4,{"$f":"I16/I$37","v":5.2631578947368418E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[9,"Meeting the Scope of Work Required","Please confirm that ESKOM will gain ownership of metadata generated by the cloud service system during procedures of upload, management, download, and migration.   Eskom data must be provided in an agreed format and time frame.","Data Ownership and Use","Eskom requires that the CSP should, at all times, ensure that Eskom resources have access to Eskom data including metadata and access logs and must provide Eskom data in an agreed format and time frame.",null,null,"Very important",4,{"$f":"I17/I$37","v":5.2631578947368418E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[10,"Meeting the Scope of Work Required","ESKOM prohibits this.","Data Ownership and Use","Does the Supplier reserve any rights to use, or make available  ESKOM data for the purposes of:\n\n- operating and improving the services\n- advertising\n - anonymized open data (through standard APIs)\n\n",null,null,"Very important",4,{"$f":"I18/I$37","v":5.2631578947368418E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[11,"Meeting the Scope of Work Required","ESKOM prefers the CSP to not be dependent on any 3rd party ","Availability, Retrieval and Use","Is the availibility of the cloud service dependent on any 3rd party and what risks are associated with this dependency?",null,null,"Very important",{"$f":"IF(H19='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H19='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H19='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H19='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H19='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H19='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H19='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I19/I$37","v":5.2631578947368418E-2},"Preferred answer is Yes\nIn Case of No, 3rd party integration and contracting should be seemless and not pose excessive risk to Eskom\n",null,{"$f":"J19*L19","v":0}]
[12,"Meeting the Scope of Work Required","The solution shall be available for use 24 hours per day, 7 days a week and 365 days per year.","Availability, Retrieval and Use","Does the degree of availability of the data meet ESKOM business needs as defined?  ",null,null,"Very important",{"$f":"IF(H20='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H20='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H20='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H20='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H20='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H20='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H20='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I20/I$37","v":5.2631578947368418E-2},"Yes\nReview availablitiy against business requirement",null,0]
[13,"Meeting the Scope of Work Required","Real-time Response is required ","Availability, Retrieval and Use","Does the Cloud Service (availability, latency, performance, integration) support real-time, semi-realtime or delayed interactive data exchange?",null,null,"Very important",{"$f":"IF(H21='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H21='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H21='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H21='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H21='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H21='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H21='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I21/I$37","v":5.2631578947368418E-2},"Yes\nReview performance against business requirement",null,0]
[14,"Meeting the Scope of Work Required","The solution shall be available for use 24 hours per day, 7 days a week and 365 days per year.","Data Storage and Preservation","Is backup of all data and metadata included as part of the service offering and are there tools and interfaces available for Administrators to interact with and restore this data?",null,null,"Very important",{"$f":"IF(H22='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H22='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H22='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H22='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H22='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H22='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H22='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I22/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation",null,0]
[15,"Meeting the Scope of Work Required","Eskom Requires this.  Details should be provided as to how this will  be done.","Data Storage and Preservation","At contract termination the CSP must be able to destroy ESKOM data and associated metadata (and all their copies, including backups)  in compliance with ESKOM data retention and disposition policies.",null,null,"Very important",{"$f":"IF(H23='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H23='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H23='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H23='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H23='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H23='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H23='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I23/I$37","v":5.2631578947368418E-2},"Yes, motivation provided should align to Eskom requirements.  Security team should provide guidance here",null,0]
[16,"Meeting the Scope of Work Required","ESKOM requires that the CSP maintain the same levels of security and controls required across all platforms and data centers.\n\n","Security, Confidentiality and Privacy","Does the system prevent unauthorized access, use, alteration or destruction of ESKOM data?\nAlso refer to Security Section for further details required.",null,null,"Very important",{"$f":"IF(H24='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H24='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H24='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H24='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H24='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H24='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H24='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I24/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation",null,0]
[17,"Meeting the Scope of Work Required","ESKOM requires the CSP to secure data during procedures of transfer into and out of the system","Security, Confidentiality and Privacy","ESKOM data is secured during procedures of transfer into and out of the system?\nAlso refer to Security Section for further details required.",null,null,"Very important",{"$f":"IF(H25='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H25='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H25='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H25='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H25='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H25='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H25='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I25/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation",null,0]
[18,"Meeting the Scope of Work Required","The Cloud Service Provider (CSP) must have the required certifications as determined in the Eskom Cloud Security Standard.\n\n","Security, Confidentiality and Privacy","Please list all relevant Cloud certifications and Audit reports for your Cloud Service. (e.g. ISO27018, SOC2 etc.)",null,null,"Very important",{"$f":"IF(H26='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H26='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H26='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H26='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H26='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H26='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H26='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I26/I$37","v":5.2631578947368418E-2},"Security Architecture to give guidance of acceptable standards.  Reference can be made to Cloud Security Standard",null,0]
[19,"Meeting the Scope of Work Required","The Cloud Service Provider (CSP) must have clear procedures and reporting tools in place to always notify ESKOM of any breach or system malfunction\n\n","Security, Confidentiality and Privacy","Will ESKOM be notified in the case of a security breach or system malfunction?",null,null,"Very important",{"$f":"IF(H27='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H27='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H27='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H27='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H27='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H27='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H27='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I27/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation"]
[20,"Meeting the Scope of Work Required","This is a strict requirement","Security, Confidentiality and Privacy","Does the Supplier have a confidentiality policy with regards to its employees, partners and subcontractors?",null,null,"Very important",4,{"$f":"I28/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation"]
[21,"Meeting the Scope of Work Required","ESKOM requires the CSP to have the required policies in place that protects Personal and Confidential data.  This should be in compliance with the POPI act.","Security, Confidentiality and Privacy","Does the Supplier’s terms include privacy, confidentiality, or security policies for sensitive, confidential, personal or other special kinds of data? If so, please confirm that these are aligned with Eskom’s requirements.\n",null,null,"Very important",4,{"$f":"I29/I$37","v":5.2631578947368418E-2},"Yes plus acceptable motivation"]
[22,"Meeting the Scope of Work Required","Details of where ESKOM data and their copies will be located while stored in the cloud service.\nData location should be in South Africa\n\n","Data Location","Please provide details of where ESKOM data and their copies will be located while stored in the cloud service?",null,null,"Very important",{"$f":"IF(H30='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H30='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H30='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H30='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H30='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H30='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H30='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I30/I$37","v":5.2631578947368418E-2},"Yes if located in South Africa plus details provided of the location of the data",null,{"$f":"J30*L30","v":0}]
[23,"Meeting the Scope of Work Required","ESKOM requires this at no additional cost","End of Service - Contract Termination ","If the contract is terminated, will ESKOM data be transferred to ESKOM or to another Supplier of ESKOM’s choice in a usable and interoperable format?",null,null,"Very important",{"$f":"IF(H31='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H31='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H31='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H31='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H31='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H31='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H31='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I31/I$37","v":5.2631578947368418E-2},"This is dependant on the solution.  Evaluation subjective",null,{"$f":"J31*L31","v":0}]
[24,"Meeting the Scope of Work Required","The solution shall be available for use 24 hours per day, 7 days a week and 365 days per year","Service Availability","Please advise how soon ESKOM will access its data and the services in the event of downtime which may be caused due to, inter alia:\n- a server being down;\n- data loss or corruption;\n-  the failure of a telecommunications link;\n- a natural disaster causing damage to Supplier’s data centre; or\n- the provider closing its business because of financial difficulties.",null,null,"Important",3,{"$f":"I32/I$37","v":3.9473684210526314E-2}]
[25,null,"The solution shall be available for use 24 hours per day, 7 days a week and 365 days per year.","Disaster Recovery & Business Continuity","Supplier will be required to include detailed disaster recovery and business continuity plans requiring Supplier to demonstrate and promise that Supplier can continue to make the services available even in the event of a disaster, power outage or similarly significant event.",null,null,"Important",3,{"$f":"I33/I$37","v":3.9473684210526314E-2}]
[26,null,"Supplier is not allowed to withhold services under any circumstances.","Disaster Recovery & Business Continuity","Withholding of services \n- Under Supplier’s standard offering, to what extent would Supplier withhold services?\n- Suppler will warrant that it will not withhold Services provided hereunder, for any reason, including but not limited to a dispute between the parties arising under this Agreement, except as may be specifically authorized herein.",null,null,"Important",3,{"$f":"I34/I$37","v":3.9473684210526314E-2}]
[27,null,"ESKOM requires at a minimum the following to be addressed:\n·       Uptime (see specific Uptime requirements);\n·       Details of planned downtime\n·       service response time;\n·       simultaneous visitors;\n·       problem response time and resolution time;\n·       data return; and \n·       remedies including service credits.\nSee RFP for specific requirements.","Service Levels","ESKOM requires assurance from the Supplier that ESKOM can rely on the services. Supplier will be required to provide ESKOM with (i) detailed service levels and (ii) appropriate remedies if Supplier fails to meet the agreed service levels.",null,null,null,4,{"$f":"I35/I$37","v":5.2631578947368418E-2}]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I12:I31)","v":76},{"$f":"SUM(J12:J31)","v":0.99999999999999956},null,null,{"$f":"SUM(M12:M31)","v":0}]

{"sheet":"Security","index":6,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,13,7,13]]}
["Integrated Prepaid Electricity Vending System"]
["CORP xxxx Tender",null,null,null,null,null,null,null,null,null,null,"Scoring (Sliding scale)"]
["Tenderer:",null,null,null,null,null,null,null,null,null,null,"100% - Fully compliant"]
["Evaluated by:",null,null,null,null,null,null,null,null,null,null,"50%-Partially compliant"]
[null,null,null,null,null,null,null,null,null,null,null,"0%-Non compliance"]
["Evaluation Criteria"]
[null,null,null,null,null,"Vendor Compliance\nFull Compliance - Y\nPartial Compliance - P\nNon Compliance - N","Vendor to indicate any applicable response based on Compliance","Priority\nRequirement priority as determined by Eskom","Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score",null,"Comments (Internal) for scorer"]
["ID","Type","Criterion","Functional Requirement","Requirement description","Vendor Compliance","Vendor Response","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Certificate from the OEM or Reputable Authority ","Information Security","Information Security Threat Management \nPlease advise to what extend is your Solution Compatible with each of below:\n1. Malware\n2. Cyber Attack\n3. Anti-Virus\n",null,null,"Very important",{"$f":"IF(H9='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H9='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H9='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H9='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H9='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H9='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H9='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I9/I$17","v":0.30769230769230771},"Score 5 for providing information on all three\nScore 3 for providing information on two\nScore 1 dor providing information on one",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","E2E Encryption\nEncryption of Data in transit and in Rest\nDoes your Proposed Solution comply and is compatible with the latest TLS and Cypher Standards to protect and encrypt data?",null,null,"Critical",{"$f":"IF(H10='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H10='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H10='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H10='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H10='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H10='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H10='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I10/I$17","v":0.38461538461538464},"Score 5 for Encryption of both data in transit and Rest\nScore 3 for only Encryption of data in transit\nScore 1 for only Encryption of data in rest",null,0]
[3,"Meeting the Scope of Work Required","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal\n\nData classification is confidential","Information Security Confidentiality + Integrity and protection against Cyber Exploit ","Data Classification\nAll ICT Projects solutions in Eskom need to indicate a detail  Information Classification criteria matrix ( Controlled Disclosure, Confidential, Secret, Top Secret) to be indicated by Business and System owner and need to be visible for PM. Does your System Data align with, National Cyber Security Policy Framework as well as Critical Infrastructure Protection Act requirements to Secure data/information  againts Cyber Exploitation?",null,null,"Very important",{"$f":"IF(H11='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H11='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H11='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H11='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H11='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H11='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H11='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I11/I$17","v":0.30769230769230771},"Score 5 for \"aligning\" with Acts/Frameworks, score 0 for \"no aligning\" with Acts/Frameworks",null,0]
[4,"Meeting the Scope of Work Required","Data Security","Data Security","For security reasons Validation data should not be stored on the mobile device",null,null,"Very important",{"$f":"IF(H12='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H12='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H12='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H12='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H12='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H12='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H12='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I12/I$17","v":0.30769230769230771},"Score 5 for \"yes\", score 0 for \"no\"",null,{"$f":"J12*L12","v":0}]
[5,"Meeting the Scope of Work Required","Data Security","Data Security","There must be full auditability on all communications",null,null,"Very important",{"$f":"IF(H13='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H13='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H13='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H13='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H13='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H13='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H13='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I13/I$17","v":0.30769230769230771},"Score 5 for \"yes\", score 0 for \"no\"",null,0]
[6,"Meeting the Scope of Work Required","Data Security","Data Security","Customer data should only be stored for the duration of the USSD transaction. ",null,null,"Very important",{"$f":"IF(H14='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H14='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H14='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H14='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H14='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H14='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H14='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I14/I$17","v":0.30769230769230771},"Score 5 for \"yes\", score 0 for \"no\"",null,0]
[7,"Meeting the Scope of Work Required","Data Security","Data Security","Data should be retained as far as possible and should only be kept for the period of the customer interaction. Data should be deleted from 3rd party. Record of the transaction will be kept on our CRM.  Reference number will be sent to customer via USSD / SMS.",null,null,"Very important",{"$f":"IF(H15='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(H15='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(H15='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(H15='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(H15='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(H15='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(H15='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I15/I$17","v":0.30769230769230771},"Score 5 for \"yes\", score 0 for \"no\"",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I11)","v":13},{"$f":"SUM(J9:J11)","v":1},null,null,{"$f":"SUM(M9:M11)","v":0}]