Analysis of the intermediate consumptions factors of input-output tables by the data of Ukrainian and EU statistical services

Spitkovskyi A.I., PhD (Biol.), Associate Professor,
Leshchenko I.Ch., PhD (Engin.), Senior Research Scientist, ,
Lebid M.V.,
Institute of General Energy of the National Academy of Sciences of Ukraine, 172 Antonovycha str., Kyiv, 03150, Ukraine
Language: Ukrainian
Source: The Problems of General Energy, 2017, 4(51):40-51
Section: Mathematical modeling of energy facilities and systems
UDC: 620.9
Received: 30.10.2017
Published: 21.12.2017


We give the description and results of work of the new software suite, which is used for preparing initial data for calculations with applying input-output models. The suite enables one to aggregate data from input-output balance, which is developed annually by the State Statistics Committee of Ukraine in the format of MS Excel spreadsheets, and to process this information for determining the intermediate consumption factors. We present the calculated factors obtained with using data from the State Statistics Committee of Ukraine for 2012–2015 and Statistical Bureau of the European Union for 2005–2007. It is shown that data of the State Statistics Committee of Ukraine cannot be used in input-output models due to significant discrepancies between the years, but, at the same time, EU data are completely suitable for use in the Leontieff model.

Keywords: input-output tables, Leontieff input-output models, aggregation, intermediate consumption factors.


  1. Leontief, W. et al. (1958). Studies in the structure of the American economy. Moscow [in Russian].
  2. Kulyk, М.M. (2016). Input-output model aggregation method. Problemy Zahal’noi Enerhetyky - The Problems of General Energy, 1(44), 5—9 [in Ukrainian].
  3. Tablytsia vytraty–vypusk Ukrainy v osnovnykh tsinakh za 2012 – 2015 roky: statystychnyi zbirnyk. K.: Derzhavna sluzhba statystyky Ukrainy. URL:[in Ukrainian].
  4. Sait Yevrostat. URL:


Full text (PDF)