cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

Mathcad 15 Select data in a row from a table

LC_12355277
10-Marble

Mathcad 15 Select data in a row from a table

Hi All,

I am new to Mathcad. I have a table where the first column is the material name and the second to fouth columns are material properties. I would like to add the table to a worksheet. When I select one of the materials, the three properties of the material will then be used in subsequent calculations. This can be done easily in Mathcad Prime 9 or 10 using Combo Box, but Mathcad 15 does not have this feature. Could someone give some guidance as to how to archieve this in Mathcad 15? Thanks in advance.

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(To:LC_12355277)


@LC_12355277 wrote:

Thanks Werner_E. I understand I could use "Web Control" in Mathcad 15, as shown in your snapshot, but it would only allow me to select data from one column. I need data from three columns. I will take a look at your attachment. Thank you so much. 


What I did was to use the choice made from the list box to choose the appropriate values from the Mathcad matrix.
So its not the control which returns the needed values but a Mathcad assignment below (or to the right of)  the control (which I had hidden in a collapsed area)

 

View solution in original post

7 REPLIES 7
Werner_E
25-Diamond I
(To:LC_12355277)


@LC_12355277 wrote:

Hi All,

I am new to Mathcad. I have a table where the first column is the material name and the second to fouth columns are material properties. I would like to add the table to a worksheet. When I select one of the materials, the three properties of the material will then be used in subsequent calculations. This can be done easily in Mathcad Prime 9 or 10 using Combo Box, but Mathcad 15 does not have this feature. Could someone give some guidance as to how to archieve this in Mathcad 15? Thanks in advance.


Why do you think that Mathcad 15 would not have scripted components?

Werner_E_0-1731560845329.png

For some extended usage and useful scripts you may have a look at Richards collection: Extra Components and Controls - PTC Community

Find attached a little demo file using one of the components of this collection to achieve what I guess you are looking for.

 

For further help you would have to provide your worksheet with the Mathcad matrix containing the materials and properties.

 

Thanks Werner_E. I understand I could use "Web Control" in Mathcad 15, as shown in your snapshot, but it would only allow me to select data from one column. I need data from three columns. I will take a look at your attachment. Thank you so much. 

Werner_E
25-Diamond I
(To:LC_12355277)


@LC_12355277 wrote:

Thanks Werner_E. I understand I could use "Web Control" in Mathcad 15, as shown in your snapshot, but it would only allow me to select data from one column. I need data from three columns. I will take a look at your attachment. Thank you so much. 


What I did was to use the choice made from the list box to choose the appropriate values from the Mathcad matrix.
So its not the control which returns the needed values but a Mathcad assignment below (or to the right of)  the control (which I had hidden in a collapsed area)

 

Thanks. Your attachment is very helpful and I will follow the approach. Your help is much appreciated.

StuartBruff
23-Emerald III
(To:LC_12355277)

I suppose the underlying question is, as a newcomer to Mathcad, why are you using Mathcad 15 and not Mathcad Prime 10 (especially if you're looking for an M15 workaround for something you know MP10 can do)?

 

Stuart

The reason I use M15 is that I am working to update some calculations in a file which uses M15.

StuartBruff
23-Emerald III
(To:LC_12355277)

OK.  A common reason.

Announcements

Top Tags