Ideate BIMLinkWorking in ExcelExcel Tips
  • Using Formulas in Cells

    • 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)

    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.

    Submit feature or issue request for Ideate Software

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

    By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.