KOA Stats Analyser

From Kick Off Wiki
Jump to navigation Jump to search

The KOA Stats Analyser (previously known as KOA Tournaments Database Viewer) is an application that reads the KOA Tournaments database, created by Spyros Paraschis maintained by Alkis Polyrakis, and presents a huge amount a statistics.

Download Application full setup: http://www.alkis.org/External/KOATDBViewer.exe
Download DB and app Update: http://www.alkis.org/External/KOATD.ZIP

So, if you are even remotely interested in statistics like who has the 3rd best defense as Team B or what are the results between Martin Jeffrey and Robert Swift or what is the ranking progress of Nikos Andreou or what is Nazim Choudhury best scoring record as Team B or who are the best players from Italy or even what are the predicted results of a tourney with Steve Camber, Klaus Loite, Vasilis Kafiris and Mark Poelstra, the KOA Stats Analyser is a must download.

Finally, here are some screenshot thumbnails:

Ranking progress graph.jpg
The ranking progress graph

Misc stats.jpg
The updated Misc Stats, showing the players with the best attack as Team A

Tournament stats.jpg
The Tournament stats section



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 Polyrakis. 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.ZIP

How do I update the program and the database?

Soon after a tournament takes place, Alkis Polyrakis 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 Polyrakis 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.

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 / usage

I run the app and I get an error message: "Selected collating sequence not supported by the operating system"

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.

Some stats are displayed differently in the Misc Stats / List All section and the Player Stats screen. What goes?

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.

Is there anyway to sort the stats based on Goal and Defensive averages?

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.

I played a tournament but in the next database update my ranking points hadn't changed. Why?

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.

I have played in a tournament but my name does not appear in the rankings. Why?

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!

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.

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.

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.

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.

Are these the same as Rob Swifts stats (more or less?)

Yup, these are actually the infamous Robert Swift rankings...

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

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.

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

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.exe



  • paraschis.gr - Homepage of Spyros Paraschis, featuring, among other things, original software, freeware game reviews and an article on rewiring one old metallic joystick
  • Alkis - Greek Fan Site owned by the 2001 Kick Off 2 World Champion