XLC Trial (1M) XLC Ed (12M) XLC Pro (12M) Hover over ticks and crosses for further detail. A little taste of what we have to offer Reduced price for students and teachers For engineering professionals and corporations Website Repository Trial Folder Full Repository access Hide site Google Ads Document control and update notification Forum access to expert community Commercial use of Repository downloads. XLC add-in XLC Add-in Toolbar version Full XLC equation functionality XLC Multiple installations XLC reinstalls not required XLC support Commercial use of XLC add-in Payment Instant site access with PayPal Instant site access with Credit Card Full 12 month term applied on sign up Volume Discount Alternative Payment methods On-site training/engineering consultancy. Subscription duration 1 month 12 month 12 month Cost of subscription Free \$45 USD \$90 USD

 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 = 30 mm in
d = 50 mm in
d1 = 20 mm in
b1 = 5 mm in
Area and distances from centroid to extremities
Area of Rectangle
A = =D2*D3-D5*D4 mm² in²
Distance to Extreme Fiber
y1 = =(D3)/(2) mm in
y2 = =(D2)/(2) mm in
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =(D2*D3^3-D5*D4^3)/(12) mm⁴ in⁴
I2 = =(D3*D2^3-D4*D5^3)/(12) mm⁴ in⁴
r1 = =SQRT((D17)/(D9)) mm mm
r2 = =SQRT((D19)/(D9)) mm mm
Plastic section moduli shape factors, and locations of plastic neutral axes
Plastic section modulus
Z1 = =(D2*D3^2-D5*D4^2)/(4) mm³ in³
Z2 = =(D3*D2^2-D4*D5^2)/(4) mm³ in³
Shape Factor
SF1 = =(D28*D3)/(2*D17)
SF2 = =(D30*D2)/(2*D19)
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 = 30 mm in
d = 50 mm in
d1 = 20 mm in
b1 = 5 mm in
Area and distances from centroid to extremities
Area of Rectangle
A = =D2*D3-D5*D4 mm² in² =EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$33_2")
Distance to Extreme Fiber
y1 = =OVD(D3)/UND(2) mm in =EQS(D11,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$36_2")
y2 = =OVD(D2)/UND(2) mm in =EQS(D13,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$37_2")
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =OVD(D2*D3^3-D5*D4^3)/UND(12) mm⁴ in⁴ =EQS(D17,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$45_2")
I2 = =OVD(D3*D2^3-D4*D5^3)/UND(12) mm⁴ in⁴ =EQS(D19,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$47_2")
r1 = =SQRT(OVD(D17)/UND(D9)) mm mm =EQS(D22,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$51_2")
r2 = =SQRT(OVD(D19)/UND(D9)) mm mm =EQS(D24,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$52_2")
Plastic section moduli shape factors, and locations of plastic neutral axes
Plastic section modulus
Z1 = =OVD(D2*D3^2-D5*D4^2)/UND(4) mm³ in³ =EQS(D28,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$56_2")
Z2 = =OVD(D3*D2^2-D4*D5^2)/UND(4) mm³ in³ =EQS(D30,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$58_2")
Shape Factor
SF1 = =OVD(D28*D3)/UND(2*D17) =EQS(D33,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$61_2")
SF2 = =OVD(D30*D2)/UND(2*D19) =EQS(D35,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$63_2")
 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")
r1 = =SQRT(OVD(D17)/UND(D9)) mm in =EQS(D22,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$44_2")
r2 = =SQRT(OVD(D19)/UND(D9)) mm in =EQS(D24,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$46_2")
Plastic section moduli shape factors, and locations of plastic neutral axes
Plastic section modulus
Z1 = =OVD(D5*D3^2)/UND(4)+D2*D4*(D3+D4) mm³ in³ =EQS(D28,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$50_2")
Z2 = =OVD(D2^2*D4)/UND(2)+OVD(D5^2*D3)/UND(4) mm³ in³ =EQS(D30,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$52_2")
Shape Factor
SF1 = =OVD(D28*D11)/UND(D17) =EQS(D33,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$55_2")
SF2 = =OVD(D30*D13)/UND(D19) =EQS(D35,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$J\$57_2")
 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 = 80 mm in
d = 30 mm in
t = 10 mm in
tw = 15 mm in
Area and distances from centroid to extremities
Area
A = =E4*E2+2*E5*E3 mm² in²
Distance to Extreme Fiber
y1 = =(E2*E4^2+2*E5*E3*(2*E4+E3))/(2*(E4*E2+2*E5*E3)) mm in
y2 = =(E2)/(2) mm in
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =(E2)/(3)*(E3+E4)^3-(E3^3)/(3)*(E2-2*E5)-E9*(E3+E4-E12)^2 mm⁴ in⁴
I2 = =((E3+E4)*E2^3)/(12)-(E3*(E2-2*E5)^3)/(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
Z1a = =(E3^2*E5)/(2)-(E2^2*E4^2)/(8*E5)+(E2*E4*(E3+E4))/(2) mm³ in³
Z1b = =(E4^2*E2)/(4)+E5*E3*(E4+E3-(E5*E3)/(E2)) mm³ in³
Z1 = =IF(2*E5*E3<=E2*E4,E28,E30) mm³ in³
s1 = =(E2*E4/2*E5+E3)/2 mm in
s2 = =E5*E3/E2+E4/2 mm in
s = =IF(2*E5*E3<=E2*E4,E34,E36) mm in
Z2 = =(E2^2*E4)/(4)+E5*E3*(E2-E5) mm³ in³
Shape Factor
SF1 = =(E32*(E3+E4-E12))/(E17)
SF2 = =(E40*E2)/(2*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 = 80 mm in
d = 30 mm in
t = 10 mm in
tw = 15 mm in
Area and distances from centroid to extremities
Area
A = =D4*D2+2*D5*D3 mm² in² =EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$34_0")
Distance to Extreme Fiber
y1 = =OVD(D2*D4^2+2*D5*D3*(2*D4+D3))/UND(2*(D4*D2+2*D5*D3)) mm in =EQS(D12,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$37_0")
y2 = =OVD(D2)/UND(2) mm in =EQS(D14,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$38_0")
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
I1 = =OVD(D2)/UND(3)*(D3+D4)^3-OVD(D3^3)/UND(3)*(D2-2*D5)-D9*(D3+D4-D12)^2 mm⁴ in⁴ =EQS(D18,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$42_0")
I2 = =OVD((D3+D4)*D2^3)/UND(12)-OVD(D3*(D2-2*D5)^3)/UND(12) mm⁴ in⁴ =EQS(D20,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$43_0")
r1 = =SQRT(OVD(D18)/UND(D9)) mm in =EQS(D23,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$46_0")
r2 = =SQRT(OVD(D20)/UND(D9)) mm in =EQS(D25,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$48_0")
Plastic section moduli shape factors, and locations of plastic neutral axes
Plastic section modulus
Z1a = =OVD(D3^2*D5)/UND(2)-OVD(D2^2*D4^2)/UND(8*D5)+OVD(D2*D4*(D3+D4))/UND(2) mm³ in³ =EQS(D29,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$52_0")
Z1b = =OVD(D4^2*D2)/UND(4)+D5*D3*(D4+D3-OVD(D5*D3)/UND(D2)) mm³ in³ =EQS(D31,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$54_0")
Z1 = =IF(2*D5*D3<=D2*D4,D29,D31) mm³ in³ =EQS(D33,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$56_0")
s1 = =(D2*D4/2*D5+D3)/2 mm in =EQS(D35,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$58_0")
s2 = =D5*D3/D2+D4/2 mm in =EQS(D37,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$60_0")
s = =IF(2*D5*D3<=D2*D4,D35,D37) mm in =EQS(D39,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$62_0")
Z2 = =OVD(D2^2*D4)/UND(4)+D5*D3*(D2-D5) mm³ in³ =EQS(D41,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$64_0")
Shape Factor
SF1 = =OVD(D33*(D3+D4-D12))/UND(D18) =EQS(D44,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$67_0")
SF2 = =OVD(D41*D2)/UND(2*D20) =EQS(D46,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$69_0")
 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
R = 20 mm in
Ri = 15 mm in
Area and distances from centroid to extremities
Area
A = =PI()*(D2^2-D3^2) mm² in²
Distance to Extreme Fiber
yc = =D2 mm in
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
Ix = =(PI())/(4)*(D2^4-D3^4) mm⁴ in⁴
Iy = =(PI())/(4)*(D2^4-D3^4) mm⁴ in⁴
rx = =(1)/(2)*SQRT(D2^2+D3^2) mm in
ry = =(1)/(2)*SQRT(D2^2+D3^2) mm in
Plastic section moduli, shape factors, and locations of plastic neutral axes
Plastic section modulus
Zx = =1.333*(D2^3-D3^3) mm³ in³
Zy = =1.333*(D2^3-D3^3) mm³ in³
Shape factor
SFx = =1.698*((D2^4-D3^3*D2)/(D2^4-D3^4))
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
R = 20 mm in
Ri = 15 mm in
Area and distances from centroid to extremities
Area
A = =PI()*(D2^2-D3^2) mm² in² =EQS(D7,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$31_0")
Distance to Extreme Fiber
yc = =D2 mm in =EQS(D9,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$33_0")
Moments and products of inertia and radii of gyration about central axes
Moment of inertia
Ix = =OVD(PI())/UND(4)*(D2^4-D3^4) mm⁴ in⁴ =EQS(D13,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$37_0")
Iy = =OVD(PI())/UND(4)*(D2^4-D3^4) mm⁴ in⁴ =EQS(D15,"Units= ; EqnPrefix=Eqn. ; EqnNo= 0; Multiplication= 0; ShowWorking= 0; EqnStyle= 0; Eqp\$H\$39_0")