Comparing Journal Packages using renewals worksheet

At a recent KB+ One Day Workshop there was some interest in how KB+ can be used for comparing journal packages, examples of potential use include checking for duplication of titles across different packages, identifying which titles are potential gains or loses when considering moving from one package to another, comparing your entitlements with a publisher title list etc.

There are a number of ways in which KB+ can help answer these questions and we have a series of blog posts covering the tools available. The last post covered using the Comparison Tool to compare the same package over time or two different packages.

Comparing a journal package with one or more packages

You can compare a number of journal packages by using the Generate Renewals Worksheet, select Institutions > (your institution) > ‘Generate Renewals Worksheet’.

Search for the packages you wish to compare and click the ‘add basket button’ Once you have made your selection click ‘Generate Comparison Sheet’ for an excel spread sheet listing all the titles in the packages.

generate subscription sheet - with labels

You can edit this spread sheet in excel by adding Filters and then Filtering by colour for those columns with the package name as a heading. If you filter by colour ‘green’ for all the packages you will see the titles which are duplicated across the packages.

Comparing your journal entitlements with a package

The Renewals workflow (see user guide for full details and screenshots) allows you to compare one of your subscriptions with another package. This is similar to the process above whereby your subscription is added to the basket with another package and click on ‘Generate Comparison Sheet’. As above you can then edit this spread sheet to filter by colour to see which titles are in both packages (both cells will be green) and which titles are in one package but not the other.(one cell will be green the other blank). This could be useful for when you want to compare your titles against the latest publisher list to see if there are any new titles or any deletions, this could include titles that are transferring in or out of the publisher list.

Contact us at if you require any support in using the tools I have mentioned above or if you have any examples using the comparison features in KB+ to share with the community.

We have recently added some new Use Cases showing how KB+ is currently being used across the community.


One thought on “Comparing Journal Packages using renewals worksheet

  1. Pingback: Checking for duplicate titles across entitlements | Knowledge Base+

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s