| Staff |
1
SUN
|
2
MON
|
3
TUE
|
4
WED
|
5
THU
|
6
FRI
|
7
SAT
|
8
SUN
|
9
MON
|
10
TUE
|
11
WED
|
12
THU
|
13
FRI
|
14
SAT
|
15
SUN
|
16
MON
|
17
TUE
|
18
WED
|
19
THU
|
20
FRI
|
21
SAT
|
22
SUN
|
23
MON
|
24
TUE
|
25
WED
|
26
THU
|
27
FRI
|
28
SAT
|
29
SUN
|
30
MON
|
31
TUE
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ASSISTANT MANAGER
|
|||||||||||||||||||||||||||||||
|
COOK
|
|||||||||||||||||||||||||||||||
|
COOK / BUTLER
|
|||||||||||||||||||||||||||||||
|
COOK / BUTLER
|
|||||||||||||||||||||||||||||||
|
HK / BUTLER
|
|||||||||||||||||||||||||||||||
|
HK / BUTLER
|
|||||||||||||||||||||||||||||||
|
HK / BUTLER
|
|||||||||||||||||||||||||||||||
|
HK / BUTLER
|
|||||||||||||||||||||||||||||||
|
SECURITY
|
|||||||||||||||||||||||||||||||
|
VILLA LEADER
|
Copy a block from your Excel sheet and paste below. Tab-separated columns: Staff name · Day 1 · Day 2 · β¦ · Day 31.
Cell values: a number (hours), or one of OFF / EO / PH / AL / SL+ / SL- / OT 4 / DS / FULL. Empty cells clear that day.
A header row that starts with "Name" / "Staff" / day numbers is auto-skipped. Staff names are matched against active staff (case-insensitive).
| Staff | Total Hours | OT Hours | DS Hours | DS days | AL | PH | SL | OFF | EO | FULL |
|---|---|---|---|---|---|---|---|---|---|---|
|
JODY
ASSISTANT MANAGER
|
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|
ALIA
COOK
|
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|
NUZUL
COOK / BUTLER
|
133.5 | 0 | 0 | 0 | 0 | 1 | 0 | 4 | 0 | 0 |
|
RETHA
COOK / BUTLER
|
136 | 0 | 0 | 0 | 0 | 1 | 0 | 5 | 0 | 0 |
|
BAYU
HK / BUTLER
|
326 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 0 |
|
BERLIAN
HK / BUTLER
|
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|
KIM
HK / BUTLER
|
356 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 0 |
|
OBI
HK / BUTLER
|
318 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 1 | 0 |
|
YOPIE
SECURITY
|
552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 |
|
VENAND
VILLA LEADER
|
189 | 0 | 0 | 0 | 0 | 4 | 0 | 3 | 1 | 0 |