Spreadsheet: 185832d1349858822-sorting-non-empty-cells-to-bottom-schedule-example
Sheet: December

CSS/CAS |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4 | DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  | DEEPS | DAYS | EVENINGS
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | MEYER | HENSLEY
TERI |  | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  | H | H | X | X | X |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEYER | HENSLEY | MEYER
LISA H |  |  | X | X | X | TD | H | V | V | X | X | X |  |  |  |  | X | X | X | TD | V | V | H | X | X | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HENSLEY | [NAME] | [NAME]
2000-0600 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARRELL | AULTZ | BOYETTE
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AULTZ | BOYETTE | AULTZ
[NAME] |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V | V | V | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BOYETTE | HARRELL | HARRELL
CHRISTY |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  | FH | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRANDON | BRANDON | BRANDON
STEPHANIE |  | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V |  | V | V | V | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIPTRAP | LIPTRAP | LIPTRAP
DEBBIE |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
DANNEL |  | X | V | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
JESSIE |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
JESS |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COOPER | COOPER | COOPER
CHARITY L |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COX | COX | COX
ADMIN 8 |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CECIL | CECIL | CECIL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HARPER | HARPER | HARPER
CSS/CAS |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EDWARDS | EDWARDS | EDWARDS
CINDY |  | X | X |  |  |  |  |  | X | X |  |  |  |  |  | X | X |  |  |  |  |  | X | X | V | V | V | V | V | X | X | H |  | V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRUSSELL | CRUSSELL | CRUSSELL
JULIE |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOOK | HOOK | HOOK
0600-1600 |  | \ | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TATE | TATE | TATE
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHILLIPS | PHILLIPS | PHILLIPS
[NAME] |  | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOWLER | FOWLER | FOWLER
CHERYL |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PALMER | PALMER | PALMER
VAL |  | X |  |  |  |  | X | X | X | V |  |  |  | X | X | X |  |  | V | V | X | X | X | V | V |  |  | X | X | X |  |  |  |  |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CANTISANO | CANTISANO | CANTISANO
RHONDA |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  | V | V | X | X | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESPINOZA | ESPINOZA | ESPINOZA
KATY |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V | H | H | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WALKER | WALKER | WALKER
[NAME] |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
KELLY |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  | TD | H |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAYHALL | MAYHALL | MAYHALL
1000-2000 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THOMAS | THOMAS | THOMAS
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRANCH | BRANCH | BRANCH
TAMMY |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOOD | HOOD | HOOD
ADMIN 7 |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X |  | X | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOVATO | LOVATO | LOVATO
ADMIN 8 |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MORRIS | MORRIS | MORRIS
CSS/CAS |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F
ANGELA H |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V |  |  | X | X | X |  |  |  |  | X | X |  | X
CHAD |  | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X
1000-2000 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F
ALANA |  | X | X | X |  | V | V | V | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V |  |  | X | X | X
LACY |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  | H | X | X | X |  |  |  |  | X | X |  | X
JESSICA |  | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X
1200-2200 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F
ANGELA |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  | V | V | X | X | X |  |  |  |  |  | X | X | X
KAY |  | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V |  |  |  |  | X
MARK |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X
ADMIN 5 |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X
1600-0200 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 1 | 2 | 3 | 4
EMPLOYEE | PHONE | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |  | T | W | T | F
BRANDY |  | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | H |  |  |  | X | X | X | H |  | H |  |  | X
NICOLE |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X |  | X
CHARITY E |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X
KATHY |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X | V | V | H | H | X | X | X |  |  |  |  |  | X | X | X
ADMIN 6 |  |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  | X | X | X |  |  |  |  |  | X | X | X
 | TOTAL ON DUTY
 | TOTAL ON DUTY
 | TOTAL ON DUTY