The 0.2% Offset Method in Excel

The 0.2% offset method is the standard for finding the yield strength of materials. Here's how we can take some Excel data and use the 0.2% offset in Excel - no pencil required!

Пікірлер: 39

  • @hassantheman1017
    @hassantheman10173 жыл бұрын

    this is like the sixth time im coming back to this video

  • @spectrexfpv

    @spectrexfpv

    3 жыл бұрын

    tenth for me😂 every single time

  • @appleofmyeyes_kr
    @appleofmyeyes_kr3 жыл бұрын

    Thank you so so much sir....... Sending love from Korea....... TT I was struggling with my report and I finally found your explanation video.... You saved me.. TT

  • @birkwin2250
    @birkwin22502 жыл бұрын

    Hi, Australian biomed student here! This helped out a whole great deal in furthering my understanding of Excels tools, and with me finishing my assignment on time. It may be 1am right now but I just wanted to give thanks, have a great one 👍

  • @lukeschmidtler8855
    @lukeschmidtler88553 жыл бұрын

    You are a very good speaker and did an amazing job explaining this, thank you!

  • @omaralessa8598
    @omaralessa85983 жыл бұрын

    you are a legend and a fantastic instructor. Thank you for this tutorial

  • @noahgarcia731
    @noahgarcia7312 жыл бұрын

    Very informative and easy to understand video! Thanks so much, now I can get back to my lab!

  • @kilroy3363
    @kilroy33633 жыл бұрын

    Fantastic tutorial. You saved me so much stress and time on my report

  • @sumayyahabdulla288
    @sumayyahabdulla2883 жыл бұрын

    You're a lifesaver, Sir. Thank you :)

  • @Jabonte
    @Jabonte3 жыл бұрын

    This video is awesome. Thanks so much for the help!

  • @LukeTheFist
    @LukeTheFist2 жыл бұрын

    Hello, thank you very much for this video! It's very helpful. I just have two remarks: 1. In the equation for the 0.2% offset strain, I believe the 0.2% alone is not right. As it is a relative value (0.2% of what?), it must be multiplied by the total plastic strain. Therefore, the equation should be =CV+0.002*MAX(Strain column). 2. When you place your pointer on a scatter plot, it shows you only the closest known (assigned) value from your dataset, it doesn't show you the actual value of the exact position you're in. Therefore, the end result would be closer to 38 ksi. Other than this, very good job in explaining the method. It helped me a lot! Thank you once again!

  • @dyaaddin2366
    @dyaaddin23664 жыл бұрын

    Thank you sir, this helped me alot

  • @anakagunggedebagussuryakri4762
    @anakagunggedebagussuryakri47624 жыл бұрын

    Thankyou for your explaination sir 🙏

  • @abkamara7953
    @abkamara79533 жыл бұрын

    You saved me tons of time!

  • @luisa-lc1ho
    @luisa-lc1ho3 жыл бұрын

    mate, you are the best

  • @ethansobkowich8185
    @ethansobkowich81853 жыл бұрын

    Thank you so much sir you helped me with my lab so much

  • @rileymccue3641
    @rileymccue3641 Жыл бұрын

    Thank you! this helped a lot

  • @chameeraperera9022
    @chameeraperera90223 жыл бұрын

    Thank you so much sir.

  • @Stans_well
    @Stans_well2 жыл бұрын

    Although I recommend watching the whole video, for those just figuring out what to input for the .2% offset skip to 8:30

  • @rodrigomecalco4220
    @rodrigomecalco42203 жыл бұрын

    this help me a lot thx

  • @nurikapcoglu9884
    @nurikapcoglu98843 жыл бұрын

    ı dont know who you are but i know that i love you.

  • @owenchamberlain9731
    @owenchamberlain9731 Жыл бұрын

    Absolute baller video real alpha male shit, thanks G

  • @paytonbryce4101
    @paytonbryce41013 жыл бұрын

    Thank you! How do I get the intersection between the two lines?

  • @musawenkosisunnyboy7710
    @musawenkosisunnyboy77104 жыл бұрын

    thank you, its really helpful compared to other complicated methods

  • @DOCTORALX
    @DOCTORALX3 жыл бұрын

    @stephen Kuchnicki Thanks for posting this video Stephen. Towards the end you say that the 0.2% proof stress is around 42ksi. However it looks the intersection point would be around 38ksi? Can you please take a look and confirm?

  • @omowonuolaolufowobi9733
    @omowonuolaolufowobi97333 жыл бұрын

    Please, how did you determine the elastic part of the graph with the cardboard palate?

  • @albabhuzaifa6853
    @albabhuzaifa68532 жыл бұрын

    Thank you!

  • @Jaffa__
    @Jaffa__2 жыл бұрын

    Thank you! god's work right here

  • @brianjackson8056
    @brianjackson80563 жыл бұрын

    Can this be used for a torque vs angle of twist graph?

  • @mhmdchacha98
    @mhmdchacha983 жыл бұрын

    Hello, when you did the 0.2% stress, you selected the Strain data instead of the Stress data. Is that the right way to do it, or do you need to select the stress column?

  • @stephenkuchnicki7956

    @stephenkuchnicki7956

    3 жыл бұрын

    Hello Mohamad - When we make the 0.2% offset stress, we need a line parallel to the elastic part of the curve. So, what we do is we take the strain and multiply it by the Young's modulus, which is the slope of the elastic part of the graph. We also add 0.2% (0.002 in/in) to that strain. That gives us a line that starts at 0.2% strain and is parallel to the elastic slope - we're guaranteed that this line will intersect our data somewhere, which is what we need! That intersection point is our standard yield strength.

  • @danielmendoza8647
    @danielmendoza86473 жыл бұрын

    Gracias

  • @basseybassey6834
    @basseybassey68344 ай бұрын

    Can this method be applied to crude oils?

  • @nero2zero1
    @nero2zero13 жыл бұрын

    king

  • @mariamabdu5069
    @mariamabdu5069 Жыл бұрын

    why is my 0.2% above the stress strain graph? someone respond because its time sensitive (:

  • @terryhogan2971
    @terryhogan29712 жыл бұрын

    Sy = 42 ksi? I think you really meant the intersection looks more like about 38 ksi.

  • @NasimAkhtar-uy6lb
    @NasimAkhtar-uy6lb2 жыл бұрын

    Reading wrong stress value of yield, while seeing the graph that obviously contradicts.

  • @matthewcameron45
    @matthewcameron4510 ай бұрын

    the ads are really excessive