TMERs : One Step at a Time

Sometimes my daily blog post is more a note to myself than a piece of general interest. These are usually categorized in Posts with label About.com, an ongoing project I started five years ago. This year I used the blog to track my progress on two 'Tournament, Match, and Exhibition Record' (TMER) projects:-

• Magnus Carlsen's TMER (2000-); Last updated 2013-07-15 (under construction).
• Viswanathan Anand's TMER (1983-); Last updated 2013-10-28.

I summarized the first TMER project in

• 2013-09-02: The Carlsen Saga,

then updated the second TMER over the next two months:-

• 2013-09-09: In a Class by Himself • Last year, as part of my 'About to Tripod' project, I revived my page on 'Anand's TMER (1983-)', and recorded the milestone [on this blog]. The TMER page is currently flagged 'Last updated 2004-06-05', so it's high time to bring it up to date.
• 2013-09-16: Anand's TMER 2004-2008 • Continuing with 'In a Class by Himself', a small project to update my page on 'Anand's TMER (1983-; last updated 2004-06-05)', I collected all subsequent games from events played through the end of 2008 that were included in The Week in Chess (TWIC).
• 2013-09-23: Anand's TMER 2009-2013 • Last week I constructed an index for 'Anand's TMER 2004-2008', and this week I did the same for events he played up to the date of this post.
• 2013-09-30: Anand's TMER PGN • Continuing with 'Anand's TMER' -- last seen in 2004-2008 and 2009-2013 -- I extracted, combined, and sorted the PGN for the events falling in the nine++ years 2004-2013.
• 2013-10-07: Anand's W-L-D Record 2004-2008 • After creating Anand's TMER PGN' for the years 2004 to 2013, I started adding the events, including W-L-D (win, loss, draw) data, to the TMER index page. I managed to work through 2008 before running out of time.
• 2013-10-14: Anand's W-L-D Record 2009-2013 • Continuing with 'Anand's W-L-D Record 2004-2008', I picked up where I left off and brought the W-L-D (win, loss, draw) data up to date through Anand's most recent tournament, the Tal Memorial, held at Moscow in June.
• 2013-10-21: Anand's Game Scores 2004-2013 • After compiling the data for 'Anand's W-L-D Record 2009-2013', I uploaded the PGN game scores to the 'Chess for All Ages' web site.
• 2013-10-28: Anand's TMER 1983-2013 • That's a wrap! After uploading 'Anand's Game Scores 2004-2013', I updated 'Viswanathan Anand's TMER (1983-)'. The TMER index now includes W-L-D data for all events through 2013.

Now I would like to remove the 'under construction' label from the Carlsen TMER. That means:-

• Normalizing the large PGN file.
• Splitting that file into PGN files for each event.
• Documenting the separate PGN files on the TMER.
• Adding venue to the TMER.
• Removing the external references from the TMER.

There also remains some cleanup work for the Anand TMER -- the 'Games' count in the last column is not consistent over the old and new sections (not to mention other minor inconsistencies) -- but one step at a time. The first step was to load the Carlsen TMER and the corresponding PGN index into a database for further analysis.