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 'A Time Crystal Visible to the Human Eye'

https://interestingengineering.com/science/worlds-first-time-crystal-visible-human-eye

View full post »

Thread 'Why can't Solar panels be hemispherical, or a curved strip type?'

comparing a flat solar panel of area 2π r² and a hemisphere of the same area, the hemispherical solar panel would only occupy the area π r² of while the flat panel would occupy an entire 2π r² of land. wouldn't the hemispherical version have the same area of panel exposed to the sun, occupy less land space and can therefore increase the number of panels one land can have fitted? this would increase the power output proportionally as well. when I searched it up I wasn't satisfied with...

View full post »