A tutorial on the use of Excel 2010 and Excel for Mac 2011 for conducting delay-discounting analyses.

Lerner et al. (2012) wrote a how-to guide. It shows every click to turn delay-discounting numbers into clean graphs in Excel 2010 or Excel for Mac 2011.

The paper gives ready-made macro steps. You paste your data, run the macro, and the sheet spits out the curve and area-under-the-curve value.

There are no new data here. The authors simply prove the macro works by walking through one example file.

The take-away is speed: following the steps builds a publish-ready discounting graph in under five minutes.

Chok (2019) and Deochand et al. (2015) are direct successors. They keep the same click-by-click style but update it for newer Excel versions and different graph needs—functional-analysis charts and phase-change lines.

Lehardy et al. (2021) extends the idea into training. They paired a short Excel video with a checklist and watched master’s students jump from 25% to 96% graph accuracy, showing the tutorial format can teach real skills.

Morris et al. (2018) and Deochand (2017) move sideways. They use the same Excel platform to build data sheets or auto-insert phase lines, proving one toolbox can serve many ABA chores.

If you run delay-discounting assessments, this macro kills the busywork. You skip manual curve drawing and the sheet calculates area-under-the-curve for you. Download the file once, then plug in client data whenever insurance or a grant report needs a picture of self-control. Pair it with the newer training packages if you supervise students—they can learn the whole workflow in fifteen minutes.