Worksheet 3 requires no user interaction. It automatically accumulates and displays time totals sorted by month. This is done for each client, as well as a Grand Total for each month.
Time Spreader is a macro enabled Spreadsheet for measuring and logging time spent per Client, Task or Project. It is intended to be used by professionals who require the ability to easily switch from one client or task to another throughout the day, while maintaining a record of the time spent with each one. Each file provides tracking for up to four clients, though it is equally effective for one, two or three clients. More than four clients can be tracked by using additional, separate files (4 clients per file). Keep in mind that this tool may be used to track time for virtually any type of task you choose.
Description and Use:
Worksheet 1 is divided into four tables. The name of each table heading is user settable (simply type over the "Client" headers using 20 characters or less). Changing the name on Sheet1 will automatically propagate the name to the other worksheets. To begin tracking time, do the following:
1. Click into the topmost available cell in the "Start" column for the appropriate client. 2. Click the macro button labeled "Insert Time". The current date and time will be entered into that cell . The focus will shift to the cell immediately to the right (in the stop column for that client). 3. When it is time to stop or switch clients, click the "Insert Time" macro button again. The time will be entered in the stop column and elapsed time will be displayed in the third column (Total). 4. Repeat steps 1 through 3 for any other clients or tasks as necessary throughout the day. The totals per client will automatically be displayed at the bottom of each table as stop times are entered. 5. Input Start or Stop times can be adjusted by 5 minute increments using the provided buttons. To do this, simply select an already populated input cell, then click the +/- button as needed.
Worksheet 2 is where daily totals are logged by the "End of Day" operation.
1. When the last stop time of the day has been recorded press the "End of Day" button. 2. Focus will jump to Sheet2, and the Day, Date and Time Totals will be logged below the solid blue divider bar. 3. As each "End of Day" is processed the previous day’s data will be shifted down (one day per row, newest at the top). 4. Averages for the most recent 25 days will be calculated and displayed at the right side of the page. 5. Return to Worksheet 1 to prepare it for the next day’s session. Click the macro button "Clear all Inputs". 6. All input times on Worksheet 1 will be cleared and the "Save-As" command will be issued. Name and Save your file.
Important First-Run Requirements (for Libre Office users only):
To allow Time Spreader's embedded macros to work in Libre Office Calc, do the following:
1. From the main menu click-through > Tools > Options > Security; Press "Macro Security" button and Select either "Medium" or "Low" then "OK". Note: Setting to "Low" will prevent a "nag" screen when loading.
2. Close and restart the LibreOffice Calc application.