Archibus Area calculations

Tim Schaubroeck

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

Applications Expert - FM
More Content by Tim Schaubroeck

Archibus Licensing

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

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

Return to Resources

Welcome to our Hub

Archibus Area calculations

About the Author

Previous Article

Next Article

Solutions Beyond Software™

Archibus Area calculations

About the Author

Previous Article

Next Article

Related Content

Discover how healthcare organizations can improve collaboration between Facilities, IT, and Clinical Operations to drive efficiency, safety, and better patient outcomes. Read the IMAGINiT whitepaper.

Learn how healthcare FM teams can better prepare for audits and inspections by organizing building and asset data in a centralized, accessible system.

Explore why effective FM is critical in healthcare and how IMAGINiT helps facilities teams manage spaces, assets, and compliance with confidence.

Did you know that you can have Archibus monitor a table for changes that are made and who is making those changes?

Starting with v2024.01 of Smart Client, you can change the font size by editing the user.config file.

Learn how Eptura Visitor Management and IMAGINiT’s FM team help organizations across industries simplify check-ins, improve security, and streamline workplace operations.

In Archibus, there are several tables for which you can define drawing highlights patterns for, such as the Division and Department tables.

You will want your Revit model to have a floor plan view for every floor that will have in Archibus. Once this is setup, open the view of that level

Have you ever found rooms in Web Central or Smart Client that don't exist in the AutoCAD drawing? Or rooms in the AutoCAD drawing that aren't reflected in the Archibus data?

Effective visitor management is essential for maintaining security, improving efficiency, and delivering a seamless experience. In this on-demand webinar, IMAGINiT and Eptura explore how Eptura’s Visi

Learn how IMAGINiT’s FM experts helped a major research library transform their environmental monitoring and security management.

Are you struggling with fragmented data across your construction and facilities projects? Discover how to take control of your project data, from design through construction and into long-term facilit

Discover how IMAGINiT's solutions empower government facilities to optimize operations, ensure compliance, and achieve excellence in management and performance.

Eptura for Government streamlines asset management, boosts employee productivity, and ensures top-notch security for your built environment.

Archibus by Eptura ensures secure, efficient operations, enhancing productivity while meeting all federal security standards.

Learn how Eptura’s Visitor Management Solution helps organizations streamline check-ins, boost security, and create a seamless guest experience.

Smart client has several methods for using filters to restrict the data in the view you’re are looking at.

Eptura’s advanced visitor management system offers a customizable and effortless check-in process, as well as advanced security measures and access control.

Eptura connects people, places, and assets, enabling your organization to drive more value.

This modern, web-based platform allows organizations to take control of their real estate portfolio, streamline operations, and foster workplace innovation.

Solutions Beyond Software™