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

1151618202149

Comments

  • PJ_Soul
    PJ_Soul Vancouver, BC Posts: 50,752
    FrankieG wrote:
    Hey Guys,

    I have been working on a google docs scoresheet. HERE is the View Only link. :)

    Let me know what you think. I put in 4 songs as 'played' on the first show to demonstrate the functionality. Mostly everything is automated with formulas except for marking the songs as 'played'. I figured that each song/show should have an individual row/column to keep it very visible to avoid confusion/double updating, etc.

    If anyone has any suggestions I can try to implement them or I have no problem allowing people editing access and you can try yourself. :)

    Has anyone been working on another scoresheet? Is this good or do we want to go in a different direction?

    -Frank
    Whoa, that is awesome Frank! I can't see why that doesn't work just fine.... Although I notice that up near the top there a song was played 4 times but the score doesn't seem to include the 4th point (but maybe you just haven't entered the formulas beyond the third show column yet). Anyway, fucking awesome - thanks for putting that together! :thumbup:
    With all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata
  • eeriepadave
    eeriepadave West Chester, PA Posts: 43,360
    FrankieG wrote:
    What do you suggest to make it look pretty?

    Some fins to lower wind resistance. And a racing stripe should make it pretty sharp....

    :lol: nice simpsons reference
    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
  • ragejoe
    ragejoe Agawam Mass Posts: 1,419
    I have to admit when I first started reading the thread I thought this was going to be ridiculous .. and im an ADDICTED fantasy football player... But I have to say, this is set up really well!!!! Thats awesome, thanks for whoever had a hand in creating this... Im a little late to the party I see but,

    CAN YOU PUT ME DOWN AS A RESERVE?? I WOULD LOVE TO PLAY if there was a spot for me.

    Thanks
    1998 Tour- Hartford 9/13
    2000 Tour- Saratoga 8/27 Boston 8/29, 8/30
    2003 Tour- Albany 4/29 Boston 7/2,7/3,7/11 Philadelphia 7/5,7/6 MSG 7/8,7/9
    2004 Tour-
    Boston 9/28,9/29
    2006 Tour-
    Albany 5/12 Hartford 5/13 Boston 5/24,5/25
    2008 Tour-
    MSG 6/24,6/25 Hartford 6/27 Boston 6/28,6/30 Eddie- Boston 8/1
    2009 Tour-
    Eddie- Albany 6/9 Philly Spectrum- 10/30, 10/31
    2010 Tour-
    Hartford 5/15 MSG 5/20,5/21
    2011 Tour-
    Eddie- Hartford 6/18
    2013 Tour- Worcester,MA 10/15,10/16 Hartford 10/25
    2016 Tour- MSG 5/1,5/2 FENWAY 8/5,8/7
    2018 Tour- Fenway 9/2, 9/4 (My 40th show)!
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    PJ_Soul wrote:
    FrankieG wrote:
    Hey Guys,

    I have been working on a google docs scoresheet. HERE is the View Only link. :)

    Let me know what you think. I put in 4 songs as 'played' on the first show to demonstrate the functionality. Mostly everything is automated with formulas except for marking the songs as 'played'. I figured that each song/show should have an individual row/column to keep it very visible to avoid confusion/double updating, etc.

    If anyone has any suggestions I can try to implement them or I have no problem allowing people editing access and you can try yourself. :)

    Has anyone been working on another scoresheet? Is this good or do we want to go in a different direction?

    -Frank

    Whoa, that is awesome Frank! I can't see why that doesn't work just fine.... Although I notice that up near the top there a song was played 4 times but the score doesn't seem to include the 4th point (but maybe you just haven't entered the formulas beyond the third show column yet). Anyway, fucking awesome - thanks for putting that together! :thumbup:

    I'll have to take a look at it later tonight/tomorrow. I thought it was good to go, so this is weird.. I know it looks awesome, but I'm not promising that it will be perfect. I found and corrected several bugs, but there maybe more that I haen't found yet. I would definitely check your score periodically to make sure its calculating correctly.
    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
  • ragejoe wrote:
    I have to admit when I first started reading the thread I thought this was going to be ridiculous .. and im an ADDICTED fantasy football player... But I have to say, this is set up really well!!!! Thats awesome, thanks for whoever had a hand in creating this... Im a little late to the party I see but,

    CAN YOU PUT ME DOWN AS A RESERVE?? I WOULD LOVE TO PLAY if there was a spot for me.

    Thanks

    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    ragejoe wrote:
    I have to admit when I first started reading the thread I thought this was going to be ridiculous .. and im an ADDICTED fantasy football player... But I have to say, this is set up really well!!!! Thats awesome, thanks for whoever had a hand in creating this... Im a little late to the party I see but,

    CAN YOU PUT ME DOWN AS A RESERVE?? I WOULD LOVE TO PLAY if there was a spot for me.

    Thanks

    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?
    Yeah! Do it! One of you guys just needs to volunteer to collect everyone's address and bootleg pledges. Then decide the draft order and start the draft chain email. I can add you to the scoresheet google doc after you finish the draft.
    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:
    What do you suggest to make it look pretty?

    Some fins to lower wind resistance. And a racing stripe should make it pretty sharp....

    :lol: nice simpsons reference
    :D :thumbup:
    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
  • rr165892
    rr165892 Posts: 5,697
    BN8419 wrote:
    PJ_Soul wrote:
    FrankieG wrote:
    Can someone post up the cameron conference rosters?
    Mayday, if you could post in the OP that would be awesome. :)

    Still no news on what goody everyone put up for it.... BN8419? :)

    CAMERON conference prize pledges -

    Mjservs806 – a boot or two

    PJSoul - a choice of: PJ20 blue-ray (regular version - new), Philly 3 or 4 video boot DVD, or Deranged Diction "Life Support/No Art No Cowboys No Rules" double CD.

    Kurto26 - a bootleg digital download or equivalent

    PJ23 - a bootleg choice from the goods section.

    Gern Blansten - either a bootleg or maybe a couple old singles and some other stuff.

    PhillyCrownofThorns – bootleg download

    EvilClosetMonkey - an official bootleg (TBA) from 2010 - not sure which one.

    EeriePaDave - bootleg of choice

    Neutron Baum - the Pearl Jam keychain from goods.

    rr165892 - let me know what you need for prize fund

    MusicDude415 - Choice of boot from shop

    BN8419 – Grand Rapids 2004 bootleg DVD copy (assuming I can find it)
    Ill pledge a TSHIRT FROM GOODS .
  • Hey Guys, I'm in. You have me in at #10 as rr165892's bro. Set me up.





    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?[/quote]
  • FrankieG wrote:
    ragejoe wrote:
    I have to admit when I first started reading the thread I thought this was going to be ridiculous .. and im an ADDICTED fantasy football player... But I have to say, this is set up really well!!!! Thats awesome, thanks for whoever had a hand in creating this... Im a little late to the party I see but,

    CAN YOU PUT ME DOWN AS A RESERVE?? I WOULD LOVE TO PLAY if there was a spot for me.

    Thanks

    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?
    Yeah! Do it! One of you guys just needs to volunteer to collect everyone's address and bootleg pledges. Then decide the draft order and start the draft chain email. I can add you to the scoresheet google doc after you finish the draft.

    Alright, I can volunteer for that. Does anyone object to using that 1-12 listed above as the draft order?
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    FrankieG wrote:
    PJ_Soul wrote:
    FrankieG wrote:
    Hey Guys,

    I have been working on a google docs scoresheet. HERE is the View Only link. :)

    Let me know what you think. I put in 4 songs as 'played' on the first show to demonstrate the functionality. Mostly everything is automated with formulas except for marking the songs as 'played'. I figured that each song/show should have an individual row/column to keep it very visible to avoid confusion/double updating, etc.

    If anyone has any suggestions I can try to implement them or I have no problem allowing people editing access and you can try yourself. :)

    Has anyone been working on another scoresheet? Is this good or do we want to go in a different direction?

    -Frank

    Whoa, that is awesome Frank! I can't see why that doesn't work just fine.... Although I notice that up near the top there a song was played 4 times but the score doesn't seem to include the 4th point (but maybe you just haven't entered the formulas beyond the third show column yet). Anyway, fucking awesome - thanks for putting that together! :thumbup:

    I'll have to take a look at it later tonight/tomorrow. I thought it was good to go, so this is weird.. I know it looks awesome, but I'm not promising that it will be perfect. I found and corrected several bugs, but there maybe more that I haen't found yet. I would definitely check your score periodically to make sure its calculating correctly.

    You were right, the formula for adding up the number of times played was only extended to column L. Fixed 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
  • on2legs
    on2legs Posts: 16,013
    Besides prizes for the winners how about a punishment for whoever comes in last?

    Like you have to wear a pair of the PJ board shorts to the next concert?
    1996: Randall's Island 2  1998: East Rutherford | MSG 1 & 2  2000: Cincinnati | Columbus | Jones Beach 1, 2, & 3 | Boston 1 | Camden 1 & 2 2003: Philadelphia | Uniondale | MSG 1 & 2 | Holmdel  2005: Atlantic City 1  2006: Camden 1 | East Rutherford 1 & 2 2008: Camden 1 & 2 | MSG 1 & 2 (#25) | Newark (EV)  2009: Philadelphia 1, 2 & 4  2010: Newark | MSG 1 & 2  2011: Toronto 1  2013: Wrigley Field | Brooklyn 2 | Philadelphia 1 & 2 | Baltimore  2015: Central Park  2016: Philadelphia 1 & 2 | MSG 1 & 2 | Fenway Park 2 | MSG (TOTD)  2017: Brooklyn (RnR HOF)  2020: MSG | Asbury Park  2021: Asbury Park  2022: MSG | Camden | Nashville  2024: MSG 1 & 2 (#50) | Philadelphia 1 & 2 | Baltimore  2025: Raleigh


  • eeriepadave
    eeriepadave West Chester, PA Posts: 43,360
    Jorock11 wrote:
    Hey Guys, I'm in. You have me in at #10 as rr165892's bro. Set me up.





    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?
    [/quote]

    I thought the guy who set ours up said he could do the other conference as well, BN8149.
    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
  • MayDay10
    MayDay10 Posts: 11,861
    the 1st page of the thread has a random order generator. You just type the names in and it will make a random order...


    Spoke to my friend Gabe and he is 100% down.
  • Jorock11 wrote:
    Hey Guys, I'm in. You have me in at #10 as rr165892's bro. Set me up.





    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?

    I thought the guy who set ours up said he could do the other conference as well, BN8149.

    Sure, I just thought I'd get it rolling, so far I am waiting for 5 replies with email, and prize data. I'll follow up with those people again. FrankieG offered to add us to the score sheet.
  • BN8419
    BN8419 Posts: 290
    Jorock11 wrote:
    Hey Guys, I'm in. You have me in at #10 as rr165892's bro. Set me up.





    This should bring us to 12 on the reserves, a new conference?
    RESERVES
    1. DirtyFrankAndBeans
    2. Nuzzer1
    3. 8bitj
    4. Nixon In Detroit
    5. Gibson
    6. lejarmap138
    7. Save Who
    8. Mayday10 (friend Gabe, who isnt active in MP)
    9. jened10
    10. rr165892's bro
    11. Given2Fly-Fish
    12. ragejoe

    Am I right?

    I thought the guy who set ours up said he could do the other conference as well, BN8149.

    Sure, I just thought I'd get it rolling, so far I am waiting for 5 replies with email, and prize data. I'll follow up with those people again. FrankieG offered to add us to the score sheet.

    YES, I could, but really the hard part is already done it sounds like, just making contact, confirming all 12 players, and documenting the prize pledges. You will probably end up a couple short, based on the last experience. The only other step is creating the google doc to track the picks.

    Lejarmap138 - You can keep it moving and I'll be your advisor, how about that? ;) When you're ready, I'll zero out the google doc and share it with you so you have the format all set.
  • jethrojam420
    jethrojam420 Foxborough MA Posts: 1,075
    on2legs wrote:
    Besides prizes for the winners how about a punishment for whoever comes in last?

    Like you have to wear a pair of the PJ board shorts to the next concert?


    Or a Bieber tattoo that says YOLO Swag 2013??
    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
    on2legs wrote:
    Besides prizes for the winners how about a punishment for whoever comes in last?

    Like you have to wear a pair of the PJ board shorts to the next concert?


    Or a Bieber tattoo that says YOLO Swag 2013??

    :lol: I saw that fantasy football league too. That was the best/worst tatto i have ever seen. :lol::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
  • Gibson
    Gibson Chicago Posts: 2,671
    Where are we with this? I'm eager to find out what's next!!
    1998: Barrie  2000: Toronto  2005: Kitchener, London, Hamilton, Toronto  2006: Toronto 1&2, Paris, Milan, Torino, Pistoia  2009: Calgary, Vancouver  2011: Canada  2013: London, Wrigley, Philly 1&2  2014: St. Louis, ACL 1, Detroit  2016: Lexington, Quebec, Ottawa, Toronto 1&2, Fenway 1&2, Wrigley 1&2  2017: EV - Louisville  2018: London 1&2, Milan, Padova, Rome, Prague, Krakow, Berlin, Wrigley 1&2, Fenway 1&2  2020: Toronto, Ottawa, Hamilton  2021: London 1&2  2022: Hamilton, Toronto  2023: Chicago 1&2, Noblesville  2024: Seattle 1&2, Noblesville, Wrigley 1&2

  • on2legs
    on2legs Posts: 16,013
    on2legs wrote:
    Besides prizes for the winners how about a punishment for whoever comes in last?

    Like you have to wear a pair of the PJ board shorts to the next concert?


    Or a Bieber tattoo that says YOLO Swag 2013??

    Howabout a Creed tattoo for the loser?
    1996: Randall's Island 2  1998: East Rutherford | MSG 1 & 2  2000: Cincinnati | Columbus | Jones Beach 1, 2, & 3 | Boston 1 | Camden 1 & 2 2003: Philadelphia | Uniondale | MSG 1 & 2 | Holmdel  2005: Atlantic City 1  2006: Camden 1 | East Rutherford 1 & 2 2008: Camden 1 & 2 | MSG 1 & 2 (#25) | Newark (EV)  2009: Philadelphia 1, 2 & 4  2010: Newark | MSG 1 & 2  2011: Toronto 1  2013: Wrigley Field | Brooklyn 2 | Philadelphia 1 & 2 | Baltimore  2015: Central Park  2016: Philadelphia 1 & 2 | MSG 1 & 2 | Fenway Park 2 | MSG (TOTD)  2017: Brooklyn (RnR HOF)  2020: MSG | Asbury Park  2021: Asbury Park  2022: MSG | Camden | Nashville  2024: MSG 1 & 2 (#50) | Philadelphia 1 & 2 | Baltimore  2025: Raleigh