Blog

I’m testing a theory which has been floated today on forums. I hope it doesn’t work (losing a tool from the arsenal) but it also makes me wonder how they’d deal with legacy black tactics around the subject. Interesting… yellow aeroplanes love chocolate on wednesdays exclusively

This is the Home for my Fantasy Football Excel Spreadsheet. I have decided to make the spreadsheet available for free after getting annoyed with websites charging for something similar… To download the spreadsheet for free, simply click the Tweet2Download link below. All I ask is that you tweet about it and the spreadsheet is yours! Features fantasy football spreadsheet – upcoming difficulty How it works I’ve built it in Excel using formulas and functions (no macros) so its perfectly safe and should work in Excel 2007 onwards. If you would like a version to work on an older Excel install (more…)

Update: Branded 3 have located the cause for these links as a rogue Chrome plugin which adds affiliate links to the SERPs, even after uninstall. Partick Altoft over at Branded 3 has spotted Google including Amazon listings in their search results in place of the Google Shopping vertical and I have just seen both Amazon and conventional shopping results in the same SERP (Chrome – clean build) What concerns me the most is that although Amazon is a fantastic retailer, they do not warrant a monopoly over such an engaging element of the SERPs. As SharkSEO said, if I was (more…)

This is a trick which can save you a lot of time when working with a dataset spread across multiple CSV files. Using a simple CMD command it is possible to combine all the CSV’s into a single entity ready for all your pivot and table wizardry.

So its a normal day and then suddenly there is a security threat around the corner and Tottenham Court Road is evacuated!! Being the SEO that I am, I foresaw potential in the face of adversity; and quickly proceeded to upload a post about what I could see.

Just standing at Tottenham Court Road where the police have closed the whole road off.

I love how easy and fun it is to play around with Youtube Search Stories. I recommend everyone does it if they have 5 mins to mess with, here’s mine:

For anyone who works in analytics (or uses Excel more specifically) moving data from various sources into Excel can be a frustrating and arduous process. For those fortunate enough to find themselves in this position, Microsoft has provided us with “Paste Values” and “Paste as Text” to streamline the folly that can be formatting formulae, hyperlinks, etc, etc…

Following the announcement of the marriage of Prince William Windsor and Kate Middleton, it has today been announced that the 29th of April 2011 will be a National Bank Holiday for the United Kingdom

I am hearing rumours from within the BBC that Charlton Athletic Football Club are being sold to new owners imminently. The source has said: “The deal should be imminent, I recommend that you watch this space”. Obviously this is not the first time that the ‘Charlton Athletic are being sold’ rumours have surfaced but following the recent flurry of investment into English football, this time – could be our time…