{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","Functional","Technical","Security","Integration and Testing","Cloud","Priority Ratings","Config","Concerns and Recommendations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"Summary","index":0,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,5,22,5],[23,1,23,4],[7,0,7,4],[17,1,17,2],[18,0,22,0],[18,4,22,4]]}
["ERI Configuration Management System"]
[]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria"]
[]
["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.\" "]
[]
[]
[]
[null,null,null,null,"Paper Evaluation (100%)"]
[null,"Weighting",null,"Total","Paper Evaulation ","Final Score"]
["Paper evaulation","Functional",0.4,{"$f":"C19*B34","v":0},{"$f":"(D19+D20+D21+D22+D23)","v":0},{"$f":"E19","v":0}]
[null,"Technical",0.15,{"$f":"C20*B35","v":0}]
[null,"Security",0.15,{"$f":"C21*B36","v":0}]
[null,"Integration & Testing",0.15,{"$f":"C22*B37","v":0}]
[null,"Cloud",0.15,{"$f":"C23*B38","v":0}]
[null,"Paper Evaluation (100%) Score",null,null,null,{"$f":"SUM(D19:D23)","v":0}]
[]
["PLEASE NOTE:"]
["Functional weighting is highest at 40%, and the rest of the sections 15%"]
["The threshold for the Final score (Paper Evaluation) is 70% (Cell F24)"]
["The Paper Evaluation makes up 100% of the Final Score"]
[]
["Evaluation on Weighted Criteria"]
[]
["Evaluation on Weighted Criteria"]
["Sum of Weighted Question (Functional)",{"$f":"Functional!M23","v":0}]
["Sum of Weighted Question (Technical)",{"$f":"Technical!M14","v":0}]
["Sum of Weighted Question (Security)",{"$f":"Security!M21","v":0}]
["Sum of Weighted Question (Integration and testing)",{"$f":"'Integration and Testing'!M26","v":0}]
["Sum of Weighted Question (Cloud)",{"$f":"Cloud!M37","v":0}]

{"sheet":"Functional","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,10,6,12],[21,0,21,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!A1","v":"ERI Configuration Management System"}]
["CORP xxxx Tender"]
["Tenderer:"]
["Evaluated by:"]
[]
["Evaluation Criteria - Functional "]
[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","Vendor Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer","Internal\nComment"]
[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.","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","Register components in the system upon arrival at work centres","Ability to create component identity by: \n1.Scanning the marked components into the system\n (Secondary requirement to procure handheld devices) or\n2.Allow manual entry into the system by an authorized person\n3.Ability for all Eskom employees to view all technical information pertaining to the registered components\n4.Ability to track components as they move through the refurbishment life cycle",null,"Show stopper",{"$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":6},{"$f":"I9/I$23","v":8.5714285714285715E-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.","ERI Configuration Management System","Register components in the system upon arrival at work centres","The Component technical information must be captured according to the following metadata structure:\n1.\tPlant \n2.\tUnit \n3.\tTechnology\n4.\tService Report (Service Report number)\n              a.\tMonitoring Documentation (Vibration Analysis)\n              b.\tModule Assembly (HP,IP, LP, Gen etc.)\n              c.\tComponent ( Blades, Diaphragms etc.)     \n                          i.\t Project Number\n                          ii. WBS Elements\n                          iii. PQP\n                          iv. Engineering Project Number\n                          v. Engineering Drawings\n                          vi. Serial number",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},8.5714285714285715E-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.","ERI Configuration Management System","Previous Experience","Tenderer or via joint venture partner does have prior or past experience in implemention of a Configuration Management System. ",null,"Show stopper",{"$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":6},8.5714285714285715E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J11*L11","v":0}]
[4,"Meeting the Scope of Work Required","How well has the Tenderer described how scope requirements will be met?  Do they understand what needs to be done?  List concerns in Comments.","ERI Configuration Management System","Production Quality Package (PQP’s)","1.\tAbility to develop and print PQP’s directly in the system\n2.\tAbility to electronically capture PQP results of a specific refurbishment step on the system\n          2.1 Electronic identification of operator must be enabled\n3.\tPQP’s must be automatically saved on the system when the operator submits the results.                                                                                                                     4.\tThe system must be able to link to different Document Management Systems to access relevant procedures and documents.                                                                                                                        5. The system should be able to get information from the following sytems SAP (PS, PP, SD & MM) and Primavera\n6. PQP's to be linked with all Quality documentation and procedures. \n7. Standard generic Scope of Work (SOW) with Bill of Material (BOM) stored in a centralized data management system. SOW needs to cover all possible work that may be completed on the specific component. All BOM, check sheets and PQP’s need to be derived from the selected SOW’s. Project duration for specific SOW must also be derived based on the selection.\n8. Electronic check sheet and PQP’s at point of use (control points) during the refurbishment phase (Control points will be the identified at work centres). The supplier must assist in developing and implementing all digitalized Quality Control documentation.  \n9. All Quality documentation must be completed and verified electronically with electronic signatures.\n10. Only certified and qualified employees may be allowed to execute and certify quality documentation.  ",null,"Show stopper",{"$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":6},8.5714285714285715E-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.","ERI Configuration Management System","Revision Control","Ability for the system to record all changes/updates made to components captured in the system.\nThe system must have a fully functional documentation management system with workflows associated. ",null,"Show stopper",{"$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":6},8.5714285714285715E-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.","ERI Configuration Management System","Component Design Drawings","Ability to view the below listed file formats available on Solidworks\nThe system must support the below listed file formats: \n\nThe file types available from SolidWorks are:\n•\tSOLIDWORKS Assembly (.asm; .sldasm)\n•\tSOLIDWORKS Composer (.smg)\n•\tSOLIDWORKS Part (.prt; .sldprt)\n•\t3D Manufacturing Format (.3mf)\n•\t3D XML (.3dxml)\n•\tACIS (.sat)\n•\tAdditive Manufacturing File (.amf)\n•\tAdobe Illustrator File (.ai)\n•\tAdobe Photoshop Files (.psd)\n•\tAdobe Portable Document Format (.pdf)\n•\tAssembly Templates (.asmdot)\n•\tCATIA Graphics (.cgr)\n•\teDrawings (.easm)\n•\tHCG (.hcg)\n•\tHOOPS HSF (.hsf)\n•\tIFC 2x3 (.ifc)\n•\tIFC 4 (.ifc)\n•\tIGES (.igs)\n•\tJPEG (.jpg)\n•\tMicrosoft XAML (.xaml)\n•\tParasolid (.x_t; .x_b)\n•\tPolygon File Format (.ply)\n•\tPortable Network Graphics (.asm)\n•\tSTEP (.step; .stp)\n•\tSTL (.stl)\n•\tTif (.tif)\n•\tVRLM (.wrl)",null,"Show stopper",{"$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":6},8.5714285714285715E-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.","ERI Configuration Management System","Information flow through integration between the Configuration Management Solution and following systems:\nSAP PM, SAP PP, SAP QIM, SAP PS, Solidworks, NDT Manager, OpenText DMS.","Work order data, Project Schedule Data, Issue and Incident Management Data, Design Drawings, Inspection Data, Worflow and Routing Data , ",null,"Show stopper",{"$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":6},8.5714285714285715E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J15*L15","v":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.","ERI Configuration Management System","Reporting","••\tAbility to graphically view below reports using analytic capabilities\n\n•\tAnalytics capability- work centres\n\tNon-Destructive Testing (NDT) report\n•\tNon-conformance reports\n•\tProduction output reports\n•\tElectrical reports\n•\tService Report\n•\tPQP (Part 1-4)\n•\tEngineering Memo’s\n•\tInspection Report\n•\tNDE Reports                                                                                                                                                                                                                                                                                                     •\tTechnical Notifications                                                                                                                                                                                                                                                                                   •\tSOW                                                                                                                                                                                                                                                                                                                       •\tChecksheets\n•\tWork in Progress reporting \n•\tWorkload distribution reporting\n•\tAbility to use digital footage for progress update on projects\n•\tSystem must be able to produce a digital twin of the specific unit operating in the power station with all linked technical information for that unit. ",null,"Show stopper",{"$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":6},8.5714285714285715E-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.","ERI Configuration Management System","Nonconformance Management","•\tIdentification, reporting and management of nonconformances. ",null,"Very important",4,{"$f":"I17/I$23","v":5.7142857142857141E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[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.","ERI Configuration Management System","CNC Machine integration ","•\tIntegration with CNC machines for program management and automating the logging of measurements at Workshops and Sites.",null,"Very important",4,5.7142857142857141E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[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.","ERI Configuration Management System","Document Management and Data Storage","•\tCentralised Configuration Management Database with documentation management and workflow capabilities for document management and long-term storage.\n•\tThe system must have the capability to workflow and manage all Microsoft Office file formats as well as PDF’s.\n•\tOpenText is currently listed as the Document Management System. Data to be preferably on OpenText. \n\n",null,"Show stopper",6,8.5714285714285715E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[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.","ERI Configuration Management System","Allocation of tasks ","·         Allocate specific tasks with product deliverables and integrate with execution plan. ",null,"Very important",4,5.7142857142857141E-2,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance"]
[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.","ERI Configuration Management System","Workflow","System needs to have workflow functionality that will include:\n•\tNotifications – Email communication via Exchange Online\n•\tEscalations to higher level after set time as per procedure \n•\tApprovals/ Rejections \n•\tAcceptance\n•\tSolution must allow communication with external stakeholders",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},{"$f":"I21/I$23","v":5.7142857142857141E-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:I21)","v":70},{"$f":"SUM(J9:J21)","v":1.0000000000000002},null,null,{"$f":"SUM(M9:M21)","v":0}]

{"sheet":"Technical","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,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]]}
["ERI Configuration Management System"]
["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","Functional Requirement","Requirement description","Vendor Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer","Internal\nComment"]
[1,"Meeting the Scope of Work Required","ERI Configuration Management System","Compatibility Certificate from Microsoft Azure","Information Security","Technical Support Team\nAccess Control and User Account Management \nDoes your Proposed Solution comply and is Compatible with Microsoft Azure, OAUTH2",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$14","v":0.35714285714285715},"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","ERI Configuration Management System","Compatability Certificate from Microsoft Edge  and FireFox ","Information Security","Browser Accessability\nPlease advise if Solution is compatible with:\n1. Microsoft Edge\n2. Firefox\n3. SAP system\n4. Primavera",null,"Important",{"$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":3},{"$f":"I10/I$14","v":0.21428571428571427},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[3,"Meeting the Scope of Work Required","ERI Configuration Management System","Network Printing","Network ","Network Printing\nPlease advise if the Solution allows network printing",null,"Useful",{"$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":2},{"$f":"I11/I$14","v":0.14285714285714285},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[4,"Meeting the Scope of Work Required","ERI Configuration Management System","Scanning","Handheld scanning","Ability to connect wirelessly to the Handheld scanners.\n",null,"Very important",{"$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":4},{"$f":"I12/I$14","v":0.2857142857142857},"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:I12)","v":14},{"$f":"SUM(J9:J12)","v":0.99999999999999989},null,null,{"$f":"SUM(M9:M12)","v":0}]

{"sheet":"Security","index":3,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,10,6,12],[19,0,19,12],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3],[6,8,6,9]]}
["ERI Configuration Management System"]
["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","Functional Requirement","Requirement description","Vendor Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer","Internal\nComment"]
[1,"Meeting the Scope of Work Required","ERI Configuration Management System","Compatibility Authentication Mechanism/s\nSubstantiate by providing details of standards that are supported","Information Security","Authentication for the following Categories:\n* Technical Support Team\n* User\n* System\n\nAccess Control and User Account Management\nDoes your Proposed Solution comply and is Compatible with Microsoft Active Directory, AD Azure, SAML2, OAuth2 and/or LDAPv3, MFA ?",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$21","v":8.5106382978723402E-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","ERI Configuration Management System","Certificate from the OEM or Reputable Authority ","Information Security","Information Security Threat Management\nPlease advise to what extend is your Solution Compatible with each of below:\n1. Malware\n2. Cyber Attack\n3. Anti-Virus",null,"Very important",{"$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":4},{"$f":"I10/I$21","v":8.5106382978723402E-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","ERI Configuration Management System","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","E2E Encryption\nEncryption of Data in transit and in Rest\nDoes your Proposed Solution comply and is compatible with the latest TLS and Cypher Standards to protect and encrypt data?",null,"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},0.10638297872340426,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[4,"Meeting the Scope of Work Required","ERI Configuration Management System","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","POPIA\nDoes your Proposed Solution take the POPIA requirements into consideration",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},0.10638297872340426,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[5,"Meeting the Scope of Work Required","ERI Configuration Management System","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security Confidentiality + Integrity and protection against Cyber Exploit ","Data Classification\nAll ICT Projects solutions in Eskom need to indicate a detail  Information Classification criteria matrix ( Controlled Disclosure, Confidential, Secret, Top Secret) to be indicated by Business and System owner and need to be visible for PM. Does your System Data align with, National Cyber Security Policy Framework as well as Critical Infrastructure Protection Act requirements to Secure data/information  againts Cyber Exploitation?",null,"Very important",{"$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":4},8.5106382978723402E-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","ERI Configuration Management System","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","Data Storage\nFor Cloud-based Off-Premise Solutions, do the respondents or via joint venture partner have the hosting datacenter within South African boarders?",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},0.10638297872340426,"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,0]
[7,"Meeting the Scope of Work Required","ERI Configuration Management System","Substantiate by providing details of standards that are supported and ensure that these Capabilities are detailed in the proposal","Information Security","SIEM Integration\nDoes your Proposed Solution provide a Feed for SIEM Integration using Standard Technologies? i.e. Syslog, Windows Events, etc.",null,"Very important",{"$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":4},8.5106382978723402E-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","ERI Configuration Management System","Cloud Data Standard\nBaseline security Control\n\nAccess to Cloud environment – access control to Cloud environments, as well as the ingress and egress movement of data, will be done using existing mechanisms and other complementary Cloud-specific mechanisms. Do not enable direct remote access to Cloud VMs from the Internet, but enforce the use of VPNs.","DATA SECURITY: Access & Connectivity","Can the solution be accessed via a Public: Web Portal",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},8.5106382978723402E-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","ERI Configuration Management System","What type of channel security does Source Application support, i.e. One-Way or Two-Way certificate (SSL/TLS) to secure the channel?","DATA SECURITY: Access & Connectivity - Integration","Provide the security capability",null,"Very 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":4},8.5106382978723402E-2,"100%:Source Supports a secure channel of communication\n0%: Source supports no secure channel of communicaiton",null,0]
[10,"Meeting the Scope of Work Required","ERI Configuration Management System","What type of authentication security does Source support, i.e. Basic Authentication for Web Services, Database or SFTP?","DATA SECURITY: Access & Connectivity - Integration","Provide the Authentication capability",null,"Very important",{"$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":4},8.5106382978723402E-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",null,0]
[11,"Meeting the Scope of Work Required","ERI Configuration Management System","Cloud Data Standard\nBaseline security Control\n\nAccess to Cloud environment – access control to Cloud environments, as well as the ingress and egress movement of data, will be done using existing mechanisms and other complementary Cloud-specific mechanisms. Do not enable direct remote access to Cloud VMs from the Internet, but enforce the use of VPNs.","DATA SECURITY: Access & Connectivity","Can the solution be accessed via a Public: Mobile App",null,"Very 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":4},8.5106382978723402E-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:I19)","v":47},{"$f":"SUM(J9:J19)","v":1},null,null,{"$f":"SUM(M9:M19)","v":0}]

{"sheet":"Integration and Testing","index":4,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,12],[6,10,6,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!A1","v":"ERI Configuration Management System"}]
["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","Vendor Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer","Internal\nComment"]
[1,"Meeting the Scope of Work Required","Integration to Microsoft Azure","ERI Configuration Management System","Integration","Microsoft Azure will be used authentication of users to gain access to the system.",null,"Show stopper",{"$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":6},{"$f":"I9/I$26","v":8.2191780821917804E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance\n",null,{"$f":"J9*L9","v":0}]
[2,"Meeting the Scope of Work Required","Integration to Microsoft Exchange Online","ERI Configuration Management System","Integration","Email notifications for escalations and approvals",null,"Important",{"$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":3},4.1095890410958902E-2,"100%: Good Experience with certification\n50%: Some exeperience without certification\n0%: No experience, No certification\n",null,{"$f":"J10*L10","v":0}]
[3,"Meeting the Scope of Work Required","Previous involvement in the end to end testing of a similar system and methodologies used)","ERI Configuration Management System","Testing","Provide names of the customer and brief description of your responsiblities with regards to testing",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%: Fully comply with requirement\n50%:   Partially comply(Names without description of the services)\n0%:     No compliance\n",null,0]
[4,"Meeting the Scope of Work Required","Resource model. It is a requirement that sufficient dedicated testers are allocated the project, independent of the development team","ERI Configuration Management System","Testing","The following experienced roles must be filled a:Test Manger, Test analyst ,Tester and  Perfomance tester. CV's must be submitted indicating the relevant experience ",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%:Experience with all roles\n50%: Exeperience with 2 roles\n0%:     No experience",null,0]
[5,"Meeting the Scope of Work Required","Resource Experience with Eskoms Testing tools","ERI Configuration Management System","Testing","Must be HP ALM, UFT and Load Runner ",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%: Experience with both tools\n50%: Exeperience with 1 tool\n0%: No experience\n",null,0]
[6,"Meeting the Scope of Work Required","Your testing approach specific to the project with refence to a methodology","ERI Configuration Management System","Testing","Tenderer must provide approach ",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%: Complete approach provided with reference to a methodology\n50%:  Approach provided with no reference to a methodology\n0%:  No approach provided",null,0]
[7,"Meeting the Scope of Work Required","Tenderer's proposed testing resources must have the required ISTQB(International Software Testing Qualifications Board) qualifications acrredited by SATQB(Southern African Software Testing Qualifications Board).  ","ERI Configuration Management System","Testing","CV's together with respective copies of acquired certificates.",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%: All roles with certifications\n50%:  2 Roles with certifications\n0%:  No certifications\n",null,0]
[8,"Meeting the Scope of Work Required","Previous experience in implementation of Oracle Fusion Integration solutions in a enterprise ","ERI Configuration Management System","Integration","Please provide reference projects & sites and pattern your previous experience covers",null,"Show stopper",{"$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":6},8.2191780821917804E-2,"100%: Good Experience in Data Power Implementation\n0%: No experience in Data Power Implementation",null,0]
[9,"Meeting the Scope of Work Required","Previous experience in implementation of Datapower integration solutions in a enterprise ","ERI Configuration Management System","Integration","Please provide reference projects & sites and pattern your previous experience covers",null,"Show stopper",{"$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":6},8.2191780821917804E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",null,0]
[10,"Meeting the Scope of Work Required","Team has the required certifications for Oracle Fusion 12C","ERI Configuration Management System","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(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":4},5.4794520547945202E-2,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",null,0]
[11,"Meeting the Scope of Work Required","Team has the required certifications IBM Data Power","ERI Configuration Management System","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(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":4},5.4794520547945202E-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",null,0]
[12,"Meeting the Scope of Work Required","Previous experence in carrying out analysis, design, development, testing and deployment of Oracle Fusion and Datapower integration services","ERI Configuration Management System","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(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":6},8.2191780821917804E-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",null,0]
[13,"Meeting the Scope of Work Required","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. ","ERI Configuration Management System","Integration","Provide name(s) of the companies where the solution was implemented together with contact persons & details.",null,"Show stopper",{"$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":6},8.2191780821917804E-2,"100%: Good Experience in both Technologies\n50%: Experience in one of the Technologies\n0%: No experience",null,0]
[14,"Meeting the Scope of Work Required","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)","ERI Configuration Management System","Integration","Provide the capability of the Application",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},{"$f":"I22/I$26","v":5.4794520547945202E-2},"100%:Source can send a Common information message (CIM) structure\n50%: The Source can send only a proprietary message structure\n0%: Neither",null,0]
[15,"Meeting the Scope of Work Required","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?","ERI Configuration Management System","Integration","Provide the Basic Authentication capability",null,"Very important",{"$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":4},5.4794520547945202E-2,"100%:Source can accept full service response\n50%: The Source can accept HTTP/SOAP response\n0%: Neither",null,0]
[16,"Meeting the Scope of Work Required","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)","ERI Configuration Management System","Integration","Provide The Retry capability",null,"Very important",{"$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":4},5.4794520547945202E-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",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I24)","v":73},{"$f":"SUM(J9:J24)","v":1},null,null,{"$f":"SUM(M9:M24)","v":0}]

{"sheet":"Cloud","index":5,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,0,35,12],[6,10,6,12],[0,0,0,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,3],[6,8,6,9]]}
["ERI Configuration Management  System"]
["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","Functional Requirement","Requirement description","Vendor Comments","Priority Description","Priority\n","Weighted Question","Scoring","Answer\n(0,50,100%)","Weighted Answer","Internal\nComment"]
[1,"Meeting the Scope of Work Required","ERI Configuration Management System","Cyber Attack","SECURITY, CONFIDENTIALITY AND PRIVACY","How will the vendor ensure  that ERI's  Data is protected from Cyber attacks?",null,"Show stopper",{"$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":6},{"$f":"I9/I$37","v":5.1724137931034482E-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","ERI Configuration Management System","System Availability","AVAILABILITY, RETRIEVAL AND USE","The tenderer's Cloud hosting data centre must be within the borders of South Africa.",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},{"$f":"I10/I$37","v":5.1724137931034482E-2},"100%: Fully comply with requirement\n50%:   Partially comply will require development/ customisation\n0%:     No compliance",null,{"$f":"J10*L10","v":0}]
[3,"Meeting the Scope of Work Required","ERI Configuration Management System","Support","AVAILABILITY, RETRIEVAL AND USE","Clear and concise SLA to be put in place",null,"Very important",{"$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":4},3.4482758620689655E-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","ERI Configuration Management System","Loss, Leakage or Unavailability of data","AVAILABILITY, RETRIEVAL AND USE","Ensure encryption of data in transit and at rest",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},4.3103448275862072E-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","ERI Configuration Management System","System Availability","AVAILABILITY, RETRIEVAL AND USE","Ensure redundancy at vendor site",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},4.3103448275862072E-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","ERI Configuration Management System","Storage and Archiving","DATA STORAGE AND PRESERVATION","Is this covering data on their cloud/site. Will ERI  have the right level of access to data. \nWhere is the data stored.\nAlso storage and archiving. Including NERSA / Legal requirements.",null,"Very important",{"$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":4},3.4482758620689655E-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","ERI Configuration Management System","Data Recovery","AVAILABILITY, RETRIEVAL AND USE","Provide details of backups. How long is it kept. . Process for destroying data.\nIs ERI clearly informed about the procedure and conditions for the destruction of ERI data?",null,"Very important",{"$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":4},3.4482758620689655E-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","ERI Configuration Management System","Security Logs","SECURITY, CONFIDENTIALITY AND PRIVACY","Does the system provide and give ERI access to audit trails, metadata and/or access logs to demonstrate security measures?  ",null,"Show stopper",{"$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":6},5.1724137931034482E-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","ERI Configuration Management System"," Data ownership and use Compliance document","DATA OWNERSHIP AND USE","Please confirm that ESKOM retains ownership of the data that ESKOM stores, transmits, and/or creates with the cloud service.",null,"Very 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":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[10,"Meeting the Scope of Work Required","ERI Configuration Management System"," Data ownership and use Compliance document","DATA OWNERSHIP AND USE","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?",null,"Very important",{"$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":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[11,"Meeting the Scope of Work Required","ERI Configuration Management System","ESKOM requires no exception for metadata.","DATA OWNERSHIP AND USE","Do the Supplier’s terms apply to Eskom generated metadata as well?",null,"Very 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":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[12,"Meeting the Scope of Work Required","ERI Configuration Management System","Metadata ownership","DATA OWNERSHIP AND USE","Does ESKOM gain ownership of metadata generated by the cloud service system during procedures of upload, management, download, and migration?",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},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[13,"Meeting the Scope of Work Required","ERI Configuration Management System","Business continuity","AVAILABILITY, RETRIEVAL AND USE","Supplier will be required to include detailed DR(disaster recovery) and business continuity plans to ensure all the business information is restored fully.",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},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[14,"Meeting the Scope of Work Required","ERI Configuration Management System","Time and cost for restoring ESKOM data    ","AVAILABILITY, RETRIEVAL AND USE","Are the procedures, time and cost for restoring ESKOM data following a service outage clearly defined?",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},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[15,"Meeting the Scope of Work Required","ERI Configuration Management System","Non-interruptable service","AVAILABILITY, RETRIEVAL AND USE","The Cloud Service Provider to ensure uninterruptable service availability and reliability 24x7",null,"Very important",{"$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":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[16,"Meeting the Scope of Work Required","ERI Configuration Management System","Audit trails and access logs","SECURITY, CONFIDENTIALITY AND PRIVACY","Does the system provide and give Eskom access to audit trails, metadata and/or access logs to demonstrate security measures?  ",null,"Very important",{"$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":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n50%:  Partly comply with requirement\n0%:     No compliance",null,0]
[17,"Meeting the Scope of Work Required","ERI Configuration Management System","Backup services","DATA STORAGE","Does the Supplier create backups of ESKOM’s data?",null,"Very important",{"$f":"IF(H25='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H25='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H25='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H25='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H25='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H25='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H25='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[18,"Meeting the Scope of Work Required","ERI Configuration Management System","Backup services","DATA STORAGE","Are there specific service levels around backups?",null,"Very important",{"$f":"IF(H26='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H26='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H26='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H26='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H26='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H26='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H26='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[19,"Meeting the Scope of Work Required","ERI Configuration Management System","Backup services","DATA STORAGE","Does ESKOM have audit rights to verify that back-ups have been done as contracted?",null,"Very important",{"$f":"IF(H27='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H27='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H27='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H27='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H27='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H27='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H27='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[20,"Meeting the Scope of Work Required","ERI Configuration Management System","Data recovery","DATA STORAGE","In the event of accidental data deletion, does the Supplier bear responsibility for data recovery?",null,"Very important",{"$f":"IF(H28='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H28='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H28='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H28='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H28='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H28='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H28='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[21,"Meeting the Scope of Work Required","ERI Configuration Management System","Data integrity","DATA PRESERVATION","Will ESKOM be notified by the Supplier of changes made to ESKOM data due to evolution of the service?",null,"Very important",{"$f":"IF(H29='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H29='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H29='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H29='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H29='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H29='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H29='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[22,"Meeting the Scope of Work Required","ERI Configuration Management System","Data disposal","DATA RETENTION AND DISPOSITION","Will ESKOM data (and all their copies, including backups) be destroyed in compliance with ESKOM data retention and disposition policies?",null,"Very important",{"$f":"IF(H30='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H30='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H30='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H30='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H30='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H30='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H30='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[23,"Meeting the Scope of Work Required","ERI Configuration Management System","Data disposal","DATA RETENTION AND DISPOSITION","Will the Supplier deliver and/or give access to audit trails of the destruction activity?",null,"Very important",{"$f":"IF(H31='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H31='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H31='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H31='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H31='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H31='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H31='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[24,"Meeting the Scope of Work Required","ERI Configuration Management System","Data disposal","DATA RETENTION AND DISPOSITION","Will the Supplier provide an attestation, report, or statement of deletion (if required by ESKOM internal or legal destruction policies)?",null,"Very important",{"$f":"IF(H32='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H32='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H32='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H32='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H32='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H32='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H32='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[25,"Meeting the Scope of Work Required","ERI Configuration Management System","Data protection and security","SECURITY, CONFIDENTIALITY AND PRIVACY","Will ESKOM be notified in case of a security breach or system malfunction?",null,"Very important",{"$f":"IF(H33='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H33='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H33='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H33='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H33='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H33='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H33='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[26,"Meeting the Scope of Work Required","ERI Configuration Management System","Data protection and security","SECURITY, CONFIDENTIALITY AND PRIVACY","Please specify the location where all systems will be located and advise ESKOM’s access rights to such location and facilities.",null,"Very important",{"$f":"IF(H34='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H34='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H34='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H34='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H34='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H34='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H34='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[27,"Meeting the Scope of Work Required","ERI Configuration Management System","Supplier/Vendor accreditation","ACCREDITATION AND AUDITING","Is the Supplier audited on a systematic, regular and independent basis by a third-party in order to demonstrate compliance with security, confidentiality and privacy policies?",null,"Very important",{"$f":"IF(H35='Priority Ratings'!$C$21,'Priority Ratings'!$B$21,IF(H35='Priority Ratings'!$C$22,'Priority Ratings'!$B$22,IF(H35='Priority Ratings'!$C$23,'Priority Ratings'!$B$23,IF(H35='Priority Ratings'!$C$24,'Priority Ratings'!$B$24,IF(H35='Priority Ratings'!$C$25,'Priority Ratings'!$B$25,IF(H35='Priority Ratings'!$C$26,'Priority Ratings'!$B$26,IF(H35='Priority Ratings'!$C$27,'Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},3.4482758620689655E-2,"100%: Fully comply with requirement\n0%:     No compliance",null,0]
[]
[null,null,null,null,null,null,"Totals",null,{"$f":"SUM(I9:I35)","v":116},{"$f":"SUM(J9:J35)","v":0.99999999999999944},null,null,{"$f":"SUM(M9:M35)","v":0}]

{"sheet":"Priority Ratings","index":6,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"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"]
[]
[null,"Please do NOT delete this sheet. "]

{"sheet":"Config","index":7,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Solution",null,"Priority rating","Priority Description",null,"Category"]
[null,"Chatbot",null,0,"No interest",null,"Functional"]
[null,"Social Media API",null,1,"Nice to have",null,"Technical Evaluation"]
[null,"Chatbot and Social Media API",null,2,"Useful",null,"Integration and Testing"]
[null,null,null,3,"Important",null,"Cloud"]
[null,null,null,4,"Very important"]
[null,null,null,5,"Critical"]
[null,null,null,6,"Show stopper"]
[]
[]
[]
[null,"Please do NOT delete this sheet. The items are used in the drop down lists"]

{"sheet":"Concerns and Recommendations","index":8,"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,"Please do NOT delete this sheet. "]
[null,"Recommendation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Concerns"]