The aim of this workshop is to gain a first understanding of how to collect, process and disseminate APCs paid as Open Data

Day 1 Considering available skills and tools

Day 2 Producing useful inputs for the library community

Day 3 Presentation of workshop results

Bielefeld University Library has been in charge of local funds to support publications in Open Access Journals since 2008.

The funds are supported by the DFG, thus certain conditions have to be met, e.g:

• Fee per article may not exceed 2,000 €
• Yearly reporting and application duties including determination of publication output, fees paid, work programme on how we manage APCs and complementary support

Huge workload, which is only available for review :-(

• FWF shares spreadsheet via figshare.

• Wellcome Trust. Crowdsourcing through Google Spreadsheet.

• JISC APC Pilot. Data modell and search environment.

• OpenAPC.

The aim of this repository is:

• to release datasets on fees paid for Open Access journal articles by German Universities under an Open Database License
• to share a copy of Directory of Open Access Journals (DOAJ) journal master list (downloaded January 2014)
• to demonstrate how reporting on fee-based Open Access publishing can be made more transparent and reproducible across institutions.

Information on both open access journal articles and open access publication of articles in toll-access journals (“hybrid”) are provided.

In total, 3706751€ for 3029 articles were paid by the participating unviversities. Average fee is 1223.8€ and the median 1190€.

We were inspired by the growing landscape of Open Science Tools, especially

1. Version control with Git and collaboration through GitHub
2. Clients that provide access to bibliographic data (rOpenSci, Librecat)
3. Authoring tools such as knitr and R Markdown for automatic report generation

Ram, K. (2013). Git can facilitate greater reproducibility and increased transparency in science. Source Code Biol Med, 8(1), 7. doi:10.1186/1751-0473-8-7

Potential works:

• Provide a pre-filled spreadsheet for participating libraries
• Explore interesting patterns in the data
• Support semantic versioning of the data
• Create dynamic reporting templates with RStudio

Please, team up!

The aim of this workshop is to gain a first understanding of how to collect, process and disseminate APCs paid as Open Data

Day 1 Considering available skills and tools

Day 2 Producing useful inputs for the library community

Day 3 Presentation of workshop results

What is the value of making this information openly available?

• help negotiations with publishers
• open model from the start helps to keep the model open
• promoting library services
• teaches Open Data to library staff
• bench marking across universities, funders and countries

Hands-On: adding APC information to the OpenAPC dataset.

Pipeline:

1. clean DOI list
2. enrich with disambiguated metadata from CrossRef, Europe PMC and DOAJ
3. merge with main spreadsheet
4. automatic generation of report
5. push to github
6. generate Word Document for the Head Librarian