In this post, you’ll learn how to create a catenary cable tension calculator in Excel by solving an implicit equation. The example will show specifically how to use Goal Seek for finding roots of equations in Excel. Video Subscribe to EngineerExcel on YouTube Catenary Cable Tension Calculator in Excel – Finding the Root of an …
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 are available whenever you …
Custom Excel Functions for Engineering Constants Read More »
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 to enter guess values …
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 cross-sectional area. If you aren’t interested in …
Constrained Optimization in Excel – Maximize Open Channel Flow Read More »
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, the equation requires …
Excel provides another way to ensure input values meet certain criteria other than data validation: form controls like combo boxes, list boxes, and radio buttons. To add form controls, we have to enable the Developer tab, because it’s not turned on by default when you install Excel. Go to File > Options > Customize Ribbon. …
Using Excel Form Controls to Control Spreadsheet Inputs Read More »
Excel contains a variety of trigonometric functions: Basic functions Hyperbolic functions Inverse functions Miscellaneous SIN SINH ASIN PI() COS COSH ACOS RADIANS TAN TANH ATAN DEGREES SEC SECH ASINH CSC CSCH ACOSH COT COTH ATANH The inverse functions are those usually denoted with a superscript -1 in math (i.e. ASIN is the Excel function for …
If you’ve used solver before, you’ve noticed that every time you close out the Solver dialog and reopen, your settings are preserved. This is handy because it allows us to quickly test and tune the model without having to reenter all the information again. However, what if you want to make a significant change to …
