Libraries never seem to have enough money or time. Unfortunately, finding the balance can be tricky. Because of the money shortage, we should review each subscription renewal. However, we often don’t have time to individually review hundreds (or thousands) of renewals each year. This poster will outline how one library automated its approximately 2,500 subscription renewals to the point that a classified staff member can simply enter the price into a spreadsheet and get an immediate decision if s/he should renew a title or if the title needs to be escalated directly to a subject selector for review because of a significant increase in cost or high cost per use.

The Two Second (Data-Driven) Renewal: Automating Renewal Decisions Using Excel