I am working with the following types of datasets:
TRIAL_LABEL IA_LABEL IA_FIRST_FIXATION_TIME
Trial: 1 bouche 932
Trial: 1 nez 376
Trial: 1 nez2 568
Trial: 1 oeil 2476
Trial: 1 oeil2 1312
Trial: 1 sourcils .
Trial: 1 sourcils2 .
Trial: 1 centresourcils 244
Trial: 1 joues 732
Trial: 1 joues2 .
Trial: 1 menton .
Trial: 2 bouche 856
Trial: 2 nez 684
Trial: 2 nez2 .
Trial: 2 oeil 448
Trial: 2 oeil2 1504
Trial: 2 sourcils .
Trial: 2 sourcils2 6116
Trial: 2 centresourcils 264
Trial: 2 joues .
Trial: 2 joues2 5404
Trial: 2 menton .
Trial: 3 bouche .
Trial: 3 nez 404
Trial: 3 nez2 248
Trial: 3 oeil 4532
Trial: 3 oeil2 3644
Trial: 3 sourcils .
Trial: 3 sourcils2 .
Trial: 3 centresourcils .
Trial: 3 joues .
Trial: 3 joues2 1084
Trial: 3 menton .
Trial: 4 bouche 1272
Trial: 4 nez 4484
Trial: 4 nez2 2920
Trial: 4 oeil 396
Trial: 4 oeil2 728
Trial: 4 sourcils 3948
Trial: 4 sourcils2 4220
Trial: 4 centresourcils 240
Trial: 4 joues 4952
Trial: 4 joues2 .
Trial: 4 menton .
Trial: 5 bouche 964
Trial: 5 nez 544
Trial: 5 nez2 268
Trial: 5 oeil 4180
Trial: 5 oeil2 1940
Trial: 5 sourcils 6444
Trial: 5 sourcils2 5476
Trial: 5 centresourcils .
Trial: 5 joues .
Trial: 5 joues2 .
Trial: 5 menton .
Trial: 6 bouche 260
Trial: 6 nez 584
Trial: 6 nez2 .
Trial: 6 oeil .
Trial: 6 oeil2 .
Trial: 6 sourcils .
Trial: 6 sourcils2 .
Trial: 6 centresourcils .
Trial: 6 joues 1308
Trial: 6 joues2 1024
Trial: 6 menton .
Trial: 7 bouche 1212
Trial: 7 nez 5532
Trial: 7 nez2 .
Trial: 7 oeil 2068
Trial: 7 oeil2 1588
Trial: 7 sourcils .
Trial: 7 sourcils2 8188
Trial: 7 centresourcils 7004
Trial: 7 joues .
There are 96 trials in total and each are labelled (IA Label) as shown above. I need to create a calculation sheet to input these data files into so that excel will organize the data by selecting the smallest fixation time for each part of the face (bouche, nez, oeil, sourcils, joues and menton) for each trial number (1 through 96). The final dataset needs to have the trials 1 to 96 in a column with the lowest value for each face part in the coinciding rows. I am just learning to program in Excel and this is far to complicated for me to figure out at this point, so any input would be greatly appreciated!!!
Thanks in advance!
Emma
TRIAL_LABEL IA_LABEL IA_FIRST_FIXATION_TIME
Trial: 1 bouche 932
Trial: 1 nez 376
Trial: 1 nez2 568
Trial: 1 oeil 2476
Trial: 1 oeil2 1312
Trial: 1 sourcils .
Trial: 1 sourcils2 .
Trial: 1 centresourcils 244
Trial: 1 joues 732
Trial: 1 joues2 .
Trial: 1 menton .
Trial: 2 bouche 856
Trial: 2 nez 684
Trial: 2 nez2 .
Trial: 2 oeil 448
Trial: 2 oeil2 1504
Trial: 2 sourcils .
Trial: 2 sourcils2 6116
Trial: 2 centresourcils 264
Trial: 2 joues .
Trial: 2 joues2 5404
Trial: 2 menton .
Trial: 3 bouche .
Trial: 3 nez 404
Trial: 3 nez2 248
Trial: 3 oeil 4532
Trial: 3 oeil2 3644
Trial: 3 sourcils .
Trial: 3 sourcils2 .
Trial: 3 centresourcils .
Trial: 3 joues .
Trial: 3 joues2 1084
Trial: 3 menton .
Trial: 4 bouche 1272
Trial: 4 nez 4484
Trial: 4 nez2 2920
Trial: 4 oeil 396
Trial: 4 oeil2 728
Trial: 4 sourcils 3948
Trial: 4 sourcils2 4220
Trial: 4 centresourcils 240
Trial: 4 joues 4952
Trial: 4 joues2 .
Trial: 4 menton .
Trial: 5 bouche 964
Trial: 5 nez 544
Trial: 5 nez2 268
Trial: 5 oeil 4180
Trial: 5 oeil2 1940
Trial: 5 sourcils 6444
Trial: 5 sourcils2 5476
Trial: 5 centresourcils .
Trial: 5 joues .
Trial: 5 joues2 .
Trial: 5 menton .
Trial: 6 bouche 260
Trial: 6 nez 584
Trial: 6 nez2 .
Trial: 6 oeil .
Trial: 6 oeil2 .
Trial: 6 sourcils .
Trial: 6 sourcils2 .
Trial: 6 centresourcils .
Trial: 6 joues 1308
Trial: 6 joues2 1024
Trial: 6 menton .
Trial: 7 bouche 1212
Trial: 7 nez 5532
Trial: 7 nez2 .
Trial: 7 oeil 2068
Trial: 7 oeil2 1588
Trial: 7 sourcils .
Trial: 7 sourcils2 8188
Trial: 7 centresourcils 7004
Trial: 7 joues .
There are 96 trials in total and each are labelled (IA Label) as shown above. I need to create a calculation sheet to input these data files into so that excel will organize the data by selecting the smallest fixation time for each part of the face (bouche, nez, oeil, sourcils, joues and menton) for each trial number (1 through 96). The final dataset needs to have the trials 1 to 96 in a column with the lowest value for each face part in the coinciding rows. I am just learning to program in Excel and this is far to complicated for me to figure out at this point, so any input would be greatly appreciated!!!
Thanks in advance!
Emma