On the Blackboard download the two spreadsheets Brassxlsx an

On the Blackboard, download the two spreadsheets (Brass.xlsx and Aluminum.xlsx) containing load and strain data. Use excel (or another computer program) to create stress-strain curves for these specimens. The specimens had a diameter of 0.505 inches. Find and label: a) Yield stress and b) Modulus of elasticity

help me on how to upload the excel files please

Solution

In microsoft excel you can draw the plot.

First get the load and elongation data from tensile test.

then convert the corresponding load and elongation datapoints into stress and strain data points by using appropriate formulaes.

stress =load/ area strain = elongation/ original gage length

now in excel in 1st column tabulate all the strain points and in 2nd column all the stress points. With the help of these two columns you can insert a plot between them keeping strain in x axis and stress in y axis.

In the plot so obtained , the data point upto which the stress strain curve increases linearly gives the value of yield strangth ( 0.2 percent offset you can also find as (stress +0.002 E) where E is Young\'s Modulus obtained as slope of linear portion of the curve.

The point after which the stress strain curve starts decresing gives the value of UTS.