• May include: A 2027 shift calendar titled Your Whole 2027 Shift Year with the subtitle Pick your rotation, enter one date you worked — the year fills in. The grid displays twelve months with color-coded shift rotations labeled D, N, 24-hr, O, and E.
  • May include: A printable January 2027 calendar page featuring a landscape layout with daily shift tracking for a user and a partner. The grid includes yellow and light green color-coded cells labeled with D or O, small red heart icons, and a notes section.
  • May include: A digital spreadsheet titled When Are We Both Off? for 2027. It features a monthly summary table and a detailed schedule with columns for date, day, individual status, and a highlighted column indicating shared days off labeled YES.
  • May include: A digital spreadsheet titled Pay & Overtime Estimator displaying monthly payroll data. The table includes columns for shifts worked, total hours, regular hours, overtime hours, double-time hours, and calculated pay amounts for each month.
  • May include: A digital spreadsheet titled Grouped by Pay Period showing a 2027 payroll estimate table. Columns include start and end dates, shifts worked, total hours, regular hours, OT hours, double-time hours, regular pay, OT pay, and estimated gross pay.
  • May include: A 2027 Shift Worker Planner setup spreadsheet with dark blue headers and yellow input cells. The document includes sections for My Schedule, Partner's Schedule, Custom Pattern, and Calculated fields with text labels and numerical data.
  • May include: A digital shift schedule planner for January 2027 featuring 7 built-in rotations including Pitman, 4-on-4-off, DuPont, 24/48, Kelly, Panama, and 5-2. The layout displays four monthly calendar grids with color-coded shifts and small heart icons.
  • May include: A 2027 shift calendar titled Your Whole 2027 Shift Year with the subtitle Pick your rotation, enter one date you worked — the year fills in. The grid displays twelve months with color-coded shift rotations labeled D, N, 24-hr, O, and E.
  • May include: A printable January 2027 calendar page featuring a landscape layout with daily shift tracking for a user and a partner. The grid includes yellow and light green color-coded cells labeled with D or O, small red heart icons, and a notes section.
  • May include: A digital spreadsheet titled When Are We Both Off? for 2027. It features a monthly summary table and a detailed schedule with columns for date, day, individual status, and a highlighted column indicating shared days off labeled YES.
  • May include: A digital spreadsheet titled Pay & Overtime Estimator displaying monthly payroll data. The table includes columns for shifts worked, total hours, regular hours, overtime hours, double-time hours, and calculated pay amounts for each month.
  • May include: A digital spreadsheet titled Grouped by Pay Period showing a 2027 payroll estimate table. Columns include start and end dates, shifts worked, total hours, regular hours, OT hours, double-time hours, regular pay, OT pay, and estimated gross pay.
  • May include: A 2027 Shift Worker Planner setup spreadsheet with dark blue headers and yellow input cells. The document includes sections for My Schedule, Partner's Schedule, Custom Pattern, and Calculated fields with text labels and numerical data.
  • May include: A digital shift schedule planner for January 2027 featuring 7 built-in rotations including Pitman, 4-on-4-off, DuPont, 24/48, Kelly, Panama, and 5-2. The layout displays four monthly calendar grids with color-coded shifts and small heart icons.
Report this item to Etsy

2027 Shift Work Calendar Spreadsheet, Pitman 4on4off 24/48 DuPont Rotation Planner, Overtime Pay Estimator, Google Sheets & Excel

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

Seller's description

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 file (You > Purchases and reviews > Download Files).
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.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$9.99

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: A 2027 shift calendar titled Your Whole 2027 Shift Year with the subtitle Pick your rotation, enter one date you worked — the year fills in. The grid displays twelve months with color-coded shift rotations labeled D, N, 24-hr, O, and E.

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 file (You > Purchases and reviews > Download Files).
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.

  • Designed by
    QuickUtility
  • Item type
    Digital download
  • Digital file type(s)
    1 PDF, 1 other file
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

Joseph
QuickUtility ·

United States

No reviews yet
·
0 sales
·
New on Etsy

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Social Work Planner

Quickbooks Setup

Legal Assistant Planner

Shift Calendar

Bankruptcy Spreadsheet

Shift Planner

Listed on Nov 5, 2026
Homepage Paper & Party Supplies Paper Calendars & Planners