Hi,
I try to build a nice table related to a slot bonus hunt (gambling).
The principle is to get bonuses from slots but not to open them directly. Once I have some, I open all of them in a row.
In my table, I encode their names, the bets, and the amount I won from the bonus.
In another part, I want to show some stats : balance before the hunt, balance before opening the bonuses, total number of bonuses, break even at start of the opening, etc.
The break even at start means the average number of times I have to multiply the bet for all bonuses to get the initial balance back.
Now, I would like also to calculate the break even "live". In other words, after I encode the win of a bonus, I want to know the break even regarding the bonuses not played yet to get my balance back (and of course considering the amount already won).
I attach an image to show my table.
Is this clear enough ? Could someone help me with doing such a formula ? I'm not expert enough to do this
Many thanks in advance,
malfecha