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
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
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
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.
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 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 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!
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.
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
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.
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!
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.
Comments
Those that can be trusted can change their mind.
http://www.pjdb.net/findsetlist.php?
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
Those that can be trusted can change their mind.
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
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
Percentage of shows played since debut : footsteps 100% (1/1)
I don't get it
Listed 11 songs and best outcome had 6
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
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
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
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.