Simulating Dice throws - the correct way to do it in excel

By Chandoo at 13 August, 2008, 10:46 pm | 7 Comments

Simulating Dice throws - the correct way to do it in excel

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if [...]

Read More >>

Bingo / Housie Ticket Generator in Excel

By Chandoo at 16 July, 2008, 5:49 pm | 1 Comment

Bingo / Housie Ticket Generator in Excel

I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why whenever I get sometime I experiment with simulating games to know them better [read Why Monopoly board game is not as random as it appears]. [...]

Read More >>