Question

Objective: Learn how to apply and use Excel spreadsheets in data post-processing Emphasize on axial stress in tensile test and ductile-to-brittle transition for material selection and design. Solve the below problems with Microsoft Excel. - Create a summarized file report containing your Name, ID, answers and figures. -Label correctly your graphs-axis-titles and employ the correct units. Convert your file to PDF and submit individually on BBlearn Problem 1 A specimen of magnesium having a rectangular cross-section of dimensions 3.2 mm x Length Load 19.1 mm is deformed in tension. Using the load-elongation data tabulated as follows, complete parts (a) through (f) using Microsoft excel and SI units Ib in mm 0 0 2.500 63.50 1380 63.53 310 2.501 625 2780 2.502 63.56 (a) Plot the data as engineering stress versus engineering strain 1265 5630 2.505 63.62 1670 7430 2.508 63.70 (b) Compute the modulus of elasticity. 1830 8140 2.510 63.75 2220 9870 2.525 64.14 (c) Determine the yield strength at a strain offset of 0.002 12,850 2.575 65.41 2890 3170 2.625 66.68 14,100 3225 14,340 2.675 67.95 (d) Determine the tensile strength of this alloy. 3110 13,830 2.725 69.22 2810 (e) Compute the modulus of resilience. 12,500 2.775 70.49 Fracture (f) What is the ductility, in percent elongation?

Answer 1

Page Layout Insert le Home E AutoSum cut Calibri ECopy Fill Conditional Format Formatting as Table Styles Sort &Find 8 Fiter Select Editing Paste Cell Insert Delete Format Format Painter B ciear" clipboard Number Styles Cells K19 A 1load(N) area(mm)| D G stress(N/mm] modulus of elasticity Yield strength Tensile strength Modulus of resilience Ductility( % ) 11.01 length (mm) strain 234.62 61.12 0 2 63.5 38596.61322 0.52 200 22.57853403 0.000472441 0.000944882 3 1380 63.53 63.56 4 2780 45.48429319 92.11387435 63.62 51 5630 0.001889764 0.003149606 121.5641361 6 7430 63.7 133.1806283 0.003937008 7 8140 63.75 64.14 0.01007874 0.03007874 0.05007874 0.07007874 161.4856021 9870 210.2421466 12850 65.41 10 14100 11 14340 12 13830 13 12500 66.68 230.6937173 234.6204188 67.95 69.22 226.276178 0.09007874 70.49 204.5157068 0.11007874 14 51 Stress vs Strain 6 9 Modulus of elasticity: slope of linear stress strain curve 200N/mm2 Maximum stress in stress strain curve- 234.62 N/mm2 Yield strength at strain offset of 0.02 Tensile strength: Modulus of resilience:(yield strength/2E ductility Final gauge length Initial gauge length/initial gauge length 002.04 o.e