AgdaPkt 2021.03.22 Joint SA PFA - Laserfiche WebLink

Browse Search

6.E. - Page 48 of 73 Aa eernent for Truef tint Services Exhibit D — Nater Budget Methodolpyi d. There shall be no limit to the number of primary and secondary water use type budgets a named budget formula can be applied to, (i.e. a single budget formula can be applied to primary for WUT 12 and 5, and also secondary for WUT 5, It may also be that there is a separate formula. for each WUT and each primary and secondary formula.) e. budget formulas shall have a "save as" function, so authorized users can make copies from a known/bested starting point. f: Budget formulas shall be editable in part or whole without the need to re-create the complete formula should only one change be required.. There: shall be a way to validate the syntax of a budget formula upon or prior to saving the formula. Only validated formulas can be assigned as primary or secondary budget, 4w A water budget shall be calculated daily for each subsite for the previous day, and transmitted to the City's My Water Customer Portal for customer use. 5. Following the completion of a consumption period. and prior to billing an account a water budget shall be calculated for the full consumption period within a billing: cycle for each subsite, fi. A water.budget shall :be calmlate.d for closing accounts from the beginning of the consumption period through the date the account Is closed. This calculation shall be complete prior to the calculation of charges and printing of a closing statement, 7. There shall be a 'Weather Data Override Period which enables authorized users to manually enter or edit ETo and Precip data. a.. The Weather Data Override Period is a dynamic date range that affects budget calculation's for all accounts/subsites and prevents budgets from being recalculated in part or in whole for accounts that have been billed. Weather data Is only editable for dates between today and the most recent unbilled date that falls within the consumption period for any water account. 8. TruePoint shall work with the City to establish the Ideal order of operations for each step in the budget calculation process. The following provides an Initial processing order which may need to. be refined. based upon organizational needs, changes to CIMIS and WU services, and related Integrations with other software systems. a. Make initial request for ETo through the. CIMIS API i. if CIMIS is unavailable or returns an error the application shall wait 5 minutes and retry. ii. A Natal of 3 attempts shall be made dally to retrieve ETo (1 initial, 2 retries) iii. If all 3 attempts fail to collect ETo for a target date the system shall skip the calculations for NIR and use a historical average NIR value as a placeholder for the target date (typically yesterday).. iv. The application shall attempt to obtain ETo from CIMIS each day following a failure to obtain ETo for a target date until one of the following conditions are met. 1. An authorized user manually enters an ETo value for the target date. 2. The Weather luta Override Period has ended: (in this case the historical placehoider shall become a permanent part of the water budget for the target date.) b. Mabe initial request for Precip through the WU API REV, 04-13-19 PR Page 39 of 64 ATTY/AOF2.2019.1061TruePoint TrueBiil Utility Billing Syst®m Nater Budget Methodology Page - 3U6 .