Modeling of the state support results for agricultural development in Russia’s macroregions

In order to ensure stable growth in agricultural production, scientific and technological support for agricultural development and reducing technological risks in the food sector, the Federal Scientific and Technical Program for the Development of Agriculture for 2017-2030 has been adopted and is being implemented. The work presents the author's development for the analysis and visualization of structured data characterizing the implementation of this program simultaneously in three planes: on a time scale (years), by macro-region, by the volume of subsidies for the development of the agricultural industry. An analysis of the volume of subsidies was also carried out based on built-in Microsoft Excel tools (info-lines). The purpose of the study was to identify the dynamics of subsidization volumes in macro-regions of Russia. This goal was achieved under the assumption that the use of tools in the visualization and analysis of structured data makes it possible to obtain operational information for making management business decisions in unclear conditions. The authors presented a demonstration of the operation of a tool for analyzing structured data and visualizing pie charts for selected positions and indicators.