Units 2

[Gearhead]

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

 

[ivymike]

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).

 

[mirekp]

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

 

[killswitch]

Check out the CONVERT function in the help file.

Killswitch

 

[cuky2000]

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

 

[Gearhead]

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

 

[seymours2571]

Gearhead,

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