

| A | B | |
| Sheet Name | Description | |
| Fluence Calculations | Primary sheet where fluence calculations are performed. Values must be entered by user for volume, diameter, water path length, distance from light source to sample, weighting factor, and radiometer reading. | |
| Absorbance | UV-VIS spectrophotometer measurements for the microorganism working stock solution is imported into this sheet. | |
| Reflection Factor | Pre-calculated reflection factor based on personal communications with Professor Jim Bolton (2016). | |
| Weighting | Sheet that accounts for the relative lamp emission of the photorepair lamp, radiometer factor, sample absorbance, Beer Lambert law, photolyase absorbance, and weighting factors to calculate the average intensity. | |
| Lamp Spectra | Sheet that depicts the lamp spectra, average wavelength, and peak wavelength. | |
| Irradiance Interpolation | Sheet that performs interpolation function in Excel to output spectral irradiance values for integer wavelengths so that values can be used in the Weighting tab. | |
| Photolyase Spect Interpolation | Sheet that performs interpolation function in Excel to output photolyase action spectra values for integer wavelengths so that values can be used in the Weighting tab. |
| A | B | |
| Sheet Name | Description | |
| Plot | Shows a plot of all spectral irradiance measurements obtained at different distances from the light source | |
| RawData | Contains all the raw measurements, including background measurements (i.e., dark controls with the cap on the spectroradiometer), and measurements taken at different distances | |
| SpecIrr_BkgdCorrected | Spectral irradiance data with background corrections (i.e., background spectra subtracted from light spectra measurements) | |
| Tabs named 12 to 12.35 | Each tab has the data for measurements obtained at the various heights (units in cm). The sheets interpolate the measurements to integer wavelength values which can then be used in the Photorepair Fluence Calculation spreadsheet. The total irradiance from 320-475 nm is calculated in cell M2 as the sum of the spectral irradiance values between 320-475 nm. |