{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sheet1","Summary","Demo","Functional","Sheet3","Technical evaluation","Integration and Testing","Demonstration","Priority Ratings","Config","Concerns and Recommendations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"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":"Sheet1","index":0,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
["ID","Type","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Design of solution","• Functional Specification and Detailed Design: \nApproved Functional Specification and Detailed (Physical) design based on the User Requirement Specification and Logical Design provided as part of RFP.  ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",0.5,4.4910179640718561E-3]
[2,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","• Support of cloud\nStandAlone or cloud solution","Provide solution details indicating whether the solution can be deployed as a standalone or via the cloud\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[3,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Breakdown / decomposition of the functionalities  \n"," The functional capabilities are broken down / decomposed\n* Interaction\n* Intelligence\n* Integration\n* Development",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[4,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Capability to support customer journey's / service types in conjunction with AI (Chatbot)","Solution capabilities support use cases/Customer jouneys are per Customer journey/service types submitted as attachment. \nThe Customer service interactions (use cases) are categorised by types (Supporting attachment called “Customer Services: Service categories and types”) that are handled by the contact center. \nThe following are the high priorities: \n a. Electricity Supply Problem (high priority) \n   i. receive feedback on faults reported (I,e, using a ref number)\n   ii. And progress feedback on faults a section item\n b. Submit Meter readings (high priority). \n  c. Refer to attachments for a complete list of ALL service \ncategories\n  i. An important one can be data enrichment such as verification and  \n     updating of customer details such as telephone numbers etc.\n",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[5,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Provide reference number feedback","Capability to display reference number that has been generated by Eskom source systems. The solution should include reference number feedback (i.e. Customer calling in to see how far the fault is and getting feedback on it.)",null,"Very important",4,1.1976047904191617E-2,"100%: Out of box functionality\n75%:   Development\n0%:     No compliance",null,0]
[6,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Flag customers - Low buyer","Ability to interpret flag from backend systems and respond accordingly to customers as per the business rules. ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[7,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Flag customers - Customer previously logged fault","• Another flag should be considered as to whether this customer has previously logged the fault (i.e. to eradicate duplications). (Functionality to be built in OMS) - Discussion with CC&I and OMS for implementation.\n• The outage flags must also include (planned, unplanned, load shedding, load reduction) ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[8,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Inform Customers","Capability , in conjunction with AI(Chatbot) to inform customer that they have been flagged as such and inform them of the business process  that will follow \n * they will be audited in n x days), \n * to inform them to pay a certain amount to be “unblocked”  ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[9,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Provide Geo location of caller","Ability for the social media channel API (WhatsApp) to get geo-locations of the caller, where possible. Indicate how the data will be pass-through. ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[10,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Determine if customer is afected by Outage","Identify if customer is affected by planned or unplanned outage and advise customer.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[11,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Customer interface: "," Provide capability for client to develop the logic/features of the solution directly. This includes tuning of rules etc. /admin – \nAbility to easily configure WhatsApp profile.Provide flexibility to configure as required.\nWhatsApp welcome greeting. This will be determined by business and the solution should allow this configuration to be flexible and allow the client to perform this configuration using simple GUI.",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[12,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Development platform \nUser / Self-configurable option with a simple GUI Interface","Provision of a UI environment preferred. Low code or no code. Provision of a graphical User Interface to develop the BOT. User is able to make configurations/changes etc without coding experience / drag and drop (add fields etc)\nAbility to configure and provide an Auto respond with a message/s i.e. “We have received your chat…..”. This should also be a self-configurable option with a simple GUI Interface. -",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[13,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Account Registration and verification of users.\nAuthentication security capability","Administration, Support and management - need to use MS AD / Azure. Employees can use same org credentials.\nFor Customers: \nSupport of OAuth and SAML2.\n",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[14,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Handling of disclaimers is managed","Indicate how the handling of disclaimers is managed / configured. I.e. for the risk of information around meters/billing that is transmitted between Eskom and Customer etc. i.e. WhatsApp on an open desktop. Anybody can access an unlocked desktop.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[15,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Solution availability on different platforms","The solution should be available on mobile and web browser (e.g. as an application), Application for Desktop & Mobile platforms. Minimum OS Android and IOS supported . \nAt least Internet Explorer /Edge, Mozilla, Chrome and Safari",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[16,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Solution availability on different platforms","Management, Administration, Support Internet Explorer /Edge, Mozilla ",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[17,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Intergration - to backend systems to address querries","The social media channel API solution intergrate via AI (Chatbot) for purposes of actioning or addressing queries. Also intergrate with any other social media channel.\n",null,"Show stopper",6,1.7964071856287425E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[18,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intergration - to backend systems to address querries","The Chatbot solution should be able to access existing / new databases or integrate to applications for purposes of actioning or addressing queries via the defined intergration technology.\n(Applications i.e. Work Force Management, Billing, CRM, OMS – (PowerOn Advantage), verification of contact details etc.\n",null,"Show stopper",6,1.7964071856287425E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[19,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Carry incoming/outgoing transactions  ","Indicate the social media channel API ability to carry incoming/outgoing transactions  \nPerformance:\nCapability to handle 20 000 messages per day. Also indicate concurrent capability.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[20,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Incoming/outgoing transaction capability\n","Incoming / outgoing transaction capability should cater for:\n  o Customer Surveys\n",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[21,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Incoming/outgoing transaction capability\n","Incoming / outgoing transaction capability should cater for:\n  o General feedback",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[22,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Incoming/outgoing transaction capability","Incoming / outgoing transaction capability should cater for :\n  o Visibility of the network. i.e. Customer confirms supply is restored\n ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[23,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Incoming/outgoing transaction capability\n","Incoming / outgoing transaction capability should cater for:\n  o marketing from Eskom",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[24,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Message relay ","(read and write to social media channels for text, media, web hooks, message templates, SMS / Rich Communication Service support etc.).",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[25,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Developer Portal and versioning for API Lifecycle Management.","Ability to manage versioning ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[26,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Security - Provision of secure environment and protection of data","Needs to comply with the POPI act. Business is dealing with personal information.\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[27,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security - Data encryption","Data to be encrypted – end to end. Must be pass through to the routing engine. Prior to routing engine. Post API.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[28,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security ","Uploading, Retrieving and Deleting Client / Web hook CA certificate.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[29,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security ","Setup and use HTTPS endpoints.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[30,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security ","* Access control\n* Authentication Token \n* Threat Protection\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[31,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Dashboard Console ","Dashboard Console to monitor and alert on API health / activity.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[32,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Caller ability to \"switch\" to diferent querry/type","The solution is required to support topic switching. To varying degree (e.g. multiple items in a single request/case). ",null,"Useful",2,5.9880239520958087E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[33,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Input capabilitues inclusive. \nIndicate what types of content are supported i.e. pdf, jpg etc.\n","Provision of additional input classes \n* Vocie and Text ",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[34,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Input capabilitues inclusive. \nIndicate what types of content are supported i.e. pdf, jpg etc.\n","Provision of additional input classes / rich content directly into messages\n* image \n* barcodes from images. \n* Documents\n* GPS Cordinates\n * Proof of payments. aterfacts to be saved\n* provision of repository for artefacts.refer to archiving standards and legal. \n* Ability to embed data / rich content from the integrated features of the host device ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[35,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Input capabilitues inclusive. \nIndicate what types of content are supported i.e. pdf, jpg etc.\n","Handle XML , Jason to text\n- Business wants to move away from SMS, to other forms of communication\n",null,"Useful",2,5.9880239520958087E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[36,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Load volumes and Scalability for growth","Indicate the solution capabilities regarding the load/volumes i.e. physical number of messages and size of messages \nScalability: Flexibility to allow for future growth. Growth is expected – possibly a selection of the full customer base responding to AI related channels (Residential customers = 7 mil+/100K concurrency) \n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[37,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to handover to human or other channels","When customers do not find an option to resolve their case or query using the WhatsApp channel, they will be directed to another channel. This should be configurable. \nFeedback of queries which is inaccurate could result in litigation (low risk). ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[38,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to handover to human or other channels","\nSafety and other sensitive interactions should be routed / directed according to Business process. i.e Handled by Human agent",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[39,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Abilty to use/configure/port a preferrred number ","Business has a preference to use the 086 Contact Centre number. \nNeed to consider the impact of moving customers to a new number.Could have an auto repsonce to customer to use the new number.","\n","Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[40,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to develop / Modify standard templates to guide user interaction  based on current Case based reasoning","Predefined templates that can be configured. Vendors template flexibility to allow structured questions for case based reasoning. Development according to Eskom requirements. Allow for changes down the line. The ease in changing templates for Eskom requirements. Drag n drop preferrance.Customer interactions will be guided and provided via templates, this should allow for the customer to choose and provide enough information to classify/process the request. This is more structured. This follows the case based reasoning. ALLOW FOR STRUCTURED (Different levels as well) CHANGES TO BE IMPLEMENTED. Scoring (80-90% User configurable -100%, 60-80% User configurable - 50%, < - 0%)\nMore discussion to resolve.",null,"Very important",4,1.1976047904191617E-2,"100%: 80-90% User configurable\n50%:   60-80% User configurable\n0%:     No compliance",null,0]
[41,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to develop structured interactions to to obtain and interrogate data easily ","Platform capability to function with organisation's current and future case base reasoning structure. Information/data from interactions should be structured in an intelligent format, using i.e.  /root cause tree, drop down boxes etc. to receive data in format that can be interrogated. ",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[42,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Automated interactions applicable","The Chatbot will power the WhatsApp channel resulting in an automated interaction. Therefore the vendor should indicate how much can be automated from start to end of the process. \nScoring- with regards to what is currently automated-100% (Lakheni)",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[43,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Inclusive list of supported languages","Language support. English is the primary language. Provide an inclusive list of what official South African languages are supported. \nMulti-language translation will be more applicable to conversational bots.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[44,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Non-Latin characters support"," Support for non-Latin characters i.e. Cyrillic script - Customers not using standard characters / emojis etc.. How dow the platform support / filter / handle these characters. Not only alphabetical but also symbols. What hac been tested. Applies to free text",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[45,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Filtering capability","Indicate the Filtering capability – i.e. only take numbers from South Africa. Prevent DOS Attack etc. This will provide the capability to route an interaction from a VIP to Key customer etc.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[46,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Performance - Response times","o Indicate how fast the solution is. \no Down and uptime. \n* Capability of performing technical analysis - when the back end apps experiencing increased load. How does the platform handle this. Notifications/alerts. End to end. Having multiple queues / seperate from other customers. Other organisations customers handled seperately.\nResponse times required – Responds needs to be quicker than email, SMS especially since this is using an automated process i.e. Chatbot. Responses should be within seconds. “Chatlike”.\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[47,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Performance - Availability and scaling","High Availability to support 24/7 operations. Impacts Eskom image. DR and failover.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[48,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Broadcast capabilty"," Indicate the type of broadcast capability. One-to-many broadcast capability. Customer groups for communication via the social media channel API will be configured by internal source systems. Solution should provide capability and configuration to allow this. \no broadcasts /Campaigns /notifications /Alerts /Markketing/Surveys\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[49,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Creation and Management of groups.","Ability to port/import files with customers/contact details and communicate. Ability to create groups. Ability to alow ad-hoc communication.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[50,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Reporting - ","Capability to access any data analytics i.e Power BI, SAS (internal – specific to the AI). To provide reports to admin/management/customers i.e. \no Count customer interactions\no Audits\no Ensure that all transactions via channel are completed\n* Indicate standard reports - \n* Ability to easily create custom reports\n - ie correlation between interactions in particular area ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[51,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Reporting - ","Management of the support process (1st line and 2nd line)\no Performance monitoring reporting which is the same as that done on an existing  agent/channel- Lakheni to check what CC&I has?\no How many queries (customer journeys) handled per type.\no The time to resolve\no Repeat calls that started at the WhatsApp and went to other channels\nwhat higer level escalation is provided to report/handle the service side (Platform)\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[52,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Reporting - ","• Audit \no Reporting to assess if the WhatsApp is doing the correct things by comparing the query results against the information in the database, e.g. balance enquiry journey results sent to customer to be verified against what sits in the database].\n",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[53,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Auditing","Indicate the audit controls- show a chain of message custody. Prove that the transaction was conducted end to end. No interception.\n",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[54,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Training","Training to be documented and performed in English as a minimum",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[55,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Training","Conducted in South African time ",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[56,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Training","Indicate frequency of training. Continuous training to be available.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[57,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Training","Installation, configuration, development -",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[58,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Training","Installation, configuration, development -",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[59,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Interaction","Human to bot interaction - \nBasic level Customer interaction with bot, also Handoffs etc.",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[60,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Interaction","Multi-Channel - multiple social media channels and other multimenia channels",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[61,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Interaction","Bot-to-bot interaction",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[62,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Menu Based - Based on USSD type interaction. Does it provide the capability to develop this.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[63,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Word based rules",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[64,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Line based intelligence",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[65,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Intent Separation",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[66,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","State Machine",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[67,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Mood detection\nThe solution is required to perform sentiment analysis. E.g. mood/complaints etc. Typically to handle anger/racism/etc.  Ability to escalate to human-handover process",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[68,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Conversation listening. Text based is important. Listen with intent to understand. Ie mood. Make further analysis based on conversation. \nWhat about whats app voice recording. Does business want to handle this.\n",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[69,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Conversation based intelligence\n",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[70,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","B2B conversation (Bot to bot)",null,"Useful",2,5.9880239520958087E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[71,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Training of NLP Model",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[72,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Self-learning",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[73,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Passes the Turing test - Clarify definition. Test machine ability to exhibit behaviour equivalent to human.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[74,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Should respond in keystroke-type (Text) and / or natural talk language (voice) outputs -",null,"Critical",5,1.4970059880239521E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[75,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Community Support\nNeed assistance from development community. To resolve similar problems.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[76,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","3rd Party Support\nWhat technology will they use. Will they support this technology. Looking outside for assistance. Provide alternatives for resolution of issues.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[77,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Error Handling\nLevel of error handling: Exception  handling at code level and descriptive errror messages interpretation ",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[78,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Support of Multi-bot Approach\nApproach to define more than one bot. Aligned to B2B. Call existing libraries / reuse code/objects.",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[79,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Support of Custom Component Approach",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[80,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Support of Flow Chart Approach",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[81,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Development","Channel Agnostic Design\nCapbaility to be implmented on multiple channels (Social media, SMS, Email etc)",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[82,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Entity Definition (incl. regular expressions)",null,"Important",3,8.9820359281437123E-3,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[83,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Vendor Support\nProduct supplied/implemented supported by one/multiple vendors\nStandard vanilla or modified solutions.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[91,"Meeting the Scope of Work Required","Are the list of all roles in the project team provided?  Are there perceived missing roles (Provide comments)?  Provided a project resource model.","Chatbot and Social Media API","Non Functional / Administration","Is it possible in the solution for power users must be enabled to make minor configuration changes , e.g. updating lookup lists, field visibility, screen layout, queries/reports, business rules, workflows etc. without depending on IT staff.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[90,"Meeting the Scope of Work Required","Are the list of all roles in the project team provided?  Are there perceived missing roles (Provide comments)?  Provided a project resource model.","Chatbot and Social Media API","Non Functional / Administration","Roles: Internal administration and Customers.\nCan different user roles be created. Describe the user roles that can be defined in the solution.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[89,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Security","Can the solution integrate to LDAP  to manage user secure login?\n",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[87,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Data migration / Import and export of data","Will it be possible to easily migrate all data, in an agreed format, to a new system should  a replacement solution be required in future?\nBusiness continuity impact.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[88,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Implementation ","Provide a high level architecture for the proposed solution by referriing to the business, informtion, data, application, security and technology components. According to Current Eskom Architecture patterns.",null,"Very important",4,1.1976047904191617E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]

{"sheet":"Summary","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[22,0,22,1],[1,4,3,4],[1,5,3,5],[1,6,3,6],[6,0,6,3],[7,0,7,3],[8,0,8,3],[14,0,14,5],[9,0,9,3],[10,0,10,3],[11,0,11,3],[15,0,15,5],[16,0,16,5],[18,1,18,2],[18,5,19,5],[19,0,21,0],[19,4,21,4],[1,9,3,9],[1,10,3,10],[1,11,3,11],[5,0,5,3],[0,0,0,3],[0,4,0,13],[1,1,1,3],[2,1,2,3],[1,12,3,12],[1,13,3,13],[1,8,3,8],[3,1,3,3],[1,7,3,7]]}
[{"$f":"'Technical evaluation'!A1","v":"MyEskom Outage Mobile App"}]
["CORP xxxx Tender",null,null,null,"Please indicate location of answers to the criteria and where required answer yes or no."]
["Tenderer:"]
["Evaluated by:"]
[]
["Important Notes: "]
["1. Please indicate location of answers to the criteria and where required answer yes or no. To be included in Comments tab per sheet."]
["2. The qualified solution service provider shall do a product demo of the proposed product to be presented to Eskom.  This is mandatory. "]
["3. \"Tenderer(s) to take note of the following key instructions - Please follow the structure of the technical evaluation sheet provided when responding to this enquiry."]
["4.  DO NOT just give YES/NO kind of response to the questions which require more details and information."]
["5. Provide full information to your answer(s) in line with the details of the question(s) in point.\" "]
["6. All Code that is developed by the Vendor on behalf of Eskom, remain Eskom’s IP"]
[]
[]
["Notes regarding Table Below"]
["Paper based evaluation makes up 80% of the total score and the Demo makes up 20% of the final score "]
["The responses will be evaluated and the threshold is 65%.  Only the service providers who manage to score 65% and above will qualify for the next part of the Commercial process"]
[]
["Stage","Weighting",null,"Total","RFP Total","Final Score\nRFP+Demo"]
["Paper based evaluation","Functional",0.5,{"$f":"B30*C20","v":0},{"$f":"SUM(D20:D22)","v":0}]
[null,"Technical",0.25,{"$f":"B31*C21","v":0},null,{"$f":"(E20*0.8)+(D23*0.2)","v":0}]
[null,"Integration and Testing",0.25,{"$f":"B32*C22","v":0}]
["DEMO",null,1,{"$f":"B33","v":0}]
[]
[]
[]
["Evaluation on Weighted Criteria"]
[]
["Evaluation on Weighted Criteria"]
["Sum of Weighted Question (Functional)",{"$f":"Functional!M26","v":0}]
["Sum of Weighted Question (Technical)",{"$f":"'Technical evaluation'!M22","v":0}]
["Sum of Weighted Question (Integration and testing)",{"$f":"'Integration and Testing'!N27","v":0}]
["Sum of Weighted Question (Demo)",{"$f":"Demo!M17","v":0}]

{"sheet":"Demo","index":2,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,10,6,12],[15,0,15,12],[0,0,0,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,8,6,9]]}
[{"$f":"'[1]Technical evaluation'!A1","v":"MyEskom Outage Mobile App"}]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"User registration and verification","Demonstrate in previous applications deployed, the ability to verify and register users",null,"Important",{"$f":"IF(H9='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H9='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H9='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H9='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H9='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H9='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H9='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},{"$f":"I9/I$17","v":0.125},"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"User authentication.\n\n","Demonstrate in previous applications deployed, the ability to authenticate users",null,"Important",{"$f":"IF(H10='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H10='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H10='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H10='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H10='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H10='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H10='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},0.125,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[3,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"Build and consume API's","Demonstrate in previous applications deployed, the ability to build and consume API's",null,"Critical",{"$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":5},0.20833333333333334,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[4,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"Pull and push notification functionality","Demonstrate in previous applications deployed, the use of pull and push notifications",null,"Critical",{"$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":5},0.20833333333333334,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[5,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"Style the app","Demonstrate in previous applications deployed, various styles of the apps",null,"Important",{"$f":"IF(H13='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H13='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H13='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H13='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H13='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H13='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H13='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},0.125,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[6,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"App map functionality e.g. Leaflet and Google maps","Demonstrate in previous applications deployed, the use of maps",null,"Important",{"$f":"IF(H14='[1]Priority Ratings'!$C$21,'[1]Priority Ratings'!$B$21,IF(H14='[1]Priority Ratings'!$C$22,'[1]Priority Ratings'!$B$22,IF(H14='[1]Priority Ratings'!$C$23,'[1]Priority Ratings'!$B$23,IF(H14='[1]Priority Ratings'!$C$24,'[1]Priority Ratings'!$B$24,IF(H14='[1]Priority Ratings'!$C$25,'[1]Priority Ratings'!$B$25,IF(H14='[1]Priority Ratings'!$C$26,'[1]Priority Ratings'!$B$26,IF(H14='[1]Priority Ratings'!$C$27,'[1]Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},0.125,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[7,"Meeting the Scope of Work Required","A software demonstration of the functional capabilities of the Bidder's solution.  List concerns in Comments.",null,"Mobile app publication.","Demonstrate that previous applications have been deployed to Google, Apple and Huawei app stores",null,"Useful",{"$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":2},8.3333333333333329E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I15)","v":24},{"$f":"SUM(J9:J15)","v":1},null,null,{"$f":"SUM(M9:M15)","v":0}]

{"sheet":"Functional","index":3,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,10,6,12],[24,0,24,12],[0,0,0,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,8,6,9]]}
[{"$f":"'Technical evaluation'!A1","v":"MyEskom Outage Mobile App"}]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"User registration and verification","The ability for a user to register as an app user, using a cellular number.  An OTP must be sent to the cellular number to verify the cellular number provided.  The registration details and unique device ID must be stored in the mobile backend.  The mobile backend must handle the registration and verification process and must be configurable for future registration and verification requirements.",null,"Critical",{"$f":"IF(H9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},{"$f":"I9/I$26","v":6.4935064935064929E-2},"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"User authentication.\n\n","Once a user has successfully registered on the app, the user / device should be authenticated automatically when using the app\nThe backend must handle the authentication process and must be configurable for future authentication requirements.",null,"Critical",{"$f":"IF(H10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[3,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Reporting a customer outage","The ability for customers to identify their product / service, log a service request (for example logging electricity supply problems) and receiving responses to diagnostic questions (API’s / Chatbot interface used), receive a service request reference number (from the CRM system) and get feedback on the service request status (from information supplied from the CRM system).",null,"Critical",{"$f":"IF(H11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,{"$f":"J11*L11","v":0}]
[4,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Get the status of a reported fault","The ability for customers to view a service request's current status (API's used, information supplied by CRM system).",null,"Critical",{"$f":"IF(H12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,{"$f":"J12*L12","v":0}]
[5,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Case based reasoning","The ability to display diagnostic questions and process customer responses during the service request logging process (API's used). \nThe ability to interface with the Eskom chatbot (which drives diagnostic questions and processes customer responses) and have the ability to display appropriate, contemporary, user friendly user interface (which is selected and approved by Eskom business)  ",null,"Critical",{"$f":"IF(H13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[6,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Create watchlist items","The ability to save a list of accounts, prepaid meter, area, products or services as favourites in order to receive product / service notifications, such as updates on electricity outages  (API's used).",null,"Critical",{"$f":"IF(H14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[7,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Receive pull and push watchlist updates","The ability to receive accounts, prepaid meter, area, products or / services pull and push notifications for items saved in the list of favourites (API's used).",null,"Critical",{"$f":"IF(H15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[8,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Update the watchlist","The ability to update the list of accounts, prepaid meter, area, products or / services and preferences for items saved as favourites (API's used).",null,"Critical",{"$f":"IF(H16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[9,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Receive and respond to push notifications","The ability to receive push notifications with options linked to actions (API's used) eg enquiring whether a customer's supply has been restored and customers having the ability to respond (Yes or No response).",null,"Critical",{"$f":"IF(H17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[10,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"View current outages","The ability to view currently active service interruptions for accounts, prepaid meter, area, products or / services.  Viewed in map or list view, with the option to disable the map view.",null,"Critical",{"$f":"IF(H18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[11,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"View future (planned) outages","The ability to view planned service interruptions for accounts, prepaid meter, area, products or / services.  Viewed in map or list view, with the option to disable the map view.",null,"Critical",{"$f":"IF(H19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[12,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Style the app","The ability to style the application according to Eskom corporate identity guidelines.\nRefer to wireframes and Corporate identity guidelines.",null,"Very important",{"$f":"IF(H20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.1948051948051951E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[13,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Future proof app design","The ability to add functionality in future releases to the app without having to re-design the entire app. They will include:\n• Billing and account details\n• Submission of meter readings with pictures as proof\n• Account payments\n• Purchase of prepaid electricity tokens\n• Applications for supply\n• Submitting proof of payment with attachments or pictures as proof\n• Logging of various “other” service requests\n• Displaying dynamic content in the app (i.e. photos and other digital media)\n• Changing of registration and authentication processes\n• Track and tracing (Uber like interface) of technicians",null,"Very important",{"$f":"IF(H21='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H21='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H21='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H21='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H21='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H21='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H21='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.1948051948051951E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[14,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"App mapping functionality.","The ability to use various web map services to:\n•\tSearch for locations\n•\tSet and save locations / pins\n•\tDisplay the current device location\n•\tPan to another location on the map and display data related to the new location\n•\tDisplay polygons related to the current or selected location (location within a set distance of an outage)",null,"Very important",{"$f":"IF(H22='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H22='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H22='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H22='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H22='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H22='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H22='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.1948051948051951E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[15,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  Supporting evidence from a portfolio of previous applications of a similar scope and customer testimonials?  List concerns in Comments.",null,"Mobile app publication.","The mobile app must be available for download from the Google Play Store, Huawei App gallery and the Apple app store for cellular phones, published under the Eskom accounts.",null,"Critical",{"$f":"IF(H23='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H23='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H23='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H23='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H23='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H23='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H23='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,0]
[16,"Team Organisation and Member Requirements","Roles:\nProject manager\nTesting resources (Test manager, testers, perf scriptor) \nIntegration resources\nTraining / Skills transfer\nSystem analyst - Developer, configuration, build resource/s\nSolution architect for detailed design",null,"Project Management","\nAre the list of all roles in the project team provided?  Are there perceived missing roles (Provide comments)?  Provide a project resource model.\n",null,"Critical",{"$f":"IF(H24='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H24='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H24='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H24='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H24='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H24='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H24='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},6.4935064935064929E-2,"100%: Fully comply with requirement\n50%:   Partially comply\n0%:     No compliance",0,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I24)","v":77},{"$f":"SUM(J9:J24)","v":1.0000000000000002},null,null,{"$f":"SUM(M9:M24)","v":0}]

{"sheet":"Sheet3","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,"Test"]
[null,null,null,null,1]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,5]

{"sheet":"Technical evaluation","index":5,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,12],[6,10,6,12],[6,8,6,9],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3]]}
["MyEskom Outage Mobile App"]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Solution","Criterion","Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required",null,"Provision of proof that the company has successfully developed a mobile application using React Native.","Development","Provide evidence of successful project implementation (evidence such as reference letter, downloadeable from an app store).",null,"Very important",{"$f":"IF(H9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"I9/I$22","v":7.407407407407407E-2},"< 2 Evidence sources = 0%\n2 or more evidence sources with\n1 project  = 25 %\n2 projects = 50 %\n3+ projects =100 %",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required",null,"Provision of proof of having a minimum of 2 resources that have experience in developing mobile apps using React Native","Development","Provide CV's and evidence of successful project implementation",null,"Show stopper",{"$f":"IF(H10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},0.1111111111111111,"<2 CVs = 0%\n2 or more CVs with\n1 project  = 25 %\n2 projects = 50 %\n3+ projects =100 %\n",null,0]
[3,"Meeting the Scope of Work Required",null,"Provision of proof of having at least one resource that has experience in developing Restful APIs in .NET","Development","Provide CV's and evidence of successful project implementation",null,"Critical",{"$f":"IF(H11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},9.2592592592592587E-2,"< 1 CV = 0%\n1 or more CVs with\n1 project  = 25 %\n2 projects = 50 %\n3+ projects =100 %\n",null,0]
[4,"Meeting the Scope of Work Required",null,"Provision of proof of having at least one resource that has experience in application analysis and design (mockups/UX design/Functional Specifications)","Analysis and Design","Provide CV's and evidence of successful project implementation",null,"Critical",{"$f":"IF(H12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},9.2592592592592587E-2,"< 1 CV = 0%\n1 or more CVs with\n1 project  = 25 %\n2 projects = 50 %\n3+ projects =100 %\n",null,{"$f":"J12*L12","v":0}]
[5,"Meeting the Scope of Work Required",null,"Number of years of experience the resources have working with Restful APIs in .NET","Development","Provide CV's and evidence of successful project implementation",null,"Critical",{"$f":"IF(H13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},9.2592592592592587E-2,"0-1 years= 25%\n2 years = 50%\n3  years = 75%\n4  years = 100%",null,0]
[6,"Meeting the Scope of Work Required",null,"Number of years of experience the resources have in building apps using React Native","Development","Provide CV's and evidence of successful project implementation",null,"Critical",{"$f":"IF(H14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},9.2592592592592587E-2,"0-1 years= 25%\n2 years = 50%\n3  years = 75%\n4  years = 100%",null,{"$f":"J14*L14","v":0}]
[7,"Meeting the Scope of Work Required",null,"Number of years of experience the resources have application analysis and design (mockups/UX design)","Analysis and Design","Provide CV's and evidence of successful project implementation",null,"Critical",{"$f":"IF(H15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":5},9.2592592592592587E-2,"0-1 years= 25%\n2 years = 50%\n3  years = 75%\n4  years = 100%",null,{"$f":"J15*L15","v":0}]
[8,"Meeting the Scope of Work Required",null,"Eskom wants to determine the measure the supplier will put in place for system's ability to increase or decrease in performance.","Deployment","Describe the scalability options for your solution. Also provide high level physical architecture of the solution",null,"Very important",{"$f":"IF(H16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},7.407407407407407E-2,"100%: Fully comply with requirement\n\n0%:     No compliance",null,0]
[9,"Meeting the Scope of Work Required",null,"The target audience for this app is the general public, and therefore Eskom requires a solution that can handle multiple number of users at any point in time.","Maximum users","The app should be able to handle a minimum 10 000 concurrent users.\n\nCan this requirement be met, please elaborate in terms of estimated infrastructure requirements or mechanisms to be deployed.",null,"Important",{"$f":"IF(H17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},5.5555555555555552E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",null,0]
[10,"Meeting the Scope of Work Required",null,"Please provide assurance that the Intelectual Property (IP) of the solution will remain with Eskom","Intelectual Property Ownership","Eskom requires to retain the Intelectual Property (IP). Please provide assurance that this will be done accordingly.",null,"Show stopper",{"$f":"IF(H18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},0.1111111111111111,"100%: Yes\n\n0%:     No",null,0]
[11,"Meeting the Scope of Work Required",null,"Previous experence in carrying out reporting capabilities","Support and Reporting","Does your solution offer the following Reporting capabilities that are easily configurable by a super-user. Please describe how this is achieved.\n* Historical event analysis and reporting\n* Real-time reporting\n* Trend analysis and reporting\n* Scenario analysis",null,"Important",{"$f":"IF(H19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},5.5555555555555552E-2,"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",null,{"$f":"J19*L19","v":0}]
[12,"Meeting the Scope of Work Required",null,"Eskom is having in place Windows Servers and MS SQL Database","Compliance to Eskom Environment","The list of the web and/or application server technologies and versions have already been provisioned. Will your solution be able to run on these environments?",null,"Important",{"$f":"IF(H20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":3},5.5555555555555552E-2,"100%: Yes\n\n0%:     No",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I20)","v":54},{"$f":"SUM(J9:J20)","v":1},null,null,{"$f":"SUM(M9:M20)","v":0}]

{"sheet":"Integration and Testing","index":6,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[6,11,6,13],[25,0,25,13],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3],[6,9,6,10]]}
[{"$f":"'Technical evaluation'!A1","v":"MyEskom Outage Mobile App"}]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Category","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","Non Functional","Previous involvement in the end to end testing of a similar system and methodologies used",null,"Testing ","Provide reference customers and sites",null,"Very important",{"$f":"IF(I9='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I9='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I9='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I9='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I9='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I9='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I9='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},{"$f":"J9/J$27","v":5.2631578947368418E-2},"100%: Fully comply with requirement\n50%:   Partially comply with requirement\n0%:     No compliance",0,{"$f":"K9*M9","v":0}]
[2,"Team Organisation and Member Requirements","Non Functional","Resource model. It is a requirement that sufficient dedicated testers are allocated to the project, independent of the development team",null,"Testing ","Experienced Test Manger must be provided, ISTQB certification is required for all testing resources",null,"Very important",{"$f":"IF(I10='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I10='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I10='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I10='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I10='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I10='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I10='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Good Experience with certification\n50%: Some experience without certification\n0%: No experience, No certification\n",0,{"$f":"K10*M10","v":0}]
[3,"Meeting the Scope of Work Required","Non Functional","Resource Experience with Eskom's Testing tools",null,"Testing ","Must be HP ALM, UFT and Load Runner ",null,"Very important",{"$f":"IF(I11='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I11='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I11='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I11='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I11='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I11='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I11='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Good Experience with certification\n50%: Some experience without certification\n0%: No experience, No certification\n",0,0]
[4,"Meeting the Scope of Work Required","Non Functional","Your testing approach specific to the project (  Agile/Waterfall etc.)",null,"Testing ","Tenderer must provide detailed approach",null,"Very important",{"$f":"IF(I12='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I12='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I12='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I12='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I12='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I12='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I12='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Complete approach provided\n50%:  Partial approach provided\n0%:  No approach provided\n",0,0]
[5,"Meeting the Scope of Work Required","Non Functional","Solid Testing capability (reference projects & sites and methodologies used)",null,"Testing ","Resource model. It is a requirement that vendors have sufficient dedicated testers allocated to the project independent of the development team. When required the testing resources might be required to be on site and all Covid-19 regulations to be observed.",null,"Very important",{"$f":"IF(I13='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I13='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I13='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I13='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I13='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I13='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I13='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Complete approach provided\n50%:  Partial approach provided\n0%:  No approach provided\n",0,0]
[6,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of Oracle Fusion integration solutions in an enterprise",null,"Integration","Please provide reference projects & sites and pattern your previous experience covers",null,"Show stopper",{"$f":"IF(I14='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I14='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I14='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I14='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I14='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I14='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I14='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},7.8947368421052627E-2,"100%: Experience in Oracle Fusion Implementation\n0%: No experience in Oracle Fusion",0]
[7,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation  of DataPower integration solutions in an enterprise",null,"Integration","Please provide reference projects & sites and pattern your previous experience covers",null,"Show stopper",{"$f":"IF(I15='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I15='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I15='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I15='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I15='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I15='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I15='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},7.8947368421052627E-2,"100%: Good Experience in Data Power Implementation\n0%: No experience in Data Power Implementation",0]
[8,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications for Oracle Fusion 12C ",null,"Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?",null,"Very important",{"$f":"IF(I16='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I16='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I16='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I16='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I16='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I16='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I16='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",0]
[9,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications IBM Data Power",null,"Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?",null,"Very important",{"$f":"IF(I17='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I17='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I17='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I17='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I17='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I17='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I17='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",0]
[10,"Meeting the Scope of Work Required","Non Functional","Previous experence in carrying out analysis, design, development, testing and deployment of  Datapower integration services",null,"Integration","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions. Provide references",null,"Show stopper",{"$f":"IF(I18='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I18='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I18='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I18='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I18='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I18='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I18='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},7.8947368421052627E-2,"100%: Experience in  analysis, design, development, testing and deployment of Data Power\n0%: No experience",0]
[11,"Meeting the Scope of Work Required","Non Functional","Previous experence in carrying out analysis, design, development, testing and deployment of Oracle Fusion integration services\n\n\n",null,"Integration","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions. Provide references",null,"Show stopper",{"$f":"IF(I19='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I19='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I19='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I19='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I19='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I19='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I19='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":6},7.8947368421052627E-2,"100%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion\n0%: No experience",0]
[12,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation  of Oracle Fusion and DataPower integration solutions at enterprise level is required. Please provide references on experience by  the tenderer for both technologies. Tenderer must provide proof that their product has the ability to expose business services to enable integration capabilities. Evidence required - Provide name(s) of the companies where the solution was implemented together with contact persons & details.",null,"Integration","Provide proof that you have implemented a solution where the following items were delivered: analysis, design, develop, test and deploy integration solutions. Provide references",null,"Very important",{"$f":"IF(I20='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I20='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I20='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I20='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I20='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I20='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I20='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion and Data Power\n50%: Experience in  analysis, design, development, testing and deployment of Oracle Fusion or Data Power\n0%: No experience",0]
[13,"Meeting the Scope of Work Required","Non Functional","What is the structure of the message? Is it a proprietary file, is it in a Database? If this information is PUSHED by Source, can the Source send to Integration a Common Information Message (CIM) or they can only send a proprietory message structure? (Proprietory – Applications own business service message structure)",null,"Integration","Provide the capability of the Application",null,"Very important",{"$f":"IF(I21='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I21='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I21='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I21='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I21='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I21='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I21='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%:Source can send a Common information message (CIM) structure\n50%: The Source can send only a proprietary message structure\n0%: Neither",0,0]
[14,"Meeting the Scope of Work Required","Non Functional","What type of channel security does Source Application support, i.e. One-Way or Two-Way certificate (SSL/TLS) to secure the channel?",null,"Integration","Provide the security capability",null,"Very important",{"$f":"IF(I22='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I22='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I22='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I22='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I22='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I22='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I22='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%:Source Supports a secure channel of communication\n0%: Source supports no secure channel of communicaiton",0,0]
[15,"Meeting the Scope of Work Required","Non Functional","What type of authentication security does Source support, i.e. Basic Authentication for Web Services, Database or SFTP?",null,"Integration","Provide the Authentication capability",null,"Very important",{"$f":"IF(I23='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I23='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I23='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I23='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I23='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I23='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I23='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%:Source can apply Basic Authentication for Web Services, Database and SFTP\n50%: The Source can only apply Basic Suthentication on Database or SFTP\n0%: Neither",0,0]
[16,"Meeting the Scope of Work Required","Non Functional","Can Integration reply to the Source Application with a full service response (pre-defined message structure) in case Source Application is invoking an Integration Web Service or the Source can only handle HTTP/SOAP responses?",null,"Integration","Provide the Basic Authentication capability",null,"Very important",{"$f":"IF(I24='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I24='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I24='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I24='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I24='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I24='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I24='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%:Source can accept full service response\n50%: The Source can accept HTTP/SOAP response\n0%: Neither",0,0]
[17,"Meeting the Scope of Work Required","Non Functional","Is the Source Application capable of retrying a message if there are connection errors in Integration or Target and they have received a service response or HTTP response?\nSource Application can distinguish between Technical and Business error, and handle each one in a seperate manor\n IF Database, Have a separate column in the table where errors can be written, and column for a flag (Successful, technical error, business error)",null,"Integration","Provide The Retry capability",null,"Very important",{"$f":"IF(I25='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(I25='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(I25='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(I25='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(I25='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(I25='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(I25='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},5.2631578947368418E-2,"100%:Source can handles Technical and Business error seperately and can cater for separate columns in the Database for errors and a flag\n50%: The Source handles Technical and Business errors in one manor or can only cater for the Database flag or comments field\n0%: The Source cannot cater for any re-tries",0,0]
[]
[null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(J9:J25)","v":76},{"$f":"SUM(K9:K25)","v":0.99999999999999978},null,null,{"$f":"SUM(N9:N25)","v":0}]

{"sheet":"Demonstration","index":7,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":true,"merged":[[6,10,6,12],[74,0,74,12],[0,0,0,2],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,2],[6,8,6,9]]}
[{"$f":"'Technical evaluation'!A1","v":"MyEskom Outage Mobile App"}]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[null,null,null,null,null,null,null,null,"Weight\n(agreed by evaluation team members)",null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)"]
["ID","Type","Criterion","Solution","Functional Requirement","Requirement description","Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer"]
[1,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","• Support of cloud\nStandAlone or cloud solution","Provide solution details indicating whether the solution can be deployed as a standalone or via the cloud\n",null,"Very important",4,{"$f":"I9/I$76","v":1.4492753623188406E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Capability to support customer journey's / service types in conjunction with AI (Chatbot)","Solution capabilities support use cases/Customer jouneys are per Customer journey/service types submitted as attachment. \nThe Customer service interactions (use cases) are categorised by types (Supporting attachment called “Customer Services: Service categories and types”) that are handled by the contact center. \nThe following are the high priorities: \n a. Electricity Supply Problem (high priority) \n   i. receive feedback on faults reported (I,e, using a ref number)\n   ii. And progress feedback on faults a section item\n b. Submit Meter readings (high priority). \n  c. Refer to attachments for a complete list of ALL service \nd. Display reference number that has been generated by Eskom source systems.\ncategories\n  i. An important one can be data enrichment such as verification and  \n     updating of customer details such as telephone numbers etc.\nOff the shelf or customisation?",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[3,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Customer interface: "," Provide capability for client to develop the logic/features of the solution directly. This includes tuning of rules etc. /admin – \nAbility to easily configure WhatsApp profile.Provide flexibility to configure as required.\nWhatsApp welcome greeting. This will be determined by business and the solution should allow this configuration to be flexible and allow the client to perform this configuration using simple GUI.",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[4,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Development platform \nUser / Self-configurable option with a simple GUI Interface","Provision of a UI environment preferred. Low code or no code. Provision of a graphical User Interface to develop the BOT. User is able to make configurations/changes etc without coding experience / drag and drop (add fields etc)\nAbility to configure and provide an Auto respond with a message/s i.e. “We have received your chat…..”. This should also be a self-configurable option with a simple GUI Interface. -",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[5,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Solution availability on different platforms","The solution should be available on mobile and web browser (e.g. as an application), Application for Desktop & Mobile platforms. Minimum OS Android and IOS supported . \nAt least Internet Explorer /Edge, Mozilla, Chrome and Safari",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[6,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Solution availability on different platforms","Management, Administration, Support of modern browsers - Edge, Mozilla etc.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[7,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Carry incoming/outgoing transactions  ","Indicate the social media channel API ability to carry incoming/outgoing transactions  \nPerformance:\nCapability to handle 20 000 messages per day. Also indicate concurrent capability.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[8,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Message relay ","read and write to social media channels for text, media, web hooks, message templates, SMS / Rich Communication Service support etc.",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[9,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Security - Provision of secure environment and protection of data","Needs to comply with the POPI act. Business is dealing with personal information.\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[10,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security - Data encryption","Data to be encrypted – end to end. Must be pass through to the routing engine. Prior to routing engine. Post API.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[11,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Security ","Setup and use HTTPS endpoints.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[12,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Dashboard Console ","Dashboard Console to monitor and alert on API health / activity.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[13,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Input capabilitues inclusive. \nIndicate what types of content are supported i.e. pdf, jpg etc.\n","Provision of additional input classes \n* Vocie and Text ",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[14,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Load volumes and Scalability for growth","Indicate the solution capabilities regarding the load/volumes i.e. physical number of messages and size of messages \nScalability: Flexibility to allow for future growth. Growth is expected – possibly a selection of the full customer base responding to AI related channels (Residential customers = 7 mil+/100K concurrency) \n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[15,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to handover to human or other channels","\nSafety and other sensitive interactions should be routed / directed according to Business process. i.e Handled by Human agent. ",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[16,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to develop / Modify standard templates to guide user interaction  based on current Case based reasoning","Predefined templates that can be configured. Vendors template flexibility to allow structured questions for case based reasoning. Development according to Eskom requirements. Allow for changes down the line. The ease in changing templates for Eskom requirements. Drag n drop preferrance.Customer interactions will be guided and provided via templates, this should allow for the customer to choose and provide enough information to classify/process the request. This is more structured. This follows the case based reasoning. ALLOW FOR STRUCTURED (Different levels as well) CHANGES TO BE IMPLEMENTED. Scoring (80-90% User configurable -100%, 60-80% User configurable - 50%, < - 0%)\nMore discussion to resolve.",null,"Very important",4,1.4492753623188406E-2,"100%: 80-90% User configurable\n50%:   60-80% User configurable\n0%:     No compliance",null,{"$f":"J24*L24","v":0}]
[17,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Ability to develop structured interactions to to obtain and interrogate data easily ","Platform capability to function with organisation's current and future case base reasoning structure. Information/data from interactions should be structured in an intelligent format, using i.e.  /root cause tree, drop down boxes etc. to receive data in format that can be interrogated. ",null,"critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[18,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Automated interactions applicable","The Chatbot will power the WhatsApp channel resulting in an automated interaction. Therefore the vendor should indicate how much can be automated from start to end of the process. \nScoring- with regards to what is currently automated-100%)",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[19,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Inclusive list of supported languages","Language support. English is the primary language. Provide an inclusive list of what official South African languages are supported. \nMulti-language translation will be more applicable to conversational bots.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[20,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Non-Latin characters support"," Support for non-Latin characters i.e. Cyrillic script - Customers not using standard characters / emojis etc.. How dow the platform support / filter / handle these characters. Not only alphabetical but also symbols. What hac been tested. Applies to free text",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[21,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Filtering capability","Indicate the Filtering capability – i.e. only take numbers from South Africa. Prevent DOS Attack etc. This will provide the capability to route an interaction from a VIP to Key customer etc.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[22,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Performance - Response times","o Indicate how fast the solution is. \no Down and uptime. \n* Capability of performing technical analysis - when the back end apps experiencing increased load. How does the platform handle this. Notifications/alerts. End to end. Having multiple queues / seperate from other customers. Other organisations customers handled seperately.\nResponse times required – Responds needs to be quicker than email, SMS especially since this is using an automated process i.e. Chatbot. Responses should be within seconds. “Chatlike”.\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[23,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Performance - Availability and scaling","High Availability to support 24/7 operations. Impacts Eskom image. DR and failover.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[24,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Broadcast capabilty"," Indicate the type of broadcast capability. One-to-many broadcast capability. Customer groups for communication via the social media channel API will be configured by internal source systems. Solution should provide capability and configuration to allow this. \no broadcasts /Campaigns /notifications /Alerts /Markketing/Surveys\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J32*L32","v":0}]
[25,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Creation and Management of groups.","Ability to port/import files with customers/contact details and communicate. Ability to create groups. Ability to alow ad-hoc communication.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J33*L33","v":0}]
[26,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Reporting - ","Management of the support process (1st line and 2nd line)\no Performance monitoring reporting which is the same as that done on an existing  agent/channel\no How many queries (customer journeys) handled per type.\no The time to resolve\no Repeat calls that started at the WhatsApp and went to other channels\nwhat higer level escalation is provided to report/handle the service side (Platform)\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J34*L34","v":0}]
[27,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Auditing","Indicate the audit controls- show a chain of message custody. Prove that the transaction was conducted end to end. No interception.\n",null,"critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J35*L35","v":0}]
[28,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Training","Training to be documented and performed in English as a minimum",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[29,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Social Media API","Integration"," The social media channel API should integrate with a Chatbot - and the chatbot must be able to consume the preprogrammed  questions and answers and be intelligent to discover answers.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[30,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Integration","Scheduled Activity\nBot initiates conversation-\nie Does the Bot have he capability to initiate transaction on a predertimed date/time \nie Outbound campaigns",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[31,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Interaction","Human to bot interaction - \nBasic level Customer interaction with bot, also Handoffs etc.",null,"critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[32,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Interaction","Multi-Channel - multiple social media channels and other multimenia channels",null,"critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[33,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Intelligence","Should respond in keystroke-type (Text) and / or natural talk language (voice) outputs -",null,"Critical",5,1.8115942028985508E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[34,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Community Support\nNeed assistance from development community. To resolve similar problems.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[35,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","3rd Party Support\nWhat technology will they use. Will they support this technology. Looking outside for assistance. Provide alternatives for resolution of issues.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[36,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Error Handling\nLevel of error handling: Exception  handling at code level and descriptive errror messages interpretation ",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[37,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Support of Flow Chart Approach",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[38,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot","Development","Vendor Support\nProduct supplied/implemented supported by one/multiple vendors\nStandard vanilla or modified solutions.\ni.e. If components belong to other vendors ie Microdoft, manage the support,relationship with vendors/",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J46*L46","v":0}]
[39,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Data migration / Import and export of data","Will it be possible to easily migrate all data, in an agreed format, to a new system should  a replacement solution be required in future?\nBusiness continuity impact.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J47*L47","v":0}]
[40,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Chatbot and Social Media API","Implementation ","Provide a high level architecture for the proposed solution by referriing to the business, informtion, data, application, security and technology components. According to Current Eskom Architecture patterns.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[41,"Meeting the Scope of Work Required","Are the list of all roles in the project team provided?  Are there perceived missing roles (Provide comments)?  Provided a project resource model.","Chatbot and Social Media API","Non Functional / Administration","Roles: Internal administration and Customers.\nCan different user roles be created. Describe the user roles that can be defined in the solution. For the support team use.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[42,"Meeting the Scope of Work Required","Are the list of all roles in the project team provided?  Are there perceived missing roles (Provide comments)?  Provided a project resource model.","Chatbot and Social Media API","Non Functional / Administration","Is it possible in the solution for power users must be enabled to make minor configuration changes , e.g. updating lookup lists, field visibility, screen layout, queries/reports, business rules, workflows etc. without depending on IT staff.ie Make announcements, update catalogue items etc.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[43,"Meeting the Scope of Work Required","Compatibility Certificate from Microsoft AD or Azure","Social Media API","Information Security","Technical Support Team\nAccess Control and User Account Management \nDoes your Proposed Solution comply and is Compatible with Microsoft Active Directory,Azure, SAML2, OAUTH",null,"Very important",4,{"$f":"I51/I$76","v":1.4492753623188406E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[44,"Meeting the Scope of Work Required","Certificate from the OEM or Reputable Authority ","Chatbot and Social Media API","Information Security","Information Security Threat Management \n\nPlease advise to what extend is your Solution Compatible \n1. Malware\n2. Cyber Attack\n3. Anti-Virus\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[45,"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","Social Media API","Information Security","User and System to System Authentication \n\nWhat Authentication Tools or Model will be deployed as part of the proposed solution, this should include compatibility with Java Authentication and Authorisation Service (JAAS), LDAP, OASIS SAML v2.0, Open SSO TLS and WSS, OAUTH.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[46,"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","Chatbot and Social Media API","Information Security","End to end encryption of messages at rest and transit. Logs etc.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[47,"Meeting the Scope of Work Required","Network Security and 3rd Party Access","Chatbot and Social Media API","Network Deployment","How would the proposed solution protect Data and Facilitate 3rd Party Access, please specify the tools if any \nAlso for provision of support.\nHow is the access to the data managed.Manage access to backend systems to address possible access to information to unauthorised people.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[48,"Meeting the Scope of Work Required","Near realtime response times below 3 seconds, network performance certificate as proof. ","Chatbot and Social Media API","Network Deployment","Network Optimizing \n\nPlease advise how the Network will be optimised to cater for the near real time transaction performance. Please advise on the Network shaping tools you will deploy (if any) and performance of the solution over the cloud network.\nWhat monitoring provided outside of Eskom network",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[49,"Meeting the Scope of Work Required","Business Continuity ","Social Media API","Mintenance/ Availability","Provide a message queing strategy for all trafic bound to Eskom internal services in case of Eskom internal backend issues.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[50,"Meeting the Scope of Work Required","End Point Devices access","Chatbot","Core Infrastructure","If this Solution is to be accessed by the End Point Devices(i.e. Laptops and Desktops), please advise if the Solution is accessable  via the Approved minimum Internet Browser(s) . Indicate the technologies available.",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[51,"Meeting the Scope of Work Required","Previous involvement in the end to end testing of a similar system and methodologies used)","Chatbot and Social Media API","Testing ","Provide reference customers and sites",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[52,"Team Organisation and Member Requirements","Resource model. It is a requirement that sufficient dedicated testers are allocated the project, independent of the development team","Chatbot and Social Media API","Testing ","Experienced Test Manger must be provided, ISTQB certification is required for all testing resources",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[53,"Meeting the Scope of Work Required","Resource Experience with Eskoms Testing tools","Chatbot and Social Media API","Testing ","Must be HP ALM, UFT and Load Runner ",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[54,"Meeting the Scope of Work Required","Your testing approach specific to the project. (  Agile/Waterfall) etc..","Chatbot and Social Media API","Testing ","Tenderer must provide approach",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[55,"Meeting the Scope of Work Required","Solid Testing capability (reference projects & sites and methodologies used)","Chatbot and Social Media API","Testing ","Provide reference customers and sites\n\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[56,"Team Organisation and Member Requirements","Solid Testing capability (reference projects & sites and methodologies used)","Chatbot and Social Media API","Testing ","Resource model. It is a requirement that vendor have sufficient dedicated testers allocated to the project independent of the development team. Resources to be based on Eskom premises for the testing related activities of project. ",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[57,"Meeting the Scope of Work Required","Previous experience in implementation of Oracle Fusion and Datapower integration solutions in a enterprise (reference projects & sites and pattern)","Chatbot and Social Media API","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[58,"Meeting the Scope of Work Required","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","Chatbot and Social Media API","Integration","Tenderer must provide references, sites and patterns or Previous Experience",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[59,"Meeting the Scope of Work Required","Intergration - to backend systems to address querries","Chatbot","Integration","The Chatbot solution should be able to access existing / new databases or integrate to applications for purposes of actioning or addressing queries via the defined intergration technology.\n(Applications i.e. Work Force Management, Billing, CRM, OMS – (PowerOn Advantage), verification of contact details etc.\n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[60,"Meeting the Scope of Work Required","Does the Supplier’s compliance with copyright laws and other applicable intellectual property rights restrict the type of content ESKOM can store with the cloud service?","Chatbot and Social Media API","DATA OWNERSHIP AND USE"," Data ownership and use Compliance document",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[61,"Meeting the Scope of Work Required","Does ESKOM gain ownership of metadata generated by the cloud service system during procedures of upload, management, download, and migration?","Chatbot and Social Media API","DATA OWNERSHIP AND USE","Metadata ownership \n",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[62,"Meeting the Scope of Work Required","Provide specific indicators for Eskom access\n* 24x7 support\n* alerts\n* Monitor\n* web page to view avialability of service\n* Heirachical view\netc. ","Chatbot and Social Media API","AVAILABILITY, RETRIEVAL AND USE","Methods to provide precise indicators regarding the availability of the service?",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[63,"Meeting the Scope of Work Required","Is this covering data on their cloud/site. Will our customers have the right level of access to their data. \nWhere is the data stored.\nAlso storage and archiving. Including NERSA / Legal requirements.","Chatbot and Social Media API","AVAILABILITY, RETRIEVAL AND USE","Customer use\nDoes the degree of availability of the data allow ESKOM to comply with the right of persons to access their own personal information?",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[64,"Meeting the Scope of Work Required","Is this covering data on their cloud/site. Will Eskom  have the right level of access to data. \nWhere is the data stored.\nAlso storage and archiving. Including NERSA / Legal requirements.","Chatbot and Social Media API","AVAILABILITY, RETRIEVAL AND USE","Internal use / Support\nDoes the degree of availability of the data allow ESKOM to comply with the right of authorities to legally access ESKOM data for investigation, audit, control or judicial purposes?",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[65,"Meeting the Scope of Work Required","Data Storage\nDowntime from Eskom side. Source Biling systems down?\nIf chats are backed up, then their will be customer data. Even in the verification process, there will be some customer data transferred. Kept by 3rd party.\nProvide details of backups. How long is it kept. . Process for destroying data.\nIs ESKOM clearly informed about the procedure and conditions for the destruction of ESKOM data?","Chatbot and Social Media API","DATA STORAGE AND PRESERVATION","If ESKOM organization manages external records (e.g. customer data), does the Supplier create backups of ESKOM customer’s data?",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[66,"Meeting the Scope of Work Required","Does the system provide and give Eskom access to audit trails, metadata and/or access logs to demonstrate security measures?  ","Chatbot and Social Media API","SECURITY, CONFIDENTIALITY AND PRIVACY","Security",null,"Very important",4,1.4492753623188406E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I74)","v":276},{"$f":"SUM(J9:J74)","v":0.99999999999999867},null,null,{"$f":"SUM(M9:M74)","v":0}]

{"sheet":"Priority Ratings","index":8,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Priority rating","Priority Description",null,"Score Ratings","Score Description"]
[null,0,"No interest",null,0,"0% Compliance"]
[null,1,"Nice to have",null,0.25,"25% Compliance"]
[null,2,"Useful",null,0.5,"50% Compliance"]
[null,3,"Important",null,0.75,"75% Compliance"]
[null,4,"Very important",null,1,"100% Compliance"]
[null,5,"Critical"]
[null,6,"Show stopper"]

{"sheet":"Config","index":9,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Solution",null,"Priority rating","Priority Description",null,"Category"]
[null,"Outage Mobile App",null,0,"No interest",null,"Functional"]
[null,null,null,1,"Nice to have",null,"Technical Evaluation"]
[null,null,null,2,"Useful",null,"Integration and Testing"]
[null,null,null,3,"Important"]
[null,null,null,4,"Very important"]
[null,null,null,5,"Critical"]
[null,null,null,6,"Show stopper"]

{"sheet":"Concerns and Recommendations","index":10,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,1,2,2],[3,1,16,14],[18,1,18,2],[19,1,33,14]]}
["Note: Not applicable for the vendors / Tenderers / respondents. This sheet is not needed for issuing the Tendor. Useful for making recommendatins after evaluation."]
[]
[null,"Recommendation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Concerns"]