[Spoilers] Old Harry's Game

[Fintourist]

I may have overcomplicated the formula a bit:
=floor(if(O3=P3,P7+O8,((O8-O5)+(O8-O5)*(P4*0.2-O4*0.2))+P7),1)+1



Without the cheating +1 at the end I get 14 beakers...

I'm taking the overflow, O8-O5 = 6
Then working how many beakers should be added or removed from the overflow, (O8-O5)*(P4*0.2-O4*0.2) = 6*(-0.2)=-1.2
Then adding the two together = 4.8

I believe the formula is simply a bit off. You are calculating 6*0,8, which is different from 6/1,2. And the latter seems to be the right way of dealing with overflow-pre-req calculations.

So instead of comparing the amount of pre-reqs simply do the calculation in two steps:
1. Convert the overflow back to base beakers using old multiplers.
2. Adjust the base beakers with new multiplers.

I am by no means the expert in this topic though..