Re: 2 variables in 2 quadratic equations in excel

From: Steve Dalton (steve_sdk_at_eigensys.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 10:47:15 -0000

Hi Eric

The brute force way (requiring the least mathematical analysis) is to
calculate the left hand side as functions of two reasonable first guess x
and y inputs and then calculate the total error (say as a sum squares of the
differences) of these compared to the right hand sides.

Once you have that you can run the solver add-in to minimise (or set to
zero) the error cell's value by altering (subject to optional constraints)
your input x and y values.

Regards

Steve Dalton

<fsshl@centurytel.net> wrote in message
news:1107681393.070670.213660@c13g2000cwb.googlegroups.com...
> Dear ms excel user/programmers:
>
> I hope this question is not repeated before. But anyway
>
> highly appreciate anyone can tell me how (or hint) to use ms excell
> and/or visual c/c++, basic, or octave(emulate matlab) to solve:
> (12-x)^2 + y^2 =15^2,
> (16+y)^2+x^2=25^2
>
> (by programming or using its built in function)?
>
> that ^2 mean square.
>
> looking to any excel user, mathmatician, and/or programmer's help,
> eric, fsshl@yahoo.com
>