Dynamic Rolling 13-Week Performance Forecast Model

Develop an advanced Excel workbook that creates a dynamic rolling 13-week performance forecast using historical data. The model should automatically update trend lines, calculate statistical confidence intervals, and generate predictive visualizations using only built-in Excel functions. Include conditional formatting that highlights potential performance anomalies and create a dashboard that allows users to input different scenario weightings to adjust forecast sensitivity.