What would be the best way to develop a dynamic forecasting tool in Excel using historical data? Each week new data would be added that I would like to influence future forecasts. I would like like to be able to forecast new items by connecting them to "like" items.