need someone to create the excel vacation tracker
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.
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.