Excel Leave Planner Automation
Budget: $30 – $250 USD
I have a basic excel spreadsheet for planning our annual group leave. I've automated the calendar dates and days, but I need help with one feature. I want the planner to automatically fill in off days based on a repetitive cycle of 6 work days followed by 4 off days. We use the letters R, F, F, F to represent off days.
What I need:
- A feature that allows me to input the first off (R) day for a specific year, and the spreadsheet auto-completes the 10 day cycle for all employees for the rest of the year.
- The planner will need to accommodate 1-10 employees.
- The planner does not need to handle exceptions or holidays during the year.
- The current format for entering the initial off (R) day is custom text.
Ideal skills and experience for this job:
- Proficient in Excel, with experience in creating and modifying spreadsheets.
- Ability to create automated functions in Excel.
- Experience with spreadsheets for planning or scheduling tasks.
What I need:
- A feature that allows me to input the first off (R) day for a specific year, and the spreadsheet auto-completes the 10 day cycle for all employees for the rest of the year.
- The planner will need to accommodate 1-10 employees.
- The planner does not need to handle exceptions or holidays during the year.
- The current format for entering the initial off (R) day is custom text.
Ideal skills and experience for this job:
- Proficient in Excel, with experience in creating and modifying spreadsheets.
- Ability to create automated functions in Excel.
- Experience with spreadsheets for planning or scheduling tasks.