Proof Stress Calculation with Excel 2007: Manual or Automated?

[cbor0023]

using excel 2007, can the construction to determine the proof stress of a material not be done manually? if so, how?

 

[Mapes]

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?

 

[cbor0023]

yes! thanks:) will try it soon:)