Excel Home made rota system- creating a time sheet in relation to demand


Joined
Dec 6, 2017
Messages
1
Reaction score
0
Hello,

I have created a basic rota system for a hospitality company, where based on sales mix for the past few weeks a manager can forecast their sales and the sheet calculates based on agreed percentages how many bar team members/ chefs etc.

I am not strong with excel and how it breaks this down is with time scale across top and for each department within this hour it has a 1/2/3 etc. for how many team members they are allowed. Below are the team members and in order to input rota the manager has to put a 1 in the box for the time they are there see below


upload_2017-12-6_5-50-49.png


I have created it this way so that my summary sheet works correctly please see below:

upload_2017-12-6_5-51-33.png



I want to improve the system by changing the rota part so that the manager can input a simple start/ finish time for their team members, but I still need it to post the info against the hourly breakdowns so that they can see if they have to many team members on / not enough etc.

Any advice on how to make this more user friendly/ improved etc would be greatly received!
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top