
Hi All, Is it possible to calculate Efficiency of different Business Units on the basis some inputs and output using Microsoft Solver Foundation? Following is the sample data for which efficiency needs to calculate. Each row here represent the details of each Business Units. 1st column "Location" contains the location of business unit 2nd & 3rd columns "Personal" & "Business" are the outputs 4th column "Staff" is the input. Location Personal Business Staff Croydon 125 50 18 Dorking 44 20 16 Redhill 80 55 17 Reigate 23 12 11 In MS Excel, there is a addin named as "Solver" that can be used to calculate the efficiency. For that we need to add the weighted output, weighted input and some more columns to meet the requirement of Solver addin. I believe some thing similar should be existing with Microsoft Solver Foundation, and can be calculate the efficiency programatically. you all are requested to provide your thoughts on the same... An earlier reply will be appreciated. Regards, Anuj Chauhan anuj.mca@hotmail.com +91 9313499294



I believe you are talking about DEA (Data Envelopment Analysis) . This is often formulated as a set of small LPs, and this can be solved easily using MSF.  Erwin Kalvelagen Amsterdam Optimization Modeling Group erwin.kalvelagen@gmail.com http://amsterdamoptimization.com 



Yes, it is the DEA. May I request you for some sample code to implement it. I am fairly new to Solver Foundation and facing problem in implementing DEA, I will be greatfull to you if you can also provide some sample code to implement DEA. Best Regards, Anuj Chauhan anuj.mca@gmail.com  anuj.mca@hotmail.com +91 9313499294 http://www.linkedin.com/in/anujchauhan



Implementing a model to calculate the efficiency of a single DMU should be trivial. If you have troubles with that, well, then you really have a problem. Here is a note on how to get results for all DMU's using the Excel plugin: http://yetanothermathprogrammingconsultant.blogspot.com/2009/07/msfsolverdeaviaexcelplugin.html.  Erwin Kalvelagen Amsterdam Optimization Modeling Group erwin.kalvelagen@gmail.com http://amsterdamoptimization.com 


Edited Feb 2 2012 at 1:56 PM

Hello Mr.Erwin, I have seen your example concerning The Data Envelopment Analysis using the Excel Plugin You Have The DUAL Model Implemented. I have a question Please Haw to Implement The Primal Modell With OML (Excel Plugin) Its Possible to Implement this Model For .NetFramework using Visual Basic (Visual Studio 2010) for you help I would be very grateful Amine



Hello Mr.Erwin, I have seen you example concerning The Data Envelopment Analysis using the Excel Plugin You Have The DUAL Model Implemented. I have a question Please Haw to Implement The Primal Modell With OML (Excel Plugin) Its Possible to Implement this Model For .NetFramework using Visual Basic (Visual Studio 2010) for you help I would be very grateful Amine

