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:

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      

Allocated Room Area

(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)