MFSLB is a tool designed to streamline and automate the application processes within the Finance Committee at the University of Toronto Engineering Society. Built using JavaScript and powered by Google Apps Script, it leverages the simplicity of the language and its integration with Google Services. The project was developed by Finance Secretary Suyeon Park and Members at Large Kenneth Sulimro from 2023 to 2024 to alleviate the time-consuming tasks associated with preparing for monthly Finance Committee meetings, which previously took over five hours - Now it is done with just one click!
Watch the introduction video to Finance Committee Workflow
Watch the introduction video to MFSLB Project
- Automated Form Management: Open and close forms based on time triggers.
- Application Distribution: Categorize applications and allocate files to corresponding folders.
- Data Extraction: Extract and record important data from applications in a spreadsheet.
- Meeting Minutes: Generate meeting minutes from extracted data.
- Comment Sheet: Create a comment sheet with random member reviews of applications.
- Budget Tracking: Record approved amounts and analyze budget trends post-meeting.
If you are the VP Finance or Finance Secretary, your school Google account has access to this project. Finance Committee members interested in MFSLB can request access from them.
For any issues or questions, please reach out to me.