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).
Length of sides
b = 40 mm in
d = 50 mm in
t = 10 mm in
tw = 15 mm in
Area and distances from centroid to extremities
Area
A = =2*E2*E4+E5*E3 mm² in²
Distance to Extreme Fiber
y1 = =(E3)/(2)+E4 mm in
y2 = =(E2)/(2) mm in
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =(E2*(E3+2*E4)^3)/(12)-((E2-E5)*E3^3)/(12) mm⁴ in⁴
I2 = =(E2^3*E4)/(6)+(E5^3*E3)/(12) mm⁴ in⁴
r1 = =SQRT((E17)/(E9)) mm in
r2 = =SQRT((E19)/(E9)) mm in
Plastic section moduli shape factors, and locations of plastic neutral axes
Plastic section modulus
Z1 = =(E5*E3^2)/(4)+E2*E4*(E3+E4) mm³ in³
Z2 = =(E2^2*E4)/(2)+(E5^2*E3)/(4) mm³ in³
Shape Factor
SF1 = =(E28*E11)/(E17)
SF2 = =(E30*E13)/(E19)
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.
Length of sides
b = 40 mm in
d = 50 mm in
t = 10 mm in
tw = 15 mm in
Area and distances from centroid to extremities
Area
A = =2*D2*D4+D5*D3 mm² in² =EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$31_2")
Distance to Extreme Fiber
y1 = =OVD(D3)/UND(2)+D4 mm in =EQS(D11,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$33_2")
y2 = =OVD(D2)/UND(2) mm in =EQS(D13,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$35_2")
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =OVD(D2*(D3+2*D4)^3)/UND(12)-OVD((D2-D5)*D3^3)/UND(12) mm⁴ in⁴ =EQS(D17,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$39_2")
I2 = =OVD(D2^3*D4)/UND(6)+OVD(D5^3*D3)/UND(12) mm⁴ in⁴ =EQS(D19,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$41_2")