JS523HR ◉ SHIFT SCHEDULE MAKER & ATTENDANCE TRACKER | 4 TEAMS | 3 SHIFTS | 32 DAYS

$24.00

GOOGLE SHEETS & EXCEL VERSION

$24 | Multi User |  

Pay Once | Use Forever

Instant Download

 

Description

If you are looking for a shift schedule maker with attendance tracker capabilities you can use this SHIFT SCHEDULE MAKER and ATTENDANCE TRACKER. With this template, you can assign different roles and rotation pattern by employees every 32 days cycle. You can set it 12 cycles in advance or one cycle at the time.

You can switch or adjust generated schedule in separate tab where it also functions as attendance tracker tab. So, it is not just a shift planner template but also an attendance tracker to record any absences of your employees.

Use this spreadsheet to plan schedule for 4 teams with 3 work rotating periods within 32 days cycle

You can use up to 25 employees per spreadsheet. Re use it to plan schedule for other 25 employees.

Here short instructions on how to use it

  1. Assign pattern your employees (max 25 employees). You can reuse this template to another 25 employees
  2. Adjust generated pattern (switch employee shift, edit pattern based on employee’s availability, etc)
  3. Record absences (taken PTO, no show, etc)

Also, you can print all available tabs including reports.

Here are all tabs

  • Rotation Planner – Plan and assign rotation schedule
  • Rotation Attendance – Adjust generated pattern and record absence
  • Generated Rotation – Calendar View 1 – Rotation Attendance visualization in 12 month calendar (in weekly)
  • Generated Rotation – Calendar View 2 – Rotation Attendance visualization in 12 month calendar (in monthly)
  • Yearly Rotation | Attendance Calendar | Select Employee – Select employee rotation | attendance calendar in one page calendar
  • Weekly Rotation Period – Rotation visualization by shift period
  • Work Hour Report – Summary of total workhours for all employee
  • Yearly Attendance Report | Select Employee – Select employee attendance report in one page

You can design your own pattern within 32 days cycle.

You could design a pattern multiplication of 4, 8, 16 and 32 days.

This template has 12 tables with 32 days per cycle. It only cover 384 days in total. So, you will see days that are not shown in one calendar year in calendar visualization tab.

Shift Schedule Maker and Attendance Tracker - 4 Teams 3 Shifts 32 Days

What you will get

You will get :

  • One ready to use Excel spreadsheet
  • One Excel spreadsheet filled with dummy data for reference
  • One text file to copy google sheets file to your account

 

Requirement

Microsoft Excel 2007, 2010, 2013, 2016, 2019 for Windows Vista, 7, 8, 10

Microsoft Excel 2008, 2011, 2016, 2019 for Mac OS X

Google Sheets

Demo

See it live in Google Sheets (Viewing only. Not editable).

https://docs.google.com/spreadsheets/d/1b4tHz9K2IRzEA99cCLdm1FN0nxe1r6c6lZAS71zxLvI/edit?usp=sharing