Aseptic Products Modelling

This repository contains the code required to build the Aseptic demand and capacity model for NHS England.

Repository Structure

├───data
    └───raw
├───documents
├───images
├───src
    ├───etl
      ├───load.R
      ├───processing.R
      └───utils.R
    └───requirements
      └───packages.R
├───www
    └───nhse_theme.css.R
├───.gitignore
├───app.R
├───LICENSE
└───README.md

data

This folder contains the demand and capacity excel model developed by Karl Taylor at NHSE. The version of the model you want to use within the model will be loaded from here.

documents

Contains the assumptions_guide.md providing an overview of the assumptions used in the model.

images

Contains the TU logo for the README.md

src

Contains scripts used for loading and processing the data for use in the shiny app. Also contains utility functions for creating data tables with totals and a plotly waterfall plot.

www

Contains the .css file for formatting the app.

app.R

This is the shiny app containing both the ui and server components.

Running the Model Locally

You can run the model by cloning the repository and running the app in R.

1. Clone the repository

git clone https://github.com/NHS-Transformation-Unit/aseptic_services_modelling.git
cd aseptic_services_modelling

2. Open RStudio and install packages

Packages will be installed via the src/requirements/packages.R script but you can run this first to ensure they are all installed correctly.

3. Run the app

Run the app.R script to run the app locally.

If you wish to change the input data file to a new version of the mode this will need to first be saved in data/raw/.

Update the file name in each load stage within src/etl/load.R so that it reads:

read_excel(here("data", "raw", "NEW_FILE_NAME_HERE.xlsx"), ...)

Ensure that any cell references are still correct.

Contributors

This repository has been created and developed by:

• Andy Wilson

The model has been built and developed from the original modelling undertake by Karl Taylor at NHS England.

License

This project is licensed under the GPL-3.0 license - see the LICENSE file for details.