![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Dice Probabilities
Sep. 11th, 2009 09:06 amYo Ho, Gamers.
On behalf of![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
mister_free, I created a simple spreadsheet (MSExcel 2003) that will calculate basic dice probabilities.
You enter the # of sides of the dice, the # of dice in the dice pool, and the target number for a success (i.e. 7+ on a D10). Then you go down a chart and find the number of success needed (say you need 3 successes out of 10 dice). Then scroll across and it tells you that you have xx% chance of making your goal. It gives all of the percentages from 1 to 20 dice simultaneously, so it's a nice tool that you can use to compare probabilities given a particular dice pool and target number.
It does not take into account adding bonuses, etc. It's very basic, but should be easy enough to tweak if you are familiar enough with Excel equations*.
If you would be interested in a copy of this drop me a line here with you email addy (comments screened) and I'll shoot you a copy.
( More details about the spreadsheet here )
Enjoy!
* I'm not going to teach you how to do things in Excel, so please don't ask.
** (See *) If you can't do this yourself I'd be happy to do it for you if you ask. Just tell me the max die pool size and I'll adjust it for you accordingly. I might do some other tweaking if asked, but I reserve the right to say no if I think it might be too complicated or something I just won't have the time for.
On behalf of
mister_free, I created a simple spreadsheet (MSExcel 2003) that will calculate basic dice probabilities.You enter the # of sides of the dice, the # of dice in the dice pool, and the target number for a success (i.e. 7+ on a D10). Then you go down a chart and find the number of success needed (say you need 3 successes out of 10 dice). Then scroll across and it tells you that you have xx% chance of making your goal. It gives all of the percentages from 1 to 20 dice simultaneously, so it's a nice tool that you can use to compare probabilities given a particular dice pool and target number.
It does not take into account adding bonuses, etc. It's very basic, but should be easy enough to tweak if you are familiar enough with Excel equations*.
If you would be interested in a copy of this drop me a line here with you email addy (comments screened) and I'll shoot you a copy.
( More details about the spreadsheet here )
Enjoy!
* I'm not going to teach you how to do things in Excel, so please don't ask.
** (See *) If you can't do this yourself I'd be happy to do it for you if you ask. Just tell me the max die pool size and I'll adjust it for you accordingly. I might do some other tweaking if asked, but I reserve the right to say no if I think it might be too complicated or something I just won't have the time for.
