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

Options
otter
otter Posts: 772
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

  • FoxyRedLa
    FoxyRedLa 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.
  • RS151862
    RS151862 Pittsburgh, PA Posts: 2,725
    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 • Baltimore 2024 • Pittsburgh I & II 2025

  • FoxyRedLa
    FoxyRedLa 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.
  • RS151862
    RS151862 Pittsburgh, PA Posts: 2,725
    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 • Baltimore 2024 • Pittsburgh I & II 2025

  • otter
    otter Posts: 772
    sweet! Thanks!
    I found my place......and it's alright
  • otter
    otter Posts: 772
    I Can't get it to work. I can't get past select a song
    I found my place......and it's alright
  • RS151862
    RS151862 Pittsburgh, PA Posts: 2,725
    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 • Baltimore 2024 • Pittsburgh I & II 2025

  • BHealy
    BHealy 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.
  • otter
    otter Posts: 772
    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
  • otter
    otter Posts: 772
    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
  • otter
    otter Posts: 772
    Got it working. Thanks mr burgundy

    Listed 11 songs and best outcome had 6

    I found my place......and it's alright
  • FrankY59
    FrankY59 Posts: 1,052
    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?!

  • BHealy
    BHealy 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!
  • ParanoidBoy
    ParanoidBoy 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.
  • ParanoidBoy
    ParanoidBoy Posts: 22
    PM sent
  • BHealy
    BHealy 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!!
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    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
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • BHealy
    BHealy 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.
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    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
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • BHealy
    BHealy 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.
  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    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
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • BHealy
    BHealy Flagstaff, Arizona Posts: 466
    I think it was an update that got pushed through and messed it up. It actually seems better now.
  • Roeland
    Roeland 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.
  • BHealy
    BHealy 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.
  • BHealy
    BHealy Flagstaff, Arizona Posts: 466
    Sorry I haven't had a chance to work on this guys, I haven't forgotten.

Categories