Excel and fiscal dates

I keep having to remember the fiscal year formulae for Excel – fiscal year starts July 1, ends June 30.

Here’s my note so I can remember:

Fiscal year:  =IF(MONTH([cell])>6,YEAR([cell])+1,YEAR([cell]))

Fiscal month: ==IF(MONTH([cell])>6,MONTH([cell])-6,MONTH([cell])+6)

SLES 11 SP4 – mysql, php and sockets

Something changed in SLES 11 SP4 (or one of the very recent updates).

The default mysql.sock moved to /var/run/mysql/mysql.sock rather than the previous location in /var/lib

For some reason this meant that the defaults for PHP5 were looking for the wrong location for the socket.

A quick cleanup of /etc/php5/apache2/php.ini to include mysql.default_socket = /var/run/mysql/mysql.sock and everything is back functioning.

Photos and Menalto/Gallery Project

I have been a long time user of Gallery Project. I migrated from jAlbum in mid 2003 and migrated through G1 up to G2 with integration into WordPress.

Six years ago I made a note to really investigate the changes from Gallery 2 to Gallery 3 – I did the homework; but the change didn’t make sense for many reasons.

Last year I was saddened to see that the Gallery Project had gone into hibernation. Always sad to see an open source and community led project get shuttered.

Less photos these days; we tend to share a limited number via Facebook – but still the dilemma – what to do with the hundreds of thousands of old photos and rapidly rotting code.

Whiteboards lead to architecture lead to whitepapers

Over the past 15 years I’ve become very aware that different people take in information in very different ways. I am a visual learner as an example – so seeing diagrams, manipulating shapes on a touch screen, linking conceptual boxes together – that’s my thing. Others prefer to read and digest, others like to listen, question and engage in conversation.

I am writing a series of architecture papers – and to make sure that the concepts and intent are really landed I’m doing a lot of whiteboarding and socialising too.

Elasticity in the cloud

It’s nice to be able to turn the dial to 11 when you need something doing quickly.

Just rebuilt the thumbnails on the photo albums – it’s a CPU intensive job. Turn Azure up to 11 – more RAM, more procs – and it’s done in no time.

Comcast backbone issues

Something is broken with Comcast Business Internet.

Speed test (urg) to Comcast in Seattle gives 50/10 – as expected:

image

Speed test to Comcast in San Jose gives 50/10 as expected:

image

Speed test to Comcast in Salt Lake gives 2/10 – which is horribly broken.

image

Same Ookla test outside Comcast – and I get 2/10 in Seattle.

image

Comcast Chicago compared with Comcast Seattle.

image