responses.xls (case 9123)

Hi,

I have trouble displaying participants' scores to participants.
I think that this problem results from responses.xls.

I created responses.xls file which has three rows - variable, value, skipto.
I wanted participants to do personality test and show their scores, and so I created two variables -meaning, escore, and elabel with excel SUM formula.
However, the screen displayed as follows:
you are <escore> out of 12.
you are <elabel>.

What should I do to correct this issue?

Also, I would like to know about "reports" folder. My "data" folder has only "by variablename" subfolder and "byquestionnair" subfolder.

Please let me get great advice on these issues.

Thanks,

Hi nablee,

I'd be happy to help you with your use of the responses.xls feature in MediaLab. It would be easiest for me if I could get a copy of your responses.xls and MediaLab questionnaire and experiment files. You can attach them to your response to this email; you can keep them separate if there are only a few or put them all in a zipped file folder if you have a large number of files.

Cheers.

Jason

The problem was in the name of your responses.xls file. You need to name the file responses and have .xls as the file extension. Your file name just had an extra .xls in it. When I deleted that, it ran just fine.

Thank you for your effort =)

Unfortunately, it did not work after changing the file name.

the result screen still displayed as follows.
you are <escore> out of 12.
you are <elabel>.

The formula embedded in my excel file seems not to calculate participant's score. Otherwise, 'response' file seems not to be linked to the experiment file.

In fact, the formula is belonged to one que file of the entire 6 que files.

Could you let me get other ways to solve this problem if possible?

Thank you very much.

Do you only have a single response file named "responses.xls" (without the quotation marks) in the set of files for this MediaLab experiment? Also, do you see any files in your Data folder for this study in a folder named "reports?" If so, please send me a copy of what is in the "reports" folder.

Hi nablee,

I'm sorry to be a bother, but could you send me a copy of all of the file folders that you have for this experiment? I would like to see what you have for both the program files and the data files. Please just make a copy of all the files as you have them on your computer and put them in a compressed zip folder that you can attach to your reply to this message.

Thanks for your patience.

Jason

I don't see any responses.xls file among those that you sent me. Are you still using the responses.xls feature or did you change the structure or your study?

The 'responses.xls' file is in '4' folder. Please see the folder.

Thanks a lot,

Hi Jason,

Did you see my last post? I am wondering if there are any other problems to help me about the 'responses.xls' file.

Please let me know if you need my materials or help.

I really appreciate your help!

Hi nablee,

Thanks for letting me know where the responses.xls file was. I got the calculated values to display properly by moving the responses.xls file out of the 4 folder and putting it in the same folder with the 123experiments.exp file. Give that a try.

It works well!

I really appreciate your help!!! :)

Excellent! And it's my pleasure to help; it is what I'm here for, after all :)

Please don't hesitate to contact me if you have any other questions or issues in the future.

I think I know what the problem is. I had this issue as well. In order to fix it, you should put your SUM variable (escore and elabel) in the cell exactly below the related experimental variables. If you this, the excel file will recognize it and will calculate and return the variable in the participant's screen. But, if you put the calculated variable anywhere else in your response.xls file, like if you put it after all your experimental variables, it will not work. I have checked this several times choosing different cells. I hope MediaLab team fixes this problem in their later versions.

Hope this works for you.
[quote=nablee;19836]Thank you for your effort =)

Unfortunately, it did not work after changing the file name.

the result screen still displayed as follows.
you are <escore> out of 12.
you are <elabel>.

The formula embedded in my excel file seems not to calculate participant's score. Otherwise, 'response' file seems not to be linked to the experiment file.

In fact, the formula is belonged to one que file of the entire 6 que files.

Could you let me get other ways to solve this problem if possible?

Thank you very much.[/quote]

Thanks for the suggestion, rosa.hendijani! If you don't mind me asking, what version of MediaLab are you working with?

[QUOTE=rosa.hendijani;19934]I think I know what the problem is. I had this issue as well. In order to fix it, you should put your SUM variable (escore and elabel) in the cell exactly below the related experimental variables. If you this, the excel file will recognize it and will calculate and return the variable in the participant's screen. But, if you put the calculated variable anywhere else in your response.xls file, like if you put it after all your experimental variables, it will not work. I have checked this several times choosing different cells. I hope MediaLab team fixes this problem in their later versions.

Hope this works for you.[/QUOTE]

Hi, there!

Thanks for leaving your comment, Rosa! That fixed my problem! Jason, I'm using v2012.