Creating S-N Diagrams with Excel

  • Thread starter Thread starter fmunene
  • Start date Start date
  • Tags Tags
    Diagrams
Click For Summary
SUMMARY

This discussion focuses on creating S-N diagrams using Excel, specifically how to plot stress (S) against the number of cycles (N). The formula for calculating stress is provided: S = 32*M/(π*d³), where M is the moment and d is the diameter. Users are guided to use the scatter function in Excel for plotting and to utilize the log-log display option for better visualization of the data. The discussion includes specific data points for average diameter, moment, and number of cycles to facilitate the plotting process.

PREREQUISITES
  • Understanding of S-N curves and their significance in material fatigue analysis.
  • Familiarity with Excel's scatter plot functionality.
  • Knowledge of basic mathematical formulas for stress calculation.
  • Ability to manipulate data in Excel, including using equations and formatting graphs.
NEXT STEPS
  • Learn how to implement the formula S = 32*M/(π*d³) in Excel for stress calculations.
  • Research techniques for creating log-log plots in Excel for better data representation.
  • Explore advanced Excel functions for data analysis and visualization.
  • Study the principles of fatigue analysis and the significance of S-N diagrams in engineering.
USEFUL FOR

Engineers, material scientists, and students involved in fatigue analysis and data visualization using Excel will benefit from this discussion.

fmunene
Messages
1
Reaction score
0
Hello, I need help
with plotting a S-N curve using Excel given the data below
I know how to plot using the scatter function in excel but i am confused on what values should go on the y-axis...i.e S...it is clear that the number of cycles will obviously go onto the x-axis...Please explain what excel equations I need to get . Any help will be highly appreciated.

"Average Diameter [in]","Moment [in-lb]","Number Cycles [N]"
0.25, 122.718463, 20000
0.2513, 101.2723101, 40000
0.2496, 91.59776729, 100000
0.2503, 76.97548741, 200000
0.2506, 61.80207912, 500000
0.2513, 52.1941906, 1000000
0.251, 46.5738686, 2000000
0.2513, 38.95088851, 5000000
0.2503, 33.09945959, 10000000
0.2506, 30.90103956, 100000000
 
Engineering news on Phys.org
fmunene: Compute stress, S = 32*M/(pi*d^3), where d = diameter. After you plot S versus N, display the graph with the log-log display option.
 

Similar threads

Plotting S-N Diagram with Cycles to Failure
  • · Replies 7 ·
Replies
7
Views
5K
Undergrad EM Spectrum's Official EM Ranges
  • · Replies 9 ·
Replies
9
Views
5K