Feb 14, 2017 11:10 AM
| Last Modified: Nov 19, 2018 6:27 PM
Write Limits to Data Table from Limits Table.jmpaddin
This JMP Add-in takes Spec Limits and any of the 23 different types of Control Limits (i.e. XBar, S, Moving Range, etc.) that are in a separate data table (I call it a Limits Table) and populates the appropriate limits column properties in a JMP Data Table.
As stated above, the “Limits Table” is just a JMP table. To be a valid Limits Table, it must have a column that contains the names of the columns to be updated, and then a column for each specific limit who’s values are going to be moved into the column properties your table that has your measurement data in. Below is an example of what a Limits Table might look like. Note: the names of the columns do not have to have specific names. As will be seen, the columns to be used for the different parts of the spec and control limits will be mapped in a dialog window.
The “Limits Table” has 7 columns ad 128 rows. Each row contains the limits for a specific column in your measurement data table. In this example, the column named “Column Names” contains the names of the columns in your measurement data table that are to be updated. All columns in the “Limits Table” will be mapped in the Add-in, as to the role it plays.
The measurement data table below, is the Semiconductor Capability data table from the JMP Sample data tables. For this example, the Spec Limits that are part of the shipped data table have been removed.
To run the Add-in, go to your measurement data table, and click on it to make it the Current “Active” Data Table. Then run the Addin The window that appears requests the user to select the “Limits Table” to be used for the updating.
When you select the table to use, the window will be augmented with the selection boxes to map the columns in the “Limits Table” to the role it will play in the moving of the limits into the measurement data table.
This is where the mapping takes place. The first item to map, it to identify the column in the “Limits Table” that is to be used as the Identifier of what columns to update. In our example, the “Column Names” column contains this information and it needs to be placed into the ID Column selection box.
Next, we map the limit columns into the type of Limit and whether it is the Upper, Target or Lower limit for the specified limit. . Spec Limits and Control Limits are handled separately. There is a radio button that needs to be set to Spec Limits or Control Limits, to match what type of limit you are mapping. To start with, we will setup the Spec Limits. In the “Limits “Table” the columns named LSL, Target and USL contain spec limits. To map them, simply select each one and move it to the appropriate limit selection box.
The columns XBar LCL, XBar Target and XBar UCL contain control limits. Specifically they contain XBar control limits. To map them to the Add=in, one first sets the radio button to “Control Limits”.
The mapping environment changes slightly. Added to the display, is a down arrow box, which allows one to set which type of control limit you want to map.
The type of control limit that is in the “Limits Table” are XBar limits, so that is the control limit type we select. Then we just map the columns to the limit rolls each of them play
If there were more types of control limits in the “Limit Table” one would just repeat the steps of selecting the limit type you want to map, and then place the appropriate columns into the selection box that represents the type of limit it is.
When you are done with the mapping, just click on “OK” to execute the Add-in. When it completes, you can validate that it has been successful by going to the measurement data table and review the limits column properties