Electrical Load Forecasting based on Multiple Regression using Excel Tools

Abstract

Forecasting of load is an important factor for power system operation and planning. As the electricity consumption increases, load forecasting methods become more complicated. Depending on the load nature variations, selection of one particular method is a difficult task. Microsoft's Excel tools are most popular spreadsheet program and most people have it on their computer and to avoid the need to purchase specialized forecast software, the excel software program is selected for use in this is paper Excel data analysis regression tool have been applied for short term load forecasting (for 10 days) on the dataset of September 2022 for Phata region of Maharashtra, India. The result indicates average error value is 0.14, between actual load and forecasted load.