Dec
27
Bug Fixing Day
Filed Under Perl | Leave a Comment
I have over 40 modules on CPAN, and probably average about 1 bug report a week (not including all the discussion that goes on the Class::DBI mailing list). Most of them are really simple to fix without much effort at all (such as typos in the docs), but like most of these things, if I [...]
Dec
15
Last Day of Month in Excel
Filed Under Spreadsheets, Technology | 7 Comments
My next Excel Top Tip is how to calculate the last day of a month. I thought there was a function to do this as part of a whole suite of date manipulation functions, but I seem to have imagined that, as I couldn’t find. I was dreading having to do lots of nasty date [...]
Dec
7
Fun with Excel
Filed Under Spreadsheets, Technology | 1 Comment
I’m trying to build a simple bookkeeping system in Excel, and I’m learning all manner of interesting things. But I ran into a significant problem that I’ve found a really ugly solution to. If this is really the best way to do this, hopefully this post will be useful to someone else someday. If it’s [...]