Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 15 of 15

Thread: responses.xls (case 9123)

  1. #1

    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,

  2. #2
    Join Date
    Feb 2013
    Posts
    1,093
    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
    Jason Reed
    Empirisoft Software Support Specialist

  3. #3
    Join Date
    Feb 2013
    Posts
    1,093
    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.
    Jason Reed
    Empirisoft Software Support Specialist

  4. #4

    I have still trouble.

    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.

  5. #5
    Join Date
    Feb 2013
    Posts
    1,093
    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.
    Jason Reed
    Empirisoft Software Support Specialist

  6. #6
    Join Date
    Feb 2013
    Posts
    1,093
    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
    Jason Reed
    Empirisoft Software Support Specialist

  7. #7
    Join Date
    Feb 2013
    Posts
    1,093
    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?
    Jason Reed
    Empirisoft Software Support Specialist

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

    Thanks a lot,

  9. #9
    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!

  10. #10
    Join Date
    Feb 2013
    Posts
    1,093
    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.
    Jason Reed
    Empirisoft Software Support Specialist

  11. #11
    It works well!

    I really appreciate your help!!!

  12. #12
    Join Date
    Feb 2013
    Posts
    1,093
    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.
    Jason Reed
    Empirisoft Software Support Specialist

  13. #13
    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 Originally Posted by nablee View Post
    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.

  14. #14
    Join Date
    Feb 2013
    Posts
    1,093
    Thanks for the suggestion, rosa.hendijani! If you don't mind me asking, what version of MediaLab are you working with?
    Jason Reed
    Empirisoft Software Support Specialist

  15. #15
    Join Date
    Jun 2013
    Posts
    12
    Quote Originally Posted by rosa.hendijani View Post
    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.
    Hi, there!

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

Similar Threads

  1. responses.xls
    By trab24 in forum DirectRT Older Versions: Troubleshooting
    Replies: 0
    Last Post: 03-30-2011, 04:33 PM
  2. Can questionorder.xls be referenced by responses.xls formula during a session?
    By samjacks7986 in forum MediaLab Older Versions: How Do I...
    Replies: 2
    Last Post: 04-27-2009, 03:29 PM
  3. responses.xls is not working
    By bam in forum MediaLab Older Versions: Troubleshooting
    Replies: 3
    Last Post: 04-06-2009, 02:37 PM
  4. Responses.xls and HTML
    By joshfoster in forum MediaLab Older Versions: How Do I...
    Replies: 1
    Last Post: 07-17-2008, 04:00 PM
  5. responses.xls
    By profpsych in forum MediaLab Older Versions: General Questions
    Replies: 3
    Last Post: 07-07-2008, 11:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •