The Optimized Library: Phased Renovation Schedule

How to get the renovations your library wants with the budget it has

Posted on September 28, 2026 in Videos

Authors:

Sam Suber
A librarian creating a budget for phased renovations

“The Optimized Library: Solving the Puzzles of Modern Library Management” is a video series from LibTech Insights, hosted by Sam Suber, Electronic Resources Coordinator at Moraine Valley Community College Library. In this series, Sam explores how mathematical optimization empowers libraries to make smarter, value-driven decisions when facing today’s complex operational hurdles. Check out Sam’s previous work.

All libraries would love to receive a lump-sum donation to completely renovate their facilities, but in reality, most have to reconcile their upgrades with their annual budgets. In this video, Sam shows how to use Microsoft Excel Solver to generate a multiyear renovation schedule that stays within budget, limits lengthy construction periods, and transforms a laundry list of upgrades into an actionable plan.

For more background on Microsoft Excel Solver, refer to Sam’s post, “Maximizing Impact: Using Excel Solver for Optimal Library Budgeting.”

🚀 Subscribe to Choice’s YouTube channel

Subscribe to the LibTech Insights newsletter 🌟

Related Posts