PDA

View Full Version : Anyone know of a program that can chart this: Roll 3d4+3d6 and keep best 3/6 dice?



darkrose50
2014-09-19, 10:32 AM
Anyone know of a program that can chart this:

Roll 3d4+3d6 and keep best 3/6 dice?

Roll 4d4+4d6 and keep best 3/8 dice?

Thanks,
Rich

Bulhakov
2014-09-19, 10:43 AM
Excel(or open office calc) should do the trick. I can try to write out the functions in a spare moment.

darkrose50
2014-09-19, 10:47 AM
Excel(or open office calc) should do the trick. I can try to write out the functions in a spare moment.

Thank you sir!

ElenionAncalima
2014-09-19, 10:53 AM
I believe for Excel

=RANDBETWEEN(1,4) should give you the equivalent of a d4
=RANDBETWEEN(1,6) should give you a d6

=LARGE([Enter range of values],1) - Should give you the highest value
=LARGE([Enter range of values],2) - 2nd highest
=LARGE([Enter range of values],3) - 3rd highest

Bulhakov
2014-09-19, 11:17 AM
I was about to suggest:

= INT(RAND()*x)+1 // for dx dice rolls
= LARGE (range,n) // n-th largest number in range

if you wan't to qucikly "reroll ", just press Delete while on an empty cell

or do you want to generate a large set to chart the distribution?

Jay R
2014-09-19, 04:53 PM
The average is 12.3151.
The standard deviation is 2.2576.

The distribution and cumulative distribution are:


3 0.01% 0.01%
4 0.04% 0.05%


5 0.15% 0.20%


6 0.56% 0.77%


7 1.48% 2.24%


8 3.10% 5.35%


9 5.83% 11.18%


10 9.72% 20.90%


11 13.28% 34.18%


12 16.91% 51.09%


13 17.30% 68.39%


14 15.10% 83.49%


15 9.47% 92.96%


16 5.19% 98.15%


17 1.39% 99.54%


18 0.46% 100.00%


While this distribution reduces the probability of really bad rolls, it doesn't increase the probability of rolls of 17 or 18 one iota, and doesn't increase the odds of 15s and 16s by a huge amount. The probability of a 15 or greater is 16.5%, compared to 9.3% with a straight 3d6. The probability of a ten or less is 20.9%, compared with 50% with 3d6. Mostly it turns bad rolls into average or slightly above average rolls. 62.6% of all rolls will be in the range 11-14, and 81.8% will be in the range 10 - 15.

darkrose50
2014-09-19, 05:41 PM
Thank you! I thought it would be a good system to add meat to the middle. I am thinking of using this system, or talking my friend into it for 5e D&D.

I also think it would work well for Delta Green Call of Cthulhu, as the characters always seem to come out with worse stats then the examples given for each agency.

I asked the creator of this webpage for help, and got this result http://anydice.com/program/46be .

And this result 4d4 + 4d6, keep best 3 . . . http://anydice.com/program/46bf .

JusticeZero
2014-09-20, 07:10 PM
Then why keep fighting with random rolls?? I can't stand them myself. Use a standard array or some other purely deterministic system that gives the numbers you want.

Knaight
2014-09-23, 12:11 AM
Anydice can do this pretty easily, and it outputs pretty graphs. It was linked above, but it warrants repeating. It's also a more powerful tool than it looks like, once you get into dice which are dice combinations and such.

Jay R
2014-09-23, 07:51 AM
Then why keep fighting with random rolls?? I can't stand them myself. Use a standard array or some other purely deterministic system that gives the numbers you want.

Because some people prefer it that way. They get to play with their preferences, just as you get to play with yours.

JusticeZero
2014-09-23, 10:01 AM
Some people don't actually even think to use deterministic answers for some reason. So i'm saying.

Jay R
2014-09-23, 01:30 PM
Some people don't actually even think to use deterministic answers for some reason. So i'm saying.

Don't worry. There is no chance that anybody active enough to be on this forum has failed to have that idea presented to them, with great vim and vigor. If they haven't considered it yet, then adding your voice to the chorus won't make much difference.

Knaight
2014-09-23, 01:45 PM
Some people don't actually even think to use deterministic answers for some reason. So i'm saying.

Anyone on this forum has had it presented, as Jay R has said. That it hasn't been considered is about as likely as D&D not being considered for a game here.

CarpeGuitarrem
2014-09-23, 02:40 PM
Anydice can do this pretty easily, and it outputs pretty graphs. It was linked above, but it warrants repeating. It's also a more powerful tool than it looks like, once you get into dice which are dice combinations and such.
Anydice is fantastic, particularly because it does the math for you.