In his demo at a live Mastering JMP webinar on Tracking and Trending Manufacturing Metrics, Systems Engineer Byron Wingerd @Byron_JMPshowed 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.

Copy code from the window that pops up with sample code for ‘Save Presentation.’

Paste code into top of New Script window.

Remove JSL code (lines 2 and 3) that would open Big Class data and run a bivariate script.

Highlight lines 2 and 3, delete, add a few carriage returns.

Copy and add JSL code that will import your Excel data.

From the Tables panel of the JMP Table where you imported the Excel data, right-click Source, then select Edit.

Copy the code displayed in the Edit window.

Paste copied code in New Script, Line 2.

Add a semicolon at the end to indicate the end of a JSL code block.

Copy and add JSL code that will reformat the data as needed for the analysis.

From the Tables panel of the JMP Table where you re-formatted (split and grouped) the data, right-click Source, then select Edit.

Copy the code displayed in the Edit window.

Paste copied code in New Script window, after the semicolon that indicates the end of the data import JSL code block.

Add a semicolon at the end to indicate the end of this JSL code block.

Copy and add code that will create Control Charts.

From the Control Chart window, right-click the Control Chart Builder red triangle, then select Save Script>To the Clipboard.

Paste code in New Script window, after the semicolon that indicates the end of the reformatted data JSL code block.

Add a semicolon at the end to indicate the end of this JSL code block.

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