As a consultant, I need to keep track of my day to make sure our company bills our customers for the appropriate hours I spend. If I'm working on one customer all day, it is pretty easy to enter my time into our billing system at the end of the day. On the other hand, when I'm working on several customers throughout the day and being interrupted by other customers and other consultants via meetings, e-mails, and phone calls, I need a spreadsheet where I can track every minute of the day - and is easy to see what I worked on for each external or internal customer when I'm entering my time into the billing system.
A colleague of mine had created the basic format, but it was very static. Always trying to improve and streamline, I changed it into a dynamic interface. Plus, I really wanted it to be easy to see all the work I did throughout the day for one particular customer and project.
I have been trying to ween myself off VBA in Excel whenever possible, so this spreadsheet contains no VBA macros - it is all Excel formulas and conditional formatting. The sheet is protected to keep data entry in the designated places, but there is no password if you want to poke around and see how it works.
Shoot me a comment if you find the spreadsheet useful.
No comments:
Post a Comment