Created a Python script to automate the weekly generation of an excel spreadsheet, logging daily pass-downs for the current week by scraping notes from a separate Word Document. Utilized Python’s DocX package to handle Microsoft Word documents and Openpyxl package to modify the existing spreadsheet, create new weekly tabs, and auto-populate date ranges within a custom-formatted Excel document.

Note: Actual images are not displayed due to confidentiality reasons. The final implementation of note scraping has not yet been added to the script for troubleshooting purposes.