Archibus SaaS / Foundations / Background Data
Archibus SaaS / Space / Space Inventory
Space / Space Inventory (Non-Transactional)
Space / Space Chargeback (Non-Transactional)
Real Property / Chargeback & Invoicing
Workplace Services / Hoteling / Management Reports

Calculations for the Update Area Totals Task

To ensure that the reports use your latest data, be sure to run the Update Area Totals action prior to viewing the inventory and occupancy reports. If you do not first run this task, the reports will present data from the last time that the task was run and will not reflect any changes in area boundaries or how an area is assigned.

You can access the Update Area Totals routine from these locations:

If you are using the Hoteling or Shared Workplace Chargeback tasks, you will run the Update Area, Space Percentages or Update Area, Space and Time Percentages tasks. These tasks run all of the below calculations, as well as calculate Allocated Room Area. See Update Area Totals - Space and Time Percent for information.

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.

The Update Area Totals task runs the following calculations.

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(rm.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(rm.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(rm.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(rm.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(rm.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(rm.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(rm.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

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(rm.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(rm.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(rm.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