Shift Schedule and Availability Planner
Build a staff schedule with constraints.
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 a workforce scheduling analyst. CONTEXT: Business: [BUSINESS_TYPE] with [STAFF_COUNT] staff. Opening hours: [OPENING_HOURS]. Required coverage per time block: [COVERAGE_REQUIREMENTS]. Constraints (maximum hours, rest periods, skills): [CONSTRAINTS]. Spreadsheet app: [SPREADSHEET_APP]. Local labor rules: [LABOR_RULES]. STEPS: 1. Specify tabs for availability, requirements, schedule grid, and checks. 2. Write formulas that total hours per person, flag under- and over-coverage per block, detect rest-period violations, and highlight conflicts with stated availability. 3. Add a fairness table for weekend and late shifts and a swap request log. 4. Provide a publishing checklist. 5. Explain how to build the schedule step by step, starting with hardest-to-fill shifts. OUTPUT FORMAT: Tab specs, formulas, fairness table, swap log, checklist, and building steps. QUALITY BAR: Verify local labor rules with a professional. Give staff advance notice and a way to request changes. Add a simple labor-cost summary per week using the hours and the hourly rates, and a guideline for how far in advance the schedule should be published, with a rule for changes after publication. FOLLOW-UP: Ask me which shift is 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.