run_exponential_smoothing
Apply exponential smoothing to Excel time series columns using simple, Holt, or Holt-Winters methods, with optional forecasting for trend analysis.
Instructions
Apply exponential smoothing (simple/Holt/Holt-Winters) to a time series column.
Args: file_path: Workbook path. sheet_name: Worksheet name. column: Column to smooth. alpha: Smoothing factor for simple smoothing. new_column_name: Optional name for output column; if omitted, a generated name is used. header_row: 1-based header index. output_file: Optional file to write output. method: One of "simple", "holt", "holt_winters". seasonal_periods: Required for Holt-Winters. forecast_steps: Number of out-of-sample forecast steps to produce. smoothing_trend, smoothing_seasonal: Optional fixed smoothing parameters.
Returns: dict: Summary and references to output column/sheet.
Notes:
- May modify workbook if output_file/new_column_name provided.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alpha | No | ||
| column | Yes | ||
| method | No | simple | |
| file_path | Yes | ||
| header_row | No | ||
| sheet_name | Yes | ||
| output_file | No | ||
| forecast_steps | No | ||
| new_column_name | No | ||
| smoothing_trend | No | ||
| seasonal_periods | No | ||
| smoothing_seasonal | No |