pj spreadsheet

12346»

Comments

  • Rearviewrelease
    Rearviewrelease Posts: 721
    Here is how mine is set up....

    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
  • Bump30
    Bump30 Burlington Ontario Posts: 446
    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! :D
    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 :-(
  • eddies in my tree
    eddies in my tree Posts: 486
    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.
    a wise man investigates what a fool passes by

    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
  • Bump30
    Bump30 Burlington Ontario Posts: 446
    eddies in my tree wrote:
    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 :-(
  • eddies in my tree
    eddies in my tree Posts: 486
    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.
    a wise man investigates what a fool passes by

    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
  • AmyMoore
    AmyMoore Posts: 141
    Someone needs to make a website like this one http://www.nintourhistory.com/.

    You add your show to your profile, and it figures out all the stats for you.
  • Travelar
    Travelar Posts: 3,441
    AmyMoore wrote:
    Someone needs to make a website like this one http://www.nintourhistory.com/.

    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. :(

Categories