Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
solving a matrix in Excel
Hi,
I am wondering how to solve an 8x8 matrix using Excel equations. Supposing the situation is column A B C D E F G H I 1 7 4 2 9 .... 2| 5 2 10 3 6 ... | 1 r 3 2 ... | o 4 . w 5 . data 6 7 8 In other words, it is solving the system A1*x[1]+B1*x[2]+C1*x[3]+D1*x[4]+E1*x[5]+F1*x[6]+G1*x[7]+H1*x[8]=I1 A2*x[1]+B2*x[2]+C2*x[3]+D2*x[4]+E2*x[5]+F2*x[6]+G2*x[7]+H2*x[8]=I2 A3*x[1]+B3*x[2]+C3*x[3]+D3*x[4]+E3*x[5]+F3*x[6]+G3*x[7]+H3*x[8]=I3 .. .. A8*x[1]+B8*x[2]+C8*x[3]+D8*x[4]+E8*x[5]+F8*x[6]+G8*x[7]+H8*x[8]=I8 I have already done this but my answers are wrong. It took several manipulations and created about 16 blocks on the spreadsheet in 230 rows. In its final form the solution should have a diagonal of all 1's between A1 and H8 and the rest zeros, except column I should be the solutions to each x[1],x[2],..,x[8]. Does anyone know what I'm talking about? Any help would be appreciated. Is there a formula that will compute the matrix all in one formula? Jon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solving Sudoku using Excel | Excel Discussion (Misc queries) | |||
Solving Sudoku with EXCEL | Excel Worksheet Functions | |||
Mathematic problem solving using Excel | Excel Worksheet Functions | |||
solving equations using Excel | Excel Discussion (Misc queries) | |||
i've got a simple excel problem that needs solving... | Excel Discussion (Misc queries) |