{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Abbreviations","Scoring","GGAP","Summary Score","Mandatory Company Commitment","Company Experience","Customer References","Primary Resource","Secondary Resource","Elective Company Commitment","Transition-Continuation Plan"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Abbreviations","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,0,0,1]]}
["Abbreviations and Definitions"]
["CGW","Candidate Gateway"]
["ERP","Enterprise Resource Planning"]
["GGAP","Generally Good Administration Practices"]
["HCM","Human Capital Management"]
["PS","Oracle PeopleSoft"]
["RACI","Key responsibilities: responsible, accountable, consulted, informed"]
["SCM","Supply Chain Management"]
["SLA","Service Level Agreement"]

{"sheet":"Scoring","index":1,"n_rows":27,"n_cols":7,"rows_kept":27}
["Scoring",{"$nulls":3},"FOR PRIORITISATION/WEIGHT CALCULATIONS (Not to be included in bidder submission template)"]
[]
["Yrs of Experience\n(10% of Experience Score)","Score","Description (see GGAP Worksheet)",null,"CSIR Capability","Score ","Description"]
["< 1 yr",0,"Less than one year",null,"Expert",0,"We can resolve problems"]
["≥ 1 yr & < 3 yrs",5,"One or more years but less than three years",null,"Advanced",2,"We can do it"]
["≥ 3 yr & < 5 yrs",7,"Three or more years but less than five years",null,"Proficient",3,"We can help ourselves"]
["≥ 5yr & < 7 yrs",9,"Five or more years but less than seven years",null,"Basic",4,"We require assistance/direction"]
["> 7 yrs",10,"Seven or more years",null,"None",5,"We require instruction"]
[]
["Company Capability\n(90% of Experience Score)","Score","Description (see GGAP Worksheet)",null,"CSIR Capacity","Score ","Description"]
["None",0,"Your company has no experience in ….",null,"Dedicated",0,"We have space capacity that can be redirected"]
["Basic",5,"Your company may have to consult to execute the standard administration practices.",null,"Free",2,"We can free up capacity with minimal operational or delivery impact, or both"]
["Proficient",7,"In addition, your company can execute all standard administration function.",null,"Limited",3,"Must compromise on critical delivery or operational delivery, or both"]
["Advanced",9,"In addition, your company can independently and setup and configure integration between PeopleSoft components, with interfacing systems and public interfaces, do troubleshooting.",null,"Restricted",4,"To free up capacity we must compromise operations to a degree that it may impact CSIR's operations"]
["Expert",10,"In addition, your company operates complete ERP environments, or can do advanced troubleshooting on integrating with interfacing systems and public interfaces, or both, only requiring assistance from Oracle in the event of a bug or software error.",null,"None",5,"None"]
[]
["Resources Capability\n(90% of Experience Score)","Score","Description (see GGAP Worksheet)",null,"ERP System Criticality","Factor"]
["None",0,"The resource requires direction in all aspects of the work.",null,"Low",{"v":0.25,"d":"25%"}]
["Basic",5,"The resource requires guidance to execute one or more of the relevant generally good administration practices.",null,"Medium",{"v":0.5,"d":"50%"}]
["Proficient",7,"The resource is fully capable of functioning independently in complying with the relevant generally good administration practices.",null,"High",{"v":0.75,"d":"75%"}]
["Advanced",9,"In addition, the resource can independently set up, configure, troubleshoot and optimise the performance of integrations between: \n• PeopleSoft components and public interfaces, e.g. Candidate Gateway\n• PeopleSoft and interfacing systems in the PeopleSoft-centred landscape\n• PeopleSoft and public interfaces, e.g. National Treasury",null,"Critical",{"v":1,"d":"100%"}]
["Expert",10,"In addition, the resource operates the complete ERP environment, can do advanced troubleshooting on integrating with interfacing systems and public interfaces, only requiring assistance from Oracle in the event of a bug or software error."]
[]
["Transition Plan Evaluation","Score","Description"]
["Does not meet expectations",0,"The quality of the element/component/characteristic does not meet expectations"]
["Meets Expectations",5,"The quality of the element/component/characteristic meets expectations"]
["Exceeds Expectations",10,"The quality of the element/component/characteristic exceeds expectations"]

{"sheet":"GGAP","index":2,"n_rows":22,"n_cols":3,"rows_kept":22,"merged":[[0,0,0,2]]}
["Generally Good Administration Practices"]
[]
["General Best Practices:",null,"Application Administration:"]
["Change Management: Implement a robust change management process, ensuring changes are tested, approved, and documented.",null,"Regular Updates: Update applications regularly, especially for security patches."]
["Incident Management: Have a well-defined process for handling incidents, ensuring timely response and recovery.",null,"User Management: Manage user roles and permissions diligently. Only grant access as needed."]
["Training: Continuously train administrators on new technologies, security threats, and best practices.",null,"Monitoring and Logging: Monitor application performance and user activities. Ensure logs are comprehensive but avoid logging sensitive information."]
["Vendor/Original Equipment Manufacturer Management: Regularly review and communicate with vendors about patches, updates, and known vulnerabilities.",null,"Performance Tuning: Monitor application performance and fine-tune configurations to ensure optimal performance."]
["Automation: Wherever possible, automate repetitive tasks to reduce human errors.",null,"Backup and Recovery: Regularly backup application data and configurations. Test recovery processes."]
["Auditing and Compliance: Regularly audit system and user activities. Ensure compliance with industry standards and regulations.",null,"Security: Implement security measures like HTTPS, input validation, output encoding, and secure session management."]
["Principle of Least Privilege: Only give users and processes the permissions they need to perform their tasks.",null,"Configuration Management: Store configurations securely, preferably outside the codebase. Avoid hardcoding sensitive data."]
[null,null,"Testing: Regularly test the application for vulnerabilities and performance issues. Implement continuous integration and continuous development/deployment (CI/CD) pipelines if possible."]
[null,null,"Documentation: Maintain updated documentation about the application's architecture, dependencies, configurations, and customizations."]
[]
["Database Administration:",null,"Server Administration:"]
["Regular Backups: Ensure databases are backed up regularly, and test the restoration processes.",null,"Regular Updates and Patching: Ensure that the OS and software are kept up-to-date with the latest patches and updates."]
["Performance Tuning: Monitor query performance, optimize indexes, and fine-tune configurations to ensure optimal performance.",null,"Monitoring: Use tools to monitor server health, performance metrics, and potential security threats."]
["Security: Use strong authentication methods, encrypt sensitive data, and regularly audit access and actions.",null,"Backup: Implement regular backups and test the restoration process to ensure data integrity and availability."]
["Data Integrity: Implement data validation checks, constraints, and referential integrity rules.",null,"User Management: Only grant necessary permissions and privileges. Use the principle of least privilege."]
["Monitoring: Monitor database health, transaction rates, and error logs.",null,"Security: applying the principle of Least Privilege, Using a firewall to regulate incoming and outgoing traffic, Limiting open ports to only those necessary for your application, use of SSH Key, implement 2FA where feasible, especially for administrative access.\n"]
["Updates and Patching: Keep the database management system (DBMS) updated with the latest patches.",null,"Hardening: Disable unused services, ports, and protocols. Configure firewalls and intrusion detection systems."]
["Disaster Recovery: Implement and test disaster recovery plans and high-availability setups like replication or clustering.",null,"Documentation: Maintain updated documentation regarding server configurations, installed software, and changes."]
["Documentation: Document database schemas, relationships, stored procedures, and any custom configurations."]

{"sheet":"Summary Score","index":3,"n_rows":11,"n_cols":4,"rows_kept":11}
["Summary Score"]
[]
["The Bidder Meets The Pre-qualification Requirements",{"$f":"'Mandatory Company Commitment'!C24","v":"No"}]
[]
["Functional Factors","Weight","Score","Weighted Score"]
["Company Experience",20,{"$f":"'Company Experience'!F19*10","v":{"v":0,"d":"0.00"}},{"$f":"(B6/100)*C6","v":{"v":0,"d":"0.00"}}]
["Primary Resource Expertise",35,{"$f":"'Primary Resource'!F30*10","v":{"v":0,"d":"0.00"}},{"$f":"(B7/100)*C7","v":{"v":0,"d":"0.00"}}]
["Secondary Resource Expertise",15,{"$f":"'Secondary Resource'!F30*10","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Elective Company Commitment",20,{"$f":"'Elective Company Commitment'!D24*10","v":{"v":0,"d":"0.00"}},{"$f":"(B9/100)*C9","v":{"v":0,"d":"0.00"}}]
["Transition/Continuation Plan",10,{"$f":"IF('Transition-Continuation Plan'!D21=\"\",\"\",'Transition-Continuation Plan'!D21)*10","v":{"v":0,"d":"0.00"}},{"$f":"(B10/100)*C10","v":{"v":0,"d":"0.00"}}]
[null,null,"Final Score out of 100",{"$f":"SUM(D6:D10)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Mandatory Company Commitment","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"merged":[[2,0,3,0]]}
["Mandatory Company Commitment"]
[]
["Scope of Work Cross Reference","Mandatory Requirements (Pre-qualification requirements)","Yes"]
[null,"Bidders shall reference the detailed descriptions of the mandatory responsibilities/activities in the cross-referenced section of the RFP","No"]
["B.3.2.1","Support and Administration"]
["B.3.2.1.a","Maintaining the performance and availability of the environment in line with business requirements, including deploying enhancements and fixes from the developers into production and maintaining the synchronisation between the instances."]
["B.3.2.1.b","Implementing releases and changes in line with the CSIR's change control procedures, practices and policies."]
["B.3.2.1.c","Back up the environment per the CSIR Backup Procedure, successfully restore information on demand when required, and successfully recover the environment as part of the CSIR Disaster Recovery Simulations."]
["B.3.2.1.d","Performing the necessary support and administration of the environment during core business hours, being on standby for after-hours support and being available outside of core business hours for planned downtimes."]
["B.3.2.1.e","Adhering to Service Level Agreement (SLA) times on incidents and service request as agreed with the business and stipulated in the SLA agreement for several types of calls."]
["B.3.2.1.f","Performing and recording the necessary activities, controls and checks required from a PeopleSoft Apps DBA and Oracle DBA as part of generally good administration practices that will ensure compliance. "]
["B.3.2.1.g","Creating, managing, maintaining, and administrating the integration points within the environment where other systems integrate with PeopleSoft."]
["B.3.2.3","Collaboration and Communication"]
["B.3.2.3.a","Sharing knowledge with CSIR colleagues that enables one or more colleagues with adequate working knowledge of operational activities such that they can replicate, support, and troubleshoot the environment"]
["B.3.2.4","Logistics "]
["B.3.2.4.a","Commence within two weeks after the agreement is signed"]
["B.3.2.4.b","The billable hours will commence once the resource is registered and given access to the systems."]
["B.3.2.4.c","Resourcing must be adequate to ensure continuity services for the scope of work."]
["B.3.2.4.d","Support and administration shall be available full-time during core business hours (08:00 – 16:30) Mon-Fri."]
["B.3.2.4.e","Support and administration shall be available on a standby basis after hours for any ad-hoc support such as to maximise the availability of the environment between 06:00 and 20:00 on workdays."]
["B.3.2.4.f","Operational services shall be available on an ad-hoc basis after hours for planned maintenance, upgrades and patching such as to maximise the availability of the environment between 06:00 and 20:00 on workdays. "]
["B.3.2.4.g","All duties shall be performed in accordance with the relevant CSIR governance requirements."]
["B.3.2.4.h","Any rework due to the supplier’s fault will be done at the supplier’s expense"]
[null,"The Bidder Meets The Pre-qualification Requirements",{"$f":"IF((COUNTIF(C6:C12,\"No\")+COUNTIF(C14:C14,\"No\")+COUNTIF(C16:C23,\"No\")+COUNTIF(C6:C12,\"\")+COUNTIF(C14:C14,\"\")+COUNTIF(C16:C23,\"\"))>0,\"No\",\"Yes\")","v":"No"}]

{"sheet":"Company Experience","index":5,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[2,0,4,0],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,7,2,11],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11]]}
["Company Experience"]
[]
["Oracle PeopleSoft Component and Associated Activity","Level of Expertise","Years of Experience","Score","Weight","Weight Score",null,"Weight Calculation\n(Not to be included in bidder submission template)"]
[null,"Weight","Weight",{"$nulls":4},"CSIR In-house Capability","CSIR In-house Capacity","Systems Criticality","Score","Weight"]
[null,0.9,0.1]
["Support and Administration of PeopleSoft Financial and Supply Chain Management (Application)",null,null,{"$f":"IF(OR(B6=\"\",C6=\"\"),\"\",$B$5*VLOOKUP(B6,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C6,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"$f":"L6","v":{"v":0.060790273556231005,"d":"6%"}},{"$f":"IF(D6=\"\",\"\",D6*E6)","v":""},null,"Advanced","Limited","Critical",{"$f":"(IF(OR(H6=\"\",I6=\"\",J6=\"\"),\"\",(VLOOKUP(H6,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I6,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J6,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"$f":"IF(K6=\"\",\"\",$K6/SUM($K$6:$K$18))","v":{"v":0.060790273556231005,"d":"6%"}}]
["Support and Administration of PeopleSoft Human Capital Management (Application)",null,null,{"$f":"IF(OR(B7=\"\",C7=\"\"),\"\",$B$5*VLOOKUP(B7,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C7,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"$f":"L7","v":{"v":0.060790273556231005,"d":"6%"}},{"$f":"IF(D7=\"\",\"\",D7*E7)","v":""},null,"Advanced","Limited","Critical",{"$f":"(IF(OR(H7=\"\",I7=\"\",J7=\"\"),\"\",(VLOOKUP(H7,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I7,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J7,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"$f":"IF(K7=\"\",\"\",$K7/SUM($K$6:$K$18))","v":{"v":0.060790273556231005,"d":"6%"}}]
["Support and Administration of PeopleSoft HCM - Candidate Gateway",null,null,{"$f":"IF(OR(B8=\"\",C8=\"\"),\"\",$B$5*VLOOKUP(B8,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C8,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0729483282674772,"d":"7%"},"",null,"Basic","Restricted","High",{"$f":"(IF(OR(H8=\"\",I8=\"\",J8=\"\"),\"\",(VLOOKUP(H8,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I8,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J8,Scoring!$E$18:$F$21,2,FALSE)))","v":6},{"v":0.0729483282674772,"d":"7%"}]
["Support and Administration PeopleTools",null,null,{"$f":"IF(OR(B9=\"\",C9=\"\"),\"\",$B$5*VLOOKUP(B9,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C9,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.12158054711246201,"d":"12%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H9=\"\",I9=\"\",J9=\"\"),\"\",(VLOOKUP(H9,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I9,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J9,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.12158054711246201,"d":"12%"}]
["Support and Administration of PeopleSoft Customer Relationship Management",null,null,{"$f":"IF(OR(B10=\"\",C10=\"\"),\"\",$B$5*VLOOKUP(B10,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C10,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02735562310030395,"d":"3%"},"",null,"Basic","None","Low",{"$f":"(IF(OR(H10=\"\",I10=\"\",J10=\"\"),\"\",(VLOOKUP(H10,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I10,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J10,Scoring!$E$18:$F$21,2,FALSE)))","v":2.25},{"v":0.02735562310030395,"d":"3%"}]
["Support and Administration of Oracle Databases",null,null,{"$f":"IF(OR(B11=\"\",C11=\"\"),\"\",$B$5*VLOOKUP(B11,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C11,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0851063829787234,"d":"9%"},"",null,"Proficient","Restricted","Critical",{"$f":"(IF(OR(H11=\"\",I11=\"\",J11=\"\"),\"\",(VLOOKUP(H11,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I11,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J11,Scoring!$E$18:$F$21,2,FALSE)))","v":7},{"v":0.0851063829787234,"d":"9%"}]
["Upgrading PeopleSoft Financial and Supply Chain Management",null,null,{"$f":"IF(OR(B12=\"\",C12=\"\"),\"\",$B$5*VLOOKUP(B12,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C12,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0911854103343465,"d":"9%"},"",null,"None","None","High",{"$f":"(IF(OR(H12=\"\",I12=\"\",J12=\"\"),\"\",(VLOOKUP(H12,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I12,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J12,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.0911854103343465,"d":"9%"}]
["Upgrading PeopleSoft Human Capital Management",null,null,{"$f":"IF(OR(B13=\"\",C13=\"\"),\"\",$B$5*VLOOKUP(B13,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C13,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0911854103343465,"d":"9%"},"",null,"None","None","High",{"$f":"(IF(OR(H13=\"\",I13=\"\",J13=\"\"),\"\",(VLOOKUP(H13,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I13,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J13,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.0911854103343465,"d":"9%"}]
["Upgrading PeopleSoft HCM - Candidate Gateway",null,null,{"$f":"IF(OR(B14=\"\",C14=\"\"),\"\",$B$5*VLOOKUP(B14,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C14,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0911854103343465,"d":"9%"},"",null,"None","None","High",{"$f":"(IF(OR(H14=\"\",I14=\"\",J14=\"\"),\"\",(VLOOKUP(H14,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I14,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J14,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.0911854103343465,"d":"9%"}]
["Upgrading PeopleTools",null,null,{"$f":"IF(OR(B15=\"\",C15=\"\"),\"\",$B$5*VLOOKUP(B15,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C15,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0911854103343465,"d":"9%"},"",null,"None","None","High",{"$f":"(IF(OR(H15=\"\",I15=\"\",J15=\"\"),\"\",(VLOOKUP(H15,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I15,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J15,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.0911854103343465,"d":"9%"}]
["Upgrading Oracle Databases",null,null,{"$f":"IF(OR(B16=\"\",C16=\"\"),\"\",$B$5*VLOOKUP(B16,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C16,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0425531914893617,"d":"4%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H16=\"\",I16=\"\",J16=\"\"),\"\",(VLOOKUP(H16,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I16,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J16,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.0425531914893617,"d":"4%"}]
["Upgrading Oracle Linux",null,null,{"$f":"IF(OR(B17=\"\",C17=\"\"),\"\",$B$5*VLOOKUP(B17,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C17,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0425531914893617,"d":"4%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H17=\"\",I17=\"\",J17=\"\"),\"\",(VLOOKUP(H17,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I17,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J17,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.0425531914893617,"d":"4%"}]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",null,null,{"$f":"IF(OR(B18=\"\",C18=\"\"),\"\",$B$5*VLOOKUP(B18,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C18,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.12158054711246201,"d":"12%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H18=\"\",I18=\"\",J18=\"\"),\"\",(VLOOKUP(H18,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I18,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J18,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.12158054711246201,"d":"12%"}]
[{"$nulls":4},"Total Score\nout of 10",{"$f":"SUM(F6:F18)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"SUM(L6:L18)","v":{"v":0.9999999999999998,"d":"100%"}}]

{"sheet":"Customer References","index":6,"n_rows":51,"n_cols":10,"rows_kept":51,"merged":[[5,0,5,2],[5,3,5,4],[5,6,5,8],[5,9,5,11],[6,0,8,2],[6,3,6,4],[6,6,8,8],[6,9,6,11],[7,3,7,4],[7,9,7,11],[8,3,8,4],[8,9,8,11],[9,3,9,4],[9,9,9,11],[10,3,10,4],[10,9,10,11],[11,0,11,4],[11,6,11,11],[12,0,12,1],[12,6,12,7],[12,9,12,10],[13,0,13,1],[13,6,13,7],[13,9,13,10],[14,0,14,1],[14,6,14,7],[14,9,14,10],[15,0,15,1],[15,6,15,7],[15,9,15,10],[16,0,16,1],[16,6,16,7],[16,9,16,10],[17,0,17,1],[17,6,17,7],[17,9,17,10],[18,0,18,3],[18,6,18,10],[21,0,21,2],[21,3,21,4],[21,6,21,8],[21,9,21,11],[22,0,24,2],[22,3,22,4],[22,6,24,8],[22,9,22,11],[23,3,23,4],[23,9,23,11],[24,3,24,4],[24,9,24,11],[25,3,25,4],[25,9,25,11],[26,3,26,4],[26,9,26,11],[27,0,27,4],[27,6,27,11],[28,0,28,1],[28,6,28,7],[28,9,28,10],[29,0,29,1],[29,6,29,7],[29,9,29,10],[30,0,30,1],[30,6,30,7],[30,9,30,10],[31,0,31,1],[31,6,31,7],[31,9,31,10],[32,0,32,1],[32,6,32,7],[32,9,32,10],[33,0,33,1],[33,6,33,7],[33,9,33,10],[34,0,34,3],[34,6,34,10],[37,0,37,2],[37,3,37,4],[37,6,37,8],[37,9,37,11],[38,0,40,2],[38,3,38,4],[38,6,40,8],[38,9,38,11],[39,3,39,4],[39,9,39,11],[40,3,40,4],[40,9,40,11],[41,3,41,4],[41,9,41,11],[42,3,42,4],[42,9,42,11],[43,0,43,4],[43,6,43,11],[44,0,44,1],[44,6,44,7],[44,9,44,10],[45,0,45,1],[45,6,45,7],[45,9,45,10],[46,0,46,1],[46,6,46,7],[46,9,46,10],[47,0,47,1],[47,6,47,7],[47,9,47,10],[48,0,48,1],[48,6,48,7],[48,9,48,10],[49,0,49,1],[49,6,49,7],[49,9,49,10],[50,0,50,3],[50,6,50,10]]}
["Customer References"]
[]
["Customer references will be contacted to confirm the details in company experience"]
["Please limit the number of company references to six.  You must at least add one reference.   The references, together must cover the Company Experience detail."]
[]
["Customer Reference One - Name",null,null,"Reference(s) Name(s)",null,null,"Customer Reference Two - Name",null,null,"Reference(s) Name(s)"]
[]
[{"$nulls":3},"Email address(es)",{"$nulls":5},"Email address(es)"]
[]
["Number of Users","From\n(Year)","To\n(Year)","Mobile number s)",null,null,"Number of Users","From\n(Year)","To\n(Year)","Mobile number s)"]
[]
["Indicate which of the services listed in company experience was provided to the client",{"$nulls":5},"Indicate which of the services listed in company experience was provided to the client"]
["Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management",null,null,"Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management"]
["Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management",null,null,"Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management"]
["Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway",null,null,"Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway"]
["Support and Administration PeopleTools",null,null,"Upgrading PeopleTools",null,null,"Support and Administration PeopleTools",null,null,"Upgrading PeopleTools"]
["Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases",null,null,"Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases"]
["Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux",null,null,"Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux"]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",{"$nulls":5},"Successfully maintaining high performance, highly available and up to date PeopleSoft environments "]
[]
[]
["Customer Reference Three - Name",null,null,"Reference(s) Name(s)",null,null,"Customer Reference Four - Name",null,null,"Reference(s) Name(s)"]
[]
[{"$nulls":3},"Email address(es)",{"$nulls":5},"Email address(es)"]
[]
["Number of Users","From\n(Year)","To\n(Year)","Mobile number s)",null,null,"Number of Users","From\n(Year)","To\n(Year)","Mobile number s)"]
[]
["Indicate which of the services listed in company experience was provided to the client",{"$nulls":5},"Indicate which of the services listed in company experience was provided to the client"]
["Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management",null,null,"Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management"]
["Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management",null,null,"Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management"]
["Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway",null,null,"Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway"]
["Support and Administration PeopleTools",null,null,"Upgrading PeopleTools",null,null,"Support and Administration PeopleTools",null,null,"Upgrading PeopleTools"]
["Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases",null,null,"Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases"]
["Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux",null,null,"Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux"]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",{"$nulls":5},"Successfully maintaining high performance, highly available and up to date PeopleSoft environments "]
[]
[]
["Customer Reference Five - Name",null,null,"Reference(s) Name(s)",null,null,"Customer Reference Six - Name",null,null,"Reference(s) Name(s)"]
[]
[{"$nulls":3},"Email address(es)",{"$nulls":5},"Email address(es)"]
[]
["Number of Users","From\n(Year)","To\n(Year)","Mobile number s)",null,null,"Number of Users","From\n(Year)","To\n(Year)","Mobile number s)"]
[]
["Indicate which of the services listed in company experience was provided to the client",{"$nulls":5},"Indicate which of the services listed in company experience was provided to the client"]
["Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management",null,null,"Support and Administration of PS Financial and Supply Chain Management",null,null,"Upgrading PS Financial and Supply Chain Management"]
["Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management",null,null,"Support and Administration of PeopleSoft Human Capital Management",null,null,"Upgrading PeopleSoft Human Capital Management"]
["Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway",null,null,"Support and Administration of PS HCM - Candidate Gateway",null,null,"Upgrading PS HCM - Candidate Gateway"]
["Support and Administration PeopleTools",null,null,"Upgrading PeopleTools",null,null,"Support and Administration PeopleTools",null,null,"Upgrading PeopleTools"]
["Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases",null,null,"Support and Administration of PS Customer Relationship Management",null,null,"Upgrading Oracle Databases"]
["Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux",null,null,"Support and Administration of Oracle Databases",null,null,"Upgrading Oracle Linux"]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",{"$nulls":5},"Successfully maintaining high performance, highly available and up to date PeopleSoft environments "]

{"sheet":"Primary Resource","index":7,"n_rows":30,"n_cols":12,"rows_kept":30,"merged":[[2,0,4,0],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,7,2,11],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11]]}
["Primary Resource"]
[]
["Oracle PeopleSoft Component and Associated Activity","Level of Expertise","Years of Experience","Score","Weight","Weight Score",null,"Weight Calculation\n(Not to be included in bidder submission template)"]
[null,"Weight","Weight",{"$nulls":4},"CSIR Capability","CSIR Capacity","Systems Criticality","Score","Weight"]
[null,{"v":0.9,"d":"90%"},{"v":0.1,"d":"10%"}]
["PeopleTools",null,null,{"$f":"IF(OR(B6=\"\",C6=\"\"),\"\",$B$5*VLOOKUP(B6,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C6,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"$f":"L6","v":{"v":0.06765327695560254,"d":"7%"}},{"$f":"IF(D6=\"\",\"\",D6*E6)","v":""},null,"Basic","Restricted","Critical",{"$f":"(IF(OR(H6=\"\",I6=\"\",J6=\"\"),\"\",(VLOOKUP(H6,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I6,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J6,Scoring!$E$18:$F$21,2,FALSE)))","v":8},{"$f":"IF(K6=\"\",\"\",$K6/SUM($K$6:$K$29))","v":{"v":0.06765327695560254,"d":"7%"}}]
["PS Application Server",null,null,{"$f":"IF(OR(B7=\"\",C7=\"\"),\"\",$B$5*VLOOKUP(B7,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C7,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.08456659619450317,"d":"8%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H7=\"\",I7=\"\",J7=\"\"),\"\",(VLOOKUP(H7,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I7,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J7,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.08456659619450317,"d":"8%"}]
["Integration Broker",null,null,{"$f":"IF(OR(B8=\"\",C8=\"\"),\"\",$B$5*VLOOKUP(B8,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C8,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.06765327695560254,"d":"7%"},"",null,"Basic","Restricted","Critical",{"$f":"(IF(OR(H8=\"\",I8=\"\",J8=\"\"),\"\",(VLOOKUP(H8,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I8,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J8,Scoring!$E$18:$F$21,2,FALSE)))","v":8},{"v":0.06765327695560254,"d":"7%"}]
["PS Webserver",null,null,{"$f":"IF(OR(B9=\"\",C9=\"\"),\"\",$B$5*VLOOKUP(B9,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C9,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.08456659619450317,"d":"8%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H9=\"\",I9=\"\",J9=\"\"),\"\",(VLOOKUP(H9,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I9,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J9,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.08456659619450317,"d":"8%"}]
["Oracle Databases",null,null,{"$f":"IF(OR(B10=\"\",C10=\"\"),\"\",$B$5*VLOOKUP(B10,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C10,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.07610993657505286,"d":"8%"},"",null,"None","Restricted","Critical",{"$f":"(IF(OR(H10=\"\",I10=\"\",J10=\"\"),\"\",(VLOOKUP(H10,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I10,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J10,Scoring!$E$18:$F$21,2,FALSE)))","v":9},{"v":0.07610993657505286,"d":"8%"}]
["Monitoring the ERP environment’s performance and availability",null,null,{"$f":"IF(OR(B11=\"\",C11=\"\"),\"\",$B$5*VLOOKUP(B11,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C11,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.04439746300211417,"d":"4%"},"",null,"Basic","Limited","High",{"$f":"(IF(OR(H11=\"\",I11=\"\",J11=\"\"),\"\",(VLOOKUP(H11,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I11,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J11,Scoring!$E$18:$F$21,2,FALSE)))","v":5.25},{"v":0.04439746300211417,"d":"4%"}]
["Performance tuning of the PS application components",null,null,{"$f":"IF(OR(B12=\"\",C12=\"\"),\"\",$B$5*VLOOKUP(B12,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C12,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.03805496828752643,"d":"4%"},"",null,"None","Restricted","Medium",{"$f":"(IF(OR(H12=\"\",I12=\"\",J12=\"\"),\"\",(VLOOKUP(H12,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I12,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J12,Scoring!$E$18:$F$21,2,FALSE)))","v":4.5},{"v":0.03805496828752643,"d":"4%"}]
["Performance tuning of the Oracle databases",null,null,{"$f":"IF(OR(B13=\"\",C13=\"\"),\"\",$B$5*VLOOKUP(B13,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C13,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02959830866807611,"d":"3%"},"",null,"Basic","Limited","Medium",{"$f":"(IF(OR(H13=\"\",I13=\"\",J13=\"\"),\"\",(VLOOKUP(H13,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I13,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J13,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.02959830866807611,"d":"3%"}]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",null,null,{"$f":"IF(OR(B14=\"\",C14=\"\"),\"\",$B$5*VLOOKUP(B14,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C14,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.06342494714587738,"d":"6%"},"",null,"None","None","High",{"$f":"(IF(OR(H14=\"\",I14=\"\",J14=\"\"),\"\",(VLOOKUP(H14,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I14,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J14,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.06342494714587738,"d":"6%"}]
["Oracle Linux",null,null,{"$f":"IF(OR(B15=\"\",C15=\"\"),\"\",$B$5*VLOOKUP(B15,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C15,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02959830866807611,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H15=\"\",I15=\"\",J15=\"\"),\"\",(VLOOKUP(H15,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I15,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J15,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.02959830866807611,"d":"3%"}]
["Patching Peoplesoft Application Components",null,null,{"$f":"IF(OR(B16=\"\",C16=\"\"),\"\",$B$5*VLOOKUP(B16,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C16,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.042283298097251586,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H16=\"\",I16=\"\",J16=\"\"),\"\",(VLOOKUP(H16,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I16,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J16,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.042283298097251586,"d":"4%"}]
["Patching Oracle Databases",null,null,{"$f":"IF(OR(B17=\"\",C17=\"\"),\"\",$B$5*VLOOKUP(B17,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C17,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02959830866807611,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H17=\"\",I17=\"\",J17=\"\"),\"\",(VLOOKUP(H17,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I17,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J17,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.02959830866807611,"d":"3%"}]
["Patching Oracle Linux Servers, ",null,null,{"$f":"IF(OR(B18=\"\",C18=\"\"),\"\",$B$5*VLOOKUP(B18,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C18,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02536997885835095,"d":"3%"},"",null,"Proficient","Limited","Medium",{"$f":"(IF(OR(H18=\"\",I18=\"\",J18=\"\"),\"\",(VLOOKUP(H18,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I18,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J18,Scoring!$E$18:$F$21,2,FALSE)))","v":3},{"v":0.02536997885835095,"d":"3%"}]
["Backing up PS Applications, Oracle databases and Oracle Linux Servers",null,null,{"$f":"IF(OR(B19=\"\",C19=\"\"),\"\",$B$5*VLOOKUP(B19,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C19,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.012684989429175475,"d":"1%"},"",null,"Advanced","Dedicated","High",{"$f":"(IF(OR(H19=\"\",I19=\"\",J19=\"\"),\"\",(VLOOKUP(H19,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I19,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J19,Scoring!$E$18:$F$21,2,FALSE)))","v":1.5},{"v":0.012684989429175475,"d":"1%"}]
["Restoring Oracle database and databases tables",null,null,{"$f":"IF(OR(B20=\"\",C20=\"\"),\"\",$B$5*VLOOKUP(B20,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C20,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02536997885835095,"d":"3%"},"",null,"Proficient","Limited","Medium",{"$f":"(IF(OR(H20=\"\",I20=\"\",J20=\"\"),\"\",(VLOOKUP(H20,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I20,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J20,Scoring!$E$18:$F$21,2,FALSE)))","v":3},{"v":0.02536997885835095,"d":"3%"}]
["Disaster recovery simulations",null,null,{"$f":"IF(OR(B21=\"\",C21=\"\"),\"\",$B$5*VLOOKUP(B21,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C21,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.03805496828752643,"d":"4%"},"",null,"None","Restricted","Medium",{"$f":"(IF(OR(H21=\"\",I21=\"\",J21=\"\"),\"\",(VLOOKUP(H21,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I21,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J21,Scoring!$E$18:$F$21,2,FALSE)))","v":4.5},{"v":0.03805496828752643,"d":"4%"}]
["Major version upgrades for PS applications/components (PS HCM)",null,null,{"$f":"IF(OR(B22=\"\",C22=\"\"),\"\",$B$5*VLOOKUP(B22,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C22,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.042283298097251586,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H22=\"\",I22=\"\",J22=\"\"),\"\",(VLOOKUP(H22,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I22,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J22,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.042283298097251586,"d":"4%"}]
["Major version upgrades for PeopleTools",null,null,{"$f":"IF(OR(B23=\"\",C23=\"\"),\"\",$B$5*VLOOKUP(B23,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C23,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.042283298097251586,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H23=\"\",I23=\"\",J23=\"\"),\"\",(VLOOKUP(H23,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I23,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J23,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.042283298097251586,"d":"4%"}]
["Major version upgrades for Oracle Databases",null,null,{"$f":"IF(OR(B24=\"\",C24=\"\"),\"\",$B$5*VLOOKUP(B24,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C24,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.014799154334038054,"d":"1%"},"",null,"Proficient","Restricted","Low",{"$f":"(IF(OR(H24=\"\",I24=\"\",J24=\"\"),\"\",(VLOOKUP(H24,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I24,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J24,Scoring!$E$18:$F$21,2,FALSE)))","v":1.75},{"v":0.014799154334038054,"d":"1%"}]
["Major version upgrades for Oracle Linux",null,null,{"$f":"IF(OR(B25=\"\",C25=\"\"),\"\",$B$5*VLOOKUP(B25,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C25,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.014799154334038054,"d":"1%"},"",null,"Proficient","Restricted","Low",{"$f":"(IF(OR(H25=\"\",I25=\"\",J25=\"\"),\"\",(VLOOKUP(H25,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I25,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J25,Scoring!$E$18:$F$21,2,FALSE)))","v":1.75},{"v":0.014799154334038054,"d":"1%"}]
["Minor version upgrades for PS applications/components (PS HCM)",null,null,{"$f":"IF(OR(B26=\"\",C26=\"\"),\"\",$B$5*VLOOKUP(B26,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C26,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.042283298097251586,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H26=\"\",I26=\"\",J26=\"\"),\"\",(VLOOKUP(H26,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I26,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J26,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.042283298097251586,"d":"4%"}]
["Minor version upgrades for PeopleTools",null,null,{"$f":"IF(OR(B27=\"\",C27=\"\"),\"\",$B$5*VLOOKUP(B27,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C27,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.042283298097251586,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H27=\"\",I27=\"\",J27=\"\"),\"\",(VLOOKUP(H27,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I27,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J27,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"$f":"IF(K27=\"\",\"\",$K27/SUM($K$6:$K$29))","v":{"v":0.042283298097251586,"d":"4%"}}]
["Minor version upgrades for Oracle Databases",null,null,{"$f":"IF(OR(B28=\"\",C28=\"\"),\"\",$B$5*VLOOKUP(B28,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C28,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02959830866807611,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H28=\"\",I28=\"\",J28=\"\"),\"\",(VLOOKUP(H28,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I28,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J28,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"$f":"IF(K28=\"\",\"\",$K28/SUM($K$6:$K$29))","v":{"v":0.02959830866807611,"d":"3%"}}]
["Deploying Oracle Linux servers on VMware and configuring VMware to meet server requirements",null,null,{"$f":"IF(OR(B29=\"\",C29=\"\"),\"\",$B$5*VLOOKUP(B29,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C29,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.012684989429175475,"d":"1%"},"",null,"Proficient","Limited","Low",{"$f":"(IF(OR(H29=\"\",I29=\"\",J29=\"\"),\"\",(VLOOKUP(H29,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I29,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J29,Scoring!$E$18:$F$21,2,FALSE)))","v":1.5},{"v":0.012684989429175475,"d":"1%"}]
[{"$nulls":4},"Total Score\nout of 10",{"$f":"SUM(F6:F29)","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"SUM(L6:L29)","v":{"v":1,"d":"100%"}}]

{"sheet":"Secondary Resource","index":8,"n_rows":30,"n_cols":12,"rows_kept":30,"merged":[[2,0,4,0],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,7,2,11],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11]]}
["Secondary Resource"]
[]
["Oracle PeopleSoft Component and Associated Activity","Level of Expertise","Years of Experience","Score","Weight","Weight Score",null,"Weight Calculation\n(Not to be included in bidder submission template)"]
[null,"Weight","Weight",{"$nulls":4},"CSIR Capability","CSIR Capacity","Systems Criticality","Score","Weight"]
[null,{"v":0.9,"d":"90%"},{"v":0.1,"d":"10%"}]
["PeopleTools",null,null,{"$f":"IF(OR(B6=\"\",C6=\"\"),\"\",$B$5*VLOOKUP(B6,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C6,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"$f":"L6","v":{"v":0.0636182902584493,"d":"6%"}},{"$f":"IF(D6=\"\",\"\",D6*E6)","v":""},null,"Basic","Restricted","Critical",{"$f":"(IF(OR(H6=\"\",I6=\"\",J6=\"\"),\"\",(VLOOKUP(H6,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I6,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J6,Scoring!$E$18:$F$21,2,FALSE)))","v":8},{"$f":"IF(K6=\"\",\"\",$K6/SUM($K$6:$K$29))","v":{"v":0.0636182902584493,"d":"6%"}}]
["PS Application Server",null,null,{"$f":"IF(OR(B7=\"\",C7=\"\"),\"\",$B$5*VLOOKUP(B7,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C7,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.07952286282306163,"d":"8%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H7=\"\",I7=\"\",J7=\"\"),\"\",(VLOOKUP(H7,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I7,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J7,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.07952286282306163,"d":"8%"}]
["Integration Broker",null,null,{"$f":"IF(OR(B8=\"\",C8=\"\"),\"\",$B$5*VLOOKUP(B8,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C8,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.0636182902584493,"d":"6%"},"",null,"Basic","Restricted","Critical",{"$f":"(IF(OR(H8=\"\",I8=\"\",J8=\"\"),\"\",(VLOOKUP(H8,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I8,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J8,Scoring!$E$18:$F$21,2,FALSE)))","v":8},{"v":0.0636182902584493,"d":"6%"}]
["PS Webserver",null,null,{"$f":"IF(OR(B9=\"\",C9=\"\"),\"\",$B$5*VLOOKUP(B9,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C9,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.07952286282306163,"d":"8%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H9=\"\",I9=\"\",J9=\"\"),\"\",(VLOOKUP(H9,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I9,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J9,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.07952286282306163,"d":"8%"}]
["Oracle Databases",null,null,{"$f":"IF(OR(B10=\"\",C10=\"\"),\"\",$B$5*VLOOKUP(B10,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C10,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.07157057654075547,"d":"7%"},"",null,"None","Restricted","Critical",{"$f":"(IF(OR(H10=\"\",I10=\"\",J10=\"\"),\"\",(VLOOKUP(H10,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I10,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J10,Scoring!$E$18:$F$21,2,FALSE)))","v":9},{"v":0.07157057654075547,"d":"7%"}]
["Monitoring the ERP environment’s performance and availability",null,null,{"$f":"IF(OR(B11=\"\",C11=\"\"),\"\",$B$5*VLOOKUP(B11,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C11,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.041749502982107355,"d":"4%"},"",null,"Basic","Limited","High",{"$f":"(IF(OR(H11=\"\",I11=\"\",J11=\"\"),\"\",(VLOOKUP(H11,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I11,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J11,Scoring!$E$18:$F$21,2,FALSE)))","v":5.25},{"v":0.041749502982107355,"d":"4%"}]
["Performance tuning of the PS application components",null,null,{"$f":"IF(OR(B12=\"\",C12=\"\"),\"\",$B$5*VLOOKUP(B12,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C12,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.03578528827037773,"d":"4%"},"",null,"None","Restricted","Medium",{"$f":"(IF(OR(H12=\"\",I12=\"\",J12=\"\"),\"\",(VLOOKUP(H12,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I12,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J12,Scoring!$E$18:$F$21,2,FALSE)))","v":4.5},{"v":0.03578528827037773,"d":"4%"}]
["Performance tuning of the Oracle databases",null,null,{"$f":"IF(OR(B13=\"\",C13=\"\"),\"\",$B$5*VLOOKUP(B13,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C13,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.027833001988071572,"d":"3%"},"",null,"Basic","Limited","Medium",{"$f":"(IF(OR(H13=\"\",I13=\"\",J13=\"\"),\"\",(VLOOKUP(H13,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I13,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J13,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.027833001988071572,"d":"3%"}]
["Successfully maintaining high performance, highly available and up to date PeopleSoft environments ",null,null,{"$f":"IF(OR(B14=\"\",C14=\"\"),\"\",$B$5*VLOOKUP(B14,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C14,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.07952286282306163,"d":"8%"},"",null,"None","None","Critical",{"$f":"(IF(OR(H14=\"\",I14=\"\",J14=\"\"),\"\",(VLOOKUP(H14,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I14,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J14,Scoring!$E$18:$F$21,2,FALSE)))","v":10},{"v":0.07952286282306163,"d":"8%"}]
["Oracle Linux",null,null,{"$f":"IF(OR(B15=\"\",C15=\"\"),\"\",$B$5*VLOOKUP(B15,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C15,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.027833001988071572,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H15=\"\",I15=\"\",J15=\"\"),\"\",(VLOOKUP(H15,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I15,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J15,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.027833001988071572,"d":"3%"}]
["Patching Peoplesoft Application Components",null,null,{"$f":"IF(OR(B16=\"\",C16=\"\"),\"\",$B$5*VLOOKUP(B16,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C16,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.039761431411530816,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H16=\"\",I16=\"\",J16=\"\"),\"\",(VLOOKUP(H16,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I16,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J16,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.039761431411530816,"d":"4%"}]
["Patching Oracle Databases",null,null,{"$f":"IF(OR(B17=\"\",C17=\"\"),\"\",$B$5*VLOOKUP(B17,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C17,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.027833001988071572,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H17=\"\",I17=\"\",J17=\"\"),\"\",(VLOOKUP(H17,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I17,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J17,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"v":0.027833001988071572,"d":"3%"}]
["Patching Oracle Linux Servers, ",null,null,{"$f":"IF(OR(B18=\"\",C18=\"\"),\"\",$B$5*VLOOKUP(B18,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C18,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02385685884691849,"d":"2%"},"",null,"Proficient","Limited","Medium",{"$f":"(IF(OR(H18=\"\",I18=\"\",J18=\"\"),\"\",(VLOOKUP(H18,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I18,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J18,Scoring!$E$18:$F$21,2,FALSE)))","v":3},{"v":0.02385685884691849,"d":"2%"}]
["Backing up PS Applications, Oracle databases and Oracle Linux Servers",null,null,{"$f":"IF(OR(B19=\"\",C19=\"\"),\"\",$B$5*VLOOKUP(B19,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C19,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.011928429423459244,"d":"1%"},"",null,"Advanced","Dedicated","High",{"$f":"(IF(OR(H19=\"\",I19=\"\",J19=\"\"),\"\",(VLOOKUP(H19,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I19,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J19,Scoring!$E$18:$F$21,2,FALSE)))","v":1.5},{"v":0.011928429423459244,"d":"1%"}]
["Restoring Oracle database and databases tables",null,null,{"$f":"IF(OR(B20=\"\",C20=\"\"),\"\",$B$5*VLOOKUP(B20,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C20,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.02385685884691849,"d":"2%"},"",null,"Proficient","Limited","Medium",{"$f":"(IF(OR(H20=\"\",I20=\"\",J20=\"\"),\"\",(VLOOKUP(H20,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I20,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J20,Scoring!$E$18:$F$21,2,FALSE)))","v":3},{"v":0.02385685884691849,"d":"2%"}]
["Disaster recovery simulations",null,null,{"$f":"IF(OR(B21=\"\",C21=\"\"),\"\",$B$5*VLOOKUP(B21,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C21,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.03578528827037773,"d":"4%"},"",null,"None","Restricted","Medium",{"$f":"(IF(OR(H21=\"\",I21=\"\",J21=\"\"),\"\",(VLOOKUP(H21,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I21,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J21,Scoring!$E$18:$F$21,2,FALSE)))","v":4.5},{"v":0.03578528827037773,"d":"4%"}]
["Major version upgrades for PS applications/components (PS HCM)",null,null,{"$f":"IF(OR(B22=\"\",C22=\"\"),\"\",$B$5*VLOOKUP(B22,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C22,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.039761431411530816,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H22=\"\",I22=\"\",J22=\"\"),\"\",(VLOOKUP(H22,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I22,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J22,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"v":0.039761431411530816,"d":"4%"}]
["Major version upgrades for PeopleTools",null,null,{"$f":"IF(OR(B23=\"\",C23=\"\"),\"\",$B$5*VLOOKUP(B23,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C23,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.05964214711729622,"d":"6%"},"",null,"None","None","High",{"$f":"(IF(OR(H23=\"\",I23=\"\",J23=\"\"),\"\",(VLOOKUP(H23,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I23,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J23,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.05964214711729622,"d":"6%"}]
["Major version upgrades for Oracle Databases",null,null,{"$f":"IF(OR(B24=\"\",C24=\"\"),\"\",$B$5*VLOOKUP(B24,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C24,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.013916500994035786,"d":"1%"},"",null,"Proficient","Restricted","Low",{"$f":"(IF(OR(H24=\"\",I24=\"\",J24=\"\"),\"\",(VLOOKUP(H24,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I24,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J24,Scoring!$E$18:$F$21,2,FALSE)))","v":1.75},{"v":0.013916500994035786,"d":"1%"}]
["Major version upgrades for Oracle Linux",null,null,{"$f":"IF(OR(B25=\"\",C25=\"\"),\"\",$B$5*VLOOKUP(B25,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C25,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.013916500994035786,"d":"1%"},"",null,"Proficient","Restricted","Low",{"$f":"(IF(OR(H25=\"\",I25=\"\",J25=\"\"),\"\",(VLOOKUP(H25,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I25,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J25,Scoring!$E$18:$F$21,2,FALSE)))","v":1.75},{"v":0.013916500994035786,"d":"1%"}]
["Minor version upgrades for PS applications/components (PS HCM)",null,null,{"$f":"IF(OR(B26=\"\",C26=\"\"),\"\",$B$5*VLOOKUP(B26,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C26,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.05964214711729622,"d":"6%"},"",null,"None","None","High",{"$f":"(IF(OR(H26=\"\",I26=\"\",J26=\"\"),\"\",(VLOOKUP(H26,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I26,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J26,Scoring!$E$18:$F$21,2,FALSE)))","v":7.5},{"v":0.05964214711729622,"d":"6%"}]
["Minor version upgrades for PeopleTools",null,null,{"$f":"IF(OR(B27=\"\",C27=\"\"),\"\",$B$5*VLOOKUP(B27,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C27,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.039761431411530816,"d":"4%"},"",null,"None","None","Medium",{"$f":"(IF(OR(H27=\"\",I27=\"\",J27=\"\"),\"\",(VLOOKUP(H27,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I27,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J27,Scoring!$E$18:$F$21,2,FALSE)))","v":5},{"$f":"IF(K27=\"\",\"\",$K27/SUM($K$6:$K$29))","v":{"v":0.039761431411530816,"d":"4%"}}]
["Minor version upgrades for Oracle Databases",null,null,{"$f":"IF(OR(B28=\"\",C28=\"\"),\"\",$B$5*VLOOKUP(B28,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C28,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.027833001988071572,"d":"3%"},"",null,"Proficient","Restricted","Medium",{"$f":"(IF(OR(H28=\"\",I28=\"\",J28=\"\"),\"\",(VLOOKUP(H28,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I28,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J28,Scoring!$E$18:$F$21,2,FALSE)))","v":3.5},{"$f":"IF(K28=\"\",\"\",$K28/SUM($K$6:$K$29))","v":{"v":0.027833001988071572,"d":"3%"}}]
["Deploying Oracle Linux servers on VMware and configuring VMware to meet server requirements",null,null,{"$f":"IF(OR(B29=\"\",C29=\"\"),\"\",$B$5*VLOOKUP(B29,Scoring!$A$11:$B$15,2,FALSE)+$C$5*VLOOKUP(C29,Scoring!$A$4:$B$8,2,FALSE))","v":""},{"v":0.011928429423459244,"d":"1%"},"",null,"Proficient","Limited","Low",{"$f":"(IF(OR(H29=\"\",I29=\"\",J29=\"\"),\"\",(VLOOKUP(H29,Scoring!$E$4:$F$8,2,FALSE)+VLOOKUP(I29,Scoring!$E$11:$F$15,2,FALSE))*VLOOKUP(J29,Scoring!$E$18:$F$21,2,FALSE)))","v":1.5},{"v":0.011928429423459244,"d":"1%"}]
[{"$nulls":4},"Total Score\nout of 10",{"$f":"SUM(F6:F29)","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"SUM(L6:L29)","v":{"v":0.9999999999999999,"d":"100%"}}]

{"sheet":"Elective Company Commitment","index":9,"n_rows":24,"n_cols":4,"rows_kept":24,"merged":[[2,0,3,0],[2,2,3,2]]}
["Elective Company Commitment"]
[]
["Scope of Work Cross Reference","Responsibilities/Activities","Weight","Yes"]
[null,"Bidders shall reference the detailed descriptions of the responsibilities/activities in the cross-referenced section of the RFP",null,"No"]
["B.3.2.1","Support and Administration",{"$f":"SUM(C6:C11)","v":{"v":0.38999999999999996,"d":"39%"}}]
["B.3.2.1.h","Participating in audits by providing required artefacts, coordinating and gathering the needed information and being available to answer the auditors' questions.",{"v":0.03,"d":"3%"}]
["B.3.2.1.i","Advanced troubleshooting and problem-solving specifically tailored to handle bespoke configurations within and between PeopleSoft and interfacing systems whether documented or not.",{"v":0.15,"d":"15%"}]
["B.3.2.1.j","Deploying new and transitory PeopleSoft and Oracle database instances as required.",{"v":0.03,"d":"3%"}]
["B.3.2.1.k","Participating in deploying new PeopleSoft functionality and taking responsibility for PeopleSoft application administration activities.",{"v":0.03,"d":"3%"}]
["B.3.2.1.l","Producing innovative ways to improve the performance and availability of the environment, automate activities and processes and process reviews.",{"v":0.1,"d":"10%"}]
["B.3.2.1.m","Documenting and maintaining scripts, configurations, procedures and work instructions. Creating and maintaining design documents (requirements and solutions design).",{"v":0.05,"d":"5%"}]
["B.3.2.2","Upgrades and Patching",{"$f":"SUM(C13:C18)","v":{"v":0.46,"d":"46%"}}]
["B.3.2.2.a","Planning upgrades and patching by assessing and evaluating new releases for the system and technology stack components, including the database, operating system, application servers, and related software.",{"v":0.1,"d":"10%"}]
["B.3.2.2.b","Coordinating upgrades with relevant stakeholders, including application owners, infrastructure teams, and business users, to schedule and execute the upgrade process.",{"v":0.03,"d":"3%"}]
["B.3.2.2.c","Executing the upgrades without unplanned business disruption and performing post-upgrade/patch monitoring to address any issues or fine-tune configurations as needed.",{"v":0.15,"d":"15%"}]
["B.3.2.2.d","Conducting comprehensive testing for all instances, including functional testing, performance testing, and security assessments, to ensure the upgrades are stable and meet the expected quality standards.",{"v":0.03,"d":"3%"}]
["B.3.2.2.e","Advanced setup, configuration and troubleshooting of bespoke configuration that integrates between PeopleSoft sub-systems and interfacing systems whether documented or not.",{"v":0.1,"d":"10%"}]
["B.3.2.2.f","Documenting and maintaining requirements specifications and solutions designs.",{"v":0.05,"d":"5%"}]
["B.3.2.3","Collaboration and Communication",{"$f":"SUM(C20:C21)","v":{"v":0.1,"d":"10%"}}]
["B.3.2.3.b","Draw up and communicate a maintenance and release plan for the environment and report progress against the plan monthly.",{"v":0.05,"d":"5%"}]
["B.3.2.3.c","Provide proactive and timeous alerts, reporting, updates, and feedback to stakeholders.",{"v":0.05,"d":"5%"}]
["B.3.2.4","Logistics",{"$f":"(C23)","v":{"v":0.05,"d":"5%"}}]
["B.3.2.4.i","Resource/s must be able to work remotely and on-site as and when required.",{"v":0.05,"d":"5%"}]
[null,null,"Total Score\nout of 10",{"$f":"SUMIFS(C6:C11,D6:D11,\"Yes\")*10+SUMIFS(C13:C18,D13:D18,\"Yes\")*10+SUMIFS(C20:C21,D20:D21,\"Yes\")*10+SUMIFS(C23:C23,D23:D23,\"Yes\")*10","v":0}]

{"sheet":"Transition-Continuation Plan","index":10,"n_rows":34,"n_cols":4,"rows_kept":34,"merged":[[2,0,3,0],[2,3,3,3]]}
["Transition/Continuation Plan"]
[]
["Transition/Continuation Plan Cross Reference","Transition/Continuation Plan","Weight","Score"]
[null,"The transition/continuation plan must include at least the three project plan elements","Evaluation"]
["B.3.4 (i)","Project Schedule in the form of a GANTT chart\nThe project schedule must include at least the following elements/charateristics\n",{"v":0.6,"d":"60%"},{"$f":"IF(ISERROR(AVERAGE(D6:D12)),\"\",AVERAGE(D6:D12))","v":""}]
[null,"Project Schedule is in the form of a Gantt chart.",null,{"$f":"IF(ISERROR(VLOOKUP(C6,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C6,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"Tasks/activities that at least:\n•  Indicates the creation of the main components that make up deliverables (Please see examples listed below)\n•  Clearly distinguish between tasks to be completed in parallel with the current incumbent (maximum 20 days) and tasks to be completed after the current incumbent has exited",null,{"$f":"IF(ISERROR(VLOOKUP(C7,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C7,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"Summary tasks or milestones that indicate which activities provide at least the following outputs:\n•  Stakeholder analysis\n•  As-is configuration documentation\n•  Taking on CSIR service management disciplines/requirements\n•  Taking on CSIR's compliance requirements\n•  Taking over system maintenance, support and operations of production and non-production environments",null,{"$f":"IF(ISERROR(VLOOKUP(C8,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C8,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"Task dependencies",null,{"$f":"IF(ISERROR(VLOOKUP(C9,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C9,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"Task durations - (If required, the bidder may use any arbitrary start date to indicate durations)",null,{"$f":"IF(ISERROR(VLOOKUP(C10,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C10,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"Responsible role(s) and institution(s) for eash task",null,{"$f":"IF(ISERROR(VLOOKUP(C11,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C11,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"The bidder can independently deliver of the transition plan.",null,{"$f":"IF(ISERROR(VLOOKUP(C12,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C12,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
["B.3.4 (ii)","Assumptions\nDetail all assumptions critical to deliver the transition plan on brief, on budget and on time (OB²OT)\nIn the event where there are no assumptions, the transition plan must state \"No Assumptions\"",{"v":0.1,"d":"10%"},{"$f":"IF(ISERROR(AVERAGE(D14:D15)),\"\",AVERAGE(D14:D15))","v":""}]
[null,"There are no assumptions that indicate a reliance on the CSIR, or any other third party, to deliver on the transition plan other than providing access to information currently available.",null,{"$f":"IF(ISERROR(VLOOKUP(C14,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C14,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"None of the assumptions indicates a limitation in terms of delivery of the transition plan.",null,{"$f":"IF(ISERROR(VLOOKUP(C15,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C15,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
["B.3.4 (iii)","Risk Plan\n1) Detail the risks in terms of:\nA description of the risk detailing cause and effect linking the two clauses by a phrase such as “leads to (directing or provoking and outcome)”; “causing (Unstoppable forced immediate outcome)’; “results in (Influence the outcome)” (without using conditional terms like “might”; “may”; “could”). State the cause as an event, or as a set of conditions. \n2} Risk mitigation plan commensurate with the risk response\n",{"v":0.3,"d":"30%"},{"$f":"IF(ISERROR(AVERAGE(D17:D20)),\"\",AVERAGE(D17:D20))","v":""}]
[null,"Risk(s) detail the cause and effect and link the two clauses by the prescribed phases.",null,{"$f":"IF(ISERROR(VLOOKUP(C17,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C17,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"The risk mitigation plans effectively reduce the risks to an acceptable level.",null,{"$f":"IF(ISERROR(VLOOKUP(C18,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C18,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"The risk plan includes the risks associated with:\n•   Inadequate overlap between exiting incumbent and successful bidder to gather required information\n•   Reliance on current and past incumbents to resolve issues\n•   A lack of information assumed to be available",null,{"$f":"IF(ISERROR(VLOOKUP(C19,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C19,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,"The risk mitigation plans effectively reduce the risks to an acceptable level.",null,{"$f":"IF(ISERROR(VLOOKUP(C20,Scoring!$A$25:$B$27,2,FALSE)),\"\",VLOOKUP(C20,Scoring!$A$25:$B$27,2,FALSE))","v":""}]
[null,null,"Total Score out of 10",{"$f":"IF(ISERROR(SUM(C5*D5,C13*D13,C16*D16)),0,SUM(C5*D5,C13*D13,C16*D16))","v":{"v":0,"d":"0.0"}}]
[]
[]
[null,"Examples of Components that make up deliverables"]
[null,"Stakeholder analysis"]
[null,"•  RACI\n•  Stakeholder Analysis\n•  Escalation Paths"]
[null,"As-is implemented configuration"]
[null,"•  Technology Stack\n•  Integration Documentation\n•  Environment-specific Configuration Documents\n•  Standards & Naming Conventions"]
[null,"Service Management"]
[null,"•  SLA\n•  Incident, Request & Problem Managements SOP's"]
[null,"Compliance Requirements"]
[null,"•  Change Control Procedures\n•  Information Security Requirements\n•  Privacy Requirements\n•  Audit Requirements"]
[null,"System Maintenance & Operations of Production and Non-production environments"]
[null,"•  Backup Schedules\n•  Operating System Maintenance\n•  Database Patching Schedules\n•  Upgrades\n•  Disaster Recovery Procedures\n•  Performance Benchmarking"]