What is a Spectrograph?

A spectrograph is an instrument designed for dispersing radiation into a spectrum and recording or mapping this spectrum. The purpose of this process is to analyze the properties of light or sound, which are forms of radiation. Spectrography refers to the use of this instrument and the study of the resulting spectra. When operating spectrographically, the instrument spreads the radiation and photographs the spectrum, capturing a visual representation of it for further analysis.

Spectrograph Plugins for Excel

Integration with Spectrometer Systems

Spectrograph plugins for Excel are designed to work in tandem with spectrometer systems. They enable instantaneous data capture and graphing directly from a spectrometer, making them a highly efficient tool for spectral analysis.

Operational Modes

These plugins can be initiated and operated from within Excel in various modes such as absorbance, transmission, or scope mode, depending on the requirements of the analysis.

Customization for Research

Customization features of the plugins allow for the tailoring of spectral analysis to meet unique research needs. This flexibility is beneficial for adapting to the specific demands of different research projects.

Data Acquisition and Analysis

The data acquisition capabilities of the plugins can be incorporated into pre-existing analytical Excel spreadsheets. This integration facilitates the creation of custom reports and enables users to compute and graph absorbance or percent transmission with ease.

Included with StellarNet Spectrometers

Spectrograph plugins are included at no extra cost with the purchase of a StellarNet spectrometer. StellarNet has also developed specialized spreadsheets such as the NIST CRI/CQS calculator and the LED Test Report spreadsheet to enhance the functionality of these plugins.

Features of Spectral Acquisition

The plugins provide basic spectral acquisition features, including but not limited to absorbance and transmission. They are capable of displaying scope, absorbance, and transmission data simultaneously and can assist in identifying noise within the absorbance and transmission curves.

LED Test Reporting Software

Included software for LED test reporting presents all test data on a single sheet for convenience. This software automatically loads spectrometer calibration coefficients and irradiance calibration data and is capable of acquiring a complete spectrum to display spectral distribution. It is also equipped to calculate critical metrics such as CCT, PAR, dominant wavelength, and color purity percentage. NIST calculations for CRI and CQS are included, along with measurements for total power in Lumens, Watts, or irradiance values.

Customization and Compatibility

Users with experience in Excel are empowered to modify the program to perform specific spectral calculations. It is important to note that SpectraWiz VBA for Excel is not compatible with Excel 365 App and requires a 32-bit distribution of Excel for functionality.

Common Use Cases

• S

  
  Use case 1: Customizing and streamlining spectral data analysis for specific research needs by integrating the plugin into existing analytical spreadsheets in Excel.
• S

  
  Use case 2: Enhancing productivity by creating custom reports and graphs for absorbance, percent transmission, and other spectral data directly within Excel.
• S

  
  Use case 3: Performing comprehensive lighting analysis by utilizing the LED Test Report Software and NIST calculations for CRI, CQS, CCT, PAR, and total power measurements.
• S

  
  Use case 4: Maintaining accuracy and efficiency in spectral analysis by automatically loading spectrometer calibration coefficients and irradiance calibration data.

Frequently Asked Questions

Is SpectraWiz VBA compatible with all versions of Microsoft Excel?

SpectraWiz VBA requires a 32-bit version of standalone Excel and is not compatible with the Excel 365 App version.

Can SpectraWiz VBA perform data analysis for recorded sound and export the analysis to Excel?

The SpectraWiz VBA is designed for use with StellarNet spectrometers and is not specifically mentioned to analyze recorded sound.

What types of data can SpectraWiz VBA display and calculate within Excel?

SpectraWiz VBA can display scope, absorbance, and transmission data. It can also calculate and graph absorbance or percent transmission, and includes calculations for CCT, PAR, dominant wavelength, color purity percentages, and NIST calculations for CRI and CQS.

Does the SpectraWiz VBA plugin allow for customization to meet unique research needs?

Yes, SpectraWiz VBA is customizable and allows users to create custom reports, integrate with existing spreadsheets, and modify the plugin for specific spectral calculations.

Is there an additional cost for the SpectraWiz VBA plugin when purchasing a StellarNet spectrometer?

No, the SpectraWiz VBA plugin comes free with the purchase of a StellarNet spectrometer.