Spreadsheet: 725984d1617009048-sorting-and-filter-copy-of-staffing-guide-2020-2021-xxxxx-ans1
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 |  |  |  | Cintron, [NAME] | 0.933333 | West Navarre Int. -- 6              Worksite #15 |  |  |  | [NAME], [NAME] | 0.2
[NAME], [NAME] |  |  |  | Wigton, [NAME] | 0.35 | West Navarre Int. -- 6              Worksite #15 |  |  |  | Antonacci, Megan | 0.2
Sanchez, [NAME] |  |  |  | Coddington, [NAME] | 0.083333 | Pea Ridge Elementary-- 5     Worksite #11 |  |  |  | [NAME], [NAME] | 0.633333
[NAME],[NAME] | Noa, [NAME] | 0.066667 |  | Antonacci, Megan | 0.2 | [NAME] Elem. -- 5          Worksite #10 |  |  |  | Barrow, [NAME] | 0.066667
Jewell,Sandy |  |  |  | Sadler, [NAME] | 0.183333 | [NAME] Elem. -- 5          Worksite #10 |  |  |  | Bauer, Billie J | 0.666667
Wagner, [NAME] m | Wagner, [NAME] | 0.066667 |  | [NAME], [NAME] | 0.433333 | [NAME] Elem. -- 5          Worksite #10 |  |  |  | Bloodworth, [NAME] D | 0.266667
 |  |  |  | Trinks, [NAME] | 0.216667 | [NAME] Elem. -- 5          Worksite #10 |  |  |  | Bohlman, [NAME] | 0.05
[NAME] -- 4      Worksite # 1 |  |  |  | Bravo, [NAME] | 0.7 | Navarre High-- 12                      Worksite #28 |  |  |  | Bravo, [NAME] | 0.7
Bloodworth, Stacy d |  |  |  | [NAME], [NAME] | 0.383333 | Navarre High-- 12                      Worksite #28 |  |  |  | Cable, [NAME] | 0.45
McNew, [NAME] |  |  |  | Pine, [NAME] | 0.7 | Navarre High-- 12                      Worksite #28 |  |  |  | Cintron, [NAME] | 0.933333
Walling, Debbie  a | Walling, [NAME] A | 0.633333 |  | Cable, [NAME] | 0.45 | [NAME] 14                        Worksite #27 |  |  |  | Clowers, [NAME] | 0.033333
[NAME], [NAME] | [NAME], [NAME] | 0.633333 |  | Clowers, [NAME] | 0.033333 | [NAME] 14                        Worksite #27 |  |  |  | Coddington, [NAME] | 0.083333
[NAME], [NAME] | [NAME], [NAME] | 0.416667 |  | Cornell, [NAME] | 0.05 | [NAME] 14                        Worksite #27 |  |  |  | [NAME], [NAME] | 0.383333
 |  |  |  | Jones, Amanda K | 0.466667 | [NAME] 14                        Worksite #27 |  |  |  | Cornell, [NAME] | 0.05
[NAME] Elem.-- 6     Worksite #13 |  |  |  | Spivey, Rebekah | 0.033333 | [NAME] 14                        Worksite #27 |  |  |  | Dorner, Kimberly N | 0.016667
Barker, [NAME] |  |  |  | Tshama Muambuyi, Albertine | 0.033333 | [NAME] 14                        Worksite #27 |  |  |  | Earnshaw, [NAME] | 0.016667
[NAME], [NAME] |  |  |  | Earnshaw, [NAME] | 0.016667 | Jay Elementary & High-- 8      Worksite #26 |  |  |  | Franklin, [NAME] R | 0.066667
Morrell ,[NAME] |  |  |  | Rohrer, [NAME] | 0.683333 | [NAME] 6    Worksite #9 |  |  |  | Glover, Robbi D | 0.1
[NAME], [NAME] |  |  |  | Stone, Saori | 0.15 | [NAME] 6    Worksite #9 |  |  |  | Goodman, [NAME] | 0.2
Lazio, Jordyn |  |  |  | Dorner, Kimberly N | 0.016667 | [NAME] Int.-- 6           Worksite #8 |  |  |  | Grimes, [NAME] B | 0.55
Hernandez, [NAME] | Hernandez, [NAME] | 0.483333 |  | Tittle, [NAME] | 0.316667 | Hobbs Middle-- 5                      Worksite #20 |  |  |  | Hernandez, [NAME] | 0.483333
 |  |  |  | Petsch, [NAME] T | 0.65 | Gulf Breeze High-- 10             Worksite #25 |  |  |  | Hinesley, [NAME] | 0.133333
Berryhill Elementary -- 7       Worksite #2 |  |  |  | [NAME], [NAME] | 0.2 | Dixon Intermediate-- 5          Worksite #4 |  |  |  | [NAME], [NAME] | 0.333333
Lindsey. Lana l | Lindsey, Lana L | 0.116667 |  | [NAME], [NAME] | 0.333333 | Dixon Intermediate-- 5          Worksite #4 |  |  |  | Iaconelli, Julia M | 0.133333
Hulett, Amber |  |  |  | Lopez, [NAME] | 0.183333 | Dixon Intermediate-- 5          Worksite #4 |  |  |  | Jones, Amanda K | 0.466667
Rowland. [NAME] |  |  |  | Barrow, [NAME] | 0.066667 | Chumuckla Elementary-- 3   Worksite #3 |  |  |  | Kramp, Louis | 0.033333
Terrel, [NAME] |  |  |  | Hinesley, [NAME] | 0.133333 | Chumuckla Elementary-- 3   Worksite #3 |  |  |  | [NAME], [NAME] | 0.366667
[NAME], Erica |  |  |  | Hernandez, [NAME] | 0.483333 | [NAME] Elem.-- 6     Worksite #13 |  |  |  | Lindsey, Lana L | 0.116667
Higdon, [NAME] |  |  |  | [NAME], [NAME] | 0.633333 | [NAME] -- 4      Worksite # 1 |  |  |  | Lopez, [NAME] | 0.183333
Laney, Tremayne |  |  |  | [NAME], [NAME] | 0.416667 | [NAME] -- 4      Worksite # 1 |  |  |  | [NAME], [NAME] | 0.416667
[NAME], [NAME] |  |  |  | Wagner, [NAME] | 0.066667 | Avalon Middle -- 5               Worksite # 17 |  |  |  | Mcandrew, [NAME] | 0.433333
 |  |  |  | Bauer, Billie J | 0.666667 |  |  |  |  | Mills, [NAME] R | 0.316667
Central School -- 5                  Worksite #24 |  |  |  | Bloodworth, [NAME] D | 0.266667 |  |  |  |  | Noa, [NAME] | 0.066667
Mac, Beverly |  |  |  | Bohlman, [NAME] | 0.05 |  |  |  |  | [NAME], [NAME] | 0.133333
Mitchell, Jolynn |  |  |  | Franklin, [NAME] R | 0.066667 |  |  |  |  | Paige, [NAME] | 0.116667
[NAME], [NAME] |  |  |  | Glover, Robbi D | 0.1 |  |  |  |  | Pascoe, [NAME] | 0.783333
Pollard, [NAME] |  |  |  | Goodman, [NAME] | 0.2 |  |  |  |  | Petsch, [NAME] T | 0.65
[NAME], [NAME] |  |  |  | Grimes, [NAME] B | 0.55 |  |  |  |  | Phillips, Geneva | 0.083333
 |  |  |  | Iaconelli, Julia M | 0.133333 |  |  |  |  | Pine, [NAME] | 0.7
Chumuckla Elementary-- 3   Worksite #3 |  |  |  | Kramp, Louis | 0.033333 |  |  |  |  | Prescott, [NAME] | 1.05
Barrow, [NAME] | Barrow, [NAME] | 0.066667 |  | [NAME], [NAME] | 0.366667 |  |  |  |  | [NAME], [NAME] | 0.2
Blocker, [NAME] |  |  |  | Lindsey, Lana L | 0.116667 |  |  |  |  | Rodriguez Colon, Gisela | 0.7
Hinesley, Bette j | Hinesley, [NAME] | 0.133333 |  | Mcandrew, [NAME] | 0.433333 |  |  |  |  | Rohrer, [NAME] | 0.683333
 |  |  |  | Mills, [NAME] R | 0.316667 |  |  |  |  | Sadler, [NAME] | 0.183333
Dixon Primary-- 5                   Worksite #5 |  |  |  | Noa, [NAME] | 0.066667 |  |  |  |  | Scallan-Grew, [NAME] | 0.2
[NAME], [NAME] |  |  |  | [NAME], [NAME] | 0.133333 |  |  |  |  | Sedlacek, [NAME] | 0.15
Van Voorhis, Jan |  |  |  | Paige, [NAME] | 0.116667 |  |  |  |  | Simmons, Lola J | 0.566667
Blanton, [NAME] |  |  |  | Pascoe, [NAME] | 0.783333 |  |  |  |  | Spivey, Rebekah | 0.033333
Holt, [NAME] |  |  |  | Phillips, Geneva | 0.083333 |  |  |  |  | Staten, [NAME] | 0.333333
 |  |  |  | Prescott, [NAME] | 1.05 |  |  |  |  | Stone, Saori | 0.15
 |  |  |  | [NAME], [NAME] | 0.2 |  |  |  |  | [NAME], [NAME] | 0.433333
Dixon Intermediate-- 5          Worksite #4 |  |  |  | Rodriguez Colon, Gisela | 0.7 |  |  |  |  | [NAME], [NAME] | 0.1
Goodman, [NAME] | Goodman, [NAME] | 0.2 |  | Scallan-Grew, [NAME] | 0.2 |  |  |  |  | Tittle, [NAME] | 0.316667
Lopez, Daniel m | Lopez, [NAME] | 0.183333 |  | Sedlacek, [NAME] | 0.15 |  |  |  |  | Trinks, [NAME] | 0.216667
Liane Scallan-Grew | Scallan-Grew, [NAME] | 0.2 |  | Simmons, Lola J | 0.566667 |  |  |  |  | Tshama Muambuyi, Albertine | 0.033333
[NAME], [NAME] | [NAME], [NAME] | 0.333333 |  | Staten, [NAME] | 0.333333 |  |  |  |  | Turner, Constance | 0.016667
[NAME], [NAME] | [NAME], [NAME] | 0.2 |  | [NAME], [NAME] | 0.1 |  |  |  |  | Wagner, [NAME] | 0.066667
 |  |  |  | Turner, Constance | 0.016667 |  |  |  |  | Walling, [NAME] A | 0.633333
East Milton Elementary-- 7   Worksite #6 |  |  |  | Walling, [NAME] A | 0.633333 |  |  |  |  | Warr, [NAME] | 0.55
Pascoe, [NAME]  j | Pascoe, [NAME] | 0.783333 |  | Warr, [NAME] | 0.55 |  |  |  |  | Wigton, [NAME] | 0.35
Lesso, Amanda |  |  |  | [NAME], [NAME] | 0.183333 |  |  |  |  | [NAME], [NAME] | 0.183333
Staten, [NAME]  a | Staten, [NAME] | 0.333333 |  | Wood, Dennis | 0.316667 |  |  |  |  | Wood, Dennis | 0.316667
Hyman, [NAME]
Wyers, [NAME]
Gulf Breeze Elementary-- 5   Worksite #7
Harrington, Amber
Enzian, Brittney
[NAME], [NAME]
[NAME], [NAME]
[NAME] Middle--  5         Worksite #18
Elliott, Codi
Rose, [NAME]
Bice-Craven, Regina
Gilman, [NAME]
Gulf Breeze High-- 10             Worksite #25
Petsch, [NAME] t | Petsch, [NAME] T | 0.65
Hanson. Aida
Franklin. Gina r | Franklin, [NAME] R | 0.066667
Coleman, Kimberly
Kramp, [NAME] | Kramp, Louis | 0.033333
Paige, [NAME]  j | Paige, [NAME] | 0.116667
Rhodes, Victoria
Hobbs Middle-- 5                      Worksite #20
Beaudry, [NAME]
Simmons, [NAME]  j | Simmons, Lola J | 0.566667
Tittle, [NAME] | Tittle, [NAME] | 0.316667
Wise, Autumn
[NAME] 6    Worksite #9
Rohrer, [NAME] | Rohrer, [NAME] | 0.683333
Edwards, Leah
Stone, Saori | Stone, Saori | 0.15
Sedlacek, [NAME]  m | Sedlacek, [NAME] | 0.15
Turner, Connie | Turner, Constance | 0.016667
[NAME] Int.-- 6           Worksite #8
May, [NAME] | Dorner, Kimberly N | 0.016667
[NAME], [NAME]
[NAME], Rita
Peebles, Cassandra
Dorner, Kimberly n | Dorner, Kimberly N | 0.016667
Hilliard, [NAME]
Apollo, [NAME]
[NAME] Middle-- 5       Worksite #19
Enfield, [NAME]
[NAME], [NAME]
Gibbs, [NAME]
Corley, [NAME]
[NAME], Keiko
[NAME] -- 3                   Worksite #14
Prescott,  [NAME]  m | Prescott, [NAME] | 1.05
[NAME], [NAME]
Jay Elementary & High-- 8      Worksite #26
[NAME], [NAME]  m | [NAME], [NAME] | 0.1
Glover, [NAME]  d | Glover, Robbi D | 0.1
Joiner, [NAME]
Philips, Geneva
Starosta, [NAME]
White Couie, [NAME]
Earnshaw, [NAME] | Earnshaw, [NAME] | 0.016667
King Middle-- 7                  Worksite #21
Ballew, Lindsey
[NAME], [NAME]
Abenojar, Yolanda
Downs, Dawn
Commander, [NAME]
Swafford, Carmen
[NAME] 14                        Worksite #27
Cable, [NAME] | Cable, [NAME] | 0.45
Cornell, [NAME] | Cornell, [NAME] | 0.05
Tshama Muambuyi, Albertine | Tshama Muambuyi, Albertine | 0.033333
Jones, Amanda K | Jones, Amanda K | 0.466667
[NAME], [NAME]
Clowers, [NAME] | Clowers, [NAME] | 0.033333
[NAME], [NAME]
Reese, [NAME]
[NAME], [NAME]
Crane, [NAME]
Spivey, Rebekah | Spivey, Rebekah | 0.033333
[NAME], Sara
Navarre High-- 12                      Worksite #28
Grimes, [NAME]  b | Grimes, [NAME] B | 0.55
Feick, Kristina
Vanc, [NAME]
Pine, [NAME] | Pine, [NAME] | 0.7
[NAME], [NAME] | [NAME], [NAME] | 0.383333
Gilbreath, Ashley
Lattig, Sherra
Bravo, [NAME] | Bravo, [NAME] | 0.7
Iaconell, Julia
[NAME], [NAME]
Rios, [NAME]
[NAME] Elem. -- 5          Worksite #10
[NAME], Christine   m | Mcandrew, [NAME] | 0.433333
Sadler, [NAME] | Sadler, [NAME] | 0.183333
Antonacci, Megan | Antonacci, Megan | 0.2
[NAME], [NAME] k | [NAME], [NAME] | 0.433333
Daves, [NAME]
[NAME], Vera
Trinks, [NAME] | Trinks, [NAME] | 0.216667
Pace High  --  12                        Worksite #29
[NAME], [NAME]  l | [NAME], [NAME] | 0.133333
Heinrich, Christine
[NAME], [NAME]
Beckius, [NAME]
Veach, Fay
Gonzale, [NAME]
Villafania, [NAME]
Justice, [NAME]
[NAME], [NAME]
Pollard, Meggie
Ciminieri, [NAME]
Pea Ridge Elementary-- 5     Worksite #11
Towery, Shannon
Turner, [NAME]
[NAME], [NAME]
Haun, Mary
Coddington, [NAME] | Coddington, [NAME] | 0.083333
Rhodes Elementary--  7        Worksite # 12
Pope, [NAME]
[NAME], [NAME]
Broughton, Terral
[NAME], [NAME]
Ruinato, Amanda
Fall, [NAME]
Love, [NAME]
Sims Middle  --  5                    Worksite #22
Rodriguez-Colon, Gisela | Rodriguez Colon, Gisela | 0.7
Bohlmon, [NAME] | Bohlman, [NAME] | 0.05
Vance, [NAME]
Bradford, [NAME]
Ward, [NAME]
West Navarre Int. -- 6              Worksite #15
Bauer, [NAME] j | Bauer, Billie J | 0.666667
[NAME], Sandy
Cintron, [NAME] j | Cintron, [NAME] | 0.933333
Wigton, [NAME] | Wigton, [NAME] | 0.35
[NAME], [NAME]
West Navarre Primary--  6       Worksite #16
Emerson, [NAME]
Acevedo, Eden
[NAME], [NAME]
Lowell, [NAME]
Hatzidakis, [NAME]
Woodlawn Beach Middle-- 6   Worksite #23
Colvin,  [NAME]
Glaze, Sandra
Campa, [NAME]
Tatro, [NAME]
Elliott, Martina