Personal Work Log Workbook (PersWorkLog)

Christopher Rath



Last year, I returned to consulting after 10 years working at Nortel.  One important task that is part of my day is tracking my time. My requirements were/are neither complex nor complicated, but I did require something that was easy to use:

The net result was that I put together an Excel workbook to perform the tasks in a manner very similar to how the Hours utility had performed its work.


The tool takes the form of an Excel template.  You place the template in your Excel template folder and then when you want to begin a new log (I create a new one each calendar quarter) you choose File->New, and select the "PersWorkLog" document type.

Each time you sit down to work, log in to the tool by either clicking on the icon, or by pressing [Shift]-[Control]-I.  When you complete your work session, or when you change tasks, click on the icon or press [Shift]-[Control]-O.

Reports are viewed on the either the "BillableSummary" or "NonBillableSummary" tabs.  The reports are produced via an Excel Pivot Table, and they must be manually refreshed.

Further documentation can be found within the template itself.


The template can be downloaded from the following link: current template version (PersWorkLog

Copyright & Licensing

Note, the template is Copyright © 2004 Christopher Rath. Permission is granted for any use of this template by others as long as this copyright statement is retained, other due and proper credit is provided to the author (e.g., don't claim you wrote this template), and the LGPL license is respected.   This package is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License. See the LGPL tab of this workbook.  This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE; on an “AS IS,” “WHERE IS” and “WITH ALL FAULTS” basis.

©Copyright 2004, Christopher Rath
Telephone: 613-824-4584
Address: 1371 Major Rd., Ottawa, ON, Canada K1E 1H3
Last updated: 2015/02/14 @ 21:34:00 ( )