Tracking water levels in a reservoir

[bvukosavljevic]

OK. This one is tough, and I'm not sure if I'm posting it in a right place. Maybe I need a macro or VB programming, but let's hope that formula can help.
Please see an example worksheet attached.

I'm tracking water levels in a reservoir. There are 4 input columns, and 2 that I have to calculate.
Input columns:
-date
-water inflow (m3)
-water withdrawal from a reservoir (m3)
-reservoir capacity (limit that's changing)

I'd like to track a water level in a reservoir, and amount of water overflowing the reservoir, so the level is limited (capped) with capacity, and when capacity is reached, water is overflowing the reservoir.

If anyone can figure out a formula for at least a column E (water level), that would be really helpful.

Thanks a lot.

[boopathiraja]

for column e

MIN(d2,SUM($B$1:B2)-SUM($C$1:C2))

[bvukosavljevic]

Thanks a lot Boopathiraha. Water level column works perfect.