Download Work Rotation Schedule Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Simple Sales Chart

These are 7 simple sales chart templates with variety of models you can use to …

Read More

Date Tracking Gantt Chart

A Date Tracking Gantt chart is a project management tool that helps in planning, scheduling …

Read More

Body Mass Index Chart(BMI)

A BMI Chart or Body Mass Index Chart is a useful tool for visualizing the ranges for underweight, healthy …

Read More

Simple BMR Calculator

Basal Metallic Rate Calculator Basal metabolic rate or Simple BMR Calculator, is the amount of …

Read More
Search
Generic filters

I was asked if it would be possible to convert my annual calendar template into an automated work rotation schedule. For an employee who is working a Rota consisting of number of days on followed by a number of days off. The result was the new template Work Rotation Schedule.

Rotating Shift Schedule

This template provides convenient way to display your work rotation schedule, using annual calendar template. Just enter year and start month, then use other inputs to define your shift schedule pattern. The workbook contains 3 separate worksheets, each providing a little different set of features.

In the first two worksheets (Rotation and Rotation Advanced). Rota schedule is define by entering numbers of days on Shift 1, follow by the number of days on Shift 2, follow by the number of days off. For simpler “days on/off” pattern, just leave “Shift 2” field blank.

Rotating Shift

In the Rotation String worksheet, you can define rotation as a repeating string such as “11xxx22xx333xx” which would mean that you work Shift 1 for 2 days. Follow by 3 days off, follow by working Shift 2 for 2 days, follow by 2 days off, follow by working Shift 3 for 3 days, follow by 2 days off.

Both the Rotation Advanced and Rotation String worksheets can use the new built-in function NETWORKDAYS.INTL(), available as of Excel 2010, to let you choose which days to make up the “weekend” (Sat/Sun, Mon/Tue, Sunday only, etc.) and to also account for holidays. In these worksheets, the rotation excludes both weekend and holidays, all of which we call “non-working days. “This means that if rotation calls for you to work 2 days starting on Friday, then you would work Friday and then Monday and skipping the non-working weekend days.

The workbook contains a “Holidays” worksheet where you can list days that is consider non-working days.

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Work Rotation Schedule Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: