CORE & MAIN LP (#2027021) - Laserfiche WebLink

RFP-2 – Scope of Work RFP# PWD 25.604 City of Pleasanton, CA RFP-2 | Page 32 Internal Use Only 2.5.4.Reporting 2.5.4.1 Standard Reports The Contractor shall ensure that the AMI Software solution includes a simple, flexible reporting tool that allows utility user to query data for specific Customers or groups of Customers consumption data. The tool shall allow the Users to add or remove fields, filter, or adjust the criteria of the report based on User’s requirements. The Contractor shall ensure that the modified or standard reports shall be able to be saved by the User, so they can re-use the reports in the future. The Contractor shall ensure that the AMI Software can produce standard reports that can be downloaded as a PDF file or in Excel format for further analysis and action. The Contractor shall ensure that the downloaded PDF, CSV, reports are able to filter, sort, and modify without having to manipulate the data due to formatting limitations (merged cells). 2.5.4.2 Customizable Reports The Contractor shall ensure that the AMI headend software shall have a robust reporting tool that allows Utility User customizable queries to be built. The reporting tools should allow for fields to be added or sequenced differently; filters to be applied; or criteria and ranges to be added to the query. 2.5.4.3 Special Reports Where the standard or customized report is deemed inadequate, the Contractor shall develop special reports that can be run efficiently from the AMI Software and support the City’s operational needs. Special reports will be defined through a business requirement document and quoted by the Contractor on a report-by-report basis. 2.5.4.4 Scheduling Reports The Contractor shall ensure that the reports to be run on both ad hoc and scheduled times and support both static (specific meter groups that do not change) and dynamic reporting groups (allows for several conditions to be set) are able to be created. The Contractor shall ensure that the AMI Software notifies the User of real time alerts via e-mail or text message for specific City-specified events. 2.5.4.5 Meter Management Reporting The Contractor shall ensure that the AMI Software solution has the ability for the User to select the pre-defined thresholds reporting on specific events that occur with the system. 2.5.4.6 On Demand Readings The Contractor shall ensure that the AMI System can perform on-demand readings and receive a register read no more than four hours old for all AMI meters on an individual or global basis. The AMI shall have the ability to obtain all interval data for a specific date range and register values at the time of the reading. 2.5.4.7 Performance Metrics The Contractor shall ensure that the AMI Software solution can provide performance or diagnostics information with respect to the AMI meters and network equipment. Docusign Envelope ID: 6AD75F50-8A33-85A5-8039-9E3E1257A838Docusign Envelope ID: 177582DA-4F1C-8834-813C-BC4FD03AA45E