Do you have some difficulties on planning your employee’s shift? Do you need a simple tool in Microsoft Excel to help you arrange and manage your employee’s shift schedule? If the answer is yes, you might consider this Excelindo Employee Shift Schedule Generator for Excel. It is a shift schedule template created using Microsoft Excel, without Macros, that you can open and use it in Windows, Apple/Macintosh or even Google Spreadsheet environment without any problems. And with Excel platform, you can easily create a report, or integrate it into your other Microsoft Documents easily.
Using this software will cut your shift scheduling arrangement from hours to minutes. And with more than 40 Pre-Designed widely used shift plan, you can choose and apply it within minutes. There is also a template to create your own shift pattern that might suited your company shift schedule more.
Almost all shift schedules are designed to cover companies or industries that implement 24/7 working days, where it is difficult for one employee to work in this type of schedule. Shifts can be divided into 1, 2, or 3 time period where at least it needs 2 groups to cover the whole working days. Several famous plan you can find and select in this spreadsheet are :
> Four On Four Off
> Five and Two
Non 24/7 Plan
Arranging shift schedules for companies that are not implement 24/7 working days is easier, because employees at least will have one day off. The challenge is only on managing the working hours of all employees. There are a complete list of Non 24/7 plan in Features section. And if you can’t find the suitable one, just use the custom feature to create your own shift plan.
There is the Lite edition you can try before deciding to buy a pro version. You will get one year free updates. There is a 60-day money back guarantee. Start using the lite version to evaluate and objectively assess all available features to generate your shift scheduling tasks.
Below is a feature comparison table between Lite and Pro version.
|License||Single User||Multi User|
|Maximum Employees per Group||6||35|
|Pre-Designed Shift Plan||22||46|
|Custom Shift Plan||Yes||Yes|
|Shift Time View||Yes||Yes|
|Shift Group View||Yes||Yes|
|Shift Time Colorization||Yes||Yes|
|Shift Group Colorization||Yes||Yes|
|Maximum Generated Schedule||4 Weeks||52 Weeks|
|Shift Schedule Display Period||1, 2, 4 Weeks||1 - 5 Weeks|
|Working Hour Calculation||4 Weeks||52 Weeks|
≡ 46 Pre-Designed Shift Plan
With this 46 Pre-Designed Shift Plan, you can directly select the plan that suit your business nature and map your employees based on your choice. You can try several plan before deciding the best one which suit your company’s need. You can see the list of that 46 shift plans below.
|No||Common Name||Working Hour/Day||Pattern||# of Teams/Shifts|
|1||2 Team 5 On 5 Off||24/5||5 On 5 Off||2/1|
|2||2 Team 6 On 6 Off||24/6||6 On 6 Off||2/1|
|3||2 Team 7 On 7 Off||24/7||7 On 7 Off||2/1|
|4||2 Team 5-Day Shifting||24/5||1 On 1 Off||2/1|
|5||2 Team 6-Day Shifting||24/6||1 On 1 Off||2/1|
|6||2 Team 7-Day Shifting||24/7||1 On 1 Off||2/1|
|7||3 Team 5 On 10 Off||24/5||5 On 10 Off||3/1|
|8||3 Team 6 On 12 Off||24/6||6 On 12 Off||3/1|
|9||3 Team 7 On 14 Off||24/7||7 On 14 Off||3/1|
|10||3 Team 5-Day Shifting||24/5||1 On 2 Off||3/1|
|11||3 Team 6-Day Shifting||24/6||1 On 2 Off||3/1|
|12||3 Team 7-Day Shifting Model 1 (24/48)||24/7||1 On 2 Off||3/1|
|13||3 Team 7-Day Shifting Model 2||24/7||1 On 1/4 Off||3/1|
|14||3 Team 7-Day Shifting Model 3 (Kelly)||24/7||1 On 1/4 Off||3/1|
|15||3 Team 7-Day Shifting Model 4 (48/96)||24/7||2 On 4 Off||3/1|
|16||Early and Late 5 On No Rotation||10/5||5 On||2/2|
|17||Early and Late 5 On Week Shifting||10/5||5 On||2/2|
|18||Early and Late 5 On 2 Week Shifting||10/5||5 On||2/2|
|19||Early and Late 6 On No Rotation||10/6||6 On||2/2|
|20||Early and Late 6 On Week Shifting||10/6||6 On||2/2|
|21||Early and Late 6 On 2 Week Shifting||10/6||6 On||2/2|
|22||DNO||24/7||2 On 1 Off||3/2|
|23||DDNNOO||24/7||4 On 2 Off||3/2|
|24||Four On Four Off - Fixed||24/7||4 On 4 Off||4/2|
|25||Four On Four Off - Rotating||24/7||4 On 4 Off||4/2|
|26||12 Day||24/7||6 On 6 Off||4/2|
|27||Pitman||24/7||2/3 On 2/3 Off||4/2|
|28||Five n Two||24/7||3/2 On 3/2 Off||4/2|
|29||Extended 12||24/7||14 On 7 Off||3/2|
|30||DuPont||24/7||3/4 On 1/3/7 Off||4/2|
|31||2-2 3-2 2-3||24/7||2/3 On 2/3 Off||4/2|
|32||Panama||24/7||2/3 On 2/3 Off||4/2|
|33||3 Team Fixed Shift||24/5||5 On||3/3|
|34||3 Team Fixed Shift||24/6||6 On||3/3|
|35||3 Team Rotating Shift||24/5||5 On||3/3|
|36||3 Team Rotating Shift||24/6||6 On||3/3|
|37||21 hour day||24/7||3 On 1 Off||4/3|
|38||Metropolitan||24/7||6 On 1 Off||4/3|
|39||6 On 2 Off||24/7||6 On 2 Off||4/3|
|40||Continental||24/7||7 On 2/3 Off||4/3|
|41||4 Team Rotating Shift||24/7||7 On 2/3 Off||4/3|
|42||4-2 4-3 4-3||24/7||4 On 2/3 Off||5/3|
|43||5-3 5-4 5-3||24/7||5 On 3/4 Off||5/3|
|44||6-4 6-4 6-4||24/7||6 On 4 Off||5/3|
|45||4-3||24/7||4 On 3 Off||5/3|
|46||28-hour day||24/6||2 On 1 Off||6/4|
≡ Custom Shift Plan
If you can’t find the suitable Pre-Designed shift plan, you can create your own custom shift plan. It is as easy as typing all required parameters and set your pattern in related shift plan table.
≡ Shift Schedule in Custom Time and Group View
You can personalize generated shift schedule before you print and share it to your employees. Schedule will be generated for 52 weeks period. You can choose to use time or group view or you can use both. You can set the schedule to be seen or printed in 1, 2, 3, 4 or 5 weeks.
≡ Automatic Working Hour Calculation
This feature will allow you to see the amount of working hour of all your employees for 52 week period.
This software requires Microsoft Excel 2007/2010/2013 running on Microsoft Windows environment. It should work on Apple/Mac environment but you’d better test it first.