need someone to create the excel vacation tracker

Job ID: 34296249

Budget: ₹1,000 – ₹45,000 INR

We are looking for someone to create two spreadsheets that can help us track Paid Time Off (PTO), Sick Leave, Family Medical Leave Act (FMLA), and Affordable Care Act (ACA) leave.


Specifically ONE spreadsheet should be able to:

PTO
- Calculate the right PTO accrual amount based on vacation amounts for each level (e.g., level 1 may have 1 week of vacation accrued per year, but level 2 may have 2 weeks of vacation accrued per year)
- Enable a user to enter PTO requests
- Automatically calculate how much PTO a person has accrued, how much they've used to do date, and how much they have left

Sick Leave
- Enable a user to enter Sick Leave requests
- Automatically calculate how much Sick Leave a person has used to do date, and how much they have left

FMLA Leave
- Enable a user to enter FMLA requests
- Automatically calculate how much FMLA leave a person has used to do date, and how much they have left

General
- Show a calendar view of who has taken leave when over a period of time (to see if there are a lot of overlaps over our staff)
- Include spots for managers to approve PTO (a simple cell with drop-down values should be fine)

The second spreadsheet should be able to:

- Flag who, based on an extract of data, has worked more than an average of 30 hours over a period of time (this period would be variable)

While these spreadsheets may initially be built in Excel, we will likely upload this to a shared drive or to Google Drive to help make it collaborative for users to input data.

NOTE: We would prefer a spreadsheet without extensive custom VBA since we want to upload this to Google Sheets and it may not be compatible.
Related categories: PHP Visual Basic Data Entry Excel Software Architecture