Have you ever been asked to gather statistics regarding the number of renewals for your patrons? This process will help you to first gather the number of renewals of your items by your institution’s patrons. You will then be able to derive the number of renewals of OhioLINK items by your patrons.

To get started, you will want to generate a Cross-tab report (http://cat.opal-libraries.org/iii/webrpt/secure/CrossTab.html) with the following parameters:

Dates: user specified
Statistic type: Renewal
Limited by: All locations
Rows: LOCATION
Columns: PTYPE

You will then delete all the PTYPE columns except for your own so you can focus in on those transactions.

To tally your patrons and institutions renewals, sum up the item locations and ptypes associated with your institution only.

To tally the number of renewals of OhioLINK items, take the totals of renewals of all item locations and subtract the number of local renewals (the number in the previous step).

When sifting through the mass of statistical reports generated from the OPAL system, you are typically concerned with how your institution is doing. The data associated with your terminal numbers corresponds to the transactions happening at your institutions. Most reports can be built or narrowed by using this criteria.

Terminal numbers can be found in the system under Admin > Parameters > Circ > Statistical Group Maintenance.