The rotation does the arguing
Every chore carries a turn number. Who has it this week is that many places along the
people list, walked round and round: INDEX(crew, MOD(week number + turn − 1, people) + 1).
The week number is whole weeks since a rotation start date you set once, so changing the week
at the top re-deals the whole chart — nothing to drag, nothing to retype.
Give four chores turns 1, 2, 3 and 4 and they land on four different people in the same week.
Give two chores the same turn and they always travel together, which is what you want for
“cook dinner” and “wash up”.
Share is measured in minutes
Each chore has a minutes-per-go number, and a person’s share is of the minutes actually done —
not of the chores held. A forty-minute dinner and a five-minute bin run are not the same
favour, and a chart that counts them the same is the reason chore charts get abandoned. The
People sheet puts that share next to a fair share (1 ÷ the number of people) and colours the
difference: pink over five points, green under.
Pro: eight weeks on the fridge
Rotation prints the next eight weeks in one table — the same formula with the column’s week
offset added — so the chart can go on the wall once instead of being redone every Sunday. Add
or remove a person on Setup and the whole table re-deals from the week you’re in.
Checked, not just built
The build recalculates both workbooks in LibreOffice and in a second, independent engine, then
compares nineteen values — who each chore lands on, ticks and minutes per chore, what’s left,
the week’s totals and completion, per-person counts, minutes and share, and the rotation one
week on — against numbers computed outside Excel. It also scans every formula in the file for
error cells.