Exceltemplates.org – Shift schedule generator with attendance planner template is an excel spreadsheet to generate shift schedule for your employees with built-in shift patterns that you can select to fit your company’s purposes. It includes fixed and rotation options where you can try and see the outcome, in terms of generated working hours per day/week and days off. This automatic shift pattern generator should cut your manual task on planning it manually. And it will show you in shift table format where you can print and distribute it to your employees.
Different from the other shift schedule generator from the same author that generate shift schedule to one group, this version can generate until 3 different shift plans for 3 different groups. With this new features, you can manage and assign shift to different group of employees in your company. For example, if you worked as a Human Resources Manager in a manufacture type company, you may need to create a shift schedule to your labors who work 5 days a week, then you must create different shift schedule for your security employees who must operate 24/7. It could be more complicated if you must generate a different shift plan those security employees who must work on Saturday and Sunday with more number of persons. With this shift schedule generator template, you can do trial and error to find the most suitable one. You don’t have to put your employee’s names manually in shift board table, you can focus on their holidays and number of working hours as your shift assignment consideration.
If you already have your own shift pattern, you can put it into this spreadsheet as one of your pattern by using custom option. You can find it at the bottom of the table. Another feature is you can set different start and end time of any generated shifts which yield different time duration for your employees.
It has automatic working hour calculation that should ease you to calculate respective wages to your employees. You can easily copy calculated data and paste it in your own salary spreadsheet. And, there is additional feature that should help you more. It has employee swapping and attendance monitoring capabilities. With this feature, you can plan a shift schedule that accommodate your employee’s vacation plans. Also, you can mark any employees who absent on their shift assignments.
To swap employees, you just need to input your employee’s vacation dates in respective vacation worksheet and find any orange marking color in generated shift schedule. If you can find one, you must swap it by selecting replacement employee from the drop down list next to that orange color cell. Once you select it, the orange marker will disappear which mean that their conflicting schedules have been settled.
To monitor and mark absent employees, you do similar steps like swapping employees. Except, you select “ABS” option from the drop down list. It will make the background color of absent employees turn into red, and it will remove working hour calculation of respective employees. You can assign particular absent codes once they confirmed their absent purposes in particular absent worksheet.
The screenshot above give you rough information about relation between generated shift schedule and attendance worksheet. There is no version that you can use for free. But, there is a demo version that you can use to evaluate some of those features. You can go to the author site to get more information about this spreadsheet.Download
Using Microsoft Excel to simplify your spreadsheet tasks is not as difficult as you think. I learned how to use it in less than 24 hours and rely on internet to find the solution if I got stuck. I am not an Excel expert, but here are all useful spreadsheets I have collected and created.