Geeky Corner

This won’t appeal to many folks but just in case you’ve ever been excited by the NHS Code to Grouper spreadsheet and would like to squeeze that and the PbR tariff information spreadsheet onto your iPhone, I’ve written up a review of the NHS Reference or NHSRef iPhone app over on my NHS Excel...
Read more »

Waterfall charts have become all the rage in the office of late. They are popping up all over. I suppose it is no surprise, it’s springtime and we are well into the planning process and a waterfall chart is the perfect way to demonstrate how a starting position either increases or decreases through a...
Read more »

If you work with spreadsheets that are regularly being updated and amended by multiple users then you will know something about version control. If you then add to this mix, the need to periodically distribute the updated spreadsheet for public viewing you will be more than well aware that Microsoft Excel isn’t really designed...
Read more »

I think I’ve arrived late to the party but I’ve just stumbled upon a brilliant piece of software that can actually give Sporttracks a run for it’s money. TrailRunner is a superb piece of kit that acts as a standard GPS enabled training log but with added mapping and routing wizardry. I haven’t had...
Read more »

I’ve been running with my iPhone for a couple of years and I think I have now got a fairly stable armory of running or health related apps that I would be prepared to recommend. I’ll split them into 4 sections and go from there. The Running Logs The iPhone is my ever present...
Read more »

Crossing the line at the end of the Great North run I felt elated, 10 mins later I was sick and feverish. Any fitness I had in September disappeared over the next 5 weeks as I feebly battled a chest infection. Now that I’ve more or less cleared my chest and started venturing back...
Read more »

Excel to CrossTabI often find myself struggling to deal with data that has been rendered almost unusable by the data provider who has converted it to a cross tab format. Usually they think they are helping and have probably started with a nice flat list then spent ages formatting it so the data spreads...
Read more »

How to create a custom search folder in Microsoft Outlook 2007 that shows mail categorised in more than one specified category. A combined category search folder using the logical AND rather than the OR operator.
Read more »

I’m moving to a new job soon and wanted to take the opportunity to set up the new email system in line with GTD (Getting Things Done) methodology. Here’s my checklist for setting up the new system on Outlook 2007. Most tips and code are taken from Simon Guest over at Simon Says but I’ve amended...
Read more »

The blog post sounds a little Darwinian but I’m afraid it’s just a dull selection of VBA code that enables you to sort one array on the basis of values from another. A double sorting array. I’ve amended array sorting code from John Walkenbach and Anthony’s VBA Tutorials to create something I can understand....
Read more »