Help finding probabilities of doing body damage for Normal Damage attacks

[Sociotard]

I'm trying to size an EB based on its ability to do body damage to a specific target. Does anybody have a program or excel sheet to find the odds of doing body damage for large DC normal damage attacks?

 

I made one such sheet, but it only goes to 4DC. Any further seems . . . difficult.

[prestidigitator]

Re: Help finding probabilities of doing body damage for Normal Damage attacks

 

This should make it a lot easier:

 

p(B, N) - The probability of rolling B Body on N dice

 

If B < 0, p(B, N) = 0

If B > 2*N, p(B, N) = 0

 

Otherwise:

 

p(0, 1) = 1/6

p(1, 1) = 2/3

p(2, 1) = 1/6

p(B, N+1) = (1/6)*p(B, N)+(2/3)*p(B-1, N)+(1/6)*p(B-2, N)

 

That should allow you to setup, for example, a column for each DC value, with a simple formula in all but the first column that calculates the probabilities for each cell. Not very complicated at all.

[Sean Waters]

Re: Help finding probabilities of doing body damage for Normal Damage attacks

 

This should make it a lot easier:

 

p(B, N) - The probability of rolling B Body on N dice

 

If B < 0, p(B, N) = 0

If B > 2*N, p(B, N) = 0

 

Otherwise:

 

p(0, 1) = 1/6

p(1, 1) = 2/3

p(2, 1) = 1/6

p(B, N+1) = (1/6)*p(B, N)+(2/3)*p(B-1, N)+(1/6)*p(B-2, N)

 

That should allow you to setup, for example, a column for each DC value, with a simple formula in all but the first column that calculates the probabilities for each cell. Not very complicated at all.

 

Cool.

 

Now, do you have a spoon I can put my brain back in with?