home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip: 25 Years Anniversary
/
CHIP_25Jahre_Jubilaeum.iso
/
downloads
/
401065
/
WPO11
/
Data1.cab
/
qpadden.dll
/
string.txt
Wrap
Text File
|
2003-03-07
|
26KB
|
1,213 lines
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