Reading it initially:
Alas I fear that is not really possible.
UNLESS you have ANOTHER sensor outside that can detect the water BEFORE it gets to your place.
The closest I think I came to that is with the third value/output.
From the sump being EMPTY, water comes in, the sump fills
When it reaches the second value the pump/s turn on.
If they are ON and the level keeps rising it gets to level 3, then alarms go off.
Though that time would not be long - depending on many factors:
How big the sump is.
How fast the water is coming in.
How far help is away from arriving.
The other problem is the existing pump's output and how clear they are.
If there is any problems with that: there's a whole other can of worms opened.
I am not saying my solution is better than anyone else's.
But when I read the thread, there are graphs and all this statistical stuff.
I guess if you really wanted to be a bit more analytical about things:
New idea:
Sensor has 3 values
empty - turn pumps off
high - turn pumps on
high + margin - this is a value above the high that if he water exceeds, alarms go off.
Factors:
In normal emptying of the sump, let's say 10L / Min. (example)
The sump is 30L capacity. Not much good having one with a 11L capacity. You need a fairly good difference there. Say 50%
So 15L is the minimum.
And that needs to be as closer fitting to the pumps as possible.
Not a 4m x 4m pit 1m deep. (bad example, but I hope it conveys the importance of the sump's shape)
empty
is 5L. Could be maybe 3L
So, high
is triggered.
That starts a timer
to ...... wait a minute!
All this is nice in theory, but it is over complicating things.
high
is reached. the pumps turn on.
The level of the water is monitor - as per usual.
If the level gets below empty
the pumps are turned off.
However, if not, the pumps stay on.
(more time and water)
The level rises from the high (of say 7L) to 10L
When this happens the value is noted and alarms go off.
Trends are not useful in this situation.
If there is water: you want the pumps on and pumping at full capacity until it is empty.
(at a low level but the pumps are still in water)
So the pumps turn on at 7L and when the sump gets to 10L of water, the alarms go off and you DO THINGS.
Yes, if the sump goes from 2L to 15L in 10 seconds, buy an arc. (sorry.)
You can't control that.
All you do it set a value just above the turn on
value so if the water goes above that, you are told.
To explain another way:
The sump is empty.
Water starts coming in at 15L/min - you don't / can't know this.
It quickly goes above the high
level and the pumps turn on.
They are extracting water a 10L/Min.
Your net is +5L/Min.
It will take about 40 seconds to fill the sump.
In those 40 seconds (near the end) the inflow reduces to 10L/Min.
(That's breaking even with the pumps)
So they will stay on ..... forever if nothing else changes.
ALSO you will NOT get flooded.
So after...... 10 minutes of that....... the inflow reduces to 8L/Min.
Now you are winning.
The pumps will stay on until the level gets below the empty
mark then turn off.
Does that help with anyone understanding from where I'm coming?
Oh, sorry. P.S.
The margin needs to be enough that any water falling into the sump won't corrupt the value.
If it does, you may get false positives on one hand and delayed calls for help on the other.