A week of shifts: people down the side, seven days across, a shift code per cell from a dropdown — hours and pay per person come from the code table, headcount per day is counted. Pro adds coverage against required staffing per shift, payroll with overtime, and a formulas walkthrough. No macros.
Eight people × 7 days. Codes M/E/N/D/O from a dropdown, coloured. Hours per person from the code table (SUMPRODUCT + SUMIF, no XLOOKUP), pay from the rate, on-shift count per day, over 40 hours flagged.
Scheduled against required per shift per day: red when short, yellow when over, green when exact. A double covers morning and evening. Counts of shifts short and over.
Regular hours up to the threshold, overtime above it at the multiplier, pay per person with bars, total overtime cost.
Week start, codes with start/end/hours, required per shift, the team with hourly rates, overtime threshold and multiplier.
Eight formulas explained.
Every workbook is recalculated in LibreOffice and by a second, independent formula engine on the sample data; the totals are compared with numbers worked out outside any spreadsheet, and every formula cell is scanned for errors. We don't run Excel itself on the build machine, so this says built for, not tested in — open the live preview to see the numbers the formulas produce.
The home page and its CSS — enough to publish a one-pager. A credit link stays in the footer.
Every page, the Pro-only pages, the source files, no attribution, and 12 months of updates and email support.
Use it for unlimited personal and commercial purposes, including client work.
Do not resell the spreadsheet itself, alone or in a bundle.
Each cell is a shift code from a dropdown. The hours for a person’s week come from one
formula — SUMPRODUCT(SUMIF(codes, row, hours)) — which looks up all seven codes in the
shift table at once and adds the hours. It’s the portable way to do it: no XLOOKUP, no
helper row, works in Excel 2016 and Numbers. Change a code’s hours on Setup and every total
follows.
Coverage counts how many people are on each shift each day and colours the cell against what Setup says you need — red short, yellow over. Doubles count for both morning and evening. Payroll splits hours at the overtime threshold, applies the multiplier, and shows what overtime is costing above plain rate.
The build recalculates the workbook in LibreOffice and in a second, independent engine on the sample rota and compares eleven values — hours for two people, one over 40, pay, on-shift counts, coverage, overtime hours and the payroll total — against numbers computed outside Excel.
First release
Type a year and a month and the calendar redraws itself: weekends shaded, today blue, other months greyed, and your events written into the right days from a list. Pro adds the whole year on one sheet, a week planner, holidays, and a formulas walkthrough. No macros.
Type in and out as times and a break in hours; hours and overtime are calculated, night shifts past midnight included. Pro adds a log with projects and hourly rates, billable amounts per project and per week, distinct days worked, and a formulas walkthrough. No macros.
A to-do list that knows what's late: task, category, priority, due date and a ✓ when done; status (Done, Overdue, Today, Soon, Open), days left and a progress bar are calculated. Pro adds a Focus sheet listing what's overdue and due this week, a Board with counts per category, person and priority, and a formulas walkthrough. No macros.