BookmarkSubscribeSubscribe to RSS Feed

Super User


Jun 22, 2012

Write Limits to a Data Table from a Limits Table

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.

limits table.PNG


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. 

data table.PNG

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.

LW window 1.PNG

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.

LW window 2.PNG

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.

LW window 3.PNG

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.

LW window 4.PNG

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”.

LW window 5.PNG

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.

LW window 6.PNG

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

LW window 7.PNG

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

LW window 8.PNG

LW window 9.PNG


this .jmpaddin file is not being intalled in my computer.

Anyone with this problem?





You might check the version compatibility with the Add-in. He might have limited it to 12 or newer. You might want to check with your license admin. I’m pretty sure you have access to version 12 and 13… there were lots of improvements that you might find really handy.



@M_Anderson is correct.  The addin requires JMP 12 or later


Great addin! I was just going to write kind of the same thing for a project. 


Is is it possible run the addin via JSL? I would like to automate the process of adding spec limits in my application. 

Thank you for your comment.  As far as running the addin as part of JSL, you will have to dig into the code and pull out the working part.   The code is structured into functions and EXPRs, that should allow you to easily strip out the code that is called from the dialog box.


Absolutely brilliant add-in. Great time saver. Especially as the "Show as graph reference lines" is automatically activated.


Thanks for sharing.



Article Labels
Article Tags