I have created three Excel spreadsheets that perform various spectral calculations on your data. Each spreadsheet is designed for different sample intervals across the visible spectrum: 5 nm, 10 nm and 20 nm. You should use the spreadsheet that corresponds to the measuring interval of your spectrophotometer.
The spreadsheets cover the range of 340 nm to 830 nm. You simply paste your spectral data into the proper rows, leaving unused rows at zero. The spectral results are instantly calculated and displayed. You may also paste in a custom illuminant, if you wish. The spreadsheet provides values resulting from all combinations of:
|Standard Observers||Reference Illuminants||Colorimetry||Density||Working Space RGB|
Place values into the yellow cells. Calculated results are displayed in the blue cells.
Note: For emissive measurements (e.g. from a monitor), the values corresponding to Illuminant E should be used.
|Sample Interval||ZIP Format|