\ Daniel Rentz B08= -zIb%8= H$> 8= H$> 8= H$> 8= H$> 8= -zIb%>  FGIHJKL/9NO_ dMbP?c@CellParam FunctionsArrayTable Cell  FGgB d MbP?"*+_%111 Arial1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1hTimes New Roman1Times New Roman1Times New Roman1 Arial1 Arial&F Seite &P&[4d2?'[4d2?(<~?)<~?M  d d@ Param# ALCF2E24C5,# ALCF2F25BD-# DLCF2D2407,YZ 0@Z 1@Z 2@Z 3@:# EDATEYV General00.00#,##0 #,##0.00 #,##0;\-#,##0#,##0;[Red]\-#,##0#,##0.00;\-#,##0.00#,##0.00;[Red]\-#,##0.00#,##0\ "";\-#,##0\ ""#,##0\ "";[Red]\-#,##0\ "" #,##0.00\ "";\-#,##0.00\ ""%"#,##0.00\ "";[Red]\-#,##0.00\ ""0%0.00% 0.00E+00 #\ ?/? #\ ??/??  dd/mm/yyyy dd/\ mmm\ yy dd/\ mmm mmm\ yy h:mm\ AM/PMh:mm:ss\ AM/PMhh:mm hh:mm:ssdd/mm/yyyy\ hh:mm"ok";\-General;0;[Red]@        ALCF2C2310- DLCF316317,cC C  C  C  C  C C C C C C C C C C C  C  C  C  B}C  CSC  BKC C "C  C  C  C ! B}C 1 CSC A BKC QC C  C  C a" Header0 Header1 Header2 Header3OkU }  } } } }  } } } } } } } }  FD D ;7 0>K=7  ƀ w   F;0M b0MtE  ;7};v ?;&FORMULA TEST DOCUMENT     1 - CELL FORMULAS     1.1 - CONSTANT OPERANDS!1.5 - OPERATOR PRECEDENCE # 1.6 - CELL REFERENCE TOKENS  1.9 - FUNCTION TOKENS TokenFormula Is Must Ok?Formula Is Must  Ok?  Token Formula  Is Must Ok? TokenFormula Is Must Ok? tInt =1?~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7*3+27@ ~ 7@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tRef  =Q7 ?D~ ?!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ ? tFunc=ABS(1)?A~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tNum=1.2345n? n?n?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7*3+(2)7@ ~ 7@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tRef  =$Q8 @D~ @!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ @tFuncVar - 1 param=MIN(1)?B~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tStr =""z'V!?DDAA&DAA&D B$B ERR!B=7*(3)+27@ ~ 7@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tRef  =Q$9 @D@~ @!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ @tFuncVar - 30 params^V=MIN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30)p?^     B~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tStr ="ABC" 'ABCABC ABC !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B =(7)*3+2 7@ ~ 7@ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tRef =$Q$10 @D ~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @ tFuncVar/tMissing  =SUM(1,,2) @ B~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tStr ="2" Z'22 2 !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B =7*(3+2) A@ ~ A@ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tArea =Q11:Q12 @E ~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @  tSheet/tName =EDATE(DATE(2000,1,1),1)@ .#AAB~ @ !*D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR! tBool =FALSE   !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B =(7*3)+2 7@ ~ 7@ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tArea =Q11:Q12 @E ~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @ tAttrSum =SUM(1) ?@~ ? !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tBool =TRUE   !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B =(7*3+2) 7@ ~ 7@ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tArea  =Q12:$Q13 @E ~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @  tFuncVar(SUM)  =SUM(1,2) @ B~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B  tErr(NULL) =#NULL!   !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B =7+3*2 *@ ~ *@ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B tArea  =Q13:Q$14  @E @~  @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~  @ tErr(DIV/0)=#DIV/0!!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7+(3*2)*@ ~ *@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tArea  =Q14:$Q$15 "@E ~ "@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ "@ tErr(VALUE)=#VALUE!!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=(7+3)*24@ ~ 4@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tArea  =$Q15:Q16 $@E~ $@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ $@1.10 - PARENTHESES tErr(REF)=#REF!J!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7^3*2p@ ~ p@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tArea  =Q$16:Q17 &@E@~ &@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ &@ TokenFormula Is Must Ok? tErr(NAME)=#NAME?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7^(3*2)@ ~ @ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tArea  =$Q$17:Q18 (@E~ (@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ (@Constant value =(1)?~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tErr(NUM)=#NUM!$$$!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=(7^3)*2p@ ~ p@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tArea  =$Q$18:$Q$19 *@E~ *@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ *@Constant array=({2})'@ @+@~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tErr(N/A) =#N/A***!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7*3^2O@ ~ O@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tSheet  =Cell!Q20- ,@A)C~ ,@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ ,@Unary operator (pre)=(+(3))@~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtArray ={1}&?@+?~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7*(3^2)O@ ~ O@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tSheet =Cell!$Q$20:$Q$21- .@_,C~ .@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ .@Unary operator (post) =((400)%)@~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtArray={"ABC"}"H'@,ABCABC ABC!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=(7*3)^2{@ ~ {@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tSheet  =Param!G21- 0@/C~ 0@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!BBinary operator =((2)+(3))@ ~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtArray={TRUE}&@,?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7^3+2u@ ~ u@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tSheet  =Param!$G$22- 1@2C~ 1@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!BFunction, 0 params=(PI())-DT! @A-DT! @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtArray ={#VALUE!}&@,?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=7^(3+2)i@ ~ i@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tSheet =Param!$G$23:$G$24- 3@C~ 3@!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!BFunction, 1 param =(ABS((7)))@A~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=(7^3)+2u@ ~ u@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BFunction, 2 params=(SUMME((3);(5))) @ B~  @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B1.2 - UNARY OPERATORS=7+3^20@ ~ 0@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B& 1.7 - CELL REFERENCE OPERATORS  Cell reference=($V$26)"@D~ "@!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B TokenFormula Is Must Ok?=7+(3^2)0@ ~ 0@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  Token Formula  Is Must Ok?~ ? Intersection=(($V$27) ($V$27))-$@F&, $$~ $@!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtParen =(1)?~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=(7+3)^2Y@ ~ Y@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  tList =SUM((Q27:Q29,Q28:Q30)); @&.,%%~ @!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ ?Repeated =((((11))))&@ ~ &@!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BtUPlus =+(2)@~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=2^3*4+5!B@~ B@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tIsect =SUM(Q27:Q29 Q28:Q30)4 @&<,%%~ @!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ ?tUMinus =-(3)~ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B =2^3*(4+5)"R@~ R@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B tRange =SUM(Q27:Q29:Q28:Q30)4 @&D,%%~ @!?D ADAB$D ADA GD AA&DAA&B$ D ADA D D B$"B ERR!B~ ? 1.11 - SPACEStPercent =4%{Gz?~ @!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B =2^(3*4)+5"@~ @ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B TokenFormula Is Must Ok? =(2^3)*4+5"B@~ B@ !?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B0 (1.8 - CELL REFERENCE OPERATOR PRECEDENCE  Constant value = 1?@~ ?!?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B ;l D! "|7 #>K$7%&% '(ƀ(w);C*+,3F-I.0M/ 0b120M3tE45 6 7789:;v <=>?B 1.3 - BINARY OPERATORS      =2^(3*4+5)" A~ A !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B Formula  Is Must Ok?  Constant array = {2}* @ @@L,@~ @ !?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B !Token!Formula !Is !Must !Ok?! =2^(3*(4+5))#!A~ !A! !?D!AD!AB$D!AD!A GD!AA&D!AA&B$ D!AD!A D!D! B$"B ERR!B/! '=SUM((Q34:Q36:Q35:Q37 Q36:Q38,Q37:Q39))K! 6@+&V,%!#%"$%#%%$&#$$&~ !6@!!?D! AD!AB$D! AD!A GD! AA&D!AA&B$ D! AD!A D! D! B$"B ERR!B~ !?!Unary operator (pre)!= +(3)!@ @~ !@!!?D!AD!AB$D!AD!A GD!AA&D!AA&B$ D!AD!A D!D! B$"B ERR!B "tAdd "=3+2"@~ "@"!?D"AD"AB$D"AD"A GD"AA&D"AA&B$ D"AD"A D"D" B$"B ERR!B" =2^((3*4)+5)#"A~ "A" !?D"AD"AB$D"AD"A GD"AA&D"AA&B$ D"AD"A D"D" B$"B ERR!B1" )=SUM(((Q34:Q36:Q35:Q37) Q36:Q38,Q37:Q39))L" 6@,&d, %!#%"$%#%%$&#$$&~ "6@"!?D" AD"AB$D" AD"A GD" AA&D"AA&B$ D" AD"A D" D" B$"B ERR!B~ "@"Unary operator (post)"=400 %"@@~ "@"!?D"AD"AB$D"AD"A GD"AA&D"AA&B$ D"AD"A D"D" B$"B ERR!B #tSub #=3-2#?~ #?#!?D#AD#AB$D#AD#A GD#AA&D#AA&B$ D#AD#A D#D# B$"B ERR!B# =(2^3*4)+5"#B@~ #B@# !?D#AD#AB$D#AD#A GD#AA&D#AA&B$ D#AD#A D#D# B$"B ERR!B1# )=SUM((Q34:Q36:(Q35:Q37 Q36:Q38),Q37:Q39))L# 9@,&r, %!#%"$%#%%$&!$$&~ #9@#!?D# AD#AB$D# AD#A GD# AA&D#AA&B$ D# AD#A D# D# B$"B ERR!B~ #@#Binary operator#=2 +3#@ @~ #@#!?D#AD#AB$D#AD#A GD#AA&D#AA&B$ D#AD#A D#D# B$"B ERR!B $tMul $=3*2$@~ $@$!?D$AD$AB$D$AD$A GD$AA&D$AA&B$ D$AD$A D$D$ B$"B ERR!B$ =(2^(3*4))+5#$@~ $@$ !?D$AD$AB$D$AD$A GD$AA&D$AA&B$ D$AD$A D$D$ B$"B ERR!B1$ )=SUM((Q34:Q36:Q35:Q37 (Q36:Q38,Q37:Q39)))L$ &@,&, %!#%"$%#%%$&#$$$~ $&@$!?D$ AD$AB$D$ AD$A GD$ AA&D$AA&B$ D$ AD$A D$ D$ B$"B ERR!B~ $@$Function, 0 params$ = PI( )$-DT! @ @@A$-DT! @$!?D$AD$AB$D$AD$A GD$AA&D$AA&B$ D$AD$A D$D$ B$"B ERR!B %tDiv %=3/2%?~ %?%!?D%AD%AB$D%AD%A GD%AA&D%AA&B$ D%AD%A D%D% B$"B ERR!B% =((2^3)*4)+5#%B@~ %B@% !?D%AD%AB$D%AD%A GD%AA&D%AA&B$ D%AD%A D%D% B$"B ERR!B1% )=SUM(((Q34:Q36:Q35:Q37 Q36:Q38),Q37:Q39))L% 6@,&, %!#%"$%#%%$&#$$&~ %6@%!?D% AD%AB$D% AD%A GD% AA&D%AA&B$ D% AD%A D% D% B$"B ERR!B~ %@%Function, 1 param% = ABS( 7 )$%@@@@A~ %@%!?D%AD%AB$D%AD%A GD%AA&D%AA&B$ D%AD%A D%D% B$"B ERR!B&tPower &=3^2&"@~ &"@&!?D&AD&AB$D&AD&A GD&AA&D&AA&B$ D&AD&A D&D& B$"B ERR!B&=5+4*3^2!&D@~ &D@& !?D&AD&AB$D&AD&A GD&AA&D&AA&B$ D&AD&A D&D& B$"B ERR!B1& )=SUM((Q34:Q36:(Q35:Q37 Q36:Q38,Q37:Q39)))F& 5@,&, %!#%"$%#%%$&!&~ &5@&!?D& AD&AB$D& AD&A GD& AA&D&AA&B$ D& AD&A D& D& B$"B ERR!B~ &@&Function, 2 params&= SUM( 3, 5 ),& @@@@@B~ & @&!?D&AD&AB$D&AD&A GD&AA&D&AA&B$ D&AD&A D&D& B$"B ERR!B'tConcat'="A"&"B"'0 'ABAB 'AB'!?D'AD'AB$D'AD'A GD'AA&D'AA&B$ D'AD'A D'D' B$"B ERR!B' =5+4*(3^2)"'D@~ 'D@' !?D'AD'AB$D'AD'A GD'AA&D'AA&B$ D'AD'A D'D' B$"B ERR!B/' '=SUM((Q40:Q42,Q41:Q43 Q42:Q44:Q43:Q45))K' *@+&,%')%(*%)+%*,'))*~ '*@'!?D' AD'AB$D' AD'A GD' AA&D'AA&B$ D' AD'A D' D' B$"B ERR!B~ '?'Cell reference'= $V$40'"@@D'~ '"@'!?D'AD'AB$D'AD'A GD'AA&D'AA&B$ D'AD'A D'D' B$"B ERR!B( =5+(4*3)^2"(b@~ (b@( !?D(AD(AB$D(AD(A GD(AA&D(AA&B$ D(AD(A D(D( B$"B ERR!B1( )=SUM(((Q40:Q42,Q41:Q43) Q42:Q44:Q43:Q45))L( $@,&, %')%(*%)+%*,)))*~ ($@(!?D( AD(AB$D( AD(A GD( AA&D(AA&B$ D( AD(A D( D( B$"B ERR!B~ (@( Intersection(= $V$41 $V$412($@@F, $($(@((~ ($@(!?D(AD(AB$D(AD(A GD(AA&D(AA&B$ D(AD(A D(D( B$"B ERR!B))!1.4 - BINARY COMPARISON OPERATORS))))) =(5+4)*3^2")@T@~ )@T@) !?D)AD)AB$D)AD)A GD)AA&D)AA&B$ D)AD)A D)D) B$"B ERR!B1) )=SUM((Q40:Q42,(Q41:Q43 Q42):Q43:Q44:Q45))N) 8@.&,"%')%(*$)%*+$,~')),~ )8@)!?D) AD)AB$D) AD)A GD) AA&D)AA&B$ D) AD)A D) D) B$"B ERR!B~ )@) Parentheses) = ( 11 )")&@@ @@~ )&@)!?D)AD)AB$D)AD)A GD)AA&D)AA&B$ D)AD)A D)D) B$"B ERR!B *Token*Formula *Is *Must *Ok?* =5+(4*3^2)"*D@~ *D@* !?D*AD*AB$D*AD*A GD*AA&D*AA&B$ D*AD*A D*D* B$"B ERR!B1* )=SUM((Q40:Q42,Q41:Q43 (Q42:Q44:Q43:Q45)))L* *@,&, %')%(*%)+%*,'))*~ **@*!?D* AD*AB$D* AD*A GD* AA&D*AA&B$ D* AD*A D* D* B$"B ERR!B~ *@* tFuncVar(IF)*= IF( FALSE, 1 ) +1;*?)@@@@B@~ *?*!?D*AD*AB$D*AD*A GD*AA&D*AA&B$ D*AD*A D*D* B$"B ERR!B +tLT +=3<2+ ++!?D+AD+AB$D+AD+A GD+AA&D+AA&B$ D+AD+A D+D+ B$"B ERR!B+ =5+(4*(3^2))#+D@~ +D@+ !?D+AD+AB$D+AD+A GD+AA&D+AA&B$ D+AD+A D+D+ B$"B ERR!B1+ )=SUM(((Q40:Q42,Q41:Q43 Q42:Q44):Q43:Q45))F+ 5@,&, %')%(*%)+%*,',~ +5@+!?D+ AD+AB$D+ AD+A GD+ AA&D+AA&B$ D+ AD+A D+ D+ B$"B ERR!B~ +@+ tFuncVar(IF)+= IF( TRUE, 1 ) +1;+@)@@@@B@~ +@+!?D+AD+AB$D+AD+A GD+AA&D+AA&B$ D+AD+A D+D+ B$"B ERR!B ,tLE ,=3<=2, ,,!?D,AD,AB$D,AD,A GD,AA&D,AA&B$ D,AD,A D,D, B$"B ERR!B, =5+((4*3)^2)#,b@~ ,b@, !?D,AD,AB$D,AD,A GD,AA&D,AA&B$ D,AD,A D,D, B$"B ERR!B1, )=SUM((Q40:Q42,(Q41:Q43 Q42:Q44:Q43:Q45)))L, *@,&, %')%(*%)+%*,'))*~ ,*@,!?D, AD,AB$D, AD,A GD, AA&D,AA&B$ D, AD,A D, D, B$"B ERR!B~ ,@, tFuncVar(IF),= IF( FALSE, 1, 2 ) +1F,@4@ @@@@B@~ ,@,!?D,AD,AB$D,AD,A GD,AA&D,AA&B$ D,AD,A D,D, B$"B ERR!B -tEQ -=3=2- --!?D-AD-AB$D-AD-A GD-AA&D-AA&B$ D-AD-A D-D- B$"B ERR!B- =(5+4*3)^2"-r@~ -r@- !?D-AD-AB$D-AD-A GD-AA&D-AA&B$ D-AD-A D-D- B$"B ERR!B-  =-Q46 Q46+- F, $-$---~ --!?D- AD-AB$D- AD-A GD- AA&D-AA&B$ D- AD-A D- D- B$"B ERR!B~ -?- tFuncVar(IF)-= IF( TRUE, 1, 2 ) +1F-@4@ @@@@B@~ -@-!?D-AD-AB$D-AD-A GD-AA&D-AA&B$ D-AD-A D-D- B$"B ERR!B .tGE .=3>=2. ..!?D.AD.AB$D.AD.A GD.AA&D.AA&B$ D.AD.A D.D. B$"B ERR!B. =(5+(4*3))^2#.r@~ .r@. !?D.AD.AB$D.AD.A GD.AA&D.AA&B$ D.AD.A D.D. B$"B ERR!B.  =-(Q47):Q47,. F- $.$...~ ..!?D. AD.AB$D. AD.A GD. AA&D.AA&B$ D. AD.A D. D. B$"B ERR!B~ .@.tFuncVar(CHOOSE).= CHOOSE( 1, 2, 3 ) +1M.@;@$@@@@Bd@~ .@.!?D.AD.AB$D.AD.A GD.AA&D.AA&B$ D.AD.A D.D. B$"B ERR!B /tGT /=3>2/ //!?D/AD/AB$D/AD/A GD/AA&D/AA&B$ D/AD/A D/D/ B$"B ERR!B/ =((5+4)*3)^2#/Ȇ@~ /Ȇ@/ !?D/AD/AB$D/AD/A GD/AA&D/AA&B$ D/AD/A D/D/ B$"B ERR!B/  =-Q48:(Q48),/ F - $/$///~ //!?D/ AD/AB$D/ AD/A GD/ AA&D/AA&B$ D/ AD/A D/ D/ B$"B ERR!B~ /@/tFuncVar(CHOOSE)/= CHOOSE( 2, 2, 3 ) +1M/@;@$@@@@Bd@~ /@/!?D/AD/AB$D/AD/A GD/AA&D/AA&B$ D/AD/A D/D/ B$"B ERR!B 0tNE 0=3<>2000!?D0AD0AB$D0AD0A GD0AA&D0AA&B$ D0AD0A D0D0 B$"B ERR!B0=2^3/4-5!0~ 00 !?D0AD0AB$D0AD0A GD0AA&D0AA&B$ D0AD0A D0D0 B$"B ERR!B0tFuncVar(CHOOSE)0= CHOOSE( 3, 2, 3 ) +1M0;@$@@@@Bd@00!?}D0AD0AB$GD0AA&D0AA&B$ D0AD0A D0D0 B$"B ERR!B1=5-3/4^2!1@@~ 1@@1 !?D1AD1AB$D1AD1A GD1AA&D1AA&B$ D1AD1A D1D1 B$"B ERR!B2=2+3&72' 57 2572 !?D2AD2AB$D2AD2A GD2AA&D2AA&B$ D2AD2A D2D2 B$"B ERR!B3=2+(3&7)3C@ ~ 3C@3 !?D3AD3AB$D3AD3A GD3AA&D3AA&B$ D3AD3A D3D3 B$"B ERR!B4=(2+3)&74' 57 4574 !?D4AD4AB$D4AD4A GD4AA&D4AA&B$ D4AD4A D4D4 B$"B ERR!B5=2+3=75  55 !?D5AD5AB$D5AD5A GD5AA&D5AA&B$ D5AD5A D5D5 B$"B ERR!B6=2+(3=7)6@  ~ 6@6 !?D6AD6AB$D6AD6A GD6AA&D6AA&B$ D6AD6A D6D6 B$"B ERR!B7=(2+3)=77  77 !?D7AD7AB$D7AD7A GD7AA&D7AA&B$ D7AD7A D7D7 B$"B ERR!B8=-(3)+28 ~ 88 !?D8AD8AB$D8AD8A GD8AA&D8AA&B$ D8AD8A D8D8 B$"B ERR!B9=-(3+2)9 ~ 99 !?D9AD9AB$D9AD9A GD9AA&D9AA&B$ D9AD9A D9D9 B$"B ERR!B: =-(3)+-(2): ~ :: !?D:AD:AB$D:AD:A GD:AA&D:AA&B$ D:AD:A D:D: B$"B ERR!B;=-(3)*2; ~ ;; !?D;AD;AB$D;AD;A GD;AA&D;AA&B$ D;AD;A D;D; B$"B ERR!B<=-(3*2)< ~ << !?D<AD<AB$D<AD<A GD<AA&D<AA&B$ D<AD<A D<D< B$"B ERR!B= =-(3)*-(2)=@ ~ =@= !?D=AD=AB$D=AD=A GD=AA&D=AA&B$ D=AD=A D=D= B$"B ERR!B>=-(3)^2>"@ ~ >"@> !?D>AD>AB$D>AD>A GD>AA&D>AA&B$ D>AD>A D>D> B$"B ERR!B?=-(3^2)?" ~ ?"? !?D?AD?AB$D?AD?A GD?AA&D?AA&B$ D?AD?A D?D? B$"B ERR!B@ d DA  B 7 C >KD 7E @ =-(2)^-(2)@? ~ @?@ !?D@AD@AB$D@AD@A GD@AA&D@AA&B$ D@AD@A D@D@ B$"B ERR!BA =50%^200%A ? 2~ A ?A !?DAADAAB$DAADAA GDAAA&DAAA&B$ DAADAA DADA B$"B ERR!BB=-(50)%^-(200)%B@ 2~ B@B !?DBADBAB$DBADBA GDBAA&DBAA&B$ DBADBA DBDB B$"B ERR!BC =--50%^--200%)C?Ii~ C ?C !?DCADCAB$DCADCA GDCAA&DCAA&B$ DCADCA DCDC B$"B ERR!BD=---(10000)%%%D{Gz '~ DD !?DDADDAB$DDADDA GDDAA&DDAA&B$ DDADDA DDDD B$"B ERR!BE =-+-+-+(1)E ~ EE !?DEADEAB$DEADEA GDEAA&DEAA&B$ DEADEA DEDE B$"B ERR!B= -zIb%> " n Param  )!B d MbP?"*+_%111 Arial1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1hTimes New Roman1Times New Roman1 Arial1Times New Roman1 Arial&F Seite &P&[4d2?'[4d2?(<~?)<~?M  d d@V General00.00#,##0 #,##0.00 #,##0;\-#,##0#,##0;[Red]\-#,##0#,##0.00;\-#,##0.00#,##0.00;[Red]\-#,##0.00#,##0\ "";\-#,##0\ ""#,##0\ "";[Red]\-#,##0\ "" #,##0.00\ "";\-#,##0.00\ ""%"#,##0.00\ "";[Red]\-#,##0.00\ ""0%0.00% 0.00E+00 #\ ?/? #\ ??/??  dd/mm/yyyy dd/\ mmm\ yy dd/\ mmm mmm\ yy h:mm\ AM/PMh:mm:ss\ AM/PMhh:mm hh:mm:ssdd/mm/yyyy\ hh:mm"ok";\-General;0;[Red]@        ALCF2E24C5, ALCF2F25BD- DLCF2D2407,cC C  C  C  C  C C C C C C C C C C C  C  C  C  B}C  CSC BKC C "C  C  C  C ! B}C 1 CSC A BKC QC C C a" Header0 Header1 Header2 Header3OkU } #}  } }   !   D {  ;7  >K |7  ;  Wƀ Jw      F  0M   b T '0M ;tE b X  M 7  ; Z J*FORMULA TEST DOCUMENT &2 - SPECIAL PARAMETER HANDLING 6.2.1 - ADD MISSING/DIFFERENT DEFAULT PARAMETERS Formula Is Must Ok? =FLOOR(-15,-10)'$.$A~ $ ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=CEILING(-15,-10)'4.$A ~ 4 ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B+ #2.2 - REMOVE UNSUPPORTED PARAMETERS     Formula Is Must Ok? # =PERCENTRANK($D$12:$D$15,2) Zd;O?% BI Zd;O?  ?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ ?% =PERCENTRANK($D$12:$D$15,2,1)# 333333?% BI~ >@  ?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @% =PERCENTRANK($D$12:$D$15,2,3)# Zd;O?% BI Zd;O?  ?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @%=PERCENTRANK($D$12:$D$15,2,5)#1ZGU?% BI1ZGU? ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ @=INDIRECT("$E$16")!@$E$16B~ @ ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ @=INDIRECT("$E$17",TRUE)#@$E$17B~ @ ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ @=ADDRESS(18,5)6' B$E$18 $E$18 ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=ADDRESS(19,5,4)T' BE19 E19 ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B=ADDRESS(20,5,4,TRUE)!r'BE20 E20 ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B4,Test cells for 3D references in other sheets %=ADDRESS(21,5,4,TRUE,"Param")('ParamB Param!E21 Param!E21 ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ 0@~ 1@( 2.3 - REPLACE DEFAULT PARAMETERS~ 2@Formula Is Must Ok?~ 3@ =IF(FALSE,)!B ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B =IF(TRUE,)!B~  ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B =IF(FALSE,,)&B~  ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B =IF(TRUE,,)&B~  ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B.&2.4 - REMOVE TRAILING EMPTY PARAMETERSFormula Is Must Ok?=SUM(1,)?B~ ? ?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B  D =SUM( 1, 1, , ). @@@@@B~ @  ?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B= H$> " N Functions   3 ^;EFB d MbP?"*+_%111 Arial1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 MS Sans Serif1 Arial1hTimes New Roman1Times New Roman1Times New Roman1 Arial&F Seite &P&[4d2?'[4d2?(<~?)<~?M  d d@:# ACCRINT# ACCRINTM# AMORDEGRC# AMORLINC# BESSELI# BESSELJ# BESSELK# BESSELY# BIN2DEC# BIN2HEX# BIN2OCT# COMPLEX# CONVERT# COUPDAYBS# COUPDAYS# COUPDAYSNC# COUPNCD# COUPNUM# COUPPCD# CUMIPMT# CUMPRINC# DEC2BIN# DEC2HEX# DEC2OCT# DELTA# DISC# DOLLARDE# DOLLARFR# DURATION# EDATE# EFFECT# EOMONTH#ERF# ERFC# FACTDOUBLE# FVSCHEDULE#GCD# GESTEP# HEX2BIN# HEX2DEC# HEX2OCT# IMABS# IMAGINARY# IMARGUMENT# IMCONJUGATE# IMCOS# IMDIV# IMEXP# IMLN# IMLOG10# IMLOG2# IMPOWER# IMPRODUCT# IMREAL# IMSIN# IMSQRT# IMSUB# IMSUM# INTRATE# ISEVEN# ISODD#LCM# MDURATION# MROUND# MULTINOMIAL# NETWORKDAYS# NOMINAL# OCT2BIN# OCT2DEC# OCT2HEX# ODDFPRICE# ODDFYIELD# ODDLPRICE# ODDLYIELD# PRICE# PRICEDISC# PRICEMAT# QUOTIENT# RANDBETWEEN# RECEIVED# SERIESSUM# SQRTPI# TBILLEQ# TBILLPRICE# TBILLYIELD# WEEKNUM# WORKDAY# XIRR# XNPV# YEARFRAC# YIELD# YIELDDISC# YIELDMATYV General00.00#,##0 #,##0.00 #,##0;\-#,##0#,##0;[Red]\-#,##0#,##0.00;\-#,##0.00#,##0.00;[Red]\-#,##0.00#,##0\ "";\-#,##0\ ""#,##0\ "";[Red]\-#,##0\ "" #,##0.00\ "";\-#,##0.00\ ""%"#,##0.00\ "";[Red]\-#,##0.00\ ""0%0.00% 0.00E+00 #\ ?/? #\ ??/??  dd/mm/yyyy dd/\ mmm\ yy dd/\ mmm mmm\ yy h:mm\ AM/PMh:mm:ss\ AM/PMhh:mm hh:mm:ssdd/mm/yyyy\ hh:mm d/m/yy"ok";\-General;0;[Red]@       cC C  C  C  C  C C C C C C C C C C C  C  C  C  B}C  CSC BKC C "C  C  C  C ! B}C 1 CSC A BKC QC C  C C  C  C  C a" Header0 Header1 Header2 Header3OkU } } } } } } } } } }  D D ;7  >K!7       F0];b0]te M57^FORMULA TEST DOCUMENT     3 - ALL SHEET FUNCTIONS     *"3.1 - FUNCTIONS SUPPORTED IN BIFF2*"3.2 - FUNCTIONS SUPPORTED IN BIFF3    '3.4 - ANALYSIS ADD-IN FUNCTIONS IndexFunction Is Must Ok? Test values Index Function  Is  Must  Ok?Function Is Must Ok?~  COUNT?B~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ ?~ @~ i@  YEN/USDOLLAR ' B1   1  $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BACCRINTC1i#?nB~ ?$$-DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ ? IF$?B~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ ?~ @~ i@  FINDB ? AAB~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BACCRINTM=+՚#?B~ $PpDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ @ ISNADA$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ ?~ ~ i@ SEARCHB ? AAB~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B AMORDEGRCI7S#?d ?B~ 9@$VpDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ @ ISERROR DA  $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ i@ REPLACEB! 'AAAA A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B AMORLINCI 7ɟ#`?d ?B~ $@ $\pD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~ @ SUM ?~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ j@ LEFTB ('ABA A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B BESSELI7 %-#?B~  $bpD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~ @ AVERAGE ?B~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~  j@ RIGHTB N'ABA A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B BESSELJ7 %#?B~  $xD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~ @ MIN ?B~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ @j@ MIDB n' AAA A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B BESSELK7 i%#?B  i? $hpD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~ @ MAX ?B~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B~ `j@ LENB ?AA~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B BESSELY7 E%c# ?B E? $xD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~  @ ROW?$B~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ j@ ROUNDUP! ??A~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BBIN2DEC4"˫# ?1B~ ?$0DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ "@COLUMN?$B ~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ j@  ROUNDDOWN! ?ffffff?A~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BBIN2HEX4o"%# ?1B  1$*-DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ $@ NA*A *$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ j@  ASC 'AAA  A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BBIN2OCT4o"# ?1B  1$6DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ &@ NPV? B ~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ j@ JIS/DBCS 'AAA  A $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCOMPLEX7o%# ^_?B  1$xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ (@ STDEV B ~ $?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ `k@ ADDRESS B' B$A$1  $A$1 $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCONVERT:(Y# F?mmB~ ?$<DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ *@DOLLARd' B 1   1 $?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ k@ DAYS360  DDDDB~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B COUPDAYBS:({#~?dB~ ?$xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ ,@ FIXED' B1  1$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B Test values~ k@  TODAY " ;@AV $?DD AA&D AA&D AB$B ERR!BCOUPDAYS:(#?B~ v@$oDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ .@ SIN? AA~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B*~ k@  VBD% B~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B COUPDAYSNC:(S#F ?B~ ?$npDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 0@ COS?A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ `l@ MEDIAN ?B~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCOUPNCD:(#D?B~ @$tpDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 1@ TANA~ $?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ l@  SUMPRODUCT ?B~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCOUPNUM:(#?B~ ?$xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 2@ ATANA~ $?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ l@  SINH A~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCOUPPCD:(y#?B~ $zpDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 3@ PI-DT! @A-DT! @$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ l@  COSH ?A~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCUMIPMTC1#D?B~ $xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 4@ SQRT?A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ l@  TANH A~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BCUMPRINCC1Q#N?B~ $xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 5@ EXP?A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ m@  ASINH A~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BDEC2BIN4o"#?B  1$xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 6@ LNA~ $?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~  m@  ACOSH A~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BDEC2HEX4o" #?B  1$ xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 7@ LOG10? A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ @m@  ATANH A~   $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!BDEC2OCT4o"s#F?B  1$&xDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 8@ ABS?A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ `m@  DGET& ?%%A~  ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D B$"B ERR!B DELTA7%#W ?B~ ?$oDADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR!~ 9@ INT?A~ ?$?DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!B~ n@  INFO! osystemAPCDOSV $?DD AA&D AA&D AB$B ERR!B DISC=+=#?B~ $܄DADAB$DADA GDAA&DAA&B$ DADA DD B$"B ERR!BERR! l D!; "I7 #T>K$7%&'()*+,F-.0M/ 0b120]3te45 6M57789:;<=^>2?B~ :@ SIGN ?A~ ? $?D AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!B DOLLARDE7 %#F?B~ ? $oD AD AB$D AD A GD AA&D AA&B$ D AD A D D  B$"B ERR!BERR!~ !;@ !ROUND!? A~ !?!$?D!AD!AB$D!AD!A GD!AA&D!AA&B$ D!AD!A D!D! B$"B ERR!B*!"3.3 - FUNCTIONS SUPPORTED IN BIFF4! ! ! ! !DOLLARFR7!%#P&?B~ !?!$oD!AD!AB$D!AD!A GD!AA&D!AA&B$ D!AD!A D!D! B$"B ERR!BERR!~ "<@"LOOKUP "?%B~ "?"$?D"AD"AB$D"AD"A GD"AA&D"AA&B$ D"AD"A D"D" B$"B ERR!B "Index" Function " Is " Must " Ok?"DURATION@".# ?UB~ "?"$pD"AD"AB$D"AD"A GD"AA&D"AA&B$ D"AD"A D"D" B$"B ERR!BERR!~ #=@ #INDEX!#?$B~ #?#$?D#AD#AB$D#AD#A GD#AA&D#AA&B$ D#AD#A D#D# B$"B ERR!B~ #k@ # RANK# ? $B~ # ?# $?D# AD# AB$D# AD# A GD# AA&D# AA&B$ D# AD# A D# D# B$"B ERR!B #EDATE7#%o#?B~ #@@#$,xD#AD#AB$D#AD#A GD#AA&D#AA&B$ D#AD#A D#D# B$"B ERR!BERR!~ $>@ $REPT$' AAA $A$$?D$AD$AB$D$AD$A GD$AA&D$AA&B$ D$AD$A D$D$ B$"B ERR!B~ $n@ $ DB"$ ?B~ $ ?$ $?D$ AD$ AB$D$ AD$ A GD$ AA&D$ AA&B$ D$ AD$ A D$ D$ B$"B ERR!B$EFFECT7$%#?B~ $?$$uD$AD$AB$D$AD$A GD$AA&D$AA&B$ D$AD$A D$D$ B$"B ERR!BERR!~ %?@ %MID%' AAA %A%$?D%AD%AB$D%AD%A GD%AA&D%AA&B$ D%AD%A D%D% B$"B ERR!B~ %o@%  FREQUENCY% ? A~ % ?% $?D% AD% AB$D% AD% A GD% AA&D% AA&B$ D% AD% A D% D% B$"B ERR!B%EOMONTH7%%# ?B~ %M@%$uD%AD%AB$D%AD%A GD%AA&D%AA&B$ D%AD%A D%D% B$"B ERR!BERR!~ &@@ &LEN&?AA ~ &?&$?D&AD&AB$D&AD&A GD&AA&D&AA&B$ D&AD&A D&D& B$"B ERR!B~ &Pp@&  ERROR.TYPE& @DAV& $?DD& AA&D& AA&D& AB$B ERR!B &ERF4&"S#!|?B~ &&$xD&AD&AB$D&AD&A GD&AA&D&AA&B$ D&AD&A D&D& B$"B ERR!BERR!~ '@@ 'VALUE'?1A!~ '?'$?D'AD'AB$D'AD'A GD'AA&D'AA&B$ D'AD'A D'D' B$"B ERR!B~ 'p@' AVEDEV' B ~ ' ' $?D' AD' AB$D' AD' A GD' AA&D' AA&B$ D' AD' A D' D' B$"B ERR!B 'ERFC4'"#"?B~ '?'$-D'AD'AB$D'AD'A GD'AA&D'AA&B$ D'AD'A D'D' B$"B ERR!BERR!~ (A@ (TRUE(A"(($?D(AD(AB$D(AD(A GD(AA&D(AA&B$ D(AD(A D(D( B$"B ERR!B~ (p@( BETADIST( ? B~ ( ?( $?D( AD( AB$D( AD( A GD( AA&D( AA&B$ D( AD( A D( D( B$"B ERR!B( FACTDOUBLE4("##g?B~ (?($pD(AD(AB$D(AD(A GD(AA&D(AA&B$ D(AD(A D(D( B$"B ERR!BERR!~ )A@ )FALSE)A#))$?D)AD)AB$D)AD)A GD)AA&D)AA&B$ D)AD)A D)D) B$"B ERR!B~ )p@) GAMMALN) ƽA~ ) ƽ) $?D) AD) AB$D) AD) A WD) AA&D) AA&B$0D) AD) A D) D) D) -C6? B$"B ERR!B) FVSCHEDULE7)%#$Z?B~ )?)$mD)AD)AB$D)AD)A GD)AA&D)AA&B$ D)AD)A D)D) B$"B ERR!BERR!~ *B@ *AND*B$**$?D*AD*AB$D*AD*A GD*AA&D*AA&B$ D*AD*A D*D* B$"B ERR!B~ *q@* BETAINV%* ??B~ * ?* $?D* AD* AB$D* AD* A WD* AA&D* AA&B$0D* AD* A D* D* D* -C6? B$"B ERR!B *GCD4*"#%F?B~ *?*$oD*AD*AB$D*AD*A GD*AA&D*AA&B$ D*AD*A D*D* B$"B ERR!BERR!~ +B@ +OR+B%++$?D+AD+AB$D+AD+A GD+AA&D+AA&B$ D+AD+A D+D+ B$"B ERR!B~ +q@+  BINOMDIST!+ A~ + ?+ $?D+ AD+ AB$D+ AD+ A WD+ AA&D+ AA&B$0D+ AD+ A D+ D+ D+ -C6? B$"B ERR!B+GESTEP4+"#&?B~ +?+$pD+AD+AB$D+AD+A GD+AA&D+AA&B$ D+AD+A D+D+ B$"B ERR!BERR!~ ,C@ ,NOT,A&,,$?D,AD,AB$D,AD,A GD,AA&D,AA&B$ D,AD,A D,D, B$"B ERR!B~ , q@, CHIDIST, ? A~ , ?, $?D, AD, AB$D, AD, A WD, AA&D, AA&B$0D, AD, A D, D, D, -C6? B$"B ERR!B,HEX2BIN4,o"#'V?1B , 1,$wD,AD,AB$D,AD,A GD,AA&D,AA&B$ D,AD,A D,D, B$"B ERR!BERR!~ -C@ -MOD-? A'~ -?-$?D-AD-AB$D-AD-A GD-AA&D-AA&B$ D-AD-A D-D- B$"B ERR!B~ -0q@- CHIINV- j(= A- "W<<- $'D- AD- AB$D- AD- A WD- AA&D- AA&B$0D- AD- A D- D- D- -C6? B$"B ERR!BERR!-HEX2DEC4-"y#( ?1B~ -?-$wD-AD-AB$D-AD-A GD-AA&D-AA&B$ D-AD-A D-D- B$"B ERR!BERR!~ .D@.DCOUNT&.?%%A(~ .?.$?D.AD.AB$D.AD.A GD.AA&D.AA&B$ D.AD.A D.D. B$"B ERR!B~ .@q@. COMBIN. ? A~ . ?. $?D. AD. AB$D. AD. A WD. AA&D. AA&B$0D. AD. A D. D. D. -C6? B$"B ERR!B.HEX2OCT4.o"#)?1B . 1.$xD.AD.AB$D.AD.A GD.AA&D.AA&B$ D.AD.A D.D. B$"B ERR!BERR!~ /D@ /DSUM&/?%%A)~ /?/$?D/AD/AB$D/AD/A GD/AA&D/AA&B$ D/AD/A D/D/ B$"B ERR!B~ /Pq@/  CONFIDENCE$/ l??A/ HRk?/ $?D/ AD/ AB$D/ AD/ A WD/ AA&D/ AA&B$0D/ AD/ A D/ D/ D/ -C6? B$"B ERR!B /IMABS4/"{#*S?B~ /?/$xD/AD/AB$D/AD/A GD/AA&D/AA&B$ D/AD/A D/D/ B$"B ERR!BERR!~ 0E@0DAVERAGE&0?%%A*~ 0?0$?D0AD0AB$D0AD0A GD0AA&D0AA&B$ D0AD0A D0D0 B$"B ERR!B~ 0`q@0  CRITBINOM*0 ??A~ 0 0 $?D0 AD0 AB$D0 AD0 A GD0 AA&D0 AA&B$ D0 AD0 A D0 D0 B$"B ERR!B0 IMAGINARY40"#+u?B~ 00$ℇD0AD0AB$D0AD0A GD0AA&D0AA&B$ D0AD0A D0D0 B$"B ERR!BERR!~ 1E@ 1DMIN&1?%%A+~ 1?1$?D1AD1AB$D1AD1A GD1AA&D1AA&B$ D1AD1A D1D1 B$"B ERR!B~ 1pq@ 1 EVEN1 @A~ 1 @1 $?D1 AD1 AB$D1 AD1 A GD1 AA&D1 AA&B$ D1 AD1 A D1 D1 B$"B ERR!B1 IMARGUMENT41"U#, ?B~ 11$oD1AD1AB$D1AD1A GD1AA&D1AA&B$ D1AD1A D1D1 B$"B ERR!BERR!~ 2F@ 2DMAX&2?%%A,~ 2?2$?D2AD2AB$D2AD2A GD2AA&D2AA&B$ D2AD2A D2D2 B$"B ERR!B~ 2q@2  EXPONDIST2  A~ 2 2 $?D2 AD2 AB$D2 AD2 A GD2 AA&D2 AA&B$ D2 AD2 A D2 D2 B$"B ERR!B2 IMCONJUGATE42o"#-j?B 2 12$mD2AD2AB$D2AD2A GD2AA&D2AA&B$ D2AD2A D2D2 B$"B ERR!BERR!~ 3F@3DSTDEV&3%%A-~ 33$?D3AD3AB$D3AD3A GD3AA&D3AA&B$ D3AD3A D3D3 B$"B ERR!B~ 3q@ 3 FDIST3 ? A~ 3 ?3 $?D3 AD3 AB$D3 AD3 A GD3 AA&D3 AA&B$ D3 AD3 A D3 D3 B$"B ERR!B 3IMCOS43o"M#.D?B 3 13$pD3AD3AB$D3AD3A GD3AA&D3AA&B$ D3AD3A D3D3 B$"B ERR!BERR!~ 4G@ 4VAR4 B.~ 44$?D4AD4AB$D4AD4A GD4AA&D4AA&B$ D4AD4A D4D4 B$"B ERR!B~ 4q@ 4 FINV4  A~ 4 4 $?D4 AD4 AB$D4 AD4 A GD4 AA&D4 AA&B$ D4 AD4 A D4 D4 B$"B ERR!B 4IMDIV74o%#/I?B 4 14$脇D4AD4AB$D4AD4A GD4AA&D4AA&B$ D4AD4A D4D4 B$"B ERR!BERR!~ 5G@ 5DVAR&5%%A/~ 55$?D5AD5AB$D5AD5A GD5AA&D5AA&B$ D5AD5A D5D5 B$"B ERR!B~ 5q@5 FISHER5 A~ 5 5 $?D5 AD5 AB$D5 AD5 A GD5 AA&D5 AA&B$ D5 AD5 A D5 D5 B$"B ERR!B 5IMEXP45o"#0u?B 5 15$oD5AD5AB$D5AD5A GD5AA&D5AA&B$ D5AD5A D5D5 B$"B ERR!BERR!~ 6H@ 6TEXT6' 0A01 6 16$?D6AD6AB$D6AD6A GD6AA&D6AA&B$ D6AD6A D6D6 B$"B ERR!B~ 6q@6  FISHERINV6 A~ 6 6 $?D6 AD6 AB$D6 AD6 A GD6 AA&D6 AA&B$ D6 AD6 A D6 D6 B$"B ERR!B 6IMLN46o" #1?B 6 06$oD6AD6AB$D6AD6A GD6AA&D6AA&B$ D6AD6A D6D6 B$"B ERR!BERR!~ 7H@7LINEST7 %B1~ 77$?D7AD7AB$D7AD7A GD7AA&D7AA&B$ D7AD7A D7D7 B$"B ERR!B~ 7q@ 7 FLOOR7 ? A~ 7 ?7 $?D7 AD7 AB$D7 AD7 A GD7 AA&D7 AA&B$ D7 AD7 A D7 D7 B$"B ERR!B7IMLOG1047o" #2? B 7 17$$oD7AD7AB$D7AD7A GD7AA&D7AA&B$ D7AD7A D7D7 B$"B ERR!BERR!~ 8I@ 8TREND8? %B2~ 8?8$?D8AD8AB$D8AD8A GD8AA&D8AA&B$ D8AD8A D8D8 B$"B ERR!B~ 8q@8  GAMMADIST!8 A~ 8 8 $?D8 AD8 AB$D8 AD8 A GD8 AA&D8 AA&B$ D8 AD8 A D8 D8 B$"B ERR!B8IMLOG248o"U#3F?B 8 08$pD8AD8AB$D8AD8A GD8AA&D8AA&B$ D8AD8A D8D8 B$"B ERR!BERR!~ 9I@9LOGEST9? %B3~ 9?9$?D9AD9AB$D9AD9A GD9AA&D9AA&B$ D9AD9A D9D9 B$"B ERR!B~ 9q@9 GAMMAINV9 > A~ 9 9 $6'D9 AD9 AB$D9 AD9 A GD9 AA&D9 AA&B$ D9 AD9 A D9 D9 B$"B ERR!BERR!9IMPOWER79o%#4t ?B 9 19$xD9AD9AB$D9AD9A GD9AA&D9AA&B$ D9AD9A D9D9 B$"B ERR!BERR!~ :J@:GROWTH:? %B4~ :?:$?D:AD:AB$D:AD:A GD:AA&D:AA&B$ D:AD:A D:D: B$"B ERR!B~ :r@: CEILING: ? A ~ : ?: $?D: AD: AB$D: AD: A GD: AA&D: AA&B$ D: AD: A D: D: B$"B ERR!B: IMPRODUCT4: o"=#54?B : 1:$pD:AD:AB$D:AD:A GD:AA&D:AA&B$ D:AD:A D:D: B$"B ERR!BERR!~ ;L@ ;PV; B8~ ;;$?D;AD;AB$D;AD;A GD;AA&D;AA&B$ D;AD;A D;D; B$"B ERR!B~ ;r@;  HYPGEOMDIST!; ?A!~ ; ?; $?D; AD; AB$D; AD; A WD; AA&D; AA&B$0D; AD; A D; D; D; -C6? B$"B ERR!B;IMREAL4;"#6?B~ ;?;$ pD;AD;AB$D;AD;A GD;AA&D;AA&B$ D;AD;A D;D; B$"B ERR!BERR!~ <L@ <FV< B9~ <<$?D<AD<AB$D<AD<A GD<AA&D<AA&B$ D<AD<A D<D< B$"B ERR!B~ < r@<  LOGNORMDIST< ? A"~ < ?< $?D< AD< AB$D< AD< A WD< AA&D< AA&B$0D< AD< A D< D< D< -C6? B$"B ERR!B <IMSIN4< o"7#7P?B < 0<$&pD<AD<AB$D<AD<A GD<AA&D<AA&B$ D<AD<A D<D< B$"B ERR!BERR!~ =M@ =NPER= B:~ ==$?D=AD=AB$D=AD=A GD=AA&D=AA&B$ D=AD=A D=D= B$"B ERR!B~ =0r@= LOGINV$= ??A#~ = ?= $?D= AD= AB$D= AD= A WD= AA&D= AA&B$0D= AD= A D= D= D= -C6? B$"B ERR!B=IMSQRT4= o"#8F?B = 1=$xD=AD=AB$D=AD=A GD=AA&D=AA&B$ D=AD=A D=D= B$"B ERR!BERR!~ >M@ >PMT> B;~ >>$?D>AD>AB$D>AD>A GD>AA&D>AA&B$ D>AD>A D>D> B$"B ERR!B~ >@r@>  NEGBINOMDIST$> ??A$~ > ?> $?D> AD> AB$D> AD> A WD> AA&D> AA&B$0D> AD> A D> D> D> -C6? B$"B ERR!B >IMSUB7> o%?#9?B > 1>$xD>AD>AB$D>AD>A GD>AA&D>AA&B$ D>AD>A D>D> B$"B ERR!BERR!~ ?N@ ?RATE%?!?B<~ ?!??$?D?AD?AB$D?AD?A GD?AA&D?AA&B$ D?AD?A D?D? B$"B ERR!B~ ?Pr@? NORMDIST!? ?A%~ ? ?? $?D? AD? AB$D? AD? A WD? AA&D? AA&B$0D? AD? A D? D? D? -C6? B$"B ERR!B ?IMSUM4? o"#:?B ? 1?$mD?AD?AB$D?AD?A GD?AA&D?AA&B$ D?AD?A D?D? B$"B ERR!BERR!@l DA B7 C>KD7EFGHIJKLFM N0MO  PbQR0]SteTU VM5W7XYZ[\]^^2_B~ @N@ @MIRR"@!?%A=~ @!?@$?D@AD@AB$D@AD@A GD@AA&D@AA&B$ D@AD@A D@D@ B$"B ERR!B~ @`r@@  NORMSDIST@ ?A&~ @ ?@ $?D@ AD@ AB$D@ AD@ A WD@ AA&D@ AA&B$0D@ AD@ A D@ D@ D@ -C6? B$"B ERR!B@INTRATE=@+M"#;W?B~ @@$mD@AD@AB$D@AD@A GD@AA&D@AA&B$ D@AD@A D@D@ B$"B ERR!BERR!~ AO@ AIRRA!Tq>= %B>A!Tq>=A$?DAADAAB$DAADAA WDAAA&DAAA&B$0DAADAA DADADA-C6? B$"B ERR!B~ Apr@A NORMINV$A ??A'~ A ?A $?DA ADA AB$DA ADA A WDA AA&DA AA&B$0DA ADA A DA DA DA -C6? B$"B ERR!BAISEVEN4A"{$#<&?BAA$oDAADAAB$DAADAA GDAAA&DAAA&B$ DAADAA DADA B$"B ERR!BERR!~ BO@ BRANDB_Q?A?VB$?DDBAA&DBAA&DBAB$B ERR!B~ Br@B NORMSINVB  ?A(B 1ZB $?DB ADB AB$DB ADB A WDB AA&DB AA&B$0DB ADB A DB DB DB -C6? B$"B ERR!B BISODD4B"&#=?BBB$xDBADBAB$DBADBA GDBAA&DBAA&B$ DBADBA DBDB B$"B ERR!BERR!~ CP@ CMATCH C?%B@~ C?C$?DCADCAB$DCADCA GDCAA&DCAA&B$ DCADCA DCDC B$"B ERR!B~ Cr@C  STANDARDIZEC  A)~ C C $?DC ADC AB$DC ADC A GDC AA&DC AA&B$ DC ADC A DC DC B$"B ERR!B CLCM4C"G)#>^_?B~ C?C$xDCADCAB$DCADCA GDCAA&DCAA&B$ DCADCA DCDC B$"B ERR!BERR!~ D@P@ DDATED"@ AA~ D"@D$?DDADDAB$DDADDA GDDAA&DDAA&B$ DDADDA DDDD B$"B ERR!B~ Dr@ D ODDD ?A*~ D ?D $?DD ADD AB$DD ADD A GDD AA&DD AA&B$ DD ADD A DD DD B$"B ERR!BD MDURATION@D.+#?D?UB~ D?D$DDADDAB$DDADDA GDDAA&DDAA&B$ DDADDA DDDD B$"B ERR!BERR!~ EP@ ETIMEE#? AB~ E#?E$?DEADEAB$DEADEA GDEAA&DEAA&B$ DEADEA DEDE B$"B ERR!B~ Er@E PERMUTE ? A+~ E ?E $?DE ADE AB$DE ADE A GDE AA&DE AA&B$ DE ADE A DE DE B$"B ERR!BEMROUND7E%!.#@?B~ E?E$*oDEADEAB$DEADEA GDEAA&DEAA&B$ DEADEA DEDE B$"B ERR!BERR!~ FP@ FDAYF8@DDAC~ F8@F$?DFADFAB$DFADFA GDFAA&DFAA&B$ DFADFA DFDF B$"B ERR!B~ Fr@F  POISSONDISTF $ A,~ F ?F $'DF ADF AB$DF ADF A GDF AA&DF AA&B$ DF ADF A DF DF B$"B ERR!BERR!F MULTINOMIAL4F"0#Ax?B~ F?F$0oDFADFAB$DFADFA GDFAA&DFAA&B$ DFADFA DFDF B$"B ERR!BERR!~ GQ@ GMONTHG@DDAD~ G@G$?DGADGAB$DGADGA GDGAA&DGAA&B$ DGADGA DGDG B$"B ERR!B~ Gr@ G TDISTG ? A-~ G ?G $?DG ADG AB$DG ADG A GDG AA&DG AA&B$ DG ADG A DG DG B$"B ERR!BG NETWORKDAYS7G%2#B&?B~ G?G$6oDGADGAB$DGADGA GDGAA&DGAA&B$ DGADGA DGDG B$"B ERR!BERR!~ H@Q@ HYEARH@DDAE~ H@H$?DHADHAB$DHADHA GDHAA&DHAA&B$ DHADHA DHDH B$"B ERR!B~ Hr@H WEIBULL!H A.~ H H $?DH ADH AB$DH ADH A GDH AA&DH AA&B$ DH ADH A DH DH B$"B ERR!BHNOMINAL7H%W5#C?B~ H?H$@DEAH~ K>@K$?DKADKAB$DKADKA GDKAA&DKAA&B$ DKADKA DKDK B$"B ERR!B~ Ks@K SUMX2DY2K @ A1~ K @K $?DK ADK AB$DK ADK A GDK AA&DK AA&B$ DK ADK A DK DK B$"B ERR!BKOCT2HEX4K!o"<#F~?1B K 1K$oDKADKAB$DKADKA GDKAA&DKAA&B$ DKADKA DKDK B$"B ERR!BERR!~ L@R@LSECONDLDEAI~ LL$?DLADLAB$DLADLA GDLAA&DLAA&B$ DLADLA DLDL B$"B ERR!B~ L s@L CHITEST#L ?eeA2~ L ?L $?DL ADL AB$DL ADL A GDL AA&DL AA&B$ DL ADL A DL DL B$"B ERR!BL ODDFPRICEULnWC>#G?P8??dB LnaWY@L$NoDLADLAB$DLADLA GDLAA&DLAA&B$ DLADLA DLDL B$"B ERR!BERR!~ MR@ MNOWM#3;@AJVM$?DDMAA&DMAA&DMAB$B ERR!B~ M0s@M CORREL#M ?eeA3~ M ?M $?DM ADM AB$DM ADM A GDM AA&DM AA&B$ DM ADM A DM DM B$"B ERR!BM ODDFYIELDUM^~_C[A#H&?P8??dB M^[~_g@M$,pDMADMAB$DMADMA GDMAA&DMAA&B$ DMADMA DMDM B$"B ERR!BERR!~ NR@ NAREASN? $AK~ N?N$?DNADNAB$DNADNA GDNAA&DNAA&B$ DNADNA DNDN B$"B ERR!B~ N@s@ N COVAR#N eeA4~ N N $?DN ADN AB$DN ADN A GDN AA&DN AA&B$ DN ADN A DN DN B$"B ERR!BN ODDLPRICERNYM@C#I?P8??BN"YMC@N$2pDNADNAB$DNADNA GDNAA&DNAA&B$ DNADNA DNDN B$"B ERR!BERR!~ OS@ OROWSO? $AL~ O?O$?DOADOAB$DOADOA GDOAA&DOAA&B$ DOADOA DODO B$"B ERR!B~ OPs@O FORECAST&O ?eeA5~ O ?O $?DO ADO AB$DO ADO A GDO AA&DO AA&B$ DO ADO A DO DO B$"B ERR!BO ODDLYIELDROp=|@F#J?P8??BOsp=|+@O$8pDOADOAB$DOADOA GDOAA&DOAA&B$ DOADOA DODO B$"B ERR!BERR!~ P@S@PCOLUMNSP? $AM~ P?P$?DPADPAB$DPADPA GDPAA&DPAA&B$ DPADPA DPDP B$"B ERR!B~ P`s@ P FTEST#P UV?eeA6P UV?P $?DP ADP AB$DP ADP A WDP AA&DP AA&B$0DP ADP A DP DP DP -C6? B$"B ERR!B PPRICEOP=I#K ?P??BPF@P$-DPADPAB$DPADPA GDPAA&DPAA&B$ DPADPA DPDP B$"B ERR!BERR!~ QS@QOFFSET$Q?$BN~ Q?Q$?DQADQAB$DQADQA GDQAA&DQAA&B$ DQADQA DQDQ B$"B ERR!B~ Qps@Q  INTERCEPT#Q eeA7~ Q Q $?DQ ADQ AB$DQ ADQ A GDQ AA&DQ AA&B$ DQ ADQ A DQ DQ B$"B ERR!BQ PRICEDISC=Q+K#L?nB~ QQ$>pDQADQAB$DQADQA GDQAA&DQAA&B$ DQADQA DQDQ B$"B ERR!BERR!~ RT@RSEARCHR? 11BR~ R?R$?DRADRAB$DRADRA GDRAA&DRAA&B$ DRADRA DRDR B$"B ERR!B~ Rs@R PEARSON#R ?eeA8~ R ?R $?DR ADR AB$DR ADR A GDR AA&DR AA&B$ DR ADR A DR DR B$"B ERR!BRPRICEMATFR4N#MA?n?B~ RY@R$jxDRADRAB$DRADRA GDRAA&DRAA&B$ DRADRA DRDR B$"B ERR!BERR!~ ST@S TRANSPOSES?AS~ S?S$?DSADSAB$DSADSA GDSAA&DSAA&B$ DSADSA DSDS B$"B ERR!B~ Ss@ S RSQ#S ?eeA9~ S ?S $?DS ADS AB$DS ADS A GDS AA&DS AA&B$ DS ADS A DS DS B$"B ERR!BSQUOTIENT7S%qP#NDe?B~ S?S$pxDSADSAB$DSADSA GDSAA&DSAA&B$ DSADSA DSDS B$"B ERR!BERR!~ TU@ TTYPET?AV~ T?T$?DTADTAB$DTADTA GDTAA&DTAA&B$ DTADTA DTDT B$"B ERR!B~ Ts@ T STEYX#T eeA:~ T T $'DT ADT AB$DT ADT A GDT AA&DT AA&B$ DT ADT A DT DT B$"B ERR!BERR!T RANDBETWEEN7T%R#O?B~ TT$vxDTADTAB$DTADTA GDTAA&DTAA&B$ DTADTA DTDT B$"B ERR!BERR!~ U@X@ UATAN2U Aa~ UU$?DUADUAB$DUADUA GDUAA&DUAA&B$ DUADUA DUDU B$"B ERR!B~ Us@ U SLOPE#U eeA;~ U U $?DU ADU AB$DU ADU A GDU AA&DU AA&B$ DU ADU A DU DU B$"B ERR!BURECEIVEDIU7uU#P?n??B~ U?U$vDUADUAB$DUADUA GDUAA&DUAA&B$ DUADUA DUDU B$"B ERR!BERR!~ VX@ VASINVAb~ VV$?DVADVAB$DVADVA GDVAA&DVAA&B$ DVADVA DVDV B$"B ERR!B~ Vs@ V TTEST)V Cm?eeA<V Cm?V $?DV ADV AB$DV ADV A WDV AA&DV AA&B$0DV ADV A DV DV DV -C6? B$"B ERR!BV SERIESSUM=V+W#Q?B~ V?V$ToDVADVAB$DVADVA GDVAA&DVAA&B$ DVADVA DVDV B$"B ERR!BERR!~ WX@ WACOSWAc~ WW$?DWADWAB$DWADWA GDWAA&DWAA&B$ DWADWA DWDW B$"B ERR!B~ Ws@ W PROBW ? B=~ W ?W $?DW ADW AB$DW ADW A GDW AA&DW AA&B$ DW ADW A DW DW B$"B ERR!BWSQRTPI4W"QZ#R?B~ WW$xDWADWAB$DWADWA GDWAA&DWAA&B$ DWADWA DWDW B$"B ERR!BERR!~ XY@XCHOOSE(X? Bd~ X?X$?DXADXAB$DXADXA GDXAA&DXAA&B$ DXADXA DXDX B$"B ERR!B~ Xs@ X DEVSQX B>~ X X $?DX ADX AB$DX ADX A GDX AA&DX AA&B$ DX ADX A DX DX B$"B ERR!BXTBILLEQ@X2.\#S?'~(?BX`2?X$DXADXAB$DXADXA GDXAA&DXAA&B$ DXADXA DXDX B$"B ERR!BERR!~ Y@Y@YHLOOKUP#Y?%Be~ Y?Y$?DYADYAB$DYADYA GDYAA&DYAA&B$ DYADYA DYDY B$"B ERR!B~ Ys@Y GEOMEANY ?B?~ Y ?Y $?DY ADY AB$DY ADY A GDY AA&DY AA&B$ DY ADY A DY DY B$"B ERR!BY TBILLPRICE@YUUUu.=_#T6?'~(?BYUUUUUuV@Y$$DYADYAB$DYADYA GDYAA&DYAA&B$ DYADYA DYDY B$"B ERR!BERR!~ ZY@ZVLOOKUP#Z?%Bf~ Z?Z$?DZADZAB$DZADZA GDZAA&DZAA&B$ DZADZA DZDZ B$"B ERR!B~ Zt@Z HARMEANZ ?B@~ Z ?Z $?DZ ADZ AB$DZ ADZ A GDZ AA&DZ AA&B$ DZ ADZ A DZ DZ B$"B ERR!BZ TBILLYIELD@Z.a#Uo?'~(?BZ@Z$-DZADZAB$DZADZA GDZAA&DZAA&B$ DZADZA DZDZ B$"B ERR!BERR!~ [@Z@ [ISREF[$Ai[[$?D[AD[AB$D[AD[A GD[AA&D[AA&B$ D[AD[A D[D[ B$"B ERR!B~ [t@ [ SUMSQ[ ?BA~ [ ?[ $?D[ AD[ AB$D[ AD[ A GD[ AA&D[ AA&B$ D[ AD[ A D[ D[ B$"B ERR!B[WEEKNUM4["d#V?B~ [?[$DpD[AD[AB$D[AD[A GD[AA&D[AA&B$ D[AD[A D[D[ B$"B ERR!BERR!~ \@[@ \LOG\Bm~ \\$?D\AD\AB$D\AD\A GD\AA&D\AA&B$ D\AD\A D\D\ B$"B ERR!B~ \ t@ \ KURT"\ (33333BB~ \ ^\ $?D\ AD\ AB$D\ AD\ A GD\ AA&D\ AA&B$ D\ AD\ A D\ D\ B$"B ERR!B\WORKDAY7\%yf#W?B~ \?\$JpD\AD\AB$D\AD\A GD\AA&D\AA&B$ D\AD\A D\D\ B$"B ERR!BERR!~ ][@ ]CHAR]'AAoA ]A]$?D]AD]AB$D]AD]A GD]AA&D]AA&B$ D]AD]A D]D] B$"B ERR!B~ ]0t@ ] SKEW]  BC~ ] ] $?D] AD] AB$D] AD] A GD] AA&D] AA&B$ D] AD] A D] D] B$"B ERR!B ]XIRR?]-h#XSZ?%%B])>]$xD]AD]AB$D]AD]A GD]AA&D]AA&B$ D]AD]A D]D] B$"B ERR!BERR!~ ^\@ ^LOWER^'AApa ^a^$?D^AD^AB$D^AD^A GD^AA&D^AA&B$ D^AD^A D^D^ B$"B ERR!B~ ^@t@ ^ ZTEST ^ D,V?%BD^ V?^ $?D^ AD^ AB$D^ AD^ A WD^ AA&D^ AA&B$0D^ AD^ A D^ D^ D^ -C6? B$"B ERR!B ^XNPVB^0gk#Yte?%%B~ ^^$|xD^AD^AB$D^AD^A GD^AA&D^AA&B$ D^AD^A D^D^ B$"B ERR!BERR!~ _@\@ _UPPER_.'aAqA _A_$?D_AD_AB$D_AD_A GD_AA&D_AA&B$ D_AD_A D_D_ B$"B ERR!B~ _Pt@ _ LARGE_ ? AE~ _ ?_ $?D_ AD_ AB$D_ AD_ A GD_ AA&D_ AA&B$ D_ AD_ A D_ D_ B$"B ERR!B_YEARFRAC7_%m#Z?nB~ _?_$vD_AD_AB$D_AD_A GD_AA&D_AA&B$ D_AD_A D_D_ B$"B ERR!BERR!`l Da b7 c>Kd7ef