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
=roundup(Area/OccupancyLoad,0)
  - OR -
=ROUNDUP(D2/E2,0)

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

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.

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

If you'd like to upload a file to help explain the issue, you can upload a file to Hightail.