{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Process","Scoring ","Func Evaluation","Non Functional (Technical)","Integration & Testing"],"not_rendered":{"images":1,"external_links":3,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Process","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,0,0,1]]}
["RFP Assessment Process"]
["Step 1","Business and Group IT Assessment :"]
[null,"(Business Score 60%) A threshold  of  60% will be considered meeting the minimum requirement."]
[null,"(Group IT - Non Functional (Technical) Score 20%). A threshold  of 70% will be considered meeting the minimum requirement."," "]
[null,"(Group IT - Integration & Testing Score 20%) A threshold  of 70% will be considered meeting the minimum requirement"]
["Step 2","Demonstrations of products"]
["Step 3","Final score is made up 60% RFP response score and 40% product demonstration score"]
["Step 4","Rank products and compile report"]

{"sheet":"Scoring ","index":1,"n_rows":5,"n_cols":2,"rows_kept":5}
["Scoring 1","Scores"]
[]
["Functional Evalution",{"$f":"'Func Evaluation'!H77","v":{"v":0.6,"d":"60%"}}]
["Non-Functional Evaluation",{"v":0.2,"d":"20%"}]
["Integration & Testing",{"v":0.2,"d":"20%"}]

{"sheet":"Func Evaluation","index":2,"n_rows":77,"n_cols":9,"rows_kept":77,"merged":[[0,1,0,4],[1,1,1,4],[2,0,2,8],[3,1,3,2],[4,1,4,2],[4,8,10,8],[5,1,5,2],[5,5,10,5],[5,6,10,6],[5,7,10,7],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,8,22,8],[12,1,12,2],[12,6,22,6],[12,7,22,7],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,8,27,8],[24,1,24,2],[24,6,27,6],[24,7,27,7],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,8,33,8],[29,1,29,2],[29,6,33,6],[29,7,33,7],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,8,38,8],[35,1,35,2],[35,6,38,6],[35,7,38,7],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[39,8,45,8],[40,1,40,2],[40,6,45,6],[40,7,45,7],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,0,49,5],[47,6,49,7],[47,8,49,8],[51,0,51,8],[52,8,70,8],[53,6,70,6],[53,7,70,7],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[72,0,74,5],[72,6,74,7],[72,8,74,8]]}
[null,"CONTRACT MANAGEMENT SYSTEM SOLUTION",{"$nulls":5},"REVISION",1]
[null,"TECHNICAL EVALUATION CRITERIA"]
["PART A - DESK TOP TECHNICAL EVALUATION"]
["Item","Description",null,"Criteria & Measure","Maximum Score Achievable","Tenderer's Response","Assessed Score","Weight","Weighted Score"]
[1,"System Users ",{"$nulls":3},"Enter number",null,null,{"$f":"H6*G6","v":{"v":0.15,"d":"15.00%"}}]
[null,"The users will include IT Administrators, Super users and users with deferent Access Rights.  The Tenderer to provide proof of solution capacity in terms of number of users.",null,">Unlimited",{"v":1,"d":"100%"},"Unlimited",{"$f":"IF(F6<=100,20%,IF(F6<=500,40%,IF(F6<=1000,60%,IF(F6<=1999,80%,IF(F6=\"Unlimited\",100%,0)))))","v":{"v":1,"d":"100%"}},{"v":0.15,"d":"15%"}]
[{"$nulls":3},"<1999",{"v":0.8,"d":"80%"}]
[{"$nulls":3},"<1000",{"v":0.6,"d":"60%"}]
[{"$nulls":3},"<500",{"v":0.4,"d":"40%"}]
[{"$nulls":3},"<100",{"v":0.2,"d":"20%"}]
[]
[2,"Solution Compatibility",{"$nulls":3},"Select Options",null,null,{"$f":"H13*G13","v":{"v":0.06,"d":"6.0%"}}]
[null,"The system is expected to link with existing system to avoid duplication of efforts wrt data inputs. The tenderer is expected to confirm which systems or programme are compatible with the solution.",null,"SAP MM",{"$f":"100%/COUNTA($D$13:$D$22)","v":{"v":0.1,"d":"10%"}},"Compatible ",{"$f":"IF(SUMIF(F13:F22,\"=Compatible \",E13:E22)>100%,\"Error\",SUMIF(F13:F22,\"=Compatible \",E13:E22))","v":{"v":0.6,"d":"60%"}},{"v":0.1,"d":"10%"}]
[{"$nulls":3},"SAP FI/PS",{"v":0.1,"d":"10%"},"Compatible "]
[{"$nulls":3},"WIN QS",{"v":0.1,"d":"10%"},"Compatible "]
[{"$nulls":3},"MS OFFICE",{"v":0.1,"d":"10%"},"Compatible "]
[{"$nulls":3},"SharePoint",{"v":0.1,"d":"10%"},"Compatible "]
[{"$nulls":3},"PRISMG2",{"v":0.1,"d":"10%"},"Compatible "]
[{"$nulls":3},"CURA",{"v":0.1,"d":"10%"}]
[{"$nulls":3},"Open Text",{"v":0.1,"d":"10%"}]
[{"$nulls":3},"PRIMAVERA P6",{"v":0.1,"d":"10%"}]
[{"$nulls":3},"Other",{"v":0.1,"d":"10%"}]
[]
[3,"Accessibility",{"$nulls":3},"Select Options",null,null,{"$f":"H25*G25","v":{"v":0.045,"d":"4.50%"}}]
[null,"The tenderer to submit proof of the solution's accessibility offline and or online, and the extent which data, information or records can be uploaded and or updated.",null,"Online (Full Access)",{"v":0.7,"d":"70%"},"Compatible ",{"$f":"SUMIF(F25:F27,\"=Compatible \",E25:E27)","v":{"v":0.8999999999999999,"d":"90%"}},{"v":0.05,"d":"5%"}]
[{"$nulls":3},"Offline (Full Access)",{"v":0.3,"d":"30%"}]
[{"$nulls":3},"Offline (Partial Access)",{"v":0.2,"d":"20%"},"Compatible "]
[]
[4,"System and Data Security",{"$nulls":3},"Select Options",null,null,{"$f":"H30*G30","v":{"v":0.08000000000000002,"d":"8.00%"}}]
[null,"The tenderer to submit proof of the solution's security capability and capacity.",null,"Cyber Security (Hacker Proof)",{"v":0.2,"d":"20%"},"Compatible ",{"$f":"SUMIF(F30:F34,\"=Compatible \",E30:E34)","v":{"v":0.8,"d":"80%"}},{"v":0.1,"d":"10%"}]
[{"$nulls":3},"Data Security",{"v":0.2,"d":"20%"},"Compatible "]
[{"$nulls":3},"Login Password Protection",{"v":0.2,"d":"20%"},"Compatible "]
[{"$nulls":3},"Concurrent multiple users security",{"v":0.2,"d":"20%"}]
[{"$nulls":3},"User type Access Rights restrictions",{"v":0.2,"d":"20%"},"Compatible "]
[5,"Data Storage",{"$nulls":3},"Select 1 Options",null,null,{"$f":"H36*G36","v":{"v":0.06,"d":"6.00%"}}]
[null,"The tenderer to submit proof of system storage capability and capacity. And flexibility to backup data to local storage facility",null,"Both Cloud and local",{"v":1,"d":"100%"},null,{"$f":"IF((SUMIF(F36:F39,\"=Compatible \",E36:E39))>100%,\"Error\",(SUMIF(F36:F39,\"=Compatible \",E36:E39)))","v":{"v":0.6,"d":"60%"}},{"v":0.1,"d":"10%"}]
[{"$nulls":3},"Local Storage Only",{"v":0.8,"d":"80%"}]
[{"$nulls":3},"Cloud Storage Only",{"v":0.6,"d":"60%"},"Compatible "]
[]
[6,"Contract Monitoring and Reporting",{"$nulls":3},"Select Options",null,null,{"$f":"H41*G41","v":{"v":0.06000000000000001,"d":"6.00%"}}]
[null,"The solutions must have the contract monitoring and report generating functionality. The Tenderer must submit proof of the solution's capability and capability to generate contract related reports, notify users on outstanding information or date, mandatory fields, data integrity, revision control and changes effected.   ",null,"Customised Reporting",{"v":0.2,"d":"20%"},"Compatible ",{"$f":"IF((SUMIF(F41:F46,\"=Compatible \",E41:E46))>100%,\"Error\",(SUMIF(F41:F46,\"=Compatible \",E41:E46)))","v":{"v":0.6000000000000001,"d":"60%"}},{"v":0.1,"d":"10%"}]
[{"$nulls":3},"Various Contract Registers",{"v":0.2,"d":"20%"},"Compatible "]
[{"$nulls":3},"Time Analysis",{"v":0.2,"d":"20%"},"Compatible "]
[{"$nulls":3},"User Notifications and reminders system",{"v":0.2,"d":"20%"}]
[{"$nulls":3},"Workflow Assignment and notification",{"v":0.2,"d":"20%"}]
[]
[{"$nulls":7},{"$f":"SUM(H5:H46)","v":{"v":0.6,"d":"60%"}}]
["Minimum Sub Total Weighted Average Score ≥ 60% is required for items 1 to 7 above before tenderers will be considered for Part B Demonstration Technical Evaluation in item 8.",{"$nulls":5},{"$f":"IF(I48>60%,\"Total Sub-Weighted Score Recommended\",\"Total Sub-Weighted Score Not Recommended\")","v":"Total Sub-Weighted Score Not Recommended"},null,{"$f":"SUM(I5:I46)","v":{"v":0.455,"d":"45.5%"}}]
[]
[]
[]
["PART B - DEMONSTRATION TECHNICAL EVALUATION"]
[8,"Solution Capacity and Capability Live Demonstration",{"$nulls":3},"Select Options",null,null,{"$f":"H54*G54","v":{"v":0.1375,"d":"13.8%"}}]
[{"$nulls":6},{"$f":"IF(SUMIF(F55:F71,\"=Compatible \",E55:E71)>100%,\"Error\",SUMIF(F55:F71,\"=Compatible \",E55:E71))","v":{"v":0.6875,"d":"69%"}},{"v":0.2,"d":"20%"}]
[1,"Demonstrate Information/data Migration","Seamless migration of data from all existing Contract Management System into equivalent submodules of new system. This should include all metadata, “links” and attachments via hyperlinks to Document Record Management (DRM)database.",null,{"$f":"100%/COUNTA($C$55:$C$71)","v":{"v":0.0625,"d":"6%"}},"Compatible "]
[2,"User interface Functionality","Be able to display an orientation framework within the project as a whole, to the user. (Note: since many of the projects are large, complex structured hierarchies of information, users will need the system to highlight where in the hierarchy they are working)",null,{"v":0.0625,"d":"6%"},"Compatible "]
[3,null,"Have a common look and feel across all modules",null,{"v":0.0625,"d":"6%"},"Compatible "]
[4,null,"Have a Graphical User Interface (GUI) with capabilities such as drag and drop, cut and paste, dock-able to open multiple windows, and dual screen viewing",null,{"v":0.0625,"d":"6%"},"Compatible "]
[5,null,"Browser support (specifically – Microsoft Edge and/or Mozilla Firefox, as per Eskom standards)",null,{"v":0.0625,"d":"6%"},"Not Compatible "]
[6,null,"Drill-down/drill-up functionality between levels of detail",null,{"v":0.0625,"d":"6%"},"Compatible "]
[7,null,"Maintain relationships in HTML via hyperlinks (if browser/web based, the system should allow for navigation through the system and project(s) hierarchies by the use of Hyperlinks)",null,{"v":0.0625,"d":"6%"},"Compatible "]
[8,"System Integration requirements","Ability to integrate with Vendor/procurement info from SAP (Export information from\nSAP into solution)",null,{"v":0.0625,"d":"6%"},"Not Compatible "]
[9,null,"Ability to access the draft contract records by clicking on the link that directs the user to SharePoint",null,{"v":0.0625,"d":"6%"},"Not Compatible "]
[10,"System Performance requirements","Support remote access via Eskom network for instance via Citrix (which is an Eskom standard)",null,{"v":0.0625,"d":"6%"},"Compatible "]
[11,null,"Synchronize offline and online information, (e.g. An exported cost structure once the user is online again). Solution provider to specify how the synchronization will occur if there are changes to the structure between initial and off-line ",null,{"v":0.0625,"d":"6%"},"Compatible "]
[12,null,"Operate at the same performance as 1 user accessing the repository and if there are up to 100 users accessing the same repository (if the recommended infrastructure and bandwidth is in place)",null,{"v":0.0625,"d":"6%"},"Compatible "]
[13,"Security requirements","The System should provide for password protection as per Eskom’s logical access control\nstandards. Users should be able to log in and out using Eskom usernames and passwords (as defined in MS Active Directory)",null,{"v":0.0625,"d":"6%"},"Not Compatible "]
[14,null,"The System should allow users to be restricted to only having access to specific contracts, based on the setup and configuration of roles and user groups, and assignment of these to users by the System Administrator",null,{"v":0.0625,"d":"6%"},"Not Compatible "]
[15,null,"Access rights must align with user role - Programme Manager; Project Manager; Contract Manager; Contract Administrator; Contract Specialist; DRM\nManager; DRM officer",null,{"v":0.0625,"d":"6%"},"Compatible "]
[16,"Demonstrate User Training programme","Comprehensive System Administrator training, Comprehensive Tactical Rollout Resource training, Comprehensive User training for new users, Managers training, Introduction to new system training (high level overview).",null,{"v":0.0625,"d":"6%"},"Compatible "]
[]
[{"$nulls":7},{"$f":"SUM(H54)","v":{"v":0.2,"d":"20%"}}]
["Total Weighted Average Score ≥ 70% is required for items 1 to 8 above for a tenderer to be declared Technically Compliant.",{"$nulls":5},{"$f":"IF(I73>60%,\"Total Weighted Score Recommended\",\"Total Weighted Score Not Recommended\")","v":"Total Weighted Score Not Recommended"},null,{"$f":"SUM(I48,I53)","v":{"v":0.5925,"d":"59.3%"}}]
[]
[]
[]
[{"$nulls":7},{"$f":"SUM(,H47)","v":{"v":0.6,"d":"60%"}}]

{"sheet":"Non Functional (Technical)","index":3,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[1,2,1,5],[2,1,8,1],[9,2,9,5],[10,1,12,1],[13,2,13,5],[14,1,20,1],[21,2,21,5],[22,1,26,1],[27,2,27,5],[28,1,30,1]]}
[null,null,"Item #","Question","Answer Rating","Max score"]
[null,null,"Deployment"]
[null,"Deployment",1,"Can your application be deployed on-premise? \n","5= Yes\n0 = No",5]
[null,null,2,"What is the solution footprint in South Africa","5= Large (more than 10 sites)\n3 = Medium (3-10 sites)\n0 = Small (0-3 sites)",5]
[null,null,3,"What are the licencing options /  models available","0 = Best fit for Eskom requirements\n0= Partial fit for Eskom requirements\n0 = No fit for Eskom requirements",0]
[null,null,4,"Provide a diagram showing all the components required for an on premise deployment of your solution. Include all components required for the update of information.","3 = Diagram that includes all components as per submission and that is complete\n1 = Diagram that excludes any components mentioned in submission or that is not complete from an architecture perspective, i.e. does not show the full solution or there are evidently components missing\n0 = No diagram provided\n",3]
[null,null,5,"Describe the scalability options for your solution.","2 = Evidence provided of the solution scalability\n0 = No evidence provided of the solution scalability",2]
[null,null,6,"List all databases (including their versions) that are supported by your solution? List all","3 = Complies with Eskom standards\n1 = Complies with standard technology, but version is not standardised, only if that version is a newer version than the standard or a version that is still under support and the vendor has an upgrade path\n0 = Does not comply with Eskom standards",3]
[null,null,7,"List all the operating systems (including their versions) that your application is compatible with? List all","3 = Complies with Eskom standards\n1 = Complies with standard technology, but version is not standardised, only if that version is a newer version than the standard or a version that is still under support and the vendor has an upgrade path\n0 = Does not comply with Eskom standards",3]
[null,null,"Hosting & Cloud"]
[null,"Hosting & Cloud",8,"What assurance as a cloud provider will be provided to Eskom? Describe in terms of security policy/framework approach, business continuity","3 - full security for confidentiality, integrity and availability of data\n1 - security controls in place, but gaps exist\n0 -none",3]
[null,null,9,"Does Eskom owns the data and IP of all the work done on the software platform and has the right to access the information as well as export the information into any other Eskom environment it deems fit? ","Yes = 3\nNo = 0",3]
[null,null,10,"List all hosting & cloud options available for your application.","3 = Fully aligned to Eskom's cloud strategy\n2 = Partially aligned to Eskom's cloud strategy\n1 = No alignment to Eskom's cloud strategy",3]
[null,null,"Platform & Integration"]
[null,"Platform & Integration",11,"List the web and/or application server technologies and versions that are required for your solution. If options are available, clearly indicate it.","3 = Complies with Eskom standards\n1 = Complies with standard technology, but version is not standardised, only if that version is a newer version than the standard or a version that is still under support and the vendor has an upgrade path\n0 = Does not comply with Eskom standards",3]
[null,null,12,"Describe the technologies and protocols that your solution can use to integrate with other systems. List all","3 = Complies with Eskom standards\n0 = Does not comply with Eskom standards",3]
[null,null,13,"Have you integrated with any 3rd party applications before? Please list details.","3 = Yes, list of integrated applications  provided\n1 = Yes, any integration experience (other than AD, MS Exchange)\n0 = No",3]
[null,null,14,"Does your solution integrate with Microsoft Exchange?","3 = Yes\n0 = No",3]
[null,null,15,"Does your solution require any add-on to Microsoft Outlook in order to work?","3 = No\n0 = Yes",3]
[null,null,16,"Describe how your solution supports SOA?","3 = Well supported (API and Webservices available and/or customisable)\n1 = Partially supported (limited APIs and Webservice support)\n0 = Not supported",3]
[null,null,17,"What is the sytem availability and does it form part of the SLA?","3 = high availibility >= 99.5% and in SLA .\n1 = assurance of high availability (i.e explains technical solution) but not specified in SLA or less than 99.5%.\n0 - very little, or no assurance of availability",3]
[null,null,"Security & Access Mngt"]
[null,"Security & Access Mngt",18,"Describe how logical access management is done.","3 = IAM in Place\n0 = No IAM in Place",3]
[null,null,19,"Can your solution authenticate against either Microsoft Active Directory or LDAP? If so, please indicate which.","3 = Yes, AD\n1 = Yes, LDAP only\n0 = Neither",3]
[null,null,20,"Describe what mechanisms are in place to secure the link to update content?","3 = Secure Link in Place\n0 = No Secure Link in Place\n",3]
[null,null,21,"Is content scanned before update to ensure there is no malicious code present?","3 = Security measures / Anti-Malware in Place\n0 = No Security measures / Anti-Malware",3]
[null,null,22,"What reports will be made available on security controls/Backups and system availability and other Cobit Control objectives","3 = audit reports provided periodically\n1 = reports provided on request, 0 - none",3]
[null,null,"Content Mngt"]
[null,"Content Mngt",23,"Does  your solution require customisation or configuration in order to meet requirement? If customisation is required, Specify if it is more than 10% or less than Provide detailed list of features that needs to be customized","3 = Configuration < 1%\n1 = Customisation < 1-10%\n0 = Customisation > 10 %",3]
[null,null,24,"Is data updated via push or pull?\nIs your system able to do 'Pull Based', 'Push Based', 'Search in place' or all of these? List all capabilities.","Real/near real time data required:\n3 = Push and Search in Place\n1 = Push only\n0 = Pull only\n",3]
[null,null,25,"List how your solution caters for people that are visually or audibly impaired?","3 = Mechanisms available\n0 = No mechanisms available",3]
[]
[{"$nulls":5},{"$f":"SUM(F3:F31)","v":75}]
[{"$nulls":3},"A threshold  of  70% will be considered meeting the minimum requirement."]

{"sheet":"Integration & Testing","index":4,"n_rows":27,"n_cols":13,"rows_kept":27,"merged":[[0,0,0,2],[5,6,5,8]]}
[]
["MWPxxxxCX Tender",{"$nulls":9},"Scoring (Sliding scale)"]
["Tenderer:",{"$nulls":9},"100% - Fully compliant"]
["Evaluated by:",{"$nulls":9},"50%-Partially compliant"]
[{"$nulls":10},"0%-Non compliance"]
[{"$nulls":6},"Priority and Weight",null,null,"Score\n(determined by each evaluation team member during evaluation. Will be averaged for final scores)","Score"]
["ID","Type","Category","Criterion","Functional Requirement","Requirement description","Priority Description","Priority\n","Weighted Question","Scoring"," Answer\n(0,50,100%)","Weighted Answer","Comments"]
[]
[1,"Meeting the Scope of Work Required","Non Functional","Previous involvement in the end to end testing of a similar system and methodologies used)","Testing ","Provide reference customers and sites","Very important",{"$f":"IF(G9='[2]Priority Ratings'!$C$21,'[2]Priority Ratings'!$B$21,IF(G9='[2]Priority Ratings'!$C$22,'[2]Priority Ratings'!$B$22,IF(G9='[2]Priority Ratings'!$C$23,'[2]Priority Ratings'!$B$23,IF(G9='[2]Priority Ratings'!$C$24,'[2]Priority Ratings'!$B$24,IF(G9='[2]Priority Ratings'!$C$25,'[2]Priority Ratings'!$B$25,IF(G9='[2]Priority Ratings'!$C$26,'[2]Priority Ratings'!$B$26,IF(G9='[2]Priority Ratings'!$C$27,'[2]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: Fully comply with requirement\n50%:   Partially comply(Have experience but not a similar system)\n0%:     No experience\n","0%+K9K9:K15",{"$f":"I9*K9","v":{"$error":"#VALUE!"}}]
[2,"Team Organisation and Member Requirements","Non Functional","Resource model. It is a requirement that sufficient dedicated testers are allocated the project, independent of the development team. Team members have the required ISTQB testing certifications (Provide Certifications of team members)","Testing ","Experienced Test Manger must be provided","Very important",{"$f":"IF(G10='[2]Priority Ratings'!$C$21,'[2]Priority Ratings'!$B$21,IF(G10='[2]Priority Ratings'!$C$22,'[2]Priority Ratings'!$B$22,IF(G10='[2]Priority Ratings'!$C$23,'[2]Priority Ratings'!$B$23,IF(G10='[2]Priority Ratings'!$C$24,'[2]Priority Ratings'!$B$24,IF(G10='[2]Priority Ratings'!$C$25,'[2]Priority Ratings'!$B$25,IF(G10='[2]Priority Ratings'!$C$26,'[2]Priority Ratings'!$B$26,IF(G10='[2]Priority Ratings'!$C$27,'[2]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: > 5 years experienced Testmanager provided, resources with certification\n50%: between 2 and 5 years exeperience with certification\n0%: < 2 yearsexperience, No certification\n",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[3,"Meeting the Scope of Work Required","Non Functional","Resource Experience with Eskoms Testing tools","Testing ","Must be HP ALM, UFT and Load Runner ","Very important",{"$f":"IF(G11='[2]Priority Ratings'!$C$21,'[2]Priority Ratings'!$B$21,IF(G11='[2]Priority Ratings'!$C$22,'[2]Priority Ratings'!$B$22,IF(G11='[2]Priority Ratings'!$C$23,'[2]Priority Ratings'!$B$23,IF(G11='[2]Priority Ratings'!$C$24,'[2]Priority Ratings'!$B$24,IF(G11='[2]Priority Ratings'!$C$25,'[2]Priority Ratings'!$B$25,IF(G11='[2]Priority Ratings'!$C$26,'[2]Priority Ratings'!$B$26,IF(G11='[2]Priority Ratings'!$C$27,'[2]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: 5 years experience on one of the tools\n50%: between 2 and 5 years exeperience \n0%: < 2 years experience\n",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[4,"Meeting the Scope of Work Required","Non Functional","Your testing approach specific to the project with refence to a methodology","Testing ","Tenderer must provide approach","Very important",{"$f":"IF(G12='[2]Priority Ratings'!$C$21,'[2]Priority Ratings'!$B$21,IF(G12='[2]Priority Ratings'!$C$22,'[2]Priority Ratings'!$B$22,IF(G12='[2]Priority Ratings'!$C$23,'[2]Priority Ratings'!$B$23,IF(G12='[2]Priority Ratings'!$C$24,'[2]Priority Ratings'!$B$24,IF(G12='[2]Priority Ratings'!$C$25,'[2]Priority Ratings'!$B$25,IF(G12='[2]Priority Ratings'!$C$26,'[2]Priority Ratings'!$B$26,IF(G12='[2]Priority Ratings'!$C$27,'[2]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: Complete approach provided with reference to a methodology\n50%:  Approach provided with no reference to a methodology\n0%:  No approach provided\n",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[5,"Meeting the Scope of Work Required","Non Functional","Solid Testing capability (reference projects & sites and methodologies used)","Testing "," Provide written reference from customers and sites","Very important",{"$f":"IF(G13='[2]Priority Ratings'!$C$21,'[2]Priority Ratings'!$B$21,IF(G13='[2]Priority Ratings'!$C$22,'[2]Priority Ratings'!$B$22,IF(G13='[2]Priority Ratings'!$C$23,'[2]Priority Ratings'!$B$23,IF(G13='[2]Priority Ratings'!$C$24,'[2]Priority Ratings'!$B$24,IF(G13='[2]Priority Ratings'!$C$25,'[2]Priority Ratings'!$B$25,IF(G13='[2]Priority Ratings'!$C$26,'[2]Priority Ratings'!$B$26,IF(G13='[2]Priority Ratings'!$C$27,'[2]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%:Fully comply with requirement\n50%:  Capability shown but no refence to sites \n0%:  No experience\n",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[6,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation of Oracle Fusion integration solutions in an enterprise","Integration","Please provide reference projects & sites and pattern your previous experience covers","Very important",{"$f":"IF(G14='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(G14='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(G14='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(G14='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(G14='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(G14='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(G14='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: Experience in Oracle Fusion Implementation\n0%: No experience in Oracle Fusion",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[7,"Meeting the Scope of Work Required","Non Functional","Previous experience in implementation  of DataPower integration solutions in an enterprise","Integration","Please provide reference projects & sites and pattern your previous experience covers","Very important",{"$f":"IF(G15='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(G15='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(G15='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(G15='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(G15='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(G15='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(G15='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: Good Experience in Data Power Implementation\n0%: No experience in Data Power Implementation",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[8,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications for Oracle Fusion 12C ","Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?","Show stopper",{"$f":"VLOOKUP(G16,'[3]Priority Ratings'!M23:N29,2,FALSE)","v":6},null,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[9,"Meeting the Scope of Work Required","Non Functional","Team has the required certifications IBM Data Power","Integration","(Provide Certificate) acquired through permanent resources or partnership. Capability of at least 1 senior certified resource must have working experience in the technology?","Very important",{"$f":"IF(G17='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(G17='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(G17='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(G17='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(G17='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(G17='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(G17='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"100%: Good Experience with certification\n50%: Certification without experience\n0%: No experience, No certification",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[10,"Meeting the Scope of Work Required","Non Functional","Previous experence in carrying out analysis, design, development, testing and deployment of Oracle Fusion and Datapower integration services\n\n\n","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","Very important",{"$f":"IF(G18='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(G18='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(G18='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(G18='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(G18='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(G18='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(G18='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"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",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[11,"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.","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","Very important",{"$f":"IF(G19='[3]Priority Ratings'!$C$21,'[3]Priority Ratings'!$B$21,IF(G19='[3]Priority Ratings'!$C$22,'[3]Priority Ratings'!$B$22,IF(G19='[3]Priority Ratings'!$C$23,'[3]Priority Ratings'!$B$23,IF(G19='[3]Priority Ratings'!$C$24,'[3]Priority Ratings'!$B$24,IF(G19='[3]Priority Ratings'!$C$25,'[3]Priority Ratings'!$B$25,IF(G19='[3]Priority Ratings'!$C$26,'[3]Priority Ratings'!$B$26,IF(G19='[3]Priority Ratings'!$C$27,'[3]Priority Ratings'!$B$27,\"No Rating\")))))))","v":4},null,"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",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[12,"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)","Integration","Provide the capability of the Application","Very important",{"$f":"VLOOKUP(G20,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"100%:Source can send a Common information message (CIM) structure\n50%: The Source can send only a proprietary message structure\n0%: Neither",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[13,"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?","Integration","Provide the security capability","Very important",{"$f":"VLOOKUP(G21,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"100%:Source Supports a secure channel of communication\n0%: Source supports no secure channel of communicaiton",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[14,"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?","Integration","Provide the Authentication capability","Very important",{"$f":"VLOOKUP(G22,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"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",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[15,"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?","Integration","Provide the Basic Authentication capability","Very important",{"$f":"VLOOKUP(G23,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"100%:Source can accept full service response\n50%: The Source can accept HTTP/SOAP response\n0%: Neither",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[16,"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)","Integration","Provide The Retry capability","Very important",{"$f":"VLOOKUP(G24,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"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",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[15,"Meeting the Scope of Work Required","Non Functional","Confirm the list of integration services that need to be built is clearly understood","Integration","The solution should be able to integrate to applications for purposes of actioning or addressing queries via the defined intergration technology Oracle Fusion and IBM Datapower.\n(As defined in the Architectural integration highlevel requirements).\n","Very important",{"$f":"VLOOKUP(G25,'[3]Priority Ratings'!M27:N33,2,FALSE)","v":4},null,"100%: Fully comply with requirement\n0%:     No compliance",{"v":0,"d":"0%"},{"v":0,"d":"0.00%"}]
[]
["A 70% threshold will be considered meeting the minimum requirement.",{"$nulls":9},{"$f":"SUM(K10:K26)","v":{"v":0,"d":"0%"}}]