Hi all,

I need to define the transmittance of a material and I have as input the emission of the source in terms of CIE 1931 x, y and as output the measurement with the same standard.
Inserted the values in the Source Spectrum Plot of OS, I obtained the spectrum for 100 wavelengths of both the source and the target.
How can I combine the weight of each wavelength to generate the absorption values to be included in the material catalog?

I attach the Excel file used for the calculation.

Thanks in advance.