MCDM'07 - paper no. 4


Back to MCDM'07 contents

A spreadsheet based system for DEA models

Josef Jablonsky


DEA models are tools for evaluation of efficiency and performance of decision making units. They are based on the definition of efficiency as the ratio of the sum of outputs produced by the unit divided by the sum of inputs spent in the production process. A standard LP solver is the only requirement for solving DEA models. Unfortunately specialized optimization packages are not available to typical users. In this case it is possible to use the built-in MS Excel solver. This solver has many limitations but it is usually a sufficient tool for DEA models. The paper describes an original MS Excel add-on application that offers a simple tool for solving several standard DEA models. This application includes basic envelopment models with constant and variable returns to scale, SBM models, models with undesirable inputs and outputs and models with uncontrollable input and outputs. The application allows to calculate super-efficiency measures for most of the models mentioned. The functionality and main features of the system are illustrated by a simple case study - an evaluation of performance of pension funds in the Czech Republic.


data envelopment analysis, efficiency, Excel, spreadsheets

Reference index:

Josef Jablonsky, (2008), A spreadsheet based system for DEA models, Multiple Criteria Decision Making (3), pp. 51-64

Full text:


Scopus citations in 1 paper(s):
  1. Daryanto, W. M., & Wibisono, I. (2019). Measuring financial performance of national oil and gas companies in southeast asia. International Journal of Innovation, Creativity and Change, 6(3), 191-206