The readers requested it and here it is; a spreadsheet that everyone can see to look at the overall tournament performance of each faction.
How to read the spreadsheet
The Public tab is where most people will want to be looking at data. I have listed the number of tournament appearances and the number of first place rankings for each army.
‘Tournament win percent over average” is how likely each army is to win a tournament compared to an ‘average’ competitor (value over replacement for baseball fans). Positive values mean that a particular army is more likely to win tournaments, and negative values mean an army is less likely to win.
“No loss/tie” represent the percent of tournaments where an army wins every game. Similarly, “One loss/tie” is the the percent of tournaments where an army wins all but one game.
Games with the win, loss, and tie percents should be self explanatory.
The color coded section includes every army that has at least ten tournament appearances. If you don’t see a particular faction, then keep scrolling to the right and you should find it. I have listed every faction as it was displayed in Best Coast Pairings even when that faction (I’m looking at you Khorne Daemonkin) doesn’t really exist anymore. As the listed faction reach 10 or more tournament appearances I will moved them into the section on the left.
How do I determine if an army is good or bad?
This is the part that requires some user interpretation. Are you just playing pickup games, and not participating in tournaments? Win percent is probably the strongest indicator. Tournament players can look at a couple of different things. One loss/tie is a strong indication that the army performed in the top half of all armies, and no loss/tie is a strong indication that the army was in the top three performers. This doesn’t always work out, but it is a good way to evaluate armies at a glance. I would qualify an army as good if the combination of One and No loss/tie is at least 50%.
Moving forward, I need to learn databasing. When I started this project it was relatively simple, but I have quickly outgrown the capabilities of sheets. I am planning on continuing to study this area, but will will not be inputing quite as much data until I learn a more efficient method. This isn’t then end of anything, just the beginning of a transition to more efficient software.