Goal Seek or Solver to Solve for two Unknows?
Goal Seek or Solver to Solve for two Unknows?
(OP)
Hi,
I am trying to figure out if Goal Seek or Solver would be the most appropriate to find two values (Qd for LRB & Qd for NR) that when they are multiplied by a desired value (8 and 24,respectively) would give me another desired value (665.1). Please see attach excel spreadsheet for what I am trying to do.
(8)(Qd for LRB) + (24)(Qd for NR) = 665.1
Really appreciate your help in your guidance on how to accomplish this.
Thanks
I am trying to figure out if Goal Seek or Solver would be the most appropriate to find two values (Qd for LRB & Qd for NR) that when they are multiplied by a desired value (8 and 24,respectively) would give me another desired value (665.1). Please see attach excel spreadsheet for what I am trying to do.
(8)(Qd for LRB) + (24)(Qd for NR) = 665.1
Really appreciate your help in your guidance on how to accomplish this.
Thanks





RE: Goal Seek or Solver to Solve for two Unknows?
Or you need to explain your requirements in a bit more depth.
RE: Goal Seek or Solver to Solve for two Unknows?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Goal Seek or Solver to Solve for two Unknows?
Qd for NR = (665.1 - 8(Qd for LRB))/24
This result in a line with Qd for NR ranging from 0 to 27.7125 and Qd for LRB ranging from 83.1375 to 0 (if we're only looking at the cases where both Qd's aren't negative).