📊 Nachweis Generator

Privacy-safe local tool that generates:

• Nachweis Excel workbooks (per file-campus)
• Quota overview workbook (SWS-weighted internal quota, fraction 0..1)

⚠️ Data privacy: never commit real exports or outputs. data/ and *.xlsx are ignored by git.

Quick start

python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
pip install -e .
nachweis-generator --config config/config.example.yml

QA report

nachweis-generator --config config/config.example.yml --qa

Config files

• config/config.example.yml: runtime options (term, paths, grouping, logging)
• config/schema.example.yml: schema + normalization (column names, required cols, rules)

Development

pip install -r requirements-dev.txt
pip install -e .
make lint
make format
make test

Template-compatible Nachweis

Place your real template at:

• data/templates/nachweis_template.xlsx

Adjust mapping in:

• config/template.example.yml

Run:

make run

Reference-compatible structure

This version matches the structure of the provided reference files (merged cells, widths/heights, labels).

• Nachweis files: Nachweis_Campus <Name>.xlsx
• Quota file: Quoten_Übersicht.xlsx with Summary_<TermLabel> and Matrix_<TermLabel>

Lexique (program code -> full name)

Edit config/lexique.yml to match the exact Lexique sheet content per campus.