Schedule24™ Excel® Shift Pattern Add-In for Microsoft® Excel® has been designed to solve a big problem for Excel users trying to create shift patterns, especially where their business operation has to cope with extended hours and 24/7 working.
Invariably where extended hours and 24/7 working is needed, staff usually have to rotate not only their shifts but also their days off to ensure an adequate staff supply as staff finish and start work at different times of the day – or night. A major headache is ensuring shift patterns are fair and equitable to all.
One major shortcoming of creating shift patterns manually in Excel, is in almost every instance we think of shift patterns based on the 7 day week. That’s how we think about our time in every other ‘walk of life’ and so it is understandable, and this is OK as far as it goes. However, there are many shift pattern solutions that are not weekly based and are sequence based so we never think about them, except the most simple patterns. For example 4 days on and 4 days off is a sequence based shift pattern. It has an 8 day cycle before it repeats itself not 7 days.
Another quirk of rotating shift patterns is you can never get an acceptable pattern when the number of days on (working) and the number of days off equal 7 days e.g. 3 days off 4 days on; or 2 days off 5 days on etc. If you do you will find staff always have the same days off each week; great if your days off fall at the weekend, not so great if they fall on Monday and Tuesday.
So it is hardly surprising why the path of defining a shift pattern in Excel is a tortuous one; and can involve many hours, if not days just to work out a mediocre shift pattern. Schedule24 Shift Pattern Add-In for Microsoft® Excel® can deal with this kind of ‘brain twisting’ complexity in seconds. It also computes what for many are the hallmark of industry best practice in shift pattern design including control over the direction of rotation (DOR); and the speed of rotation (SOR). Factors that maximize rest periods, reduce sleep deprivation, and tune shift patterns to our ‘body clock’ or circadian rhythms for healthier shift working options.
Designed specifically and optimized for business analysts, and consulting professionals to work out combinations of shift patterns faster than it takes to format your next worksheet. Through a seamless integration, Schedule24 Shift Pattern Add-In for Microsoft® Excel® adds a new dimension to your Excel® shift pattern designs and staff scheduling.
Schedule24 Shift Pattern Add-In for Microsoft® Excel® is scheduled to be released in the next few weeks.
Microsoft, Microsoft Office, Excel, and Windows are trademarks or registered trademarks of Microsoft Corporation. Schedule24 is a registered trademark in the United States of America and other countries.