ADVERTISEMENT

Interactive Bracket - 2019 - 125 and HWT Redrawn available

LutherAce

HR All-American
Oct 31, 2002
4,154
3,805
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:
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.
 
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.
 
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.
 
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.
 
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
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.
 
Are you planning to update the heavyweight bracket? As a fan of college wrestling I greatly appreciate your time and effort.
 
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?
 
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.
 
ADVERTISEMENT