CTUNetwork contains home-grown functions as well as a Shiny App to
load and interpret Projectfacts’
CTU Bern internal data.
You can install the development version of CTUNetwork from github
with:
remotes::install_github("CTU-Bern/CTUNetwork")| 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 |
You can run the shiny app directly with
CTUNetwork::runCTUNetworkApp()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)Contributions to CTUNetwork are welcome. If you have ideas, open an
issue or a discussion
thread on GitHub.
The package logo was created with
ggplot2 and
hexSticker with icons
from Font Awesome.