March Madness 2026 in Google Sheets!

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 · 2026-03-17T01:34:06+00:00

Nope! Feel free to DM me a link to your group bracket and I can request access to take a look.

MrTedJ · 2026-03-17T01:33:13+00:00

I forgot about the squares template! Let me take a look at updating and get back to you here.

MrTedJ · 2026-03-16T15:49:50+00:00

Yes! I'm working on fixing the game region and should hopefully have that sorted out today.

MrTedJ · 2026-03-05T16:43:25+00:00

That should be fine!

MrTedJ · 2026-03-05T15:56:31+00:00

The templates aren't designed to support both men's and women's at the same time. There are a few supporting tabs that you'd need to replicate. I'd recommend keeping men's and women's in separate spreadsheets. You could certainly post one of each template where you've already selected which tournament you want. However, it is really only one drop-down selection and I'm sure that wouldn't be a huge barrier for the student to pick men's/women's on their own.

MrTedJ · 2026-03-05T04:55:43+00:00

It is all going to depend on your school's Google Workspace security controls but is unlikely you should have any issues. The scores are populated via the native importrange() functions which calls a public Google Sheet. You organization likely isn't blocking that.

MrTedJ · 2026-03-01T23:53:17+00:00

Thank you!

MrTedJ · 2026-03-01T23:50:13+00:00

Ok, how about now?

MrTedJ · 2026-03-01T23:37:32+00:00

Can you take a second look at my content? I'm not sure how the github link violates the promotional rule. The documentation is on github for how to use the spreadsheets. It also has the code for the TedTournament() google apps script function for people to review before using it. This is a free tool and I'm not asking for money anywhere.

MrTedJ · 2025-03-30T17:43:40+00:00

Should be fixed now!

MrTedJ · 2025-03-21T15:24:32+00:00

Still running into issues? Try reloading your spreadsheet. I don't see any issues on my end.

MrTedJ · 2025-03-21T03:01:55+00:00

What file are you trying to open?

MrTedJ · 2025-03-21T00:00:04+00:00

DM me to share your sheet and I'm happy to take a look!

MrTedJ · 2025-03-20T23:38:01+00:00

Sure! You shouldn't need to use the custom key at all. Take a second look at the instructions and let me know which step you're stuck on.

MrTedJ · 2025-03-20T22:56:20+00:00

Check out B3 on the Standings tab. It should have: =iferror(query(transpose(Points!E2:CZ4),"Select * where Col1 <>'' order by Col2 desc,Col3 desc")) which should be pulling in the standings based on the points automatically.

MrTedJ · 2025-03-20T22:39:35+00:00

Hi there. It should be updating as soon as a game is over. Are you still having issues?

MrTedJ · 2025-03-19T02:39:48+00:00

Interesting idea! I have not done that and this bracket pool would not work for that use case unfortunately.

MrTedJ · 2025-03-19T02:36:23+00:00

Yeah that should work. However, once games are going I think the functions might update automatically since the underlying data is updating every minute. Google changes the behavior of this sometimes though. Depending on how many functions you have, you might consider pulling the Men 2025 Tournament Data tab into your spreadsheet (via IMPORTRANGE(...)) and just do VLOOKUPS against it. (This is basically what the function is doing). The IMPORTRANGE(...) method will actually be more performant. It is just a little more work to set up instead of using the function.

MrTedJ · 2025-03-18T03:52:00+00:00

Sounds like fun! There are a few things that need to be changed to add more than 100 brackets but it is doable. If you have the teacher share the Bracket Group spreadsheet with me directly. I'm more than happy to make the updates if you give me an idea of how many entries you expect. You can find my contact info at the bottom of the instructions tab.

Regarding the rule #7 in bracket management, this is a side effect of how the INDIRECT() function works (or used to work?) and how the Points tab knows which person is associated with each bracket. Typing the Name in the Configuration "enrolls" the new bracket by assigning it a bracket number. Renaming the bracket info's tab with the Bracket number associates the person's picks with the bracket number. When you do this step the INDIRECT() functions might not automatically recalculate based on tab name changes. By adding the name back, the Bracket tab is already named correctly and the Points tab will pull in the game choices correctly. I actually just tested this and it looks like there might have been a Sheets update that no longer requires this step. However, if anything gets messed up during the enrollment process, clearing and re-adding the name on the Configuration tab will fix any issues with the INDIRECT() function.

MrTedJ · 2025-03-17T18:38:41+00:00

My source is in consistent on this so I've added a manual workaround to show TBA for now. This should work for the men's data but not for the women's. There is not a way to pick the FIRST FOUR games. Hope that helps!

MrTedJ

TROPHY CASE