Perform data envelopment analysis in MS Excel based on models of C~2R and C~2GS~2
Yanli Zhang, LI Xian-wen · Zhejiang Medical Education · 2008
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.