ABA Fundamentals

Generating variable and random schedules of reinforcement using Microsoft Excel macros.

Bancroft et al. (2008) · Journal of applied behavior analysis 2008
★ The Verdict

Grab the free Excel macros to create accurate variable and random reinforcement schedules in under a minute.

✓ Read this if BCBAs who run schedule-based studies or noncontingent reinforcement protocols.
✗ Skip if Practitioners who only use fixed-ratio or fixed-interval schedules and never need random timing.

01Research in Context

01

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.

02

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.

03

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.

04

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.

Free CEUs

Want CEUs on This Topic?

The ABA Clubhouse has 60+ free CEUs — live every Wednesday. Ethics, supervision & clinical topics.

Join Free →
→ Action — try this Monday

Download the macro file, open the VT tab, and generate 50 reinforcer times for your next NCR session.

02At a glance

Intervention
not applicable
Design
methodology paper
Finding
not reported

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