Hey all,

I'm an engineering student, and I was recently asked to crunch a lot of data, but I have an issue. The data that the lab produced is a measure of certain optical properties of amorphous silicon through a range of wavelengths, with wavelength being the independent variable (x) in the data set. A sample of the data looks like this:


210.77812200 1.365183 3.158104
212.36825600 1.383018 3.203131
213.95842000 1.422307 3.261899
215.54863000 1.460486 3.293017
217.13891600 1.482046 3.325932
218.72921800 1.513605 3.334321
220.31958000 1.535114 3.351916

Where the first column is wavelength (nm), the second column is n, and the third column is k. I need to use this data, but to use it, I need to use integer values for wavelength, and was hoping to use linear interpolation. I interpolated a few by hand:


211 1.36767 3.16439
212 1.37889 3.19270

But the process takes a bit of time, and I need to interpolate from 211 nm to 1700 nm. I didn't see a function for this in excel, so does anyone know a faster way to interpolate this data?

Thanks,

--Avren--