Unfortunately, both schwarze and ozomatli are not in this year's tourney and we have relied on their considerable excel prowess to provide automatic scoring links in the past.

Do we have any owners here who think they can come up with something?

It's always nice to see how quickly I'm falling to the bottom of the standings.

I sent schwarze a DM to see if he'll teach me the arcane science that produces the consolidated standings.

If we can compensate Schwarze for his talents to help us out, I am more than willing to chip in a few bucks.

redcped ran it last year, and I believe he (with schwarze's help) set up an Excel sheet, but I could be wrong. I would check with him first.

Posted by Jtpsops on 6/30/2026 4:17:00 PM (view original):
redcped ran it last year, and I believe he (with schwarze's help) set up an Excel sheet, but I could be wrong. I would check with him first.

It was all schwarze. I don’t know how to do it alas.

I can send the spreadsheet I used last year with some explanations on how to set up the Web Query. You do need some knowledge of Excel for this to be useful.

The setup isn't difficult once explained, but it is time consuming for the initial setup. Once it is set up, it's just a matter of remembering to run it after each session and upload the revised file to a shared google drive.

The upload to a google drive turns the Excel spreadsheet into a Google Sheets Doc, and one extra step needs to be done each time after it's uploaded, due to some differences between Excel and Google. Sadly, I am not a Google Sheets expert, otherwise there may be a way for the update to occur automatically. I think ozomatli did this when he ran things.

Posted by schwarze on 6/30/2026 6:10:00 PM (view original):
I can send the spreadsheet I used last year with some explanations on how to set up the Web Query. You do need some knowledge of Excel for this to be useful.

The setup isn't difficult once explained, but it is time consuming for the initial setup. Once it is set up, it's just a matter of remembering to run it after each session and upload the revised file to a shared google drive.

The upload to a google drive turns the Excel spreadsheet into a Google Sheets Doc, and one extra step needs to be done each time after it's uploaded, due to some differences between Excel and Google. Sadly, I am not a Google Sheets expert, otherwise there may be a way for the update to occur automatically. I think ozomatli did this when he ran things.

I’m willing to try. But if we have anyone who inhabits these areas with more expertise, I gladly defer to them.

CPA here. I am on the case, and will hopefully become schwarze's pupil shortly.

Posted by Qhadow123 on 6/30/2026 6:25:00 PM (view original):
CPA here. I am on the case, and will hopefully become schwarze's pupil shortly.

Thank you for stepping up. We can try to do some roster analysis in the sheet, too, once it's going.

I sent him last year's spreadsheet with some instructions on how to set up the Web Query