icon_340

Using Word to extract email addresses

Most of my day using Office is firmly inside Excel – numbers, graphs and all that – splendid it is too. However recently I’ve found myself needing to extract specific text from pages and pages of other information – be that from PDFs, other Word files or even from information copy/pasted from web pages. I’ve…

Surface area to volume ratio - why penguins are so large

Weight loss challenge 2014

I’ve been about 15 stone (yes 15!!) for at least the past 10 years – with a waist line that has steadily expanded to 38″, and at only 5’7″ that equals “very overweight”, “obese” and at 42 years old – “sad, fat old man”…. So, enter the 2014 weight loss challenge. Last year I got…

json_school

Getting data from My Local School (JSON and Excel)

My Local School is useful if you want to look at a particular school in detail, but what the site explicitly does not do is allow you to compare schools or to extract the data so that you can on process it (with some Excel-fu). Fortunately, the site is standards based and uses JSON to pull…

UK_molly

Armed forces spending predicts Eurovision success

I love data and I love Eurovision, so after the heights of last night I’ve turned to numbers to try and understand why. As you can see, the UK has had a difficult ride in recent years in Eurovision – up to 1998 we were consistently in the top half of the leader board –…