Property Scraper & Excel Automation

I have an Excel workbook filled with property addresses. I need a Python script that will read each address, open a custom property website (I’ll share the URL), scrape the property price and owner information shown on the results page, and then write those values back into the workbook—one row per address, each data point in its own column.

Once the data is in place, the same script should trigger three built-in calculations already set up in the sheet:
• total of all scraped prices
• average price
• a simple comparison column that flags when a price is above or below that average

Technical stack
• Python 3.x with either Selenium or Playwright—whichever you prefer for reliable page navigation
• pandas and openpyxl for reading/writing the workbook and refreshing formulas

Deliverables
1. A well-commented .py script that completes the full flow: read → scrape → write → refresh formulas.
2. A sample output workbook showing at least a few populated rows and updated calculations.
3. A brief README explaining setup, dependencies, and how to schedule the job via Windows Task Scheduler or cron.

No login is required on the target site, and all data is plain text, so there are no captcha or image parsing hurdles. Keep the code modular so I can point it at future sheets or additional address columns with minimal tweaks.