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
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
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
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