Alternating between two excel conditions in a loop


Here’s what I got so far for my experiment. In my experiment, I am trying to manipulate the retention interval. There are 2 conditions and they both last 12 seconds. In Fast condition, conds_12_opa, the color’s opacity suppose to change every second where 1 second it will be light blue and in 2 seconds, it will be dark blue. In Slow condition, conds_4_opa, the color’s opacity supposed to change every 3 seconds. I create two excel files(conds_4_opa, conds_12_opa) and imported it. I want the program to alternate between the two excel files depending on the colorChanges from the excel condition, thesis_YesSlash_A. If the colorChanges 4, then the program needs to pick conds_4_opa as the loop to run and not conds_12_opa. And if the colorChanges is 12, then the program needs to pick conds_12_opa. I tried this, and it didn’t work. I attached the excel file for reference.

conds_4_opa.xlsx (8.7 KB)

conds_12_opa.xlsx (8.7 KB)
thesis_slashYes_A_both.xlsx (10.0 KB)

Thank you so much in advance,

Augustine