Automate Sunday Rotation Calendar
Budget: $10 – $30 USD
I already have a Sunday-rotation calendar in place, but it needs smarter logic. Using a checklist, I manually choose crew members' availability, so the calendar must read that, confirm who is up next, and post the name on the correct Sunday.
Here is the flow I need you to implement or repair:
1. Read the latest availability from the Excel file that gets updated manually.
2. Pick the next person in line who is marked “available” for the coming Sunday.
3. Lock in that assignment on the calendar so it does not shift once the date has passed, creating a running history of who covered which week.
4. Roll forward and repeat automatically for future Sundays.
The existing calendar structure is already built; I just need the underlying script, macro, or add-in adjusted so all of the above happen without manual edits each week. Use (VBA Excel libraries, etc.) that best suits the task, as long as it integrates cleanly with the current Excel sheet and the calendar platform.
Deliverables
• Updated, working calendar file or script
• Clear instructions on how to point it at a new version of the availability spreadsheet if it changes location or filename
• Quick walkthrough or screen recording showing the assignment logic in action
Acceptance criteria: when I drop a fresh availability spreadsheet into the folder and open the calendar, the correct crew member for the next unassigned Sunday appears automatically and remains fixed after that date passes.
Here is the flow I need you to implement or repair:
1. Read the latest availability from the Excel file that gets updated manually.
2. Pick the next person in line who is marked “available” for the coming Sunday.
3. Lock in that assignment on the calendar so it does not shift once the date has passed, creating a running history of who covered which week.
4. Roll forward and repeat automatically for future Sundays.
The existing calendar structure is already built; I just need the underlying script, macro, or add-in adjusted so all of the above happen without manual edits each week. Use (VBA Excel libraries, etc.) that best suits the task, as long as it integrates cleanly with the current Excel sheet and the calendar platform.
Deliverables
• Updated, working calendar file or script
• Clear instructions on how to point it at a new version of the availability spreadsheet if it changes location or filename
• Quick walkthrough or screen recording showing the assignment logic in action
Acceptance criteria: when I drop a fresh availability spreadsheet into the folder and open the calendar, the correct crew member for the next unassigned Sunday appears automatically and remains fixed after that date passes.