Home› The Porch

Perfect PJ Bootleg Finder - Excel Sheet

FrankieGFrankieG Abingdon MD Posts: 9,100
edited November 2013 in The Porch
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! :)

1Ar0vbI.jpg

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

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!
2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
Post edited by Unknown User on
«1

Comments

  • KimmiebyromKimmiebyrom Posts: 1,832
    Holy moly that is AWESOME!! I cannot wait to use it!
    2003 Dallas
    2013 Wrigley
    2013 Dallas
    2013 Oklahoma City
    2013 Seattle

    How I choose to feel is how I am.
    There's just one word I still believe...and it's LOVE.
    "Take care of one another..." -EV
  • jlaustinjlaustin Ann Arbor, MI Posts: 2,355
    This is fantastic! I really wish I knew how to do stuff like this, glad we have you, FrankieG! :D :thumbup:
    2013 Wrigley, Pittsburgh, Buffalo
    2014 Cincy, Detroit, Moline, & Milwaukee
    2015 Central Park
    2016 Lexington, Ottawa, Toronto 1 & 2, Boston 1 & 2, Chicago 1 & 2
    2017 Rock and Roll Hall of Fame Induction Ceremony
    2018 Seattle 1 & 2, Missoula, Chicago 1

  • papa_pearls_jam.pj20papa_pearls_jam.pj20 Chicago USA Posts: 2,142
    Man, that is the cutting edge!
    :clap::clap::clap::clap::clap:
    Posimists. Fuck the pessimists...fuck'em.
  • NatashapearljamfanNatashapearljamfan Australia Posts: 3,777
    Thank you, thank you, thank you very much. This is awesome.
    You are one talented person.

    :clap::clap::clap::clap:
  • pjradiopjradio Posts: 6,704
    I wish I knew how to do this fucking thing!!! Kudos to OP Anyway!
    aqo2t.jpg
  • mca47mca47 Posts: 13,312
    I hate Excel.

    Looking for a new boot. Have a couple freebies thru 10c. Any suggestions?
  • iamloco724iamloco724 Brooklyn NY Posts: 1,441
    Amazing!
  • buck502000buck502000 Birthplace of GIBSON guitar Posts: 8,951
    I love spreadsheets! No, this is why I quit my job. Great work, though.
  • morellomorello Auckland, New Zealand Posts: 6,217
    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! 8-)
    <hr>
    PJ - Auckland 2009; Alpine Valley1&2 2011; Man1, Am'dam1&2, Berlin1&2, Stockholm, Oslo & Copenhagen 2012; LA, Oakland, Portland, Spokane, Calgary, Vancouver, Seattle 2013; Auckland 2014, Auckland1&2 2024
    EV - Canberra, Newcastle & Sydney 1&2 2011
  • demetriosdemetrios Posts: 94,712
    Thanks! :)
  • Driftin'AlongDriftin'Along Posts: 1,403
    Very interesting. I will have to give this a try and see what I come up with. Thanks for creating/posting.
    "Not only do you have sunshine but you have better thunder...fuckers." -Ed, Phx 10/21/00
    PJ * 10/21/00 - Phx * 6/7/03 - Phx * 6/29/06 - Milwaukee * 6/30/06 - Milwaukee * 11/19/13 - Phx *
    EV * 11/4/12 - Phx, AZ *
  • ratonesratones Posts: 169
    That's pretty cool!! :):):)

    I'll be playing with it for a while, I'm sure!
  • FrankieGFrankieG Abingdon MD Posts: 9,100
    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: :lol:
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • nevmilesnevmiles Ottawa, ON Posts: 1,363
    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.....
    Barrie 08/22/98
    Montreal 10/04/00
    Toronto 10/05/00
    Toronto 06/28/03
    Kitchener 09/11/05
    Ottawa 09/16/05
    Toronto 08/21/09
    Toronto 09/11/11
    Ottawa 09/14/11
    Buffalo 10/12/13
    Ottawa 05/08/16
    Chicago 08/20/18
    Ottawa 09/03/22
    Nashville 09/16/22
  • Bednarz42Bednarz42 Posts: 223
    Holmdel 03 was such a good show
    Albany '03
    Holmdel '03
    Reading '04
    Philly '05
    Irving Plaza '06
    Albany '06
    Hartford '06
    Camden 1 '06
    East Rutherford 1 '06
    East Rutherford 2 '06
    MSG 1 '08
    MSG 2 '08
    Philly 4 '09
    MSG 1 '10
    MSG 2 '10
    Alpine 1 '11
    Alpine 2 '11
    Made in America '12
    Worcester 2 '13
    Brooklyn 1 '13
    Brooklyn 2 '13
    Philly 2 '13
    Philly 2 '16
    Boston 1 '16
  • Daron OshayDaron Oshay Middletown, NJ Posts: 2,561
    Bednarz42 wrote:
    Holmdel 03 was such a good show

    For sure. One if the great "forgotten" shows.
  • FrankieGFrankieG Abingdon MD Posts: 9,100
    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! :mrgreen:
    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.
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • nevmilesnevmiles Ottawa, ON Posts: 1,363
    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!
    Barrie 08/22/98
    Montreal 10/04/00
    Toronto 10/05/00
    Toronto 06/28/03
    Kitchener 09/11/05
    Ottawa 09/16/05
    Toronto 08/21/09
    Toronto 09/11/11
    Ottawa 09/14/11
    Buffalo 10/12/13
    Ottawa 05/08/16
    Chicago 08/20/18
    Ottawa 09/03/22
    Nashville 09/16/22
  • RoelandRoeland Posts: 177
    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! :mrgreen:
    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).
  • SpartanacusSpartanacus Oviedo, FL Posts: 870
    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!
    1998 (2) - East Lansing & Auburn Hills; 2000 (2) - Tampa & Noblesville; 2003 (2) - Lexington & Noblesville; 2006 (1) - Cincinnati; 2007 (1) - Chicago (Lollapalooza); 2008 (Ed in Milwaukee); 2009 (1) - Chicago; 2010 (1) - Noblesville; 2013 (3) - San Diego & Los Angeles I & II; 2016 (Temple of the Dog in Los Angeles); 2017 (Ed at Ohana in Dana Point);
    2021 (3) - Dana Point I, II & III; 2022 (3) - San Diego & Los Angeles I & II; *2025 (2) - Hollywood, FL I & II
  • SVRDhand13SVRDhand13 Posts: 26,689
    :shock:... great job!!!
    severed hand thirteen
    2006: Gorge 7/23 2008: Hartford 6/27 Beacon 7/1 2009: Spectrum 10/30-31
    2010: Newark 5/18 MSG 5/20-21 2011: PJ20 9/3-4 2012: Made In America 9/2
    2013: Brooklyn 10/18-19 Philly 10/21-22 Hartford 10/25 2014: ACL10/12
    2015: NYC 9/23 2016: Tampa 4/11 Philly 4/28-29 MSG 5/1-2 Fenway 8/5+8/7
    2017: RRHoF 4/7   2018: Fenway 9/2+9/4   2021: Sea Hear Now 9/18 
    2022: MSG 9/11  2024: MSG 9/3-4 Philly 9/7+9/9 Fenway 9/15+9/17
    2025: Pittsburgh 5/16+5/18
  • KM78948KM78948 Posts: 107
    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!
    '98 - washington, dc (tfc) & columbia, md
    '00 - columbia, md
    '03 - bristow, va & hershey, pa
    '06 - washington, dc
    '08 - washington, dc
    '09 - philadelphia, pa (halloween)
    '10 - bristow, va
    '13 - baltimore, md & charlottesville, va
    '15 - new york, ny (gcf)
  • Driftin'AlongDriftin'Along Posts: 1,403
    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?
    "Not only do you have sunshine but you have better thunder...fuckers." -Ed, Phx 10/21/00
    PJ * 10/21/00 - Phx * 6/7/03 - Phx * 6/29/06 - Milwaukee * 6/30/06 - Milwaukee * 11/19/13 - Phx *
    EV * 11/4/12 - Phx, AZ *
  • FrankieGFrankieG Abingdon MD Posts: 9,100
    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.
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • Driftin'AlongDriftin'Along Posts: 1,403
    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.
    "Not only do you have sunshine but you have better thunder...fuckers." -Ed, Phx 10/21/00
    PJ * 10/21/00 - Phx * 6/7/03 - Phx * 6/29/06 - Milwaukee * 6/30/06 - Milwaukee * 11/19/13 - Phx *
    EV * 11/4/12 - Phx, AZ *
  • BSullyBSully Indiana Posts: 1,354
    Great, thanks!!!
    1998: Noblesville, IN 08-17
    2000: Noblesville, IN 08-18
    2003: Noblesville, IN 06-22
    2006: Cincinnati, OH 06-24
    2010: Noblesville, IN 05-07
    2016: Lexington, KY 04-26, Wrigley Field 2 08-22
    2018: Wrigley Field 1 08-18, Wrigley Field 2 08-20
    2022: St. Louis, MO 09-18
    2024: Noblesville, IN 08-26, Wrigley Field 1 08-29, Wrigley Field 2 08-31
  • mtxmtx Posts: 283
    :thumbup:
    Wuhlheide 2006, 2009, 2010,2014; Chorzów 2007; Hyde Park 2010; Open'er 2010;
    Alpine 1&2;
    2012 Amsterdam 1&2, Prague, Berlin 1&2, Copenhagen;
    2013 Wrigley EarthCam / Ice cold water $1
  • FrankieGFrankieG Abingdon MD Posts: 9,100
    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%

    :mrgreen: :ugeek: 8-)
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • AponeApone Posts: 588
    This is an awesome spreadsheet! Cheers!
    2006: Leeds; 2012: Manchester 1; 2014: Leeds; 2017: London 1 (EV); 2018: Amsterdam 1, London 1, London 2; 2019: Amsterdam 1 (EV), Dublin (EV); 2022: Berlin, London 1, London 2, Budapest, Krakow, Amsterdam 1, Amsterdam 2; 2023: Chicago 1, Chicago 2; 2024: Manchester, London
  • hrd2imgnhrd2imgn Southwest Burbs of Chicago Posts: 4,909
    awesome, but I already know my perfect setlist, it happened over two days in East Troy, with a pre-set at the Vic theater
Sign In or Register to comment.