Controlling how and when cells are calculated.

[Slurry Pumper]

Hi all,

I have a wife that thinks that it is possible to beat the casino game of craps much like it is possible to count cards and beat the casino in black jack. Her contention is that you need to string together a multi roll strategy placing separate bets at certain times with increasing and decreased amounts. So I put together a spreadsheet that calculates the payouts and losses as the rules dictate. There are way too many rules to explain if you don't already know, so if your interested in the casino game of craps, a little Wikipedia search of the rules will explain. For my spreadsheet, the dice will keep on rolling until there is a 7 rolled. This is generally when the game ends for a shooter, and the next shooter is given the dice. Yes there are exceptions, but they are also accounted for in my spreadsheet. My spreadsheet will calculate the correct payout and when the payout or loss occurs.

I now want to control when each individual roll of the dice is taken. For instance, in my spreadsheet, the dice rolls are all calculated at the same time, when in reality, there is a pause after each roll to give players time to place new bets, press or reduce previous bets if allowed, or even take off bets the table. How do I make it so that there is a pause in between calculating cells? Each roll causes evaluations of bets made in previous rolls so I think I should be able to make the calculations pause until I'm ready to make the roll.

[Keebellah]

Hi, good luck with the statistics. Happy rolling
For your question, set calculation to manual, you can do that under the menu item File, Options, Formulas and you will see the Calculation options, set it to manual
if you want to 'ROLL' the dice then just press the F9 key to calculate.
If you only want to be set to manual for this file then you need to write a small caro that is triggered when the workbook is opened that sets the calculation to manual and trigger another macro to set it back to automatic when the work book is closed
Hope this helps

[Slurry Pumper]

Thanks Keebellah,

I tried the method you described, and it works, but it still allows all of the cells to be calculated together. I really want to be able to calculate 1 roll at a time so some of the cells will calculate then there will be a stopping point that will stop everything until the user triggers an event for another roll. At which point some more calculations will occur until another stopping point is reached.

[Keebellah]

Then you will have to trigger an event per cell change and if in that range only process that one, calculate is not cell restricted.