I need your help in using JMP to build up control charts. Right now we have all data on excel spreadsheets updated daily (every day is 1 line more on Excel representing the datapoints of the day) and I want to make out of this data a I-MR chart.
Here below my requirements:
I don't know exactly what is the best and easiest way to proceed therefore I need your input.
Thanks a lot.
Are you using v14? Because that will make a few things easier.
To start with, just use File open, and the import wizard to open your excel table.
-JMP writes a Source script in the table.
Then use Control Chart builder to make your graphs, and save the script to the data table.
-JMP writes the cotrol chart script.
While you're there set the control limits as you like, and then Save Limits to a Table.
-Check the scripting guide, it has a scripting for loading spec limits.
At the most basic level all you'll have to to is "glue" these pieces together.
obj=dt<<control chart builder();
obj<< get limits (limit table name):
then for fun, it might be nice to throw in the process screening tool get your alerts.
first of all thanks for your help!
I'm using V12.2, what are the main issues I can face compared to V14?
Anyway I'll try to "glue" all the pieces together in order to have a simple tool to manage all control charts from the lab, it has to be user friendly and fast enough to do not overload daily activities for laboratory technicians.
I will get back to you if I need further help.
You should add which JMP version you are using.
The first pass script is easy, but the devil is in the details:
I am sure you will get a response for the first pass once you supply the JMP version. This note is a heads up, that the items above are usual features requested. So you will need to dig into leraning some JSL.
From the JMP main menu, select Help>Scripting Index> select Functions > and type Excel in the search text field, select Open from the list of items (item match). See example 3. It contains the general syntax for the reading Excel and th example below.
dt = Open( "$SAMPLE_IMPORT_DATA/Team Results.xlsx", Worksheets( "Ungrouped Team Results" ), Worksheet Settings( Headers Start on Row( 3 ), Data Starts on Row( 4 ) ) );
Now select Objects and type Control Chart in the search text field. I suggest you try the script for:
The options available depend upon your version of JMP.
I'm using JMP 12.2.
Here below my comments in red
I also have few additional questions:
if you have time, take a look at these:
and also this little bit here
Please don't take this as a "let me google that for you", Over the last year or so I tried to cover this exact topic in the Mastering JMP webcasts.
I read some tutorials and tried several charts, but I can't figure out one thing:
why if I create a chart from the control chart builder I have access to the warnings configuration and customization instead if I start creating an IR chart I can't and I need to use the standard rules?
I think, anyway, I'm almost there but I might need some additional hints in the coming days.
I responded to an earlier discussion about Moving Range charts. Not all trend rules make sense, however several suchs as those that flag numerous values all within 1sigma can flag a reduction in the moving range (the variability) and a rule like 4 of 5 outside 2 sigma is really flagging instability. My guess is that JMP does not allow the standard rules for the MR since they are meant for "normal" type data.
That said, the script belows shows a work around:
Be careful which rules you apply. I have seen many times people misinterpretting an MR chart.