Gaussian Elimination

Dec 20, 2005

For an assignment i am doing at uni i have been asked to produce a spreadsheet that will solve a set of 5 simultaneous equations using gaussian elimination.

I have set up the spreadsheet to do this, however, we have also been asked to make it work if we get a zero on the leading diagonal. This means that the equations would have to be rearranged.

This is the part im not sure how to do. Obviously i would be starting with an 'IF' expression, but other than that i dont know where to start.

View 14 Replies


ADVERTISEMENT

Excel 2013 :: Plotting Gaussian Curve Over Bar Chart

Apr 14, 2014

I'm trying to overlay a Gaussian distribution on some data. The data is a frequency of particle size diameters, ranging from 200-1000 um (see attached). I'm using Excel 2013.

View 1 Replies View Related

Data Elimination- Resolution

Jul 17, 2009

I produce a report each month that requires manual manipulation to get to the end result. Because I have yet to find a macro or formula that can assist me in reducing the data for what I am looking for

Emp Name
Project Code
PRoject Name
LevelRevenueLbr RevenueLbr CostExp CostProfitVarianceRoy, Marcus L.
Project1
PORT RAIL
CM-89.530.000.000.00-89.53-89.53Roy, Marcus L.
Project1
PORT RAIL
PM293.600.000.000.00293.600.00Roy, Marcus L.
Project1............................

View 9 Replies View Related

Consolidate Macro Elimination Duplicate Statements

Dec 21, 2009

how this code can be condensed getting rid of some of the duplicate coding?

Everything is duplicate except for the For i = 1 To x part as the formula that is added is changed from sheet to sheet.

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved