topic Re: Control Chart: Table report of the batches out of control limits and values in Discussions

Control Chart: Table report of the batches out of control limits and values

Sebastienlg — Fri, 09 Jun 2023 16:56:58 GMT

Hello everyone,

I am currently making a control chart with the following script:

Control Chart(
	Sample Label( :Numero de lot ),
	Sample Size( :Nombre de seringues ),
	KSigma( 7.33914672387493 ),
	Chart Col(
		:"Y1"n,
		P( Avg( 0.0000859059564066319 ), LCL( -1 ), UCL( . ) )
	),
	SendToReport(
		Dispatch(
			{},
			"P of RNS_NS tordu (srg)",
			OutlineBox,
			{Set Title( "p'-chart, p of Y1" )}
		),
		Dispatch(
			{"P of Y1"},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 5 ), Min( -0.000183894230769231 ),
			Max( 0.00256610576923077 ), Inc( 0.00025 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{"P of Y1"},
			"1",
			ScaleBox,
			{Min( 0.5 ), Max( 30.5 ), Inc( 1 ), Minor Ticks( 2 )}
		)
	)
)

And at the end I would like to know if there is a way to report in a table the batches out of the control limits, and their respective values?

I tried to make it with the software but could not find a solution.

Is anyone has a suggestion to help me?

Thanks a lot for your answer,

Sebastien

Re: Control Chart: Table report of the batches out of control limits and values

Mark_Bailey — Thu, 14 Apr 2022 14:06:52 GMT

You are using a legacy platform. You might review the options to see what you might use in your script. In particular, see the Tests. These apply one or more rules to find an out of control signal and identify the subgroups that violate each rule. You can use an alert script to trap these subgroups and respond any way that you like.

See this example to get ideas.

Re: Control Chart: Table report of the batches out of control limits and values

Sebastienlg — Wed, 20 Apr 2022 14:17:03 GMT

Hello Everyone,

I tried to set alarms with the exemples given in my script, but it does not work...

Here is my script:

Graph_expr1=Expr(
		Graph1 = Control Chart(
				Sample Label( :Numéro de lot ),
				Sample Size( :Nombre de seringues ),
				KSigma(TBD),
				Sort by Row Order( 1 ),
			Chart Col( :"Y1"n, P( Test Beyond Limits( 1 ), Limits Precision( 1 ), LCL( -3 ) ) ),
		Alarm Script(
							Write(
								"Out of Control for test ",
								qc_test,
								" in column ",
								qc_col,
								" in sample ",
								qc_sample,
								"\!N"
							)),
		SendToReport(
		Dispatch(
			{},
			"P of Y1",
			OutlineBox,
			{Set Title( "p'-chart, Proportion de défaut" )}
		),
		Dispatch(
			{"P of Y1"},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 5 ), Min( -0.00025 ), Max( 0.0025 ),
			Inc( 0.00025 ), Minor Ticks( 1 )}
		),
		Dispatch(
			{"P of Y1"},
			"1",
			ScaleBox,
			{Min( 0.5 ), Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{"P of Y1"},
			"",
			AxisBox,
			{Add Axis Label( "Taux de défauts (srg)" )}
		))));
	SubstituteInto(Graph_expr1, Expr(TBD), z_KSigmaZ);
	Graph_expr1<< Test 1(1));

I think it comes from the Graph_expr1=Expr( ...

Any idea to help me?

It works on exemples you gave me, However, how can we get the batch number or run number in a table and not only in the log window?

Thank you in advance,

Sebastien