1 | For the week of: | Element 52 Housekeeping Log | Updated: | 1/26/2014 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|
2 | 1/27-2/2 | Monday | Tuesday | Wednseday | Thursday | Friday | Saturday | Sunday | |||
3 | Unit # | 1/27/2014 | 1/28/2014 | 1/29/2014 | 1/30/2014 | 1/31/2014 | 2/1/2014 | 2/2/2014 | Notes | ||
4 | A4 | ||||||||||
5 | A6 | Pre-Arrival | Arrival | Owner | 2/1 Owner arrival | ||||||
6 | A8 | ||||||||||
7 | A11 | ||||||||||
8 | A12 | Pre-Arrival | Arrival | Owner | Owner | 1/31 Owner arrival | |||||
9 | A13 | ||||||||||
10 | A14 | ||||||||||
11 | RB | Pre-Arrival | Arrival | Daily | |||||||
12 | E3 | Dep Clean | |||||||||
13 | E4 | ||||||||||
14 | E5 | Daily | Daily | Dep Clean | 1/29/2014 | ||||||
15 | E6 | ||||||||||
16 | S1B | ||||||||||
17 | C103 | ||||||||||
18 | W101 | Pre-Arrival | Arrival | Gift Cert | Gift Cert | Dep Clean | 1/30 Arrival: Gift Certificate does not include daily HSK | ||||
19 | W102 | Pre-Arrival | Arrival | Owner | Owner | Owner | Arrival date changed to 1/30 | ||||
20 | W201 | ||||||||||
21 | W202 | ||||||||||
22 | W301 | Daily | Daily | Turnover | Daily | Daily | Daily | Daily | |||
23 | W302 | ||||||||||
24 | W303 | ||||||||||
25 | SW301 | ||||||||||
26 | Spa | ||||||||||
27 | Fitness | Daily | Daily | Daily | Daily | Daily | Daily | Daily | |||
28 | Lobby | Daily | Daily | Daily | Daily | Daily | Daily | Daily | Total | ||
29 | |||||||||||
30 | Pre-Arrival | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 5 | ||
31 | Dep Clean | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | ||
32 | Arrival | 0 | 0 | 0 | 2 | 1 | 2 | 0 | 5 | ||
33 | Daily | 2 | 2 | 0 | 1 | 1 | 1 | 2 | 9 | ||
34 | Turnover | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | ||
35 | |||||||||||
36 | |||||||||||
37 | spreadsheet locale | question in Google Docs User forum by Matthew Eisenberg | |||||||||
38 | United States | https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/-s9-Qd2xAoI | |||||||||
39 | Google New Sheets | ||||||||||
40 | yogi_get count of each of the items listed in cells B30:B34 in each column of range C4:I26 Marked with red chain dotted line | ||||||||||
41 | formula in cell C30 for cells C30:C34 | ||||||||||
42 | =ArrayFormula(countif(C4:C26,$B30:$B34)) | ||||||||||
43 | this formula is then dragged to the right to copy to cells D30:I30 | ||||||||||
44 | and | ||||||||||
45 | formula in cell J30 for cells J30:J34 | ||||||||||
46 | =ArrayFormula(mmult(C30:I34,transpose(column(C30:I30)^0))) | ||||||||||
47 |