{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["394-22 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":"394-22 Requirements","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"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]]}
["RFQ # 394-22"]
["Golf Point of Sale 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, 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","Mobile Access",null,"Must Have","Describe your solution's ability for mobile access and interface for both the back end and public access views, including both Apple and Android platforms.","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","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(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.>"]
[1.6000000000000005,"General Inquiry","Functional","Attachments",null,"Should Have","Describe your solution's ability to attach supporting documents to records within your system (e.g., purchase orders, etc.)","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.7000000000000006,"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(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.>"]
[]
[2,"Licensing/User Roles"]
[{"$f":"A19+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(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":"A20+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(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.>"]
[]
[3,"Financial Transactions"]
[3.1,"Financial Transactions","Functional","Wells Fargo Integration",null,"Must Have","Please describe your solution's ability to currently be able to integrate with Wells Fargo gateway for credit card processing.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H24,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[3.2,"Financial Transactions","Functional","Receipt Printing",null,"Must Have","Please describe your solution's ability to print off physical receipts and/or email copies to the Thorncreek customer.","Cannot Meet",{"$f":"IFERROR(VLOOKUP(H25,VendorResponseLookupTbl[], 2,0), \"\")","v":" The product cannot meet the requirement “Out-of-the-Box”, “With Configuration”, “With Custom Programming” or with a “Future Release”."},"<Please use this space to note what product/module of the solution is required to address the requirement.>"]
[3.3,"Financial Transactions","Functional","Cash Drawers",null,"Must Have","Please describe your solution's ability to open a physical cash drawer when using your solution, whether cash is being dispensed or not (if your solution is a \"smart\" or \"dumb\" cash drawer system.","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.>"]
[]
[4,"Online Interactions"]
[4.0999999999999996,"Online Interactions","Functional","Scheduling Tee Times",null,"Must Have","Please describe your solution's ability to provide real-time schedule availability and tracking of appointments for tee time scheduling","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.2,"Online Interactions","Functional","Scheduling Lessons",null,"Must Have","Please describe your solution's ability to provide real-time schedule availability for golf lessons","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.3,"Online Interactions","Functional","Payments",null,"Must Have","Please describe your solution's ability to process payments, including online for various functions (e.g., tee times, lessons, etc.)","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.4000000000000004,"Online Interactions","Functional","Dynamic Pricing",null,"Must Have","Please describe your solution's ability to utilize a dynamic-based pricing module that is a flexible pricing based on current business levels of demand and availability at the course.","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.>"]
[]
[5,"Inventory Tracking"]
[5.0999999999999996,"Inventory Tracking","Functional ","Inventory MGMT - Restaurant",null,"Must Have","Please describe your solution's ability to provide inventory management for restaurant business operations, including the ability to input orders that have been placed.","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.2,"Inventory Tracking","Functional ","Inventory MGMT - Golf",null,"Must Have","Please describe your solution's ability to provide inventory management for golf operations, including the ability to input order that have been placed.","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.3,"Inventory Tracking","Functional ","Barcode Scanning",null,"Must Have","Please describe your solution's ability for using barcodes to scan merchandise, including how your system performs this task.","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.>"]
[]
[6,"General Reporting Functions","Functional"]
[{"$f":"A39+0.1","v":6.1},"Financial Reporting","Functional","Canned Reports",null,"Should Have","Please describe what other canned reports your solution has in terms of financial reporting capabilities.","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":6.1999999999999993},"General Reporting Functions","Functional","Templates and Ad Hoc",null,"Should Have","Please describe your solution's ability to run reports on an ad hoc basis, and if these reports can be saved and/or customizable for later reuse by Thornton.","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":"A41+0.1","v":6.2999999999999989},"General Reporting Functions","Functional","Scheduled Reporting",null,"Should Have","Please describe your solution's ability to run reports by setting them to run on a scheduled periodic run (Daily, weekly, monthly, etc.)","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.1","v":6.3999999999999986},"Financial Reporting","Functional","Flat File",null,"Must Have","Please describe your solution's ability to accommodate a flat file that is comma delimited for Thornton to be able to have that file readable by our financial system, JD Edwards.  Your solution does NOT need to directly interface with JD Edwards.","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.4999999999999982},"General Reporting Functions","Functional","Exporting Files and Reports",null,"Must Have","Please describe your solution's ability to export files and reports into a common, usable electronic format for Thornton (i.e., Microsoft Office, Adobe, .csv, etc.)","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,"Financial Reporting","Functional"]
[{"$f":"A46+0.1","v":7.1},"Financial Reporting","Functional","Financial - Golf Operations",null,"Must Have","Please describe your solution's ability to provide financial reporting on Golf Operations for various types of reporting, including but not limited to:\n\na) Daily general ledger summary\nb) Daily cash journals\nc) Credit card reporting\nd) Tax collected\ne) What services have been rendered ability to filter ","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},"Financial Reporting","Functional","Financial - Restaurant Operations",null,"Must Have","Please describe your solution's ability to provide financial reporting on Restaurant Operations for various types of reporting, including but not limited to:\n\na) Daily general ledger summary\nb) Daily cash journals\nc) Credit card reporting\nd) Tax collected\ne) What services have been rendered ability to filter\nf) Beverage and food sales with an ability to filter ","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},"Financial Reporting","Functional","Gift Certificates",null,"Should Have","Please describe your solution's ability to track and report out on outstanding gift certificates, including but not limited to, balances, who purchased the certificate, who the certificate was made out to, etc.","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.>"]
[]
[8,"Operations Reporting","Functional"]
[{"$f":"A51+0.1","v":8.1},"Operations Reporting","Functional","Inventory MGMT - Restaurant",null,"Should Have","Please describe your solution's ability to report on inventory levels, including setting reorder points (e.g., Min/Max levels)","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.>"]
[{"$f":"A52+0.1","v":8.1999999999999993},"Operations Reporting","Functional","Scheduling Reporting",null,"Should Have","Please describe your solution's ability to report on how many golf lessons have been scheduled, and with who from Thornton those have been scheduled with.","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.>"]
[]
[9,"Optional Items","Non-Functional"]
[9.1,"Website Design","Non-Functional","Website Design",null,"Could Have","Please describe your solution's ability to aid Thornton in designing and implementing a website","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.>"]
[{"$f":"A56+0.1","v":9.1999999999999993},"Event Management","Non-Functional","Event Registration",null,"Could Have","Please describe your solution's ability to create individual events by Thornton, and for the general public to then sign up for those events.","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.>"]
[9.2999999999999989,"Event Management","Non-Functional","Live Scoring and Leaderboards",null,"Could Have","Please describe your solution's ability to create live scoring and leaderboards that are viewable on a dedicated screen and/or mobile application","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.>"]
[9.3999999999999986,"Event Management","Non-Functional","Printing Tee Sheets",null,"Could Have","Please describe your solution's ability to create and print off tee sheets.","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.>"]
[9.4999999999999982,"Event Management","Non-Functional","Cart Signs",null,"Could Have","Please describe your solution's ability to create and print off cart signs (not vehicle wraps).","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.>"]
[9.5999999999999979,"Event Management","Non-Functional","Score Cards",null,"Could Have","Please describe your solution's ability to create and print off score cards","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.>"]
[9.6999999999999975,"Event Management","Non-Functional","Event Payment",null,"Could Have","Please describe your solution's ability to allow for the general public to pay for events online.","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.>"]

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