#Sensus water meter wiring diagram code#

I used a one minute interval and, initially, the function did the roll one cell at a time in a loop but I hit my daily quota for processing time with Google. Google Javascript - Google provides an interval timer which will trigger a function call. Google sheet works well for me but this approach is not a scalable product. At the appropriate time, the summary data is rolled up one row by a Javascript function. The calculations sum minutes into 5 minute intervals, minutes into hours, hours into days, days into months and months into years for display in the charts. I will have to manually move the history to another location but that should not be for 6 months or possibly more. At one minute intervals the system collects 1,440 records a day. The AppSheet graphs work better with stand alone sheets. Google sheet - I use separate sheets for: 1) the database (timestamp and gallons every minute), 2) calculations, and 3) a separate sheet to list the data used in each chart (year, month, day, hour, minute). Refer to their project descriptions for additional instructions.

#Sensus water meter wiring diagram code#

Particle Proton - The C++ code came primarily from Christopher Cope with the Google interface from Gustova Gonnet. I decided on the cable since the HMC5883L is sampling constantly and the Proton is always on so maintaining a battery would be an issue. All of the electronics are enclosed in water resistant enclosures. A 120 volt power supply provides 5 volts to the Proton using a USB mini connector, the Sandbox devices also need 5 volts and and two step down voltage regulator supplies 3.2 volts for the I2C signal and the HMC5883L. The bidirectional traffic and power for the HMC5883L is over a CAT6 cable buried underground. The Proton is located next to the house near a 120 volt power source and within range of my wifi and the HMC5883L is attached to the water meter. Sandbox provided good documentation and answered all of my questions via email. I found a pair of devices by Sandbox Electronics that converts the I2C protocol to a bidirectional protocol using an NXP PCA9600 at 12 volts for the extended distance. Since the HMC5883L communicates using I2C which is a very short range protocol, I needed an alternative. The meter was also next to the street and in the open which eliminated some options. Unfortunately, my water meter is encased in a cement enclosure about 60 feet from the house which was far enough away that the WIFI reception on the Proton was nonexistent. Getting the HMC5883L connected to the Proton and changing the code to report activity (passing a magnetic over it) on my Particle dashboard was pretty straight forward. Additionally, Sparkfun has documentation on the HMC5883L and their breakout board which was very helpful. Christopher Case did the preliminary work in helping to understand how the HMC5883L works with the water meter and connection to the Proton. This process counts the number of oscillations and converts it to gallons (or liters ). It reduces the piston oscillations into volume totalization units displayed on the register dial face.' In other words, for this process to work, you need a meter that has a magnet driving the meter. The driven magnet is connected to the register gear train. A drive magnet transmits the motion of the piston to a driven magnet located within the hermetically sealed register. The hydrodynamically balanced piston oscillates around a central hub, guided by the division plate. Per the meters datasheet, 'Water flows through the meterвЂ™s strainer and into the measuring chamber where it drives the piston. So far I've had to learn a little C++ for the Proton and Javascript for the Google sheets and an addon to Google sheets called AppSheets but I'm pretty familiar with Excel so constructing the sheet was not a problem and the rest just takes a little time and effort. I discovered Gustavo Gonnet's project on saving data on Google sheets and I knew I had an answer I could deal with. Since I know nothing about that, I began looking for alternatives. Cope suggested InfluxDB as a database and Grafana as the presentation program. I then discovered Christopher Cope's work with the Particle Proton and the HMC5883L magnetometer and began investigating further. The only thing I could find would cost about $750 and would only monitor my landscape water utilization. I was able to buy an application that connects to my PG&E Smart Meter to report real time usage on my iPhone so I was looking for something similar for my water meter. With the California drought and a relatively high water bill, I decided that monitoring my water usage would be a worthwhile endeavor.