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.xlsx 2024 NCAA WRESTLING BRACKET.xlsx 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 1 minute ago, Doublehalf said: Should we turn this into a vehicle to gamble with? Our March Matness Brackets perhaps? 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) 24 minutes ago, 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 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 2 minutes ago, nhs67 said: FYI, the names don't transfer over - as a heads up. Edit: HUGE thank you, btw. 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) 18 minutes ago, 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. 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) 4 minutes ago, 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... 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) 2 minutes ago, 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 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 1 minute ago, nhs67 said: Already tried it, and it does. Once one bracket is 'modified' it can be copy/pasted to the others. 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 5 minutes ago, 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. 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.xlsx
maligned Posted March 13 Posted March 13 3 hours ago, 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 WOW! This is amazing work.
Drew Newcomb Posted March 13 Author Posted March 13 3 hours ago, 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 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).xlsx 1 1 1
bnwtwg Posted March 14 Posted March 14 13 hours ago, 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 @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 13 hours ago, bnwtwg said: @Drew Newcomb more like Drew Nested amiright?! (Only the accounting homies will chuckle at that one) 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 1 hour ago, CGriff said: Is there gonna be an updated bracket with Brennan out? 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.xlsx
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.xlsx 1 1
Gabe Ramirez Canyon View, Arizona Class of 2025 Committed to California Baptist Projected Weight: 125, 133
Ane'e Vigil Prairie View via Clackamas CC, Colorado Class of 2025 Committed to Arizona State Projected Weight: 125
Madeline Bowlin Cane Bay, South Carolina Class of 2025 Committed to Presbyterian (Women) Projected Weight: 131
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