cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Goal Seek

h_nas
4-Participant

Goal Seek

What is equivalent to MS Excel goal seek in Mathcad?

14 REPLIES 14
RichardJ
19-Tanzanite
(To:h_nas)

A solve block, but Mathcad has several possible alternatives that may be more suitable, depending on exactly what you are trying to solve.

Have a look below.

Clipboard01.jpg

I have also attached an example worksheet.

Mike

10 out of 10 for providing an example, but you may want to change it so that you are finding C, rather than D. You could find D just by a simple assignment

h_nas
4-Participant
(To:RichardJ)

True

Good point.

Clipboard01.jpg

Mike

http://communities.ptc.com/servlet/JiveServlet/showImage/38-1286-16192/applause.gif

h_nas
4-Participant
(To:MikeArmstrong)

Is it applicable if we have say five equations each one is depended on the other ( i.e. the last result is depending on these five equations), we need to fix the last result to some value suitable for us, then trying to find the required input. At the moment I am using try and error.

Solving this issue will save me time.

Thank you

Is it applicable if we have say five equations each one is depended on the other ( i.e. the last result is depending on these five equations), we need to fix the last result to some value suitable for us, then trying to find the required input. At the moment I am using try and error.

Yes I would have thought so. Remember you need the same number of equations as the number of unknowns though.

Can you provide a worksheet?

Mike

h_nas
4-Participant
(To:MikeArmstrong)

I have attached a small example for what I need.

Thank you

RichardJ
19-Tanzanite
(To:h_nas)

You need to write your expressions as functions of the variable you wish to vary:

You need to write your expressions as functions of the variable you wish to vary:

Are you sure? Your value for x doesn't seem correct.

See attached.

Mike Armstrong wrote:

You need to write your expressions as functions of the variable you wish to vary:

Are you sure?

Yes.

Your value for x doesn't seem correct

Just the effects of a typo. I have Y(x):=X(x)/x, not Y(x):=X(x)/z. So the answer is correct, just not for the original equations.

Just the effects of a typo. I have Y(x):=X(x)/x, not Y(x):=X(x)/z. So the answer is correct, just not for the original equations.

Your let off then

Mike

Announcements

Top Tags