help to define this logic in Mathcad R15, while using data from excel

[ptc-2696759]

Hi,

I am using a data set in MS excel. From the given inputs -known (Nominal Ratio -NR & Power-P) I need to select the output (unit Size). The logic used is as follows:

For the given value of NR select the lower value, from table. For eg if given NR is 6.1, then select 5.6
For the given value of P select the higher value, from table. For eg if given P is 83.0, then select 124.0
Hence result is 160 Unit Size.

Please also refer attached image.

Can anyone help to define this logic in Mathcad R15? and also make use of the data from Excel

Thanks

Deepak

[MikeArmstrong · Accepted solution]

Have a look at the attached.

I assume you are using an embedded Excel component.

Mike

[MikeArmstrong]

Error found in first sheet. I have also included a much simpler version in the attached. (Remover the loops)

Mike

[AlanStevens]

Mike, your method still doesn't result in 160 for NR = 6.1 and P = 83.0. Try the attached.

Alan

[MikeArmstrong]

Not quite Alan,

Your function returns 160 and 225 for the corresponding HR and P values. But unless I'm mistaken they should be 140 and 200 respectively.

See the attached - final version.

This was a little trickier than first thought.

Mike

[AlanStevens]

Mike,

According to the original post:

"For the given value of NR select the lower value, from table. For eg if given NR is 6.1, then select 5.6
For the given value of P select the higher value, from table. For eg if given P is 83.0, then select 124.0
Hence result is 160 Unit Size."

A remaining restriction on my approach is that it assumes the values of P in any row are either monotonically increasing or monotonically decreasing.

Alan

[MikeArmstrong]

That'll teach me to read things properly.

Mike