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:
- 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 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 |
|