CTUNetwork

CTUNetwork contains home-grown functions as well as a Shiny App to load and interpret Projectfacts’ CTU Bern internal data.

Installation

You can install the development version of CTUNetwork from github with:

remotes::install_github("CTU-Bern/CTUNetwork")

Overview

Function	Purpose
AvgTimeBookings.R	Cumulative sum of time bookings over package/project levels
BuildTable.R	Print a datatable object
Calculations.R	Computing calculations for HourlyCosts, MoneySpent and TimePercent variables
convertTime.R	Convert time in minutes as integers to standard HH:MM
extractData.R	Extract and format Projectfacts data from the getPFData function
filterData.R	Filter ProjectFacts data from the getPFData function
FilterNotes.R	Extracting text information encapsulated between html-like tags, e.g. Notes field
ggColorHue.R	Emulate ggplot2 color palette
NetworkPlot.R	Network plot function - Build the network
shinyApp.R	Run the CTUNetwork app
StandardDates.R	Standardizing dates to European format, i.e. DD-MM-YYYY
themeShiny.R	Customized ggplot2 theme applied to homogenize the plots in Shiny App

Usage

Shiny App

You can run the shiny app directly with

CTUNetwork::runCTUNetworkApp()

Isolated functions

First, install Alan’s PF package locally

remotes::install_local("R:/Projectfacts/ODBC/pf_app/")

Then retrieve the data either locally

All_Tabs <- pf::getPFData()

or directly through ODBC (requires DNS to be configured)

All_Tabs <- pf::getPFData(NULL)

Extract and reformat data from the large list of lists (All_Tabs)

Data <- CTUNetwork::extractData(All_Tabs)

Finally, filter and replace Projectfacts key codes by real values

FiltData <- CTUNetwork::filterData(Data, All_Tabs)

Contributing

Contributions to CTUNetwork are welcome. If you have ideas, open an issue or a discussion thread on GitHub.

Acknowledgements

The package logo was created with ggplot2 and hexSticker with icons from Font Awesome.