This is a simple application that calculates the number of high school teachers needed for each branch. The data needed are gathered from main.xlsx
file. School-specific information comes from list.xlsx
and modified results are printed in result.xlsx
.
Dependencies This is a Python3 project using modules
numpy
,xlrd
,PySide2
, andopenpyxl
.
The algorithm intelligently considers the following criteria:
- Weekly hours
- Must/elective status (of the courses)
- Persona of the students from each year
- Distribution of the personas
- Number of student
Figure: (a) Main screen (b) Persona configuration (c) Distribution of personas