Housekeeping Schedule template using Pivot Method
Unit
E016-0
E259-0
E693-0
P,118-1
P,118-2
P,318-1
P,328-2
P'1011-2
P'3201-0
P'9201-0
P*319-1
P*9191-0
P1111-12
P128-1
P128-3
P128-5
P128-6
P9121-0
Pe-2271
S007-106
S015-A
S207-2
Work Type
HK Clean /DOG
HK Clean /DOG
HK Clean /DOG
HK Clean: HK#1 A, 2
HK Clean
HK Clean: HK#1 A, 2
HK Clean
SAME DAY! HK Clean
SAME DAY! HK Clean
HK Clean /DOG
HK Clean
SAME DAY! HK Clean: HK#1 A, 2
SAME DAY! HK Clean
SAME DAY! HK Clean: HK#1 A, 2
HK Clean
HK Clean
SAME DAY! HK Clean
HK Clean: HK#1 A, 2
HK Clean: HK#1 A, 2
SAME DAY! HK Clean /DOG
HK Clean /DOG
HK Clean
Total Beds
Total HK needed
Additional HKs needed
BR
HKs
HKs
Hours
Hours
Needed Assigned Needed Assigned
HK 1
Hours
Assigned
2
1
1
4.5
4.5
Oralia Soto
4.5
-
-4
-
-
-
-
(SUB) Guadalupe Sanchez
(SUB) Guadalupe Sanchez
(SUB) Susi Lopez
(SUB) Susi Lopez
(SUB) Susi Lopez
Luz Maria Hernandez
Juana Arango
Araceli Avendano
Brenda alejo
Juana Cruz
(SUB) Sergio Santiago
Maira Ortiz
(SUB) Sergio Santiago
Destiny Moreno
Destiny Moreno
Azucena Ramirez
(SUB) Maribel Cruz Velasco
(SUB) Maribel Cruz Velasco
Maria Salazar
Juana Arango
Norma Ortiz Perez
6
6
6
6
HK 2
(SUB) Guadalupe Sanchez
(SUB) Susi Lopez
Hours
Assigned
6
6
HK 3
Hours
Assigned
Employee
Hours
(SUB) Guadalupe Sanchez
6
(SUB) Maribel Cruz Velasco
6
(SUB) Sergio Santiago
6
(SUB) Susi Lopez
6
Araceli Avendano
6
Azucena Ramirez
6
3
6
4
6
Brenda alejo
6
Destiny Moreno
-
Guadalupe Sanchez De Nieto
Juana Cruz
Juana Arango
Luz Maria Hernandez
6
Maira Ortiz
Maria Salazar
4.5
3
4.5
4
1.5
4
Norma Ortiz Perez
Oralia Soto
Total HKs
Assigned
Status
-
Assigned
Assigned
Assigned
Assigned
Assigned
Assigned
Assigned
Assigned
Available
Assigned
Assigned
Assigned
Assigned
Assigned
Assigned
Assigned
4
Hrs
Hrs
Assigned Assigned
as HK1
as HK-
-
Hrs
Assigned
as HK3
Hrs Left
-
-
Hours Assigned-