🎉 Free 14-day trial — No credit card required.   Start your free trial →
📈
Free Resource Download Updated: October 2026 (UK Rates & Regulations)

Care Home Staff Dependency Tool Template

A free Excel dependency tool that scores resident acuity and converts it into the care hours and staffing levels each shift requires.

What’s Included in This Resource

  • ✓ Acuity scoring matrix across mobility, continence, cognition and nutrition
  • ✓ Converts dependency scores into required care hours per resident
  • ✓ Compares required versus rostered hours for every shift
  • ✓ Produces safe-staffing evidence for CQC Regulation 18 records

Care Home Staff Dependency & Acuity Calculator

An Excel tool that translates resident clinical dependency scores into statutory safe staffing hours per shift under CQC Regulation 18.

  1. 1

    Score Resident Acuity Levels

    Evaluate each resident across 4 core domains: Mobility & Transfers, Continence Care, Cognition & Dementia, and Nutrition & Hydration.

  2. 2

    Convert Scores to Required Care Hours

    The sheet automatically computes direct care hours required per resident per 24-hour cycle (e.g. Low: 2.0h, Medium: 3.5h, High: 5.0h, Complex: 6.5h+).

  3. 3

    Calculate Required Carer Ratios per Shift

    Distributes required hours across Early, Late, and Night shifts, accounting for double-handed transfers.

  4. 4

    Compare Roster against Dependency Requirement

    Flags under-staffed shifts and provides mathematical evidence for CQC safe staffing files.

30-Bed Residential & Dementia Unit Dependency Calculation

Total Daily Acuity Evaluation Across 30 Residents:

Low Dependency (6 residents × 2.0h) 12.0 hours
Medium Dependency (12 residents × 3.5h) 42.0 hours
High Dependency (8 residents × 5.0h) 40.0 hours
Complex / 2:1 Care (4 residents × 7.0h) 28.0 hours
Total Daily Care Hours Required 122.0 direct care hours
Recommended Staffing (Day: 6 carers, Eve: 5 carers, Night: 3 carers) 126.0 rostered hours (Safe)

Direct evidence satisfying CQC Regulation 18 (Safe Staffing) requirements.

Need automated workforce management?

AsanWork automates everything in this resource directly inside our cloud platform.

Start Free Trial →

Get Instant Access

Enter your details to download Care Home Staff Dependency Tool Template instantly.

We respect your privacy. No spam guaranteed.

Frequently Asked Questions

Inspectors recognise validated acuity tools including the Barthel Index, the Rhys Hearn method, and modified social care dependency scoring tools.
Monthly for stable residents, and immediately following any hospital discharge, fall, or clinical change in condition.