Pro workbook: Week, Rotation, People, Setup, Formulas. Sample data, real formulas.
| Chore chart | |||||||||||||||||||||
| Who has which chore this week comes from the rotation. Tick a day when it's done — anything in the cell counts. | |||||||||||||||||||||
| Week starting | 21 Sep | ||||||||||||||||||||
| Rotation start | 5 Jan | ||||||||||||||||||||
| Week number | 37 | ||||||||||||||||||||
| People | 4 | ||||||||||||||||||||
| 21 | 22 | 23 | 24 | 25 | 26 | 27 | |||||||||||||||
| Chore | Room | Per wk | Mins | Turn | Whose | Mo | Tu | We | Th | Fr | Sa | Su | Done | Mins | Left | Person | Chores | Done | Mins | Share | |
| Wash up | Kitchen | 7 | 10 | 1 | Sam | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 7 | 70 | Alex | 3 | 11 | 115 | 21.1% | ||
| Wipe counters | Kitchen | 7 | 5 | 2 | Nina | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 30 | 1 | Sam | 4 | 15 | 290 | 53.2% | ||
| Take out rubbish | Kitchen | 3 | 5 | 3 | Theo | 1 | 1 | 2 | 10 | 1 | Nina | 4 | 10 | 95 | 17.4% | ||||||
| Empty dishwasher | Kitchen | 7 | 10 | 4 | Alex | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 60 | 1 | Theo | 3 | 4 | 45 | 8.3% | ||
| Cook dinner | Kitchen | 5 | 40 | 1 | Sam | 1 | 1 | 1 | 1 | 4 | 160 | 1 | |||||||||
| Hoover the lounge | Lounge | 2 | 15 | 2 | Nina | 1 | 1 | 2 | 30 | ||||||||||||
| Dust surfaces | Lounge | 1 | 15 | 3 | Theo | 1 | 1 | 15 | |||||||||||||
| Water plants | Lounge | 2 | 5 | 4 | Alex | 1 | 1 | 2 | 10 | ||||||||||||
| Clean the loo | Bathroom | 2 | 10 | 1 | Sam | 1 | 1 | 2 | 20 | Fair share | 25.0% | ||||||||||
| Clean the shower | Bathroom | 1 | 20 | 2 | Nina | 1 | 1 | 20 | |||||||||||||
| Mop the floors | Hall | 1 | 20 | 3 | Theo | 1 | 1 | 20 | |||||||||||||
| Laundry: wash | Utility | 3 | 15 | 4 | Alex | 1 | 1 | 1 | 3 | 45 | |||||||||||
| Fold and put away | Utility | 2 | 20 | 1 | Sam | 1 | 1 | 2 | 40 | ||||||||||||
| Change bed sheets | Bedrooms | 1 | 15 | 2 | Nina | 1 | 1 | 15 | |||||||||||||
| Ticks per day | 5 | 5 | 6 | 5 | 4 | 12 | 3 | 40 | 545 | ||||||||||||
| Week done | 90.9% | of the week's target | |||||||||||||||||||
| Whose = the person whose turn it is: (week number + the chore's turn) wrapped around the people list. Change Turn to reshuffle who starts on what. | |||||||||||||||||||||
| Per wk is the target; Left is what's still owed this week and turns green at zero. Minutes = ticks × minutes, and that's what Share is worked out on. |
| Eight weeks ahead | |||||||||
| The same rotation, rolled forward. Nobody has to remember whose turn it is. | |||||||||
| 21 Sep | 28 Sep | 5 Oct | 12 Oct | 19 Oct | 26 Oct | 2 Nov | 9 Nov | ||
| Chore | Turn | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 |
| Wash up | 1 | Sam | Nina | Theo | Alex | Sam | Nina | Theo | Alex |
| Wipe counters | 2 | Nina | Theo | Alex | Sam | Nina | Theo | Alex | Sam |
| Take out rubbish | 3 | Theo | Alex | Sam | Nina | Theo | Alex | Sam | Nina |
| Empty dishwasher | 4 | Alex | Sam | Nina | Theo | Alex | Sam | Nina | Theo |
| Cook dinner | 1 | Sam | Nina | Theo | Alex | Sam | Nina | Theo | Alex |
| Hoover the lounge | 2 | Nina | Theo | Alex | Sam | Nina | Theo | Alex | Sam |
| Dust surfaces | 3 | Theo | Alex | Sam | Nina | Theo | Alex | Sam | Nina |
| Water plants | 4 | Alex | Sam | Nina | Theo | Alex | Sam | Nina | Theo |
| Clean the loo | 1 | Sam | Nina | Theo | Alex | Sam | Nina | Theo | Alex |
| Clean the shower | 2 | Nina | Theo | Alex | Sam | Nina | Theo | Alex | Sam |
| Mop the floors | 3 | Theo | Alex | Sam | Nina | Theo | Alex | Sam | Nina |
| Laundry: wash | 4 | Alex | Sam | Nina | Theo | Alex | Sam | Nina | Theo |
| Fold and put away | 1 | Sam | Nina | Theo | Alex | Sam | Nina | Theo | Alex |
| Change bed sheets | 2 | Nina | Theo | Alex | Sam | Nina | Theo | Alex | Sam |
| Every column is the same formula with one more week added, so the list keeps turning as long as the people list stays the same. | |||||||||
| Add or remove a person on Setup and the whole table re-deals from the week you're in. |
| Who does what | ||||||||
| This week per person: chores held, how many are done, what's still owed and the share of the minutes. | ||||||||
| Person | Chores | Target | Done | Left | Minutes | Share | Fair share | Difference |
| Alex | 3 | 12 | 11 | 1 | 115 | 21.1% | 25.0% | -3.9% |
| Sam | 4 | 16 | 15 | 1 | 290 | 53.2% | 25.0% | 28.2% |
| Nina | 4 | 11 | 10 | 1 | 95 | 17.4% | 25.0% | -7.6% |
| Theo | 3 | 5 | 4 | 1 | 45 | 8.3% | 25.0% | -16.7% |
| Share is of the minutes actually done, not of the chores held — a forty-minute dinner is not a five-minute bin run. | ||||||||
| Difference is share minus fair share: pink means more than their turn this week, green means less. Over a rotation it should even out. |
| Setup | ||||
| The week, the rotation start, who's in the house and the chores. | ||||
| Week starting | 2026-09-21 | Any Monday | ||
| Rotation start | 2026-01-05 | The week everyone's turn was 1 | ||
| People | ||||
| Alex | ||||
| Sam | ||||
| Nina | ||||
| Theo | ||||
| Chore | Room | Per week | Minutes | Turn |
| Wash up | Kitchen | 7 | 10 | 1 |
| Wipe counters | Kitchen | 7 | 5 | 2 |
| Take out rubbish | Kitchen | 3 | 5 | 3 |
| Empty dishwasher | Kitchen | 7 | 10 | 4 |
| Cook dinner | Kitchen | 5 | 40 | 1 |
| Hoover the lounge | Lounge | 2 | 15 | 2 |
| Dust surfaces | Lounge | 1 | 15 | 3 |
| Water plants | Lounge | 2 | 5 | 4 |
| Clean the loo | Bathroom | 2 | 10 | 1 |
| Clean the shower | Bathroom | 1 | 20 | 2 |
| Mop the floors | Hall | 1 | 20 | 3 |
| Laundry: wash | Utility | 3 | 15 | 4 |
| Fold and put away | Utility | 2 | 20 | 1 |
| Change bed sheets | Bedrooms | 1 | 15 | 2 |
| Eight people rows and twenty chore rows. Leave the spares empty — every count here ignores blanks. | ||||
| Turn is the chore's place in the queue. Give four chores turns 1–4 and they land on four different people in the same week. |
| How the formulas work | ||
| Every formula in this workbook, in plain words. No macros, nothing hidden. Formulas are shown without the leading = sign. | ||
| Where | Formula | What it does |
| Week · Week number | INT((B3-B4)/7) | Whole weeks between the rotation start and the week you're looking at. Two dates subtract to a number of days; INT drops the remainder. |
| Week · Whose | INDEX(crew,MOD($B$5+$E10-1,$B$6)+1) | Walks the people list round and round. MOD wraps the count back to zero when it passes the end of the list, and the +1 turns a 0-based position into INDEX's 1-based one. |
| Week · Done | IF($A10="",0,COUNTA(G10:M10)) | Counts non-empty day cells — a 1, an x, a name, anything. An empty day means it didn't happen; don't type 0, that counts as a tick. |
| Week · Left | IF($A10="",0,MAX(0,$C10-N10)) | What's still owed this week. MAX(0,…) stops it going negative when someone does more than the target. |
| Week · Share | R10/SUM($U$10:$U$17) | Each person's minutes over everyone's minutes. Minutes, not chores — a forty-minute dinner and a five-minute bin run are not the same favour. |
| Week · person totals | SUMPRODUCT(($F$10:$F$29=$R10)*$O$10:$O$29) | Adds up one column where another column matches a name. SUMPRODUCT does the whole 'if the name matches, add the minutes' in one go — no helper column, and it works the same in Google Sheets. |
| Rotation · cell | INDEX(crew,MOD(Week!$B$5+1+$B6-1,Week!$B$6)+1) | The Week formula with the column's week offset added, so each column is one week further on. |
| People · Difference | G6-H6 | Share of the minutes minus the fair share (1 ÷ number of people). Pink over five points, green under — one week is noisy, a rotation should even out. |