Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 3 of 3

Thread: Excel Responses File - Failure

  1. #1
    Join Date
    Feb 2008
    Posts
    16

    Excel Responses File - Failure

    I'm using MediaLab 2006 and Windows Vista. I've programmed a responses file to feedback some score calsulated in Excel. I had it working yesterday, but today it doesn't work. I've got a fill in the blank event labeled "est1" and in Excel I have "est1" and then "f1" and "a1" - both of which get caluclated in Excel. Then on the next event in MediaLab I feedback the scores using "<f1>" and "<a1>". If data is entered into the fill in the blank event, the feedback screen displays for 7 seconds (as I've programmed it) but nothing is displayed (not the content nor the f1 and a1 values). Its very strange. Also, if I press Ctrl + -> (right arrow) during the "est1" fill in the blank event, the feedback frame content is displayed, but with values calculated as if 0 was entered into the fill in the blank event. So, if no response is given you get feedback, but if a respons is given you don't get any feedback - what gives? Has anyone had problems with this kind of thing? I'm beginning to think its not a Vista problem as the same occurs on an Windows XP computer. Also, I've kept the Excel file as a 2003-2007 file with the "xls" extension rather than the "xlsx" extension. John Petrocelli
    Attached Files Attached Files
    Last edited by petrocjv; 10-07-2009 at 04:31 PM.

  2. #2
    Join Date
    Mar 2009
    Posts
    401
    Hm - it would seem that the problem is stemming from the value being stored as 'xxdots' rather than simply 'xx' - Because of this, each field can't appropriately calculate the required values. I've thought of two possible solutions for this problem:

    1. Remove the extra characters from the end of the string. Ie. rather than 'xxdots', simply use 'xx'. You won't be able to have the text displayed with the fill-in-the-blank item; however you'll be able to properly save the value, and the value alone.

    2. Change the way the other excel fields parse each variable. The current equation for B6 is as followed:
    Code:
    =IF(B2>B5,(100-(((B2-B5)/B5)*100)),(100-((B5-B2)/B5)*100))
    If B2's value read 23dots, the equation above would fail. To overcome this, you could swap each B2 variable with the following:
    Code:
    INT(MID(B2,1,2))
    This syntax will parse the value in the B2 cell, convert this parsed value to an integer, and then use the converted integer in the equation. The original equation would then look like:
    Code:
    =IF(INT(MID(B2,1,2))>B5,(100-(((INT(MID(B2,1,2))-B5)/B5)*100)),(100-((B5-INT(MID(B2,1,2)))/B5)*100))
    You'll need to do this for each 'est' variable.

    Does this help solve the problem? Please let me know if you have any additional questions or if I can help in any way.

  3. #3
    Join Date
    Jan 2011
    Posts
    4
    Hi There,
    I'm having a similar issue as the one stated above...during the experiment participants make a couple of decisions and as a result earn points. In the study I twice show how many points they've earned as a result of their own and (fictitious) others' choices. The screen and calculated values for the first decision work fine. However, the screen that's supposed to show calculated values after the second decision is blank (screen 63) - that is, no text or calculated values appear.
    Any ideas?
    Thanks,
    Kyle
    Attached Files Attached Files

Similar Threads

  1. Responses xls file
    By clare66 in forum MediaLab Older Versions: General Questions
    Replies: 0
    Last Post: 09-15-2009, 12:28 PM
  2. 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
  3. Negative time values in Log file & out-of-range responses recorded
    By deconroy in forum DirectRT Older Versions: Troubleshooting
    Replies: 5
    Last Post: 05-14-2008, 04:19 PM
  4. need more columns in excel
    By bhammoud in forum DirectRT Older Versions: How Do I...
    Replies: 2
    Last Post: 02-25-2008, 10:34 AM
  5. Lexical Decision Task for Success/Failure Focus
    By joshfoster in forum DirectRT Older Versions: Sharing Area
    Replies: 0
    Last Post: 09-15-2006, 01:45 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
  •