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; } } }

Is it possible to load factor or output response setting from a configuration file?

tanwt

Hi all,

is it possible to load factor/output response settings to jmp with some sort of configuration file?

instead of keying manually

Thanks

Accepted answers

All comments

txnelson

JMP DOE allows for the loading of the Factors from a Factors table and the loading of Responses from a Response table. Both of these tables are just JMP tables of a specified structure,

Which could easily be used as a config table and then just loaded into the DOE

tanwt

Hi txnelson,

Thanks a lot for your reply

That response and factors table you showed looks a lot like excel

can i say it is possible to copy the config from excel (assuming it follows jmp requirement) and paste in those tables directly, and it will work?

ian_jmp

Her's an example to get you started. Put the two attachments on your desktop, then run the code below. To do this, do 'File > New > New Script', paste the JSL into the window, then 'Edit > Run Script'.

NamesDefaultToHere(1);

// Make a DOE object
doe = DOE(Custom Design);

// Read in factors from Excel
fTable = Open("$DESKTOP/Factors.xlsx");
// Set 'Design Role' column property for all factors
for(c=1, c<=NCol(fTable), c++, Column(fTable, c) << setProperty("Design Role", "Continuous"));
doe << LoadFactors;
Close(fTable, NoSave);

// Read in responses from Excel
rTable = Open("$DESKTOP/Responses.xlsx");
doe << LoadResponses;
Close(rTable, NoSave);

Factors.xlsx

Responses.xlsx

txnelson

You can copy and paste the table values, however, there are column properties that need to be set. The column properties provide the information about the Design Role(Discrete Numeric, Continuous, Blocking, etc.), and how hard or easy is this factor changed.
I suggest you interactively create one or more of your Design Inputs and then go to the red triangle and select "Save Factors", and then explore the resulting table, along with reading the DOE Guide from the JMP Documentation Library, available under the Help pull down menu. That will give you the information you need on what you can do.

tanwt

Hi ian

thanks for the help. a few questions

1) Is it possible to have the response and factor info within the same excel file, but different sheet?

2) in your response table below, is the sequence important or as long as the field name match jmp requirement is good enough

Response Name

Lower Limit

Upper Limit

Response Goal

Importance

3) for the factors info below, what about additional info like continous/categorical, etc? can those info be loaded as well?

X1	X2	X3	X4	X5
-1	-1	-1	-1	-1
1	1	1	1	1