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,

    any idea, link, etc?

    thanks for posting
     
  2. haditya

    Senior Member

    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
     
  7. terrakota

    Thread Starter Well-Known Member

    Feb 8, 2005
    67
    1
    thanks for reply
     
  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!

    Thanks in advance...
     
  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
    9,905
    1,723
    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
     
Loading...