Tuesday, December 3, 2013

Annual timesheet template v2014

At the end of 2012 I turned a 4-weekly timesheet into an annual timesheet tracker. A number of issues popped up early on -- a really simple oversight on a late-requested addition -- which I had to provide a quick fix for. But I'm now in the process of improving it for 2014.

2013 features
  • Protected sheets to prevent accidental messing up of formulas. (But not password protected because I trust that anyone intentionally editing it knows what they're doing. Do unto others...)
  • Macros to unprotect / re-protect all sheets. (Excel 2010 doesn't seem to have a "protect all" option, so you otherwise have to lock all 13 sheets individually. Inefficient.) CTRL+SHIFT+U and CTRL+SHIFT+L.
  • Summary page showing hours worked, hours accrued per month, and # of SDOs (scheduled days off, probably also known as time off in lieu days, rostered days off etc). This is to make it more useful as a tool for supervisors/managers.
  • Graphs! (I don't know how useful they are, but it impresses some people -- important for adopting a new thing.)