A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Enter Start Date for Chart >>> | 9/8/2013 | created by Casey Slide of MoneyCrashers.com | http://www.moneycrashers.com/weekly-house-cleaning-schedule-template-checklist-chart-printable/ | ||||||||||||||||||||||||||||||||
2 | Week 1 | Week 2 | Week 3 | Week 4 | ||||||||||||||||||||||||||||||||
3 | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | SU | M | T | W | TH | F | SA | ||||||||
4 | CHORES | Frequency AND Day of Week | Sept 8 | 9/9 | 9/10 | 9/11 | 9/12 | 9/13 | 9/14 | 9/15 | 9/16 | 9/17 | 9/18 | 9/19 | 9/20 | 9/21 | 9/22 | 9/23 | 9/24 | 9/25 | 9/26 | 9/27 | 9/28 | 9/29 | 9/30 | 10/1 | 10/2 | 10/3 | 10/4 | 10/5 | ORDER OF NAMES for this job | |||||
5 | Load Dishwasher & Hand Wash Dishes | B | J | J | J | M | J | J | B | J | J | J | M | J | J | B | J | J | J | M | J | J | B | J | J | J | M | J | J | |||||||
6 | Put All Dishes Away/Put Away Dinner leftovers AND keep counters wiped down all day | M | B | M | M | J | B | M | M | B | M | M | J | B | M | M | B | M | M | J | B | M | M | B | M | M | J | B | M | |||||||
7 | Cook Dinner | J | M | B | M | J | M | B | J | M | B | M | M | J | B | J | M | B | M | J | M | B | J | M | B | M | M | J | B | |||||||
8 | Make a 4-week Menu | M | ||||||||||||||||||||||||||||||||||
9 | Make grocery list accordingly | B | ||||||||||||||||||||||||||||||||||
10 | Mop Entire House include both Bathrms - Coordinate with person assigned Sweeping for this day | Weekly - Fridays | J | M | J | M | JM | |||||||||||||||||||||||||||||
11 | Deep clean kitchen/dining room (Refer to Deep Cleaning sheet for what needs to be included in your cleaning) | EOW | B | M | B | M | BM | |||||||||||||||||||||||||||||
12 | Deep clean bathrooms (Refer to Deep Cleaning sheet for what needs to be included in your cleaning) | EOW | M&J | B | M&J | B | M&J,B | |||||||||||||||||||||||||||||
13 | Deep clean bedrooms (Refer to Deep Cleaning sheet for what needs to be included in your cleaning) | 1XM | M | B | M | B | MB | |||||||||||||||||||||||||||||
14 | Deep clean living and laundry rooms (Refer to Deep Cleaning sheet for what needs to be included in your cleaning) | Weekly - Tuesdays | B | M | B | M | BM | |||||||||||||||||||||||||||||
15 | Pull Weeds | Weekly on Mondays for 20 min. | MJB | MJB | MJB | MJB | ||||||||||||||||||||||||||||||
16 | Wash Car | EOW | B | J | B | J | BJ | |||||||||||||||||||||||||||||
17 | ||||||||||||||||||||||||||||||||||||
18 | If you look at my blog post: yogi_Set Up Formula To Print Only Chosen Cells Within A Google Spreadsheet http://yogi--anand-consulting.blogspot.com/2013/08/yogiset-up in the sheet named yogi_Checklist: 1) I entered in cell B3 date for WeekOf for which the data is to be printed 2) in cell B3, I entered the name of the individual for which the data is to be printed 3) then I created a new sheet named yogi_Set Up Formula To Print Only Chosen Cells Within A Google Spreadsheet ... then in cell A1 of the newly created sheet I entered the following formula: =filter(query(ArrayFormula(if({1,1,1,1,1,1,1,0,0};(index(yogi_Checklist!A1:IV1,1,match(yogi_Checklist!B2,yogi_Checklist!E4:4;0)+columns(yogi_Checklist!A:E)-1):index(yogi_Checklist!A1:IV34,0,(match(yogi_Checklist!B2,yogi_Checklist!E4:4;0)+columns(yogi_Checklist!A:E)-1)+6))&"";if({0,0,0,0,0,0,0,1,0};yogi_Checklist!A1:A34;yogi_Checklist!B1:B34))); "select Col8,Col9,Col1,Col2,Col3,Col4,Col5,Col6,Col7");ArrayFormula(mmult(ArrayFormula(if(row(YY1:YY34)<5,1,if(ArrayFormula(index(yogi_Checklist!A1:IV1,1,match(yogi_Checklist!B2,yogi_Checklist!E4:4;0)+columns(yogi_Checklist!A:E)-1):index(yogi_Checklist! A1:IV34,0,(match(yogi_Checklist!B2,yogi_Checklist!E4:4;0)+columns(yogi_Checklist!A:E)-1)+6))=yogi_Checklist!B3,1,"")));transpose(column(yogi_Checklist!A:G)^0)))) Make It A Great One Cheers! Yogi | |||||||||||||||||||||||||||||||||||
19 | ||||||||||||||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||||||||||||
21 | ||||||||||||||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||||||||||||
23 |