Generating models using spreadsheet data

[bginvestor]

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

 

[GregLocock]

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?



Cheers

Greg Locock

SIGlease see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[bginvestor]

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

 

[bginvestor]

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?

 

[GregLocock]

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.



Cheers

Greg Locock

SIGlease see FAQ731-376 for tips on how to make the best use of Eng-Tips.