It is more difficult than you think, but I can do it. The data is spread among many workbooks because the file sizes get massive. And nicknames can be tricky, as there can be multiple instances of each.
There is the added complication in future that I might have to cut down what I do. Today I had to pay for the data scrape for TT31 because Sony/PD/whoever runs the gran-turismo.com site has blocked my normal scraper. That is why the results were delayed. I spoke with the scraping firm and they say sites sometimes increase their blocking intensity, hence me having this problem for the first time. The solution is to pay for the pro version and take advantage of their IP address rotation tool, but that is north of $100 p.m. so clearly I am not doing that. Other suppliers are similar in price.
That said, I'm happy to help, but as this already takes a whole chunk of my time, let me propose the following:
- - You make a list of all users who wish to be included.
- - You get their consent for me to slightly process their data (I already have it for some due to an earlier exercise I did - option for you to search for that on this thread or just ask them again).
- - You get their GT7 nicknames and ensure they are the right ones by getting their GT7 profile page link (example here is mine: https://www.gran-turismo.com/gb/gt7/user/mymenu/acfa6a32-1c74-4c0b-852e-b8a1bf152d08/profile)
- - Share with me that list of nicknames and profile page links
- - Tell me what data you want, for example, time, position?
- - Then I will create the table and update after each TT, as long as I can resolve the scraping matter.