How to Calculate Single and Double Hotel Rooms from Bed Capacity in WPS Office Spreadsheets
Question details
The user needs a WPS Office Spreadsheets formula to calculate single- and double-occupancy room or bed counts from a total bed capacity and a target double-occupancy percentage.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Hotel room allocation or capacity planning requires splitting total beds into double and single occupancy counts based on a target double-occupancy percentage.
- Observed behavior
- The model must return a whole-number double occupancy count and the remaining single occupancy count without producing fractional rooms or beds.
Open your workbook in WPS Office Spreadsheets and confirm that the total bed capacity cell (for example E4) and the target double-occupancy percentage cell (for example B8) are already entered and formatted correctly.
Calculate Double and Single Occupancy Counts Using INT and Subtraction
Use this when your total bed capacity is in one cell and the target double-occupancy percentage is in another cell.
The formula =INT(E4*B8) multiplies the total beds by the double-occupancy percentage and rounds down to the nearest whole number, preventing fractional rooms or beds. The single occupancy result is simply the remaining amount after subtracting the double occupancy.
Click cell E8 in WPS Office Spreadsheets, or select the cell where you want the double occupancy result.
Type =INT(E4*B8) and press Enter. This calculates the double occupancy amount from the total beds in E4 and the target percentage in B8.
Click cell E7, type =E4-E8, and press Enter. This subtracts the double occupancy amount from the total bed capacity.
If your model counts rooms instead of beds, remember that each double room accommodates two beds. Adjust the double room result accordingly before using the remaining amount.
Adapt the Formula When Counting Rooms Instead of Beds
Use this if your worksheet calculates the number of double rooms rather than the number of double beds.
Calculate Hotel Room Occupancy with WPS Office Spreadsheets
Use WPS Office Spreadsheets to split total bed capacity into single and double occupancy counts with simple Excel-compatible formulas. It is free, lightweight, and handles .xlsx files seamlessly.
- 1. Open WPS Spreadsheets: Launch WPS Office and open the workbook that contains your hotel bed capacity and occupancy target.
- 2. Enter the known values: Place the total bed capacity in cell E4 and the desired double-occupancy percentage in cell B8.
- 3. Use the INT formula for double occupancy: Click cell E8, type =INT(E4*B8), and press Enter.
- 4. Calculate single occupancy: Click cell E7, type =E4-E8, and press Enter to get the remaining single amount.
Frequently Asked Questions
How do I calculate double occupancy beds from a total bed count and a percentage in WPS Spreadsheets?
Select the double occupancy result cell, enter =INT(E4*B8), and press Enter. E4 should contain the total beds and B8 should contain the double-occupancy percentage as a percentage-formatted or decimal value.
Why does the formula use INT instead of ROUND?
INT rounds down to the nearest whole number, which prevents fractional rooms or beds and avoids overcounting double occupancy. ROUND can round up and create an invalid quantity.
How do I get the single occupancy amount after calculating double occupancy?
Click the single result cell and enter =E4-E8. This subtracts the double occupancy amount in E8 from the total bed capacity in E4.
What should I change if the model counts rooms instead of beds?
Since each double room uses two beds, divide the double bed result by two. For example, use =INT(E4*B8)/2 for double rooms, then subtract the double beds from E4 to get single beds.
Can I use these formulas in Microsoft Excel as well?
Yes. The formulas use standard Excel-compatible functions, and WPS Office Spreadsheets can open, edit, and save .xlsx files created in Microsoft Excel.
