Archibus Rm Area Calculations
Issue: The areas listed on data like building/floor area is wrong.
Causes:The update Area Totals action needs to be run.
Solution: You can find the update area totals in the navigator in these areas:
- 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
The update area totals action runs these calculations. Note: This is for non-workspace transactions instances of Archibus
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 |
|
About the Author
More Content by Tim Schaubroeck