here is some data for ya that i quickly whipped up
Total Songs Played 16,150
My Total Songs 275
My % 1.7%
so they have played 16,150 songs over the last 20 years and i've seen 275 of those. i'm suprised my % is as high as it is.
here is some data for ten
Total Plays % of Total Plays This Album % of Total Plays All Songs My Performances % of Performances Heard
Ten
Once 274 7.6% 1.7% 3 1.1%
Even Flow 661 18.3% 4.1% 7 1.1%
Alive 581 16.1% 3.6% 7 1.2%
Why Go 323 9.0% 2.0% 4 1.2%
Black 440 12.2% 2.7% 4 0.9%
Jeremy 422 11.7% 2.6% 4 0.9%
Oceans 68 1.9% 0.4% 1 1.5%
Porch 418 11.6% 2.6% 4 1.0%
Garden 127 3.5% 0.8% 1 0.8%
Deep 172 4.8% 1.1% 1 0.6%
Release 121 3.4% 0.7% 2 1.7%
3,607 100.0% 22.3% 38 1.1%
doesn't paste pretty....but Once has been played 274 times. Once makes up 7.6% of all ten performances or 1.7% of all performances. I've seen it 3 times or 1.1% of the times played.
ok finally figured out the numbers that made me want to fill out this damn thing.
i'm a lightweight i've been to 5 pj shows.
Total songs heard live 137 (tags, covers, studio)
TEN 9 out of 11
VS. 8 out of 12
VITALOGY 5 out of 14
NO CODE 3 out of 13
YIELD 9 out of 13
BINAURAL 9 out of 13
RIOT ACT 3 out of 15
LOST DOGS 3 out of 30
PEARL JAM 8 out of 13
BACKSPACER 5 out of 11
*~Pearl Jam will be blasted from speakers until morale improves~*
I just made one! Actually, still working on it. So far, I've got the tally (455 TOTAL songs heard, 127 unique songs). Not including partial tags.
Now, I'm working on expanding it to show which songs were played in which order at each show, so that I can see those rare times when they opened up with Even Flow or closed with Indifference, etc. Also, it will be cool to see trends like, I hadn't heard Hail,Hail since 1998 until this tour, and I heard it twice in three nights.
1st Column: Song
2nd: Album
3rd: Show (X's for songs you heard that night)
4th: Number of Times that song had been played up untill that night
Repeat 3rd and 4th columnbs for as many shows as you have.
Last column: Number of times you have seen that song total.
In this last column, I color code the numbers. 0 times = red. 1 = orange. 2 = yellow. 3 = blue. 4 = green
2006/05/25 - Boston
2008/06/30 - Mansfield
2009/10/31 - Philadelphia
2010/05/17 - Boston
2011/06/15 - Providence (Eddie Vedder)
2012/09/02 - Made in America
2013/10/17 - Worcester
2013/10/25 - Hartford
2015/09/26 - Global Citizen Festival
2016/08/05 - Fenway
2016/08/07 - Fenway
I love that i''m not alone in this. Not only do I have a personal spreadsheet. But I have an 2009 tour stats, Philly 2009 and 2010 tour stats. Along with a few others...i've had to keep it to a minimum cause it could get outta hand!
Love being a PJ geek!
Toronto - 2009
Hartford - 2010
Ed Solo - Hartford - 2011
Toronto X 2, Ottawa & Hamilton - 2011
Ed Solo - Jacksonville - 2012
London, Pittsburgh & Buffalo - 2013
No shows in 2014 :-(
i just made one after the msg's.
i used microsoft excel. it was nice cuz it allows you to add notes to each block. i used it to put how many times ive seen that song.
7 shows
99 different songs heard
5 different venues
3 different states
out of the 99 songs ive heard 24 have been covers or bsides
binaural and no code have avoided me the most.
i just made one after the msg's.
i used microsoft excel. it was nice cuz it allows you to add notes to each block. i used it to put how many times ive seen that song.
7 shows
99 different songs heard
5 different venues
3 different states
out of the 99 songs ive heard 24 have been covers or bsides
binaural and no code have avoided me the most.
Yeah I like the notes/comments additions. That way you can add any special info or tags etc.
Toronto - 2009
Hartford - 2010
Ed Solo - Hartford - 2011
Toronto X 2, Ottawa & Hamilton - 2011
Ed Solo - Jacksonville - 2012
London, Pittsburgh & Buffalo - 2013
No shows in 2014 :-(
yeah i just added another column for tags. i like the little red thing in the corner. it makes it easy for me to see what songs ive seen. it didnt take me too long to put it all together and im not that good with excel.
Comments
have to check it out tongiht
Total Songs Played 16,150
My Total Songs 275
My % 1.7%
so they have played 16,150 songs over the last 20 years and i've seen 275 of those. i'm suprised my % is as high as it is.
here is some data for ten
Total Plays % of Total Plays This Album % of Total Plays All Songs My Performances % of Performances Heard
Ten
Once 274 7.6% 1.7% 3 1.1%
Even Flow 661 18.3% 4.1% 7 1.1%
Alive 581 16.1% 3.6% 7 1.2%
Why Go 323 9.0% 2.0% 4 1.2%
Black 440 12.2% 2.7% 4 0.9%
Jeremy 422 11.7% 2.6% 4 0.9%
Oceans 68 1.9% 0.4% 1 1.5%
Porch 418 11.6% 2.6% 4 1.0%
Garden 127 3.5% 0.8% 1 0.8%
Deep 172 4.8% 1.1% 1 0.6%
Release 121 3.4% 0.7% 2 1.7%
3,607 100.0% 22.3% 38 1.1%
doesn't paste pretty....but Once has been played 274 times. Once makes up 7.6% of all ten performances or 1.7% of all performances. I've seen it 3 times or 1.1% of the times played.
best formula ever is sumif.
+1
8/15/92, 9/28/96, 8/28/98, 8/29/98, 9/18/98, 8/3/00, 8/9/00, 8/10/00, 8/23/00, 8/25/00, 9/1/00, 9/2/00, 4/28/03, 6/18/03, 7/5/03, 7/6/03, 10/1/04, 10/3/05, 6/19/08, 10/27/09, 10/31/09, 5/21/10, 9/3/11, 9/4/11, 10/21/13
More to Come....
why did they take it down?
i guess it would be better to ask on their board
i'm a lightweight i've been to 5 pj shows.
Total songs heard live 137 (tags, covers, studio)
TEN 9 out of 11
VS. 8 out of 12
VITALOGY 5 out of 14
NO CODE 3 out of 13
YIELD 9 out of 13
BINAURAL 9 out of 13
RIOT ACT 3 out of 15
LOST DOGS 3 out of 30
PEARL JAM 8 out of 13
BACKSPACER 5 out of 11
Now, I'm working on expanding it to show which songs were played in which order at each show, so that I can see those rare times when they opened up with Even Flow or closed with Indifference, etc. Also, it will be cool to see trends like, I hadn't heard Hail,Hail since 1998 until this tour, and I heard it twice in three nights.
1st Column: Song
2nd: Album
3rd: Show (X's for songs you heard that night)
4th: Number of Times that song had been played up untill that night
Repeat 3rd and 4th columnbs for as many shows as you have.
Last column: Number of times you have seen that song total.
In this last column, I color code the numbers. 0 times = red. 1 = orange. 2 = yellow. 3 = blue. 4 = green
2008/06/30 - Mansfield
2009/10/31 - Philadelphia
2010/05/17 - Boston
2011/06/15 - Providence (Eddie Vedder)
2012/09/02 - Made in America
2013/10/17 - Worcester
2013/10/25 - Hartford
2015/09/26 - Global Citizen Festival
2016/08/05 - Fenway
2016/08/07 - Fenway
Love being a PJ geek!
Hartford - 2010
Ed Solo - Hartford - 2011
Toronto X 2, Ottawa & Hamilton - 2011
Ed Solo - Jacksonville - 2012
London, Pittsburgh & Buffalo - 2013
No shows in 2014 :-(
i used microsoft excel. it was nice cuz it allows you to add notes to each block. i used it to put how many times ive seen that song.
7 shows
99 different songs heard
5 different venues
3 different states
out of the 99 songs ive heard 24 have been covers or bsides
binaural and no code have avoided me the most.
4/26/03 - pittsburgh
4/28/03 - philly
7/05/03 - camden
7/12/03 - hershey
5/28/06 - camden
5/20/10 - msg
5/21/10 - msg
6/25/11 - upper darby - EV
Yeah I like the notes/comments additions. That way you can add any special info or tags etc.
Hartford - 2010
Ed Solo - Hartford - 2011
Toronto X 2, Ottawa & Hamilton - 2011
Ed Solo - Jacksonville - 2012
London, Pittsburgh & Buffalo - 2013
No shows in 2014 :-(
4/26/03 - pittsburgh
4/28/03 - philly
7/05/03 - camden
7/12/03 - hershey
5/28/06 - camden
5/20/10 - msg
5/21/10 - msg
6/25/11 - upper darby - EV
You add your show to your profile, and it figures out all the stats for you.
TSIS used to have one..... then it was no more. :(