Sheets from Excel

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

When developing a project document list, the most convenient way is to create information within Excel. The formulas and formatting in Excel allow for a lot of mundane document management tasks to be expedited. The next step is to get the document list into Revit and generate sheets from that list.

Option 1: Simple workflow

For a simple document spreadsheet containing sheet number and name information, we can use a simple Dynamo script as follows.

The title bock family and file path of the sheet list needs to be assigned as the inputs for the script. The list is then sorted and any redundant spreadsheet data removed before the sheets are created. There are two possibilities for sheet creation within Dynamo:

  • Sheet.ByNameNumberTitleBlockAndView’ – This is a standard Dynamo node. It requires Sheet Names, Sheet Numbers, Title block Family Type, and View inputs. If the project is in a very early stage, the views for the sheets have generally not been created yet. Therefore they cannot be used as an input without generating an error.
  • Tool.CreateEmptySheet’ – This is a node from the SteamNodes package. It requires Titleblock Family Type, Sheet Numbers, Sheet Names and the refresh inputs. The good thing about this node is that you don’t need to have the views in your model for it to work, as it will create empty sheets.

Option 2: Advanced workflow

For a more complicated spreadsheet, we may have multiple worksheets and additional parameter information. For example, BVN utilises an organisation method for assigning different trade packages in a document set via the ‘BVN Alphabet’ parameter. This standard allows us to group and quickly identify views and sheets in the Project Browser and group trade package documentation together. In the example below, the Excel document spreadsheet is identifying Sheet Number, Sheet Name, BVN Alphabet series, Sheet Issue Date, Design Stage, as well as having multiple worksheets corresponding to the different BVN Alphabet series.

Although these additional fields allow for greater functionality in Excel, they add complexity in how Dynamo extracts the data. The enhancements to this script allow for the other sheet tabs in Excel to be read.

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

15 Comments

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.

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.