{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["247-24 Requirements","Vendor Response Lookup","MoSCoW Values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"247-24 Requirements","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,0,8,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[4,0,4,3],[6,0,6,3],[4,5,4,9],[6,5,6,9]]}
["RFP # 247-24"]
["RED LIGHT AND SPEED ENFORCEMENT EQUIPMENT"]
["Appendix No. 1 - Requirements Traceability Matrix (RTM)"]
[]
["Proposing Vendor Name:"]
[]
["Proposing Vendor Contact Name:"]
[]
["Notes to Proposing Vendors:\n1)  Column H is a set of drop down fields for you to select from a set of pre-defined abilities.  Please select your response and do NOT change the formatting.\n2)  Column J is an open field for you to list what product/module of your solution is providing the service to cover the listed requirement.  The space to provide detailed answers about your solution is within Appendix No. 2 Proposal Questions, which correspond to this RTM."]
["ID","Requirement Category","Requirement Type","Requirement Description","Prioritization Value","MoSCoW Value","Request for Information","Requirement Compliance","Description","Product/Module"]
["1.0","General Inquiry"]
[{"$f":"A11+0.1","v":1.1000000000000001},"General Inquiry","Functional","Browser Accessibility ",null,"Must Have","Describe your solution's accessibility over multiple browser platforms and if your solution is agnostic to the major platforms, including:\n\na) Chrome\nb) Edge\nc) Safari\nd) Firefox","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H12,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[1.2000000000000002,"General Inquiry","Functional","SaaS Solution",null,"Must Have","Describe your solution's ability to provide a modern, SaaS cloud based solution and connectivity.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H13,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[1.3000000000000003,"General Inquiry","Functional","Device Functionality",null,"Must Have","Describe how your solution provides functionality and user interface across different devices (desktop, laptop, mobile devices/phones).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H14,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[1.4000000000000004,"General Inquiry","Functional","Technology Accessibility Compliance",null,"Must Have","Describe your solution's ability for users to view and operate your solution if they have a disability, and if your solution is in compliance with Colorado's Anti-Discrimination Act (\"CADA\") on Technology Accessibility Compliance standards, which are currently 2.1 WCAG AA minimum standards.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H15,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[]
[2,"Licensing/User Roles"]
[{"$f":"A17+0.1","v":2.1},"Licensing/User Roles","Functional","User Roles",null,"Must Have","Please describe your solution's ability to have multiple user licenses available, including, Administrator permissions, general use permissions, etc.  \n\nIn your written proposal answer, please list all user types and a description of each type, including any limitations that that user may have (e.g., view only).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H18,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A18+0.1","v":2.2000000000000002},"Licensing/User Roles","Functional","Simultaneous Viewing",null,"Must Have","Please describe in detail the application's ability to allow individual and multiple users to view similar data across multiple items simultaneously.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H19,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A19+0.1","v":2.3000000000000003},"Licensing/User Roles","Functional","Single Sign-On",null,"Should Have","Please describe your solution's capability to provide  Single Sign-On (SSO) as part of user and password management for your clients.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H20,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[]
[{"$f":"A17+1","v":3},"File Types/Support"]
[{"$f":"A22+0.1","v":3.1},"File Types/Support","Functional","Data Import/Exporting",null,"Must Have","Describe how your solution's ability to import and export common file types that include Microsoft Office (Excel, Word, etc.) and Adobe PDF.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H23,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A23+0.1","v":3.2},"General Inquiry","Functional","Attachments\n(Supporting Documents)",null,"Should Have","Describe your solution's ability to attach supporting documents to records within your system (e.g., PDF files, Word documents, etc.).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H24,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[3.3000000000000003,"File Types/Support","Functional","Attachments\n(Images)",null,"Should Have","Please describe how your solution is capable of basic recording and attaching saved images to an individual record.  Include in your written response what file types are used by your cameras (red-light and mobile) for capturing these images.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H25,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[3.4000000000000004,"File Types/Support","Functional","File Sizes",null,"Should Have","Please describe any file size limitations that your solution may have for uploading and attaching to an item of record.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H26,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[]
[{"$f":"A22+1","v":4},"User Interface","Functional"]
[{"$f":"A28+0.1","v":4.0999999999999996},{"$f":"B28","v":"User Interface"},"Functional","Spell Check",null,"Must Have","Describe your solution's ability to provide basic spell checking and corrections.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H29,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[4.1999999999999993,"User Interface","Functional","Search Fields","Describe your solution's ability to provide basic spell checking and corrections.","Should Have","Basic search field functionality or search bar for quicker and easier access to records.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H30,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[4.2999999999999989,"User Interface","Functional","Driver Recognition",null,"Must Have","Describe your solution's ability to capture high-resolution images of a driver and their face during a traffic violation.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H31,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[4.3999999999999986,"User Interface","Functional","Automated traffic violation notice Processing",null,"Must Have","In the RTM, please list your solution's abilitiy for an automated traffic violation notice processing.\n\nIn your written response, please provide any further details how your solution performs the task of auotmated traffic violation notice processing.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H32,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[]
[{"$f":"A28+1","v":5},"Reports and Templates","Functional"]
[{"$f":"A34+0.1","v":5.0999999999999996},"Reports and Templates","Functional","General Reports - Canned",null,"Must Have","In the RTM, does your solution have canned reports as part of your solution?\n\nIn your written response:  Please list all of your solution's canned/out-of-the-box reports that are available, and provide a basic description that each report is providing information ","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H35,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.1999999999999993,"Reports and Templates","Functional","Specific Reports - Violation Quantities",null,"Must Have","In the RTM, does your solution have this type of specific report need?\n\nIn your written response, please provide a detailed description of how your solution reports out the quantity of violations detected using AVIS, traffic patterns, and system performance that have been sent to the TPD for review during a user defined time period.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H36,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.2999999999999989,"Reports and Templates","Functional","Specific Reports - Violations Authorized and Mailed",null,"Must Have","In the RTM, does your solution have this type of specific report need?\n\nIn your written response, please provide a detailed description of how your solution reports out the quantity of violations approved by the TPD and mailed out by your firm during a user defined time period.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H37,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.3999999999999986,"Reports and Templates","Functional","Specific Reports - Violations Undeliverable",null,"Should Have","In the RTM, does your solution have this type of specific report need?\n\nIn your written response, please provide a detailed description of how your solution reports out the quantity of violations that had been mailed out, but only to have been returned as undeliverable during a user defined time period.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H38,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.4999999999999982,"Reports and Templates","Functional","Customizable Reports",null,"Must Have","Please describe your solution's ability to design, and generate customized reports","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H39,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.5999999999999979,"Reports and Templates","Functional","Reporting Templates",null,"Must Have","Please describe your solution's ability to save, store, and replicate previous customized or ad hoc reports generated by a user.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H40,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.6999999999999975,"Reports and Templates","Functional","Exporting Report Format",null,"Must Have","Please describe and list the formats and file types that your solution can provide for exporting all types of reports.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H41,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.7999999999999972,"Reports and Templates","Functional","Exporting Reports to Email",null,"Must Have","Please describe your solution's ability to export a report that has been generated by a user directly into Outlook for dissemination.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H42,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.8999999999999968,"Reports and Templates","Functional","Scheduling Reports",null,"Should Have","Please describe your solution's ability to schedule for reports to run at a user's pre-defined intervals (i.e., 1st Monday of each month) and where those reports can be found at within your solution.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H43,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[5.0999999999999996,"Reports and Templates","Functional","Scheduled Reports to Email",null,"Could Have","Please describe your solution's ability to automatically send out a report that has been scheduled to run at a pre-defined interval by a user, through an Outlook email so that another user may have it automatically in their inbox when opening Outlook.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H44,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A44+0.01","v":5.1099999999999994},"Reports and Templates","Functional","Visual Representations and KPIs",null,"Should Have","Please describe your solution's ability to provide reports in a visual representation (e.g., line/bar graphs) and if this information can be displayed as a Key Performance Indicator (KPI) for a user to view on their homepage or upon logging into the system.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H45,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A45+0.01","v":5.1199999999999992},"Reports and Templates","Functional","Data Analytics",null,"Should Have","In the RTM, is your solution capable of performing/including data analytics to help identify trends for informed decision making?\n\nIn your written response, please detail what this data analytics package includes and how it performs and aids your clients.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H46,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[]
[{"$f":"A34+1","v":6},"Record Retention"]
[{"$f":"A48+0.1","v":6.1},{"$f":"B48","v":"Record Retention"},"Functional","Audit Trails",null,"Must Have","Describe how your solution can provide an audit trail of a user's specific actions, including creation, deletion, migration of records/documents.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H49,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A49+0.1","v":6.1999999999999993},{"$f":"B49","v":"Record Retention"},"Functional","Versioning",null,"Should Have","Describe how your solution allows for a user to track changes and revert to a previous version, if it is needed by a user.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H50,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A50+0.1","v":6.2999999999999989},{"$f":"B50","v":"Record Retention"},"Functional","Recovery and Restoration",null,"Must Have","Describe your solution's capabilities to recover files that need to recovered and restored from accidental deletion.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H51,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[{"$f":"A51+0.1","v":6.3999999999999986},{"$f":"B51","v":"Record Retention"},"Functional","Policies",null,"Should Have","Describe how your solution can support Thornton specifically defined records retention policies that require deletion upon user specified dates for permanent deletion.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H52,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]

{"sheet":"Vendor Response Lookup","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["RequirementCompliance","Description"]
["Cannot Meet"," The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."]
["Future Release","The current version of the solution cannot meet the requirement “Out of the Box” or “With Configuration” but will be able to with a scheduled, future release of the product."]
["Out-of-the-Box","The solution meets the requirement as is, “out-of-the-box” functionality with no configuration or custom programming/coding."]
["With Configuration","The solution can meet the requirement by arranging the functional parameters that are already inherent in the product – and not by changing the product’s source code – so that it functions in a way that meets the City’s specific business needs."]
["With Custom Programming","The solution can meet the requirement only by modifying the product’s source code (changing or adding new code) to enable it to do what it was not originally able to do."]

{"sheet":"MoSCoW Values","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Prioritization Type","Prioritization Description"]
["Must Have","Requirements labeled as \"Must Have\" are critical to the current delivery timebox in order for it to be a success. If even one \"Must Have\" requirement is not included, the project delivery should be considered a failure (note: requirements can be downgraded from \"Must Have\", by agreement with all relevant stakeholders; for example, when new requirements are deemed more important). "]
["Should Have","Requirements labeled as \"Should Have\" are important but not necessary for delivery in the current delivery timebox. While \"Should Have\" requirements can be as important as \"Must Have\", they are often not as time-critical or there may be another way to satisfy the requirement, so that it can be held back until a future delivery timebox."]
["Could Have","Requirements labeled as \"Could Have\" are desirable but not necessary, and could improve user experience or customer satisfaction for little development cost. These will typically be included if time and resources permit."]
["Won't Have","Requirements labeled as \"Won't Have\" have been agreed by stakeholders as the least-critical, lowest-payback items, or not appropriate at that time. As a result, \"Won't Have\" requirements are not planned into the schedule for the next delivery timebox. \"Won't Have\" requirements are either dropped or reconsidered for inclusion in a later timebox. (Note: occasionally the term Would like to have is used; however, that usage is incorrect, as this last priority is clearly stating something is outside the scope of delivery)."]