Picking Data From Table of Values 1

[m_ridzon]

I'm using Mathcad 8.0. I have the following table of data from a colleague.


I want to build this table of data in Mathcad. Then I want to pick from it for downstream calculations. In other words, downstream, if D/2h is specified as 2.8, I want to pick K1 from the table as 1.27. How do I do that?

An added step would be to linear interpolate between data points on the table. In other words, if D/2h is specified as 2.5, I want to interpolate K1 from the table as 1.13.

 

[SWComposites]

seems like you want to read that data into an array.

 

[m_ridzon]

seems like you want to read that data into an array.

Perhaps that is what I need to do, but I'm kind of new and do not know how to do it. Could you share some tips?

 

[Stress_Eng]

You can enter the data as two column arrays, one acting as the independent variable ‘x’ and the other as the dependent ‘y’. You can then use something like the ‘cspline’ function and use that with the ‘interp’ function. This basically fits a smooth curve through your data points and permits you to interpolate.

 

[fel3]

Please see the attached example that uses the cspline function for interpolation as Stress_Eng suggested. I pulled the relevant pieces out of a worksheet that I made several years ago for designing traffic slabs per ACI 360R. The .zip file includes a Mathcad Prime 9.0 worksheet and a .pdf printout of the worksheet. I included three methods for reproducing the data from ACI 360R. i show them side-by-side, which is why the document is 11"x17" instead of 8.5"x11". The first method (which I use in my worksheet) uses two column vectors. The second method uses a 2xN matrix. The third method uses a Mathcad table.

 

[m_ridzon]

Thanks folks. This helped. The only tweak I made was to use the "linterp" function instead, since I want to keep it linear and simple for now.

 

[EJ_H]

If you're ever interested in an alternative to Mathcad, Blockpad handles this pretty well with native spreadsheet-like tables.

Blockpad - Quick Start - Tables