DEA is starting to appear as a topic in recent editions of general OR teaching texts (e.g. Interest in applying the technique has been growing rapidly, and many papers have been published on public and 1ΔΆ private sector applications, often leading to technical developments. Introduction Since Charnes et al s (1978) description of the use of ratios of weighted inputs and outputs to measure efficiency, Data Envelopment Analysis (DEA) has developed into a successful OR tool. It is argued that making use of the developing power of spreadsheets to implement OR techniques such as DEA can help make OR more accessible to practitioners and students. Since the macro language for Excel (Visual Basic for Applications) can control the Solver, a macro can be written to automate the process of calculating the efficiency of each unit. Excel s Solver can perform the optimisation required, whether nonlinear or linear programming formulations are used. 2007, ISBN Using Excel for Basic Data Envelopment Analysis Manchester School of Management, UMIST Abstract This paper describes the use of Excel to implement the basic Data Envelopment Analysis (DEA) algorithms. (2000), Using Excel for Data Envelopment Analysis, Manchester School of Management Working Paper No.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |