What's included
- Excel workbook, seven tabs: Start Here, Setup, Cited Law, Your Units, Gap Analysis, Dashboard, Glossary & Sources
- Cited Law: the Oregon ratios — intensive care 1:2 (from June 2024) and medical/surgical 1:4 (from June 2026, was 1:5) — with citation and effective date on each row
- Your Units: up to 40 units — census and nurses assigned in; actual ratio, applicable limit and status out, with units that have no Oregon ratio measured against your internal target
- The enforcement caveat on Start Here, Cited Law and the glossary: OHA's guidance ties enforcement to an approved nurse staffing plan, so 'Below mandate' is not a finding of violation
- Gap Analysis and Dashboard: each unit's gap to its limit, with mandate and target counts 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
Oregon HB 2697 Unit Staffing Compliance Pack
The Oregon HB 2697 Unit Staffing Compliance Pack is an Excel workbook plus a printable QuickStart guide to it. The workbook's 2. Cited Law tab carries the two Oregon ratios the edition-stamped reference module holds as verified — intensive care 1:2 from June 2024, and medical/surgical 1:4 from June 2026 (was 1:5) — each with its citation (Oregon HB 2697 (2023); OAR ch. 333) and effective date, never retyped. On 3. Your Units you enter up to 40 units with census and nurses assigned; intensive care and medical/surgical units are measured against those ratios, and every other unit against the internal target you set. 4. Gap Analysis shows each unit's distance from its limit and 5. Dashboard reports mandate and target counts separately. The pack says plainly, on its Start Here and Cited Law tabs and in its glossary, that how Oregon's ratios bind is contested — the Oregon Health Authority's guidance describes enforcement where a ratio is incorporated into an approved hospital nurse staffing plan — so a "Below mandate" status here is not a finding of violation. Every census and staffing count is your own; 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 Oregon ratios — intensive care 1:2 (from June 2024) and medical/surgical 1:4 (from June 2026, was 1:5) — with citation and effective date on each row
- Your Units: up to 40 units — census and nurses assigned in; actual ratio, applicable limit and status out, with units that have no Oregon ratio measured against your internal target
- The enforcement caveat on Start Here, Cited Law and the glossary: OHA's guidance ties enforcement to an approved nurse staffing plan, so 'Below mandate' is not a finding of violation
- Gap Analysis and Dashboard: each unit's gap to its limit, with mandate and target counts 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.
California §70217 Unit Ratio Compliance Pack
Check each unit's census-to-nurse ratio against the cited California §70217 limit for its unit type — an unentered row never reads as a pass.
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.