Introducing Automatic Shift Pattern Add-In for Microsoft® Excel®

Introducing Automatic Shift Pattern Add-In for Microsoft ExcelSchedule24™ 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.

Author Rating
no rating based on 0 votes
Software Name
Schedule24 Excel Add-in
Operating System
USD 249
Landing Page
Clip to Evernote
Posted in General, News, Shift Patterns Tagged with: , , , , , , , , , , ,
14 comments on “Introducing Automatic Shift Pattern Add-In for Microsoft® Excel®
  1. gaziog says:

    Thank you for the great info, can’t wait for this excel add-in to be released!

  2. jacken says:

    Spent what feels like an eternity looking for shift pattern generator for excel. Awaiting its release with anticipation.

  3. Rachel says:

    Can you let me know what verions of Microsoft Excel your addin will run?

    I look forward to hearing from you.


    • Tec Support says:

      Hi Rachel,

      Currently, Schedule24 Shift Pattern Addin runs in the following versions of Microsoft Excel*:

      • – Microsoft Excel 2003
      • – Microsoft Excel 2007
      • – Microsoft Excel 2010
      • – Microsoft Excel 2013

      *Add-in is currently only supported on 32bit Excel not 64bit Excel.

      Best regards,
      Chris White

  4. Boas Plassen says:

    I have a reasonable knowledge of shift rotas but I’m fairly new to excel plugins, and so don’t fully understand the relationship with excel. what can i expect it to do?

    Thank you,

  5. ExcelMaster101 says:

    Will the addin calculate rest time between shift turnaround?

    • Admin says:

      Yes. It calculates the minimum and average rest periods between shifts and displays the results in the dashboard. Most analysts are interested in the minimum turnaround, too low and somebody will not be getting enough sleep. Certainly flags any issue with the end of a night shift and the start of a day shift.

  6. Najwa Shamoon says:

    Looking forward to this App. When can we expect it?

  7. Andreas says:

    it was a wonderful entry into shift pattern designing for me. I managed to get a beta copy. :-) i used it on a client to work out their weird shift system.

  8. verney savoie says:

    What are the limits on shift pattern size? Is there a maximum input for staff?

    verney savoie

  9. Pansy Blickem says:

    This blog site has got a lot of very useful information on it. Cheers for helping me!

  10. Leandra Duer says:

    Nice read, I just passed this onto a friend who was doing research on staff rotas for his company. And he actually bought me lunch because I found it for him :-) Therefore let me rephrase that: Thank you for lunch!

    Leandra Duer

  11. Neil Hunt says:

    I just want to tell you that I just found your weblog. You definitely have well written articles. Thanks for revealing your insites to all things employee scheduling – it’s a complicated world!

  12. Admin says:

    Hi Najwa,

    Released – more information on Schedule24 Excel Add-in can be found at:

    Andy French