Spreadsheet: 355860d1414815085-help-very-difficult-spreadsheet-calculations-and-filtering-pre-work
Sheet: Employee Data

Assoc.# | Section Code | Job Title | Job code | FT/PT | Division | Dept | Inception Date | Termination Date | Reason for Leaving company | Vol/Inv | Current Rating
911-732 | B-413 | Service Rep. II | 49565 | FT | NE | SVC | 2012-09-10 00:00:00 | 2014-10-21 00:00:00 | Attendance/Tardiness | I | No rating
514-912 | [NAME] | Service Rep. I | 48565 | PT | NE | SVC | 2014-03-10 00:00:00 | 2014-10-20 00:00:00 | Another Job | V | No rating
101-112 | B-404 | Service Rep. II | 49565 | FT | NE | SVC | 2013-07-15 00:00:00 | 2014-10-19 00:00:00 | Another Job | V | 3.22
866-321 | A-167 | Claims Rep I | 49625 | FT | SW | Claims | 2012-02-27 00:00:00 | 2014-10-13 00:00:00 | Family Responsibilities/Personal | V | 2.55
210-003 | B-491 | Service Representative II | 49565 | FT | SW | SVC | 2013-09-23 00:00:00 | 2014-10-04 00:00:00 | Family Responsibilities/Personal | V | 3.6
212-499 | A-155 | Claims Rep I | 49625 | FT | SW | Claims | 2010-09-07 00:00:00 | 2014-10-03 00:00:00 | Dissatisfied with company policies | V | 3.09
201-003 | B-421 | Service Rep. II | 49565 | FT | SW | SVC | 2011-10-17 00:00:00 | 2014-09-28 00:00:00 | Did not return from leave | V | 4.23
109-140 | B-487 | Service Rep. [NAME] | 50565 | FT | NE | SVC | 2013-12-09 00:00:00 | 2014-09-28 00:00:00 | Deceased | V | 2.9
203-378 | B-458 | Service Representative III | 50565 | FT | NE | SVC | 2013-08-26 00:00:00 | 2014-09-25 00:00:00 | Another Job | V | 3.88
242-242 | B-321 | Sales Level II | 49570 | FT | SW | Sales | 2013-08-19 00:00:00 | 2014-09-24 00:00:00 | Dissatisfied with type of work | V | 3.1
210-319 | B-477 | Service Rep. II | 49565 | FT | SW | SVC | 2014-05-27 00:00:00 | 2014-09-16 00:00:00 | Family Responsibilities/Personal | V | 3.54
314-118 | B-486 | Service Representative II | 49565 | FT | NE | SVC | 2012-09-24 00:00:00 | 2014-09-16 00:00:00 | Another Job | V | 3.24
500-699 | B-122 | Claims Rep I | 49625 | FT | NE | Claims | 2013-09-16 00:00:00 | 2014-09-12 00:00:00 | Dissatisfied with hours | V | 4
799-345 | B-118 | Claims Rep I | 49625 | PT | NE | Claims | 2013-06-24 00:00:00 | 2014-09-12 00:00:00 | Relocation | V | 3.03
688-366 | B-101 | Trainee | 48570 | FT | SW | Sales | 2014-07-14 00:00:00 | 2014-09-12 00:00:00 | Abandonment of Job | V | 1.12
333-010 | B-455 | Service Rep. [NAME] | 50565 | PT | NE | SVC | 2000-04-06 00:00:00 | 2014-09-05 00:00:00 | Dissatisfied with type of work | V | 3.03
133-681 | B-121 | Trainee | 48570 | FT | NE | Sales | 2014-03-24 00:00:00 | 2014-09-04 00:00:00 | Unable to Pass Licensing | I | No rating
655-534 | B-422 | Service Rep. I | 48565 | FT | SW | SVC | 2013-12-09 00:00:00 | 2014-09-04 00:00:00 | Abandonment of Job | V | 2.69
163-351 | B-421 | Service Rep. I | 48565 | FT | NE | SVC | 2013-11-11 00:00:00 | 2014-09-02 00:00:00 | Another Job | V | No rating
922-912 | B-419 | Service Rep. I | 48565 | FT | SW | SVC | 2014-05-27 00:00:00 | 2014-08-29 00:00:00 | Did not return from leave | V | No rating
988-001 | B-444 | Service Rep. I | 48565 | FT | NE | SVC | 2014-05-27 00:00:00 | 2014-08-28 00:00:00 | Another Job | V | No rating
772-504 | B-477 | Service Rep. In Training | 48535 | FT | NE | SVC | 2009-07-20 00:00:00 | 2014-08-26 00:00:00 | Abandonment of Job | V | No rating
212-483 | B-466 | Service Rep. II | 49565 | FT | NE | SVC | 2011-02-07 00:00:00 | 2014-08-25 00:00:00 | Abandonment of Job | V | 3.1
844-444 | B-256 | Claims Rep I | 49625 | FT | NE | Claims | 2012-09-17 00:00:00 | 2014-08-22 00:00:00 | Another Job | V | 4.3
211-401 | B-331 | Sales Level I | 48572 | FT | SW | Sales | 2013-12-02 00:00:00 | 2014-08-21 00:00:00 | Unsatisfactory Orientation | I | 2
688-803 | B-580 | Service Representative II | 49565 | FT | SW | SVC | 2012-05-14 00:00:00 | 2014-08-16 00:00:00 | Dissatisfied with company policies | V | 3.87
553-021 | B-444 | Service Representative II | 49565 | FT | NE | SVC | 2012-11-05 00:00:00 | 2014-08-14 00:00:00 | Relocation | V | 4.23
101-036 | B-381 | Sales Level III | 50570 | FT | NE | Sales | 2013-10-21 00:00:00 | 2014-08-06 00:00:00 | Retirement | V | 4.8
102-042 | A-192 | Claims Rep I | 49625 | FT | SW | Claims | 2010-11-08 00:00:00 | 2014-08-05 00:00:00 | Retirement | V | 3
299-407 | [NAME] | Sales Level I | 48572 | FT | SW | Sales | 2014-01-13 00:00:00 | 2014-07-30 00:00:00 | Return to School | V | 3
351-800 | B-354 | Sales Level III | 50570 | FT | NE | Sales | 1991-11-18 00:00:00 | 2014-07-29 00:00:00 | Dissatisfied with promotional opp. | V | 3.5
848-301 | B-401 | Service Rep. I | 48565 | FT | NE | SVC | 2014-02-24 00:00:00 | 2014-07-27 00:00:00 | Another Job | V | No rating
222-000 | B-252 | Claims Rep I | 49625 | FT | NE | Claims | 2012-02-13 00:00:00 | 2014-07-25 00:00:00 | Another Job | V | 4.1
211-488 | B-376 | Sales Level II | 49570 | PT | NE | Sales | 2010-08-16 00:00:00 | 2014-07-25 00:00:00 | Dissatisfied with type of work | V | 3.6
866-368 | B-101 | Trainee | 48617 | FT | NE | Claims | 2014-02-03 00:00:00 | 2014-07-25 00:00:00 | Unsatisfactory Orientation | I | 2.76
208-611 | B-492 | Service Rep. IV | 51565 | FT | SW | SVC | 2014-03-24 00:00:00 | 2014-07-22 00:00:00 | Dissatisfied with the type of work | V | 3.79
899-111 | B-444 | Service Rep. I | 48565 | FT | SW | SVC | 2012-02-20 00:00:00 | 2014-07-18 00:00:00 | Dissatisfied with the type of work | V | No rating
213-788 | B-167 | Claims Rep I | 49625 | FT | NE | Claims | 2011-06-13 00:00:00 | 2014-07-17 00:00:00 | Dissatisfied with hours | V | 3.35
208-345 | B-352 | Sales Level II | 49570 | PT | NE | Sales | 1999-10-14 00:00:00 | 2014-07-15 00:00:00 | Did not return from leave | V | 3.5
208-544 | B-122 | Claims Rep I | 49625 | FT | NE | Claims | 2008-01-14 00:00:00 | 2014-07-10 00:00:00 | Another Job | V | 3.15
210-566 | B-129 | Claims Rep I | 49625 | FT | NE | Claims | 2009-01-15 00:00:00 | 2014-07-07 00:00:00 | Another Job | V | 2.62
677-005 | B-377 | Sales Level I | 48572 | FT | SW | Sales | 2014-03-10 00:00:00 | 2014-07-03 00:00:00 | Relocation | V | 1.8
535-003 | A-144 | Claims Rep I | 49625 | FT | SW | Claims | 2013-08-05 00:00:00 | 2014-07-02 00:00:00 | Abandonment of Job | V | 3.8
109-155 | [NAME] | Sales Level II | 49570 | FT | SW | Sales | 2014-04-07 00:00:00 | 2014-07-02 00:00:00 | Violation of Company policies/practices | I | 3.3
210-692 | [NAME] | Service Rep. II | 49565 | PT | NE | SVC | 2010-04-19 00:00:00 | 2014-06-26 00:00:00 | Another Job | V | 3.33
200-42 | B-486 | Service Rep. [NAME] | 50565 | FT | SW | SVC | 1999-09-27 00:00:00 | 2014-06-23 00:00:00 | Retirement | V | 2.4
210-234 | B-361 | Sales Level II | 49570 | FT | NE | Sales | 2008-03-03 00:00:00 | 2014-06-20 00:00:00 | Attendance/Tardiness | I | 2.9
770-442 | B-395 | Sales Level II | 49570 | FT | SW | Sales | 2011-12-12 00:00:00 | 2014-06-20 00:00:00 | Family Responsibilities/Personal | V | 2.9
211-303 | B-467 | Service Rep. II | 49565 | FT | NE | SVC | 2010-10-18 00:00:00 | 2014-06-19 00:00:00 | Abandonment of Job | V | 2.87
213-791 | B-361 | Sales Level II | 49570 | FT | SW | Sales | 2011-04-11 00:00:00 | 2014-06-13 00:00:00 | Attendance/Tardiness | I | 3.9
214-101 | B-481 | Service Rep. II | 49565 | FT | SW | SVC | 2011-08-01 00:00:00 | 2014-06-09 00:00:00 | Violation of Company policies/practices | I | 2.6
206-199 | B-123 | Claims Rep II | 50625 | FT | NE | Claims | 1992-09-01 00:00:00 | 2014-06-06 00:00:00 | Relocation | V | 3
222-015 | A-156 | Claims Rep I | 49625 | FT | SW | Claims | 2011-08-22 00:00:00 | 2014-06-06 00:00:00 | Family Responsibilities/Personal | V | 2.35
809-909 | B-433 | Service Rep. II | 49565 | FT | SW | SVC | 2012-10-29 00:00:00 | 2014-06-05 00:00:00 | Relocation | V | 3.21
209-400 | A-124 | Claims Rep I | 49625 | FT | SW | Claims | 2008-06-16 00:00:00 | 2014-05-23 00:00:00 | Relocation | V | 2.1
875-578 | B-102 | Trainee | 48617 | FT | NE | Claims | 2014-01-20 00:00:00 | 2014-05-16 00:00:00 | Family Responsibilities/Personal | V | 3
163-021 | B-388 | Sales Level I | 48572 | FT | NE | Sales | 2013-12-02 00:00:00 | 2014-05-16 00:00:00 | Unsatisfactory Orientation | I | 2.1
209-510 | B-478 | Service Rep. [NAME] | 50565 | FT | NE | SVC | 2009-06-08 00:00:00 | 2014-05-07 00:00:00 | Commute | V | 3.35
206-810 | B-555 | Service Representative III | 50565 | FT | SW | SVC | 2007-04-09 00:00:00 | 2014-05-07 00:00:00 | Dissatisfied with type of work | V | 2.65
210-848 | [NAME] | Supervisor | 54638 | FT | SW | Claims | 2012-05-14 00:00:00 | 2014-05-05 00:00:00 | Self Employment | V | 3.65
903-121 | [NAME] | Service Rep. I | 48565 | FT | SW | SVC | 2013-10-21 00:00:00 | 2014-04-29 00:00:00 | Family Responsibilities/Personal | V | 3.56
113-386 | [NAME] | Trainee | 48570 | FT | SW | Sales | 2012-10-22 00:00:00 | 2014-04-29 00:00:00 | Abandonment of Job | V | 3
800-311 | B-413 | Service Rep. In Training | 48535 | FT | SW | SVC | 2014-02-24 00:00:00 | 2014-04-29 00:00:00 | Dissatisfied with promotional opp. | V | 1.58
212-833 | B-412 | Service Rep. II | 49565 | FT | NE | SVC | 2011-05-09 00:00:00 | 2014-04-28 00:00:00 | Another Job | V | 3.9
442-832 | B-108 | Trainee | 48617 | FT | SW | Claims | 2014-01-13 00:00:00 | 2014-04-28 00:00:00 | Dissatisfied with hours | V | 3.01
212-804 | B-422 | Service Rep. I | 49565 | FT | SW | SVC | 2012-07-09 00:00:00 | 2014-04-23 00:00:00 | Abandonment of Job | V | 2.8
317-082 | B-111 | Trainee | 48617 | FT | NE | Claims | 2014-02-03 00:00:00 | 2014-04-21 00:00:00 | Family Responsibilities/Personal | V | 1
888-440 | B-322 | Sales Level II | 49570 | FT | NE | Sales | 2013-08-19 00:00:00 | 2014-04-18 00:00:00 | Dissatisfied with type of work | V | 3.4
851-104 | A-139 | Claims Rep I | 49625 | FT | SW | Claims | 2012-06-25 00:00:00 | 2014-04-18 00:00:00 | Family Responsibilities/Personal | V | 2.17
221-505 | B-395 | Sales Level II | 49570 | PT | NE | Sales | 2011-09-26 00:00:00 | 2014-04-15 00:00:00 | Relocation | V | 2.9
210-832 | B-122 | Claims Coach | 50629 | FT | NE | Claims | 2010-02-04 00:00:00 | 2014-04-11 00:00:00 | Another Job | V | 4
632-041 | B-333 | Sales Level II | 49570 | FT | NE | Sales | 2013-06-24 00:00:00 | 2014-04-06 00:00:00 | Did not return from leave | V | 4.2
210-733 | B-467 | Service Rep. II | 49565 | FT | SW | SVC | 2010-09-07 00:00:00 | 2014-04-04 00:00:00 | Relocation | V | 3.15
909-166 | B-321 | Sales Level I | 48572 | FT | SW | Sales | 2013-10-21 00:00:00 | 2014-04-04 00:00:00 | Attendance/Tardiness | I | 2.8
232-001 | B-133 | Claims Rep I | 49625 | FT | NE | Claims | 2011-11-07 00:00:00 | 2014-04-01 00:00:00 | Another Job | V | 3.24
244-011 | [NAME] | Sales Level I | 48572 | FT | SW | Sales | 2008-06-09 00:00:00 | 2014-04-01 00:00:00 | Family Responsibilities/Personal | V | 2.5
211-033 | A-160 | Claims Rep I | 49625 | FT | SW | Claims | 2012-08-27 00:00:00 | 2014-03-28 00:00:00 | Family Responsibilities/Personal | V | 4.12
404-009 | B-444 | Service Rep. I | 48565 | PT | NE | SVC | 2013-07-29 00:00:00 | 2014-03-27 00:00:00 | Attendance/Tardiness | I | 2.1
443-800 | B-433 | Service Representative I | 48565 | PT | NE | SVC | 2008-07-14 00:00:00 | 2014-03-25 00:00:00 | Self Employment | V | 4.08
300-003 | [NAME] | Service Representative II | 49565 | FT | SW | SVC | 2010-02-15 00:00:00 | 2014-03-25 00:00:00 | Family Responsibilities/Personal | V | 2.75
536-012 | B-400 | Service Rep. In Training | 48535 | FT | SW | SVC | 2012-06-04 00:00:00 | 2014-03-21 00:00:00 | Dissatisfied with type of work | V | No rating
208-369 | B-222 | Claims Rep II | 50620 | FT | NE | Claims | 2013-04-07 00:00:00 | 2014-03-21 00:00:00 | Another Job | V | 3
222-601 | B-483 | Service Rep. I | 48565 | FT | NE | SVC | 2011-08-01 00:00:00 | 2014-03-21 00:00:00 | Another Job | V | 2.7
210-688 | B-363 | Sales Level II | 49570 | FT | NE | Sales | 2010-04-10 00:00:00 | 2014-03-18 00:00:00 | Dissatisfied with type of work | V | 3.4
622-226 | B-466 | Service Representative I | 48565 | FT | SW | SVC | 2013-08-12 00:00:00 | 2014-03-17 00:00:00 | Unable to Pass Licensing | I | 3
368-040 | B-477 | Service Representative III | 50565 | FT | SW | SVC | 2012-05-14 00:00:00 | 2014-03-13 00:00:00 | Family Responsibilities/Personal | V | 4.2
223-111 | A-165 | Claims Rep I | 49625 | FT | SW | Claims | 2011-10-24 00:00:00 | 2014-03-12 00:00:00 | Family Responsibilities/Personal | V | 3
206-444 | [NAME] | Service Representative III | 50565 | PT | NE | SVC | 2003-03-24 00:00:00 | 2014-03-11 00:00:00 | Family Responsibilities/Personal | V | 3.2
235-006 | A-166 | Claims Rep I | 49625 | FT | SW | Claims | 2012-01-23 00:00:00 | 2014-03-11 00:00:00 | Family Responsibilities/Personal | V | 3
582-225 | B-300 | Sales Level I | 48572 | FT | NE | Sales | 2013-03-25 00:00:00 | 2014-03-07 00:00:00 | Dissatisfied with type of work | V | 2.9
800-144 | 1-150 | Claims Rep I | 49625 | FT | SW | Claims | 2012-06-25 00:00:00 | 2014-03-04 00:00:00 | Family Responsibilities/Personal | V | 2.78
676-919 | B-399 | Sales Level I | 48572 | FT | SW | Sales | 2012-02-20 00:00:00 | 2014-02-26 00:00:00 | Did not return from leave | V | 2.5
637-042 | B-477 | Service Representative I | 48565 | FT | NE | SVC | 2013-06-03 00:00:00 | 2014-02-18 00:00:00 | Abandonment of Job | V | 3.3
673-909 | B-310 | Sales Level II | 49570 | FT | NE | Sales | 2013-08-12 00:00:00 | 2014-02-17 00:00:00 | Violation of Company policies/practices | I | 3.8
898-000 | B-386 | Sales Level II | 49570 | FT | SW | Sales | 2013-03-25 00:00:00 | 2014-02-17 00:00:00 | Dissatisfied with type of work | V | 3.8
632-101 | B-267 | Claims Rep I | 49625 | PT | NE | Claims | 2012-06-25 00:00:00 | 2014-02-10 00:00:00 | Another Job | V | 2.6
366-022 | B-544 | Service Representative III | 50565 | FT | SW | SVC | 2008-08-04 00:00:00 | 2014-02-05 00:00:00 | Dissatisfied with type of work | V | 3.21
210-691 | B-152 | Claims Rep I | 49625 | FT | NE | Claims | 2010-06-07 00:00:00 | 2014-02-02 00:00:00 | Dissatisfied with type of work | V | 3.21
401-041 | B-39- | Sales Level I | 48572 | FT | SW | Sales | 2013-09-23 00:00:00 | 2014-01-31 00:00:00 | Abandonment of Job | V | 2.2
208-639 | B-543 | Service Representative III | 49565 | FT | SW | SVC | 2007-05-21 00:00:00 | 2014-01-20 00:00:00 | Did not return from leave | V | 3.3
800-411 | B-120 | Trainee | 48617 | FT | SW | Claims | 2010-11-08 00:00:00 | 2014-01-15 00:00:00 | Dissatisfied with promotional opp. | V | 3.68
208-033 | A-144 | Claims Rep I | 49625 | FT | SW | Claims | 2007-08-20 00:00:00 | 2013-08-19 00:00:00 | Did not return from leave | V | 2.32
206-833 | A-121 | Claims Rep I | 49625 | FT | SW | Claims | 2006-10-30 00:00:00 | 2013-03-13 00:00:00 | Family Responsibilities/Personal | V | 4.3