333514_en-US

liliconcom

Re-binning based on new spec limits

I have a table with a number of parameters with spec limits and a pass fail column.

I use manage Spec limits to change some of the limits and reload them to the columns of the table.

OK so far.

But now I want to re-bin all the devices (i.e. re-determine Pass & Fail) based on the new spec limits.

Since there are many, many parameters writing a formula to do this would be unwieldy and take quite a bit of time.

I could write a script to do it (determining the columns with spec limits and creating a formula column based on that).

But is there anything built into JMP to do this?

 

 

Data TableOtherRe: Re-binning based on new spec limits

I am not aware of a JMP binning tool based upon Spec Limits, but here is a very efficient piece of code that does the binning.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

colNames = dt << get column names( continuous, string );

For( i = 1, i <= N Items( colNames ), i++,
 Clear Symbols( specs );
 specs = Column( dt, colNames[i] ) << get property( "Spec Limits" );
 If( Is Empty( specs ) == 0,
  dt << New Column( colNames[i] || " Pass_Fail", character, set each value( "Fail" ) );
  theRows = dt << get rows where( Eval( specs["LSL"] ) <= As Column( dt, colNames[i] ) <= Eval( specs["USL"] ) );
  If( N Rows( theRows ),
   Column( dt, colNames[i] || " Pass_Fail" )[theRows] = "Pass"
  );
 );
);