Archibus Area calculations

January 24, 2025 Tim Schaubroeck

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

Tim Schaubroeck

FM Support Specialist

More Content by Tim Schaubroeck
Previous Article
Archibus Licensing

How do you find the licenses you have access to in your archibus?

Next Article
Inventor IPN displays more objects in 2024 than in 2020

×

Get Tips Delivered.

Subscribe to Email Updates.

First Name
Last Name
Country
Thank you!
Error - something went wrong!