[ILL-L] Statistics gathering

[Peterson, Kim A.]

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