Query current ratings in a spreadsheet?

Running Chess Tournaments
1

I recall somewhere seeing some code to query the current published rating by name or ID number, but I can’t find it.

What I’d like to do is have a column in a spreadsheet get the current rating based on the contents of another column in the row which is the USCF ID number.

This is a Google Docs spreadsheet, but the magic for an Excel spreadsheet would probably work too.

Anyone?

Thanks,
-Matt Phelps

2

I should say I’d prefer to query the web for the rating and not a locally stored database file, if possible.

-Matt

3

I’m not sure, but it sounds like you’re asking about the “thin client” web page Mike Nolan created some time ago:

uschess.org/msa/thin.php

4

Yes, That’s the pointer I needed! If anyone has insights into using this in a spreadsheet, let me know. I’ll flail away for a while.

-Matt

5

Got it! NOTE: This only works in Google Spreadsheets as it uses a Google specific function:

B2=USCF ID in text format

=Value(mid(index(importHtml(“http://www.uschess.org/msa/MbrDtlMain.php?"&B2,"table”,5),3,2),2,4))

Trust me. It works :slight_smile:

-Matt

6

This topic is (also) being discussed in the clubs forum. Check there for more info.

Alex Relyea