Anyone Want to do "Fantasy League" For the Tour?

1293032343549

Comments

  • MayDay10
    MayDay10 Posts: 11,856
    muchos gracias for updating the scoresheet.

    I was Baltimoring all weekend!
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    edited October 2013
    MayDay10 wrote:
    muchos gracias for updating the scoresheet.

    I was Baltimoring all weekend!

    :thumbup: Me too! Just did it once I got home last night at 1 am :lol:

    EDIT: Didn't know you were making the trip! Should have met up before hand.. Next tour! 8-)
    Post edited by FrankieG on
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    BN8419 wrote:
    This league is pretty difficult to judge who is in the lead, winning/losing, etc... I am going to present our conference in a different way than what's shown on the google doc just for fun-

    Assuming every song on an individual's roster is played, it comes down to who has the fewest duplicates plays. If a song is played 8 times on tour, that would be 7 duplicate plays, another may be played 3 times, which is two duplicate plays. For every song that doesn't get played all tour, that is equivalent to 26 duplicate plays over the course of the tour.

    If you have a song that has not yet been played, once it's played, your score drops by 26 points on the leaderboard, and you move up. If you have a song that has already been played and it gets played again, you score increases by 1 and you move down.

    Ranking in terms of fewest duplicates/duplicate equivalents (adjusted for songs not yet played) -

    CAMERON Standings
    1. Phillycrownofthorns.....14 (0 not played / 14 duplicates)
    2. Evilclosetmonkey........35 (1 / 9)
    3. PJ Soul.....................58 (2 / 6)
    4. BN..........................60 (2 / 8)
    5. rr...........................107 (4 / 3)
    6. kurto.......................111 (4 / 7)
    7. PJ23........................112 (4 / 8)
    8. eeriepadave..............114 (4 / 10)
    9. musicdude...............116 (4 / 12)
    10. neutronbaum...........117 (4 / 13)
    11. mjservs..................135 (5 / 5)
    12. Gern Blansten..........182 (7 / 0)

    Thats a cool way to look at it! Would you mind if I coded it in so that the doc automatically calculates this? :)
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • BN8419
    BN8419 Posts: 290
    Sure- have at it!

    It would be interesting to see the leaderboard like this for all the conferences together.
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    BN8419 wrote:
    Sure- have at it!

    It would be interesting to see the leaderboard like this for all the conferences together.

    :thumbup: I'll see what i can do tonight. :mrgreen:
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • JimmyV
    JimmyV Boston's MetroWest Posts: 19,602
    Hard to Imagine AND Love Reign O'er Me in Baltimore...I'm making my move in the McCready conference! :D
    ___________________________________________

    "...I changed by not changing at all..."
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    JimmyV wrote:
    Hard to Imagine AND Love Reign O'er Me in Baltimore...I'm making my move in the McCready conference! :D

    I saw that! Was like 'who the hell is passing me'. Glorified G was on the setlist for Baltimore too, which would have put me up another 26 points, which would have really made it close!
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • CAVSTARR313
    CAVSTARR313 Posts: 8,756
    PLAY RIVAL YOU FUCKIN' PUSSIES
    None are more hopelessly enslaved than those who falsely believe that they are free.
    Abrn Hlls '98 - Clarkston 2 '03 - Grd Rpds '06 - Abrn Hlls '06 - Clvd '10 - PJ20 - Berlin 1+2 '12 - Wrigley '13 - Pitt '13- buff '13- Philly 1+2 '13 - Seattle '13
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    -Updated Scoresheet-

    Now dynamically sorts based on score (To the right of the grey boxes)

    Added 'Duplicate' calculation, which is total number of points lost form the max. Assuming all 120 picked songs get played, then the person with the lowest Duplicate number will win.

    Added 'Not Played' calculation, which shows how many songs per team haven;t been played yet. Gives a good idea on who can jump into the lead quickly.)
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • jethrojam420
    jethrojam420 Foxborough MA Posts: 1,075
    FrankieG wrote:
    -Updated Scoresheet-

    Now dynamically sorts based on score (To the right of the grey boxes)

    Added 'Duplicate' calculation, which is total number of points lost form the max. Assuming all 120 picked songs get played, then the person with the lowest Duplicate number will win.

    Added 'Not Played' calculation, which shows how many songs per team haven;t been played yet. Gives a good idea on who can jump into the lead quickly.)


    I still say you should work for google or something ;)
    8/29/00*5/2/03*7/2/03*7/3/03*7/11/03*9/28/04*5/24/06*6/28/08*5/15/10*5/17/10* 10/16/13*10/25/13* 4/28/16*4/28/16*8/5/16*8/7/16 EV 6/15/11 Brad 10/27/02
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    FrankieG wrote:
    -Updated Scoresheet-

    Now dynamically sorts based on score (To the right of the grey boxes)

    Added 'Duplicate' calculation, which is total number of points lost form the max. Assuming all 120 picked songs get played, then the person with the lowest Duplicate number will win.

    Added 'Not Played' calculation, which shows how many songs per team haven;t been played yet. Gives a good idea on who can jump into the lead quickly.)


    I still say you should work for google or something ;)

    :thumbup: :wave: Thanks!
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • jethrojam420
    jethrojam420 Foxborough MA Posts: 1,075
    FrankieG wrote:
    FrankieG wrote:
    -Updated Scoresheet-

    Now dynamically sorts based on score (To the right of the grey boxes)

    Added 'Duplicate' calculation, which is total number of points lost form the max. Assuming all 120 picked songs get played, then the person with the lowest Duplicate number will win.

    Added 'Not Played' calculation, which shows how many songs per team haven;t been played yet. Gives a good idea on who can jump into the lead quickly.)


    I still say you should work for google or something ;)

    :thumbup: :wave: Thanks!
    8-)
    8/29/00*5/2/03*7/2/03*7/3/03*7/11/03*9/28/04*5/24/06*6/28/08*5/15/10*5/17/10* 10/16/13*10/25/13* 4/28/16*4/28/16*8/5/16*8/7/16 EV 6/15/11 Brad 10/27/02
  • I feel like the leader board is like golf. The people with all their songs played are the leaders in the club house, while everyone else is still on the course. But i can guess you can't lose points in golf after the round is done :lol:
  • OMG they finally played that turd song The Fixer! I just got more points instead of losing them! Happy day.
  • CAVSTARR313
    CAVSTARR313 Posts: 8,756
    OMG they finally played that turd song The Fixer! I just got more points instead of losing them! Happy day.
    I just got done explaining to my wife why I hate you!! ;);)8-)

    nice pick
    None are more hopelessly enslaved than those who falsely believe that they are free.
    Abrn Hlls '98 - Clarkston 2 '03 - Grd Rpds '06 - Abrn Hlls '06 - Clvd '10 - PJ20 - Berlin 1+2 '12 - Wrigley '13 - Pitt '13- buff '13- Philly 1+2 '13 - Seattle '13
  • MusicDude415
    MusicDude415 Philly Burbs Posts: 171
    OMG they finally played that turd song The Fixer! I just got more points instead of losing them! Happy day.

    Right there with you. Even though it's early, was starting to get nervous.
    5/26/06 - Camden, NJ -- 10/31/09 - Phila, PA -- 10/21/13 - Phila, PA -- 10/22/13 - Phila, PA -- 04/28/16 - Phila, PA -- 04/29/16 - Phila, PA -- 09/14/22 - Camden, NJ
  • eeriepadave
    eeriepadave West Chester, PA Posts: 43,321
    OMG they finally played that turd song The Fixer! I just got more points instead of losing them! Happy day.

    and they didn't play yellow moon. thank god
    8/28/98- Camden, NJ
    10/31/09- Philly
    5/21/10- NYC
    9/2/12- Philly, PA
    7/19/13- Wrigley
    10/19/13- Brooklyn, NY
    10/21/13- Philly, PA
    10/22/13- Philly, PA
    10/27/13- Baltimore, MD
    4/28/16- Philly, PA
    4/29/16- Philly, PA
    5/1/16- NYC
    5/2/16- NYC
    9/2/18- Boston, MA
    9/4/18- Boston, MA
    9/14/22- Camden, NJ
    9/7/24- Philly, PA
    9/9/24- Philly, PA
    Tres Mts.- 3/23/11- Philly. PA
    Eddie Vedder- 6/25/11- Philly, PA
    RNDM- 3/9/16- Philly, PA
  • Caveeze wrote:
    OMG they finally played that turd song The Fixer! I just got more points instead of losing them! Happy day.
    I just got done explaining to my wife why I hate you!! ;);)8-)

    nice pick

    Haha! Amazing! I'm still laughing!
    Tonight's setlist was CRAZY!
  • eeriepadave
    eeriepadave West Chester, PA Posts: 43,321
    i'm actually doing better than i thought i was. :lol: and with Big wave being played tonight and yellow moon not that helped a little more :)
    8/28/98- Camden, NJ
    10/31/09- Philly
    5/21/10- NYC
    9/2/12- Philly, PA
    7/19/13- Wrigley
    10/19/13- Brooklyn, NY
    10/21/13- Philly, PA
    10/22/13- Philly, PA
    10/27/13- Baltimore, MD
    4/28/16- Philly, PA
    4/29/16- Philly, PA
    5/1/16- NYC
    5/2/16- NYC
    9/2/18- Boston, MA
    9/4/18- Boston, MA
    9/14/22- Camden, NJ
    9/7/24- Philly, PA
    9/9/24- Philly, PA
    Tres Mts.- 3/23/11- Philly. PA
    Eddie Vedder- 6/25/11- Philly, PA
    RNDM- 3/9/16- Philly, PA
  • vant0037
    vant0037 Posts: 6,170
    FrankieG wrote:
    -Updated Scoresheet-

    Now dynamically sorts based on score (To the right of the grey boxes)

    Added 'Duplicate' calculation, which is total number of points lost form the max. Assuming all 120 picked songs get played, then the person with the lowest Duplicate number will win.

    Added 'Not Played' calculation, which shows how many songs per team haven;t been played yet. Gives a good idea on who can jump into the lead quickly.)

    Uhhh...can you explain which "duplicate" column I should look at and what's good or bad about it? I'm trying to figure it out...but not getting it. :lol:
    1998-06-30 Minneapolis
    2003-06-16 St. Paul
    2006-06-26 St. Paul
    2007-08-05 Chicago
    2009-08-23 Chicago
    2009-08-28 San Francisco
    2010-05-01 NOLA (Jazz Fest)
    2011-07-02 EV Minneapolis
    2011-09-03 PJ20
    2011-09-04 PJ20
    2011-09-17 Winnipeg
    2012-06-26 Amsterdam
    2012-06-27 Amsterdam
    2013-07-19 Wrigley
    2013-11-21 San Diego
    2013-11-23 Los Angeles
    2013-11-24 Los Angeles
    2014-07-08 Leeds, UK
    2014-07-11 Milton Keynes, UK
    2014-10-09 Lincoln
    2014-10-19 St. Paul
    2014-10-20 Milwaukee
    2016-08-20 Wrigley 1
    2016-08-22 Wrigley 2
    2018-06-18 London 1
    2018-08-18 Wrigley 1
    2018-08-20 Wrigley 2
    2022-09-16 Nashville
    2023-08-31 St. Paul
    2023-09-02 St. Paul
    2023-09-05 Chicago 1
    2024-08-31 Wrigley 2
    2024-09-15 Fenway 1
    2024-09-27 Ohana 1
    2024-09-29 Ohana 2
    2025-05-03 NOLA (Jazz Fest)