Excel file

Upload One Excel file with multiple sheets/tabs; make sure each sheet is clearly labeled -- see figure below.
A) Timber Compression:
Plot Stress-Strain graphs for Pine, and Douglas-Fir specimens. Report following parameters:

1. Elastic Modulus (E)
2. Proportional Limit (Fpro)
3. Ultimate Stress (Fult)
   Note 1: The data for Douglas-Fir Specimen could be obtained from a pdf file: Douglas Fir Data.pdf
   Note 2: The data for Pine specimen could be obtained from the video.
   Video: https://youtu.be/FdlNH3eDFY
   B) Steel Commercial Tension:
   Report Yield Stress (Fy), Ultimate Stress (Fu), and Rupture Stress (FRUP) for three color-coded specimens
   tested.
   Report Ductility for each specimen based on elongation D = ( Lf - Li ) / Li x 100, and reduction in area D = ( Ai -
   Af ) / Ai x 100.
   Note: Subscripts f and i are respectively for "Final" and "Initial" measurements.
   Video: https://youtu.be/tgEjDGdW2hc
   C) Steel Shear:
   Report Ultimate/Peak Shear Strength. Use following equation:
   Video: https://youtu.be/r3-kK1TuQe8

Sample Solution