Section modulus is a geometric property of a cross section used in the design of beams or other flexural members that will experience deflection due to an applied bending moment. The units of section modulus are length^3. There are two types of section moduli: elastic section modulus and plastic … Read more about Section Modulus: Complete Guide and Calculators
Colored Vector Plot in Excel
In the last blog post, I showed how to use VBA to create a vector plot in Excel. That plot was just a simple black and white vector plot. So in this post I'll show you how to take that chart to the next level with a color scale to indicate the magnitude of the vectors, like the one below: The … Read more about Colored Vector Plot in Excel
C8x11.5 Channel Specifications
C8X11.5 is a rolled structural steel channel shape used in construction and other applications. C8x11.5 Channel Size and Dimensions The dimensions and specifications of C8x11.5 structural steel channel are as follows: Depth 8.00 in. Weight 11.5 lb/ft Area 3.38 in2 Flange … Read more about C8x11.5 Channel Specifications
Create a Vector Plot in Excel
For some time now, I've been interested in figuring out how to create a vector plot in Excel. I didn't really have a need for it personally, but I thought it would be an interesting challenge and might be helpful to someone else. Here's what I came up with, created completely in Excel: Creating … Read more about Create a Vector Plot in Excel
Colebrook-White Equation
The Colebrook-White Equation (or simply Colebrook Equation) is an engineering equation used to approximate the Darcy friction factor (or Darcy-Weisbach friction factor) for turbulent flow in full flowing pipes or ducts. The friction factor is required to calculate the pressure drop or head loss due … Read more about Colebrook-White Equation
Numerical Integration in Excel
There are two primary ways to perform numerical integration in Excel: Integration in Excel via the Spreadsheet Integration using VBA 1. Integration in Excel via the Spreadsheet This type of numerical integration is largely reserved for experimental data. It is useful for when you want … Read more about Numerical Integration in Excel
Linear Interpolation in Excel
To perform linear interpolation in Excel, use the FORECAST function to interpolate between two pairs of x- and y-values directly. In the example below, the formula to interpolate and find the y-value that corresponds to an x-value of 1.4 is: =FORECAST(F2,C3:C4,B3:B4) This simple method … Read more about Linear Interpolation in Excel
Weighted Standard Deviation in Excel
In this post, you’ll learn how to calculate a weighted standard deviation in Excel. A weighted standard deviation calculates the spread in a data set where not all the observations have the same weight. Video: Weighted Standard Deviation in Excel Watch on YouTube | Subscribe to … Read more about Weighted Standard Deviation in Excel
