Proof Stress Calculation with Excel 2007: Manual or Automated?

Thread starter cbor0023
Start date Mar 31, 2011
Tags

Curve Strain Stress Stress strain curve

AI Thread Summary

Using Excel 2007, proof stress calculation can be automated by creating a line with a y-intercept at 0.2% and a slope matching the initial slope of the material's stress-strain curve. The point where this line intersects the curve indicates the proof stress. This method allows for a systematic approach to determining proof stress without manual calculations. Users expressed gratitude for the guidance and indicated plans to try the method soon. Overall, the discussion highlights an effective way to utilize Excel for material stress analysis.

Mar 31, 2011

cbor0023

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

Mar 31, 2011

Mapes

Science Advisor

Homework Helper

Gold Member

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?

Mar 31, 2011

cbor0023

yes! thanks:) will try it soon:)

Thread 'Linear generator prototype'

i want to just test a linear generator with galvanometer , the magnet is N28 and the wire (Cu) is of 0.6mm thikness and 10m long , but galvanometer dont show anthing , The core is PLA material (3d printed) The magnet size if 28mm * 10mm * 5mm

View full post »

Thread 'Mechanism of Energy Conservation in Zero-Amplitude Sum of EM Waveforms'

Assume that this is a case where by sheer coincidence, two sources of coherent single-frequency EM wave pulses with equal duration are both fired in opposing directions, with both carrying the same frequency and amplitude and orientation. These two waves meet head-on while moving in opposing directions, and their phases are precisely offset by 180 degrees so that each trough of one wave meets with the crest of the other. This should be true for both the electric and magnetic components of...

View full post »