Calculations for the Update Area Totals Task
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
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:
- Archibus SaaS / Foundations / Background Data
- Archibus SaaS / Space / Space Inventory
- Space / Space Inventory / Building Performance (Non-Transactional)
- Space / Space Inventory / Group Inventory (Non-Transactional)
- Space / Space Inventory / Room Inventory (Non-Transactional)
- Space / Space Chargeback / Standard Space Chargeback (Non-Transactional)
- Space /Space Chargeback / Shared Workplace Chargeback (Non-Transactional)
- Real Property / Chargeback & Invoicing / Chargeback Administrator / Chargeback Cost Wizard
- Workplace Services / Hoteling / Management Reports
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 Non-occupiable Org |
Sum of non-occupiable organizational. |
fl.area_nocup_org bl.area_nocup_org site.area_nocup_org |
||
|
Total Occupiable Org |
Sum of occupiable organizational. |
fl.area_ocup_org bl.area_ocup_org site.area_ocup_org |
||
|
Total Room Org Area |
Sum of room organizational area. |
fl.area_rm_org bl.area_rm_org site.area_rm_org |
||
|
Total Group Org Area |
Sum of group organizational area. |
fl.area_gp_org bl.area_gp_org site.area_gp_org |
||
|
Total Room Area |
Sum of room area. |
org.area_rm |
||
|
Total Group Area |
Sum of group area. |
org.area_gp |
||
|
Total Occupiable Area |
Sum of occupiable area. |
org.area_ocup |
||
|
Total Non-occupiable |
Sum of non-occupiable. |
org.area_nocup |
||
|
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 |