CWEngineer
Civil/Environmental
- Jul 3, 2002
- 269
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