Leica, Microsoft Excel, VBA Developer / Consultant - Microsoft Excel, VBA
Company: Leica, Zürich
Technology: MS Excel, VBA.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Okt 2018 – Jan 2019
Cost: no details
Creation of a time recording system for the employees of the company Leica in Zurich. The time recording is realised using Microsoft Excel and VBA. Different working time models are taken into account, such as flexitime, shift work, overtime, weekend working time and management contracts. The times can be entered manually in Excel and the balances are calculated per month and per year. Of course, the calculation also takes into account public holidays and holiday days as well as special absences such as military, illness and accident. The application was realised using Microsoft Excel and Microsoft VBA.
- Development of a dynamic time recording system using Excel.
- Integration of overtime calculation.
- Integration of overtime calculation.
- Compliance with all internal guidelines.
- Compliance with all legal requirements.
- Calculation of annual totals.
- Calculation of monthly carryovers.
- Sending of PDF by e-mail.