This program does a few things that will save me a lot of time in the future.
- Reads in absorbance data for gold nanoparticles from an excel file and plots the data (abs vs wavelength). It can read from multiple columns.
- Extracts key parameters from each spectrum such as maximum absorbance, wavelength at max absorbance, and size of particle.
- Outputs the plots from (1) and a table summarizing the data in (2)
Things I would like to add to this program in the future:
- User-controlled visualization options. e.g. "do you want subplots or just one plot, or plot curves X, Y, Z on one plot and A, B, C on another," etc.
- Calculate concentration based on user input of extinction coefficinent and vial path length
- Let the user control what range of wavelengths to plot
- Let user decide how the legend looks based on how many columns are in the excel file
- Let user specify number of sheets in excel file and which ones to analyze