# 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() );

y;

);

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

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.