Wiki Link: [discussion:2056]
Calculation of Efficiency using Microsoft Solver Foundation 

Jul 21 2009 at 1:39 PM
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 add-in 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 add-in.

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

Jul 21 2009 at 8:56 PM
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
----------------------------------------------------------------

Jul 22 2009 at 7:03 AM
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

Jul 27 2009 at 8:50 AM
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 plug-in:
http://yetanothermathprogrammingconsultant.blogspot.com/2009/07/msf-solver-dea-via-excel-plug-in.html.

----------------------------------------------------------------
Erwin Kalvelagen
Amsterdam Optimization Modeling Group
erwin.kalvelagen@gmail.com
http://amsterdamoptimization.com
----------------------------------------------------------------

Feb 2 2012 at 1:53 PM
Edited Feb 2 2012 at 1:56 PM
Hello Mr.Erwin,

I have seen your example concerning The Data Envelopment Analysis using the Excel Plug-in
You Have The DUAL Model Implemented.
I have a question Please Haw to Implement The Primal Modell With OML (Excel Plug-in)
Its Possible to Implement this Model For .NetFramework using Visual Basic (Visual Studio 2010)

for you help I would be very grateful

Amine

Feb 2 2012 at 1:55 PM
Hello Mr.Erwin,

I have seen you example concerning The Data Envelopment Analysis using the Excel Plug-in
You Have The DUAL Model Implemented.
I have a question Please Haw to Implement The Primal Modell With OML (Excel Plug-in)
Its Possible to Implement this Model For .NetFramework using Visual Basic (Visual Studio 2010)

for you help I would be very grateful

Amine


Updating...
Page view tracker