I've changed my mind on your spreadsheet being correct.
On the other hand it's not as simple as the length between the local peaks on either side of the leak above the elevation of the leak, but I may have misunderstood.
The attached has a button which will add minima and maxima indications to column D, as a first step.
I don't understand your pseudo-code in msg#1, but is it something along the lines of these diagrams below?: 2019-09-09_231314.jpg
and: 2019-09-09_232208.jpg
Last edited by p45cal; 09-09-2019 at 03:57 PM.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.