Suggestions for more 'User Friendly' Layout - excel 2007

[KJ2607]

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.

[TABLE="width: 2833"]
<tbody>[TR]
[TD][/TD]
[TD]Surname[/TD]
[TD]Forname[/TD]
[TD]Project[/TD]
[TD="colspan: 29"]Network Rail - Week 36[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[TD="colspan: 4"]Sun[/TD]
[TD="colspan: 4"]Mon[/TD]
[TD="colspan: 4"]Tues[/TD]
[TD="colspan: 4"]Weds[/TD]
[TD="colspan: 4"]Thurs[/TD]
[TD="colspan: 4"]Fri[/TD]
[TD]Total Weekly Hours[/TD]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[TD="colspan: 4"]01/12/2013[/TD]
[TD="colspan: 4"]02/12/2013[/TD]
[TD="colspan: 4"]03/12/2013[/TD]
[TD="colspan: 4"]04/12/2013[/TD]
[TD="colspan: 4"]05/12/2013[/TD]
[TD="colspan: 4"]06/12/2013[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[TD]Start[/TD]
[TD]Finish[/TD]
[TD]Total Shift Hours[/TD]
[TD]Total Rest Hours[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Smith[/TD]
[TD]John[/TD]
[TD]Swindon[/TD]
[TD="align: right"]07:30[/TD]
[TD="align: right"]17:30[/TD]
[TD="align: right"]10:00[/TD]
[TD="align: right"]10:30[/TD]
[TD="align: right"]04:00[/TD]
[TD="align: right"]13:30[/TD]
[TD="align: right"]09:30[/TD]
[TD][/TD]
[TD="align: right"]07:30[/TD]
[TD="align: right"]21:30[/TD]
[TD="align: right"]14:00[/TD]
[TD][/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]15:00[/TD]
[TD][/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]15:00[/TD]
[TD][/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]15:00[/TD]
[TD][/TD]
[TD="align: right"]07:00[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]15:00[/TD]
[TD][/TD]
[TD="align: right"]93:30:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jones[/TD]
[TD]Paul[/TD]
[TD]Eastleigh[/TD]
[TD="align: right"]08:30[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]12:30[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]09:00[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]08:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]20:30:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]00:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Drrellik]

I would start by looking through the on line templates for something. if you are not sure how to find them do this. go to the File Tab and click New. the click template or if you have 2013 in the search box at the top type things like employee time; or project tracking; this may now have just what you are looking for but it might give you ideas on how to layout the project. I might also add or ask have you ever used a pivot table? Who many different managers are there and how many employees.

 

[KJ2607]

I have thought of using a pivot table and do like the idea, however my sheet isn't really set out as a data list so it doesn't quite work

I'll have a look through the templates and see if there's anything that suits my requirements.

Thanks

 

[Drrellik]

How did you fair with the templates.

 

[KJ2607]

I had a look through and while there wasn't one that fit my need exactly - I've taken ideas from a few of them to design my layout

Thanks!!