Leave planner application
Ever wanted to know how much leave you’ll have in the future and easily visualise your balance over time? Sure, some leave systems have some kind of future leave calculator, but none that I’ve seen make it easy or intuitive.
Application available here, on github pages: https://prule.github.io/leave-planner/
The spreadsheet prototype
To scratch my own itch, I started with a google sheet. The principle is simple: Enter your starting balance, and for each month fill in the estimated hours leave accrued. Add in your hours leave taken for the month… and graph the total leave remaining.
Here’s the end result:
It’s very simple to use:
- Adjust dates
- Enter your starting balance
- Enter the actual hours leave accrued for each month in the past
- For future months enter an estimate
- Enter your hours leave taken in the past or booked for the future
Your leave balance is calculated and projected into the future based on what you’ve entered. The graph lets you easily see when you are approaching zero!
Here’s a link to the template - you can make a copy and then fill it in for yourself: Leave Planner Template
The web application
Now that the concept has proven useful to me, it’s time to turn it into a web application for convenient use…
Main view:
Enter leave:
Settings:
About:
Available here, on github pages: https://prule.github.io/leave-planner/