Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 4 of 4

Thread: responses.xls is not working

  1. #1

    responses.xls is not working

    We're having problems with our advanced feature file responses.xls.
    Like in one of the examples we worked out a great excel file and wanted to test it in just one of five trials. The problem is, that it fills in the <variable> wording but that the skip to function doesn't seem to work.
    Concretely, we want to skip only if three answers a like the desired ones (we already made it in the excel file and the report data showed that our idea works). Even though the calculation itself works it doesn't skip.
    The problem seems to be between MediaLab and the Excelfile.

    We thought of some reasons why the communication between th both doesn't work:

    Is it necessary to put all the experiment variables + those that we created in the responses.xls file? Or would it be sufficient to have only the important ones?

    Can you have more than 3 columns (e.g. to create a sum that we need in another calculation) or might this confuse MediaLab?

    Do numbers in the variable names lead to confusion?

    Maybe there's some other reasons but these came to mind although we already tried some different combinations and it didn't improve.

    Thanks in advance

  2. #2
    Join Date
    Nov 2005
    Posts
    3,328
    If the resulting skipto value is included in the third column for the variable in question then it should work. A couple things to check for would be:

    1. you have no blank rows in your responses.xls file
    2. try using lowercase variable names and do this both in your que file and in your xls file.

    If neither of those two suggestions help, then please send me or post a zipped copy of the experiment folder (at least the que and xls files) so I can try to replicate the problem here.

  3. #3
    Thanks for your answer but we already found the solution.
    We changed the calculation and furthermore put the result of the calculation in the third column of an experimental variable instead of the calculation variable (I think this might have been the main problem before) so that it works perfectly now! But thanks, anyway.

    Another question: Is it normal that with responses.xls the change of each display needs a lot of time (1-2 sec.)? We've got a rather long experiment so it's quite disturbing.
    Last edited by jarvis24; 04-06-2009 at 02:34 PM.

  4. #4
    Join Date
    Nov 2005
    Posts
    3,328
    I have seen delays like that. And, yes, I do believe it has been in cases where there have been many variables involved in the study. Not really a way around this aside from faster computers or more efficient program code. Before we release the next version we'll take a look and see if there is anything we can do to speed this up. Also, I assume you are running the study locally on each machine and not across a network? I mention that because that too can slow things down under heavy loads.
    Last edited by jarvis24; 04-06-2009 at 02:40 PM.

Similar Threads

  1. Responses.xls Problem
    By ChrisB in forum MediaLab Older Versions: Troubleshooting
    Replies: 1
    Last Post: 01-30-2009, 02:54 PM
  2. Responses.xls and HTML
    By joshfoster in forum MediaLab Older Versions: How Do I...
    Replies: 1
    Last Post: 07-17-2008, 04:00 PM
  3. responses.xls
    By profpsych in forum MediaLab Older Versions: General Questions
    Replies: 3
    Last Post: 07-07-2008, 11:33 AM
  4. Presenting stimuli in different orders using responses.xls
    By cbrownkramer in forum MediaLab Older Versions: Troubleshooting
    Replies: 3
    Last Post: 04-30-2008, 03:52 PM
  5. responses.xls functions not working
    By jarvis24 in forum MediaLab Older Versions: Troubleshooting
    Replies: 6
    Last Post: 11-17-2006, 11:06 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
  •