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

Excel Discussion in 'Microsoft Office' started by airport62, Dec 6, 2017.

  1. airport62

    airport62

    Joined:
    Dec 6, 2017
    Likes Received:
    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

    [​IMG]
    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

    [​IMG]
    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: Dec 6, 2017
    airport62, Dec 6, 2017
    #1
    1. 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 (here). After that, you can post your question and our members will help you out.