Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hey guys and girls, I'm new to the forum and hoping you can help. I have a set of 6x6 "matrices" in excel that expand out to give 6 equations each with six unknowns (it is a formula for a composite lamina that has the 6 known moments and forces in a column on the left hand side equal to a known 6x6 matrix multiplied by the column of six unknown strains..hence why each equation gets 6 unknowns). There are no non-linearites or any other complexities - just the unknowns. It could be solved linearly or if there is some way of calculating the inverse of my 6x6 matrix then that would work too. This would be an easy solution in a program such as MatLab or Mathcad but i'm completely stuck in excel. Is there some fuction that will let me solve this... I'm thinking a gauss elimination or something similar to 2x2 simultanious equations but for 6! thanks a lot! Neil -- n1ftyneil ------------------------------------------------------------------------ n1ftyneil's Profile: http://www.excelforum.com/member.php...o&userid=33192 View this thread: http://www.excelforum.com/showthread...hreadid=530090 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I anchor one end of a linear trend line? | Charts and Charting in Excel | |||
graph linear Algebra equations and inequalities | New Users to Excel | |||
trendline - request power --> get linear | Excel Worksheet Functions |