Home› The Porch

pj spreadsheet

realmgeorgerealmgeorge Posts: 301
edited May 2010 in The Porch
alright fellow nerds.... anyone ever make a spreadsheet to list songs you have and haven't heard live??? care to share?
and love, what a different life had I not had this love with you.
Post edited by Unknown User on
«134

Comments

  • AmentsChickAmentsChick Posts: 6,969
    I personally haven't...but know a couple people who do. Hmm...guess that's really not that relevant. oh well...
    This is the greatest band in the world -- Ben Harper

  • Alpine BoundAlpine Bound Posts: 1,809
    realmgeorge wrote:
    alright fellow nerds.... anyone ever make a spreadsheet to list songs you have and haven't heard live??? care to share?


    yes and then deleted it about a year later when I realized how big a geek I was for still having it :lol:
  • SVRDhand13SVRDhand13 Posts: 26,148
    I have one. But I will never admit that to anyone I know in person :D .
    severed hand thirteen
    2006: Gorge 7/23 2008: Hartford 6/27 Beacon 7/1 2009: Spectrum 10/30-31
    2010: Newark 5/18 MSG 5/20-21 2011: PJ20 9/3-4 2012: Made In America 9/2
    2013: Brooklyn 10/18-19 Philly 10/21-22 Hartford 10/25 2014: ACL10/12
    2015: NYC 9/23 2016: Tampa 4/11 Philly 4/28-29 MSG 5/1-2 Fenway 8/5+8/7
    2017: RRHoF 4/7   2018: Fenway 9/2+9/4   2021: Sea Hear Now 9/18 
    2022: MSG 9/11  2024: MSG 9/3-4 Philly 9/7+9/9 Fenway 9/15+9/17
  • FrankieGFrankieG Posts: 9,100
    I got one. Used excel. Listed all songs by album in column A. Listed concerts across row A. Put numbers for which song was played in what order for which concert. Got a tally of the total number of times i heard each song live. listed covers and non-album songs under Backspacer. Takes a decent amount of time, but it came out good. :D
    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
  • AmentsChickAmentsChick Posts: 6,969
    FrankieG wrote:
    I got one. Used excel. Listed all songs by album in column A. Listed concerts across row A. Put numbers for which song was played in what order for which concert. Got a tally of the total number of times i heard each song live. listed covers and non-album songs under Backspacer. Takes a decent amount of time, but it came out good. :D
    :roll: :lol:;)
    This is the greatest band in the world -- Ben Harper

  • washedinblack91washedinblack91 Posts: 3,078
    if i knew how to i would. and i wouldn't be ashamed to say it ;) we're all nerds here, there's no shame here! :D
    PJ: 9/29/04, 5/12/06, 5/13/06, 6/22/08, 6/24/08, 6/25/08, 6/27/08, 6/30/08, 10/30/09, 10/31/09, 5/18/10, 5/20/10, 5/21/10, 9/3/11, 9/4/11, 10/18/13, 8/7/16
    eV: 8/4/08, 8/5/08, 6/21/11
    SG: 10/4/08<-- MET STONE!!!
  • TheDecline13TheDecline13 Posts: 990
    i have one but im not sharing :P
    Tour with fucking NOFX
  • jfconnorjrjfconnorjr Posts: 518
    Send me a PM and I will send you my template.... I am a nerd
  • FrankieGFrankieG Posts: 9,100
    AmentsChick wrote:
    :roll: :lol:;)
    washedinblack91 wrote:
    and i wouldn't be ashamed to say it ;)
    jfconnorjr wrote:
    I am a nerd
    ;)8-):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
  • realmgeorgerealmgeorge Posts: 301
    pm sent. thanks!
    and love, what a different life had I not had this love with you.
  • demetriosdemetrios Posts: 91,351
    I have a huge PJ xls Audio/Video Spreadsheet but it's totally NFT! ;)
    I'll start one up for the live song spreadsheet soon.
  • jimbojones1138jimbojones1138 Posts: 3,640
    are we talking about EVERY pj song, or just album songs?
    it's largely due to eddie that i liked to jump off of things as a child...
  • demetriosdemetrios Posts: 91,351
    jimbojones1138 wrote:
    are we talking about EVERY pj song, or just album songs?

    Gotta be album songs only, hopefully! Way too many cover songs to list down! http://www.pearljam.com/music/songs
  • jimbojones1138jimbojones1138 Posts: 3,640
    demetrios wrote:
    jimbojones1138 wrote:
    are we talking about EVERY pj song, or just album songs?

    Gotta be album songs only, hopefully! Way too many cover songs to list down! http://www.pearljam.com/music/songs


    wow i wasnt even thinking covers... but lost dogs, rarities, gems, fanclub singles...bsides
    it's largely due to eddie that i liked to jump off of things as a child...
  • gndcd402gndcd402 Posts: 2,561
    washedinblack91 wrote:
    if i knew how to i would. and i wouldn't be ashamed to say it ;) we're all nerds here, there's no shame here! :D
    where have u been?!
  • As the Earth to the SunAs the Earth to the Sun Posts: 241
    wow, just the other day I was thinking about doing this, not that my number of shows would take terribly long. you guys read my mind. i heart nerds, especially pj nerds! :ugeek:
    Pepsi Center - Apr 1 '03, Jul 2-3 '06 | Grant Park - Aug 05 '07 | E Center - Sep 28 '09 | Wachovia Spectrum Arena - Oct 27 '09 | Sprint Center May 3 '10 | Scottrade Center May 4 '10 | Alpine Valley - Sep 3-4, '11 | Wrigley Field - July 19, '13 | Pepsi Center Oct 22, '14
  • washedinblack91washedinblack91 Posts: 3,078
    gndcd402 wrote:
    washedinblack91 wrote:
    if i knew how to i would. and i wouldn't be ashamed to say it ;) we're all nerds here, there's no shame here! :D
    where have u been?!
    arouuuuuund
    PJ: 9/29/04, 5/12/06, 5/13/06, 6/22/08, 6/24/08, 6/25/08, 6/27/08, 6/30/08, 10/30/09, 10/31/09, 5/18/10, 5/20/10, 5/21/10, 9/3/11, 9/4/11, 10/18/13, 8/7/16
    eV: 8/4/08, 8/5/08, 6/21/11
    SG: 10/4/08<-- MET STONE!!!
  • WM31482WM31482 Posts: 563
    also guilty, although i do feel much better about it after reading this thread-

    even though no one else has confessed that theirs links to the page on pearljam.com with the song lyrics... :oops:
  • pjgirl9pjgirl9 Posts: 30
    I don't have an actual spreadsheet that I keep, but I am sort of guilty of this. I went to six shows last year and after having to constantly tell my friends how different all the shows were, I figured I'd see just how many different/duplicate songs I heard while I was on tour. I think it was a little over 80 different songs (I threw the paper away so I don't remember the exact count). So I'm guess I'm a little bit of a pj nerd... ;)
  • bootlegger10bootlegger10 Posts: 15,838
    I've got a decent spreadsheet. The first tab has all songs (PJ and covers) I've heard live in column A, and then columns B through AQ list the shows. I put a "1" in the row with the song name if I heard it at the show. I'm sure there are better ways to do it, but then I can total up in the last column the total amount of times I've heard each song and transfer that to the songs heard summary tab. I've 1,172 songs live and 173 unique songs.

    I then have a tab tracking studio songs net yet heard and realistic Lost Dogs songs.

    I am most proud (or embarrassed) of the tab where I can instantly find the number of repeated songs between any two of 42 shows I've been to. The next tab then summarizes by show the average number of repeats between a given show and all other shows to see which show was most unique (not really scientific though).
    I'm an accountant who is posting at 12:55 am because I'm still at work. Ladies, you probably guessed right, I'm available.
  • FiveB247xFiveB247x Posts: 2,330
    I won't share it for viewing, but in mine, I even color code each song by album (for example Yield is White with Red font where as Pearl Jam is Yellow with Blue font) and also keep track of the number of times I've seen each song as well. Tab 1 is all songs seen live or not seen live and Tab 2 is concerts I've attended w/dates and entire setlists.
    CONservative governMENt

    Our government is the potent, the omnipresent teacher. For good or for ill, it teaches the whole people by its example. Crime is contagious. If the government becomes a law-breaker, it breeds contempt for law; it invites every man to become a law unto himself; it invites anarchy. - Louis Brandeis
  • AmentsChickAmentsChick Posts: 6,969
    FiveB247x wrote:
    I won't share it for viewing, but in mine, I even color code each song by album (for example Yield is White with Red font where as Pearl Jam is Yellow with Blue font) and also keep track of the number of times I've seen each song as well. Tab 1 is all songs seen live or not seen live and Tab 2 is concerts I've attended w/dates and entire setlists.
    :lol::o
    This is the greatest band in the world -- Ben Harper

  • MozzyMozzy Posts: 154
    FrankieG wrote:
    I got one. Used excel. Listed all songs by album in column A. Listed concerts across row A. Put numbers for which song was played in what order for which concert. Got a tally of the total number of times i heard each song live. listed covers and non-album songs under Backspacer. Takes a decent amount of time, but it came out good. :D
    I've got one that is very similar. Where I start to fall apart at, is what counts as a song being preformed by PJ, does it require all the band members to be there? At a few shows I've been to there's only been one or two members playing the song for different reasons. The agony. I want it to count, but all my friends think I'm crazy.
  • smg97791smg97791 Posts: 151
    I have a spreadsheet for which 2000/2003 boots that I own/don't own.
  • WM31482WM31482 Posts: 563
    Mozzy wrote:
    FrankieG wrote:
    I got one. Used excel. Listed all songs by album in column A. Listed concerts across row A. Put numbers for which song was played in what order for which concert. Got a tally of the total number of times i heard each song live. listed covers and non-album songs under Backspacer. Takes a decent amount of time, but it came out good. :D
    I've got one that is very similar. Where I start to fall apart at, is what counts as a song being preformed by PJ, does it require all the band members to be there? At a few shows I've been to there's only been one or two members playing the song for different reasons. The agony. I want it to count, but all my friends think I'm crazy.


    it's your spreadsheet- it counts!!
  • msjpearsonmsjpearson Posts: 97
    Is there a website that tracks concert stats? I'm also a DMB fan, and there is a fan site (www.antsmarching.org) that allows you to input the shows you have been to, and it tells you how many times you have seen each song, which songs you have seen broken down by album, guests seen, rarest songs, rarest shows, etc. It really is an interesting feature. Anything similar in the PJ community?
  • jervin007jervin007 Posts: 3,182
    I have officially joined the rank of the pearl jam dork community. That's right, I have created a spreadsheet of the shows I have attended. Only 8 shows, but hopefully it will be 10 by the end of may. Actually really cool to see everything I have seen live. The Hartford 08 show was full of firsts for me! Such a great show!

    I haven't seen a site that does your pearl jam stats for you. I know what you mean though because I have used something similar for the Phish shows I have attended.
    PJ:
    2003 Mansfield: July 2
    2004 Boston: Sept 28 & 29
    2005 Montreal: Sept 15
    2006 Boston: May 24 & 25
    2008 Hartford: June 27, Mansfield: June 28,
    2010 Boston: May 17
    2013 Worcester: Oct 15, Hartford: Oct 25,
    2016 Hampton: April 18, Raleigh: April 20 (cancelled), Columbia: April 21. Quebec: May 5. Boston (Fenway): August 7

    EV Solo: Boston 8/2/08, Boston 6/16/11
  • Given2Fly-FishGiven2Fly-Fish Posts: 825
    realmgeorge wrote:
    alright fellow nerds.... anyone ever make a spreadsheet to list songs you have and haven't heard live??? care to share?

    I was never great at excel formula's, so I have a word doc but I have not updated it in awhile.
    :D
  • choopchoop Posts: 1,060
    we need a spreadsheet like this..........

    http://spreadsheets.google.com/pub?key= ... 6EQ&gid=11
    "If I should ever die, God forbid, let this be my epitaph: The only proof he needed for the existence of God was music." KV Jr.
  • vedder_soupvedder_soup Posts: 5,861
    i have one, but it needs updating.

    i can tell you that Wash, opening at Mansfield 2 in 2008 was the 100th different song that i saw them play live :ugeek:
    2003 - Sydney x3,
    2006 - Reading Festival,
    2007 - Katowice, London, Nijmegen, Rock Werchter,
    2008 - MSG x2, Hartford, Mansfield x2, Beacon Theater,
    2009 - Melbourne, Sydney,
    2010 - I watched it go to fire!
    2011 - EV Brisbane x3, Newcastle, Sydney x3,
    2012 - Manchester x 2, Amsterdam x2, Prague, Berlin x2, Stockholm, Oslo, Copenhagen,
    2014 - Sydney, EV Sydney x3

    I wave to all my Friends... Yeah!
Sign In or Register to comment.