Table in Mathcad

[dm-3]

Hi,

How to create and automate tables?

For example I have capacity value calculated against various dia of pipes and flowrates.

If I key in dia and floe rate I want Mathcad to automatically select the proper capacity value.

Is it possible to do this in Mathcad?

--

Dhinesh

[VladimirN]

Hello!

Please attach your Excel file with this table.

[dm-3]

Vladimir,

Please find a part of the table

--

Dhinesh

[ValeryOchkov]

Dhinesh wrote:

Vladimir,

Please find a part of the table

--

Dhinesh

See the same task where your table is a matrix M:

http://twt.mpei.ac.ru/ochkov/Mathcad_12/4_03_3D_Spline.png

But You want/must/can create a function FlowRate(Capacity, PipeSise)?

PS I aslo think thet this function may be useful for You - http://twt.mpei.ac.ru/MCS/Worksheets/Hydro/La-De-Re.xmcd

and this http://twtmas.mpei.ac.ru/mas/Worksheets/Interp_f_x_y.mcd

[wayne]

You can interpolate in the table, but why don't you just calculate the values? Sometimes tabel values are based on testing and you need to interpolate, but thats not the case with this table.

[Fred_Kohlhepp]

Dhinesh wrote:

Hi,

How to create and automate tables?

For example I have capacity value calculated against various dia of pipes and flowrates.

If I key in dia and floe rate I want Mathcad to automatically select the proper capacity value.

Is it possible to do this in Mathcad?

--

Dhinesh

The function "Match" can do what you want.