Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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, |
#2
![]() |
|||
|
|||
![]()
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 wrote in message oups.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, |
#3
![]() |
|||
|
|||
![]()
and/or ...octave(emulate matlab) to solve:
I don't have matlab, but I would assume there is a Solve command similar to the following. Are you looking for a more general form of the equation in order to solve other equations with different variables? equ = { (12-x)^2 + y^2==15^2, (16+y)^2 + x^2==25^2 }; Solve[equ] {x - 0, y - 9}, {x - 24, y - -9} HTH -- Dana DeLouis Win XP & Office 2003 wrote in message oups.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, |
#4
![]() |
|||
|
|||
![]()
Just be advised that, in general, two circles may not intersect (two
imaginary solutions), have 1 common point, or hopefully in your example, two real solutions... http://mathworld.wolfram.com/Circle-...ersection.html HTH -- Dana DeLouis Win XP & Office 2003 "Dana DeLouis" wrote in message ... and/or ...octave(emulate matlab) to solve: I don't have matlab, but I would assume there is a Solve command similar to the following. Are you looking for a more general form of the equation in order to solve other equations with different variables? equ = { (12-x)^2 + y^2==15^2, (16+y)^2 + x^2==25^2 }; Solve[equ] {x - 0, y - 9}, {x - 24, y - -9} HTH -- Dana DeLouis Win XP & Office 2003 wrote in message oups.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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Can't read Dutch written equations in excel files. Could before.. | Excel Worksheet Functions |