Factor Table Wizard
For complex factorial designs, use the Factor Table Wizard to construct the full crossing of the factors and levels. This is preferred with large designs containing multiple variables. The Factor Table Wizard operates via an Excel macro to first create each individual factors and their corresponding levels, and then create a full crossing of the factors, and finally copy the conditions into E-Studio. Since the Factor
Table Wizard is implemented via an Excel macro, you must first ensure that your Excel security settings are not configured to block macro execution.
When any Excel workbook that contains a macro is opened, including the Factor Table Wizard workbook, the macro will be disabled by default, but Excel will alert you to the fact that a macro is available (see the image below).
Running the Factor Table Wizard
Once your Excel security settings are configured to enable macros, launch the Factor Table Wizard from the E-Prime 3.0 start menu folder (E-Prime 3.0 > FactorTable Wizard).
The Instructions (Help) worksheet is the first worksheet in the Factor Table Wizard workbook. It contains the control buttons which enable you to define factors, add levels, and ultimately cross the factors. Please refer to the Instructions (Help) worksheet for detailed instructions on how to use Factor Table Wizard.
Once the list is completed, the values in the table can be copied. Then, the values can be pasted into a List object in your experiment by placing the cursor in the first cell of the user added column (i.e., paste in the first cell of an added Attribute).
NOTE: Only the table values themselves are copied; the column headings are not. However, the column headings on the list object match the order of the columns in the Factor Table Wizard, so no additional editing of the list object is required.