How do you specify a spec table when scripting Process Capability

kyle_lamson

I'm trying to automate some reports with process capability but I don't know the syntax needed to retrieve the spec table I have. I've also tried using the eval() function to place the correct syntax but that's not working either. What should I place in the Spec Limits() field to make that work?

pc = Process Capability(

Process Variables( collist[1] ),

Spec Limits( USE SPEC TABLE HERE),

Individual Detail Reports( 1 ),

Capability Box Plots( 0 ),

Goal Plot( 0 )

txnelson

What I think will be the easiest way to handle what you want to do, is to copy the spec limits into the column properties for each of the columns that you are going to run the Process Capability Platform on.  Once you have saved the limits to the column properties, they will be there and can be accessed by many of the JMP platforms.  Here is a script that should give you a start on how to populate the column property

 

Names Default To Here( 1 );

dt = Open( "SAMPLE_DATA/semiconductor capability.jmp" );

   

// for the purpose of the example, delete the current spec limits for column NPN1 

dt:npn1 << delete property( "spec limits" );

   

// set the values for the new limits.  This could be in a loop,  

// reading the values from a spec data table 

hi limit = 118; 

lo limit = 100; 

parameter = "NPN1";

   

// Now set the limits for the columns, substituting the values in the expression 

// and then running the code 

Eval( 

       Substitute( 

                     Expr( 

                           Column( dt, __col__ ) << set property( "spec Limits", {LSL( _L_S_L_ ), USL( _U_S_L_ )} ) 

                     ), 

              Expr( _L_S_L_ ), lo limit,

              Expr( _U_S_L_ ), hi limit, 

              Expr( __col__ ), parameter 

       ) 

);