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
- :
- Discussions
- :
- [JSL] Spec limits and reference lines

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

Jan 19, 2017 10:17 PM
(4058 views)

Hi,

I have been trying to find a script to import specs from specs datatable and set Show Limits( 1 ) for all columns.

I came across a few posts but still could not figure out how to do it.

Please kindly help.

Thanks a lot.

1 ACCEPTED SOLUTION

Accepted Solutions

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

Here is a simple script that sets spec limits. It would be a simple matter to place this into a loop that reads from one data table and writes the limits to another, but not knowing the structure of your input table, etc. I am only providing the write component

```
Names Default To Here( 1 );
dt = Current Data Table();
col="NPN1";
LSL=100;
Target=110;
USL=120;
Eval(
Eval Expr(
column(dt,Expr( col )) << set property(
"spec limits",
{LSL( Expr( LSL ) ), USL( Expr( USL ) ), Target( Expr( Target ) ), Show Limits( 1 )}
)
)
);
```

Jim

4 REPLIES

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

Here is a simple script that sets spec limits. It would be a simple matter to place this into a loop that reads from one data table and writes the limits to another, but not knowing the structure of your input table, etc. I am only providing the write component

```
Names Default To Here( 1 );
dt = Current Data Table();
col="NPN1";
LSL=100;
Target=110;
USL=120;
Eval(
Eval Expr(
column(dt,Expr( col )) << set property(
"spec limits",
{LSL( Expr( LSL ) ), USL( Expr( USL ) ), Target( Expr( Target ) ), Show Limits( 1 )}
)
)
);
```

Jim

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

How many times has this question been posted on the JMP Community? Someone should write a book... J

Learn it once, use it forever!

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

Maybe not a book, but it has inspired me enough write some code to add it to the Semiconductor Tool kit

Jim

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

Here is a blog post about checking the box for "Show as graph reference lines".

https://community.jmp.com/t5/Byron-Wingerd-s-Blog/Spec-Limit-Lines-on-Graphs/ba-p/33317