Automatically selection Table value

[smilani]

Dear all,

I would to create a calculation sheet in Mathcad 15 where when I select an option the reference value are automatically selected.

For example:

In the previous table I would select the value determined by weld condition (full penetration) and quality level 2.

I would to create  a windows that, when I select this two condition, the referring value is automatically selected.

Best regards

Stefano

[LucMeekes]

What do you define as the 'reference value' or the 'referring value'?

If in table 5.12 select 'Full penetration' and a quality level of 2, I still have to choose a surface condition between 'Machined' or 'Welded' to arrive at a single Fatigue strength reduction factor.

Luc

[smilani]

Hi Luc,

I would create an automatically option into Mathcad to select the reference value. I mean the output value obtained by the input selection.

For the example in table 5.11 if I set Weld condition (full penetration) and surface condition (machined) and quality level  1 that are the input data, I would to automatically obtain the ouput (reference) value equal to 1.

Stefano

[LucMeekes]

But then, you might be looking for something like this:

Success!
Luc

[smilani]

Is possible to obtain a similar results with control command ?

Stefano

[MJG]

I was just working on such a solution for you:

With this in a hidden or non-printed region:

File attached.

[smilani]

Is that I request

Thanks.

How can create it? do you have any indication for me?

Regards

Stefano

[Fred_Kohlhepp]

Mark attached a file that you can download.

It's in version 15, I don't think Prime has controls yet.

[DJF]

This is how I did it in Prime.  I assume something similar works in 15.  Note the use of strings.