DoE Workflow/Tool-ChainHi everybody,
I am evaluating JMP. Using the trial version.
Before I used JMP, I used R+MiniTab for a DoE with about a Million data points.
So I summarized the data in R to get 20 medians as response.
MiniTab shows run orders, which I used to join my results.
But how does that works in JMP?
My DoE table has no run order. Neither I am able to export this table. Is that a limitation to the trail version?
I figured out, that I could make join with a different table, but because of the repetitions, I still need a unique key to join with.
So what is the workflow in JMP for exporting a DoE-table, run the DoE and reimport the results?
DOERe: DoE Workflow/Tool-ChainIt is not really clear to me what you are trying to do. But maybe some of this information will help.
You can create a design in JMP under the DOE menu. There are many choices for the type of design. In the design creation process, just before you create the data table, there is a checkbox to add a run order column.

Checking that and clicking Make Table will give you a DOE with a run column. You can then enter your response data directly into the JMP table. There is no need to export or "re-import" the table. It can all be done in JMP, including the summarizing of the data.
Being new to JMP, I would strongly suggest going through the tutorial that is provided under the Help menu. There are also MANY free online videos and tutorials under jmp.com. Please explore some of those videos to learn more about what JMP can do. Best of luck!
Re: DoE Workflow/Tool-ChainAs Dan says, there is no need to setup the design in R. Create the design in JMP (this can be exported in Excel if you prefer), analyze the design in JMP and then if you want you can export the analysis into Word or PowerPoint or other file types.
Re: DoE Workflow/Tool-Chain@EDS : A designed experiment with a million observations? I'm curious, can you articulate additional details around how you went from apparently 20 unique treatment combinations to a million observations? I've never heard of a designed experiment like this so I'm always interested to learn about unique approaches to DOE in general.
Re: DoE Workflow/Tool-ChainHi P.,
well. It´s quite simple.
It is a printing process. The stencil has ~20.000 openings.
The optical inspection unit measures area, height and volume of every opening. So three values per opening.
Of course I focus on special areas with a weak performance. And there are just 20 real repetitions.
Goal of the DoE is to reduce outliers and raise the median of the volume. But the height and area might be interesting for further investigations.
My first DoE (R+Minitab) brought me impressive results.
Now I´m planning a DoE with the same concept, but with 80 to 140 real repetitions.(It´s a bit tricky. A lot of hard to change factors...)
There for a I looking for a software to handle the whole data at once and filter the named areas interactively.
So the only puzzle piece I´m missing to reach my goal is the way to link the measured data to the DoE table...
Re: DoE Workflow/Tool-ChainHi Dan,
done my very best to help my self. But after 2 hours of reading and watching tutorials just for that last point on the list, I gave up.
I think that´s really a bit the tricky thing with JMP.
Of course there is a solution for your problem. Just in very, very few times you are the one with a new problem. But where to find the checkboxes or how it must be done is the issue.
Well - if I have seen the dialog from our snapshot somewhere... But I really didn´t.
But now I know it exists and is exactly what I was look for. For the moment that is good enough. So if we buy the software, it will work.
Thank you very much for your help!