Excel and similar spreadsheet programs have always been the mainstay of data entry and analysis operations. Even with access to more sophisticated applications, most architects and engineers, still prefer to modify parameters of projects and components with a fluid interface such as a spreadsheet so that they can take the data elsewhere and do interesting things with it.
The Revit Project being a database, always lent itself to extension using Excel. Dynamo made it even more accessible. This recipe is a small demonstration of all the pieces needed to not only extract Revit component parameters to Excel but also push back updated data back to Revit after performing operations within Excel.
Surprisingly, the biggest challenge turned out to be not the actual connection to Excel, but the smaller nuances of how the parameter data gets modified during the process of transferring between the two applications. If you would like to skip the explanations, you can download the dataset here.
Check out the complete recipe at the work-in-progress GitBook (which, by the way, is an awesome platform)
Over here at Microsol Resources, we field this inquiry often. We researched and can confirm that if you have a 2012 (or later) version of Autodesk AutoCAD or Autodesk AutoCAD LT software*, but have a preference or requirement for the MAC platform, you are able to run the software as a MAC without having to submit a request or require any processing time. Read on to learn how:
In my previous blog, we saw how we could use Project Boulder for Infraworks 360 to simulate a storm surge similar to the one experienced during Hurricane Sandy and observe its effects on Lower Manhattan. What if we now wanted to start conceptualizing ideas for designing a system to protect the areas most affected by the storm surge? How would we approach that design process and how could we communicate it effectively?