Hello,
I assume you need this for an online experiment. I have used a simpler solution. I generate a random string for each the participants had to send me via E-Mail. This random string is saved in the data-file giving me the option to check whether somebody took part in the experiment.
letters = ['A','B','C','D','E','F','G','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','1','2','3','4','5','6','7','8','9','0']
shuffle(letters)
vpkode = ''.join(letters[0:8])
Store the code in your data-file:
thisExp.addData('vpkode', vpkode);
At the end of the experiment, I presented a text-component with the following text:
$‘Please note your participant code ’ + vpkode + ’ and send an email containing this code to … \n\n Continue with j’
Unfortunately, the assignment of participant numbers via Excel does not work on-line, but see here for a solution to obtain unique participants numbers.
Best wishes Jens