We manage(and often pay ) to a results outcome rather than to actual hours worked so its important that the Daily reports are correctly managed It is managers highest priority to review the previous days performance from the daily reports AT THE START OF THE DAY and take the appropriate corrective management action
The google forms format is used so its easy and accurate for staff to submit reports and easy and efficient for managers to review results
before we look at result we ensure that data entry is correct, especially if we have made changes to the method for staff to submit the report
look at the data - does it seems accurate
if unsure check with staff and cross check
If data was entered incorrectly then check if training guides tab information is sufficient and update as required
If training is required then make sure this is done, so data is accurate
Ensure that entered data is correct and at times verify this , the guide to how data is verified and checked should be shown in the details tab for the particular teams worksheet
at times the questions or format may have to be updated, if so contact you manager
Once we know data entry is correct we look @ result , copy/paste formula from previous days
if all green lights with results
( assuming data entry is correct and KPI are correct )
then all great thanks the team for great result
Often you will add comment in mangers comment column as a record of action/conversation that took place as a result of daily report
If some KPI not met
try to see which areas failed
if its a one off make sure your staff know this is a one off and offer support to correct this with them, given its an usual one off you may likely say that you are not so concerned with this as its a one off event
if more regular than a one off then you need to manage the staff and take the appropriate action
ALL STAFF SHOULD KNOW THEIR RESULTS /THEIR NUMBERS REQUIRED, THATS YOUR JOB AS MANAGER TO EXPLAIN IT TO THEM AND HELP THEM ACHIEVE THE REQUIRED RESULT
Once per week remove entries that are older than 6 weeks old so the tab is clean ( you may set up spare tab to hold this data ) but we can retrieve later if required