{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["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":"Requirements","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[8,0,8,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,3],[6,0,6,3],[4,4,4,8],[6,4,6,8]]}
["RFP # 261-25"]
["AUTOMATED TRAFFIC SIGNAL PERFORMANCE MEASURES (\"ATSPM\") PLATFORM"]
["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 I will autopopulate based on your selection in colum H.  Please do NOT change the formatting.\n3)  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 and any additional supporting information."]
["ID","Requirement Category","Requirement Type","Requirement Description","MoSCoW Value","Request for Information","Requirement Compliance","Description","Product/Module/Supporting Information"]
[1,"General Inquiry"]
[{"$f":"A11+0.1","v":1.1000000000000001},"General Inquiry","Functional","SaaS Solution","Must Have","Please list your solution's ability to be a modern, SaaS cloud model based solution and connectivity.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G12,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[1.2,"General Inquiry","Functional","Browser Accessibility ","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(G13,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[1.3,"General Inquiry","Functional","Device Functionality","Should Have","Describe how your solution provides functionality and user interface across different devices (desktop, laptop, mobile devices/phones).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G14,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[1.4,"General Inquiry","Functional","Technology Accessibility Compliance","Should 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(G15,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[2,"Licensing/User Roles"]
[{"$f":"A17+0.1","v":2.1},"Licensing/User Roles","Functional","User Roles","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(G18,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[{"$f":"A18+0.1","v":2.2000000000000002},"Licensing/User Roles","Functional","Simultaneous Use","Must Have","Please describe in detail your solution's ability to allow individual and multiple users to use the solution simultaneously.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G19,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[{"$f":"A19+0.1","v":2.3000000000000003},"Licensing/User Roles","Functional","Single Sign-On","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(G20,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[{"$f":"A17+1","v":3},"Integration Points"]
[{"$f":"A22+0.1","v":3.1},{"$f":"B22","v":"Integration Points"},"Functional","Econolite Cobalt Controller","Must Have","Please indicate and describe if your solution is able to provide a direct, two-way integration point with Econolite Cobalt traffic signal controllers to obtain high-resolution data.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G23,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[3.2,{"$f":"B23","v":"Integration Points"},"Functional","System Interoperability","Must Have","Please describe your solution's ability to operate in parallel with the TransSuite central traffic signal system. If the solution fails, the existing TransSuite system and local controllers shall not be negatively impacted.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G24,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[3.3,"Integration Points","Functional","Network Security Devices","Must Have","Please indicate and describe if you solution is able to fully function between network security devices (i.e., firewalls).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G25,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[{"$f":"A22+1","v":4},"File Types/Support"]
[{"$f":"A27+0.1","v":4.0999999999999996},"File Types/Support","Functional","Exporting","Must Have","Describe how your solution's ability to export common file types that include Microsoft Office (Excel, Word, etc.) and Adobe PDF.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G28,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[5,"User Interface and Features"]
[{"$f":"A30+0.1","v":5.0999999999999996},{"$f":"B30","v":"User Interface and Features"},"Functional","Visual Graphical Information","Must Have","Describe your solution's ability to display performance measures in a graphical format.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G31,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[5.1999999999999993,"User Interface and Features","Functional","Dashboard","Should Have","Describe your solution's ability to provide dashboards configurable for each user and each performance measure the user wishes to see.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G32,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[{"$f":"A30+1","v":6},"Reports and Templates"]
[{"$f":"A34+0.1","v":6.1},"Reports and Templates","Functional","Canned Reports","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(G35,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.2,"Reports and Templates","Functional","Customizable Reports","Must Have","Please describe your solution's ability for users to design, and generate customized reports.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G36,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.3,"Reports and Templates","Functional","Ad Hoc Reporting Templates","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(G37,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.3999999999999995,"Reports and Templates","Functional","Exporting Report Format","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(G38,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.4999999999999991,"Reports and Templates","Functional","User Customizable Data","Must Have","Please describe your solution's ability to allow users to create reports that are customizable by timeframe and data interval.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G39,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.5999999999999988,"Reports and Templates","Functional","Querying and Automated Reports","Must Have","Please describe your solution's ability to create automated reports and reports based on a specific query.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G40,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.6999999999999984,"Reports and Templates","Functional","High Level Summaries","Should Have","Please describe your solution's ability to produce reports that are high level summaries for decision makers and detailed for use in operations and troubleshooting.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G41,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.799999999999998,"Reports and Templates","Functional","Comparisons","Must Have","Describe how your solution produces reports that compare current operations to past performance at the same intersection.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G42,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[6.8999999999999977,"Reports and Templates","Functional","Automatic Alerts","Must Have","Please describe how your solution alerts specific users via email or text based on triggers.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G43,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[{"$f":"A34+1","v":7},"Record Retention"]
[{"$f":"A45+0.1","v":7.1},{"$f":"B45","v":"Record Retention"},"Functional","Data Retention","Must Have","Describe how your solution stores logs, alarms, and reports for a set amount of time where they are easily accessible.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G46,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[7.2,{"$f":"B45","v":"Record Retention"},"Functional","Policies","Could 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(G47,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[7.3,{"$f":"B46","v":"Record Retention"},"Functional","Logs","Must Have","Describe how your solution provides near real-time logs (within 15 minutes).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G48,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[]
[8,"Performance Measures"]
[{"$f":"A50+0.1","v":8.1},{"$f":"B50","v":"Performance Measures"},"Functional","Split Monitor","Must Have","Describe your solution's ability to analyze data, create and report split monitoring performance measures for when duration of traffic signal phases.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G51,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[{"$f":"A51+0.1","v":8.1999999999999993},{"$f":"B50","v":"Performance Measures"},"Functional","Pedestrian Delay","Must Have","Describe your solution's ability to analyze data, create and report performance measures for pedestrian delay.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G52,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[{"$f":"A52+0.1","v":8.2999999999999989},{"$f":"B51","v":"Performance Measures"},"Functional","Purdue Coordination Diagram","Must Have","Describe your solution's ability to analyze data, create and report Purdue Coodination Diagram performance measures using arrivals of vehicles during green, yellow, and red phases.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G53,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.3999999999999986,"Performance Measures","Functional","Purdue Split Failure","Must Have","Describe your solution's ability to analyze data, create and report Purdue Split Failure performance measures using green and red occupancy ratios.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G54,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.4999999999999982,"Performance Measures","Functional","Purdue Phase Termination","Must Have","Describe your solution's ability to analyze data, create and report Purdue Phase Termination performance measures (gap out, max out, force off, skip, and pedestrian activity).","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G55,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.5999999999999979,"Performance Measures","Functional","Turning Movement Counts","Should Have","Describe your solution's ability to analyze data, create and report report vehicle volumes by lane and lane group.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G56,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.6999999999999975,"Performance Measures","Functional","Approach Volume","Must Have","Describe your solution's ability to analyze data, create and report report vehicle volume by intersection approach.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G57,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.7999999999999972,"Performance Measures","Functional","Approach Delay","Must Have","Describe your solution's ability to analyze data, create, and report total vehicle delay and average vehicle delay by intersection approach.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G58,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.8999999999999968,"Performance Measures","Functional","Approach Speed","Must Have","Describe your solution's ability to analyze data, create, and report average speeds and 85th percentile speeds by intersection approach.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G59,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[8.9999999999999964,"Performance Measures","Functional","Arrivals on Red","Must Have","Describe your solution's ability to analyze data, create, and report performance measures for the number or percentage of vehicles arriving during red lights.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G60,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[9.0999999999999961,"Performance Measures","Functional","Number of Preemptions","Must Have","Describe your solution's ability to analyze data, create, and report preemption requests.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G61,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[9.1999999999999957,"Performance Measures","Functional","Length of Preemptions","Should Have","Describe your solution's ability to analyze data, create, and report preemption service duration.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G62,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[9.2999999999999954,{"$f":"B61","v":"Performance Measures"},"Functional","Queue Length","Should Have","Describe your solution's ability to analyze data, create, and report the length of vehicle queues behind a stop bar.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G63,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[9.399999999999995,{"$f":"B62","v":"Performance Measures"},"Functional","Bicycle Volume","Should Have","Describe your solution's ability to analyze data, create, and report bicycle volume by approach.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G64,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]
[9.4999999999999947,{"$f":"B64","v":"Performance Measures"},"Functional","Yellow and Red Actuations","Should Have","Describe your solution's ability to analyze data, create, and report when vehicles enter an intersection during the yellow or red phase.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(G65,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."}]

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