1000 Index 1001 INDEXTOLETTER 1002 Letters 1003 LETTERTOINDEX 1004 Block 1005 FIRSTBLANKPAGE 1006 Block 1007 LASTBLANKPAGE 1008 Block 1009 FINDFRONTMOSTBLANKPAGE 1010 Block 1011 FINDBACKMOSTBLANKPAGE 1012 Excluded Names 1013 PAGENAMES 1014 Notebooklink^Excluded Names 1015 PAGENAMES2 1016 Index 1017 PAGENAME 1018 Notebooklink^Index 1019 PAGENAME2 1020 Name 1021 PAGEINDEX 1022 Notebooklink^Name 1023 PAGEINDEX2 1024 Block 1025 BLOCKNAMES 1026 Notebooklink^Block 1027 BLOCKNAMES2 1028 Block 1029 BLOCKNAME 1030 Notebooklink^Block 1031 BLOCKNAME2 1033 BONUS 1034 Name 1035 ISLEGALPAGENAME 1036 Block^Groupname 1037 FIRSTINGROUP 1038 Block^Groupname 1039 LASTINGROUP 1040 Block^Pagename 1041 GETGROUP 1042 Filename 1043 DELFILE 1044 How did you find this function? 1045 SHOWQPWBITMAP 1046 String 1047 FULLP 1048 String 1049 HALFP 1050 String^String 1051 STRCMPNORM 1052 Number^Style 1053 SUUJI 1054 Kanji Number 1055 KANSUUJI 1056 Date 1057 NENGO 2000 x^n 2001 BESSELI 2002 x^n 2003 BESSELJ 2004 x^n 2005 BESSELK 2006 x^n 2007 BESSELY 2008 binary 2009 BINTONUM 2010 binary 2011 BINTOHEX 2012 binary 2013 BINTOOCT 2014 x^y 2015 COMPLEX 2016 x^from units^to units 2017 CONVERT 2018 decimal 2019 NUMTOBIN 2020 decimal 2021 NUMTOOCT 2022 x^y 2023 DELTA 2024 x^y 2025 GESTEP 2026 hex 2027 HEXTOBIN 2028 hex 2029 HEXTOOCT 2030 complex 2031 IMABS 2032 complex 2033 IMAGINARY 2034 complex 2035 IMARGUMENT 2036 complex 2037 IMCONJUGATE 2038 complex 2039 IMCOS 2040 complex1^complex2 2041 IMDIV 2042 complex 2043 IMEXP 2044 complex 2045 IMLN 2046 complex 2047 IMLOG10 2048 complex 2049 IMLOG2 2050 complex1^power 2051 IMPOWER 2052 complex1^complex2 2053 IMPRODUCT 2054 complex 2055 IMREAL 2056 complex 2057 IMSIN 2058 complex 2059 IMSQRT 2060 complex1^complex2 2061 IMSUB 2062 list 2063 IMSUM 2064 format 2065 IMFORMAT 2066 oct 2067 OCTTOBIN 2068 oct 2069 OCTTONUM 2070 oct 2071 OCTTOHEX 2072 x 2073 SQRTPI 2074 decimal number^base^precision 2075 BASE 2076 x^y 2077 CEILING 2078 x 2079 EVEN 2080 n 2081 FACTDOUBLE 2082 x^y 2083 FLOOR 2084 x^multiple 2085 MROUND 2086 list 2087 MULTINOMIAL 2088 x 2089 ODD 2090 x^y 2091 QUOTIENT 2092 n^m 2093 RANDBETWEEN 2094 x^n^m^coefficients 2095 SERIESSUM 2097 FOURIER 3000 tu^ppu^stdtbl|val^mintbl|val^maxtbl|val^md 3001 FEETBL 3002 optcode^optprem^value^date^load^cmdstring 3003 STKOPT 3004 int^ttlper^princ^res^exprinc^fper^lper^rper^opt 3005 MTGACC 3007 MTGREFI 3009 MTGAMT 3010 binary^signed 3011 BINTONUM64 3012 binary^places 3013 BINTOHEX64 3014 binary^places 3015 BINTOOCT64 3016 decimal^places 3017 NUMTOBIN64 3018 decimal^places 3019 NUMTOHEX64 3020 decimal^places 3021 NUMTOOCT64 3022 hex number^places 3023 HEXTOBIN64 3024 hex^signed 3025 HEXTONUM64 3026 hex number^places 3027 HEXTOOCT64 3028 string^places 3029 ASCTOHEX 3030 hex 3031 HEXTOASC 3032 binary value^shiftbits^bit-in^bits 3033 SHLB 3034 hex value^shiftbits^bit-in^bits 3035 SHLH 3036 binary value^shiftbits^bit-in^bits 3037 SHRB 3038 hex value^shiftbits^bit-in^bits 3039 SHRH 3040 binary #1^binary #2^bit-in^bits 3041 ADDB 3042 hex 1^hex 2^bit-in^bits 3043 ADDH 3044 binary #1^binary #2^bit-in^bits 3045 SUBB 3046 hex #1^hex #2^bit-in^bits 3047 SUBH 3048 binary number^bits 3049 SHLBO 3050 hex number^bits 3051 SHLHO 3052 binary number^bits 3053 SHRBO 3054 hex number^bits 3055 SHRHO 3056 binary #1^binary #2^bit-in^bits 3057 ADDBO 3058 hex #1^hex #2^bit-in^bits 3059 ADDHO 3060 binary #1^binary #2^bit-in^bits 3061 SUBBO 3062 hex #1^hex #2^bit-in^bits 3063 SUBHO 3064 binary number^position 3065 BITSB 3066 binary number^position 3067 BITRB 3068 binary number^position 3069 BITTB 3070 hex number^position 3071 BITSH 3072 hex number^position 3073 BITRH 3074 hex number^position 3075 BITTH 3076 binary #1^binary #2^bits 3077 ANDB 3078 binary 1^binary 2^bits 3079 ORB 3080 binary 1^binary 2^bits 3081 XORB 3082 binary number^bits 3083 INVB 3084 hex #1^hex #2^bits 3085 ANDH 3086 hex 1^hex 2^bits 3087 ORH 3088 hex 1^hex 2^bits 3089 XORH 3090 hex number^bits 3091 INVH 3092 bin1^hibt1^lobt1^bin2^hibt2^lobt2^bits 3093 CATB 3094 hex 1^hibt1^lobt1^hex 2^hibt2^lobt2^bits 3095 CATH 3096 args^bin1^...binary N, bits 3097 CATNB 3098 args^hex 1^...hex N, bits 3099 CATNH 3500 D1, ^Orig Balance 3501 E1, ^Orig Rate 3502 F1, ^Term (yrs) 3503 G1, ^1st PMT 3504 H1, ^Future Value 3505 D2, +100000 3506 E2, 12/100 3507 F2, +360/12 3508 G2, @DATE(101;1;1) 3509 H2, +0 3510 A4, ^Pmt # 3511 B4, ^ Date 3512 C4, ^Yr Rate 3513 D4, ^P&I Payment 3514 E4, ^ Principal 3515 F4, ^ Interest 3516 G4, ^Extra Prin 3517 H4, ^ New Balance 3518 I4, ^ Cum. Interest 3519 J4, ^Yearly Total Int 3520 A5, "- 3521 B5, @AMNTHS(G2;-12/12) 3522 C5, +E2 3523 A3, ':Sbuqdut0ri0]ysxqu|0\>0Bqqr 3524 D5, @ROUND(-@PAYMT(E2/12;F2*12;D2;-H2);2) 3525 E5, ^- 3526 F5, ^- 3527 G5, ^- 3528 H5, +D2 3529 I5, ^- 3530 J5, ^- 3531 A6, +1+A5 3532 B6, @AMNTHS(B5;12/12) 3533 C6, +C5 3534 D6, @MIN(D5;H5+F6) 3535 E6, +D6-F6 3536 F6, @ROUND(H5*C6/12;2) 3537 G6, @MIN(G5;H5-E6) 3538 H6, +H5-E6-G6 3539 I6, +I5+F6 3540 J6, @IF(@YEAR(B6)=@YEAR(B5);+F6+J5;F6) 3541 d2/Numeric_Format/Currency;0 3542 e2/Numeric_Format/Percent;2 3543 g2/Numeric_Format/MMM-YY;2 3544 h2/Numeric_Format/Currency;0 3545 c5..d5/Numeric_Format/Hidden;2 3546 h5/Numeric_Format/Currency;2 3547 a4..j4/Column_Width/Auto Width;1 3548 b5..b6/Numeric_Format/MMM-YY;2 3549 c6/Numeric_Format/Percent;2 3550 d6..j6/Numeric_Format/Currency;2 3551 f6/g6/h6/d15/g15/h15 3552 A1, ^Current Loan 3553 A3, 'Loan Description 3554 F3, ^Current 3555 G3, ^Current 3556 H3, ^Rem. 3557 I3, ^Future 3558 J3, ^Equivalent 3559 K3, ^Fixed mo. 3560 L3, ^Loan 3561 F4, ^Balance 3562 G4, ^Rate 3563 H4, ^Term 3564 I4, ^Value 3565 J4, ^P & I 3566 K4, ^Loan Fees 3567 L4, ^Pmt 3568 A6, 'Current Lender 3569 F6, 100000 3570 G6, 12/100 3571 H6, 30 3572 I6, 0 3573 J6, -@PAYMT(G6/12;H6*12;F6;-I6) 3574 A2, ':Sbuqdut0ri0]ysxqu|0\>0Bqqr 3575 K6, 0 3576 L6, +J6+K6 3577 A10, ^Candidate Loans 3578 A12, 'Loan Description 3579 B12, ^Current 3580 C12, ^Cash 3581 D12, ^Pct 3582 E12, ^Fixed 3583 F12, ^Loan 3584 G12, ^Rate 3585 H12, ^Term 3586 I12, ^Future 3587 J12, ^P & I 3588 K12, ^Fixed mo. 3589 L12, ^Loan 3590 M12, ^Savings 3591 Q12, ^Payback (Years) 3592 B13, ^ Balance 3593 C13, ^ Out 3594 D13, ^Fees 3595 E13, ^ Fees 3596 F13, ^ Amount 3597 H13, ^(yrs) 3598 I13, ^Value 3599 J13, ^Payment 3600 K13, ^Loan Fees 3601 L13, ^ Pmt 3602 M13, ^Gross 3603 N13, ^Term +/- 3604 O13, ^Cash I/O 3605 P13, ^ Net 3606 Q13, ^When 3607 R13, ^Loan Life 3608 S13, ^ Bal chg 3609 A15, New Lender 3610 B15, +$F$6 3611 C15, 0 3612 D15, 0 3613 E15, 0 3614 F15, +B15+C15+D15*B15+E15 3615 G15, 10/100 3616 H15, 30 3617 I15, 0 3618 J15, -@PAYMT(G15/12;H15*12;F15;-I15) 3619 K15, 0 3620 L15, +J15+K15 3621 M15, +$L$6-L15 3622 N15, @PAYMT(G15/12;$H$6*12;F15;-$I$6)-@PAYMT(G15/12;H15*12;F15;-I15) 3623 O15, @IF(C15>0;" >$"&@STRING(@PAYMT(G15/12;H15*12;-C15);0)&"<";@PAYMT($G$6/12;$H$6*12;-C15)) 3624 P15, @SUM(M15..O15) 3625 Q15, @IF(P15<=0;"Never";-(@NPER(G15/12;P15;F15-$F$6)+@NPER($G$6/12;P15;@IF(C15<0;-C15;0)))/12) 3626 R15, 5 3627 S15, +@FVAL($G$6/12;@MIN(R15;@NPER(G15/12;-(J15+M15);F15)/12;@NPER($G$6/12;-$J$6;$F$6+@IF(C15<0;C15;0))/12)*12\ 3628 ;-$J$6;$F$6+@IF(C15<0;C15;0))-@FVAL(G15/12;@MIN(R15;@NPER(G15/12;-(J15+M15);F15)/12;@NPER($G$6/12;-$J$6;$F$6+@IF(C15<0;C15;0))/12)*12;-(J15+M15);F15) 3629 A18, 'Notes: 3630 A19, '1. "Term +/-" indicates how much of the apparent (gross) savings is due to the change in the remaining 3631 A20, ' term. If the refinance lengthens the remaining term, the net savings is less than the gross savings by 3632 A21, ' the "Term +/-" amount (a negative number). 3633 A22, '2. "Cash I/O", when negative, indicates how much of the gross savings is due to closing costs paid up 3634 A23, ' front. When positive, it indicates how much the gross savings have already been reduced by cash 3635 A24, ' taken out (in this case, "Cash I/O" is enclosed by "> <" and will not affect "Net" amount). 3636 A25, '3. Enter how long the candidate loan would be kept in "Loan Life". The amount in "Bal chg" will be 3637 A26, ' the difference between the candidate and current loan balances at the end of "Loan Life", 3638 A27, ' assuming they both continued on for comparison's sake. Any cash-in is applied to both loans, 3639 A28, ' and the extra monthly principal payment (taken from the "Gross" savings column) is applied to 3640 A29, ' the candidate loan. 3641 A30, '4. Payback has occurred when "Bal chg" is zero or less (a negative amount indicates money saved). 3642 Numeric_Format/Currency;0/f6/i6..l6/b15..c15/e15..f15/i15..p15/s15 3643 Numeric_Format/Percent;2/g6/d15/g15 3644 Numeric_Format/Fixed;2/h6/h15/r15 3645 Numeric_Format/Fixed;1/q15 3646 Shading/9;0;Blend1/a1..s1/a10..s10/m12..s12 3647 Line_Drawing/Thin;Thin;Thin;Thin;Clear;Clear/a1..s1/a10..s10/m12..p12/q12..s12 3648 Font/Arial;10;No;No;No;No/a1..s12/a10..s10 3649 Font/Arial;10;Yes;No;No;No/a1..s1/a10..s10 3650 Alignment/Center across block/a1..i1/a10..i10/m12..p12/q12..s12 3651 Numeric_Format/General;0/A1 3652 AA1, ^Summary 3653 AA2, '{Application.Macro.Macro_Redraw Both} 3654 AA3, '{SelectBlock (B1;C1;E1;H1;I1;J1;K1;N1;O1);O1} 3655 AA4, '{Setproperty Reveal/Hide;"Columns;Hide"} 3656 AA5, '{Notebook.Zoom_Factor "95"} 3657 AA6, '{SelectBlock (A1);A1} 3658 AD1, ^Full_Text 3659 AD2, '{Application.Macro.Macro_Redraw Both} 3660 AD3, '{SelectBlock (A1..T1);S1} 3661 AD4, '{Setproperty Reveal/Hide;"Columns;Reveal"} 3662 AD5, '{Notebook.Zoom_Factor "100"} 3663 AD6, '{SelectBlock (A1);A1} 3664 AF1, '{floatcreate Button;A7;25;25;B9;0;0;"Full Text"} 3665 AF2, '{setproperty "Macro";"{Branch AD2}"} 3666 AF3, '{floatcreate Button;B7;400;25;D9;0;0;"Summary"} 3667 AF4, '{setproperty "Macro";"{Branch AA2}"} 3668 AF5, '{SelectBlock (A1);A1} 3669 Column_Width/Auto Width;1/a13..s13 3670 Column_Width/Set Width;1620;1/a1 3671 Numeric_Format/General;0/AF1 3672 e2/f2/d2/h2 4000 List 4001 AVEDEV 4002 Input Block^Output Block^Grouped^Labels^Alpha 4003 ANOVA1 4004 Input Block^Output Block^Sample Rows^Alpha 4005 ANOVA2 4006 Input Block^Output Block^Labels^Alpha 4007 ANOVA3 4008 Z^W 4009 BETA 4010 X^Z^W^A^B 4011 BETADIST 4012 Prob^Z^W^A^B 4013 BETAINV 4014 Z^W^X 4015 BETAI 4016 Successes^Trials^Probability^Cumulative 4017 BINOMDIST 4018 X^DegFreedom 4019 CHIDIST 4020 Prob^Degrees Freedom 4021 CHIINV 4022 Actual^Expected 4023 CHITEST 4026 Alpha^Std Dev^Size 4027 CONFIDENCE 4028 Array1^Array2 4029 CORREL 4030 Array1^Array2 4031 COVAR 4032 Trials^Probability^Alpha 4033 CRITBINOM 4034 Input Block^Output Block^Grouped^Labels^Largest^Smallest^Confidence 4035 DESCR 4036 List 4037 DEVSQ 4038 Lower Bound^Upper Bound 4039 ERF 4040 Lower Bound^Upper Bound 4041 ERFC 4043 EXPON 4044 X^Lambda^Cumulative 4045 EXPONDIST 4046 X^Degrees Freedom 1^Degrees Freedom 2 4047 FDIST 4048 Prob^Degrees Freedom 1^Degrees Freedom 2 4049 FINV 4050 X 4051 FISHER 4052 X 4053 FISHERINV 4054 X^Known Y^Known X 4055 FORECAST 4056 Data Block^Bin Block^Output Block 4057 FREQUENCY 4058 Array1^Array2 4059 FTEST 4061 FTESTV 4062 Parameter 4063 GAMMA 4064 X^Alpha^Beta^Cumulative 4065 GAMMADIST 4066 Probability^Alpha^Beta 4067 GAMMAINV 4068 Value 4069 GAMMALN 4070 Parameter^Value 4071 GAMMAP 4072 Parameter^Value 4073 GAMMAQ 4074 List 4075 GEOMEAN 4076 List 4077 HARMEAN 4079 HISTOGRAM 4080 SampSuccess^SampSize^PopSuccess^PopSize 4081 HYPGEOMDIST 4082 Known Y^Known X 4083 INTERCEPT 4084 List 4085 KURT 4086 Array^n 4087 LARGEST 4088 Probability^Mean^Std Dev 4089 LOGINV 4090 X^Mean^Std Dev 4091 LOGNORMDIST 4092 List 4093 MEAN 4094 List 4095 MEDIAN 4096 List 4097 MODE 4099 MCORREL 4101 MCOVAR 4103 MOVEAVG 4104 Failures^Successes^Probability 4105 NEGBINOMDIST 4106 X^Mean^Std Dev^Cumulative 4107 NORMDIST 4109 NORMFUN 4110 x Value 4111 NORMSDIST 4112 Probability 4113 NORMSINV 4114 Probability^Mean^Std Dev 4115 NORMINV 4116 Array1^Array2 4117 PEARSON 4118 Array^Percentile Value 4119 PERCENTILE 4120 Array^Value to Rank^Digits 4121 PERCENTRANK 4122 n^r 4123 PERMUT 4124 n Events^Mean^Cumulative 4125 POISSON 4126 XData^Probability Range^Lower Limit^Upper Limit 4127 PROB 4129 PTTESTM 4131 PTTESTV 4133 RANKPERC 4135 REGRESS 4136 Array^X 4137 QUARTILE 4139 RANDOM 4140 Number^Array^Order 4141 RANK 4142 Known X^Known Y 4143 RSQ 4145 SAMPLE 4146 List 4147 SKEW 4148 Known Y^Known X 4149 SLOPE 4150 Array^n 4151 SMALLEST 4152 Value^Mean^Std Dev 4153 STANDARDIZE 4154 Known X^Known Y 4155 STEYX 4156 List 4157 SUMSQ 4158 Array1^Array2 4159 SUMX2MY2 4160 Array1^Array2 4161 SUMX2PY2 4162 Array1^Array2 4163 SUMXMY2 4164 Array1^Array2 4165 SUMXPY2 4166 Array1^Array2 4167 SUMXY 4168 Array1^Array2 4169 SUMXY2 4170 X^DegFreedom^Tails 4171 TDIST 4175 TINVONE 4176 Array1^Array2^Tails^Type 4177 TTEST 4179 TTESTM 4180 Probability^Degrees Freedom 4181 TINV 4182 Array^Decimal Fraction 4183 TRIMMEAN 4184 x Parameter^Alpha^Beta^Cumulative 4185 WEIBULL 4186 Array^X^S 4187 ZTEST 4189 ZTESTM 4500 Analysis of Variance:One Way 4501 One Way 4502 Summary 4503 Groups 4504 Count 4505 Sum 4506 Average 4507 Variance 4508 Analysis of Variance 4509 Source of Variation 4510 SS 4511 df 4512 MS 4513 F 4514 P-value 4515 F-crit 4516 Between Groups 4517 Within Groups 4518 Group 4519 Total 4520 Anova: Two Way with Replication 4521 Font 4522 AvantGarde;10;Yes;Yes;No;No 4523 Active_Block 4524 Line_Drawing 4525 NoChange;NoChange;NoChange;Thin;NoChange;NoChange;0;0;0;3;0;0 4526 @AVG(%s) 4527 @SUM(%s) 4528 @VARS(%s) 4529 Sample 4530 Column 4531 Interaction 4532 Within 4533 Column_Width 4534 Auto Width;1500;1 4535 Anova: Two Way Without Replication 4536 Row %d 4537 Column %d 4538 Rows 4539 Columns 4540 Error 4541 @NA 4542 +%s 4543 +(1-%s)*%s+%s*%s 4544 @SQRT(@QSTAT.SUMXMY2(%s;%s)/3) 4545 @AVG(%s..%s) 4546 @SQRT(@QSTAT.SUMXMY2(%s..%s;%s..%s)/3) 4547 @qstat.correl(%s;%s) 4548 @qstat.covar(%s;%s) 4549 @var(%s) 4550 Bin 4551 Frequency 4552 Cumulative % 4553 Numeric_Format 4554 Percent;2 4555 @avg(%s) 4556 @count(%s) 4557 +@count(%s) - 1 4558 @if(C(0)R(-%d)>C(1)R(-%d);C(0)R(-%d)/C(1)R(-%d);C(1)R(-%d)/C(0)R(-%d)) 4559 +@qstat.fdist(%s;%d;%d) 4560 @qstat.finv(@if(C(0)R(-5)>C(1)R(-5);%s;2*%s);@count(%s) - 1;@count(%s) - 1) 4561 Variable %d 4562 F-Test: Two-Sample for Variances 4563 Mean 4564 Observations 4565 P(F<=f) one-tail 4566 F Critical one-tail 4567 Standard Error 4568 @stds(%s)/@sqrt(%d) 4569 Median 4570 @qstat.median(%s) 4571 Mode 4572 @qstat.mode(%s) 4573 Standard Deviation 4574 @stds(%s) 4575 @vars(%s) 4576 Kurtosis 4577 @qstat.kurt(%s) 4578 Skewness 4579 @qstat.skew(%s) 4580 Range 4581 +@qstat.largest(%s;1) - @qstat.smallest(%s;1) 4582 Minimum 4583 @min(%s) 4584 Maximum 4585 @max(%s) 4586 Smallest(%d) 4587 @qstat.smallest(%s;%d) 4588 Largest(%d) 4589 @qstat.largest(%s;%d) 4590 Confidence Level(%s) 4591 -@qstat.normsinv(%s/2)*sqrt(C(0)R(%d)/C(0)R(%d)) 4592 Font.Italic 4593 Yes 4594 @qstat.pearson(%s;%s) 4595 Pearson Correlation 4596 Pooled Variance 4597 Hypothesized Mean Difference 4598 t 4599 t Critical one-tail 4600 P(T<=t) two-tail 4601 t Critical two-tail 4602 t-Test: Paired Two-Sample for Means 4603 P(T<=t) one-tail 4604 t-Test: Two-Sample Assuming Unequal Variances 4605 Rank 4606 Point 4607 Percent 4608 t-Test Two Sample Assuming Equal Variance 4609 Graph 4610 z-Test: Two-Sample for Means 4611 Known Variance 4612 z 4613 z Critical one-tail 4614 P(Z<=z) two-tail 4615 z Critical two-tail 4616 P(Z<=z) one-tail 4617 Regression Statistics 4618 Multiple R 4619 R Square 4620 Adjusted R Square 4621 Regression 4622 Residual 4623 Sum of Squares 4624 Mean Square 4625 Significance F 4626 Intercept 4627 Coefficients 4628 t Statistic 4629 Lower %2.2f% 4630 Upper %2.2f% 4631 Predicted Y 4632 Residuals 4633 Stdzd Residuals 4634 x%d 4635 y 4636 Percentile 4637 @qstat.fdist(C(-1)R(0);C(-4)R(0);C(-4)R(1)) 4638 +C(-2)R(0)/C(-1)R(0) 4639 @qstat.tdist(C(-1)R(0);%d;2) 4640 -@qstat.tinv((1-%s);%d)*C(-3)R(0)+C(-4)R(0) 4641 @qstat.tinv((1-%s);%d)*C(-4)R(0)+C(-5)R(0) 4642 +C(-1)R(0)/%s 4643 -@qstat.normsinv(%s/2)*sqrt(@qstat.median(%s)/@min(%s)) 5000 Number^Form 5001 ROMAN 5002 Block 5003 COLUMN 5004 Block 5005 ROW 5008 List 5009 AND 5010 List 5011 OR 5012 Block 5013 PURECOUNT 5014 List 5015 XCOUNT 5016 Value 5017 ISNONTEXT 5018 Cell 5019 ISBLANK 5020 Block 5021 COUNTBLANK 5022 Value 5023 TYPE 5024 Reference^Rows^Cols^Height^Width 5025 OFFSET 5026 Strings 5027 CONCATENATE 5028 Text^OldText^NewText^UnstanceNum 5029 SUBSTITUTE 5030 Number 5031 ISEVEN 5032 Number 5033 ISODD 5034 Number 5035 SIGN 5036 Number^Power 5037 POWER 5038 List 5039 NOT 5040 Number^Digits^Direction 5041 ROUNDDOWN 5042 Number^Digits 5043 ROUNDDOWNXL 5044 Number^Digits^Direction 5045 ROUNDUP 5046 Number^Digits 5047 ROUNDUPXL 5048 FracDollar^Denom 5049 DOLLARFR 5050 DecDollar^Denom 5051 DOLLARDE 5052 Number 5053 TANH 5054 Number 5055 SINH 5056 Number 5057 COSH 5058 Number 5059 ATANH 5060 Number 5061 ASINH 5062 Number 5063 ACOSH 5064 Number 5065 ACOTH 5066 Number 5067 ACSC 5068 Number 5069 ACSCH 5070 Number 5071 ASEC 5072 Number 5073 ASECH 5074 Number 5075 COTH 5076 Number 5077 COT 5078 Number 5079 ACOT 5080 Number 5081 CSCH 5082 Number 5083 CSC 5084 Number 5085 SECH 5086 Number 5087 SEC 5088 Degrees^Minutes^Seconds^Direction 5089 LLDEC 5090 List 5091 PUREAVG 5092 Block1^Block2 5093 MMULT 5094 List 5095 PUREMIN 5096 List 5097 PUREMAX 5098 List 5099 PURESTD 5100 List 5101 PURESTDS 5102 List 5103 PUREVAR 5104 List 5105 PUREVARS 5106 DataBlock^WeightBlock^Type 5107 WEIGHTAVG 5108 Number^Root 5109 ROOTN 5110 FirstTerm^Term^Ratio 5111 GEOSUM 5112 Matrix 5113 MINVERSE 5114 Rate^Periods 5115 EFFECT 5116 StartDate^EndDate^Method ^ 5117 DAYS360 5118 StartDate^EndDate 5119 D360 5120 Cost^Salvage^Life^Period^Month 5121 DB 5122 Cost^Salvage^Life^StartPeriod^EndPeriod^Depreciation-Factor^Switch 5123 VDB 5124 Range^FinanceRate^Reinvest Rate^Type 5125 MIRR 5126 Rate^Values^Dates 5127 XNPV 5128 Values^Dates^Guess 5129 XIRR 5130 Number^Base 5131 LOGBASE 5132 Block^ColHead^RowHead^PageName 5133 XINDEX 5134 Settlement^Maturity^Coupon^Price^Redemption^Frequency^Basis 5135 YIELDPER 5136 Settlement^Maturity^Coupon^Price^Redemption^Frequency^Basis 5137 _YIELDPER 5140 Rate^Nper^Pv^StartPeriod^EndPeriod^Type 5141 CUMPRINC 5142 Rate^Nper^Pv^StartPeriod^EndPeriod^Type 5143 CUMIPMT 5144 Lookup Value^[Lookup Vector, Lookup Result] or [Array] 5145 LOOKUP 5146 Known Y's^Known X's^Const^Stats 5147 LOGEST 5148 Known Y's^Known X's^Const^Stats 5149 LINEST 5150 Known Y's^Known X's^New X's^Const 5151 TREND 5152 Known Y's^Known X's^New X's^Const 5153 GROWTH 5154 X-Range^Y-Range^Attribute^Compute 5155 REGRESSION 5156 Value 5157 ISLOGICAL 5158 Number^Decimals 5159 DOLLAR 5160 Number^Decimals 5161 TRUNC 5162 Block 5163 TRANSPOSE 5164 X^Y 5165 MODULO 5166 Text^Length^Alignment 5167 SETSTRING 5168 Date^Attribute 5169 DATEINFO 5170 Datenum^WeekBegins 5171 WEEKNUM 5172 StartDate^EndDate^Format 5173 DATEDIF 5174 StartDate^Months 5175 EOMONTH 5176 StartDate^EndDate^Holidays^WeekEnds 5177 NETWORKDAYS 5178 StartDate^Days^Holidays^WeekEnds 5179 WORKDAY 5180 Known X's^Known Y's^OuputBlock 5181 SPLINE 5182 Known X's^Known Y's^Coeff^X 5183 USESPLINE 5184 X 5185 FACTLN 5186 X 5187 GAMMA 5188 Block 5189 SEMEAN 5190 X 5191 ERFD 5192 X 5193 EXP2 5194 Number^FromBase^ToBase 5195 LOGCONV 5196 EffectRate^Nper 5197 NOMINAL 5198 Num^Dec^NoCommas 5199 FIXED 5200 Block 5201 IBlock 5202 Data^Intervals 5203 FREQDIST 5204 RowNum^ColNum^Absolute^Format^PageName 5205 ADDRESS 5206 BlockList 5207 MINLOOKUP 5208 BlockList 5209 MAXLOOKUP 5210 Version Number 5211 OWNER 5212 String^FieldNumber^Delimiter 5213 FIELD 5214 Number 5215 ISPRIME 5216 Number 5217 NEXTPRIME 5218 Block 5219 LARGESTSUM 5220 BlockList 5221 LARGESTSUMBLOCK 5222 Block^Condition 5223 COUNTIF 5224 Block^Condition^Sum Range 5225 SUMIF 5226 Contents^Block^Match Type 5227 MATCH 5228 Date^Type 5229 WEEKDAY 5230 Number^Format 5231 DOLLARTEXT 5232 X 5233 INTXL 5234 Block^Type 5235 LASTCELLVALUE 5237 ISUARUNNING 5238 Principal^Rate^Term 5239 PMTC 5240 Registry Key^Registry Value 5241 GETREGISTRYKEY 5242 V_VAL^H_VAL^Block^Type 5243 VHLOOKUP 5500 @ARRAY( 5501 @@( 5502 ) 5503 Mon 5504 Tue 5505 Wed 5506 Thu 5507 Fri 5508 Sat 5509 Sun 5510 Monday 5511 Tuesday 5512 Wednesday 5513 Thursday 5514 Friday 5515 Saturday 5516 Sunday 5517 Jan 5518 Feb 5519 Mar 5520 Apr 5521 May 5522 Jun 5523 Jul 5524 Aug 5525 Sep 5526 Oct 5527 Nov 5528 Dec 5529 January 5530 February 5531 March 5532 April 5533 May 5534 June 5535 July 5536 August 5537 September 5538 October 5539 November 5540 December 5541 NAN 5542 NA 5543 ERR 5544 One 5545 Two 5546 Three 5547 Four 5548 Five 5549 Six 5550 Seven 5551 Eight 5552 Nine 5553 Twenty 5554 Thirty 5555 Forty 5556 Fifty 5557 Sixty 5558 Seventy 5559 Eighty 5560 Ninety 5561 Ten 5562 Eleven 5563 Twelve 5564 Thirteen 5565 Fourteen 5566 Fifteen 5567 Sixteen 5568 Seventeen 5569 Eighteen 5570 Nineteen 5571 Thousand 5572 Million 5573 Billion 5574 Trillion 5575 Zero 5576 Hundred 5577 Dollars 5578 and 5579 /100 5580 /100 Dollars 5581 Dollars and 5582 Cents 5583 Cent 6000 Principle^Int^Term^N^Part^Res^ResOff^Adv^Odd^Simp 6001 AMAINT 6002 Principle^Term^Payment^Res^ResOff^Adv^Odd^Simp^Precission 6003 AMINT 6004 Principle^Int^Term^Res^ResOff^Adv^Odd^Simp 6005 AMPMT 6006 Principle^Int^Term^N^Res^ResOff^Adv^Odd^Simp 6007 AMPMTI 6008 Int^Term^Payment^Res^ResOff^Adv^Odd^Simp 6009 AMPRN 6010 Principle^Int^Term^Payment^ResOff^Adv^Odd^Simp 6011 AMRES 6012 Principle^Int^Term^N^Part^Res^ResOff^Adv^Odd^Simp 6013 AMRPRN 6014 Principle^Int^Payment^Res^ResOff^Adv^Odd^Simp 6015 AMTERM 6016 Date^Days^Holidays^Saturday^Sunday 6017 ABDAYS 6018 StartDate^End Date^Holidays^Saturday^Sunday 6019 BDAYS 6020 Date^Dir^Holidays^Saturday^Sunday 6021 BUSDAY 6022 Date^Holidays^Saturday^Sunday 6023 FBDAY 6024 StartDate^End Date^Holidays^Saturday^Sunday 6025 HOLS 6026 Date^Holidays^Saturday^Sunday 6027 ISBDAY 6028 Date^Holidays^Saturday^Sunday 6029 LBDAY 6030 Date^Holidays^Saturday^Sunday 6031 NBDAY 6032 Date^Holidays^Saturday^Sunday 6033 PBDAY 6034 Number^Denominator 6035 DFRAC 6036 Fraction^Denominator 6037 FRACD 6038 Y1^F1^F2^Q1^Q2 6039 YLD2YLD 6040 Date^Number Days^Calendar^Ends/Months 6041 ACDAYS 6042 Date^Months^Ends/Months 6043 AMNTHS 6044 StartDate^End Date^Calendar^February 6045 CDAYS 6046 Date 6047 EMNTH 6048 Weekday^Month^Year^AuxWday 6049 LWKDAY 6050 Month^Year 6051 MDAYS 6052 StartDate^End Date^Ends/Months 6053 MNTHS 6054 N^Weekday^Month^Year^AuxWday 6055 NWKDAY 6056 Date 6057 WKDAY 6058 Year 6059 YDAYS 6060 Date^Number Divisions^Months^Anchor Date^Ends/Months 6061 YDIV 6062 StartDate^End Date^Calendar 6063 YEARFRAC 6064 N^R 6065 COMB 6066 N 6067 FACT 6068 N 6069 FIB 6070 X^Y 6071 GCD 6072 X^Y 6073 LCM 6074 Know X^Know Y^X 6075 LINTERP 6076 Array 6077 MDET 6078 List 6079 MULT 6080 Known Y^Known X 6081 STEC 6082 Discount Rate^Flows^Initial^Odd/Per^Simp^Path-Dep^filter^Start^Dnd 6083 DURAT 6084 Interest Rate^Flows^Odd/Per^Simp^Path-Dep^filter^Start^Dnd 6085 FUTV 6086 Discount Rate^Flows^Initial^Odd/Per^Simp^Path-Dep^filter^Start^End 6087 NETPV 6088 NPV^Flows^Initial^Odd/Per^Simp^Path-Dep^Guess^Precission^Max-Iter^Filter^Start^End 6089 PIRATE 6090 NPV^Discount Rate^Flows^Initial^Odd/Per^Simp^Path-Dep^Guess^Precission^Max-Iter^Filter^Start^End 6091 SCMARG 6092 Settle^Maturity^Price^Redemption^Calendar 6093 DISC 6094 Settle^Maturity^Discount^Redemption^Calendar 6095 PRICEDISC 6096 Settle^Maturity^Discount 6097 TBILLEQ 6098 Settle^Maturity^Discount 6099 TBILLPRICE 6100 Settle^Maturity^Price 6101 TBILLYIELD 6102 Settle^Maturity^Price^Redemption^Calendar 6103 YIELDDISC 6104 Settle^Maturity^Invest^Redemption^Calendar 6105 INTRATE 6106 Settle^Maturity^Investment^Discount^Calendar 6107 RECEIVED 6108 Settle^Maturity^Coupon^Issue^FirstCpn^Par^Frequency^Calendar 6109 ACCRINT 6110 Issue^FirstInt^Settle^Coupon^Par^Frequency^Calendar 6111 ACCRINTXL 6112 Settle^Issue^FirstInt^Coupon^Par^Frequency^Calendar 6113 ACCRUED 6114 Settle^Maturity^Frequency^Calendar 6115 COUPDAYBS 6116 Settle^Maturity^Frequency^Calendar 6117 COUPDAYS 6118 Settle^Maturity^Frequency^Calendar 6119 COUPDAYSNC 6120 Settle^Maturity^Frequency^Calendar 6121 COUPNCD 6122 Settle^Maturity^Frequency^Calendar 6123 COUPNUM 6124 Settle^Maturity^Frequency^Calendar 6125 COUPPCD 6126 Settle^Maturity^Coupon^Yield^Frequency^Calendar 6127 DURATION 6128 Settle^Maturity^Coupon^Yield^Frequency^Calendar 6129 MDURATION 6130 Settle^Maturity^Issue^FirstCpn^Coupon^Yield^Redemption^Frequency^Calendar 6131 ODDFPRICE 6132 Settle^Maturity^Issue^FirstCpn^Coupon^Price^Redemption^Frequency^Calendar 6133 ODDFYIELD 6134 Settle^Maturity^LastCpn^Coupon^Yield^Redemption^Frequency^Calendar 6135 ODDLPRICE 6136 Settle^Maturity^LastCpn^Coupon^Price^Redemption^Frequency^Calendar 6137 ODDLYIELD 6138 Settle^Maturity^Coupon^Yield^Redemption^Frequency^Calendar 6139 PRICE 6140 Settle^Maturity^Issue^Coupon^Price^Calendar 6141 YIELD 6144 Issue^Settle^Coupon^Par^Calendar 6145 ACCRINTM 6146 Settle^Maturity^Issue^Coupon^Yield^Calendar 6147 PRICEMAT 6148 Settle^Maturity^Issue^Coupon^Price^Calendar 6149 YIELDMAT 6172 Value^Denominator^ForceDenom 6173 FRACTION