home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: SHell self-extracting ARchive
(archive/shar).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| dexvert
| SHell self-extracting ARchive (archive/shar)
| magic
| Supported |
| 1%
| dexvert
| Text File (text/txt)
| fallback
| Supported |
| 100%
| file
| ASCII text
| default
| |
| 100%
| checkBytes
| Printable ASCII
| default
| |
| 100%
| perlTextCheck
| Likely Text (Perl)
| default
| |
| 100%
| siegfried
| fmt/329 Shell Archive Format
| default
| |
| 100%
| detectItEasy
| Format: plain text[LF]
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4e 65 77 73 67 72 6f 75 | 70 73 3a 20 63 6f 6d 70 |Newsgrou|ps: comp|
|00000010| 2e 73 6f 75 72 63 65 73 | 2e 75 6e 69 78 0a 46 72 |.sources|.unix.Fr|
|00000020| 6f 6d 3a 20 67 72 65 67 | 40 62 72 6f 6f 6b 74 72 |om: greg|@brooktr|
|00000030| 65 65 2e 63 6f 6d 20 28 | 47 72 65 67 6f 72 79 20 |ee.com (|Gregory |
|00000040| 53 61 6e 74 6f 73 29 0a | 53 75 62 6a 65 63 74 3a |Santos).|Subject:|
|00000050| 20 76 32 37 69 30 33 31 | 3a 20 63 6f 6e 76 31 32 | v27i031|: conv12|
|00000060| 33 20 2d 20 63 6f 6e 76 | 65 72 74 20 41 53 43 49 |3 - conv|ert ASCI|
|00000070| 49 20 66 69 6c 65 73 20 | 74 6f 20 4c 6f 74 75 73 |I files |to Lotus|
|00000080| 2d 31 32 33 20 66 6f 72 | 6d 61 74 2c 20 50 61 72 |-123 for|mat, Par|
|00000090| 74 30 31 2f 30 32 0a 4d | 65 73 73 61 67 65 2d 69 |t01/02.M|essage-i|
|000000a0| 64 3a 20 3c 31 2e 37 34 | 37 32 39 32 31 36 38 2e |d: <1.74|7292168.|
|000000b0| 32 30 32 34 31 40 67 77 | 2e 68 6f 6d 65 2e 76 69 |20241@gw|.home.vi|
|000000c0| 78 2e 63 6f 6d 3e 0a 53 | 65 6e 64 65 72 3a 20 75 |x.com>.S|ender: u|
|000000d0| 6e 69 78 2d 73 6f 75 72 | 63 65 73 2d 6d 6f 64 65 |nix-sour|ces-mode|
|000000e0| 72 61 74 6f 72 40 67 77 | 2e 68 6f 6d 65 2e 76 69 |rator@gw|.home.vi|
|000000f0| 78 2e 63 6f 6d 0a 41 70 | 70 72 6f 76 65 64 3a 20 |x.com.Ap|proved: |
|00000100| 76 69 78 69 65 40 67 77 | 2e 68 6f 6d 65 2e 76 69 |vixie@gw|.home.vi|
|00000110| 78 2e 63 6f 6d 0a 0a 53 | 75 62 6d 69 74 74 65 64 |x.com..S|ubmitted|
|00000120| 2d 42 79 3a 20 67 72 65 | 67 40 62 72 6f 6f 6b 74 |-By: gre|g@brookt|
|00000130| 72 65 65 2e 63 6f 6d 20 | 28 47 72 65 67 6f 72 79 |ree.com |(Gregory|
|00000140| 20 53 61 6e 74 6f 73 29 | 0a 50 6f 73 74 69 6e 67 | Santos)|.Posting|
|00000150| 2d 4e 75 6d 62 65 72 3a | 20 56 6f 6c 75 6d 65 20 |-Number:| Volume |
|00000160| 32 37 2c 20 49 73 73 75 | 65 20 33 31 0a 41 72 63 |27, Issu|e 31.Arc|
|00000170| 68 69 76 65 2d 4e 61 6d | 65 3a 20 63 6f 6e 76 31 |hive-Nam|e: conv1|
|00000180| 32 33 2f 70 61 72 74 30 | 31 0a 0a 23 21 20 2f 62 |23/part0|1..#! /b|
|00000190| 69 6e 2f 73 68 0a 23 20 | 54 68 69 73 20 69 73 20 |in/sh.# |This is |
|000001a0| 61 20 73 68 65 6c 6c 20 | 61 72 63 68 69 76 65 2e |a shell |archive.|
|000001b0| 20 20 52 65 6d 6f 76 65 | 20 61 6e 79 74 68 69 6e | Remove| anythin|
|000001c0| 67 20 62 65 66 6f 72 65 | 20 74 68 69 73 20 6c 69 |g before| this li|
|000001d0| 6e 65 2c 20 74 68 65 6e | 20 75 6e 70 61 63 6b 0a |ne, then| unpack.|
|000001e0| 23 20 69 74 20 62 79 20 | 73 61 76 69 6e 67 20 69 |# it by |saving i|
|000001f0| 74 20 69 6e 74 6f 20 61 | 20 66 69 6c 65 20 61 6e |t into a| file an|
|00000200| 64 20 74 79 70 69 6e 67 | 20 22 73 68 20 66 69 6c |d typing| "sh fil|
|00000210| 65 22 2e 20 20 54 6f 20 | 6f 76 65 72 77 72 69 74 |e". To |overwrit|
|00000220| 65 20 65 78 69 73 74 69 | 6e 67 0a 23 20 66 69 6c |e existi|ng.# fil|
|00000230| 65 73 2c 20 74 79 70 65 | 20 22 73 68 20 66 69 6c |es, type| "sh fil|
|00000240| 65 20 2d 63 22 2e 20 20 | 59 6f 75 20 63 61 6e 20 |e -c". |You can |
|00000250| 61 6c 73 6f 20 66 65 65 | 64 20 74 68 69 73 20 61 |also fee|d this a|
|00000260| 73 20 73 74 61 6e 64 61 | 72 64 20 69 6e 70 75 74 |s standa|rd input|
|00000270| 20 76 69 61 0a 23 20 75 | 6e 73 68 61 72 2c 20 6f | via.# u|nshar, o|
|00000280| 72 20 62 79 20 74 79 70 | 69 6e 67 20 22 73 68 20 |r by typ|ing "sh |
|00000290| 3c 66 69 6c 65 22 2c 20 | 65 2e 67 2e 2e 20 20 49 |<file", |e.g.. I|
|000002a0| 66 20 74 68 69 73 20 61 | 72 63 68 69 76 65 20 69 |f this a|rchive i|
|000002b0| 73 20 63 6f 6d 70 6c 65 | 74 65 2c 20 79 6f 75 0a |s comple|te, you.|
|000002c0| 23 20 77 69 6c 6c 20 73 | 65 65 20 74 68 65 20 66 |# will s|ee the f|
|000002d0| 6f 6c 6c 6f 77 69 6e 67 | 20 6d 65 73 73 61 67 65 |ollowing| message|
|000002e0| 20 61 74 20 74 68 65 20 | 65 6e 64 3a 0a 23 09 09 | at the |end:.#..|
|000002f0| 22 45 6e 64 20 6f 66 20 | 61 72 63 68 69 76 65 20 |"End of |archive |
|00000300| 31 20 28 6f 66 20 32 29 | 2e 22 0a 23 20 43 6f 6e |1 (of 2)|.".# Con|
|00000310| 74 65 6e 74 73 3a 20 20 | 4d 41 4e 49 46 45 53 54 |tents: |MANIFEST|
|00000320| 20 4d 61 6b 65 66 69 6c | 65 20 52 45 41 44 4d 45 | Makefil|e README|
|00000330| 20 63 6f 6e 76 31 32 33 | 2e 31 20 63 6f 6e 76 31 | conv123|.1 conv1|
|00000340| 32 33 2e 64 6f 63 20 67 | 72 70 68 31 32 33 2e 31 |23.doc g|rph123.1|
|00000350| 0a 23 20 20 20 67 72 70 | 68 31 32 33 2e 64 6f 63 |.# grp|h123.doc|
|00000360| 20 69 6e 74 32 73 2e 63 | 20 6c 6f 74 75 73 2e 68 | int2s.c| lotus.h|
|00000370| 20 73 32 69 6e 74 2e 63 | 20 73 77 61 70 62 2e 63 | s2int.c| swapb.c|
|00000380| 20 73 77 61 70 62 2e 68 | 0a 23 20 57 72 61 70 70 | swapb.h|.# Wrapp|
|00000390| 65 64 20 62 79 20 76 69 | 78 69 65 40 67 77 2e 68 |ed by vi|xie@gw.h|
|000003a0| 6f 6d 65 2e 76 69 78 2e | 63 6f 6d 20 6f 6e 20 53 |ome.vix.|com on S|
|000003b0| 75 6e 20 53 65 70 20 20 | 35 20 32 32 3a 30 38 3a |un Sep |5 22:08:|
|000003c0| 35 36 20 31 39 39 33 0a | 50 41 54 48 3d 2f 62 69 |56 1993.|PATH=/bi|
|000003d0| 6e 3a 2f 75 73 72 2f 62 | 69 6e 3a 2f 75 73 72 2f |n:/usr/b|in:/usr/|
|000003e0| 75 63 62 20 3b 20 65 78 | 70 6f 72 74 20 50 41 54 |ucb ; ex|port PAT|
|000003f0| 48 0a 69 66 20 74 65 73 | 74 20 2d 66 20 27 4d 41 |H.if tes|t -f 'MA|
|00000400| 4e 49 46 45 53 54 27 20 | 2d 61 20 22 24 7b 31 7d |NIFEST' |-a "${1}|
|00000410| 22 20 21 3d 20 22 2d 63 | 22 20 3b 20 74 68 65 6e |" != "-c|" ; then|
|00000420| 20 0a 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 57 | . echo| shar: W|
|00000430| 69 6c 6c 20 6e 6f 74 20 | 63 6c 6f 62 62 65 72 20 |ill not |clobber |
|00000440| 65 78 69 73 74 69 6e 67 | 20 66 69 6c 65 20 5c 22 |existing| file \"|
|00000450| 27 4d 41 4e 49 46 45 53 | 54 27 5c 22 0a 65 6c 73 |'MANIFES|T'\".els|
|00000460| 65 0a 65 63 68 6f 20 73 | 68 61 72 3a 20 45 78 74 |e.echo s|har: Ext|
|00000470| 72 61 63 74 69 6e 67 20 | 5c 22 27 4d 41 4e 49 46 |racting |\"'MANIF|
|00000480| 45 53 54 27 5c 22 20 5c | 28 35 33 30 20 63 68 61 |EST'\" \|(530 cha|
|00000490| 72 61 63 74 65 72 73 5c | 29 0a 73 65 64 20 22 73 |racters\|).sed "s|
|000004a0| 2f 5e 58 2f 2f 22 20 3e | 27 4d 41 4e 49 46 45 53 |/^X//" >|'MANIFES|
|000004b0| 54 27 20 3c 3c 27 45 4e | 44 5f 4f 46 5f 46 49 4c |T' <<'EN|D_OF_FIL|
|000004c0| 45 27 0a 58 20 20 20 46 | 69 6c 65 20 4e 61 6d 65 |E'.X F|ile Name|
|000004d0| 09 09 41 72 63 68 69 76 | 65 20 23 09 44 65 73 63 |..Archiv|e #.Desc|
|000004e0| 72 69 70 74 69 6f 6e 0a | 58 2d 2d 2d 2d 2d 2d 2d |ription.|X-------|
|000004f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000500| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000510| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000520| 2d 2d 2d 2d 0a 58 20 4d | 41 4e 49 46 45 53 54 20 |----.X M|ANIFEST |
|00000530| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000540| 20 20 31 09 0a 58 20 4d | 61 6b 65 66 69 6c 65 20 | 1..X M|akefile |
|00000550| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000560| 20 20 31 09 0a 58 20 52 | 45 41 44 4d 45 20 20 20 | 1..X R|EADME |
|00000570| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000580| 20 20 31 09 0a 58 20 63 | 6f 6e 76 31 32 33 2e 31 | 1..X c|onv123.1|
|00000590| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000005a0| 20 20 31 09 0a 58 20 63 | 6f 6e 76 31 32 33 2e 63 | 1..X c|onv123.c|
|000005b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000005c0| 20 20 32 09 0a 58 20 63 | 6f 6e 76 31 32 33 2e 64 | 2..X c|onv123.d|
|000005d0| 6f 63 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |oc | |
|000005e0| 20 20 31 09 0a 58 20 67 | 72 70 68 31 32 33 2e 31 | 1..X g|rph123.1|
|000005f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000600| 20 20 31 09 0a 58 20 67 | 72 70 68 31 32 33 2e 63 | 1..X g|rph123.c|
|00000610| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000620| 20 20 32 09 0a 58 20 67 | 72 70 68 31 32 33 2e 64 | 2..X g|rph123.d|
|00000630| 6f 63 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |oc | |
|00000640| 20 20 31 09 0a 58 20 69 | 6e 74 32 73 2e 63 20 20 | 1..X i|nt2s.c |
|00000650| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000660| 20 20 31 09 0a 58 20 6c | 6f 74 75 73 2e 68 20 20 | 1..X l|otus.h |
|00000670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000680| 20 20 31 09 0a 58 20 73 | 32 69 6e 74 2e 63 20 20 | 1..X s|2int.c |
|00000690| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000006a0| 20 20 31 09 0a 58 20 73 | 77 61 70 62 2e 63 20 20 | 1..X s|wapb.c |
|000006b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000006c0| 20 20 31 09 0a 58 20 73 | 77 61 70 62 2e 68 20 20 | 1..X s|wapb.h |
|000006d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000006e0| 20 20 31 09 0a 45 4e 44 | 5f 4f 46 5f 46 49 4c 45 | 1..END|_OF_FILE|
|000006f0| 0a 69 66 20 74 65 73 74 | 20 35 33 30 20 2d 6e 65 |.if test| 530 -ne|
|00000700| 20 60 77 63 20 2d 63 20 | 3c 27 4d 41 4e 49 46 45 | `wc -c |<'MANIFE|
|00000710| 53 54 27 60 3b 20 74 68 | 65 6e 0a 20 20 20 20 65 |ST'`; th|en. e|
|00000720| 63 68 6f 20 73 68 61 72 | 3a 20 5c 22 27 4d 41 4e |cho shar|: \"'MAN|
|00000730| 49 46 45 53 54 27 5c 22 | 20 75 6e 70 61 63 6b 65 |IFEST'\"| unpacke|
|00000740| 64 20 77 69 74 68 20 77 | 72 6f 6e 67 20 73 69 7a |d with w|rong siz|
|00000750| 65 21 0a 66 69 0a 23 20 | 65 6e 64 20 6f 66 20 27 |e!.fi.# |end of '|
|00000760| 4d 41 4e 49 46 45 53 54 | 27 0a 66 69 0a 69 66 20 |MANIFEST|'.fi.if |
|00000770| 74 65 73 74 20 2d 66 20 | 27 4d 61 6b 65 66 69 6c |test -f |'Makefil|
|00000780| 65 27 20 2d 61 20 22 24 | 7b 31 7d 22 20 21 3d 20 |e' -a "$|{1}" != |
|00000790| 22 2d 63 22 20 3b 20 74 | 68 65 6e 20 0a 20 20 65 |"-c" ; t|hen . e|
|000007a0| 63 68 6f 20 73 68 61 72 | 3a 20 57 69 6c 6c 20 6e |cho shar|: Will n|
|000007b0| 6f 74 20 63 6c 6f 62 62 | 65 72 20 65 78 69 73 74 |ot clobb|er exist|
|000007c0| 69 6e 67 20 66 69 6c 65 | 20 5c 22 27 4d 61 6b 65 |ing file| \"'Make|
|000007d0| 66 69 6c 65 27 5c 22 0a | 65 6c 73 65 0a 65 63 68 |file'\".|else.ech|
|000007e0| 6f 20 73 68 61 72 3a 20 | 45 78 74 72 61 63 74 69 |o shar: |Extracti|
|000007f0| 6e 67 20 5c 22 27 4d 61 | 6b 65 66 69 6c 65 27 5c |ng \"'Ma|kefile'\|
|00000800| 22 20 5c 28 37 36 30 20 | 63 68 61 72 61 63 74 65 |" \(760 |characte|
|00000810| 72 73 5c 29 0a 73 65 64 | 20 22 73 2f 5e 58 2f 2f |rs\).sed| "s/^X//|
|00000820| 22 20 3e 27 4d 61 6b 65 | 66 69 6c 65 27 20 3c 3c |" >'Make|file' <<|
|00000830| 27 45 4e 44 5f 4f 46 5f | 46 49 4c 45 27 0a 58 42 |'END_OF_|FILE'.XB|
|00000840| 49 4e 44 49 52 20 3d 20 | 2f 75 73 72 2f 6c 6f 63 |INDIR = |/usr/loc|
|00000850| 61 6c 2f 62 69 6e 0a 58 | 4d 41 4e 44 49 52 20 3d |al/bin.X|MANDIR =|
|00000860| 20 2f 75 73 72 2f 6c 6f | 63 61 6c 2f 6d 61 6e 2f | /usr/lo|cal/man/|
|00000870| 6d 61 6e 31 0a 58 4f 42 | 4a 45 43 54 53 31 20 3d |man1.XOB|JECTS1 =|
|00000880| 20 63 6f 6e 76 31 32 33 | 2e 6f 20 69 6e 74 32 73 | conv123|.o int2s|
|00000890| 2e 6f 20 73 32 69 6e 74 | 2e 6f 0a 58 4f 42 4a 45 |.o s2int|.o.XOBJE|
|000008a0| 43 54 53 32 20 3d 20 67 | 72 70 68 31 32 33 2e 6f |CTS2 = g|rph123.o|
|000008b0| 20 69 6e 74 32 73 2e 6f | 20 73 32 69 6e 74 2e 6f | int2s.o| s2int.o|
|000008c0| 0a 58 43 46 4c 41 47 53 | 20 3d 20 2d 4f 0a 58 4c |.XCFLAGS| = -O.XL|
|000008d0| 44 46 4c 41 47 53 20 3d | 0a 58 0a 58 61 6c 6c 3a |DFLAGS =|.X.Xall:|
|000008e0| 09 63 31 32 33 20 67 31 | 32 33 0a 58 0a 58 63 31 |.c123 g1|23.X.Xc1|
|000008f0| 32 33 3a 20 24 28 4f 42 | 4a 45 43 54 53 31 29 0a |23: $(OB|JECTS1).|
|00000900| 58 09 63 63 20 24 28 43 | 46 4c 41 47 53 29 20 24 |X.cc $(C|FLAGS) $|
|00000910| 28 4f 42 4a 45 43 54 53 | 31 29 20 2d 6f 20 63 6f |(OBJECTS|1) -o co|
|00000920| 6e 76 31 32 33 20 24 28 | 4c 44 46 4c 41 47 53 29 |nv123 $(|LDFLAGS)|
|00000930| 0a 58 09 63 68 6d 6f 64 | 20 37 35 35 20 2e 2f 63 |.X.chmod| 755 ./c|
|00000940| 6f 6e 76 31 32 33 0a 58 | 0a 58 67 31 32 33 3a 20 |onv123.X|.Xg123: |
|00000950| 24 28 4f 42 4a 45 43 54 | 53 32 29 0a 58 09 63 63 |$(OBJECT|S2).X.cc|
|00000960| 20 24 28 43 46 4c 41 47 | 53 29 20 24 28 4f 42 4a | $(CFLAG|S) $(OBJ|
|00000970| 45 43 54 53 32 29 20 2d | 6f 20 67 72 70 68 31 32 |ECTS2) -|o grph12|
|00000980| 33 20 24 28 4c 44 46 4c | 41 47 53 29 0a 58 09 63 |3 $(LDFL|AGS).X.c|
|00000990| 68 6d 6f 64 20 37 35 35 | 20 2e 2f 67 72 70 68 31 |hmod 755| ./grph1|
|000009a0| 32 33 0a 58 0a 58 63 6c | 65 61 6e 3a 0a 58 09 72 |23.X.Xcl|ean:.X.r|
|000009b0| 6d 20 2d 66 20 2e 2f 63 | 6f 6e 76 31 32 33 2e 6f |m -f ./c|onv123.o|
|000009c0| 0a 58 09 72 6d 20 2d 66 | 20 2e 2f 67 72 70 68 31 |.X.rm -f| ./grph1|
|000009d0| 32 33 2e 6f 0a 58 09 72 | 6d 20 2d 66 20 2e 2f 69 |23.o.X.r|m -f ./i|
|000009e0| 6e 74 32 73 2e 6f 0a 58 | 09 72 6d 20 2d 66 20 2e |nt2s.o.X|.rm -f .|
|000009f0| 2f 73 32 69 6e 74 2e 6f | 0a 58 09 72 6d 20 2d 66 |/s2int.o|.X.rm -f|
|00000a00| 20 2e 2f 63 6f 6e 76 31 | 32 33 0a 58 09 72 6d 20 | ./conv1|23.X.rm |
|00000a10| 2d 66 20 2e 2f 67 72 70 | 68 31 32 33 0a 58 0a 58 |-f ./grp|h123.X.X|
|00000a20| 69 6e 73 74 61 6c 6c 3a | 0a 58 09 63 70 20 2e 2f |install:|.X.cp ./|
|00000a30| 63 6f 6e 76 31 32 33 20 | 24 28 42 49 4e 44 49 52 |conv123 |$(BINDIR|
|00000a40| 29 0a 58 09 63 70 20 2e | 2f 67 72 70 68 31 32 33 |).X.cp .|/grph123|
|00000a50| 20 24 28 42 49 4e 44 49 | 52 29 0a 58 09 63 70 20 | $(BINDI|R).X.cp |
|00000a60| 2e 2f 63 6f 6e 76 31 32 | 33 2e 31 20 24 28 4d 41 |./conv12|3.1 $(MA|
|00000a70| 4e 44 49 52 29 0a 58 09 | 63 70 20 2e 2f 67 72 70 |NDIR).X.|cp ./grp|
|00000a80| 68 31 32 33 2e 31 20 24 | 28 4d 41 4e 44 49 52 29 |h123.1 $|(MANDIR)|
|00000a90| 0a 58 0a 58 75 6e 69 6e | 73 74 61 6c 6c 3a 0a 58 |.X.Xunin|stall:.X|
|00000aa0| 09 72 6d 20 2d 66 20 24 | 28 42 49 4e 44 49 52 29 |.rm -f $|(BINDIR)|
|00000ab0| 2f 63 6f 6e 76 31 32 33 | 0a 58 09 72 6d 20 2d 66 |/conv123|.X.rm -f|
|00000ac0| 20 24 28 42 49 4e 44 49 | 52 29 2f 67 72 70 68 31 | $(BINDI|R)/grph1|
|00000ad0| 32 33 0a 58 09 72 6d 20 | 2d 66 20 24 28 4d 41 4e |23.X.rm |-f $(MAN|
|00000ae0| 44 49 52 29 2f 63 6f 6e | 76 31 32 33 2e 31 0a 58 |DIR)/con|v123.1.X|
|00000af0| 09 72 6d 20 2d 66 20 24 | 28 4d 41 4e 44 49 52 29 |.rm -f $|(MANDIR)|
|00000b00| 2f 67 72 70 68 31 32 33 | 2e 31 0a 58 0a 58 24 28 |/grph123|.1.X.X$(|
|00000b10| 4f 42 4a 45 43 54 53 31 | 29 3a 20 63 6f 6e 76 31 |OBJECTS1|): conv1|
|00000b20| 32 33 2e 63 20 69 6e 74 | 32 73 2e 63 20 73 32 69 |23.c int|2s.c s2i|
|00000b30| 6e 74 2e 63 0a 58 24 28 | 4f 42 4a 45 43 54 53 32 |nt.c.X$(|OBJECTS2|
|00000b40| 29 3a 20 67 72 70 68 31 | 32 33 2e 63 20 69 6e 74 |): grph1|23.c int|
|00000b50| 32 73 2e 63 20 73 32 69 | 6e 74 2e 63 0a 45 4e 44 |2s.c s2i|nt.c.END|
|00000b60| 5f 4f 46 5f 46 49 4c 45 | 0a 69 66 20 74 65 73 74 |_OF_FILE|.if test|
|00000b70| 20 37 36 30 20 2d 6e 65 | 20 60 77 63 20 2d 63 20 | 760 -ne| `wc -c |
|00000b80| 3c 27 4d 61 6b 65 66 69 | 6c 65 27 60 3b 20 74 68 |<'Makefi|le'`; th|
|00000b90| 65 6e 0a 20 20 20 20 65 | 63 68 6f 20 73 68 61 72 |en. e|cho shar|
|00000ba0| 3a 20 5c 22 27 4d 61 6b | 65 66 69 6c 65 27 5c 22 |: \"'Mak|efile'\"|
|00000bb0| 20 75 6e 70 61 63 6b 65 | 64 20 77 69 74 68 20 77 | unpacke|d with w|
|00000bc0| 72 6f 6e 67 20 73 69 7a | 65 21 0a 66 69 0a 23 20 |rong siz|e!.fi.# |
|00000bd0| 65 6e 64 20 6f 66 20 27 | 4d 61 6b 65 66 69 6c 65 |end of '|Makefile|
|00000be0| 27 0a 66 69 0a 69 66 20 | 74 65 73 74 20 2d 66 20 |'.fi.if |test -f |
|00000bf0| 27 52 45 41 44 4d 45 27 | 20 2d 61 20 22 24 7b 31 |'README'| -a "${1|
|00000c00| 7d 22 20 21 3d 20 22 2d | 63 22 20 3b 20 74 68 65 |}" != "-|c" ; the|
|00000c10| 6e 20 0a 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |n . ech|o shar: |
|00000c20| 57 69 6c 6c 20 6e 6f 74 | 20 63 6c 6f 62 62 65 72 |Will not| clobber|
|00000c30| 20 65 78 69 73 74 69 6e | 67 20 66 69 6c 65 20 5c | existin|g file \|
|00000c40| 22 27 52 45 41 44 4d 45 | 27 5c 22 0a 65 6c 73 65 |"'README|'\".else|
|00000c50| 0a 65 63 68 6f 20 73 68 | 61 72 3a 20 45 78 74 72 |.echo sh|ar: Extr|
|00000c60| 61 63 74 69 6e 67 20 5c | 22 27 52 45 41 44 4d 45 |acting \|"'README|
|00000c70| 27 5c 22 20 5c 28 31 39 | 35 35 20 63 68 61 72 61 |'\" \(19|55 chara|
|00000c80| 63 74 65 72 73 5c 29 0a | 73 65 64 20 22 73 2f 5e |cters\).|sed "s/^|
|00000c90| 58 2f 2f 22 20 3e 27 52 | 45 41 44 4d 45 27 20 3c |X//" >'R|EADME' <|
|00000ca0| 3c 27 45 4e 44 5f 4f 46 | 5f 46 49 4c 45 27 0a 58 |<'END_OF|_FILE'.X|
|00000cb0| 0a 58 63 6f 6e 76 31 32 | 33 2c 20 67 72 70 68 31 |.Xconv12|3, grph1|
|00000cc0| 32 33 20 20 39 20 41 75 | 67 20 31 39 39 33 20 2d |23 9 Au|g 1993 -|
|00000cd0| 2d 20 67 73 73 0a 58 0a | 58 63 6f 6e 76 31 32 33 |- gss.X.|Xconv123|
|00000ce0| 20 69 73 20 61 20 75 74 | 69 6c 69 74 79 20 66 6f | is a ut|ility fo|
|00000cf0| 72 20 63 72 65 61 74 69 | 6e 67 20 61 20 62 69 6e |r creati|ng a bin|
|00000d00| 61 72 79 2d 72 65 61 64 | 79 20 73 70 72 65 61 64 |ary-read|y spread|
|00000d10| 73 68 65 65 74 0a 58 74 | 68 61 74 20 63 61 6e 20 |sheet.Xt|hat can |
|00000d20| 62 65 20 72 65 61 64 20 | 69 6e 20 64 69 72 65 63 |be read |in direc|
|00000d30| 74 6c 79 20 62 79 20 4c | 6f 74 75 73 2f 31 32 33 |tly by L|otus/123|
|00000d40| 28 54 4d 29 20 6f 72 20 | 70 72 6f 67 72 61 6d 73 |(TM) or |programs|
|00000d50| 0a 58 74 68 61 74 20 63 | 61 6e 20 72 65 61 64 20 |.Xthat c|an read |
|00000d60| 4c 6f 74 75 73 2f 31 32 | 33 28 54 4d 29 20 73 70 |Lotus/12|3(TM) sp|
|00000d70| 72 65 61 64 73 68 65 65 | 74 73 2e 20 20 49 74 20 |readshee|ts. It |
|00000d80| 67 72 65 77 20 6f 75 74 | 20 6f 66 0a 58 74 68 65 |grew out| of.Xthe|
|00000d90| 20 6e 65 65 64 20 74 6f | 20 74 61 6b 65 20 6f 75 | need to| take ou|
|00000da0| 72 20 63 6f 72 70 6f 72 | 61 74 65 20 64 61 74 61 |r corpor|ate data|
|00000db0| 20 61 6e 64 20 64 65 6c | 69 76 65 72 20 69 74 20 | and del|iver it |
|00000dc0| 61 73 20 61 0a 58 6b 69 | 6e 64 20 6f 66 20 69 6e |as a.Xki|nd of in|
|00000dd0| 65 78 70 65 6e 73 69 76 | 65 20 22 65 78 65 63 75 |expensiv|e "execu|
|00000de0| 74 69 76 65 20 69 6e 66 | 6f 72 6d 61 74 69 6f 6e |tive inf|ormation|
|00000df0| 20 73 79 73 74 65 6d 22 | 20 74 6f 0a 58 6d 69 63 | system"| to.Xmic|
|00000e00| 72 6f 2d 63 6f 6d 70 75 | 74 65 72 73 20 74 68 61 |ro-compu|ters tha|
|00000e10| 74 20 68 61 64 20 62 65 | 65 6e 20 6e 65 74 77 6f |t had be|en netwo|
|00000e20| 72 6b 65 64 20 74 6f 67 | 65 74 68 65 72 2c 20 77 |rked tog|ether, w|
|00000e30| 68 65 6e 20 69 74 0a 58 | 77 61 73 20 72 65 61 6c |hen it.X|was real|
|00000e40| 69 7a 65 64 20 74 68 61 | 74 20 74 68 65 20 73 74 |ized tha|t the st|
|00000e50| 61 6e 64 61 72 64 20 22 | 69 6d 70 6f 72 74 22 20 |andard "|import" |
|00000e60| 66 75 6e 63 74 69 6f 6e | 20 75 73 65 64 20 74 6f |function| used to|
|00000e70| 0a 58 72 65 61 64 20 41 | 53 43 49 49 20 64 61 74 |.Xread A|SCII dat|
|00000e80| 61 20 66 69 6c 65 73 20 | 77 61 73 20 74 6f 6f 20 |a files |was too |
|00000e90| 72 65 73 74 72 69 63 74 | 69 6e 67 2e 0a 58 0a 58 |restrict|ing..X.X|
|00000ea0| 49 74 20 69 73 20 68 6f | 70 65 64 20 74 68 61 74 |It is ho|ped that|
|00000eb0| 20 74 68 65 20 73 74 72 | 61 69 67 68 74 66 6f 72 | the str|aightfor|
|00000ec0| 77 61 72 64 20 41 53 43 | 49 49 20 69 6e 70 75 74 |ward ASC|II input|
|00000ed0| 20 66 69 6c 65 20 66 6f | 72 6d 61 74 2c 0a 58 64 | file fo|rmat,.Xd|
|00000ee0| 65 73 69 67 6e 65 64 20 | 66 6f 72 20 75 73 65 20 |esigned |for use |
|00000ef0| 77 69 74 68 20 61 20 72 | 65 70 6f 72 74 20 77 72 |with a r|eport wr|
|00000f00| 69 74 65 72 2c 20 77 69 | 6c 6c 20 62 65 20 73 75 |iter, wi|ll be su|
|00000f10| 69 74 61 62 6c 65 20 66 | 6f 72 0a 58 6d 6f 73 74 |itable f|or.Xmost|
|00000f20| 20 64 61 74 61 2d 67 65 | 6e 65 72 61 74 69 6e 67 | data-ge|nerating|
|00000f30| 20 6d 65 74 68 6f 64 73 | 2c 20 69 6e 63 6c 75 64 | methods|, includ|
|00000f40| 69 6e 67 20 33 72 64 20 | 61 6e 64 20 34 74 68 20 |ing 3rd |and 4th |
|00000f50| 67 65 6e 65 72 61 74 69 | 6f 6e 0a 58 6c 61 6e 67 |generati|on.Xlang|
|00000f60| 75 61 67 65 73 2e 0a 58 | 0a 58 54 68 69 73 20 64 |uages..X|.XThis d|
|00000f70| 69 73 74 72 69 62 75 74 | 69 6f 6e 20 61 6c 73 6f |istribut|ion also|
|00000f80| 20 69 6e 63 6c 75 64 65 | 73 20 67 72 70 68 31 32 | include|s grph12|
|00000f90| 33 2c 20 77 68 69 63 68 | 20 70 72 6f 64 75 63 65 |3, which| produce|
|00000fa0| 73 20 61 20 4c 6f 74 75 | 73 28 54 4d 29 0a 58 22 |s a Lotu|s(TM).X"|
|00000fb0| 6e 61 6d 65 64 20 67 72 | 61 70 68 22 20 66 69 6c |named gr|aph" fil|
|00000fc0| 65 2e 20 20 41 6c 74 68 | 6f 75 67 68 20 72 65 71 |e. Alth|ough req|
|00000fd0| 75 69 72 69 6e 67 20 61 | 20 64 69 66 66 65 72 65 |uiring a| differe|
|00000fe0| 6e 74 20 69 6e 70 75 74 | 20 66 69 6c 65 0a 58 66 |nt input| file.Xf|
|00000ff0| 6f 72 6d 61 74 2c 20 74 | 68 69 73 20 75 74 69 6c |ormat, t|his util|
|00001000| 69 74 79 20 63 61 6e 20 | 62 65 20 71 75 69 74 65 |ity can |be quite|
|00001010| 20 75 73 65 66 75 6c 2c | 20 70 65 72 6d 69 74 74 | useful,| permitt|
|00001020| 69 6e 67 20 61 73 20 69 | 74 20 64 6f 65 73 0a 58 |ing as i|t does.X|
|00001030| 74 68 65 20 63 72 65 61 | 74 69 6f 6e 20 6f 66 20 |the crea|tion of |
|00001040| 70 72 65 2d 66 6f 72 6d | 61 74 74 65 64 20 67 72 |pre-form|atted gr|
|00001050| 61 70 68 20 69 6e 73 74 | 72 75 63 74 69 6f 6e 73 |aph inst|ructions|
|00001060| 20 66 6f 72 20 4c 6f 74 | 75 73 2f 31 32 33 28 54 | for Lot|us/123(T|
|00001070| 4d 29 2c 0a 58 61 6e 64 | 20 61 6c 73 6f 20 66 6f |M),.Xand| also fo|
|00001080| 72 20 74 68 6f 73 65 20 | 70 72 6f 67 72 61 6d 73 |r those |programs|
|00001090| 20 63 61 70 61 62 6c 65 | 20 6f 66 20 69 6e 74 65 | capable| of inte|
|000010a0| 72 70 72 65 74 69 6e 67 | 20 73 75 63 68 20 69 6e |rpreting| such in|
|000010b0| 66 6f 72 6d 61 74 69 6f | 6e 0a 58 28 65 2e 67 2e |formatio|n.X(e.g.|
|000010c0| 2c 20 45 78 63 65 6c 28 | 54 4d 29 29 2e 0a 58 0a |, Excel(|TM))..X.|
|000010d0| 58 54 68 65 20 75 74 69 | 6c 69 74 69 65 73 20 61 |XThe uti|lities a|
|000010e0| 72 65 20 66 61 69 72 6c | 79 20 73 69 6d 70 6c 65 |re fairl|y simple|
|000010f0| 2c 20 63 75 72 72 65 6e | 74 6c 79 20 73 75 70 70 |, curren|tly supp|
|00001100| 6f 72 74 69 6e 67 20 6e | 6f 20 6f 70 74 69 6f 6e |orting n|o option|
|00001110| 73 2c 20 61 6e 64 0a 58 | 61 66 74 65 72 20 75 6e |s, and.X|after un|
|00001120| 70 61 63 6b 69 6e 67 2c | 20 73 68 6f 75 6c 64 20 |packing,| should |
|00001130| 6a 75 73 74 20 72 65 71 | 75 69 72 65 20 61 20 73 |just req|uire a s|
|00001140| 69 6d 70 6c 65 20 22 6d | 61 6b 65 22 20 74 6f 20 |imple "m|ake" to |
|00001150| 63 72 65 61 74 65 2e 0a | 58 59 6f 75 20 6d 61 79 |create..|XYou may|
|00001160| 20 77 61 6e 74 20 74 6f | 20 65 64 69 74 20 74 68 | want to| edit th|
|00001170| 65 20 4d 61 6b 65 66 69 | 6c 65 20 66 6f 72 20 63 |e Makefi|le for c|
|00001180| 6f 6d 70 69 6c 65 72 20 | 66 6c 61 67 73 2c 20 6f |ompiler |flags, o|
|00001190| 72 20 66 6f 72 20 74 61 | 72 67 65 74 0a 58 64 69 |r for ta|rget.Xdi|
|000011a0| 72 65 63 74 6f 72 79 20 | 69 6e 66 6f 72 6d 61 74 |rectory |informat|
|000011b0| 69 6f 6e 20 28 22 42 49 | 4e 44 49 52 22 20 61 6e |ion ("BI|NDIR" an|
|000011c0| 64 20 22 4d 41 4e 44 49 | 52 22 20 76 61 72 69 61 |d "MANDI|R" varia|
|000011d0| 62 6c 65 73 29 20 69 66 | 20 79 6f 75 20 69 6e 74 |bles) if| you int|
|000011e0| 65 6e 64 0a 58 74 6f 20 | 22 6d 61 6b 65 20 69 6e |end.Xto |"make in|
|000011f0| 73 74 61 6c 6c 2e 22 0a | 58 0a 58 63 6f 6e 76 31 |stall.".|X.Xconv1|
|00001200| 32 33 20 63 61 6e 20 62 | 65 20 75 73 65 64 20 61 |23 can b|e used a|
|00001210| 73 20 61 20 66 69 6c 74 | 65 72 20 28 69 2e 65 2e |s a filt|er (i.e.|
|00001220| 2c 20 73 74 64 69 6e 20 | 6f 72 20 73 74 64 6f 75 |, stdin |or stdou|
|00001230| 74 20 72 65 64 69 72 65 | 63 74 65 64 29 2c 0a 58 |t redire|cted),.X|
|00001240| 61 6c 74 68 6f 75 67 68 | 20 67 72 70 68 31 32 33 |although| grph123|
|00001250| 20 63 61 6e 20 72 65 2d | 64 69 72 65 63 74 20 6f | can re-|direct o|
|00001260| 6e 6c 79 20 73 74 64 6f | 75 74 2e 20 20 54 68 65 |nly stdo|ut. The|
|00001270| 79 20 68 61 76 65 20 62 | 65 65 6e 20 74 65 73 74 |y have b|een test|
|00001280| 65 64 0a 58 6f 6e 6c 79 | 20 6f 6e 20 48 50 2d 55 |ed.Xonly| on HP-U|
|00001290| 58 20 38 2e 30 78 20 28 | 73 65 72 69 65 73 20 37 |X 8.0x (|series 7|
|000012a0| 30 30 20 6d 61 63 68 69 | 6e 65 73 29 2c 20 41 49 |00 machi|nes), AI|
|000012b0| 58 20 33 2e 32 2c 20 61 | 6e 64 20 53 75 6e 4f 53 |X 3.2, a|nd SunOS|
|000012c0| 20 34 2e 78 2e 20 20 57 | 65 0a 58 72 65 61 6c 6c | 4.x. W|e.Xreall|
|000012d0| 79 20 64 6f 6e 27 74 20 | 66 65 65 6c 20 6d 75 63 |y don't |feel muc|
|000012e0| 68 20 6c 69 6b 65 20 65 | 6e 68 61 6e 63 69 6e 67 |h like e|nhancing|
|000012f0| 20 74 68 65 6d 20 72 69 | 67 68 74 20 6e 6f 77 2c | them ri|ght now,|
|00001300| 20 62 75 74 20 66 65 65 | 6c 20 66 72 65 65 20 74 | but fee|l free t|
|00001310| 6f 0a 58 6d 61 69 6c 20 | 62 75 67 73 20 72 65 70 |o.Xmail |bugs rep|
|00001320| 6f 72 74 73 20 28 69 6e | 20 61 6e 79 20 66 6f 72 |orts (in| any for|
|00001330| 6d 29 20 74 6f 20 67 72 | 65 67 40 62 72 6f 6f 6b |m) to gr|eg@brook|
|00001340| 74 72 65 65 2e 63 6f 6d | 2e 0a 58 0a 58 42 79 20 |tree.com|..X.XBy |
|00001350| 74 68 65 20 77 61 79 3a | 20 69 66 20 79 6f 75 20 |the way:| if you |
|00001360| 72 65 61 6c 6c 79 20 6d | 75 73 74 20 72 75 6e 20 |really m|ust run |
|00001370| 74 68 69 73 20 70 72 6f | 67 72 61 6d 20 6f 6e 20 |this pro|gram on |
|00001380| 61 6e 20 49 6e 74 65 6c | 20 70 72 6f 63 65 73 73 |an Intel| process|
|00001390| 6f 72 2c 0a 58 62 65 20 | 73 75 72 65 20 74 6f 20 |or,.Xbe |sure to |
|000013a0| 61 6c 74 65 72 20 74 68 | 65 20 22 73 77 61 70 62 |alter th|e "swapb|
|000013b0| 22 20 6d 61 63 72 6f 20 | 74 6f 20 64 6f 20 6e 6f |" macro |to do no|
|000013c0| 20 73 77 61 70 70 69 6e | 67 2e 20 20 49 74 20 69 | swappin|g. It i|
|000013d0| 73 20 6e 6f 74 0a 58 69 | 6d 61 67 69 6e 65 64 20 |s not.Xi|magined |
|000013e0| 74 68 61 74 20 74 68 65 | 72 65 20 77 6f 75 6c 64 |that the|re would|
|000013f0| 20 62 65 20 6d 75 63 68 | 20 6e 65 65 64 20 66 6f | be much| need fo|
|00001400| 72 20 74 68 69 73 2c 20 | 61 73 20 6d 6f 73 74 20 |r this, |as most |
|00001410| 49 6e 74 65 6c 2d 62 61 | 73 65 64 0a 58 6f 70 65 |Intel-ba|sed.Xope|
|00001420| 72 61 74 69 6e 67 20 73 | 79 73 74 65 6d 73 20 73 |rating s|ystems s|
|00001430| 68 6f 75 6c 64 20 68 61 | 76 65 20 75 74 69 6c 69 |hould ha|ve utili|
|00001440| 74 69 65 73 20 73 75 63 | 68 20 61 73 20 63 6f 6e |ties suc|h as con|
|00001450| 76 31 32 33 20 72 65 61 | 64 69 6c 79 20 61 6e 64 |v123 rea|dily and|
|00001460| 0a 58 69 6e 65 78 70 65 | 6e 73 69 76 65 6c 79 20 |.Xinexpe|nsively |
|00001470| 61 76 61 69 6c 61 62 6c | 65 2e 0a 45 4e 44 5f 4f |availabl|e..END_O|
|00001480| 46 5f 46 49 4c 45 0a 69 | 66 20 74 65 73 74 20 31 |F_FILE.i|f test 1|
|00001490| 39 35 35 20 2d 6e 65 20 | 60 77 63 20 2d 63 20 3c |955 -ne |`wc -c <|
|000014a0| 27 52 45 41 44 4d 45 27 | 60 3b 20 74 68 65 6e 0a |'README'|`; then.|
|000014b0| 20 20 20 20 65 63 68 6f | 20 73 68 61 72 3a 20 5c | echo| shar: \|
|000014c0| 22 27 52 45 41 44 4d 45 | 27 5c 22 20 75 6e 70 61 |"'README|'\" unpa|
|000014d0| 63 6b 65 64 20 77 69 74 | 68 20 77 72 6f 6e 67 20 |cked wit|h wrong |
|000014e0| 73 69 7a 65 21 0a 66 69 | 0a 23 20 65 6e 64 20 6f |size!.fi|.# end o|
|000014f0| 66 20 27 52 45 41 44 4d | 45 27 0a 66 69 0a 69 66 |f 'READM|E'.fi.if|
|00001500| 20 74 65 73 74 20 2d 66 | 20 27 63 6f 6e 76 31 32 | test -f| 'conv12|
|00001510| 33 2e 31 27 20 2d 61 20 | 22 24 7b 31 7d 22 20 21 |3.1' -a |"${1}" !|
|00001520| 3d 20 22 2d 63 22 20 3b | 20 74 68 65 6e 20 0a 20 |= "-c" ;| then . |
|00001530| 20 65 63 68 6f 20 73 68 | 61 72 3a 20 57 69 6c 6c | echo sh|ar: Will|
|00001540| 20 6e 6f 74 20 63 6c 6f | 62 62 65 72 20 65 78 69 | not clo|bber exi|
|00001550| 73 74 69 6e 67 20 66 69 | 6c 65 20 5c 22 27 63 6f |sting fi|le \"'co|
|00001560| 6e 76 31 32 33 2e 31 27 | 5c 22 0a 65 6c 73 65 0a |nv123.1'|\".else.|
|00001570| 65 63 68 6f 20 73 68 61 | 72 3a 20 45 78 74 72 61 |echo sha|r: Extra|
|00001580| 63 74 69 6e 67 20 5c 22 | 27 63 6f 6e 76 31 32 33 |cting \"|'conv123|
|00001590| 2e 31 27 5c 22 20 5c 28 | 31 30 30 39 37 20 63 68 |.1'\" \(|10097 ch|
|000015a0| 61 72 61 63 74 65 72 73 | 5c 29 0a 73 65 64 20 22 |aracters|\).sed "|
|000015b0| 73 2f 5e 58 2f 2f 22 20 | 3e 27 63 6f 6e 76 31 32 |s/^X//" |>'conv12|
|000015c0| 33 2e 31 27 20 3c 3c 27 | 45 4e 44 5f 4f 46 5f 46 |3.1' <<'|END_OF_F|
|000015d0| 49 4c 45 27 0a 58 2e 54 | 48 20 43 4f 4e 56 31 32 |ILE'.X.T|H CONV12|
|000015e0| 33 20 31 20 22 36 20 41 | 75 67 20 31 39 39 33 22 |3 1 "6 A|ug 1993"|
|000015f0| 20 22 31 32 33 20 55 74 | 69 6c 69 74 69 65 73 22 | "123 Ut|ilities"|
|00001600| 0a 58 2e 53 48 20 4e 41 | 4d 45 0a 58 63 6f 6e 76 |.X.SH NA|ME.Xconv|
|00001610| 31 32 33 20 5c 2d 20 54 | 68 65 20 41 53 43 49 49 |123 \- T|he ASCII|
|00001620| 20 74 6f 20 4c 6f 74 75 | 73 28 54 4d 29 20 73 70 | to Lotu|s(TM) sp|
|00001630| 72 65 61 64 73 68 65 65 | 74 20 63 6f 6e 76 65 72 |readshee|t conver|
|00001640| 74 65 72 0a 58 0a 58 2e | 53 48 20 53 59 4e 4f 50 |ter.X.X.|SH SYNOP|
|00001650| 53 49 53 0a 58 2e 42 20 | 63 6f 6e 76 31 32 33 0a |SIS.X.B |conv123.|
|00001660| 58 5b 69 6e 70 75 74 66 | 69 6c 65 5d 20 5b 6f 75 |X[inputf|ile] [ou|
|00001670| 74 70 75 74 66 69 6c 65 | 5d 0a 58 0a 58 2e 53 48 |tputfile|].X.X.SH|
|00001680| 20 44 45 53 43 52 49 50 | 54 49 4f 4e 0a 58 0a 58 | DESCRIP|TION.X.X|
|00001690| 2e 49 20 63 6f 6e 76 31 | 32 33 0a 58 69 73 20 61 |.I conv1|23.Xis a|
|000016a0| 20 75 74 69 6c 69 74 79 | 20 66 6f 72 20 72 65 61 | utility| for rea|
|000016b0| 64 69 6e 67 20 61 20 73 | 70 65 63 69 61 6c 6c 79 |ding a s|pecially|
|000016c0| 2d 66 6f 72 6d 61 74 74 | 65 64 20 66 6c 61 74 0a |-formatt|ed flat.|
|000016d0| 58 41 53 43 49 49 20 66 | 69 6c 65 20 61 6e 64 20 |XASCII f|ile and |
|000016e0| 63 6f 6e 76 65 72 74 69 | 6e 67 20 69 74 20 69 6e |converti|ng it in|
|000016f0| 74 6f 20 61 20 4c 6f 74 | 75 73 2f 31 32 33 28 54 |to a Lot|us/123(T|
|00001700| 4d 29 20 22 2e 77 6b 31 | 22 20 66 69 6c 65 2e 0a |M) ".wk1|" file..|
|00001710| 58 45 61 63 68 20 73 70 | 65 63 69 61 6c 6c 79 2d |XEach sp|ecially-|
|00001720| 66 6f 72 6d 61 74 74 65 | 64 20 41 53 43 49 49 20 |formatte|d ASCII |
|00001730| 66 69 6c 65 20 63 72 65 | 61 74 65 73 20 6f 6e 65 |file cre|ates one|
|00001740| 20 65 6e 74 69 72 65 20 | 73 70 72 65 61 64 73 68 | entire |spreadsh|
|00001750| 65 65 74 2e 0a 58 54 68 | 69 73 20 73 70 72 65 61 |eet..XTh|is sprea|
|00001760| 64 73 68 65 65 74 20 66 | 69 6c 65 20 69 73 20 69 |dsheet f|ile is i|
|00001770| 6e 20 69 74 73 20 66 69 | 6e 61 6c 2c 20 64 69 72 |n its fi|nal, dir|
|00001780| 65 63 74 6c 79 2d 72 65 | 61 64 61 62 6c 65 20 0a |ectly-re|adable .|
|00001790| 58 62 69 6e 61 72 79 20 | 66 6f 72 6d 2c 20 61 6e |Xbinary |form, an|
|000017a0| 64 20 6e 65 65 64 20 75 | 6e 64 65 72 67 6f 20 6e |d need u|ndergo n|
|000017b0| 6f 20 66 75 72 74 68 65 | 72 20 74 72 61 6e 73 6c |o furthe|r transl|
|000017c0| 61 74 69 6f 6e 20 62 65 | 66 6f 72 65 20 62 65 69 |ation be|fore bei|
|000017d0| 6e 67 0a 58 72 65 61 64 | 20 64 69 72 65 63 74 6c |ng.Xread| directl|
|000017e0| 79 20 62 79 20 4c 6f 74 | 75 73 2f 31 32 33 28 54 |y by Lot|us/123(T|
|000017f0| 4d 29 2e 20 20 54 68 69 | 73 20 66 65 61 74 75 72 |M). Thi|s featur|
|00001800| 65 20 6d 61 6b 65 73 0a | 58 2e 49 20 63 6f 6e 76 |e makes.|X.I conv|
|00001810| 31 32 33 0a 58 65 73 70 | 65 63 69 61 6c 6c 79 0a |123.Xesp|ecially.|
|00001820| 58 73 75 69 74 65 64 20 | 74 6f 20 6e 65 74 77 6f |Xsuited |to netwo|
|00001830| 72 6b 65 64 20 65 6e 76 | 69 72 6f 6e 6d 65 6e 74 |rked env|ironment|
|00001840| 73 2c 20 77 68 65 72 65 | 20 72 65 70 6f 72 74 20 |s, where| report |
|00001850| 77 72 69 74 65 72 73 20 | 6f 72 20 70 72 6f 67 72 |writers |or progr|
|00001860| 61 6d 73 0a 58 72 75 6e | 6e 69 6e 67 20 6f 6e 20 |ams.Xrun|ning on |
|00001870| 74 72 61 6e 73 61 63 74 | 69 6f 6e 20 70 72 6f 63 |transact|ion proc|
|00001880| 65 73 73 69 6e 67 20 6d | 61 63 68 69 6e 65 73 20 |essing m|achines |
|00001890| 63 61 6e 20 65 61 73 69 | 6c 79 20 61 6e 64 20 64 |can easi|ly and d|
|000018a0| 69 72 65 63 74 6c 79 0a | 58 63 72 65 61 74 65 20 |irectly.|Xcreate |
|000018b0| 73 70 72 65 61 64 73 68 | 65 65 74 20 6f 75 74 70 |spreadsh|eet outp|
|000018c0| 75 74 2c 20 69 6e 73 74 | 61 6e 74 6c 79 20 72 65 |ut, inst|antly re|
|000018d0| 61 64 79 20 66 6f 72 20 | 63 6f 70 79 69 6e 67 2c |ady for |copying,|
|000018e0| 20 64 6f 77 6e 6c 6f 61 | 64 69 6e 67 2c 0a 58 6f | downloa|ding,.Xo|
|000018f0| 72 20 64 69 72 65 63 74 | 20 61 63 63 65 73 73 20 |r direct| access |
|00001900| 69 6e 20 74 68 65 20 4d | 53 2d 44 4f 53 28 54 4d |in the M|S-DOS(TM|
|00001910| 29 20 6f 72 20 4d 61 63 | 69 6e 74 6f 73 68 28 54 |) or Mac|intosh(T|
|00001920| 4d 29 20 65 6e 76 69 72 | 6f 6e 6d 65 6e 74 73 2e |M) envir|onments.|
|00001930| 0a 58 49 6e 20 61 64 64 | 69 74 69 6f 6e 20 74 6f |.XIn add|ition to|
|00001940| 20 69 6e 64 69 76 69 64 | 75 61 6c 20 64 61 74 61 | individ|ual data|
|00001950| 20 76 61 6c 75 65 73 2c | 20 63 65 72 74 61 69 6e | values,| certain|
|00001960| 20 63 6f 6d 6d 6f 6e 20 | 61 67 67 72 65 67 61 74 | common |aggregat|
|00001970| 65 0a 58 66 75 6e 63 74 | 69 6f 6e 73 20 28 66 6f |e.Xfunct|ions (fo|
|00001980| 72 6d 75 6c 61 73 29 20 | 6d 61 79 20 62 65 20 73 |rmulas) |may be s|
|00001990| 70 65 63 69 66 69 65 64 | 20 28 73 75 6d 2c 6d 69 |pecified| (sum,mi|
|000019a0| 6e 2c 6d 61 78 2c 76 61 | 72 69 61 6e 63 65 2c 73 |n,max,va|riance,s|
|000019b0| 74 64 0a 58 64 65 76 69 | 61 74 69 6f 6e 2c 20 61 |td.Xdevi|ation, a|
|000019c0| 6e 64 20 61 76 65 72 61 | 67 65 29 2c 20 61 6e 64 |nd avera|ge), and|
|000019d0| 20 66 69 76 65 20 62 69 | 6e 61 72 79 20 66 75 6e | five bi|nary fun|
|000019e0| 63 74 69 6f 6e 73 20 28 | 61 64 64 69 74 69 6f 6e |ctions (|addition|
|000019f0| 2c 0a 58 73 75 62 74 72 | 61 63 74 69 6f 6e 2c 20 |,.Xsubtr|action, |
|00001a00| 6d 75 6c 74 69 70 6c 69 | 63 61 74 69 6f 6e 2c 20 |multipli|cation, |
|00001a10| 64 69 76 69 73 69 6f 6e | 2c 20 61 6e 64 20 70 65 |division|, and pe|
|00001a20| 72 63 65 6e 74 61 67 65 | 29 20 6d 61 79 20 61 6c |rcentage|) may al|
|00001a30| 73 6f 0a 58 62 65 20 73 | 70 65 63 69 66 69 65 64 |so.Xbe s|pecified|
|00001a40| 2e 0a 58 0a 58 54 68 65 | 20 69 6e 70 75 74 20 66 |..X.XThe| input f|
|00001a50| 69 6c 65 20 66 6f 72 6d | 61 74 20 68 61 73 20 62 |ile form|at has b|
|00001a60| 65 65 6e 20 6f 70 74 69 | 6d 69 7a 65 64 20 66 6f |een opti|mized fo|
|00001a70| 72 20 67 65 6e 65 72 61 | 74 69 6f 6e 20 62 79 20 |r genera|tion by |
|00001a80| 61 0a 58 73 69 6d 70 6c | 65 20 74 6f 70 2d 64 6f |a.Xsimpl|e top-do|
|00001a90| 77 6e 2c 20 6c 65 66 74 | 2d 74 6f 2d 72 69 67 68 |wn, left|-to-righ|
|00001aa0| 74 20 72 65 70 6f 72 74 | 20 67 65 6e 65 72 61 74 |t report| generat|
|00001ab0| 6f 72 2c 0a 58 61 6e 64 | 20 69 73 20 68 75 6d 61 |or,.Xand| is huma|
|00001ac0| 6e 2d 72 65 61 64 61 62 | 6c 65 2e 20 20 54 68 65 |n-readab|le. The|
|00001ad0| 20 69 6e 70 75 74 20 6c | 6f 67 69 63 20 68 61 73 | input l|ogic has|
|00001ae0| 20 62 65 65 6e 20 6d 61 | 64 65 20 66 61 69 72 6c | been ma|de fairl|
|00001af0| 79 20 69 6e 74 65 6c 6c | 69 67 65 6e 74 2c 0a 58 |y intell|igent,.X|
|00001b00| 61 75 74 6f 6d 61 74 69 | 63 61 6c 6c 79 20 64 69 |automati|cally di|
|00001b10| 73 63 65 72 6e 69 6e 67 | 20 6e 75 6d 65 72 69 63 |scerning| numeric|
|00001b20| 20 61 6e 64 20 6e 6f 6e | 2d 6e 75 6d 65 72 69 63 | and non|-numeric|
|00001b30| 20 76 61 6c 75 65 73 2c | 0a 58 63 61 6c 63 75 6c | values,|.Xcalcul|
|00001b40| 61 74 69 6e 67 20 66 6f | 72 6d 75 6c 61 20 72 61 |ating fo|rmula ra|
|00001b50| 6e 67 65 73 2c 20 61 6e | 64 20 63 61 6c 63 75 6c |nges, an|d calcul|
|00001b60| 61 74 69 6e 67 20 74 68 | 65 20 6d 61 78 69 6d 75 |ating th|e maximu|
|00001b70| 6d 20 6e 75 6d 62 65 72 | 0a 58 6f 66 20 64 65 63 |m number|.Xof dec|
|00001b80| 69 6d 61 6c 20 70 6c 61 | 63 65 73 20 69 6e 20 61 |imal pla|ces in a|
|00001b90| 20 72 6f 77 20 6f 72 20 | 63 6f 6c 75 6d 6e 2e 0a | row or |column..|
|00001ba0| 58 0a 58 2e 53 48 20 4f | 50 54 49 4f 4e 53 0a 58 |X.X.SH O|PTIONS.X|
|00001bb0| 54 68 65 72 65 20 61 72 | 65 20 63 75 72 72 65 6e |There ar|e curren|
|00001bc0| 74 6c 79 20 6e 6f 20 63 | 6f 6d 6d 61 6e 64 2d 6c |tly no c|ommand-l|
|00001bd0| 69 6e 65 20 6f 70 74 69 | 6f 6e 73 20 66 6f 72 0a |ine opti|ons for.|
|00001be0| 58 2e 49 20 63 6f 6e 76 | 31 32 33 2e 0a 58 0a 58 |X.I conv|123..X.X|
|00001bf0| 0a 58 2e 53 48 20 50 41 | 52 41 4d 45 54 45 52 53 |.X.SH PA|RAMETERS|
|00001c00| 0a 58 54 68 65 20 6f 6e | 6c 79 20 70 61 72 61 6d |.XThe on|ly param|
|00001c10| 65 74 65 72 73 20 61 72 | 65 20 74 68 65 20 69 6e |eters ar|e the in|
|00001c20| 70 75 74 20 61 6e 64 20 | 6f 75 74 70 75 74 20 66 |put and |output f|
|00001c30| 69 6c 65 20 6e 61 6d 65 | 73 2c 20 62 6f 74 68 0a |ile name|s, both.|
|00001c40| 58 6f 66 20 77 68 69 63 | 68 20 61 72 65 20 6f 70 |Xof whic|h are op|
|00001c50| 74 69 6f 6e 61 6c 3b 0a | 58 2e 49 20 63 6f 6e 76 |tional;.|X.I conv|
|00001c60| 31 32 33 0a 58 63 61 6e | 20 61 63 74 20 61 73 20 |123.Xcan| act as |
|00001c70| 61 20 66 69 6c 74 65 72 | 2c 20 61 6e 64 20 62 79 |a filter|, and by|
|00001c80| 0a 58 64 65 66 61 75 6c | 74 20 61 63 63 65 70 74 |.Xdefaul|t accept|
|00001c90| 73 20 69 74 73 20 69 6e | 70 75 74 20 66 72 6f 6d |s its in|put from|
|00001ca0| 20 73 74 64 69 6e 20 61 | 6e 64 20 73 65 6e 64 73 | stdin a|nd sends|
|00001cb0| 20 69 74 73 20 6f 75 74 | 70 75 74 20 74 6f 0a 58 | its out|put to.X|
|00001cc0| 73 74 64 6f 75 74 2e 0a | 58 0a 58 2e 53 48 20 49 |stdout..|X.X.SH I|
|00001cd0| 4e 50 55 54 20 46 49 4c | 45 20 46 4f 52 4d 41 54 |NPUT FIL|E FORMAT|
|00001ce0| 0a 58 54 68 65 20 6d 61 | 6a 6f 72 20 66 65 61 74 |.XThe ma|jor feat|
|00001cf0| 75 72 65 20 6f 66 20 74 | 68 65 20 69 6e 70 75 74 |ure of t|he input|
|00001d00| 20 66 69 6c 65 20 66 6f | 72 6d 61 74 20 69 73 20 | file fo|rmat is |
|00001d10| 61 20 22 64 65 66 69 6e | 69 74 69 6f 6e 22 0a 58 |a "defin|ition".X|
|00001d20| 6c 69 6e 65 2c 20 63 6f | 6e 73 69 73 74 69 6e 67 |line, co|nsisting|
|00001d30| 20 6f 66 20 61 6c 6c 20 | 64 61 73 68 65 73 20 28 | of all |dashes (|
|00001d40| 2d 29 20 61 6e 64 20 73 | 70 61 63 65 73 2e 20 20 |-) and s|paces. |
|00001d50| 45 61 63 68 20 73 74 72 | 69 6e 67 20 6f 66 0a 58 |Each str|ing of.X|
|00001d60| 63 6f 6e 74 69 67 75 6f | 75 73 20 64 61 73 68 65 |contiguo|us dashe|
|00001d70| 73 20 6f 6e 20 74 68 65 | 20 22 64 65 66 69 6e 69 |s on the| "defini|
|00001d80| 74 69 6f 6e 22 20 6c 69 | 6e 65 20 77 69 6c 6c 20 |tion" li|ne will |
|00001d90| 62 65 63 6f 6d 65 20 61 | 20 63 6f 6c 75 6d 6e 0a |become a| column.|
|00001da0| 58 69 6e 20 4c 6f 74 75 | 73 2f 31 32 33 28 54 4d |Xin Lotu|s/123(TM|
|00001db0| 29 2c 20 74 68 65 20 77 | 69 64 74 68 20 6f 66 20 |), the w|idth of |
|00001dc0| 74 68 61 74 20 63 6f 6c | 75 6d 6e 20 62 65 69 6e |that col|umn bein|
|00001dd0| 67 20 64 65 74 65 72 6d | 69 6e 65 64 20 62 79 20 |g determ|ined by |
|00001de0| 74 68 65 0a 58 6e 75 6d | 62 65 72 20 6f 66 20 64 |the.Xnum|ber of d|
|00001df0| 61 73 68 65 73 2e 20 20 | 43 68 61 72 61 63 74 65 |ashes. |Characte|
|00001e00| 72 73 20 69 6e 20 74 68 | 65 20 69 6e 70 75 74 20 |rs in th|e input |
|00001e10| 66 69 6c 65 20 74 68 61 | 74 20 66 61 6c 6c 20 6f |file tha|t fall o|
|00001e20| 75 74 73 69 64 65 0a 58 | 74 68 65 73 65 20 22 63 |utside.X|these "c|
|00001e30| 6f 6c 75 6d 6e 20 64 65 | 66 69 6e 69 74 69 6f 6e |olumn de|finition|
|00001e40| 73 22 20 61 72 65 20 69 | 67 6e 6f 72 65 64 2e 20 |s" are i|gnored. |
|00001e50| 20 49 6e 20 61 64 64 69 | 74 69 6f 6e 2c 20 75 70 | In addi|tion, up|
|00001e60| 20 74 6f 20 74 77 6f 0a | 58 6c 69 6e 65 73 20 61 | to two.|Xlines a|
|00001e70| 62 6f 76 65 20 74 68 65 | 20 22 64 65 66 69 6e 69 |bove the| "defini|
|00001e80| 74 69 6f 6e 22 20 6c 69 | 6e 65 20 63 61 6e 20 62 |tion" li|ne can b|
|00001e90| 65 20 75 73 65 64 20 66 | 6f 72 20 68 65 61 64 65 |e used f|or heade|
|00001ea0| 72 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 2c 0a 58 |r inform|ation,.X|
|00001eb0| 74 68 6f 75 67 68 20 74 | 68 69 73 20 69 73 20 6e |though t|his is n|
|00001ec0| 6f 74 20 72 65 71 75 69 | 72 65 64 2e 20 20 54 68 |ot requi|red. Th|
|00001ed0| 65 72 65 20 6d 61 79 20 | 6e 6f 74 20 62 65 20 61 |ere may |not be a|
|00001ee0| 6e 79 20 77 68 69 74 65 | 20 73 70 61 63 65 20 62 |ny white| space b|
|00001ef0| 65 66 6f 72 65 0a 58 74 | 68 65 20 66 69 72 73 74 |efore.Xt|he first|
|00001f00| 20 64 61 73 68 20 6f 6e | 20 74 68 65 20 64 65 66 | dash on| the def|
|00001f10| 69 6e 69 74 69 6f 6e 20 | 6c 69 6e 65 3b 20 69 6e |inition |line; in|
|00001f20| 20 6f 74 68 65 72 20 77 | 6f 72 64 73 2c 20 74 68 | other w|ords, th|
|00001f30| 65 20 64 65 66 69 6e 69 | 74 69 6f 6e 0a 58 6c 69 |e defini|tion.Xli|
|00001f40| 6e 65 20 4d 55 53 54 20 | 62 65 67 69 6e 20 69 6e |ne MUST |begin in|
|00001f50| 20 74 68 65 20 66 69 72 | 73 74 20 63 6f 6c 75 6d | the fir|st colum|
|00001f60| 6e 20 6f 66 20 74 68 65 | 20 69 6e 70 75 74 20 66 |n of the| input f|
|00001f70| 69 6c 65 2e 0a 58 0a 58 | 46 6f 6c 6c 6f 77 69 6e |ile..X.X|Followin|
|00001f80| 67 20 69 73 20 61 6e 20 | 65 78 61 6d 70 6c 65 20 |g is an |example |
|00001f90| 69 6e 70 75 74 20 66 69 | 6c 65 2c 20 66 6f 6c 6c |input fi|le, foll|
|00001fa0| 6f 77 65 64 20 62 79 20 | 61 20 6d 6f 72 65 20 64 |owed by |a more d|
|00001fb0| 65 74 61 69 6c 65 64 0a | 58 65 78 70 6c 61 6e 61 |etailed.|Xexplana|
|00001fc0| 74 69 6f 6e 20 6f 66 20 | 69 74 73 20 63 6f 6e 74 |tion of |its cont|
|00001fd0| 65 6e 74 73 3a 0a 58 0a | 58 20 20 20 20 20 20 20 |ents:.X.|X |
|00001fe0| 20 20 20 20 20 20 20 20 | 20 20 20 20 4a 61 6e 20 | | Jan |
|00001ff0| 20 20 20 20 20 20 20 20 | 20 46 65 62 20 20 20 20 | | Feb |
|00002000| 20 20 20 20 20 4d 61 72 | 20 20 20 20 20 20 20 20 | Mar| |
|00002010| 20 51 74 72 0a 58 20 20 | 20 20 20 50 72 6f 64 75 | Qtr.X | Produ|
|00002020| 63 74 20 20 20 20 20 20 | 53 61 6c 65 73 20 20 20 |ct |Sales |
|00002030| 20 20 20 20 20 53 61 6c | 65 73 20 20 20 20 20 20 | Sal|es |
|00002040| 20 53 61 6c 65 73 20 20 | 20 20 20 20 20 54 6f 74 | Sales | Tot|
|00002050| 61 6c 0a 58 20 20 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |al.X |--------|
|00002060| 2d 20 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 20 20 |- -----|------ |
|00002070| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |--------|--- ----|
|00002080| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|00002090| 2d 2d 2d 0a 58 20 20 20 | 20 77 69 64 67 65 74 2d |---.X | widget-|
|000020a0| 31 20 20 20 20 20 34 35 | 30 30 30 2e 38 37 20 20 |1 45|000.87 |
|000020b0| 20 20 20 20 20 35 34 33 | 39 30 2e 39 20 20 20 20 | 543|90.9 |
|000020c0| 37 35 39 34 37 2e 31 32 | 20 20 20 20 20 40 52 53 |75947.12| @RS|
|000020d0| 55 4d 0a 58 20 20 20 20 | 77 69 64 67 65 74 2d 32 |UM.X |widget-2|
|000020e0| 20 20 20 20 20 34 37 30 | 30 30 2e 37 38 20 20 20 | 470|00.78 |
|000020f0| 20 20 20 20 36 34 35 35 | 30 2e 30 20 20 20 20 37 | 6455|0.0 7|
|00002100| 33 36 34 37 2e 37 37 20 | 20 20 20 20 40 52 53 55 |3647.77 | @RSU|
|00002110| 4d 0a 58 20 20 20 20 77 | 69 64 67 65 74 2d 33 20 |M.X w|idget-3 |
|00002120| 20 20 20 20 34 37 38 30 | 30 2e 31 31 20 20 20 20 | 4780|0.11 |
|00002130| 20 20 20 36 37 38 33 30 | 2e 35 20 20 20 20 35 34 | 67830|.5 54|
|00002140| 35 33 36 2e 33 37 20 20 | 20 20 20 40 52 53 55 4d |536.37 | @RSUM|
|00002150| 0a 58 20 20 20 20 77 69 | 64 67 65 74 2d 34 20 20 |.X wi|dget-4 |
|00002160| 20 20 20 33 33 30 30 33 | 2e 33 30 20 20 20 20 20 | 33003|.30 |
|00002170| 20 20 37 36 35 33 30 2e | 37 20 20 20 20 39 38 36 | 76530.|7 986|
|00002180| 35 33 2e 38 33 20 20 20 | 20 20 40 52 53 55 4d 0a |53.83 | @RSUM.|
|00002190| 58 20 20 20 20 77 69 64 | 67 65 74 2d 35 20 20 20 |X wid|get-5 |
|000021a0| 20 20 31 32 30 30 30 2e | 34 34 20 20 20 20 20 20 | 12000.|44 |
|000021b0| 20 36 34 38 33 36 2e 37 | 20 20 20 20 32 37 36 33 | 64836.7| 2763|
|000021c0| 37 2e 39 31 20 20 20 20 | 20 40 52 53 55 4d 0a 58 |7.91 | @RSUM.X|
|000021d0| 0a 58 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.X | |
|000021e0| 20 20 20 20 20 20 20 40 | 43 53 55 4d 20 20 20 20 | @|CSUM |
|000021f0| 20 20 20 20 40 43 53 55 | 4d 20 20 20 20 20 20 20 | @CSU|M |
|00002200| 40 43 53 55 4d 20 20 20 | 20 20 40 43 53 55 4d 0a |@CSUM | @CSUM.|
|00002210| 58 0a 58 54 68 69 73 20 | 69 73 20 61 20 66 61 69 |X.XThis |is a fai|
|00002220| 72 6c 79 20 73 69 6d 70 | 6c 65 20 73 70 72 65 61 |rly simp|le sprea|
|00002230| 64 73 68 65 65 74 20 77 | 69 74 68 20 74 65 6e 20 |dsheet w|ith ten |
|00002240| 72 6f 77 73 20 61 6e 64 | 20 66 69 76 65 0a 58 63 |rows and| five.Xc|
|00002250| 6f 6c 75 6d 6e 73 2e 20 | 20 54 68 65 20 66 69 66 |olumns. | The fif|
|00002260| 74 68 20 63 6f 6c 75 6d | 6e 20 69 73 20 61 63 74 |th colum|n is act|
|00002270| 75 61 6c 6c 79 20 6d 61 | 64 65 20 6f 66 20 66 6f |ually ma|de of fo|
|00002280| 72 6d 75 6c 61 73 0a 58 | 28 22 72 6f 77 20 73 75 |rmulas.X|("row su|
|00002290| 6d 73 22 29 2c 20 61 73 | 20 69 73 20 74 68 65 20 |ms"), as| is the |
|000022a0| 6c 61 73 74 20 72 6f 77 | 20 28 22 63 6f 6c 75 6d |last row| ("colum|
|000022b0| 6e 20 73 75 6d 73 22 29 | 2e 0a 58 2e 49 20 63 6f |n sums")|..X.I co|
|000022c0| 6e 76 31 32 33 0a 58 69 | 73 0a 58 73 6d 61 72 74 |nv123.Xi|s.Xsmart|
|000022d0| 20 65 6e 6f 75 67 68 20 | 74 6f 20 6b 6e 6f 77 20 | enough |to know |
|000022e0| 74 68 61 74 20 65 61 63 | 68 20 64 61 74 61 20 76 |that eac|h data v|
|000022f0| 61 6c 75 65 20 69 6e 20 | 74 68 65 20 66 69 72 73 |alue in |the firs|
|00002300| 74 20 63 6f 6c 75 6d 6e | 0a 58 69 73 20 6e 6f 6e |t column|.Xis non|
|00002310| 2d 6e 75 6d 65 72 69 63 | 2c 20 61 6e 64 20 63 72 |-numeric|, and cr|
|00002320| 65 61 74 65 73 20 74 68 | 65 20 66 6f 72 6d 75 6c |eates th|e formul|
|00002330| 61 73 20 69 6e 20 74 68 | 65 20 66 69 66 74 68 20 |as in th|e fifth |
|00002340| 63 6f 6c 75 6d 6e 0a 58 | 61 63 63 6f 72 64 69 6e |column.X|accordin|
|00002350| 67 6c 79 2c 20 69 2e 65 | 2e 2c 20 74 68 65 20 22 |gly, i.e|., the "|
|00002360| 72 6f 77 20 73 75 6d 73 | 22 20 61 72 65 20 73 75 |row sums|" are su|
|00002370| 6d 73 20 6f 66 20 74 68 | 65 20 76 61 6c 75 65 73 |ms of th|e values|
|00002380| 20 69 6e 0a 58 74 68 65 | 20 73 65 63 6f 6e 64 20 | in.Xthe| second |
|00002390| 74 68 72 6f 75 67 68 20 | 74 68 65 20 66 6f 75 72 |through |the four|
|000023a0| 74 68 20 63 6f 6c 75 6d | 6e 73 2e 20 20 49 6e 20 |th colum|ns. In |
|000023b0| 61 64 64 69 74 69 6f 6e | 2c 20 73 69 6e 63 65 0a |addition|, since.|
|000023c0| 58 2e 49 20 63 6f 6e 76 | 31 32 33 0a 58 6b 65 65 |X.I conv|123.Xkee|
|000023d0| 70 73 20 74 72 61 63 6b | 20 6f 66 20 74 68 65 20 |ps track| of the |
|000023e0| 6d 61 78 69 6d 75 6d 20 | 6e 75 6d 62 65 72 20 6f |maximum |number o|
|000023f0| 66 20 64 65 63 69 6d 61 | 6c 20 70 6c 61 63 65 73 |f decima|l places|
|00002400| 0a 58 75 73 65 64 20 69 | 6e 20 61 20 67 69 76 65 |.Xused i|n a give|
|00002410| 6e 20 72 6f 77 20 6f 72 | 20 63 6f 6c 75 6d 6e 2c |n row or| column,|
|00002420| 20 74 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 64 | the num|ber of d|
|00002430| 65 63 69 6d 61 6c 20 70 | 6c 61 63 65 73 0a 58 64 |ecimal p|laces.Xd|
|00002440| 69 73 70 6c 61 79 65 64 | 20 69 6e 20 4c 6f 74 75 |isplayed| in Lotu|
|00002450| 73 2f 31 32 33 28 54 4d | 29 20 77 69 6c 6c 20 62 |s/123(TM|) will b|
|00002460| 65 20 74 77 6f 20 28 32 | 29 20 66 6f 72 20 61 6c |e two (2|) for al|
|00002470| 6c 20 66 6f 72 6d 75 6c | 61 73 2c 0a 58 77 69 74 |l formul|as,.Xwit|
|00002480| 68 20 74 68 65 20 65 78 | 63 65 70 74 69 6f 6e 20 |h the ex|ception |
|00002490| 6f 66 20 74 68 65 20 43 | 53 55 4d 20 69 6e 20 74 |of the C|SUM in t|
|000024a0| 68 65 20 74 68 69 72 64 | 20 63 6f 6c 75 6d 6e 2c |he third| column,|
|000024b0| 20 77 68 69 63 68 20 77 | 69 6c 6c 0a 58 64 69 73 | which w|ill.Xdis|
|000024c0| 70 6c 61 79 20 77 69 74 | 68 20 6f 6e 65 20 28 31 |play wit|h one (1|
|000024d0| 29 20 64 65 63 69 6d 61 | 6c 20 70 6c 61 63 65 2e |) decima|l place.|
|000024e0| 20 20 4e 6f 74 65 20 61 | 6c 73 6f 20 74 68 61 74 | Note a|lso that|
|000024f0| 20 74 68 65 20 70 6f 73 | 69 74 69 6f 6e 0a 58 6f | the pos|ition.Xo|
|00002500| 66 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 72 20 |f the nu|mber or |
|00002510| 66 6f 72 6d 75 6c 61 20 | 63 6f 64 65 20 69 6e 20 |formula |code in |
|00002520| 65 61 63 68 20 63 6f 6c | 75 6d 6e 20 69 73 20 6e |each col|umn is n|
|00002530| 6f 74 20 73 69 67 6e 69 | 66 69 63 61 6e 74 2c 0a |ot signi|ficant,.|
|00002540| 58 61 73 20 6c 6f 6e 67 | 20 61 73 20 74 68 65 20 |Xas long| as the |
|00002550| 65 6e 74 69 72 65 20 76 | 61 6c 75 65 73 20 66 69 |entire v|alues fi|
|00002560| 74 73 20 75 6e 64 65 72 | 20 74 68 65 20 64 61 73 |ts under| the das|
|00002570| 68 65 64 2d 6c 69 6e 65 | 20 63 6f 6c 75 6d 6e 0a |hed-line| column.|
|00002580| 58 64 65 66 69 6e 69 74 | 69 6f 6e 28 73 29 2e 20 |Xdefinit|ion(s). |
|00002590| 20 41 6c 73 6f 2c 20 6d | 6f 73 74 20 73 70 72 65 | Also, m|ost spre|
|000025a0| 61 64 73 68 65 65 74 20 | 70 72 6f 67 72 61 6d 73 |adsheet |programs|
|000025b0| 20 77 69 6c 6c 20 72 65 | 2d 70 6f 73 69 74 69 6f | will re|-positio|
|000025c0| 6e 0a 58 74 68 65 20 76 | 61 6c 75 65 73 20 77 69 |n.Xthe v|alues wi|
|000025d0| 74 68 69 6e 20 65 61 63 | 68 20 63 65 6c 6c 20 61 |thin eac|h cell a|
|000025e0| 73 20 74 68 65 20 76 61 | 6c 75 65 73 20 61 72 65 |s the va|lues are|
|000025f0| 20 64 69 73 70 6c 61 79 | 65 64 2e 0a 58 0a 58 0a | display|ed..X.X.|
|00002600| 58 2e 53 48 20 46 4f 52 | 4d 55 4c 41 20 43 4f 44 |X.SH FOR|MULA COD|
|00002610| 45 53 0a 58 41 73 20 68 | 61 73 20 62 65 65 6e 20 |ES.XAs h|as been |
|00002620| 73 68 6f 77 6e 20 69 6e | 20 74 68 65 20 61 62 6f |shown in| the abo|
|00002630| 76 65 20 65 78 61 6d 70 | 6c 65 2c 20 63 65 6c 6c |ve examp|le, cell|
|00002640| 20 63 6f 6e 74 65 6e 74 | 73 20 6d 61 79 20 62 65 | content|s may be|
|00002650| 0a 58 64 65 63 69 6d 61 | 6c 20 6e 75 6d 62 65 72 |.Xdecima|l number|
|00002660| 73 20 6f 72 20 63 68 61 | 72 61 63 74 65 72 20 76 |s or cha|racter v|
|00002670| 61 6c 75 65 73 2c 20 77 | 69 74 68 20 74 68 65 20 |alues, w|ith the |
|00002680| 77 69 64 74 68 20 6f 66 | 20 74 68 65 20 63 65 6c |width of| the cel|
|00002690| 6c 0a 58 64 65 74 65 72 | 6d 69 6e 65 64 20 62 79 |l.Xdeter|mined by|
|000026a0| 20 74 68 65 20 77 69 64 | 74 68 20 6f 66 20 74 68 | the wid|th of th|
|000026b0| 65 20 63 6f 6e 74 69 67 | 75 6f 75 73 20 64 61 73 |e contig|uous das|
|000026c0| 68 65 73 20 69 6e 20 74 | 68 65 20 22 64 65 66 69 |hes in t|he "defi|
|000026d0| 6e 69 74 69 6f 6e 22 0a | 58 6c 69 6e 65 2e 20 20 |nition".|Xline. |
|000026e0| 43 65 6c 6c 20 63 6f 6e | 74 65 6e 74 73 20 6d 61 |Cell con|tents ma|
|000026f0| 79 20 61 6c 73 6f 20 62 | 65 20 66 6f 72 6d 75 6c |y also b|e formul|
|00002700| 61 20 63 6f 64 65 73 2e | 20 20 41 20 66 6f 72 6d |a codes.| A form|
|00002710| 75 6c 61 20 63 6f 64 65 | 20 69 73 0a 58 61 20 63 |ula code| is.Xa c|
|00002720| 6f 6e 74 69 67 75 6f 75 | 73 20 73 65 74 20 6f 66 |ontiguou|s set of|
|00002730| 20 63 68 61 72 61 63 74 | 65 72 73 2c 20 61 6c 77 | charact|ers, alw|
|00002740| 61 79 73 20 62 65 67 69 | 6e 6e 69 6e 67 20 77 69 |ays begi|nning wi|
|00002750| 74 68 20 61 20 63 6f 6d | 6d 65 72 63 69 61 6c 0a |th a com|mercial.|
|00002760| 58 22 61 74 22 20 73 69 | 67 6e 20 28 40 29 2e 20 |X"at" si|gn (@). |
|00002770| 20 54 68 65 72 65 20 61 | 72 65 20 74 68 72 65 65 | There a|re three|
|00002780| 20 74 79 70 65 73 3a 20 | 72 6f 77 2c 20 63 6f 6c | types: |row, col|
|00002790| 75 6d 6e 20 61 6e 64 20 | 62 6f 74 68 2e 20 20 54 |umn and |both. T|
|000027a0| 68 65 0a 58 74 79 70 65 | 20 69 6e 64 69 63 61 74 |he.Xtype| indicat|
|000027b0| 6f 72 20 69 73 20 61 20 | 73 69 6e 67 6c 65 20 75 |or is a |single u|
|000027c0| 70 70 65 72 20 63 61 73 | 65 20 6c 65 74 74 65 72 |pper cas|e letter|
|000027d0| 2c 20 6f 6e 65 20 6f 66 | 20 22 52 22 20 28 72 6f |, one of| "R" (ro|
|000027e0| 77 29 2c 20 22 43 22 0a | 58 28 63 6f 6c 75 6d 6e |w), "C".|X(column|
|000027f0| 29 20 6f 72 20 22 42 22 | 20 28 62 6f 74 68 29 2c |) or "B"| (both),|
|00002800| 20 69 6d 6d 65 64 69 61 | 74 65 6c 79 20 66 6f 6c | immedia|tely fol|
|00002810| 6c 6f 77 69 6e 67 20 74 | 68 65 20 22 40 22 20 28 |lowing t|he "@" (|
|00002820| 22 61 74 22 20 73 69 67 | 6e 29 2e 0a 58 54 68 65 |"at" sig|n)..XThe|
|00002830| 20 66 6f 72 6d 75 6c 61 | 20 66 75 6e 63 74 69 6f | formula| functio|
|00002840| 6e 20 69 6d 6d 65 64 69 | 61 74 65 6c 79 20 66 6f |n immedi|ately fo|
|00002850| 6c 6c 6f 77 73 20 74 68 | 65 20 74 79 70 65 20 69 |llows th|e type i|
|00002860| 6e 64 69 63 61 74 6f 72 | 2c 20 61 6e 64 20 6d 61 |ndicator|, and ma|
|00002870| 79 0a 58 62 65 20 61 6e | 20 61 67 67 72 65 67 61 |y.Xbe an| aggrega|
|00002880| 74 65 20 66 75 6e 63 74 | 69 6f 6e 20 6f 72 20 61 |te funct|ion or a|
|00002890| 20 62 69 6e 61 72 79 20 | 66 75 6e 63 74 69 6f 6e | binary |function|
|000028a0| 2e 20 20 54 68 65 20 72 | 61 6e 67 65 20 66 6f 72 |. The r|ange for|
|000028b0| 20 61 6e 0a 58 61 67 67 | 72 65 67 61 74 65 20 66 | an.Xagg|regate f|
|000028c0| 75 6e 63 74 69 6f 6e 20 | 69 73 20 63 61 6c 63 75 |unction |is calcu|
|000028d0| 6c 61 74 65 64 20 61 75 | 74 6f 6d 61 74 69 63 61 |lated au|tomatica|
|000028e0| 6c 6c 79 2c 20 62 65 69 | 6e 67 20 74 68 65 20 72 |lly, bei|ng the r|
|000028f0| 61 6e 67 65 20 66 72 6f | 6d 0a 58 74 68 65 20 65 |ange fro|m.Xthe e|
|00002900| 61 72 6c 69 65 73 74 20 | 61 76 61 69 6c 61 62 6c |arliest |availabl|
|00002910| 65 20 63 65 6c 6c 20 2d | 2d 20 69 2e 65 2e 2c 20 |e cell -|- i.e., |
|00002920| 74 68 65 20 63 65 6c 6c | 20 66 61 72 74 68 65 73 |the cell| farthes|
|00002930| 74 20 22 61 62 6f 76 65 | 22 20 66 6f 72 0a 58 63 |t "above|" for.Xc|
|00002940| 6f 6c 75 6d 6e 73 2c 20 | 6f 72 20 66 61 72 74 68 |olumns, |or farth|
|00002950| 65 73 74 20 74 6f 20 74 | 68 65 20 22 6c 65 66 74 |est to t|he "left|
|00002960| 22 20 66 6f 72 20 72 6f | 77 73 20 2d 2d 20 74 6f |" for ro|ws -- to|
|00002970| 20 74 68 65 20 63 65 6c | 6c 20 69 6d 6d 65 64 69 | the cel|l immedi|
|00002980| 61 74 65 6c 79 0a 58 61 | 64 6a 61 63 65 6e 74 20 |ately.Xa|djacent |
|00002990| 74 6f 20 74 68 65 20 66 | 6f 72 6d 75 6c 61 20 64 |to the f|ormula d|
|000029a0| 65 66 69 6e 69 74 69 6f | 6e 2e 20 20 4e 6f 74 65 |efinitio|n. Note|
|000029b0| 20 74 68 61 74 20 74 68 | 69 73 20 22 66 61 72 74 | that th|is "fart|
|000029c0| 68 65 73 74 22 20 63 65 | 6c 6c 0a 58 6c 6f 63 61 |hest" ce|ll.Xloca|
|000029d0| 74 69 6f 6e 20 69 73 20 | 72 65 2d 61 64 6a 75 73 |tion is |re-adjus|
|000029e0| 74 65 64 20 77 68 65 6e | 20 61 20 6e 6f 6e 2d 6e |ted when| a non-n|
|000029f0| 75 6d 65 72 69 63 20 63 | 65 6c 6c 20 64 65 66 69 |umeric c|ell defi|
|00002a00| 6e 69 74 69 6f 6e 20 69 | 73 20 0a 58 65 6e 63 6f |nition i|s .Xenco|
|00002a10| 75 6e 74 65 72 65 64 2c | 20 62 65 69 6e 67 20 73 |untered,| being s|
|00002a20| 65 74 20 74 6f 20 62 65 | 67 69 6e 20 61 74 20 74 |et to be|gin at t|
|00002a30| 68 65 20 6e 65 78 74 20 | 6e 75 6d 65 72 69 63 20 |he next |numeric |
|00002a40| 63 65 6c 6c 20 28 74 68 | 69 73 20 64 6f 65 73 0a |cell (th|is does.|
|00002a50| 58 6e 6f 74 20 69 6e 63 | 6c 75 64 65 20 6e 6f 6e |Xnot inc|lude non|
|00002a60| 2d 63 65 6c 6c 73 2c 20 | 69 2e 65 2e 2c 20 70 6f |-cells, |i.e., po|
|00002a70| 73 69 74 69 6f 6e 73 20 | 77 69 74 68 69 6e 20 74 |sitions |within t|
|00002a80| 68 65 20 73 70 72 65 61 | 64 73 68 65 65 74 20 77 |he sprea|dsheet w|
|00002a90| 69 74 68 0a 58 6e 6f 20 | 76 61 6c 75 65 29 2e 20 |ith.Xno |value). |
|00002aa0| 20 54 68 65 20 61 75 74 | 6f 6d 61 74 69 63 20 72 | The aut|omatic r|
|00002ab0| 61 6e 67 65 20 73 74 61 | 72 74 20 70 6f 73 69 74 |ange sta|rt posit|
|00002ac0| 69 6f 6e 20 6d 61 79 20 | 62 65 20 6f 76 65 72 72 |ion may |be overr|
|00002ad0| 69 64 64 65 6e 20 66 6f | 72 0a 58 22 72 6f 77 22 |idden fo|r.X"row"|
|00002ae0| 20 66 75 6e 63 74 69 6f | 6e 73 20 62 79 20 70 6c | functio|ns by pl|
|00002af0| 61 63 69 6e 67 20 61 20 | 6e 75 6d 65 72 69 63 20 |acing a |numeric |
|00002b00| 76 61 6c 75 65 20 61 74 | 20 74 68 65 20 65 6e 64 |value at| the end|
|00002b10| 20 6f 66 20 74 68 65 20 | 66 6f 72 6d 75 6c 61 0a | of the |formula.|
|00002b20| 58 63 6f 64 65 20 28 73 | 74 69 6c 6c 20 63 6f 6e |Xcode (s|till con|
|00002b30| 74 69 67 75 6f 75 73 29 | 2e 20 20 41 20 6e 75 6d |tiguous)|. A num|
|00002b40| 65 72 69 63 20 76 61 6c | 75 65 20 61 74 20 74 68 |eric val|ue at th|
|00002b50| 65 20 65 6e 64 20 6f 66 | 20 61 20 66 6f 72 6d 75 |e end of| a formu|
|00002b60| 6c 61 20 63 6f 64 65 0a | 58 69 73 20 74 72 65 61 |la code.|Xis trea|
|00002b70| 74 65 64 20 61 73 20 61 | 6e 20 61 62 73 6f 6c 75 |ted as a|n absolu|
|00002b80| 74 65 20 63 6f 6c 75 6d | 6e 20 6e 75 6d 62 65 72 |te colum|n number|
|00002b90| 2c 20 77 69 74 68 20 74 | 68 65 20 66 69 72 73 74 |, with t|he first|
|00002ba0| 20 63 6f 6c 75 6d 6e 0a | 58 64 65 66 69 6e 65 64 | column.|Xdefined|
|00002bb0| 20 61 73 20 63 6f 6c 75 | 6d 6e 20 6f 6e 65 20 28 | as colu|mn one (|
|00002bc0| 31 29 2e 0a 58 0a 58 54 | 68 65 20 72 61 6e 67 65 |1)..X.XT|he range|
|00002bd0| 20 66 6f 72 20 61 20 62 | 69 6e 61 72 79 20 66 75 | for a b|inary fu|
|00002be0| 6e 63 74 69 6f 6e 20 69 | 73 20 73 69 6d 70 6c 79 |nction i|s simply|
|00002bf0| 20 74 68 65 20 6c 61 73 | 74 20 74 77 6f 20 61 64 | the las|t two ad|
|00002c00| 6a 61 63 65 6e 74 0a 58 | 63 65 6c 6c 73 20 22 61 |jacent.X|cells "a|
|00002c10| 62 6f 76 65 22 20 74 68 | 65 20 66 6f 72 6d 75 6c |bove" th|e formul|
|00002c20| 61 20 64 65 66 69 6e 69 | 74 69 6f 6e 20 66 6f 72 |a defini|tion for|
|00002c30| 20 63 6f 6c 75 6d 6e 20 | 66 75 6e 63 74 69 6f 6e | column |function|
|00002c40| 73 2c 20 61 6e 64 0a 58 | 22 6c 65 66 74 22 20 6f |s, and.X|"left" o|
|00002c50| 66 20 74 68 65 20 66 6f | 72 6d 75 6c 61 20 64 65 |f the fo|rmula de|
|00002c60| 66 69 6e 69 74 69 6f 6e | 20 66 6f 72 20 72 6f 77 |finition| for row|
|00002c70| 20 66 75 6e 63 74 69 6f | 6e 73 2e 20 20 54 68 65 | functio|ns. The|
|00002c80| 20 61 64 6a 61 63 65 6e | 74 0a 58 63 65 6c 6c 20 | adjacen|t.Xcell |
|00002c90| 69 73 20 61 6c 77 61 79 | 73 20 75 73 65 64 20 69 |is alway|s used i|
|00002ca0| 6e 20 74 68 65 20 63 61 | 6c 63 75 6c 61 74 69 6f |n the ca|lculatio|
|00002cb0| 6e 3b 20 61 6e 20 6f 76 | 65 72 72 69 64 65 20 6e |n; an ov|erride n|
|00002cc0| 75 6d 62 65 72 20 61 66 | 74 65 72 0a 58 74 68 65 |umber af|ter.Xthe|
|00002cd0| 20 66 75 6e 63 74 69 6f | 6e 20 63 6f 64 65 20 69 | functio|n code i|
|00002ce0| 6e 20 61 20 72 6f 77 20 | 66 75 6e 63 74 69 6f 6e |n a row |function|
|00002cf0| 20 69 73 20 74 72 65 61 | 74 65 64 20 61 73 20 61 | is trea|ted as a|
|00002d00| 6e 20 61 62 73 6f 6c 75 | 74 65 0a 58 63 6f 6c 75 |n absolu|te.Xcolu|
|00002d10| 6d 6e 20 6e 75 6d 62 65 | 72 20 6f 76 65 72 72 69 |mn numbe|r overri|
|00002d20| 64 69 6e 67 20 74 68 65 | 20 70 65 6e 75 6c 74 69 |ding the| penulti|
|00002d30| 6d 61 74 65 20 63 65 6c | 6c 2e 20 20 46 6f 72 20 |mate cel|l. For |
|00002d40| 63 6f 6d 6d 75 74 61 74 | 69 76 65 0a 58 66 75 6e |commutat|ive.Xfun|
|00002d50| 63 74 69 6f 6e 73 20 28 | 61 64 64 69 74 69 6f 6e |ctions (|addition|
|00002d60| 20 61 6e 64 20 6d 75 6c | 74 69 70 6c 69 63 61 74 | and mul|tiplicat|
|00002d70| 69 6f 6e 29 2c 20 6f 72 | 64 65 72 20 69 73 20 6e |ion), or|der is n|
|00002d80| 6f 74 20 73 69 67 6e 69 | 66 69 63 61 6e 74 2e 0a |ot signi|ficant..|
|00002d90| 58 46 6f 72 20 6e 6f 6e | 2d 63 6f 6d 6d 75 74 61 |XFor non|-commuta|
|00002da0| 74 69 76 65 20 66 75 6e | 63 74 69 6f 6e 73 20 28 |tive fun|ctions (|
|00002db0| 73 75 62 74 72 61 63 74 | 69 6f 6e 20 61 6e 64 20 |subtract|ion and |
|00002dc0| 64 69 76 69 73 69 6f 6e | 29 2c 20 74 68 65 0a 58 |division|), the.X|
|00002dd0| 64 65 66 69 6e 69 74 69 | 6f 6e 20 69 73 20 61 20 |definiti|on is a |
|00002de0| 2d 20 62 2c 20 6f 72 20 | 61 2f 62 2c 20 77 68 65 |- b, or |a/b, whe|
|00002df0| 72 65 20 61 20 69 73 20 | 74 68 65 20 70 65 6e 75 |re a is |the penu|
|00002e00| 6c 74 69 6d 61 74 65 20 | 63 65 6c 6c 2c 20 61 6e |ltimate |cell, an|
|00002e10| 64 20 62 0a 58 69 73 20 | 74 68 65 20 69 6d 6d 65 |d b.Xis |the imme|
|00002e20| 64 69 61 74 65 6c 79 20 | 61 64 6a 61 63 65 6e 74 |diately |adjacent|
|00002e30| 20 63 65 6c 6c 2e 20 20 | 49 66 20 74 68 65 72 65 | cell. |If there|
|00002e40| 20 69 73 20 61 6e 20 6f | 76 65 72 72 69 64 65 20 | is an o|verride |
|00002e50| 63 6f 6c 75 6d 6e 0a 58 | 6e 75 6d 62 65 72 2c 20 |column.X|number, |
|00002e60| 54 48 49 53 20 4f 52 44 | 45 52 20 49 53 20 52 45 |THIS ORD|ER IS RE|
|00002e70| 56 45 52 53 45 44 20 2d | 2d 20 69 2e 65 2e 2c 20 |VERSED -|- i.e., |
|00002e80| 62 20 2d 20 61 20 61 6e | 64 20 62 2f 61 2c 20 77 |b - a an|d b/a, w|
|00002e90| 68 65 72 65 20 61 20 69 | 73 0a 58 74 68 65 20 6f |here a i|s.Xthe o|
|00002ea0| 76 65 72 72 69 64 69 6e | 67 20 63 6f 6c 75 6d 6e |verridin|g column|
|00002eb0| 20 6e 75 6d 62 65 72 20 | 61 6e 64 20 62 20 69 73 | number |and b is|
|00002ec0| 20 74 68 65 20 69 6d 6d | 65 64 69 61 74 65 6c 79 | the imm|ediately|
|00002ed0| 20 61 64 6a 61 63 65 6e | 74 20 63 65 6c 6c 2e 0a | adjacen|t cell..|
|00002ee0| 58 54 68 69 73 20 73 69 | 74 75 61 74 69 6f 6e 20 |XThis si|tuation |
|00002ef0| 69 73 20 6d 61 64 65 20 | 63 6c 65 61 72 65 72 20 |is made |clearer |
|00002f00| 69 6e 20 74 68 65 20 65 | 78 61 6d 70 6c 65 73 20 |in the e|xamples |
|00002f10| 62 65 6c 6f 77 2e 0a 58 | 0a 58 46 6f 6c 6c 6f 77 |below..X|.XFollow|
|00002f20| 69 6e 67 20 69 73 20 61 | 20 73 75 6d 6d 61 72 79 |ing is a| summary|
|00002f30| 20 6f 66 20 74 68 65 20 | 61 76 61 69 6c 61 62 6c | of the |availabl|
|00002f40| 65 20 66 75 6e 63 74 69 | 6f 6e 73 2c 20 77 68 69 |e functi|ons, whi|
|00002f50| 63 68 20 4d 55 53 54 20 | 62 65 20 69 6e 0a 58 75 |ch MUST |be in.Xu|
|00002f60| 70 70 65 72 20 63 61 73 | 65 20 77 68 65 72 65 20 |pper cas|e where |
|00002f70| 61 70 70 6c 69 63 61 62 | 6c 65 3a 0a 58 0a 58 20 |applicab|le:.X.X |
|00002f80| 20 20 20 53 55 4d 20 2d | 2d 20 50 65 72 66 6f 72 | SUM -|- Perfor|
|00002f90| 6d 73 20 61 64 64 69 74 | 69 6f 6e 20 6f 6e 20 61 |ms addit|ion on a|
|00002fa0| 20 72 61 6e 67 65 20 6f | 66 20 63 65 6c 6c 73 2e | range o|f cells.|
|00002fb0| 0a 58 20 20 20 20 41 56 | 47 20 2d 2d 20 54 61 6b |.X AV|G -- Tak|
|00002fc0| 65 73 20 74 68 65 20 61 | 76 65 72 61 67 65 20 76 |es the a|verage v|
|00002fd0| 61 6c 75 65 20 6f 6e 20 | 61 20 72 61 6e 67 65 20 |alue on |a range |
|00002fe0| 6f 66 20 63 65 6c 6c 73 | 2e 0a 58 20 20 20 20 4d |of cells|..X M|
|00002ff0| 49 4e 20 2d 2d 20 45 78 | 74 72 61 63 74 73 20 74 |IN -- Ex|tracts t|
|00003000| 68 65 20 6d 69 6e 69 6d | 75 6d 20 76 61 6c 75 65 |he minim|um value|
|00003010| 20 6f 6e 20 61 20 72 61 | 6e 67 65 20 6f 66 20 63 | on a ra|nge of c|
|00003020| 65 6c 6c 73 2e 0a 58 20 | 20 20 20 4d 41 58 20 2d |ells..X | MAX -|
|00003030| 2d 20 45 78 74 72 61 63 | 74 73 20 74 68 65 20 6d |- Extrac|ts the m|
|00003040| 69 6e 69 6d 75 6d 20 76 | 61 6c 75 65 20 6f 6e 20 |inimum v|alue on |
|00003050| 61 20 72 61 6e 67 65 20 | 6f 66 20 63 65 6c 6c 73 |a range |of cells|
|00003060| 2e 0a 58 20 20 20 20 56 | 41 52 20 2d 2d 20 43 61 |..X V|AR -- Ca|
|00003070| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 76 61 72 |lculates| the var|
|00003080| 69 61 6e 63 65 20 6f 6e | 20 61 20 72 61 6e 67 65 |iance on| a range|
|00003090| 20 6f 66 20 63 65 6c 6c | 73 2e 0a 58 20 20 20 20 | of cell|s..X |
|000030a0| 53 54 44 20 2d 2d 20 43 | 61 6c 63 75 6c 61 74 65 |STD -- C|alculate|
|000030b0| 73 20 74 68 65 20 73 74 | 61 6e 64 61 72 64 20 64 |s the st|andard d|
|000030c0| 65 76 69 61 74 69 6f 6e | 20 6f 6e 20 61 20 72 61 |eviation| on a ra|
|000030d0| 6e 67 65 20 6f 66 20 63 | 65 6c 6c 73 2e 0a 58 20 |nge of c|ells..X |
|000030e0| 20 20 20 20 2b 20 20 2d | 2d 20 41 64 64 73 20 74 | + -|- Adds t|
|000030f0| 77 6f 20 63 65 6c 6c 73 | 2e 0a 58 20 20 20 20 20 |wo cells|..X |
|00003100| 2d 20 20 2d 2d 20 53 75 | 62 74 72 61 63 74 73 20 |- -- Su|btracts |
|00003110| 74 77 6f 20 63 65 6c 6c | 73 2e 0a 58 20 20 20 20 |two cell|s..X |
|00003120| 20 2a 20 20 2d 2d 20 4d | 75 6c 74 69 70 6c 69 65 | * -- M|ultiplie|
|00003130| 73 20 74 77 6f 20 63 65 | 6c 6c 73 2e 0a 58 20 20 |s two ce|lls..X |
|00003140| 20 20 20 2f 20 20 2d 2d | 20 44 69 76 69 64 65 73 | / --| Divides|
|00003150| 20 74 77 6f 20 63 65 6c | 6c 73 2e 0a 58 20 20 20 | two cel|ls..X |
|00003160| 20 20 25 20 20 2d 2d 20 | 44 69 76 69 64 65 73 20 | % -- |Divides |
|00003170| 74 77 6f 20 63 65 6c 6c | 73 2c 20 61 6e 64 20 6d |two cell|s, and m|
|00003180| 75 6c 74 69 70 6c 69 65 | 73 20 74 68 65 20 72 65 |ultiplie|s the re|
|00003190| 73 75 6c 74 20 62 79 20 | 31 30 30 2e 0a 58 20 20 |sult by |100..X |
|000031a0| 20 20 4e 55 4c 20 2d 2d | 20 54 68 69 73 20 69 73 | NUL --| This is|
|000031b0| 20 61 63 74 75 61 6c 6c | 79 20 6e 6f 74 20 61 20 | actuall|y not a |
|000031c0| 66 75 6e 63 74 69 6f 6e | 2c 20 62 75 74 20 70 65 |function|, but pe|
|000031d0| 72 66 6f 72 6d 73 20 74 | 68 65 20 74 61 73 6b 0a |rforms t|he task.|
|000031e0| 58 20 20 20 20 20 20 20 | 20 20 20 20 6f 66 20 61 |X | of a|
|000031f0| 20 22 70 6c 61 63 65 68 | 6f 6c 64 65 72 22 2c 20 | "placeh|older", |
|00003200| 70 72 65 76 65 6e 74 69 | 6e 67 20 74 68 65 20 22 |preventi|ng the "|
|00003210| 72 65 73 65 74 74 69 6e | 67 22 20 6f 66 20 61 75 |resettin|g" of au|
|00003220| 74 6f 2d 0a 58 20 20 20 | 20 20 20 20 20 20 20 20 |to-.X | |
|00003230| 6d 61 74 69 63 61 6c 6c | 79 20 63 61 6c 63 75 6c |maticall|y calcul|
|00003240| 61 74 65 64 20 6e 75 6d | 65 72 69 63 20 72 61 6e |ated num|eric ran|
|00003250| 67 65 73 20 77 69 74 68 | 6f 75 74 20 63 72 65 61 |ges with|out crea|
|00003260| 74 69 6e 67 0a 58 20 20 | 20 20 20 20 20 20 20 20 |ting.X | |
|00003270| 20 63 65 6c 6c 20 63 6f | 6e 74 65 6e 74 73 2e 20 | cell co|ntents. |
|00003280| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 69 | This fu|nction i|
|00003290| 73 20 6d 6f 73 74 20 66 | 72 65 71 75 65 6e 74 6c |s most f|requentl|
|000032a0| 79 20 75 73 65 64 20 74 | 6f 0a 58 20 20 20 20 20 |y used t|o.X |
|000032b0| 20 20 20 20 20 20 65 78 | 74 65 6e 64 20 74 68 65 | ex|tend the|
|000032c0| 20 72 6f 77 20 72 61 6e | 67 65 20 6f 66 20 61 67 | row ran|ge of ag|
|000032d0| 67 72 65 67 61 74 65 20 | 63 6f 6c 75 6d 6e 20 66 |gregate |column f|
|000032e0| 75 6e 63 74 69 6f 6e 73 | 2e 0a 58 0a 58 0a 58 2e |unctions|..X.X.X.|
|000032f0| 53 48 20 46 4f 52 4d 55 | 4c 41 20 45 58 41 4d 50 |SH FORMU|LA EXAMP|
|00003300| 4c 45 53 0a 58 20 20 20 | 20 48 65 72 65 20 61 72 |LES.X | Here ar|
|00003310| 65 20 73 6f 6d 65 20 73 | 61 6d 70 6c 65 20 69 6e |e some s|ample in|
|00003320| 70 75 74 20 6c 69 6e 65 | 73 2c 20 77 69 74 68 20 |put line|s, with |
|00003330| 72 65 73 75 6c 74 20 66 | 6f 6c 6c 6f 77 69 6e 67 |result f|ollowing|
|00003340| 2e 0a 58 0a 58 20 20 20 | 20 69 6e 70 75 74 3a 0a |..X.X | input:.|
|00003350| 58 20 20 20 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 20 20 |X ---|------ |
|00003360| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d |--------|--- ---|
|00003370| 2d 2d 2d 2d 2d 2d 2d 2d | 20 2d 2d 2d 2d 2d 2d 2d |--------| -------|
|00003380| 2d 2d 2d 2d 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |---- ---|--------|
|00003390| 0a 58 20 20 20 20 77 69 | 64 67 65 74 2d 31 20 20 |.X wi|dget-1 |
|000033a0| 20 20 20 20 31 30 30 2e | 30 30 20 20 20 20 20 20 | 100.|00 |
|000033b0| 20 32 30 30 2e 30 30 20 | 20 20 20 20 20 33 30 30 | 200.00 | 300|
|000033c0| 2e 30 30 20 20 20 20 20 | 40 52 53 55 4d 0a 58 0a |.00 |@RSUM.X.|
|000033d0| 58 20 20 20 20 72 65 73 | 75 6c 74 3a 0a 58 20 20 |X res|ult:.X |
|000033e0| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d | ------|--- ---|
|000033f0| 2d 2d 2d 2d 2d 2d 2d 2d | 20 20 2d 2d 2d 2d 2d 2d |--------| ------|
|00003400| 2d 2d 2d 2d 2d 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- --|--------|
|00003410| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 0a 58 20 |- ------|-----.X |
|00003420| 20 20 20 77 69 64 67 65 | 74 2d 31 20 20 20 20 20 | widge|t-1 |
|00003430| 20 20 20 31 30 30 2e 30 | 30 20 20 20 20 20 20 20 | 100.0|0 |
|00003440| 32 30 30 2e 30 30 20 20 | 20 20 20 20 33 30 30 2e |200.00 | 300.|
|00003450| 30 30 20 20 20 20 20 20 | 36 30 30 2e 30 30 0a 58 |00 |600.00.X|
|00003460| 0a 58 0a 58 20 20 20 20 | 69 6e 70 75 74 3a 0a 58 |.X.X |input:.X|
|00003470| 20 20 20 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 20 2d | ----|----- -|
|00003480| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 20 20 2d 2d 2d 2d |--------|-- ----|
|00003490| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|000034a0| 2d 2d 2d 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 0a |--- ----|-------.|
|000034b0| 58 20 20 20 20 77 69 64 | 67 65 74 2d 31 20 20 20 |X wid|get-1 |
|000034c0| 20 20 20 20 31 30 30 2e | 30 30 20 20 20 20 20 20 | 100.|00 |
|000034d0| 20 32 30 30 2e 30 30 20 | 20 20 20 20 20 33 30 30 | 200.00 | 300|
|000034e0| 2e 30 30 20 20 20 20 20 | 40 52 2b 0a 58 0a 58 20 |.00 |@R+.X.X |
|000034f0| 20 20 20 72 65 73 75 6c | 74 3a 0a 58 20 20 20 20 | resul|t:.X |
|00003500| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 20 20 2d 2d 2d 2d 2d |--------|- -----|
|00003510| 2d 2d 2d 2d 2d 2d 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------ |--------|
|00003520| 2d 2d 2d 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 20 |--- ----|------- |
|00003530| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 0a 58 20 20 20 |--------|---.X |
|00003540| 20 77 69 64 67 65 74 2d | 31 20 20 20 20 20 20 20 | widget-|1 |
|00003550| 20 31 30 30 2e 30 30 20 | 20 20 20 20 20 20 32 30 | 100.00 | 20|
|00003560| 30 2e 30 30 20 20 20 20 | 20 20 33 30 30 2e 30 30 |0.00 | 300.00|
|00003570| 20 20 20 20 20 20 35 30 | 30 2e 30 30 0a 58 0a 58 | 50|0.00.X.X|
|00003580| 0a 58 20 20 20 20 69 6e | 70 75 74 3a 0a 58 20 20 |.X in|put:.X |
|00003590| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d | ------|--- ---|
|000035a0| 2d 2d 2d 2d 2d 2d 2d 2d | 20 20 2d 2d 2d 2d 2d 2d |--------| ------|
|000035b0| 2d 2d 2d 2d 2d 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- --|--------|
|000035c0| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 0a 58 20 |- ------|-----.X |
|000035d0| 20 20 20 77 69 64 67 65 | 74 2d 31 20 20 20 20 20 | widge|t-1 |
|000035e0| 20 20 31 30 30 2e 30 30 | 20 20 20 20 20 20 20 32 | 100.00| 2|
|000035f0| 30 30 2e 30 30 20 20 20 | 20 20 20 33 30 30 2e 30 |00.00 | 300.0|
|00003600| 30 20 20 20 20 20 40 52 | 2f 0a 58 0a 58 20 20 20 |0 @R|/.X.X |
|00003610| 20 72 65 73 75 6c 74 3a | 0a 58 20 20 20 20 2d 2d | result:|.X --|
|00003620| 2d 2d 2d 2d 2d 2d 2d 20 | 20 2d 2d 2d 2d 2d 2d 2d |------- | -------|
|00003630| 2d 2d 2d 2d 20 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |---- --|--------|
|00003640| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d |- ------|----- --|
|00003650| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 0a 58 20 20 20 20 77 |--------|-.X w|
|00003660| 69 64 67 65 74 2d 31 20 | 20 20 20 20 20 20 20 31 |idget-1 | 1|
|00003670| 30 30 2e 30 30 20 20 20 | 20 20 20 20 32 30 30 2e |00.00 | 200.|
|00003680| 30 30 20 20 20 20 20 20 | 33 30 30 2e 30 30 20 20 |00 |300.00 |
|00003690| 20 20 20 20 20 20 30 2e | 36 37 0a 58 0a 58 0a 58 | 0.|67.X.X.X|
|000036a0| 20 20 20 20 69 6e 70 75 | 74 3a 0a 58 20 20 20 20 | inpu|t:.X |
|000036b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 20 20 2d 2d 2d 2d 2d |--------|- -----|
|000036c0| 2d 2d 2d 2d 2d 2d 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------ |--------|
|000036d0| 2d 2d 2d 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 20 |--- ----|------- |
|000036e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 0a 58 20 20 20 |--------|---.X |
|000036f0| 20 77 69 64 67 65 74 2d | 31 20 20 20 20 20 20 20 | widget-|1 |
|00003700| 31 30 30 2e 30 30 20 20 | 20 20 20 20 20 32 30 30 |100.00 | 200|
|00003710| 2e 30 30 20 20 20 20 20 | 20 33 30 30 2e 30 30 20 |.00 | 300.00 |
|00003720| 20 20 20 20 40 52 2f 33 | 0a 58 0a 58 20 20 20 20 | @R/3|.X.X |
|00003730| 72 65 73 75 6c 74 3a 0a | 58 20 20 20 20 2d 2d 2d |result:.|X ---|
|00003740| 2d 2d 2d 2d 2d 2d 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------ |--------|
|00003750| 2d 2d 2d 20 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--- ---|--------|
|00003760| 20 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 20 2d 2d 2d | -------|---- ---|
|00003770| 2d 2d 2d 2d 2d 2d 2d 2d | 0a 58 20 20 20 20 77 69 |--------|.X wi|
|00003780| 64 67 65 74 2d 31 20 20 | 20 20 20 20 20 20 31 30 |dget-1 | 10|
|00003790| 30 2e 30 30 20 20 20 20 | 20 20 20 32 30 30 2e 30 |0.00 | 200.0|
|000037a0| 30 20 20 20 20 20 20 33 | 30 30 2e 30 30 20 20 20 |0 3|00.00 |
|000037b0| 20 20 20 20 20 31 2e 35 | 30 0a 58 0a 58 20 20 20 | 1.5|0.X.X |
|000037c0| 20 4e 6f 74 65 20 69 6e | 20 74 68 65 20 61 62 6f | Note in| the abo|
|000037d0| 76 65 20 65 78 61 6d 70 | 6c 65 20 74 68 61 74 20 |ve examp|le that |
|000037e0| 74 68 65 20 6f 72 64 65 | 72 20 6f 66 20 64 69 76 |the orde|r of div|
|000037f0| 69 73 6f 72 2f 64 69 76 | 69 64 65 6e 64 20 61 73 |isor/div|idend as|
|00003800| 0a 58 20 20 20 20 72 65 | 67 61 72 64 73 20 74 68 |.X re|gards th|
|00003810| 65 20 69 6d 6d 65 64 69 | 61 74 65 6c 79 20 61 64 |e immedi|ately ad|
|00003820| 6a 61 63 65 6e 74 20 63 | 65 6c 6c 20 69 73 20 74 |jacent c|ell is t|
|00003830| 68 65 20 72 65 76 65 72 | 73 65 20 6f 66 20 74 68 |he rever|se of th|
|00003840| 65 0a 58 20 20 20 20 70 | 72 65 76 69 6f 75 73 20 |e.X p|revious |
|00003850| 65 78 61 6d 70 6c 65 2e | 0a 58 0a 58 0a 58 20 69 |example.|.X.X.X i|
|00003860| 6e 70 75 74 3a 0a 58 20 | 2d 2d 2d 2d 2d 2d 2d 2d |nput:.X |--------|
|00003870| 2d 20 20 2d 2d 2d 2d 2d | 2d 2d 2d 20 20 2d 2d 2d |- -----|--- ---|
|00003880| 2d 2d 2d 2d 2d 20 2d 2d | 2d 2d 2d 2d 2d 2d 20 2d |----- --|------ -|
|00003890| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 20 2d 2d 2d 2d 2d 2d |--------|- ------|
|000038a0| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 0a 58 20 77 |- ------|----.X w|
|000038b0| 69 64 67 65 74 2d 31 20 | 20 20 20 31 30 30 2e 30 |idget-1 | 100.0|
|000038c0| 30 20 20 20 20 32 30 30 | 2e 30 30 20 20 20 20 20 |0 200|.00 |
|000038d0| 40 52 53 55 4d 20 20 20 | 20 20 33 30 30 2e 30 30 |@RSUM | 300.00|
|000038e0| 20 20 20 34 30 30 2e 30 | 20 20 20 20 20 40 52 53 | 400.0| @RS|
|000038f0| 55 4d 0a 58 20 77 69 64 | 67 65 74 2d 32 20 20 20 |UM.X wid|get-2 |
|00003900| 20 31 30 30 2e 30 30 20 | 20 20 20 31 30 30 2e 30 | 100.00 | 100.0|
|00003910| 30 20 20 20 20 20 40 52 | 53 55 4d 20 20 20 20 20 |0 @R|SUM |
|00003920| 31 30 30 2e 30 30 20 20 | 20 32 30 30 2e 30 20 20 |100.00 | 200.0 |
|00003930| 20 20 20 40 52 53 55 4d | 34 0a 58 20 20 20 20 20 | @RSUM|4.X |
|00003940| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003950| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 4e | | @N|
|00003960| 55 4c 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 20 |UL.X | |
|00003970| 20 20 40 43 53 55 4d 20 | 20 20 20 20 40 42 53 55 | @CSUM | @BSU|
|00003980| 4d 20 20 20 20 20 40 43 | 53 55 4d 0a 58 0a 58 20 |M @C|SUM.X.X |
|00003990| 72 65 73 75 6c 74 3a 0a | 58 20 2d 2d 2d 2d 2d 2d |result:.|X ------|
|000039a0| 2d 2d 2d 20 20 2d 2d 2d | 2d 2d 2d 2d 2d 20 20 2d |--- ---|----- -|
|000039b0| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|000039c0| 20 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 20 2d 2d 2d | -------|---- ---|
|000039d0| 2d 2d 2d 2d 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 0a |---- ---|-------.|
|000039e0| 58 20 77 69 64 67 65 74 | 2d 31 20 20 20 20 20 31 |X widget|-1 1|
|000039f0| 30 30 2e 30 30 20 20 20 | 20 32 30 30 2e 30 30 20 |00.00 | 200.00 |
|00003a00| 20 20 33 30 30 2e 30 30 | 20 20 20 20 20 20 33 30 | 300.00| 30|
|00003a10| 30 2e 30 30 20 20 20 34 | 30 30 2e 30 20 20 20 20 |0.00 4|00.0 |
|00003a20| 20 37 30 30 2e 30 30 0a | 58 20 77 69 64 67 65 74 | 700.00.|X widget|
|00003a30| 2d 32 20 20 20 20 20 31 | 30 30 2e 30 30 20 20 20 |-2 1|00.00 |
|00003a40| 20 31 30 30 2e 30 30 20 | 20 20 32 30 30 2e 30 30 | 100.00 | 200.00|
|00003a50| 20 20 20 20 20 20 31 30 | 30 2e 30 30 20 20 20 32 | 10|0.00 2|
|00003a60| 30 30 2e 30 20 20 20 20 | 20 35 30 30 2e 30 30 0a |00.0 | 500.00.|
|00003a70| 58 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |X.X | |
|00003a80| 20 32 30 30 2e 30 30 20 | 20 20 20 35 30 30 2e 30 | 200.00 | 500.0|
|00003a90| 30 20 20 20 20 20 30 2e | 30 30 0a 58 0a 58 0a 58 |0 0.|00.X.X.X|
|00003aa0| 0a 58 2e 53 48 20 53 50 | 45 43 49 41 4c 20 43 4f |.X.SH SP|ECIAL CO|
|00003ab0| 4e 53 49 44 45 52 41 54 | 49 4f 4e 53 0a 58 0a 58 |NSIDERAT|IONS.X.X|
|00003ac0| 54 68 65 20 64 61 73 68 | 65 64 2d 6c 69 6e 65 20 |The dash|ed-line |
|00003ad0| 64 65 66 69 6e 69 74 69 | 6f 6e 73 20 6d 75 73 74 |definiti|ons must|
|00003ae0| 20 62 65 67 69 6e 20 61 | 74 20 74 68 65 20 66 69 | begin a|t the fi|
|00003af0| 72 73 74 20 63 68 61 72 | 61 63 74 65 72 0a 58 6f |rst char|acter.Xo|
|00003b00| 66 20 74 68 65 20 6c 69 | 6e 65 20 69 6e 20 77 68 |f the li|ne in wh|
|00003b10| 69 63 68 20 74 68 65 79 | 20 6f 63 63 75 72 2e 0a |ich they| occur..|
|00003b20| 58 0a 58 4f 75 74 70 75 | 74 20 66 69 6c 65 73 20 |X.XOutpu|t files |
|00003b30| 61 72 65 20 62 61 73 69 | 63 61 6c 6c 79 20 69 6e |are basi|cally in|
|00003b40| 20 4c 6f 74 75 73 28 54 | 4d 29 20 22 2e 57 4b 31 | Lotus(T|M) ".WK1|
|00003b50| 22 20 66 6f 72 6d 61 74 | 2c 20 61 6e 64 20 6f 75 |" format|, and ou|
|00003b60| 74 70 75 74 0a 58 66 69 | 6c 65 73 20 73 68 6f 75 |tput.Xfi|les shou|
|00003b70| 6c 64 20 62 65 20 6e 61 | 6d 65 64 20 77 69 74 68 |ld be na|med with|
|00003b80| 20 74 68 69 73 20 65 78 | 74 65 6e 73 69 6f 6e 20 | this ex|tension |
|00003b90| 74 6f 20 70 72 6f 76 69 | 64 65 20 6d 61 78 69 6d |to provi|de maxim|
|00003ba0| 75 6d 0a 58 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |um.Xinfo|rmation |
|00003bb0| 74 6f 20 73 70 72 65 61 | 64 73 68 65 65 74 20 70 |to sprea|dsheet p|
|00003bc0| 72 6f 67 72 61 6d 73 2e | 0a 58 0a 58 42 69 6e 61 |rograms.|.X.XBina|
|00003bd0| 72 79 20 66 75 6e 63 74 | 69 6f 6e 73 20 69 6e 20 |ry funct|ions in |
|00003be0| 63 6f 6c 75 6d 6e 20 66 | 6f 72 6d 75 6c 61 20 63 |column f|ormula c|
|00003bf0| 6f 64 65 73 20 61 72 65 | 20 61 6c 6c 6f 77 65 64 |odes are| allowed|
|00003c00| 2c 20 62 75 74 20 72 61 | 72 65 6c 79 0a 58 6d 61 |, but ra|rely.Xma|
|00003c10| 6b 65 20 6d 75 63 68 20 | 73 65 6e 73 65 2e 0a 58 |ke much |sense..X|
|00003c20| 0a 58 54 68 65 20 70 72 | 6f 67 72 61 6d 20 69 73 |.XThe pr|ogram is|
|00003c30| 20 73 69 6d 70 6c 65 20 | 62 79 20 64 65 73 69 67 | simple |by desig|
|00003c40| 6e 2c 20 61 6e 64 20 6d | 61 6b 65 73 20 6e 6f 20 |n, and m|akes no |
|00003c50| 61 74 74 65 6d 70 74 20 | 74 6f 20 69 6e 63 6f 72 |attempt |to incor|
|00003c60| 70 6f 72 61 74 65 0a 58 | 75 73 65 66 75 6c 2c 20 |porate.X|useful, |
|00003c70| 6d 6f 72 65 20 63 6f 6d | 70 6c 65 78 20 66 65 61 |more com|plex fea|
|00003c80| 74 75 72 65 73 20 73 75 | 63 68 20 61 73 20 61 62 |tures su|ch as ab|
|00003c90| 73 6f 6c 75 74 65 20 63 | 65 6c 6c 20 70 6f 73 69 |solute c|ell posi|
|00003ca0| 74 69 6f 6e 69 6e 67 2c | 0a 58 67 65 6e 65 72 61 |tioning,|.Xgenera|
|00003cb0| 6c 2d 70 75 72 70 6f 73 | 65 20 66 6f 72 6d 75 6c |l-purpos|e formul|
|00003cc0| 61 65 2c 20 6d 61 63 72 | 6f 73 2c 20 65 74 63 2e |ae, macr|os, etc.|
|00003cd0| 20 20 49 74 20 61 6c 73 | 6f 20 68 61 73 20 6e 6f | It als|o has no|
|00003ce0| 74 20 75 6e 64 65 72 67 | 6f 6e 65 0a 58 61 20 63 |t underg|one.Xa c|
|00003cf0| 6f 6d 70 6c 65 74 65 20 | 74 65 73 74 20 73 75 69 |omplete |test sui|
|00003d00| 74 65 2e 0a 58 0a 58 0a | 58 2e 53 48 20 42 55 47 |te..X.X.|X.SH BUG|
|00003d10| 53 0a 58 0a 58 54 68 65 | 20 6d 61 78 69 6d 75 6d |S.X.XThe| maximum|
|00003d20| 20 6e 75 6d 62 65 72 20 | 6f 66 20 63 6f 6c 75 6d | number |of colum|
|00003d30| 6e 73 20 69 73 20 63 75 | 72 72 65 6e 74 6c 79 20 |ns is cu|rrently |
|00003d40| 68 61 72 64 2d 63 6f 64 | 65 64 20 69 6e 74 6f 20 |hard-cod|ed into |
|00003d50| 74 68 65 20 0a 58 70 72 | 6f 67 72 61 6d 20 61 74 |the .Xpr|ogram at|
|00003d60| 20 31 32 34 3b 20 6d 65 | 6d 6f 72 79 20 73 68 6f | 124; me|mory sho|
|00003d70| 75 6c 64 20 62 65 20 64 | 79 6e 61 6d 69 63 61 6c |uld be d|ynamical|
|00003d80| 6c 79 20 61 6c 6c 6f 63 | 61 74 65 64 20 74 6f 20 |ly alloc|ated to |
|00003d90| 73 75 70 70 6f 72 74 0a | 58 61 6e 20 61 72 62 69 |support.|Xan arbi|
|00003da0| 74 72 61 72 79 20 73 70 | 72 65 61 64 73 68 65 65 |trary sp|readshee|
|00003db0| 74 20 73 69 7a 65 2e 0a | 58 0a 58 4f 70 74 69 6d |t size..|X.XOptim|
|00003dc0| 69 7a 61 74 69 6f 6e 73 | 20 63 6f 75 6c 64 20 62 |izations| could b|
|00003dd0| 65 20 61 70 70 6c 69 65 | 64 20 61 74 20 73 65 76 |e applie|d at sev|
|00003de0| 65 72 61 6c 20 70 6f 69 | 6e 74 73 2e 0a 58 0a 58 |eral poi|nts..X.X|
|00003df0| 53 74 61 72 74 69 6e 67 | 2f 65 6e 64 69 6e 67 20 |Starting|/ending |
|00003e00| 70 6f 69 6e 74 73 20 66 | 6f 72 20 66 6f 72 6d 75 |points f|or formu|
|00003e10| 6c 61 65 20 73 68 6f 75 | 6c 64 20 62 65 20 61 72 |lae shou|ld be ar|
|00003e20| 62 69 74 72 61 72 69 6c | 79 0a 58 73 70 65 63 69 |bitraril|y.Xspeci|
|00003e30| 66 69 61 62 6c 65 2e 0a | 45 4e 44 5f 4f 46 5f 46 |fiable..|END_OF_F|
|00003e40| 49 4c 45 0a 69 66 20 74 | 65 73 74 20 31 30 30 39 |ILE.if t|est 1009|
|00003e50| 37 20 2d 6e 65 20 60 77 | 63 20 2d 63 20 3c 27 63 |7 -ne `w|c -c <'c|
|00003e60| 6f 6e 76 31 32 33 2e 31 | 27 60 3b 20 74 68 65 6e |onv123.1|'`; then|
|00003e70| 0a 20 20 20 20 65 63 68 | 6f 20 73 68 61 72 3a 20 |. ech|o shar: |
|00003e80| 5c 22 27 63 6f 6e 76 31 | 32 33 2e 31 27 5c 22 20 |\"'conv1|23.1'\" |
|00003e90| 75 6e 70 61 63 6b 65 64 | 20 77 69 74 68 20 77 72 |unpacked| with wr|
|00003ea0| 6f 6e 67 20 73 69 7a 65 | 21 0a 66 69 0a 23 20 65 |ong size|!.fi.# e|
|00003eb0| 6e 64 20 6f 66 20 27 63 | 6f 6e 76 31 32 33 2e 31 |nd of 'c|onv123.1|
|00003ec0| 27 0a 66 69 0a 69 66 20 | 74 65 73 74 20 2d 66 20 |'.fi.if |test -f |
|00003ed0| 27 63 6f 6e 76 31 32 33 | 2e 64 6f 63 27 20 2d 61 |'conv123|.doc' -a|
|00003ee0| 20 22 24 7b 31 7d 22 20 | 21 3d 20 22 2d 63 22 20 | "${1}" |!= "-c" |
|00003ef0| 3b 20 74 68 65 6e 20 0a | 20 20 65 63 68 6f 20 73 |; then .| echo s|
|00003f00| 68 61 72 3a 20 57 69 6c | 6c 20 6e 6f 74 20 63 6c |har: Wil|l not cl|
|00003f10| 6f 62 62 65 72 20 65 78 | 69 73 74 69 6e 67 20 66 |obber ex|isting f|
|00003f20| 69 6c 65 20 5c 22 27 63 | 6f 6e 76 31 32 33 2e 64 |ile \"'c|onv123.d|
|00003f30| 6f 63 27 5c 22 0a 65 6c | 73 65 0a 65 63 68 6f 20 |oc'\".el|se.echo |
|00003f40| 73 68 61 72 3a 20 45 78 | 74 72 61 63 74 69 6e 67 |shar: Ex|tracting|
|00003f50| 20 5c 22 27 63 6f 6e 76 | 31 32 33 2e 64 6f 63 27 | \"'conv|123.doc'|
|00003f60| 5c 22 20 5c 28 31 30 34 | 37 34 20 63 68 61 72 61 |\" \(104|74 chara|
|00003f70| 63 74 65 72 73 5c 29 0a | 73 65 64 20 22 73 2f 5e |cters\).|sed "s/^|
|00003f80| 58 2f 2f 22 20 3e 27 63 | 6f 6e 76 31 32 33 2e 64 |X//" >'c|onv123.d|
|00003f90| 6f 63 27 20 3c 3c 27 45 | 4e 44 5f 4f 46 5f 46 49 |oc' <<'E|ND_OF_FI|
|00003fa0| 4c 45 27 0a 58 0a 58 0a | 58 4e 41 4d 45 0a 58 20 |LE'.X.X.|XNAME.X |
|00003fb0| 20 20 20 63 6f 6e 76 65 | 72 74 20 31 32 33 20 2d | conve|rt 123 -|
|00003fc0| 20 54 68 65 20 41 53 43 | 49 49 20 74 6f 20 4c 6f | The ASC|II to Lo|
|00003fd0| 74 75 73 2f 31 32 33 28 | 54 4d 29 20 73 70 72 65 |tus/123(|TM) spre|
|00003fe0| 61 64 73 68 65 65 74 20 | 63 6f 6e 76 65 72 74 65 |adsheet |converte|
|00003ff0| 72 0a 58 0a 58 53 59 4e | 4f 50 53 49 53 0a 58 20 |r.X.XSYN|OPSIS.X |
|00004000| 20 20 20 63 6f 6e 76 31 | 32 33 20 5b 69 6e 70 75 | conv1|23 [inpu|
|00004010| 74 66 69 6c 65 5d 20 5b | 6f 75 74 70 75 74 66 69 |tfile] [|outputfi|
|00004020| 6c 65 5d 0a 58 0a 58 49 | 4e 54 52 4f 44 55 43 54 |le].X.XI|NTRODUCT|
|00004030| 49 4f 4e 0a 58 20 20 20 | 20 63 6f 6e 76 31 32 33 |ION.X | conv123|
|00004040| 20 69 73 20 61 20 75 74 | 69 6c 69 74 79 20 66 6f | is a ut|ility fo|
|00004050| 72 20 72 65 61 64 69 6e | 67 20 61 20 73 70 65 63 |r readin|g a spec|
|00004060| 69 61 6c 6c 79 2d 66 6f | 72 6d 61 74 74 65 64 20 |ially-fo|rmatted |
|00004070| 66 6c 61 74 0a 58 20 20 | 20 20 41 53 43 49 49 20 |flat.X | ASCII |
|00004080| 66 69 6c 65 20 61 6e 64 | 20 63 6f 6e 76 65 72 74 |file and| convert|
|00004090| 69 6e 67 20 69 74 20 69 | 6e 74 6f 20 61 20 4c 6f |ing it i|nto a Lo|
|000040a0| 74 75 73 2f 31 32 33 28 | 54 4d 29 20 22 2e 77 6b |tus/123(|TM) ".wk|
|000040b0| 31 22 20 66 69 6c 65 2e | 0a 58 20 20 20 20 45 61 |1" file.|.X Ea|
|000040c0| 63 68 20 73 70 65 63 69 | 61 6c 6c 79 2d 66 6f 72 |ch speci|ally-for|
|000040d0| 6d 61 74 74 65 64 20 41 | 53 43 49 49 20 66 69 6c |matted A|SCII fil|
|000040e0| 65 20 63 72 65 61 74 65 | 73 20 6f 6e 65 20 65 6e |e create|s one en|
|000040f0| 74 69 72 65 20 73 70 72 | 65 61 64 2d 0a 58 20 20 |tire spr|ead-.X |
|00004100| 20 20 73 68 65 65 74 2e | 20 20 54 68 69 73 20 73 | sheet.| This s|
|00004110| 70 72 65 61 64 73 68 65 | 65 74 20 66 69 6c 65 20 |preadshe|et file |
|00004120| 69 73 20 69 6e 20 69 74 | 73 20 66 69 6e 61 6c 2c |is in it|s final,|
|00004130| 20 64 69 72 65 63 74 6c | 79 2d 72 65 61 64 61 62 | directl|y-readab|
|00004140| 6c 65 20 0a 58 20 20 20 | 20 62 69 6e 61 72 79 20 |le .X | binary |
|00004150| 66 6f 72 6d 2c 20 61 6e | 64 20 6e 65 65 64 20 75 |form, an|d need u|
|00004160| 6e 64 65 72 67 6f 20 6e | 6f 20 66 75 72 74 68 65 |ndergo n|o furthe|
|00004170| 72 20 74 72 61 6e 73 6c | 61 74 69 6f 6e 20 62 65 |r transl|ation be|
|00004180| 66 6f 72 65 20 62 65 69 | 6e 67 0a 58 20 20 20 20 |fore bei|ng.X |
|00004190| 72 65 61 64 20 64 69 72 | 65 63 74 6c 79 20 62 79 |read dir|ectly by|
|000041a0| 20 4c 6f 74 75 73 2f 31 | 32 33 28 54 4d 29 2e 20 | Lotus/1|23(TM). |
|000041b0| 20 54 68 69 73 20 66 65 | 61 74 75 72 65 20 6d 61 | This fe|ature ma|
|000041c0| 6b 65 73 20 63 6f 6e 76 | 31 32 33 20 65 73 70 65 |kes conv|123 espe|
|000041d0| 63 69 61 6c 6c 79 0a 58 | 20 20 20 20 73 75 69 74 |cially.X| suit|
|000041e0| 65 64 20 74 6f 20 6e 65 | 74 77 6f 72 6b 65 64 20 |ed to ne|tworked |
|000041f0| 65 6e 76 69 72 6f 6e 6d | 65 6e 74 73 2c 20 77 68 |environm|ents, wh|
|00004200| 65 72 65 20 72 65 70 6f | 72 74 20 77 72 69 74 65 |ere repo|rt write|
|00004210| 72 73 20 6f 72 20 70 72 | 6f 67 72 61 6d 73 0a 58 |rs or pr|ograms.X|
|00004220| 20 20 20 20 72 75 6e 6e | 69 6e 67 20 6f 6e 20 74 | runn|ing on t|
|00004230| 72 61 6e 73 61 63 74 69 | 6f 6e 20 70 72 6f 63 65 |ransacti|on proce|
|00004240| 73 73 69 6e 67 20 6d 61 | 63 68 69 6e 65 73 20 63 |ssing ma|chines c|
|00004250| 61 6e 20 65 61 73 69 6c | 79 20 61 6e 64 20 64 69 |an easil|y and di|
|00004260| 72 65 63 74 6c 79 0a 58 | 20 20 20 20 63 72 65 61 |rectly.X| crea|
|00004270| 74 65 20 73 70 72 65 61 | 64 73 68 65 65 74 20 6f |te sprea|dsheet o|
|00004280| 75 74 70 75 74 2c 20 69 | 6e 73 74 61 6e 74 6c 79 |utput, i|nstantly|
|00004290| 20 72 65 61 64 79 20 66 | 6f 72 20 63 6f 70 79 69 | ready f|or copyi|
|000042a0| 6e 67 2c 20 64 6f 77 6e | 6c 6f 61 64 69 6e 67 2c |ng, down|loading,|
|000042b0| 0a 58 20 20 20 20 6f 72 | 20 64 69 72 65 63 74 20 |.X or| direct |
|000042c0| 61 63 63 65 73 73 20 69 | 6e 20 74 68 65 20 4d 53 |access i|n the MS|
|000042d0| 2d 44 4f 53 28 54 4d 29 | 20 6f 72 20 4d 61 63 69 |-DOS(TM)| or Maci|
|000042e0| 6e 74 6f 73 68 28 54 4d | 29 20 65 6e 76 69 72 6f |ntosh(TM|) enviro|
|000042f0| 6e 6d 65 6e 74 73 2e 0a | 58 20 20 20 20 49 6e 20 |nments..|X In |
|00004300| 61 64 64 69 74 69 6f 6e | 20 74 6f 20 69 6e 64 69 |addition| to indi|
|00004310| 76 69 64 75 61 6c 20 64 | 61 74 61 20 76 61 6c 75 |vidual d|ata valu|
|00004320| 65 73 2c 20 63 65 72 74 | 61 69 6e 20 63 6f 6d 6d |es, cert|ain comm|
|00004330| 6f 6e 20 61 67 67 72 65 | 67 61 74 65 0a 58 20 20 |on aggre|gate.X |
|00004340| 20 20 66 75 6e 63 74 69 | 6f 6e 73 20 28 66 6f 72 | functi|ons (for|
|00004350| 6d 75 6c 61 73 29 20 6d | 61 79 20 62 65 20 73 70 |mulas) m|ay be sp|
|00004360| 65 63 69 66 69 65 64 20 | 28 73 75 6d 2c 6d 69 6e |ecified |(sum,min|
|00004370| 2c 6d 61 78 2c 76 61 72 | 69 61 6e 63 65 2c 73 74 |,max,var|iance,st|
|00004380| 64 0a 58 20 20 20 20 64 | 65 76 69 61 74 69 6f 6e |d.X d|eviation|
|00004390| 2c 20 61 6e 64 20 61 76 | 65 72 61 67 65 29 2c 20 |, and av|erage), |
|000043a0| 61 6e 64 20 66 69 76 65 | 20 62 69 6e 61 72 79 20 |and five| binary |
|000043b0| 66 75 6e 63 74 69 6f 6e | 73 20 28 61 64 64 69 74 |function|s (addit|
|000043c0| 69 6f 6e 2c 0a 58 20 20 | 20 20 73 75 62 74 72 61 |ion,.X | subtra|
|000043d0| 63 74 69 6f 6e 2c 20 6d | 75 6c 74 69 70 6c 69 63 |ction, m|ultiplic|
|000043e0| 61 74 69 6f 6e 2c 20 64 | 69 76 69 73 69 6f 6e 2c |ation, d|ivision,|
|000043f0| 20 61 6e 64 20 70 65 72 | 63 65 6e 74 61 67 65 29 | and per|centage)|
|00004400| 20 6d 61 79 20 61 6c 73 | 6f 0a 58 20 20 20 20 62 | may als|o.X b|
|00004410| 65 20 73 70 65 63 69 66 | 69 65 64 2e 0a 58 0a 58 |e specif|ied..X.X|
|00004420| 20 20 20 20 54 68 65 20 | 69 6e 70 75 74 20 66 69 | The |input fi|
|00004430| 6c 65 20 66 6f 72 6d 61 | 74 20 68 61 73 20 62 65 |le forma|t has be|
|00004440| 65 6e 20 6f 70 74 69 6d | 69 7a 65 64 20 66 6f 72 |en optim|ized for|
|00004450| 20 67 65 6e 65 72 61 74 | 69 6f 6e 20 62 79 20 61 | generat|ion by a|
|00004460| 0a 58 20 20 20 20 73 69 | 6d 70 6c 65 20 74 6f 70 |.X si|mple top|
|00004470| 2d 64 6f 77 6e 2c 20 6c | 65 66 74 2d 74 6f 2d 72 |-down, l|eft-to-r|
|00004480| 69 67 68 74 20 72 65 70 | 6f 72 74 20 67 65 6e 65 |ight rep|ort gene|
|00004490| 72 61 74 6f 72 2c 20 61 | 6e 64 20 69 73 20 68 75 |rator, a|nd is hu|
|000044a0| 6d 61 6e 0a 58 20 20 20 | 20 72 65 61 64 61 62 6c |man.X | readabl|
|000044b0| 65 2e 20 20 54 68 65 20 | 69 6e 70 75 74 20 6c 6f |e. The |input lo|
|000044c0| 67 69 63 20 68 61 73 20 | 62 65 65 6e 20 6d 61 64 |gic has |been mad|
|000044d0| 65 20 66 61 69 72 6c 79 | 20 69 6e 74 65 6c 6c 69 |e fairly| intelli|
|000044e0| 67 65 6e 74 2c 0a 58 20 | 20 20 20 61 75 74 6f 6d |gent,.X | autom|
|000044f0| 61 74 69 63 61 6c 6c 79 | 20 64 69 73 63 65 72 6e |atically| discern|
|00004500| 69 6e 67 20 62 65 74 77 | 65 65 6e 20 6e 75 6d 65 |ing betw|een nume|
|00004510| 72 69 63 20 61 6e 64 20 | 6e 6f 6e 2d 6e 75 6d 65 |ric and |non-nume|
|00004520| 72 69 63 20 76 61 6c 75 | 65 73 2c 0a 58 20 20 20 |ric valu|es,.X |
|00004530| 20 63 61 6c 63 75 6c 61 | 74 69 6e 67 20 66 6f 72 | calcula|ting for|
|00004540| 6d 75 6c 61 20 72 61 6e | 67 65 73 2c 20 61 6e 64 |mula ran|ges, and|
|00004550| 20 63 61 6c 63 75 6c 61 | 74 69 6e 67 20 74 68 65 | calcula|ting the|
|00004560| 20 6d 61 78 69 6d 75 6d | 20 6e 75 6d 62 65 72 0a | maximum| number.|
|00004570| 58 20 20 20 20 6f 66 20 | 64 65 63 69 6d 61 6c 20 |X of |decimal |
|00004580| 70 6c 61 63 65 73 20 69 | 6e 20 61 20 72 6f 77 20 |places i|n a row |
|00004590| 6f 72 20 63 6f 6c 75 6d | 6e 2e 0a 58 0a 58 4f 50 |or colum|n..X.XOP|
|000045a0| 54 49 4f 4e 53 0a 58 20 | 20 20 20 54 68 65 72 65 |TIONS.X | There|
|000045b0| 20 61 72 65 20 63 75 72 | 72 65 6e 74 6c 79 20 6e | are cur|rently n|
|000045c0| 6f 20 63 6f 6d 6d 61 6e | 64 2d 6c 69 6e 65 20 6f |o comman|d-line o|
|000045d0| 70 74 69 6f 6e 73 20 66 | 6f 72 20 63 6f 6e 76 31 |ptions f|or conv1|
|000045e0| 32 33 2e 0a 58 0a 58 50 | 41 52 41 4d 45 54 45 52 |23..X.XP|ARAMETER|
|000045f0| 53 0a 58 20 20 20 20 54 | 68 65 20 6f 6e 6c 79 20 |S.X T|he only |
|00004600| 70 61 72 61 6d 65 74 65 | 72 73 20 61 72 65 20 74 |paramete|rs are t|
|00004610| 68 65 20 69 6e 70 75 74 | 20 61 6e 64 20 6f 75 74 |he input| and out|
|00004620| 70 75 74 20 66 69 6c 65 | 20 6e 61 6d 65 73 2c 20 |put file| names, |
|00004630| 62 6f 74 68 0a 58 20 20 | 20 20 6f 66 20 77 68 69 |both.X | of whi|
|00004640| 63 68 20 61 72 65 20 6f | 70 74 69 6f 6e 61 6c 3b |ch are o|ptional;|
|00004650| 20 63 6f 6e 76 31 32 33 | 20 63 61 6e 20 61 63 74 | conv123| can act|
|00004660| 20 61 73 20 61 20 66 69 | 6c 74 65 72 2c 20 61 6e | as a fi|lter, an|
|00004670| 64 20 62 79 0a 58 20 20 | 20 20 64 65 66 61 75 6c |d by.X | defaul|
|00004680| 74 20 61 63 63 65 70 74 | 73 20 69 74 73 20 69 6e |t accept|s its in|
|00004690| 70 75 74 20 66 72 6f 6d | 20 73 74 64 69 6e 20 61 |put from| stdin a|
|000046a0| 6e 64 20 73 65 6e 64 73 | 20 69 74 73 20 6f 75 74 |nd sends| its out|
|000046b0| 70 75 74 20 74 6f 0a 58 | 20 20 20 20 73 74 64 6f |put to.X| stdo|
|000046c0| 75 74 2e 0a 58 0a 58 49 | 4e 50 55 54 20 46 49 4c |ut..X.XI|NPUT FIL|
|000046d0| 45 20 46 4f 52 4d 41 54 | 0a 58 20 20 20 20 54 68 |E FORMAT|.X Th|
|000046e0| 65 20 6d 61 6a 6f 72 20 | 66 65 61 74 75 72 65 20 |e major |feature |
|000046f0| 6f 66 20 74 68 65 20 69 | 6e 70 75 74 20 66 69 6c |of the i|nput fil|
|00004700| 65 20 66 6f 72 6d 61 74 | 20 69 73 20 61 20 22 64 |e format| is a "d|
|00004710| 65 66 69 6e 69 74 69 6f | 6e 22 0a 58 20 20 20 20 |efinitio|n".X |
|00004720| 6c 69 6e 65 2c 20 63 6f | 6e 73 69 73 74 69 6e 67 |line, co|nsisting|
|00004730| 20 6f 66 20 61 6c 6c 20 | 64 61 73 68 65 73 20 28 | of all |dashes (|
|00004740| 2d 29 20 61 6e 64 20 73 | 70 61 63 65 73 2e 20 20 |-) and s|paces. |
|00004750| 45 61 63 68 20 73 74 72 | 69 6e 67 20 6f 66 0a 58 |Each str|ing of.X|
|00004760| 20 20 20 20 63 6f 6e 74 | 69 67 75 6f 75 73 20 64 | cont|iguous d|
|00004770| 61 73 68 65 73 20 6f 6e | 20 74 68 65 20 22 64 65 |ashes on| the "de|
|00004780| 66 69 6e 69 74 69 6f 6e | 22 20 6c 69 6e 65 20 77 |finition|" line w|
|00004790| 69 6c 6c 20 62 65 63 6f | 6d 65 20 61 20 63 6f 6c |ill beco|me a col|
|000047a0| 75 6d 6e 0a 58 20 20 20 | 20 69 6e 20 4c 6f 74 75 |umn.X | in Lotu|
|000047b0| 73 2f 31 32 33 28 54 4d | 29 2c 20 74 68 65 20 77 |s/123(TM|), the w|
|000047c0| 69 64 74 68 20 6f 66 20 | 74 68 61 74 20 63 6f 6c |idth of |that col|
|000047d0| 75 6d 6e 20 62 65 69 6e | 67 20 64 65 74 65 72 6d |umn bein|g determ|
|000047e0| 69 6e 65 64 20 62 79 20 | 74 68 65 0a 58 20 20 20 |ined by |the.X |
|000047f0| 20 6e 75 6d 62 65 72 20 | 6f 66 20 64 61 73 68 65 | number |of dashe|
|00004800| 73 2e 20 20 43 68 61 72 | 61 63 74 65 72 73 20 69 |s. Char|acters i|
|00004810| 6e 20 74 68 65 20 69 6e | 70 75 74 20 66 69 6c 65 |n the in|put file|
|00004820| 20 74 68 61 74 20 66 61 | 6c 6c 20 6f 75 74 73 69 | that fa|ll outsi|
|00004830| 64 65 0a 58 20 20 20 20 | 74 68 65 73 65 20 22 63 |de.X |these "c|
|00004840| 6f 6c 75 6d 6e 20 64 65 | 66 69 6e 69 74 69 6f 6e |olumn de|finition|
|00004850| 73 22 20 61 72 65 20 69 | 67 6e 6f 72 65 64 2e 20 |s" are i|gnored. |
|00004860| 20 49 6e 20 61 64 64 69 | 74 69 6f 6e 2c 20 75 70 | In addi|tion, up|
|00004870| 20 74 6f 20 74 77 6f 20 | 28 32 29 0a 58 20 20 20 | to two |(2).X |
|00004880| 20 6c 69 6e 65 73 20 61 | 62 6f 76 65 20 74 68 65 | lines a|bove the|
|00004890| 20 22 64 65 66 69 6e 69 | 74 69 6f 6e 22 20 6c 69 | "defini|tion" li|
|000048a0| 6e 65 20 63 61 6e 20 62 | 65 20 75 73 65 64 20 66 |ne can b|e used f|
|000048b0| 6f 72 20 68 65 61 64 65 | 72 20 69 6e 66 6f 72 6d |or heade|r inform|
|000048c0| 61 74 69 6f 6e 2c 0a 58 | 20 20 20 20 74 68 6f 75 |ation,.X| thou|
|000048d0| 67 68 20 74 68 69 73 20 | 69 73 20 6e 6f 74 20 72 |gh this |is not r|
|000048e0| 65 71 75 69 72 65 64 2e | 20 20 54 68 65 72 65 20 |equired.| There |
|000048f0| 6d 61 79 20 6e 6f 74 20 | 62 65 20 61 6e 79 20 77 |may not |be any w|
|00004900| 68 69 74 65 20 73 70 61 | 63 65 20 62 65 66 6f 72 |hite spa|ce befor|
|00004910| 65 0a 58 20 20 20 20 74 | 68 65 20 66 69 72 73 74 |e.X t|he first|
|00004920| 20 64 61 73 68 20 6f 6e | 20 74 68 65 20 64 65 66 | dash on| the def|
|00004930| 69 6e 69 74 69 6f 6e 20 | 6c 69 6e 65 3b 20 69 6e |inition |line; in|
|00004940| 20 6f 74 68 65 72 20 77 | 6f 72 64 73 2c 20 74 68 | other w|ords, th|
|00004950| 65 20 64 65 66 69 6e 69 | 74 69 6f 6e 0a 58 20 20 |e defini|tion.X |
|00004960| 20 20 6c 69 6e 65 20 4d | 55 53 54 20 62 65 67 69 | line M|UST begi|
|00004970| 6e 20 69 6e 20 74 68 65 | 20 66 69 72 73 74 20 63 |n in the| first c|
|00004980| 6f 6c 75 6d 6e 20 6f 66 | 20 74 68 65 20 69 6e 70 |olumn of| the inp|
|00004990| 75 74 20 66 69 6c 65 2e | 0a 58 0a 58 20 20 20 20 |ut file.|.X.X |
|000049a0| 46 6f 6c 6c 6f 77 69 6e | 67 20 69 73 20 61 6e 20 |Followin|g is an |
|000049b0| 65 78 61 6d 70 6c 65 20 | 69 6e 70 75 74 20 66 69 |example |input fi|
|000049c0| 6c 65 2c 20 66 6f 6c 6c | 6f 77 65 64 20 62 79 20 |le, foll|owed by |
|000049d0| 61 20 6d 6f 72 65 20 64 | 65 74 61 69 6c 65 64 0a |a more d|etailed.|
|000049e0| 58 20 20 20 20 65 78 70 | 6c 61 6e 61 74 69 6f 6e |X exp|lanation|
|000049f0| 20 6f 66 20 69 74 73 20 | 63 6f 6e 74 65 6e 74 73 | of its |contents|
|00004a00| 3a 0a 58 0a 58 20 20 20 | 20 20 20 20 20 20 20 20 |:.X.X | |
|00004a10| 20 20 20 20 20 20 20 20 | 4a 61 6e 20 20 20 20 20 | |Jan |
|00004a20| 20 20 20 20 20 46 65 62 | 20 20 20 20 20 20 20 20 | Feb| |
|00004a30| 20 4d 61 72 20 20 20 20 | 20 20 20 20 20 51 74 72 | Mar | Qtr|
|00004a40| 0a 58 20 20 20 20 20 50 | 72 6f 64 75 63 74 20 20 |.X P|roduct |
|00004a50| 20 20 20 20 53 61 6c 65 | 73 20 20 20 20 20 20 20 | Sale|s |
|00004a60| 20 53 61 6c 65 73 20 20 | 20 20 20 20 20 53 61 6c | Sales | Sal|
|00004a70| 65 73 20 20 20 20 20 20 | 20 54 6f 74 61 6c 0a 58 |es | Total.X|
|00004a80| 20 20 20 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 20 2d | ----|----- -|
|00004a90| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 20 20 2d 2d 2d 2d |--------|-- ----|
|00004aa0| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|00004ab0| 2d 2d 2d 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 0a |--- ----|-------.|
|00004ac0| 58 20 20 20 20 77 69 64 | 67 65 74 2d 31 20 20 20 |X wid|get-1 |
|00004ad0| 20 20 34 35 30 30 30 2e | 38 37 20 20 20 20 20 20 | 45000.|87 |
|00004ae0| 20 35 34 33 39 30 2e 39 | 20 20 20 20 37 35 39 34 | 54390.9| 7594|
|00004af0| 37 2e 31 32 20 20 20 20 | 20 40 52 53 55 4d 0a 58 |7.12 | @RSUM.X|
|00004b00| 20 20 20 20 77 69 64 67 | 65 74 2d 32 20 20 20 20 | widg|et-2 |
|00004b10| 20 34 37 30 30 30 2e 37 | 38 20 20 20 20 20 20 20 | 47000.7|8 |
|00004b20| 36 34 35 35 30 2e 30 20 | 20 20 20 37 33 36 34 37 |64550.0 | 73647|
|00004b30| 2e 37 37 20 20 20 20 20 | 40 52 53 55 4d 0a 58 20 |.77 |@RSUM.X |
|00004b40| 20 20 20 77 69 64 67 65 | 74 2d 33 20 20 20 20 20 | widge|t-3 |
|00004b50| 34 37 38 30 30 2e 31 31 | 20 20 20 20 20 20 20 36 |47800.11| 6|
|00004b60| 37 38 33 30 2e 35 20 20 | 20 20 35 34 35 33 36 2e |7830.5 | 54536.|
|00004b70| 33 37 20 20 20 20 20 40 | 52 53 55 4d 0a 58 20 20 |37 @|RSUM.X |
|00004b80| 20 20 77 69 64 67 65 74 | 2d 34 20 20 20 20 20 33 | widget|-4 3|
|00004b90| 33 30 30 33 2e 33 30 20 | 20 20 20 20 20 20 37 36 |3003.30 | 76|
|00004ba0| 35 33 30 2e 37 20 20 20 | 20 39 38 36 35 33 2e 38 |530.7 | 98653.8|
|00004bb0| 33 20 20 20 20 20 40 52 | 53 55 4d 0a 58 20 20 20 |3 @R|SUM.X |
|00004bc0| 20 77 69 64 67 65 74 2d | 35 20 20 20 20 20 31 32 | widget-|5 12|
|00004bd0| 30 30 30 2e 34 34 20 20 | 20 20 20 20 20 36 34 38 |000.44 | 648|
|00004be0| 33 36 2e 37 20 20 20 20 | 32 37 36 33 37 2e 39 31 |36.7 |27637.91|
|00004bf0| 20 20 20 20 20 40 52 53 | 55 4d 0a 58 0a 58 20 20 | @RS|UM.X.X |
|00004c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c10| 20 20 20 40 43 53 55 4d | 20 20 20 20 20 20 20 20 | @CSUM| |
|00004c20| 40 43 53 55 4d 20 20 20 | 20 20 20 20 40 43 53 55 |@CSUM | @CSU|
|00004c30| 4d 20 20 20 20 20 40 43 | 53 55 4d 0a 58 0a 58 20 |M @C|SUM.X.X |
|00004c40| 20 20 20 54 68 69 73 20 | 69 73 20 61 20 66 61 69 | This |is a fai|
|00004c50| 72 6c 79 20 73 69 6d 70 | 6c 65 20 73 70 72 65 61 |rly simp|le sprea|
|00004c60| 64 73 68 65 65 74 20 77 | 69 74 68 20 74 65 6e 20 |dsheet w|ith ten |
|00004c70| 72 6f 77 73 20 61 6e 64 | 20 66 69 76 65 0a 58 20 |rows and| five.X |
|00004c80| 20 20 20 63 6f 6c 75 6d | 6e 73 2e 20 20 54 68 65 | colum|ns. The|
|00004c90| 20 66 69 66 74 68 20 63 | 6f 6c 75 6d 6e 20 69 73 | fifth c|olumn is|
|00004ca0| 20 61 63 74 75 61 6c 6c | 79 20 6d 61 64 65 20 6f | actuall|y made o|
|00004cb0| 66 20 66 6f 72 6d 75 6c | 61 73 0a 58 20 20 20 20 |f formul|as.X |
|00004cc0| 28 22 72 6f 77 20 73 75 | 6d 73 22 29 2c 20 61 73 |("row su|ms"), as|
|00004cd0| 20 69 73 20 74 68 65 20 | 6c 61 73 74 20 72 6f 77 | is the |last row|
|00004ce0| 20 28 22 63 6f 6c 75 6d | 6e 20 73 75 6d 73 22 29 | ("colum|n sums")|
|00004cf0| 2e 20 20 63 6f 6e 76 31 | 32 33 20 69 73 0a 58 20 |. conv1|23 is.X |
|00004d00| 20 20 20 73 6d 61 72 74 | 20 65 6e 6f 75 67 68 20 | smart| enough |
|00004d10| 74 6f 20 6b 6e 6f 77 20 | 74 68 61 74 20 65 61 63 |to know |that eac|
|00004d20| 68 20 64 61 74 61 20 76 | 61 6c 75 65 20 69 6e 20 |h data v|alue in |
|00004d30| 74 68 65 20 66 69 72 73 | 74 20 63 6f 6c 75 6d 6e |the firs|t column|
|00004d40| 0a 58 20 20 20 20 69 73 | 20 6e 6f 6e 2d 6e 75 6d |.X is| non-num|
|00004d50| 65 72 69 63 2c 20 61 6e | 64 20 63 72 65 61 74 65 |eric, an|d create|
|00004d60| 73 20 74 68 65 20 66 6f | 72 6d 75 6c 61 73 20 69 |s the fo|rmulas i|
|00004d70| 6e 20 74 68 65 20 66 69 | 66 74 68 20 63 6f 6c 75 |n the fi|fth colu|
|00004d80| 6d 6e 0a 58 20 20 20 20 | 61 63 63 6f 72 64 69 6e |mn.X |accordin|
|00004d90| 67 6c 79 2c 20 69 2e 65 | 2e 2c 20 74 68 65 20 22 |gly, i.e|., the "|
|00004da0| 72 6f 77 20 73 75 6d 73 | 22 20 61 72 65 20 73 75 |row sums|" are su|
|00004db0| 6d 73 20 6f 66 20 74 68 | 65 20 76 61 6c 75 65 73 |ms of th|e values|
|00004dc0| 20 69 6e 0a 58 20 20 20 | 20 74 68 65 20 73 65 63 | in.X | the sec|
|00004dd0| 6f 6e 64 20 74 68 72 6f | 75 67 68 20 74 68 65 20 |ond thro|ugh the |
|00004de0| 66 6f 75 72 74 68 20 63 | 6f 6c 75 6d 6e 73 2e 20 |fourth c|olumns. |
|00004df0| 20 49 6e 20 61 64 64 69 | 74 69 6f 6e 2c 20 73 69 | In addi|tion, si|
|00004e00| 6e 63 65 0a 58 20 20 20 | 20 63 6f 6e 76 31 32 33 |nce.X | conv123|
|00004e10| 20 6b 65 65 70 73 20 74 | 72 61 63 6b 20 6f 66 20 | keeps t|rack of |
|00004e20| 74 68 65 20 6d 61 78 69 | 6d 75 6d 20 6e 75 6d 62 |the maxi|mum numb|
|00004e30| 65 72 20 6f 66 20 64 65 | 63 69 6d 61 6c 20 70 6c |er of de|cimal pl|
|00004e40| 61 63 65 73 0a 58 20 20 | 20 20 75 73 65 64 20 69 |aces.X | used i|
|00004e50| 6e 20 61 20 67 69 76 65 | 6e 20 72 6f 77 20 6f 72 |n a give|n row or|
|00004e60| 20 63 6f 6c 75 6d 6e 2c | 20 74 68 65 20 6e 75 6d | column,| the num|
|00004e70| 62 65 72 20 6f 66 20 64 | 65 63 69 6d 61 6c 20 70 |ber of d|ecimal p|
|00004e80| 6c 61 63 65 73 0a 58 20 | 20 20 20 64 69 73 70 6c |laces.X | displ|
|00004e90| 61 79 65 64 20 69 6e 20 | 4c 6f 74 75 73 2f 31 32 |ayed in |Lotus/12|
|00004ea0| 33 28 54 4d 29 20 77 69 | 6c 6c 20 62 65 20 74 77 |3(TM) wi|ll be tw|
|00004eb0| 6f 20 28 32 29 20 66 6f | 72 20 61 6c 6c 20 66 6f |o (2) fo|r all fo|
|00004ec0| 72 6d 75 6c 61 73 2c 0a | 58 20 20 20 20 77 69 74 |rmulas,.|X wit|
|00004ed0| 68 20 74 68 65 20 65 78 | 63 65 70 74 69 6f 6e 20 |h the ex|ception |
|00004ee0| 6f 66 20 74 68 65 20 43 | 53 55 4d 20 69 6e 20 74 |of the C|SUM in t|
|00004ef0| 68 65 20 74 68 69 72 64 | 20 63 6f 6c 75 6d 6e 2c |he third| column,|
|00004f00| 20 77 68 69 63 68 20 77 | 69 6c 6c 0a 58 20 20 20 | which w|ill.X |
|00004f10| 20 64 69 73 70 6c 61 79 | 20 77 69 74 68 20 6f 6e | display| with on|
|00004f20| 65 20 28 31 29 20 64 65 | 63 69 6d 61 6c 20 70 6c |e (1) de|cimal pl|
|00004f30| 61 63 65 2e 20 20 4e 6f | 74 65 20 61 6c 73 6f 20 |ace. No|te also |
|00004f40| 74 68 61 74 20 74 68 65 | 20 70 6f 73 69 74 69 6f |that the| positio|
|00004f50| 6e 0a 58 20 20 20 20 6f | 66 20 74 68 65 20 6e 75 |n.X o|f the nu|
|00004f60| 6d 62 65 72 20 6f 72 20 | 66 6f 72 6d 75 6c 61 20 |mber or |formula |
|00004f70| 63 6f 64 65 20 69 6e 20 | 65 61 63 68 20 63 6f 6c |code in |each col|
|00004f80| 75 6d 6e 20 69 73 20 6e | 6f 74 20 73 69 67 6e 69 |umn is n|ot signi|
|00004f90| 66 69 63 61 6e 74 2c 0a | 58 20 20 20 20 61 73 20 |ficant,.|X as |
|00004fa0| 6c 6f 6e 67 20 61 73 20 | 74 68 65 20 65 6e 74 69 |long as |the enti|
|00004fb0| 72 65 20 76 61 6c 75 65 | 73 20 66 69 74 73 20 75 |re value|s fits u|
|00004fc0| 6e 64 65 72 20 74 68 65 | 20 64 61 73 68 65 64 2d |nder the| dashed-|
|00004fd0| 6c 69 6e 65 20 63 6f 6c | 75 6d 6e 0a 58 20 20 20 |line col|umn.X |
|00004fe0| 20 64 65 66 69 6e 69 74 | 69 6f 6e 28 73 29 2e 20 | definit|ion(s). |
|00004ff0| 20 41 6c 73 6f 2c 20 6d | 6f 73 74 20 73 70 72 65 | Also, m|ost spre|
|00005000| 61 64 73 68 65 65 74 20 | 70 72 6f 67 72 61 6d 73 |adsheet |programs|
|00005010| 20 77 69 6c 6c 20 72 65 | 2d 70 6f 73 69 74 69 6f | will re|-positio|
|00005020| 6e 0a 58 20 20 20 20 74 | 68 65 20 76 61 6c 75 65 |n.X t|he value|
|00005030| 73 20 77 69 74 68 69 6e | 20 65 61 63 68 20 63 65 |s within| each ce|
|00005040| 6c 6c 20 61 73 20 74 68 | 65 20 76 61 6c 75 65 73 |ll as th|e values|
|00005050| 20 61 72 65 20 64 69 73 | 70 6c 61 79 65 64 2e 0a | are dis|played..|
|00005060| 58 0a 58 0a 58 46 4f 52 | 4d 55 4c 41 20 43 4f 44 |X.X.XFOR|MULA COD|
|00005070| 45 53 0a 58 20 20 20 20 | 41 73 20 68 61 73 20 62 |ES.X |As has b|
|00005080| 65 65 6e 20 73 68 6f 77 | 6e 20 69 6e 20 74 68 65 |een show|n in the|
|00005090| 20 61 62 6f 76 65 20 65 | 78 61 6d 70 6c 65 2c 20 | above e|xample, |
|000050a0| 63 65 6c 6c 20 63 6f 6e | 74 65 6e 74 73 20 6d 61 |cell con|tents ma|
|000050b0| 79 20 62 65 0a 58 20 20 | 20 20 64 65 63 69 6d 61 |y be.X | decima|
|000050c0| 6c 20 6e 75 6d 62 65 72 | 73 20 6f 72 20 63 68 61 |l number|s or cha|
|000050d0| 72 61 63 74 65 72 20 76 | 61 6c 75 65 73 2c 20 77 |racter v|alues, w|
|000050e0| 69 74 68 20 74 68 65 20 | 77 69 64 74 68 20 6f 66 |ith the |width of|
|000050f0| 20 74 68 65 20 63 65 6c | 6c 0a 58 20 20 20 20 64 | the cel|l.X d|
|00005100| 65 74 65 72 6d 69 6e 65 | 64 20 62 79 20 74 68 65 |etermine|d by the|
|00005110| 20 77 69 64 74 68 20 6f | 66 20 74 68 65 20 63 6f | width o|f the co|
|00005120| 6e 74 69 67 75 6f 75 73 | 20 64 61 73 68 65 73 20 |ntiguous| dashes |
|00005130| 69 6e 20 74 68 65 20 22 | 64 65 66 69 6e 69 74 69 |in the "|definiti|
|00005140| 6f 6e 22 0a 58 20 20 20 | 20 6c 69 6e 65 2e 20 20 |on".X | line. |
|00005150| 43 65 6c 6c 20 63 6f 6e | 74 65 6e 74 73 20 6d 61 |Cell con|tents ma|
|00005160| 79 20 61 6c 73 6f 20 62 | 65 20 66 6f 72 6d 75 6c |y also b|e formul|
|00005170| 61 20 63 6f 64 65 73 2e | 20 20 41 20 66 6f 72 6d |a codes.| A form|
|00005180| 75 6c 61 20 63 6f 64 65 | 20 69 73 0a 58 20 20 20 |ula code| is.X |
|00005190| 20 61 20 63 6f 6e 74 69 | 67 75 6f 75 73 20 73 65 | a conti|guous se|
|000051a0| 74 20 6f 66 20 63 68 61 | 72 61 63 74 65 72 73 2c |t of cha|racters,|
|000051b0| 20 61 6c 77 61 79 73 20 | 62 65 67 69 6e 6e 69 6e | always |beginnin|
|000051c0| 67 20 77 69 74 68 20 61 | 20 63 6f 6d 6d 65 72 63 |g with a| commerc|
|000051d0| 69 61 6c 0a 58 20 20 20 | 20 22 61 74 22 20 73 69 |ial.X | "at" si|
|000051e0| 67 6e 20 28 40 29 2e 20 | 20 54 68 65 72 65 20 61 |gn (@). | There a|
|000051f0| 72 65 20 74 68 72 65 65 | 20 74 79 70 65 73 3a 20 |re three| types: |
|00005200| 72 6f 77 2c 20 63 6f 6c | 75 6d 6e 20 61 6e 64 20 |row, col|umn and |
|00005210| 62 6f 74 68 2e 20 20 54 | 68 65 0a 58 20 20 20 20 |both. T|he.X |
|00005220| 74 79 70 65 20 69 6e 64 | 69 63 61 74 6f 72 20 69 |type ind|icator i|
|00005230| 73 20 61 20 73 69 6e 67 | 6c 65 20 75 70 70 65 72 |s a sing|le upper|
|00005240| 20 63 61 73 65 20 6c 65 | 74 74 65 72 2c 20 6f 6e | case le|tter, on|
|00005250| 65 20 6f 66 20 22 52 22 | 20 28 72 6f 77 29 2c 20 |e of "R"| (row), |
|00005260| 22 43 22 0a 58 20 20 20 | 20 28 63 6f 6c 75 6d 6e |"C".X | (column|
|00005270| 29 20 6f 72 20 22 42 22 | 20 28 62 6f 74 68 29 2c |) or "B"| (both),|
|00005280| 20 69 6d 6d 65 64 69 61 | 74 65 6c 79 20 66 6f 6c | immedia|tely fol|
|00005290| 6c 6f 77 69 6e 67 20 74 | 68 65 20 22 40 22 20 28 |lowing t|he "@" (|
|000052a0| 22 61 74 22 20 73 69 67 | 6e 29 2e 0a 58 20 20 20 |"at" sig|n)..X |
|000052b0| 20 54 68 65 20 66 6f 72 | 6d 75 6c 61 20 66 75 6e | The for|mula fun|
|000052c0| 63 74 69 6f 6e 20 69 6d | 6d 65 64 69 61 74 65 6c |ction im|mediatel|
|000052d0| 79 20 66 6f 6c 6c 6f 77 | 73 20 74 68 65 20 74 79 |y follow|s the ty|
|000052e0| 70 65 20 69 6e 64 69 63 | 61 74 6f 72 2c 20 61 6e |pe indic|ator, an|
|000052f0| 64 20 6d 61 79 0a 58 20 | 20 20 20 62 65 20 61 6e |d may.X | be an|
|00005300| 64 20 61 67 67 72 65 67 | 61 74 65 20 66 75 6e 63 |d aggreg|ate func|
|00005310| 74 69 6f 6e 20 6f 72 20 | 61 20 62 69 6e 61 72 79 |tion or |a binary|
|00005320| 20 66 75 6e 63 74 69 6f | 6e 2e 20 20 54 68 65 20 | functio|n. The |
|00005330| 72 61 6e 67 65 20 66 6f | 72 20 61 6e 0a 58 20 20 |range fo|r an.X |
|00005340| 20 20 61 67 67 72 65 67 | 61 74 65 20 66 75 6e 63 | aggreg|ate func|
|00005350| 74 69 6f 6e 20 69 73 20 | 63 61 6c 63 75 6c 61 74 |tion is |calculat|
|00005360| 65 64 20 61 75 74 6f 6d | 61 74 69 63 61 6c 6c 79 |ed autom|atically|
|00005370| 2c 20 62 65 69 6e 67 20 | 74 68 65 20 72 61 6e 67 |, being |the rang|
|00005380| 65 20 66 72 6f 6d 0a 58 | 20 20 20 20 74 68 65 20 |e from.X| the |
|00005390| 65 61 72 6c 69 65 73 74 | 20 61 76 61 69 6c 61 62 |earliest| availab|
|000053a0| 6c 65 20 63 65 6c 6c 20 | 2d 2d 20 69 2e 65 2e 2c |le cell |-- i.e.,|
|000053b0| 20 74 68 65 20 63 65 6c | 6c 20 66 61 72 74 68 65 | the cel|l farthe|
|000053c0| 73 74 20 22 61 62 6f 76 | 65 22 20 66 6f 72 0a 58 |st "abov|e" for.X|
|000053d0| 20 20 20 20 63 6f 6c 75 | 6d 6e 73 2c 20 6f 72 20 | colu|mns, or |
|000053e0| 66 61 72 74 68 65 73 74 | 20 74 6f 20 74 68 65 20 |farthest| to the |
|000053f0| 22 6c 65 66 74 22 20 66 | 6f 72 20 72 6f 77 73 20 |"left" f|or rows |
|00005400| 2d 2d 20 74 6f 20 74 68 | 65 20 63 65 6c 6c 20 69 |-- to th|e cell i|
|00005410| 6d 6d 65 64 69 61 74 65 | 6c 79 0a 58 20 20 20 20 |mmediate|ly.X |
|00005420| 61 64 6a 61 63 65 6e 74 | 20 74 6f 20 74 68 65 20 |adjacent| to the |
|00005430| 66 6f 72 6d 75 6c 61 20 | 64 65 66 69 6e 69 74 69 |formula |definiti|
|00005440| 6f 6e 2e 20 20 4e 6f 74 | 65 20 74 68 61 74 20 74 |on. Not|e that t|
|00005450| 68 69 73 20 22 66 61 72 | 74 68 65 73 74 22 20 63 |his "far|thest" c|
|00005460| 65 6c 6c 0a 58 20 20 20 | 20 6c 6f 63 61 74 69 6f |ell.X | locatio|
|00005470| 6e 20 69 73 20 72 65 2d | 61 64 6a 75 73 74 65 64 |n is re-|adjusted|
|00005480| 20 77 68 65 6e 20 61 20 | 6e 6f 6e 2d 6e 75 6d 65 | when a |non-nume|
|00005490| 72 69 63 20 63 65 6c 6c | 20 64 65 66 69 6e 69 74 |ric cell| definit|
|000054a0| 69 6f 6e 20 69 73 20 0a | 58 20 20 20 20 65 6e 63 |ion is .|X enc|
|000054b0| 6f 75 6e 74 65 72 65 64 | 2c 20 62 65 69 6e 67 20 |ountered|, being |
|000054c0| 73 65 74 20 74 6f 20 62 | 65 67 69 6e 20 61 74 20 |set to b|egin at |
|000054d0| 74 68 65 20 6e 65 78 74 | 20 6e 75 6d 65 72 69 63 |the next| numeric|
|000054e0| 20 63 65 6c 6c 20 28 74 | 68 69 73 20 64 6f 65 73 | cell (t|his does|
|000054f0| 0a 58 20 20 20 20 6e 6f | 74 20 69 6e 63 6c 75 64 |.X no|t includ|
|00005500| 65 20 6e 6f 6e 2d 63 65 | 6c 6c 73 2c 20 69 2e 65 |e non-ce|lls, i.e|
|00005510| 2e 2c 20 70 6f 73 69 74 | 69 6f 6e 73 20 77 69 74 |., posit|ions wit|
|00005520| 68 69 6e 20 74 68 65 20 | 73 70 72 65 61 64 73 68 |hin the |spreadsh|
|00005530| 65 65 74 20 77 69 74 68 | 0a 58 20 20 20 20 6e 6f |eet with|.X no|
|00005540| 20 76 61 6c 75 65 29 2e | 20 20 54 68 65 20 61 75 | value).| The au|
|00005550| 74 6f 6d 61 74 69 63 20 | 72 61 6e 67 65 20 73 74 |tomatic |range st|
|00005560| 61 72 74 20 70 6f 73 69 | 74 69 6f 6e 20 6d 61 79 |art posi|tion may|
|00005570| 20 62 65 20 6f 76 65 72 | 72 69 64 64 65 6e 20 66 | be over|ridden f|
|00005580| 6f 72 0a 58 20 20 20 20 | 22 72 6f 77 22 20 66 75 |or.X |"row" fu|
|00005590| 6e 63 74 69 6f 6e 73 20 | 62 79 20 70 6c 61 63 69 |nctions |by placi|
|000055a0| 6e 67 20 61 20 6e 75 6d | 65 72 69 63 20 76 61 6c |ng a num|eric val|
|000055b0| 75 65 20 61 74 20 74 68 | 65 20 65 6e 64 20 6f 66 |ue at th|e end of|
|000055c0| 20 74 68 65 20 66 6f 72 | 6d 75 6c 61 0a 58 20 20 | the for|mula.X |
|000055d0| 20 20 63 6f 64 65 20 28 | 73 74 69 6c 6c 20 63 6f | code (|still co|
|000055e0| 6e 74 69 67 75 6f 75 73 | 29 2e 20 20 41 20 6e 75 |ntiguous|). A nu|
|000055f0| 6d 65 72 69 63 20 76 61 | 6c 75 65 20 61 74 20 74 |meric va|lue at t|
|00005600| 68 65 20 65 6e 64 20 6f | 66 20 61 20 66 6f 72 6d |he end o|f a form|
|00005610| 75 6c 61 20 63 6f 64 65 | 0a 58 20 20 20 20 69 73 |ula code|.X is|
|00005620| 20 74 72 65 61 74 65 64 | 20 61 73 20 61 6e 20 61 | treated| as an a|
|00005630| 62 73 6f 6c 75 74 65 20 | 73 74 61 72 74 69 6e 67 |bsolute |starting|
|00005640| 20 63 6f 6c 75 6d 6e 20 | 6e 75 6d 62 65 72 2c 20 | column |number, |
|00005650| 77 69 74 68 20 74 68 65 | 20 66 69 72 73 74 20 63 |with the| first c|
|00005660| 6f 6c 75 6d 6e 0a 58 20 | 20 20 20 64 65 66 69 6e |olumn.X | defin|
|00005670| 65 64 20 61 73 20 63 6f | 6c 75 6d 6e 20 6f 6e 65 |ed as co|lumn one|
|00005680| 20 28 31 29 2e 0a 58 0a | 58 20 20 20 20 54 68 65 | (1)..X.|X The|
|00005690| 20 72 61 6e 67 65 20 66 | 6f 72 20 61 20 62 69 6e | range f|or a bin|
|000056a0| 61 72 79 20 66 75 6e 63 | 74 69 6f 6e 20 69 73 20 |ary func|tion is |
|000056b0| 73 69 6d 70 6c 79 20 74 | 68 65 20 6c 61 73 74 20 |simply t|he last |
|000056c0| 74 77 6f 20 61 64 6a 61 | 63 65 6e 74 0a 58 20 20 |two adja|cent.X |
|000056d0| 20 20 63 65 6c 6c 73 20 | 22 61 62 6f 76 65 22 20 | cells |"above" |
|000056e0| 74 68 65 20 66 6f 72 6d | 75 6c 61 20 64 65 66 69 |the form|ula defi|
|000056f0| 6e 69 74 69 6f 6e 20 66 | 6f 72 20 63 6f 6c 75 6d |nition f|or colum|
|00005700| 6e 20 66 75 6e 63 74 69 | 6f 6e 73 2c 20 61 6e 64 |n functi|ons, and|
|00005710| 0a 58 20 20 20 20 22 6c | 65 66 74 22 20 6f 66 20 |.X "l|eft" of |
|00005720| 74 68 65 20 66 6f 72 6d | 75 6c 61 20 64 65 66 69 |the form|ula defi|
|00005730| 6e 69 74 69 6f 6e 20 66 | 6f 72 20 72 6f 77 20 66 |nition f|or row f|
|00005740| 75 6e 63 74 69 6f 6e 73 | 2e 20 20 54 68 65 20 61 |unctions|. The a|
|00005750| 64 6a 61 63 65 6e 74 0a | 58 20 20 20 20 63 65 6c |djacent.|X cel|
|00005760| 6c 20 69 73 20 61 6c 77 | 61 79 73 20 75 73 65 64 |l is alw|ays used|
|00005770| 20 69 6e 20 74 68 65 20 | 63 61 6c 63 75 6c 61 74 | in the |calculat|
|00005780| 69 6f 6e 3b 20 61 6e 20 | 6f 76 65 72 72 69 64 65 |ion; an |override|
|00005790| 20 6e 75 6d 62 65 72 20 | 61 66 74 65 72 0a 58 20 | number |after.X |
|000057a0| 20 20 20 74 68 65 20 66 | 75 6e 63 74 69 6f 6e 20 | the f|unction |
|000057b0| 63 6f 64 65 20 69 6e 20 | 61 20 72 6f 77 20 66 75 |code in |a row fu|
|000057c0| 6e 63 74 69 6f 6e 20 69 | 73 20 74 72 65 61 74 65 |nction i|s treate|
|000057d0| 64 20 61 73 20 61 6e 20 | 61 62 73 6f 6c 75 74 65 |d as an |absolute|
|000057e0| 0a 58 20 20 20 20 63 6f | 6c 75 6d 6e 20 6e 75 6d |.X co|lumn num|
|000057f0| 62 65 72 20 6f 76 65 72 | 72 69 64 69 6e 67 20 74 |ber over|riding t|
|00005800| 68 65 20 70 65 6e 75 6c | 74 69 6d 61 74 65 20 63 |he penul|timate c|
|00005810| 65 6c 6c 2e 20 20 46 6f | 72 20 63 6f 6d 6d 75 74 |ell. Fo|r commut|
|00005820| 61 74 69 76 65 0a 58 20 | 20 20 20 66 75 6e 63 74 |ative.X | funct|
|00005830| 69 6f 6e 73 20 28 61 64 | 64 69 74 69 6f 6e 20 61 |ions (ad|dition a|
|00005840| 6e 64 20 6d 75 6c 74 69 | 70 6c 69 63 61 74 69 6f |nd multi|plicatio|
|00005850| 6e 29 2c 20 6f 72 64 65 | 72 20 69 73 20 6e 6f 74 |n), orde|r is not|
|00005860| 20 73 69 67 6e 69 66 69 | 63 61 6e 74 2e 0a 58 20 | signifi|cant..X |
|00005870| 20 20 20 46 6f 72 20 6e | 6f 6e 2d 63 6f 6d 6d 75 | For n|on-commu|
|00005880| 74 61 74 69 76 65 20 66 | 75 6e 63 74 69 6f 6e 73 |tative f|unctions|
|00005890| 20 28 73 75 62 74 72 61 | 63 74 69 6f 6e 20 61 6e | (subtra|ction an|
|000058a0| 64 20 64 69 76 69 73 69 | 6f 6e 29 2c 20 74 68 65 |d divisi|on), the|
|000058b0| 0a 58 20 20 20 20 64 65 | 66 69 6e 69 74 69 6f 6e |.X de|finition|
|000058c0| 20 69 73 20 61 20 2d 20 | 62 2c 20 6f 72 20 61 2f | is a - |b, or a/|
|000058d0| 62 2c 20 77 68 65 72 65 | 20 61 20 69 73 20 74 68 |b, where| a is th|
|000058e0| 65 20 70 65 6e 75 6c 74 | 69 6d 61 74 65 20 63 65 |e penult|imate ce|
|000058f0| 6c 6c 2c 20 61 6e 64 20 | 62 0a 58 20 20 20 20 69 |ll, and |b.X i|
|00005900| 73 20 74 68 65 20 69 6d | 6d 65 64 69 61 74 65 6c |s the im|mediatel|
|00005910| 79 20 61 64 6a 61 63 65 | 6e 74 20 63 65 6c 6c 2e |y adjace|nt cell.|
|00005920| 20 20 49 66 20 74 68 65 | 72 65 20 69 73 20 61 6e | If the|re is an|
|00005930| 20 6f 76 65 72 72 69 64 | 65 20 63 6f 6c 75 6d 6e | overrid|e column|
|00005940| 0a 58 20 20 20 20 6e 75 | 6d 62 65 72 2c 20 54 48 |.X nu|mber, TH|
|00005950| 49 53 20 4f 52 44 45 52 | 20 49 53 20 52 45 56 45 |IS ORDER| IS REVE|
|00005960| 52 53 45 44 20 2d 2d 20 | 69 2e 65 2e 2c 20 62 20 |RSED -- |i.e., b |
|00005970| 2d 20 61 20 61 6e 64 20 | 62 2f 61 2c 20 77 68 65 |- a and |b/a, whe|
|00005980| 72 65 20 61 20 69 73 0a | 58 20 20 20 20 74 68 65 |re a is.|X the|
|00005990| 20 6f 76 65 72 72 69 64 | 69 6e 67 20 63 6f 6c 75 | overrid|ing colu|
|000059a0| 6d 6e 20 6e 75 6d 62 65 | 72 20 61 6e 64 20 62 20 |mn numbe|r and b |
|000059b0| 69 73 20 74 68 65 20 69 | 6d 6d 65 64 69 61 74 65 |is the i|mmediate|
|000059c0| 6c 79 20 61 64 6a 61 63 | 65 6e 74 20 63 65 6c 6c |ly adjac|ent cell|
|000059d0| 2e 0a 58 20 20 20 20 54 | 68 69 73 20 73 69 74 75 |..X T|his situ|
|000059e0| 61 74 69 6f 6e 20 69 73 | 20 6d 61 64 65 20 63 6c |ation is| made cl|
|000059f0| 65 61 72 65 72 20 69 6e | 20 74 68 65 20 65 78 61 |earer in| the exa|
|00005a00| 6d 70 6c 65 73 20 62 65 | 6c 6f 77 2e 0a 58 0a 58 |mples be|low..X.X|
|00005a10| 20 20 20 20 46 6f 6c 6c | 6f 77 69 6e 67 20 69 73 | Foll|owing is|
|00005a20| 20 61 20 73 75 6d 6d 61 | 72 79 20 6f 66 20 74 68 | a summa|ry of th|
|00005a30| 65 20 61 76 61 69 6c 61 | 62 6c 65 20 66 75 6e 63 |e availa|ble func|
|00005a40| 74 69 6f 6e 73 2c 20 77 | 68 69 63 68 20 4d 55 53 |tions, w|hich MUS|
|00005a50| 54 20 62 65 20 69 6e 0a | 58 20 20 20 20 75 70 70 |T be in.|X upp|
|00005a60| 65 72 20 63 61 73 65 20 | 77 68 65 72 65 20 61 70 |er case |where ap|
|00005a70| 70 6c 69 63 61 62 6c 65 | 3a 0a 58 0a 58 20 20 20 |plicable|:.X.X |
|00005a80| 20 53 55 4d 20 2d 2d 20 | 50 65 72 66 6f 72 6d 73 | SUM -- |Performs|
|00005a90| 20 61 64 64 69 74 69 6f | 6e 20 6f 6e 20 61 20 72 | additio|n on a r|
|00005aa0| 61 6e 67 65 20 6f 66 20 | 63 65 6c 6c 73 2e 0a 58 |ange of |cells..X|
|00005ab0| 20 20 20 20 41 56 47 20 | 2d 2d 20 54 61 6b 65 73 | AVG |-- Takes|
|00005ac0| 20 74 68 65 20 61 76 65 | 72 61 67 65 20 76 61 6c | the ave|rage val|
|00005ad0| 75 65 20 6f 6e 20 61 20 | 72 61 6e 67 65 20 6f 66 |ue on a |range of|
|00005ae0| 20 63 65 6c 6c 73 2e 0a | 58 20 20 20 20 4d 49 4e | cells..|X MIN|
|00005af0| 20 2d 2d 20 45 78 74 72 | 61 63 74 73 20 74 68 65 | -- Extr|acts the|
|00005b00| 20 6d 69 6e 69 6d 75 6d | 20 76 61 6c 75 65 20 6f | minimum| value o|
|00005b10| 6e 20 61 20 72 61 6e 67 | 65 20 6f 66 20 63 65 6c |n a rang|e of cel|
|00005b20| 6c 73 2e 0a 58 20 20 20 | 20 4d 41 58 20 2d 2d 20 |ls..X | MAX -- |
|00005b30| 45 78 74 72 61 63 74 73 | 20 74 68 65 20 6d 69 6e |Extracts| the min|
|00005b40| 69 6d 75 6d 20 76 61 6c | 75 65 20 6f 6e 20 61 20 |imum val|ue on a |
|00005b50| 72 61 6e 67 65 20 6f 66 | 20 63 65 6c 6c 73 2e 0a |range of| cells..|
|00005b60| 58 20 20 20 20 56 41 52 | 20 2d 2d 20 43 61 6c 63 |X VAR| -- Calc|
|00005b70| 75 6c 61 74 65 73 20 74 | 68 65 20 76 61 72 69 61 |ulates t|he varia|
|00005b80| 6e 63 65 20 6f 6e 20 61 | 20 72 61 6e 67 65 20 6f |nce on a| range o|
|00005b90| 66 20 63 65 6c 6c 73 2e | 0a 58 20 20 20 20 53 54 |f cells.|.X ST|
|00005ba0| 44 20 2d 2d 20 43 61 6c | 63 75 6c 61 74 65 73 20 |D -- Cal|culates |
|00005bb0| 74 68 65 20 73 74 61 6e | 64 61 72 64 20 64 65 76 |the stan|dard dev|
|00005bc0| 69 61 74 69 6f 6e 20 6f | 6e 20 61 20 72 61 6e 67 |iation o|n a rang|
|00005bd0| 65 20 6f 66 20 63 65 6c | 6c 73 2e 0a 58 20 20 20 |e of cel|ls..X |
|00005be0| 20 20 2b 20 20 2d 2d 20 | 41 64 64 73 20 74 77 6f | + -- |Adds two|
|00005bf0| 20 63 65 6c 6c 73 2e 0a | 58 20 20 20 20 20 2d 20 | cells..|X - |
|00005c00| 20 2d 2d 20 53 75 62 74 | 72 61 63 74 73 20 74 77 | -- Subt|racts tw|
|00005c10| 6f 20 63 65 6c 6c 73 2e | 0a 58 20 20 20 20 20 2a |o cells.|.X *|
|00005c20| 20 20 2d 2d 20 4d 75 6c | 74 69 70 6c 69 65 73 20 | -- Mul|tiplies |
|00005c30| 74 77 6f 20 63 65 6c 6c | 73 2e 0a 58 20 20 20 20 |two cell|s..X |
|00005c40| 20 2f 20 20 2d 2d 20 44 | 69 76 69 64 65 73 20 74 | / -- D|ivides t|
|00005c50| 77 6f 20 63 65 6c 6c 73 | 2e 0a 58 20 20 20 20 20 |wo cells|..X |
|00005c60| 25 20 20 2d 2d 20 44 69 | 76 69 64 65 73 20 74 77 |% -- Di|vides tw|
|00005c70| 6f 20 63 65 6c 6c 73 2c | 20 61 6e 64 20 6d 75 6c |o cells,| and mul|
|00005c80| 74 69 70 6c 69 65 73 20 | 74 68 65 20 72 65 73 75 |tiplies |the resu|
|00005c90| 6c 74 20 62 79 20 31 30 | 30 2e 0a 58 20 20 20 20 |lt by 10|0..X |
|00005ca0| 4e 55 4c 20 2d 2d 20 54 | 68 69 73 20 69 73 20 61 |NUL -- T|his is a|
|00005cb0| 63 74 75 61 6c 6c 79 20 | 6e 6f 74 20 61 20 66 75 |ctually |not a fu|
|00005cc0| 6e 63 74 69 6f 6e 2c 20 | 62 75 74 20 70 65 72 66 |nction, |but perf|
|00005cd0| 6f 72 6d 73 20 74 68 65 | 20 74 61 73 6b 0a 58 20 |orms the| task.X |
|00005ce0| 20 20 20 20 20 20 20 20 | 20 20 6f 66 20 61 20 22 | | of a "|
|00005cf0| 70 6c 61 63 65 68 6f 6c | 64 65 72 22 2c 20 70 72 |placehol|der", pr|
|00005d00| 65 76 65 6e 74 69 6e 67 | 20 74 68 65 20 22 72 65 |eventing| the "re|
|00005d10| 73 65 74 74 69 6e 67 22 | 20 6f 66 20 61 75 74 6f |setting"| of auto|
|00005d20| 2d 0a 58 20 20 20 20 20 | 20 20 20 20 20 20 6d 61 |-.X | ma|
|00005d30| 74 69 63 61 6c 6c 79 20 | 63 61 6c 63 75 6c 61 74 |tically |calculat|
|00005d40| 65 64 20 6e 75 6d 65 72 | 69 63 20 72 61 6e 67 65 |ed numer|ic range|
|00005d50| 73 20 77 69 74 68 6f 75 | 74 20 63 72 65 61 74 69 |s withou|t creati|
|00005d60| 6e 67 0a 58 20 20 20 20 | 20 20 20 20 20 20 20 63 |ng.X | c|
|00005d70| 65 6c 6c 20 63 6f 6e 74 | 65 6e 74 73 2e 20 20 54 |ell cont|ents. T|
|00005d80| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 69 73 20 |his func|tion is |
|00005d90| 6d 6f 73 74 20 66 72 65 | 71 75 65 6e 74 6c 79 20 |most fre|quently |
|00005da0| 75 73 65 64 20 74 6f 0a | 58 20 20 20 20 20 20 20 |used to.|X |
|00005db0| 20 20 20 20 65 78 74 65 | 6e 64 20 74 68 65 20 72 | exte|nd the r|
|00005dc0| 6f 77 20 72 61 6e 67 65 | 20 6f 66 20 61 67 67 72 |ow range| of aggr|
|00005dd0| 65 67 61 74 65 20 63 6f | 6c 75 6d 6e 20 66 75 6e |egate co|lumn fun|
|00005de0| 63 74 69 6f 6e 73 2e 0a | 58 0a 58 0a 58 46 4f 52 |ctions..|X.X.XFOR|
|00005df0| 4d 55 4c 41 20 45 58 41 | 4d 50 4c 45 53 0a 58 20 |MULA EXA|MPLES.X |
|00005e00| 20 20 20 48 65 72 65 20 | 61 72 65 20 73 6f 6d 65 | Here |are some|
|00005e10| 20 73 61 6d 70 6c 65 20 | 69 6e 70 75 74 20 6c 69 | sample |input li|
|00005e20| 6e 65 73 2c 20 77 69 74 | 68 20 72 65 73 75 6c 74 |nes, wit|h result|
|00005e30| 20 66 6f 6c 6c 6f 77 69 | 6e 67 2e 0a 58 0a 58 20 | followi|ng..X.X |
|00005e40| 20 20 20 69 6e 70 75 74 | 3a 0a 58 20 20 20 20 2d | input|:.X -|
|00005e50| 2d 2d 2d 2d 2d 2d 2d 2d | 20 20 2d 2d 2d 2d 2d 2d |--------| ------|
|00005e60| 2d 2d 2d 2d 2d 20 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- -|--------|
|00005e70| 2d 2d 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 20 2d |-- -----|------ -|
|00005e80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 0a 58 20 20 20 20 |--------|--.X |
|00005e90| 77 69 64 67 65 74 2d 31 | 20 20 20 20 20 20 31 30 |widget-1| 10|
|00005ea0| 30 2e 30 30 20 20 20 20 | 20 20 20 32 30 30 2e 30 |0.00 | 200.0|
|00005eb0| 30 20 20 20 20 20 20 33 | 30 30 2e 30 30 20 20 20 |0 3|00.00 |
|00005ec0| 20 20 40 52 53 55 4d 0a | 58 0a 58 20 20 20 20 72 | @RSUM.|X.X r|
|00005ed0| 65 73 75 6c 74 3a 0a 58 | 20 20 20 20 2d 2d 2d 2d |esult:.X| ----|
|00005ee0| 2d 2d 2d 2d 2d 20 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- -|--------|
|00005ef0| 2d 2d 20 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 20 |-- ----|------- |
|00005f00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |--------|--- ----|
|00005f10| 2d 2d 2d 2d 2d 2d 2d 0a | 58 20 20 20 20 77 69 64 |-------.|X wid|
|00005f20| 67 65 74 2d 31 20 20 20 | 20 20 20 20 20 31 30 30 |get-1 | 100|
|00005f30| 2e 30 30 20 20 20 20 20 | 20 20 32 30 30 2e 30 30 |.00 | 200.00|
|00005f40| 20 20 20 20 20 20 33 30 | 30 2e 30 30 20 20 20 20 | 30|0.00 |
|00005f50| 20 20 36 30 30 2e 30 30 | 0a 58 0a 58 0a 58 20 20 | 600.00|.X.X.X |
|00005f60| 20 20 69 6e 70 75 74 3a | 0a 58 20 20 20 20 2d 2d | input:|.X --|
|00005f70| 2d 2d 2d 2d 2d 2d 2d 20 | 20 2d 2d 2d 2d 2d 2d 2d |------- | -------|
|00005f80| 2d 2d 2d 2d 20 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |---- --|--------|
|00005f90| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d |- ------|----- --|
|00005fa0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 0a 58 20 20 20 20 77 |--------|-.X w|
|00005fb0| 69 64 67 65 74 2d 31 20 | 20 20 20 20 20 20 31 30 |idget-1 | 10|
|00005fc0| 30 2e 30 30 20 20 20 20 | 20 20 20 32 30 30 2e 30 |0.00 | 200.0|
|00005fd0| 30 20 20 20 20 20 20 33 | 30 30 2e 30 30 20 20 20 |0 3|00.00 |
|00005fe0| 20 20 40 52 2b 0a 58 0a | 58 20 20 20 20 72 65 73 | @R+.X.|X res|
|00005ff0| 75 6c 74 3a 0a 58 20 20 | 20 20 2d 2d 2d 2d 2d 2d |ult:.X | ------|
|00006000| 2d 2d 2d 20 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--- ---|--------|
|00006010| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d | ------|----- --|
|00006020| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 20 2d 2d 2d 2d 2d 2d |--------|- ------|
|00006030| 2d 2d 2d 2d 2d 0a 58 20 | 20 20 20 77 69 64 67 65 |-----.X | widge|
|00006040| 74 2d 31 20 20 20 20 20 | 20 20 20 31 30 30 2e 30 |t-1 | 100.0|
|00006050| 30 20 20 20 20 20 20 20 | 32 30 30 2e 30 30 20 20 |0 |200.00 |
|00006060| 20 20 20 20 33 30 30 2e | 30 30 20 20 20 20 20 20 | 300.|00 |
|00006070| 35 30 30 2e 30 30 0a 58 | 0a 58 0a 58 20 20 20 20 |500.00.X|.X.X |
|00006080| 69 6e 70 75 74 3a 0a 58 | 20 20 20 20 2d 2d 2d 2d |input:.X| ----|
|00006090| 2d 2d 2d 2d 2d 20 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- -|--------|
|000060a0| 2d 2d 20 20 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 20 |-- ----|------- |
|000060b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |--------|--- ----|
|000060c0| 2d 2d 2d 2d 2d 2d 2d 0a | 58 20 20 20 20 77 69 64 |-------.|X wid|
|000060d0| 67 65 74 2d 31 20 20 20 | 20 20 20 20 31 30 30 2e |get-1 | 100.|
|000060e0| 30 30 20 20 20 20 20 20 | 20 32 30 30 2e 30 30 20 |00 | 200.00 |
|000060f0| 20 20 20 20 20 33 30 30 | 2e 30 30 20 20 20 20 20 | 300|.00 |
|00006100| 40 52 2f 0a 58 0a 58 20 | 20 20 20 72 65 73 75 6c |@R/.X.X | resul|
|00006110| 74 3a 0a 58 20 20 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |t:.X |--------|
|00006120| 2d 20 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 20 20 |- -----|------ |
|00006130| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |--------|--- ----|
|00006140| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|00006150| 2d 2d 2d 0a 58 20 20 20 | 20 77 69 64 67 65 74 2d |---.X | widget-|
|00006160| 31 20 20 20 20 20 20 20 | 20 31 30 30 2e 30 30 20 |1 | 100.00 |
|00006170| 20 20 20 20 20 20 32 30 | 30 2e 30 30 20 20 20 20 | 20|0.00 |
|00006180| 20 20 33 30 30 2e 30 30 | 20 20 20 20 20 20 20 20 | 300.00| |
|00006190| 30 2e 36 37 0a 58 0a 58 | 0a 58 20 20 20 20 69 6e |0.67.X.X|.X in|
|000061a0| 70 75 74 3a 0a 58 20 20 | 20 20 2d 2d 2d 2d 2d 2d |put:.X | ------|
|000061b0| 2d 2d 2d 20 20 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--- ---|--------|
|000061c0| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d | ------|----- --|
|000061d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 20 2d 2d 2d 2d 2d 2d |--------|- ------|
|000061e0| 2d 2d 2d 2d 2d 0a 58 20 | 20 20 20 77 69 64 67 65 |-----.X | widge|
|000061f0| 74 2d 31 20 20 20 20 20 | 20 20 31 30 30 2e 30 30 |t-1 | 100.00|
|00006200| 20 20 20 20 20 20 20 32 | 30 30 2e 30 30 20 20 20 | 2|00.00 |
|00006210| 20 20 20 33 30 30 2e 30 | 30 20 20 20 20 20 40 52 | 300.0|0 @R|
|00006220| 2f 33 0a 58 0a 58 20 20 | 20 20 72 65 73 75 6c 74 |/3.X.X | result|
|00006230| 3a 0a 58 20 20 20 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |:.X -|--------|
|00006240| 20 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 20 2d | ------|----- -|
|00006250| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 20 2d 2d 2d 2d 2d |--------|-- -----|
|00006260| 2d 2d 2d 2d 2d 2d 20 2d | 2d 2d 2d 2d 2d 2d 2d 2d |------ -|--------|
|00006270| 2d 2d 0a 58 20 20 20 20 | 77 69 64 67 65 74 2d 31 |--.X |widget-1|
|00006280| 20 20 20 20 20 20 20 20 | 31 30 30 2e 30 30 20 20 | |100.00 |
|00006290| 20 20 20 20 20 32 30 30 | 2e 30 30 20 20 20 20 20 | 200|.00 |
|000062a0| 20 33 30 30 2e 30 30 20 | 20 20 20 20 20 20 20 31 | 300.00 | 1|
|000062b0| 2e 35 30 0a 58 0a 58 20 | 20 20 20 4e 6f 74 65 20 |.50.X.X | Note |
|000062c0| 69 6e 20 74 68 65 20 61 | 62 6f 76 65 20 65 78 61 |in the a|bove exa|
|000062d0| 6d 70 6c 65 20 74 68 61 | 74 20 74 68 65 20 6f 72 |mple tha|t the or|
|000062e0| 64 65 72 20 6f 66 20 64 | 69 76 69 73 6f 72 2f 64 |der of d|ivisor/d|
|000062f0| 69 76 69 64 65 6e 64 20 | 61 73 0a 58 20 20 20 20 |ividend |as.X |
|00006300| 72 65 67 61 72 64 73 20 | 74 68 65 20 69 6d 6d 65 |regards |the imme|
|00006310| 64 69 61 74 65 6c 79 20 | 61 64 6a 61 63 65 6e 74 |diately |adjacent|
|00006320| 20 63 65 6c 6c 20 69 73 | 20 74 68 65 20 72 65 76 | cell is| the rev|
|00006330| 65 72 73 65 20 6f 66 20 | 74 68 65 0a 58 20 20 20 |erse of |the.X |
|00006340| 20 70 72 65 76 69 6f 75 | 73 20 65 78 61 6d 70 6c | previou|s exampl|
|00006350| 65 2e 0a 58 0a 58 0a 58 | 20 20 20 20 69 6e 70 75 |e..X.X.X| inpu|
|00006360| 74 3a 0a 58 20 20 20 20 | 2d 2d 2d 2d 2d 2d 2d 2d |t:.X |--------|
|00006370| 2d 20 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 20 20 2d 2d |- -----|---- --|
|00006380| 2d 2d 2d 2d 2d 2d 2d 20 | 2d 2d 2d 2d 2d 2d 2d 2d |------- |--------|
|00006390| 2d 20 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d |- ------|----- --|
|000063a0| 2d 2d 2d 2d 2d 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |----- --|--------|
|000063b0| 0a 58 20 20 20 20 77 69 | 64 67 65 74 2d 31 20 20 |.X wi|dget-1 |
|000063c0| 20 20 20 31 30 30 2e 30 | 30 20 20 20 20 20 32 30 | 100.0|0 20|
|000063d0| 30 2e 30 30 20 20 20 20 | 20 20 40 52 53 55 4d 20 |0.00 | @RSUM |
|000063e0| 20 20 20 20 20 33 30 30 | 2e 30 30 20 20 20 34 30 | 300|.00 40|
|000063f0| 30 2e 30 20 20 20 20 20 | 40 52 53 55 4d 0a 58 20 |0.0 |@RSUM.X |
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
