I build an excel to calculate some errors cause by source data in CIE colorimetry. First of all, the errors from spectral range. CIE recommend all rigorous calculations be calculated in the full range of wavelengths, 360 nm to 830 nm. In practical, we didn't use a spectrometer has that wavelength range. X-Rite i1 pro 2 is 380 ~ 730 nm, barbieri Spectro LFP S3 is 380 ~ 780 nm.
I calculated ΔE2000 at different spectral range, the result shows very small errors. CIE practical suggestion is 380 ~ 780 nm, the error causing by spectral range is only 0.0003 in average at D50, 2°. Analyze errors at different CMFs. In short wavelength, error significantly increases when wavelength be cut from 380 ~ 400 nm. Lack of long wavelength data, the errors double every 10 nm cutoff stably at 700 ~ 800 nm.
Focus on no errors wavelength range at 4 dp. D50 illuminant, 1931 2° CMF is 370 ~ 770 nm, 1964 10° CMF is 380 ~ 770 nm, new CIE fundamental CMF is 390 ~ 770 nm. CIE A illuminant, 1931 2° CMF is 370 ~ 780 nm, 1964 10° CMF is 380 ~ 780 nm, new CIE fundamental CMF is 390 ~ 780 nm. CIE practical suggestion calculating range 380 ~ 780 nm is reliable.
I also calculated other error causes, e.g, spectral interval, spectral resolution, interpolation function, significant figures. Anyone interested?