Creating S-N Diagrams with Excel

  • Thread starter Thread starter fmunene
  • Start date Start date
  • Tags Tags
    Diagrams
Click For Summary
To create an S-N diagram in Excel, the y-axis should represent stress (S), calculated using the formula S = 32*M/(π*d^3), where M is the moment and d is the diameter. The number of cycles (N) will be plotted on the x-axis. After computing the stress values for each data point, use the scatter function to plot S against N. For better visualization, apply the log-log display option in Excel. This method will effectively illustrate the relationship between stress and the number of cycles.
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.
 
Had my central air system checked when it sortta wasn't working. I guess I hadn't replaced the filter. Guy suggested I might want to get a UV filter accessory. He said it would "kill bugs and particulates". I know UV can kill the former, not sure how he thinks it's gonna murder the latter. Now I'm finding out there's more than one type of UV filter: one for the air flow and one for the coil. He was suggesting we might get one for the air flow, but now we'll have to change the bulb...

Similar threads

  • · Replies 7 ·
Replies
7
Views
5K
  • · Replies 9 ·
Replies
9
Views
5K