Computer Spreadsheets for Library Applications, 2nd Edition

By using software programmes in Computer Spreadsheets for Library Applications librarians should be able to quickly and easily build spreadsheets for budgetary and other quantitative analysis. Using library terminology, the author shows users who are familiar with microcomputers how to translate familiar library statistical compilations into automated, appealing spreadsheet formats. In this revised and updated second edition of his original Electronic Spreadsheets for Libraries , Auld presents 35 spreadsheet models in which real or imaginary what if data can be assembled, analysed, and displayed. New to this edition are chapters in three-dimensional spreadsheets; macros, graphics, word processing and databases; fines; grades, salaries by sources of funding; an expanded section on circulation; CD-ROM use; preservation values; reference work values; and random numbers. The book also covers budgets, currency exchange rates and estimating shelving capacity. Each spreadsheet is presented in two ways: first in expanded cell-by-cell instructions which contain no data but widen and identify cell columns and rows and display all formulas; and then in tables as the completed spreadsheet with data in place. Two and three-dimensional spreadsheet software applications are included for most examples.