murthy_v_s
03-02-2007, 01:45 PM
Hello all:
Can anyone please let me know how can I generate a user defined function(UDF) that triggers excel's solver?
I have a set of 5 constraints and one objective that is to be maximized. I want to perform a senstivity analysis for my objective changing these 5 constraints. So I want the UDF to take all the 5 constraints and return me the optimized value (obtained from excel's solver) for the objective cell.
I appreciate your help in this regard.
Thanks.
Can anyone please let me know how can I generate a user defined function(UDF) that triggers excel's solver?
I have a set of 5 constraints and one objective that is to be maximized. I want to perform a senstivity analysis for my objective changing these 5 constraints. So I want the UDF to take all the 5 constraints and return me the optimized value (obtained from excel's solver) for the objective cell.
I appreciate your help in this regard.
Thanks.