Exactly 1 year ago I had a need to pull down a copy of the combined rankings for every course and flap off the players page, but doing this by hand was a pain. I was inspired by basebalkid's Excel macros that do this for you, but it needed a fresh coat of paint. So I created a document that reduced the number of simultaneous web queries from well over 100 down to just 36. This improved performance dramatically, and now it takes just 2-3 minutes to pull down all the data.

So I just kept pulling the data. I'd take the file, do a save as with an appropriate file name, and rerun the query each week. Then I'd mark the file read-only so I don't accidentally muck it up. I figured there might be a future use for it doing historical trends. I'm up to a year's worth of data, so I wanted to share in case someone more brilliant than me could find a use for it. I'll continue to update this each week (assuming I'm not forgetful).

You can find the archive here:
https://drive.google.com/drive/folders/1NBf0P1ZC6L3Xj4QFpWIUWNg0tX0rMYj5?usp=...

Each file contains multiple tabs. 1 each for AF, ARR, PRSR, and the course and flap records for all 16 tracks.

I could further automate the file, but I've been busy/lazy. Some things I would like to add:
1. Automate the process to run the web queries weekly (or upon detection of Alex P's post), save a copy of the file, and make it read-only. Right now I'm at risk of missing a week's worth of data if I forget to run the queries and save a new file once a week. Although it only takes 2 minutes, I've had some close calls...
2. Fix the issue with the web queries failing if it searches for a table with no results. See if a page like Luigi's Circuit has exactly 1300 records, but I attempt to pull down records 1301-1400, the whole query fails. Writing a catch statement would save me from having to manually update the query when a page rolls from having 1300 records to 1301 records (if I don't manually update the query, the final record is truncated).

If you know Power Query / VBA and are interested in helping me with these two ideas, I'd appreciate it.

So there you have it. Hopefully this is of use to somebody. Having a secret archive without telling anyone doesn't help anyone. Enjoy!

ETA: Justin Paris's sheet probably pulls the data more elegantly than mine; I forgot it existed. However, the point of this post was to share the archived data.