Rethalgamon
First Post
Hey guys. I've been looking at making the switch in my homebrew from 1d20 to 3d6, per the section in Unearthed Arcana. I'm building an excel spreadsheet for "playtesting", and I was wondering if the formula I've got now, which calculates opposed d20 rolls, would work for 3d6 rolls, if I just changed the numbers around; i.e., is the math the same save for the numbers?
The formula I'm using now found in a wonderful PDF about opposed rolls specifically, which I can no longer locate
. It's basically:
(20-R)*(20-R-1)/(20^2)
where R is the difference of the first roller's roll modifier and the second roller's roll modifier.
My hangup is that "1"; I don't know a lot about statistics/probability, so I'm worried that my formula will come out wrong/be incorrect if I leave it as a 1 and not as a 3. I'm assuming that the "20" and the "1" in the formula represent the maximum and minimum range for the die rolls; the range with 3d6 is, of course, 3-18, and not 1-20, so I'm thinking changing the formula to:
(18-R)*(18-R-3)/(18^2)
would work, but I just need someone with a little more experience with probability to verify/correct me. I appreciate the help, guys!
The formula I'm using now found in a wonderful PDF about opposed rolls specifically, which I can no longer locate

(20-R)*(20-R-1)/(20^2)
where R is the difference of the first roller's roll modifier and the second roller's roll modifier.
My hangup is that "1"; I don't know a lot about statistics/probability, so I'm worried that my formula will come out wrong/be incorrect if I leave it as a 1 and not as a 3. I'm assuming that the "20" and the "1" in the formula represent the maximum and minimum range for the die rolls; the range with 3d6 is, of course, 3-18, and not 1-20, so I'm thinking changing the formula to:
(18-R)*(18-R-3)/(18^2)
would work, but I just need someone with a little more experience with probability to verify/correct me. I appreciate the help, guys!