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.pyIt 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
