Graph plot dashborad using python

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me.

Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly.

Deliverables
• The updated workbook with the automation in place
• A short note or screencast explaining where the logic lives and how to extend it if new columns are added later

I’ll test by pasting a sample dataset; if every arithmetic field populates correctly and no manual recalculation is needed, the job is done.