Anyone Want to do "Fantasy League" For the Tour?
Comments
-
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?
-FrankWith all its sham, drudgery, and broken dreams, it is still a beautiful world. Be careful. Strive to be happy. ~ Desiderata0 -
jethrojam420 wrote:FrankieG wrote:What do you suggest to make it look pretty?
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, PATres Mts.- 3/23/11- Philly. PA
Eddie Vedder- 6/25/11- Philly, PA
RNDM- 3/9/16- Philly, PA0 -
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.
Thanks1998 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)!0 -
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/nk0s70 -
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?0 -
lejarmap138 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?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/nk0s70 -
eeriepadave wrote:jethrojam420 wrote:FrankieG wrote:What do you suggest to make it look pretty?
nice simpsons reference
: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/020 -
BN8419 wrote:PJ_Soul wrote:FrankieG wrote:Can someone post up the cameron conference rosters?
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)0 -
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]0 -
FrankieG wrote:lejarmap138 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?
Alright, I can volunteer for that. Does anyone object to using that 1-12 listed above as the draft order?0 -
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/nk0s70 -
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: Raleigh0 -
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.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, PATres Mts.- 3/23/11- Philly. PA
Eddie Vedder- 6/25/11- Philly, PA
RNDM- 3/9/16- Philly, PA0 -
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.0 -
eeriepadave wrote: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.0 -
lejarmap138 wrote:eeriepadave wrote: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.
0 -
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/020 -
jethrojam420 wrote: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??I saw that fantasy football league too. That was the best/worst tatto i have ever seen.
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/nk0s70 -
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&20
-
jethrojam420 wrote: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: Raleigh0
Categories
- All Categories
- 148.9K Pearl Jam's Music and Activism
- 110.1K The Porch
- 274 Vitalogy
- 35.1K Given To Fly (live)
- 3.5K Words and Music...Communication
- 39.2K Flea Market
- 39.2K Lost Dogs
- 58.7K Not Pearl Jam's Music
- 10.6K Musicians and Gearheads
- 29.1K Other Music
- 17.8K Poetry, Prose, Music & Art
- 1.1K The Art Wall
- 56.8K Non-Pearl Jam Discussion
- 22.2K A Moving Train
- 31.7K All Encompassing Trip
- 2.9K Technical Stuff and Help