Blog

Unlike simultaneous linear equations, simultaneous non-linear equations cannot be solved using linear algebra. However, we can extend the concept of using Goal Seek from solving a single implicit equation to solving systems of nonlinear equations. In our worksheet, we'll set up equations for flow … Read more about Solving Systems of Simultaneous Nonlinear Equations in Excel

In addition to solving nonlinear equations like the Colebrook equation graphically, you can also solve them numerically using a feature called Goal Seek. Our worksheet is set up to do just that. This spreadsheet is set up to use a guess for the value of f as an input. You'll use the "Outputs" table … Read more about Solving Non-Linear Equations in Excel with Goal Seek

Systems of linear equations can be solved in Excel using formulas that perform matrix calculations. This worksheet is set up to find three unknowns in a free-body diagram using some of those matrix functions. The problem contains a beam supported by a pin and a tension cable, with a weight at the … Read more about Solving a System of Simultaneous Linear Equations in Excel

So far, you've seen a few different methods to prevent errors from being generated in your spreadsheets, but those methods won't prevent someone from making unauthorized changes to your worksheet or workbook that cause errors. Another person could cause problems if they make changes to cell formulas … Read more about Protecting Excel Worksheets and Workbooks

In engineering, you'll encounter data than doesn't follow a linear trend. In those cases, you'll need to use nonlinear methods. Excel has a few different options for fitting these curves. The worksheet contains pressure and flow data for a valve in a piping system. Select the data and create an … Read more about Nonlinear Curve Fitting in Excel Using Charts

Excel allows you to apply names to arrays, which will make calculations on a series of data easier to understand as well. Worksheet 03y contains a similar internal energy calculation as we've seen the last few sections. Instead of calculating the internal energy for one final pressure, this … Read more about Named Arrays in Excel

You saw in the pressure drop example that LINEST can be used to find the best fit between a single array of y-values and multiple arrays of x-values. In that example, we raised the x-values to the first and second power, essentially creating two arrays of x-values. That characteristic allows LINEST … Read more about Multiple Linear Regression in Excel