Organizing Excel Data

Several Excel tools are particularly useful in re-organizing and auditing the data after it is exported from Ideate BIMLink.

Finding Duplicates
Revit does not allow for duplicates in View names or Sheet numbers and will flag duplicates for Mark and Type Mark with warnings.  To help avoid these issues, the Conditional Formatting within Excel can be used to highlight duplicates.

See Excel menu:  Home tab > Styles panel >Conditional Formatting > Highlight Cells Rules > Duplicate Values

Related topic:  Manage Duplicate Type Marks

Sorting with Excel
Starting with versions 2013.6 / 2014.3, Ideate BIMLink includes sorting.  If you forgot to sort, or are using an earlier version, you can also sort within Excel.  The easiest way to sort in Excel is to place your cursor within the very first cell (A1) and then to use the Sort tool which is found from the Excel menu:  Data tab > Sort and Filter panel > Sort

Using an Excel Table
Another method that can be used to filter and sort large amounts of data is to use the Excel Table tool.

See Excel menu:  Insert tab ►Tables panel ► (Table)

For more information, also see the Microsoft website help topic:  Create or delete an Excel table in a Worksheet.

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.