What's included
- Excel workbook, seven tabs: Start Here, Setup, Cited Law, Your Units, Gap Analysis, Dashboard, Glossary & Sources
- Cited Law: the sixteen §70217 unit ratios (critical care/ICU 1:2, medical/surgical 1:5, emergency department 1:4, step-down 1:3, psychiatric 1:6, labor & delivery (active) 1:2 and the rest), with the citation on every row
- Your Units: up to 40 units — unit type, patient census and nurses assigned in; actual ratio, applicable limit and status out
- Your own internal target (set on Setup) for units with no §70217 ratio, reported separately from the mandate and never blended into it
- Gap Analysis and Dashboard: each unit's gap to its limit, with mandate and target counts and rates reported separately
- A row you have not marked complete reads 'Not entered', never a pass
- A printable QuickStart PDF that walks through the workbook step by step
Staffing Ratios & Compliance
California §70217 Unit Ratio Compliance Pack
The California §70217 Unit Ratio Compliance Pack is an Excel workbook plus a printable QuickStart guide to it. The workbook's 2. Cited Law tab carries the sixteen §70217 unit ratios exactly as the edition-stamped reference module holds them — critical care/ICU 1:2, medical/surgical 1:5, emergency department 1:4, step-down 1:3, psychiatric 1:6, labor & delivery (active) 1:2 and the rest — each row with its citation, never retyped. On 3. Your Units you enter up to 40 units with their §70217 unit type, patient census and nurses assigned; the workbook computes each unit's patients-per-nurse ratio and tests it against the §70217 limit for that unit type, or against the internal target you set where no ratio applies. 4. Gap Analysis shows how far each unit sits from its limit, and 5. Dashboard counts units against the mandate and against your target separately, never blended. A row you have not marked as entered reads "Not entered", never a pass. The ratios are California law as the module holds them; every census and staffing count is your own, and nothing here is legal or compliance advice.
No subscription. Download once, use forever.
Instant digital download · all sales final. Refund policy
What's included
- Excel workbook, seven tabs: Start Here, Setup, Cited Law, Your Units, Gap Analysis, Dashboard, Glossary & Sources
- Cited Law: the sixteen §70217 unit ratios (critical care/ICU 1:2, medical/surgical 1:5, emergency department 1:4, step-down 1:3, psychiatric 1:6, labor & delivery (active) 1:2 and the rest), with the citation on every row
- Your Units: up to 40 units — unit type, patient census and nurses assigned in; actual ratio, applicable limit and status out
- Your own internal target (set on Setup) for units with no §70217 ratio, reported separately from the mandate and never blended into it
- Gap Analysis and Dashboard: each unit's gap to its limit, with mandate and target counts and rates reported separately
- A row you have not marked complete reads 'Not entered', never a pass
- A printable QuickStart PDF that walks through the workbook step by step
Want this automatically? NursingWorkforce tracks turnover, vacancies, and retention for you.
Live BLS nurse-wage benchmarking, turnover dashboards, and vacancy forecasting — no spreadsheet maintenance required.
Join the Waitlist →More templates
Unit Staffing Adequacy & Ratio Compliance Audit Log
Timestamp shift-by-shift assigned ratios per unit against the applicable state limit — or your internal target where none exists — into a period audit trail.
Oregon HB 2697 Unit Staffing Compliance Pack
Check each unit against the Oregon HB 2697 ratios — ICU 1:2, med-surg 1:4 from June 2026 — with the contested enforcement model flagged, not resolved.
Committee & Disclosure State Staffing Plan Workbook (NY, IL, NJ, RI, VT)
Measure units against your own internal target for NY, IL, NJ, RI and VT and record committee and plan steps — the cited law in words, no invented mandate.
RN Turnover Tracker
Track nurse departures by unit, see your rolling 12-month turnover, and benchmark it against the cited NSI figure.