×
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

Units
2

Units

Units

(OP)
Are there add ins which handle units and unit conversions and can help keep track of Units?

RE: Units

I'm not sure about add-ins, but it seems like you could define a table of variables containing scalar values to convert various units to a particular unit system, MKS for example.  Every unit of length that you wanted to include could be assigned a scalar value equivalent to its length divided by one meter, etc.  Any calculations could then reference the appropriate variables; =5*foot would return 1.524 (foot = 0.305).

RE: Units

Try to search web, or you can write your own, which is simple and fast. It can look somehow like next examples.

Function mm_to_inch(x As Double) As Double
  mm_to_inch = x / 25.4
End Function
In sheet you use formula: =mm_to_inch(10)

or more complex
Function units(x As Double, tp As String)
  tp = UCase(tp)
  Select Case tp
  Case "MM_IN", "MM_INCH"
    units = x / 25.4
  Case "IN_MM", "INCH_MM"
    units = x * 25.4
  Case Else
    units = "ERROR"
  End Select
End Function
In sheet you use formula: =units(10,”mm_in”)

Mirekp
http://www.mitcalc.com
Mechanical calculations

RE: Units

2
Check out the CONVERT function in the help file.

Killswitch

RE: Units

One alternate way is using Mathcad. This program is compatible with Excel allowing import/export from one program to another.

To illustrate how Mathcad could handle units see the enclose site.

http://www.andrew.cmu.edu/course/06-202/units.PDF

RE: Units

(OP)
Yech MathCad

I don't want another program. I want an Add-in that is inside Excell and has unit conversions defined and can track my unit changes to make sure I am not mixing units

RE: Units

Gearhead,

MathCAD has an Excel addin which will perform the unit conversions real-time within your Excel spreadsheet.

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