In this unique guide, two collection development experts show how to use Excel® to translate circulation and collection data into meaningful reports for making collection management decisions. Step-by-step instructions accompanied by screen shots allow anyone to use Excel® to quickly "crunch the numbers" that often bog down library use studies. Analyzing Library Collection Use with Excel® gives library collection analysts the ready tools to This hands-on guide shows how to set up customized spreadsheets and processes all data into usable summaries. Librarians responsible for collection development in public, school, academic, and special libraries will learn why analyzing collection use is important and how they can analyze that use to better serve their patrons.
Another addition to my wishlist, "Analyzing Library Collection Use with Excel" is well worth having, no matter what level or stage of weeding you're in or about to enter. A lot of the suggested reports I'd already been doing, and though the version of Excel used in the samples is dated, the methods and reasoning is still there and still solid. And, of course, there is a level of sass and wit in the pages, that as with another book recently purchased, made me feel like I'd written the book myself in the future for the me of today. Highly recommended for a librarian's personal collection.
I think if I had read this several years ago it would have been more useful. Excel has changed a great deal since it was published in 2007. Still a worthwhile book for those who may not have thought how or what could be analyzed by using Excel. Thank you to Tony and Bob for writing this.
I think this is very useful but it's going to take a while to really put it into practice. I set up a test download of stats just to work through the book the first time and I think I wouldn't have understood it at all without doing that. I'm ordering a copy (got this one on ILL) and will try to make myself use it on parts of the collection.