The world is a funny place, no soon as you've found your perfect product, the manufacturer has found a way to make it cheaper and probably worse and eventually the shop stops selling it. This is the sad story of my constant quest to keep myself furnished in Travel mugs. If you've not read my previous editorial on the key constituents of a more »
"You only know what you know how to google" - Martin Childs, 2016 This post was supposed to be about how create a custom Excel VBA function, the origination of the idea was despite my lifelong career of tinkering with excel I'd never come across or had the requirement to have a function cycle through the cell you input as a range to perform a more »
Faster printing over the network from word 34mb print spool to 4mb if pdf from a 26page document graph image word doc. Transmission speeds weren't any faster but took loads less time beacause of the reduced file more »
It's not often I'm partial to having sweets and it is safe to say that I am more of a savory person. So much so Cherry lips Foam bananas Haribo fangtastics Fizzy Cherry cola bottles Haribo tangy monsters - Apple flavour Giant more »
Unlike at any of the Manchester Airport terminals where they are firmly intent on extracting the most money out of you as possible, Heathrow actually fare a little better - they advertise the locations on their airport plans. Actually I'm coming to realise the whole Manchester experience is pretty rubbish - crap food outlets, broken water more »
There are some things that aren't easy to do in SQL as you'd like. I don't know why it has to make the seemingly simple things to complete in Excel so annoyingly tricky. Dynamic pivots is one of those things that is overcomplicated, sure there's plenty of tutorials on the t'internet , but what they all seem to lack is instructions of how to write more »
Whilst we were out in Tanzania on Safari something wasn't quite adding up, every night at the hotels there was several Lamb dishes to be found on the menu. The thing was vexing me was that despite being in the country for nearly a week and spending at least eight hours a day driving through various types of countryside I'd yet to lay eyes on more »
As much as I love Excel there are some circumstances where it just doesn't cut it - more than a millions rows and computer says no; some rediculouse vlookup and you could be there for hours. So step in SQL, it can do those aforementioned tasks in a matter of seconds. There are a couple of occasions though where SQL is not king, one of these is more »
One of the common themes of the computer industry is to try to install a load of bloat on your computer under the guise of making it easier for you, well when I first got my Dell E310dw and had a flick through the setup guide to head off any such shinangans I noticed they had some sort of 'universal' installer. Trying not to fall for that I more »