中文版：请帮我制作一份员工排班Excel表格。

根据员工名单、岗位、工作日期、班次类型、工作时间、休息规则和人员需求制作合理的排班表。

建立“员工信息”“班次设置”“月度排班”“人员需求”和“排班统计”工作表。

确保同一员工不会被安排到时间冲突的班次，并尽量保证员工的工作天数、休息时间和班次分配合理。

使用颜色或条件格式区分早班、中班、晚班、休息和请假状态。

自动统计每位员工的工作天数、工作小时数、休息天数和不同班次数量。

如果人员数量不足，请自动标记缺口并给出排班调整建议。

英文版：Create an employee scheduling Excel workbook.

Based on the employee list, job roles, working dates, shift types, working hours, rest rules, and staffing requirements, create a practical staff schedule.

Create worksheets for employee information, shift settings, monthly schedule, staffing requirements, and scheduling statistics.

Ensure that employees are not assigned to overlapping shifts and aim to maintain a reasonable balance of working days, rest periods, and shift distribution.

Use colors or conditional formatting to distinguish morning, afternoon, night, rest, and leave statuses.

Automatically calculate working days, working hours, rest days, and the number of different shifts for each employee.

If staffing is insufficient, automatically flag the staffing gap and provide scheduling adjustment recommendations.

该提示词已在以下工具中验证有效：ChatGPT、Claude、Gemini、Copilot、WPS AI