choice-metrics.com

Hi

I have a design that I exported from Qualtrics as an .xlsx. There are about 1000 rows and each row has 3 alternatives and 5 attributes for each alternative. Could I evaluate the efficiency of this design in Ngene using the "; eval" command and how would I have to modify this .xlsx file so that it could be read and evaluated in Ngene i.e. how do I turn an .xlsx file into a .ngd file?

Sorry if this has been asked before. I can't find it in the search.

Thanks!

Page 23 of the manual shows an example of the format in Excel.

You can use any header names, Ngene does not use them, but your spreadsheet does need headers in the first row.

First column: use 1 for each row
Second column: choicetask numbers
Other columns: your attributes

Please make sure that you put the attributes in the Ngene script in the same order as they appear in the spreadsheet, first for alternative 1, then alternative 2, then alternative 3. Make sure that the attribute levels in the spreadsheet match the levels in the Ngene script.

Once your spreadsheet is complete, save it, close it, and open it in your project in Ngene. Next, you add, ;eval = spreadsheetname.xlsx to your script.

Michiel

Hi - Thank you so much for your quick reply. It worked!