There are as many different ways to stay organized as there are people. It is not a trivial task. Many disciplines, schools of thought, and solutions are devised to increase efficiency and, possibly, decrease complexity. As a matter of fact, the most popular article on Code Project[^] is ToDoList 5.8.4 - A simple but effective way to keep on top of your tasks[^]... However, while it is essential that we plan, track and report on our daily tasks, there is no standard way to do it. People have to adapt to a new system (and comply to its requirements) every time they switch their working environment. This article suggests the use of spreadsheets to record tasks as a universal, minimalistic, portable, flexible, and very customizable approach that requires "no" learning curve.
The attached workbook can be used as a template for measuring daily tasks. It has no macros and can be used in Microsoft Excel [^] and OpenOffice [^]. It has been successfully tested with older and newer versions of these applications.
(!) One way to increase performance is to use macros in place of some of the formulas in the template (e.g., [^]). Note that if you use macros, you'll sacrifice portability for speed.
The attached workbook has three main spreadsheets. Presently, they are Def (for all definitions), Log (for all daily tasks), and Qry (for all queries). (+) You can rename the spreadsheets in the template to any title you like.
The following definitions are included:
(+) You can expand or shorten any of the definitions.
The spreadsheet tracks the use of these definitions and shows statistics on the frequency of occurrence and total amount of effort for each one and in total. The same information is visualized with the help of charts. (+) Feel free to choose the charts you like for this purpose.
The following columns are included:
* If a task with the same code and activity has been previously entered, the cell is auto-populated.
(+) You can add, remove, or re-order any of the columns.
The following queries are included:
Use this spreadsheet for free-form notes, comments, calculations, work-related tokens, etc.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
General News Suggestion Question Bug Answer Joke Rant Admin
Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.