Re: Inter-branch traffic

[Carol Gyger <gyger@xxxxxxxxxx>]

Ellen,

You can find what you are looking for in Millennium Web Management
Reports.  See the User Manual Page #101642.  I found a report that is
pretty close to what you need.

When you are in Web Management Reports choose the follow parameters -

Circulation
  Circ Activity
    Circ Stats - All Activity
    Dates - Last month
    Sort by - Limit
    Limit by - Terminal
    Type - Location

Submit.

You will be asked to specify which terminals.  Pick all the terminals from
one branch.

Download this report.  You can open it in Excel as a pipe delimited file.
You can sum the Checkin column for various groups of location codes.

This reports works pretty easily for us for two reasons.

1) We have our terminal numbers (stat group numbers) grouped by 100's.
For example, all the terminal numbers for our Main Library are in the
200's.  All of our terminals numbers for our Harmony Library are in the
300's.  If you have some logic to your numbering system, this might be
easy for you, too.

2) Our location codes are alphabetical by branch and since this report is
alphabetical by branch, the sums are easy to get.

Your setup may be different.  If you use ITYPE or an ICODE to denote
branch, you could run this report using that field instead of LOCATION.

You need to run this report for each group of terminal numbers.

I only discovered these stats today and I've only done a quick "do the
numbers make sense" check with our Circulation Manager.  I would suggest
you try this and see if they make seem accurate.  At least it's a place to
start!

Good luck,
cg

Carol Gyger
Systems Administrator
Fort Collins Public Library
201 Peterson St.
Fort Collins CO  80524
(970)221-6716
gyger@xxxxxxxxxx

On Thu, 24 Jul 2003, EJones - WPL wrote:

> Hello,
> In Dynix we could get a count of how many items were shipped back and forth
> between Waterloo Public Library branches.  Is there such a thing in III
> software?  When I put in "branch" in the manual I don't get relevant
> information.  I've tried Cross tab Circ Statistics in the Web Management
> Reports and the IUG archives using "branch", "statistics" and "pickup
> location" but no luck.
> Ellen
>
> Ellen Jones
> Manager, Systems, Waterloo Public Library,
> 35 Albert St., Waterloo, ON N2L 5E2
> phone: 519-886-1310 x32
> fax: 519-886-7936
> e-mail: ejones@xxxxxxxxxx
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC@xxxxxxxxxx
> Update your subscription options: http://innopacusers.org/list/listinfo/innopac
>