Quote Originally Posted by bisonaudit View Post
There are only 2,048 (2^11) possible permutations of 11 game results (assuming no ties) so once I've got the % chance to win each game it's just brute force multiplication to calculate the chance of each of those permutations occurring and then summing them up to get the chance for each record. Once the table is set up excel updates the calculation in a blink. Learn to love: if/then, countif, sumif and lock down those cell references $.