Excel Responses File - Failure

[Trevor Newell]

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:

=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:

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:

=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.

[Kyle_Irwin]

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