[ILL-L] Statistics gathering

[Campbell, Heather]

Unfortnately, the city ITD removed Access from all city computers so I'd
downloaded the ILLiad data into Excel.  I copied data into Type and
State worksheets to do the computations.  I tried the OCLC stats;
something's wrong.  The stats are off.

 

Heather Campbell, Senior Librarian

Manager- Interlibrary Loan 

Jacksonville Public Library (JPL)

303 North Laura Street

Jacksonville, FL 32202-3505 heatherc at coj.net  (904) 630-2986

 

________________________________

From: ill-l-bounces at webjunction.org
[mailto:ill-l-bounces at webjunction.org] On Behalf Of Nathan Hosburgh
Sent: Friday, December 18, 2009 11:24 AM
To: Interlibrary Loan Listserv
Subject: Re: [ILL-L] Statistics gathering

 

This is the tact I would take, however it would not include the ALA
requests - those could be added manually:

 

I mention Access because it is much easier to manipulate data vs. Excel,
but there are some other tricks within Access, so I would have to go
into further detail.  This would be easier than manually assigning type
designations to 1000s of libraries, though.

 

Nate

 

From: ill-l-bounces at webjunction.org
[mailto:ill-l-bounces at webjunction.org] On Behalf Of Campbell, Heather
Sent: Friday, December 18, 2009 10:23 AM
To: Interlibrary Loan Listserv
Subject: [ILL-L] Statistics gathering

 

Admin forwarded a request for statistical and percentage/proportional
data from the last fiscal year that they needed immediately- namely:

 

For Borrowing: use the "Borrower Transaction-Level Detail Report" from
WCRS, selecting the last month in the fiscal year and specifying 12
months.  Export this to Excel to work with (then further import into
Access).  This report has the totals Y-T-D at the top.

Loans filled by in-state libraries (number and percentage of whole) Sort
the Institution State column to group all in-state libraries and take a
count.

Loans filled by out-of-state libraries (number and percentage of whole)
What is left over will yield the out-of-state libraries.

The types of libraries filling the loans (academic. public, school,
special, other) (number and percentage of whole for each type) Sort the
Library Type column and take a count of each.

 

For Lending: same procedure, but use the "Lender Transaction-Level
Detail Report"

For Borrowing:

Loans filled for in-state libraries (number and percentage of whole)

Loans filled for out-of-state libraries (number and percentage of whole)

The types of libraries requesting the loans (academic. public, school,
special, other) (number and percentage of whole for each type)

 

I used ILLiad data for this because it includes ALA requests but I had
to go through all 3960 records and assign state and library type
designations and because ILLiad gave me the data for the whole year.  It
looked like OCLC only gave this information for a month at a time
instead of for a time period.  

 

Can any of you think of less labor-intensive way of getting this
information together?  

 

By the way- the resulting information was interesting and surprising in
some cases.  My eyes are still tying to recover.

 

 

Heather Campbell, Senior Librarian

Manager- Interlibrary Loan 

Jacksonville Public Library (JPL)

303 North Laura Street

Jacksonville, FL 32202-3505 heatherc at coj.net  (904) 630-2986

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.webjunction.org/wjlists/ill-l/attachments/20091218/bf8937c4/attachment.htm>