Easily estimate a water bill across any part of California with OWRS compliant water rate data specified. OWRS bill calculator refactoring tool of same name from MNWD.
Develop a bill calculator leveraging Open Water Rate Specification (OWRS) data. This tool would allow users to put in their address and water use for a given month and see the estimated bill for that month. Extensions include comparing that to other water utilities.
The MNWD_BillCalculator folder contains code from one specific utility. The goal of this winter sprint is to refactor and generalize that utility-specific code for use with any OWRS file from any local water retailer. A preliminary timeline for the project is shown below:
| Original Timeline | Deliverable |
|---|---|
| 12/22/17 | Kickoff meeting |
| ... | ... |
| 1/19/18 | Launch! |
ARGO team lead: Christopher Tull ( chris@argolabs.org )
RateParser was incorporated in the bill calculator tool. Selection element was added for users to specify their water district. Based on the selected district, the most recent OWRS information will be retrieved. The tool will calculate commodity charge, total bill, water use and charges in each tier shown in plots and table. Bill calculator is built compatible with different rate structures.
General background information on water rate design here. Especially pages 24+
Information on the Open Water Rate Specification (OWRS) is here.
There are lots of R Shiny tutorials here.