Technical Issues - Refractive Index with the $NK Function and BASIC TargetsSelect Additional piecewise examples discussed here. Ambiguity issues discussed here. There are materials for which no
dispersion
function (e.g. Lorentz, Cauchy, etc.) is available. In
such cases we are forced to deduce n,k at each wavelength. This piecewise fit capability is built into INDEX (for %R/%T measured
at with light incident at 0° on the filmed surface) but also available in
DESIGN where
possibilities include reverse light incidence and multiple
angles/polarization states.
' In the DESIGN BASIC code below, TargetsSelect extracts multiple targets at a single wavelength ' Targ$ is repeatedly reopened to select multiple targets at other wavelengths. Const Targs$ = "C:\Winfilm\Data\TargsTemp.trw" Const bREV As Boolean = False ' Include reverse reflectance targets? Const OK$ = " Click OK when done." Sub Main If MsgBox("Click <Copy Spectra> in Excel." & OK$, vbOK, "FORWARD") = vbCancel Then Exit Sub DataPaste SpecTargets True, "R", 1, 0, "R" SpecTargets False, "T", 1, 0, "R" If bREV Then If MsgBox( "Click <Copy Spectra> in Excel." & OK$, vbOK, "REVERSE") = vbOK Then DataPaste SpecTargets False, "V", 1, 0, "R" End If End If AxesDraw FileSave Targs$ ' Save all targets DoSolve End Sub Sub DoSolve Dim w!, nk$ For w = 1290 To 310 Step -10 FileOpen Targs$ TargetsSelect w Optimize nk$ = nk$ & CStr(w) & vbTab & IndexCoeff(3, 1) & vbTab & IndexCoeff(3,2) & vbCrLf Next w Clipboard nk$ ' Now paste nk$ table into INDEX via File..Paste Table End Sub We can also deduce n&k in DESIGN. Below we see that, in the case of 25 nm films, results are essentially identical to INDEX Solutions above. DESIGN adds the ability to include reverse reflectance, angle and polarization. Further work is left to the reader to determine the advantage, if any, to adding reverse reflectance. Graphs shown are based on forward reflectance only.
In the following boxcar averaging reduces noise by averaging groups of 11 adjacent spectra.
Solutions deteriorate as film thickness becomes large enough to magnify measurement errors. 0.5% variation at T=1% are far more deleterious than at T=80%. As shown below, smoothing helps, but there is no substitute for accurate low-noise measurement techniques.
AgRandom.xlsm includes the possibility of different errors for %R (cell B2) and %T (cell B3) as shown below. Note the peaks at about 710 and 750 nm.
It appears that the peaks correspond to %T noise at 710 and 750. Unfortunately, when %T gets near zero, the effects of random errors are magnified.
The replacement of absolute error by
relative error is left to the reader. Current
FilmStar users puzzled by any of the above
should contact FTG Software for an
online presentation. |
Copyright © 2023 FTG Software Associates
Last updated on
June 06, 2023