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 ...
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).
The followers of your method might appreciate the direct solutions for the first and the second columns. The first column is represented by =INDIRECT(ADDRESS(TRUNC(1+(ROW(A1)-ROW(A$1))/3),COLUMN(A$1))) , and the second by =IF((MOD(ROW(A1)-ROW(A$1)+2,3)=0),INDIRECT(ADDRESS(ROW(A$1)+(ROW(A1)-ROW(A$1))/3,COLUMN(A$1))),0) , provided that A and B are the initial columns.
Glad to hear it! I will be defending next week. I made another video that shows how to normalize and smooth XRD data in excel. th-cam.com/video/TBKLdpXW-90/w-d-xo.html
Degree of crystallinity is simply the fraction of peak area to total area. This can certainly be done by hand in excel, but you will need to find the range of each peak individually. Technically it could be possible to make a VBA code to do all of this automatically, but you would need to be very familiar with coding in VBA, and it will only be worth the time if you have many XRD patterns to analyze. Although I am not too familiar with this procedure. I think it might only be applicable when there is a mixture of amorphous and crystalline phase. Small nanoparticles can be crystalline but result in broad XRD peaks.
@@ZGNeale thanks for the explanation, i really appreciate it, can u make a video for that?, it will be very helpfull, cuz i cant find the video about calculating degree crystalinity with excel...
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
Do you mean the 2theta of diffraction peaks, or how to find the references? The peak position is the angle of highest intensity, although two overlapping peaks may change this.
The data is collected by the XRD machine. It was an example data set I used for class, I no longer have access. You might be able to find data sets in the supporting information files of some research related to crystalography or elsewhere online.
Hi, I'm doing my thesis, I have a question when it comes to recognizing the type of material in certain peaks, I can write you an email, if it's not too much trouble. Greetings from Ecuador.
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 ...
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!
Thank you, I am happy to hear it.
@@ZGNeale please help me sir, I need to connect you
@@mahadgaraad2754 How can I help you?
@@ZGNeale i need for XRD analyse data
@@mahadgaraad2754 What is your question?
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).
Thanks, this is helpful!
The followers of your method might appreciate the direct solutions for the first and the second columns. The first column is represented by =INDIRECT(ADDRESS(TRUNC(1+(ROW(A1)-ROW(A$1))/3),COLUMN(A$1))) , and the second by =IF((MOD(ROW(A1)-ROW(A$1)+2,3)=0),INDIRECT(ADDRESS(ROW(A$1)+(ROW(A1)-ROW(A$1))/3,COLUMN(A$1))),0) , provided that A and B are the initial columns.
special advisor !!
much faster than method that I ever use ! thanks
Thank you so much for your help. I am so grateful that i found your video while writing my thesis .
Happy I could help. Good luck on your thesis!
@@ZGNeale thank you so much 🤗
That's awesome u r my thesis advisor already
Thank you. It really helps. Please continue uploading new videos.
Thank you a lot for help another PhD student! nice voice and good explanation! Muchas gracias!
Glad to hear it! I will be defending next week.
I made another video that shows how to normalize and smooth XRD data in excel. th-cam.com/video/TBKLdpXW-90/w-d-xo.html
Thank you very much! You'll be blessed.
Fantastic Video! Thanks for your guidance!
Very very impressive and useful for me. TQVM.
Sorry about the keyboard asmr.
Thank you very much. It's very helpful for me
you have saved me THANK YOU
This is very helpful.
Thank you so much.
great help sir!
Thanks a lot. very helpful vedio
Thank you very much
how can i obtained the jade analysis software.?
What software are you using for reference Data, I have been able to plot my XRD Data, now I need to analyze it.
The phases were matched on JADE, but the reference library requires a license.
How are you inserting the data to the excell sheet.My excell is freezing while I copy paste all the XRD data..Please help
Thank you sir From India . Sir can we calculate HLK Value in excel without any software if yes kindly provide link of the lecture
thanks for sharing!!
When I click the scatter graph, excel automatically sorts the data from smallest to highest, and it keeps messing my data
That's odd, I have not experienced that before. Try selecting an empty cell away from your data before adding a graph.
How can I find fwhm from xrd plot in excel?
can we measure the degree of crystalinity using excel?
Degree of crystallinity is simply the fraction of peak area to total area. This can certainly be done by hand in excel, but you will need to find the range of each peak individually. Technically it could be possible to make a VBA code to do all of this automatically, but you would need to be very familiar with coding in VBA, and it will only be worth the time if you have many XRD patterns to analyze.
Although I am not too familiar with this procedure. I think it might only be applicable when there is a mixture of amorphous and crystalline phase. Small nanoparticles can be crystalline but result in broad XRD peaks.
@@ZGNeale thanks for the explanation, i really appreciate it, can u make a video for that?, it will be very helpfull, cuz i cant find the video about calculating degree crystalinity with excel...
please can you help to upload new video that the excel sheet is not blurred?
Make sure your video quality is 1080p.
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
Muchas gracias por la ayuda, estoy haciendo mi tesis y esto realmente me ayudo demasiado. :)
¡De nada!
how to find diffraction peak ?
Do you mean the 2theta of diffraction peaks, or how to find the references? The peak position is the angle of highest intensity, although two overlapping peaks may change this.
VERY HELPFULL
Anyone tell me how to find that x and y values.....what is that data?
The data is collected by the XRD machine. It was an example data set I used for class, I no longer have access. You might be able to find data sets in the supporting information files of some research related to crystalography or elsewhere online.
Hi, I'm doing my thesis, I have a question when it comes to recognizing the type of material in certain peaks, I can write you an email, if it's not too much trouble. Greetings from Ecuador.
Sure, send me your question. zgneale@outlook.com
@@ZGNeale I wrote to your email
the material I am studying is clay