Setting up NCAA Pool in Excel?
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Setting up NCAA Pool in Excel?

  1. #1
    Guest

    Default

     
    Disclaimer: In posting this message I am in no way condoning the use of NCAA Pools, as I know that they are illegal. Yep.

    Hypothetically, then, if I were in an NCAA pool and trying to figure out how best to score the entries rather than going through each individual person's bracket every time a round completes to sum their score, do any of you know of a way to get Excel to do this for me? Lots of If-Then statements that I don't know how to use, but I imagine it can be done.

    I was thinking something along the lines of: type in the entire bracket on sheet one, type in everyone's round one picks on sheet two, everyone's round two picks on sheet three, and so on, and then have a tab with everyone's score, which is linked directly to their bracket. This score would be automatically calculated at the end of every round as I type in the winners of each game. That would save a TON of work for me.

    Any ideas would be greatly appreciated. Thanks in advance!

    Ro

  2. #2
    Guest

    Default

    Also, I forgot to add that, in this hypothetical world, we would give double points if a person were to pick an upset victory (just based on seeds, not Vegas lines, so if the team with the lower seed wins, that counts for 2x the points).

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-13 14:54, Anonymous wrote:
    Disclaimer: In posting this message I am in no way condoning the use of NCAA Pools, as I know that they are illegal. Yep.
    Sure, in the same way that I don't condone going to lunch tomorrow in our building's restaurant, spending $8 for the buffet and then sitting for 3 hours watching NCAA basketball that I'm not interested whilst stuffing chicken wings into my fat face.

    Actually, there may be someone here's that's got something. Also, and this is quite sad, there are quite a few "March Madness" utilities on the internet. I highly recommend searching for them. Although a pool spreadsheet named "Budget.xls" is far more enticing than having shortcuts all over your machine that say stuff like "NCAA Pool Manager Software v4.0".



  4. #4
    Guest

    Default

    Yeah, but I think they all cost money. I don't imagine it can take too long to set a really crappy one up in Excel, which is why I don't really care to lay out the $20.

  5. #5
    New Member
    Join Date
    Jun 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Let me know what you come up with or find. I am in the same boat, hypothetically, of course.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com