Data source
Excel import
Upload an updated copy of the Detailed Compensation Worksheet. The import replaces the current data. For each department and rank, the most recent fiscal year and quarter is used.
Current dataset
Detailed Compensation Worksheet.xlsx
Imported 11/6/2026, 11:51:13 PM
- Departments
- 45
- Ranks
- 9
- Incentive types
- 77
- Pay entries
- 16,518
Sheets read
| Sheet | Used as | Rows read | Status |
|---|---|---|---|
| SuppressionBase | base pay | 1,753 | imported |
| SREMSBase | base pay (EMT/Paramedic) | 76 | imported |
| DeferredComp | employer deferred comp | 132 | imported |
| Education | incentives + 275 education caps | 2,381 | imported |
| EMS | incentives | 1,315 | imported |
| ERHealthcare | employer health contributions | 1,072 | imported |
| EEHealthcare | employee medical premiums | 2,261 | imported |
| EEDental | employee dental premiums | 87 | imported |
| EEVision | employee vision premiums | 72 | imported |
| FLSA | FLSA overtime hours | 29 | imported |
| Holiday | incentives | 554 | imported |
| Longevity | incentives | 1,806 | imported |
| Misc | incentives | 3,418 | imported |
| Retirement | pension / OPEB / social security rates | 2,813 | imported |
| Schedule | work hours | 245 | imported |
How the workbook is read
- SuppressionBase: monthly Top_Step base pay per department and rank.
- SuppressionBase / SREMSBase: Step 1–15 values too, for step comparison.
- Education, EMS, Misc: each incentive's calculated monthly Step and Top Step amounts. EMS notes saying "Only higher of EMT/Paramedic" are applied automatically.
- Hire-date notes like "Only if hired prior to 2/1/14" or "eliminated if hired after 2017" limit an incentive when a hire date is set. Longevity Classic and PEPRA rows are split at the date in their note, or 1/1/2013 when there's no note.
- Retirement (PERS, OPEB and Social Security tables) and EEHealthcare / EEDental / EEVision: employee contributions for the take-home view.
- Education cap table (second table, headed "Department Name … Education_Cap … Max_Amt"): caps total education pay.
- Longevity: the Max column, as a % of base or a dollar amount.
- Holiday: a % of base, or monthly hours paid at the hourly rate (same as the Comps sheets).
- Schedule: hours per week, shift pattern and annual hours. EMT/Paramedic incentives under $10 (except uniform allowance) are read as $/hour and multiplied by each department's hours per week.
- Comparison, healthcare, leave and retirement sheets aren't used. SREMS (EMT/Paramedic) schedules aren't included yet.