Interactive Bracket - 2019 - 125 and HWT Redrawn available

Discussion in 'Iowa Wrestling' started by LutherAce, Mar 14, 2019.

  1. LutherAce

    LutherAce HR All-American
    Expand Collapse

    Joined:
    Oct 31, 2002
    Messages:
    3,690
    Likes Received:
    2,860
    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.
     
    1 LutherAce, Mar 14, 2019
    Last edited: Mar 20, 2019
    oldhawk56, Gusaford, breno14 and 17 others like this.
  2. MSeil

    MSeil All-Conference
    Expand Collapse

    Joined:
    Nov 23, 2017
    Messages:
    339
    Likes Received:
    601
    Thanks man!
     
  3. Buchos

    Expand Collapse

    Joined:
    Nov 30, 2018
    Messages:
    11
    Likes Received:
    15
    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.
     
  4. ss7

    ss7 Scout Team
    Expand Collapse

    Joined:
    Feb 5, 2018
    Messages:
    116
    Likes Received:
    225
    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.
     
  5. LutherAce

    LutherAce HR All-American
    Expand Collapse

    Joined:
    Oct 31, 2002
    Messages:
    3,690
    Likes Received:
    2,860
    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.
     
  6. ss7

    ss7 Scout Team
    Expand Collapse

    Joined:
    Feb 5, 2018
    Messages:
    116
    Likes Received:
    225
    Oh. I guess I misunderstood. It's even better than I thought! Thanks again.
     
  7. cosmo90

    cosmo90 Scout Team
    Expand Collapse

    Joined:
    Aug 21, 2005
    Messages:
    105
    Likes Received:
    264
    Bump. Because this is so cool.
     
    CowboyUp61 likes this.
  8. sirhcdralla

    Expand Collapse

    Joined:
    Mar 5, 2016
    Messages:
    4
    Likes Received:
    5
    125 needs to be updated since it was redrawn with the withdraw of Millhof
     
  9. LutherAce

    LutherAce HR All-American
    Expand Collapse

    Joined:
    Oct 31, 2002
    Messages:
    3,690
    Likes Received:
    2,860
    On vacation until tomorrow night. Will update it when I get home
     
    sirhcdralla likes this.
  10. sirhcdralla

    Expand Collapse

    Joined:
    Mar 5, 2016
    Messages:
    4
    Likes Received:
    5
    No worries, Just wanted to give you a heads up. Hell of a job done on this. Very impressive.
     
    your_master5 likes this.
  11. mvattivo

    mvattivo Team MVP
    Expand Collapse

    Joined:
    Jun 23, 2005
    Messages:
    264
    Likes Received:
    745
    Has this been updated with the new 125? By the way, this is awesome! Thanks for all your hard work putting it together.
     
  12. sirhcdralla

    Expand Collapse

    Joined:
    Mar 5, 2016
    Messages:
    4
    Likes Received:
    5
    As a PSU fan I really just wanted to say thank you again for this. It really is awesome.
     
  13. wildcat2993

    Expand Collapse

    Joined:
    Nov 15, 2011
    Messages:
    1
    Likes Received:
    0
    Are you planning to update the heavyweight bracket? As a fan of college wrestling I greatly appreciate your time and effort.
     
  14. LutherAce

    LutherAce HR All-American
    Expand Collapse

    Joined:
    Oct 31, 2002
    Messages:
    3,690
    Likes Received:
    2,860
    Tonight..check after 9 Central
     
  15. Mendoza77

    Mendoza77 HR All-State
    Expand Collapse

    Joined:
    Jan 31, 2015
    Messages:
    582
    Likes Received:
    1,343
    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?
     
  16. SetonHallPirate

    Expand Collapse

    Joined:
    Mar 30, 2002
    Messages:
    1,718
    Likes Received:
    273
    Just copy-paste the 133-197 brackets between the two sheets...that's what I did.
     
  17. Mendoza77

    Mendoza77 HR All-State
    Expand Collapse

    Joined:
    Jan 31, 2015
    Messages:
    582
    Likes Received:
    1,343
    Didn't know I could copy-paste in Excel - I'll give it a try
     
  18. Is_there_vodka_in_heaven

    Is_there_vodka_in_heaven HR All-American
    Expand Collapse

    Joined:
    Mar 24, 2016
    Messages:
    2,603
    Likes Received:
    6,853
    Right click the sheet tab at the bottom that you want to copy and then it'll have options. You can have copies moved into a new file.
     

Share This Page