Software to manage workloads?

view story

http://unix.stackexchange.com – My university uses a poorly implemented and absurdly complex Excel spreadsheet with macros to manage staff workloads. It is supposed to take into account all the work a staff member does: lectures, tutorials, labs, online work, research, general service etc, with different load allocations depending on whether or not it's a large subject, whether the lectures are repeats or not, and all adjusted if leave is taken. I'm wondering what my options are - I spent much of today wrestling with this spreadsheet, and I'm thinking there must be a better way. In particular, it would be nice if there wa (HowTos)