2027 Shift Worker Planner — Shift Calendar, Both-Off Days & Overtime Estimator (Excel + Google Sheets)

Plan your whole 2027 around your rotation in about 5 minutes. Pick your shift pattern, enter one date you worked, and the planner fills in every day of the year, shows when you and your partner are both off, and estimates your pay and overtime.

★ FEATURES

• 7 built-in rotations: Pitman 2-2-3, 4-on-4-off, DuPont, 24/48, Kelly, Panama, 5-2 weekdays

• Custom pattern up to 28 days (Day, Night, Evening, 24-hour, Off)

• Team offset for A/B/C/D crews

• Full-year 2027 calendar + 12 printable month pages (one landscape page each) with notes

• "Both Off" view: add a partner's rotation and see every shared day off, counted per month

• Pay & overtime ESTIMATE by month: weekly OT, optional daily OT/double time, and a California preset

• Pay Periods tab: weekly, biweekly, semi-monthly or monthly; choose the day your workweek starts

• 2027 US federal holidays showing your shift on each one

• Night-shift sleep log with monthly averages

★ OVERTIME RULES CHECKED AGAINST OFFICIAL SOURCES

The California preset follows the California Labor Commissioner's overtime FAQ (dir.ca.gov): 1.5x over 8 hours (up to 12) in a workday, 2x over 12, the 7th-consecutive-day rule, and weekly OT over 40 without counting hours twice. Other states: use "Weekly only" or set your own daily thresholds.

★ WHAT YOU GET

• 1 spreadsheet file (.xlsx), works in Microsoft Excel and Google Sheets

• "Start Here" PDF with download, Google Sheets and setup steps

★ HOW IT WORKS

1. Download the files from the link on your receipt page or email.
2. Open it in Excel, or upload it to Google Drive and choose "Open with Google Sheets" > File > Save as Google Sheets.
3. On the Setup tab, fill in the yellow cells: rotation, a date you worked, shift times, hourly rate.
4. Everything else updates automatically.

★ COMPATIBILITY

Microsoft Excel (desktop) and Google Sheets (free Google account). Easiest to set up on a computer; viewable on phones with the Excel or Google Sheets app. Not designed for Apple Numbers.

★ PLEASE NOTE

• Digital download — no physical item will be shipped.

• Covers calendar year 2027.

• Pay and overtime figures are ESTIMATES for planning only. This is not payroll, tax or legal advice. Union contracts, alternative workweek schedules, exemptions, differentials and other states' rules can differ. Always confirm with your employer.

• Designed by me and built with the help of AI tools; I chose the features, reviewed and tested the formulas, and support the file myself.

Questions? Message me any time.