/sll_vr_reporting_utils

Scripts used to dig out the data needed for the SciLifeLab and VR yearly reports.

Primary LanguagePython

SciLifeLab & VR reporting utils

These are scripts used to gather data that is used in the SciLifeLab and VR annual reports.

generate_report.py

A slightly over-engineered script to create SciLifeLab and VR reports.

Used to fetch all time entries logged between two dates given as arguments. These time entries are used to determin which projects have been active during the selected time period. Data about these active projects are then summarized and printed to a .xslx file.

# examples

# standard SciLifeLab report for short-medium term projects 2023
python3 generate_report.py -c config.yaml --sll --sm-term   --year 2023 -o sll_2023.xlsx

# standard SciLifeLab report for long term projects 2023
python3 generate_report.py -c config.yaml --sll --long-term --year 2023 -o sll_2023.xlsx

# standard VR report for short-medium term projects 2023
python3 generate_report.py -c config.yaml --vr --sm-term   --year 2023 -o sll_2023.xlsx

# standard VR report for long term projects 2023
python3 generate_report.py -c config.yaml --vr --long-term --year 2023 -o sll_2023.xlsx