Skip to main content
1-Visitor
March 4, 2011
Solved

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

  • March 4, 2011
  • 6 replies
  • 3863 views

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

excelsheet.JPG

Best answer by MikeArmstrong

Have a look at the attached.

I assume you are using an embedded Excel component.

Mike

6 replies

1-Visitor
March 4, 2011

Have a look at the attached.

I assume you are using an embedded Excel component.

Mike

1-Visitor
March 4, 2011

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

Mike

19-Tanzanite
March 4, 2011

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

Alan