Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Pulling data from unusual table

BT_9328149
3-Newcomer

Pulling data from unusual table

I'm looking for a way pull a specific value from a matrix by specifying the Y value through a drop down menu and the X value by interpolating the temperature. See figures.  I can't figure out a way for Mathcad to use a value in one matrix to determine a value in a different matrix. Hopefully one of you have an idea. See the figures for the tables and what I have pulled into Mathcad from Excel.

B31.3 Table.jpg

 

Mathcad Matrices.jpg

 

ACCEPTED SOLUTION

Accepted Solutions

5 REPLIES 5

Hi,

Can you include the worksheet so we don't have to do a lot of typing to reproduce the table.

Cheers

Terry

Of course. I attached it here. Mathcad Prime 9.

Hi,

Like This:-

Capture.JPG

Hi,

Prime is unit aware so it is not necessary to divide by the units.

Capture.JPG

Cheers

Terry

Thank you for the clarification.

Announcements

Top Tags