The data fields in the Download as Spreadsheet are described here:
The primary ISSN we use for this journal (see issn.org Linking ISSNs)
The title of this journal.
The Elsevier-assigned Subject. Will be deleted soon, in favor of era_subjects (below).
Subjects assigned to the journal by Excellence in Research for Australia (ERA) [source].
This is the Cost per Use (CPU) of the journal. We use a more advanced variant of CPU (internally we call this Net Per Paid Use, or NCPPU). This CPU calculation is the net cost (subscription minus ILL), divided by Paid Use (Usage that can't be met with free sources). This is our most important measure of journal value--it summarizes the real value you're getting for your subscription dollar. This article has more details: How do we calculate cost-effectiveness (Cost Per Use, CPU)
The journal's rank according to CPU, relative to other journals in this dataset. The most cost-effective journal has a rank of 1.
TRUE if you currently have the journal modeled as "subscribed" in your scenario, FALSE if the journal is currently "unsubscribed"
The cost of this journal according to the Settings and Subscription status of the journals in this Scenario. It will be either Subscription Cost or ILL Cost (see next columns), depending on whether the journal is currently subscribed to or not in this scenario.
The projected Usage of the journal by your institution. Usage is a measure of the journal's value to your institution. It is calculated as:
Usage of a journal =
Downloads from the journal
+ (Citations to the journal by your authors) * (citation weight)
+ (Authored papers in the journal) * (authorship weight)
The percent of Usage that is available instantly -- available as Open Access, PTA, or Subscription.
The percent of Usage that can be fulfilled via Open Access or PTA. This excludes usage met only by ILL or Subscription.
The title-by-title subscription cost of this journal. It includes a 'content fee' based on your settings, and annual price increases over the next five years (the cost shown is the average cost over the next five years). This data is based on public price lists unless you've uploaded a custom price list (available in a purchased account). This article has more details: How do we calculate title-by-title subscription costs?
The ILL subscription cost of this journal. It is based on the ILL transaction cost and your ILL Request Rate, both of which are adjustable parameters. This article has more details: How do we calculate ILL requests and ILL cost?
The net cost of the subscription, which is the Subscription cost above minus the ILL cost (since almost all universities will offer a journal by ILL if they didn't subscribe). For some journals with very high Usage and low subscription prices this number is actually negative -- subscribing is *cheaper* than filling all the anticipated ILL requests.
The percent of Usage that can be fulfilled via as Green, Hybrid, or Bronze Open Access. Some of this content can be excluded in the settings (see the Open Access page for more info).
The percent of Usage that can be fulfilled via your PTA (Post-Termination Access) rights.
Percent of Usage that can be fulfilled ONLY via title-by-title subscription in this scenario--after fulfilling requests via Open Access and PTA fulfillment wherever possible.
Percent of Usage that is fulfilled via ILL in this scenario. This is simply turnaways (Usage that can't be fulfilled by Open Access, PTA, or your title-by-title subscriptions) multiplied by your ILL Request Rate parameter. This article has more details: How do we calculate ILL requests and ILL cost?
Percent of Usage that is fulfilled via Unknown paths in this scenario. This all Usage that isn't fulfilled by Open Access, PTA rights, title-by-title subscription or ILL. Instead, the user fulfills their information need some other way -- asks the author for a paper, asks a colleague, finds another similar paper that is good enough for their purposes, etc.
The years when your institution has PTA (Post-Termination Access) to this title. Defaults to none.
Optional text for those who have already left their Big Deals, to annotate which journals they'd previously subscribed to.
For some journals the publisher automatically makes the content free to read after a certain number of months. For those journals, this column lists the age of the articles (in months) when they will automatically become free to read on the publisher's site.
The percent of Usage that can be fulfilled via Green OA. This is Open Access hosted on open repositories, like Harvard's institutional repository, arXiv, or PMC. Green OA that hasn't been peer-reviewed (preprints, submitted drafts, etc) can be excluded in the Parameters.
The percent of Usage that can be fulfilled via Hybrid OA. This is Open Access hosted on the publisher site with an open license in an otherwise subscription journal. Usually an APC was paid by the authors when they published this paper.
The percent of Usage that can be fulfilled via Bronze OA. This is Open Access hosted on the publisher site in an otherwise subscription journal, but unlike Hybrid it does not have an open license. It is sometimes promotional material, and sometimes open after an embargo in a Delayed OA journal (like Elsevier's Open Archive content). Bronze OA can be excluded in the Parameters.
The percent of Usage that can be fulfilled via Academic Social Networks like ResearchGate and Academia.edu. These are not considered open repositories, so papers hosted here are not considered Open Access. These can be excluded in the settings.
Percent of Usage that can be fulfilled via a peer-reviewed full-text copy of the article. This includes all of Hybrid and Bronze, and the portion of Green OA that is an Accepted or Published version of the paper. Green OA that hasn't been peer-reviewed (preprints, submitted drafts, etc) can be excluded in the Parameters.
The number of times people in your institution will download papers from this journal. We base this on your COUNTER statistics and literature on download decay curves (how often an article is to be downloaded based on how long ago it was published).
The number of times that a paper authored by someone in your institution will cite a paper in this journal. This number is based on the citations patterns of the previous five years. The importance of this number to overall Usage is determined by the Citation Weight parameter.
The number of papers in this journal that have at least one author from your institution. This number is based on the authorship patterns of the previous five years. The importance of this number to overall Usage is determined by the Authorship Weight parameter.
We include a few "fuzzed" columns, in case you want to share this data approximately but not exactly. We've broken the values into three groups of approximately the same size, and labelled them low, medium, and high.