Hello all,
If your institution has ever needed to answer "how many of our papers are Open Access, in what quality of journals, and what are we spending on APCs?" - that question is what led me to build this.
I'm the Librarian at IIT Guwahati. Over the past several months I built a web-based tool that takes a raw Scopus / Web of Science / OpenAlex / Lens.org export and turns it into a clean institutional OA report. The hardest part to do well by hand - and the part I most wanted to solve - was filtering to only the records where the corresponding author is from my own institution, then classifying each by OA type (Gold / Hybrid / Green) and attaching journal-quality indicators (CiteScore and SCImago quartiles, SJR, SNIP). It then auto-generates a docx report: publisher breakdown, year-wise OA trend, and citation and quartile summaries.
I've attached a sample report run on my own institution's Scopus data (1,705 OA articles, 2020–2026) so you can see the actual output (attached as a PDF of the generated docx report) and here's a short walkthrough: APlytiCs Youtube Video
The platform is at APlytiCs Website- access is by request and admin approval, to keep institutional data controlled, so it's not an instant sign-in.
I'd value hearing how others handle this: how are you classifying OA type and confirming corresponding authorship at scale, and what do your stakeholders most want to see in an institutional OA report?
(There's also a module for India's One Nation One Subscription programme for APC-savings estimation - niche to Indian institutions, but happy to expand if anyone works on consortium APC tracking.)
Best,
Dr. Tamal Kumar Guha
Librarian, Indian Institute of Technology Guwahati
------------------------------
TAMAL KUMAR GUHA
LIBRARIAN, IIT GUWAHATI
GUWAHATI, ASSAM, INDIA
tkguha@gmail.com------------------------------