Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 3 of 3

Thread: Output File Issues excel spreadsheet (case 17316)

  1. #1

    Output File Issues excel spreadsheet (case 17316)

    I am using MediaLab 2014

    PROBLEM:

    I encountered a strange situation in which it seems that new variables were created (or automatically generated) in the outputfiles. These variables are not present in the experiment but are rather variations of variables. The exact variables were labeled SANuniq1, SANuniq2, SANuniq3, SANuniq4, but what appeared in the output files was SANuniq1_01, SANuniq1_02, SANuniq1_03, SANuniq1_04... then SANuniq2_01, SANuniq2_02 etc., thereby turning my 4 item scale into 16 and miss labeling every variable following and causing other variables to do the same thing: ntbs1 became ntbs1_01, ntbs1_02, ntbs1_03, ntbs1_04, ntbs1_05 but then did it for all ntbs variables 1-10 creating 50 variables rather than the 10. This happened for several variables on several computers (we have 34 computers used for data collection). I thought that by relabeling them SANuniq1_01 to SANuniq1 and SANuniq1_02 to SANuniq2 that I could save all the data collected but its a very long process as SANuniq1 was the 64th out of 210 different lines in the questionnaire. I will still be looking into that.


    SOLUTION?:

    What I have done is go in and cut out the extra variables that were generated and save the excel spreadsheet. I then took the survey several times with different answers (we are using a lot of randomizing) and it seemed to be working. BUT there are a couple places where the participant should be seeing "Instructions" but instead of an "ok" or "99" to indicate that they did see or did not see those interactions a couple of times it has a number such as 5. It isn't possible to respond with a number to instructions. It seems that all subsequent questions are off by one place. I can't figure out though why it is off by one and at the very end of the spread sheet the last number in those rows is in its own column with no label.
    Last edited by jason_reed; 12-01-2014 at 02:00 PM.

  2. #2

    Spreadsheet with the above mentioned issue

    Here is the spreadsheet with some highlight in the places I noticed were off. Either it was impossible to answer because it was instructions or a video, or it was a question that required a response (such as 1 - 5) and ended up saying "ok" instead.
    STUDY1B_EXP_withhighlights.csv
    Last edited by jason_reed; 12-01-2014 at 02:00 PM.

  3. #3
    Join Date
    Feb 2013
    Posts
    1,093
    Can you please upload a copy of the .que files that go with the previously uploaded output sheet? If you would rather send them to me directly, please send them to support@empirisoft.com and refer to case 17316 in the email.
    Jason Reed
    Empirisoft Software Support Specialist

Similar Threads

  1. Excel Responses File - Failure
    By petrocjv in forum MediaLab Older Versions: Troubleshooting
    Replies: 2
    Last Post: 09-22-2011, 11:35 AM
  2. Connect my experiment with en Excel file?
    By Entscheidungen in forum MediaLab Older Versions: How Do I...
    Replies: 0
    Last Post: 03-10-2010, 05:21 AM
  3. importing essay data into an Excel file
    By tonyhermann in forum MediaLab Older Versions: General Questions
    Replies: 6
    Last Post: 02-08-2010, 09:56 AM
  4. Variable names missing in Excel file, probably due to testing?
    By edlemay in forum MediaLab Older Versions: Troubleshooting
    Replies: 1
    Last Post: 10-01-2008, 03:49 PM

Tags for this Thread

Posting Permissions

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