KOA Stats Analyser
The KOA Stats Analyser (previously known as KOA Tournaments Database Viewer) is an application that reads the KOA Tournaments database, maintained by Alkis, and presents a huge amount a statistics.
So, if you are even remotely interested in statistics like who has the 3rd best defense or what are the results between Martin J and Robert S or what is the ranking progress of Nikos A or what is Nazim's best scoring record or who are the best players from Italy or even what are the predicted results of a tourney with Steve C, Klaus Lo, Vasilis K and Mark P, the KOA Stats Analyser is a must download.
For any installation / operation problems I will keep a small FAQ and I will update it with all questions asked. Please keep in mid that some posts in this topic may be deleted (after moving the relevant questions in the FAQ) to keep the topic clear and easy to follow.
Finally, here are some screenshots - reduced in size and quality - FYI:
The ranking progress graph
The Misc Stats, showing the players with the best attack
The Head-to-Head results sectionFAQInstallation1. I downloaded the app. Is this the only thing I need to do to see the stats?
The KOA Stats Analyser needs the KOATDB, maintained by Alkis. After downloading and installing the Analyser for the first time, you also need to download the latest version of the KOATDB, extract it in a folder and then run the Analyser. It will ask you to locate the KOATDB.mdb file.
Application full setup: http://www.alkis.org/External/KOATDBViewer.exe
DB and app Update: http://www.alkis.org/External/KOATD.ZIP2. How do I update the program and the database?
In the beginning of a month, Alkis will update the KOATDB and will post here to give you the download link. If any updates to the program are required, the archive Alkis posts will also contain the latest version of the application executable. All you have to do is unzip everything to the Analyser directory and overwrite any existing files while doing so. The Analyser should not be running for the update to work.3. Are there any other requirements for running the analyser?
The analyser needs the Microsoft Data Access Components (MDAC), which are used to access the database. These components are installed by many apps so you probably already have them in your system. If not, you need to download them (from the Microsoft site for example)
Problems / usage4. I run the app and I get an error message: "Selected collating sequence not supported by the operating system" (spotted by Ely)
This error is usually caused by trying to read an Access database in a system with no multilanguage support. Install multilanguage support to solve it.5. Some stats are displayed differently in the Misc Stats / List All section and the Player Stats screen. What goes? (spotted by the TheFoxSoft)
In older versions there is a mistake in the average calculation of some stats (for example the Team B average goals scored) in the Player Stats screen. This has been corrected in v1.1.6. Is there anyway to sort the stats based on Goal and Defensive averages? (asked by Durban)
You can sort the stats of all players based on Goal and Defensive averages - just go to the Misc Stats, select for example "Best Defense Avg" from the "individual stats" section and click on the "List All" button.7. I played a tournament but in the next database update my ranking points hadn't changed. Why? (asked by VKafiris)
The ranking points are updated on a monthly basis, so for example the May 2003 rankings will be calculated for all tournaments held till April 30, 2003. If you play a tournament in May, the results will be reflected on the June rankings.8. I have played in a tournament but my name does not appear in the rankings. Why? (asked by Pee)
You won't appear in the rankings until you have played 2 tournaments. The reason for this is that we have about 40 players out of the 80 that have just played a single tournament and these all sit in a cluster around 1000 pts and distort the ranking. We made the decision that they are not 'active' players until they play 2 tournaments. Think of it in terms of going 'pro' on your second tournament! (answered by Robert Swift)
However, the ranking points of those "inactive" players are still calculated and can be displayed in the ranking table of the Analyser (by unchecking the "Ranking table tournament participation limit" checkbox in the options). If however a player participates in his first tournament, his name will be included in the player lists of all the statistics categories after the next ranking update.9. I get a runtime error when running the application. Any possible fixes?
This can happen when you match a version of the application with an earlier (or later) version of the DB. What happens in this case is that the app is looking for some specific fields/tables that do not exist. If this is the cause, deleting the ini file and selecting the new version of the db will solve the problem. Keep in mind that whenever an application update is needed for a new db version, the application is included in the db update archive.10. Does changing the month have much of an effect? I noticed a few players near the top moved around but I seem to be stuck at 48th position no matter what month I put it on, I would have thought I would have dropped (or risen) a little in that time. (asked by Durban)
Let's take an example:
-November 2002: Mark W 829 points (47th)
-December 2002: Mark W 815 points (45th)
-January 2003: Mark W 778 points (47th)
-February 2003: Mark W 780 points (46th)
In order to see difference in your points (other than the small percentage by which you automatically approach 1000 every month), you have to look at months between which you have played a tournament. For instance, you played in the World Cup and Kitchen II in November, and Kitchen III in December. Losing points does not necessarily mean you move down (and vice versa), it obviously depends on what the other people around you do.
Anyway, the best way to track your progress in the Rankings is going to Player Stats-> Mark W-> Progress.(answered by Alkis)11. Are these the same as Rob Swifts stats (more or less?) (asked by Durban)
Yup, these are actually the infamous Swift rankings...12. It doesn't sort League with Goal Difference in mind. So you get odd looking situations where two players have equal point and the one with worst GD is above the other. Can't remember which tournament I saw it on, but it does it for Fantasy ones as well (spotted by Ely)
On tournaments, this is normal, because leagues are sorted by the results of the player in their games vs each other and then by gd. On the fantasy league, this was corrected in v1.4a.13. I have downloaded the full installation before, which placed a shortcut on my desktop. After extracting the last update, running the app from the shortcut produces a runtime error (spotted by Stainy)
During its development, the app's executable name changed from KOATBViewer.exe to KOAStats.exe. The shortcut still points to KOATBViewer.exe but this executable isn't compatible with the latest changes made to the db. Delete the shortcut (and the actual KOATBViewer.exe) and always run the KOAStats.exe15. Does the application run on Windows Vista?
Yes. However, you have to run it as administrator - normally Programs are run with User-privileges under Vista. Right-click on koastats.exe (or its shortcut) and choose "Run as Administrator" (thanks Sascha