OSCA WORKCHART SOLVER

Linear solver for simple scheduling.

Instructions

Format availability responses as CSV. You can export CSV directly from Google Sheets, Google Form responses, or Excel files. The program is designed to accept availability input through a Google Forms checkbox grid, with days as columns and shifts/hours as rows. You will need to include keywords in the column labels for the program to recognize location of data.

For preferred availability, put BEST AVAILABILITY in the column title. For regular availability, put OKAY AVAILABILITY. The name column should be labeled Name. Other columns will be filtered out.

Usage

To run the script:

python workchart.py <PATH_TO_FILE>

Requirements

• pandas
• PuLP

Planned features

• Full integration with google forms
• GUI