Saturday 07/09/2011 by tmwsiy

SIM-BOP & BE-BOPHONE, ALL THESE LINKS ARE GRAND!... "THE SPREADSHEET"

Most Phish fans can be categorized into two groups. One that has 'The Spreadsheet' in their browser bookmark bar and the other that is yet to experience the "Holy Shit!" moment when they discover it for the first time. A labor of love & dedication, the Spreadsheet is one of the definitive sources for Phish MP3's and catalogs every known circulating show since 1983. A mere utterance of the term, "The Spreadsheet", and most fans instantly know that you are talking about Kevin Hoy's Google Doc. But how did this amazing resource come about? And who is Kevin?

I spent some time recently asking Kevin all about the Spreadsheet.

Thanks so much for taking the time to answer some questions, before we get into the nuts & bolts, tell me a little bit about yourself. How long have you been listening to Phish, what got you interested in them, where are you from, and all the jazz.

Well, I was born and raised in Milwaukee, WI, and other than a 4 year stint at the University of Dayton (in Dayton, OH), I have lived my entire life here in Milwaukee. My wife, Maggie, and I currently live in the suburb of Glendale with our cat, Monkey, and new puppy, Rubicon. As for my first Phish experience or what got me into Phish, that came in 6th or 7th grade, which was around 1994. A friend of mine had made me a copy of a mix tape that his older brother had given him, and on it was the studio versions of both Down with Disease and Golgi Apparatus. Sidenote: the rest of the tape was filled with the likes of Regulators (Warren G), Fatastic Voyage (Coolio), Lodi Dodi (Snoop), and Cantaloop (Flip Fantasia) (Us3). From there, it took me until the beginning of high school to really figure out what this band was all about. By this point A Live One had come out, and I was listening to it constantly. I quickly found a group of kids at school that were heavily into tape trading and I just thought it was the most amazing hobby in the world. I quickly became obsessed with it and would spend countless hours/days/weeks tracking down tapes that I didn’t have (either through friends or B&Ps). It’s bringing back great memories just thinking about it, actually.


How did the Spreadsheet come about?

Actually, the genesis of the Spreadsheet can be directly tied back to one man: Scott Marks (Bizzaro Jerry on PT, currently @bizarchive on Twitter). Back in late 2007 or early 2008, Scott had a series of threads on PT called “Bizarro’s Phish Thread.” In these threads, he would go through his entire Phish collection and post mediafire links to his personal archive of shows, in chronological order. In the years since my tape trading days, I had obviously adapted to the digital world and had a pretty good collection of my own at the time (around 400 shows), but this thread was the Holy Grail!! I was grabbing early shows like it was my job when Scott first started this. Anyways, there was talk in one of these threads about creating a better way to house all of the links. As most will remember, the PT search and archiving tools were a little lacking back then, so as these threads went on, it was becoming increasingly difficult to find a specific show. It was mentioned that a shared Google Doc may be the way to go and that someone should work on getting that set up. Google Docs was pretty new at this point, so after reading that post, I decided to do some investigating. After emailing with Scott and getting his nod of approval, I started putting together a very rudimentary version of what the Spreadsheet is today. Scott and I had a great thing going at this point...he was uploading his shows in chronological order from the beginning and I started uploading my shows, starting in 2000 and worked backwards. At a certain point, Scott started working on a major setlist overhaul project for Phish.net and I eventually took over the Spreadsheet maintenance by myself.

What is your process for adding links/updating? How do you determine which sources to add?

When I was going through it all initially, I re-downloaded everything from the shnfamily hub in lossless format (prior to this, the majority of my collection was in mp3 format). I did my absolute best to get the best possible sounding source of each show. I would compare the different sources myself and look at the comments for each source on etree.org to come up with a final decision. I can’t say that it’s 100% perfect, but I definitely did my research, as best I could, to get only the best possible sources added.

I try my best to keep up with new/upgraded sources that surface, but it seems to be a never-ending battle. I also rely heavily on the users of the spreadsheet to let me know when there is a better source out there, when links are dead, when something isn’t properly labeled, etc. You have no idea the amount of emails I get every day regarding the Spreadsheet, and I don’t mean that in a bad way at all. I love reading the thoughts, ideas, praise and even the complaints from time to time...

Do you keep copies of everything you upload? How much storage space to have devoted to Phish?

I do...all in lossless format too. I currently have about 1.8 TB of Phish audio stored on my hard drive.

How much of your downloads to you listen to?

A lot...I am as obsessed with listening to Phish as I am collecting it. Why else would you have it all, right? I try to listen to entire shows from start to finish rather than just random tracks. I guess I am purist in that respect. I’d say I listen to about 4-5 complete shows per week. About a year ago, I started tracking all the shows that I listen to, along with any highlights from every show, and keep it all in another spreadsheet. The goal is to listen to everything, literally everything that circulates, and have my own little bible of all the setlists and my highlights. Something to pass down to the kids, right? (laughs)

How quick is your goal to get recent shows up on sheet? A couple days? Week? Do you take first source up or wait for known quality tapers?

The goal is to have them up the very next day, assuming I am not on tour. Most of the time this happens, but sometimes, you know, life gets in the way... I usually look for the most downloaded source from etree and use that one. However, I will upgrade the source if I am made aware of a better source out there afterwards.

How many shows are now indexed on your sheet?

At this moment in time there are:
1,319 Phish shows
276 Trey shows
143 Mike shows
27 Page shows
58 Fishman shows
22 From the Archives shows
77 remastered shows

Of the missing shows that no known sources exist, are there any in particular that you have your fingers crossed for that will surface some day and be part of the Spreadsheet?

Well, I’d love to see the few years that are missing 1 or 2 shows get completed...that would be 1993, 1995 and 1999.

The shows missing, that I’d love to see circulate are:

3/8/93 - the only “regular” post-1992 show that doesn’t circulate, as far as I know (Sante Fe, New Mexico)
5/14/95 - at Fishman’s house...would love to hear that one
6/24/99 - the infamous Carreystock

Any contingency plan if MediaFire goes away?

Not really, no. Scary, huh?

How much time to you spend on average per week on maintaining? Are there others that help?

Since completing it last summer, the only real work comes when the band (or side projects) are on tour. During these times, I probably spend 5-6 hours per week downloading, comparing sources, tracking, converting and uploading. During the “off-season,” I just keep my eye out for anything new that pops up on etree, which will mostly be side projects. For example, I just added 4 new Vida Blue shows the other day.

At this point it is a solo effort, but, like I said before, I get great help/feedback from the users through email, which is greatly appreciated.

How can fans help with your efforts?

All I can say is for them to just keep doing what they are already doing. Fans have been great at contacting me when they find something that isn’t posted or when a link goes down. I really couldn’t keep it as up to date as it is without them. I suppose if everyone who used to trade tapes could dig them out of storage and make sure they don’t have anything that doesn’t currently circulate, that could yield some interesting/exciting results. But really, everyone has been great, so just keep it up!

Do you have Google Analytics and can share with us some of the interesting stats?

I don’t have Google Analytics, but Mediafire keeps some basic upload/download stats. Since March of 2008 when I created my MediafirePro account, I have uploaded 418.55 GB from 3,626 total files and there have been a total of 783,427 downloads from my account. These stats always amaze me...every time I look at them.

Tell me a little bit more about the remasters page. Are these all submitted to you or do you hunt them down?

I take zero credit for the remasters page. All remasters that have been posted have literally been delivered to my inbox and I just turn around and copy and paste them to the Spreadsheet. Big thanks to Kenny Powers, phishjam10 and Paul Shapera for the links!

How about Worcester’s sheet...do you know him? ever thought of collaborating?

I am very familiar with Worcester’s amazing Rare Material spreadsheet, and I have to admit that I have used it in the past as a source for some of the side projects shows that are on my page. Though I do not know him personally, I know the hard work and dedication that goes into something like that and I really appreciate his efforts. I don’t really see the need to collaborate the two, because they are both very different. My spreadsheet is more directed towards complete shows in audio format, while his tends to be the more obscure/rare stuff and videos that he comes across. Both serve their purpose very well, separately, and that’s what fans have grown accustomed to, so why mess with a good thing, right?

Do I remember correctly that you also have a blog detailing updates to sheet?

I do. You can find it at http://phishspreadsheet.blogspot.com/. Every time I post a new show or upgrade an existing show, I will update the blog.

What do people say to you when they find out you are “the spreadsheet guy”?

Well, I don’t really go around shows advertising that I am “the spreadsheet guy,” so, I can honestly say that I don’t have too much experience with this type of situation. I can say that fans are extremely gracious and appreciative in the comments that they send by email. In fact, I get a handful of emails every week that just say “thank you for what you do,” or something to that effect. Look, I don’t do this for the praise or the notoriety. I do it because I love being able to help a community that has giving me so much over the years. That’s enough for me.

What are a few of your favorite shows?

Oh, man...that’s always been such a hard question for me to answer. A few that come to mind immediately are:

11/22/97 Hampton
12/13/97 Albany
7/17/98 Gorge
3/13/92 Providence
12/14/95 Binghampton
8/7/93 Darien Lake

Thoughts on summer tour so far?

I’ve been really enjoying it. It’s been a slow tour for me, as I was only able to make it to the little Midwest swing (Pine Knob, Blossom, Cincy), but have listened to every note. Pine Knob and Blossom were an amazing time and I thought they were fantastic shows. Other highlights for me (from listening to the shows) have been Bethel 1 and 2, Charlotte, SBIX 3 as well as the soundchecks that have been released (Bethel, Darien, SBIX) and the amazing Storage Jam. I’m headed to all 3 UIC shows in August and really looking forward to some indoor Phish!

Any thoughts, reactions to the Phish.net blog post on taping last week?

I thought it was great! I wholeheartedly agree with the fact that AUD sources do capture the “essence” of a show a lot more than the soundboards are able to. It is for this reason that I hang on to all my AUDs of shows even after purchasing a LivePhish release. I really appreciate everything the tapers do...that takes a lot of time and dedication, much more than I spend on the Spreadsheet, and my hat is off to them. Without them, the Spreadsheet would not (could not) exist.

How about the future? Any plans for enhancements, additions, etc to the Spreadsheet above and beyond continuing to add new shows?

I’ve been thinking about somehow adding the option to download album art for each of the shows. A couple months back I went back and forth with someone who has been creating and posting some great cover art that they created over on PT. It didn’t go anywhere, at the time, but I’d love to revisit that idea in the future.

The other thing I have been thinking quite a lot about doing is adding the option to download everything in lossless format (FLAC). Now, I’ve been thinking about doing this since completing the mp3 uploads last summer and it obviously hasn’t come to fruition yet, and that’s for a couple of reasons. First of all, logistically, it would be a challenge. Obviously, lossless files are much larger than mp3s, so it would take a great deal of time and online storage space to make this happen. Currently, Mediafire only allows files under 200 MB to be downloaded by non-MediafirePro users. This would mean that a lossless show (which is usually close to 1 GB) would need to be split up into 5 separate files. So, in order to make it less of a pain to the user, I would have to start looking for a new site to move to for these shows (Megaupload would probably be the solution). `

But, the main reason why I think I haven’t started this massive undertaking, aside from the time it would take, is that I don’t want to eliminate the use of etree.org. Having been part of actual tape trading, I know that with getting a new show/tape, came interacting with people and the community. I feel like etree.org is the one last sacred place where people go to get shows while still interacting with each other, all in one place (albeit at a very minimal level when compared to actual tape trading). I feel like having a Spreadsheet of mp3s doesn’t detract from etree because they do not offer mp3s as an option, but if I went and dumped lossless copies of every show onto the Spreadsheet, that would be an entirely different story.


Thanks for the time today, Kevin, anything else you’d like to add?

Well, thanks for the opportunity! I guess I would just like to express a huge amount of thanks to Scott Marks for really getting this whole thing started. There would absolutely be no Spreadsheet without him. Also, thanks to everyone who has emailed me additions, thoughts, comments, praise, etc. I am still blown away by how gracious and giving the Phish community is...I’m just glad to be able to give back in any way possible!

------------

Want to thank Kevin for all his work? Please use comments to thank Kevin, share your story about finding the Spreadsheet the first time, suggestions, or any other comments about the sheet. Of course, should you have any of the missing shows from the Spreadsheet, don't forget to let Kevin know!

Spreadsheet

Spreadsheet Blog

email address for additions, suggestions, and praise: hoydog23@gmail.com

If you liked this blog post, one way you could "like" it is to make a donation to The Mockingbird Foundation, the sponsor of Phish.net. Support music education for children, and you just might change the world.


Comments

, comment by Abe_Froman
Abe_Froman I laughed out loud reading the first sentence. I am one of those fans, you know the kind that has the spreadsheet link first in my favorites.

It's an awesome resource, thanks to Kevin for all of his hard work. You rock dude. I'm an old tape trader, and I still love pulling out an XLII now and then, but the spreadsheet is like finding the mother lode. Thanks again.
, comment by forbin1
forbin1 great read....such a useful tool and it's always being updated...much appreciated...Thank you Kevin...
, comment by GreenerBlues
GreenerBlues Holy Shit!
, comment by safetymeeting
safetymeeting Speaking of XLII's. . .if anyone has any cassettes that are collecting dust, I'd be happy to pay for postage to have them shipped to me. :)
, comment by 2010P
2010P Great work Kevin..I've always loved the spreadsheet and wondered about the origins of it, who maintained it, and all that stuff. I of course remember those Bizarro Jerry threads, but forgot that this stemmed from that..or maybe I didn't forget, maybe I never knew. What an amazing resource for fans. I know so many people that simply don't know how, or don't want to download stuff from etree, and this fills that void. I use the Spreadsheet quite a bit, especially when I am at work and can't torrent and there's a show I want to listen to, or just a track to add to my iPod. thanks again!
, comment by ADAWGWYO
ADAWGWYO Great read. Thanks for all your hard work and dedication.

Sidenote: last I checked, the 7/8/98 partial sbd of soundcheck and set I is not yet on the spreadsheet. Just a heads up.

Peace
, comment by hoydog23
hoydog23 @ADAWGWYO said:
Great read. Thanks for all your hard work and dedication.

Sidenote: last I checked, the 7/8/98 partial sbd of soundcheck and set I is not yet on the spreadsheet. Just a heads up.

Peace
grabbing it now and will post when I can. Thanks!
, comment by bertoletdown
bertoletdown I don't believe there is a fan community remotely close to Phish's when it comes to selfless acts of sharing and obsessive archival detail. The Spreadsheet took things to a whole new level and every hardcore Phish fan will remember his or her jaw hitting the ground when we realized what this was and what it made possible.

Awesome interview. Awesome people.
, comment by AugustWest2001
AugustWest2001 thanks kevin!
, comment by PhillyAndrew
PhillyAndrew i loooove the spreadsheet!! without those marvelous links and perfect organization, i feel like i'm being spoiled. keep up the amazing work!
, comment by kipconner
kipconner There's is definitely something about the AUD recordings... it is the way it was intended to be heard- by the band and their live mix engineer. It would be my dream to have instant access to both versions. This is a great start.
, comment by AmblingAntelope1
AmblingAntelope1 HUGE thanks to kevin for all your work, you truly are making it easier and more fun to be a phish head. so cool to be able to sit at home and follow every note of a tour...keep it up brother.
, comment by cerqs
cerqs "the spreadsheet" greatest site ever! ty
, comment by Josep
Josep How do I download and open a rar file? Thanks
, comment by tmwsiy
tmwsiy Numerous programs do it, but can use:

Mac: UnRAR
http://www.unrarx.com/ />
PC: WinRAR
http://download.cnet.com/WinRAR-32-bit/3000-2250_4-10007677.html

It's just like a ZIP file but a different compression technology.
, comment by WaxBrain
WaxBrain Thanks a ton man. You are one of the most important members of this entire community for your tireless hard work to complete the Spreadsheet. It's obviously a very very important thing for me and all of us. Thanks again.
, comment by Thisisnotafish
Thisisnotafish I was reading this article when i realized "wait..i use the spreadsheet all the time..and i dont have it in my bookmark bar!"

i was totally doing it wrong.
, comment by MikeG_212
MikeG_212 Thanks Kevin! My buddy sent me the spreadsheet last september with the subject line "Phinally!!" Since then one of my favorite things to do is pick up a new show and listen from start to end (guess I'm "old school" like you). Thanks again and keep up the good work!
, comment by chadreece2001
chadreece2001 Thanks Kevin. You are a prime example of why Phish is so awesome. Yes, the band is the greatest ever, but I firmly believe that the phans are equally responsible for what makes this whole thing awesome. I salute you!!
, comment by dRStone
dRStone @GreenerBlues said:
Holy Shit!
Couldn't have said it better. Well on my way to filling up my terabyte hard drive
, comment by gankmore
gankmore I like the spreadsheet, and phishows.com, but wouldn't archive.org be a much better long term solution to this?

Seems like we could build on all this work, and have a permanent archive. It'd take Phish management a few minutes to approve this request and it'd get us out of the business of trading lossy files via mediafire.
, comment by tmwsiy
tmwsiy @gankmore said:
I like the spreadsheet, and phishows.com, but wouldn't archive.org be a much better long term solution to this?

Seems like we could build on all this work, and have a permanent archive. It'd take Phish management a few minutes to approve this request and it'd get us out of the business of trading lossy files via mediafire.
Archive.org would be great but Phish is not going to approve that. They have consciously and flatly rejected Archive hosting Phish shows for 20 years now.

I think etree is the next best thing for people that want lossless files and most shows are there. There is clearly a huge demand for mp3 files as it will not be long before the spreadsheet has served 1 Million downloads. Likewise, I hosted MP3's of the 2009 summer shows on drop.io and had 2,000-3,000 downloads per show. Not everyone has the technical ability to convert lossless files, the storage space on their drive (yes, this is true, despite decreasing costs of storage and the claim that it is "practically free" many people can't afford additional drives), or the inclination to own FLACs for a variety of reasons.

I do think Lossless files are the route to go, and encourage people to learn about them. I started a thread here to help people out with learning about torrenting: http://forum.phish.net/?thread=1309134803#start

In the interim, until Apple (which sadly many people are inexplicably wed to) decides to play nice with FLAC, and lossless becomes the standard and not the one-off, I think 'The Spreadsheet' is as close to a permanent solution as possible. In many ways, it is more permanent than even etree as torrents there die all the time with lack of seeders.

The good news is that with the birth of digital music coming at the dawn of Phishs' popularity, it is doubtful that any of the shows that have now been circulated will ever disappear into obscurity with the meticulous nature with which they have been tracked, cataloged, collected and archived across many medium, sites, and sources.

The more important thing, in my opinion, to focus on now are the shows that have never seen the light of day. Sadly, there are 'hoarders' and tapers that simply do not circulate what they have. Why? So they can be a hero and release a trove of material in 2040 like when the Betty Boards circulated? So they can listen in smug happiness knowing that they are the only ones able to listen to a particular show? Who knows what the motivation is, but it is sad when you have people like Lenny Stubbe, Jason Sobel, and Kevin Hoy busting their asses to make it all available.

Hopefully, one day too, there will be a distribution and release system from the tons of material meticulously archived by Kevin Shapiro.

, comment by makisupaman
makisupaman phishows.com is also nice
, comment by ocelotvswilson
ocelotvswilson It certainly was a "Holy shit!" moment for me. Kevin Hoy has really done a priceless favor for us all. Cannot thank him enough. You rock man!
, comment by TweeterReprise
TweeterReprise Great work, Kevin. Out of all the famous alumni to come out of MUHS, you're still tops in my book. I'll hopefully see ya at UIC. Thanks again.
, comment by forbin1
forbin1 @hoydog23 said:
@ADAWGWYO said:
Great read. Thanks for all your hard work and dedication. Sidenote: last I checked, the 7/8/98 partial sbd of soundcheck and set I is not yet on the spreadsheet. Just a heads up. Peace
grabbing it now and will post when I can. Thanks!
another sidenote: 5/7/94 bomb factory is missing set 1 on the spreadsheet as well...sorry for the inconvience...
, comment by hoydog23
hoydog23 @forbin1 said:
@hoydog23 said:
@ADAWGWYO said:
Great read. Thanks for all your hard work and dedication. Sidenote: last I checked, the 7/8/98 partial sbd of soundcheck and set I is not yet on the spreadsheet. Just a heads up. Peace
grabbing it now and will post when I can. Thanks!
another sidenote: 5/7/94 bomb factory is missing set 1 on the spreadsheet as well...sorry for the inconvience...
That's because, as shocking as it is, the only known recording of the first set is the livephish release, which I obviously can't post.
, comment by zel123
zel123 Informative analysis ! Incidentally , if you has been needing to merge PDF files , my colleagues used a service here http://goo.gl/QVKFM0
You must be logged in to post a comment.
Support Phish.net & Mbird
Fun with Setlists
Check our Phish setlists and sideshow setlists!
Phish News
Subscribe to Phish-News for exclusive info while on tour!


Phish.net

Phish.net is a non-commercial project run by Phish fans and for Phish fans under the auspices of the all-volunteer, non-profit Mockingbird Foundation.

This project serves to compile, preserve, and protect encyclopedic information about Phish and their music.

Credits | Terms Of Use | Legal | DMCA

© 1990-2024  The Mockingbird Foundation, Inc. | Hosted by Linode