Welcome home, fellow Gator.

The Gator Nation's oldest and most active insider community
Join today!

Final Regular Season Contest Results

Discussion in 'Nuttin' but Net' started by OklahomaGator, Mar 7, 2020.

  1. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    finalstats.JPG
     
  2. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    finalbest.JPG finalplayers.JPG
     
  3. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    finalrank.JPG
     
    • Like Like x 1
  4. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
  5. buckeyegator

    buckeyegator Premium Member

    2,878
    493
    478
    Oct 29, 2007
    gainesville, florida
    the twist better be to get me better scores, last 3 games lost points in each game.
     
  6. HallGator

    HallGator Senile Administrator Moderator VIP Member

    52,653
    2,698
    2,508
    Apr 3, 2007
    Outer Limits
    Great job Oklahoma! All the work has really been appreciated and it was good to see so many participants.

    Next up, the conclusion of the season and who wins out.
     
    • Agree Agree x 4
  7. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    Thanks and I want to thank everyone who participated in it. Your input resulting in the modified scoring in the second half seemed much more realistic as to the overall player performance.
     
    • Like Like x 1
  8. jeffphillips21

    jeffphillips21 VIP Member

    3,614
    619
    408
    Jun 20, 2009
    Vancouver
    Yes great job Oklahoma! A lot of work went into this and has been a lot of fun, especially when my picks do well
     
    • Fistbump/Thanks! Fistbump/Thanks! x 1
  9. akaGatorhoops

    akaGatorhoops VIP Member GC Columnist

    15,573
    2,695
    1,483
    Apr 10, 2007
    Great context. Thanks!
    Looking forward to the next round.
     
  10. Matherly87

    Matherly87 VIP Member

    4,503
    4,656
    613
    Oct 3, 2016
    Ocala, FL
    Thanks again Oklahoma for all your time behind the scenes. I'm surprised I made in it today with Blackshear getting hurt. Another example of how close the scoring ended up. Can't wait to see what twist you have in mind.
     
  11. tampajack1

    tampajack1 Premium Member

    6,993
    895
    333
    Apr 3, 2007
    Why aren’t I in the finals? I am only 186 points out of the lead. I can easily make that up within the next 5 years, which is the same amount of time that we have given Mike White. You will be hearing from my lawyer, Wily Coyote, Esq. from the law firm of Dewey, Cheatem and Howe, LLP.
     
    • Funny Funny x 2
  12. gatortenor37

    gatortenor37 GC Legend

    803
    283
    408
    Jan 29, 2016
    Arkansas
    Top 10 both rounds for me, but close only counts in horseshoes and handgranades.
     
  13. lifetimeg8r

    lifetimeg8r All American

    321
    7
    213
    Jan 18, 2008
    Damn ... I was top 5 for most of the 2nd half. But relied on a freshman at the end and it burned me. Definitely enjoyed participating regardless :)
     
  14. gatorbogey

    gatorbogey GC Hall of Fame

    38,137
    2,147
    1,898
    Apr 3, 2007
    s. e. florida
    Fun contest. Will this be an annual occurrence?
     
  15. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    That depends on everyone I guess. I would say it took about 2 hours (not at one sit down, but over a day or so)per game to do all of the tracking, calculations and posting. I would need to figure out a way to make that easier.
     
    • Agree Agree x 1
    • Fistbump/Thanks! Fistbump/Thanks! x 1
    • Informative Informative x 1
  16. channingcrowderhungry

    channingcrowderhungry Premium Member

    5,984
    1,327
    733
    Apr 3, 2007
    Bottom of a pint glass
    I had a blast doing it.

    Did you do your calculations using an excel spreadsheet? If not that should save a lot of time by simply plugging everything in.
     
    • Agree Agree x 2
  17. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    Yes did an excel spread sheet that totaled the points for me and did a simple sort to get the rankings. Once I got it set up in the beginning it wasn't that hard. Just entering everyone picks, then calculating the contest points, entering the points then by each poster was a little time consuming. After that, the totals, sorting, and copying the info off was pretty quick.

    I do pretty well with excel but probably will improve the sheet if we do it again next year to make it a little easier.
     
    • Like Like x 1
  18. channingcrowderhungry

    channingcrowderhungry Premium Member

    5,984
    1,327
    733
    Apr 3, 2007
    Bottom of a pint glass
    Sounds like you need to do one more formula of an "if/then" so you just enter who people pick and then it will auto fill their points on the backside. Such as "if D1=Egbunu then F1=points." Not sure if your dabbled in that type of excel nonsense, but if you decide to do this again next year I can help you set it up.

    My guess is there is a website where you can just download the boxscore in an excel sheet and plug it in, so then really the only manual work would be entering who people picked.
     
    • Like Like x 1
    • Winner Winner x 1
  19. Matherly87

    Matherly87 VIP Member

    4,503
    4,656
    613
    Oct 3, 2016
    Ocala, FL
    I wonder if you set up each game as a pivot table to populate the first page and keep loading pivot tables to build on as the season goes. I've never created it myself but I've worked many a budget and forecasts all through pre-loaded pivot tables that can do some amazing things if it all flows right.
     
    • Winner Winner x 1
  20. OklahomaGator

    OklahomaGator Jedi Administrator Moderator VIP Member

    77,511
    46,454
    3,128
    Apr 3, 2007
    Appreciate the offer, if we do it again we can share spread sheets and get it figured out. I see what you are thinking about only entering the players points once and let the stats "autofill". Wish I would have thought of that sooner. I'll be in touch next time for sure.