Okay, take a look at this attachment. The equations are getting longer. In this example, the spreadsheet always starts with Cycle 1 AM. I imagine that's not the case. We could set up a cell with a dropdown (AM/PM) or (Cycle 1/Cycle 2) to adapt for that. Which would you prefer?
Currently, Col B and C are just to play with, they can be deleted once you're happy with results. They show inventory AFTER that cycle.
Col D, D7 is
E7 is
and F7 is
Note: If your second strength falls within 5 cycles of depletion after the first one but before refill, a second warning will show up. Hope that's okay.
Bookmarks