Skip to main content

Posts

Showing posts with the label excel

Does the parameter exist?

I'm back after a while with a new article on Dynamo. This time I'll try to explain how to check if a list of parameters are available in the project. This can be used as starting point to QA a model against a pre-defined template. The idea is pretty simple: we need to extract all the parameters from the model and to do this we list all the elements of type "ParameterElement". You'll get the list of both shared and project paraemters in this way. Then we can extract the paraemters names and create a list of paraemter that we want to check (this list can be also an input from Excel). Whit a simple Python script that compares all the parameters name, agains the list of predifined parameters, we can easily extract two lists: the first is the list of matched and the second is the list of unmatched. This is the python code. import  clr clr. AddReference ('ProtoGeometry') from  Autodesk.DesignScript.Geometry  import  * #The inputs to this node...

Dynamo, Revit, Excel, UI...what a wonderful day!

Introduction Today I'll show you two examples of how to use Dynamo to export existing Revit schedules and how to compose a custom schedule on the fly, to be exported to Excel. Both of them with a very nice graphical user interface thanks to Data-Shapes (https://data-shapes.net/) package. Export Schedules Let's start from the easier. The idea behind this script is to export a list of existing schedules to an Excel file, creating for each schedule a separate tab. To be able to complete this script you'll need two packages: Data-Shapes for the graphical interfaces BimorphNodes to extract schedules data The script is very easy and you have to focus only on how to create an interface Then you can use your input to feed the next nodes. Finished! So just push the run button (or use Dynamo Player is you are in Revit 2017.1 or 2017.2) and enjoy the interface. Export parameters to Excel In the second script I'll focus on something more int...

BIM Track™ - Model coordination made easy in few clicks

Generally I'm not used to give reviews and presentation about particular software but, this time, I would like to share some personal feedback about this great platform. Model management When it comes to manage big models, big teams and coordination reviews, you need definitely a platform to track all the changes.  Navisworks is able to manage reports and changes between different stages of the project but, is not able to provide information to each single user directly inside Revit and, of course, is not able to provide a professional cloud platform for Managers to track the progress of models coordination. When first time I faced this problem, I realize that we need a professional environment to manage this workflow and I started to try different ways. First I tried with couple of Dynamo scripts to visualize clash spheres in Revit (based on XML clash reports) combined with Excel Worksheets but this is not very user friendly (at that time we didn't have Dynamo Player...