Hello Cafe goers,

I'm writing to ask how others are handling the logistics of data collection and assessment for your read and publish (R&P) agreements.  We currently support around 10 R&P agreements.  The data availability is all over the place, with some publishers only providing publication data on a quarterly basis to me via email and other publishers allowing for report retrieval on demand via Copyright Clearance Center.  I'm currently maintaining a clunky spreadsheet to track total articles published as well as total APC savings, and I'm wondering if there is a better way to gather and track these data points besides manually smooshing the data from each publishers' report into a spreadsheet and trying to remember to retrieve reports manually throughout the year.

Any and all approaches or advice are appreciated!

Cheers,

Erin

Erin Gallagher (she/her/hers)

Chair, Acquisitions & Collections Services

George A. Smathers Libraries

400 SMA, P.O. Box 117007

University of Florida

Gainesville, FL 32611-7007

[log in to unmask]

(352) 294 0449