how to create engineering stress strain curves in EXCEL

This video shows how to create engineering stress strain curves in Excel using data from a completed tensile test. This video also shows how to find the 0.2% offset line, Young's Modulus (YM), yield, ultimate & fracture stress. If you need help getting started, you can find the completed Excel workbook from this video here: https://www.dropbox.com/scl/fi/cdocug... Engineering vs. True stress/strain: Engineering stress and strain use the original dimensions of a material, while true stress and strain account for the changing dimensions during deformation. Engineering stress is calculated by dividing the applied force by the initial cross-sectional area, and engineering strain is the change in length divided by the original length. True stress uses the instantaneous cross-sectional area, and true strain uses the natural logarithm of the instantaneous length over the original length. A great resource video for understanding engineering vs. true stress/strain:    • Understanding True Stress and True Strain   TIME STAMPS: 0:00 - intro 0:53 - setting up the excel sheet & defining tensile mechanical properties 5:49 - converting load and extension into stress and strain 7:55 - plotting the stress strain curve 8:38 - finding the linear region and YOUNG'S MODULUS (graphically) 11:25 - 0.2% offset line for determining YIELD stress 13:59 - finding YIELD stress 15:08 - finding ULTIMATE stress 15:32 - finding FRACTURE stress 15:58 - improving the stress strain curve plot with labels and legend 16:53 - another way to determine YOUNG'S MODULUS with built in excel functions ( =SLOPE, =RSQ or =CORREL) 19:40 - conclusion Thank YOU for watching! Join our community discord server:   / discord   Support with a coffee if you'd like :) https://buymeacoffee.com/strelkomania