Excel table help
January 15th, 2025 at 11:06:28 PM
permalink
Hi all,
I am having some trouble figuring out how to create a table Excel that allows me to manipulate certain variables and get the house edge. The table I have (below) is definitely wrong but I can't figure out how else to do it. What I'm trying to get the house edge of, is a progressive jackpot that pays out if the player gets a mini royal or a straight flush with 3 cards. If the player gets the mini royal they get 100% of the progressive and if they get a SF they get 10% of it.
Can anyone help with how to set up this table so that i can change the seed amount (the amount that the house starts the progressive at) and the contribution amount (the amount that is taken from the cost to play and added to the progressive each time its bet) and see how those changes impact the house edge?
I am having some trouble figuring out how to create a table Excel that allows me to manipulate certain variables and get the house edge. The table I have (below) is definitely wrong but I can't figure out how else to do it. What I'm trying to get the house edge of, is a progressive jackpot that pays out if the player gets a mini royal or a straight flush with 3 cards. If the player gets the mini royal they get 100% of the progressive and if they get a SF they get 10% of it.
Can anyone help with how to set up this table so that i can change the seed amount (the amount that the house starts the progressive at) and the contribution amount (the amount that is taken from the cost to play and added to the progressive each time its bet) and see how those changes impact the house edge?
January 16th, 2025 at 3:52:41 PM
permalink
I assume that this is for a new game.
For a field trial, there is zero chance of it being tested with a progressive. So don’t worry about that.
Just work out the math and the house edge using static payouts for those hands. Everybody will understand that you can add a progressive later.
Whatever gaming company you end up selling it to will work out their own math for the progressive.
For a field trial, there is zero chance of it being tested with a progressive. So don’t worry about that.
Just work out the math and the house edge using static payouts for those hands. Everybody will understand that you can add a progressive later.
Whatever gaming company you end up selling it to will work out their own math for the progressive.
I invented a few casino games. Info:
http://www.DaveMillerGaming.com/ —————————————————————————————————————
Superstitions are silly, childish, irrational rituals, born out of fear of the unknown. But how much does it cost to knock on wood? 😁
January 18th, 2025 at 8:15:11 AM
permalink
I responded to this question earlier. Let me try again, but with equations and an example.
For each $1000 in the jackpot you specified, a player gains an expected return of
1000 x 17.5% x (24+264)/132600 = 38%.
Therefore, when the jackpot meter amount is x, where x>$2000. The player expected return is 38 x %, so the house is edge is
1 - 38 x%.
If the bonus has never been paid out, the meter amount is
$2000 + $0.5 m,
where m is the number of times that the bonus bet has been placed before a minor bonus jackpot payout.
For example, if the bonus bet has been placed 1000 times, the meter amount is
$2000 + $0.5 * 1000 =$2500.
Then, the player expected return is
38% * ($2000 + $0.5 * 1000) = 95%.
So the house edge is
1-95% =5%.
If a minor bonus has been paid out, you just set the current meter amount as the new seed amount.
For each $1000 in the jackpot you specified, a player gains an expected return of
1000 x 17.5% x (24+264)/132600 = 38%.
Therefore, when the jackpot meter amount is x, where x>$2000. The player expected return is 38 x %, so the house is edge is
1 - 38 x%.
If the bonus has never been paid out, the meter amount is
$2000 + $0.5 m,
where m is the number of times that the bonus bet has been placed before a minor bonus jackpot payout.
For example, if the bonus bet has been placed 1000 times, the meter amount is
$2000 + $0.5 * 1000 =$2500.
Then, the player expected return is
38% * ($2000 + $0.5 * 1000) = 95%.
So the house edge is
1-95% =5%.
If a minor bonus has been paid out, you just set the current meter amount as the new seed amount.
