Create tentative aquatics facility staff schedules from a given spreadsheet containing availability for the upcoming scheduling period.
This project contains two application methods, but both require the following inputs:
- Number of staff per shift of each type (Lifeguards, Managers, Pool Attendants).
- The maximum ideal number of consecutive shifts worked by one staff member (will be scheduled only if necessary).
- Input file path (launches file explorer).
- Output file path.
The input file for this application must be in the format of "Sample Availability Sheet.xlsx" in order to run correctly. All three notebook tabs must be included, and the format must remain largely the same. You can make the following changes to the :
- Change the text representing the staff members who are available (currently U1,U2, U3, ...).
- Change the text representing the day.
- Change the text representing the shift.
- Add more staff members below the current ones.
- Add more days (with shifts) in the same format as the currently included shifts.
- Change the document filename.
Make sure both the input file and output file (overwritten if it exists) are not open in any other program before running this application.
This project requires the source files "utils.py", "wrapper.py", "cmd_app.py" and "gui_app.py" to have full feature access. You could ignore either one of the "..._app.py" files, but then you will not have access to that file's application type (Command Line Interface or Graphical User Interface). The Python Library "openpyxl" must be installed. You can do this by running the command "pip install openpyxl". To learn more about openpyxl, check out the documentation.
I have only been able to test this application on the Windows operating system, but it should work on any Operating System.
Feel free to reach out to me with ideas, questions, or other comments regarding this project by opening an Issue!