@@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?
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
I tried calculating two equations for two variables, but not even Wolfram alpha gave the answer. I probably made a mistake alpng the way. However, in my search I stumbled upon a method to determine accurate 0,2%YS: I should mention you need very precise data. We're talking about measuring tge elongation every 0,01 second minimum. Then you can subtract the 0,2% strain from the original elastic-region strain, find value closest to zero ...=min(absolute_value(*region*))... and find the corresponding stress ...=vlookup...
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 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!🍀
Thank you Dr. Gucci, for saving me time on my material engineering labs.
Hope you have a good day !
Glad it helps!
Thank you Dr. Gucci. I am a undergraduate student and this material is challenging to comprehend. Thank you for your time
Most helpful video I have seen on yt
Thank you Dr. Gucci! I appreciate this video
YOU ARE THE BESSSSSSST PERSON EVER!!!!!!!
good to watch and refresh the memories~
thanks for sharinggg
I am PhD Student at the moment =D
Glad you like it! Good luck on your PhD Study.
gucci you're the OG.
This was incredibly helpful.
Thank you Sir!! You saved my semester❤
Nice beautifully explained
thank you for this. this would help me much
ty Dr Gucci! labs uggh
Thank you Prof.
thank you Sir. good job
Is there an exact way of calculating the intercept of the two lines to determine the exact yield stress?
Not as I know so far.
I need the interception point as well. Could you please tell me how to find the coordinate of interception sir? (Not predicting ,need accurate)
I do not see Excel has that function yet. So, you would have to estimate so far. Sorry!
@@DrGucci Thanks for answering sir, good works...
@@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?
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
I tried calculating two equations for two variables, but not even Wolfram alpha gave the answer. I probably made a mistake alpng the way. However, in my search I stumbled upon a method to determine accurate 0,2%YS:
I should mention you need very precise data. We're talking about measuring tge elongation every 0,01 second minimum. Then you can subtract the 0,2% strain from the original elastic-region strain, find value closest to zero ...=min(absolute_value(*region*))... and find the corresponding stress ...=vlookup...
Useful video. Could you please tell me how to find out Guaranteed tensile strength and guaranteed tensile strain from tensile test data
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!
Thank You Sir
،how can found the value of k?
wouldnt the strain be (l-l_0)/l_0? instead of l-l_0?
It is (l-l_0)/l_0. That is also what I did in the video, which I used elongation devideed by the original length.
I followed all the steps but my offset doesn't intersect the curve. huhu please help
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.🙂
@@DrGucci The offset just follows the original curve. no intersection at all. Perhaps there's something wrong with our young's modulus?
@@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!🍀
Great.
GUCCI!