Emp# Name State Hire Date Pay Rate
759 Brandi Turner CA 11/23/2021 $ 38.90
735 Brent Brock IA 8/10/2015 $ 30.80
769 Elisa Chan WA 11/29/2021 $ 38.13
741 Antonia More LA 6/14/2023 $ 28.49
743 Bill Crane WA 5/12/2021 $ 27.86
723 Bob Harvey CA 7/15/2016 $ 28.15
711 Candace Kimball TX 11/11/2017 $ 26.66
772 Cara Stevenson ND 8/23/2015 $ 38.62
736 Carl Howard CA 8/6/2016 $ 26.64
706 Cecelia Carr AZ 12/27/2017 $ 37.74
791 Cheri Kennedy UT 11/23/2015 $ 31.27
777 Cristina Hubbard TX 9/18/2018 $ 35.21
785 Derek Fuller OR 3/4/2017 $ 34.71
721 Dianne Dillon ND 9/14/2014 $ 26.92
744 Doug McGrath CA 3/29/2020 $ 24.63
731 Edwin Johnson NM 12/2/2020 $ 26.58
782 Ernie Chandler TX 1/15/2015 $ 25.48
740 Ethel Nash OR 2/10/2017 $ 27.78
795 George Gates MT 8/8/2021 $ 20.43
749 Hazel Rich ID 10/17/2019 $ 30.72
724 Herbert Daley UT 3/2/2022 $ 26.13
721 Howard Webster CA 8/18/2021 $ 30.12
792 Jacqueline Cordova CA 12/23/2018 $ 35.78
716 Janis Thornton ND 11/27/2016 $ 25.31
758 Jesus Golden LA 6/21/2023 $ 36.44
777 Kelly Roy IA 11/22/2019 $ 39.81
729 Lonnie Barton ID 8/29/2017 $ 23.81
781 Lou Rivas TX 1/27/2021 $ 31.21
735 Lucille Loomis CA 5/22/2020 $ 27.21
788 Marcos Abbott NV 12/30/2016 $ 31.51
715 Maria White ND 12/2/2014 $ 32.75
704 Marian Adkins WA 3/22/2015 $ 23.41
737 Mel Estrada MT 8/10/2017 $ 25.70
1001 Moe Jones OR 5/4/2024 $ 30.00
758 Myron Downs TX 4/1/2023 $ 33.04
756 Omar Mathews OR 3/15/2018 $ 39.90
766 Pedro Frost ND 9/10/2017 $ 26.06
751 Ralph Dunbar CA 6/30/2016 $ 26.39
702 Rickey Lancaster TX 8/20/2015 $ 34.22
788 Ricky Merritt MT 9/13/2018 $ 35.75
758 Rodolfo Li CA 9/8/2021 $ 28.78
798 Roxanne Rollins OR 10/1/2022 $ 35.29
714 Sam Gleason NV 2/6/2016 $ 31.78
701 Sean Tate IA 5/15/2022 $ 22.53
783 Shannon Drew MT 10/1/2022 $ 33.23
776 Shari Melendez IA 12/30/2015 $ 30.03
751 Shelley Moon MT 7/1/2023 $ 34.42
710 Steven Nunez UT 7/12/2017 $ 30.94
729 Trisha Graham CA 2/16/2019 $ 25.35
766 Van Galloway IA 12/18/2016 $ 30.10
771 Wade Maynard ID 7/17/2019 $ 33.45
Hours Gross Pay Time Off Balance
34 $ 1,305.98 5
28 $ 875.74 5
28 $ 1,063.93 5
36 $ 1,020.16 13
34 $ 948.03 16
22 $ 608.83 18
24 $ 627.61 12
29 $ 1,109.61 14
40 $ 1,060.26 6
40 $ 1,508.77 13
40 $ 1,235.51 8
29 $ 1,027.03 2
22 $ 746.88 12
36 $ 970.18 9
25 $ 617.25 12
27 $ 717.73 12
39 $ 989.39 6
25 $ 687.76 18
27 $ 551.97 14
26 $ 789.93 16
27 $ 693.86 8
36 $ 1,072.22 9
37 $ 1,329.45 15
23 $ 573.97 14
27 $ 979.82 6
23 $ 909.28 15
33 $ 781.97 16
35 $ 1,097.44 2
27 $ 721.64 15
31 $ 964.05 4
20 $ 656.91 2
25 $ 593.39 6
36 $ 932.37 3
25 $ 750.00 18
28 $ 939.25 18
36 $ 1,436.42 16
38 $ 990.25 6
32 $ 843.09 3
27 $ 921.57 10
21 $ 757.17 17
30 $ 872.39 9
25 $ 869.29 18
36 $ 1,136.49 11
25 $ 559.59 6
38 $ 1,262.43 16
29 $ 880.59 9
31 $ 1,062.96 11
20 $ 619.87 14
27 $ 688.23 2
38 $ 1,131.94 4
37 $ 1,254.06 16
Sort and Filter
Slicers
Total Row
Emp# Name State Hire Date Pay Rate
759 Brandi Turner CA 11/23/2021 $ 38.90
735 Brent Brock IA 8/10/2015 $ 30.80
769 Elisa Chan WA 11/29/2021 $ 38.13
741 Antonia More LA 6/14/2023 $ 28.49
743 Bill Crane WA 5/12/2021 $ 27.86
723 Bob Harvey CA 7/15/2016 $ 28.15
711 Candace Kimball TX 11/11/2017 $ 26.66
772 Cara Stevenson ND 8/23/2015 $ 38.62
736 Carl Howard CA 8/6/2016 $ 26.64
706 Cecelia Carr AZ 12/27/2017 $ 37.74
791 Cheri Kennedy UT 11/23/2015 $ 31.27
777 Cristina Hubbard TX 9/18/2018 $ 35.21
785 Derek Fuller OR 3/4/2017 $ 34.71
721 Dianne Dillon ND 9/14/2014 $ 26.92
744 Doug McGrath CA 3/29/2020 $ 24.63
731 Edwin Johnson NM 12/2/2020 $ 26.58
782 Ernie Chandler TX 1/15/2015 $ 25.48
740 Ethel Nash OR 2/10/2017 $ 27.78
795 George Gates MT 8/8/2021 $ 20.43
749 Hazel Rich ID 10/17/2019 $ 30.72
724 Herbert Daley UT 3/2/2022 $ 26.13
721 Howard Webster CA 8/18/2021 $ 30.12
792 Jacqueline Cordova CA 12/23/2018 $ 35.78
716 Janis Thornton ND 11/27/2016 $ 25.31
758 Jesus Golden LA 6/21/2023 $ 36.44
777 Kelly Roy IA 11/22/2019 $ 39.81
729 Lonnie Barton ID 8/29/2017 $ 23.81
781 Lou Rivas TX 1/27/2021 $ 31.21
735 Lucille Loomis CA 5/22/2020 $ 27.21
788 Marcos Abbott NV 12/30/2016 $ 31.51
715 Maria White ND 12/2/2014 $ 32.75
704 Marian Adkins WA 3/22/2015 $ 23.41
737 Mel Estrada MT 8/10/2017 $ 25.70
1001 Moe Jones OR 5/4/2024 $ 30.00
758 Myron Downs TX 4/1/2023 $ 33.04
756 Omar Mathews OR 3/15/2018 $ 39.90
766 Pedro Frost ND 9/10/2017 $ 26.06
751 Ralph Dunbar CA 6/30/2016 $ 26.39
702 Rickey Lancaster TX 8/20/2015 $ 34.22
788 Ricky Merritt MT 9/13/2018 $ 35.75
758 Rodolfo Li CA 9/8/2021 $ 28.78
798 Roxanne Rollins OR 10/1/2022 $ 35.29
714 Sam Gleason NV 2/6/2016 $ 31.78
701 Sean Tate IA 5/15/2022 $ 22.53
783 Shannon Drew MT 10/1/2022 $ 33.23
776 Shari Melendez IA 12/30/2015 $ 30.03
751 Shelley Moon MT 7/1/2023 $ 34.42
710 Steven Nunez UT 7/12/2017 $ 30.94
729 Trisha Graham CA 2/16/2019 $ 25.35
766 Van Galloway IA 12/18/2016 $ 30.10
771 Wade Maynard ID 7/17/2019 $ 33.45
Hours Gross Pay Time Off Balance
34 $ 1,305.98 5
28 $ 875.74 5
28 $ 1,063.93 5
36 $ 1,020.16 13
34 $ 948.03 16
22 $ 608.83 18
24 $ 627.61 12
29 $ 1,109.61 14
40 $ 1,060.26 6
40 $ 1,508.77 13
40 $ 1,235.51 8
29 $ 1,027.03 2
22 $ 746.88 12
36 $ 970.18 9
25 $ 617.25 12
27 $ 717.73 12
39 $ 989.39 6
25 $ 687.76 18
27 $ 551.97 14
26 $ 789.93 16
27 $ 693.86 8
36 $ 1,072.22 9
37 $ 1,329.45 15
23 $ 573.97 14
27 $ 979.82 6
23 $ 909.28 15
33 $ 781.97 16
35 $ 1,097.44 2
27 $ 721.64 15
31 $ 964.05 4
20 $ 656.91 2
25 $ 593.39 6
36 $ 932.37 3
25 $ 750.00 18
28 $ 939.25 18
36 $ 1,436.42 16
38 $ 990.25 6
32 $ 843.09 3
27 $ 921.57 10
21 $ 757.17 17
30 $ 872.39 9
25 $ 869.29 18
36 $ 1,136.49 11
25 $ 559.59 6
38 $ 1,262.43 16
29 $ 880.59 9
31 $ 1,062.96 11
20 $ 619.87 14
27 $ 688.23 2
38 $ 1,131.94 4
37 $ 1,254.06 16
Conditional
Formatting
Hire Length of
Emp# First Last State Date Service (yrs)
788 Marcos Abbott NV 12/30/2016 8.3
704 Marian Adkins WA 3/22/2015 10.0
729 Lonnie Barton ID 8/29/2017 7.6
735 Brent Brock IA 8/10/2015 9.7
706 Cecelia Carr AZ 12/27/2017 7.3
769 Elisa Chan WA 11/29/2021 3.3
782 Ernie Chandler TX 1/15/2015 10.2
792 Jacqueline Cordova CA 12/23/2018 6.3
743 Bill Crane WA 5/12/2021 3.9
724 Herbert Daley UT 3/2/2022 3.1
721 Dianne Dillon ND 9/14/2014 10.6
758 Myron Downs TX 4/1/2023 2.0
783 Shannon Drew MT 10/1/2022 2.5
751 Ralph Dunbar CA 6/30/2016 8.8
737 Mel Estrada MT 8/10/2017 7.7
766 Pedro Frost ND 9/10/2017 7.6
785 Derek Fuller OR 3/4/2017 8.1
766 Van Galloway IA 12/18/2016 8.3
795 George Gates MT 8/8/2021 3.7
714 Sam Gleason NV 2/6/2016 9.2
758 Jesus Golden LA 6/21/2023 1.8
729 Trisha Graham CA 2/16/2019 6.1
723 Bob Harvey CA 7/15/2016 8.7
736 Carl Howard CA 8/6/2016 8.7
777 Cristina Hubbard TX 9/18/2018 6.5
731 Edwin Johnson NM 12/2/2020 4.3
791 Cheri Kennedy UT 11/23/2015 9.4
711 Candace Kimball TX 11/11/2017 7.4
702 Rickey Lancaster TX 8/20/2015 9.6
758 Rodolfo Li CA 9/8/2021 3.6
735 Lucille Loomis CA 5/22/2020 4.9
756 Omar Mathews OR 3/15/2018 7.1
771 Wade Maynard ID 7/17/2019 5.7
744 Doug McGrath CA 3/29/2020 5.0
776 Shari Melendez IA 12/30/2015 9.3
788 Ricky Merritt MT 9/13/2018 6.6
751 Shelley Moon MT 7/1/2023 1.8
741 Antonia More LA 6/14/2023 1.8
740 Ethel Nash OR 2/10/2017 8.1
710 Steven Nunez UT 7/12/2017 7.7
749 Hazel Rich ID 10/17/2019 5.5
781 Lou Rivas TX 1/27/2021 4.2
798 Roxanne Rollins OR 10/1/2022 2.5
777 Kelly Roy IA 11/22/2019 5.4
772 Cara Stevenson ND 8/23/2015 9.6
701 Sean Tate IA 5/15/2022 2.9
716 Janis Thornton ND 11/27/2016 8.4
759 Brandi Turner CA 11/23/2021 3.4
721 Howard Webster CA 8/18/2021 3.6
715 Maria White ND 12/2/2014 10.3
Pay Generate a report based on:
Rate Hours Length of Service and Hours by
State
$ 31.51 31
$ 23.41 25
$ 23.81 33
$ 30.80 28
$ 37.74 40
$ 38.13 28
$ 25.48 39
$ 35.78 37
$ 27.86 34
$ 26.13 27
$ 26.92 36
$ 33.04 28
$ 33.23 38
$ 26.39 32
$ 25.70 36
$ 26.06 38
$ 34.71 22
$ 30.10 38
$ 20.43 27
$ 31.78 36
$ 36.44 27
$ 25.35 27
$ 28.15 22
$ 26.64 40
$ 35.21 29
$ 26.58 25
$ 31.27 40
$ 26.66 24
$ 34.22 27
$ 28.78 30
$ 27.21 27
$ 39.90 36
$ 33.45 37
$ 24.63 25
$ 30.03 29
$ 35.75 21
$ 34.42 31
$ 28.49 36
$ 27.78 25
$ 30.94 20
$ 30.72 26
$ 31.21 35
$ 35.29 25
$ 39.81 23
$ 38.62 29
$ 22.53 25
$ 25.31 23
$ 38.90 34
$ 30.12 36
$ 32.75 20
based on:
nd Hours by
Employee Turnover Metrics Data She
Month Employees LeftAverage Total Employees
Jan 10 250
Feb 8 255
Mar 12 260
Apr 9 265
May 11 270
Jun 7 275
Jul 10 280
Aug 8 285
Sep 13 290
Oct 6 295
Nov 10 300
Dec 7 305
Turnover Metrics Data Sheet (Monthly)
Turnover Rate (%)
Top Reasons for Turnover
4% Retirement, Resignation
3.14% Career growth, Relocation
4.62% Better opportunities
3.40% Personal reasons
4.07% New job offers
2.55% Family relocation
3.57% Career change
2.81% Retirement, Resignation
4.48% Better work-life balance
2.03% Personal growth
3.33% New opportunities
2.30% Holiday season
Retention Strategies List
Mentorship program Better opportunities
Flexible work hours Family relocation
Training workshops Career change
Employee recognition Personal growth
Wellness programs
Professional growth
Work-life balance
Skill development
Leadership training
Employee surveys
Recognition programs
Career advancement
Insert Data From Another Source