turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- How do I use a script to save control chart limits...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 7:18 AM
(912 views)

I need help creating a script that will create a new table containing the UCL LCL and Average from a control chart.

The control chart is created by a script using data from an excel file. I need the UCL LCL and Average to go back into the original excel file.

I have found reference to a "Save Limits" option for control charts in JMP but I'm not sure how to use it or if it is even appropriate for me needs.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 8:31 AM
(936 views)

Solution

Use the in column command to save the limits to the column. Here is an example.

```
dt = Open("$SAMPLE_DATA/Quality Control/Diameter.jmp");
obj = dt<<Control Chart Builder(
Variables( "Subgroup"(:DAY), "Y"(:DIAMETER) ),
Chart(
Position( 1 ),
Points( Statistic( "Average" ) ),
Limits( Sigma( "Range" ) ),
Connecting Line( 1 )
),
Chart(
Position( 2 ),
Points( Statistic( "Range" ) ),
Limits( Sigma( "Range" ) ),
Connecting Line( 1 )
)
);
obj << in Column; // *Save Limits in Column*
```

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 7:53 AM
(905 views)

If you use the Control Chart Builder, the only option available is to Save to Column, which saves the limits to the columns's "Control Limits, column property". A simple script could move these values to a JMP data table.

However, if you use one of the other Control Chart platforms, such as Xbar, etc. They have the option of saving the limits to a table.

So either option will work.

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 8:13 AM
(902 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 8:27 AM
(900 views)

The answer is: Of course

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
dt:npn1 << set property( "control limits",
({XBar( Avg( 115 ), LCL( 112 ), UCL( 118 ) )}) );
```

This is a very simple example, but it can be built on. One would need to know the table structure of the limits coming in, and then it would have to be able to match up the input from the limits table to the data table you are populating. If you are looking for a JMP Platform to do this, I am working on an Addin to do this precise thing. It should be available by the end of this week, in the File Exchange.

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 8:31 AM
(937 views)

Use the in column command to save the limits to the column. Here is an example.

```
dt = Open("$SAMPLE_DATA/Quality Control/Diameter.jmp");
obj = dt<<Control Chart Builder(
Variables( "Subgroup"(:DAY), "Y"(:DIAMETER) ),
Chart(
Position( 1 ),
Points( Statistic( "Average" ) ),
Limits( Sigma( "Range" ) ),
Connecting Line( 1 )
),
Chart(
Position( 2 ),
Points( Statistic( "Range" ) ),
Limits( Sigma( "Range" ) ),
Connecting Line( 1 )
)
);
obj << in Column; // *Save Limits in Column*
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 13, 2017 8:45 AM
(886 views)

I believe that Tonya has the correct answer.....I was approaching the issue from a different angle

Jim