Exhibit B _ PA031_26 _ Functional Requirement.xlsx

XLSX spreadsheet 97 KB Posted

Attached to
PA031-26, Provision of Design, Implementation, and Maintenance of an E911 Community Engagement Solut
Solicitation number
PE-77023-NONST-2027-000000742
Issued by
Gwinnett County, Georgia

About this file

This file is a functional requirements scoring worksheet for Gwinnett County Police Department E911 Communications Division's solicitation for an E911 Community Engagement Solution. The document establishes evaluation criteria organized across two primary worksheets: Sheet 1 containing 47 Information Technology (IT) requirements and Sheet 2 containing 40 Business Requirements focused on survey management, reporting and analysis, and administration compliance. The requirements are designed to be scored differently based on three solution types—Cloud, Hybrid, and On-Premise—with varying point values of 20, 25, and 25 respectively. Each requirement is classified by importance level (High, Medium, Low) with corresponding point values (5, 3, 1), and vendors must select responses from dropdown menus indicating whether the proposed solution fully meets, partially meets, or does not meet each requirement. The maximum available points total 205 for IT requirements and 206 for Business Requirements, with normalized scoring calculations built into the worksheet structure.

Responding vendors must complete specified cells (E, F, G, H) with service provider information, solution type selection, compliance responses, and notes explaining any partially met requirements. The IT requirements encompass auditing and reporting, availability and reliability, security compliance (including SOC 2 Type 2, HIPAA, FedRamp, and encryption standards), supportability, and usability considerations. Business requirements focus on automated survey delivery via multiple channels (SMS, email), customizable survey templates and questions, sentiment analysis capabilities, real-time dashboarding, integration with Centralsquare CAD systems, multilingual support for community languages including Spanish, Korean, and Chinese, and comprehensive reporting with export functionality in Excel, CSV, PDF, and API formats. The worksheet includes mandatory compliance with accessibility standards (Section 508, WCAG 2.1 AA), role-based access control, and system administrator audit capabilities, with failure to complete all three response columns resulting in a zero score for any requirement.

View the file

Other files

File Type Posted
Exhibit C _ PA031_26 _ Pricing Proposal Respo.xlsx XLSX spreadsheet
Exhibit A _ PA031_26 _ Security Requirements .pdf PDF
PA031_26 INV.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Scoring Summary- HIDE

Scoring SummaryVendor
Solution TypeCLOUD
Scoring Total Point Value20
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotalRequirement row range for formulas
5315First rowLast rowException range
Functional Requirements Sheet 116045020500000000Sheet 1450
Functional Requirements Sheet 22006020600000000Sheet 24500
TOTAL36051041100000000
Scoring SummaryVendor
Solution TypeHYBRID
Scoring Total Point Value25
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotalRequirement row range for formulas
5315
Functional Requirements Sheet 116045020500000000Sheet 1450
Functional Requirements Sheet 22006020600000000Sheet 24500
TOTAL36051041100000000
Scoring SummaryVendor
Solution TypeON-PREMISE
Scoring Total Point Value25
Worksheet NameAvailable Raw PointScored Raw PointsNormalized Points
HighsMediumsLowsMaxHighsMediumsLowsTotalHighsMediumsLowsTotal
5315Requirement row range for formulas
Functional Requirements Sheet 113530016500000000
Functional Requirements Sheet 22006020600000000Sheet 145011-20
TOTAL33536037100000000Sheet 24200

&A &B Confidential&B Page &P

Functional Requirement Instruct

1.1 Completing the Functional Requirements Response Workbook
Step 1. Review the instructions on the first worksheet.

Step 2. Go to each tab/worksheet and enter your service provider in Cell F2 (Default value:"<Enter service provider Name>").

Step 3. Go to each tab/worksheet "Solution" and select the Solution Type from the drop-down options in Cell C2.

(This impacts the scoring and not scoring of solution type specific requirements in the workbook.)

Step 4. Go to each row in each of the worksheets and for each corresponding requirements select the response from columns F, G and H that reflects the current state of the proposed solution.

For any response that indicates "Yes - Partially met" for Availability, the vendor is required to include an explanation in the "Response Notes" Column E.

NOTE: Failure to complete all three response columns for a requirement will result in a score of zero (0) for that functional requirement. Failure to complete the Response Notes for "Partially met" items may also result in a zero or a degraded score. Further, Columns E, F, G and H are the ONLY columns in which the service provider should enter information. All other columns should are for internal use only and must not be altered by the service provider.

Additional detail on the columns in the worksheet is included in the Request for Proposal document.

Note : Light blue cells indicate response cells for the responding service provider.

TermMeaning
AgencyThis refers to the Gwinnett County Police Department E911 Communications Division.
Calls for ServiceRefers to an incident assigned to public safety or emergency services to respond to and resolve.
System AdministratorRefers to Gwinnett County personnel responsible for the configuration of workflows, user management, and support liaison with vendor.

&F

&D &A Page &P

DoITS Requirements Sheet 1

Req. IDCategoryImportanceRequirementResponse NotesCompliance Response
AvailabilityCompliance Response
EnvironmentCompliance Response
DeliveryTally
(H,Full)Tally
(H,Part)Tally
(H,No)Tally
(M,Full)Tally
(M,Part)Tally
(M,No)Tally
(L,Full)Tally
(L,Part)Tally
(L,No)Availability scoreEnvironment ScoreTotal weighted scoreMaximum available scoreScorer CommentsTraceability
SOLUTION TYPEService Provider Name <Insert Service Provider Name>520310100(1,.25,0,0)
The proposed solution…....
IT-1Auditing and ReportingMedium... includes the ability to capture and access reporting on usage statistics.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-2Auditing and ReportingHigh... includes and retains audit information based upon configured rules.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-3Availability and ReliabilityHigh... fits within the County’s disaster recovery and business continuity plans for the organization. The County may require proof prior to final award.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-4Availability and ReliabilityHigh... includes redundancy and can be deployed without a single point of failure.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-5Availability and ReliabilityMedium... provides a high availability architecture or configuration options to operate as such.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-6Availability and ReliabilityMedium... provides horizontal scalability and redundancy to all levels of the architecture/infrastructure.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-7Availability and ReliabilityHigh... provides solution and data backups.

- For on-premise solutions, it provides for full and incremental backups to support a fail-safe backup strategy.

- For hosted solution, it provides a fail-safe backup.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-8Cloud & Hybrid SolutionHigh... is SOC 2 Type 2 compliant. As such the service provider will provide a System and Organization Control (SOC) 2 Type 2 report with an Unqualified opinion prior to final contract award.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-9Cloud & Hybrid SolutionHigh... provides Data Security, including safeguards against unauthorized access and disclosure of confidential, sensitive, and personally identifiable information (PII).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-10Cloud & Hybrid SolutionHigh... provides detailed logs of audit events and makes these logs continuously available for ingestion by a security information and event management solution (SIEM) without the need to manually download or transfer data.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-11Cloud & Hybrid SolutionMedium... is NIST 800-53 Compliant.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-12Cloud & Hybrid SolutionMedium... is SSAE16 Certified.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-13Cloud & Hybrid SolutionMedium... enables software updates and patches automatically applied within 30 days for critical updates/patches and immediately for vulnerability with a known exploit.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-14Cloud & Hybrid SolutionMedium... is compatible with Microsoft DLP.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-15Cloud & Hybrid SolutionMedium... provides high-availability architecture implementations that support 99.99 uptime or better.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-16Cloud & Hybrid SolutionHigh... meets HIPAA Compliance rules and guidelines.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-17Cloud & Hybrid SolutionHigh... and service provider(s) guarantee all County owned data is stored within the continental United States of America.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-18ComplianceHigh... enables access to custodians of documents subject to the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and the rules adopted under it and prohibit unauthorized access.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-19ComplianceHigh... is compliant with Section 508 of the Rehabilitation Act of 1973 to provide for accessibility of information technology by the handicapped.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-20ComplianceHigh... supports compliance with the State of Georgia Open Records Act (50-18-71 Article 5).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-21ComplianceMedium... supports the use and security of digital signatures (as authorized by the Georgia Electronic Signature Act, Title 10 Chapter 5) and should follow the Georgia Uniform Electronic Transactions Act.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-22ComplianceHigh... enables compartmentalization of documents identified by their creators as judicial work product, attorney privileged, confidential, personally identifiable information (PII), protected health information (HPI), etc. so that only authorized users may access them and those users are aware of their classification.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-23SecurityHigh... remote access capabilities are compatible with the existing enterprise remote access solutions (Global Protect and Cisco AnyConnect).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-24SecurityHigh... meets the requirement that all service provider personnel and contractors accessing the data are based in the continental United States.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-25SecurityHigh... enforces unique usernames.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-26SecurityHigh... does not store authentication credentials or sensitive data in its code.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-27SecurityHigh... includes an interface for assigning, reporting, certifying, and modifying permissions based on user.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-28SecurityHigh... meets or exceeds any and all encryption standards for data storage, access, and transmission as outlined in Exhibit A.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-29SecurityMedium... provides file encryption capabilities within the solution and allows storage of data that has been encrypted by other encryption platforms (and continue to maintain those encryption levels).Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-30SecurityHigh... is certified FedRamp High or StateRamp.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-31SecurityHigh... provides roles and permissions assigned individually and by group or role.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-32SecurityHigh... ensures end-to-end encryption of data in transit.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-33SecurityHigh... ensures end-to-end encryption of data at rest.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-34SecurityHigh... ensures end-to-end encryption during backup and retrieval.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-35SupportabilityHigh... has uptime availability that meets or exceed a 99.5% service level to meet County requirements, excluding planned maintenance.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-36SupportabilityHigh... is configurable.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-37SupportabilityHigh... does not require a “heavy client” installation on the individual workstations or on-site servers.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-38UsabilityHigh... provides users with a intuitive user interface that requires no coding experience and requires less than two hours of user training.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-39UsabilityMedium... provides a user interface that uses standard MS Windows-like layout and navigation features.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-40UsabilityHigh... provides the ability to use and create context sensitive tooltips or other similar online help feature.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-41UsabilityMedium... provides context sensitive Online Help.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-42UsabilityMedium... provides context menus accessible on a right mouse click or other one-step access.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-43UsabilityHigh... provides a Web-Enabled User Interface.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-44UsabilityMedium... adheres to Usability Design best practices in its construction (e.g., ISO 9241).Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-45UsabilityMedium... includes computer-based training (CBT) or online training modules.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
IT-46UsabilityHigh... allows all user components to be available to users through one common interface (user does not have to move between applications) to perform their work.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
IT-47UseabilityHigh... is compatible with multiple browsers including the following ones at a minimum: Edge, Google Chrome, Mozilla Firefox, and Safari.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Totals000000000000205

&F &A

&D &A Page &P

Business Requirements Sheet

Req. IDCategoryImportanceRequirementResponse NotesCompliance Response
AvailabilityCompliance Response
EnvironmentCompliance Response
DeliveryTally
(H,Full)Tally
(H,Part)Tally
(H,No)Tally
(M,Full)Tally
(M,Part)Tally
(M,No)Tally
(L,Full)Tally
(L,Part)Tally
(L,No)Availability scoreEnvironment ScoreTotal weighted scoreMaximum available scoreScorer CommentsTraceability
SOLUTION TYPE<Insert Company Name of Responding vendor>520310100(1,.25,0,0)
The proposed solution…....
Survey ManagementHigh…automatically sends surveys following 911 and non-emergency calls for service.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…sends surveys based on agency set configurations.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to determine the call type associated with a survey.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to determine the incident type associated with a citizen survey.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to determine the disposition type associated with a survey.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to determine the timelapse before a survey is sent.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to customize survey questions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to customize survey response options.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…allows the agency to customize survey templates.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…supports survey delivery via text message (SMS).Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…collects survey comments.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…collects survey compliments.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…collects survey complaints.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…collects survey suggestions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementHigh…integrates with Centralsquare Enterprise Computer Aided Dispatch (CAD) system.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Survey ManagementMedium…supports Gwinnett community languages such as Spanish, Korean, Simplified Chinese and Traditional Chinese.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
Survey ManagementHigh…prevents duplication of responses through IP filtering, device fingerprinting, or token-based validation.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…conducts sentiment analysis through automated classification of open text responses.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…identifies and links calltaker, call taker supervisor, and shift supervisor to survey.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…automatically sends positive feedback to calltaker.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…automatically sends negative feedback to calltaker supervisor and shift supervisor without notification to calltaker.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…supports real-time dashboarding with charts, heatmaps, and trend lines.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…supports display of real-time feedback and satisfaction scores inside the E911 Communication Center.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…ability to filter and analyze data by date.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh...ability to filter and analyze data by call type.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh...ability to filter and analyze data by call taker.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh...ability to filter and analyze data by shift.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh...ability to filter and analyze data by team.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…tracks and reports survey participation rates.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…tracks and reports satisfaction scores.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…tracks and reports survey trends.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…tracks and reports complaints.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…tracks and reports positive employee recognition.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…exports reports into Excel.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…exports reports into CSV.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisHigh…exports reports into PDF.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Reporting and AnalysisMedium…exports reports into API endpoints.Select from drop down listSelect from drop down listSelect from drop down list0000000000003
Administration and ComplianceHigh…meets WCAG2.1 AA compliance for ADA accessibility.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Administration and ComplianceHigh…supports role based access control.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Administration and ComplianceHigh…provides system administrators the ability to change roles and associated permissions.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Administration and ComplianceHigh…provides management with management specific portal to access all survey and feedback data.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Administration and ComplianceHigh…provides system administrators with system activity audit logs.Select from drop down listSelect from drop down listSelect from drop down list0000000000005
Totals000000000000206

&F &A

&D &A Page &P

File details come from the government source that posted it. Updated .