Latest Story

NHS Excel website expands

April 15, 2012
By

I’ve added a number of excel tutorials to the NHS Excel website and this will become the home for most of my excel related content.

It’s been a busy month at work due to year end and the agreement of balances exercise but its been interesting from an excel point of view. We’ve had to work across a departments and this has thrown up a number of issues, not least of which has been the problem of people using different versions of excel to work on a single workbook. This month I’ve written a tutorial explaining how to force Excel 2007 to work in compatibility mode so that you can create pivot tables that work in earlier versions of excel.

I’ve also written some VBA code to automate log-ins to password protected websites. The idea of this is to use in conjunction with a website query to download data from a central NHS website to a spreadsheet on a regular basis.

Topics: Excel, Geeky Corner | No Comments »

Spring Construction on the Plot

April 15, 2012
By
Spring Construction on the Plot

It’s been a warm dry spring so far and we’ve made the most of the weather down on the plot, getting suitably hot and bothered. I’ve posted an update on the earthwoman blog detailing the ongoing struggle I have with the blasted M1 Gardener...
Read more »

Costing Patient Spells using the NHS Ref iPhone App

January 30, 2012
By
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...
Read more »

Assembling a Campagnolo Frictional Gear Shifter

September 18, 2011
By
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...
Read more »

Restoring a Classic Bike

September 10, 2011
By
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...
Read more »

The Square One Tavern Plan

September 2, 2011
By
The Square One Tavern Plan

My enforced rest from running was initiated by a trip to a pub. Me and my good lady gathered around a couple of pints of Wandle, pulled out the Moleskin and jotted down a recovery plan to rid me of plantar fasciitis for good...
Read more »

Eat Food, Not Too Much, Mostly Plants

September 1, 2011
By
Eat Food, Not Too Much, Mostly Plants

I’ve spent a good proportion of the bank holiday reading about food and quite specifically how to eat food. I started with the seriously irritating Allen Carr and his Easyweigh to Lose Weight. I’ve read this once before and threw it out in disgust...
Read more »

The Stick and Other Methods of Torture

August 21, 2011
By
The Stick and Other Methods of Torture

I’ve been using The Stick ever since I suffered with a painful muscular injury to my hamstrings. It has a very simple design – a slightly flexible plastic stick around which a set of plastic spindles can independently rotate. It is these spindles that...
Read more »

Roasted Sweet Beetroot Relish

August 21, 2011
By
Roasted Sweet Beetroot Relish

The plot and the hedgerows are so productive at the moment. It seems about two months too early but the sloes are already plump and juicy. I’ve just had to polish of the last remaining drop of slow gin from last year so that...
Read more »

Pool Running for the Injured

August 21, 2011
By
Pool Running for the Injured

The enforced running respite has resulted in a very slight improvement to my plantar fasciitis pain so I’m motivated to keep up with the recommendations from my podiatrist. I’ve stuck to the stretches, swapped the running with cycling and been wearing the temporary insoles...
Read more »

A Guilty Harvest

August 8, 2011
By
A Guilty Harvest

It’s been an incredibly productive season. Today we bagged up 3 sacks of assorted spuds and loaded the car boot with beans galore. It all feels vaguely sinful. The freezer is bulging, I’ve cooked dishes to last a week, I have beetroot roasting for...
Read more »

flickr rss

What I'm Doing...

Posting tweet...

Ads



Reading List