Costing Patient Spells using the NHS Ref iPhone App Thumbnail

Costing Patient Spells using the NHS Ref iPhone App

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 blog. [...]

iPhone

Assembling a Campagnolo Frictional Gear Shifter Thumbnail

Assembling a Campagnolo Frictional Gear Shifter

I had a slight moment of panic when I recieved in the post a set of vintage Campagnolo C Record downtube shifters for the Walvale classic bike restoration. They came in no less than 18 teeny pieces and as they were vintage they didn't come with an easy to follow assembly instruction manual. After 15 [...]

Classic Bike Restoration

Restoring a Classic Bike Thumbnail

Restoring a Classic Bike

My new project arrived in a box last night. It's a thing of beauty but is destined to cause cursing and consternation in the household. I'm not known for my mechanical skills but I am known for flitting from one project to the next with only a book for guidance. The book didn't help me [...]

Classic Bike Restoration

Waterfall Charts and the X-Axis Thumbnail

Waterfall Charts and the X-Axis

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 series [...]

Excel Tutorial

Managing Version Control in Excel using Macros Thumbnail

Managing Version Control in Excel using Macros

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 to [...]

Excel Tutorial

Excel Pivot Table or CrossTab to Flat List Thumbnail

Excel Pivot Table or CrossTab to Flat List

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 out [...]

Excel Tutorial

Sunglasses and Summer Biker Gear Thumbnail

Sunglasses and Summer Biker Gear

If I don't have to use my heated grips in the morning then it is just too darn hot for biking. What possesses these fair weather bikers to dust off their machines just in time to roast in the heat wave? I've seen varied summer fashions, from the Ducati guy with shorts and t-shirt to [...]

Motorbike

Commuting Reconnaissance Trip Thumbnail

Commuting Reconnaissance Trip

I hope something out of the ordinary happened today because I couldn’t move. I was trapped in maelstrom of push bikes, cars and jackknifed buses. Bikes were crammed into every available gap, going nowhere but making an ugly disheveled plug. Others were hopping up on to the pavements looking for escape. I was sat behind [...]

Motorbike