Proof Stress Calculation with Excel 2007: Manual or Automated?

Thread starter cbor0023
Start date Mar 31, 2011
Tags

Curve Strain Stress Stress strain curve

In summary, calculating proof stress with Excel 2007 allows for determining the maximum stress a material can withstand before permanent deformation. It can be done manually or using an automated process, with the necessary inputs being the initial length and diameter of the material, maximum load applied, and final length. Excel 2007 can also be used to plot a stress-strain curve, but it has limitations such as assuming a perfect linear relationship and potential errors if incorrect data or formulas are entered. It is important to have a basic understanding of the manual calculation before using the automated process.

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:)

Related to Proof Stress Calculation with Excel 2007: Manual or Automated?

1. What is the purpose of calculating proof stress with Excel 2007?

The purpose of calculating proof stress with Excel 2007 is to determine the maximum amount of stress that a material can withstand before it begins to deform permanently. This information is useful in designing and testing materials for various applications, such as in construction or manufacturing.

2. Is it better to calculate proof stress manually or using an automated process in Excel 2007?

It ultimately depends on personal preference and the complexity of the calculation. Manual calculation allows for a better understanding of the process and potential errors, while automated calculation can save time and ensure accuracy. It is recommended to have a basic understanding of the manual calculation before using the automated process.

3. What are the necessary inputs for calculating proof stress in Excel 2007?

The necessary inputs for calculating proof stress in Excel 2007 include the initial length and diameter of the material being tested, the maximum load applied, and the final length of the material after testing. These inputs can be obtained through experimentation or provided by material specifications.

4. How can Excel 2007 be used to plot a stress-strain curve for proof stress calculation?

Excel 2007 has a built-in feature for creating a scatter plot, which can be used to plot the stress-strain data points obtained from the calculation. Simply select the data points and choose the scatter plot option from the Insert tab. This will create a visual representation of the data, making it easier to analyze and determine the proof stress.

5. Are there any limitations to using Excel 2007 for proof stress calculation?

Yes, there are some limitations to using Excel 2007 for proof stress calculation. One limitation is that it assumes a perfect linear relationship between stress and strain, which may not always be the case. Additionally, errors can occur if the incorrect formula or data is entered. It is important to double check the inputs and formulas to ensure accurate results.