[edited by moderator]
I want to use a formula on the responses.xls sheet to reference the question_order.csv sheet in the middle of an experiment. Or at least, that's the only way I can think of to randomize the presentation of 4 stimuli, but then later, show these stimuli again, but in the same order that they were shown the first time within the experiment.
Is this possible? Can you think of other ways if you can't reference questionorder.xls with responses.xls? Again, I want to show, for instance, subject a and b the same four stimuli, 1, 2, 3, and 4. I randomize the presentation, and subject a sees 1,3,4,2 and b sees 2,1,4,3. However, at a later point within their respective sessions, I want to show each subject the stimuli again, and I want a to see 1,3,4,2 and I want b to see 2,1,4,3. It's crucial that each subject sees the stimuli in the same order both times they see the stimuli in the experiment.
thanks!