Adaptive components from Excel

2 min read
Share on twitter
Share on linkedin
Share on facebook
Share on email

This tutorial explores how you can translate geometry from Rhino to Revit via Excel using an adaptive component family. The first stage is to generate some geometry within Rhino/Grasshopper. Below is a simple panelisation script that can be exported to Excel. Note the use of the path mapper component to group Pt1, Pt2, etc. as we want the data to be structured in rows, not columns. At the end of the script, you can use Lunchbox’s ‘Excel Write’ component to export to Excel.

Excel export

Your Excel file should look something like this with four columns and each cell containing an XYZ coordinate. Since we used the newer version of ‘Excel Write’, headers are included. We’ll remove this in the next step.

Dynamo automation

Ensure that your 4-point adaptive component family (or however many points was exported) is pre-loaded into your Revit project. We can then use the ‘AdaptiveComponent.FromExcel‘ node from the BVN package to populate our Revit model with the desired adaptive component. The node reads the Excel file, removes the curly brackets and splits the string into XYZ values so that adaptive components can be placed. There is an optional input to remove the header from the Excel document.

Revit_AdaptiveComponent

Troubleshooting

If you receive an error, which usually takes the form of adaptive components not being placed or collapsed to the ground plane, ensure that the normal to your surface is correct. Depending on the complexity of your Revit family, if the order of placement points is reversed, the adaptive component can fail. The best way to check that your normals are correct is to go into Rhino’s display options and set the backface settings to be a single colour. This setting will give you a visual reference to the surface’s direction.

Rhino_DisplaySettings_1800x850
Share on twitter
Share on linkedin
Share on facebook
Share on email

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Balcony Area and Depth with Dynamo
Premium

Min balcony area and depth

Verify a balcony’s minimum area and depth with Dynamo for compliance with the NSW Apartment Design Guide and SEPP65 requirements.

Renumber Balconies
Premium

Renumber balconies

A Dynamo workflow to renumber balconies based on their associated apartment room to assist in documentation and compliance checking.

Marketing Plans on Sheets
Premium

Marketing plans on sheets

Automatically place marketing plans onto individual sheets and set the various title block properties with Dynamo.

Create Marketing Plans
Premium

Create marketing plans

A workflow to automatically create marketing plans with Dynamo, including cropping and rotating the views.

Copyright​

© 2021 Parametric Monkey
Parametric Monkey and the Parametric Monkey logo are trademarks of Parametric Monkey Pty Ltd.

CONTACT US

Drop us a message and someone from our team will be in touch with you shortly.

BOOM!

Thank you for your interest. Someone from our team will be in touch soon.

WORKSHOP APPLICATION

To find out about upcoming public workshops or to organise a private workshop, please submit the following contact form and we’ll be in touch soon.