Space / Space Inventory (Transactional)
Space / Occupancy (Transactional)
Space / Space Chargeback / Space Chargeback (Transactional)
Calculations for the Update Area Totals Task
The Update Area Totals task runs the below calculations.
You can access the Update Area Totals routine from these locations:
- Space / Space Inventory / Room Inventory - Set Up & Manage
- Space / Space Inventory / Building Performance
- Space / Space Inventory / Group Inventory
- Space / Space Inventory / Space Manager
- Space / Space Chargeback / Space Chargeback
- Space / Occupancy / Space Manager
- Space / Occupancy / Background Data
Note: If your site adheres to conventions established by the BOMA 2017 Office Space Standards document, you will want to examine the BOMA 2017 Method A and Method B buttons on the Building Performance report. These buttons calculate various area values based on the BOMA Method A and Method B standards. See Calculating Rentable Area According to BOMA 2017 Methods A and B.
Note: These calculations are for a room transaction-based space inventory. If your site is using the non-transactional space inventory tasks, see Calculations for the Update Area Totals Task (Non-Transactional).
Name | Definition | Result Tables and Columns | Calc Tables and Columns | Filter Tables and Columns |
---|---|---|---|---|
Total Room Area |
Sum of room areas. |
fl.area_rm, bl.area_rm, site.area_rm |
sum(rm.area) |
rmcat.used_in_calcs IN ('all_totals') |
Total Group Area |
Sum of group areas. |
fl.area_gp, bl.area_gp, site.area_gp |
sum(gp.area) |
|
Total Area |
Total Room Area + Total Group Area |
|
sum(rm.area) + sum(gp.area) |
|
Total Vertical Penetration Area |
Sum of room areas assigned to rmcat.supercat of VERT |
fl.area_vert_pen, bl.area_vert_pen, site.area_vert_pen |
sum(rm.area) |
rmcat.supercat = VERT |
Rentable Area |
Internal Gross Area - Tot Vert Pen Area |
fl.area_rentable, bl.area_rentable, site.area_rentable |
area_gross_int - area_vert_pen |
|
Total Service Area |
Sum of room areas assigned to rmcat.supercat of SERV |
fl.area_serv, bl.area_serv, site.area_serv |
sum(rm.area) |
rmcat.supercat = SERV |
Usable Area |
Rentable Area - Total Service Area |
fl.area_usable, bl.area_usable, site.area_usable |
area_rentable - area_serv |
|
R/U Ratio |
Rentable Area / Usable Area |
fl.ratio_ru, bl.ratio_ru, site.ratio_ru |
area_rentable / area_usable |
|
Efficiency Rate (U/R) |
Usable Area / Rentable Area |
fl.ratio_ur, bl.ratio_ur, site.ratio_ur |
area_usable / area_rentable |
|
Total Non-occupiable Area |
Sum of room areas assigned to rmcat with occupiable = 0 and used_in_calcs IN ('all_totals') |
fl.area_nocup, bl.area_nocup, site.area_nocup |
sum(rmpct.area) |
rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Non-occupiable Dept |
Sum of room areas assigned to departments with occupiable = 0 and used_in_calcs IN ('all_totals') |
fl.area_nocup_dp, bl.area_nocup_dp, site.area_nocup.dp |
sum(rmpct.area) |
rm.dp_id is not null AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Non-occupiable Common |
Sum of room areas with prorate <> NONE and occupiable = 0 and used_in_calcs IN ('all_totals') |
fl.area_nocup_comn, bl.area_nocup_comn, site.area_nocup_comn |
sum(rmpct.area) |
rm.prorate <> NONE AND rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Area |
Sum of room areas assigned to rmcat with occupiable = 1 and used_in_calcs IN ('all_totals') |
fl.area_ocup, bl.area_ocup, site.area_ocup |
sum(rmpct.area) |
rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Dept |
Sum of room areas assigned to departments with occupiable = 1 and used_in_calcs IN ('all_totals' |
fl.area_ocup_dp, bl.area_ocup_dp, site.area_ocup_dp |
sum(rmpct.area) |
rm.dp_id is not null AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Total Occupiable Common |
Sum of room areas with prorate <> NONE and occupiable = 1 and used_in_calcs IN ('all_totals') |
fl.area_ocup_comn, bl.area_ocup_comn, site.area_ocup_comn |
sum(rmpct.area) |
rm.prorate <> NONE AND rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Total Room Department Area |
Sum of room area assigned to divisions and departments |
fl.area_rm_dp, bl.area_rm_dp, site.area_rm_dp |
sum(rmpct.area) |
rm.dp_id is not null AND rmcat.used_in_calcs IN ('all_totals') |
Total Group Department Area |
Sum of group area assigned to divisions and departments |
fl.area_gp_dp, bl.area_gp_dp, site.area_gp_dp |
sum(gp.area) |
gp.dp_id is not null |
Total Room Common |
Sum of room areas with prorate <> NONE |
fl.area_rm_comn, bl.area_rm_comn, site.area_rm_comn |
sum(rm.area) |
rm.prorate <> NONE AND rmcat.used_in_calcs IN ('all_totals') |
Total Group Common |
Sum of group areas with prorate <> NONE |
fl.area_gp_comn, bl.area_gp_comn, site.area_gp_comn |
sum(gp.area) |
gp.prorate <> NONE |
Remaining Area |
Internal Gross Area - Total Area |
fl.area_remain, bl.area_remain, site.area_remain |
area_gross_int - (area_rm + area_gp) |
|
Total Room Area, dv and dp |
Sum of room areas assigned to department and division |
dp.area_rm, dv.area_rm |
sum(rmpct.area) by rm.dv_id or rm.dp_id |
rmcat.used_in_calcs IN ('all_totals') |
Total Group Area, dv and dp |
Sum of group areas assigned to department and division |
dp.area_gp, dv.area_gp |
sum(gp.area) by gp.dv_id or gp.dp_id |
|
Total Occupiable Area, dv and dp |
Sum of room areas assigned to rmcat with occupiable = 1 and used_in_calcs IN ('all_totals') |
dp.area_ocup, dv.area_ocup |
sum(rmpct.area) by rm.dv_id or rm.dp_id |
rmcat.occupiable = 1 AND rmcat.used_in_calcs IN ('all_totals') |
Total Non-occupiable, dv and dp |
Sum of room areas assigned to rmcat with occupiable = 0 and used_in_calcs IN ('all_totals') |
dp.area_nocup, dv.area_nocup |
sum(rmpct.area) by rm.dv_id or rm.dp_id |
rmcat.occupiable = 0 AND rmcat.used_in_calcs IN ('all_totals') |
Total Area, type, cat, and std |
Sum of room areas assigned to category type, or standard |
rmcat.area, rmtype.area, rmstd.area |
sum(rm.area) by rm.rm_cat, rm.rm_type, or rm.rm_std |
|
Total Count, type, cat, and std |
Count of room assigned to category, type, or standard |
rmcat.tot_count, rmtype.tot_count, rmstd.tot_count |
count(rm) by rm.rm_cat, rm.rm_type, or rm.rm_std |
|
Average Area, type, cat, and std |
Total Area / Total Count |
rmcat.area_avg, rmtype.area_avg, rmstd.area_avg |
area / tot_count |
|
Occupancy Count | Count of the number of occupants assigned to a room as of a certain date or a date range | |||
(rmpct.area_rm) |
(the corresponding room’s area) * (pct_space / 100) * (pct_time / 100). | |||
Allocated Area (rm.area_alloc) |
Derived by adding up all of the rmpct.area_rm values (above field) for a specific room. |
SUM(rmpct.area_rm) |