Samstag, 24. Oktober 2015

Market Research: Shoes & Footwear - Results & Findings

It was time to get me a pair of new shoes. As always it was a long process to find the best solution. First there are my own needs. My personal list of problems my shoes have to solve in their life is the basis. Then a thorough market research has to be made. There are thousands if not  millions  of models  and types of shoes which have to be taken into account here! And then there are blue Vans Sk8-High...



Freitag, 23. Oktober 2015

38.224 lines of Music as txt

I like to listen to music and I like to track everything. That's why I now have 38.224 lines in a txt file representing the music I listened to over the last 22 month and it's also why most of my friends think I'm kind of weird.

Here's how:
The basic is Spotify as my streaming music service of choice. Spotify allows you to scrobble all the music you've listened to over to You'll find that somewhere in your spotify settings.
Now to collect all this data for myself, to play around with it and get happy, I needed my own list. Using an IFTTT recipe, everytime a new 'scrobble' was made at, a line was added to a google spreadsheet. Unfortunately google somehow added a new file every 2000 lines so that I decided today to tinker all those files into one txt file and to change the IFTTT recipe to dropbox (Here's the recipe). While I'm writing this, the recipe creates a second file in dropbox too...

Here's what:
Having all those lines of pure music data as a txt file, you can easily import it into your spreadsheed.
Using a little pivot table I found out that I've been listening to 2212 different artists, Alt-J at first place, followed by Turbostaat:

My most-played song over the last 22 month was All Opportunities by Solander.
I didn't even realize that It's On is a song of both Broncho and Pins:

What I double checked is this chart: it shows songs played per day. And there are days when I listened to more than 200 songs:

By hour of day:

Now I could cluster artists by hour... or day of week ... or I could go outside, enjoy the sun, have some coffee ...

Samstag, 10. Oktober 2015

Sorting my apps...

So the first train was late and I missed the next connection. Made the most out of it and color sorted all the apps.