# simultaneous equations

Discussion in 'General Electronics Chat' started by terrakota, May 25, 2005.

1. ### terrakota Thread Starter Well-Known Member

Feb 8, 2005
67
1
Hi,

i need some kind of free tool to solve simultaneous equations easy and quick, i dont have an expensive calculator, so i need some kind of software i can download and solve simultaneous equations for network analisis,

thanks for posting

Jan 19, 2004
220
0
how many eqns do u have?

3. ### terrakota Thread Starter Well-Known Member

Feb 8, 2005
67
1
could be 2 or 3

4. ### hgmjr Moderator

Jan 28, 2005
9,030
214
Solving a linear system of n-equations containing n-unknowns is basically an exercise in Matrix Algebra.

If you have access to Microsoft Excel 2000 or newer you may want to experiment around with the EXCEL function MDETERM. This function solves for the determinant of an n-by-n matrix. All you would need to do is set up the various matrices in a spreadsheet and let Microsoft EXCEL do the number crunching.

Good Luck,
hgmjr

5. ### terrakota Thread Starter Well-Known Member

Feb 8, 2005
67
1
forget it!

i found an easy and fast way to do it with MS EXCEL.

6. ### hgmjr Moderator

Jan 28, 2005
9,030
214
I'm glad you were able to get the MS EXCEL to work out for you. I have played with the MDETERM function and found it to be very powerful.

The neat thing about the MS EXCEL matrix function is you can use ii to investigate what happens to the system of equations when you change the coefficients.

hgmjr

Feb 8, 2005
67
1

8. ### Lasci New Member

Feb 7, 2007
1
0
Hi,

Just did a google search on simultaneous equations and came across this post so registered. Can anyone explain further how to solve in MS Excel? I have 7 equations and 7 unknowns to solve!

9. ### RichardM New Member

Aug 4, 2008
5
0
I have been trying to give the All About Circuits forums a thorough once-over, and came across this thread. It is pretty old, but it is searchable, so I thought I would reply to it.

There are also a few good online tools I can recommend. They are based on good code and, since they are online, they are accessible from anywhere with Internet access.

1) AKiTi's Simultaneous Equation Solver
http://www.akiti.ca/SimEqR12Solver.html

(In addition to this solver, the AKiTi site also offers several other numerical mathematics tools.)

2) Bluebit's Matrix Calculator
http://www.bluebit.gr/matrix-calculator/

In addition to solving systems of up to 30 equations in 30 unknowns, it offers several other tools for analyzing the properties of matrices.

10. ### Papabravo Expert

Feb 24, 2006
10,340
1,850
Scilab, is a free Matlab clone. Solves linear algebra prolems in a flash, and it's hard to beat the price. If your spirit of adventure knows no bounds then try `R' on for size