Theory: Draft Value by Elo with Random Pairings

So the last spreadsheet I made only worked for one of the 315 possible ways that eight players could be paired for a single-elimination 8-man tournament. This one accounts for all possible pairings. You can even compare what the value was for each player with random pairings to what it was with the actual pairings that were announced.



Here's a couple of the nuts and bolts going on behind the scenes:





You can download the spreadsheet here. Unfortunately it isn't compatible with Google Docs.