- Get the new PDF from Bundesministerium der Finanzen
- Convert PDF to Excel e.g. here
- Copy lump sum table to a new
tsv
file with the following first line, save asbackend/data/lumpSums_YYYY-MM-DD.tsv
country catering24 catering8 overnight
- run
docker compose exec -T backend npm run parse-lumpsums
Keep in mind that the lump sums for germany are not included in the puplications of the Bundesministerium der Finanzen
.
To Update the lump sums of germany add a line manualy to the corresponding lump sum file.