Need to run control charts on updated data regularly?
In his demo at a live Mastering JMP webinar on Tracking and Trending Manufacturing Metrics, Systems Engineer Byron Wingerd @Byron_JMP showed how to import production data from Excel, format data for analysis, run control charts, publish them to PowerPoint, and very easily create a script to do that all with several clicks when data is updated.
The video shows the whole process.
I’ve summarized the scripting part below because it is easy to do and applicable for many JMP reports that you want to generate using updated data.
To begin, we assume you have let JMP create the scripts for your work as you imported data, formatted the data for analysis, run reports and saved them to PPT. Then:
Now make minor edits to the new script:
1. Create a variable called dt1 that will refer to the Excel file you will import.
2. Create a variable called dt2 by splitting table dt1. Going forward, dt2 will refer to the reformatted (split and grouped) table, no matter what you may call that table. Note: << means Send To, so the Split instructions are going to be sent to dt1, and the split table will be dt2.
3. Send the Control Chart Builder script instructions to dt2.
4. Identify the Control Chart Builder reports as an object.
5. Create a report object variable (in the PowerPoint code you used to start New Script) to refer to the Control Charts and save the Presentation.
6. Remove path so New Script will save PowerPoint presentation to same directory where New Script will live.
7. Name and save the New Script you created. File>Save As>yourscriptname.jsl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.