If you are working with the following methods, you will encounter the Allocated Room Area field in many reports and statistics:
The Allocated Room Area field of the Workspace Transactions (the rmpct) table represents how much space (both space-wise and time-wise) is allocated to a particular instance of use. It is calculated as:
rmpct.area_rm = (the corresponding room’s area) * (pct_space / 100) * (pct_time / 100)
This instance of use can then be billed to the corresponding department
Space reports sum the Allocated Room Area field of the Workspace Transactions table to the appropriate room. For example, consider room HQ-19-106. This is a storage room with an area of 9.26 feet, as recorded in the Rooms table.
Suppose the space in this storage room is shared so that three different departments equally divide its space. You would create three Workspace Transaction records with Percentage of Space at 33%, Percentage of Time at 100%, and the appropriate department specified for each record.
When you run the Update Area Totals action for the current date (this example does not consider time percentages), you will see the following Allocated Room Area values:
As you can see, room 106's area of 9.26 feet has been evenly distributed such that three different departments are each responsible for 33 percent of this area, that is 3.09 feet.
Consider another example.
The Workspace Transaction records will be:
| Workspace Transaction |
Start Date | End Date | Percentage of Time | Percentage of Space | Department Assignment |
Allocated Room Area |
| 1 | 9/1 | 9/15 | 50 | 50 | A | 40 |
| 2 | 9/1 | 9/15 | 50 | 50 | B | 40 |
| 3 | 9/16 | 9/30 | 50 | 50 | B | 40 |
Since Department A uses 50 percent of the room's space during 50 percent of the specified time frame, then the Allocated Room Area for this instance of use is 40 square feet. Department A will be charged for 40 square feet of space.
The allocated area for Department B is 80 square feet, since it is suing 50% of 160 and this occurs 100% of the time.
Space reports sum the Allocated Room Area field of the Workspace Transactions table to the appropriate room. For this room, the above scenario would show a total Allocated Room Area of 120 for the period of 9/1 to 9/30. The reports showing under-allocated and over-allocated rooms would then flag this room as having unused area.