This project generates dynamic analytical graphs for enterprise management using Python's Dash library. It requires Excels worksheets to be available locally. They must have the following columns.
employee | date | project | product | task | total hours |
---|---|---|---|---|---|
John | 23/07/24 | project1 | product1.1 | backend development | 7.4 |
Names inside the repository might be in Portuguese because I developed in a way to be easily plugable to the Codex workhours worksheets back in the day.
The company's workhours worksheets must be locally available, as by using OneDrive-Desktop to add their cloud directory as a shortcut at your local. Copy the local path to this mirrored local directory and paste it as the environment variable COMPANY_WORKHOURS_EXCELS_DIR
in the .env
.
Install project using Poetry
# Change directory into project directory
cd <project-dir>
# Install venv
poetry install
# Activate venv
poetry shell
# Run project
python run.py
It is strongly dependent upon OneDrive's synchronization.
. βββ π README.md βββ π app βΒ Β βββ π __init__.py βΒ Β βββ π alternative_to_onedrive.py βΒ Β βββ π app_state.py βΒ Β βββ π assets βΒ Β βΒ Β βββ π css βΒ Β βΒ Β βΒ Β βββ π card.css βΒ Β βΒ Β βΒ Β βββ π header-selectors.css βΒ Β βΒ Β βΒ Β βββ π main.css βΒ Β βΒ Β βΒ Β βββ π root.css βΒ Β βΒ Β βΒ Β βββ π tab.css βΒ Β βΒ Β βΒ Β βββ π table.css βΒ Β βΒ Β βββ π favicon.ico βΒ Β βΒ Β βββ π favicon_mock.ico βΒ Β βΒ Β βββ π script.js βΒ Β βββ π cache βΒ Β βΒ Β βββ π state.pickle βΒ Β βΒ Β βββ π valid_data.pickle βΒ Β βββ π callbacks βΒ Β βΒ Β βββ π __init__.py βΒ Β βΒ Β βββ π cards βΒ Β βΒ Β βΒ Β βββ π __init__.py βΒ Β βΒ Β βΒ Β βββ π invalid_registers.py βΒ Β βΒ Β βΒ Β βββ π team_commitment.py βΒ Β βΒ Β βΒ Β βββ π valid_registers.py βΒ Β βΒ Β βββ π headers.py βΒ Β βΒ Β βββ π read_excels_bar.py βΒ Β βββ π commitment_card_processor.py βΒ Β βββ π languages βΒ Β βΒ Β βββ π __init__.py βΒ Β βΒ Β βββ π translations.csv βΒ Β βΒ Β βββ π translator.py βΒ Β βββ π layout βΒ Β βΒ Β βββ π __init__.py βΒ Β βΒ Β βββ π layout.py βΒ Β βββ π mocks βΒ Β βΒ Β βββ π mock.py βΒ Β βββ π utils βΒ Β βββ π logger.py βββ π img βΒ Β βββ π flowchart.svg βββ π logs βΒ Β βββ π main.log βββ π poetry.lock βββ π pyproject.toml βββ π run.py