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

## Load Factors table into DOE using JSL

I am designing multiple DOE using risks assesments done in Excel. I wrote a script to organize all the variables into a neat table and converted the properties to that of a factors table (credit to a previous post (Saving a data table as a factors table):

``````dt3  = Current Data Table();
nomdata = dt3 << get column names( nominal );
condata = dt3 << get column names( continuous );

For( i = 1, i <= N Items( nomdata ), i++,
Column( dt3, Char( nomdata[i] ) ) << Set Property("Design Role", Design Role( Categorical ), Factor Changes( Easy))
);

For( i = 1, i <= N Items( condata ), i++,
Column( dt3, Char( condata[i] ) ) << Set Property("Design Role", Design Role( Continuous ),  Factor Changes( Easy))
);``````

Now I would like load this factot table into the Custom design DOE, is there a way to do this using JSL or is using the graphic interface the only way?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

## Re: Load Factors table into DOE using JSL

I solved it. It was actually a super simple solution:

``````DOeInit = DOE(
Custom Design,
{Add Response( Maximize, "Y", ., ., . ), Set Random Seed( 4547922 ),
Optimality Criterion( Name( "Make D-Optimal Design" ) ), Simulate Responses( 0 ),
Save X Matrix( 0 )}
);

As long as the Factors table remain open, this will automatically gets imported.

Highlighted

## Re: Load Factors table into DOE using JSL

I solved it. It was actually a super simple solution:

``````DOeInit = DOE(
Custom Design,
{Add Response( Maximize, "Y", ., ., . ), Set Random Seed( 4547922 ),
Optimality Criterion( Name( "Make D-Optimal Design" ) ), Simulate Responses( 0 ),
Save X Matrix( 0 )}
);