topic Re: Process Capability in Discussions

Process Capability

vladbondarenko0 — Fri, 07 Oct 2016 18:11:28 GMT

Hello,

Trying to add a list of the variables (“Process Variables”) in Process Capability plot.

It works for single item from the list, but it does not work for whole list.

lTest = Data Table("dtGoal") << get column names( numeric);

Data Table("dtGoal") << Process Capability(

Process Variables( eval(lTest[i]) ), // it works for any i

// Process Variables( eval(lTest) ), // does not work

_ _ _ _ _

};

Thanks

Re: Process Capability

Craige_Hales — Fri, 07 Oct 2016 20:21:41 GMT

I hope someone chimes in with a better way. This should work... "FIXME()" is an arbitrary placeholder that the substitute() function can find and replace with the proper expression.

dt = Open( "$sample_data/big class.jmp" );

ltest = dt << getcolumnnames( numeric );

Substitute Into( ltest, Expr( List() ), Expr( Process Variables ) );

show(nameexpr(ltest)); // Process Variables(age, height, weight);

e = Substitute(

Expr(

Process Capability(

FIXME(), // replace this...

Spec Limits(

height( LSL( 0 ), Target( 50 ), USL( 99 ) ),

weight( LSL( 0 ), Target( 100 ), USL( 200 ) ),

age( LSL( 0 ), Target( 50 ), USL( 100 ) )

Goal Plot( 1 ),

Capability Index Plot( 1 )

)

Expr( FIXME() ), Name Expr( ltest ) // ...with ltest

);

show(nameexpr(e)); // Process Capability(Process Variables(age, height, weight), ...

eval(e); // open the platform

Re: Process Capability

vladbondarenko0 — Sat, 08 Oct 2016 01:01:30 GMT

Thanks. It works, but I cannot import spec limits from the saved Spec Limits Table.

Names Default To Here( 1 );

dt = Open( "$sample_data/big class.jmp" );

dtSpecLimits = New Table( "MySpecLimits",

Add Rows( 3 ),

New Column( "Parameter", Character, Nominal, Set Values( {"height", "weight", "age"} )),

New Column( "LSL", Continuous, Set Values ( [0, 0, 0] ) ),

New Column( "Target", Continuous, Set Values( [50, 100, 50] ) ),

New Column( "USL", Continuous, Set Values ( [99, 200, 100] ) )

);

dtSpecLimits << Save("C:\Users\user\Documents\MySpecLimits.jmp");

ltest = dt << getcolumnnames( numeric );

Substitute Into( ltest, Expr( List() ), Expr( Process Variables ) );

e = Substitute(

Expr(

Process Capability(

FIXME(), // replace this...

Spec Limits( Import Spec Limits("C:\Users\user\Documents\MySpecLimits.jm")),

Spec Limits Dialog( "No (skip columns with no spec limits)" ),

Show Within Sigma Points( 1 ),

Show Overall Sigma Points( 0 ),

Shade Levels( 1 )

Expr( FIXME() ), Name Expr( ltest ) // ...with ltest

);

eval(e); // open the platform

Re: Process Capability

txnelson — Sat, 08 Oct 2016 03:16:30 GMT

Here is a working version of the script. It bypasses the requirement to add the spec limits to the platform code by moving the limits into column properties for the columns in the data table.

Names Default To Here( 1 );

dt = Open( "$sample_data/big class.jmp" );

dtSpecLimits = New Table( "MySpecLimits",

Add Rows( 3 ),

New Column( "Parameter", Character, Nominal, Set Values( {"height", "weight", "age"} ) ),

New Column( "LSL", Continuous, Set Values( [0, 0, 0] ) ),

New Column( "Target", Continuous, Set Values( [50, 100, 50] ) ),

New Column( "USL", Continuous, Set Values( [99, 200, 100] ) )

);

//dtSpecLimits << Save( "C:\Users\user\Documents\MySpecLimits.jmp" );

ltest = dt << getcolumnnames( numeric );

Substitute Into( ltest, Expr( List() ), Expr( Process Variables ) );

// Process the Spec Limits and add them as column properties to the data table

For( i = 1, i <= N Rows( dtSpecLimits ), i++,

Eval(

Substitute(

Expr(

__var__ << set property(

"Spec Limits",

{LSL( __LSL__ ), Target( __Target__ ), USL( __USL__ ), show limits( 1 )}

)

Expr( __var__ ), Parse( "dt:" || dtSpecLimits:Parameter ),

Expr( __LSL__ ), dtSpecLimits:LSL,

Expr( __Target__ ), dtSpecLimits:Target,

Expr( __USL__ ), dtSpecLimits:USL,

)

);

Eval(

Substitute(

Expr(

dt << Process Capability( FIXME(), Goal Plot( 1 ), Capability Index Plot( 1 ) )

Expr( FIXME() ),

Name Expr( ltest ) // ...with ltest

)

);

Re: Process Capability

vladbondarenko0 — Sat, 08 Oct 2016 03:49:31 GMT

Thanks everybody for the help.