Laserfiche WebLink
<br /> <br />Redwood City Public Works Services <br />Customer Water Use Portal RFP <br />Attachment A – Customer Portal Requirements 2 <br /> <br />c. One account in a Sub-Site is identified as primary for the purpose of summary billing <br />d. Provide a link to the City’s online survey for customers to request changes to the <br />water use factor variables or provide a method of collecting water use factor <br />variables. <br />8. Calculate Residential and Irrigation water budgets as described in Attachment B, and <br />including the following parameters. <br />e. Graphically display daily water budgets for individual or grouped accounts using <br />billing system identifiers <br />i. The solution shall integrate with the City’s Utility Billing System which <br />maintains a process to group accounts that share a water budget using one <br />unique value called “Site ID” and a coded water use type classification and <br />identifier for a primary account within a Sub-Site. <br />f. Integrate with the billing system to receive billing date ranges and transmit aggregate <br />budgets for specified billing periods to the billing system <br />g. Retain 365 days of historical average weather data in the event of data unavailability <br />i. Historical weather data shall be calculated on a rolling 5 year average <br />h. Automatically obtain daily weather information from data sources specified by <br />Redwood City <br />i. Flag weather data for quality control parameters and include alerts to City staff when <br />data is out of specified ranges <br />i. Provide a mechanism for City staff to override any individual weather data <br />variable <br />j. Provide a mechanism for Redwood City to alter the budget formula with minimal <br />intervention from the Proposer for the purpose of implement water rationing, <br />changes in water rates, budget calculation methodology, etc. <br />k. Ability to display a secondary budget if necessary (i.e. Drought Budget, User Specified <br />Budget, etc.) <br />l. Ability to test or model water budget formula scenarios on individual accounts, <br />account groups, or classes of accounts. <br />m. Budget Formulas shall include the following components: <br />i. Ability to add, edit, and delete formula constants <br />ii. Ability to add, edit, and delete formula account specific variables <br />iii. Ability to add, edit, and delete formula functions <br />iv. At a minimum the ability to compose mathematical calculations using <br />constants, variables, and functions with the following operators <br />1. Parenthesis <br />2. Addition <br />3. Subtraction <br />4. Multiplication <br />5. Division <br />9. For the City’s consideration a Proposer may choose to propose additional items or features <br />their solution is capable of delivering as separate items to this proposal. <br />6.1.E. - Page 53