LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
n1ftyneil
 
Posts: n/a
Default Gauss elimination / linear algebra. Please help.


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I anchor one end of a linear trend line? William Spurlock Charts and Charting in Excel 3 January 15th 06 08:06 PM
graph linear Algebra equations and inequalities Roxxanna New Users to Excel 1 May 18th 05 02:40 AM
trendline - request power --> get linear CR Optiker Excel Worksheet Functions 1 October 28th 04 11:02 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"