Rotating Shift Schedule Template, 12 Hour 2-2-3 DuPont Panama 24/48 Fire Rotation, Overtime Calculator, Crew Rota | Excel Google Sheets

Seller's description

Build a full year of rotating shifts for every crew and every person, see who's short when people take time off, and know what each pattern costs in overtime before you pick one. For plants, warehouses, hospitals, security, fire and EMS, dispatch and any 24/7 operation. Works in Excel and Google Sheets.

WHAT'S INCLUDED
1. Rotating Shift Schedule Generator workbook (Excel + Google Sheets), 13 tabs:
- Start Here: setup steps in plain English.
- Setup: pattern, start date (any day of the week), workweek start day, overtime rules, default rate and your holidays. Official sources listed.
- Shift Codes (10): day, night, 8-hour and 24-hour shifts with start times, hours and the minimum people needed.
- Patterns (15): 11 built in: 2-2-3 (Panama), DuPont, 4 on 4 off, 3 on 3 off, 2-2-2, 12/36, 8-hour 4-crew forward rotation, 24/48, 48/96, Kelly and 24/72. Plus 4 of your own (up to 6 crews, cycles up to 28 days) with a check that every day is covered.
- Crews (6) and People (80): names, crews, supervisors and hourly rates.
- Time Off (200): named people and dates. They come off their shifts and short shifts are flagged.
- Calendar: 52 weeks, each crew's shift, people on each shift, holidays and a Status column.
- Month Rota and My Year: printable month wall chart and a one-person year view.
- Overtime: hours and overtime per crew in every workweek or 7(k) period.
- Compare Patterns: hours, overtime, pay and the cost of one 24/7 post for every pattern under your rules.
- Dashboard: totals, crews side by side (hours, overtime, weekend, holiday and time-off shifts), next short shifts, rows to fix, and the lowest-cost pattern.
2. Start Here PDF with your Google copy link.

WHY IT'S DIFFERENT
- One file for 1 to 6 crews and 8, 12 or 24-hour shifts, including fire and EMS schedules (24/48, 48/96, Kelly, 24/72). Start on any day, not just a Monday.
- Real people, real time off: book vacation by name and see which shifts drop below your minimum.
- Overtime the way the law counts it: a fixed workweek starting on your chosen day, optional daily overtime and double time (as in California), and 14 or 28-day 7(k) periods for fire and police.
- Pick the cheapest pattern with numbers: cost per 24/7 post for every pattern, with the lowest one that covers every day named for you.
- Fairness at a glance: weekend and holiday shifts per crew.

TESTED
30 automated tests check every calculation against an independent model over 6 rounds, including hand-worked overtime, all 11 patterns, broken custom patterns, a full file of 80 people and 200 time-off entries, and 18 random setups. Google Sheets matched the Excel/LibreOffice values cell by cell (25,199 cells, 0 differences).

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open Rotating-Shift-START-HERE.pdf. Click the link and choose "Make a copy" for Google, or open the .xlsx in Excel.
3. Look at the sample, clear it, and enter your crews, people and time off.

GOOD TO KNOW, PLEASE READ
- Overtime and pay are estimates from the schedule and the rules you enter. Not legal or payroll advice. Hours count on the day a shift starts.
- Everyone in a crew works the crew's shifts. One-off swaps and extra shifts aren't tracked. It's a spreadsheet, so it doesn't connect to a time clock or payroll.
- Compatible with Google Sheets (free Google account), Excel 2010 or newer on Windows or Mac, and LibreOffice. Not designed for Apple Numbers.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own business use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing the shift schedule templates already available and what they leave out. I tested every calculation against an independent check (30 tests) before listing.