I have developed ZnO thin film in nano rod structure on glass substrate and have calculated the absorption coefficient (α) value from absorbance value. I also have plotted ln(α) vs. photon energy (hv) curve. Now I want to calculate Urbach energy from the curve but I donot know the calculation procedure. Please help me by providing calculation procedure. Here I attach the xls file.