RTP JMP User's Group Meeting Oct 11, 2016

Byron_JMP — Fri, 30 Sep 2016 15:58:41 GMT

Lets get the group together to share highlights and discoveries from the Discovery Summit

Last week at the Discovery conference I learned a ton of new tips and tricks for working with data and I'm pretty sure I'm not the only one!

Where & When:Tuesday Oct 11, at the SAS campus in Cary NC. Building F (training building, Google Maps).

5:30 - 6:00 Networking and Snacks

6:00 - 7:30 Meeting

Cost: Free

Who: Any JMPer, whether you went to the Discovery Summit or not.

Agenda:

1. Discovery Summit Highlights

-Analysis insights

-Formulas and JSL

-Hot talks and posters

Re: RTP JMP User's Group Meeting Oct 11, 2016

Byron_JMP — Fri, 28 Oct 2016 13:30:21 GMT

Meeting Notes

1. Discovery 2016 recorded presentations:

Lots of the talks were recorded and the slide decks, journals and example tables are attached to the talk pages.

This is super helpful if you weren't able to attend more than one talk at a time during Discovery, or if you wanted to catch up on the latest.

2. Handling specification limits in column formulas

Jerry Cooper presented a really unique method of using spec limit properties in a column formula

His talk is here: Letting Go of Excel: Hello Formula Editor

In the link, you can download his data table. The two interesting formulas are in these columns

:height.is

Names Default To Here( 1 );

specs = :height << getproperty( "Spec Limits" );

isResult = Function( {x, y},

:height << Color Cells( x, Row() );

);

If(

:height > specs["USL"], isResult( 3, 1 ),

:height < specs["LSL"], isResult( 5, -1 ),

specs["LSL"] <= :height <= specs["USL"], isResult( 4, 0 )

);

The big Ah-Ha is the getting the spec limit property in the formula.

:height.is.LocSorted

{"Too Short", "Just Right", "Too Tall"}[Loc Sorted( [0, 64, 68.1], :height )]

Here, getting the values in a matrix and then using that sorting to produce labels. Its easier than a conditional match.

3. Control Chart Builder

Event Chooser is a new option for Attribute charts. This is very very handy.

Annie Dudley Zangi's talk is here Control Chart Builder Can Do That?

4. Creating Dynamic Workflows

Brady Brady, hits the ball out of the park with completely unglued new utility that he presented in his talk

Creating Your Own Dynamic Workflow With JMP® Custom Starter Menus

If there was only one thing you had to take away and try from all the talks at Discovery, this is #1. (IMHO)

Here's what you do.

1. Download his template table, and the add-in, run the add-in to install it.

2. Edit the template table. I made a short one for this meeting (attached below)

3. Run the script in the table. This script makes a new script.

4. Run the new script. This script makes a simple straight forward JMP Starter-like window with buttons and everything

Fast and Easy Custom Menus in JMP

Note about the attachment. The links are to files that are not included in the file, so that means that the JMP Starter it generates won't actually work for you, its just an example.

topic Re: RTP JMP User's Group Meeting Oct 11, 2016 in Research Triangle Park JMP Users Group