Abstract
The paper discusses how the Excel Solver can be used to solve various Data Envelopment Analysis REA) models. The structure of the DEA models allows one to use simple visual basic for applications (VBA) codes to automate the DEA calculation. As a result, one can easily establish the DEA spreadsheets and solve any existing or new DEA models.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Charnes, A., Cooper, W.W., and Rhodes, E. (1978), “Measuring the efficiency of decision making units”, European Journal of Operational Research 2 /6, 429–444.
Zhu, Joe (2002), Quantitative Models for Performance Evaluation and Benchmarking: Data Envelopment Analysis with Spreadsheets. Kluwer Academic Publishers, Boston.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zhu, J. (2003). Solving DEA via Excel. In: Multi-Objective Programming and Goal Programming. Advances in Soft Computing, vol 21. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-36510-5_44
Download citation
DOI: https://doi.org/10.1007/978-3-540-36510-5_44
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-00653-4
Online ISBN: 978-3-540-36510-5
eBook Packages: Springer Book Archive