Excel generating random outcomes based on probability (Slot Machine)

[TiffanyWong]

There are 3 similar reels for the slot machine. It consists of cherry, plum, melon, ace, bar, bell, diamond, lemon, gold coins, orange, and seven. After inserting one or more dollar coins, the gambler pulls the handle and the reels spin. The machine displays three images, one from each reel, when the reels stop spinning. Depending on the counts of certain images displayed and the bet inserted, the machine gives in return nothing, some coins, or an overflowing payoff.

Assume in each reel, there are 4 cherry, 4 plum, 4 melon, 5 ace, 5 bar, 7 bell, 7 diamond, 7 lemon, 7 gold coins, 7 orange and 7 seven images, all randomly arranged.

For every $1 inserted, the payoff for 1 cherry image is $2, 2 cherry images gives $5, and 3 cherry images gives $10; 2 plum images gives $20, 3 plum images gives $30; and 2 melon images gives $40 and 3 melon images gives $60. What is the net balance after 28 pulls when the initial is $100 and bets are all $1 each?


1. Do anyone know how can my outcomes suit the requirements (Eg. 4 cherry) ??
2. And how do I ensure the things stop at 28 pulls ?? I can't use random ??

I have no ideas on how should I start with my spreadsheet model.

[shg]

What's it pay if there is one cherry and two plums?

[shg]

BTW, borrow all the money you can and play that machine until your arm falls off ...

[TiffanyWong]

$22. Is that question doable ?