Excel Predictive Model Dashboard

I need an advanced Excel solution that turns raw customer data into clear, reliable forecasts. The workbook should contain three purpose-built sheets: • Input – a clean, well-labeled area where I can paste new customer data at any time. • Model – regression and time-series calculations powered by LINEST, FORECAST, and the Analysis ToolPak (or equivalent VBA where it adds value). The logic must remain fully transparent so auditors can trace every step. • Output/Dashboard – dynamic charts, confidence intervals, and headline KPIs that update automatically when new data is dropped into the Input sheet. Alongside the file itself, I will need concise documentation explaining key formulas, assumptions, and how to extend the model. A short hand-off call or a screen-recording walkthrough will complete the delivery. Please let me know: 1. Links or screenshots of similar predictive models you have built in Excel. 2. Your estimated timeline from kickoff to hand-off. 3. Any clarifying questions you need answered before starting. Accuracy, clarity, and auditability are critical, so experience with statistical functions and dashboard design in native Excel is essential. Thanks, and I look forward to collaborating.

Project ID: 39754936