Bed occupancy, length of stay and turnover — from one ward export

Upload ward-level data with patient days, bed days, discharges, beds and calendar days. The platform detects the columns and computes the standard capacity indicators per ward and per period.

What you get

  • Bed occupancy rate, average length of stay (ALOS) and turnover interval, overall, per ward and per period.
  • Beds needed at your target occupancy (85% by default) and the bed gap per ward.
  • Ward-months above 100% flagged, with the usual explanation: patient days credited to the discharge month.
  • Unusual length-of-stay months (more than 1.8 SD above the ward's own mean) and an XmR control chart of monthly occupancy.
  • A what-if slider: how many beds shorter stays would release.

Formulas used

Occupancy = patient days ÷ bed days. ALOS = patient days ÷ discharges. Turnover interval = (bed days − patient days) ÷ discharges. Beds needed at target = patient days ÷ (calendar days × target). See the guide for worked examples.

Frequently asked questions

Why is a ward above 100% occupancy?

Usually because a patient's whole stay is credited to the month they were discharged. True occupancy needs a midnight census; the dashboard flags these months instead of hiding them.

Can it refresh monthly from our system?

Yes. Connect REDCap or KoboToolbox, or use the API to upload the export; the analyses re-run and the dashboard republishes once every number verifies.

Try it with your data See a sample dashboard

Related