I’m not using any Excel or analytical model elements. I’m building this tool because we often have analytical models that are not 100% accurate in terms of member locations and are not “linked” with the Documentation models, but much of the info in the Analytical model needs to get into the Documentation model without also pushing the member location errors into the documentation model.
The assumption that I’m going on at this time is that the Structural Analysis Software (RAM , RISA, etc) has some sort of “Export to Revit” capability. Then I assume that I have two models,the model from the Analysis software that has the correct design info (member sizes, reactions, etc) and the Documentation model that has some incorrect info (member sizes and reactions) but has correct element locations. I link the model generated from Analysis into the Documentation model. Then I go to Dynamo.
In Dynamo, I compare the location of each Element in the Documentation model to the Location of Each element in the Linked Analysis model (for Structural framing and Columns, I take the average of the start and end nodes as the location). Then I take the member from the Linked model that has the “smallest” value (the member closest) and compare that “difference” value to a user specified “tolerance”. If the resulting “closest member” is within the tolerance, then I Get Parameters from the Linked Model and Set Parameters in the Documentation model.
Still a work in progress and it may or may not be useful in the long run, but I’m learning a lot as I do it (I started learning Dynamo at AU last month) and that alone is worth it to me.