Proof Stress Calculation with Excel 2007: Manual or Automated?

Click For Summary
SUMMARY

The discussion focuses on calculating proof stress using Excel 2007, emphasizing a manual method. Users can create a line with a y-intercept at 0.2% and a slope equal to the initial slope of the stress-strain curve. The intersection of this line with the curve determines the proof stress. This method is confirmed as effective for determining proof stress in materials.

PREREQUISITES
  • Understanding of stress-strain curves
  • Familiarity with Excel 2007 functions and graphing tools
  • Knowledge of material properties and proof stress concepts
  • Basic skills in linear regression analysis
NEXT STEPS
  • Research how to create graphs in Excel 2007 for stress-strain data
  • Learn about linear regression techniques in Excel
  • Explore material science concepts related to proof stress
  • Investigate automated methods for stress calculations in newer Excel versions
USEFUL FOR

Material engineers, construction professionals, and anyone involved in mechanical testing and analysis of materials will benefit from this discussion.

cbor0023
Messages
7
Reaction score
0
using excel 2007, can the construction to determine the proof stress of a material not be done manually? if so, how?
 
Physics news on Phys.org
Create a line with y intercept at 0.2% and a slope equal to the initial slope of the curve. Check where the line intercepts the curve; this will be the proof stress. Does this answer your question?
 
yes! thanks:) will try it soon:)
 

Similar threads

Undergrad How is the UTS different from breaking stress and why?
  • · Replies 3 ·
Replies
3
Views
14K
Undergrad Finding yield strength with a load/displacement curve
  • · Replies 5 ·
Replies
5
Views
2K
Understanding Yield Strength & Stress Strain Curve
  • · Replies 2 ·
Replies
2
Views
6K
Undergrad Stress Strain Curve: How Is It Derived & Tested?
  • · Replies 4 ·
Replies
4
Views
2K
Confusion Calculating Young's Modulus
  • · Replies 5 ·
Replies
5
Views
2K
What is the difference between failure and fracture?
  • · Replies 4 ·
Replies
4
Views
6K
High School Question about stress - strain graph and definition of hardness
  • · Replies 4 ·
Replies
4
Views
2K
Confidence in FEA stress values?
  • · Replies 9 ·
Replies
9
Views
4K
Capped pressure vessel - strength and stability
  • · Replies 3 ·
Replies
3
Views
2K
Strain and Stress in Thin-Walled Hoops Under Pressure
  • · Replies 9 ·
Replies
9
Views
5K