My house is situated on a spring, it seems. During wet season, my sump pump can cycle 60 seconds on, 150 seconds off. It can get to a depth of four inches in my whole basement overnight if the pump fails (it has, once). Battery backup is pretty useless if power is out for more than a couple hours, due to the heavy use. Yes, a generator might be a good idea... but is a lot more money than a Twine.
And hot damn, got vibration working with a Google Docs spreadsheet as I reported previously
I've now got it set up the following rules:
1) Gets Wet for more than .1 sec > Email me that the basement might be flooding.
I may need something more alerting than this -- my email doesn't make noise on my phone, and my phone often isn't by my bed. I may have to do something like trigger Google Voice to call my home phone as well. I'm also concerned about the occasional "splash" as the sump lid isn't a seal -- I don't want to wake myself up constantly.
2) Temperature falls below 40 > Email me that pipes might be heading toward freezing
I don't expect this to happen, but hey, the feature is there, I might as well
3) Vibration On for more than 2 seconds after being off for at least 3 > Issue an HTTP request to my Google Spreadsheet web app script
4) Vibration Off for more than 2 seconds after being on for at least 3 > Issue an HTTP request to my Google Spreadhseet web app script.
The script logs the time the HTTP request is sent, then checks for the parameter. Unfortunately, the web app URL is rather long, leaving me just three characters for my own use. The parameters are either ?ON or ?OF (rolls eyes).
The script puts the date/time, then compares with the previous date/time and lots either "1824 seconds since last run" or "Ran for 96 seconds"
I could probably use some spreadsheet-fu -- my script puts a horrendous formula in, e.g.
="Ran for " & Int((INDIRECT(ADDRESS(ROW(),COLUMN()-1,4))-INDIRECT(ADDRESS(ROW()-1,COLUMN()-1,4)))*86400) & " seconds"
Next step is to amend the Google Spreadsheets script to send me alerts if the behavior of the sump pump changes significantly: Not running for an hour when it's been running every three minutes could be a sign of failure, even if the water sensor hasn't tripped (firm believer in software belt and suspenders). Running more frequently than previously could be a sign of another disaster: a leaking pipe, for instance.