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

1…2021232526…49

Comments

  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,749
    BN8419 wrote:
    I had not looked at the live scoring sheet until today, and I must say - that is some top notch shit.

    I'm a bit of an excel regular myself, and this document impresses.

    Kudos!

    Let the shows begin.

    It would be nice if we could get this thread stickied. Maybe in the Tour section, even. How does that happen?
    PM Kat or Sea - they might be glad to do that. :)
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    BN8419 wrote:
    I had not looked at the live scoring sheet until today, and I must say - that is some top notch shit.

    I'm a bit of an excel regular myself, and this document impresses.

    Kudos!

    Let the shows begin.

    It would be nice if we could get this thread stickied. Maybe in the Tour section, even. How does that happen?

    8-) Thanks! If you have any suggestions how to make the excel sheet better, or if you want to add some functionality yourself, just let me know and I can do it or add you so you can do it.

    To get it stickied the Mods would need to deem it worthy, which probably won't happen since it only applies to the 60 of us that are doing it.
    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
  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,749
    FrankieG wrote:
    BN8419 wrote:
    I had not looked at the live scoring sheet until today, and I must say - that is some top notch shit.

    I'm a bit of an excel regular myself, and this document impresses.

    Kudos!

    Let the shows begin.

    It would be nice if we could get this thread stickied. Maybe in the Tour section, even. How does that happen?

    8-) Thanks! If you have any suggestions how to make the excel sheet better, or if you want to add some functionality yourself, just let me know and I can do it or add you so you can do it.

    To get it stickied the Mods would need to deem it worthy, which probably won't happen since it only applies to the 60 of us that are doing it.
    That's a lot more interest than some of the threads that get stickied. ;)
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    PJ_Soul wrote:
    FrankieG wrote:
    To get it stickied the Mods would need to deem it worthy, which probably won't happen since it only applies to the 60 of us that are doing it.
    That's a lot more interest than some of the threads that get stickied. ;)

    :lol: True. A couple of them really need to go..
    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
    MayDay10 wrote:
    A song starts out with 0 Points. If it gets played, the song earns 25 points. Each time the song is played, it loses a point. So if you have "Brain of J", and it gets played in Pittsburgh, then Buffalo, then not for the rest of the tour, it will be worth 24 points.
    If you pick "Fatal" and it doesnt get played, it earns 0.
    If you have "Do The Evolution" and it gets played at each stop, it would end up with 1 point.

    I think this scenario is impossible, since now there is 25 shows on the tour. (They added the Mass show after we set this up.)
    Songs need to earn 26 points if its played once, so that if its played at all 25 shows, then it will end up with 1 point.
    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
  • eeriepadave
    eeriepadave West Chester, PA Posts: 43,349
    jlwhite1076 wrote:
    Tonight is the night, let the game begin!!!!!!!!!!!!!!!!!!!!!!!!!!

    :mrgreen: good luck everyone!
    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
  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,749
    FrankieG wrote:
    MayDay10 wrote:
    A song starts out with 0 Points. If it gets played, the song earns 25 points. Each time the song is played, it loses a point. So if you have "Brain of J", and it gets played in Pittsburgh, then Buffalo, then not for the rest of the tour, it will be worth 24 points.
    If you pick "Fatal" and it doesnt get played, it earns 0.
    If you have "Do The Evolution" and it gets played at each stop, it would end up with 1 point.

    I think this scenario is impossible, since now there is 25 shows on the tour. (They added the Mass show after we set this up.)
    Songs need to earn 26 points if its played once, so that if its played at all 25 shows, then it will end up with 1 point.
    Wow, good point. Good thing thing you noticed before we started! :)
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    PJ_Soul wrote:
    FrankieG wrote:
    MayDay10 wrote:
    A song starts out with 0 Points. If it gets played, the song earns 25 points. Each time the song is played, it loses a point. So if you have "Brain of J", and it gets played in Pittsburgh, then Buffalo, then not for the rest of the tour, it will be worth 24 points.
    If you pick "Fatal" and it doesnt get played, it earns 0.
    If you have "Do The Evolution" and it gets played at each stop, it would end up with 1 point.

    I think this scenario is impossible, since now there is 25 shows on the tour. (They added the Mass show after we set this up.)
    Songs need to earn 26 points if its played once, so that if its played at all 25 shows, then it will end up with 1 point.
    Wow, good point. Good thing thing you noticed before we started! :)

    Yeah, well now my spreadsheet has to work, so I was just double checking it... :oops: :)
    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
    Adding "Guaranteed points". Which is the amount of points you would end up with if they played the song at all remaining concerts. THis won't really matter until we get further into the tour. Took the idea from March Madness brackets where if the team you picked to win the whole thing is knocked out early there is a 'max score'.
    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
  • KM78948
    KM78948 Posts: 107
    this is it! hope none of my songs get played tonight.

    thanks to mayday, frankieg, and anyone else who helped setting all this up. great thought, and unbelievably great execution!
    '98 - washington, dc (tfc) & columbia, md
    '00 - columbia, md
    '03 - bristow, va & hershey, pa
    '06 - washington, dc
    '08 - washington, dc
    '09 - philadelphia, pa (halloween)
    '10 - bristow, va
    '13 - baltimore, md & charlottesville, va
    '15 - new york, ny (gcf)
  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,749
    KM78948 wrote:
    this is it! hope none of my songs get played tonight.

    thanks to mayday, frankieg, and anyone else who helped setting all this up. great thought, and unbelievably great execution!
    :clap:
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    PJ_Soul jumps out to an early lead :lol:
    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
  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,749
    FrankieG wrote:
    PJ_Soul jumps out to an early lead :lol:
    :fp: :fp: :lol:
    Amazing opener... hopefully Eddie got it out of his system. :lol:
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • PhillyCrownOfThorns
    PhillyCrownOfThorns Posts: 690
    Great job with live scoring! Huge last round pick with untitled for me!
    9.29.96, 8.28.98, 9.1.00, 7.5.03, 9.30.05, 6.1.06, 6.19.08, 6.20.08, 6.24.08, 10.27.09, 10.28.09, 10.30.09, 5.20.10, 9.3.11, 9.4.11, 9.2.12, 7.19.13...

    2013- Brooklyn2, Philly1, Philly2, NOLA
  • joannawilson
    joannawilson Posts: 341
    Did anyone else get as excited as me when the show started? Haha. This is a blast. I have 78 points!
  • theJawas
    theJawas Posts: 395
    Not sure who to tell, but- I was credited points for Jeremy tonight, but I think it should have been for rearviewmirror. Could make a difference later on. I'm in the Cameron conference.
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    Kurto26 wrote:
    Not sure who to tell, but- I was credited points for Jeremy tonight, but I think it should have been for rearviewmirror. Could make a difference later on. I'm in the Cameron conference.

    Thanks! Yes report errors early so they are easier to catch. Ill take a look at it. :)

    EDIT: Easy fix. all correct now!
    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
    Check your scores! Make sure the sheet is adding up correctly. I'm not gonna go through everything... Let me know if you find something strange!
    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
  • KM78948
    KM78948 Posts: 107
    FrankieG wrote:
    Kurto26 wrote:
    Not sure who to tell, but- I was credited points for Jeremy tonight, but I think it should have been for rearviewmirror. Could make a difference later on. I'm in the Cameron conference.

    Thanks! Yes report errors early so they are easier to catch. Ill take a look at it. :)

    EDIT: Easy fix. all correct now!

    just looked, i have foorseps instead of footsteps so it's not calculating. thx
    '98 - washington, dc (tfc) & columbia, md
    '00 - columbia, md
    '03 - bristow, va & hershey, pa
    '06 - washington, dc
    '08 - washington, dc
    '09 - philadelphia, pa (halloween)
    '10 - bristow, va
    '13 - baltimore, md & charlottesville, va
    '15 - new york, ny (gcf)
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    KM78948 wrote:
    FrankieG wrote:
    Kurto26 wrote:
    Not sure who to tell, but- I was credited points for Jeremy tonight, but I think it should have been for rearviewmirror. Could make a difference later on. I'm in the Cameron conference.

    Thanks! Yes report errors early so they are easier to catch. Ill take a look at it. :)

    EDIT: Easy fix. all correct now!

    just looked, i have foorseps instead of footsteps so it's not calculating. thx

    :thumbup: fixed
    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

Categories