topic Re: Is it possible to load factor or output response setting from a configuration file? in Discussions

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

tanwt — Thu, 08 Jun 2023 21:00:49 GMT

Hi all,

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

instead of keying manually

Thanks

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

txnelson — Mon, 05 Oct 2020 05:41:48 GMT

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

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

tanwt — Mon, 05 Oct 2020 05:48:39 GMT

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?

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

ian_jmp — Mon, 05 Oct 2020 11:29:52 GMT

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

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

txnelson — Mon, 05 Oct 2020 11:43:53 GMT

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.

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

tanwt — Tue, 06 Oct 2020 04:49:34 GMT

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

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

ian_jmp — Tue, 06 Oct 2020 08:53:23 GMT

The short answer is 'yes', it's perfectly possible to store all of the information that JMP needs to set up any experiment in Excel (on a single sheet, or multiple sheets). But, to make this happen, you probably need a little more knowledge of how JMP needs this information, and how you can use JSL to manipulate it to the desired form. For example, I didn't check how strict JMP is in the ordering of the columns, but if this does matter, you can rearrange them in the JMP table before presenting this to the DOE platform.

@txnelson has already given some good advice. For the multiple sheet aspect, look here. There are lots of good resources to learn JSL if this is a problem worth solving. I'm sure people would offer additional help on specific issues as these arise.

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

tanwt — Wed, 07 Oct 2020 01:02:48 GMT

Hi ian

thanks for the encouragement

i am going to try the methods suggested by the experts

will report back when i have progress