Thread: Goal Seek Bias
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tina tina is offline
external usenet poster
 
Posts: 139
Default Goal Seek Bias

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.