A search and sensitivity analysis of time optimal plans of energy resources supply using SolverTable add-in

• Date: 2022
• Main Authors: Кузьмичов, А. І., Чернецька, Ю. В., Шестаков, В. А.
• Format: Article
• Language: Ukrainian
• Published: Інститут проблем реєстрації інформації НАН України 2022
• Subjects: spreadsheet modeling; optimization modeling; resource allocation modeling; sensitivity analysis; SolverTable; Excel Solver; energy management
• Online Access: http://drsp.ipri.kiev.ua/article/view/275103
• Journal Title: Data Recording, Storage & Processing

Any optimization technique should be adapted to concrete management task, and this study focu-ses on practical issues of resource allocation modeling used for energy management. The principal aspect is uneven consumption of energy resources over time (within a day, a week, a year) that requires the development of optimization models for decision-making about their supply, considering time-related energy consumption predictions and operational features of energy sources. The proposed resource allocation model, built in Excel to use its standard optimization tool Solver, has unusual structure with time periods to overcome the issue and identify the time optimal plan of energy resources supply. Another important aspect is flexibility and stability requirement of optimization model in the situation of possible change of inputs. SolverTable add-in is applied to succeed in dealing with the issue; it is a specialized tool for sensitivity analysis, which complements the functionality of the standard Excel Solver and helps to interpretate the results of repeated computational experiments that are crucial for rational decisions. The proposed resource allocation model detailed for the case of electricity supply. Electricity distribution system has a grid structure that allows use matrix model with a number of electricity sources and a number of consumers, represented by their hourly electricity demand. Objective function is the total cost of electricity for consumers with the same supplier. Two groups of constraints for the optimal day-ahead hourly scheduling: limited proposals of electricity sources and equation between the demand and supply. Sensitivity analysis of the model allowed to identify an electricity source, which limit changes can improve the result of objective function. The model is tested on actual data to choose a time optimal plan for electricity supply; the publication contains just an illustrative numerical example. The proposed model can be modified to solve other problems of optimal allocation of energy resources.