Google Sheets 2026 Automation Upgrade

I’m refreshing my main Google Sheet ahead of our 2026 planning cycle and want it to do more than store numbers. Specifically, I need the file to run data-analysis automation that performs regression analysis on new entries the moment they arrive, then returns clear, readable results in-sheet.

Here’s what I’m after:
• Configure an Apps Script (or another cloud-friendly solution) that watches a designated input tab, cleans the data, and kicks off regression calculations automatically.
• Display key outputs—coefficients, R-squared, p-values, and forecast values—in a dedicated results tab, with conditional formatting that flags significant findings.
• Build lightweight, on-demand charts that update with every new run so trends are instantly visible.
• Keep the workflow simple for non-technical teammates: a single button or timed trigger to launch the process, plus inline notes so they understand what happens under the hood.

I already have a functioning sheet; your task is to upgrade it, not start from scratch. Share the final file (or a copy) plus the script, commented clearly enough that I can tweak variables later. If you’ve tackled Google Apps Script regression tasks before, let me see a sample—speed to deployment matters.