{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Mandatory Criteria","Recommended Criteria","Criteria Vendor A","Criteria Vendor B","Criteria Vendor C","Criteria Vendor D","Criteria Vendor E","Weighted Decision"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"How to use this procurement spreadsheet"]
[]
["1. ","Create a copy of the template. Go to File -> Save As and click on Browse to navigate to the folder the document will be saved in. Give the file a name and click Save."]
["2.","Add mandatory and recommended criteria to Criteria Vendor A tab. Sample criteria can be found on the Mandatory Criteria and Recommended Criteria tabs. The cells from the Mandatory and Recommended Criteria tabs can be copied and pasted into the Criteria Vendor A tab. The data will then be pulled into the other vendor tabs automatically. The criteria names on the Weighted Decision tab will also be pulled in automatically."]
["3.","When needing to insert an additional row in either the mandatory or recommended tables on the vendor tabs, please ensure to click the Add line to mandatory or Add line to recommended link found at the top of the Criteria Vendor A tab. This will add one line to the table on each vendor tab, as well as the appropriate table on the Weighted Decision tab."]
["4.","For each vendor place an x in the column of the satisfaction level that corresponds to the criterion. For example if the vendor meets the Good outcome, an x will be placed in the Good column. This will then calculate the points awarded for that criterion. The points awarded will be pulled in automatically to the Weighted Decision tab. If a criterion scores a Seriously Deficient the line will highlight in red as a warning that the vendor should not be considered."]
["5.","The appropriate weighting of each criterion needs to be updated on the Weighted Decision tab. The weighting of all the criteria needs to add up to 100%. There is error checking on the tab, and if the percentages do not equal 100% a warning will appear and the column will display in red."]
["6.","The total score for each vendor appears in the last row on the Weighted Decision tab. This score will help to distinguish which vendors should be considered."]

{"sheet":"Mandatory Criteria","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,5],[6,0,6,5],[8,0,8,5]]}
[]
[]
[]
[]
[]
["Suggested Mandatory Criteria"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points"]
[null,"MANDATORY CRITERIA"]
["NF15","Mandatory Criteria","DATA INTERFACE","YG would like to be able to interface the proposed system with other systems for data interchange using published interfaces.\n\nYG expects the proposal to explain what type of interface is included with the system, provide the documentation for one such interface, and describe applications where the provided interfaces are used to interchange between the proposed system and other systems.","Acceptable (MANDATORY THRESHOLD): The proposed system has documented application programming interfaces for importing and exporting data.\n\nExcellent: The proposed system has documented RESTful web services for importing and exporting data.",800]
["NF15A","Mandatory Criteria","DATA INTERFACE EXTENT","YG would like to be able to interface the proposed system with other systems for data interchange using web services. Having a wide range such web services available is important to YG.\n\nYG expects the proposal to show how much of the system functionality is available via documented web services. A complete listing would be an effective way to do this.\n\n(This is a new requirement, but it makes sense for it to follow NF15 which already exists.)","Seriously Deficient: Less than 60% of the system functionality is available via documented web services.\n\nAcceptable: At least 60% of the system functionality is available via documented web services.\n\nGood: At least 80% of the system functionality is available via documented RESTful web\nservices.\n\nExcellent: 100% of the system functionality is available via documented RESTful web services.",800]
["NF21","Mandatory Criteria","IDENTITY AND ACCESS MANAGEMENT FOR EXTERNAL USERS OR CUSTOMERS","YG would like use modern, flexible, approaches for external user identity and access management. This includes things like account creation, profile management, and authentication.\n\nYG expects the proposal to explain what type of user and account management capability is included with the system, provide the documentation for any methods or protocols used, and examples where the provided methods or protocols have been used previously.","Seriously Deficient: The system uses only internal database authentication for external user and access management\n\nAcceptable (MANDATORY THRESHOLD): The proposed system supports commonly used external user management and authentication sources such as LDAP.\n\nGood: The proposed system supports one or more of the following authentication protocols and the proponent can provide current examples of where these protocols are used :\n– SAML/SAML2\n– OAuth\n– OAuth2\n– OpenID Connect\n\nExcellent: The proposed system supports one or more of the following authentication protocols\nand the proponent can provide current examples of where these protocols are used :\n– SAML/SAML2\n– OAuth\n– OAuth2\n– OpenID Connect\nAND the proponent provide can provide examples of where the proposed system has implemented multi factor authentication for user authentication.",800]
["NF26","Mandatory Criteria","USER RESEARCH","YG expects a plan to conduct ongoing user research and usability testing of the service.","Seriously Deficient: There is no plan for ongoing user research.\n\nAcceptable: Proponent can supply a record of user research used to guide the original development of the user interface.\n\nExcellent: Proponent both supplies a record of user research used to guide the original development and provides a plan for incorporating ongoing user research into the implementation plan.",800]
["NF27","Mandatory Criteria","SIMPLE, SHAREABLE URLS","YG expects that separate parts of the proposed system are separately addressable (i.e., it is possible to bookmark specific pages). Most meaningful PUBLIC application state can be captured in the URL.","Seriously Deficient: Pages are only accessible via opaque, inscrutable, or impermanent URLs.\n\nAcceptable (MANDATORY THRESHOLD): The majority of task entry pages have permanent URLs.\n\nExcellent: All task entry pages have meaningful and permanent URLs. A meaningful URL is one that can be remembered, all but for one or two state variable values.",600]
["NF28","Mandatory Criteria","ENGLISH AND FRENCH","YG expects all services to be available to the PUBLIC in both English and French, equivalently.","Seriously Deficient: Public content and features are delivered in only one language.\n\nAcceptable (MANDATORY THRESHOLD): Public content and features are delivered in both English and French.\n\nExcellent: Public content and features are devliered in both English and French, including all artifacts (e.g., email, images, PDFs). Administration of translations can be completed by non-developers. The proposed service captures and remembers the user's language of choice.",1000]
["NF29","Mandatory Criteria","ACCESSIBILITY","YG expects all services to be accessible to all users regardless of their ability and environment.\n\nYG strives for compliance with Web Content Accessibility Guidelines (WCAG) 2.0, Level AA.","Seriously Deficient: Content and features are not compliant with at least the WCAG 2.0 standard.\n\nAcceptable (MANDATORY THRESHOLD): Content and features are compliant with the WCAG 2.0 Level A standard.\n\nGood: Content and features are compliant with the WCAG 2.0 Level AA standard, or better.\n\nExcellent: The proposed system can directly integrate the Yukon.ca design system (Bootstrap 4/Drupal 8 theme; or HTML, CSS, and JavaScript) and is therefore compliant with the WCAG 2.0 Level AA standard.",1000]
["NF30","Mandatory Criteria","PERFORMANCE DATA","YG expects to collect performance data and establish benchmarks in order to measure key performance indicators for the service.","Seriously Deficient: The proposed system does not report transaction-level or web page hit statistics.\n\nAcceptable (MANDATORY THRESHOLD): The proposed system reports raw or context-free transaction-level or web page hit statistics.\n\nExcellent: The proposed system reports both raw transaction and web page hit statistics along with meaningful user-action level timing and counting metrics. The PUBLIC interface of the proposed system can integrate with YG's Matomo web analytics system via embedded JavaScript tracker code.",800]
["NF31","Mandatory Criteria","CHANGE MANAGEMENT","For YG-hosted systems, YG expects to be able to manage the promotion of code and configuration changes through development, user acceptance testing, and production environments.","Seriously Deficient: The proposed system does not provide for a non-production version of the system to be used for testing.\n\nAcceptable (MANDATORY THRESHOLD): The proposed system allows for manual configurations of a non-production version of the system.\n\nExcellent: The proposed system allows for scripted migrations and point-in-time source code deployments to move one or more non-production systems forwards or backwards through a history of patch-level version deliveries.",600]

{"sheet":"Recommended Criteria","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,5],[6,0,6,5],[8,0,8,5]]}
[]
[]
[]
[]
[]
["Suggested Recommended Criteria"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. "]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points"]
[null,"RECOMMENDED CRITERIA"]
[null,"Recommended Criteria","CRITERIA NAME",null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: ",800]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: ",800]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Recommended Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]
[null,"Mandatory Criteria",null,null,"Seriously Deficient: \n\nAcceptable: \n\nGood: \n\nExcellent: "]

{"sheet":"Criteria Vendor A","index":3,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,0,5,10],[6,0,6,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["eServices amendments to PLRA Appendix A: Non-Functional Requirements"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
["Add line to Mandatory"]
["Add line to Recommended"]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points","Seriously Deficient","Acceptable","Good","Excellent","Points Awarded"]
[null,"MANDATORY CRITERIA"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G15=\"x\",F15*0, IF(H15=\"x\",F15*0.5, IF(I15=\"x\",F15*0.7, IF(J15=\"x\",F15, 0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G16=\"x\",F16*0, IF(H16=\"x\",F16*0.5, IF(I16=\"x\",F16*0.7, IF(J16=\"x\",F16, 0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"RECOMMENDED CRITERIA"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21=\"x\",F21*0, IF(H21=\"x\",F21*0.5, IF(I21=\"x\",F21*0.7, IF(J21=\"x\",F21, 0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G22=\"x\",F22*0, IF(H22=\"x\",F22*0.5, IF(I22=\"x\",F22*0.7, IF(J22=\"x\",F22, 0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G23=\"x\",F23*0, IF(H23=\"x\",F23*0.5, IF(I23=\"x\",F23*0.7, IF(J23=\"x\",F23, 0))))","v":0}]

{"sheet":"Criteria Vendor B","index":4,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,10],[6,0,6,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["eServices amendments to PLRA Appendix A: Non-Functional Requirements"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points","Seriously Deficient","Acceptable","Good","Excellent","Points Awarded"]
[null,"MANDATORY CRITERIA"]
[{"$f":"'Criteria Vendor A'!A15","v":0},{"$f":"'Criteria Vendor A'!B15","v":0},{"$f":"'Criteria Vendor A'!C15","v":0},{"$f":"'Criteria Vendor A'!D15","v":0},{"$f":"'Criteria Vendor A'!E15","v":0},{"$f":"'Criteria Vendor A'!F15","v":0},null,null,null,null,{"$f":"IF(G13=\"x\",F13*0, IF(H13=\"x\",F13*0.5, IF(I13=\"x\",F13*0.7, IF(J13=\"x\",F13, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A16","v":0},{"$f":"'Criteria Vendor A'!B16","v":0},{"$f":"'Criteria Vendor A'!C16","v":0},{"$f":"'Criteria Vendor A'!D16","v":0},{"$f":"'Criteria Vendor A'!E16","v":0},{"$f":"'Criteria Vendor A'!F16","v":0},null,null,null,null,{"$f":"IF(G14=\"x\",F14*0, IF(H14=\"x\",F14*0.5, IF(I14=\"x\",F14*0.7, IF(J14=\"x\",F14, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A17","v":0},{"$f":"'Criteria Vendor A'!B17","v":0},{"$f":"'Criteria Vendor A'!C17","v":0},{"$f":"'Criteria Vendor A'!D17","v":0},{"$f":"'Criteria Vendor A'!E17","v":0},{"$f":"'Criteria Vendor A'!F17","v":0},null,null,null,null,0]
[]
[]
[null,"RECOMMENDED CRITERIA"]
[{"$f":"'Criteria Vendor A'!A21","v":0},{"$f":"'Criteria Vendor A'!B21","v":0},{"$f":"'Criteria Vendor A'!C21","v":0},{"$f":"'Criteria Vendor A'!D21","v":0},{"$f":"'Criteria Vendor A'!E21","v":0},{"$f":"'Criteria Vendor A'!F21","v":0},null,null,null,null,{"$f":"IF(G19=\"x\",F19*0, IF(H19=\"x\",F19*0.5, IF(I19=\"x\",F19*0.7, IF(J19=\"x\",F19, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A22","v":0},{"$f":"'Criteria Vendor A'!B22","v":0},{"$f":"'Criteria Vendor A'!C22","v":0},{"$f":"'Criteria Vendor A'!D22","v":0},{"$f":"'Criteria Vendor A'!E22","v":0},{"$f":"'Criteria Vendor A'!F22","v":0},null,null,null,null,{"$f":"IF(G20=\"x\",F20*0, IF(H20=\"x\",F20*0.5, IF(I20=\"x\",F20*0.7, IF(J20=\"x\",F20, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A23","v":0},{"$f":"'Criteria Vendor A'!B23","v":0},{"$f":"'Criteria Vendor A'!C23","v":0},{"$f":"'Criteria Vendor A'!D23","v":0},{"$f":"'Criteria Vendor A'!E23","v":0},{"$f":"'Criteria Vendor A'!F23","v":0},null,null,null,null,{"$f":"IF(G21=\"x\",F21*0, IF(H21=\"x\",F21*0.5, IF(I21=\"x\",F21*0.7, IF(J21=\"x\",F21, 0))))","v":0}]

{"sheet":"Criteria Vendor C","index":5,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,10],[6,0,6,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["eServices amendments to PLRA Appendix A: Non-Functional Requirements"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points","Seriously Deficient","Acceptable","Good","Excellent","Points Awarded"]
[null,"MANDATORY CRITERIA"]
[{"$f":"'Criteria Vendor A'!A15","v":0},{"$f":"'Criteria Vendor A'!B15","v":0},{"$f":"'Criteria Vendor A'!C15","v":0},{"$f":"'Criteria Vendor A'!D15","v":0},{"$f":"'Criteria Vendor A'!E15","v":0},{"$f":"'Criteria Vendor A'!F15","v":0},null,"x",null,null,{"$f":"IF(G13=\"x\",F13*0, IF(H13=\"x\",F13*0.5, IF(I13=\"x\",F13*0.7, IF(J13=\"x\",F13, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A16","v":0},{"$f":"'Criteria Vendor A'!B16","v":0},{"$f":"'Criteria Vendor A'!C16","v":0},{"$f":"'Criteria Vendor A'!D16","v":0},{"$f":"'Criteria Vendor A'!E16","v":0},{"$f":"'Criteria Vendor A'!F16","v":0},null,null,"x",null,{"$f":"IF(G14=\"x\",F14*0, IF(H14=\"x\",F14*0.5, IF(I14=\"x\",F14*0.7, IF(J14=\"x\",F14, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A17","v":0},{"$f":"'Criteria Vendor A'!B17","v":0},{"$f":"'Criteria Vendor A'!C17","v":0},{"$f":"'Criteria Vendor A'!D17","v":0},{"$f":"'Criteria Vendor A'!E17","v":0},{"$f":"'Criteria Vendor A'!F17","v":0},null,null,"x",null,0]
[]
[]
[null,"RECOMMENDED CRITERIA"]
[{"$f":"'Criteria Vendor A'!A21","v":0},{"$f":"'Criteria Vendor A'!B21","v":0},{"$f":"'Criteria Vendor A'!C21","v":0},{"$f":"'Criteria Vendor A'!D21","v":0},{"$f":"'Criteria Vendor A'!E21","v":0},{"$f":"'Criteria Vendor A'!F21","v":0},null,"x",null,null,{"$f":"IF(G19=\"x\",F19*0, IF(H19=\"x\",F19*0.5, IF(I19=\"x\",F19*0.7, IF(J19=\"x\",F19, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A22","v":0},{"$f":"'Criteria Vendor A'!B22","v":0},{"$f":"'Criteria Vendor A'!C22","v":0},{"$f":"'Criteria Vendor A'!D22","v":0},{"$f":"'Criteria Vendor A'!E22","v":0},{"$f":"'Criteria Vendor A'!F22","v":0},null,null,null,null,{"$f":"IF(G20=\"x\",F20*0, IF(H20=\"x\",F20*0.5, IF(I20=\"x\",F20*0.7, IF(J20=\"x\",F20, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A23","v":0},{"$f":"'Criteria Vendor A'!B23","v":0},{"$f":"'Criteria Vendor A'!C23","v":0},{"$f":"'Criteria Vendor A'!D23","v":0},{"$f":"'Criteria Vendor A'!E23","v":0},{"$f":"'Criteria Vendor A'!F23","v":0},null,null,null,null,{"$f":"IF(G21=\"x\",F21*0, IF(H21=\"x\",F21*0.5, IF(I21=\"x\",F21*0.7, IF(J21=\"x\",F21, 0))))","v":0}]

{"sheet":"Criteria Vendor D","index":6,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,10],[6,0,6,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["eServices amendments to PLRA Appendix A: Non-Functional Requirements"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points","Seriously Deficient","Acceptable","Good","Excellent","Points Awarded"]
[null,"MANDATORY CRITERIA"]
[{"$f":"'Criteria Vendor A'!A15","v":0},{"$f":"'Criteria Vendor A'!B15","v":0},{"$f":"'Criteria Vendor A'!C15","v":0},{"$f":"'Criteria Vendor A'!D15","v":0},{"$f":"'Criteria Vendor A'!E15","v":0},{"$f":"'Criteria Vendor A'!F15","v":0},null,null,null,null,{"$f":"IF(G13=\"x\",F13*0, IF(H13=\"x\",F13*0.5, IF(I13=\"x\",F13*0.7, IF(J13=\"x\",F13, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A16","v":0},{"$f":"'Criteria Vendor A'!B16","v":0},{"$f":"'Criteria Vendor A'!C16","v":0},{"$f":"'Criteria Vendor A'!D16","v":0},{"$f":"'Criteria Vendor A'!E16","v":0},{"$f":"'Criteria Vendor A'!F16","v":0},null,null,null,null,{"$f":"IF(G14=\"x\",F14*0, IF(H14=\"x\",F14*0.5, IF(I14=\"x\",F14*0.7, IF(J14=\"x\",F14, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A17","v":0},{"$f":"'Criteria Vendor A'!B17","v":0},{"$f":"'Criteria Vendor A'!C17","v":0},{"$f":"'Criteria Vendor A'!D17","v":0},{"$f":"'Criteria Vendor A'!E17","v":0},{"$f":"'Criteria Vendor A'!F17","v":0},null,null,null,null,0]
[]
[]
[null,"RECOMMENDED CRITERIA"]
[{"$f":"'Criteria Vendor A'!A21","v":0},{"$f":"'Criteria Vendor A'!B21","v":0},{"$f":"'Criteria Vendor A'!C21","v":0},{"$f":"'Criteria Vendor A'!D21","v":0},{"$f":"'Criteria Vendor A'!E21","v":0},{"$f":"'Criteria Vendor A'!F21","v":0},null,null,null,null,{"$f":"IF(G19=\"x\",F19*0, IF(H19=\"x\",F19*0.5, IF(I19=\"x\",F19*0.7, IF(J19=\"x\",F19, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A22","v":0},{"$f":"'Criteria Vendor A'!B22","v":0},{"$f":"'Criteria Vendor A'!C22","v":0},{"$f":"'Criteria Vendor A'!D22","v":0},{"$f":"'Criteria Vendor A'!E22","v":0},{"$f":"'Criteria Vendor A'!F22","v":0},null,null,null,null,{"$f":"IF(G20=\"x\",F20*0, IF(H20=\"x\",F20*0.5, IF(I20=\"x\",F20*0.7, IF(J20=\"x\",F20, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A23","v":0},{"$f":"'Criteria Vendor A'!B23","v":0},{"$f":"'Criteria Vendor A'!C23","v":0},{"$f":"'Criteria Vendor A'!D23","v":0},{"$f":"'Criteria Vendor A'!E23","v":0},{"$f":"'Criteria Vendor A'!F23","v":0},null,null,null,null,{"$f":"IF(G21=\"x\",F21*0, IF(H21=\"x\",F21*0.5, IF(I21=\"x\",F21*0.7, IF(J21=\"x\",F21, 0))))","v":0}]

{"sheet":"Criteria Vendor E","index":7,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,10],[6,0,6,10],[8,0,8,10]]}
[]
[]
[]
[]
[]
["eServices amendments to PLRA Appendix A: Non-Functional Requirements"]
["Contact: Dave.Rogers@gov.yk.ca, eServices Delivery Manager"]
[]
["Changed requirements have highlighted ID numbers. Criteria NF31 only applies to YG-hosted systems."]
[]
["ID","Category / Epic","Name","Description","Outcomes","Max Points","Seriously Deficient","Acceptable","Good","Excellent","Points Awarded"]
[null,"MANDATORY CRITERIA"]
[{"$f":"'Criteria Vendor A'!A15","v":0},{"$f":"'Criteria Vendor A'!B15","v":0},{"$f":"'Criteria Vendor A'!C15","v":0},{"$f":"'Criteria Vendor A'!D15","v":0},{"$f":"'Criteria Vendor A'!E15","v":0},{"$f":"'Criteria Vendor A'!F15","v":0},null,null,null,null,{"$f":"IF(G13=\"x\",F13*0, IF(H13=\"x\",F13*0.5, IF(I13=\"x\",F13*0.7, IF(J13=\"x\",F13, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A16","v":0},{"$f":"'Criteria Vendor A'!B16","v":0},{"$f":"'Criteria Vendor A'!C16","v":0},{"$f":"'Criteria Vendor A'!D16","v":0},{"$f":"'Criteria Vendor A'!E16","v":0},{"$f":"'Criteria Vendor A'!F16","v":0},null,null,null,null,{"$f":"IF(G14=\"x\",F14*0, IF(H14=\"x\",F14*0.5, IF(I14=\"x\",F14*0.7, IF(J14=\"x\",F14, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A17","v":0},{"$f":"'Criteria Vendor A'!B17","v":0},{"$f":"'Criteria Vendor A'!C17","v":0},{"$f":"'Criteria Vendor A'!D17","v":0},{"$f":"'Criteria Vendor A'!E17","v":0},{"$f":"'Criteria Vendor A'!F17","v":0},null,null,null,null,0]
[]
[]
[null,"RECOMMENDED CRITERIA"]
[{"$f":"'Criteria Vendor A'!A21","v":0},{"$f":"'Criteria Vendor A'!B21","v":0},{"$f":"'Criteria Vendor A'!C21","v":0},{"$f":"'Criteria Vendor A'!D21","v":0},{"$f":"'Criteria Vendor A'!E21","v":0},{"$f":"'Criteria Vendor A'!F21","v":0},null,null,null,null,{"$f":"IF(G19=\"x\",F19*0, IF(H19=\"x\",F19*0.5, IF(I19=\"x\",F19*0.7, IF(J19=\"x\",F19, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A22","v":0},{"$f":"'Criteria Vendor A'!B22","v":0},{"$f":"'Criteria Vendor A'!C22","v":0},{"$f":"'Criteria Vendor A'!D22","v":0},{"$f":"'Criteria Vendor A'!E22","v":0},{"$f":"'Criteria Vendor A'!F22","v":0},null,null,null,null,{"$f":"IF(G20=\"x\",F20*0, IF(H20=\"x\",F20*0.5, IF(I20=\"x\",F20*0.7, IF(J20=\"x\",F20, 0))))","v":0}]
[{"$f":"'Criteria Vendor A'!A23","v":0},{"$f":"'Criteria Vendor A'!B23","v":0},{"$f":"'Criteria Vendor A'!C23","v":0},{"$f":"'Criteria Vendor A'!D23","v":0},{"$f":"'Criteria Vendor A'!E23","v":0},{"$f":"'Criteria Vendor A'!F23","v":0},null,null,null,null,{"$f":"IF(G21=\"x\",F21*0, IF(H21=\"x\",F21*0.5, IF(I21=\"x\",F21*0.7, IF(J21=\"x\",F21, 0))))","v":0}]

{"sheet":"Weighted Decision","index":8,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,11,6,12],[4,0,4,8],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10]]}
[]
[]
[]
[]
["Weighted Decision Matrix"]
[]
["Criteria","Weighting",null,"Company A",null,"Company B",null,"Company C",null,"Company D",null,"Company E"]
[null,null,null,"Score","Total","Score","Total","Score","Total","Score","Total","Score","Total"]
[]
["Mandatory Criteria"]
[{"$f":"PROPER('Criteria Vendor A'!C15)","v":""},0.1,null,{"$f":"'Criteria Vendor A'!K15","v":0},{"$f":"B11*D11","v":0},{"$f":"'Criteria Vendor B'!K13","v":0},{"$f":"B11*F11","v":0},{"$f":"'Criteria Vendor C'!K13","v":0},{"$f":"B11*H11","v":0},{"$f":"'Criteria Vendor D'!K13","v":0},{"$f":"B11*J11","v":0},{"$f":"'Criteria Vendor E'!K13","v":0},{"$f":"B11*L11","v":0}]
[{"$f":"PROPER('Criteria Vendor A'!C16)","v":""},0.05,null,{"$f":"'Criteria Vendor A'!K16","v":0},0,{"$f":"'Criteria Vendor B'!K14","v":0},{"$f":"B12*F12","v":0},{"$f":"'Criteria Vendor C'!K14","v":0},{"$f":"B12*H12","v":0},{"$f":"'Criteria Vendor D'!K14","v":0},0,{"$f":"'Criteria Vendor E'!K14","v":0},0]
[{"$f":"PROPER('Criteria Vendor A'!C17)","v":""},0.1,null,{"$f":"'Criteria Vendor A'!K17","v":0},0,{"$f":"'Criteria Vendor B'!K15","v":0},0,{"$f":"'Criteria Vendor C'!K15","v":0},0,{"$f":"'Criteria Vendor D'!K15","v":0},0,{"$f":"'Criteria Vendor E'!K15","v":0},0]
[]
["Recommended Criteria"]
[{"$f":"PROPER('Criteria Vendor A'!C21)","v":""},0.15,null,{"$f":"'Criteria Vendor A'!K21","v":0},{"$f":"B16*D16","v":0},{"$f":"'Criteria Vendor B'!K19","v":0},0,{"$f":"'Criteria Vendor C'!K19","v":0},0,{"$f":"'Criteria Vendor D'!K19","v":0},{"$f":"B16*J16","v":0},{"$f":"'Criteria Vendor E'!K19","v":0},{"$f":"B16*L16","v":0}]
[{"$f":"PROPER('Criteria Vendor A'!C22)","v":""},0.6,null,{"$f":"'Criteria Vendor A'!K22","v":0},{"$f":"B17*D17","v":0},{"$f":"'Criteria Vendor B'!K20","v":0},0,{"$f":"'Criteria Vendor C'!K20","v":0},0,{"$f":"'Criteria Vendor D'!K20","v":0},0,{"$f":"'Criteria Vendor E'!K20","v":0},0]
[{"$f":"PROPER('Criteria Vendor A'!C23)","v":""},null,null,{"$f":"'Criteria Vendor A'!K23","v":0},{"$f":"B18*D18","v":0},{"$f":"'Criteria Vendor B'!K21","v":0},{"$f":"B18*F18","v":0},{"$f":"'Criteria Vendor C'!K21","v":0},{"$f":"B18*H18","v":0},{"$f":"'Criteria Vendor D'!K21","v":0},{"$f":"B18*J18","v":0},{"$f":"'Criteria Vendor E'!K21","v":0},{"$f":"B18*L18","v":0}]
[]
["Weight Total",{"$f":"SUM(B11:B19)","v":1},"Total",null,{"$f":"SUM(E11:E19)","v":0},null,{"$f":"SUM(G11:G19)","v":0},null,{"$f":"SUM(I11:I19)","v":0},null,{"$f":"SUM(K11:K19)","v":0},null,{"$f":"SUM(M11:M19)","v":0}]