Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
tanwt
Level I

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

Hi all,

 

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

instead of keying manually

 

Thanks

 

jmp_pic.jpg

7 REPLIES 7
Highlighted
txnelson
Super User

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

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, 

factor.PNG

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

Jim
Highlighted
tanwt
Level I

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

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?

Highlighted
ian_jmp
Staff

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

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);
Highlighted
tanwt
Level I

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

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 NameLower LimitUpper LimitResponse GoalImportance

 

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

X1X2X3X4X5
-1-1-1-1-1
11111
Highlighted
ian_jmp
Staff

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

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.

Highlighted
tanwt
Level I

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

Hi ian

 

thanks for the encouragement

i am going to try the methods suggested by the experts

will report back when i have progress

Highlighted
txnelson
Super User

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

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.
Jim
Article Labels