Gallon of water used

@Linn, @robertokc, @franz
I have cleaned up my excel workbook with automated graphs.
There is one tab to set up some initial calculations to

  • convert rachio gallons used into your “true” gallons used
  • based on your water bill (CCFs used and water related charges) calculate $/CCF
  • determine household base load (if on one meter only), and factor it in where necessary
    there is a Log tab to input what you pull from WU in terms of rainfall in your neighborhood (I use 3 stations for comparison of local rain events).
    Every tab has a commentary to make input easy.
    Once set up with your own data, the only thing to do is to input daily precipitation and irrigation. Rest is automated. Nothing is protected, so you could play with it and modify as you like.

I am more than happy to make this available as is, if desired, but I don’t know if there is a corner to upload user content other than jpg files? Franz, could you please advise?
Cheers
Heiri

1 Like