Example: In the month of June 4000 inpatients days were served in a hospital with 150 beds. Calculate the percentage of inpatient occupancy rate. Therefore, we recommend that you calculate falls as a rate, specifically, the rate of falls per 1,000 occupied bed days. Later, we will show you how to make this calculation. You can calculate an occupancy rate by following a simple equation. Divide the number of inpatient days of care by the number of bed days available.
We then add up all those 30 midnight snapshots and that gives us our numerator: occupied bed days. Then we have to calculate our denominator, which is called available bed days, and is basically the bed complement for General Medicine multiplied by 30 (the number of days in April). I need a formula for each day to calculate the occupied beds per day. I have been using a Sum(If array formula, but I am not sure how to write one for the occupied beds census. Calculate the bassinet occupancy percentage for the unit on a certain day. Occasionally, at the time of disaster, or during periods of epidemics, all the regular hospital beds are occupied.