Picking random excel sheet with code for builder

[bjackson55]

Hello,

I am using the builder, but am trying to add in a line of custom code so that after the instruction screen, the program picks one of the 8 excel sheets in my folder. Each sheet is a different stimulus set order and each participant only needs to complete one of the excel sheet/stimulus sets. Since I am not used to writing code and instead rely on the builder, I am in need of help figuring out how to have my code randomly picking one of the excel sheets to read from.

Any advice is welcome. Thank you.

[jgeller112]

This might be of help to you:

Blocks of trials and counterbalancing

Blocks of trials and counterbalancing Many people ask how to create blocks of trials, how to randomise them, and how to counterbalance their order. This isn’t all that hard, although it does require a bit of thinking! Blocking The key thing to understand is that you should not create different Routines for different trials in your blocks (if at all possible). Try to define your trials with a single Routine. For instance, let’s imagine you’re trying to create an experiment that presents a bloc…