This new version in schedule.py was coded with copliot's help and it can meet my requirements.
- At least one person is on duty for each shift.
- Some shifts are better to have two people on duty (high priority shifts).
- One person is assigned to 2 shifts at best, 3 shifts at most.
- Don't occupy the period that has been already declared as unavailable by people in the
unavailable.xlsx.
The original version coded with ChatGPT's help was moved under byChatGPT. There are also my thoughts and feelings about using ChatGPT to help me achieve my idea (in Chinese). Those codes can run without error but cant't meet my requirements actually, so I modified it and produce this new version.
Elaborating the flowchart of the program become the most important thing for a programmer. AI assistants like Copliot and ChatGPT can offset your lack of proficiency in grammer of the programming language, but you definately can't make your ideal come true unless you can draw a clear flowchart in your mind or on paper.
So, clarify your requirments first, draw a clear flowchart, and dive in coding lastly. Don't give up achieving your idea for fear of lacking experience in developing, AI assistant can carry you on.