Perform Data Envelopment Analysis in MS Excel Based on Models of C2R and C2GS2

ZHANG Yan-li,LI Xian-wen,GAO Yue-ming,LV Xu-dong
DOI: https://doi.org/10.3969/j.issn.1672-0024.2008.04.004
2008-01-01
Abstract:Data Envelopment Analysis(DEA) is used to assess relative efficiency among many Decision Making Units(DMUs) with many inputs and outputs.This study was based on two mathematical models of DEA,C~2R and C~2GS~2.We used the processing function of Excel 2003 and its linear programming solution and Excel and VBA Built-in Functions to solve DEA models.
What problem does this paper attempt to address?