pj spreadsheet

2456

Comments

  • FiveB247x
    FiveB247x 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
  • AmentsChick
    AmentsChick 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

  • Mozzy
    Mozzy 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.
  • smg97791
    smg97791 Posts: 151
    I have a spreadsheet for which 2000/2003 boots that I own/don't own.
  • WM31482
    WM31482 New York, NY 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!!
  • msjpearson
    msjpearson 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?
  • jervin007
    jervin007 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-Fish
    Given2Fly-Fish Posts: 826
    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
  • choop
    choop 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_soup
    vedder_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!
  • vedder_soup
    vedder_soup Posts: 5,861
    msjpearson wrote:
    Is there a website that tracks concert stats? I'm also a DMB fan, and there is a fan site (http://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?

    TSIS used to have that but it went :cry:
    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!
  • RGarabed21
    RGarabed21 Posts: 467
    I dont know why I didnt use Excel..i just made a list in Word and color coded it to what I've seen\not seen.
    MSG - 6/25/08 EV Solo Tower Theatre - 06/11/09
    Philly 2 - 10/28/09 Philly 3 - 10/30/09
    Philly 4 - 10/31/09
    Boston 1 - 05/17/10
    PruCenter - 05/18/10
    MSG 1 - 05/20/10
    MSG 2 - 05/21/10
    Alpine1 - 09/03/11 Alpine2 - 09/04/11
  • IndySarah
    IndySarah Posts: 42
    I have one I did in Google Docs, but I was just thinking today before reading the thread that I needed to incorporate songs per album that I haven't seen yet. I also list all covers that I've seen.
    "You look like you'd be sticky" --

    Indianapolis 1998, Indianapolis 2000, Alpine 2003, Indianapolis 2003, Toledo 2004, Grand Rapids 2004, St Louis 2004, Kitchener 2005, London 2005, Hamilton 2005, Chicago I 2006, Grand Rapids 2006, Cleveland 2006, Cincinnati 2006 The Vic 2007, Lollapalooza 2007, Chicago I and II 2009
  • Wobbie
    Wobbie Posts: 31,353
    it just occurred to me to make the openers BOLD and the closing songs BOLD ITALIC. Why didn't I think of that sooner? My spreadsheet is a geeky thing of beauty. :ugeek: :lol:
    If I had known then what I know now...

    Vegas 93, Vegas 98, Vegas 00 (10 year show), Vegas 03, Vegas 06
    VIC 07
    EV LA1 08
    Seattle1 09, Seattle2 09, Salt Lake 09, LA4 09
    Columbus 10
    EV LA 11
    Vancouver 11
    Missoula 12
    Portland 13, Spokane 13
    St. Paul 14, Denver 14
    Philly I & II, 16
    Denver 22
    Missoula 24
  • YoullseeDragons
    YoullseeDragons Posts: 2,144
    I am a total PJ nerd. I created an excell file that has all my info:
    -First tab has every PJ show/apperance/broadcast, with the date-location-venue, then 3 check boxes with CD-DVD-attended, at the bottom I have an auto sum so I know how may bootlegs I have and how may shows I have attended. I also put in a text box for each show so when you put the arrow over it, a pop-up box gives the show information (setlist, show info, highlights)
    -Second tab has bootleg shows I need
    -Third tab shows songs I have heard live, number of times, and how many songs I need to finish an album.

    Now you can all give me the :roll:, but I have all my info organized. ( I have no life, but I'm organized) ;)
  • ceska
    ceska New York Posts: 1,137
    Here's my spreadsheet.
  • Wilds
    Wilds Posts: 4,329
    Here is a screen shot of mine.

    http://www.nathanwilds.com/ss.jpg
  • Boxes&Books
    Boxes&Books USA Posts: 2,672
    I started working on mines a few months back, but I never got around to finishing it- I would say its still in the works....
  • CranMalReign
    CranMalReign Posts: 1,928
    Let's ratchet up the nerdom a little, kiddies:

    I never had a spreadsheet for this. I had an Access database. I have since moved it to a MySQL database with a PHP front end on teh interwebs. It keeps track of all my shows, where they were at, the show posters, the openers, my show companions, and of course, which songs were played when. :)

    It's still a work in progress (that work has not progressed on in a few months), but i love it.

    And no, you can't see it. :)
    • 98 Pgh
    • 00 Pgh
    • 03 Pgh|Philly|PSU|Camden 1+2|Hershey
    • 04 Boston 1|Reading
    • 05 Philly
    • 06 Camden 1+2|Pgh
    • 08 Camden 1+2|Hartford|Mansfield 2
    • 09 Philly 1 [EV]|Toronto|Spectrum 1-4
    • 10 Cleveland|Buffalo
    • 11 Philly [EV]|PJ20
    • 12 Philly
    • 13 London|Pgh|Buff|Philly 1+2|Balt
    • 14 Cincy|StL
    • 16 Philly 1+2|Philly 2 [TotD]
    • 18 Boston 1+2
  • Black Diamond
    Black Diamond Posts: 25,109
    Yeah I made one up too...

    Thinking about copying all the concerts in so that all could benefit... In excel and yes it has macros :shock: (which compile missing songs and stats on each viewing :ugeek: )

    Plus it has graphs :mrgreen:
    Only PJ songs, no covers...
    GoiMTvP.gif

Categories