Symmetric I Section

Copy to Native Excel:
Click in the text area below and copy. Then paste into cell A1 of a worksheet. All the formulas are brought in intact but Excel default behaviour controls formatting. A better transfer can be achieved using our XLC add-in for Excel (see below).

<table><tbody><tr><td></td>	<td></td>	<td>Length of sides</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>b =</td>	<td>40</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>d =</td>	<td>50</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>t =</td>	<td>10</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>tw =</td>	<td>15</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Area and distances from centroid to extremities </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Area</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>A =</td>	<td>=2*E2*E4+E5*E3</td>	<td>mm²</td>	<td>in²</td></tr>
				<tr><td></td>	<td></td>	<td>Distance to Extreme Fiber</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>y1 =</td>	<td>=(E3)/(2)+E4</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>y2 =</td>	<td>=(E2)/(2)</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Moments and products of inertia and radii of gyration about central axes </td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Moment of inertia</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>I1 =</td>	<td>=(E2*(E3+2*E4)^3)/(12)-((E2-E5)*E3^3)/(12)</td>	<td>mm⁴</td>	<td>in⁴</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>I2 =</td>	<td>=(E2^3*E4)/(6)+(E5^3*E3)/(12)</td>	<td>mm⁴</td>	<td>in⁴</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Radius of gyration</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>r1 =</td>	<td>=SQRT((E17)/(E9))</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>r2 =</td>	<td>=SQRT((E19)/(E9))</td>	<td>mm</td>	<td>in</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Plastic section moduli shape factors, and locations of plastic neutral axes</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Plastic section modulus </td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>Z1 =</td>	<td>=(E5*E3^2)/(4)+E2*E4*(E3+E4)</td>	<td>mm³</td>	<td>in³</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>Z2 =</td>	<td>=(E2^2*E4)/(2)+(E5^2*E3)/(4)</td>	<td>mm³</td>	<td>in³</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Shape Factor</td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>SF1 =</td>	<td>=(E28*E11)/(E17)</td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td>SF2 =</td>	<td>=(E30*E13)/(E19)</td>	<td></td>	<td></td></tr></tbody></table>

Copy to XLC Enhanced Excel:
Click in the text area below and copy. Then use XLC’s ‘Web Paste’ button to paste at any position in worksheet. This method gives better format control, mathematical formatting and XLC equations.

<table><tbody><tr><td></td>	<td>Length of sides</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>b =</td>	<td>40</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>d =</td>	<td>50</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>t =</td>	<td>10</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>tw =</td>	<td>15</td>	<td>mm</td>	<td>in</td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Area and distances from centroid to extremities</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Area</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>A =</td>	<td>=2*D2*D4+D5*D3</td>	<td>mm²</td>	<td>in²</td>	<td>=EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$31_2")</td></tr>
				<tr><td></td>	<td>Distance to Extreme Fiber</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y1 =</td>	<td>=OVD(D3)/UND(2)+D4</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D11,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$33_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>y2 =</td>	<td>=OVD(D2)/UND(2)</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D13,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$35_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Moments and products of inertia and radii of gyration about central axes</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Moment of inertia</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I1 =</td>	<td>=OVD(D2*(D3+2*D4)^3)/UND(12)-OVD((D2-D5)*D3^3)/UND(12)</td>	<td>mm⁴</td>	<td>in⁴</td>	<td>=EQS(D17,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$39_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>I2 =</td>	<td>=OVD(D2^3*D4)/UND(6)+OVD(D5^3*D3)/UND(12)</td>	<td>mm⁴</td>	<td>in⁴</td>	<td>=EQS(D19,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$41_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Radius of gyration</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r1 =</td>	<td>=SQRT(OVD(D17)/UND(D9))</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D22,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$44_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>r2 =</td>	<td>=SQRT(OVD(D19)/UND(D9))</td>	<td>mm</td>	<td>in</td>	<td>=EQS(D24,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$46_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td>Plastic section moduli shape factors, and locations of plastic neutral axes</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Plastic section modulus</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z1 =</td>	<td>=OVD(D5*D3^2)/UND(4)+D2*D4*(D3+D4)</td>	<td>mm³</td>	<td>in³</td>	<td>=EQS(D28,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$50_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>Z2 =</td>	<td>=OVD(D2^2*D4)/UND(2)+OVD(D5^2*D3)/UND(4)</td>	<td>mm³</td>	<td>in³</td>	<td>=EQS(D30,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$52_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td>Shape Factor</td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF1 =</td>	<td>=OVD(D28*D11)/UND(D17)</td>	<td></td>	<td></td>	<td>=EQS(D33,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$55_2")</td></tr>
				<tr><td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td>	<td></td></tr>
				<tr><td></td>	<td></td>	<td>SF2 =</td>	<td>=OVD(D30*D13)/UND(D19)</td>	<td></td>	<td></td>	<td>=EQS(D35,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp$J$57_2")</td></tr></tbody></table>

Units: SI(mm) & US(in) - delete as appropriate.

Repository Link
Check version history of this calculation; subscribe for revision history email notification; add a comment; add your rating; add to your favourites; download excel file including graphics.

Include in Your Website: Copy HTML code snippet to create a dynamic window to this page from your own website.