home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-05-28 | 13.1 KB |
view JSON data
|
view as text
|
open on a Mac
|
open on a PC
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0c 00 02 00 00 01 01 00 | 01 00 0c 00 30 03 00 00 |........|....0...|
|00000010| 82 03 00 00 98 03 00 00 | d0 03 00 00 25 04 00 00 |........|....%...|
|00000020| 52 04 00 00 ba 04 00 00 | fe 04 00 00 3a 05 00 00 |R.......|....:...|
|00000030| 71 05 00 00 b1 05 00 00 | fe 05 00 00 15 06 00 00 |q.......|........|
|00000040| 40 06 00 00 82 06 00 00 | b2 06 00 00 d7 06 00 00 |@.......|........|
|00000050| 0f 07 00 00 46 07 00 00 | 67 07 00 00 9b 07 00 00 |....F...|g.......|
|00000060| ca 07 00 00 f6 07 00 00 | 2d 08 00 00 4a 08 00 00 |........|-...J...|
|00000070| 74 08 00 00 ae 08 00 00 | 14 09 00 00 71 09 00 00 |t.......|....q...|
|00000080| c8 09 00 00 11 0a 00 00 | 2a 0a 00 00 61 0a 00 00 |........|*...a...|
|00000090| 88 0a 00 00 cb 0a 00 00 | 13 0b 00 00 59 0b 00 00 |........|....Y...|
|000000a0| 8b 0b 00 00 a7 0b 00 00 | 06 0c 00 00 29 0c 00 00 |........|....)...|
|000000b0| 57 0c 00 00 80 0c 00 00 | c7 0c 00 00 ed 0c 00 00 |W.......|........|
|000000c0| 7d 0d 00 00 9b 0d 00 00 | ce 0d 00 00 ef 0d 00 00 |}.......|........|
|000000d0| 1b 0e 00 00 4d 0e 00 00 | 7e 0e 00 00 a7 0e 00 00 |....M...|~.......|
|000000e0| d1 0e 00 00 f5 0e 00 00 | 37 0f 00 00 75 0f 00 00 |........|7...u...|
|000000f0| db 0f 00 00 3d 10 00 00 | 7a 10 00 00 b0 10 00 00 |....=...|z.......|
|00000100| d1 10 00 00 1c 11 00 00 | 33 11 00 00 66 11 00 00 |........|3...f...|
|00000110| 99 11 00 00 f5 11 00 00 | 2c 12 00 00 9a 12 00 00 |........|,.......|
|00000120| da 12 00 00 fe 12 00 00 | 2d 13 00 00 56 13 00 00 |........|-...V...|
|00000130| 91 13 00 00 d6 13 00 00 | 1c 14 00 00 6e 14 00 00 |........|....n...|
|00000140| aa 14 00 00 ce 14 00 00 | 09 15 00 00 4d 15 00 00 |........|....M...|
|00000150| 7c 15 00 00 ba 15 00 00 | f2 15 00 00 26 16 00 00 ||.......|....&...|
|00000160| 82 16 00 00 da 16 00 00 | 2e 17 00 00 63 17 00 00 |........|....c...|
|00000170| 91 17 00 00 c8 17 00 00 | 03 18 00 00 34 18 00 00 |........|....4...|
|00000180| 69 18 00 00 c2 18 00 00 | 0e 19 00 00 34 19 00 00 |i.......|....4...|
|00000190| 6c 19 00 00 a6 19 00 00 | 09 1a 00 00 63 1a 00 00 |l.......|....c...|
|000001a0| 92 1a 00 00 ec 1a 00 00 | 51 1b 00 00 9d 1b 00 00 |........|Q.......|
|000001b0| dd 1b 00 00 30 1c 00 00 | a2 1c 00 00 f2 1c 00 00 |....0...|........|
|000001c0| 65 1d 00 00 c1 1d 00 00 | 15 1e 00 00 16 1e 00 00 |e.......|........|
|000001d0| 17 1e 00 00 18 1e 00 00 | 7a 1e 00 00 d4 1e 00 00 |........|z.......|
|000001e0| 1e 1f 00 00 61 1f 00 00 | 93 1f 00 00 ab 1f 00 00 |....a...|........|
|000001f0| 0c 20 00 00 44 20 00 00 | 8a 20 00 00 a4 20 00 00 |. ..D ..|. ... ..|
|00000200| f1 20 00 00 14 21 00 00 | 38 21 00 00 80 21 00 00 |. ...!..|8!...!..|
|00000210| d1 21 00 00 f3 21 00 00 | 44 22 00 00 8f 22 00 00 |.!...!..|D"..."..|
|00000220| d9 22 00 00 22 23 00 00 | 96 23 00 00 0a 24 00 00 |.".."#..|.#...$..|
|00000230| 7d 24 00 00 ba 24 00 00 | 00 25 00 00 36 25 00 00 |}$...$..|.%..6%..|
|00000240| 60 25 00 00 9d 25 00 00 | d9 25 00 00 12 26 00 00 |`%...%..|.%...&..|
|00000250| 37 26 00 00 60 26 00 00 | 83 26 00 00 b1 26 00 00 |7&..`&..|.&...&..|
|00000260| e4 26 00 00 12 27 00 00 | 45 27 00 00 79 27 00 00 |.&...'..|E'..y'..|
|00000270| ab 27 00 00 cf 27 00 00 | f4 27 00 00 1d 28 00 00 |.'...'..|.'...(..|
|00000280| 43 28 00 00 bc 28 00 00 | 1d 29 00 00 85 29 00 00 |C(...(..|.)...)..|
|00000290| d5 29 00 00 0f 2a 00 00 | 38 2a 00 00 6d 2a 00 00 |.)...*..|8*..m*..|
|000002a0| 93 2a 00 00 bf 2a 00 00 | 0e 2b 00 00 45 2b 00 00 |.*...*..|.+..E+..|
|000002b0| 86 2b 00 00 ff 2b 00 00 | 5e 2c 00 00 e0 2c 00 00 |.+...+..|^,...,..|
|000002c0| 51 2d 00 00 93 2d 00 00 | b8 2d 00 00 13 2e 00 00 |Q-...-..|.-......|
|000002d0| 66 2e 00 00 b3 2e 00 00 | eb 2e 00 00 40 2f 00 00 |f.......|....@/..|
|000002e0| 7d 2f 00 00 a7 2f 00 00 | e0 2f 00 00 1f 30 00 00 |}/.../..|./...0..|
|000002f0| 72 30 00 00 b9 30 00 00 | f3 30 00 00 31 31 00 00 |r0...0..|.0..11..|
|00000300| 5b 31 00 00 a6 31 00 00 | f6 31 00 00 40 32 00 00 |[1...1..|.1..@2..|
|00000310| 6a 32 00 00 94 32 00 00 | f6 32 00 00 34 33 00 00 |j2...2..|.2..43..|
|00000320| 88 33 00 00 bf 33 00 00 | e8 33 00 00 12 34 00 00 |.3...3..|.3...4..|
|00000330| 52 65 74 75 72 6e 73 20 | 74 68 65 20 76 61 6c 75 |Returns |the valu|
|00000340| 65 20 69 6e 20 74 68 65 | 20 66 69 72 73 74 20 63 |e in the| first c|
|00000350| 65 6c 6c 20 69 6e 20 61 | 20 72 61 6e 67 65 20 6f |ell in a| range o|
|00000360| 72 20 30 20 69 66 20 74 | 68 65 20 63 65 6c 6c 20 |r 0 if t|he cell |
|00000370| 63 6f 6e 74 61 69 6e 73 | 20 61 20 6c 61 62 65 6c |contains| a label|
|00000380| 2e 00 52 65 74 75 72 6e | 73 20 74 68 65 20 76 61 |..Return|s the va|
|00000390| 6c 75 65 20 4e 41 2e 00 | 43 61 6c 63 75 6c 61 74 |lue NA..|Calculat|
|000003a0| 65 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |es the n|umber of|
|000003b0| 20 64 61 79 73 20 62 65 | 74 77 65 65 6e 20 74 77 | days be|tween tw|
|000003c0| 6f 20 64 61 74 65 20 6e | 75 6d 62 65 72 73 2e 00 |o date n|umbers..|
|000003d0| 43 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 64 |Calculat|es the d|
|000003e0| 61 74 65 20 74 68 65 20 | 73 70 65 63 69 66 69 65 |ate the |specifie|
|000003f0| 64 20 6e 75 6d 62 65 72 | 20 6f 66 20 6d 6f 6e 74 |d number| of mont|
|00000400| 68 73 20 62 65 66 6f 72 | 65 20 6f 72 20 61 66 74 |hs befor|e or aft|
|00000410| 65 72 20 61 20 73 70 65 | 63 69 66 69 65 64 20 64 |er a spe|cified d|
|00000420| 61 74 65 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |ate..Cal|culates |
|00000430| 74 68 65 20 6e 6f 72 6d | 61 6c 20 64 69 73 74 72 |the norm|al distr|
|00000440| 69 62 75 74 69 6f 6e 20 | 66 75 6e 63 74 69 6f 6e |ibution |function|
|00000450| 2e 00 52 65 74 75 72 6e | 73 20 74 68 65 20 64 61 |..Return|s the da|
|00000460| 74 65 2d 61 6e 64 2d 74 | 69 6d 65 20 6e 75 6d 62 |te-and-t|ime numb|
|00000470| 65 72 20 74 68 61 74 20 | 63 6f 72 72 65 73 70 6f |er that |correspo|
|00000480| 6e 64 73 20 74 6f 20 74 | 68 65 20 63 75 72 72 65 |nds to t|he curre|
|00000490| 6e 74 20 64 61 74 65 20 | 61 6e 64 20 74 69 6d 65 |nt date |and time|
|000004a0| 20 6f 6e 20 74 68 65 20 | 63 6f 6d 70 75 74 65 72 | on the |computer|
|000004b0| 27 73 20 63 6c 6f 63 6b | 2e 00 43 61 6c 63 75 6c |'s clock|..Calcul|
|000004c0| 61 74 65 73 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |ates the| number |
|000004d0| 6f 66 20 63 6f 6d 70 6f | 75 6e 64 69 6e 67 20 70 |of compo|unding p|
|000004e0| 61 79 6d 65 6e 74 20 70 | 65 72 69 6f 64 73 20 69 |ayment p|eriods i|
|000004f0| 6e 20 61 6e 20 61 6e 6e | 75 69 74 79 2e 00 43 61 |n an ann|uity..Ca|
|00000500| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 6e 65 74 |lculates| the net|
|00000510| 20 70 72 65 73 65 6e 74 | 20 76 61 6c 75 65 20 6f | present| value o|
|00000520| 66 20 61 20 73 65 72 69 | 65 73 20 6f 66 20 63 61 |f a seri|es of ca|
|00000530| 73 68 20 66 6c 6f 77 73 | 2e 00 52 6f 75 6e 64 73 |sh flows|..Rounds|
|00000540| 20 61 20 76 61 6c 75 65 | 20 61 77 61 79 20 66 72 | a value| away fr|
|00000550| 6f 6d 20 30 20 74 6f 20 | 74 68 65 20 6e 65 61 72 |om 0 to |the near|
|00000560| 65 73 74 20 6f 64 64 20 | 69 6e 74 65 67 65 72 2e |est odd |integer.|
|00000570| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|00000580| 78 74 68 20 73 61 6d 70 | 6c 65 20 70 65 72 63 65 |xth samp|le perce|
|00000590| 6e 74 69 6c 65 20 61 6d | 6f 6e 67 20 74 68 65 20 |ntile am|ong the |
|000005a0| 76 61 6c 75 65 73 20 69 | 6e 20 72 61 6e 67 65 2e |values i|n range.|
|000005b0| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|000005c0| 6e 75 6d 62 65 72 20 6f | 66 20 6f 72 64 65 72 65 |number o|f ordere|
|000005d0| 64 20 73 65 71 75 65 6e | 63 65 73 20 6f 66 20 72 |d sequen|ces of r|
|000005e0| 20 74 68 61 74 20 63 61 | 6e 20 62 65 20 73 65 6c | that ca|n be sel|
|000005f0| 65 63 74 65 64 20 66 72 | 6f 6d 20 6e 2e 00 50 72 |ected fr|om n..Pr|
|00000600| 6f 64 75 63 65 73 20 74 | 68 65 20 76 61 6c 75 65 |oduces t|he value|
|00000610| 20 70 69 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 | pi..Cal|culates |
|00000620| 74 68 65 20 70 65 72 69 | 6f 64 69 63 20 70 61 79 |the peri|odic pay|
|00000630| 6d 65 6e 74 20 6f 6e 20 | 61 20 6c 6f 61 6e 2e 00 |ment on |a loan..|
|00000640| 53 70 65 63 69 61 6c 20 | 66 6f 72 6d 20 6f 66 20 |Special |form of |
|00000650| 40 50 4d 54 20 74 68 61 | 74 20 73 75 70 70 6f 72 |@PMT tha|t suppor|
|00000660| 74 73 20 43 61 6e 61 64 | 69 61 6e 20 6d 6f 72 74 |ts Canad|ian mort|
|00000670| 67 61 67 65 20 63 6f 6e | 76 65 6e 74 69 6f 6e 73 |gage con|ventions|
|00000680| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|00000690| 20 70 65 72 69 6f 64 69 | 63 20 70 61 79 6d 65 6e | periodi|c paymen|
|000006a0| 74 20 66 6f 72 20 61 6e | 20 61 6e 6e 75 69 74 79 |t for an| annuity|
|000006b0| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|000006c0| 20 50 6f 69 73 73 6f 6e | 20 64 69 73 74 72 69 62 | Poisson| distrib|
|000006d0| 75 74 69 6f 6e 2e 00 43 | 61 6c 63 75 6c 61 74 65 |ution..C|alculate|
|000006e0| 73 20 74 68 65 20 70 72 | 69 6e 63 69 70 61 6c 20 |s the pr|incipal |
|000006f0| 70 6f 72 74 69 6f 6e 20 | 6f 66 20 61 20 70 65 72 |portion |of a per|
|00000700| 69 6f 64 69 63 20 70 61 | 79 6d 65 6e 74 2e 00 46 |iodic pa|yment..F|
|00000710| 69 6e 64 73 20 74 68 65 | 20 70 65 72 63 65 6e 74 |inds the| percent|
|00000720| 69 6c 65 20 6f 66 20 78 | 20 61 6d 6f 6e 67 20 74 |ile of x| among t|
|00000730| 68 65 20 76 61 6c 75 65 | 73 20 69 6e 20 61 20 72 |he value|s in a r|
|00000740| 61 6e 67 65 2e 00 4d 75 | 6c 74 69 70 6c 69 65 73 |ange..Mu|ltiplies|
|00000750| 20 74 68 65 20 76 61 6c | 75 65 73 20 69 6e 20 61 | the val|ues in a|
|00000760| 20 6c 69 73 74 2e 00 41 | 70 70 6c 69 65 73 20 70 | list..A|pplies p|
|00000770| 72 6f 70 65 72 2d 63 61 | 70 69 74 61 6c 69 7a 61 |roper-ca|pitaliza|
|00000780| 74 69 6f 6e 20 74 6f 20 | 65 61 63 68 20 77 6f 72 |tion to |each wor|
|00000790| 64 20 69 6e 20 74 65 78 | 74 2e 00 43 61 6c 63 75 |d in tex|t..Calcu|
|000007a0| 6c 61 74 65 73 20 74 68 | 65 20 70 72 65 73 65 6e |lates th|e presen|
|000007b0| 74 20 76 61 6c 75 65 20 | 6f 66 20 61 6e 20 69 6e |t value |of an in|
|000007c0| 76 65 73 74 6d 65 6e 74 | 2e 00 43 61 6c 63 75 6c |vestment|..Calcul|
|000007d0| 61 74 65 73 20 74 68 65 | 20 70 72 65 73 65 6e 74 |ates the| present|
|000007e0| 20 76 61 6c 75 65 20 6f | 66 20 61 6e 20 61 6e 6e | value o|f an ann|
|000007f0| 75 69 74 79 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |uity..Ca|lculates|
|00000800| 20 74 68 65 20 72 65 73 | 75 6c 74 20 6f 66 20 78 | the res|ult of x|
|00000810| 2f 79 2c 20 74 72 75 6e | 63 61 74 65 64 20 74 6f |/y, trun|cated to|
|00000820| 20 61 6e 20 69 6e 74 65 | 67 65 72 2e 00 43 6f 6e | an inte|ger..Con|
|00000830| 76 65 72 74 73 20 72 61 | 64 69 61 6e 73 20 74 6f |verts ra|dians to|
|00000840| 20 64 65 67 72 65 65 73 | 2e 00 47 65 6e 65 72 61 | degrees|..Genera|
|00000850| 74 65 73 20 61 20 72 61 | 6e 64 6f 6d 20 76 61 6c |tes a ra|ndom val|
|00000860| 75 65 20 62 65 74 77 65 | 65 6e 20 30 20 61 6e 64 |ue betwe|en 0 and|
|00000870| 20 31 2e 00 52 65 74 75 | 72 6e 73 20 74 68 65 20 | 1..Retu|rns the |
|00000880| 6e 61 6d 65 20 6f 66 20 | 74 68 65 20 72 61 6e 67 |name of |the rang|
|00000890| 65 20 69 6e 20 77 68 69 | 63 68 20 61 20 63 65 6c |e in whi|ch a cel|
|000008a0| 6c 20 69 73 20 6c 6f 63 | 61 74 65 64 2e 00 43 61 |l is loc|ated..Ca|
|000008b0| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 72 65 6c |lculates| the rel|
|000008c0| 61 74 69 76 65 20 73 69 | 7a 65 20 6f 72 20 70 6f |ative si|ze or po|
|000008d0| 73 69 74 69 6f 6e 20 6f | 66 20 61 20 76 61 6c 75 |sition o|f a valu|
|000008e0| 65 20 69 6e 20 61 20 72 | 61 6e 67 65 20 72 65 6c |e in a r|ange rel|
|000008f0| 61 74 69 76 65 20 74 6f | 20 6f 74 68 65 72 20 76 |ative to| other v|
|00000900| 61 6c 75 65 73 20 69 6e | 20 74 68 65 20 72 61 6e |alues in| the ran|
|00000910| 67 65 2e 00 43 61 6c 63 | 75 6c 61 74 65 73 20 74 |ge..Calc|ulates t|
|00000920| 68 65 20 70 65 72 69 6f | 64 69 63 20 69 6e 74 65 |he perio|dic inte|
|00000930| 72 65 73 74 20 72 61 74 | 65 20 6e 65 63 65 73 73 |rest rat|e necess|
|00000940| 61 72 79 20 66 6f 72 20 | 61 6e 20 69 6e 76 65 73 |ary for |an inves|
|00000950| 74 6d 65 6e 74 20 74 6f | 20 67 72 6f 77 20 74 6f |tment to| grow to|
|00000960| 20 61 20 66 75 74 75 72 | 65 20 76 61 6c 75 65 2e | a futur|e value.|
|00000970| 00 43 6f 6e 76 65 72 74 | 73 20 74 68 65 20 31 2d |.Convert|s the 1-|
|00000980| 32 2d 33 20 63 6f 6c 75 | 6d 6e 20 6f 72 20 73 68 |2-3 colu|mn or sh|
|00000990| 65 65 74 20 6c 65 74 74 | 65 72 73 20 41 20 74 68 |eet lett|ers A th|
|000009a0| 72 6f 75 67 68 20 49 56 | 20 74 6f 20 6e 75 6d 62 |rough IV| to numb|
|000009b0| 65 72 73 20 66 72 6f 6d | 20 31 20 74 68 72 6f 75 |ers from| 1 throu|
|000009c0| 67 68 20 32 35 36 2e 00 | 50 65 72 66 6f 72 6d 73 |gh 256..|Performs|
|000009d0| 20 6d 75 6c 74 69 70 6c | 65 20 6c 69 6e 65 61 72 | multipl|e linear|
|000009e0| 20 72 65 67 72 65 73 73 | 69 6f 6e 20 61 6e 64 20 | regress|ion and |
|000009f0| 72 65 74 75 72 6e 73 20 | 74 68 65 20 73 70 65 63 |returns |the spec|
|00000a00| 69 66 69 65 64 20 73 74 | 61 74 69 73 74 69 63 2e |ified st|atistic.|
|00000a10| 00 44 75 70 6c 69 63 61 | 74 65 73 20 74 65 78 74 |.Duplica|tes text|
|00000a20| 20 6e 20 74 69 6d 65 73 | 2e 00 52 65 70 6c 61 63 | n times|..Replac|
|00000a30| 65 73 20 63 68 61 72 61 | 63 74 65 72 73 20 69 6e |es chara|cters in|
|00000a40| 20 74 65 78 74 20 77 69 | 74 68 20 64 69 66 66 65 | text wi|th diffe|
|00000a50| 72 65 6e 74 20 63 68 61 | 72 61 63 74 65 72 73 2e |rent cha|racters.|
|00000a60| 00 52 65 74 75 72 6e 73 | 20 74 68 65 20 6c 61 73 |.Returns| the las|
|00000a70| 74 20 6e 20 63 68 61 72 | 61 63 74 65 72 73 20 69 |t n char|acters i|
|00000a80| 6e 20 74 65 78 74 2e 00 | 52 6f 75 6e 64 73 20 61 |n text..|Rounds a|
|00000a90| 20 76 61 6c 75 65 20 74 | 6f 20 74 68 65 20 6e 65 | value t|o the ne|
|00000aa0| 61 72 65 73 74 20 6d 75 | 6c 74 69 70 6c 65 20 6f |arest mu|ltiple o|
|00000ab0| 66 20 61 20 73 70 65 63 | 69 66 69 65 64 20 70 6f |f a spec|ified po|
|00000ac0| 77 65 72 20 6f 66 20 31 | 30 2e 00 52 6f 75 6e 64 |wer of 1|0..Round|
|00000ad0| 73 20 61 20 76 61 6c 75 | 65 20 64 6f 77 6e 20 74 |s a valu|e down t|
|00000ae0| 6f 20 74 68 65 20 6e 65 | 61 72 65 73 74 20 6d 75 |o the ne|arest mu|
|00000af0| 6c 74 69 70 6c 65 20 6f | 66 20 61 20 73 70 65 63 |ltiple o|f a spec|
|00000b00| 69 66 69 65 64 20 70 6f | 77 65 72 20 6f 66 20 31 |ified po|wer of 1|
|00000b10| 30 2e 00 52 6f 75 6e 64 | 73 20 61 20 76 61 6c 75 |0..Round|s a valu|
|00000b20| 65 20 75 70 20 74 6f 20 | 74 68 65 20 6e 65 61 72 |e up to |the near|
|00000b30| 65 73 74 20 6d 75 6c 74 | 69 70 6c 65 20 6f 66 20 |est mult|iple of |
|00000b40| 61 20 73 70 65 63 69 66 | 69 65 64 20 70 6f 77 65 |a specif|ied powe|
|00000b50| 72 20 6f 66 20 31 30 2e | 00 52 6f 75 6e 64 73 20 |r of 10.|.Rounds |
|00000b60| 61 20 76 61 6c 75 65 20 | 74 6f 20 74 68 65 20 6e |a value |to the n|
|00000b70| 65 61 72 65 73 74 20 73 | 70 65 63 69 66 69 65 64 |earest s|pecified|
|00000b80| 20 6d 75 6c 74 69 70 6c | 65 2e 00 43 6f 75 6e 74 | multipl|e..Count|
|00000b90| 73 20 74 68 65 20 72 6f | 77 73 20 69 6e 20 61 20 |s the ro|ws in a |
|00000ba0| 72 61 6e 67 65 2e 00 52 | 65 74 75 72 6e 73 20 74 |range..R|eturns t|
|00000bb0| 68 65 20 6c 61 62 65 6c | 20 69 6e 20 74 68 65 20 |he label| in the |
|00000bc0| 66 69 72 73 74 20 63 65 | 6c 6c 20 69 6e 20 61 20 |first ce|ll in a |
|00000bd0| 72 61 6e 67 65 20 6f 72 | 20 61 20 62 6c 61 6e 6b |range or| a blank|
|00000be0| 20 73 74 72 69 6e 67 20 | 69 66 20 74 68 65 20 63 | string |if the c|
|00000bf0| 65 6c 6c 20 63 6f 6e 74 | 61 69 6e 73 20 61 20 76 |ell cont|ains a v|
|00000c00| 61 6c 75 65 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |alue..Ca|lculates|
|00000c10| 20 74 68 65 20 73 65 63 | 61 6e 74 20 6f 66 20 61 | the sec|ant of a|
|00000c20| 6e 20 61 6e 67 6c 65 2e | 00 43 61 6c 63 75 6c 61 |n angle.|.Calcula|
|00000c30| 74 65 73 20 74 68 65 20 | 68 79 70 65 72 62 6f 6c |tes the |hyperbol|
|00000c40| 69 63 20 73 65 63 61 6e | 74 20 6f 66 20 61 6e 20 |ic secan|t of an |
|00000c50| 61 6e 67 6c 65 2e 00 45 | 78 74 72 61 63 74 73 20 |angle..E|xtracts |
|00000c60| 74 68 65 20 73 65 63 6f | 6e 64 73 20 66 72 6f 6d |the seco|nds from|
|00000c70| 20 61 20 74 69 6d 65 20 | 6e 75 6d 62 65 72 2e 00 | a time |number..|
|00000c80| 43 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 73 |Calculat|es the s|
|00000c90| 74 61 6e 64 61 72 64 20 | 65 72 72 6f 72 20 6f 66 |tandard |error of|
|00000ca0| 20 74 68 65 20 73 61 6d | 70 6c 65 20 6d 65 61 6e | the sam|ple mean|
|00000cb0| 20 66 6f 72 20 61 20 6c | 69 73 74 20 6f 66 20 76 | for a l|ist of v|
|00000cc0| 61 6c 75 65 73 2e 00 43 | 61 6c 63 75 6c 61 74 65 |alues..C|alculate|
|00000cd0| 73 20 74 68 65 20 73 75 | 6d 20 6f 66 20 61 20 70 |s the su|m of a p|
|00000ce0| 6f 77 65 72 20 73 65 72 | 69 65 73 2e 00 52 65 74 |ower ser|ies..Ret|
|00000cf0| 75 72 6e 73 20 61 20 6c | 61 62 65 6c 20 74 68 61 |urns a l|abel tha|
|00000d00| 74 20 69 73 20 6c 65 6e | 67 74 68 20 63 68 61 72 |t is len|gth char|
|00000d10| 61 63 74 65 72 73 20 6c | 6f 6e 67 2e 20 54 68 65 |acters l|ong. The|
|00000d20| 20 6c 61 62 65 6c 20 63 | 6f 6e 73 69 73 74 73 20 | label c|onsists |
|00000d30| 6f 66 20 74 65 78 74 20 | 61 6e 64 20 73 75 66 66 |of text |and suff|
|00000d40| 69 63 69 65 6e 74 20 62 | 6c 61 6e 6b 20 73 70 61 |icient b|lank spa|
|00000d50| 63 65 73 20 74 6f 20 61 | 6c 69 67 6e 20 74 65 78 |ces to a|lign tex|
|00000d60| 74 20 61 73 20 73 70 65 | 63 69 66 69 65 64 20 62 |t as spe|cified b|
|00000d70| 79 20 61 6c 69 67 6e 6d | 65 6e 74 2e 00 43 6f 75 |y alignm|ent..Cou|
|00000d80| 6e 74 73 20 74 68 65 20 | 73 68 65 65 74 73 20 69 |nts the |sheets i|
|00000d90| 6e 20 61 20 72 61 6e 67 | 65 2e 00 44 65 74 65 72 |n a rang|e..Deter|
|00000da0| 6d 69 6e 65 73 20 69 66 | 20 61 20 76 61 6c 75 65 |mines if| a value|
|00000db0| 20 69 73 20 6e 65 67 61 | 74 69 76 65 2c 20 70 6f | is nega|tive, po|
|00000dc0| 73 69 74 69 76 65 2c 20 | 6f 72 20 30 2e 00 43 61 |sitive, |or 0..Ca|
|00000dd0| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 73 69 6e |lculates| the sin|
|00000de0| 65 20 6f 66 20 61 6e 20 | 61 6e 67 6c 65 2e 00 43 |e of an |angle..C|
|00000df0| 61 6c 63 75 6c 61 74 65 | 73 20 74 68 65 20 68 79 |alculate|s the hy|
|00000e00| 70 65 72 62 6f 6c 69 63 | 20 73 69 6e 65 20 6f 66 |perbolic| sine of|
|00000e10| 20 61 6e 20 61 6e 67 6c | 65 2e 00 43 61 6c 63 75 | an angl|e..Calcu|
|00000e20| 6c 61 74 65 73 20 74 68 | 65 20 73 6b 65 77 6e 65 |lates th|e skewne|
|00000e30| 73 73 20 6f 66 20 74 68 | 65 20 76 61 6c 75 65 73 |ss of th|e values|
|00000e40| 20 69 6e 20 61 20 72 61 | 6e 67 65 2e 00 43 61 6c | in a ra|nge..Cal|
|00000e50| 63 75 6c 61 74 65 73 20 | 73 74 72 61 69 67 68 74 |culates |straight|
|00000e60| 2d 6c 69 6e 65 20 64 65 | 70 72 65 63 69 61 74 69 |-line de|preciati|
|00000e70| 6f 6e 20 61 6c 6c 6f 77 | 61 6e 63 65 2e 00 46 69 |on allow|ance..Fi|
|00000e80| 6e 64 73 20 74 68 65 20 | 6e 74 68 20 73 6d 61 6c |nds the |nth smal|
|00000e90| 6c 65 73 74 20 76 61 6c | 75 65 20 69 6e 20 61 20 |lest val|ue in a |
|00000ea0| 72 61 6e 67 65 2e 00 43 | 61 6c 63 75 6c 61 74 65 |range..C|alculate|
|00000eb0| 73 20 74 68 65 20 70 6f | 73 69 74 69 76 65 20 73 |s the po|sitive s|
|00000ec0| 71 75 61 72 65 20 72 6f | 6f 74 20 6f 66 20 78 2e |quare ro|ot of x.|
|00000ed0| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|00000ee0| 73 71 75 61 72 65 20 72 | 6f 6f 74 20 6f 66 20 78 |square r|oot of x|
|00000ef0| 2a 70 69 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |*pi..Cal|culates |
|00000f00| 74 68 65 20 70 6f 70 75 | 6c 61 74 69 6f 6e 20 73 |the popu|lation s|
|00000f10| 74 61 6e 64 61 72 64 20 | 64 65 76 69 61 74 69 6f |tandard |deviatio|
|00000f20| 6e 20 6f 66 20 61 20 6c | 69 73 74 20 6f 66 20 76 |n of a l|ist of v|
|00000f30| 61 6c 75 65 73 2e 00 43 | 61 6c 63 75 6c 61 74 65 |alues..C|alculate|
|00000f40| 73 20 74 68 65 20 73 61 | 6d 70 6c 65 20 73 74 61 |s the sa|mple sta|
|00000f50| 6e 64 61 72 64 20 64 65 | 76 69 61 74 69 6f 6e 20 |ndard de|viation |
|00000f60| 6f 66 20 61 20 6c 69 73 | 74 20 6f 66 20 76 61 6c |of a lis|t of val|
|00000f70| 75 65 73 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |ues..Cal|culates |
|00000f80| 74 68 65 20 70 6f 70 75 | 6c 61 74 69 6f 6e 20 73 |the popu|lation s|
|00000f90| 74 61 6e 64 61 72 64 20 | 64 65 76 69 61 74 69 6f |tandard |deviatio|
|00000fa0| 6e 20 6f 66 20 61 20 6c | 69 73 74 20 6f 66 20 76 |n of a l|ist of v|
|00000fb0| 61 6c 75 65 73 2c 20 69 | 67 6e 6f 72 69 6e 67 20 |alues, i|gnoring |
|00000fc0| 63 65 6c 6c 73 20 74 68 | 61 74 20 63 6f 6e 74 61 |cells th|at conta|
|00000fd0| 69 6e 20 6c 61 62 65 6c | 73 2e 00 43 61 6c 63 75 |in label|s..Calcu|
|00000fe0| 6c 61 74 65 73 20 74 68 | 65 20 73 61 6d 70 6c 65 |lates th|e sample|
|00000ff0| 20 73 74 61 6e 64 61 72 | 64 20 64 65 76 69 61 74 | standar|d deviat|
|00001000| 69 6f 6e 20 6f 66 20 61 | 20 6c 69 73 74 20 6f 66 |ion of a| list of|
|00001010| 20 76 61 6c 75 65 73 2c | 20 69 67 6e 6f 72 69 6e | values,| ignorin|
|00001020| 67 20 63 65 6c 6c 73 20 | 74 68 61 74 20 63 6f 6e |g cells |that con|
|00001030| 74 61 69 6e 20 6c 61 62 | 65 6c 73 2e 00 52 65 74 |tain lab|els..Ret|
|00001040| 75 72 6e 73 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |urns inf|ormation|
|00001050| 20 61 62 6f 75 74 20 74 | 68 65 20 61 74 74 72 69 | about t|he attri|
|00001060| 62 75 74 65 73 20 6f 66 | 20 61 20 76 65 72 73 69 |butes of| a versi|
|00001070| 6f 6e 20 67 72 6f 75 70 | 2e 00 52 65 74 75 72 6e |on group|..Return|
|00001080| 73 20 74 68 65 20 6e 61 | 6d 65 20 6f 66 20 74 68 |s the na|me of th|
|00001090| 65 20 6c 61 73 74 20 64 | 69 73 70 6c 61 79 65 64 |e last d|isplayed|
|000010a0| 20 76 65 72 73 69 6f 6e | 20 67 72 6f 75 70 2e 00 | version| group..|
|000010b0| 43 6f 6e 76 65 72 74 73 | 20 74 68 65 20 76 61 6c |Converts| the val|
|000010c0| 75 65 20 78 20 74 6f 20 | 61 20 6c 61 62 65 6c 2e |ue x to |a label.|
|000010d0| 00 41 64 64 73 20 61 20 | 6c 69 73 74 20 6f 66 20 |.Adds a |list of |
|000010e0| 76 61 6c 75 65 73 2e 20 | 55 73 65 20 74 6f 20 69 |values. |Use to i|
|000010f0| 6e 64 69 63 61 74 65 20 | 77 68 69 63 68 20 63 65 |ndicate |which ce|
|00001100| 6c 6c 73 20 40 47 52 41 | 4e 44 54 4f 54 41 4c 20 |lls @GRA|NDTOTAL |
|00001110| 73 68 6f 75 6c 64 20 73 | 75 6d 2e 00 41 64 64 73 |should s|um..Adds|
|00001120| 20 61 20 6c 69 73 74 20 | 6f 66 20 76 61 6c 75 65 | a list |of value|
|00001130| 73 2e 00 53 75 6d 73 20 | 6f 6e 6c 79 20 74 68 65 |s..Sums |only the|
|00001140| 20 6e 65 67 61 74 69 76 | 65 20 76 61 6c 75 65 73 | negativ|e values|
|00001150| 20 69 6e 20 61 20 6c 69 | 73 74 20 6f 66 20 76 61 | in a li|st of va|
|00001160| 6c 75 65 73 2e 00 53 75 | 6d 73 20 6f 6e 6c 79 20 |lues..Su|ms only |
|00001170| 74 68 65 20 70 6f 73 69 | 74 69 76 65 20 76 61 6c |the posi|tive val|
|00001180| 75 65 73 20 69 6e 20 61 | 20 6c 69 73 74 20 6f 66 |ues in a| list of|
|00001190| 20 76 61 6c 75 65 73 2e | 00 4d 75 6c 74 69 70 6c | values.|.Multipl|
|000011a0| 69 65 73 20 74 68 65 20 | 76 61 6c 75 65 73 20 69 |ies the |values i|
|000011b0| 6e 20 63 6f 72 72 65 73 | 70 6f 6e 64 69 6e 67 20 |n corres|ponding |
|000011c0| 63 65 6c 6c 73 20 69 6e | 20 6d 75 6c 74 69 70 6c |cells in| multipl|
|000011d0| 65 20 72 61 6e 67 65 73 | 20 61 6e 64 20 74 68 65 |e ranges| and the|
|000011e0| 6d 20 73 75 6d 73 20 74 | 68 65 20 70 72 6f 64 75 |m sums t|he produ|
|000011f0| 63 74 73 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |cts..Cal|culates |
|00001200| 74 68 65 20 73 75 6d 20 | 6f 66 20 74 68 65 20 73 |the sum |of the s|
|00001210| 71 75 61 72 65 73 20 6f | 66 20 61 20 6c 69 73 74 |quares o|f a list|
|00001220| 20 6f 66 20 76 61 6c 75 | 65 73 2e 00 53 75 62 74 | of valu|es..Subt|
|00001230| 72 61 63 74 73 20 74 68 | 65 20 76 61 6c 75 65 73 |racts th|e values|
|00001240| 20 69 6e 20 63 6f 72 72 | 65 73 70 6f 6e 64 69 6e | in corr|espondin|
|00001250| 67 20 63 65 6c 6c 73 20 | 69 6e 20 74 77 6f 20 72 |g cells |in two r|
|00001260| 61 6e 67 65 73 2c 20 73 | 71 75 61 72 65 73 20 74 |anges, s|quares t|
|00001270| 68 65 20 64 69 66 66 65 | 72 65 6e 63 65 73 20 61 |he diffe|rences a|
|00001280| 6e 64 20 74 68 65 6e 20 | 73 75 6d 73 20 74 68 65 |nd then |sums the|
|00001290| 20 72 65 73 75 6c 74 73 | 2e 00 43 61 6c 63 75 6c | results|..Calcul|
|000012a0| 61 74 65 73 20 74 68 65 | 20 73 75 6d 2d 6f 66 2d |ates the| sum-of-|
|000012b0| 74 68 65 2d 79 65 61 72 | 73 27 2d 64 69 67 69 74 |the-year|s'-digit|
|000012c0| 73 20 64 65 70 72 65 63 | 69 61 74 69 6f 6e 20 61 |s deprec|iation a|
|000012d0| 6c 6c 6f 77 61 6e 63 65 | 2e 00 43 61 6c 63 75 6c |llowance|..Calcul|
|000012e0| 61 74 65 73 20 74 68 65 | 20 74 61 6e 67 65 6e 74 |ates the| tangent|
|000012f0| 20 6f 66 20 61 6e 20 61 | 6e 67 6c 65 2e 00 43 61 | of an a|ngle..Ca|
|00001300| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 68 79 70 |lculates| the hyp|
|00001310| 65 72 62 6f 6c 69 63 20 | 74 61 6e 67 65 6e 74 20 |erbolic |tangent |
|00001320| 6f 66 20 61 6e 20 61 6e | 67 6c 65 2e 00 43 61 6c |of an an|gle..Cal|
|00001330| 63 75 6c 61 74 65 73 20 | 74 68 65 20 53 74 75 64 |culates |the Stud|
|00001340| 65 6e 74 27 73 20 74 2d | 64 69 73 74 72 69 62 75 |ent's t-|distribu|
|00001350| 74 69 6f 6e 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |tion..Ca|lculates|
|00001360| 20 74 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 70 | the num|ber of p|
|00001370| 61 79 6d 65 6e 74 20 70 | 65 72 69 6f 64 73 20 69 |ayment p|eriods i|
|00001380| 6e 20 61 6e 20 69 6e 76 | 65 73 74 6d 65 6e 74 2e |n an inv|estment.|
|00001390| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|000013a0| 74 69 6d 65 20 6e 75 6d | 62 65 72 20 66 6f 72 20 |time num|ber for |
|000013b0| 61 20 73 65 74 20 6f 66 | 20 68 6f 75 72 73 2c 20 |a set of| hours, |
|000013c0| 6d 69 6e 75 74 65 73 2c | 20 61 6e 64 20 73 65 63 |minutes,| and sec|
|000013d0| 6f 6e 64 73 2e 00 43 6f | 6e 76 65 72 74 73 20 74 |onds..Co|nverts t|
|000013e0| 65 78 74 20 74 68 61 74 | 20 6c 6f 6f 6b 73 20 6c |ext that| looks l|
|000013f0| 69 6b 65 20 61 20 74 69 | 6d 65 20 69 6e 74 6f 20 |ike a ti|me into |
|00001400| 69 74 73 20 65 71 75 69 | 76 61 6c 65 6e 74 20 74 |its equi|valent t|
|00001410| 69 6d 65 20 6e 75 6d 62 | 65 72 2e 00 43 61 6c 63 |ime numb|er..Calc|
|00001420| 75 6c 61 74 65 73 20 74 | 68 65 20 64 61 74 65 20 |ulates t|he date |
|00001430| 6e 75 6d 62 65 72 20 74 | 68 61 74 20 63 6f 72 72 |number t|hat corr|
|00001440| 65 73 70 6f 6e 64 73 20 | 74 6f 20 74 68 65 20 63 |esponds |to the c|
|00001450| 75 72 72 65 6e 74 20 64 | 61 74 65 20 6f 6e 20 79 |urrent d|ate on y|
|00001460| 6f 75 72 20 63 6f 6d 70 | 75 74 65 72 2e 00 52 65 |our comp|uter..Re|
|00001470| 6d 6f 76 65 73 20 6c 65 | 61 64 69 6e 67 2c 20 74 |moves le|ading, t|
|00001480| 72 61 69 6c 69 6e 67 20 | 61 6e 64 20 63 6f 6e 73 |railing |and cons|
|00001490| 65 63 75 74 69 76 65 20 | 73 70 61 63 65 73 20 66 |ecutive |spaces f|
|000014a0| 72 6f 6d 20 74 65 78 74 | 2e 00 52 65 74 75 72 6e |rom text|..Return|
|000014b0| 73 20 74 68 65 20 6c 6f | 67 69 63 61 6c 20 76 61 |s the lo|gical va|
|000014c0| 6c 75 65 20 31 20 28 74 | 72 75 65 29 2e 00 54 72 |lue 1 (t|rue)..Tr|
|000014d0| 75 6e 63 61 74 65 73 20 | 61 20 76 61 6c 75 65 20 |uncates |a value |
|000014e0| 74 6f 20 61 20 73 70 65 | 63 69 66 69 65 64 20 6e |to a spe|cified n|
|000014f0| 75 6d 62 65 72 20 6f 66 | 20 64 65 63 69 6d 61 6c |umber of| decimal|
|00001500| 20 70 6c 61 63 65 73 2e | 00 50 65 72 66 6f 72 6d | places.|.Perform|
|00001510| 73 20 61 20 53 74 75 64 | 65 6e 74 27 73 20 74 2d |s a Stud|ent's t-|
|00001520| 74 65 73 74 20 61 6e 64 | 20 72 65 74 75 72 6e 73 |test and| returns|
|00001530| 20 74 68 65 20 61 73 73 | 6f 63 69 61 74 65 64 20 | the ass|ociated |
|00001540| 70 72 6f 62 61 62 69 6c | 69 74 79 2e 00 43 6f 6e |probabil|ity..Con|
|00001550| 76 65 72 74 73 20 61 6c | 6c 20 74 68 65 20 6c 65 |verts al|l the le|
|00001560| 74 74 65 72 73 20 69 6e | 20 74 65 78 74 20 74 6f |tters in| text to|
|00001570| 20 75 70 70 65 72 63 61 | 73 65 2e 00 43 6f 6e 76 | upperca|se..Conv|
|00001580| 65 72 74 73 20 61 20 6e | 75 6d 62 65 72 20 65 6e |erts a n|umber en|
|00001590| 74 65 72 65 64 20 61 73 | 20 74 65 78 74 20 74 6f |tered as| text to|
|000015a0| 20 69 74 73 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 | its cor|respondi|
|000015b0| 6e 67 20 76 61 6c 75 65 | 2e 00 43 61 6c 63 75 6c |ng value|..Calcul|
|000015c0| 61 74 65 73 20 74 68 65 | 20 70 6f 70 75 6c 61 74 |ates the| populat|
|000015d0| 69 6f 6e 20 76 61 72 69 | 61 6e 63 65 20 6f 66 20 |ion vari|ance of |
|000015e0| 61 20 6c 69 73 74 20 6f | 66 20 76 61 6c 75 65 73 |a list o|f values|
|000015f0| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|00001600| 20 73 61 6d 70 6c 65 20 | 76 61 72 69 61 6e 63 65 | sample |variance|
|00001610| 20 6f 66 20 61 20 6c 69 | 73 74 20 6f 66 20 76 61 | of a li|st of va|
|00001620| 6c 75 65 73 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |lues..Ca|lculates|
|00001630| 20 74 68 65 20 70 6f 70 | 75 6c 61 74 69 6f 6e 20 | the pop|ulation |
|00001640| 76 61 72 69 61 6e 63 65 | 20 6f 66 20 61 20 6c 69 |variance| of a li|
|00001650| 73 74 20 6f 66 20 76 61 | 6c 75 65 73 2c 20 69 67 |st of va|lues, ig|
|00001660| 6e 6f 72 69 6e 67 20 63 | 65 6c 6c 73 20 74 68 61 |noring c|ells tha|
|00001670| 74 20 63 6f 6e 74 61 69 | 6e 20 6c 61 62 65 6c 73 |t contai|n labels|
|00001680| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|00001690| 20 73 61 6d 70 6c 65 20 | 76 61 72 69 61 6e 63 65 | sample |variance|
|000016a0| 20 6f 66 20 61 20 6c 69 | 73 74 20 6f 66 20 76 61 | of a li|st of va|
|000016b0| 6c 75 65 73 2c 20 69 67 | 6e 6f 72 69 6e 67 20 63 |lues, ig|noring c|
|000016c0| 65 6c 6c 73 20 74 68 61 | 74 20 63 6f 6e 74 61 69 |ells tha|t contai|
|000016d0| 6e 20 6c 61 62 65 6c 73 | 2e 00 43 61 6c 63 75 6c |n labels|..Calcul|
|000016e0| 61 74 65 73 20 64 65 70 | 72 65 63 69 61 74 69 6f |ates dep|reciatio|
|000016f0| 6e 20 61 6c 6c 6f 77 61 | 6e 63 65 20 75 73 69 6e |n allowa|nce usin|
|00001700| 67 20 74 68 65 20 76 61 | 72 69 61 62 6c 65 2d 72 |g the va|riable-r|
|00001710| 61 74 65 20 64 65 63 6c | 69 6e 69 6e 67 20 62 61 |ate decl|ining ba|
|00001720| 6c 61 6e 63 65 20 6d 65 | 74 68 6f 64 2e 00 52 65 |lance me|thod..Re|
|00001730| 74 75 72 6e 73 20 74 68 | 65 20 6e 61 6d 65 20 6f |turns th|e name o|
|00001740| 66 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 76 65 |f the cu|rrent ve|
|00001750| 72 73 69 6f 6e 20 66 6f | 72 20 61 20 72 61 6e 67 |rsion fo|r a rang|
|00001760| 65 2e 00 52 65 74 75 72 | 6e 73 20 74 68 65 20 63 |e..Retur|ns the c|
|00001770| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 61 20 63 65 6c |ontents |of a cel|
|00001780| 6c 20 69 6e 20 61 6e 20 | 76 65 72 73 69 6f 6e 2e |l in an |version.|
|00001790| 00 52 65 74 75 72 6e 73 | 20 69 6e 66 6f 72 6d 61 |.Returns| informa|
|000017a0| 74 69 6f 6e 20 61 62 6f | 75 74 20 74 68 65 20 61 |tion abo|ut the a|
|000017b0| 74 74 72 69 62 75 74 65 | 73 20 6f 66 20 61 20 76 |ttribute|s of a v|
|000017c0| 65 72 73 69 6f 6e 2e 00 | 52 65 74 75 72 6e 73 20 |ersion..|Returns |
|000017d0| 74 68 65 20 63 6f 6e 74 | 65 6e 74 73 20 6f 66 20 |the cont|ents of |
|000017e0| 61 20 63 65 6c 6c 20 69 | 6e 20 61 20 76 65 72 74 |a cell i|n a vert|
|000017f0| 69 63 61 6c 20 6c 6f 6f | 6b 75 70 20 74 61 62 6c |ical loo|kup tabl|
|00001800| 65 2e 00 45 78 74 72 61 | 63 74 73 20 74 68 65 20 |e..Extra|cts the |
|00001810| 64 61 79 20 6f 66 20 74 | 68 65 20 77 65 65 6b 20 |day of t|he week |
|00001820| 66 72 6f 6d 20 61 20 64 | 61 74 65 20 6e 75 6d 62 |from a d|ate numb|
|00001830| 65 72 2e 00 43 61 6c 63 | 75 6c 61 74 65 73 20 74 |er..Calc|ulates t|
|00001840| 68 65 20 77 65 69 67 68 | 74 65 64 20 61 76 65 72 |he weigh|ted aver|
|00001850| 61 67 65 20 6f 66 20 61 | 20 6c 69 73 74 20 6f 66 |age of a| list of|
|00001860| 20 76 61 6c 75 65 73 2e | 00 43 61 6c 63 75 6c 61 | values.|.Calcula|
|00001870| 74 65 73 20 74 68 65 20 | 64 61 74 65 20 74 68 61 |tes the |date tha|
|00001880| 74 20 69 73 20 61 20 73 | 70 65 63 69 66 69 65 64 |t is a s|pecified|
|00001890| 20 6e 75 6d 62 65 72 20 | 6f 66 20 64 61 79 73 20 | number |of days |
|000018a0| 62 65 66 6f 72 65 20 6f | 72 20 61 66 74 65 72 20 |before o|r after |
|000018b0| 61 20 73 70 65 63 69 66 | 69 65 64 20 64 61 74 65 |a specif|ied date|
|000018c0| 2e 00 52 65 74 75 72 6e | 73 20 74 68 65 20 63 6f |..Return|s the co|
|000018d0| 6e 74 65 6e 74 73 20 6f | 66 20 61 20 63 65 6c 6c |ntents o|f a cell|
|000018e0| 20 73 70 65 63 69 66 69 | 65 64 20 62 79 20 63 6f | specifi|ed by co|
|000018f0| 6c 75 6d 6e 2c 20 72 6f | 77 2c 20 61 6e 64 20 73 |lumn, ro|w, and s|
|00001900| 68 65 65 74 20 68 65 61 | 64 69 6e 67 2e 00 45 78 |heet hea|ding..Ex|
|00001910| 74 72 61 63 74 73 20 74 | 68 65 20 79 65 61 72 20 |tracts t|he year |
|00001920| 66 72 6f 6d 20 61 20 64 | 61 74 65 20 6e 75 6d 62 |from a d|ate numb|
|00001930| 65 72 2e 00 52 65 74 75 | 72 6e 73 20 74 68 65 20 |er..Retu|rns the |
|00001940| 79 69 65 6c 64 20 66 6f | 72 20 62 6f 6e 64 73 20 |yield fo|r bonds |
|00001950| 74 68 61 74 20 70 61 79 | 20 70 65 72 69 6f 64 69 |that pay| periodi|
|00001960| 63 20 69 6e 74 65 72 65 | 73 74 2e 00 50 65 72 66 |c intere|st..Perf|
|00001970| 6f 72 6d 73 20 61 20 7a | 2d 74 65 73 74 20 61 6e |orms a z|-test an|
|00001980| 64 20 72 65 74 75 72 6e | 73 20 74 68 65 20 61 73 |d return|s the as|
|00001990| 73 6f 63 69 61 74 65 64 | 20 70 72 6f 62 61 62 69 |sociated| probabi|
|000019a0| 6c 69 74 79 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |lity..Ca|lculates|
|000019b0| 20 61 63 63 72 75 65 64 | 20 69 6e 74 65 72 65 73 | accrued| interes|
|000019c0| 74 20 66 6f 72 20 62 6f | 6e 64 73 20 77 69 74 68 |t for bo|nds with|
|000019d0| 20 70 65 72 69 6f 64 69 | 63 20 69 6e 74 65 72 65 | periodi|c intere|
|000019e0| 73 74 20 70 61 79 6d 65 | 6e 74 73 2c 20 75 73 69 |st payme|nts, usi|
|000019f0| 6e 67 20 4a 61 70 61 6e | 65 73 65 20 63 6f 6e 76 |ng Japan|ese conv|
|00001a00| 65 6e 74 69 6f 6e 73 2e | 00 43 6f 6e 76 65 72 74 |entions.|.Convert|
|00001a10| 73 20 73 69 6e 67 6c 65 | 2d 62 79 74 65 20 63 68 |s single|-byte ch|
|00001a20| 61 72 61 63 74 65 72 73 | 20 69 6e 20 74 65 78 74 |aracters| in text|
|00001a30| 20 74 6f 20 63 6f 72 72 | 65 73 70 6f 6e 64 69 6e | to corr|espondin|
|00001a40| 67 20 4a 61 70 61 6e 65 | 73 65 20 64 6f 75 62 6c |g Japane|se doubl|
|00001a50| 65 2d 62 79 74 65 20 63 | 68 61 72 61 63 74 65 72 |e-byte c|haracter|
|00001a60| 73 2e 00 43 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |s..Calcu|lates th|
|00001a70| 65 20 66 75 74 75 72 65 | 20 76 61 6c 75 65 20 6f |e future| value o|
|00001a80| 66 20 61 6e 20 61 6e 6e | 75 69 74 79 20 64 75 65 |f an ann|uity due|
|00001a90| 2e 00 43 6f 6e 76 65 72 | 74 73 20 4a 61 70 61 6e |..Conver|ts Japan|
|00001aa0| 65 73 65 20 64 6f 75 62 | 6c 65 2d 62 79 74 65 20 |ese doub|le-byte |
|00001ab0| 63 68 61 72 61 63 74 65 | 72 73 20 69 6e 20 74 65 |characte|rs in te|
|00001ac0| 78 74 20 74 6f 20 63 6f | 72 72 65 73 70 6f 6e 64 |xt to co|rrespond|
|00001ad0| 69 6e 67 20 73 69 6e 67 | 6c 65 2d 62 79 74 65 20 |ing sing|le-byte |
|00001ae0| 63 68 61 72 61 63 74 65 | 72 73 2e 00 43 6f 6e 76 |characte|rs..Conv|
|00001af0| 65 72 74 73 20 6e 75 6d | 62 65 72 20 74 6f 20 74 |erts num|ber to t|
|00001b00| 68 65 20 73 70 65 6c 6c | 65 64 2d 6f 75 74 20 4a |he spell|ed-out J|
|00001b10| 61 70 61 6e 65 73 65 20 | 74 65 78 74 20 66 6f 72 |apanese |text for|
|00001b20| 20 74 68 65 20 6e 75 6d | 62 65 72 2c 20 75 73 69 | the num|ber, usi|
|00001b30| 6e 67 20 74 68 65 20 66 | 6f 72 6d 61 74 20 73 70 |ng the f|ormat sp|
|00001b40| 65 63 69 66 69 65 64 20 | 69 6e 20 74 79 70 65 2e |ecified |in type.|
|00001b50| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|00001b60| 70 65 72 69 6f 64 69 63 | 20 70 61 79 6d 65 6e 74 |periodic| payment|
|00001b70| 20 6f 6e 20 61 20 6c 6f | 61 6e 2c 20 75 73 69 6e | on a lo|an, usin|
|00001b80| 67 20 61 6e 20 61 6e 6e | 75 69 74 79 20 64 75 65 |g an ann|uity due|
|00001b90| 20 63 6f 6e 76 65 6e 74 | 69 6f 6e 2e 00 43 61 6c | convent|ion..Cal|
|00001ba0| 63 75 6c 61 74 65 73 20 | 74 68 65 20 69 6e 74 65 |culates |the inte|
|00001bb0| 72 65 73 74 20 70 6f 72 | 74 69 6f 6e 20 6f 66 20 |rest por|tion of |
|00001bc0| 61 20 63 6f 6e 73 74 61 | 6e 74 20 70 65 72 69 6f |a consta|nt perio|
|00001bd0| 64 69 63 20 70 61 79 6d | 65 6e 74 2e 00 52 65 74 |dic paym|ent..Ret|
|00001be0| 75 72 6e 73 20 74 68 65 | 20 70 72 69 63 65 20 70 |urns the| price p|
|00001bf0| 65 72 20 24 31 30 30 20 | 66 61 63 65 20 76 61 6c |er $100 |face val|
|00001c00| 75 65 20 66 6f 72 20 73 | 65 63 75 72 69 74 69 65 |ue for s|ecuritie|
|00001c10| 73 20 77 69 74 68 20 70 | 65 72 69 6f 64 69 63 20 |s with p|eriodic |
|00001c20| 69 6e 74 65 72 65 73 74 | 20 72 61 74 65 73 2e 00 |interest| rates..|
|00001c30| 52 65 74 75 72 6e 73 20 | 74 68 65 20 70 72 69 63 |Returns |the pric|
|00001c40| 65 20 70 65 72 20 31 30 | 30 20 79 65 6e 20 66 61 |e per 10|0 yen fa|
|00001c50| 63 65 20 76 61 6c 75 65 | 20 66 6f 72 20 73 65 63 |ce value| for sec|
|00001c60| 75 72 69 74 69 65 73 20 | 77 69 74 68 20 70 65 72 |urities |with per|
|00001c70| 69 6f 64 69 63 20 69 6e | 74 65 72 65 73 74 20 72 |iodic in|terest r|
|00001c80| 61 74 65 73 2c 20 75 73 | 69 6e 67 20 4a 61 70 61 |ates, us|ing Japa|
|00001c90| 6e 65 73 65 20 63 6f 6e | 76 65 6e 74 69 6f 6e 73 |nese con|ventions|
|00001ca0| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|00001cb0| 20 70 72 65 73 65 6e 74 | 20 76 61 6c 75 65 20 6f | present| value o|
|00001cc0| 66 20 61 6e 20 69 6e 76 | 65 73 74 6d 65 6e 74 2c |f an inv|estment,|
|00001cd0| 20 75 73 69 6e 67 20 61 | 6e 20 61 6e 6e 75 69 74 | using a|n annuit|
|00001ce0| 79 20 64 75 65 20 63 6f | 6e 76 65 6e 74 69 6f 6e |y due co|nvention|
|00001cf0| 2e 00 43 61 6c 63 75 6c | 61 74 65 73 20 74 68 65 |..Calcul|ates the|
|00001d00| 20 69 6e 74 65 72 65 73 | 74 20 70 6f 72 74 69 6f | interes|t portio|
|00001d10| 6e 20 6f 66 20 61 20 70 | 65 72 69 6f 64 69 63 20 |n of a p|eriodic |
|00001d20| 70 61 79 6d 65 6e 74 20 | 77 68 65 72 65 20 74 68 |payment |where th|
|00001d30| 65 20 70 72 69 6e 63 69 | 70 61 6c 20 70 6f 72 74 |e princi|pal port|
|00001d40| 69 6f 6e 20 69 73 20 74 | 68 65 20 73 61 6d 65 20 |ion is t|he same |
|00001d50| 65 61 63 68 20 70 61 79 | 6d 65 6e 74 20 70 65 72 |each pay|ment per|
|00001d60| 69 6f 64 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |iod..Cal|culates |
|00001d70| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 70 61 |the numb|er of pa|
|00001d80| 79 6d 65 6e 74 20 70 65 | 72 69 6f 64 73 20 69 6e |yment pe|riods in|
|00001d90| 20 61 6e 20 69 6e 76 65 | 73 74 6d 65 6e 74 2c 20 | an inve|stment, |
|00001da0| 75 73 69 6e 67 20 61 6e | 20 61 6e 6e 75 69 74 79 |using an| annuity|
|00001db0| 20 64 75 65 20 63 6f 6e | 76 65 6e 74 69 6f 6e 2e | due con|vention.|
|00001dc0| 00 52 65 74 75 72 6e 73 | 20 74 68 65 20 79 69 65 |.Returns| the yie|
|00001dd0| 6c 64 20 66 6f 72 20 62 | 6f 6e 64 73 20 74 68 61 |ld for b|onds tha|
|00001de0| 74 20 70 61 79 20 70 65 | 72 69 6f 64 69 63 20 69 |t pay pe|riodic i|
|00001df0| 6e 74 65 72 65 73 74 2c | 20 75 73 69 6e 67 20 4a |nterest,| using J|
|00001e00| 61 70 61 6e 65 73 65 20 | 63 6f 6e 76 65 6e 74 69 |apanese |conventi|
|00001e10| 6f 6e 73 2e 00 00 00 00 | 43 61 6c 63 75 6c 61 74 |ons.....|Calculat|
|00001e20| 65 73 20 74 68 65 20 66 | 75 74 75 72 65 20 76 61 |es the f|uture va|
|00001e30| 6c 75 65 20 6f 66 20 61 | 20 6c 75 6d 70 20 73 75 |lue of a| lump su|
|00001e40| 6d 20 69 6e 76 65 73 74 | 65 64 20 61 74 20 61 20 |m invest|ed at a |
|00001e50| 67 69 76 65 6e 20 72 61 | 74 65 20 66 6f 72 20 61 |given ra|te for a|
|00001e60| 20 67 69 76 65 6e 20 6e | 75 6d 62 65 72 20 6f 66 | given n|umber of|
|00001e70| 20 70 65 72 69 6f 64 73 | 2e 00 43 61 6c 63 75 6c | periods|..Calcul|
|00001e80| 61 74 65 73 20 74 68 65 | 20 70 72 65 73 65 6e 74 |ates the| present|
|00001e90| 20 76 61 6c 75 65 20 6f | 66 20 61 20 6c 75 6d 70 | value o|f a lump|
|00001ea0| 20 73 75 6d 20 74 6f 20 | 62 65 20 72 65 63 65 69 | sum to |be recei|
|00001eb0| 76 65 64 20 6f 76 65 72 | 20 61 20 67 69 76 65 6e |ved over| a given|
|00001ec0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 70 65 72 69 6f | number |of perio|
|00001ed0| 64 73 2e 00 52 65 74 75 | 72 6e 73 20 74 68 65 20 |ds..Retu|rns the |
|00001ee0| 69 6e 74 65 72 6e 61 6c | 20 72 61 74 65 20 6f 66 |internal| rate of|
|00001ef0| 20 72 65 74 75 72 6e 20 | 66 6f 72 20 61 20 73 65 | return |for a se|
|00001f00| 72 69 65 73 20 6f 66 20 | 69 6e 66 6c 6f 77 73 20 |ries of |inflows |
|00001f10| 61 6e 64 20 6f 75 74 66 | 6c 6f 77 73 2e 00 52 65 |and outf|lows..Re|
|00001f20| 74 75 72 6e 73 20 74 68 | 65 20 6e 65 74 20 70 72 |turns th|e net pr|
|00001f30| 65 73 65 6e 74 20 76 61 | 6c 75 65 20 6f 66 20 61 |esent va|lue of a|
|00001f40| 20 73 65 72 69 65 73 20 | 6f 66 20 69 6e 66 6c 6f | series |of inflo|
|00001f50| 77 73 20 61 6e 64 20 6f | 75 74 66 6c 6f 77 73 2e |ws and o|utflows.|
|00001f60| 00 54 65 73 74 73 20 77 | 68 65 74 68 65 72 20 76 |.Tests w|hether v|
|00001f70| 61 6c 75 65 20 69 73 20 | 62 65 74 77 65 65 6e 20 |alue is |between |
|00001f80| 62 6f 75 6e 64 31 20 61 | 6e 64 20 62 6f 75 6e 64 |bound1 a|nd bound|
|00001f90| 32 2e 00 52 65 74 75 72 | 6e 73 20 61 20 67 69 76 |2..Retur|ns a giv|
|00001fa0| 65 6e 20 64 65 63 69 6c | 65 2e 00 52 65 74 75 72 |en decil|e..Retur|
|00001fb0| 6e 73 20 61 20 66 6f 72 | 65 63 61 73 74 20 76 61 |ns a for|ecast va|
|00001fc0| 6c 75 65 20 66 6f 72 20 | 78 2c 20 62 61 73 65 64 |lue for |x, based|
|00001fd0| 20 6f 6e 20 74 68 65 20 | 6c 69 6e 65 61 72 20 74 | on the |linear t|
|00001fe0| 72 65 6e 64 20 62 65 74 | 77 65 65 6e 20 76 61 6c |rend bet|ween val|
|00001ff0| 75 65 73 20 69 6e 20 79 | 5f 72 61 6e 67 65 20 61 |ues in y|_range a|
|00002000| 6e 64 20 78 5f 72 61 6e | 67 65 2e 00 41 64 64 73 |nd x_ran|ge..Adds|
|00002010| 20 65 76 65 72 79 20 6e | 74 68 20 76 61 6c 75 65 | every n|th value|
|00002020| 20 69 6e 20 61 20 6c 69 | 73 74 2c 20 73 74 61 72 | in a li|st, star|
|00002030| 74 69 6e 67 20 61 74 20 | 74 68 65 20 6f 66 66 73 |ting at |the offs|
|00002040| 65 74 2e 00 52 65 74 75 | 72 6e 73 20 74 68 65 20 |et..Retu|rns the |
|00002050| 6d 65 64 69 61 6e 20 76 | 61 6c 75 65 20 69 6e 20 |median v|alue in |
|00002060| 6c 69 73 74 2c 20 69 67 | 6e 6f 72 69 6e 67 20 63 |list, ig|noring c|
|00002070| 65 6c 6c 73 20 74 68 61 | 74 20 63 6f 6e 74 61 69 |ells tha|t contai|
|00002080| 6e 20 6c 61 62 65 6c 73 | 2e 00 52 65 74 75 72 6e |n labels|..Return|
|00002090| 73 20 61 20 67 69 76 65 | 6e 20 71 75 61 72 74 69 |s a give|n quarti|
|000020a0| 6c 65 2e 00 43 61 6c 63 | 75 6c 61 74 65 73 20 74 |le..Calc|ulates t|
|000020b0| 68 65 20 62 79 74 65 20 | 70 6f 73 69 74 69 6f 6e |he byte |position|
|000020c0| 20 6f 66 20 74 68 65 20 | 66 69 72 73 74 20 6f 63 | of the |first oc|
|000020d0| 63 75 72 72 65 6e 63 65 | 20 6f 66 20 73 65 61 72 |currence| of sear|
|000020e0| 63 68 5f 74 65 78 74 20 | 69 6e 20 74 65 78 74 2e |ch_text |in text.|
|000020f0| 00 52 65 74 75 72 6e 73 | 20 74 68 65 20 66 69 72 |.Returns| the fir|
|00002100| 73 74 20 6e 20 62 79 74 | 65 73 20 69 6e 20 74 65 |st n byt|es in te|
|00002110| 78 74 2e 00 43 6f 75 6e | 74 73 20 74 68 65 20 6e |xt..Coun|ts the n|
|00002120| 75 6d 62 65 72 20 6f 66 | 20 62 79 74 65 73 20 69 |umber of| bytes i|
|00002130| 6e 20 74 65 78 74 2e 00 | 43 6f 70 69 65 73 20 6e |n text..|Copies n|
|00002140| 20 62 79 74 65 73 20 66 | 72 6f 6d 20 74 65 78 74 | bytes f|rom text|
|00002150| 2c 20 62 65 67 69 6e 6e | 69 6e 67 20 77 69 74 68 |, beginn|ing with|
|00002160| 20 74 68 65 20 64 61 74 | 61 20 61 74 20 62 79 74 | the dat|a at byt|
|00002170| 65 20 73 74 61 72 74 5f | 6e 75 6d 62 65 72 2e 00 |e start_|number..|
|00002180| 52 65 70 6c 61 63 65 73 | 20 6e 20 62 79 74 65 73 |Replaces| n bytes|
|00002190| 20 69 6e 20 6f 72 69 67 | 69 6e 61 6c 5f 74 65 78 | in orig|inal_tex|
|000021a0| 74 20 77 69 74 68 20 6e | 65 77 5f 74 65 78 74 2c |t with n|ew_text,|
|000021b0| 20 62 65 67 69 6e 6e 69 | 6e 67 20 61 74 20 62 79 | beginni|ng at by|
|000021c0| 74 65 20 73 74 61 72 74 | 5f 6e 75 6d 62 65 72 2e |te start|_number.|
|000021d0| 00 52 65 74 75 72 6e 73 | 20 74 68 65 20 6c 61 73 |.Returns| the las|
|000021e0| 74 20 6e 20 62 79 74 65 | 73 20 69 6e 20 74 65 78 |t n byte|s in tex|
|000021f0| 74 2e 00 43 6f 6e 76 65 | 72 74 73 20 61 20 64 61 |t..Conve|rts a da|
|00002200| 74 65 20 66 72 6f 6d 20 | 6f 6e 65 20 63 61 6c 65 |te from |one cale|
|00002210| 6e 64 61 72 20 74 6f 20 | 61 6e 6f 74 68 65 72 2e |ndar to |another.|
|00002220| 20 46 6f 72 20 62 69 2d | 64 69 72 65 63 74 69 6f | For bi-|directio|
|00002230| 6e 61 6c 20 6c 61 6e 67 | 75 61 67 65 73 20 6f 6e |nal lang|uages on|
|00002240| 6c 79 2e 00 43 6f 75 6e | 74 73 20 74 68 65 20 6e |ly..Coun|ts the n|
|00002250| 75 6d 62 65 72 20 6f 66 | 20 63 68 61 72 61 63 74 |umber of| charact|
|00002260| 65 72 73 20 69 6e 20 74 | 65 78 74 2e 20 55 73 65 |ers in t|ext. Use|
|00002270| 64 20 77 69 74 68 20 54 | 68 61 69 20 63 68 61 72 |d with T|hai char|
|00002280| 61 63 74 65 72 20 73 74 | 72 69 6e 67 73 2e 00 52 |acter st|rings..R|
|00002290| 65 74 75 72 6e 73 20 74 | 68 65 20 66 69 72 73 74 |eturns t|he first|
|000022a0| 20 6e 20 63 68 61 72 61 | 63 74 65 72 73 20 69 6e | n chara|cters in|
|000022b0| 20 74 65 78 74 2e 20 55 | 73 65 64 20 77 69 74 68 | text. U|sed with|
|000022c0| 20 54 68 61 69 20 63 68 | 61 72 61 63 74 65 72 20 | Thai ch|aracter |
|000022d0| 73 74 72 69 6e 67 73 2e | 00 52 65 74 75 72 6e 73 |strings.|.Returns|
|000022e0| 20 74 68 65 20 6c 61 73 | 74 20 6e 20 63 68 61 72 | the las|t n char|
|000022f0| 61 63 74 65 72 73 20 69 | 6e 20 74 65 78 74 2e 20 |acters i|n text. |
|00002300| 55 73 65 64 20 77 69 74 | 68 20 54 68 61 69 20 63 |Used wit|h Thai c|
|00002310| 68 61 72 61 63 74 65 72 | 20 73 74 72 69 6e 67 73 |haracter| strings|
|00002320| 2e 00 43 6f 70 69 65 73 | 20 6e 20 63 68 61 72 61 |..Copies| n chara|
|00002330| 63 74 65 72 73 20 66 72 | 6f 6d 20 74 65 78 74 2c |cters fr|om text,|
|00002340| 20 62 65 67 69 6e 6e 69 | 6e 67 20 77 69 74 68 20 | beginni|ng with |
|00002350| 74 68 65 20 54 68 61 69 | 20 63 68 61 72 61 63 74 |the Thai| charact|
|00002360| 65 72 20 61 74 20 73 74 | 61 72 74 5f 6e 75 6d 62 |er at st|art_numb|
|00002370| 65 72 2e 20 55 73 65 64 | 20 77 69 74 68 20 54 68 |er. Used| with Th|
|00002380| 61 69 20 63 68 61 72 61 | 63 74 65 72 20 73 74 72 |ai chara|cter str|
|00002390| 69 6e 67 73 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |ings..Ca|lculates|
|000023a0| 20 74 68 65 20 63 68 61 | 72 61 63 74 65 72 20 70 | the cha|racter p|
|000023b0| 6f 73 69 74 69 6f 6e 20 | 6f 66 20 74 68 65 20 66 |osition |of the f|
|000023c0| 69 72 73 74 20 6f 63 63 | 75 72 72 65 6e 63 65 20 |irst occ|urrence |
|000023d0| 6f 66 20 73 65 61 72 63 | 68 5f 74 65 78 74 20 69 |of searc|h_text i|
|000023e0| 6e 20 74 65 78 74 2e 20 | 55 73 65 64 20 77 69 74 |n text. |Used wit|
|000023f0| 68 20 54 68 61 69 20 63 | 68 61 72 61 63 74 65 72 |h Thai c|haracter|
|00002400| 20 73 74 72 69 6e 67 73 | 2e 00 52 65 70 6c 61 63 | strings|..Replac|
|00002410| 65 73 20 6e 20 63 68 61 | 72 61 63 74 65 72 73 20 |es n cha|racters |
|00002420| 69 6e 20 6f 72 69 67 69 | 6e 61 6c 5f 74 65 78 74 |in origi|nal_text|
|00002430| 20 77 69 74 68 20 6e 65 | 77 5f 74 65 78 74 2c 20 | with ne|w_text, |
|00002440| 62 65 67 69 6e 6e 69 6e | 67 20 61 74 20 73 74 61 |beginnin|g at sta|
|00002450| 72 74 5f 6e 75 6d 62 65 | 72 2e 20 55 73 65 64 20 |rt_numbe|r. Used |
|00002460| 77 69 74 68 20 54 68 61 | 69 20 63 68 61 72 61 63 |with Tha|i charac|
|00002470| 74 65 72 20 73 74 72 69 | 6e 67 73 2e 00 43 6f 6e |ter stri|ngs..Con|
|00002480| 76 65 72 74 73 20 61 20 | 64 69 67 69 74 5f 73 74 |verts a |digit_st|
|00002490| 72 69 6e 67 20 69 6e 20 | 41 72 61 62 69 63 20 6e |ring in |Arabic n|
|000024a0| 75 6d 65 72 61 6c 73 20 | 74 6f 20 54 68 61 69 20 |umerals |to Thai |
|000024b0| 6e 75 6d 65 72 61 6c 73 | 2e 00 43 6f 6e 76 65 72 |numerals|..Conver|
|000024c0| 74 73 20 64 69 67 69 74 | 5f 73 74 72 69 6e 67 20 |ts digit|_string |
|000024d0| 66 72 6f 6d 20 61 20 54 | 68 61 69 20 6e 75 6d 65 |from a T|hai nume|
|000024e0| 72 69 63 20 73 74 72 69 | 6e 67 20 74 6f 20 61 6e |ric stri|ng to an|
|000024f0| 20 41 72 61 62 69 63 20 | 73 74 72 69 6e 67 2e 00 | Arabic |string..|
|00002500| 43 6f 6e 76 65 72 74 73 | 20 6e 75 6d 62 65 72 20 |Converts| number |
|00002510| 74 6f 20 61 20 73 70 65 | 6c 6c 65 64 2d 6f 75 74 |to a spe|lled-out|
|00002520| 20 54 68 61 69 20 6e 75 | 6d 65 72 69 63 20 73 74 | Thai nu|meric st|
|00002530| 72 69 6e 67 2e 00 43 6f | 6e 76 65 72 74 73 20 61 |ring..Co|nverts a|
|00002540| 20 64 61 74 65 20 76 61 | 6c 75 65 20 74 6f 20 61 | date va|lue to a|
|00002550| 20 54 68 61 69 20 64 61 | 79 20 6e 61 6d 65 2e 00 | Thai da|y name..|
|00002560| 43 6f 6e 76 65 72 74 73 | 20 61 20 64 61 74 65 20 |Converts| a date |
|00002570| 76 61 6c 75 65 20 74 6f | 20 61 20 54 68 61 69 20 |value to| a Thai |
|00002580| 64 61 74 65 20 73 74 72 | 69 6e 67 20 69 6e 20 73 |date str|ing in s|
|00002590| 68 6f 72 74 20 66 6f 72 | 6d 61 74 2e 00 43 6f 6e |hort for|mat..Con|
|000025a0| 76 65 72 74 73 20 61 20 | 64 61 74 65 20 76 61 6c |verts a |date val|
|000025b0| 75 65 20 74 6f 20 61 20 | 54 68 61 69 20 64 61 74 |ue to a |Thai dat|
|000025c0| 65 20 73 74 72 69 6e 67 | 20 69 6e 20 6c 6f 6e 67 |e string| in long|
|000025d0| 20 66 6f 72 6d 61 74 2e | 00 43 6f 6e 76 65 72 74 | format.|.Convert|
|000025e0| 73 20 61 20 6e 75 6d 65 | 72 69 63 20 73 74 72 69 |s a nume|ric stri|
|000025f0| 6e 67 20 6f 66 20 61 6e | 79 20 62 61 73 65 20 74 |ng of an|y base t|
|00002600| 6f 20 61 6e 79 20 6f 74 | 68 65 72 20 62 61 73 65 |o any ot|her base|
|00002610| 2e 00 43 6f 6e 76 65 72 | 74 73 20 61 20 62 69 6e |..Conver|ts a bin|
|00002620| 61 72 79 20 6e 75 6d 62 | 65 72 20 74 6f 20 64 65 |ary numb|er to de|
|00002630| 63 69 6d 61 6c 2e 00 43 | 6f 6e 76 65 72 74 73 20 |cimal..C|onverts |
|00002640| 61 20 62 69 6e 61 72 79 | 20 6e 75 6d 62 65 72 20 |a binary| number |
|00002650| 74 6f 20 68 65 78 61 64 | 65 63 69 6d 61 6c 2e 00 |to hexad|ecimal..|
|00002660| 43 6f 6e 76 65 72 74 73 | 20 61 20 62 69 6e 61 72 |Converts| a binar|
|00002670| 79 20 6e 75 6d 62 65 72 | 20 74 6f 20 6f 63 74 61 |y number| to octa|
|00002680| 6c 2e 00 43 6f 6e 76 65 | 72 74 73 20 61 20 64 65 |l..Conve|rts a de|
|00002690| 63 69 6d 61 6c 20 6e 75 | 6d 62 65 72 20 74 6f 20 |cimal nu|mber to |
|000026a0| 61 20 62 69 6e 61 72 79 | 20 6e 75 6d 62 65 72 2e |a binary| number.|
|000026b0| 00 43 6f 6e 76 65 72 74 | 73 20 61 20 64 65 63 69 |.Convert|s a deci|
|000026c0| 6d 61 6c 20 6e 75 6d 62 | 65 72 20 74 6f 20 61 20 |mal numb|er to a |
|000026d0| 68 65 78 61 64 65 63 69 | 6d 61 6c 20 6e 75 6d 62 |hexadeci|mal numb|
|000026e0| 65 72 2e 00 43 6f 6e 76 | 65 72 74 73 20 61 20 64 |er..Conv|erts a d|
|000026f0| 65 63 69 6d 61 6c 20 6e | 75 6d 62 65 72 20 74 6f |ecimal n|umber to|
|00002700| 20 61 6e 20 6f 63 74 61 | 6c 20 6e 75 6d 62 65 72 | an octa|l number|
|00002710| 2e 00 43 6f 6e 76 65 72 | 74 73 20 61 20 68 65 78 |..Conver|ts a hex|
|00002720| 61 64 65 63 69 6d 61 6c | 20 6e 75 6d 62 65 72 20 |adecimal| number |
|00002730| 74 6f 20 69 74 73 20 62 | 69 6e 61 72 79 20 76 61 |to its b|inary va|
|00002740| 6c 75 65 2e 00 43 6f 6e | 76 65 72 74 73 20 61 20 |lue..Con|verts a |
|00002750| 68 65 78 61 64 65 63 69 | 6d 61 6c 20 6e 75 6d 62 |hexadeci|mal numb|
|00002760| 65 72 20 74 6f 20 69 74 | 73 20 64 65 63 69 6d 61 |er to it|s decima|
|00002770| 6c 20 76 61 6c 75 65 2e | 00 43 6f 6e 76 65 72 74 |l value.|.Convert|
|00002780| 73 20 61 20 68 65 78 61 | 64 65 63 69 6d 61 6c 20 |s a hexa|decimal |
|00002790| 6e 75 6d 62 65 72 20 74 | 6f 20 69 74 73 20 6f 63 |number t|o its oc|
|000027a0| 74 61 6c 20 76 61 6c 75 | 65 2e 00 43 6f 6e 76 65 |tal valu|e..Conve|
|000027b0| 72 74 73 20 61 6e 20 6f | 63 74 61 6c 20 6e 75 6d |rts an o|ctal num|
|000027c0| 62 65 72 20 74 6f 20 62 | 69 6e 61 72 79 2e 00 43 |ber to b|inary..C|
|000027d0| 6f 6e 76 65 72 74 73 20 | 61 6e 20 6f 63 74 61 6c |onverts |an octal|
|000027e0| 20 6e 75 6d 62 65 72 20 | 74 6f 20 64 65 63 69 6d | number |to decim|
|000027f0| 61 6c 2e 00 43 6f 6e 76 | 65 72 74 73 20 61 6e 20 |al..Conv|erts an |
|00002800| 6f 63 74 61 6c 20 6e 75 | 6d 62 65 72 20 74 6f 20 |octal nu|mber to |
|00002810| 68 65 78 61 64 65 63 69 | 6d 61 6c 2e 00 43 6f 75 |hexadeci|mal..Cou|
|00002820| 6e 74 73 20 62 6c 61 6e | 6b 20 63 65 6c 6c 73 20 |nts blan|k cells |
|00002830| 69 6e 20 61 20 6c 69 73 | 74 20 6f 66 20 61 72 67 |in a lis|t of arg|
|00002840| 73 2e 00 52 65 74 75 72 | 6e 73 20 74 68 65 20 69 |s..Retur|ns the i|
|00002850| 6e 76 65 72 73 65 20 6f | 66 20 74 68 65 20 73 74 |nverse o|f the st|
|00002860| 61 6e 64 61 72 64 20 6e | 6f 72 6d 61 6c 20 63 75 |andard n|ormal cu|
|00002870| 6d 75 6c 61 74 69 76 65 | 20 64 69 73 74 72 69 62 |mulative| distrib|
|00002880| 75 74 69 6f 6e 20 28 68 | 61 73 20 61 20 6d 65 61 |ution (h|as a mea|
|00002890| 6e 20 6f 66 20 7a 65 72 | 6f 20 61 6e 64 20 61 20 |n of zer|o and a |
|000028a0| 73 74 61 6e 64 61 72 64 | 20 64 65 76 69 61 74 69 |standard| deviati|
|000028b0| 6f 6e 20 6f 66 20 6f 6e | 65 29 2e 00 52 65 74 75 |on of on|e)..Retu|
|000028c0| 72 6e 73 20 74 68 65 20 | 70 72 6f 62 61 62 69 6c |rns the |probabil|
|000028d0| 69 74 79 20 74 68 61 74 | 20 76 61 6c 75 65 73 20 |ity that| values |
|000028e0| 69 6e 20 61 20 72 61 6e | 67 65 20 61 72 65 20 62 |in a ran|ge are b|
|000028f0| 65 74 77 65 65 6e 20 74 | 77 6f 20 6c 69 6d 69 74 |etween t|wo limit|
|00002900| 73 20 6f 72 20 65 71 75 | 61 6c 20 74 6f 20 61 20 |s or equ|al to a |
|00002910| 6c 6f 77 65 72 20 6c 69 | 6d 69 74 2e 00 52 65 74 |lower li|mit..Ret|
|00002920| 75 72 6e 73 20 74 68 65 | 20 73 71 75 61 72 65 20 |urns the| square |
|00002930| 6f 66 20 74 68 65 20 50 | 65 61 72 73 6f 6e 20 70 |of the P|earson p|
|00002940| 72 6f 64 75 63 74 20 6d | 6f 6d 65 6e 74 20 63 6f |roduct m|oment co|
|00002950| 72 72 65 6c 61 74 69 6f | 6e 20 63 6f 65 66 66 69 |rrelatio|n coeffi|
|00002960| 63 69 65 6e 74 20 74 68 | 72 6f 75 67 68 20 74 68 |cient th|rough th|
|00002970| 65 20 67 69 76 65 6e 20 | 64 61 74 61 20 70 6f 69 |e given |data poi|
|00002980| 6e 74 73 2e 00 52 65 74 | 75 72 6e 73 20 74 68 65 |nts..Ret|urns the|
|00002990| 20 73 74 61 6e 64 61 72 | 64 20 65 72 72 6f 72 20 | standar|d error |
|000029a0| 6f 66 20 74 68 65 20 70 | 72 65 64 69 63 74 65 64 |of the p|redicted|
|000029b0| 20 79 2d 76 61 6c 75 65 | 20 66 6f 72 20 65 61 63 | y-value| for eac|
|000029c0| 68 20 78 20 69 6e 20 61 | 20 72 65 67 72 65 73 73 |h x in a| regress|
|000029d0| 69 6f 6e 2e 00 43 61 6c | 63 75 6c 61 74 65 73 20 |ion..Cal|culates |
|000029e0| 74 68 65 20 63 6f 6e 66 | 69 64 65 6e 63 65 20 69 |the conf|idence i|
|000029f0| 6e 74 65 72 76 61 6c 20 | 66 6f 72 20 61 20 70 6f |nterval |for a po|
|00002a00| 70 75 6c 61 74 69 6f 6e | 20 6d 65 61 6e 2e 00 43 |pulation| mean..C|
|00002a10| 61 6c 63 75 6c 61 74 65 | 73 20 74 68 65 20 65 78 |alculate|s the ex|
|00002a20| 70 6f 6e 65 6e 74 69 61 | 6c 20 64 69 73 74 72 69 |ponentia|l distri|
|00002a30| 62 75 74 69 6f 6e 2e 00 | 43 61 6c 63 75 6c 61 74 |bution..|Calculat|
|00002a40| 65 73 20 74 68 65 20 69 | 6e 76 65 72 73 65 20 6f |es the i|nverse o|
|00002a50| 66 20 74 68 65 20 46 69 | 73 68 65 72 20 74 72 61 |f the Fi|sher tra|
|00002a60| 6e 73 66 6f 72 6d 61 74 | 69 6f 6e 2e 00 43 61 6c |nsformat|ion..Cal|
|00002a70| 63 75 6c 61 74 65 73 20 | 74 68 65 20 46 69 73 68 |culates |the Fish|
|00002a80| 65 72 20 74 72 61 6e 73 | 66 6f 72 6d 61 74 69 6f |er trans|formatio|
|00002a90| 6e 2e 00 43 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |n..Calcu|lates th|
|00002aa0| 65 20 68 79 70 65 72 67 | 65 6f 6d 65 74 72 69 63 |e hyperg|eometric|
|00002ab0| 20 64 69 73 74 72 69 62 | 75 74 69 6f 6e 2e 00 43 | distrib|ution..C|
|00002ac0| 61 6c 63 75 6c 61 74 65 | 73 20 74 68 65 20 69 6e |alculate|s the in|
|00002ad0| 76 65 72 73 65 20 6f 66 | 20 74 68 65 20 6c 6f 67 |verse of| the log|
|00002ae0| 6e 6f 72 6d 61 6c 20 63 | 75 6d 75 6c 61 74 69 76 |normal c|umulativ|
|00002af0| 65 20 64 69 73 74 72 69 | 62 75 74 69 6f 6e 20 66 |e distri|bution f|
|00002b00| 75 6e 63 74 69 6f 6e 20 | 6f 66 20 78 2e 00 43 61 |unction |of x..Ca|
|00002b10| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 63 75 6d |lculates| the cum|
|00002b20| 75 6c 61 74 69 76 65 20 | 6c 6f 67 6e 6f 72 6d 61 |ulative |lognorma|
|00002b30| 6c 20 64 69 73 74 72 69 | 62 75 74 69 6f 6e 20 6f |l distri|bution o|
|00002b40| 66 20 78 2e 00 52 65 74 | 75 72 6e 73 20 74 68 65 |f x..Ret|urns the|
|00002b50| 20 6d 6f 73 74 20 66 72 | 65 71 75 65 6e 74 6c 79 | most fr|equently|
|00002b60| 20 6f 63 63 75 72 72 69 | 6e 67 20 76 61 6c 75 65 | occurri|ng value|
|00002b70| 20 69 6e 20 61 6e 20 72 | 61 6e 67 65 20 6f 66 20 | in an r|ange of |
|00002b80| 64 61 74 61 2e 00 52 65 | 74 75 72 6e 73 20 74 68 |data..Re|turns th|
|00002b90| 65 20 6e 65 67 61 74 69 | 76 65 20 62 69 6e 6f 6d |e negati|ve binom|
|00002ba0| 69 61 6c 20 64 69 73 74 | 72 69 62 75 74 69 6f 6e |ial dist|ribution|
|00002bb0| 2c 20 74 68 65 20 70 72 | 6f 62 61 62 69 6c 69 74 |, the pr|obabilit|
|00002bc0| 79 20 6f 66 20 61 20 73 | 70 65 63 69 66 69 63 20 |y of a s|pecific |
|00002bd0| 6e 75 6d 62 65 72 20 6f | 66 20 66 61 69 6c 73 20 |number o|f fails |
|00002be0| 62 65 66 6f 72 65 20 74 | 68 65 20 6e 74 68 20 73 |before t|he nth s|
|00002bf0| 75 63 63 65 73 73 20 6f | 63 63 75 72 73 2e 00 52 |uccess o|ccurs..R|
|00002c00| 65 74 75 72 6e 73 20 61 | 20 6e 6f 72 6d 61 6c 69 |eturns a| normali|
|00002c10| 7a 65 64 20 76 61 6c 75 | 65 20 66 72 6f 6d 20 61 |zed valu|e from a|
|00002c20| 20 64 69 73 74 72 69 62 | 75 74 69 6f 6e 20 63 68 | distrib|ution ch|
|00002c30| 61 72 61 63 74 65 72 69 | 7a 65 64 20 62 79 20 61 |aracteri|zed by a|
|00002c40| 20 6d 65 61 6e 20 61 6e | 64 20 73 74 61 6e 64 61 | mean an|d standa|
|00002c50| 72 64 20 64 65 76 69 61 | 74 69 6f 6e 2e 00 43 61 |rd devia|tion..Ca|
|00002c60| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 64 69 66 |lculates| the dif|
|00002c70| 66 65 72 65 6e 63 65 20 | 62 65 74 77 65 65 6e 20 |ference |between |
|00002c80| 74 68 65 20 73 71 75 61 | 72 65 73 20 6f 66 20 63 |the squa|res of c|
|00002c90| 6f 72 72 65 73 70 6f 6e | 64 69 6e 67 20 6e 75 6d |orrespon|ding num|
|00002ca0| 62 65 72 73 20 69 6e 20 | 74 77 6f 20 72 61 6e 67 |bers in |two rang|
|00002cb0| 65 73 20 61 6e 64 20 74 | 68 65 6e 20 72 65 74 75 |es and t|hen retu|
|00002cc0| 72 6e 73 20 74 68 65 20 | 73 75 6d 20 6f 66 20 74 |rns the |sum of t|
|00002cd0| 68 65 20 64 69 66 66 65 | 72 65 6e 63 65 73 2e 00 |he diffe|rences..|
|00002ce0| 43 61 6c 63 75 6c 61 74 | 65 73 20 74 68 65 20 73 |Calculat|es the s|
|00002cf0| 75 6d 20 6f 66 20 74 68 | 65 20 73 71 75 61 72 65 |um of th|e square|
|00002d00| 73 20 6f 66 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 |s of cor|respondi|
|00002d10| 6e 67 20 6e 75 6d 62 65 | 72 73 20 69 6e 20 74 77 |ng numbe|rs in tw|
|00002d20| 6f 20 72 61 6e 67 65 73 | 20 61 6e 64 20 74 68 65 |o ranges| and the|
|00002d30| 6e 20 72 65 74 75 72 6e | 73 20 74 68 65 20 74 6f |n return|s the to|
|00002d40| 74 61 6c 20 6f 66 20 74 | 68 65 20 73 75 6d 73 2e |tal of t|he sums.|
|00002d50| 00 52 65 74 75 72 6e 73 | 20 74 68 65 20 6d 65 61 |.Returns| the mea|
|00002d60| 6e 20 6f 66 20 74 68 65 | 20 69 6e 74 65 72 69 6f |n of the| interio|
|00002d70| 72 20 70 6f 72 74 69 6f | 6e 20 6f 66 20 61 20 73 |r portio|n of a s|
|00002d80| 65 74 20 6f 66 20 64 61 | 74 61 20 76 61 6c 75 65 |et of da|ta value|
|00002d90| 73 2e 00 43 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |s..Calcu|lates th|
|00002da0| 65 20 57 65 69 62 75 6c | 6c 20 64 69 73 74 72 69 |e Weibul|l distri|
|00002db0| 62 75 74 69 6f 6e 2e 00 | 52 65 74 75 72 6e 73 20 |bution..|Returns |
|00002dc0| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 64 61 |the numb|er of da|
|00002dd0| 79 73 20 66 72 6f 6d 20 | 74 68 65 20 62 65 67 69 |ys from |the begi|
|00002de0| 6e 6e 69 6e 67 20 6f 66 | 20 74 68 65 20 63 6f 75 |nning of| the cou|
|00002df0| 70 6f 6e 20 70 65 72 69 | 6f 64 20 74 6f 20 74 68 |pon peri|od to th|
|00002e00| 65 20 73 65 74 74 6c 65 | 6d 65 6e 74 20 64 61 74 |e settle|ment dat|
|00002e10| 65 2e 00 52 65 74 75 72 | 6e 73 20 74 68 65 20 6e |e..Retur|ns the n|
|00002e20| 75 6d 62 65 72 20 6f 66 | 20 64 61 79 73 20 69 6e |umber of| days in|
|00002e30| 20 74 68 65 20 63 6f 75 | 70 6f 6e 20 70 65 72 69 | the cou|pon peri|
|00002e40| 6f 64 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 73 |od that |contains|
|00002e50| 20 74 68 65 20 73 65 74 | 74 6c 65 6d 65 6e 74 20 | the set|tlement |
|00002e60| 64 61 74 65 2e 00 52 65 | 74 75 72 6e 73 20 74 68 |date..Re|turns th|
|00002e70| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 64 61 79 73 |e number| of days|
|00002e80| 20 66 72 6f 6d 20 74 68 | 65 20 73 65 74 74 6c 65 | from th|e settle|
|00002e90| 6d 65 6e 74 20 64 61 74 | 65 20 74 6f 20 74 68 65 |ment dat|e to the|
|00002ea0| 20 6e 65 78 74 20 63 6f | 75 70 6f 6e 20 64 61 74 | next co|upon dat|
|00002eb0| 65 2e 00 52 65 74 75 72 | 6e 73 20 74 68 65 20 6e |e..Retur|ns the n|
|00002ec0| 65 78 74 20 63 6f 75 70 | 6f 6e 20 64 61 74 65 20 |ext coup|on date |
|00002ed0| 61 66 74 65 72 20 74 68 | 65 20 73 65 74 74 6c 65 |after th|e settle|
|00002ee0| 6d 65 6e 74 20 64 61 74 | 65 2e 00 52 65 74 75 72 |ment dat|e..Retur|
|00002ef0| 6e 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |ns the n|umber of|
|00002f00| 20 63 6f 75 70 6f 6e 73 | 20 70 61 79 61 62 6c 65 | coupons| payable|
|00002f10| 20 62 65 74 77 65 65 6e | 20 74 68 65 20 73 65 74 | between| the set|
|00002f20| 74 6c 65 6d 65 6e 74 20 | 64 61 74 65 20 61 6e 64 |tlement |date and|
|00002f30| 20 6d 61 74 75 72 69 74 | 79 20 64 61 74 65 2e 00 | maturit|y date..|
|00002f40| 52 65 74 75 72 6e 73 20 | 74 68 65 20 70 72 65 76 |Returns |the prev|
|00002f50| 69 6f 75 73 20 63 6f 75 | 70 6f 6e 20 64 61 74 65 |ious cou|pon date|
|00002f60| 20 62 65 66 6f 72 65 20 | 74 68 65 20 73 65 74 74 | before |the sett|
|00002f70| 6c 65 6d 65 6e 74 20 64 | 61 74 65 2e 00 52 65 74 |lement d|ate..Ret|
|00002f80| 75 72 6e 73 20 74 68 65 | 20 64 69 73 63 6f 75 6e |urns the| discoun|
|00002f90| 74 20 72 61 74 65 20 66 | 6f 72 20 61 20 73 65 63 |t rate f|or a sec|
|00002fa0| 75 72 69 74 79 2e 00 52 | 65 74 75 72 6e 73 20 74 |urity..R|eturns t|
|00002fb0| 68 65 20 69 6e 74 65 72 | 65 73 74 20 72 61 74 65 |he inter|est rate|
|00002fc0| 20 66 6f 72 20 61 20 66 | 75 6c 6c 79 20 69 6e 76 | for a f|ully inv|
|00002fd0| 65 73 74 65 64 20 73 65 | 63 75 72 69 74 79 2e 00 |ested se|curity..|
|00002fe0| 43 61 6c 63 75 6c 61 74 | 65 73 20 70 72 69 63 65 |Calculat|es price|
|00002ff0| 20 70 65 72 20 24 31 30 | 30 20 66 61 63 65 20 76 | per $10|0 face v|
|00003000| 61 6c 75 65 20 6f 66 20 | 61 20 64 69 73 63 6f 75 |alue of |a discou|
|00003010| 6e 74 65 64 20 73 65 63 | 75 72 69 74 79 2e 00 43 |nted sec|urity..C|
|00003020| 61 6c 63 75 6c 61 74 65 | 73 20 70 72 69 63 65 20 |alculate|s price |
|00003030| 70 65 72 20 24 31 30 30 | 20 66 61 63 65 20 76 61 |per $100| face va|
|00003040| 6c 75 65 20 6f 66 20 61 | 20 73 65 63 75 72 69 74 |lue of a| securit|
|00003050| 79 20 74 68 61 74 20 70 | 61 79 73 20 69 6e 74 65 |y that p|ays inte|
|00003060| 72 65 73 74 20 61 74 20 | 6d 61 74 75 72 69 74 79 |rest at |maturity|
|00003070| 2e 00 52 65 74 75 72 6e | 73 20 74 68 65 20 61 6d |..Return|s the am|
|00003080| 6f 75 6e 74 20 72 65 63 | 65 69 76 65 64 20 61 74 |ount rec|eived at|
|00003090| 20 6d 61 74 75 72 69 74 | 79 20 66 6f 72 20 61 20 | maturit|y for a |
|000030a0| 66 75 6c 6c 79 20 69 6e | 76 65 73 74 65 64 20 73 |fully in|vested s|
|000030b0| 65 63 75 72 69 74 79 2e | 00 43 61 6c 63 75 6c 61 |ecurity.|.Calcula|
|000030c0| 74 65 73 20 74 68 65 20 | 62 6f 6e 64 2d 65 71 75 |tes the |bond-equ|
|000030d0| 69 76 61 6c 65 6e 74 20 | 79 69 65 6c 64 20 66 6f |ivalent |yield fo|
|000030e0| 72 20 61 20 54 72 65 61 | 73 75 72 79 20 62 69 6c |r a Trea|sury bil|
|000030f0| 6c 2e 00 43 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |l..Calcu|lates th|
|00003100| 65 20 70 72 69 63 65 20 | 70 65 72 20 24 31 30 30 |e price |per $100|
|00003110| 20 66 61 63 65 20 76 61 | 6c 75 65 20 66 6f 72 20 | face va|lue for |
|00003120| 61 20 54 72 65 61 73 75 | 72 79 20 62 69 6c 6c 2e |a Treasu|ry bill.|
|00003130| 00 43 61 6c 63 75 6c 61 | 74 65 73 20 74 68 65 20 |.Calcula|tes the |
|00003140| 79 69 65 6c 64 20 66 6f | 72 20 61 20 54 72 65 61 |yield fo|r a Trea|
|00003150| 73 75 72 79 20 62 69 6c | 6c 2e 00 43 61 6c 63 75 |sury bil|l..Calcu|
|00003160| 6c 61 74 65 73 20 74 68 | 65 20 66 72 61 63 74 69 |lates th|e fracti|
|00003170| 6f 6e 20 6f 66 20 74 68 | 65 20 79 65 61 72 20 62 |on of th|e year b|
|00003180| 61 73 65 64 20 6f 6e 20 | 61 20 73 74 61 72 74 20 |ased on |a start |
|00003190| 64 61 74 65 20 61 6e 64 | 20 61 6e 20 65 6e 64 20 |date and| an end |
|000031a0| 64 61 74 65 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |date..Ca|lculates|
|000031b0| 20 74 68 65 20 61 6e 6e | 75 61 6c 20 79 69 65 6c | the ann|ual yiel|
|000031c0| 64 20 66 6f 72 20 61 20 | 64 69 73 63 6f 75 6e 74 |d for a |discount|
|000031d0| 65 64 20 73 65 63 75 72 | 69 74 79 2c 20 73 75 63 |ed secur|ity, suc|
|000031e0| 68 20 61 73 20 61 20 74 | 72 65 61 73 75 72 79 20 |h as a t|reasury |
|000031f0| 62 69 6c 6c 2e 00 43 61 | 6c 63 75 6c 61 74 65 73 |bill..Ca|lculates|
|00003200| 20 74 68 65 20 61 6e 6e | 75 61 6c 20 79 69 65 6c | the ann|ual yiel|
|00003210| 64 20 6f 66 20 61 20 73 | 65 63 75 72 69 74 79 20 |d of a s|ecurity |
|00003220| 74 68 61 74 20 70 61 79 | 73 20 69 6e 74 65 72 65 |that pay|s intere|
|00003230| 73 74 20 61 74 20 6d 61 | 74 75 72 69 74 79 2e 00 |st at ma|turity..|
|00003240| 43 6f 75 6e 74 73 20 63 | 65 6c 6c 73 20 74 68 61 |Counts c|ells tha|
|00003250| 74 20 6d 65 65 74 20 61 | 20 67 69 76 65 6e 20 63 |t meet a| given c|
|00003260| 6f 6e 64 69 74 69 6f 6e | 2e 00 41 64 64 20 63 65 |ondition|..Add ce|
|00003270| 6c 6c 73 20 73 70 65 63 | 69 66 69 65 64 20 62 79 |lls spec|ified by|
|00003280| 20 61 20 67 69 76 65 6e | 20 63 6f 6e 64 69 74 69 | a given| conditi|
|00003290| 6f 6e 2e 00 43 6f 6e 76 | 65 72 74 73 20 61 20 6d |on..Conv|erts a m|
|000032a0| 65 61 73 75 72 65 6d 65 | 6e 74 20 6f 66 20 6f 6e |easureme|nt of on|
|000032b0| 65 20 6d 65 61 73 75 72 | 65 6d 65 6e 74 20 73 79 |e measur|ement sy|
|000032c0| 73 74 65 6d 20 74 6f 20 | 74 68 65 20 65 71 75 69 |stem to |the equi|
|000032d0| 76 61 6c 65 6e 74 20 69 | 6e 20 61 6e 6f 74 68 65 |valent i|n anothe|
|000032e0| 72 20 6d 65 61 73 75 72 | 65 6d 65 6e 74 20 73 79 |r measur|ement sy|
|000032f0| 73 74 65 6d 2e 00 43 6f | 6e 76 65 72 74 20 61 20 |stem..Co|nvert a |
|00003300| 75 6e 69 74 20 65 78 70 | 72 65 73 73 65 64 20 61 |unit exp|ressed a|
|00003310| 73 20 61 20 66 72 61 63 | 74 69 6f 6e 20 69 6e 74 |s a frac|tion int|
|00003320| 6f 20 61 20 64 65 63 69 | 6d 61 6c 20 61 6d 6f 75 |o a deci|mal amou|
|00003330| 6e 74 2e 00 43 6f 6e 76 | 65 72 74 20 61 20 75 6e |nt..Conv|ert a un|
|00003340| 69 74 20 65 78 70 72 65 | 73 73 65 64 20 61 73 20 |it expre|ssed as |
|00003350| 61 20 64 65 63 69 6d 61 | 6c 20 6e 75 6d 62 65 72 |a decima|l number|
|00003360| 20 69 6e 74 6f 20 61 20 | 6e 75 6d 62 65 72 20 77 | into a |number w|
|00003370| 69 74 68 20 61 20 66 72 | 61 63 74 69 6f 6e 20 70 |ith a fr|action p|
|00003380| 6f 72 74 69 6f 6e 2e 00 | 52 65 74 75 72 6e 73 20 |ortion..|Returns |
|00003390| 61 20 72 61 6e 64 6f 6d | 20 6e 75 6d 62 65 72 20 |a random| number |
|000033a0| 62 65 74 77 65 65 6e 20 | 74 68 65 20 6e 75 6d 62 |between |the numb|
|000033b0| 65 72 73 20 73 70 65 63 | 69 66 69 65 64 2e 00 52 |ers spec|ified..R|
|000033c0| 65 74 75 72 6e 73 20 74 | 68 65 20 73 68 65 65 74 |eturns t|he sheet|
|000033d0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 61 20 72 65 66 | number |of a ref|
|000033e0| 65 72 65 6e 63 65 2e 00 | 52 65 74 75 72 6e 73 20 |erence..|Returns |
|000033f0| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 6e 75 6d 62 65 |the colu|mn numbe|
|00003400| 72 20 6f 66 20 61 20 72 | 65 66 65 72 65 6e 63 65 |r of a r|eference|
|00003410| 2e 00 52 65 74 75 72 6e | 73 20 74 68 65 20 72 6f |..Return|s the ro|
|00003420| 77 20 6e 75 6d 62 65 72 | 20 6f 66 20 61 20 72 65 |w number| of a re|
|00003430| 66 65 72 65 6e 63 65 2e | 00 |ference.|. |
+--------+-------------------------+-------------------------+--------+--------+
