This video describes how to solve multi-objective nonlinear problem using Excel solver. At first, I presented the different approaches for compromising between the different objective functions then I solved a location problem
Very insteresting! Congratulations! Since I am not able to undertand your language, I can't understand if you told us a source of this method. Does it have any theoretical background? Could you indicate any? Thank you in advance!
For the third method of combining your OFs, what happens if optimum(OF1) or optimum(OF2) is zero? you'll be dividing by zero! Also there is a field called multiobjective optimization where you optimize all your objectives simultaneously to reach a Pareto front.