⏱️ Time Tracker 1.0 | Docs

Purpose: This section provides instructions for system administrators to manage the Google Spreadsheet and ensure proper tracking of activities.

Instructions:

1. Make a copy of this file Time Tracker 1.0 (File -> Make a copy)
2. Adding New Employees:
   • Navigate to the ‘Configuration’ tab.
   • In the next available row:
     • Column B (Employee Name): Enter the name of the employee.
     • Column C (Team Name): Enter the team name of the employee.
   • Click on the button “Initiate Tabs”
   • The script will automatically check if a tab with the employee’s name exists. If not, it will create a new tab using the ‘Template’ and mark ‘true’ in Column D. If the script does not run automatically, you may need to manually trigger it or contact ml@michelelicciardello.com
3. Verifying Tab Creation:
   • After running the script or waiting for the automatic trigger, check that a new tab with the employee’s name has been created.
   • Ensure the new tab contains the correct format for recording activities.
   • Share the file and the instructions below with your team members, and give each edit access. If you want to protect some cells feel free to do so.
4. Usage of Automation Functions:
   • Two automation functions, onEdit(e) and hideOldEntries(), are implemented to streamline data management.
   • onEdit(e): Automatically handles timestamp updates based on user edits.
   • hideOldEntries(): Automatically hides rows where the date in column B does not match the current date when the user clicks on Clean button.
   • These functions are designed to improve data accuracy and visibility.
5. General Guidelines:
   • Regularly update the ‘Configuration’ tab to reflect any changes in team structure or employee roles.
   • Do not manually create tabs unless necessary, as this could lead to duplication or formatting issues.
   • If there are any technical issues or questions, reach out to ml@michelelicciardello.com

Purpose: This section guides employees on how to record their activities in the designated Google Spreadsheet.

Instructions:

1. Accessing the Spreadsheet:
   • Open the Google Spreadsheet shared with you by your manager.
   • Ensure you have the necessary permissions to edit the spreadsheet.
2. Finding Your Tab:
   • Locate the tab at the bottom of the spreadsheet with your name. If you cannot find a tab with your name, please contact your manager.
3. Recording Your Activities:
   • In your personal tab, you will find a pre-structured format for recording activities.
   • Select your activity by changing the values in column D “Activity”.
   • When column D is edited the automation adds the current date and time to columns Date and Start Time.
   • If you’re changing activity type in Column H “N” (as for Next), if you finished your shift “E” (as for End) the rest will be set up by the automation.
4. General Guidelines:
   • • Do not edit or delete entries made by others.
     • If you encounter any issues or errors, report them immediately to your manager.