NHS Excel

Today I am processing data from a patient level costing system (PLiCS) and trying to assess the cost distribution by the patients diagnosis.

pivot histogram patient-level-costing

Since we’ve moved to excel 2010 with its expanded data range the tendency has been to create ever more detailed reports. Where once we summarised data we can now leave in every last bit of detail.

pivot file-size

There is a division in the office between the have’s and the have nots. Those that have taken the brave leap into the unknown and upgraded to Excel 2007 (or even Excel 2010) and those that are resolutely sticking to...

pivot compatability-mode

I’ve been tasked with downloading regular data updates from a national reporting website but as this website has user log-in functionality. This means I have to set the macro up to open the webpage and then automatically enter the user...

macro website-log-in

code-to-group iphone-app nhsref