Interactive Bracket - 2019 - 125 and HWT Redrawn available

LutherAce

HR All-American
Oct 31, 2002
3,998
3,454
113
Here you go: https://www.dropbox.com/s/7741wqhaop6bivj/2019ncaaChampionshipsV1.xlsx?dl=0

Version 2 with 125 redrawn: https://www.dropbox.com/s/xz803lfupzk229p/2019ncaaChampionshipsV2.xlsx?dl=0

Version 3 with 125/HWT redrawn:
https://www.dropbox.com/s/0fpu66pjkdqxit6/2019ncaaChampionshipsV3.xlsx?dl=0

Note: you will have to download the file before playing with it.

Some changes i made for this year:

Changed the scoring so all you have to do is put the result next to the winner (D, M, T, F)
Formatted the brackets a little different so the seed order is on the far left, and then the bracket.
Took over 5 hours to re-adjust all of the point tables to reflect the letters instead of the math...there still might be some erroneous cells, but at 230, things were starting to run together.

If you find any mistakes, please let me know and i'll fix them as i can.
 
Last edited:

Buchos

Rookie
Nov 30, 2018
36
69
18
Thank you for this. Just made my day so much better. Needed to have the seeds listed in order and you already took care of that. Much appreciated.
 

ss7

Scout Team
Feb 5, 2018
138
242
43
This is awesome. Thanks!

It does look like, for every match (or at least the few I've entered values), any value entered for the wrestler listed in the higher cell automatically moves that wrestler through.

For example, the Mattin - Oliver R1 match, any value entered for Mattin (even 0) moves him through, regardless of the value entered for Oliver.
 

LutherAce

HR All-American
Oct 31, 2002
3,998
3,454
113
This is awesome. Thanks!

It does look like, for every match (or at least the few I've entered values), any value entered for the wrestler listed in the higher cell automatically moves that wrestler through.

For example, the Mattin - Oliver R1 match, any value entered for Mattin (even 0) moves him through, regardless of the value entered for Oliver.

Correct, any value in the field will advance them, but if you don't use the D,M,T,F value, points won't calculate for the advancement/result.
 

ss7

Scout Team
Feb 5, 2018
138
242
43
Correct, any value in the field will advance them, but if you don't use the D,M,T,F value, points won't calculate for the advancement/result.

Oh. I guess I misunderstood. It's even better than I thought! Thanks again.
 

cosmo90

Team MVP
Gold Member
Aug 21, 2005
239
558
93
Here you go: https://www.dropbox.com/s/7741wqhaop6bivj/2019ncaaChampionshipsV1.xlsx?dl=0

Note: you will have to download the file before playing with it.

Some changes i made for this year:

Changed the scoring so all you have to do is put the result next to the winner (D, M, T, F)
Formatted the brackets a little different so the seed order is on the far left, and then the bracket.
Took over 5 hours to re-adjust all of the point tables to reflect the letters instead of the math...there still might be some erroneous cells, but at 230, things were starting to run together.

If you find any mistakes, please let me know and i'll fix them as i can.

Bump. Because this is so cool.
 
  • Like
Reactions: CowboyUp61
Mar 5, 2016
4
5
3
Here you go: https://www.dropbox.com/s/7741wqhaop6bivj/2019ncaaChampionshipsV1.xlsx?dl=0

Version 2 with 125 redrawn: https://www.dropbox.com/s/xz803lfupzk229p/2019ncaaChampionshipsV2.xlsx?dl=0

Note: you will have to download the file before playing with it.

Some changes i made for this year:

Changed the scoring so all you have to do is put the result next to the winner (D, M, T, F)
Formatted the brackets a little different so the seed order is on the far left, and then the bracket.
Took over 5 hours to re-adjust all of the point tables to reflect the letters instead of the math...there still might be some erroneous cells, but at 230, things were starting to run together.

If you find any mistakes, please let me know and i'll fix them as i can.

As a PSU fan I really just wanted to say thank you again for this. It really is awesome.
 
Nov 15, 2011
1
0
1
Are you planning to update the heavyweight bracket? As a fan of college wrestling I greatly appreciate your time and effort.
 

Mendoza77

HR All-State
Jan 31, 2015
996
2,107
93
Tonight..check after 9 Central

Last night I really enjoyed choosing my projected winners of all matches, except for 125 since you didn't have it updated with the re-drawn bracket (and now of course 285 has been re-drawn also). My question is, when I download version 3, how can I keep all of the choices that I made last night, in the weight classes other than 125 and 285? Is there a way to "merge" my completed version with version 3, or will I have to input my choices all over again?
 
Mar 30, 2002
1,754
326
83
Last night I really enjoyed choosing my projected winners of all matches, except for 125 since you didn't have it updated with the re-drawn bracket (and now of course 285 has been re-drawn also). My question is, when I download version 3, how can I keep all of the choices that I made last night, in the weight classes other than 125 and 285? Is there a way to "merge" my completed version with version 3, or will I have to input my choices all over again?
Just copy-paste the 133-197 brackets between the two sheets...that's what I did.