Spreadsheet: 685874d1594238524-lookup-formula-is-too-taxing-on-excel-and-my-pc-book1
Sheet: PAC5G

 | EID | POS | VID | EMP_NAME | BEGDT | ENDDT | DEPTID | PAC | CLASS | PROJECT | RUNDT
[PHONE] 2018-08-01 | [PHONE] | 00060048 | [PHONE] | Penny J | 2018-08-01 00:00:00 | 2018-08-31 00:00:00 | 00DCFCEN | 70000 | 03120 | 18-0010SWAHC | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00060048 | [PHONE] | Penny J | 2018-09-01 00:00:00 | 2018-10-31 00:00:00 | 00DCFCEN | 70000 | 03120 | 19-0010SWAHC | 2020-07-01 00:00:00
[PHONE] 2018-11-01 | [PHONE] | 00060048 | [PHONE] | Penny J | 2018-11-01 00:00:00 | 2019-08-31 00:00:00 | 00FEDCEN | 70000 | 03120 | 19-0010SWAHC | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00060048 | [PHONE] | Penny J | 2019-09-01 00:00:00 | 2020-02-29 00:00:00 | 00FEDCEN | 70000 | 03120 | 20-0010SWAHC | 2020-07-01 00:00:00
[PHONE] 2020-03-01 | [PHONE] | 00060048 | [PHONE] | Penny J | 2020-03-01 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00061614 | [PHONE] | Loretta | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00061614 | [PHONE] | Loretta | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00061614 | [PHONE] | Loretta | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00035902 | [PHONE] | [NAME] D | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 6ACDDCVS | 11005 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00035902 | [PHONE] | [NAME] D | 2018-09-01 00:00:00 | 2019-07-31 00:00:00 | 6ACDDCVS | 11005 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-08-01 | [PHONE] | 00035902 | [PHONE] | [NAME] D | 2019-08-01 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00040688 | [PHONE] | Nohemi | 2017-09-01 00:00:00 | 2017-10-30 00:00:00 | 08CDDFBS | 11006 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2017-10-31 | [PHONE] | 00040688 | [PHONE] | Nohemi | 2017-10-31 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00037191 | [PHONE] | [NAME] | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 07CDDCVS | 11005 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00037191 | [PHONE] | [NAME] | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 07CDDCVS | 11005 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00037191 | [PHONE] | [NAME] | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 07CDDCVS | 11005 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-11-16 | [PHONE] | 00087519 | [PHONE] | [NAME] | 2019-11-16 00:00:00 | 2099-12-31 00:00:00 | 01ADDINH | 41000 | 03065 | 20-0539APSTS | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00029366 | [PHONE] | Rose | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 3EINVCPS | 11008 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00029366 | [PHONE] | Rose | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 3EINVCPS | 11008 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00029366 | [PHONE] | Rose | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 3EINVCPS | 11008 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00039762 | [PHONE] | [NAME] | 2017-09-01 00:00:00 | 2018-07-31 00:00:00 | 00PGSREG | 73000 | 03122 | 18-0040RAAHC | 2020-07-01 00:00:00
[PHONE] 2018-08-01 | [PHONE] | 00039762 | [PHONE] | [NAME] | 2018-08-01 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00077225 | [PHONE] | [NAME] | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 01CDDCVS | 11005 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00077225 | [PHONE] | [NAME] | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 01CDDCVS | 11005 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00077225 | [PHONE] | [NAME] | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 01CDDCVS | 11005 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-11-05 | [PHONE] | 00033050 | [PHONE] | Garland E | 2018-11-05 00:00:00 | 2019-07-28 00:00:00 | 07INVCPS | 11008 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-07-29 | [PHONE] | 00033050 | [PHONE] | Garland E | 2019-07-29 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00085563 | [PHONE] | Casandra R | 2017-09-01 00:00:00 | 2018-02-18 00:00:00 | 3EINVCPS | 11008 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-02-19 | [PHONE] | 00085563 | [PHONE] | Casandra R | 2018-02-19 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00031387 | [PHONE] | Lillian V | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00031387 | [PHONE] | Lillian V | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00031387 | [PHONE] | Lillian V | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 08CDDCVS | 11005 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00062885 | [PHONE] | [NAME] | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 01INVCPS | 11008 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00062885 | [PHONE] | [NAME] | 2018-09-01 00:00:00 | 2019-07-31 00:00:00 | 01INVCPS | 11008 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-08-01 | [PHONE] | 00062885 | [PHONE] | [NAME] | 2019-08-01 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2018-01-15 | [PHONE] | 00078301 | [PHONE] | Gala Dawn | 2018-01-15 00:00:00 | 2018-08-31 00:00:00 | 07INVCPS | 11008 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00031085 | [PHONE] | Gala Dawn | 2018-09-01 00:00:00 | 2018-12-31 00:00:00 | 07INVCPS | 11008 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-01-01 | [PHONE] | 00031085 | [PHONE] | Gala Dawn | 2019-01-01 00:00:00 | 2099-12-31 00:00:00 | X | X | X | X | 2020-07-01 00:00:00
[PHONE] 2017-09-01 | [PHONE] | 00070119 | [PHONE] | Janice M | 2017-09-01 00:00:00 | 2018-08-31 00:00:00 | 01CDDFBS | 11006 | 03040 | 18-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2018-09-01 | [PHONE] | 00070119 | [PHONE] | Janice M | 2018-09-01 00:00:00 | 2019-08-31 00:00:00 | 01CDDFBS | 11006 | 03040 | 19-0530CPSTS | 2020-07-01 00:00:00
[PHONE] 2019-09-01 | [PHONE] | 00070119 | [PHONE] | Janice M | 2019-09-01 00:00:00 | 2099-12-31 00:00:00 | 01CDDFBS | 11006 | 03040 | 20-0530CPSTS | 2020-07-01 00:00:00