Drew Newcomb Posted March 13 Posted March 13 (edited) Last year I decided I wanted to see if I could make an excel file that to use for the 2024 NCAA Bracket to fill out and see how close I could get on projecting team points. This year I have upgraded the file a bit and have it ready for the 2025 tournament. This file can be used to either pick your own results or you can follow along with the actual tournament and fill it out as you go. HOW IT WORKS: There is a tab for each weight class that includes the bracket that will automatically fill out the bracket as you select the result of each match up (yellow box beside each name that has a drop down list of possible result). Based on this selection the bracket will automatically update the team points associated and progress each wrestler further into the bracket. The file keeps a track of each team point earned via advancement points, bonus points, and placement points just as trackwrestle does. There are tabs for each session to keep a running team score. There is a tab for overall team points that includes each wrestler based on team and the points they earned. There is also a tab for Finishers that includes the AA and blood round finishers at each weight. I have attached the blank 2025 NCAA Tournament file and the 2024 NCAA Tournament file to this post. Enjoy, if further instruction is needed to operate let me know. 2025 NCAA WRESTLING BRACKET.xlsxFetching info... 2024 NCAA WRESTLING BRACKET.xlsxFetching info... Edited March 13 by Drew Newcomb 3 2 2 1
Doublehalf Posted March 13 Posted March 13 Should we turn this into a vehicle to gamble with? Our March Matness Brackets perhaps? 1
Drew Newcomb Posted March 13 Author Posted March 13 Do with it as you please. Right now it is not capable of doing anything more than keeping track of the tournament based on what a user picks. Anything more than that is beyond my capabilities. 1
bnwtwg Posted March 13 Posted March 13 On 3/13/2025 at 1:07 PM, Doublehalf said: Should we turn this into a vehicle to gamble with? Our March Matness Brackets perhaps? Expand I'm in. I recommend using LeagueSafe to secure payments and payouts when interacting with strangers on the interwebs. i am an idiot on the internet
Doublehalf Posted March 13 Posted March 13 (edited) How would we submit and lock in/verify the brackets and scoring? My internet acumen for organizing anything outside of fantasy football is close to zero... I'm definitely in to do this though, doesn't have to be much, somewhere between a $30-$50 depending on how many people would do it and pay out top 3 perhaps? Edited March 13 by Doublehalf
nhs67 Posted March 13 Posted March 13 (edited) On 3/13/2025 at 1:00 PM, Drew Newcomb said: Last year I decided I wanted to see if I could make an excel file that to use for the 2024 NCAA Bracket to fill out and see how close I could get on projecting team points. This year I have upgraded the file a bit and have it ready for the 2025 tournament. This file can be used to either pick your own results or you can follow along with the actual tournament and fill it out as you go. HOW IT WORKS: There is a tab for each weight class that includes the bracket that will automatically fill out the bracket as you select the result of each match up (yellow box beside each name that has a drop down list of possible result). Based on this selection the bracket will automatically update the team points associated and progress each wrestler further into the bracket. The file keeps a track of each team point earned via advancement points, bonus points, and placement points just as trackwrestle does. There are tabs for each session to keep a running team score. There is a tab for overall team points that includes each wrestler based on team and the points they earned. There is also a tab for Finishers that includes the AA and blood round finishers at each weight. I have attached the blank 2025 NCAA Tournament file and the 2024 NCAA Tournament file to this post. Enjoy, if further instruction is needed to operate let me know. 2025 NCAA WRESTLING BRACKET.xlsx 886.99 kB · 11 downloads 2024 NCAA WRESTLING BRACKET.xlsx 943.57 kB · 1 download Expand FYI, the names don't transfer over - as a heads up. Edit: HUGE thank you, btw. Edited March 13 by nhs67 "I know actually nothing. It isn't even conjecture at this point." - me
Drew Newcomb Posted March 13 Author Posted March 13 On 3/13/2025 at 1:25 PM, nhs67 said: FYI, the names don't transfer over - as a heads up. Edit: HUGE thank you, btw. Expand Can you send a screen shot? The last names should transfer over. Make sure the only edits you make are in the yellow cells, any other changes can mess up the file.
nhs67 Posted March 13 Posted March 13 (edited) On 3/13/2025 at 1:28 PM, Drew Newcomb said: Can you send a screen shot? The last names should transfer over. Make sure the only edits you make are in the yellow cells, any other changes can mess up the file. Expand It does it for each method as well as each weight, the formula is... I notice the formula is different from the Pigtail... compared to... Edited March 13 by nhs67 "I know actually nothing. It isn't even conjecture at this point." - me
Drew Newcomb Posted March 13 Author Posted March 13 (edited) On 3/13/2025 at 1:46 PM, nhs67 said: It does it for each method as well as each weight, the formula is... I notice the formula is different from the Pigtail... compared to... Expand Interesting. Not sure where the "_xlfn." came from. Must have something do with it being uploaded. The formula in thename portion should be =IFERROR(TEXTAFTER(INDEX($B$56:$B$88,MATCH(I2,$A$56:$A$88,0))," "),"") let me know if that fixes the problem Edited March 13 by Drew Newcomb
nhs67 Posted March 13 Posted March 13 (edited) On 3/13/2025 at 1:50 PM, Drew Newcomb said: Interesting. Not sure where the "_xlfn." came from. Must have something do with it being uploaded. The formula in thename portion should be =IFERROR(TEXTAFTER(INDEX($B$56:$B$88,MATCH(I2,$A$56:$A$88,0))," "),"") let me know if that fixes the problem Expand Already tried it, and it does. Once one bracket is 'modified' it can be copy/pasted to the others. Edited March 13 by nhs67 "I know actually nothing. It isn't even conjecture at this point." - me
Drew Newcomb Posted March 13 Author Posted March 13 On 3/13/2025 at 1:52 PM, nhs67 said: Already tried it, and it does. Once one bracket is 'modified' it can be copy/pasted to the others. Expand Awesome, sorry about that. Its always a work in progress.
amorrow836 Posted March 13 Posted March 13 This is awesome, thank you! I tried to build something like this to track the Iowa HS State tournament, specifically looking at team scores and max points available to figure out when a team had clinched. Started it in 2024, ran it through the tournament and found bugs in my if statements for the consi side, fixed those in 2025, and it seemed to work for this years tourney. That's a 24 man bracket with Byes, mine isn't as elegant as yours, I enter 1,0,-1 and then have a cell to enter 1,1.5,2 for bonus. I might have to look at your code and see if I can improve mine some.
Drew Newcomb Posted March 13 Author Posted March 13 On 3/13/2025 at 2:40 PM, amorrow836 said: This is awesome, thank you! I tried to build something like this to track the Iowa HS State tournament, specifically looking at team scores and max points available to figure out when a team had clinched. Started it in 2024, ran it through the tournament and found bugs in my if statements for the consi side, fixed those in 2025, and it seemed to work for this years tourney. That's a 24 man bracket with Byes, mine isn't as elegant as yours, I enter 1,0,-1 and then have a cell to enter 1,1.5,2 for bonus. I might have to look at your code and see if I can improve mine some. Expand I've got one similar for the Big 12 that includes BYEs its a little more intricate as far as some of the issues go incorporating that. 2025 BIG12 WRESTLING BRACKET PROJECTIONS VS ACTUAL.xlsxFetching info...
maligned Posted March 13 Posted March 13 On 3/13/2025 at 1:00 PM, Drew Newcomb said: Last year I decided I wanted to see if I could make an excel file that to use for the 2024 NCAA Bracket to fill out and see how close I could get on projecting team points. This year I have upgraded the file a bit and have it ready for the 2025 tournament. This file can be used to either pick your own results or you can follow along with the actual tournament and fill it out as you go. HOW IT WORKS: There is a tab for each weight class that includes the bracket that will automatically fill out the bracket as you select the result of each match up (yellow box beside each name that has a drop down list of possible result). Based on this selection the bracket will automatically update the team points associated and progress each wrestler further into the bracket. The file keeps a track of each team point earned via advancement points, bonus points, and placement points just as trackwrestle does. There are tabs for each session to keep a running team score. There is a tab for overall team points that includes each wrestler based on team and the points they earned. There is also a tab for Finishers that includes the AA and blood round finishers at each weight. I have attached the blank 2025 NCAA Tournament file and the 2024 NCAA Tournament file to this post. Enjoy, if further instruction is needed to operate let me know. 2025 NCAA WRESTLING BRACKET.xlsx 886.99 kB · 48 downloads 2024 NCAA WRESTLING BRACKET.xlsx 943.57 kB · 3 downloads Expand WOW! This is amazing work.
Drew Newcomb Posted March 13 Author Posted March 13 On 3/13/2025 at 1:00 PM, Drew Newcomb said: Last year I decided I wanted to see if I could make an excel file that to use for the 2024 NCAA Bracket to fill out and see how close I could get on projecting team points. This year I have upgraded the file a bit and have it ready for the 2025 tournament. This file can be used to either pick your own results or you can follow along with the actual tournament and fill it out as you go. HOW IT WORKS: There is a tab for each weight class that includes the bracket that will automatically fill out the bracket as you select the result of each match up (yellow box beside each name that has a drop down list of possible result). Based on this selection the bracket will automatically update the team points associated and progress each wrestler further into the bracket. The file keeps a track of each team point earned via advancement points, bonus points, and placement points just as trackwrestle does. There are tabs for each session to keep a running team score. There is a tab for overall team points that includes each wrestler based on team and the points they earned. There is also a tab for Finishers that includes the AA and blood round finishers at each weight. I have attached the blank 2025 NCAA Tournament file and the 2024 NCAA Tournament file to this post. Enjoy, if further instruction is needed to operate let me know. 2025 NCAA WRESTLING BRACKET.xlsx 886.99 kB · 56 downloads 2024 NCAA WRESTLING BRACKET.xlsx 943.57 kB · 3 downloads Expand I HAVE UPDATED THIS SO IT SHOULD WORK BETTER ON GOOGLE DOCS OR IF YOU HAVE A LATER VERSION OF EXCEL 2025 NCAA WRESTLING BRACKET (UPDATED).xlsxFetching info... 1 1 1
bnwtwg Posted March 14 Posted March 14 On 3/13/2025 at 1:50 PM, Drew Newcomb said: Interesting. Not sure where the "_xlfn." came from. Must have something do with it being uploaded. The formula in thename portion should be =IFERROR(TEXTAFTER(INDEX($B$56:$B$88,MATCH(I2,$A$56:$A$88,0))," "),"") let me know if that fixes the problem Expand @Drew Newcomb more like Drew Nested amiright?! (Only the accounting homies will chuckle at that one) i am an idiot on the internet
Drew Newcomb Posted March 14 Author Posted March 14 On 3/14/2025 at 3:20 AM, bnwtwg said: @Drew Newcomb more like Drew Nested amiright?! (Only the accounting homies will chuckle at that one) Expand Haha love it! I'm actually an engineer, but we are pretty good with excel as well. 1
Stubz Posted March 14 Posted March 14 This is not working for me. It's not letting me open the document.
okokzach Posted March 16 Posted March 16 Here it is in case you hadn't found it @jajensen09 @Crossbodyboy. [File] > [Make a Copy] to save an editable version to your own Google Drive
Cornell Kevin Posted March 17 Posted March 17 idiot question coming up but am I supposed to see brackets to fill out on here cause all i see is the placement page. guess i don’t understand but i do want to
Drew Newcomb Posted March 19 Author Posted March 19 On 3/19/2025 at 5:49 PM, CGriff said: Is there gonna be an updated bracket with Brennan out? Expand I have updated the file to version 2.2 SEE FILE IN THIS POST UPDATES: 174 Bracket update (Tyler Brennan Situation) Finishers tab now includes the round of 16 finishers. Team & individual score now include Maximum Possible to determine maximum possible points a wrestler can get, automatically updates based on input match results. 2025 NCAA WRESTLING BRACKET VERSON 2.2.xlsxFetching info...
Drew Newcomb Posted March 20 Author Posted March 20 UPDATE: THERE WAS AN ISSUE WITH THE BONUS POINTS ON 125-149 BRACKETS IT HAS BEEN FIXED. SEE BELOW FOR VERSION 2.3 2025 NCAA WRESTLING BRACKET VERSON 2.3.xlsxFetching info... 1 1
James Lindsay Bishop Watterson, Ohio Class of 2026 Committed to Army West Point Projected Weight: 157, 165
Luke Geleta Phillipsburg, New Jersey Class of 2025 Committed to Binghamton Projected Weight: 141, 149
Graham Furtick Metrolina Christian, North Carolina Class of 2025 Committed to Gardner-Webb Projected Weight: 157
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now