Units
Units
(OP)
Are there add ins which handle units and unit conversions and can help keep track of Units?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Units
RE: Units
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
Killswitch
RE: Units
To illustrate how Mathcad could handle units see the enclose site.
http://www.andrew.cmu.edu/course/06-202/units.PDF
RE: Units
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
MathCAD has an Excel addin which will perform the unit conversions real-time within your Excel spreadsheet.