Plotting 0.2% Offset Strain on Stress-Strain Curve With Excel

[@MehmetKaya-vq4sw]

Thank you Dr. Gucci! I appreciate this video

[@aznman85]

Thank you Dr. Gucci. I am a undergraduate student and this material is challenging to comprehend. Thank you for your time

[@louisfyee8726]

good to watch and refresh the memories~ thanks for sharinggg I am PhD Student at the moment =D

[@DrGucci]

Glad you like it! Good luck on your PhD Study.

[@theotema2053]

Thank you Sir!! You saved my semester❤

[@obione51499]

This was incredibly helpful.

[@lordsiomai]

thank you for this. this would help me much

[@semihdere917]

gucci you're the OG.

[@selleryy]

thank you Sir. good job

[@tolaitc6437]

Thank you Prof.

[@kamaljitsinghboparai3595]

Nice beautifully explained

[@muhammadtalha5997]

Great.

[@suryaprasanth9105]

Thank You Sir

[@shaikbaized6660]

Useful video. Could you please tell me how to find out Guaranteed tensile strength and guaranteed tensile strain from tensile test data

[@DrGucci]

I have not heard the term "guaranteed tensile strength" and "guaranteed tensile strain" so I do not know what they refer to. Sorry about that!

[@Duncanwg7]

Is there an exact way of calculating the intercept of the two lines to determine the exact yield stress?

[@DrGucci]

Not as I know so far.

[@taxfree4603]

GUCCI!

[@oldwolfp]

I need the interception point as well. Could you please tell me how to find the coordinate of interception sir? (Not predicting ,need accurate)

[@DrGucci]

I do not see Excel has that function yet. So, you would have to estimate so far. Sorry!

[@oldwolfp]

@@DrGucci Thanks for answering sir, good works...

[@zacharyhill6473]

@@oldwolfp I'm having the same problem. I tried created different types of functions and using the Excel add-in solver to give me variables that could actually model the stress-strain curve (since no trendline comes close); the solver was working, but it would just use the same trendline variables or give errors. Idk what I expected =l There must be a way to pull the equations of the splines off of the curve that the scatterplot makes, right? I mean, how else would Excel plot that line? Digging through Excel articles to that end. Did you find anything or did you end up approximating?

[@aznman85]

My assumption to finding the intersection of two lines is to create another line from the original stress-strain curve. By doing so you have two functions that you can set equal to each other an solve for the intersection point

[@keimchi8035]

I followed all the steps but my offset doesn't intersect the curve. huhu please help

[@DrGucci]

You can double check your work first. I have had hundreds of students in class completed their graph with this video. They all got the correct graph so the tutorial should be correct. If you still have questions, you can leave message here.🙂

[@keimchi8035]

@@DrGucci The offset just follows the original curve. no intersection at all. Perhaps there's something wrong with our young's modulus?

[@DrGucci]

@@keimchi8035 You can double check all your data and see you have the same number with mine. Especially make sure your column E and F have the same number with mine. Also double check if you chose column E & F when plotting the trend. Good luck!🍀