What the Sullivan Spreadsheet Is and Why It Matters
The Sullivan Spreadsheet is a publicly available spreadsheet maintained by the California Department of Industrial Relations that tracks workers' compensation claim data, including average settlement amounts, claim duration, and injury categories. It is used by employers, insurers, attorneys, and policymakers to benchmark claim outcomes and identify cost‑saving opportunities.
- What the Sullivan Spreadsheet Is and Why It Matters
- Key Components of California Workers' Compensation
- Core Benefit Types
- How the Sullivan Spreadsheet Organizes Data
- Practical Uses for Employers and Insurers
- How Claimants Can Leverage the Spreadsheet
- Recent Updates and Where to Find the Spreadsheet
- Common Misconceptions
More from this site
Keep reading the latest coverage
Key Components of California Workers' Compensation
California's workers' compensation system provides medical care, wage replacement, and disability benefits to employees injured on the job, regardless of fault. Benefits are funded through employer-paid insurance premiums or self‑insurance. The system is governed by the Workers' Compensation Act (WCA) and overseen by the Division of Workers' Compensation (DWC).
Core Benefit Types
- Medical Treatment: All reasonable and necessary medical services related to the injury.
- Temporary Disability (TD): 2/3 of the employee's average weekly wage, up to a statutory maximum.
- Permanent Disability (PD): Lump‑sum or periodic payments based on the degree of permanent impairment.
- Supplemental Job Displacement Benefits: Training and wage replacement for workers unable to return to their prior job.
How the Sullivan Spreadsheet Organizes Data
The spreadsheet is divided into tabs that correspond to claim status (open, closed, pending) and injury categories (e.g., musculoskeletal, occupational disease, traumatic injury). Each row represents an aggregated claim cohort, showing:
| Metric | Estimate or Range | Context |
|---|---|---|
| Average Settlement (Closed Claims) | $8,500‑$12,000 | 2022‑2023 data, all injury types |
| Median Claim Duration | 180‑210 days | Time from injury report to claim closure |
| TD Weekly Rate | 66.7% of weekly wage | Statutory maximum $1,357 (2024) |
Practical Uses for Employers and Insurers
By comparing a company's claim metrics to the Sullivan Spreadsheet averages, stakeholders can:
- Identify out‑lier claims that may need early intervention.
- Benchmark premium costs against industry averages.
- Develop targeted safety programs for high‑risk injury categories.
For example, if an employer's average settlement for musculoskeletal injuries is $15,000—well above the spreadsheet's $9,000 median—they may invest in ergonomic assessments to reduce costs.
How Claimants Can Leverage the Spreadsheet
Workers filing a claim can use the spreadsheet to gauge realistic expectations for settlement amounts and claim timelines. Knowing the typical range helps in negotiating settlements and setting realistic recovery plans.
Recent Updates and Where to Find the Spreadsheet
The latest version (released March 2024) reflects data through December 2023. It is downloadable from the DWC's official website under "Statistical Reports > Workers' Compensation Claims Data." The file is provided in .xlsx format and includes a data dictionary for interpretation.
Common Misconceptions
• Misconception: The spreadsheet predicts individual claim outcomes.Reality: It shows aggregated trends; individual cases vary based on injury severity and employer practices.
• Misconception: Higher settlements always mean employer fault.Reality: Settlements can reflect injury complexity, medical costs, and statutory caps, not necessarily negligence.