×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel spreadsheet calcs

Excel spreadsheet calcs

Excel spreadsheet calcs

(OP)
As structural engineers, we often use spreadsheet software to generate structural calculations based on appropriate codes. The power of this kind of software (Excel for example) lies in its flexibility. With some knowledge of the codes and applicable modifications, any designer can develop software to come up with design loading and capacity for different kinds of structural elements. It frees the structural designer from the need to buy some proprietary software to do basic calculations (although sometimes I understand this is impossible, manufacturers lock their data in so tight it could potentially be impossible to crack the code, a severe flaw in the industry in my opinion)

Now, much of the inputs required to run these spreadsheet calcs is geometric data. True, there are material properties, installation conditions, and different bits and pieces here and there, but by and large, the input data is geometric. If it's a beam, you need to know the span, the boundary conditions, their locations etc. If you're doing ASCE 7 wind load calculations you need the mean roof height, effective areas, and the list goes on.

Unfortunately, it seems like data interoperability between spreadsheet software (such as excel) and software containing geometric information (such as AutoCAD, Revit or Bluebeam) is either nonexistent or highly convoluted, such that, if possible, would require a huge learning curve to set up (I've seen some stuff about Dynamo for Revit, Rhino, Autolisp, but none of these show real promise, seeming to be more trouble than they are worth).

Ideally, I am seeking a simple software program or programmatic method, to query geometric software for geometric data and input this data directly into excel (thus bypassing the manual switching between programs to measure the length or width of a beam... etc). Please note I am not opposed to programming, but need something sufficiently simple that it would not require years to accomplish.

Thanks for your help

RE: Excel spreadsheet calcs

Visual Basic for Applications is the shortest answer. It is compatible with AutoCAD among many other programs. But as you mentioned there are internal locks on data for many programs that are even compatible.

Sounds like you want a lot for little effort. Good luck with that.

"It is imperative Cunth doesn't get his hands on those codes."

RE: Excel spreadsheet calcs

I agree that VBA is the obvious interface between Excel and other packages, being built in, well documented, and reasonably easy to use.

Some years ago I did some work on linking AutoCAD format drawings to Excel (using Intellicad), but it does take a fair bit of learning.

These days if I want to get geometric data from a CAD file I will get it in DXF format and import it into Strand7, where I can use the API (via VBA) to extract the coordinate data, or just copy and paste is sometimes quicker. I presume most other frame analysis and/or FEA programs would offer similar facilities.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources