Sheets from Excel

When developing a project document list, the most convenient way is to create the 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.

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 which then get sorted and any redundant spreadsheet data removed before the sheets are created. There are 2 possibilities for sheet creation within Dynamo:

  • ‘Sheet.ByNameNumberTitleBlockAndView’ – This is a standard Dynamo node that requires, Sheet Names, Sheet Numbers, Title block Family Type, and View inputs. If the project is in very early stages the views for the sheets are generally not created, so they cannot be used as an input without generating an error.
  • ‘Tool.CreateEmptySheet’ – This is a node from the SteamNodes package that 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 already created for it to work, as it will create empty sheets.

 

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 allows us to group and easily 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 allows for the additional sheet tabs in excel to be read.

4 Comments on “Sheets from Excel

  1. Hi Paul,

    Thanks for posting this. I have been performing this exercise for a little while now, but with ‘Sheet.ByNameNumberTitleBlockAndView’. I wasn’t aware of ‘Tool.CreateEmptySheet’; it’s much better.

    How would you go about placing corresponding views on the created sheets? Tool.PlaceViewsOnSheets?
    (Perhaps the topic of another post?)

    Thanks,
    Michael.

    Like

    • Hi Michael. Yes I haven’t looked at it (yet) but definitely a topic for another post. But if you search the DynamoBIM forum you’ll find loads on this. It is probably the most viewed topic on the forum so it should be hard to find the answer you are after.

      Like

  2. Thanks Paul! I didn’t know about the “Tool.CreateEmptySheet” node either. Good looking out!
    Have you seen the same script with the ability to create sheets per discipline, for an MEP project?
    I just starting playing around with this option but haven’t got it to work for me just yet. Thanks!

    Like

    • Hi Fred. What do you mean by per discipline? How are the disciplines differentiated – through a sheet number prefix?

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: