Perfect PJ Bootleg Finder - Excel Sheet

FrankieG

In the past I have read threads about people wanting to find a show with certain songs in it, so they can buy a bootleg that they will enjoy. Now you can find that perfect bootleg!



As an example, I entered all of the songs from the first show I went to.

This Dropbox Download link will download an excel file I wrote. Enter the songs you want, wait for the calculation, and the sheet will tell you the bootleg that most closely matches your list!

TIPS: Make sure the excel sheet is on manual calculation! Enter all of the songs and then calculate. Leaving it on auto-calculate created problems for me! :!:

:arrow: WARNING: This excel file uses 'brute force' in the calculations. The calculations will take a long time. BE PATIENT! I am not taking any responsibility for you overloading your computer, etc, There is approx 48 x 17768 = ~852,000 calculations each time the sheet updates. It took my Macbook Pro about 20 minutes to run... :!: :!: :!:

Let me know what you think!

Kimmiebyrom

Holy moly that is AWESOME!! I cannot wait to use it!

jlaustin

This is fantastic! I really wish I knew how to do stuff like this, glad we have you, FrankieG! :thumbup:

papa_pearls_jam.pj20

Man, that is the cutting edge!

Natashapearljamfan

Thank you, thank you, thank you very much. This is awesome.
You are one talented person.

pjradio

I wish I knew how to do this fucking thing!!! Kudos to OP Anyway!

mca47

I hate Excel.

Looking for a new boot. Have a couple freebies thru 10c. Any suggestions?

iamloco724

Amazing!

buck502000

I love spreadsheets! No, this is why I quit my job. Great work, though.

morello

Good on you. I love that sort of thing too(ask my touring group for the fall tour, I've made a spreadsheet for all our plans for that)!! I've never had the issue you're aiming to help her(which bootleg to download) so I'm not going to go there & download it but just wanted to say WOW, YAY & good on you!

demetrios

Thanks!

Driftin'Along

Very interesting. I will have to give this a try and see what I come up with. Thanks for creating/posting.

ratones

That's pretty cool!!

I'll be playing with it for a while, I'm sure!

FrankieG

Thanks for the kind words everyone! I enjoyed making it. :ugeek:

Let me know if anyone has any good success. When I was playing around with it, I would always pick my favorite songs (that are rarely played) and obviously no concerts are gonna contain the most rare songs.. :fp:

nevmiles

I typed in all my songs, but then couldn't get it to "calculate". F9 did nothing and there is no "Calculate" option that I could fin under the Formulas tab. I have confirmed that it is in "manual" calculation mode too... Suggestions? Do I need to highlight a certain cell before calculating?

EDIT: Just realized it HAD started calculating . . . I thought I'd get a pop-up window or something, but I see the progress in the lower right hand corner.....

Bednarz42

Holmdel 03 was such a good show

Daron Oshay

Bednarz42 wrote:

Holmdel 03 was such a good show

For sure. One if the great "forgotten" shows.

FrankieG

Daron Oshay wrote:

Bednarz42 wrote:

Holmdel 03 was such a good show

For sure. One if the great "forgotten" shows.

And definitely one of the shows that can be found using this!

nevmiles wrote:

I typed in all my songs, but then couldn't get it to "calculate". F9 did nothing and there is no "Calculate" option that I could fin under the Formulas tab. I have confirmed that it is in "manual" calculation mode too... Suggestions? Do I need to highlight a certain cell before calculating?

EDIT: Just realized it HAD started calculating . . . I thought I'd get a pop-up window or something, but I see the progress in the lower right hand corner.....

Yeah, I looked into getting a progress bar, but that was to much of a hassle. Like I said, it takes a very long time to calculate... Which is a major downside. :x But this was the easiest solution, which unfortunatley is 'brute force' and doesnt use search functions very well.

nevmiles

FrankieG wrote:

nevmiles wrote:

I typed in all my songs, but then couldn't get it to "calculate". F9 did nothing and there is no "Calculate" option that I could fin under the Formulas tab. I have confirmed that it is in "manual" calculation mode too... Suggestions? Do I need to highlight a certain cell before calculating?

EDIT: Just realized it HAD started calculating . . . I thought I'd get a pop-up window or something, but I see the progress in the lower right hand corner.....

Yeah, I looked into getting a progress bar, but that was to much of a hassle. Like I said, it takes a very long time to calculate... Which is a major downside. :x But this was the easiest solution, which unfortunatley is 'brute force' and doesnt use search functions very well.

No worries, man! It's still an amazing piece of work!

Roeland

FrankieG wrote:

Daron Oshay wrote:

Bednarz42 wrote:

Holmdel 03 was such a good show

For sure. One if the great "forgotten" shows.

And definitely one of the shows that can be found using this!

nevmiles wrote:

I typed in all my songs, but then couldn't get it to "calculate". F9 did nothing and there is no "Calculate" option that I could fin under the Formulas tab. I have confirmed that it is in "manual" calculation mode too... Suggestions? Do I need to highlight a certain cell before calculating?

EDIT: Just realized it HAD started calculating . . . I thought I'd get a pop-up window or something, but I see the progress in the lower right hand corner.....

Yeah, I looked into getting a progress bar, but that was to much of a hassle. Like I said, it takes a very long time to calculate... Which is a major downside. :x But this was the easiest solution, which unfortunatley is 'brute force' and doesnt use search functions very well.

You can make this much more performant by using a pivottable. I've made a quick example and this way calculation is pretty much instant (http://www.sendspace.com/file/p9yfc1).

Spartanacus

Thanks! I have my own bootleg collection and live show spreadsheet, but it pales in comparison to what you say you have created! I will have to check it out on a rainy day soon!

SVRDhand13

:shock:... great job!!!

KM78948

nice work! can't wait to use it for the upcoming tour boots. out of curiousity how long have you been working on this?? however long, it is much appreciated!

Driftin'Along

I put in my setlist and tried to calculate. Just curious, how will I know it's working and how do you confirm it is on manual calculation?

FrankieG

KM78948 wrote:

nice work! can't wait to use it for the upcoming tour boots. out of curiousity how long have you been working on this?? however long, it is much appreciated!

Right now it only contains the setlists for past shows. If you want to search for tour dates after the Wrigley date this year, you will have to update sheet 2 of the document and re-write some formulas.

Driftin'Along wrote:

I put in my setlist and tried to calculate. Just curious, how will I know it's working and how do you confirm it is on manual calculation?

Depending on what version of excel you have.. There will usually be a progress bar in the lower right corner. You can confirm its on manual calculation through 'preferences' tab on a Mac or through 'formula' tab on windows.
If you aren't sure, just save the document. The calculation must run everytime you save, so just wait for it to save and you are good.

Driftin'Along

FrankieG wrote:

KM78948 wrote:

nice work! can't wait to use it for the upcoming tour boots. out of curiousity how long have you been working on this?? however long, it is much appreciated!

Right now it only contains the setlists for past shows. If you want to search for tour dates after the Wrigley date this year, you will have to update sheet 2 of the document and re-write some formulas.

Driftin'Along wrote:

I put in my setlist and tried to calculate. Just curious, how will I know it's working and how do you confirm it is on manual calculation?

Depending on what version of excel you have.. There will usually be a progress bar in the lower right corner. You can confirm its on manual calculation through 'preferences' tab on a Mac or through 'formula' tab on windows.
If you aren't sure, just save the document. The calculation must run everytime you save, so just wait for it to save and you are good.

All of the suggestions worked. Wow, this thing is pretty cool. I had 5 matches to my setlist above 45%. Will have to go and listen to those shows. Thanks again for your hard work on this.

BSully

Great, thanks!!!

mtx

:thumbup:

FrankieG

The 'OCEANS in the Northeast US Request thread' created this dream setlist:

1. Oceans
2. Of The Girl
3. Do the Evolution
4. Breath
5. Alone
6. Jeremy (Red Rocks version)
7. In Hiding
8. Lightning Bolt
9. Even Flow
10. Nothing As It Seems
11. Mind Your Manners
12. Dissident
13. Parachutes
14. Immortality
15. Low Light
16. State of Love and Trust
17. Save You
18. Blood

Encore 1

19. Of The Earth
20. Red Mosquito
21. Sirens (:shock:)
22. Daughter (War)/(Its Ok)/(Highway to hell)/(ABITW)
23. Not For You
24. Go

Encore 2

25. Last Exit
26. All Those Yesterdays
27. All or none
28. Alive
29. Indifference
30. Oceans (reprise)

Encore 3

31. Spin the Black Circle
32. Satans Bed
33. All Along the Watchtower

Which was calculated to be closest to 7/8/1995 with 13 songs in that set.

Date # Songs % Songs
7/8/95 13 52%
9/1/05 12 33%
10/28/96 12 46%
9/28/96 12 40%
11/6/95 12 39%
9/16/95 12 39%
3/24/94 12 48%
3/20/94 12 50%
7/16/13 11 37%
11/6/11 11 35%
5/18/10 11 35%
8/17/09 11 41%

:ugeek:

Apone

This is an awesome spreadsheet! Cheers!

hrd2imgn

awesome, but I already know my perfect setlist, it happened over two days in East Troy, with a pre-set at the Vic theater