I will excel leave tracker, vacation planner pto, wfh, sick

Germany

I speak English, German, Russian

179 orders completed

Excel Expert, VBA and Android Developer

Hallo! Mein Name ist Sergius Ermisch. Ich entwickle Individualsoftware, die Ihre Prozesse vereinfacht, Ihnen Zeit spart oder Ihre Fehlerquellen minimiert– ob in Excel/VBA oder als eigenständige Anwend...

Level 1

Has met certain performance criteria and shows strong potential in the marketplace.

About this Gig

Looking for a simple, visual, and efficient Excel solution to manage your team's absences? This professional absence tracker is perfect for you.


How it works:

  • Intuitive: 12 monthly sheets (Jan-Dec). Enter names, use a short code for absences (e.g., "v" for Leave) that's it!
  • Visual: Cells automatically color-code by reason (e.g., Green for Leave).
  • Automated: Enter the year in the "Master Data" sheet; weekdays & weekends update automatically across all months.
  • Centralized: Manage staff names centrally and select them easily via dropdowns in monthly sheets.


Choose your perfect version:

  • See the gig gallery for a detailed comparison chart to find your perfect match!


Want a closer look? Message me for more screenshots or to request a trial version of this powerful tool!


Your benefits:

  • Instant overview: See who's off and when
  • Tailored to Your Needs: Pick from Basic, Standard, or Premium (see gallery for details).
  • Valuable insights into absence trends
  • One-time purchase, no recurring fees (Microsoft Excel required)


Order your version for streamlined absence planning! Any Questions? Feel free to message me.

Technology:

Excel

Google Sheets

Java

Python

VBA

PowerShell

Expertise:

API integration

Classification

Data extraction

My Portfolio

Other Data Processing Services I Offer