{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["385-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":"385-24 Requirements","index":0,"n_rows":83,"n_cols":10,"rows_kept":83,"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]]}
["385-24"]
["POST TRAINING AND QUARTERMASTER SOFTWARE"]
["Appendix No. 2 - 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","Device Functionality",null,"Must Have","Describe how your solution's provides:\n1. Functionality and user interface across different devices (desktop, laptop, mobile devices/phones).\n2. A modern, 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","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(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.>"]
[{"$f":"A14+0.1","v":1.4000000000000004},"General Inquiry","Functional","Spell Check",null,"Must Have","Describe your solution's ability to provide basic spell checking and corrections.","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.>"]
[{"$f":"A15+0.1","v":1.5000000000000004},"General Inquiry","Functional","Search Fields",null,"Must Have","Basic search field functionality or search bar for quicker and easier access to records.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H16,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.6000000000000005,"General Inquiry","Functional","Mobile Compatibility",null,"Must Have","Please describe your solution's ability to enable access to training materials and assessments on mobile devices for on-the-go learning.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H17,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.7000000000000006,"General Inquiry","Functional","Customizable Reports",null,"Must Have","Please describe your solution's ability to design, and generate customized reports.","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.>"]
[1.8000000000000007,"General Inquiry","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(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.>"]
[1.9000000000000008,"General Inquiry","Functional","Exporting Reports 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(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.>"]
["1.10","General Inquiry","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(H21,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.11","General Inquiry","Functional","Compliance with Standards",null,"Must Have","Please describe your solution's ability to adhere to relevant law enforcement training standards and accreditation requirements. ","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H22,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.12","General Inquiry","Functional","Reporting Analytics",null,"Must Have","Please describe your solution's ability to:\n1. Track key metrics such as completion rates, pass rates, and time to proficiency.\n2. Generate various reports on training compliance, performance and trends.","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.>"]
[]
[2,"Licensing/User Roles"]
[{"$f":"A25+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(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":"A26+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(H27,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":"A27+0.1","v":2.3000000000000003},"Licensing/User Roles","Functional","Single Sign-On",null,"Must 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(H28,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":"A25+1","v":3},"File Types/Support"]
[{"$f":"A30+0.1","v":3.1},"File Types/Support","Functional","Data Import/Exporting",null,"Must Have","Describe 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(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.>"]
[{"$f":"A31+0.1","v":3.2},"File Types/Support","Functional","Attachments (Supporting Documents)",null,"Must 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(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.>"]
[3.3000000000000003,"File Types/Support","Functional","Attachments (Images)",null,"Must 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(H33,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 Size",null,"Must 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(H34,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":"A30+1","v":4},"User Interface- Training Records"]
[4.0999999999999996,"User Interface- Training Records","Functional","Core Functions",null,"Must Have","Please describe your solution's ability to:\n1. Centralized storage and management of training records for all employees. \n2. Track attendance, completion status and certificates. Automated reminders for upcoming training and renewals. \n3. Scheduling management.","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.>"]
[{"$f":"A37+0.1","v":4.1999999999999993},"User Interface- Training Records","Functional","Curriculum Management",null,"Must Have","Please describe your solution's ability to: \n1. Create management of training curriculum. \n2. Organization of training materials, lesson plans, and assessments.","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.>"]
[4.2999999999999989,"User Interface- Training Records","Functional","Instructor Management",null,"Must Have","Please describe your solution's ability to: \n1. Track instructor qualifications and certification. \n2. Assignment of instructors to training courses.","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.>"]
[4.3999999999999986,"User Interface- Training Records","Functional","Integration",null,"Must Have","Please describe your solution's ability to: \n1. Integrate with existing systems as well as integrate with other law enforcement systems such as CAD, RMS and personnel databases. \n2. Enable access to training records and materials on mobile devices.","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.>"]
[4.4999999999999982,"User Interface- Training Records","Functional","Security and Compliance",null,"Must Have","Please describe your solution's ability to: \n1. Implement robust security measures to protect sensitive office and training data. \n2. Adhere to relevant law enforcement standards and regulations for training personnel management.","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.>"]
[4.5999999999999979,"User Interface- Training Records","Functional","Additional Features( Optional)",null,"Must Have","Please describe your solution's ability to: \n1. Online learning platform: Integrate with an online learning platform to offer e-learning courses. \n2. Performance Management: Link training records to performance evaluations. \n3. Certification Management: Track and manage certifications and qualifications for officers and instructors. \n4. Budget Tracking: Monitor training budgets and expenses.","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.>"]
[4.6999999999999975,"User Interface- Training Records","Functional","Key Considerations",null,"Must Have","Please describe your solution's ability to: \n1. User Friendliness: Design an intuitive interface that is easy for both officers and adminstrators to use. \n2. Real-World Relevance: Ensure training records and materials are relevant to the challenges faced by law enforcement officers.\n3. Continuous Improvement: Incorporate feedback from users to continually improve the software and training programs.\n4. Compliance with Standards: Adhere to relevant law enforcement training standards and accreditation requirements.","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.>"]
[]
[{"$f":"A36+1","v":5},"User Interface- Quartmaster"]
[{"$f":"A45+0.1","v":5.0999999999999996},"User Interface- Quartmaster","Functional ","Inventory Management",null,"Must Have","Please describe your solution's ability to:\n1.  Tracking of Items (i.e. equipment, supplies, uniforms)\n2. Real-time inventory levels and stock alerts\n3. Location tracking and management\n4. Batch and serial number tracking (if applicable)","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.>"]
[5.1999999999999993,"User Interface- Quartmaster","Functional ","Procurement",null,"Must Have","Please describe your solution's ability to:\n1. Purchase Order generation and management\n2. Vendor management and contacts\n3. Receiving and inspection processes","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H47,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,"User Interface- Quartmaster","Functional ","Issuance",null,"Must Have","Please describe your solution's ability to: \n1. Item issuance tracking and authorization\n2. Returns and exchanges management","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H48,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,"User Interface- Quartmaster","Functional ","Reporting Analytics",null,"Must Have","Please describe your solution's ability to:\n1. Customizable reports (i.e. inventory turnover, consumption rates, usage trends)\n2. Dashboards for real-time insights\n3. Financial report (i.e. cost analysis, budget tracking)","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.>"]
[5.4999999999999982,"User Interface- Quartmaster","Functional ","User Interface and Experience",null,"Must Have","Please describe your solution's ability to provide role-based access controls and permissions.\n","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.>"]
[5.5999999999999979,"User Interface- Quartmaster","Functional ","Integration and Data Management",null,"Must Have","Please describe your solution's ability to: \n1. Integrate with barcode scanners and RFID technology\n2. Data import and export capabilities\n3. Data backup and recovery procedures","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.>"]
[5.6999999999999975,"User Interface- Quartmaster","Functional ","Security and Compliance",null,"Must Have","Please describe your solution's ability to:\n1. Data encryption and protections\n2. Compliance with relevant industry standards\n3. Access controls and audit trails","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.>"]
[5.7999999999999972,"User Interface- Quartmaster","Functional ","Project Management and Timeliness",null,"Must Have","Please describe your solution's ability to:\n1. Project timelines and milestones\n2. Development methodology (i.e. Agile, Waterfall)\n3. Testing and quality assurance processess\n4. Deployment and implementation plan","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H53,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,"User Interface- Quartmaster","Functional ","Support Maintenance",null,"Must Have","Please describe your solution's ability to:\n1. Post-implementation\n2. Ongoing maintence and updates\n3. Technical support channels","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H54,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+1","v":6},"User Interface- Field Training Software"]
[{"$f":"A46+1","v":6.1},"User Interface- Field Training Software","Functional","Visual Representations and KPI's",null,"Must 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.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H57,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.>"]
[6.1999999999999993,"User Interface- Field Training Software","Functional","Reporting Analytics",null,"Must Have","Please describe your solution's ability to generate reports on student progress, instructor performance and program effectiveness. ","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H58,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.>"]
[6.2999999999999989,"User Interface- Field Training Software","Functional","Curriculum Management",null,"Must Have","Please describe your solution's ability to create, manage and customize curriculum. As well as organize training materials, lesson plans and assessments.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H59,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.>"]
[6.3999999999999986,"User Interface- Field Training Software","Functional","Student Tracking",null,"Must Have","Please describe your solution's ability to enroll students in training programs, monitor student progress and performance as welll as track attendance and participation.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H60,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.>"]
[6.4999999999999982,"User Interface- Field Training Software","Functional","Instructor Tools",null,"Must Have","Please describe your solution's ability to assign tasks and assessments. Grade assignments and provide feedback and track instructor performance and workload.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H61,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.>"]
[6.5999999999999979,"User Interface- Field Training Software","Functional","Scenario Builder",null,"Must Have","Please describe your solution's ability to create realistic training scenariors to simulate real-world situations. As well as customize scenarios based on specific training objectives.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H62,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.>"]
[6.6999999999999975,"User Interface- Field Training Software","Functional","Assessement Tools",null,"Must Have","Please describe your solution's ability to design and administer various assessments. As well as evaluate student performance and identify areas for improvement.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H63,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.>"]
[6.7999999999999972,"User Interface- Field Training Software","Functional","Accessibility",null,"Must Have","Please describe your solution's ability to integrate with exisiting systems as well as provide mobile accessibility to access training materials on the go.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H64,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.>"]
[6.8999999999999968,"User Interface- Field Training Software","Functional","Data Security",null,"Must Have","Please describe your solution's ability to implement robust security measures to protect sensitive student and instructor data.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H65,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.>"]
["6.10","User Interface- Field Training Software","Functional","Compliance",null,"Must Have","Please descrive your solution's ability to adhere to relevant law enforcement standards and regulations for training and personnel management.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H66,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.>"]
["6.11","User Interface- Field Training Software","Functional","Peer Evaluation",null,"Must Have","Please describe your solution's ability to allow students to evaluate each other’s performance and provide feedback.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H67,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.>"]
["6.12","User Interface- Field Training Software","Functional","Real-World Relevance",null,"Must Have","Please describe your solution's ability to ensure training scenarios and assessments are relevant to the challenges faced by law enforcement officers.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H68,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.>"]
[]
[7,"User Interface- POST Software"]
[{"$f":"A70+0.1","v":7.1},"User Interface- POST Software","Functional","Curriculum Management",null,"Must Have","Please describe your solution's ability to:\n1. Create, manage and customize training curriculum\n2. Organize training materials, lesson plans, and assessments","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H71,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.>"]
[7.1999999999999993,"User Interface- POST Software","Functional","Student Tracking",null,"Must Have","Please describe your solution's ability to:\n1. Enroll students in training programs\n2. Monitor student progress and performance\n3. Track attendance and participation","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H72,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.>"]
[7.2999999999999989,"User Interface- POST Software","Functional","Instructor Tools",null,"Must Have","Please describe your solution's ability to:\n1. Assign tasks and assess\n2. Grade assignments and provide feedback\n3. Track instructor performance and workload","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H73,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.>"]
[7.3999999999999986,"User Interface- POST Software","Functional","Scenario Builder",null,"Must Have","Please describe your solution's ability to:\n1. Create realistic training scenarios to simulate real-world situations\n2. Customize scenarios based on specific training objectives","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H74,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.>"]
[7.4999999999999982,"User Interface- POST Software","Functional","Assessment Tools",null,"Must Have","Please describe your solution's ability to:\n1. Design and administer various assessments (e.g. written exams, practical exercises, simulations)\n2. Evaluate student performance and identify areas for improvement","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H75,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.>"]
[7.5999999999999979,"User Interface- POST Software","Functional","Reporting and Analytics",null,"Must Have","Please describe your solution's ability to: \n1. Generate reports on student progress, instructor performance, and program effectiveness.\n2. Track key metric such as completion rates, pass rates, and time to proficiency.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H76,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.>"]
[7.6999999999999975,"User Interface- POST Software","Functional","Video Recording and Analysis",null,"Must Have","Please describe your solution's ability to capture and analyze video footage of training scenarios to provide feedback and improve performance.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H77,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.>"]
[7.7999999999999972,"User Interface- POST Software","Functional","Peer Evaluation",null,"Must Have","Please describe your solution's ability to allow students to evaluate each other’s performance and provide feedback.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H78,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.>"]
[7.8999999999999968,"User Interface- POST Software","Functional","Certification Management",null,"Must Have","Please describe your solution's ability to track and manage certifications and qualifications for students and instructors.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H79,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.>"]
["7.10","User Interface- POST Software","Functional","Physical Fitness Tracking",null,"Must Have","Please describe your solution's ability to incorporate tools to track student physical fitness progress and ensure compliance with academy standards.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H80,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.>"]
["7.11","User Interface- POST Software","Functional","Weapons Proficiency",null,"Must Have","Please describe your solution's ability to include features to track student proficiency with firearms and other weapons. ","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H81,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.>"]
["7.12","User Interface- POST Software","Functional","Tactical Training",null,"Must Have","Please describe your solution's ability to support training in tactical skills such as patrol procedures, use of force, and defensive tactics.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H82,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.>"]
["7.13","User Interface- POST Software","Functional","Legal Training",null,"Must Have","Please describe your solution's ability to integrate legal training modules to ensure students understand relevant laws and regulations. ","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H83,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)."]