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.
What that means app by app: in Google Sheets, in Apple Numbers, in LibreOffice Calc.
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.
An employee schedule is one letter per person per day; everything else should follow from that.
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
Chores down the side, seven days across, and a rotation that says whose turn each one is this week — change the date and the chart re-deals itself. Ticks, minutes and what's still owed are calculated, and each person's share is worked out on minutes, not on the number of chores. Pro adds eight weeks of the rotation printed ahead and a People sheet comparing everyone against a fair share. No macros.
Type any date and the week lays itself out: seven day columns with real dates, fifteen time slots from the hour you start, weekends shaded, today highlighted. Planned and free hours per day are counted. Pro adds a Priorities sheet whose top three show on the week, a Friday Review sheet, and a formulas walkthrough. No macros.
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.