Blog

In this post, you'll learn how to create custom Excel functions to store engineering constants by creating a user-defined function in VBA that can store the yield strength of steel and return it to the spreadsheet. You'll also learn how to save your custom functions in an Excel template so they … Read more about Custom Excel Functions for Engineering Constants

Excel's convert function works well to convert between simple units. However, in engineering, there's often compounds units where simple units are either multiplied together or divided by one another. One example is the units for torque, where we multiply a force times a distance (i.e. N*m). … Read more about Using the CONVERT Function for Compound Unit Conversions

Another way to document equations in Excel is the Equation Editor. This is the same editor that's used in both PowerPoint and Word. It may be helpful to create a location in your spreadsheets to display the main governing equations that you're using, whether it's one section of a spreadsheet or … Read more about Using Excel’s Equation Editor to Document Equations

Excel's Solver add-in can be used to find the best-fit line for nonlinear data. Worksheet 07f contains the flow and pressure data that was used in a previous example to illustrate fitting with LINEST. Delete the coefficients that are in the table from that example. For Solver to work, you'll need … Read more about Using Excel Solver for Nonlinear Regression

In this post, you'll learn how to perform constrained optimization in Excel through an example where we will maximize the flow rate in an open channel. The example will show that there is an optimal relationship between the channel dimensions that maximizes the flow rate for any required … Read more about Constrained Optimization in Excel – Maximize Open Channel Flow

The Excel Solver can be used to perform a least squares regression. For most situations, you can do regression using either trendlines in the chart or the LINEST function. However, there may be situations where you want to find a best fit manually. Even if you never need to do a manual fit, this … Read more about Using Excel Solver for Linear Regression

Every engineer knows that for the results of engineering calculations to be correct, the units of the input values must be correct. In the case of a calculation like F=ma, the units must be consistent with each other (e.g. N, kg, m/s^2) and in the case of a unit-specific calculation like P=Tn/5252, … Read more about Unit Aware Calculations in Excel