Spreadsheet: 122626d1317033347-help-on-designing-a-workbook-wcb-sandbox2
Sheet: Day 2

Area | Unit | Type | Total Pay | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 1
Zone 1 | 54 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 1 | 62 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 1 | 5 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 1 | 4 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 1 | 21 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 48 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 3 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 18 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 4 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 5 | L | 7.65 | 3.825 | Jon C | Shaun G
Zone 2 | 82 | L | 7.65 | 3.825 | Jon C | Shaun G
Total Cleans | 11 |  | 84.15 | 42.075 | 42.075 | 42.075
Area | Unit | Type | Total Pay | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 2
Zone 3 | 68 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 3 | 70 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 3 | 71 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 3 | 73 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 3 | 76 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 4 | 80 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 4 | 82 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 4 | 83 | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 4 | 83A | L | 7.65 | 3.825 | Sonia B | [NAME]
Zone 4 | 86 | L | 7.65 | 3.825 | Sonia B | [NAME]
Total Cleans | 10 |  | 76.5 | 38.25 | 38.25 | 38.25
Area | Unit | Type | Total Pay | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 3
Zone 5 | 88 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 5 | 90 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 5 | 95 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 5 | 97 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 5 | 99 | P | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 5 | 2 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 6 | 5 | P | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 6 | 12 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 6 | 11 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Zone 6 | 12 | L | 7.65 | 2.55 | [NAME] | [NAME] | Zoe M
Total Cleans | 10 |  | 76.5 | 25.5 | 25.5 | 25.5 | 25.5
Area | Unit | Type | Total Pay | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 4
Zone 6 | 27 | P | 7.65 | 3.825 | [NAME] | [NAME]
Zone 6 | 39 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 6 | 44 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 61 | P | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 6 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 10 | P | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 11 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 27 | L | 7.65 | 3.825 | [NAME] | [NAME]
Zone 7 | 37a | L | 7.65 | 3.825 | [NAME] | [NAME]
Total Cleans | 9 |  | 68.85 | 34.425 | 34.425 | 34.425
Area | Unit | Type | Total Pay | Per Cleaner | Cleaner 1 | [NAME] | Cleaner 3 | [NAME]
Team 5
Zone 6 | 1 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Zone 6 | 56 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Zone 6 | 57 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Zone 7 | 58 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Zone 7 | 59 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Zone 7 | 60 | L | 7.65 | 1.9125 | Kylie B | Michaela H | [NAME] | [NAME]
Total Cleans | 6 |  | 45.9 | 11.475 | 11.475 | 11.475 | 11.475 | 11.475