Ah yes, I forgot about Kanneti and Kamaru-Deen. The way I did these calculations yesterday counted all competitors' "first" nationalities as their current one, so I've gone through and made some manual edits for France, Thailand, Nigeria, and Belize. France moved up one spot and Thailand moved down one spot in averages; neither changed ranks in singles; Nigeria moved up and Belize moved down in both singles and averages.
The problem with Belize is that most of its NRs are no longer Anthony's PBs and so don't have rankings per se. I had looked through your old update yesterday and saw that Belize wasn't even in either list - did you just disregard the few that still are his PBs? The edit I just made has it such that Belize doesn't have NRs/results in the events where Anthony has broken his PBs since switching nationalities, but I guess that's now an overestimate of their "proper" sum?
I think the first couple of times I did the lists, I included Belize and figured out where Anthony's best Belize times would have place in the current rankings. Last time I think I got fed up with the bother of it and just removed Belize. Belize should definitely be given Anthony's old times. After all, they appear on the WCA records page.
For the sake of thinking this through and noting it down:
If you start by using the person's first nationality (as is natural with a simple vlookup) I think there are 2 situations where you can have issues with somebody switching from country A to country B. Feel free to correct me if this doesn't seem complete or accurate.
1. A person set an NR for country A but has beaten that result while competing for country B. Also, nobody else in country A has beaten the person's current result. Note that somebody else beating the NR for country A is not sufficient to avoid this problem.
To fix this, you must find the best result by the person that was actually set while competing under country A (look on the WCA records page), and then work out where in the current rankings that would place.
If the person is now the NR holder in country B, country A will have been assigned records incorrectly. If not, there will be no #1 ranking for country A in the rankings table.
Anthony Brooks: Belize must be given his old results.
Ramadan Sulejman: Macedonia must be given his old results rather than his current ones.
Cameron Almasi: Iran must be given his old results.
Kanneti: Thailand FM single/average need to be edited because he has results better than the Thailand NRs.
2. The person has an NR for country B. His times will appear under country A in the spreadsheet, so country B misses out on that result being used.
To fix this, you need to edit country B results and if the result is better than country A's real NR, country A must be edited too.
Kanneti: France must be given his 2 NRs: OH and FM averages.
Kamaru-Deen: Nigeria must be given his NRs. Nothing to edit for USA because his times are not better than the USA NRs.
Ramadan Sulejman: Norway must be given his NRs (currently 3bld single+average, 4bld, multibld)
