Engineers-Excel.com

     
Engineering using Spreadsheets

Linear Equation Solver

Description
How it works








This is a tool to solve a system of linear equations. It can solve up to 20 simultaneous equations.

Download

.xls file (21 KB)

How to use the tool

To solve the system Ax = b, first key in the number of equations into the cell C4.

Then key in the matrix A into the yellow cells and b into the blue cells.

The solution x is obtained in column X, it is highlighted in green.

This screenshot shows the entries and solution for the following system:

2x1 + 3x2 + 3x3 = 1
2x1 + 3x2 + 2x3 = 1
3x1 + 3x2 + 3x3 = 3

The solution obtained is x1 = 2, x2 = -1 and x3 = 0.