{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["291-23 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":"291-23 Requirements","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[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 # 291-23 "]
["Pavement Assessment and Management Software"]
["Appendix No. 1 - Requirements Traceability Matrix (RTM)"]
[]
["Proposing Vendor Name:"]
[]
["Proposing Vendor Contact Name:"]
[]
["ID","Requirement Category","Requirement Type","Requirement Description","Prioritization Value","MoSCoW Value","Request for Information","Requirement Compliance","Description","Product/Module"]
["1.0","General Inquiry"]
[{"$f":"A10+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(H11,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(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.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(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.4000000000000004,"General Inquiry","Functional","Technology Accessibility Compliance",null,"Must Have","Describe your solution's ability for public citizens to view and operate your solution if they have a disability, and if your solution is in compliance with Colorado House Bill 21-1110 on Technology Accessibility Compliance 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.>"]
[1.5000000000000004,"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.>"]
[]
[2,"Licensing/User Roles"]
[{"$f":"A17+0.1","v":2.1},"Licensing/User Roles","Functional","Licensing",null,"Must Have","Please describe your solutions ability to have multiple user licenses available, including, Administrator permissions, general use permissions, etc.","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.>"]
[]
[3,"File Types/Support"]
[{"$f":"A21+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(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.>"]
[{"$f":"A22+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., purchase orders, PDF files, Word documents, etc.)","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.>"]
[3.3000000000000003,"File Types/Support","Functional","Attachments\n(Supporting Photos & Files)",null,"Should Have","Describe how your solution supports uploading of photos and like files (e.g. .JPEG) to be attached to item condition reports.","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":"A24+0.1","v":3.4000000000000004},"File Types/Support","Functional","Multiple Files/Single Records",null,"Must Have","Describe your solution's ability to upload multiple files within a single record(s).","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.>"]
[{"$f":"A25+0.1","v":3.5000000000000004},"File Types/Support","Functional","Digital Media File Types",null,"Should Have","Describe your solution's ability to support a wide variety of special or digital media files types, including, but not limited to WAV and TIFF.","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":3.6000000000000005},"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(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.>"]
[]
[4,"User Interface","Functional"]
[{"$f":"A29+0.1","v":4.0999999999999996},"User Interface","Functional","Search Fields",null,"Must Have","Describe your solution's ability for providing searchable fields for items, pavement segments, street names and intersections, etc.","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.1999999999999993,"User Interface","Functional","Map Overlays\n(General)",null,"Must Have","Describe your solution's ability for a user to view on a map overlay the:\n\na) Road name\nb) Classification\nc) Number Lanes\nd) Speed Limit and Where It May Change","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.2999999999999989,"User Interface","Functional","Map Overlays\n(Road Conditions)",null,"Must Have","Describe your solution's ability for a user to view on a map overlay the:\n\na) Distress Ratings\nb) Current PCI\nc) Date of Last Inspection\nd) Date of Last Treatment\ne) Previous Ratings and When That Rating Changed","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.>"]
[4.3999999999999986,"User Interface","Functional","PCI and Levels",null,"Must Have","Please describe how your solution can provide, show, change, and update different PCI levels that adhere to ASTM 6433, and how is that PCI condition reported out to the user.","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.>"]
[4.4999999999999982,"User Interface","Functional","Content Editing",null,"Must Have","Please describe how a Thornton user can edit, modify, or create a new entry within your solution.","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,"Reports and Templates","Functional"]
[{"$f":"A36+0.1","v":5.0999999999999996},"Reports and Templates","Functional","Canned Reports",null,"Must Have","Please describe your solution's canned/out-of-the-box reports that are available.","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":5.1999999999999993},"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(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.>"]
[{"$f":"A38+0.1","v":5.2999999999999989},"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(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.3999999999999986},"Reports and Templates","Functional","Exporting Reports",null,"Must Have","Please describe the formats and file types that your solution can provide for exporting all types of reports, including if your solution can export a report directly into Outlook for dissemination.","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.>"]
[]
[6,"Financial Reporting"]
[{"$f":"A42+0.1","v":6.1},{"$f":"B42","v":"Financial Reporting"},"Functional","Data Input",null,"Should Have","Please describe your solution's ability for users to input budgetary information on lane mileage ","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":"A43+0.1","v":6.1999999999999993},{"$f":"B43","v":"Financial Reporting"},"Functional","Year-over-Year",null,"Should Have","Please describe your solution's ability for users to view budgetary information on a year-over-year basis for work performed in years' past vs. current costing and budgeting numbers","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.>"]
[]
[7,"Record Retention"]
[{"$f":"A46+0.1","v":7.1},{"$f":"B46","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(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.>"]
[{"$f":"A47+0.1","v":7.1999999999999993},{"$f":"B47","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(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":"A48+0.1","v":7.2999999999999989},{"$f":"B48","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(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":7.3999999999999986},{"$f":"B49","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(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.>"]
[]
[8,"Additional Features"]
[{"$f":"A52+0.1","v":8.1},{"$f":"B52","v":"Additional Features"},"Non-Functional","Scalable Asset Tracking",null,"Could Have","Please describe your solution's ability to be scalable for other asset tracking items, including but not limited to:\n\na)  Signage\nb) Traffic Signals","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.>"]

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