Spreadsheet: 53988d1253907388-sorting-via-auto-filter-causes-formulas-to-change-data-filter-test
Sheet: FullTimeUpload

[NAME] | Dept | ID | Name | Active COS Count | Position | PAR Approved | Job Code | Job Title | Union Code | Sal Plan | Grade | Step | [NAME] | [NAME] | [NAME] | Longevity Rate Code | Annual Longevity Amt | Other Stipends Code | Other Stipend | [NAME] | Service Date | Inc Date | Increase Date | Date of Next Increase | Last Date Prior to Rate Increase | Projected Start Date | Projected End Date | Calculated Starting Date | Calculated End Date | # of Projected Workdays at Rate 1 | # of Projected Workdays at Rate 2 | Rate 1 | Rate 2 | Rate 3 | Rate 1 Total | Rate 3 Total | Other Pay - (Paid Lump Sum in Dec) | Total Projected Pay | Funding | Total Projected COS Pay | BASE RATE 1 | BASE RATE 2 | Total BASE | Total EDU | Total Long | Total Stipend
1 | Tax | 1 | Name 1 | 1 | 12345 |  | C111 | Machine Operator | UAW | S35 | 10 | 5 | 5 |  |  |  |  |  |  | 35 | 2000-08-28 | 2009-02-08 | 2009-02-08 00:00:00 | 2010 | 2010-02-08 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 101 | 102 | 5 | 5 | 5 | 3535 | 3570 | 0 | 7105 | COS | 7105 | 5 | 5 | 7105 | 0 | 0 | 0
2 | [NAME] | 3 | Name 2 | 1 | 12346 |  | C112 | Director | UAW | S35 | 08 | 5 | 5 |  |  | LONGEV | 650 |  |  | 35 | 1985-02-19 |  | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7105 | 0 | 650 | 7755 | COS | 7755 | 5 | 5 | 7105 | 0 | 650 | 0
2 | [NAME] | 4 | Name 3 | 1 | 12347 |  | C113 | [NAME] | MAA | A37 | 04 | 7 | 7 |  |  |  |  |  |  | 37.5 | 2008-10-29 | 2008-10-29 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 5 | Name 4 | 1 | 12348 |  | C114 | Analyst | MAA | A37 | 04 | 7 | 7 |  |  | LONGEV | 350 |  |  | 37.5 | 1998-07-20 | 2008-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 350 | 7962.5 | COS | 7962.5 | 5 | 5 | 7612.5 | 0 | 350 | 0
2 | [NAME] | 6 | Name 5 | 1 | 12349 |  | C116 | Executive Secretary | MAA | A37 | 11 | 7 | 7 |  |  |  |  |  |  | 37.5 | 2002-11-11 | 2008-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 7 | Name 6 | 1 | 12350 |  | C117 | Senior Analyst | MAA | A37 | 06 | 7 | 7 |  |  |  |  |  |  | 37.5 | 2002-01-07 | 2004-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 8 | Name 7 | 1 | 12351 |  | C118 | Compliance Officer | MAA | A37 | 13 | 7 | 7 |  |  |  |  |  |  | 37.5 | 2003-01-06 | 2003-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 9 | Name 8 | 1 | 12352 |  | C119 | Supervisor | MAA | A37 | 08 | 5 | 7 |  |  |  |  |  |  | 37.5 | 2005-07-11 | 2008-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 10 | Name 9 | 1 | 12353 |  | C120 | Assistant Director | MAA | A37 | 02 | 2 | 7 |  |  |  |  |  |  | 37.5 | 2008-06-30 | 2008-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 11 | Name 10 | 1 | 12354 |  | C118 | Compliance Officer | MAA | A37 | 08 | 3 | 7 |  |  |  |  |  |  | 37.5 | 2006-02-06 | 2008-07-01 | 7/1 | 2010 | 2010-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-06-30 00:00:00 | 2009-09-19 00:00:00 | 2010-06-30 00:00:00 | 203 | 0 | 5 | 5 | 5 | 7612.5 | 0 | 0 | 7612.5 | COS | 7612.5 | 5 | 5 | 7612.5 | 0 | 0 | 0
2 | [NAME] | 12 | Name 11 | 1 | 12355 |  | C114 | Analyst | UAW | S35 | 08 | 3 | 5 |  |  |  |  |  |  | 35 |  |  | 7/1 | 2010 | 2010-07-01 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 0 | 0 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | COS | 0 | 5 | 5 | 0 | 0 | 0 | 0