Moment of inertia formula calculator update#
Moment of inertia formula calculator series#

Moment of inertia formula calculator series#

That concludes this 3-post series on the mass moment of inertia calculator. The finished spreadsheet looks like this: The calculated result will have the same units as your input. Enter the radius R or the diameter D below. Formula: The formula for the moment of inertia of a. Moment of inertia Rectangular shape/section (formula) Strong Axis I y 1 12 h 3 w Weak Axis I z 1 12 h 3 w Dimensions of rectangular Cross-section. This tool calculates the moment of inertia I (second moment of area) of a circle. I copied that same formula for I y and I z, updating the col_index_num to reflect the position of the moment of inertia in the y- and z-axis in the moment of inertia table.įinally, to make it absolutely clear what shape is being calculated for, I added a heading at the top of the results section that automatically updates with the radio button selection using VLOOKUP and the shorthand replacement for CONCATENATE, “&”. The moment of inertia of an item is determined by its mass distribution relative to its axis of rotation.

Moment of inertia formula calculator update#

I can use that output in a VLOOKUP function to dynamically update the result area based on the shape selected. However, the calculation is more straightforward if the combination (A+C)+ (B+C)-C is adopted. The final area, may be considered as the additive combination of A+B+C. I know what was selected based on the results of the radio button output cell, B16. The moments of inertia of an angle can be found, if the total area is divided into three, smaller ones, A, B, C, as shown in figure below. Please use consistent units for any input.

The calculated results will have the same units as your input. Enter the shape dimensions 'b' and 'h' below. When a user selects a shape, I want the displayed results to reflect that selection. The formula calculates the moment of inertia of a filled annulus cross section with inner radius r1 and outer radius r2 with respect to a horizontal axis. This tool calculates the moment of inertia I (second moment of area) of a rectangle. Online calculator for pipe properties is a convenient tool for instantly calculating the weight of steel pipes and its contents including internal area of pipe.

This way, I can use a lookup function to extract the calculated result from the table and report it clearly elsewhere in the sheet.Īfter entering all of the formulas and some values, the table looks as shown below: Below the input dimensions I set up a table to calculate the moments of inertia for all of the shapes.Īs you can see, I included the number corresponding to the radio button output in the first column.