Skip to Content
0
Former Member
Feb 23, 2011 at 11:41 AM

Formula for upper and lower limit based on target value

1130 Views

Dear All

I have to create inspection plan for 25000 material codes. Each material code will have same MIC's assigned but with different target values. Lower limit and upper limit will be +5% and -5% depending on target value. My target values can be changed every 6 months.

Is there any formula for upper limit and lower limit so that it changes automatically with the change of target value. Plz provide the specific / easy way for revising the inspection plans. At present i am deleting all and then creating them again But it takes more than 10 days for completing. Plz provide any shortcut method.

Thanks in advance