Laserfiche WebLink
12 SF RESIDENTIAL <br />13 IRRIGATION RECYCLED <br />14 INDUSTRIAL RECYCLED <br />15 COMMERCIAL RECYCLED <br />99 UNKNOWN <br />L One account in a Sub -Site is identified as primary for the purpose of <br />summary billing <br />d. Integrate with the billing system to receive billing date ranges and transmit <br />aggregate budgets for specified billing periods to the billing system <br />e. Retain 365 days of historical average weather data in the event of data <br />unavailability <br />i. Historical weather data shall be calculated on a rolling 5 year <br />average <br />ii. Initial historical weather data will be provided by Redwood City. <br />f. Automatically obtain daily weather information from data sources specified <br />by Redwood City as outlined below. <br />g. Flag weather data for quality control parameters and include alerts to City <br />staff when data is out of specified ranges <br />i. Provide a mechanism for City staff to override any individual weather <br />data variable <br />h. Provide a mechanism for Redwood City to alter the budget formula with <br />minimal intervention from CONSULTANT for the purpose of implement <br />water rationing, changes in water rates, budget calculation methodology, <br />etc. <br />i. Ability to display a secondary budget if necessary (i.e. Drought Budget, User <br />Specified Budget, etc.) <br />j. Ability to test or model water budget formula scenarios on individual <br />accounts, account groups, or classes of accounts. <br />k. An online survey should be provided for customers to request changes to <br />the water use factor variables. <br />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 />Page 35 of 38 <br />ATTY/AGR/2017.104/SMART ENERGY SYSTEMS—CUSTOMER WATER USE PORTAL <br />REV: 05-15-17 MI <br />