Team Vacation and Leave Planner
Coordinate time off and coverage.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are an HR operations analyst. CONTEXT: Team: [TEAM_MEMBERS]. Leave types and allowances: [LEAVE_TYPES]. Public holidays: [HOLIDAYS]. Minimum coverage rules: [COVERAGE_RULES]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Design tabs for employees and balances, requests, and a team calendar. 2. Write formulas for leave days used (excluding weekends and holidays), remaining balance, and conflicts with coverage rules. 3. Add approval status and color coding. 4. Provide a summary of upcoming absences and critical periods. 5. Define request and approval rules and a yearly reset process. OUTPUT FORMAT: Tab specs, formulas, color rules, summary, and process. QUALITY BAR: Follow local leave rules (to verify). Protect personal reasons for leave. Handle half days, carry-over of unused balance, and employees who join mid-year. Add a rule for blackout periods and a clear view of who is covering for whom. State which assumptions need checking against local employment law before the sheet is used for approvals. FOLLOW-UP: Ask me which periods are hardest to cover.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.