pj spreadsheet

hookem

I've got one of those. Here's my stats summary...

Pearl Jam Tour Stats through 11/01/2009
Concerts 45
Songs 1220
Unique Songs 195
States 15
Countries 2

Albums Tracks Seen Live Missing
(Only considering songs that have been played at least once)
Ten ALL None
.vs ALL None
Vitalogy ALL None
No Code ALL None
Yield ALL None
Binaural ALL None
Riot Act 14 of 15 Help Help
Pearl Jam ALL None
Backspacer ALL None
Lost Dogs 22 of 30 Dirty Frank, Let Me Sleep

Grandmas Jam

realmgeorge wrote:

alright fellow nerds.... anyone ever make a spreadsheet to list songs you have and haven't heard live??? care to share?

I have, and I'm a genius with excel so my spreadsheet is really nice and tight....tell me how to upload it here and i will

Wobbie

CranMalReign 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!

Wilds wrote:

Here is a screen shot of mine.

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

DB? JB? DG? NW? :wtf:

Black Diamond wrote:

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
Only PJ songs, no covers...

share that mofo!!!!

RiotAct10

I am really glad I saw this post. I had kept a file in Microsoft Works back in the day, that I think was updated through my last show in 2007, but I had been thinking just over the past few days how I should update it or move it over to Word now that I have Office. But, spreadsheet makes more sense, and I got some good ideas on how to do it from reading through these posts, so I am starting my Spreadsheet file now. With 2-3 shows coming up in only 3 weeks, I need to get this thing nice and updated and ready to have some additions.

phungi

I went with a simple spreadsheet, in which I check off songs after each concert (linkety link)...

never thought of using a more complex method, but am interested in seeing more examples

Grandmas Jam

If someone helps me load mine excel spreadsheet I will do it. You just have to tell me how to do it. My spreadsheet is a good template for anyone that wants to copy it. It has all the albums and songs off the albums. All you have to do is add shows and check off the songs you saw at what show and it adds up your statists and even graphs it for you automatically. Just help me get it up here

Wobbie

Grandmas Jam wrote:

If someone helps me load mine excel spreadsheet I will do it. You just have to tell me how to do it. My spreadsheet is a good template for anyone that wants to copy it. It has all the albums and songs off the albums. All you have to do is add shows and check off the songs you saw at what show and it adds up your statists and even graphs it for you automatically. Just help me get it up here

do you know how to upload a screenshot to photobucket like the guy above? That's not a working template, but it is a good way to share. I'll do mine too.....but I forget how to take a screenshot on my mac.

MG79478

You guys are excel amatures!

Across the top rows:
Show # (PJ or EV Solo)
Date
City
Opening Act
# Songs played (auto count)
Any trilogies played?

Down the first columns:
All albums in release order, including lost dogs, “other” like leatherman, In to the wild, and covers. Songs I haven’t heard are red, songs they haven’t played are greyed out, all of this is based on conditional formatting. The sheet auto counts how many times I have heard a song total, and broken down in to: Normal, Redux (Garden, In my tree), acoustic, incomplete, as a tag, EV Solo, or during a pre-set. I easily know how many times, and how many ways I have heard a song. (For example, I have heard WMA 3 times as a tag and 3 times as a full song) Adding a new show only takes about a minute. All I have to do is put the single letter code in for how I heard the song. Most of the time, it is just an "X" for a regular playing of the song.

I'm dying to figure out a reason to put a macro in the sheet, I just can't think of a need. I'd love to hear some other cool ideas for my sheet!

mavi

Grandmas Jam wrote:

If someone helps me load mine excel spreadsheet I will do it.

Just upload it here http://www.2shared.com/ and it will give you a download link.

imalive wrote:

I'll do mine too.....but I forget how to take a screenshot on my mac.

Command + shift + 3
(or + 4 to select)

Grandmas Jam

mavi wrote:

Grandmas Jam wrote:

If someone helps me load mine excel spreadsheet I will do it.

Just upload it here http://www.2shared.com/ and it will give you a download link.

imalive wrote:

I'll do mine too.....but I forget how to take a screenshot on my mac.

Command + shift + 3
(or + 4 to select)

not only is she pretty but she is also helpful too! thank you!

decides2dream

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.

nope.
but i DO have a spreadsheet of all my shows, dates, venues and seat #s or GA.
also have one for my posters, where purchased, who from - if applicable, cost, if framed, that cost - total cost per poster, and average cost. the songs tho, too much work for me.

MG79478 wrote:

You guys are excel amatures!

Across the top rows:
Show # (PJ or EV Solo)
Date
City
Opening Act
# Songs played (auto count)
Any trilogies played?

Down the first columns:
All albums in release order, including lost dogs, “other” like leatherman, In to the wild, and covers. Songs I haven’t heard are red, songs they haven’t played are greyed out, all of this is based on conditional formatting. The sheet auto counts how many times I have heard a song total, and broken down in to: Normal, Redux (Garden, In my tree), acoustic, incomplete, as a tag, EV Solo, or during a pre-set. I easily know how many times, and how many ways I have heard a song. (For example, I have heard WMA 3 times as a tag and 3 times as a full song) Adding a new show only takes about a minute. All I have to do is put the single letter code in for how I heard the song. Most of the time, it is just an "X" for a regular playing of the song.

I'm dying to figure out a reason to put a macro in the sheet, I just can't think of a need. I'd love to hear some other cool ideas for my sheet!

:shock:



yes, total amateur. i would have no idea how to do that. then again, i was an art major. it's amazing i know what i do know about excel. haha.

RiotAct10

so nice to see the fellow dorks not afraid to admit to and discuss this!

Grandmas Jam

http://www.2shared.com/file/12684155/6f ... _Live.html there she is, bu you gotta download it....its the best spreadsheet out there hands down

Bump30

I've got a bunch....I'll admit to being a nerd!

Bump30

phungi wrote:

I went with a simple spreadsheet, in which I check off songs after each concert (linkety link)...

never thought of using a more complex method, but am interested in seeing more examples

Ohhh I really like this!! Nice job!!!

MG79478

decides2dream wrote:

yes, total amateur. i would have no idea how to do that. then again, i was an art major. it's amazing i know what i do know about excel. haha.

I'm an engineer, surprise surprise!

mavi

Grandmas Jam wrote:

not only is she pretty but she is also helpful too! thank you!

Why, thank you :oops:

And nice spreadsheet!!

Tone

Course I have a spreadsheet listing all the songs I've seen live and how many times... all the cool kids do!

I did mine after Philly last year... it took a while, I'm rather anal about spreadsheets and formatting, lol.

jked3

I started one after hearing that other people actually do it...then it became very tedious and time consuming and I realized that multiplying matricies for my reinforced concrete structural analysis and design course in college was much easier...I'll get back to it after the upcoming shows

wolfbear

Of course I do. It's just a simple excel one though, with each song from every concert we've been to. Easy reference, but nothing that would mean anything to anyone else.