[JSL] Spec limits and reference lines

mosiph

Hi,

 

I have been trying to find a script to import specs from specs datatable and set Show Limits( 1 ) for all columns.

I came across a few posts but still could not figure out how to do it.

 

Please kindly help.

 

Thanks a lot.

txnelson

Here is a simple script that sets spec limits.  It would be a simple matter to place this into a loop that reads from one data table and writes the limits to another, but not knowing the structure of your input table, etc. I am only providing the write component

Names Default To Here( 1 );

dt = Current Data Table();

col="NPN1";
LSL=100;
Target=110;
USL=120;

Eval(
	Eval Expr(
		column(dt,Expr( col )) << set property(
			"spec limits",
			{LSL( Expr( LSL ) ), USL( Expr( USL ) ), Target( Expr( Target ) ), Show Limits( 1 )}
		)
	)
);