Elo ratings are not a perfect measurement for something like this, especially as they're being abandoned by Wizards and are hidden online, but they are the best I can do and are still academically interesting.
The spreadsheet takes the ratings of eight players and, assuming certain pairings, gives the expected value of the tournament for various tournament payouts, or even your own custom one, which is currently set for a Premier Event Top 8. Because pairings are in an assumed order (which can be seen explained on the spreadsheet) the order of the players will change their expected values.
Google docs spreadsheet can be found here. It loses the conditional color formatting but is otherwise the same.
Excel spreadsheet can be downloaded from here. I haven't tested it in older versions of Excel. It should work in Open Office but without color formatting.
No comments:
Post a Comment