[ILL-L] Statistics gathering

Fri Dec 18 13:03:24 EST 2009

The upside for me is that word is the state only is going to ask for
this every 4-5 years. 

No fears, I think, for the rest of the country.  "As Florida goes, so
goes the nation." Isn't exactly bandied about as a truism.  Though--
Florida definitely has good practices to share.

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:49 PM
To: Interlibrary Loan Listserv
Subject: Re: [ILL-L] Statistics gathering

Oh, I am sorry to hear that this is a state mandated report, sorry
because this statistical breakdown may become the fashion, creeping
across the country from the SE to the Midwest.   :(

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:39 AM
	To: Interlibrary Loan Listserv
	Subject: Re: [ILL-L] Statistics gathering

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