Has anyone written a macro to convert crosstables received from USChess by email into an excel spreadsheet?
I’m not aware of one, but any such tool will become obsolete this fall when the Leago system rolls out, because crosstables will be completely different. There may also be an API available, though probably not for some time after the Leago rollout, for receiving a crosstable in a more machine-processable form.
You mean as a Pretty Viewer/Printer for the entire note or just the player info and round opponent, color, result?
Not sure how to answer. Want to convert the cross table I het emailed to me fro USChess and convert it to an excel spreadsheet.
That sounds like something that would be very easy to do with VBA … but. not worth it if the format’s about to change radically. (I do a lot of VBA programming.)
Yeah. I looked at at a few different types of tournaments and the unstructured text didn’t throw any parsing nightmares (I only saw a few longer than expected fields which could be mitigated - I’d be more worried about the 1 in a 1000 very uncommon parsing issues). All the ones I looked at also passed manual process minor text edit-copy/paste-minor edit-text2columns so basic spreadsheet skills can get the job done without any programming and would be the way I would go especially with the short life.
I am still a bit stuck on what the usefulness of it being in a spreadsheet is - if there is something in particular then it might impact the way the data is converted/formatted.
I do have to admit I wondered just how useful a crosstable would be in Excel.
About the only use I’ve had for a crosstable is calculating performance ratings, but that was just to prove a theory that I’m a worse player when also a TD.
I remember thinking of doing that, but then quickly decided it was proving the obvious in my case. When I was younger and before sudden death/faster time controls it was much easier to do both. I also noted that there is a direct correlation of when I got a bad night to there being an odd number of entries so I had to play to avoid byes. I use to joke that there was a further correlation to when you had to play there were no other back up TDs entered/spectating. 
Mike, will all the tournament running programs have to be adapted to Leago when it comes out? Or can they just produce the 3 .dbf files that they always have been producing that will be ready to upload as is?
We’ve been testing them with the upload files produced by both WinTD and SwissSys from the start so they should work fine. (I recently uploaded several large events, on the test servers, including the 2025 World Team and SuperNationals 8, both uploaded fine.)
I don’t know if we’ve tested DBF files from other pairing programs, but they should work as well as long as they follow the specs.
Down the road, possibly in 2026, there may be another option for uploading events through an API, but details on that are not firm. I’ve suggested having a ‘Developer’ landing page similar to the ones we have for TDs and Organizers, that would be a good place to post things like the specs for the DBF files (both upload and supplement files) and the API documentation when it becomes available. (The TD/A and MSA FAQ pages will all go away at some point, so we need to find places for that type of information as well.)
My understanding is that Leago is doing virtually all inter-module communication with API’s, so they should be pretty close to ready for public use, probably just needing some security and usage restriction mods.
It would be nice to be able to put non-ASCII characters in a tournament report in 2026, for sure.
That makes searching for events by name more complicated, though.
…and yet it should be possible to have a José Raúl Capablanca Memorial event…
1 Like