Employee Weekend Work Script
Custom script developed to easily log and create Excel spreadsheets listing the status of employees working over the weekend. A weekly automated email is then sent out with the data generated from the Excel spreadsheet to notify management.
User interface
Running the script displays a list of workers (names have been anonymized due to confidentiality reasons) for the user to select with the corresponding numbers next to the workers' names. The list above will populate depending on user input. The user can also remove the last worker inserted into the list. Once completed, the user should select the option to export data into an Excel Spreadsheet.
Generated Excel spreadsheet
After initiating the export command from the user interface, Microsoft Excel will automatically launch for the user, create a new workbook titled with the particular weekend in question, and display the data collected from the user in a custom format to be transferred over to a personal email client for automated sending.
Automated email
The email client will launch, auto-populate with the information from the Excel Spreadsheet, and email automatically to the desired recipients every week.
Note: Automated email handling feature has been put on hold due to other priorities and should be implemented shortly when time permits.