Generating variable and random schedules of reinforcement using Microsoft Excel macros.
Grab the free Excel macros to create accurate variable and random reinforcement schedules in under a minute.
01Research in Context
What this study did
Matson et al. (2008) wrote six Excel macros that spit out reinforcement times. You pick VR, VI, VT, RR, RI, or RT. The sheet fills itself with numbers you can paste into any program.
No math by hand. No dice rolls. Just open the file, choose how many times you need, and copy the column.
What they found
The macros work. They give the right mix of short and long waits for each schedule type. You get the same spread the textbooks say you should.
How this fits with other research
Long (1963) first worked out the math for random-interval schedules. The 2008 macros turn that old paper into one-click numbers.
Meuret et al. (2001) showed VT and FT noncontingent reinforcement cut behavior the same. Jones et al. (2025) later found VT beats FT when staff miss deliveries. Both teams could use these macros to build their VT lists fast.
Kelley et al. (2023) thinned NCR quickly with signaled multiple schedules. Their method still needs RI or RT values; the macros make them in seconds.
Why it matters
Stop wasting minutes rolling dice or typing fake times. Download the free file, pick your schedule, and paste the column into your data sheet. You get clean, correct timings for any VR, VI, VT, RR, RI, or RT study you run next week.
Want CEUs on This Topic?
The ABA Clubhouse has 60+ free CEUs — live every Wednesday. Ethics, supervision & clinical topics.
Join Free →Download the macro file, open the VT tab, and generate 50 reinforcer times for your next NCR session.
02At a glance
03Original abstract
Variable reinforcement schedules are used to arrange the availability of reinforcement following varying response ratios or intervals of time. Random reinforcement schedules are subtypes of variable reinforcement schedules that can be used to arrange the availability of reinforcement at a constant probability across number of responses or time. Generating schedule values for variable and random reinforcement schedules can be difficult. The present article describes the steps necessary to write macros in Microsoft Excel that will generate variable-ratio, variable-interval, variable-time, random-ratio, random-interval, and random-time reinforcement schedule values.
Journal of applied behavior analysis, 2008 · doi:10.1901/jaba.2008.41-227