Contact US

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!

*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

Generating models using spreadsheet data

Generating models using spreadsheet data

Generating models using spreadsheet data

Looking for ways to automate the generation of parts, markers, vforces, etc.. using spreadsheet data.

I want to use x, y, z coordinates from spreadsheets to generate the links (parts), markers, revolute joints, and vforce definitions

Any examples or strategies would be greatly appreciated.  Thanks


RE: Generating models using spreadsheet data

Easily done.

I write model generators in qbasic, but there is no inherent problem in using vba for the same purposes.

I'm assuming you are writing .adm files?



Greg Locock

SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

RE: Generating models using spreadsheet data

Hi Greg,

Thanks for the quick reply.

I am using ADAMS/View.  

Not sure if dataset .adm files are the way to go..

BACKGROUND:  I am designing a complicated pulley system with cable sets. The cable will be a series of links (parts) connected w/ constraints.  To get good curvature , there needs to be many, many, links.  I also want to automate the marker and vforce definitions.

I guess I could use a programming language to provide me the format necessary for the .cmd, but I was hoping for a simplier approach.

I'll look into the dataset format..  Appreciate any other suggestions!

Take Care

RE: Generating models using spreadsheet data

Hi Greg,

I looked into the dataset format and I believe this is going to work well!

However, I noticed that polylines do not get converted?  Is it because the definitions are stored in a table?  I would really like to be able to define a graphic that represetns a "link" that can be programmed into .adm format.  Funny thing is that "arcs" work fine in .adm, but not polylines.

Any suggestions?   

RE: Generating models using spreadsheet data

I don't use polylines, so sorry, don't have any ideas there. You could contact MSC I suppose, they are usually helpful. Or have a look on the user forums.



Greg Locock

SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.

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! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close