{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["190-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":"190-24 Requirements","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"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 # 190-24"]
["FIBER ASSET MAPPING AND SOFTWARE"]
["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 CADA on Technology Accessibility Compliance 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},"Integration Points"]
[{"$f":"A22+0.1","v":3.1},{"$f":"B22","v":"Integration Points"},"Functional","ESRI - 2-way",null,"Must Have","Please indicate and describe if your solution is able to provide a direct, two-way integration point with Thornton's ESRI account.","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},{"$f":"B23","v":"Integration Points"},"Functional","ESRI - Authoritative",null,"Must Have","Please indicate and describe if your solution is able to be an authoritative record within ESRI.","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.>"]
[]
[{"$f":"A22+1","v":4},"File Types/Support"]
[{"$f":"A26+0.1","v":4.0999999999999996},"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(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":4.1999999999999993},"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., purchase orders, PDF files, Word documents, etc.).","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.>"]
[4.2999999999999989,"File Types/Support","Functional","Supporting Photos & Files",null,"Should Have","Please describe if your solution is capable attaching or can include supporting photos, videos, or other files for auditing purposes for a fiber segment.","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.3999999999999986,"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(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.>"]
[]
[5,"User Interface and Features","Functional"]
[{"$f":"A32+0.1","v":5.0999999999999996},{"$f":"B32","v":"User Interface and Features"},"Functional","Spell Check",null,"Must Have","Describe your solution's ability to provide basic spell checking and corrections.","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.>"]
[5.1999999999999993,"User Interface and Features","Functional","Search Fields","Describe your solution's ability to provide basic spell checking and corrections.","Must Have","Describe your solution's ability for providing searchable fields for items/records within your platform.","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.>"]
[5.2999999999999989,"User Interface and Features","Functional","Mapping \nPresent and Future State",null,"Must Have","Please indicate and describe if your solution is able to map Thornton's fiber, and known 3rd party fiber networks, and their:\n\na) Present/Current state\nb) Future state","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.3999999999999986,"User Interface and Features","Functional","Descriptions and Recording",null,"Must Have","Please indicate and describe how your solution can allow for Thornton to describe, record, modify, save, etc. the following items regarding Thornton's fiber network, including fiber segments and conduit:\n\na) Make and Model of fiber\nb) Ownership status (Thornton or 3rd Party)\nc) Installation date\nd) Age of existing product","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.4999999999999982,"User Interface and Features","Functional","Mapping - handholes",null,"Should Have","Please indicate and describe if your solution is able to map handholes from Thornton's fiber network","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.5999999999999979,"User Interface and Features","Functional","Mapping - Conduit and Bundles",null,"Should Have","Please indicate and describe if your solution is able to map conduits and bundles from Thornton's fiber network","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.6999999999999975,"User Interface and Features","Functional","Mapping - Pathways",null,"Should Have","Please indicate and describe if your solution is able to map pathways from Thornton's fiber network","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.>"]
[{"$f":"A39+0.1","v":5.7999999999999972},"User Interface and Features","Functional","Mapping - Metadata",null,"Could Have","Please indicate and describe if your solution is able to map and track metadata that is generated and passes through Thornton's fiber network.","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.>"]
[{"$f":"A40+0.1","v":5.8999999999999968},"User Interface and Features","Functional","Splice Diagrams",null,"Must Have","Please indicate and describe how your solution is able to record, save, and view detailed splice diagrams of Thornton's fiber network, including terminations.","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.>"]
[{"$f":"5.1","v":5.0999999999999996},{"$f":"B41","v":"User Interface and Features"},"Functional","Patch Paneling",null,"Must Have","Please indicate and describe how your solution is able to record, save, and view patch panels in rack of Thornton's fiber network, including terminations.","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.>"]
[{"$f":"A42+0.01","v":5.1099999999999994},"User Interface and Features","Functional","Troubleshooting the Fiber Network",null,"Should Have","Please indicate and describe how your solution is able to provide troubleshooting help for Thornton personnel regarding our fiber network, including OTDR measurements and locations.","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.1199999999999992,{"$f":"B43","v":"User Interface and Features"},"Functional","Pathway Details",null,"Must Have","Please indicate and describe how your solution is able to provide various details regarding pathways of Thornton's fiber network, including but not limted to:\n\na) Number of strands\nb) Length of pathways\nc) Number of splices in a given pathway","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.>"]
[5.129999999999999,{"$f":"B44","v":"User Interface and Features"},"Functional","Pathway Recommendations",null,"Should Have","Please indicate and describe how your solution is able to provide recommendations between two points of Thornton's fiber network based on available unused fiber strands that are documented in 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.>"]
[5.1399999999999988,"User Interface and Features","Functional","Traceability",null,"Should Have","Please indicate and describe your solution's ability to find a fiber or conduit segment, and then highlight that segment for further evaluation by Thornton's staff.","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.1499999999999986,"User Interface and Features","Functional","Ingesting GPS Data",null,"Should Have","Please indicate and describe your solution's ability to import attributes of fiber or other related assets from GIS products, such as Trimble Catalyst products, or similar types of products","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.1599999999999984,{"$f":"B47","v":"User Interface and Features"},"Functional","Cost Estimation",null,"Should Have","Please indicate and describe your solution's ability to provide cost estimates to Thornton based on existing data, and how those cost estimates are provided to Thornton in cost, feet, and amount of each handhole.","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.>"]
[]
[{"$f":"A32+1","v":6},"Reports and Templates","Functional"]
[{"$f":"A50+0.1","v":6.1},"Reports and Templates","Functional","Canned Reports",null,"Must Have","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 on.","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.>"]
[6.1999999999999993,"Reports and Templates","Functional","Specific Reports\n(Cost Estimation)",null,"Should Have","Please indicate if your proposed solution's cost estimation tool is out-of-the-box, or requires additional work (configuration/customization), and include a copy/screenshot of what that report may look like.","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.>"]
[6.2999999999999989,"Reports and Templates","Functional","Specific Reports\n(Splice Diagrams)",null,"Should Have","Please indicate if your proposed solution's splice diagrams tool is out-of-the-box, or requires additional work (configuration/customization), and include a copy/screenshot of what that report may look like.","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.>"]
[6.3999999999999986,"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(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.>"]
[6.4999999999999982,"Reports and Templates","Functional","Ad Hoc 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(H55,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,"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(H56,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,"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(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.7999999999999972,"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(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.>"]
[]
[{"$f":"A50+1","v":7},"Record Retention"]
[{"$f":"A60+0.1","v":7.1},{"$f":"B60","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(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.>"]
[{"$f":"A61+0.1","v":7.1999999999999993},{"$f":"B61","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(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.>"]
[{"$f":"A62+0.1","v":7.2999999999999989},{"$f":"B62","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(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.>"]
[{"$f":"A63+0.1","v":7.3999999999999986},{"$f":"B63","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(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.>"]

{"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)."]