Perfect PJ Bootleg Finder - Excel Sheet

2»

Comments

  • SVRDhand13
    SVRDhand13 Posts: 27,016
    :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
  • KM78948
    KM78948 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'Along
    Driftin'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 *
  • FrankieG
    FrankieG 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'Along
    Driftin'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 *
  • BSully
    BSully Indiana Posts: 1,503
    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
    2025: Pitt 1 05-16, Pitt 2 05-18
  • mtx
    mtx 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
  • FrankieG
    FrankieG 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
  • Apone
    Apone Posts: 589
    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
  • hrd2imgn
    hrd2imgn Southwest Burbs of Chicago Posts: 4,925
    awesome, but I already know my perfect setlist, it happened over two days in East Troy, with a pre-set at the Vic theater
  • SVRDhand13
    SVRDhand13 Posts: 27,016
    I still have to try this out. My laptop is crap though.
    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
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    SVRDhand13 wrote:
    I still have to try this out. My laptop is crap though.

    yeah may take awhile... runs in about 4 minutes on a good laptop with 4 processors.
    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
  • SVRDhand13
    SVRDhand13 Posts: 27,016
    FrankieG wrote:
    SVRDhand13 wrote:
    I still have to try this out. My laptop is crap though.

    yeah may take awhile... runs in about 4 minutes on a good laptop with 4 processors.

    I have a Macbook from 2008 that has only 5 available gigs and cannot run unless plugged in :lol:

    I was thinking of getting the new Macbook Air sometime soon
    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
  • papa_pearls_jam.pj20
    papa_pearls_jam.pj20 Chicago USA Posts: 2,142
    I tried this out today...here's what the spreadsheet generated. Not a bad list (just the Top 20).

    2005-09-01 Gorge Amphitheatre
    2003-06-29 Montreal, Quebec
    2000-08-14 New Orleans, LA
    2006-09-30 Athens, Greece
    2005-09-30 Atlantic City, NJ
    2005-09-20 Quebec City, Quebec
    2003-03-03 Tokyo, Japan
    2000-09-02 Camden, NJ
    1998-09-01 Atlanta, GA
    1998-08-28 Camden, NJ
    1996-09-29 New York, NY (Randall’s)
    2008-06-16 Columbia, SC
    2006-07-22 Gorge Amphitheatre
    2006-06-03 East Rutherford, NJ
    2006-05-10 Toronto, Ontario
    2005-12-02 São Paulo, Brazil
    2005-10-05 House of Blues, Chicago
    2005-08-29 Missoula, MT
    2003-07-11 Mansfield, MA
    2003-07-08 Madison Square Garden

    Gonna try it again, but this time make it more realistic and maybe I'll see some setlists with more of my songs. My top one had only 12 of 30 songs I entered.
    Posimists. Fuck the pessimists...fuck'em.
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    Use the "Song Ranker" site to figure out your top songs. --> www.PearlJamSongRanker.com

    Then use this to figure out your top bootleg.

    :mrgreen::mrgreen:

    If only we could combine them! :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
  • Wobbie
    Wobbie Posts: 31,410
    I wonder what 81 would say about this :?
    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

Categories