nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I use a script to save control chart limits to a new table?

Djbrun

I need help creating a script that will create a new table containing the UCL LCL and Average from a control chart.

The control chart is created by a script using data from an excel file. I need the UCL LCL and Average to go back into the original excel file.

I have found reference to a "Save Limits" option for control charts in JMP but I'm not sure how to use it or if it is even appropriate for me needs.

Accepted answers

tonya_mauldin

Use the in column command to save the limits to the column. Here is an example.

dt = Open("$SAMPLE_DATA/Quality Control/Diameter.jmp");
obj = dt<<Control Chart Builder(
	Variables( "Subgroup"(:DAY), "Y"(:DIAMETER) ),
	Chart(
		Position( 1 ),
		Points( Statistic( "Average" ) ),
		Limits( Sigma( "Range" ) ),
		Connecting Line( 1 )
	),
	Chart(
		Position( 2 ),
		Points( Statistic( "Range" ) ),
		Limits( Sigma( "Range" ) ),
		Connecting Line( 1 )
	)
);

obj << in Column; // *Save Limits in Column*

All comments

txnelson

If you use the Control Chart Builder, the only option available is to Save to Column, which saves the limits to the columns's "Control Limits, column property". A simple script could move these values to a JMP data table.

However, if you use one of the other Control Chart platforms, such as Xbar, etc. They have the option of saving the limits to a table.

So either option will work.

Djbrun

Is there a way to save the control limits to the column using a script? So far I have had to do that manually.

txnelson

The answer is: Of course

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
dt:npn1 << set property( "control limits", 
	({XBar( Avg( 115 ), LCL( 112 ), UCL( 118 ) )}) );

This is a very simple example, but it can be built on. One would need to know the table structure of the limits coming in, and then it would have to be able to match up the input from the limits table to the data table you are populating. If you are looking for a JMP Platform to do this, I am working on an Addin to do this precise thing. It should be available by the end of this week, in the File Exchange.

tonya_mauldin

Use the in column command to save the limits to the column. Here is an example.

dt = Open("$SAMPLE_DATA/Quality Control/Diameter.jmp");
obj = dt<<Control Chart Builder(
	Variables( "Subgroup"(:DAY), "Y"(:DIAMETER) ),
	Chart(
		Position( 1 ),
		Points( Statistic( "Average" ) ),
		Limits( Sigma( "Range" ) ),
		Connecting Line( 1 )
	),
	Chart(
		Position( 2 ),
		Points( Statistic( "Range" ) ),
		Limits( Sigma( "Range" ) ),
		Connecting Line( 1 )
	)
);

obj << in Column; // *Save Limits in Column*

txnelson

I believe that Tonya has the correct answer.....I was approaching the issue from a different angle