Skip to main content
1-Visitor
April 22, 2020
Solved

Need help with writing a program

  • April 22, 2020
  • 7 replies
  • 3935 views

Hi,

       I need help with a certain problem. So I have done calibration on a set of instruments. The serial numbers as well as the calibration factors associated with them are given in the first 2 columns of the excel sheet. Now I am running all the instruments (I don't have cal factors for some) and I am getting a certain calibrator count as shown in columns F and G.

 

Now the issue is I need to compare the serial numbers of all the instruments with the subset to see which ones have cal factors associated with them. For instruments with cal factors, I need to multiply the cal factor (associated with that serial number) with the count for that particular instrument and output the result. So I need to write a mathcad program to output only the serial numbers of instruments with cal factors as well as the product of cal factor and count. I am attaching the excel sheet. I am using Mathcad Prime 6. Thanks for the help.

Best answer by terryhendicott

Hi

Enclosed is the coding and the result.

Capture.JPG

 

Capture2.JPG

 

Cheers

Terry

 

7 replies

21-Topaz II
April 23, 2020

Hi

Enclosed is the coding and the result.

Capture.JPG

 

Capture2.JPG

 

Cheers

Terry

 

arnair811-VisitorAuthor
1-Visitor
April 23, 2020

Thanks a lot!!!