Submit Excel calculations for steel/timber bending. Calculate Stress values; but, Strain values are not required. Plot Load-Deformation graph and estimate the Elastic Modulus for each specimen. Upload only one Excel file containing calculations. All Excel calculations will remain as individual assignment.

Steel Flexure:

Bending Stress (σ):

Elastic Modulus (E):

(slope of load-deformation plot)

Note: Moment of inertia for a circular section is I = π/64 d4, and section modulus is S = π/32 d3

Videos:

Test Setup: https://youtu.be/6N0wfg1Kc18

Gauge Readings: https://youtu.be/PTUcqrmZx9k

Dial Factor: 0.005

Timber Flexure: (2 specimens: Douglas-Fir and Pine)

Bending Stress (σ):

Elastic Modulus (E):

(slope of load-deformation plot)

Note: Moment of inertia for rectangular section is I = 1/12 bh3, and section modulus is S=1/6 bh2

Videos:

Test Setup: https://youtu.be/3hB-WaCAFn0

Gauge Readings: Use data attached.

Dial Factor: 0.005