Generating models using spreadsheet data
Generating models using spreadsheet data
(OP)
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
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
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
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
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
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
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.