Hello All!
I'm in the process of creating a spreadsheet that monitors the hours worked for employees under 3 different managers...there are a number of things the sheet will report such as 'total weekly hours', 'total hours worked in one shift' etc. The spreadsheet needs to cover every week for a year so there's going to be a huge amount of data on there.
Each Manager has a separate Tab where their employees hours will be entered and there will also be a tab for the total hours worked for all employees.
I've been staring at this for a few days now trying to work out the best way to present the data - so does anyone have any suggestions what will enable me to present this data in the most user friendly way that doesnt involve the user scrolling and scrolling across to get to the correct week?
I've attached a sample of the data so you can get an idea of what I'm working with.
<tbody>
</tbody>
I'm in the process of creating a spreadsheet that monitors the hours worked for employees under 3 different managers...there are a number of things the sheet will report such as 'total weekly hours', 'total hours worked in one shift' etc. The spreadsheet needs to cover every week for a year so there's going to be a huge amount of data on there.
Each Manager has a separate Tab where their employees hours will be entered and there will also be a tab for the total hours worked for all employees.
I've been staring at this for a few days now trying to work out the best way to present the data - so does anyone have any suggestions what will enable me to present this data in the most user friendly way that doesnt involve the user scrolling and scrolling across to get to the correct week?
I've attached a sample of the data so you can get an idea of what I'm working with.
| Surname | Forname | Project | Network Rail - Week 36 | |||||||||||||||||||||||||||||
| Sun | Mon | Tues | Weds | Thurs | Fri | Total Weekly Hours | ||||||||||||||||||||||||||
| 01/12/2013 | 02/12/2013 | 03/12/2013 | 04/12/2013 | 05/12/2013 | 06/12/2013 | |||||||||||||||||||||||||||
| Start | Finish | Total Shift Hours | Total Rest Hours | Start | Finish | Total Shift Hours | Total Rest Hours | Start | Finish | Total Shift Hours | Total Rest Hours | Start | Finish | Total Shift Hours | Total Rest Hours | Start | Finish | Total Shift Hours | Total Rest Hours | Start | Finish | Total Shift Hours | Total Rest Hours | |||||||||
| Smith | John | Swindon | 07:30 | 17:30 | 10:00 | 10:30 | 04:00 | 13:30 | 09:30 | 07:30 | 21:30 | 14:00 | 07:00 | 22:00 | 15:00 | 07:00 | 22:00 | 15:00 | 07:00 | 22:00 | 15:00 | 07:00 | 22:00 | 15:00 | 93:30:00 | |||||||
| Jones | Paul | Eastleigh | 08:30 | 21:00 | 12:30 | 12:00 | 09:00 | 17:00 | 08:00 | 20:30:00 | ||||||||||||||||||||||
| 00:00 |
<tbody>
</tbody>
Last edited:
