6 / Posting The Team Stats For The Creative & Leadership Teams

We can use the Time Analysis Spreadsheet to see if anyone is working too much or too little compared to their annual salary.

If an employee has tracked more than 10 hours worth of overtime over the first 3 weeks of the month as noted in the Overtime column, the Office Administrator will let their Team Leader and/or the General Manager know that the employee may be working late too often or possibly had a particularly busy day recently. The decision will then be made by Jo and/or the Team Leader whether or not it would be appropriate for the employee to leave earlier or take time off to compensate for their overtime.
If an employee has tracked more than 30 mins each week unrecorded time as noted in the Unrecorded Hours column, the Office Administrator will direct chat message their Team Leader and/or the General Manager to see if the employee has discussed this with them or if they are aware of it. If the employee hasn't talked with them, then the Office Administrator will direct chat message the employee to ask whether or not they have been tracking their hours correctly. If they have been tracking their work hours correctly, they will be told that they are currently tracking under hours for the month and that they should watch their start, end and lunch break times to ensure that they are working their salaried hours. They may choose to make up the unrecorded time later in the month, or apply for leave to make up their hours. This can be discussed with Jo and/or their Team Leader, and then the Office Administrator should be advised so it is noted for payroll and time-tracking purposes.

In the Time Analysis Spreadsheet, select the tab/sheet for the month that you are currently in
Scroll to the bottom of the pasted data until you reach the Productivity Information section
Go to the section for Team #2 - these are the stats for the Creative team VAs and Creative team Global VAs
Take a snip of the Name, Billable % (target), Billable % (paid), Billable Hours (target), Hours Worked (paid for), Hours Recorded, Billable Hours, Internal Projects, Billable % (recorded), Delegated Hours, Billable % (w delegated), Stat Holidays (Hours), Paid Leave (Hours), Unpaid Leave (Hours), Overtime, Unrecorded Hours, and Downscaled Time columns, highlighting the Delegated Hours figures (see pic below)
Post this snip in the Creative Team Stats channel in Teamwork chat, tagging @all, with a message advising of how far through the month we are and how much of the month is left

In the Time Analysis Spreadsheet, select the tab/sheet for the month that you are currently in
Scroll to the bottom of the pasted data until you reach the Productivity Information section
Take a snip of the section at the bootom left hand side that shows the totals (see pic below)
Post this snip in the Team Stats & Money channel in Teamwork chat, tagging @all, with a message advising of how far through the month we are and how much of the month is left