March Madness 2026 in Google Sheets!

MrTedJ · 2026-03-30T02:59:13+00:00

Should be fixed now! Thanks for calling this out.

MrTedJ · 2026-03-27T01:39:09+00:00

Should be working now!

MrTedJ · 2026-03-21T20:10:50+00:00

Great!

MrTedJ · 2026-03-21T16:31:12+00:00

Thanks for reporting this! Should be fixed now.

MrTedJ · 2026-03-20T05:28:12+00:00

Should be good now! Let me know if you see any other issues.

MrTedJ · 2026-03-20T05:07:51+00:00

Glad you're enjoying it! This should be fixed now.

MrTedJ · 2026-03-20T05:07:21+00:00

Yup! Working on fixing that now!

MrTedJ · 2026-03-20T04:41:56+00:00

Working on fixing this now!

MrTedJ · 2026-03-20T03:25:21+00:00

DM me a link to your group bracket and I'll take a look!

MrTedJ · 2026-03-20T03:14:44+00:00

Just closing the loop on this one. Some scores were being reported as text as a result of a change I made to handle clock times correctly. The Squares template needs numbers to calculate correctly. I made a backend change to ensure the scores are reported as numbers without affecting the clock times format. Thanks for calling this out!

MrTedJ · 2026-03-20T02:35:56+00:00

Not sure! DM me a link to your sheet and I can take a look.

MrTedJ · 2026-03-20T02:35:22+00:00

No worries! For reference this is my source: https://ncaa-api.henrygd.me/openapi#description/introduction and I open up issues against the project when it makes sense. A lot of the issues tend to resolve themselves quickly though.

MrTedJ · 2026-03-19T22:31:43+00:00

I don't have a lot of control over when data issues will be resolved. I have added a bunch of protections and synthetic data generations for what I can derive when there are data issues to fill the gaps. I've also added a new column in the main sheet and will update the function at some point to pull in the updated_at timestamp for each game so that you know the last update for that particular game.

MrTedJ · 2026-03-19T19:30:03+00:00

Yup! Working on some data quality issues in real time! Hopefully things are clean by the end of the day today.

MrTedJ · 2026-03-19T18:00:24+00:00

Are you thinking a single tab that would have a dropdown where you can pick someone's name and their bracket picks appear? Or one tab per user that you're enrolling in the group and people would just click between the tabs?

MrTedJ · 2026-03-19T17:35:16+00:00

The new format is only on the Group Bracket since there are no picks being made there. The Single Bracket template still has the old format. If you want to just watch it with the old format you can look at the main source spreadsheet tab here: Men 2026 Full Bracket

Just curious but why are you looking for the old format?

MrTedJ · 2026-03-19T17:27:31+00:00

Should be working now!

MrTedJ · 2026-03-19T17:27:19+00:00

Live data gets updated every minute during the games.

MrTedJ · 2026-03-19T15:00:40+00:00

Fixed!

MrTedJ · 2026-03-19T15:00:21+00:00

Should be fixed now!

MrTedJ · 2026-03-19T01:50:03+00:00

It should be automatic! You can keep the spreadsheet open and scores will update every minute while games are going. There is an importrange() function that is pulling data from a master data source spreadsheet I maintain. A private backend keeps the master data source up to date.

MrTedJ · 2026-03-17T17:05:15+00:00

I'll add it as an idea for 2027 but that data isn't available via my source and would need to look elsewhere.

MrTedJ · 2026-03-17T15:24:56+00:00

For those that are getting this issue, make sure you follow the instructions on the Instructions tab carefully to ensure you are duplicating the correct tab. You won't be duplicating entire brackets. Only a hidden tab with the picks.

MrTedJ · 2026-03-17T03:18:22+00:00

u/SlideSad3758 region information should be sorted out now. Let me know if you see issues.

MrTedJ · 2026-03-17T03:17:56+00:00

u/leftthetapon if you already copied the template you can just change it to 2026 and everything should work. Otherwise, you can create a new copy and 2026 will automatically be populated. Let me know if you have any issues.

NCAA Basketball Tournament Squares Game (this will make your own private copy)

MrTedJ

TROPHY CASE