Streamlining of rating data

With the new Rating History function I added a second rating database which contains all master file entries for the last 50 or so rating periods, including the most recent rating period. This meant there was some duplication of data since the Glicko-1 Calculator also has a lookup feature that was still looking at a copy of the active list I kept in a separate table. This also entailed a certain amount of duplication of effort when new rating lists are published or updates are released as I would need to make the updates in two places.

To overcome all this I have changed the Glicko-1 Calculator lookup to refer to the new tables I created for the Rating History. At this stage the Calculator just picks up the latest rating period but this could be changed in the future so that Calculator users could select the rating period they wish to use for lookups. It also simplifies my processing of new files and updates as I only need to do this in one place now.

The new lookup functionality in Glicko-1 Calculator should be indistinguishable from the old – all that has changed is the source of the data. However, if you notice any problem or even any differences, please let me know.

Leave a Reply

Your email address will not be published. Required fields are marked *

*