Friday, July 17, 2015
Employee Roster / Shift allocation template
Preparing employee roster or allocation of shift times is very time consuming & requires accuracy so as to avoid any emergencies.
In this template you need to fill data in Main sheet in front of each employee & press Run All button & all shifts will be marked in respective sheets against each employees.
For changing shift allocated time, just change shift time in main sheet & same will be replicated in respective day sheet automatically.
Column R is for entering maximum time an employee is allowed to work, enter hrs manually in column R, column S will calculate total Hours allocated & balance hours in column T.
To Reset all data in all sheets, Just press Rest All Data button.
When you click on name of Day in column 4 you will be taken to that day sheet directly & from day sheet click on Main in Cell Q1 to come back to Main sheet..
Cheers & waiting for feedback for improvements..
Share to Twitter
Share to Facebook
Share to Pinterest
Post Comments (Atom)