Excel to MathCAD
Excel to MathCAD
(OP)
Hello all!
I understand how to obtain a specific value from an excel sheet but when I have multiple rows of information (section properties for multiple sections, for example.) How can my excel sheet know which row to obtain the information for Area, Section Modulus, etc.
For example, if I choose W24X50 from my list box, which is i = 5, how can I have my excel component take this number and use it for the appropriate row for the outputs? Thanks everyone. I would be a very happy man if I can figure this one out.
Clansman
I understand how to obtain a specific value from an excel sheet but when I have multiple rows of information (section properties for multiple sections, for example.) How can my excel sheet know which row to obtain the information for Area, Section Modulus, etc.
For example, if I choose W24X50 from my list box, which is i = 5, how can I have my excel component take this number and use it for the appropriate row for the outputs? Thanks everyone. I would be a very happy man if I can figure this one out.
Clansman





RE: Excel to MathCAD
Presumably, you are extracting an array from your Excel component, and you'd have the same index used to reference the specific element of your array.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies