Coordinate Scheduling with the Excitech Toolkit

The original Excitech Revit toolkit was created in 2009 to produce coordinate schedules of elements such as isolated foundations, structural columns and any family with a single insertion point. The toolkit provided a solution to those customers who needed to produce piling schedules. An extension to the toolkit was added in 2012 to allow the automatic renumbering of elements, again aimed at piling.

Old Excitech Toolkit - Coordinate Scheduling

The new Excitech Toolkit was introduced in 2018 and contains a greater number of tools and utilities to improve productivity in a number of different areas. The new toolkit also provides the option of scheduling coordinates from elements.

New Excitech Toolkit

Please see the video for a tutorial on how our toolkit is used to schedule coordinates.


Here you can see the tutorial for the new Revit Excitech Toolkit.

Below is the procedure to create a piling schedule and renumber the piles using our new toolkit.

  1. First you select the piles that are required to have coordinates. If you have used a foundation family that has piles nested into the pile cap then you will need to select the sub elements.

On the Excitech Toolkit ribbon in the Selection panel click the Filter command as shown below.

Excitech Toolkit Selection Tools

In the Filter dialog box select Structural Foundations and then the pile sub elements that you have used in your project.

Click OK to make the selection.

Excitech Toolkit Filter

2. On the Excitech Toolkit ribbon in the Analysis panel, click the Analyse drop down menu and select Insertion as shown below.

Excitech Toolkit Insertion Point

You will then see the Insertion Point to Parameter dialog box. Here you can select the internal origin of Revit, the Project Base Point or the Survey Point. For piling that has been set out using shared coordinates, click Survey Point.

Excitech Toolkit Insertion Point to Parameter

Click OK

3. Each pile will now have the following coordinates added. X coordinate, Y coordinate and Z coordinate. These coordinates are at the toe of the pile. X Top Coordinate, Y Top Coordinate and Z Top Coordinate are positioned at the top of the pile (this would also be the cut off level)

Excitech Toolkiit Coordinates


Revit – Setting out and scheduling coordinates from grids with Dynamo

I have had a few questions around detailing coordinates of grid intersections with Revit. You may already know that it is tricky to add spot coordinates to each grid intersection as Revit will not ‘snap’ to the grid intersection. You can add reference planes across the grid intersections, but this is quite time consuming and prone to error.

Revit - Grid Setting Out and Detailing

I have created a Dynamo script to place down a setting out family at each grid intersection and record the grid intersection, Easting and Northing at each location. This has the added value of being exposed in Navisworks or an IFC model for a contractor. We can also schedule the coordinates of each grid intersection and present this onto drawings or export to Microsoft Excel for input into site instruments.

Grid Setting Out Points - Dynamo


Thanks to Christoph for providing a Python script to replace the convert to number node. Below is the updated graph.

Dynamo Update

and here is christoph’s python script.

#@Christoph Raidl(2019)
Grids = IN[0]
IsString = []
for Grid in Grids:
OUT = IsString



See the video below for more!



Revit Tutorial – Displaying Span to Depth Ratio of Steel Beams

In this tutorial we shall look at a method of calculating and displaying the Span to Depth ratio for steel primary and secondary beams. In early scheme design of a steel structure many engineers like to use the span to depth ratio to size members assuming a uniform loading across the beam.

Revit Span to Depth Ratio on Steel Beams

Revit can be used to calculate and display the Span to Depth Ratio by creating a shared parameter and making a simple formula. Typically, a span to depth ratio of 13-15 is used for primary beams and 18-20 for secondary beams. In the following tutorial I will edit a UB family, add a shared parameter and then use the value of this and the structural usage to activate certain colours with filters. The image below shows the filters colouring, green is OK, red is over the limit and yellow is under the limit. To follow this tutorial, you will need Revit 2016 or later.

The first step is to create a shared parameter, this needs to be shared as this may need to appear in a schedule or be taggable. On the Manage Ribbon click the Shared Parameters command as shown below.Shared Parameter Command

If you already have a Shared Parameter file, then click the New Parameter command as shown below. If everything is inactive, then you will need to create a new parameter file by clicking the Create button.Shared Parameter Dialog Box

You will then be presented with the Parameter Properties Dialog. I am naming the new parameter SDR (Span to Depth Ratio) but you can use something else if you prefer. You will need to ensure that the new parameter is created as a Number. Click OK to both dialog boxes. Your new Shared Parameter is now ready for use.Shared Parameter Properties Dialog Box

Next you edit a Universal Beam family (or other section type for non-UK members). In the Project Browser, open the families folder and browse to Structural Framing. Below I am adding the parameter to UB-Universal Beams, but you can add this to any Section you require.

Families Folder in the Project Browser

Right Click over the family and select edit. You are now in the Family Editor. On the Home Ribbon click the Family Types command as shown below

Revit Family Types Command

In the Family Types Dialog box click the New Parameter command as shown below.

New Parameter Command

In the Parameter Properties Dialog click the Shared Parameter radio button and then select the Select button as shown below.

Create Parameter from Shared Parameter File

Select your new SDR parameter and click OK. You now need to set the new parameter to Instance and group the parameter under Structural Analysis. Click OK. You should now see your new parameter in the Structural Analysis group.

Set SDR parameter to Instance and Structural Analysis

Create the following formula. round(Length/Height)

Parameter Formula

This will take the length of the beam and divide this by the section height. Note that the section height appears under the Structural Section Geometry group. We then round this number to get a ratio value.  Save your new family and repeat for other families where you want to calculate the span to depth ratio.

Next you create a project parameter for your Span to Depth Ratio. This will enable you to create a filter. On the Manage ribbon click the Project Parameter button as shown below.

Project Parameter Command

In the Project Parameter dialog, click the Add command. You will then see the Parameter Properties dialog as shown below. Configure the dialog by selecting Shared Parameter, select your SDR parameter and then click OK. Make sure that Instance is checked, group the parameter under Structural Analysis and check the category, Structural Framing. Click OK.

Revit Parameter Properties Dialog

You now complete the last step to create a series of filters to colour the beams by their span to depth ratio. In this example you create a filter for secondary framing. You need to ensure that you have secondary framing in your project for testing. In a Project with the edited families that you have created in the steps above, open the Visibility/Graphics Override dialog and select the Filters Tab as shown below.

Visibility Graphics Override Dialog

In the Filters tab click the Edit/New Button at the bottom of the dialog box. In the Filters Dialog box select the New command in the bottom left as shown in the image below.

Revit Filters Dialog

In the Filter Name dialog box type Secondary Framing – Span/Depth OK.

Filter Name Dialog

You can now set the Category, Structural Framing and then set the AND rules to the following. ADR is greater that or equal to 18 AND SDR is less than or equal to 20 AND Structural Usage equal Purlin. Note that the Structural Usage may have differing terminology depending on the regional settings and template applied. Click OK.

Filters - Adding And and Or filters

You now select the Add command to add your new filter into the Visibility/Graphic Overrides Dialog.

You can then add green to override the linework and for extra impact add a solid green shade to the members. Anything that displays green is now in the correct span to depth range.

Filters applied to VisibilityGraphic Override Dialog

Once the filter has been set your secondary framing will appear green when the correct span to depth ratio is achieved. Note that you can create additional filters to show members that exceed and are too deep. You can also colour the SDR values in a structural framing schedule.

Hope you find this useful? I will try and create a tutorial video when I have some time.


Revit Tutorial – Type vs Instance Parameters

Been a little while since I posted a tutorial but this month I am going ‘back to basics’ to talk about Instance and Type Parameters and where to use them. I still find that many people are using OOTB families that are not suitable for certain modelling workflows. I will focus in on two specific families, Structural Openings and Structural Framing. The structural Openings will be created with a Generic model family that’s face based, this will be ideal for rectangular openings in walls, foundations, floors, beams etc. Let’s start by looking at the instance properties of Structural Framing. In the image below I have selected the UB section, notice that the Structural Material is instance based.

Revit 2020 - Structural Framing Instance Parameters

It may be more relevant if we made this a type parameter as the structural material needs only to be set once per family type. To do this you can simply edit the family and change the instance parameter to a type parameter. With the Structural Framing Element selected, click the Edit Family button on the Modify | Structural Framing context ribbon.

Revit Edit Structural Framing Family

The Structural Framing element will now be open in the family editor. Select the Family Type button as shown in the image below.

Revit Family Types

You will now see the Family Types Dialog box displayed. Note that the Structural Material is shown. An instance parameter will always have the bracketed word (default) displayed. This is the easiest method to spot the instance parameters.

Revit - Structural Framing Material Edit

Select the Structural Material parameter and then select the Edit Parameter command by selecting the pencil icon in the lower left of the dialog box as shown below.

Revit Family Types Dialog Box

You will now see the Parameter Properties Dialog box as shown below. Select the Type Parameter radio button as shown below and then click OK.

Revit Parameter Properties Dialog

Click OK to the Family Types Dialog box, note that the Structural Material Parameter has the (default) removed as this is now a type parameter.

You can then save the family and set the type parameter. This will then update all members of the same family type.

A full video tutorial is available here, the video also covers the creation and use of structural opening family.

Advance Steel 2019 and Dynamo 2.0.2

A couple of releases back a set of Dynamo nodes were created to allow the connection between Dynamo and Advance Steel. A recent release sees this plug in upgraded for use with Dynamo 2.0.2.

Advance Steel and Dynamo 2.0.1

The tools certainly look promising but could really do with a little more development. At present you can create members, add plates and custom properties which allows for the advanced modelling of members but limited control over connections and Advance Steel Properties.

The Dynamo for Advance Steel can be located on the Add-ins Ribbon as shown below.

Dynamo for Advance Steel Add In

Once Dynamo is running you will find the Advance Steel nodes shown below.

Advance Steel Dynamo Nodes

Steel members are created by providing a list of members start and end points and then a vector to describe the Section Orientation. Bear in mind that all Advance Steel members can be generated with the Beam tools. It would have been nice to be able to change the Model Role for each set of members as this would have increased the efficiency when creating larger frames with beams, braces, columns etc.

Advance Steel Model Role

Most of the Dynamo Nodes are easy to understand but the defining the section to use can be a little tricky. The first stage is to locate the Advance Steel Profiles database. The quickest method is to launch the Advance Steel Management Tools and then open the installed databases. Filter this for the Profile Master Tables.

Advance Steel Management Tools - Profile Master Table

You will need to copy the TypeNameText of the section type that you require and Paste this into a Dynamo Code block or a String. Search the relevant table and then locate the SectionName required.

Advance Steel Management Tools - Profiles

The TypeNameText and SectionName are then concatenated with a special code #@§@# which is used to separate the two strings. Your Code Block will look like the image shown below.

Dynamo Advance Steel Section Name

I tested the Advance Steel Dynamo nodes by creating the following space truss using the LunchBox tools.

Dynamo Roof

The few nodes provided definitely show promise and with a little more development could really be useful. Of course, another option is to create the frame using Dynamo and Autodesk Revit and then export this into Advance Steel.


Revit 2019 Tutorial – Analytical Model Visualisation

Quite often when structural engineers are viewing the analytical model within Autodesk Revit it can be a little difficult to see which members are fixed or pinned or have specific release conditions set. The standard way to achieve this is to select the analytical bar and then look in the Properties Palette for the information.

The image shown below is a typical representation of the analytical model with the loads and end colours shown.

revit analytical model

Here you can see the same model  with some filters applied to help visualise fixed and pinned conditions.

revit analytical model with filters applied

The filters are set within the Visibility/Graphic Overrides dialog box. In the example below, I have chosen to indicate a Fixed or Pinned condition by using the colours red and green. Note that I have also had to create a separate filter for columns.

visibility graphic overrides dialog box

In the image below, you can see the new OR functionality being used to set a filter that either has the start or end release set to Pinned.

revit 2019 filters using or statement

I would suggest that you create a separate view within your current structural template to enable the engineers to easily check the release conditions on the analytical model, this is much easier that selecting each element and viewing the Properties.

Hope this Helps,