(kLICSO2  , 2 2  ]f`^Bd>dmuuqoo !"#$%&'(/ q H   d GANA )GBGCSqqGISOmGMCPAIR<dGMCQUAD2GPRINTGOGSMG\AG\C  G\IG\OG\PG\QG\RG\UG\Y20 # gi( f$% &'(( nB)'*-qq7'SPREADSHEET FOR METHOD 301: VALIDATION PROTOCOL 'MAKE YOUR SELECTION:'METHOD COMPARISON: 'ALT (Q)'QUAD TRAIN 'ALT (P)'PAIRED TRAIN 'ISOTOPIC SPIKING:'ALT (I)'PAIRED OR QUAD TRAINS 'ANALYTE SPIKING: 'ALT (A) 'QUAD TRAIN 'PRINTING OPTIONS: 'ALT (C)$'METHOD COMPARISON: QUAD TRAINF'ENTER SAMPLE CONCENTRATIONS (ASSUMED TO BE IN COMPARABLE UNITS) 'PROPOSED METHOD 'VALIDATED METHOD "RUN #"A "B "DIF "DIF^2 "A "B "DIF "DIF^2"DIF(V-P) "DIF^2        ?          1"     ?                ?  ?  1"     ?       @   @      ?  ?  1?"     ?       ?   ?        ?  1"     ?   '  "TOTAL@ P @ P @ P @ P @ P @ P? P@ P P? P "AVERAGE' ?PR ' ?PR ' ?PR ' ?PR ' ?PR ' ?PR ' ?PR ' ?PR ' PR ' ?PR "'VARIANCE:#'PROPOSED METHOD (Sp^2)=& #?R  $'VALIDATED METHOD (Sv^2)=& $?R  Z&J KProposed Variance AcceptableProposed Variance Unacceptable;3$&Proposed Variance Unacceptable''(F-Factor=1.0) )'BIAS:$+'STANDARD DEVIATION DI (SDd)=  +@,>?  # ,'t-VALUE= ,:!   -'CRITICAL t-VALUE= -h|?5? .'(n=4,alpha=80%)p04aBias Statistically SignificantBias Not Statistically Significant, CF not needed.;380Bias Not Statistically Significant, CF not needed.2'CORRECTION FACTOR (CF)=% 2qq?Q b 2)S??(not acceptable)(acceptable);(not acceptable);3 2(not acceptable)D4'END OF METHOD COMPARISON-QUAD SPREADSHEET. PRESS "HOME"-KEY.2<'METHOD COMPARISON: PAIRED TRAIN SPREADSHEET5>'ENTER STANDARD DEVIATION OF VALIDATED METHOD: >F@'ENTER SAMPLE CONCENTRATIONS (ASSUMED TO BE IN COMPARABLE UNITS) B"RUN #B'PROPOSED B'VALIDATEDB"DI(V-P) B"DI^2 C C CC  C?   D D DD  D?   E E EE  E?   F F FF  F  G'PRINTING OPTIONS: G G GG?  G?   H H HH?  H?  %I'PRINT METHOD COMAPARISON DATA: I I II  I  J'ALT (U) J'QUAD J J JJ  J  K'ALT (R) K'PAIRED K K KK  K  #M'PRINT ISOTOPIC SPIKING DATA:M'ALT (O)M'QUAD OR PAIREDM'AVERAGE:'MUUUUUU?PR 'Mqq?PR 'MqqPR 'Mrq?PR  N"TOTAL:N@ PN@ PN PN@ P"O'PRINT ANALYTE SPIKING DATA:O'ALT (Y) O'QUADQ'STANDARD DEVIATION:S'DIFFERENCE (SDd)=%S?  #T'PROPOSED (SDp)=T?]ɿ  V'VARIANCE:W'PROPOSED METHOD (Sp^2)=WnF3^?  X'VALIDATED METHOD (Sv^2)=X?  ZZKProposed Variance AcceptableProposed Variance Unacceptable;3"ZProposed Variance Acceptable['(F-Factor=1.0) ]'BIAS:^'t-VALUE= ^S?  !_'CRITICAL t-VALUE= _'1Z?`'(n=9,alpha=80%)pbaBias Statistically SignificantBias Not Statistically Significant, CF not needed.;38bBias Not Statistically Significant, CF not needed.d'CORRECTION FACTOR (CF)= d?! bd S??(not acceptable)(acceptable);(not acceptable);3d(not acceptable)Rf'END OF METHOD COMPARISON - PAIRED SPREADSHEET. PRESS "HOME"-KEY TO RETURN.;m'ISOTOPICALLY LABELLED SPIKING: PAIRED OR QUAD TRAINS9o'ENTER THE NUMBER OF SAMPLES USED FOR CALCULATIONS: o*q'ENTER VALUE OF ISOTOPIC SPIKE (CS)= q2Fs'ENTER SAMPLE CONCENTRATIONS (ASSUMED TO BE IN COMPARABLE UNITS)u"SAMPLE#u'CONCENTRATIONu'(Si-Sm)^2 v v vI єXl?   w w wI єXl?   x x xI єXl?   y y yI єXl?   z z zI єXl?   { { {I єXl?   | | |I єXl?   } } }I єXl?   ~ ~ ~I єXl?     I єXl?    /I єXl? o  ;  /I єXl? o  ;  /I єXl? o  ;  /I єXl? o  ;  /I єX? o  ;  /I єXl? o  ;  /I єXl? o  ;  / o  ;  / o  ;  / o  ;'AVERAGE: "MEAN=!?P  "TOTAL:? P  'BIAS: "B=xxxxxH@  "STD. DEVIATION=!Hh ?  #'STD. DEV. MEAN=? ޿# 't-VALUE=@ ! 'CRITICAL t-VALUE= S㥛@'(n=12,alpha=95%)p3 aBias not Statistically Significant, CF not needed.Bias Statistically Significant;3$Bias Statistically Significant'CORRECTION FACTOR (CF)= ǔa.?׿ b(Sffffff??(Not Acceptable)(Acceptable);(Not Acceptable);3(Not Acceptable)'PRECISION:'RELATIVE SD=f~@  A'END OF ISOTOPICALLY SPIKED SPREADSHEET. PRESS "HOME"-KEY.# 'ANALYTE SPIKING: QUAD TRAINS( 'ENTER VALUE OF SPIKED LEVEL (CS)= $J 'ENTER SPIKED AND UNSPIKED CONCENTRATIONS (COMPARABLE UNITS ASSUMED)!' SPIKED SAMPLES#' UNSPIKED SAMPLES "RUN # !"A  ""B  #"C  $"D  %"A-B&"(A-B)^2 '"C-D("(C-D)^2   ! " # $%?  &?  '?  (?     ! " # $%  &  '  (     ! " # $%  &  '  (     ! " # $%  &  '  (     ! " # $%  &  '  (     ! " # $%  &  '  (   "AVERAGE: !"Sm="UUUUUU? Q #"Mm=$UUUUUU? Q % ' 'STANDARD DEVIATION:!'SPIKED SDs=-#3Ey?PR  # #!'UNSPIKED SDu=-#3Ey?PR  # #!'RELATIVE STD RSDs=#LXz @  @$˝1? (unacceptable) (acceptable);3$ (unacceptable) #!'RELATIVE STD RSDu=#LXz @  @$1? (unacceptable) (acceptable);3$ (unacceptable) 'BIAS: "'B=!#  !'STD OF MEAN SDm=$#>, p ?  #"'t-VALUE=#.! @ ! !'CRITICAL t-VALUE= #S㥛@!'(n=12, alpha=95%)s!dBias is statistically significantBias not statistically significant, CF not needed.;3'!Bias is statistically significant!'CORRECTION FACTOR= #ڿ b$Sffffff??(Not Acceptable)(Acceptable);(Not Acceptable);3$(Not Acceptable)G 'END OF ANALYTE SPIKING SPREADSHEET. PRESS "HOME"-KEY TO RETURN.\ '\Q '\I '\P '\A '\C'{GOTO}MCQUAD~'{GOTO}ISO~'{GOTO}MCPAIR~'{GOTO}ANA~ '{GOTO}PRINT~'  '\U '\R '\O '\Y'/'/'/'/'P'P'P'P 'P 'P 'P 'P 'A 'A 'A 'A 'R 'R 'R 'R 'MCQUAD~ 'MCPAIR~  'ISO~  'ANA~ 'G 'G 'G 'G'Q'Q'Q'Q