NEW EDITION ARRIVING IN EARLY 2015
Check this page in late 2014 or ALA Store. You can also contact the authors: ExcelBook@gmail.com.
Welcome to the Analyzing Library Collection Use with Excel wiki page!
Supporting ALA Editions' Analyzing Library Collection Use with Excel by Tony Greiner and Bob Cooper
TO BUY OUR BOOK: ALA Editions has raised the price to $45. You can still get it for $40 or less from Amazon.com, and Barnes and Noble, and probably other online dealers. If they are sold out, you can get it at the ALA STORE.
Upcoming Workshop!
Dec 14, 2010. I will make my third visit to the Northeast Florida Library Information Network (Neflin) in Orange Park, near Jacksonville. Click on the link below to get details on times, cost, and how to sign up.
http://tinyurl.com/2d49dkc
Using Excel 2007- It's easier!
Our book was written for Excel 2003. Excel 2007 to learn how to apply those advances to collection use analysis.
Don't have time to do your own analysis?
Tony Greiner is also starting to do 'analysis for hire.' (aka 'Have Excel, don't need to travel...') If you are interested in hiring him to analyze your library's collection, contact him at tony_greiner@hotmail.com
Reviews of our book:
Booklist Review.pdf (Oct 2007)
Reference & Research Book News (Nov. 2007)
Greiner & Cooper (LMC Jan08).pdf (From "Library Media Connection, Jan 2008)
IFLA Review.pdf (July 2008. Go to second page of the pdf. We're being read in Russia!)
Feel free to edit the wiki with additional short cuts and tips for analyzing library collections. Because there are vandals out there, we ask that you ask permission first.
E-mail us at: excelbook@gmail.com
How your group can book a workshop or talk on collection analysis
Workshops have been presented for:
PORTALS. Portland Area Library Systems.
Ontario Library Association.
Northeast Florida Library Information Network. (2 appearances)
Southeast Florida Library Information Network
Southwest Florida Library Network
Tampa Bay Library Consortium. (2 appearances)
British Columbia Library Association
Comments from Workshop Attendees.
The workshop gave me information that I need to better do my job.
I was able to better understand Excel and felt more comfortable trying new things with it.
Practical information and skills on use of Excel; some good formulas for measuring library usage and good information on displaying information.
Tony is a good teacher.
Tony was great and this class will be very useful and easy to use. I am so glad I took this class.
Instructor was awesome.
It was very informative!
Getting Data from your Integrated Library System.
Downloading Use Statistics from POLARIS
Downloading Use Statistics from Dynix
Millenium's "Create List" feature]
Downloading Use Statistics from Sirsi Unicorn
Downloading Data from SirsiDynix 7 point 3 point 3
Fix for Sirsi programs that don't work with the regular directions
Practice Files and Other Tips.
VBA Clean Up Script
Sample File for Chapter 4
Sample File for Chapter 6
Practice File for Chapter 8
Getting those nice little boxes around the cells
Adding New Page To The Wiki
Comments (1)
Kish said
at 3:22 pm on Dec 10, 2009
I edited one of your review links... it didn't actually link up to the page with the review on it, but now it does. Feel free to re-edit the page so that my name goes away on top and delete this comment. I'm hoping my library system picks up a copy of your book... sounds like just what we need.
You don't have permission to comment on this page.