Skip to main content
L
LC_1235527710-Marble
10-Marble
November 14, 2024
Solved

Mathcad 15 Select data in a row from a table

  • November 14, 2024
  • 2 replies
  • 1728 views

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.

Best answer by Werner_E
@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)

 

2 replies

W
Werner_E25-Diamond I
25-Diamond I
November 14, 2024
@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.

 

    L
    LC_1235527710-MarbleAuthor
    10-Marble
    November 14, 2024

    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. 

    W
    Werner_E25-Diamond IAnswer
    25-Diamond I
    November 14, 2024
    @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)

     

      S
      StuartBruff23-Emerald V
      23-Emerald V
      November 14, 2024

      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

        L
        LC_1235527710-MarbleAuthor
        10-Marble
        November 14, 2024

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

        S
        StuartBruff23-Emerald V
        23-Emerald V
        November 14, 2024

        OK.  A common reason.

          Terms & ConditionsAccessibility statement