pj spreadsheet

1246

Comments

  • Wilds
    Wilds Posts: 4,329
    imalive wrote:
    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. :)

    sounds awesome.....even if I have no fucking idea what you're talking about! :lol::lol:
    Wilds wrote:
    Here is a screen shot of mine.

    http://www.nathanwilds.com/ss.jpg

    DB? JB? DG? NW? :wtf:



    Those initials are Me (Nathan Wilds) and 3 of my friends who all follow the band, and under each name is the # of times we have each seen that song. It is another few pages with covers and tags.


    JB has been to a shit ton of shows. SOB. :P
  • Wobbie
    Wobbie Posts: 31,353
    Wilds wrote:


    JB has been to a shit ton of shows. SOB. :P

    JB is your hiking partner, huh? Good guy. :mrgreen:
    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
  • ok guys, i totally nerded out and did my spreadsheet today.

    Amazing - I've been to five shows and only seen Yellow Ledbetter once!!! Also crazy that I've seen them do Bee Girl the same number of times as Alive... who woulda thunk it...

    This is what happens when I have a cold - I have to channel my excitment for the upcoming shows next week somehow!!! :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
  • 81
    81 Needing a ride to Forest Hills and a ounce of weed. Please inquire within. Thanks. Or not. Posts: 58,276
    i'd think it'd be cool if they would let you customize the song listing that shows all the data for all the shows to show just your data beside it. they've got all the data. i've put all my shows into my profile. it'd take a little programming to do, but not much.

    if i had the data in access i'd build something
    81 is now off the air

    Off_Air.jpg
  • Wilds
    Wilds Posts: 4,329
    imalive wrote:
    Wilds wrote:


    JB has been to a shit ton of shows. SOB. :P

    JB is your hiking partner, huh? Good guy. :mrgreen:

    Yup and yup. :D
  • NYCPJ
    NYCPJ nyc Posts: 764
    jfconnorjr wrote:
    Send me a PM and I will send you my template.... I am a nerd

    id love to see that template. thanks!
    6/3/06 (East Rutherford 2)
    6/24/08 (MSG1)
    6/25/08 (MSG2)
    7/1/08 (Beacon Theater -NYC)
    10/30/09 (Philly3)
    5/18/10 (Newark, NJ)
    5/20/10 (MSG1)
    5/21/10 (MSG2)
    10/18/13 (Brooklyn 1)
    10/19/13 (Brooklyn 2)
    5/1/16 (MSG 1)
    5/2/16 (MSG 2)
    3/30/20 (MSG)
    9/3/24 I(MSG1)
    9/4/24 (MSG 2)
  • katellis
    katellis Posts: 535
    edited June 2015
    --
    Post edited by katellis on
  • P34RL J4MM3R
    P34RL J4MM3R Posts: 1,342
    Yeah, I keep a spreadsheet. I need Wash, Alone, Of the Girl & Release to really fill me out. I just love the thrill of the hunt.
    My stats:
    22 shows
    620 songs
    28.2 songs per show
    170 unique songs
    Must have....more.....unique.....songs....must have......it......puts on the......lotion......precious.....precious....my precious unique songs...........
    There's no need to say goodbye
  • iamloco724
    iamloco724 Brooklyn NY Posts: 1,441
    i havnt been to many shows 3 in the past 3 this coming tour but i have a word document of what i have seen
  • WM31482
    WM31482 New York, NY Posts: 563
    It's a little sad how happy this thread makes me... :roll:
  • blondieblue227
    blondieblue227 Va, USA Posts: 4,509
    I can’t believe I’m contemplating doing one.
    *~Pearl Jam will be blasted from speakers until morale improves~*

  • 81
    81 Needing a ride to Forest Hills and a ounce of weed. Please inquire within. Thanks. Or not. Posts: 58,276
    Yeah, I keep a spreadsheet. I need Wash, Alone, Of the Girl & Release to really fill me out. I just love the thrill of the hunt.
    My stats:
    22 shows
    620 songs
    28.2 songs per show
    170 unique songs
    Must have....more.....unique.....songs....must have......it......puts on the......lotion......precious.....precious....my precious unique songs...........

    9 shows
    275 songs
    30.5 songs per show
    118 unique songs
    81 is now off the air

    Off_Air.jpg
  • gregkitefan
    gregkitefan Posts: 1,122
    I just updated mine today after Hartford and Boston.
    38
  • blondieblue227
    blondieblue227 Va, USA Posts: 4,509
    http://www.2shared.com/file/12684155/6f5bc6b4/Pearl_Jam_Live.html there she is, bu you gotta download it....its the best spreadsheet out there hands down


    yeah that's a good one

    but it was missing:
    long road
    leatherman
    it's ok

    and i thought it was rocking in THE free world, not A free world. lol!

    maybe i'm not seeing it but i'm going to do a total for each album...if that's possible.

    the last two columns don't make sense to me. please explain. i get totals but why a column for song?

    here's mine: http://www.ivykennedy.com/trash/Pearl%2 ... 0Tally.xls
    *~Pearl Jam will be blasted from speakers until morale improves~*

  • NeilJam
    NeilJam Posts: 1,191
    My spreadsheet is set up for most of it to be visible on screen at once. Songs are organized by album, including Into the Wild and Mirror Ball, Lost Dogs, Other Originals, Covers, and songs members have performed only with other artists such as Ed singing It Makes no Difference with MMJ. I add notes to cells for song titles if I've seen them play it with someone like Ben joining them for Indifference. I also note in the totals for each song if I hear a reworked version or if I hear a song the first time they play it live.

    There are three sheets for songs, one for shows I've been to with my wife, another for shows I attended that she did not, and one that adds the entries from the first two for total times I've heard each song. There are additional sheets listing the shows I've been to and artists I've seen the band, or members of, perform with.
  • WM31482
    WM31482 New York, NY Posts: 563
    I love you guys :)
  • blondieblue227
    blondieblue227 Va, USA Posts: 4,509
    i give my guy crap about his OCD. he'd laugh and tease me so hard if knew i was doing this. :lol:
    *~Pearl Jam will be blasted from speakers until morale improves~*

  • Indi4ence
    Indi4ence Posts: 949
    I made one a few months back, its pretty basic. All songs listed by album on the left, dates and locations across the top. Total # of songs under each show. Total # of times i've heard each song next to the song. took a while to type it all up but works great. took me 2 mins to load in my songs from Hartford. I just enter the date and then place an "X" in each song cell that they playd.

    if anyone needs the template let me know.

    Can't wait for MSG!
  • mavi
    mavi Posts: 941
    Geeks.

    :mrgreen:






    But I actually love this thread!
    "He who hears music, feels his solitude peopled at once" R. Browning
  • 81
    81 Needing a ride to Forest Hills and a ounce of weed. Please inquire within. Thanks. Or not. Posts: 58,276
    i'm debating if i should make mine sicker. it's pretty simple right now...

    maybe a drop down box that lets you pick a song and then charts out all the data for that song.

    hmmm...does anybody have all the concert data by concert downloaded yet. :lol: i could get sick with it.
    81 is now off the air

    Off_Air.jpg