Spreadsheet: 35b93eb7-c809-495d-807f-90a7a36c57e6
Sheet: Sheet1

Unnamed: 0 | DENR Hurricane YYYYYYY- Division of XXXXXXX: Overtime Eligible for FEMA Reimbursement | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Division | SSN | Name | Job Title | Annual Salary | [NAME] | LEO* | Activity Code | Week Ending | Ophelia Code Hours | Total Hours Worked | Overtime Hours | Ophelia Overtime Hours | [NAME] | Overtime Rate | Overtime Plus Fringe | Salary Reimbursement
Administration | [NAME] | Doe, [NAME] |  | 50000 | NS | no | 902E | 2007-09-14 00:00:00 | 37 | 47 | 7 | 7 | 24.03846153846154 | 24.03846153846154 | 27.59375 | 193.15625
Administration | [NAME] | Doe, [NAME] |  | 50000 | NS | no | 902E | 2007-09-21 00:00:00 | 10 | 64 | 24 | 10 | 24.03846153846154 | 24.03846153846154 | 27.59375 | 275.9375
Administration | [NAME] | Doe, [NAME] |  | 50000 | NS | no | 902E | 2007-09-28 00:00:00 | 58 | 58 | 18 | 18 | 24.03846153846154 | 24.03846153846154 | 27.59375 | 496.6875
Administration | [NAME] | Smith, Mary |  | 57750 | NS | no | 902E | 2007-09-14 00:00:00 | 48 | 50 | 10 | 10 | 27.76442307692308 | 27.76442307692308 | 31.87078125 | 318.7078125
Administration | [NAME] | Smith, Mary |  | 57750 | NS | no | 902E | 2007-09-21 00:00:00 | 15 | 40 | 0 | 0 | 27.76442307692308 | 27.76442307692308 | 31.87078125 | 0
Administration | [NAME] | Smith, Mary |  | 57750 | NS | no | 902E | 2007-09-28 00:00:00 | 4 | 47 | 7 | 4 | 27.76442307692308 | 27.76442307692308 | 31.87078125 | 127.483125
Administration | [NAME] | Doe, Mary |  | 35600 | S | yes | 902E | 2007-09-14 00:00:00 | 28 | 54 | 14 | 14 | 17.11538461538462 | 25.67307692307693 | 30.75377884615385 | 430.5529038461539
Administration | [NAME] | Doe, Mary |  | 35600 | S | yes | 902E | 2007-09-21 00:00:00 | 50 | 50 | 10 | 10 | 17.11538461538462 | 25.67307692307693 | 30.75377884615385 | 307.5377884615385
Administration | [NAME] | Doe, Mary |  | 35600 | S | yes | 902E | 2007-09-28 00:00:00 | 30 | 46 | 6 | 6 | 17.11538461538462 | 25.67307692307693 | 30.75377884615385 | 184.5226730769231
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 29525 | S | no | 902E | 2007-09-14 00:00:00 | 3 | 44 | 4 | 3 | 14.19471153846154 | 21.29206730769231 | 24.4411640625 | 73.3234921875
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 29525 | S | no | 902E | 2007-09-21 00:00:00 | 4 | 46 | 6 | 4 | 14.19471153846154 | 21.29206730769231 | 24.4411640625 | 97.76465624999999
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 29525 | S | no | 902E | 2007-09-28 00:00:00 | 19 | 61 | 21 | 19 | 14.19471153846154 | 21.29206730769231 | 24.4411640625 | 464.3821171874999
Administration | [NAME] | [NAME], Rock |  | 52325 | NS | yes | 902E | 2007-09-14 00:00:00 | 8 | 40 | 0 | 0 | 25.15625 | 25.15625 | 30.134671875 | 0
Administration | [NAME] | [NAME], Rock |  | 52325 | NS | yes | 902E | 2007-09-21 00:00:00 | 38 | 46 | 6 | 6 | 25.15625 | 25.15625 | 30.134671875 | 180.80803125
Administration | [NAME] | [NAME], Rock |  | 52325 | NS | yes | 902E | 2007-09-28 00:00:00 | 30 | 46 | 6 | 6 | 25.15625 | 25.15625 | 30.134671875 | 180.80803125
Administration | [NAME] | Reynolds, Debbie |  | 63800 | NS | no | 902E | 2007-09-14 00:00:00 | 25 | 49 | 9 | 9 | 30.67307692307692 | 30.67307692307692 | 35.209625 | 316.886625
Administration | [NAME] | Reynolds, Debbie |  | 63800 | NS | no | 902E | 2007-09-21 00:00:00 | 58 | 58 | 18 | 18 | 30.67307692307692 | 30.67307692307692 | 35.209625 | 633.77325
Administration | [NAME] | Reynolds, Debbie |  | 63800 | NS | no | 902E | 2007-09-28 00:00:00 | 20 | 55 | 15 | 15 | 30.67307692307692 | 30.67307692307692 | 35.209625 | 528.144375
Administration | [NAME] | [NAME] |  | 72500 | NS | no | 902E | 2007-09-14 00:00:00 | 8 | 43 | 3 | 3 | 34.85576923076923 | 34.85576923076923 | 40.0109375 | 120.0328125
Administration | [NAME] | [NAME] |  | 72500 | NS | no | 902E | 2007-09-21 00:00:00 | 29 | 43 | 3 | 3 | 34.85576923076923 | 34.85576923076923 | 40.0109375 | 120.0328125
Administration | [NAME] | [NAME] |  | 72500 | NS | no | 902E | 2007-09-28 00:00:00 | 14 | 40 | 0 | 0 | 34.85576923076923 | 34.85576923076923 | 40.0109375 | 0
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 76300 | NS | no | 902E | 2007-09-14 00:00:00 | 40 | 50 | 10 | 10 | 36.68269230769231 | 36.68269230769231 | 42.1080625 | 421.0806249999999
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 76300 | NS | no | 902E | 2007-09-21 00:00:00 | 44 | 50 | 10 | 10 | 36.68269230769231 | 36.68269230769231 | 42.1080625 | 421.0806249999999
Budget, Planning and Analysis | [NAME] | [NAME], [NAME] |  | 76300 | NS | no | 902E | 2007-09-28 00:00:00 | 12 | 40 | 0 | 0 | 36.68269230769231 | 36.68269230769231 | 42.1080625 | 0
 |  |  |  |  |  |  |  |  | 632 | 1167 | 207 | 185 |  |  | Total Salary and Fringes | 5892.703006009614
 |  | Overtime Benefits
 |  | Social Security | 0.0765 | Social Security |  | 0.0765
 |  | Retirement | 0.0714 | LEO Retirement |  | 0.1214
 |  | Total | 0.1479 | LEO Total |  | 0.1979
 | LEO* are Law Enforcement Officers in [NAME], DMF, and DFR only |  |  |  |  | SSN are for convenience only in using PMIS. Do NOT forward this information