2012 in numbers

Just a tote of various personal numbers and statistics from last year. Could really do with being an infographic, maybe later.


Weight change
+6 Kg

Distance walked or run (exercise)
385 miles
(164 miles in 2011)

Distance travelled by car
8197 miles (5803 miles approx in 2011)

Petrol Spend
£1014.85 - 758 litres
(£724.00 in 2011)

Foot/car ratio
1:21
(1:35 in 2011)

Distance flown
2876 miles

CO2 emissions from travel
1587 Kg
(Air - @0.21 Kg/mile; Road - @0.115 Kg/mile; Foot - @0.105 Kg/mile)

Change in wealth
+£6393.93
(+£5389.49 in 2011)

Stocks & Shares change
+9.58%

Gigs attended
20
(15 in 2011)

Gigs played
1
(nil in 2011)

Songs recorded
3

Programming, markup and scripting languages used
8 (Java, Javascript, Python, html, php, SQL, R, CSS)

Xbox games completed
7

Websites created
4

Website unique visitors
13600

Items knitted or crocheted
5

Starbucks and lower prices

I had this idea the other day over lunch, a frothing at the mouth libertarian Ayn Rand kind of thought about multinational companies and tax, and the sanction of the victim.

The idea was that Starbucks, instead of giving the government a voluntary donation of £10 million, should instead reduce their prices by whatever the amount that they are being accused of avoiding. So the money stays in their customers pockets and the HMRC, the taxman is cut out of the equation. I thought it was a fine idea.

Besides, don't businesses usually expect something in return when they give the government voluntary donations? It seems a bit corrupt if you ask me, there should be no place for it in government.

Elsewhere, a Times journalist called Alexi Mostrous claimed that it was "One Reuters story reut.rs/Xcs29h yields £10m to UK taxpayer..." somehow equating paying money to the tax man was the same as paying money to the taxpayer. I had a bit of a rant at him, the taxpayer is the complete opposite of the taxman. Alexi has it completely the wrong way round, money that goes to the taxman is explicitly not the taxpayers, it ceases to be the taxpayer's money as soon as it is paid. That's what tax is, money that no longer belongs to the taxpayer.

Anyhoo, cast your mind back to my second paragraph, maybe this is what businesses already do, they keep their prices as low as possible, to keep money in people's pockets as any excess money, profits, would go to the taxman, and thus be of no use to the business.

Businesses strive for perfect balance between prices, turnover, profits and tax. If any of these things chance then the business becomes unbalanced.

Anyhoo, just to very carefully remove any doubt from the reader's mind, I believe that businesses (and people) should pay the exact amount of tax they owe, and not a penny more, nor a penny less.

And there hangs a problem.

For personal banking I don't have an ISA savings account, I just have a regular savings account. So I pay tax on any interest I receive. If I moved my money into an ISA then I could avoid some tax, but that would be morally wrong.

I have a free choice here, and I choose to pay all the tax that I owe.

The neverending awesomeness of Indiepop Eyespy

Days have past, hundreds have died elsewhere in the world, but still I keep on hammering away at my keyboard. I keep on pushing, keep on fighting for something I believe in, something I've fought for for years, and that is Indie Eyespy.

Here try this
London Indiepop Eyespy

What you've got there may look pretty basic, but under the hood I've pushed the envelope of my skills. Its got html, JavaScript, php and MySQL.

It even looks pretty good when you view the source.

The list of bands and band members comes from a database that's 5 Normal Form, so the same person can be worth more points depending on what band they're in.

Now I just need to add a few more bands, and use the magic of CSS3 to make it look pretty.

And also do something slightly different for dealing with scenesters, promoters and DJs who aren't necessarily in any bands.

And then maybe I can work on adding a highscore table, and maybe a page to add new bands and band members, and then a special thing that looks up how many listeners each band has on last.fm and splits them into divisions based on how popular they are.

Order of the day

I've given some thought to what order to have the bands on the London Indiepop Eyespy website, this is another form over function problem.

Its got to be easy to use, easy to find the scensters that users want to claim points for.

This suggests alphabetical order for all the bands. This wouldn't be a problem if there were only two pages of bands. But if we're listing band members, that would be less than ten bands in total.

Besides, from my experience with the Skilmo site, people don't really want to work through a long list of bands, it puts people off using the site, their attention wanders and I've lost a scenester.

Back in the dusty days of Glasgow Indie Eyespy, the hundred or so bands of the Glasgow indie scene were split into about half a dozen divisions based on popularity, so in the premiership you'd find Franz Ferdinand, the Belles, the Obscuras, the Mogwai, in the first division you'd find the Felt Tips, The Plimptons, Wake The President etc. Scenesters could intuitively know where to look for the bands.

Which divisions the bands were in was a carefully calculated algorithm based on last.fm, technorati and MySpace data, but those vectors aren't really appropriate this decade for the twenty or so London Indiepop bands.

Sure I could work out some kind of popularity rankings, but having bands in divisions doesn't look nice if all the band members are listed. Alternatively, the site could list the bands and then expand to list the members once you've clicked on the name, but that's not very satisfactory.

I'm having real doubts about the viability of the website at this stage, I can't envisage people using it.

Doubts aside, if we look at the sort of sites I'm hoping to ape, like Last.fm and Songkick, they don't have alphabetical lists of bands, they intuitively know what band names you want to see, they don't have lists that you have to wade through.

So, with the tools I have available, what would Phil Cowans and Gideon Bullock do? What would Russ Garrett do?

​Something like this?

Getting all Fifth Normal Form on your ass

I've been reading up on database normalisation and thinking about how the London Indiepop Eyespy website would work.

Data normalisation is incredibly interesting, but not quite as important as what the site looks like, form dictates function here.

In the original pub game of indie eyespy, you'd spot a band member then look up how many point they are worth.

There's Stuart Murdoch from Belle and Sebastian, four points!

As many of the bands are quite obscure, it would be less likely that you'd know the names of band members, but you could still get points for identifying the person.
There's wassisname the drummer from Camera Obscura, would be worth the same as correctly remembering his name was Lee. Although, if playing indie eyespy competitively with friends, the person who get his name would claim the points.

So here we have the dilema for a website, what should it list:-

• Check boxes for each band member by name for each band
• Check boxes for numbered members for each band
• Text box for number of members spotted and leave the rest to banter

With the limitless possibilities of computing power, I'm tempted to go for option one, and make life easier for folk who can't remember names

As bands evolved and lineups changed so did the way points were allocated, for example spotting Gav from Camera Obscura would get you three points, but if you instead noted it was Gav the bass player from Stabiliser, it would be five points. However, you couldn't then claim eight points for identifying him as playing in both bands. You only get points for one person once.

So the website would need a way of dealing with the same person in many bands.

With the Skilmo website, this sort of problem was easily resolved when it processed the checklist page, each skill was only logged once, for example tunisian crochet only counted once if you clicked it in both the textile arts category and the crochet category because the program ignored categories when logging stuff.

But with indie eyespy, because of the different points values this isn't possible, and rather awesomely, this is precisely in what 5th Normal Form is about in database normalisation theory.

On the database side of things I'd need three tables:-

• List of people and their nominal point values
• List of bands and their points values
• List of which people are in which bands

Then every time the website is accessed a list is constructed by SQL of bands and their members and points values.

Then with PHP an html page is generated which displays this list, with form checkboxes and also generates so neat JavaScript which greys out people who play in different bands when you select them.

Then submitting this form should post a list of people and their points values.

The next page would get a list of the people in the database, and run through the posted data, tote up the score, and log the score.

That seems to work in my head.

Of course the list of names will be normalised with id numbers to cover for there being more than one person with the same name, and same with the list of bands.

The list of bands also needs a status column for whether a band is currently active, on haitus or split up. Cos, of course, active bands are worth more points than bands that are on haitus, but not as much as a band who split up in 1989.

And the list of which people are in which bands needs a column indicating former band members. Because, as I'm sure you understand, spotting the original guitarist from Pocketbooks is worth more points than the current guitarist.

The mind-boggling complexity of a London Indiepop Eyespy Website

After the frankly unremarkable failure of my last website, despite our best efforts, I'm unable to persuade people to sign up, I've decided to devote my labours towards creating a dynamic London Indie Eyepsy website.

I don't need to remind you that the basics of London Indiepop Eyespy involve awarding yourself point for spotting well-known Indiepop music scene people at gigs and concerts in London.

At first I figured it would just be a static list of bands and scenesters with check boxes and I could re-use the old php code from my skilmo website. I know where I am with php and a nice MySQL table.

But the more I think about it, the more mind-boggling it gets.

Part of the joy of the original game was that extra points could be gains using various multipliers, for example you get extra points if the person you've spotted is wearing a hipster stripy top, or if they're shopping in Lidl, or double points if you assault, sleep with or have sex with the spyee. There could be different point value for people depending on which band you identify the spyee with, for example, Dan Chapman from Pocketbooks may only be worth 2 points, but Dan Chapman from Hot Booth would be worth 5 points.

So, to do a dynamic check-list where extra lines appear for checking off several band members, or with the stripy top and sleeping with multipliers as more check boxes or radio buttons  this would use JavaScript, which looks straightforward. I've never used JavaScript before, but after a cursory glance at online tutorials it doesn't seem too challenging. A little challenging maybe, but not too much.

However, my mind boggles when I try to figure out how to create a webpage that behaves correctly with Dan Chapman. How do I make it so if you claim your points for seeing him in stripy top as Pocketbooks bass player, you then can't claim points for him as Knickers bass player, or Hot Booth, One Fathom Down. I'm going to need to use php to generate JavaScript that creates check boxes that behave as radio buttons across almost the entire length of the page.

Or maybe the check boxes remain as check boxes but become greyed out when you chose one or other of them.

Then again, maybe starting with a list of bands and scenesters is the wrong start point, and instead the site relies on a list of people, and their band affiliations is on a separate table.

I'm uncomfortable with this.

Even back in the pre-London days of Glasgow Indie Eyespy,  where the scene was much richer and more diverse, the game was pretty much a stalkers charter, where the proximity of creepiness and fun on the indie eyespy spectrum could be easily laughed off or obscured. In London Indie Eyespy, the scene is different, whilst Dan Chapman is a ubiquitous figure in the scene and a great example a few paragraphs above, actually mapping all the bands that various people called Emma are in so that anyone can stalk them in supermarkets makes me uncomfortable.

Imagine, if you will, that I recreated Facebook, not all of it, but your Facebook newsfeed and that of most of your friends, and I did without any input from you. Its clearly at the wrong end of the creepy/fun indie eyespy spectrum.

And so likewise creating a list of people and then mapping with bands they're in, and have previously been in, thats still drifting towards the awkward end of the spectrum. Especially on the lowest levels where playing on stage at The Wilmington Arms is a small step from playing in your bedroom.

Very easily someone could take it the wrong way and demand their details to be removed from the site. There's no way to take into account people's desire for privacy if you're starting from individuals rather than starting with bands.

Back in the early days of Last.fm and Songkick, there was correspondence online of bands complaining that they were listed on the sites despite having not signed up themselves, and it had to be patiently explained that if you're in a band with music to be listened to, then the listening experience belongs to the listener, whoever they maybe.

With Indiepop Eyespy, getting points for spotting Dan from Pocketbooks is one thing, but getting points for spotting Sandy in the supermarket is another matter entirely.

I was at a gig the other night, at Power Lunches, and I saw Katesby, she's a popular scenester. We go back a long way, about 420 miles and half a dozen years, but being a shy sort of chap, I didn't say hi or anything, I just lurked in a corner listening to the bands on stage and concentraing intently on my Samsung Galaxy S3 LTE. I just didn't feel comfortable saying hi, I don't think she saw me.

Maybe that makes me anti-social and a little bit creepy, or maybe its an inherent character trait that's made me the man I am today. Its the same thing I referred to the first paragraph of this blogpost, and its the inherent fallacy in constructing a London Indiepop Eyespy website.

Never the less, I'll have to go and read up and fifth normal form database normalization and see what works.

Your vote counts

So I've been working hard on my awesome internet startup websitey thing, adding new functionality and cool stuff.

I've now got pages for each photo that's been uploaded for each skill and you can upvote and downvote photos just like on Reddit. And its' kind of neat too cos on the left side of each photo it shows the top votes photos from the same person and other top voted photos for that skill.

So say you uploaded a photo of some awesome piece of knitting you'd done, and some awesome photo of an awesome bit of chainsaw carving you'd done, and an awesome photo of you looking awesome playing bass guitar in some band you were in five years ago. Then when folk were looking at your knitting photo, on the right there'd be pictures of other people's knitting and on the left would be photos of your other awesomey things.

The main problem with this cool websitey thing, is that I'm the only person to have uploaded any photos of anything so its just me gurning and things I've knitted out of Sainsburys carrier bags over the last five years.

Still, the website is here, anyone can sign up and upload photos, please do, cos I'm not quite sure if it works right.

To register on the site, you'll need to go to this page, check off some of the crafts, hobbies and skills what you can do, then come up with some user name, then from your profile page you'll be able to upload photos and stuff.

Let me know if you have any problems, if for some reason you get logged out randomly, and if you have a retina display device, let me know what it all looks like.

Cheers