Repeats_2.xlsx has columns called part_1, part_2 and part_3. It doesn’t have familiarisation_practice. Try changing the trials_3 conditions to $part_1 + '.xlsx'
it works now! Thank you! Sorry for making silly mistakes, still very new.
I do have a question, since part_1 isn’t an excel file, how come it works when ‘.xlsx’ is attached to the end of it?
part_1 is the top cell of a column in Repeats_2.xlsx.
When a loop loads a spreadsheet it uses the top row as a list of variable names.
Think of a variable as a question and the values it can take as possible answers.
part_1 is the question “what spreadsheet would you like to use in the familiarisation phase (trials)3)?”
familiarisation_practice is one of the possible answers to that question.
At the moment I note that trials_4 is set to random. If you want the practice to come first you should select sequential.
i see, so its saying, refer to the column name part_1 and take the variables in that column and add ‘.xlsx’ rather than adding it onto part_1
Yes, i changed it to sequential so they go in order.
Thank you again for your help and your time.
Correct. Please could you select which of my posts is most appropriate as the solution to mark this topic as solved?