Metermaid, Programming, WordPress

Metermaid: Easy Water Meter Tracking, Powered By WordPress

My house’s water is supplied by a well. This well is shared with a dozen other houses, all of which have water meters to track usage. Several years ago, I was volunteered to be the president of this water association, and with this position came the responsibility for tracking water usage to ensure that we’re not losing water to leaks or unauthorized usage.

For a couple of years, I just used a spreadsheet to track meter readings, but I felt like the data I was collecting could be so much more useful in a custom-built application, so I built Metermaid.

Metermaid is a WordPress plugin that adds a dashboard for tracking meter readings. Once you’ve entered some readings, it will begin charting gallons per day over time, comparing usage from this year against previous years, and even highlighting situations where water is potentially being lost due to broken pipes. It’s useful for tracking a single meter or tracking hundreds of meters.

To get started, install and activate Metermaid (available on Github) and then open the “Metermaid” menu item:

Click “Add Meter” to add your meters.

Once you enter meter readings, you will see charts showing gallons per day compared across years and gallons YTD compared across years.

Scroll down, and you’ll see all previous readings.

What are child meters and parent meters?

Metermaid supports the concept of “child meters” and “parent meters.”

A child meter is a meter that only counts usage that is already counted by a meter further upstream (the parent meter).

Imagine you have a well. At the well, there is a pump, and the pump pushes water to three houses. Directly after the pump, there is a meter that counts all gallons that the pump outputs. This is the parent meter. The three house meters are child meters. Their combined readings should equal the reading of the parent meter.

When you set up child and parent meters and then enter readings for all meters in a system on the same days, Metermaid will calculate how much water might be getting lost in the system, either through leaks or unmetered usage. For example, this real-world example shows a parent meter that measured 6.3% higher than the sum of its children meters across a six-month period.

This discrepancy could be due to unmetered water usage, inaccurate meters, or a leak in the distribution system. (It was a leak in the distribution system — an old repair had failed, but with this Metermaid feature, I was able to track it down and get it fixed.)

What is a supplement?

Metermaid also supports the concept of supplementary water. “Supplements” are a way to track water that is added to a system between a parent and a child meter.

Imagine you have a well, and a pump pumps water from the well into a holding tank, from which three houses draw. Your well pump breaks, so you have water delivered directly into your holding tank. Without tracking this supplementary water, it will appear that the houses have used more water than the well provided.

“Real” readings

Metermaid also solves the annoying issue of meter rollovers by using “real readings.” Imagine you have a water meter that reads 999999. The next day, you check the meter, and it reads 000001. Even though the meter shows a single gallon, its real reading is actually 1,000,001 gallons. Metermaid automatically calculates what the true reading of a meter is based on previous readings.

Real readings are recalculated any time you add or delete a reading, so adding historical meter data will only make them more accurate.

It is possible for the real reading to be wrong due to lack of data. If you read a 6-wheel meter on January 1 and it reads 500000 and then you check it again on February 1, and it reads 600000, there’s no way to know whether it measured 100,000 gallons or 1,100,000, and Metermaid will assume 100,000. If you added a reading from January 15 of 900000, then Metermaid would correctly update the real reading to 1600000.

Metermaid is available for free on Github. Contact me with any questions.

Standard

One comment on “Metermaid: Easy Water Meter Tracking, Powered By WordPress

  1. Anonymous says:

    Christopher- Great stuff, I’ve been operating our system of 54 homes for quite a few years. Always felt the need to upgrade the handling of data. I will continue to investigate Metermaid. Sounds like it will be helpful
    Mark Elias
    FERN VALLEY ESTATES IMPROVEMENT DISTRICT (FVEID)

Leave a Reply

Your email address will not be published. Required fields are marked *