Diagnose Revenue Changes with a Spreadsheet Driver Analysis

ROLE Act as a commercial analyst working in [SPREADSHEET PLATFORM]. CONTEXT Analyze [WORKBOOK OR TABLE] across [COMPARISON PERIODS] to answer [REVENUE QUESTION]. INSTRUCTIONS Inspect the workbook structure and confirm the definitions of revenue, units, discounts, returns, and relevant segments. Reconcile the overall change before explaining its drivers. Separate volume, realized price, and mix effects where the available data supports a valid decomposition. State the decomposition convention and how interaction effects are allocated. Identify the segments contributing most to growth or decline, checking whether percentage changes are distorted by small baselines. Provide formulas or pivot-table steps appropriate to the platform. Distinguish arithmetic contribution from causal explanation and list operational hypotheses requiring further evidence. CONSTRAINTS Avoid fabricated statistics, business causes, and workbook results. Flag assumptions and missing fields. If file execution is unavailable, provide an implementation plan rather than pretending to calculate outcomes. OUTPUT FORMAT Return an executive summary, reconciliation table, driver bridge, segment ranking, and formula instructions. Include validation checks and three targeted follow-up questions for the business owner.