Hourly Photovoltaic Power Forecasting Using Exponential Smoothing: A Comparative Study Based on Operational Data

The accurate forecasting of solar power generation is becoming increasingly important in the context of renewable energy integration and intelligent energy management. The variability of solar radiation, caused by changing meteorological conditions and diurnal cycles, complicates the planning and control of photovoltaic systems and may lead to imbalances in supply and demand. This study aims to identify the most effective exponential smoothing approach for real-world PV power forecasting using actual hourly generation data from a 9 MW solar power plant in the Kyiv region, Ukraine. Four exponential smoothing techniques are analysed: Classic, a Modified classic adapted to daily generation patterns, Holt’s linear trend method, and the Holt–Winters seasonal method. The models were implemented in Microsoft Excel (Microsoft 365, version 2408) using real measurement data collected over six months. Forecasts were generated one hour ahead, and optimal smoothing constants were identified via RMSE minimisation using the Solver Add-in. Substantial differences in forecasting accuracy were observed. The Classic simple exponential smoothing model performed worst, with an RMSE of 1413.58 kW and nMAE of 9.22%. Holt’s method improved trend responsiveness (RMSE = 1052.79 kW, nMAE = 5.96%), but still lacked seasonality modelling. Holt–Winters, which incorporates both trend and seasonality, achieved a strong balance (RMSE = 1031.00 kW, nMAE = 3.7%). The best performance was observed with the modified simple exponential smoothing method, which captured the daily cycle more effectively (RMSE = 166.45 kW, nMAE = 0.84%). These results pertain to a one-step-ahead evaluation on a single plant and an extended validation window; accuracy is dependent on meteorological conditions, with larger errors during rapid cloud transi. The study identifies forecasting models that combine high accuracy with structural simplicity, intuitive implementation, and minimal parameter tuning—features that make them well-suited for integration into lightweight real-time energy control systems, despite not being evaluated in terms of runtime or memory usage. The modified simple exponential smoothing model, in particular, offers a high degree of precision and interpretability, supporting its integration into operational PV forecasting tools.