DoorbookOccupancy and empty-bed report
List each building or room once. The worked report keeps over-capacity visible, separates men and women room occupancy, and shows where a resident can still be placed.
-
01 List
Start with the rooms people manage
Add the cost per bed, then enter each building or room, its type, its capacity and the residents actually present today.
-
02 Check
Keep vacant and over-capacity rooms visible
The report does not average away a crowded room. Each row gets a status, while the totals show the cost carried by vacant beds.
-
03 Print
Use the report in the monthly round
Add or remove rows as rooms open and close. The result stays in this browser and makes no request, so the printed report does not send HR data anywhere.
Occupancy and empty-bed report
Occupancy and empty-bed report
Prepared from the rooms and residents entered above. Over-capacity rows remain visible for follow-up.
- Total capacity
- 62
- Residents
- 57
- Vacant beds
- 7
- Men-room occupancy
- 79.4%
- Women-room occupancy
- 112.5%
- Monthly cost of empty beds
- £574.00
Rooms that can still take someone: North block, West rooms
| Building or room | Type | Capacity | Residents | Vacant beds | Status |
|---|---|---|---|---|---|
| North block | Men | 24 | 21 | 3 | Within capacity |
| Garden annex | Women | 16 | 18 | 0 | Over capacity |
| East wing | Mixed | 12 | 12 | 0 | Within capacity |
| West rooms | Men | 10 | 6 | 4 | Within capacity |
Questions to check
Use the report to separate a full building from a room that needs attention today.
How are men-room and women-room percentages calculated?
Each percentage uses only the rooms marked with that type: residents divided by capacity. Mixed rooms remain in the overall total and are not silently assigned to either percentage.
What happens when a room is over capacity?
The row is marked over capacity in red and its vacant-bed count is zero. The total residents still includes everyone entered, so the issue stays visible in both the row and the report.
Why show the cost of empty beds?
The building cost continues while a bed is vacant. Multiplying vacant beds by the cost per bed makes the monthly opportunity visible for a staffing or allocation discussion.
Can I add more rooms?
Yes. Use Add room row for another building or room, and remove a row when it is no longer part of the report. The printed table follows the current rows.
Does this store names or occupancy figures?
No. The report runs in this browser only, makes no network request and writes nothing to storage.