Robert W. Weeks bob.weeks@cox.net, http://members.cox.net/bob.weeks
PAD is a system that tracks and analyzes the costs of periodical use at a university library.
After a library patron uses a periodical, a clerk scans a barcode from the issue. This scan data, representing uses of periodicals, provides the basis for use analysis. Besides usage data, PAD also tracks a number of other items such as journal cost and subjects covered.
The library uses PAD for two purposes. One is to track information about each journal. The second is as a decision support system to support the process of adding and deleting journal subscriptions.
PAD was developed using Borland Paradox for DOS. The librarian responsible for the system received a State of Kansas Employee Suggestion Award of $5,000, the maximum award possible. For more information about PAD, email me (Robert Weeks) at bob.weeks@cox.net.
The focus of PAD is the journal screen, which store the main data for each journal or periodical. Page one of the journal screen shows basic data about each journal along with its usage. These usage numbers are calculated from the scan data.
PAD Journal screen, page 1
Page two of the journal screen shows additional data about each journal such as the librarians responsible, the subjects covered, the indices the journal apperas in, and the libraries that hold this journal.
PAD Journal screen, page 2
Page three shows so data relating to the journal's academic use, along with the university programs that make use of the journal.
PAD Journal screen, page 3
With a large collection, finding a journal needs to be quick. The following illustration shows the PAD journal lookup screen, which lets the user move to a journal by scanning through any column, such as the ISSN or title.
PAD Journal Lookup
Besides producing a number of prepared reports, PAD also lets users use Paradox's query-by-example facility to pose their own ad hoc queries. PAD stores these queries so that users can quickly pose them again. Users can view, print, or export the extracted data to a variety of formats, including spreadsheets.
PAD Query-by-example
One of the main PAD reports is the Journal Summary, which presents most of the information known for each journal.
7/23/94 Journal Summary Page 1
QA76A772 Communications of the A C M
Publisher
ISSN 0001-0782 Location CPR Refereed No ISI Impact Factor
Funding Source 2017 COMPUTER SCIENCE
NOFA 291PQA1 Periodicity 40 Current Current
12 Month Total
Current Issue 24 57 Cost per Use, CI only 1.75
Bound Volume 12 14 Cost per Use, CI and BV 1.17
Annual Cost 42.00 Expenditure YTD 1985 Cost 18.00
Status Previous ISSN Update 1/06/94
CCR 80
UGF 107
Remarks
(none)
Indices
(none)
Libraries
(none)
Librarians Subjects
1 Kathy Payne 206 CS COMPUTER SCIENCE
12 Tom DePetro 216 SCIR SCIENCE REFERENCE
268 EE ELECTRICAL ENGINEERING
Programs
(none)
Monthly Use
Month Current Issue Bound Volume Total Use
2/93 2 2
3/93 3 3
4/93 5 5
5/93 1 1
6/93 2 1 3
7/93 4 1 5
8/93 1 1
9/93 2 2
10/93 4 4 8
11/93 2 1 3
1/94 3 3
2/94 5 7 12
3/94 3 3
6/94 4 4
The Administrative Oversight report presents use data summarized by LC (Library of Congress) class, along with a projection of total uses for the fiscal year.
Administrative Oversight Report
Run Date: July 23, 1994
-------------------------------
The current survey of journals' use indicates that 3290 titles have
been used at least one time since the beginning of the current 12
months. Inferentially, 1498 titles have not been used at all.
403 titles show only bound volume use, and 1097 titles have been
used less than three times.
All current issues are presently surveyed. However, N/A titles are
deleted from the bound volume survey because of either extremely
high use or extremely low cost. Total periodicals collection
use is now projected to be 63590 uses for the current survey
period. Bound volume survey is now being done for classes Q-Z only.
-------------------------------
Use by subject categories indicates the following:
Total Title
LC Class Use Total Cost Cost/Use Count
------------------------ ------- ------------ -------- -----
42 0.00 219
AG Gen. ref. 0 118.00 118.00 3
AM Museums 8 152.00 19.00 3
AP General 7,105 4,731.76 .67 120
AS L.Societies 123 778.31 6.33 28
B Philosophy 102 3,683.42 36.11 46
BC Logic 0 331.25 331.25 4
BF Psychology 939 16,852.07 17.95 108
BH Aesthetics 4 104.00 26.00 1
BJ Ethics 9 80.00 8.89 2
BL Religion 16 337.00 21.06 7
BM Judaism 0 0.00 0.00 7
BR Christianity 102 581.91 5.71 16
BS Bible 59 745.12 12.63 12
BV Theology 2 280.00 140.00 2
D History 273 5,553.14 20.34 42
DG Hist. Italy 10 49.43 4.94 2
DK Hist. Russia 38 1,001.47 26.35 13
TS Production 758 3,847.02 5.08 36
TX Home Ec. 467 438.87 .94 12
U Military Science 6 0.00 0.00 1
UG Military Eng. 159 24.50 .15 1
V Naval Science 219 670.00 3.06 4
Z Bibliography 1,138 12,987.39 11.41 141
--------- ------------ -------- ------
Totals 63,590 735,670.80 11.57 4,788
Adjustment 0
---------
Grand Total 63,590
###
The Cost Calculations and Projections report looks at the past history of journal costs and projects future costs.
7/23/94 Cost Calculations and Projections Page 1
1985 Current Total Annual 1993 Total Cost of Proj. Avg Proj. Total Proj. Total
LC Description Avg Price Avg Price Increase Increase Titles Class for 1993 Price 1994 Cost for 1994 Cost for 1995
--- -------------- ---------- ---------- ------- ------- ------- -------------- ---------- ------------- -------------
76.93% 7.39% 219 0.00 0.00 0.00
AG Gen. ref. 31.00 39.33 26.88% 3.02% 3 118.00 40.52 121.56 125.24
AM Museums 38.15 50.67 32.81% 3.61% 3 152.00 52.50 157.49 163.17
AP General 32.00 39.43 23.22% 2.64% 120 4,731.76 40.47 4,856.90 4,985.35
AS L.Societies 20.96 27.80 32.62% 3.59% 28 778.31 28.80 806.27 835.22
B Philosophy 54.22 80.07 47.68% 4.99% 46 3,683.42 84.07 3,867.39 4,060.55
BC Logic 60.33 110.42 83.02% 7.85% 4 441.67 119.08 357.25 385.28
BD Spec. Phil. 0.00 223.75 76.93% 7.39% 1 223.75 240.29 240.29 258.05
BF Psychology 77.86 157.50 102.28% 9.21% 108 17,009.57 171.99 18,403.38 20,097.50
BH Aesthetics 50.61 104.00 105.49% 9.42% 1 104.00 113.80 113.80 124.52
DC Hist. France 22.59 60.84 169.31% 13.18% 3 182.51 68.86 206.57 233.80
DD Hist. Ger. 79.88 39.37 76.93% 7.39% 5 196.83 42.28 211.38 227.01
DE Hist. Med. 24.20 42.50 75.62% 7.29% 2 85.00 45.60 91.20 97.85
DK Hist. Russia 33.31 77.04 131.27% 11.05% 13 1,001.47 85.55 1,112.12 1,235.00
DR Hist. Balkans 0.00 0.00 76.93% 7.39% 1 0.00 0.00 0.00 0.00
DS Hist. Asia 40.26 14.82 76.93% 7.39% 36 533.35 15.91 572.78 615.12
DT Hist. Africa 54.26 71.90 32.51% 3.58% 5 359.50 74.47 372.37 385.71
DU Hist. Oceania 25.79 44.69 73.29% 7.11% 4 178.77 47.87 191.49 205.11
E Am. Hist. 27.93 30.04 7.55% .91% 51 1,531.95 30.31 1,545.95 1,560.07
F U.S. Hist. 17.47 22.09 26.42% 2.97% 76 1,678.52 22.74 1,728.44 1,779.84
G Geography 36.67 50.01 36.38% 3.95% 26 1,300.23 51.99 1,351.64 1,405.09
GA Cartography 0.00 0.00 76.93% 7.39% 1 0.00 0.00 0.00 0.00
H Social Scie. 49.50 94.88 91.67% 8.47% 50 4,743.86 102.92 5,042.86 5,470.12
HA Statistics 44.67 91.94 105.82% 9.44% 20 1,838.80 100.62 2,012.43 2,202.45
HB Economics 72.18 128.68 78.28% 7.49% 44 5,662.07 138.33 6,086.44 6,542.62
HF Commerce 42.73 71.49 67.31% 6.64% 161 11,509.98 76.24 12,198.55 13,009.11
HG Finance 66.75 122.75 83.89% 7.91% 92 11,292.84 132.46 12,053.89 13,007.62
HJ Pub. Finance 67.56 96.57 42.93% 4.57% 18 1,738.18 100.97 1,817.55 1,900.54
HM Sociology 61.63 118.84 92.83% 8.55% 42 4,991.39 129.01 5,418.37 5,881.88
HN Soc. Hist. 38.59 95.23 146.77% 11.95% 11 1,047.50 106.61 1,172.71 1,312.88
HQ Family 62.08 113.25 82.42% 7.80% 62 7,021.34 122.09 7,569.28 8,159.98
HT Urban Soc. 84.58 125.35 48.21% 5.04% 18 2,256.35 131.67 2,370.09 2,489.56
HX Socialism 51.20 24.50 76.93% 7.39% 10 245.00 26.31 263.11 282.56
JC Political Theo 0.00 0.00 76.93% 7.39% 1 0.00 0.00 0.00 0.00
TP Chemical Eng. 125.77 327.33 160.26% 12.70% 35 11,456.66 368.91 12,911.74 14,551.62
TS Production 55.39 106.86 92.93% 8.56% 36 3,847.02 116.01 4,176.36 4,533.90
TX Home Ec. 37.87 36.57 76.93% 7.39% 12 438.87 39.28 471.31 506.16
UA Armies 0.00 8.33 76.93% 7.39% 3 25.00 8.95 26.85 28.83
UG Military Eng. 15.00 24.50 63.33% 6.32% 1 24.50 26.05 26.05 27.70
Z Bibliography 110.09 93.43 76.93% 7.39% 141 13,174.26 100.34 13,947.50 14,978.58
------- -------------- ------------ ------------
Totals 4,788 739,886.46 793,038.98 855,258.50
Average Total Price Increase is 76.93 %
###
The Comprehensive Subject Report lists, for each journal, the librarians involved with a journal (marking the primary librarian), the academic departments that use the journal, the curricular emphasis, and level of student use.
7/23/94 Comprehensive Subject Report Page 1
Subject: 202 BIOCHEMISTRY
Title Librarians Department Emphasis Level
----------------------------------------------------- ------------------- ---------------------- -------- -----
QD1B55 Biochimica Et Biophysica Acta 1* CHEMISTRY Co/Re G/F
QD95B56 Biomedical and Environmental Mass CHEMISTRY
Spectrometry
QD95B56 Biological Mass Spectrometry CHEMISTRY
QD551J615 Bioelectrochemistry and Bioenergetics CHEMISTRY
QH301B358 Biochemical and Biophysical Research 1* BIOLOGICAL SCIENCES Co/Re G/F
Communication
QH431H43 Heredity CHEMISTRY
QP1H62 Biological Chemistry Hoppe-Seyler
QP501A64 Analytical Biochemistry 1 Co/Cu/Re U/G/F
QP501A67X Applied Biochemistry and Microbiology 1 Cu/Re G/F
QP501A77 Archives of Biochemistry and Biophysics BIOLOGICAL SCIENCES
QP501B525 Biochemistry 1 Co/Re G/F
QP501B58 Bioorganic Chemistry
QP501B557 Journal of Inorganic Biochemistry
QP501B47 Biochemical Journal
QP501B57 Bioorganic and Medicinal Chemistry Letters
QP501B566 Bioorganic & Medicinal Chemistry CHEMISTRY
QP501C5X Clinical Biochemistry 1 Cu/Re G/F
QP501C32 Biochemistry and Cell Biology
QP501E8X European Journal of Biochemistry 1 Cu/Re G/F
QP501F43 F E B S Letters 1 Cu/Re G/F
QP501J7 Journal of Biological Chemistry 1 Co/Cu/Re U/G/F
QP601A1E5 Enzyme 1* BIOLOGICAL SCIENCES Cu/Re G/F
QP601A1E5 Enzyme & Protein BIOLOGICAL SCIENCES
QP601.5J68 Journal of Enzyme Inhibition BIOLOGICAL SCIENCES
QP620N8 Nucleic Acids Research BIOLOGICAL SCIENCES
QP801S6S8 Steroids CHEMISTRY
QP901B5 Biochemical Pharmacology 1 Co/Re G/F
QP901M65 Molecular Pharmacology 1* BIOLOGICAL SCIENCES
QR1B5X Biochemical Genetics 1* BIOLOGICAL SCIENCES Co/Re G/F
R11B7 New England Journal of Medicine 2* 13 HEALTH SCIENCE GENERAL
R31L3 Lancet HEALTH SCIENCE GENERAL
RB1A28 Clinical Chemistry 1* CHEMISTRY Cu/Re G/F
RB1C5 Clinica Chimica Acta 1* CHEMISTRY Cu/Re G/F
RC483P972 Psychopharmacology Bulletin 1 13* PSYCHOLOGY
RC648A1A3X Acta Endocrinologica 1* BIOLOGICAL SCIENCES Co/Cu/Re G/F
RC648A1A3X European Journal of Endocrinology 1* BIOLOGICAL SCIENCES Co/Cu/Re G/F
RM1C55 Clinical Pharmacology and Therapeutics 2* HEALTH SCIENCE GENERAL Cu/Re G/F
RM1C8X Current Therapeutic Research 2* HEALTH SCIENCE GENERAL Cu/Re G/F
RM1T74 Today's Therapeutic Trends HEALTH SCIENCE GENERAL
Title count for this subject: 46
Total titles listed: 46
###