Formula Calculation QM

[sofiacrome]

Hello.

This is my first time here. I hope you can help me with this please.

For a specific material, plant, group counter and operation, I have several inspection characteristics and two of them are "SPREAD". The requirement is the following:
Inspect 3 characteristics with single results above spread, analyst maximum and minimum values and do a subtraction.
Ex.

0010 = 100

0020 = 120

0030 = 80

0040 = SPREAD

Maximum = 120, Minimum = 80 -> Then calculate = 120 - 80 = 40

The main problem is that these 3 characteristics before each spread are not always at the same place/position but they are always above the "spread". Besides, the maximum and minimum could be at first, second or third position (this numbers are written manually for users in the process).

I was looking for formula parameters and I guess I maybe could use "C9", "CA" or "D0"...

Regards.

March 14 Moderator note: Formula edited to correct it, at user's request.

[former_member42743 · Accepted solution]

Actually I kind of miss read the requirement. i thought your people were actually recording the MAX, MIN and maybe an Average. But after reading Sara's response, it appears you could be recording three different values.

Another option is to use a custom Z0 formula parameter. The formula would simply be Z07010 for instance. 7010 is the first characteristic. Z0 is the custom formula parameter that calls a FM. The FM then examines the inspection lot and uses some logic, (mic number, characteristic position, etc.. ) to identify the MICS to consider. The FM than examines the values and returns the spread.

Craig

[sofiacrome · Accepted solution]

Thank you so much, Craig!
We're going to do it like you and Stylianos recommend it.

Then, we'll post if it works and what we do.

[former_member349889 · Accepted solution]

Hello.

Can you say me where is made the new formula? Where I register new formula whith the function module?

Thanks.

Angela.

[former_member463553]

I would recommend you to follow a custom approach as suggested by Craig using a Z* parameter and a Z* function module using " QEFC_FORMULA_CALC_EXAMPLE" as your reference.

The only addition i would make is that maybe you should consider to base the calculations on the Characteristics Name and not on the Characteristic ID *0010 ...... as i personally feel that re-arranging the characteristics to existing inspection plans is slightly painfull if you have many entries .

S.

[sofiacrome]

Thank you!
We're going to do it like Craig and you said.
Then, we'll post if it works and what we do.

[former_member42743]

Unfortunately you'll need to update your plans and make the characteristics uniform.

I would pick a unique standard that would be currently well outside your current list of characteristics in your plans.

I.e. edit the plans and use characteristic number like 7010, 7011, 7012, 7013. Then 7013 is your calculated MIC and the others are standardized.

An option would be to add a reference operation. I.e. create the reference operation with just the above four MIC's. Then add the reference operation to your plants.

Use the CWBQM workbench to help delete the old characteristics.

Craig

[former_member349889]

Hello,

Where can I do a new formula? In which transaction? I need create a new function, but I don't know where to do the registrer of the formula with the function module.

Can you help me?

Thanks

[Sara_Br]

If 0010, 0020, and 0030 are actually the same test, then you could use a sampling procedure requiring multiple results. Then you would have characteristic 0010 with three results.

0010:

100

120

80

Then in your formula you can use CA, C9:

Spread = CA0010 - C90010

[sofiacrome]

Thank you, Sara!