Solver Problem

Solver Problem

I have 4 values of X and 4 values of Y, using these values of X and Y, single value Z has been calculated in Column C with the help of formula. Now I want to maximize Z value in column C using solver. How to select for multiple column?

I have attached excel file and there is an image of formula for calculating Z or r, as I am unable to write that formula in excel. We have to maximize Z value by changing X and Y value. currently Ihave Z value = 0.852, I have to set value of X and Y such that Z is maximum but less than 1.
Please help.


The Formula should be like this:


Please have a look at enclosed file:





You may also like...

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Şu HTML etiketlerini ve özelliklerini kullanabilirsiniz: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>