Arriving at this step, you should see the following screen:

The Wizard assumes at this point you have a Latent GOLD results file available to your computer. If that's true, the rest is pretty simple. Click the Import Latent GOLD run button to bring up a dialog box asking for the file.

Maneuver to the folder where you saved the text file. If you are running the demo version of the Format Wizard, you can load any of the following files:
|
File name |
Model type |
|
ex1Cluster.txt |
|
|
ex1DFactor.txt |
|
|
Latent GOLD shoe.txt |
|
|
Conjoint regression.txt |
From here, the procedure is the same regardless of which file you choose to load. In this case, we will load the third file from the above list.

When you have located the file you want, click Open. After a few seconds during which the Wizard is engrossed in processing, you should see the dialog box advance to the next step, with the imported file behind it.

Normally you would continue with this step. For now, though, click the Cancel button to explore what the Wizard has done.
Notice that the Wizard has created one worksheet for each Latent GOLD panel. If you chose to download neighboring models, you will have a set of worksheets for each model.

Notice also that the Wizard has automatically picked to model with the lowest BIC to import. Most of the time this will be what you want. For those other cases in which you want to choose another model, either select the option for downloading neighboring models or follow this procedure for when your results text file has too many rows.
Importing additional worksheets
The Wizard imports all the sheets that appear when you click the plus (+) sign next to an estimated Model specification. Occasionally, though, you may want to import more worksheets than this. If so, you can import them manually. Let's follow an example of how to do this. Say we have just imported a DFactor model like the following, and we want to include loadings information that the Wizard did not import. Here is the Latent GOLD Model ...

... and here is the imported version.

In the left pane of the Latent GOLD program, we can click on the plus (+) sign next to Parameters to open it, then click on Loadings. A new window appears in the right pane. This is the window we want to import into our Excel file.

In Excel, select Insert | Worksheet from the main menu.

Double-click on Sheet7, the sheet name, to select it. Change the name to Model 9 Loadings.

Return to Latent GOLD, click on the right pane, then press Ctrl_A to select the entire pane.

Now click on the Excel sheet we just created, and press Crtl-V.

Your data has been copied into Excel. At this point you can manipulate the sheet in any way Excel permits. For example, you can move the sheet by clicking on the sheet name and dragging it to its new location, say after Model 9 Parameters.

Cycling through the new worksheets, you will see that all of the information that you saved in the results file was transferred to the new Excel workbook. Feel free to explore the other worksheets and examples. When you are done, rerun the Format Wizard to go on to the next step.