[ILL-L] Statistics gathering

Fri Dec 18 12:39:23 EST 2009

Way off.  OCLC says we loaned 6.93% in-state. 93.87% out of state.  The
stats I compiled said we loan 79.48% in state- 20.52% out of state.  Our
State Library is our biggest borrower accounting for around 30% (and up)
of our loans each month- so I know OCLC's stats were way off.  

Yes- ILLiad doesn't count fills the same way OCLC does but enough time
has passed since the end of the last fiscal year that some of those
inconsistencies have sorted themselves out. 

Luckily- the report (a state-mandated report) used the magic word "best
estimate" and the person who needed the stats gave me more time than the
2 hours the person who assigned the task to me did.  My task would have
been easier if ILLiad Borrowing Reports indicated how  the total of much
was loaned to JPL by each lender- instead of to each user designated
pick-up locations.  It would have made for a much shorter list.

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 Peterson, Kim A.
Sent: Friday, December 18, 2009 12:20 PM
To: Interlibrary Loan Listserv
Subject: Re: [ILL-L] Statistics gathering

How far off are they? There was discussion on this list recently about
(now, if I remember this correctly!) how ILLiad counts a transaction,
something about the timing of it. It counts the filled transaction in
the month it was placed (?) or something like that. I just remember that
it was different than the OCLC stats.

We don't have ILLiad and rely only on OCLC statistics. 

Depending on how important this statistical report is to your superiors,
you could just go ahead using the OCLC stats for their breakdown
categories. Come up with the percentages of each category and then, if
it's using your own total it really important, apply those percentages
to your preferred total.

I do that for one of our state reports.

Kim Peterson

St. Louis Public Library

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

	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/e7a8f157/attachment.htm>