nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

401866_en-US

liliconcom

Automation of Reports for PowerPoint Templates with JMP 15

Hi all,

I run weekly reports on physiochemical attributes. The old process was to manually input data from excel into JMP. After entering the new data into JMP two scripts are run: Run Chart and Control Chart scripts, that are saved to the Data Table. These scripts have limits of precision and formatting applied (or saved into the scripts). Then the charts are copy & pasted one by one into a PowerPoint presentation.

I was wondering can this process be automated?

I have added a script that allows me to automatically update the Data Table.

I would love to be able to simply generate the PowerPoint presentation with just a click of a button instead of having to copy and paste each graph into the report.

Every script I have attempted always lets me down.

I would like to know if anyone could point me in the right direction or if this can even be done (see below).

In my head I would like -
1. A script to update the data table ( I have achieved already)
2. Run scripts for Run Charts and Control Charts so I can update the x axis (drag new data in and drag the old data off the x-axis. Then save the updated graphs

3. Add a final script that would automatically add the updated Run Charts and Control Charts to a formatted PowerPoint presentation.

Thanks for any advice.

Other

Re: Automation of Reports for PowerPoint Templates with JMP 15

Hi,

You might consider learning Visual Basic and using it as a master script that drives JMP and PowerPoint. You could still run JSL files within JMP if you already have those written. JMP has a full Automation interface, and the JMP Automation Reference can be found in the Documentation folder of your JMP install.

This may be a pretty big challenge. The only other idea I have would be to use JSL to emit the JMP PowerPoint output to disk and then use a Windows (if you are using Windows) command line to open the file into PP.