Skip to content

Requirements

Lam Nguyen edited this page Mar 26, 2020 · 9 revisions

Requirements

Requirement List

Requirement ID Feature Name Description Additional Information
A File Upload User must be able to upload a .xlsx or .csv file to the website. See the gray upload box in the middle of the screen
B Schedule Type Choice User must be able to choose which context the data will be sorted for. Options include Seminar, Eight Hour Workday, or Rotating Shifts Workday. The option chosen will determine the algorithm by which the data is managed and how the groups will be set up. See the scheduler type dropdown at the top left.
C Data Download After completion of sorting, the user shall be able to download a .xlsx file conatining the results.
D Data Preview The system shall display the user's inputted data before running the sorting algorithm as well as select parameters, such as the scheduling type (seminar, field, etc.) or group size as shown in options requiring groups of people to be set together, on which the data is to be handled and managed to create the final product..
E Data Changes Upon successful display of the user's data, changes shall be able to be made before running the sorting algorithm.
F Data Input User shall be able to enter data directly into the system if they choose not to upload a formatted spreadsheet.
G Data Display After sorting is completed, the system shall display a spreadsheet containing the results. If the data cannot be displayed due to ill-formatted input or a potential scheduling error, these errors will be raised and shown as a message to the end user.
H Downloadable Template User will be able to download a sample data file to demonstrate proper data formatting depending on the type of scheduler that is selected.
I Data Export After completion of sorting, the user shall be able to export the results to a Google Sheet. See the download results area in the bottom left corner.
J Deployment on Local Server (Client Request) The system shall be capable of being deployed on a commercial VPS running CentOS 7.6, Apache 2.4.39, MySQL 5.7.27, and PHP 7.0.
K Open Source Upon the completion of the project, all source code for the system shall be released under an open source license.
Clone this wiki locally