A couple of months ago, I got a wild hare and decided to dig out all of the meter records and such I have beginning from when we moved up here and activated the water company.
I started entering everything from the last 8 or 9 years into a big Excel sheet (dates, well meters, well electrical usage, and total shareholder use) and then played with different ways to crunch it.
So, now I know interesting things like:
How many cubic feet we produced each year, and how much electricity we consumed.
How many cubic feet per kilowatt hour each well pumps. If this started to slip, there's a problem with the pump.
What percentage of the total production each well does. This depends to some extent on the automated well rotation schedule.
And, how much loss we have in each billing period. That is, what percentage of water was metered to the customer vs: how much we pumped out of the ground. In our case "Loss" is something of a misnomer, as some unmetered water is used to backwash the sand filter, and some was sold from hydrants to trucks or on-site for construction water. Anything else is cumulative meter inaccuracies, leaks, or the time a truck knocked off a hydrant.
It's interesting as well, to see how the production and use rise in the dry season, and drop in the wet season.