Spreadsheet: lynn_blair__24344__Gas Logistics Customer Service 01M&B
Sheet: Sheet1

GIS ID | Name | Job Group | Job Title | Org Unit | Hire Date | PRC Rating | Grade | 1999     Annual Salary | Increase Type 1 | Increase Amt 1 USD Equiv | Increase Pct 1 | Increase Type 2 | Increase Amt 2 USD Equiv | Increase Pct 2 | Increase Type 3 | Increase Amt 3 USD Equiv | Increase Pct 3 | Total Inc Amt USD Equiv | Total Inc Pct | 2000        New Annual Salary USD Equiv | Lump Sum Amt USD Equiv | PRC Promote | Promote | Bonus Amount | Bonus % | 2001         Mid Year Promotions | Year End 2001 Salary | 2001        Merit % | 2001 Merit | New             2002 Salary | 2001 Bonus
90009837 | ADAMS, JEAN | SPEC-CS | REP MKT SVC | [NAME] | 1998-09-10 00:00:00 | STRONG | CP14 | 52788 | Merit | 2079.55 | 0.0394 |  | 0 |  |  | 0 | 0 | 2079.55 | 0.0394 | 54867.55 | 0 |  | No | 4000 | 0.0758 |  | 54867.55 | 0.0375 |  |  | 0
 | BENNINGFIELD, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1979-06-01 00:00:00 | STRONG | CP14 | 60720 | Merit | 2377 | 0.0391 |  | 0 |  |  | 0 | 0 | 2377 | 0.0391 | 63097 | 0 |  | No | 4000 | 0.0659 |  | 63097 | 0.0375 |  |  | 0
90009847 | BLAIR, JEAN | SPEC-CS | REP MKT SVC | [NAME] | 1997-03-16 00:00:00 | SATISFACTORY | CP14 | 51984 | Merit | 2049.4 | 0.0394 |  | 0 |  |  | 0 | 0 | 2049.4 | 0.0394 | 54033.4 | 0 |  | No | 3000 | 0.0577 |  | 54033.4 | 0.0375 |  |  | 0
90009839 | BRYAN, RANDY | SPRCJR-CS | REP MKT SVCS ASSOC | [NAME] | 1999-06-15 00:00:00 | EXCELLENT | CP12 | 45000 | Merit | 1787 | 0.0397 |  | 0 |  |  | 0 | 0 | 1787 | 0.0397 | 46787 | 0 | * | No | 3000 | 0.0667 |  | 46787 | 0.0375 |  |  | 0
90009864 | BUCHANAN, [NAME] | SPECSR-CS | COORD MKT SVCS | [NAME] | 1981-05-07 00:00:00 | STRONG | CP17 | 69240 | Merit | 2597 | 0.0375 | Promotion Hierarchical | 2943 | 0.0425 |  | 0 | 0 | 5540 | 0.08 | 74780 | 0 |  | No | 12000 | 0.1733 |  | 74780 | 0.0375 |  |  | 0
90009846 | CALLANS, NANCY | SPEC-CS | REP MKT SVC | [NAME] | 1981-08-17 00:00:00 | SATISFACTORY | CP14 | 46788 | Equity | 584.85 | 0.0125 | Merit | 1754.55 | 0.0375 |  | 0 | 0 | 2339.4 | 0.05 | 49127.4 | 0 |  | No | 3000 | 0.0641 |  | 49127.4 | 0.0375 |  |  | 0
90009843 | CARR, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1997-06-16 00:00:00 | SATISFACTORY | CP14 | 50316 | Merit | 1986.85 | 0.0395 |  | 0 |  |  | 0 | 0 | 1986.85 | 0.0395 | 52302.85 | 0 |  | No | 3000 | 0.0596 |  | 52302.85 | 0.0375 |  |  | 0
90009835 | CLAPPER, KAREN | SPEC-CS | REP MKT SVC | Market Services 062 02230000 | 1998-03-02 00:00:00 | STRONG | CP14 | 51294 | Merit | 2023.53 | 0.0394 |  | 0 |  |  | 0 | 0 | 2023.53 | 0.0394 | 53317.53 | 0 |  | No | 4000 | 0.078 | 55980 | 55980 | 0.0375 |  |  | 0
90009840 | FORBISH, SHERRY | SPEC-CS | REP MKT SVC | [NAME] | 1998-09-17 00:00:00 | EXCELLENT | CP14 | 54096 | Merit | 2029 | 0.0375 | Promotion Hierarchical | 2299 | 0.0425 |  | 0 | 0 | 4328 | 0.08 | 58424 | 0 |  | No | 6000 | 0.1109 |  | 58424 | 0.0375 |  |  | 0
90129166 | [NAME], AVA | CLRSR-CS | ASST MKTG SR | [NAME] | 2000-08-07 00:00:00 | SATISFACTORY | CP10 | 30600 | Merit | 1247.5 | 0.0408 |  | 0 |  |  | 0 | 0 | 1247.5 | 0.0408 | 31847.5 | 0 |  | No | 600 | 0.0196 |  | 31847.5 | 0.0375 |  |  | 0
90010346 | GIAMBRONE, LAURA | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1972-02-22 00:00:00 | SATISFACTORY | CP16 | 56058 | Merit | 2202.18 | 0.0393 |  | 0 |  |  | 0 | 0 | 2202.18 | 0.0393 | 58260.42 | 0 |  | No | 3000 | 0.0535 |  | 58260.42 | 0.0375 |  |  | 0
90009851 | GREANEY, CHRIS | SPEC-CS | REP MKT SVC | [NAME] | 1978-02-28 00:00:00 | STRONG | CP14 | 53004 | Merit | 2087.65 | 0.0394 |  | 0 |  |  | 0 | 0 | 2087.65 | 0.0394 | 55091.65 | 0 |  | No | 4000 | 0.0755 | 57840 | 57840 | 0.0375 |  |  | 0
90009866 | HERNANDEZ, ALBERT | SPEC-CS | REP MKT SVCS SR | Customer Service / Tw | 1989-01-23 00:00:00 | SATISFACTORY | CP16 | 56112 | Merit | 2204.2 | 0.0393 |  | 0 |  |  | 0 | 0 | 2204.2 | 0.0393 | 58316.2 | 0 |  | No | 3000 | 0.0535 |  | 58316.2 | 0.0375 |  |  | 0
90009852 | [NAME], RANDY | SPEC-CS | REP MKT SVC | [NAME] | 1978-07-20 00:00:00 | SATISFACTORY | CP14 | 49680 | Merit | 1963 | 0.0395 |  | 0 |  |  | 0 | 0 | 1963 | 0.0395 | 51643 | 0 |  | No | 3000 | 0.0604 |  | 51643 | 0.0375 |  |  | 0
90009848 | KOWALKE, TERRY | SPEC-CS | COORD MKT SVCS | Customer Service / Tw | 1986-04-01 00:00:00 | EXCELLENT | CP17 | 65352 | Merit | 2451 | 0.0375 | Promotion Hierarchical | 4085 | 0.0625 |  | 0 | 0 | 6536 | 0.1 | 71888 | 0 |  | No | 6000 | 0.0918 |  | 71888 | 0.0375 |  |  | 0
90009838 | LINHART, JOE | SPEC-CS | REP MKT SVC | [NAME] | 1998-03-01 00:00:00 | SATISFACTORY | CP14 | 48972 | Merit | 1936.45 | 0.0395 |  | 0 |  |  | 0 | 0 | 1936.45 | 0.0395 | 50908.45 | 0 |  | No | 3000 | 0.0613 |  | 50908.45 | 0.0375 |  |  | 0
90009836 | MCDANIEL, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1995-08-01 00:00:00 | NEEDS IMPROVEMENT | CP14 | 49560 |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 | 49560 | 0 |  | No | 0 | 0 |  | 49560 | 0.0375 |  |  | 0
90127728 | MCEVOY, CHRISTINE | SPRCJR-CS | REP MKT SVCS ASSOC | [NAME] | 2000-07-01 00:00:00 | STRONG | CP12 | 36000 | Merit | 1350 | 0.0375 | Promotion Hierarchical | 5586 | 0.1552 |  | 0 | 0 | 6936 | 0.1927 | 42936 | 0 |  | No | 1000 | 0.0278 |  | 42936 | 0.0375 |  |  | 0
90009874 | MILLER, BEVERLY | SPEC-CS | REP MKT SVC | Customer Service / Tw | 1997-12-29 00:00:00 | STRONG | CP14 | 57060 | Merit | 2239.75 | 0.0393 |  | 0 |  |  | 0 | 0 | 2239.75 | 0.0393 | 59299.75 | 0 |  | No | 4000 | 0.0701 |  | 59299.75 | 0.0375 |  |  | 0
90127649 | MINTER, TRACY | SPRCJR-CS | REP MKT SVCS ASSOC | [NAME] | 2000-07-01 00:00:00 | STRONG | CP12 | 36000 | Merit | 1350 | 0.0375 | Promotion Hierarchical | 5586 | 0.1552 |  | 0 | 0 | 6936 | 0.1927 | 42936 | 0 |  | No | 1000 | 0.0278 |  | 42936 | 0.0375 |  |  | 0
90009865 | MULLIGAN, AMY | SPRCJR-CS | REP MKT SVCS ASSOC | Customer Service / Tw | 1999-07-01 00:00:00 | EXCELLENT | CP12 | 45000 | Merit | 1787 | 0.0397 |  | 0 |  |  | 0 | 0 | 1787 | 0.0397 | 46787 | 0 | * | No | 3000 | 0.0667 |  | 46787 | 0.0375 |  |  | 0
90009857 | PERRY, KATHERINE | SPEC-CS | REP MKT SVC | [NAME] | 1994-03-14 00:00:00 | SATISFACTORY | CP14 | 45228 | Equity | 1243.77 | 0.0275 | Merit | 1696 | 0.0375 |  | 0 | 0 | 2939.77 | 0.065 | 48167.77 | 0 |  | No | 3000 | 0.0663 |  | 48167.77 | 0.0375 |  |  | 0
90009830 | PORTER, DIANA | SPEC-CS | REP MKT SVC | [NAME] | 1981-10-27 00:00:00 | SATISFACTORY | CP14 | 51528 | Merit | 2032.3 | 0.0394 |  | 0 |  |  | 0 | 0 | 2032.3 | 0.0394 | 53560.3 | 0 |  | No | 3000 | 0.0582 |  | 53560.3 | 0.0375 |  |  | 0
90009831 | SCURLOCK, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1998-11-23 00:00:00 | NEEDS IMPROVEMENT | CP14 | 48840 |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 | 48840 | 0 |  | No | 0 | 0 |  | 48840 | 0.0375 |  |  | 0
90009842 | STURR, KATHRYN | SPRCJR-CS | REP MKT SVCS ASSOC | [NAME] | 1990-03-05 00:00:00 | STRONG | CP12 | 39636 | Merit | 1486 | 0.0375 | Promotion Hierarchical | 1814 | 0.0458 |  | 0 | 0 | 3300 | 0.0833 | 42936 | 0 |  | No | 2700 | 0.0681 |  | 42936 | 0.0375 |  |  | 0
90040967 | WALDEN, SHIRLEY | SPEC-CS | REP MKT SVC | [NAME] | 1991-04-08 00:00:00 | SATISFACTORY | CP14 | 47232 | Merit | 1871.2 | 0.0396 |  | 0 |  |  | 0 | 0 | 1871.2 | 0.0396 | 49103.2 | 0 |  | No | 3000 | 0.0635 |  | 49103.2 | 0.0375 |  |  | 0
90009868 | WARD, [NAME] | SPEC-CS | REP MKT SVC | Customer Service / Tw | 1992-06-01 00:00:00 | STRONG | CP14 | 47640 | Merit | 1787 | 0.0375 | Promotion Hierarchical | 1957 | 0.0411 |  | 0 | 0 | 3744 | 0.0786 | 51384 | 0 |  | No | 4000 | 0.084 |  | 51384 | 0.0375 |  |  | 0
90009869 | WASHINGTON, KATHY | SPEC-CS | REP MKT SVC SR | Customer Service / Tw | 1981-06-01 00:00:00 | STRONG | CP16 | 63804 | Merit | 2492.65 | 0.0391 |  | 0 |  |  | 0 | 0 | 2492.65 | 0.0391 | 66296.65 | 0 |  | No | 4000 | 0.0627 |  | 66296.65 | 0.0375 |  |  | 0
90009845 | WILKENS, JERRY | SPEC-CS | REP MKT SVC | [NAME] | 1975-01-01 00:00:00 | STRONG | CP14 | 51843 | Merit | 2044.11 | 0.0394 |  | 0 |  |  | 0 | 0 | 2044.11 | 0.0394 | 53887.11 | 0 |  | No | 4000 | 0.0772 | 56580 | 56580 | 0.0375 |  |  | 0
90009832 | WOODSON, HARRY | SPEC-CS | REP MKT SVC | [NAME] | 1994-02-21 00:00:00 | STRONG | CP14 | 51144 | Merit | 2017.9 | 0.0395 |  | 0 |  |  | 0 | 0 | 2017.9 | 0.0395 | 53161.9 | 0 |  | No | 4000 | 0.0782 |  | 53161.9 | 0.0375 |  |  | 0
 | BODNAR, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87744 |  |  |  |  |  |  | 87744 | 0.0375 |  |  | 0
 | VAUGHAN, CARA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36000 |  |  |  |  |  |  | 36000 | 0.0375 |  |  | 0
 | MILLER, CHRIS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36000 |  |  |  |  |  |  | 36000 | 0.0375 |  |  | 0
 | BARRY, PATRICK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36000 |  |  |  |  |  |  | 36000 | 0.0375 |  |  | 0
 | HIBBARD, SCOTT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36000 |  |  |  |  |  |  | 36000 | 0.0375 |  |  | 0
 | Totals
GIS ID | Name | Job Group | Job Title | Org Unit | Hire Date | PRC Rating | Grade | 1999     Annual Salary | Increase Type 1 | Increase Amt 1 USD Equiv | Increase Pct 1 | Increase Type 2 | Increase Amt 2 USD Equiv | Increase Pct 2 | Increase Type 3 | Increase Amt 3 USD Equiv | Increase Pct 3 | Total Inc Amt USD Equiv | Total Inc Pct | 2000        New Annual Salary USD Equiv | Lump Sum Amt USD Equiv | PRC Promote | Promote | Bonus Amount | Bonus % | 2001         Mid Year Promotions | Year End 2001 Salary | 2001        Merit % | 2001 Merit | New             2002 Salary | 2001 Bonus
90010340 | ALDINGER, WILLIAM | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1981-05-01 00:00:00 | NEEDS IMPROVEMENT | CP16 | 65260 |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 | 65259.6 | 0 |  | No | 0 | 0 |  | 65259.6 | 0.0375 |  |  | 0
 | COLLINS, MARION | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1998-07-06 00:00:00 | SATISFACTORY | CP16 | 55101 | Merit | 2166.28 | 0.0393 |  | 0 |  |  | 0 | 0 | 2166.28 | 0.0393 | 57267.16 | 0 |  | No | 3000 | 0.0544 |  | 57267.16 | 0.0375 |  |  | 0
 | COOPER, TIMOTHY | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1985-04-16 00:00:00 | STRONG | CP16 | 51384 | Equity | 3312 | 0.0645 | Merit | 1927 | 0.0375 |  | 0 | 0 | 5239 | 0.102 | 56623 | 0 |  | No | 4000 | 0.078 |  | 56623 | 0.0375 |  |  | 0
 | CRAMER, [NAME] | SPEC-CS | REP MKT SVC | Market Services 062 02230000 | 1999-04-01 00:00:00 | SATISFACTORY | CP14 | 54000 | Merit | 2125 | 0.0394 |  | 0 |  |  | 0 | 0 | 2125 | 0.0394 | 56125 | 0 |  | No | 3000 | 0.0556 |  | 56125 | 0.0375 |  |  | 0
90010343 | HOWARD JR, JACK | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1984-09-04 00:00:00 | NEEDS IMPROVEMENT | CP16 | 51418 |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 | 51417.6 | 0 |  | No | 0 | 0 |  | 51417.6 | 0.0375 |  |  | 0
90010344 | LAFERLA, LYNDA | SPEC-CS | REP MKT SVC | Market Services 062 02230000 | 1977-06-16 00:00:00 | STRONG | CP14 | 60118 | Merit | 2354.43 | 0.0392 |  | 0 |  |  | 0 | 0 | 2354.43 | 0.0392 | 62472.27 | 0 |  | No | 4000 | 0.0665 |  | 62472.27 | 0.0375 |  |  | 0
90010345 | PHILLIPS, MARY | SPEC-CS | REP MKT SVC SR | Market Services 062 02230000 | 1972-08-21 00:00:00 | STRONG | CP16 | 61692 | Merit | 2413.45 | 0.0391 |  | 0 |  |  | 0 | 0 | 2413.45 | 0.0391 | 64105.45 | 0 |  | No | 6000 | 0.0973 |  | 64105.45 | 0.0375 |  |  | 0
90010341 | RIVERS, CYNTHIA | SPEC-CS | REP MKT SVC SR | Customer Service / Tw | 1986-09-01 00:00:00 | SUPERIOR | CP16 | 63120 | Merit | 2467 | 0.0391 |  | 0 |  |  | 0 | 0 | 2467 | 0.0391 | 65587 | 0 |  | No | 8500 | 0.1347 |  | 65587 | 0.0375 |  |  | 0
90009870 | CONKLIN, JACOB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36000 | 0.0375 |  |  | 0
 | Totals
 | EMPLOYEES WHO LEFT CUSTOMER SERVICE TEAMS IN 2001
90009872 | CORMIER, MARTHA | SPRCJR-CS | REP MKT SVCS ASSOC | Customer Service / Tw | 1989-07-31 00:00:00 | NEEDS IMPROVEMENT | CP12 | 38388 |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 | 38388 | 0 |  | No | 0 | 0 |  | 38388 | 0.0375 |  |  | 0
90009834 | DYKES, TANGIE | SPEC-CS | REP MKT SVC SR | [NAME] | 1989-01-23 00:00:00 | SATISFACTORY | CP16 | 58464 | Merit | 2292.4 | 0.0392 |  | 0 |  |  | 0 | 0 | 2292.4 | 0.0392 | 60756.4 | 0 |  | No | 3000 | 0.0513 |  | 60756.4 | 0.0375 |  |  | 0
90009856 | [NAME], JODIE | SPEC-CS | REP MKT SVC | [NAME] | 1982-03-16 00:00:00 | EXCELLENT | CP14 | 62496 | Merit | 2344 | 0.0375 | Promotion Hierarchical | 2656 | 0.0425 |  | 0 | 0 | 5000 | 0.08 | 67496 | 0 | * | No | 6000 | 0.096 |  | 67496 | 0.0375 |  |  | 0
90009861 | NEWMAN, RUTHE | SPEC-CS | REP MKT SVC | [NAME] | 1990-05-03 00:00:00 | STRONG | CP14 | 50016 | Merit | 1975.6 | 0.0395 |  | 0 |  |  | 0 | 0 | 1975.6 | 0.0395 | 51991.6 | 0 |  | No | 4000 | 0.08 |  | 51991.6 | 0.0375 |  |  | 0
90009829 | CARTER, PAMELA | SPEC-CS | REP MKT SVC | [NAME] | 1997-08-22 00:00:00 | SATISFACTORY | CP14 | 45540 | Equity | 1024.65 | 0.0225 | Merit | 1708 | 0.0375 |  | 0 | 0 | 2732.65 | 0.06 | 48272.65 | 0 |  | No | 3000 | 0.0659 |  | 48272.65 | 0.0375 |  |  | 0
 | DAILY, LEONARD | SPEC-CS | REP MKT SVC | [NAME] | 1998-03-16 00:00:00 | SATISFACTORY | CP14 | 48864 | Merit | 2054.56 | 0.042 |  | 0 |  |  | 0 | 0 | 2054.56 | 0.042 | 50918.56 | 0 |  | No | 3000 | 0.0614 |  | 50918.56 | 0.0375 |  |  | 0
90009850 | LOCKNAR, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1998-10-05 00:00:00 | SATISFACTORY | CP14 | 52656 | Merit | 2074.6 | 0.0394 |  | 0 |  |  | 0 | 0 | 2074.6 | 0.0394 | 54730.6 | 0 |  | No | 3000 | 0.057 |  | 54730.6 | 0.0375 |  |  | 0
90009863 | LYNN, [NAME] | SPEC-CS | REP MKT SVC | [NAME] | 1997-07-21 00:00:00 | SATISFACTORY | CP14 | 45540 | Equity | 1024.25 | 0.0225 | Merit | 1708 | 0.0375 |  | 0 | 0 | 2732.25 | 0.06 | 48272.25 | 0 |  | No | 3000 | 0.0659 |  | 48272.25 | 0.0375 |  |  | 0