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

## Solving a System of Simultaneous Linear Equations in Excel

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

## Protecting Excel Worksheets and Workbooks

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

## Nonlinear Curve Fitting in Excel Using Charts

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

## Nested IF Functions in Excel

In the last section, you saw how an IF function can be used to return one of two possible values. What if you have more than two possible results? Nested IF functions can be used for three or more possible outcomes. Our example spreadsheet shows a simple case where a Reynold's number will be … Read more about Nested IF Functions in Excel

## Named Arrays in Excel

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

## Multiple Linear Regression 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

## Evaluating Derivatives of Equations in Excel with VBA

We can extend the concept of finite differences into VBA if we know the function and aren't constrained to dealing with tabular data. For example, let's assume that the equation below defines the position of an object: We can calculate the velocity using finite differences in VBA. Open the … Read more about Evaluating Derivatives of Equations in Excel with VBA