|Download Excel File|
This program was written by me.
Based on the tv game show, select a case, then consider whether or not to take the deal at each step. It's mostly based on formulas, with a bit of VBA for set-up and game play. The VBA was mostly a chance for me to toy with the difference between Worksheet_Calculate and Worksheet_Change, eventually settling on Worksheet_Calculate. And yes, the resulting code is somewhat messy. But the game works, and if you like to image yourself winning some reasonable percentage of the expected value of a set of highly skewed random numbers, you might enjoy it.
Have comments about this program? Leave them below!
Excel is a registered trademarkof the Microsoft® Corporation.