Excel's Goal Seek Equivalent

7 Ansichten (letzte 30 Tage)
Kaila
Kaila am 5 Feb. 2012
I would like to solve the following equation such that the variable, hf, satisfies it:
F = J1 * J2 * (((1 - exp(-a7*hf))/a7) + (H2*(1-exp(-a7*hf)-(a7*hf*exp(-a7*hf))))/(a7^2));
Where a7 is a numerical data value computed in a separate script, H2 is a numerical value imported from Excel and F, J1 and J2 will be defined before this function call.
Example values that I have determined by hand (with rounding) are such: If, J1 = 57.259, F = 592.9, J2 = 3.256, H2 = 7, a7 = 0.4, then hf = 0.936.
Is there a way to solve this equation in a similar manner to Excel's goal seek?
Thank you
  1 Kommentar
Walter Roberson
Walter Roberson am 5 Feb. 2012
http://www.mathworks.com/matlabcentral/answers/3608-goal-seeking

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by