Archibus 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

Applications Expert - FM

More Content by Tim Schaubroeck
Previous Article
Archibus Licensing
Archibus Licensing

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

Next Article
Archibus: Drawing setup
Archibus: Drawing setup

When you open a drawing in AutoCAD extensions for the first time, it will prompt you to enter basic informa...

Optimize Your Team's IWMS

Learn More