I was recently presented with an Ideate BIMLink tech support case in which a customer was interested in overriding the surface pattern and color of Revit model elements that he needed to edit in the near-future. After running through their structural analysis program, he identified elements that needed to be edited or swapped out, and then wanted to change the color through Excel and have that color change the surface patterns of those elements when imported back into Revit.
One of the solutions that we provided him was to create a custom yes/no parameter and add that parameter to the structural categories (or most categories for that matter) in Revit. This parameter was called Edit Element Reminder and since it was a yes/no parameter, it produced a checkbox. A check in the box would then remind the user that he or she needed to edit the element at some point.
In addition to creating the checkbox, we also recommended that he create a multi-category schedule for most of the Revit categories and then add all of the parameters that they want to see and export. Included in these schedules was the custom Edit Element Reminder yes/no parameter, which also has a conditional format parameter to fill the cell color in red when set to "yes." From there, he could then export the schedule using Ideate BIMLink, run his analysis tools, identify the elements that required editing and then change the status in Excel. From there, that Excel file can be imported, which will then change the status of those elements. In turn, those elements will be flagged in the schedule, alerting the user to edit the element. In addition to creating the parameters and schedules, we also recommend that they create custom 3D coordination views that only displayed the categories of elements that they were interested in editing. To that view, we added a filter that would color the elements that required editing, which uses the Edit Element Reminder parameter as the driving force behind the color change. Elements that did not require editing would then half tone, allowing the elements that needed editing to stand out.
Using custom parameters, filters, and Ideate BIMLink, you can quickly add a status to Revit elements as a reminder to add or edit information for each of the elements that you choose to edit. In the example shown below, all elements in red need to be edited, while the half-toned elements do not.
STEP 1 - Add yes/no project parameters. In order to add the reminder, we are first going to start off by adding some yes/no project parameters and then apply them to categories that you want to remind yourself to edit. For this example, we are going to create a custom yes/no parameter for all instance-based Revit categories. You may want to consider unchecking views since they are not elements.Here is the example of the Edit Element Reminder project parameter that we created for the selected Revit categories (from the previous image).
STEP 2 - Customizing coordination views and schedules. Once the parameters have been created, we went ahead and created coordination views that isolated the element categories that we wanted to have a better look at. We also created separate schedules for categories we wanted to add reminders to. In this example, we created a multi-category schedule, which schedules most Revit categories (system families, masses, etc. are NOT included in multi-category schedules) and then created schedules for other categories that are not included in a multi-category schedule.Here is an example of a multi-category schedule with the Edit Element Reminder parameter added. Once we determine which elements we need to edit (say we did a structural analysis and determined that we need to edit the properties of certain structural elements), we can use Excel and BIMLink to quickly change the statuses of elements and remind ourselves to review the elements at a later time. Keep in mind that we can add as many parameters that we wish to, which will help us to make informed decisions.
STEP 3 - Add conditional formatting. In addition to creating the custom schedules with our newly created parameter(s), we also added a conditional format to the Edit Element Reminder parameter. In this example, if we place a checkbox in the Edit Element Reminder field, it will color the schedule cell red to remind us that we need to make changes to that element(s).
STEP 4 - Export with BIMLink Multi-Category option. Once the parameters, views, and schedules have been created, we are ready to export our Schedules using Ideate BIMLink. In this example, we are exporting our data using the BIMLink Multi-Category option. Unlink the Revit Multi-Category option, Ideate BIMLink’s Multi-Category is more robust and includes many more Revit categories, allowing you to edit one Excel spreadsheet instead of many. After the export, we can use Excel to change the EDIT Element Reminder statuses, which will remind us which elements to edit in the future.
STEP 5 - Check filters. Before exporting the BIMLink multi-category link, it is advised that you visit the filters tab and filter the list by the Edit Element Reminder parameter whose condition "is editable." This will ensure that your Excel file only shows categories that have the Edit Element Reminder parameter applied to it. By utilizing this method, you will omit categories such as views, annotations, etc., which do not have the Edit Element Reminder parameter applied to them.
STEP 6 - Edit Parameters in Excel. Once the export is complete, you are ready to edit your parameters. In this example, we are interested in changing the status of the Edit Element Reminder yes/no parameter. Perhaps we ran a structural analysis or had a client meeting and determined that we need to make changes to particular elements in the Revit model. If this is a case, we will add a reminder to edit those elements. In addition, we can add some comments and explain why we need to edit those elements. For yes/no parameters, your choices are TRUE (yes) or FALSE (no). When imported back into Revit using Ideate BIMLink, TRUE values will result in a check mark and FALSE values will not.
STEP 7 - Import Excel file back to Revit. Once the Excel file has been edited, we can then import the Excel document back into Revit using Ideate BIMLink, which will then update the Revit model and corresponding schedules. In the example shown here, we have several structural columns that we added reminders to, which are flagged with checkboxes and a red color fill. We also added some comments, which reminds us why we need to make the change.
STEP 8 - Create status filters. If you are interested in applying color to the elements that you need to edit, you could create some filters that represent the YES and/or NO statuses and then apply those filters to the view that you want to see the color in. For this example, we created filters for the YES and NO values. We will add these filters to the 3D color view and color each of the elements that have a YES status, and add halftone each of the elements that have a NO status. By utilizing the YES and the NO filters, the color will pop out, and the elements that we are not interested in editing will fade out in the background.
STEP 9 - Add color to reflect element status. Once the filters have been created, you can then go to the view that you want to override with color and add those filters to the filters tab of the visibility/graphics dialogue box. In this example, we added the YES filter and applied a red color and solid fill pattern to the surface patterns of the elements that we want to edit, and then for all of the NO's we utilized the halftone option.
With all of the pieces in place, we have created a view that clearly distinguishes the elements that need editing (colored elements) and the ones that do not (halftoned). After you edit each element (swap out, change properties, etc), you can then select the element and remove the checkbox from the Edit Element Reminder parameter in the properties dialogue box (better yet, you can re-export the schedule using Ideate BIMLink and set all the values to FALSE, which will indicate that you edited each element). After doing so, those elements will then turn to halftone, indicating that they no longer require editing.
About the Author
Sash Kazeminejad - ACI, LEED AP AEC Senior Application Specialist
Sash brings proficiency in Autodesk solutions including AutoCAD and Revit Architecture to Ideate customers. His industry experience includes project management, BIM Management, and design for Architectural firms in California, Montana and Oregon. He is LEED accredited professional and is on track to achieve California licensure with Oregon to follow. In his academic life, Sash was awarded a variety of college scholarships, earned a BA in Environmental Design, a MA in Architecture from Montana State University (MSU) and taught Building Information Modeling courses at MSU Gallatin College. As a Revit Architecture Autodesk Certified Instructor, Sash provides Revit Architecture training and support for AEC firms. @sashpdx