Job description
Needs an Excel file that can:
1. extract from the accounts the construction address (marked BV) and the period of work (Leistungszeitraum or AZ) for the indicated year - preferably selected from a list
2. list these data and generate a table of weekend trips from work to home with (on Fridays or the last working day of the week) automatic calculation of distances and multiplication by the rate per km.
3. listing of this data to generate per diems depending on the distance of the place of work in a given period of time, counting the number of days in a certain period of time and multiplying it by the per diem rate, assuming that the construction address is less than 100 days.