|
BGonline.org Forums
Dancing x times on a y point board? Excel help?
Posted By: Casper Van der Tak In Response To: Dancing x times on a y point board? Excel help? (sebalotek)
Date: Wednesday, 18 November 2015, at 9:22 a.m.
I'd just make columns:
Number of closed points (0, 1, 2, 3, 4, 5, 6)
Number of dancing rolls (previous column squared, so 0, 1, 4, 9, 16, 25, 36)
Probability of dancing per roll (previous column divided by 36, so 0/36, 1/36, 4/36, etc)
Probability of dancing 2, 3, 4 etc rolls: previous column raised to the power 2, 3, 4.
If you have trouble with this, I could make and send an Excel sheet.
|
BGonline.org Forums is maintained by Stick with WebBBS 5.12.