Home› The Porch
Options

Finding the best boot for you. Is this idea doable?

otterotter Posts: 753
in The Porch
Anyway to somehow list songs you'd like to have live and it matches up concerts?
I found my place......and it's alright

Comments

  • Options
    FoxyRedLaFoxyRedLa Lauren / MI Posts: 4,810
    Hmmm......maybe. Easy to find albums based on release dates/tours....I'm sure it's possible.
    Oh please let it rain today.
    Those that can be trusted can change their mind.
  • Options
    RS151862RS151862 Pittsburgh, PA Posts: 2,625
    pjdb.net has a function where you can search setlists by entering songs you like

    http://www.pjdb.net/findsetlist.php?

    Pittsburgh 1998 • Pittsburgh 2006 • 2012 Isle Of Wight Festival • 2012 Made In America Festival • Baltimore 2013 • Seattle 2013
    St. Paul 2014 • Mexico City 2015 • Philadelphia II 2016 • Ottawa 2016 • Amsterdam I & II 2018 • Wrigley Field II 2018 • Phoenix 2022
    Apollo Theater 2022 • Chicago I 2023

  • Options
    FoxyRedLaFoxyRedLa Lauren / MI Posts: 4,810
    Thanks Ron, you stay classy.
    Oh please let it rain today.
    Those that can be trusted can change their mind.
  • Options
    RS151862RS151862 Pittsburgh, PA Posts: 2,625
    Some people say its not accurate, but i know for a fact that 60% of the time it works every time.
    Pittsburgh 1998 • Pittsburgh 2006 • 2012 Isle Of Wight Festival • 2012 Made In America Festival • Baltimore 2013 • Seattle 2013
    St. Paul 2014 • Mexico City 2015 • Philadelphia II 2016 • Ottawa 2016 • Amsterdam I & II 2018 • Wrigley Field II 2018 • Phoenix 2022
    Apollo Theater 2022 • Chicago I 2023

  • Options
    otterotter Posts: 753
    sweet! Thanks!
    I found my place......and it's alright
  • Options
    otterotter Posts: 753
    I Can't get it to work. I can't get past select a song
    I found my place......and it's alright
  • Options
    RS151862RS151862 Pittsburgh, PA Posts: 2,625
    select a song then hit add rule.. that moves it to the bottom of the screen... add as many songs as you like that way to the bottom then hit search shows.
    Pittsburgh 1998 • Pittsburgh 2006 • 2012 Isle Of Wight Festival • 2012 Made In America Festival • Baltimore 2013 • Seattle 2013
    St. Paul 2014 • Mexico City 2015 • Philadelphia II 2016 • Ottawa 2016 • Amsterdam I & II 2018 • Wrigley Field II 2018 • Phoenix 2022
    Apollo Theater 2022 • Chicago I 2023

  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    I run statistics analyses at work, and I had thought about running something like a "cluster analysis" that would show (visually) how similar/different each set list is from others. That would help you pick a few bootlegs from each tour that were different from each other.....it would take a bit of work to set it up though..I don't know if it would be helpful or not.
  • Options
    otterotter Posts: 753
    When I hit the drop down arrow another drop down arrow appears. When I touch that a list of songs appear for a second then disappear. Plus I entered my shows and I didn't get the stats.
    I found my place......and it's alright
  • Options
    otterotter Posts: 753
    Not didn't get didn't understand
    Percentage of shows played since debut : footsteps 100% (1/1)
    I don't get it
    I found my place......and it's alright
  • Options
    otterotter Posts: 753
    Got it working. Thanks mr burgundy

    Listed 11 songs and best outcome had 6

    I found my place......and it's alright
  • Options
    FrankY59FrankY59 Posts: 1,048
    BHealy said:

    I run statistics analyses at work, and I had thought about running something like a "cluster analysis" that would show (visually) how similar/different each set list is from others. That would help you pick a few bootlegs from each tour that were different from each other.....it would take a bit of work to set it up though..I don't know if it would be helpful or not.

    I love math. How can I help?!

  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    FrankY59 said:

    BHealy said:

    I run statistics analyses at work, and I had thought about running something like a "cluster analysis" that would show (visually) how similar/different each set list is from others. That would help you pick a few bootlegs from each tour that were different from each other.....it would take a bit of work to set it up though..I don't know if it would be helpful or not.

    I love math. How can I help?!

    I need to get all the songs in a matrix with the shows listed along one axis, and all the songs along the other axis and a "0" or "1" to signify whether the song was played or not at that show. That's what been holding me back!
  • Options
    ParanoidBoyParanoidBoy Posts: 22
    I started with something similar a couple of years back. I should have a file from which I can quickly put a matrix together. The songs and shows are updated up to 2012 - but it is a start.
  • Options
    ParanoidBoyParanoidBoy Posts: 22
    PM sent
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    Cool! I'll check it out when I get home. (On my phone right now) It's worth a try, thanks!!
  • Options
    FrankieGFrankieG Abingdon MD Posts: 9,095
    I did this awhile ago, but definitely room for improvement. Brute force excel method is very slow: http://community.pearljam.com/discussion/217259/perfect-pj-bootleg-finder-excel-sheet#latest
    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 ---- http://imgur.com/a/nk0s7
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    FrankieG said:

    I did this awhile ago, but definitely room for improvement. Brute force excel method is very slow: http://community.pearljam.com/discussion/217259/perfect-pj-bootleg-finder-excel-sheet#latest

    That looks cool! I'll try to work with the matrix tomorrow.
  • Options
    FrankieGFrankieG Abingdon MD Posts: 9,095
    BHealy said:

    FrankieG said:

    I did this awhile ago, but definitely room for improvement. Brute force excel method is very slow: http://community.pearljam.com/discussion/217259/perfect-pj-bootleg-finder-excel-sheet#latest

    That looks cool! I'll try to work with the matrix tomorrow.
    I'm not sure if it's even in my dropbox still haha. Send me a PM if you can't download it. Also let me know if you need any help with it, feel free to modify/use my sheet as a starting point.
    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 ---- http://imgur.com/a/nk0s7
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    I downloaded the matrix of songs but I think my computer is crashing, and excel doesn't work right...Yikes! It sounds like its "moaning"!! The CPU is making this intermittent heavy breathing sound. I restarted it a few times, and had to run the data recovery thing. It still not working right....I've got everything backed up at least.
  • Options
    FrankieGFrankieG Abingdon MD Posts: 9,095
    Uh oh... It's not worth it to crash your computer..
    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 ---- http://imgur.com/a/nk0s7
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    I think it was an update that got pushed through and messed it up. It actually seems better now.
  • Options
    RoelandRoeland Posts: 177
    BHealy said:

    FrankY59 said:

    BHealy said:

    I run statistics analyses at work, and I had thought about running something like a "cluster analysis" that would show (visually) how similar/different each set list is from others. That would help you pick a few bootlegs from each tour that were different from each other.....it would take a bit of work to set it up though..I don't know if it would be helpful or not.

    I love math. How can I help?!

    I need to get all the songs in a matrix with the shows listed along one axis, and all the songs along the other axis and a "0" or "1" to signify whether the song was played or not at that show. That's what been holding me back!
    Here you go :): http://www.pjdb.net/grid.php

    FrankieG said:

    I did this awhile ago, but definitely room for improvement. Brute force excel method is very slow: http://community.pearljam.com/discussion/217259/perfect-pj-bootleg-finder-excel-sheet#latest

    Check my post in that thread, you can do that easily and almost instanteneously through a pivot table. You're trying to reinvent the wheel now which makes Excel very slow.
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    Thanks! I got a zero/1 grid from Paranoidboy, and I'll work with it this weekend, assuming my computer doesn't take a crap again.
  • Options
    BHealyBHealy Flagstaff, Arizona Posts: 466
    Sorry I haven't had a chance to work on this guys, I haven't forgotten.
Sign In or Register to comment.