Based on other posts, I have the impression that your math is quite good enough to understand what I said . The Binomial distribution is just the probability of things happening multiplied by the probability of other things not happening multiplied by the number of ways that can occur. There's a very nice page that explains permutations and combinations here: http://www.mathsisfun.com/combinatorics ... tions.html.
The formulas for dice rolls look ugly, but they are also just based on the formula for combinations. The derivation is kind of ugly (see http://mathworld.wolfram.com/Dice.html), but once you have the formulas they are not hard to calculate (except in Excel, without resorting to VBA programming! There's just no good way to handle those summations).
Sweet! I will check this out later when I get home. I fixed the final calculation after posting this when I realized that the sheet I uploaded was an earlier copy, but even though I knew something felt wrong about the odds to hit, I couldn't figure out what needed to be done to fix that. I also fixed the distribution possibilities on rolls after posting that one. Anyway, you've given me quite the homework; I'm looking forward to attempting to understand your work when I return!