Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut Calibri 11 A A aD Wrap Text AutoSum . General AY O BB Copy Fill - Paste BIU. $ - % " Sort & Find & Format Painter . A . Merge & Center - Conditional Format as Cell Insert Delete Format Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F5 X v fx A B C D 60 Evelyn Eggers Meets Expectations 10/17/2016 Other Employment - Higher Level Pay/Position 61 Frances Farmer Meets Expectations 10/30/2016 Other Employment - Higher Level Pay/Position 62 Greg Gunderson Meets Expectations 10/30/2016 Other Employment - Higher Level Pay/Position 63 Hailey Hawkins Meets Expectations 11/5/2016 Other Employment - Higher Level Pay/Position 64 Imogen Iverson Meets Expectations 11/7/2016 Other Employment - Higher Level Pay/Position 65 Jessica Jefferson Exceeds Expectations 11/21/2016 Family/Personal - Relocating 66 Kathy Karson Meets Expectations 11/28/2016 Other Employment - Higher Level Pay/Position 67 Lacy Long Meets Expectations 12/1/2016 Other Employment - Higher Level Pay/Position 68 Matt Marks Meets Expectations 12/6/2016 Other Employment - Higher Level Pay/Position 69 Nick North Exceeds Expectations 12/6/2016 Other Employment - Higher Level Pay/Position 70 Otto Osborn Exceeds Expectations 12/20/2016 Other Employment - Higher Level Pay/Position 71 Priscilla Parker Meets Expectations 12/31/2016 Dissatisfied with job - no other employment Employee Term Data Term Reason Lookup + Ready + 175% 2:31 PM H Type here to search O M X ? 2/17/2021Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut A A aD Wrap Text AutoSum . Calibri 11 General AY O BB Copy Fill - Paste BIU . . A . BE = Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F5 X v fx A B C D 4 TOTAL TURNOVER %: 11.53846154 5 INVOLUNTARY TURNOVER% 6 VOLUNTARY TURNOVER% 7 FUNCTIONAL TURNOVER % 8 DYSFUNCTIONAL TURNOVER % 9 UNCONTROLLABLE TURNOVER %: 10 CONTROLLABLE TURNOVER %: Termination 11 Name Last Performance Rating Date Termination Reason 12 Suzy Snowflake Exceeds Expectations 1/3/2016 Dissatisfied with job - no other employment 13 Harry Potter Meets Expectations 1/31/2016 Family/Personal - Relocating 14 Jennifer Lawrence Does Not Meet Expectations 2/4/2016 Terminated - Performance 15 Jethro Bodine Exceeds Expectations 2/4/2016 Other Employment - Higher Level Pay/Position Employee Term Data Term Reason Lookup + Ready + 160% 2:29 PM H Type here to search O WE ? A 0 -" 2/17/2021Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut AutoSum . Calibri + 11 A A aD Wrap Text General AY O BB Copy Fill - Paste BIU . . A . BE = Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F5 X v fx A B C D 13 Harry Potter Meets Expectations 1/31/2016 Family/Personal - Relocating 14 Jennifer Lawrence Does Not Meet Expectations 2/4/2016 Terminated - Performance 15 Jethro Bodine Exceeds Expectations 2/4/2016 Other Employment - Higher Level Pay/Position 16 Luke Skywalker Meets Expectations 2/16/2016 Other Employment - Higher Level Pay/Position 17 Darth Vader Meets Expectations 2/16/2016 Family/Personal - Relocating 18 Joe Smith Meets Expectations 2/21/2016 Family/Personal - Other 19 Barbara Beckwith Meets Expectations 2/28/2016 Returning to School 20 Mary Contra Meets Expectations 3/1/2016 Retirement 21 Fred Jones Exceeds Expectations 2/1/2016 Other Employment - Similar Pay/Position 22 Sam Marcus Does Not Meet Expectations 3/1/2016 Terminated - Attendance 23 Josh Claflin Does Not Meet Expectations 3/8/2016 Dissatisfied with job - no other employment 24 Tami McNammy Meets Expectations 3/8/2016 Family/Personal - Relocating 25 Mike Meyers Meets Expectations 3/15/2016 Family/Personal - Health 26 Rhonda Rosner Meets Expectations 2/17/2016 Family/Personal - Relocating Employee Term Data Term Reason Lookup + Ready + 160% 2:30 PM H Type here to search O WE (?) 2/17/2021Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut AutoSum . Calibri + 11 A A aD Wrap Text General AY O BB Copy Fill - Paste BIU . . A . BE = Format Painter Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number F Styles Cells Editing F5 X v fx A B C D 27 Larry Boots Meets Expectations 3/17/2016 Other Employment - Similar Pay/Position 28 Elvis Presser Meets Expectations 3/30/2016 Terminated - Misconduct 29 Mark Marky Exceeds Expectations 2/22/2016 Family/Personal - Relocating 30 Liz Lime Exceeds Expectations 3/22/2016 Other Employment - Similar Pay/Position 31 Wanda Burns Exceeds Expectations 4/1/2016 Returning to School 32 Katie Dyer Meets Expectations 4/7/2016 Dissatisfied with job - no other employment 33 Gabbi Smith Meets Expectations 4/21/2016 Other Employment - Higher Level Pay/Position 34 Carrie Bauer Meets Expectations 4/28/2016 Other Employment - Changing Careers 35 Tom Cruise Meets Expectations 5/2/2016 Family/Personal - Other 36 Aaron Murray Does Not Meet Expectations 5/10/2016 Other Employment - Higher Level Pay/Position 37 Georgia Dawg Does Not Meet Expectations 5/17/2016 Terminated - Misconduct 38 Art Weiner Meets Expectations 5/21/2016 Other Employment - Similar Pay/Position 39 Marcy Metzger Meets Expectations 5/30/2016 Other Employment - Higher Level Pay/Position 40 Julie Beador Does Not Meet Expectations 6/2/2016 Family/Personal - Relocating Employee Term Data Term Reason Lookup + Ready + 160%% 2:30 PM Type here to search O ? 2/17/2021Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut AutoSum . Calibri 11 A A aD Wrap Text General AY O BB Copy Fill - Paste BIU . . A . = Format Painter Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F5 X A B C D 40 Julie Beador Does Not Meet Expectations 6/2/2016 Family/Personal - Relocating 41 Cercei Lannister Meets Expectations 2/15/2016 Terminated - Misconduct 42 Andrew Lincoln Meets Expectations 6/15/2016 Family/Personal - Other 43 Carl Grimes Meets Expectations 6/21/2016 Family/Personal - Other 44 Norman Reedus Meets Expectations 6/28/2016 Other Employment - Higher Level Pay/ 45 Daryl Dixon Meets Expectations 7/3/2016 Other Employment - Higher Level Pay/ 46 T. Dogg Walker Meets Expectations 7/3/2016 Other Employment - Similar Pay/Positi 47 Shane Shotwell Meets Expectations 7/10/2016 Retirement 48 Maggie Glenn Meets Expectations 7/21/2016 Returning to School 49 Nick Walker Does Not Meet Expectations 8/2/2016 Terminated - Attendance 50 Hermione Granger Exceeds Expectations 8/12/2016 Dissatisfied with job - no other employ 51 Grace lAnne Done Not Mont Evnastations 0/14/2016 Doturning to School Employee Term Data Term Reason Lookup + Ready + 190%% 2:31 PM H Type here to search O ? 2/17/2021Assignment Ch5a Employee Turnover Spreadsheet (1)1 - Excel Sign in X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share do Cut Calibri 11 A A AutoSum . aD Wrap Text General AY O BB Copy Fill - Paste BIU . . A . = Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table Styles Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing F5 X A B C D 51 Grace Jones Does Not Meet Expectations 8/14/2016 Returning to School 52 Marvin Restler Exceeds Expectations 8/27/2016 Family/Personal - Other 53 Michael Giel Meets Expectations 8/21/2016 Other Employment - Higher Level Pay/ 54 Cat Sitter Meets Expectations 9/3/2016 Other Employment - Similar Pay/Posit 55 Tripp Goodson Meets Expectations 9/9/2016 Other Employment - Higher Level Pay/ 56 Ann Anderson Meets Expectations 9/21/2016 Dissatisfied with job - no other employ 57 Bob Barker Meets Expectations 9/30/2016 Other Employment - Similar Pay/Positi 58 Casey Kasem Meets Expectations 10/5/2016 Other Employment - Higher Level Pay/ 59 Don Drummond Meets Expectations 10/6/2016 Other Employment - Higher Level Pay/ 60 Evelyn Eggers Meets Expectations 10/17/2016 Other Employment - Higher Level Pay, 61 Frances Farmer Meets Expectations 10/30/2016 Other Employment - Higher Level Pay/ 62 Gran GundAreAn Monte Evnastations 10/20/2016 0thar Employment Uiahar Laval Dou Employee Term Data Term Reason Lookup + Ready + 190% 2:31 PM H Type here to search O WE X II ? 2/17/2021