Step 1. Configuration Table
In this example, it is a 5-3 video way slots, and we have 5 standard symbols and 2 feature symbols
Wild symbols can be seen as any other standard symbol during the payout calculation
When there are no less than 3 scatter symbols landing on any place, free games will be triggered
Step 2. Calculate Basic numbers
There are two numbers we need to calculate in this step. The expected landing numbers of each symbol and the rate of {X_Symbols}, which means this symbol does not land on this reel
The expected landing numbers are equal to the rate of symbols times the number of rows and do not forget to add the rate of wild symbols before you time the number of rows
We can get the rate of {X_Symbols} easily by using BINOM.DIST.RANGE function in Excel. The intact formula is "=BINOM.DIST.RANGE(The number of rows, the rate of symbols plus the rate of wild symbols, 0)", which means the rate of there is zero this symbol landing on the reel
Step 3. Calculate the RTP of Standard Symbols
This step is pretty easy, you just need to times the corresponding data we got in the last steps, and do not remember to divide the RTP by the constant we set, which is 100 in this example
Then, we can use the same methods we used in the first 3 steps to get the RTP of standard symbols in Free Game
Step 4. Expected Free Game Times
Considering video slots do not have a limitation of symbols' order on the reel, we can simply use BINOM.DIST function to calculate the rate of each triggering possibility
Then, times corresponding free game times to get the expected free game time in the base game and free game
Finally, using infinite series summation to calculate the total expected free game times in each spin
Step 5. RTP
Last but not least, we can get the RTP of this example in the picture below:
If you also read my last article which is about mathematical models of classic way slots, which we did not use BINOM.DIST function when we calculate the expected free game times. You can find that the steps could be a little bit more complicated and there are more listing steps, which is the most error-prone part
If you do not know how to use BINOM.DIST.RANEG and BINOM.DIST functions in Excel, I strongly recommend you that start learning them. They are very helpful in almost all slot modeling processes
0 Comments