RTV Tools

Friday, August 19, 2011

Quickly review Error Report by parsing Element ID in spreadsheet

I find the Error Report - Warning - Select by ID process to be a little unwieldy in Revit (at the moment).

Here is a little process that may speed things up for you when reviewing a Error Report in Revit.
  1. Save Error Report to HTML
  2. Open HTML Error Report
  3. Copy data to Excel spreadsheet.
  4. Use RIGHT formula to extract only the id number to a new column.
    eg =RIGHT(C3,7)
  5. Copy the cell containing the id number to the 'Select Elements by ID' dialog in Revit.

1 comment:

  1. You can also use Excel to 'sort' the View column - then you will be able to work on all the affected elements View-by-View.

    ReplyDelete