WNGZWZSS0110rqql? Geneva:C2  AUTOSAVE.WKZ-#e14)dA& o4 @Px l @%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~%@PeakAbs@MeasAbs@MeasIo@MeasI@DeltaI@ StrayLight@+f/%1%@420@f$@2%4@ @1@,  0-Y@.@e@.@\(\?0%1@,  0-Y@.@ 1@ 1@ 1@ /@ @@ 0 0@7f+r@%1%@42-Y@.@1@1@Y@ 0 0@\(\?0%1@+f/%1%@420@\(\?0%1@+f/%1%@420@1@1@1@7f+r@%1%@42-Y@.@7f+r@%1%@42-Y@.@1@\(\?0%1@+f/%1%@420@7f+r@%1%@42-Y@.@1@ \(\?0%1@+!f/%1%@420@("f+r@%1%@42@$f0 @  Geneva @  Geneva @  Geneva @  Geneva @  Geneva @   Geneva @  Geneva @  Geneva @  Geneva @ Geneva @  Geneva @B 0 Actual Peak A0 Measured A$@ @P ? 9?+v? @   Peak wavelength Absorption width  Source widthAbsorber conc.  % stray lightɪ?[H};? @   r@  D@  >@  $@   9?gJՖ? @ V Change the cells above by clicking in the cell, typing a number, and pressing ENTERc ?[6? @   Width Ratio Peak Absorbance Meas. Absorbance Measured I-zero  Measured I  Detector SNR  Photon SNRɪ?!d!? @ 5 ?5  c ?5 [6?5 WU6:@5 >Ô; 4@5 ixl@5  d@hF?|$s? @V  9?4@? @V t??#x? @V c ?kbyP? @V 8?/!f7? @V ɪ?ׂR? @V ZN%$vMR>ߑ|{&? ? @t& %@i@%!1IY6?%%$=P>z~-?*NI0? @t' %i@%!s$ =?%?%"4+L?%$ e?c ?op)5? @P(%i@%!XqwB?% ED`?%"q ?%$R ? @P)%j@%!"N-6MG?%8?%"M??%$Llۍ? @P*%@j@%!@AM?%_-?%"aT&%, ?%$4q$ ? @P+%j@%!3ER?%e?%"p+(?%$`0e'? @P,%j@%!ɴ~*V?%bL?%"`>1?%$ HM1? @P-%k@%!Ts\?% O?%"49?%$$[C9? @P.%@k@%!wHa?%HoL?%"CS)B?%$AsB? @P/%k@%!b̕)e?%{+j?%"MdJ?%$,,hJ? @P0%k@%!жi?% T?%"(R?%$@J R? @P1%l@%!fQAo?%am,X?%"r1FZ?%$Z^TdZ? @P2%@l@%!r?%C ?%"Չ_b?%$4wb? @P3%l@%!%v?%:w?%"~](\i?%$j<|i? @P4%l@%!)${?%??%"Wtq?%$zh@mq? @P5%m@%!qgG ?%7>wm?%"ܳ! x?%$gG&ȝw? @P6%@m@%!?%m|S?%"HqyԒ1?%$? @P7%m@%!b`~T?%4?%"^$?%$>? @P8%m@%!2&f#?%ڼ5?%"u8)6W?%$GƋ? @P9%n@%!Jyg3r?%h?3U?%"%@o@%!}cpRF?%L?%"wկ?%$wH? @P?%o@%!D?%ņwL?%"T>ʳ?%$ S? @P@%o@%!v+>?%/ZpX?%"$6,c?%$֛]? @PA%p@%![Ai?%no ?%"˨mɽ?%$&  ? @PB% p@%!3b?%?%"wm?%$,;/? @PC%@p@%!̤?%Gxe?%" s:?%$Ռ2? @PD%`p@%!KpI?%EuAZ ?%"b3h?%$ڜ? @PE%p@%!/ʳ?%U?%"S?%$pB?? @PF%p@%!ԧ(?%bT?%"asx)?%$Ae!C? @PG%p@%!Q $ ?%α?%"kHr?%$: o I? @PH%p@%!rp?%P?%"7,6V?%$Yo? @PI%q@%!\?%%D:?%"Ӵz?%$gt? @PJ% q@%!c5?%'3c?%" 2?%$p@Rh? @PK%@q@%!pG'0?%d.v?%"0\?%$Fc? @PL%`q@%!ߩ?%K,?%"C|~?%$FxLg? @PM%q@%!Z?%pI?%"[仌?%$v? @PN%q@%!M- c|?%tV?%"pduM]S?%$? @PO%q@%!3ľ?%vZ[C?%")ۙ?%$0GA? @PP%q@%!.,?%]6?%"ܼ?%${-ImO? @PQ%r@%!;I?%'?%"O.# D?%$"GC? @PR% r@%!dho?%?%/ZpX?%"$6,c?%$֛]? @Po%u@%!D?%ņwL?%"T>ʳ?%$ S? @Pp%u@%!}cpRF?%L?%"wկ?%$wH? @Pq%v@%!a?%a7}#?%"F}`?%$# W? @Pr% v@%!DW?%*m]?%"DAJ ?%$`? @Ps%@v@%!oX?%"?%"|*h?%$DuK? @Pt%`v@%!^?%Ia?%"H`?%$ᔵrn? @Pu%v@%!Jyg3r?%h?3U?%"? @Px%v@%!?%m|S?%"HqyԒ1?%$? @Py%w@%!qgG ?%7>wm?%"ܳ! x?%$gG&ȝw? @Pz% w@%!)${?%??%"Wtq?%$zh@mq? @P{%@w@%!%v?%:w?%"~](\i?%$j<|i? @P|%`w@%!r?%C ?%"Չ_b?%$4wb? @P}%w@%!fQAo?%am,X?%"r1FZ?%$Z^TdZ? @P~%w@%!жi?% T?%"(R?%$@J R? @P%w@%!b̕)e?%{+j?%"MdJ?%$,,hJ? @P%w@%!wHa?%HoL?%"CS)B?%$AsB? @P%x@%!Ts\?% O?%"49?%$$[C9? @P% x@%!ɴ~*V?%bL?%"`>1?%$ HM1? @P%@x@%!3ER?%e?%"p+(?%$`0e'? @P%`x@%!@AM?%_-?%"aT&%, ?%$4q$ ? @P%x@%!"N-6MG?%8?%"M??%$Llۍ? @P%x@%!XqwB?% ED`?%"q ?%$R ? @P%x@%!s$ =?%?%"4+L?%$ e? @P%x@%!1IY6?%%$=P> @P%y@%!?1?%W?%"iCW>%$vMR> @P% y@%!3 @y+?% ?%"ρP>%$Y&W> @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @2@ ChicagoGeneva55@, Effect of Source and Absorption Spectral Profiles GenevaGeneva(( Plot and fit FiD Plot"   1t R1C1..R5C15 $R1$C2..$R5$C35  best fit line=R2C3*$R2$C5+$R1$C5R2C4..R5C45 R1C1..R5C45K12 O@b@o@R1C1..R5C45  oA( oA       1 datarangenumrows{ INSTRUCTIONS: Put data to be fit into two adjacent columns, the x-axis data } { (i.e. independent variable) in the first column and the y-axis data (i.e. } { (the dependent variable) in the second column. The first row of each column } { should contain column labels. Select the data range and run this script. } { The script creates a new sheet containing a copy of the data values, the best } { fit data, an ANOVA table, and an XY plot of the data and best fit lines. } { Print page 2 of this new sheet to get report contain ANOVA table and plot. } repaint off column numbers Define datarange,numrows select range R1C10..R20C11 Copy unselect New Worksheet "" window size (12780, 7540) paste values Select last cell numrows=row() select range "R1C1..R"&numrows&"C1" Copy select range R1C3 Paste datarange="$R1$C2..$R"&numrows&"$C3" Select range datarange select more range R1C5 select more range R1C6 column letters Regress column numbers select range R1C4 Put "best fit line" Into R1C4 select range R2C4 Put "=R2C3*$R2$C5+$R1$C5" Into R2C4 select range "R2C4..R"&numrows&"C4" Copy Down select range "R1C1..R"&numrows&"C4" Unselect Add Chart Range frac(R25C6..R51C11,0,62,149,252) Using "R1C1..R"&numrows&"C4" select object 1 XY Legend Bottom select chart 1 series 1 symbol color 0 symbol width 20 symbol type 3 symbol size 7 points line fg 0 line bg 16777215 line pattern 0 line width 40 select chart 1 series 2 line fg 0 line bg 16777215 line pattern 1 line width 20 select range R1C2 select more chart 1 axis 3 axis title range select range R1C1 select more chart 1 axis 1 axis title range column letters column width range E1 to 2780 select range F8..J22 precision 4 select range A1 hide headings hide tool box hide entry bar hide cell grid repaint on select more chart 1 axis 1 select range L50 * Chicago GenevaP Analyt. curve p`D  Analyt. curve ! @D@?D@?.# J5 K5@D@?D@?.I,@ J5 K5  standardcolumn letters define standard Put E4 into L1 for standard=2 to 40 put "" into "J"&standard put "" into "K"&standard end for for standard=2 to 40 put standard*2 into E4 put B7 into "J"&standard put C7 into "K"&standard end for put L1 into E4 * ChicagoChicagoAP q q  fAp7i@y@$@$@e?$@$@ <22@2<%<%<%|88,,x,, ~ b yg(,, d'D@4