How do you get link excel spreadsheets to be unitless? 1

kenallmighty · Mar 23, 2004

I am trying to get a stud spacing (unitless) for inventor. My spreadsheet has the calculations for figureing the spacing based by loading. I am setting up an assembly model to be completely ran by a spreadsheet. All of the values being read by inventor have a inch unit and i want the stud spacing to be unitless. Any suggestions?

Absolute zero has nothing on me!!

SeanDotson · Mar 25, 2004

Are you specifying the units in the Excel sheet. The columns should be (from left to right)

Parameter Name, Value, Unit

If you leave the unit column blank it will default to length (in your case Inches).

Use "ul" (no quotes0 to make it unitless.

See my website for a tutorial on the subject.

Sean Dotson, PE
Inventor Tutorials & More

http://www.sdotson.com

Your Webbased mCAD Discussion

http://www.mcadforums.com

kenallmighty · Mar 29, 2004

your tutorials on your website helped greatly, thank you!

Absolute zero has nothing on me!!

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

How do you get link excel spreadsheets to be unitless? 1

kenallmighty

Structural

Recommended for you

SeanDotson

Mechanical

kenallmighty

Structural

Similar threads

Part and Inventory Search

Sponsor