Simple calculation tools
Convert relative reflection to absolute reflection
Convert relative reflectance to absolute reflectance for spectrophotometer measured value.
Excel version is here: reltoabs.xls
Substrate Index
Calculate the refractive index of a substrate without absorption
Calculate refractive index of substrate from reflectance or transmittance of non-coated substrate.
Excel version is here: substindexcalc.xls
Calculates the refractive index, absorption coefficient, and internal transmittance of a substrate with absorption
Excel version is here: Subst_nkTi_Calc.xlsx
Mean Free Path
Color Calculation
Calculate the color system values from XYZ tristimulus values.
Calculate XYZxy L*a*b* from spectrum values. (Excel sheet)
colorcalc-v30.xlsx
July 13, 2020 Fixed an error in the calculation of L*a*b* when the value of X/Xn, Y/Yn, Z/Zn was 0.008856 or less. (Excel sheet only).