Share my work log template that used since Apr 2009
Posted by Admin L in Templates on 04-09-2011.
Article Author: Nosa Lee
Resource Author: Nosa Lee
Original Address: https://www.seeksunslowly.com/work-log-template-share
To reprint this article, please indicate the source, thank you.
_____________________________________
My work log template may be appropriately for SOHO or the teams, However, whether need to use also depend on personal habits and preferences.
I like recording, summarizing and organizing, so I have been using it (but just use a simple txt record before), just for your reference if you have this habit.
Click here to download my work log template (xls)
Usage
1. Folder Structure
WorkLog\NosaLee\2010.xlsx
As above, the first level indicates there are work logs under it, create it at the appropriate location (under work drive’s root usually); the second level is worker name; the third level the work log files for all years.
2. File and Content Format
>> Excel documents (xls or xlsx), named “YYYY.xls” or “YYYY.xlsx”.
>> One sheet per month.
>> Record content as days, has the following fields (strive to be simple).
Date, SN, Work, Product, Remark, Status.
Date: date (01 – 31).
SN: 01 – 99.
Product: product English short name (only if you have two or more products ore services).
Remark: if you need to place special emphasis.
Status: I use “Finished” and “Processing”.
Note: don’t record if no work in one day, don’t write date and remark as ‘Official Holidays’ or ‘Handling private affairs’, redundant.
Please see the following picture