Cost modelling tools
datasetposted on 01.10.2018 by Mark Harland
Datasets usually provide raw data for analysis. This raw data often comes in spreadsheet form, but can be any collection of data, on which analysis can be performed.
A cost modelling tool developed in 2015 to help establish an internal business case to set up an APC fund for Open Access publishing. It allows users to model different cost projections based on variables such as FTE, number of articles, REF submission targets, and % Green vs Gold OA.
There are two Excel files available: one is blank and the other contains sample values to show a worked example. Both files include a Powerpoint Quickstart guide embedded within the home page. This steps you through the workflow and shows how to edit the various variables to customise your model.
The tool is a development of initial work undertaken Northumbria University in 2014 which led to the University Executive approving a £100K/annum internal fund for Gold Open Access costs.
We anticipate that this will be most useful to institutions which have received a lower/no block grant from RCUK, but there may be other use cases that we have not yet considered.