Close

Excel Plots for 8-Bit CCD Driver TCD1304DG Circuit Charts I & II

A project log for DAV5 V3.01 Raman Spectrometer

The only thing worth doing, is the thing worth doing right!

david-h-haffner-srDavid H Haffner Sr 07/18/2017 at 12:170 Comments

UPDATE

07/18/2017 11:29:AM

I wanted to add that, the objective of this post was to demonstrate a very important aspect of the scientific process; The trail of evidence, this is for those nay-sayer's who have questioned my integrity and data, I will always provide all of my processed along with all raw data, in order to provide full disclosure.

I converted the raw data from the spectral images from the other day using the formula I previously mentioned and wanted to demonstrate how it is utilized in Excel:

The image below is the same as above, also as of right now there is no way to calibrate the spectrum until everything is put together and tested in the enclosure and the software is updated.

I didn't realize until I took a closer look that there must have been some light leakage in the monochromator, you'll see it in the image below:

Now this is the full spectral range from 0 - 1323 pixels, you will notice at the far left of the chart a line shooting straight up the chart, this is the transmission line, which use to be the "absorption" line, by implementing this equation: (10ᶺ(-B2))*100

We can "flip" the spectral image right side up.

I am hoping that by presenting these charts and examples that it starts to bring more clarity to the complexity of this particular discipline :)

Discussions