You are an absolute Legend, came here to learn about how to superpose few curves, ended up
learning tips and trick about Excel and XRD knowledge
A funny note : Imagine my face when I
kept dragging that + all the way down the column because I paused
the video before I got to the double click trick ...
dronepower
Thank you very much for this! I hope it'll be nice for you to know, that you helped one PhD student out there ☺️ That is really elegant!
anzhelakukh
No script is needed for "cell decoration" at 18:30. Let us assume, that column A should be decorated. Starting at any other cell with =IF((MOD(ROW(A1)-ROW(A$1), 3)=0), INDIRECT(ADDRESS(ROW(A$1)+(ROW(A1)-ROW(A$1))/3, COLUMN(A$1))), "") and generating the values downwards will do the job. The number "3" in the formula (two entries), signifies the expansion, akin to "duty cycle", and could be changed to another number according to the necessity (P.S. Nice job with the video, Zachary. It is a real help for the beginners. I was searching for a suitable video for the undergraduate students).
istvanboldog
special advisor !!
much faster than method that I ever use ! thanks
ktgoqzj
Thank you so much for your help. I am so grateful that i found your video while writing my thesis .
aayushinaik
Thank you a lot for help another PhD student! nice voice and good explanation! Muchas gracias!
angy_ve
Thank you very much! You'll be blessed.
임동혁-ms
That's awesome u r my thesis advisor already
supachaik.
Thank you. It really helps. Please continue uploading new videos.
akmnuralamsiddiki
Thank you sir From India . Sir can we calculate HLK Value in excel without any software if yes kindly provide link of the lecture
anandkakde
Fantastic Video! Thanks for your guidance!
connorbannochie
Very very impressive and useful for me. TQVM.
jialinfu
Thank you very much. It's very helpful for me
arzajeng
This is very helpful.
Thank you so much.
paulzakka
How are you inserting the data to the excell sheet.My excell is freezing while I copy paste all the XRD data..Please help
satya
how can i obtained the jade analysis software.?
GaliMansir
Hello, thank you very much for this wonderful video... I need your help. How can we find a beta using Excel to know the size of the crystals? To apply it in the scherrer equation... Thank you
Moondisapear
Muchas gracias por la ayuda, estoy haciendo mi tesis y esto realmente me ayudo demasiado. :)
javiervaldovinos
What software are you using for reference Data, I have been able to plot my XRD Data, now I need to analyze it.
Muradsahar
When I click the scatter graph, excel automatically sorts the data from smallest to highest, and it keeps messing my data
