Automated Property Valuation Matrix with Dynamic SQL Scoring

Design a Google Sheets dashboard that connects to a PostgreSQL database to dynamically calculate real estate property valuations using machine learning regression models. Create a template that pulls live market data, applies weighted scoring algorithms based on neighborhood comps, property features, and recent sales trends, and generates a real-time estimated market value with confidence intervals. Include conditional formatting that highlights potential investment opportunities and risk zones, with automatic color-coding based on statistical variance.