Skip to main content
D
dm-31-Visitor
1-Visitor
November 19, 2011
Question

Table in Mathcad

  • November 19, 2011
  • 3 replies
  • 10960 views

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

3 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
November 19, 2011

Hello!

Please attach your Excel file with this table.

D
dm-31-VisitorAuthor
1-Visitor
November 22, 2011

Vladimir,

Please find a part of the table

--

Dhinesh

V
24-Ruby IV
ValeryOchkov24-Ruby IV
24-Ruby IV
November 22, 2011

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

W
wayne12-Amethyst
12-Amethyst
November 19, 2011

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.

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
November 19, 2011

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.

    Terms & ConditionsCookie settingsAccessibility statement