Excel’s VBA script functionality enables the user to query an instrument directly from Microsoft Excel. Data from the device is imported directly onto an Excel page for post data processing using user-defined algorithms. Above is the processed data graphics page of the module. Scope, absorbance, and transmission data are displayed simultaneously. Notice the noise below 400 nm in the absorbance and transmission curves. From looking at the scope mode data, you can quickly determine that this is due to the fact that there is no reference signal in this portion of the spectrum (and is therefore invalid). Adding a deuterium lamp would allow that spectral region to be measured.

VBA PDF

CRI & CQS calculations are performed in a comprehensive spreadsheet written by the folks at NIST. If you purchase a StellarNet spectrometer we’ll send you our free modified version that reads your instrument!

 

The SpectroRadiometer Test Report Software now enables customers to display and print all of the relevant test data on one sheet making quality control and R&D efforts much more efficient.

The FREE VBA based software is built into an MS Excel spreadsheet and it automatically loads your spectrometer’s calibration coefficients and irradiance calibration data upon starting the program. With a click of a button, you can acquire a complete spectrum of your test light source and view its spectral distribution with an under the curve wavelength color representation view which can be helpful when showing a “non-technical” person how much of a certain color is represented in the measured light source.

The test report also shows the CIELAB diagram with the xy/u’v’ chromaticity values automatically updated for your light. Additionally, CCT (Correlated Color Temperature), PAR, dominant wavelength, and % color purity are calculated.  The software also includes NIST created calculations for CRI (Color Rendering Index) and CQS (Color Quality Scale) and total power measurements in Lumens, Watts, or associated irradiance values with efficiency and efficacy values calculated as well based on your input electrical parameters.

It is so simple that anyone with Excel experience can modify the program to provide their own specific spectral calculations.

Above is a simple modification to SpectraWiz VBA to calculate thermal burn and irradiance/radiance per EC directive. Imported spectra is multiplied by a weighting function and spectral bins are calculated based on the directives guidelines. 

While SpectraWiz can run on virtually any computer, SpectraWiz VBA for MS Excel does have some requirements.

SpectraWiz VBA for MS Excel requires the user to use a standalone version of Excel – it is not compatible with the 365 App version.
Excel should also be a 32-bit distribution.

If you have any questions about if your version of Excel will work with SpectraWiz VBA for MS Excel feel free to reach out to your Application Scientist or email us at ContactUs@StellarNet.us