topic Re: Assign different spec limits from a column rows to another column rows as a property in Discussions

Assign different spec limits from a column rows to another column rows as a property

Mikasa — Fri, 09 Jun 2023 23:36:34 GMT

I know Spec limit has been discussed here different times but I could not find a solution for my question

I have a column with different product and I group the same products but each group has different spec limit. all the spec limits are in 2 columns (Upper, lower limit). I like to assign each row of the product column to the same row in the spec limit column. Could you please tell me how to have a loop for that? I have written a script like below but does not work

//Spec limits
For Each Row(
    If( :Upper Limit != "Null", 
        Eval(
            Substitute(
                    Expr(
                        :REM OX << set property(
                            "spec limits",
                            {LSL( __LSL__ ), USL( __USL__ ), Target( __Target__ ), Show Limits( 1 )}
                        )
                    ),
                Expr( __LSL__ ), :Lower Limit,
                Expr( __USL__ ), :Upper Limit,
                Expr( __Target__ ), :Center Line, 
            )
        )
    )
);

Re: Assign different spec limits from a column rows to another column rows as a property

txnelson — Tue, 01 Sep 2020 17:27:20 GMT

The Spec Limits Column Property can handle only 1 set of Spec Limits. The only platform that I am aware of that can handle multiple spec limits is the Process Screening Platform.

Analyze=>Screening=>Process Screening

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Tue, 01 Sep 2020 19:20:57 GMT

Thank you

Is there any way that I can write in in my script?

Re: Assign different spec limits from a column rows to another column rows as a property

txnelson — Tue, 01 Sep 2020 19:29:44 GMT

Your question is ambiguous. What do you want to write in a script? The script that you displayed is an attempt to write different spec limits for each row in your data table. If you do that the value for the current row, will replace the one and only one set of spec limits the column can have. The spec limit stored in the column property will be the spec limit written for the last row of the data table.

If you are talking about can you write the code for Process Screening, the answer is yes. The best way to do this, is the same way it is best for all platforms, perform the task interactively, and then go to the output's red triangle, and specify to save the script.

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Tue, 01 Sep 2020 20:38:48 GMT

Thank you Jim.

my question was exactly what you said, writing a code for the screening process. I have JMP Pro 12.2 and I can not see the platform there I guess it might be in the higher versions.

Re: Assign different spec limits from a column rows to another column rows as a property

txnelson — Tue, 01 Sep 2020 20:58:01 GMT

Yes it is in a later release. Sorry

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Wed, 02 Sep 2020 14:04:03 GMT

I installed JMP 14 and used the process screening platform. I could use the quick graph to plot one of products. But the graph script does not exist when I save the process script.

I need to plot all products as the result of process screening

Re: Assign different spec limits from a column rows to another column rows as a property

txnelson — Wed, 02 Sep 2020 14:11:36 GMT

Can you share the script it does produce and what it needs to do to solve your issue?

Re: Assign different spec limits from a column rows to another column rows as a property

tonya_mauldin — Wed, 02 Sep 2020 14:53:49 GMT

Here is an example of scripting Quick Graph for Selected Items.

dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );
obj = dt << Process Screening( Y( :NPN1, :PNP1, :PNP2, :NPN2 ) );
obj << Select All;
obj << Quick Graph for selected items;

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Wed, 02 Sep 2020 15:08:33 GMT

Thanks a lot,

That totally works. I am reporting the result in a report window and create some plots for each product. I have to use the result of process screening like Upper limit and Lower limit in the plots and I use "Bivariate" to plot them. I just need to extract the result from process screening for different products with different USL and USL. but I do not know how?

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Thu, 03 Sep 2020 10:22:44 GMT

Data Table( "SPCReady" ) << Process Screening(
    Y( :REM OX ),
    Grouping( :Product ),
    Control Chart Type( "Indiv and MR" ),
    Out of Spec Count( 0 ),
    Out of Spec Rate( 0 ),
    Latest Out of Spec( 0 ),
    Cpk( 0 ),
    Ppk( 0 ),
    Spec Limits( 1 ),
    Use Limits Table(
        1,
        Data Table( "SPCReady" ),
        Grouping( :Product ),
        Center( :Center Line ),
        LSL( :Lower Limit ),
        USL( :Upper Limit ),
        Target( :Center Line ),
        Go
    )
);

It makes a table with the group of products the I have (like: Apple(40 count), Dell (27 count), Lenova(20 count) that have the same USL and LSL. I like to plot ReM OX (Y) vs another variable (X) that I have in my original table for different products group and show different USL and LSL. I report them in a window report.

Re: Assign different spec limits from a column rows to another column rows as a property

tonya_mauldin — Fri, 04 Sep 2020 14:35:08 GMT

Save Details Table from the red triangle next to Process Screening will save a data table that contains the information you are looking for.

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Fri, 04 Sep 2020 14:46:21 GMT

Thank you Tonya. I can even make a table there. But my problem is how to plot the products with different Spec limits with "Bivariate" in my window report. REMOX is still one column and it can get only one set of limits. I have already group the products using "Munger" Formula in my original table. I do not know how Process screening result can help me.

Re: Assign different spec limits from a column rows to another column rows as a property

tonya_mauldin — Fri, 04 Sep 2020 14:51:11 GMT

Why are you using bivariate? Why are you not using the graphs from Process Screening? As mentioned previously, Bivariate only allows one set of spec limits. Process Screening is the only platform that allows spec limits based on a grouping variable.

Re: Assign different spec limits from a column rows to another column rows as a property

Mikasa — Fri, 04 Sep 2020 15:24:06 GMT

I am making 1-click report to show all my graphs in a report window.
I think I can use Process Screening there as long as I know how to show my graphs on the report window and with the variables that I want to. (Y:REM OX, and X: another variable) for different products.