Spreadsheet: 725931d1616980285-sorting-and-filter-copy-of-staffing-guide-2020-2021
Sheet: Current Staffing Guide

I want to be able to filter the employees in column C along with thier times in cloumn D by the worksites highlighted in blue in column A .  Like in cloumn B and C.                                                                                 The info in column C and D will be copied and pasted from  an excel sheet generated by our [NAME] time clock software.                                                                                  Any of the employees listed in column A could appear in column E if they clock out past thier scheduled time.
Blue cells are the work site names and the names of the staff assigned to each worksite |  |  |  | Below are the names of emoplyees with late out clock punch times.
Avalon Middle -- 5               Worksite # 17 |  |  | [NAME] | [NAME], [NAME] | 0.2
[NAME] |  |  | Megan Antonacci | Antonacci, Megan | 0.2
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.633333
[NAME] | [NAME] | 0.066667 | [NAME] | Barrow, [NAME] | 0.066667
[NAME] |  |  | [NAME] | Bauer, Billie J | 0.666667
[NAME] |  |  | [NAME] | Bloodworth, [NAME] D | 0.266667
 |  |  | [NAME] | Bohlman, [NAME] | 0.05
[NAME] -- 4      Worksite # 1 |  |  | [NAME] | Bravo, [NAME] | 0.7
[NAME] |  |  | Vanessa Cable | Cable, [NAME] | 0.45
[NAME] |  |  | [NAME] | Cintron, [NAME] | 0.933333
[NAME] |  |  | [NAME] | Clowers, [NAME] | 0.033333
[NAME] |  |  | [NAME] | Coddington, [NAME] | 0.083333
[NAME] | [NAME] | 0.416667 | [NAME] | [NAME], [NAME] | 0.383333
 |  |  | [NAME] | Cornell, [NAME] | 0.05
[NAME] Elem.-- 6     Worksite #13 |  |  | Kimberly N Dorner | Dorner, Kimberly N | 0.016667
[NAME] |  |  | [NAME] | Earnshaw, [NAME] | 0.016667
[NAME] |  |  | Gina R Franklin | Franklin, [NAME] R | 0.066667
[NAME] |  |  | Robbi D Glover | Glover, Robbi D | 0.1
[NAME] |  |  | [NAME] | Goodman, [NAME] | 0.2
[NAME] |  |  | Starr B Grimes | Grimes, [NAME] B | 0.55
[NAME] | [NAME] | 0.483333 | [NAME] | Hernandez, [NAME] | 0.483333
 |  |  | [NAME] | Hinesley, [NAME] | 0.133333
Berryhill Elementary -- 7       Worksite #2 |  |  | [NAME] | [NAME], [NAME] | 0.333333
[NAME] |  |  | Julia M Iaconelli | Iaconelli, Julia M | 0.133333
Amber Hulett |  |  | Amanda K Jones | Jones, Amanda K | 0.466667
[NAME] |  |  | [NAME] | Kramp, Louis | 0.033333
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.366667
[NAME] |  |  | Lana L Lindsey | Lindsey, Lana L | 0.116667
[NAME] |  |  | [NAME] | Lopez, [NAME] | 0.183333
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.416667
[NAME] |  |  | [NAME] | Mcandrew, [NAME] | 0.433333
 |  |  | [NAME] | Mills, [NAME] R | 0.316667
Central School -- 5                  Worksite #24 |  |  | [NAME] | Noa, [NAME] | 0.066667
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.133333
[NAME] |  |  | [NAME] | Paige, [NAME] | 0.116667
[NAME] |  |  | [NAME] | Pascoe, [NAME] | 0.783333
[NAME] |  |  | Karen T Petsch | Petsch, [NAME] T | 0.65
[NAME] |  |  | Geneva Phillips | Phillips, Geneva | 0.083333
 |  |  | [NAME] | Pine, [NAME] | 0.7
Chumuckla Elementary-- 3   Worksite #3 |  |  | [NAME] | Prescott, [NAME] | 1.05
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.2
[NAME] |  |  | [NAME] | Rodriguez Colon, Gisela | 0.7
[NAME] |  |  | [NAME] | Rohrer, [NAME] | 0.683333
 |  |  | [NAME] | Sadler, [NAME] | 0.183333
Dixon Primary-- 5                   Worksite #5 |  |  | Liane Scallan-Grew | Scallan-Grew, [NAME] | 0.2
[NAME] |  |  | [NAME] | Sedlacek, [NAME] | 0.15
Jan Van Voorhis |  |  | Lola J Simmons | Simmons, Lola J | 0.566667
[NAME] |  |  | [NAME] | Spivey, Rebekah | 0.033333
[NAME] |  |  | [NAME] | Staten, [NAME] | 0.333333
 |  |  | Saori Stone | Stone, Saori | 0.15
 |  |  | [NAME] | [NAME], [NAME] | 0.433333
Dixon Intermediate-- 5          Worksite #4 |  |  | [NAME] | [NAME], [NAME] | 0.1
[NAME] |  |  | [NAME] | Tittle, [NAME] | 0.316667
[NAME] |  |  | [NAME] | Trinks, [NAME] | 0.216667
Liane Scallan-Grew |  |  | [NAME] | Tshama Muambuyi, Albertine | 0.033333
[NAME] |  |  | [NAME] | Turner, Constance | 0.016667
[NAME] | [NAME] | 0.2 | [NAME] | Wagner, [NAME] | 0.066667
 |  |  | [NAME] A Walling | Walling, [NAME] A | 0.633333
East Milton Elementary-- 7   Worksite #6 |  |  | [NAME] | Warr, [NAME] | 0.55
[NAME] |  |  | [NAME] | Wigton, [NAME] | 0.35
[NAME] |  |  | [NAME] | [NAME], [NAME] | 0.183333
[NAME] |  |  | [NAME] | Wood, Dennis | 0.316667
[NAME]
[NAME]
Gulf Breeze Elementary-- 5   Worksite #7
Amber Harrington
[NAME]
[NAME]
[NAME]
[NAME] Middle--  5         Worksite #18
Codi Elliott
[NAME]
Regina Bice-Craven
[NAME]
Gulf Breeze High-- 10             Worksite #25
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Hobbs Middle-- 5                      Worksite #20
[NAME]
[NAME]
[NAME]
Autumn Wise
[NAME] 6    Worksite #9
[NAME] | [NAME] | 0.683333
Leah Edwards
Saori Stone | Saori Stone | 0.15
[NAME]
[NAME]
[NAME] Int.-- 6           Worksite #8
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Middle-- 5       Worksite #19
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] -- 3                   Worksite #14
[NAME]
[NAME]
Jay Elementary & High-- 8      Worksite #26
[NAME]
[NAME]
[NAME]
Geneva Philips
[NAME]
[NAME]
[NAME]
King Middle-- 7                  Worksite #21
[NAME]
[NAME]
Yolanda Abenojar
[NAME]
[NAME] Commander
Carmen Swafford
[NAME] 14                        Worksite #27
Vanessa Cable
[NAME]
[NAME]
Amanda Jones
[NAME]
[NAME] | [NAME] | 0.033333
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] | [NAME] | 0.033333
[NAME]
Navarre High-- 12                      Worksite #28
Starr Grimes
[NAME]
[NAME]
[NAME]
[NAME] | [NAME] | 0.383333
[NAME]
[NAME]
[NAME] | [NAME] | 0.7
[NAME]
[NAME]
[NAME]
[NAME] Elem. -- 5          Worksite #10
[NAME]
[NAME]
Megan Antonacci
[NAME]
[NAME]
Vera Spaeth
[NAME] | [NAME] | 0.216667
Pace High  --  12                        Worksite #29
[NAME]
[NAME]
[NAME]
[NAME]
Fay Veach
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Pea Ridge Elementary-- 5     Worksite #11
Shannon Towery
[NAME]
[NAME]
[NAME]
[NAME] | [NAME] | 0.083333
Rhodes Elementary--  7        Worksite # 12
[NAME]
[NAME]
Terral Broughton
[NAME]
[NAME]
[NAME]
[NAME]
Sims Middle  --  5                    Worksite #22
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
West Navarre Int. -- 6              Worksite #15
[NAME]
[NAME]
[NAME]
[NAME] | [NAME] | 0.35
[NAME]
West Navarre Primary--  6       Worksite #16
[NAME]
Eden  Acevedo
[NAME]
[NAME]
[NAME]
Woodlawn Beach Middle-- 6   Worksite #23
[NAME]
Sandra Glaze
[NAME]
[NAME]
[NAME]