Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 4 of 4

Thread: Complex Skip Pattern Errors (case 21014)

  1. #1
    Join Date
    Aug 2015
    Posts
    4

    Complex Skip Pattern Errors (case 21014)

    Hi,
    I am trying to develop a complex skip pattern for a psychopathology interview. All questions are answered yes or no and based on the responses or the number of responses in a specific section, the interview will go in different directions.

    I have created simple skips directly in medialab (i.e. If 1a is yes, skip to question 2, if 1a is no, go to 1b). I have now created a responses.xls file for complex skips and I am trying to figure out the appropriate formula.

    Section A is divided into two parts. The first part has 8 questions. If none of the questions have a yes answer, the participant is taken directly to section B. If any of the 8 questions are answered yes, the participant continues on to the next question in section A. Medialab exports no answers as a 1 and yes's as a 2 into excel so I created the formula:

    =IF(SUM(A5:A12)>8,"ADHDa05","ADHDb1a")
    With cell A5 being the first question in section A and cell A12 being the 8th. ADHDa05 is the variable name for the second half of section A and ADHDb1a is the 1st variable in section B.

    When I run medialab, if all questions are answered no, it responds appropriately and if all answers are yes, it responds appropriately. However, if there is a combination of yes's and no's, medialab skips the rest of Section A while those questions actually need to be asked.

    Last edited by jason_reed; 09-24-2015 at 12:12 PM.

  2. #2
    Join Date
    Feb 2013
    Posts
    1,093
    What are the formulas in the responses.xls file like this supposed to do?

    =IF(AND(A5=1, A6=1, A7=1, A8=1, A9=1, A10=1, A11=1, A12=1), A20, A13)
    Jason Reed
    Empirisoft Software Support Specialist

  3. #3
    Join Date
    Aug 2015
    Posts
    4
    The variables in cells A5 through A12 are Yes/No questions. If the participant answers "No" to all 8 questions, there should be a skip to Cell A20, but if 1 or more questions in A5-A12 are answered "Yes," the questionnaire should continue to cell A13.

  4. #4
    Join Date
    Feb 2013
    Posts
    1,093
    If you would like, please send me copies of your files and I will be happy to take a look. You can upload them here or send them to support@empirisoft.com; please reference case 22104 in the email.
    Jason Reed
    Empirisoft Software Support Specialist

Similar Threads

  1. Complex permanent background
    By baruche in forum DirectRT Older Versions: How Do I...
    Replies: 0
    Last Post: 11-02-2011, 05:55 PM
  2. do a super-complex randomization?
    By Tine in forum MediaLab Older Versions: How Do I...
    Replies: 6
    Last Post: 10-28-2010, 05:04 PM
  3. Variable Message appears during skip pattern, closes questionnaire
    By Eli08 in forum MediaLab Older Versions: Troubleshooting
    Replies: 2
    Last Post: 08-06-2008, 12:00 PM
  4. Create a Conditional Skip Pattern?
    By cazessus in forum MediaLab Older Versions: How Do I...
    Replies: 6
    Last Post: 10-15-2007, 10:35 AM
  5. randomizing within a fixed alternating pattern
    By Michal in forum DirectRT Older Versions: How Do I...
    Replies: 7
    Last Post: 04-20-2007, 02:44 PM

Posting Permissions

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