We developed DocuParse for the American Council of the Blind, which is a nationwide non-profit organization supporting individuals who are blind and visually impaired. DocuParse is a web application that allows for the automation of schedule building and email sending, which would otherwise be a long and tedious task when done manually. DocuParse also supports Text to speech (TTS) technology that allows for those who are blind and visually impaired to easily navigate and use the application.
The primary goal of our program is to match volunteers to events based on their skill set and availability. We'll be discussing the data structure used, the logic for the match, and the conversion of the data to CSV & HTML. Additionally, we'll dive into automating this data into Outlook emails.
We store volunteer data in a dictionary with:
- Key: Volunteer's name
- Value: List of skills
- Days of availability with corresponding hours
For events, we have:
- Key: Event name
- Value: Required skills
- Day of the week
- Hours
- Number of volunteers
- Other event data
Our schedule building algorithm works as follows:
- Go through each event in the list of all events to find a match
- For the number of volunteers needed the the event, find a matching volunteer
- A volunteer is a match if:
- Their skills match the event's requirements.
- Their available hours overlap with the event's hours.
- A volunteer is a match if:
- We then remove those matched hours from the volunteer's availability.
After matching, we convert the data into a CSV format. The structure becomes:
| Day | Time | Title | Account | Host | Moderator | Facilitator | Streamer | Broadcaster |
|---|
We use the convert_to_csv function to transform the output data from the schedule building algorithm into CSV.
Once in CSV format, we can easily transform this data into an HTML table for viewing on web platforms.
With the data in HTML, we can then automate the sending of notifications via Outlook emails.
We've successfully transformed raw Excel data into an automated event scheduling and notification system. This ensures that the right volunteer is matched to the right event, enhancing efficiency in resource allocation. By automating this whole process, we can save hours of time and energy for the American Council of the Blind and anyone who is blind or low-vision.
The code ("Code") in this repository was created solely by the student teams during a coding competition hosted by JPMorgan Chase Bank, N.A. ("JPMC"). JPMC did not create or contribute to the development of the Code. This Code is provided AS IS and JPMC makes no warranty of any kind, express or implied, as to the Code, including but not limited to, merchantability, satisfactory quality, non-infringement, title or fitness for a particular purpose or use.