- Careers
- Support
- Site Map
- Privacy Policy
- Terms of Use
- ©2023 Ideate Software
Support
- Ideate BIMLink
- Getting Started
- Using Ideate BIMLink
- Working in Excel
- How to...
- Create NEW Elements
- Manage Sheets and Revisions
- Create a Model Health Check
- Use Ideate BIMLink for Quality Control
- Manage Key Schedule Data
- Manage Project Standards
- Set Up Projects
- Utilize Type Swapping
- Manage Calculated Values
- Leverage Linked File Data
- Assign Space Types
- Construction Tasks
- Use Ideate Sticky with Ideate BIMLink
- Export Links Into the Same Excel File
- Video Examples
- Automation for Ideate BIMLink
- Customization
- Troubleshooting
- Ideate Explorer
- Getting Started
- Explore Revit Warnings
- Ideate Explorer Basics
- Ideate Query
- BIM Managers
- How to...
- How Do I Move Elements to Another Level?
- How Do I Delete a Hidden DWG?
- How Do I Purge Imports?
- How Do I Export BIM Data?
- How Do I Use Explorer to Swap Types?
- How Do I Manage Worksets?
- How Can I Create a Custom Filter?
- How Can I Use Ideate Query for Quality Assurance?
- How Do I Search by a Parameter Revit Value with Ideate Explorer?
- How Do I Delete ALL Identical Instances?
- Video Examples
- Automation for Ideate Explorer
- Customization
- Troubleshooting
- Ideate Sticky
- IdeateApps Help
- Getting Started
- Ideate ReNumber
- Ideate QuickSelect
- Ideate SmartDelete
- Ideate XRay
- Ideate SpellCheck
- Ideate Annotate
- Ideate Sheet and View Tools
- Customization
- Automation for IdeateApps
- Known Issues
- Ideate StyleManager
- Getting Started
- Using Ideate StyleManager
- How To...
- Troubleshooting Ideate StyleManager
- Automation for Ideate StyleManager
- Ideate Automation
- Ideate Software Platform
- Licensing
- Download Latest
Using Formulas in Cells
Ideate BIMLink supports the use of formulas in Excel spreadsheets cells. When a spreadsheet is imported into Revit, the results of the Excel formula are used.
- Calculate Occupancy
- Capitalization
- Convert Wall Orientation Degree into Text
- Combine Room Number and Mark
- Add a Prefix to a Cell
- Replace the Level number prefix for Doors, Rooms or Spaces Numbers
- Removing Spaces from Names
Calculate Occupancy
=roundup(Area/OccupancyLoad,0)
- OR -
=ROUNDUP(D2/E2,0)
Capitalization
=upper(B2) (copy, then ‘paste values’ into the desired column)
Convert Wall Orientation Degree into Text
=IF(Orientation=0,"East",(IF(Orientation=90,"North",(IF(Orientation=180,"West","South")))))
- OR -
=IF(D2=0,"East",(IF(D2=90,"North",(IF(D2=180,"West","South")))))
Combine Room Number and Mark
=Room Number&"-"&Mark
- OR -
=B2&"-"&B3
Add a Prefix to a Cell
=”Prefix-”&B2 (copy, then ‘paste values’ into the desired column)
Replace the Level number prefix for Doors, Rooms or Spaces Numbers
=REPLACE(Room Number,First Character,Only One Character,"2")
- OR -
=REPLACE(B2,1,1,"2")
Removing Spaces from Names
Some database formats require that key names have no spaces. COBie guidelines indicate that the space is not allowed, for example. Ideate BIMLink can be used to edit Family and Type names. The corresponding Excel function is SUBSTITUTE.
=SUBSTITUTE("Long Name with Spaces"," ","") - this would return "LongNamewithSpaces"
- OR —
=SUBSTITUTE(B2," ","")
See Supported Excel Functions for more information.