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.