NBO? NBA Chance 0-9 pool

Discussion in 'Beer It Forward' started by Syracuse12, Oct 9, 2014.

Thread Status:
Not open for further replies.
Page 8 of 20
  1. Dave_Treat

    Dave_Treat Pooh-Bah (2,287) Jun 23, 2012 Virginia
    Pooh-Bah Trader

    An easy way would be teams down the side, and numbers across the top. Just check the box in the appropriate column as team hits. You can calculate total unique numbers by counting cells that are not blank. Makes it a wide sheet, so maybe someone has a better way.
     
    #141 Dave_Treat, Oct 27, 2014
  2. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    That's what I had in mind, unless someone came up with some clever. Numbering from 60-130 (best guess for range of scores) would make a wide spreadsheet.
     
    #142 Syracuse12, Oct 27, 2014
  3. LakerLeith

    LakerLeith Initiate (0) Aug 11, 2013 California

    Due to new ship rules, I'll take the Kings as well. cheers
     
    #143 LakerLeith, Oct 27, 2014
    Syracuse12 likes this.
  4. nathanmiller

    nathanmiller Initiate (0) Oct 7, 2009 New York

    That's crazytown.

    Just put teams across the side, game #s across the top. Then fill in scores each day.

    The final column should be =SUM(IF(FREQUENCY($A1:$CE1,$A1:$CE1)>0,1))
     
    #144 nathanmiller, Oct 27, 2014
    Syracuse12 likes this.
  5. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    I knew someone would know better.
     
    #145 Syracuse12, Oct 27, 2014
  6. cal1207

    cal1207 Initiate (0) Oct 29, 2013 California

    I will take a second team if there's one left.
     
    #146 cal1207, Oct 28, 2014
  7. cal1207

    cal1207 Initiate (0) Oct 29, 2013 California

    Preference to the kings if not anyone is fine.
     
    #147 cal1207, Oct 28, 2014
  8. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    Kings are yours
     
    #148 Syracuse12, Oct 28, 2014
  9. LakerLeith

    LakerLeith Initiate (0) Aug 11, 2013 California

    I just claimed the Kings? ^^^
     
    #149 LakerLeith, Oct 28, 2014
  10. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    This is why I shouldn't BA while cleaning up a 2 years old puke.

    How about Hawks @cal1207
     
    #150 Syracuse12, Oct 28, 2014
    LakerLeith likes this.
  11. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    Syracuse12 Raptors & nuggets
    tommyguz Suns
    Bjohnston TBD
    Dave_Treat Wizards & Nets
    mhksuccess Lakers & Knicks
    hansenm72 Bucks
    Summer78 Bulls & pistons
    Afi4lifer Celtics
    Nathanmiller Rockets
    DooshBagalow Jazz
    Tugg407 Magic & Heat
    Lakerleith Warriors & Kings
    Leftoverburrito Blazers
    Ajaylock spurs & Pacers
    Richkrull Timberwolves
    Jshusc mavericks
    Kevinmc79 hornets
    Cal1207 Cavs & Hawks
    Lkoro Pelicans & Clippers
    Aleforme Thunder


    28 teams assigned, 29 teams promised. 1 spot left for anyone that wants to double up based on new rules (ship once, double minimum). 76ers and Grizzlies remain. One is for @Bjohnston
     
    #151 Syracuse12, Oct 28, 2014
  12. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    Would you be willing to take a look at the sheet and see what I'm doing wrong? Seems like there is something incorrect since I only get a 1 no matter how many scores I put in as a test.

    https://docs.google.com/spreadsheets/d/1-Q52Xp54EGbZNR0MasnLXd9OPHsEFysEGLrWTGvLt0E/edit?usp=sharing

    For everyone else, the sheet is not complete (or interesting at this point), just trying to get it set up.
     
    #152 Syracuse12, Oct 28, 2014
  13. nathanmiller

    nathanmiller Initiate (0) Oct 7, 2009 New York

    Looking now, one sec.

    EDIT:

    Ha, turns out that google has a "COUNTUNIQUE" function and interestingly, FREQUENCY doesn't work the same as in excel.

    =COUNTUNIQUE($C2:$AQ2)

    Try that.
     
    #153 nathanmiller, Oct 28, 2014
    Last edited: Oct 28, 2014
    Syracuse12 likes this.
  14. Bjohnston

    Bjohnston Initiate (0) Dec 24, 2011 Kentucky

    I'll take both of them.
     
    #154 Bjohnston, Oct 28, 2014
    Syracuse12 likes this.
  15. hansenm72

    hansenm72 Pundit (847) Jan 23, 2014 Texas

    I can set up a spreadsheet in google docs and share it

    EDIT: Nevermind... you already did
     
    #155 hansenm72, Oct 28, 2014
    Syracuse12 likes this.
  16. jshusc

    jshusc Pooh-Bah (1,654) Aug 16, 2013 South Carolina
    Pooh-Bah Trader

    Hate to throw the wrench out there, but @Damian74Shensky isn't on your list, and I know he has teh Clippers because he took them one post before I got the Mavs. Need to double check the list, but I know the Clips are now held by two teams.
     
    #156 jshusc, Oct 28, 2014
  17. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    Almost works, but not quite. Seems like it discounts both duplicates (22 is listed twice and doesn't count either one). It is giving me 4 on example set up, but should be 5.
     
    #157 Syracuse12, Oct 28, 2014
  18. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    @Damian74Shensky changed his mind about participating in this BIF. I hope to beat him a different BIF soon.
     
    #158 Syracuse12, Oct 28, 2014
    Damian74 likes this.
  19. jshusc

    jshusc Pooh-Bah (1,654) Aug 16, 2013 South Carolina
    Pooh-Bah Trader

    Aargh! 2 chances to get clips and missed twice
     
    #159 jshusc, Oct 28, 2014
    Syracuse12 likes this.
  20. Syracuse12

    Syracuse12 Initiate (0) Aug 21, 2012 New Jersey
    Trader

    Good thing this BIF is really no different than a lottery. Even worse than NFL 33.
     
    #160 Syracuse12, Oct 28, 2014
Page 8 of 20
Thread Status:
Not open for further replies.