Goal Seek Bias

T

Tina

I am doing resource allocation.
I have noticed a bias in Goal seek so that a higher weight item will get
greater value assigned in goal seek than lower weight ones, such that lower
weight ones may never get any preference ever.
Has anyone noticed this? Any ideas on how to fix it?
Thanks.
 
M

Mike Middleton

Tina -

I doubt that anyone can assist you unless you describe how the "set cell"
depends on the "changing cell" for your Goal Seek problem. What are the
worksheet formulas?

Many resource allocation problems use the optimization algorithms of Solver
(not Goal Seek), in which case you'll have to provide even more description
of your worksheet model.

- Mike
http://www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top