/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.iso / More Information / Resolve / Resolve Scripts / Total

< prev

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 05 54 6f 74 61 6c 00 | 00 00 00 00 00 00 00 00 |..Total.|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 52 73 53 63 52 73 6c | 76 01 00 00 00 00 00 00 |.RsScRsl|v.......|
|00000050| 00 00 00 00 00 35 a5 00 | 00 01 46 a4 b0 59 9c a4 |.....5..|..F..Y..|
|00000060| b0 59 9c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.Y......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 3d ad 00 00 |........|....=...|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 c0 28 00 00 |BAT_BTSC|0101.(..|
|00000090| 8d 0c 00 00 41 0b 00 00 | 49 0b 00 00 5d 0b 00 00 |....A...|I...]...|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 3c 0b 00 00 13 00 08 00 |........|<.......|
|000000d0| 1b 00 02 00 01 00 00 00 | 49 f4 01 00 1a 01 00 4f |........|I......O|
|000000e0| f2 11 00 1b 00 00 00 f9 | f8 1b 00 00 01 f9 f8 1d |........|........|
|000000f0| 08 00 1b 00 00 02 f9 f8 | fc f6 00 00 fd 09 1c 06 |........|........|
|00000100| 01 05 1a 01 01 ff 1b 00 | 00 00 f9 f8 fd 8e 1c 08 |........|........|
|00000110| 01 05 1a 00 0b ff 02 01 | 00 7f 47 45 54 20 53 43 |........|..GET SC|
|00000120| 52 49 50 54 20 22 54 6f | 74 61 6c 22 20 0d 09 09 |RIPT "To|tal" ...|
|00000130| 09 09 09 09 20 20 20 20 | 43 41 4c 4c 20 54 6f 74 |....    |CALL Tot|
|00000140| 61 6c 3a 73 65 74 55 70 | 4c 6f 63 61 6c 69 7a 65 |al:setUp|Localize|
|00000150| 64 53 74 72 69 6e 67 73 | 28 29 20 0d 09 09 09 09 |dStrings|() .....|
|00000160| 09 09 20 20 20 20 43 41 | 4c 4c 20 54 6f 74 61 6c |..    CA|LL Total|
|00000170| 3a 74 6f 74 61 6c 28 29 | 20 0d 09 09 09 09 09 09 |:total()| .......|
|00000180| 20 20 20 20 52 45 4d 4f | 56 45 20 53 43 52 49 50 |    REMO|VE SCRIP|
|00000190| 54 20 22 54 6f 74 61 6c | 22 00 00 fb f6 00 00 19 |T "Total|".......|
|000001a0| 0b 54 6f 74 61 6c 20 52 | 61 6e 67 65 f4 00 0b 19 |.Total R|ange....|
|000001b0| 2e 50 6c 65 61 73 65 20 | 6f 70 65 6e 20 61 20 77 |.Please |open a w|
|000001c0| 6f 72 6b 73 68 65 65 74 | 20 6f 72 20 62 72 69 6e |orksheet| or brin|
|000001d0| 67 20 6f 6e 65 20 74 6f | 20 66 72 6f 6e 74 2e f4 |g one to| front..|
|000001e0| 00 0d 19 21 57 6f 77 21 | 20 20 54 72 79 20 61 20 |...!Wow!|  Try a |
|000001f0| 73 6d 61 6c 6c 65 72 20 | 72 61 6e 67 65 20 70 6c |smaller |range pl|
|00000200| 65 61 73 65 2e f4 00 0c | 19 2a 50 6c 65 61 73 65 |ease....|.*Please|
|00000210| 20 73 65 6c 65 63 74 20 | 61 20 72 61 6e 67 65 20 | select |a range |
|00000220| 6f 66 20 6e 75 6d 62 65 | 72 73 20 74 6f 20 74 6f |of numbe|rs to to|
|00000230| 74 61 6c 2e f4 00 0e 19 | 41 54 68 65 20 63 6f 6c |tal.....|AThe col|
|00000240| 75 6d 6e 20 6f 72 20 72 | 6f 77 20 77 68 65 72 65 |umn or r|ow where|
|00000250| 20 74 68 65 20 74 6f 74 | 61 6c 73 20 77 69 6c 6c | the tot|als will|
|00000260| 20 62 65 20 65 6e 74 65 | 72 65 64 20 61 72 65 20 | be ente|red are |
|00000270| 6e 6f 74 20 65 6d 70 74 | 79 2e f4 00 0f 19 39 54 |not empt|y.....9T|
|00000280| 68 65 20 63 6f 6c 75 6d | 6e 20 77 68 65 72 65 20 |he colum|n where |
|00000290| 74 68 65 20 74 6f 74 61 | 6c 73 20 77 69 6c 6c 20 |the tota|ls will |
|000002a0| 62 65 20 65 6e 74 65 72 | 65 64 20 69 73 20 6e 6f |be enter|ed is no|
|000002b0| 74 20 65 6d 70 74 79 2e | f4 00 10 19 36 54 68 65 |t empty.|....6The|
|000002c0| 20 72 6f 77 20 77 68 65 | 72 65 20 74 68 65 20 74 | row whe|re the t|
|000002d0| 6f 74 61 6c 73 20 77 69 | 6c 6c 20 62 65 20 65 6e |otals wi|ll be en|
|000002e0| 74 65 72 65 64 20 69 73 | 20 6e 6f 74 20 65 6d 70 |tered is| not emp|
|000002f0| 74 79 2e f4 00 11 19 00 | f4 00 11 fb f6 00 03 fe |ty......|........|
|00000300| c7 4f f2 0c 00 fd 08 23 | 01 05 1a 00 0d ff fc fd |.O.....#|........|
|00000310| 04 1b 05 01 fd 04 1b 06 | 00 19 00 f4 00 08 19 00 |........|........|
|00000320| f4 00 07 19 00 f4 00 06 | 18 00 00 00 00 00 00 f0 |........|........|
|00000330| 3f fe 19 f4 03 01 18 00 | 00 00 00 00 00 f0 3f fe |?.......|......?.|
|00000340| 18 18 00 00 00 00 00 00 | f0 3f 3e f2 0b 00 1a 00 |........|.?>.....|
|00000350| 0e 1b 01 00 03 f9 f8 fd | 0c 08 01 01 01 01 05 1a |........|........|
|00000360| 03 01 ff 00 1a 03 01 fe | 1d d3 d0 f4 00 01 1a 03 |........|........|
|00000370| 01 fe 1d d3 d1 f4 00 00 | cf f4 00 02 1a 00 02 1a |........|........|
|00000380| 00 00 2b 00 00 00 00 00 | 00 f0 3f 2e f4 00 04 ce |..+.....|..?.....|
|00000390| f4 00 03 1a 00 03 1a 00 | 01 2b 00 00 00 00 00 00 |........|.+......|
|000003a0| f0 3f 2e f4 00 05 1a 00 | 01 18 00 00 00 00 c0 ff |.?......|........|
|000003b0| df 40 3a 1a 00 00 18 00 | 00 00 00 c0 ff df 40 3a |.@:.....|......@:|
|000003c0| 37 f2 0b 00 1a 00 0c 1b | 01 00 03 f9 f8 1a 00 03 |7.......|........|
|000003d0| 1a 00 05 1a 00 04 1b 03 | 00 04 f9 f4 03 02 1a 00 |........|........|
|000003e0| 02 1a 00 04 1a 00 05 1b | 03 00 05 f9 f4 03 03 1a |........|........|
|000003f0| 00 01 18 00 00 00 00 00 | 00 f0 3f 39 f2 06 00 49 |........|..?9...I|
|00000400| f4 03 03 1a 00 00 18 00 | 00 00 00 00 00 f0 3f 39 |........|......?9|
|00000410| f2 06 00 49 f4 03 02 ce | cf 2a 00 00 00 00 00 00 |...I....|.*......|
|00000420| f0 3f d4 d2 52 f2 11 00 | 1a 00 03 2a 00 00 00 00 |.?..R...|...*....|
|00000430| 00 00 f0 3f f4 00 03 ce | 2a 00 00 00 00 00 00 f0 |...?....|*.......|
|00000440| 3f cf d4 d2 52 f2 11 00 | 1a 00 02 2a 00 00 00 00 |?...R...|...*....|
|00000450| 00 00 f0 3f f4 00 02 1a | 00 03 1a 00 05 1a 00 04 |...?....|........|
|00000460| 1b 03 00 04 f9 1a 00 00 | 18 00 00 00 00 00 00 f0 |........|........|
|00000470| 3f 3e 36 f2 11 00 1a 00 | 04 2b 00 00 00 00 00 00 |?>6.....|.+......|
|00000480| f0 3f f4 00 04 1a 00 02 | 1a 00 04 1a 00 05 1b 03 |.?......|........|
|00000490| 00 05 f9 1a 00 01 18 00 | 00 00 00 00 00 f0 3f 3e |........|......?>|
|000004a0| 36 f2 11 00 1a 00 05 2b | 00 00 00 00 00 00 f0 3f |6......+|.......?|
|000004b0| f4 00 05 1a 03 02 38 1a | 03 03 38 36 f2 d5 01 1a |......8.|..86....|
|000004c0| 00 02 1a 00 04 2a 00 00 | 00 00 00 00 f0 3f 1a 00 |.....*..|.....?..|
|000004d0| 05 2a 00 00 00 00 00 00 | f0 3f 1b 03 00 05 f9 38 |.*......|.?.....8|
|000004e0| 1a 00 03 1a 00 05 2a 00 | 00 00 00 00 00 f0 3f 1a |......*.|......?.|
|000004f0| 00 04 2a 00 00 00 00 00 | 00 f0 3f 1b 03 00 04 f9 |..*.....|..?.....|
|00000500| 38 36 f2 6f 00 fd 31 08 | 01 01 01 01 2a 1a 00 03 |86.o..1.|....*...|
|00000510| 1a 00 04 2a 00 00 00 00 | 00 00 f0 3f 1a 00 05 2a |...*....|...?...*|
|00000520| 00 00 00 00 00 00 f0 3f | 1a 00 04 2a 00 00 00 00 |.......?|...*....|
|00000530| 00 00 f0 3f d8 ff 00 fd | 31 08 00 01 01 01 2a 1a |...?....|1.....*.|
|00000540| 00 05 2a 00 00 00 00 00 | 00 f0 3f 1a 00 02 1a 00 |..*.....|..?.....|
|00000550| 05 2a 00 00 00 00 00 00 | f0 3f 1a 00 04 2a 00 00 |.*......|.?...*..|
|00000560| 00 00 00 00 f0 3f d8 ff | 00 1a 00 0f 1b 01 00 03 |.....?..|........|
|00000570| f9 f8 1a 00 01 18 00 00 | 00 00 00 00 f0 3f 3a 1a |........|.....?:.|
|00000580| 00 02 1a 00 04 2a 00 00 | 00 00 00 00 f0 3f 1a 00 |.....*..|.....?..|
|00000590| 05 2a 00 00 00 00 00 00 | f0 3f 1b 03 00 05 f9 36 |.*......|.?.....6|
|000005a0| f2 08 00 1b 00 00 06 f9 | f8 1a 00 00 18 00 00 00 |........|........|
|000005b0| 00 00 00 f0 3f 3a 1a 00 | 03 1a 00 05 2a 00 00 00 |....?:..|....*...|
|000005c0| 00 00 00 f0 3f 1a 00 04 | 2a 00 00 00 00 00 00 f0 |....?...|*.......|
|000005d0| 3f 1b 03 00 04 f9 36 f2 | 08 00 1b 00 00 07 f9 f8 |?.....6.|........|
|000005e0| 1a 00 01 18 00 00 00 00 | 00 00 f0 3f 3a 1a 00 00 |........|...?:...|
|000005f0| 18 00 00 00 00 00 00 f0 | 3f 3a 36 f2 93 00 fd 55 |........|?:6....U|
|00000600| 17 01 36 19 08 3d 49 46 | 28 53 55 4d 28 1a 00 06 |..6..=IF|(SUM(...|
|00000610| 35 19 07 29 3c 3e 53 55 | 4d 28 35 1a 00 07 35 19 |5..)<>SU|M(5...5.|
|00000620| 0c 29 2c 45 52 52 28 29 | 2c 53 55 4d 28 35 1a 00 |.),ERR()|,SUM(5..|
|00000630| 06 35 19 02 29 29 35 ff | 01 1b 1a 00 05 2a 00 00 |.5..))5.|.....*..|
|00000640| 00 00 00 00 f0 3f 1a 00 | 04 2a 00 00 00 00 00 00 |.....?..|.*......|
|00000650| f0 3f d4 ff fd 1a 08 01 | 01 01 01 13 1a 00 05 2a |.?......|.......*|
|00000660| 00 00 00 00 00 00 f0 3f | 1a 00 04 d4 d3 ff 00 fd |.......?|........|
|00000670| 03 06 01 1a 00 05 2a 00 | 00 00 00 00 00 f0 3f 1a |......*.|......?.|
|00000680| 00 04 2a 00 00 00 00 00 | 00 f0 3f d4 f4 00 08 1d |..*.....|..?.....|
|00000690| 69 02 1a 03 02 38 1a 03 | 03 36 f2 6a 00 1a 00 02 |i....8..|.6.j....|
|000006a0| 1a 00 04 2a 00 00 00 00 | 00 00 f0 3f 1a 00 05 2a |...*....|...?...*|
|000006b0| 00 00 00 00 00 00 f0 3f | 1b 03 00 05 f9 38 f2 3d |.......?|.....8.=|
|000006c0| 00 fd 31 08 01 01 01 01 | 2a 1a 00 05 2a 00 00 00 |..1.....|*...*...|
|000006d0| 00 00 00 f0 3f 1a 00 02 | 1a 00 05 2a 00 00 00 00 |....?...|...*....|
|000006e0| 00 00 f0 3f 1a 00 04 2a | 00 00 00 00 00 00 f0 3f |...?...*|.......?|
|000006f0| d8 ff 00 1a 00 10 1b 01 | 00 03 f9 f8 1b 00 00 06 |........|........|
|00000700| f9 f8 1d f6 01 1a 03 02 | 1a 03 03 38 36 f2 6a 00 |........|...86.j.|
|00000710| 1a 00 03 1a 00 05 2a 00 | 00 00 00 00 00 f0 3f 1a |......*.|......?.|
|00000720| 00 04 2a 00 00 00 00 00 | 00 f0 3f 1b 03 00 04 f9 |..*.....|..?.....|
|00000730| 38 f2 3d 00 fd 31 08 01 | 01 01 01 2a 1a 00 03 1a |8.=..1..|...*....|
|00000740| 00 04 2a 00 00 00 00 00 | 00 f0 3f 1a 00 05 2a 00 |..*.....|..?...*.|
|00000750| 00 00 00 00 00 f0 3f 1a | 00 04 2a 00 00 00 00 00 |......?.|..*.....|
|00000760| 00 f0 3f d8 ff 00 1a 00 | 11 1b 01 00 03 f9 f8 1b |..?.....|........|
|00000770| 00 00 07 f9 f8 1d 83 01 | 1a 03 02 1a 03 03 36 f2 |........|......6.|
|00000780| 79 01 1a 00 02 1a 00 04 | 2a 00 00 00 00 00 00 f0 |y.......|*.......|
|00000790| 3f 1a 00 05 2a 00 00 00 | 00 00 00 f0 3f 1b 03 00 |?...*...|....?...|
|000007a0| 05 f9 38 1a 00 03 1a 00 | 05 2a 00 00 00 00 00 00 |..8.....|.*......|
|000007b0| f0 3f 1a 00 04 2a 00 00 | 00 00 00 00 f0 3f 1b 03 |.?...*..|.....?..|
|000007c0| 00 04 f9 38 37 f2 6f 00 | fd 31 08 01 01 01 01 2a |...87.o.|.1.....*|
|000007d0| 1a 00 03 1a 00 04 2a 00 | 00 00 00 00 00 f0 3f 1a |......*.|......?.|
|000007e0| 00 05 2a 00 00 00 00 00 | 00 f0 3f 1a 00 04 2a 00 |..*.....|..?...*.|
|000007f0| 00 00 00 00 00 f0 3f d8 | ff 00 fd 31 08 00 01 01 |......?.|...1....|
|00000800| 01 2a 1a 00 05 2a 00 00 | 00 00 00 00 f0 3f 1a 00 |.*...*..|.....?..|
|00000810| 02 1a 00 05 2a 00 00 00 | 00 00 00 f0 3f 1a 00 04 |....*...|....?...|
|00000820| 2a 00 00 00 00 00 00 f0 | 3f d8 ff 00 1a 00 0f 1b |*.......|?.......|
|00000830| 01 00 03 f9 f8 1b 00 00 | 06 f9 f8 1b 00 00 07 f9 |........|........|
|00000840| f8 fd 7c 17 01 5d 19 08 | 3d 49 46 28 53 55 4d 28 |..|..]..|=IF(SUM(|
|00000850| 1a 00 06 35 19 07 29 3c | 3e 53 55 4d 28 35 1a 00 |...5..)<|>SUM(5..|
|00000860| 07 35 19 33 29 2c 7b 50 | 75 74 20 63 72 6f 73 73 |.5.3),{P|ut cross|
|00000870| 66 6f 6f 74 20 69 6e 20 | 6c 6f 77 65 72 20 72 69 |foot in |lower ri|
|00000880| 67 68 74 20 63 65 6c 6c | 7d 0d 09 09 09 45 52 52 |ght cell|}....ERR|
|00000890| 28 29 2c 53 55 4d 28 35 | 1a 00 06 35 19 02 29 29 |(),SUM(5|...5..))|
|000008a0| 35 ff 01 1b 1a 00 05 2a | 00 00 00 00 00 00 f0 3f |5......*|.......?|
|000008b0| 1a 00 04 2a 00 00 00 00 | 00 00 f0 3f d4 ff fd 1a |...*....|...?....|
|000008c0| 08 01 01 01 01 13 1a 00 | 05 2a 00 00 00 00 00 00 |........|.*......|
|000008d0| f0 3f 1a 00 04 d4 d3 ff | 00 fd 03 06 01 1a 00 05 |.?......|........|
|000008e0| 2a 00 00 00 00 00 00 f0 | 3f 1a 00 04 2a 00 00 00 |*.......|?...*...|
|000008f0| 00 00 00 f0 3f d4 f4 00 | 08 1a 00 08 19 00 3e f2 |....?...|......>.|
|00000900| 14 00 fd 0c 08 01 01 01 | 01 05 1a 00 08 ff 00 fd |........|........|
|00000910| 04 06 02 06 fd 04 1b 05 | 00 fd 09 1b 03 01 05 1a |........|........|
|00000920| 03 01 ff fd 04 1b 06 01 | fb f6 00 01 1a 00 02 f4 |........|........|
|00000930| 03 01 1a 00 04 18 00 00 | 00 00 00 00 f0 3f 1d 16 |........|.....?..|
|00000940| 00 1a 00 04 18 00 00 00 | 00 00 00 f0 3f f7 1a 03 |........|....?...|
|00000950| 01 2e f4 03 01 1a 03 01 | f5 6d 00 fd 31 17 01 1b |........|.m..1...|
|00000960| 19 05 3d 53 55 4d 28 1a | 00 03 1a 03 01 1a 00 05 |..=SUM(.|........|
|00000970| 1a 03 01 d8 35 19 01 29 | 35 ff 01 12 1a 00 05 2a |....5..)|5......*|
|00000980| 00 00 00 00 00 00 f0 3f | 1a 03 01 d4 ff fd 11 08 |.......?|........|
|00000990| 01 01 01 01 0a 1a 00 05 | 1a 03 01 d4 d3 ff 00 fd |........|........|
|000009a0| 03 06 01 fd 1a 08 01 01 | 01 01 13 1a 00 05 2a 00 |........|......*.|
|000009b0| 00 00 00 00 00 f0 3f 1a | 03 01 d4 d3 ff 00 fd 04 |......?.|........|
|000009c0| 06 02 06 1d 7d ff 1a 00 | 03 1a 03 01 1a 00 05 1a |....}...|........|
|000009d0| 03 01 d8 f4 00 07 1a 00 | 05 2a 00 00 00 00 00 00 |........|.*......|
|000009e0| f0 3f 1a 00 02 2b 00 00 | 00 00 00 00 f0 3f d4 d3 |.?...+..|.....?..|
|000009f0| f4 00 09 fd 19 08 01 01 | 01 01 12 1a 00 05 1a 00 |........|........|
|00000a00| 02 2b 00 00 00 00 00 00 | f0 3f d4 ff 00 fd 03 06 |.+......|.?......|
|00000a10| 01 1a 00 09 53 f2 29 00 | fd 0f 17 00 05 54 6f 74 |....S.).|.....Tot|
|00000a20| 61 6c 01 05 1a 00 09 ff | fd 0c 08 01 01 01 01 05 |al......|........|
|00000a30| 1a 00 09 ff 00 fd 04 0f | 04 03 fd 04 06 02 06 fb |........|........|
|00000a40| f6 00 01 1a 00 03 f4 03 | 01 1a 00 05 18 00 00 00 |........|........|
|00000a50| 00 00 00 f0 3f 1d 16 00 | 1a 00 05 18 00 00 00 00 |....?...|........|
|00000a60| 00 00 f0 3f f7 1a 03 01 | 2e f4 03 01 1a 03 01 f5 |...?....|........|
|00000a70| 6d 00 fd 31 17 01 1b 19 | 05 3d 53 55 4d 28 1a 03 |m..1....|.=SUM(..|
|00000a80| 01 1a 00 02 1a 03 01 1a | 00 04 d8 35 19 01 29 35 |........|...5..)5|
|00000a90| ff 01 12 1a 03 01 1a 00 | 04 2a 00 00 00 00 00 00 |........|.*......|
|00000aa0| f0 3f d4 ff fd 11 08 01 | 01 01 01 0a 1a 03 01 1a |.?......|........|
|00000ab0| 00 04 d4 d3 ff 00 fd 03 | 06 01 fd 1a 08 01 01 01 |........|........|
|00000ac0| 01 13 1a 03 01 1a 00 04 | 2a 00 00 00 00 00 00 f0 |........|*.......|
|00000ad0| 3f d4 d3 ff 00 fd 04 06 | 02 06 1d 7d ff 1a 03 01 |?.......|...}....|
|00000ae0| 1a 00 02 1a 03 01 1a 00 | 04 d8 f4 00 06 1a 00 03 |........|........|
|00000af0| 2b 00 00 00 00 00 00 f0 | 3f 1a 00 04 2a 00 00 00 |+.......|?...*...|
|00000b00| 00 00 00 f0 3f d4 d3 f4 | 00 0a fd 19 08 01 01 01 |....?...|........|
|00000b10| 01 12 1a 00 03 2b 00 00 | 00 00 00 00 f0 3f 1a 00 |.....+..|.....?..|
|00000b20| 04 d4 ff 00 fd 03 06 01 | 1a 00 0a 53 f2 24 00 fd |........|...S.$..|
|00000b30| 0f 17 00 05 54 6f 74 61 | 6c 01 05 1a 00 0a ff fd |....Tota|l.......|
|00000b40| 0c 08 01 01 01 01 05 1a | 00 0a ff 00 fd 04 06 02 |........|........|
|00000b50| 06 fb f6 01 00 fd 08 23 | 01 05 1a 03 01 ff fd 04 |.......#|........|
|00000b60| 1b 06 01 fd 04 1b 05 00 | fd 03 1b 02 fc fb f6 03 |........|........|
|00000b70| 02 4a f4 03 05 1a 03 01 | f4 03 04 1a 03 02 18 00 |.J......|........|
|00000b80| 00 00 00 00 00 f0 3f 1d | 16 00 1a 03 02 18 00 00 |......?.|........|
|00000b90| 00 00 00 00 f0 3f f7 1a | 03 04 2e f4 03 04 1a 03 |.....?..|........|
|00000ba0| 04 f5 1a 00 1a 03 04 1a | 03 03 d4 d3 53 38 f2 0a |........|....S8..|
|00000bb0| 00 49 f4 03 05 1a 03 05 | fa 1d d0 ff 1a 03 05 fa |.I......|........|
|00000bc0| fb f6 03 02 4a f4 03 05 | 1a 03 01 f4 03 04 1a 03 |....J...|........|
|00000bd0| 02 18 00 00 00 00 00 00 | f0 3f 1d 16 00 1a 03 02 |........|.?......|
|00000be0| 18 00 00 00 00 00 00 f0 | 3f f7 1a 03 04 2e f4 03 |........|?.......|
|00000bf0| 04 1a 03 04 f5 1a 00 1a | 03 03 1a 03 04 d4 d3 53 |........|.......S|
|00000c00| 38 f2 0a 00 49 f4 03 05 | 1a 03 05 fa 1d d0 ff 1a |8...I...|........|
|00000c10| 03 05 fa fb f6 00 00 fb | fc 07 53 74 61 72 74 75 |........|..Startu|
|00000c20| 70 00 07 00 66 61 69 6c | 65 64 00 09 00 75 74 69 |p...fail|ed...uti|
|00000c30| 6c 4d 65 6e 75 05 00 72 | 6f 77 73 00 05 00 63 6f |lMenu..r|ows...co|
|00000c40| 6c 73 01 09 00 73 74 61 | 72 74 52 6f 77 02 09 00 |ls...sta|rtRow...|
|00000c50| 73 74 61 72 74 43 6f 6c | 03 07 00 65 6e 64 52 6f |startCol|...endRo|
|00000c60| 77 04 07 00 65 6e 64 43 | 6f 6c 05 0c 00 63 6f 6c |w...endC|ol...col|
|00000c70| 54 6f 74 61 6c 52 6e 67 | 06 0c 00 72 6f 77 54 6f |TotalRng|...rowTo|
|00000c80| 74 61 6c 52 6e 67 07 08 | 00 63 66 52 61 6e 67 65 |talRng..|.cfRange|
|00000c90| 08 07 00 75 70 70 65 72 | 52 09 07 00 6c 6f 77 65 |...upper|R...lowe|
|00000ca0| 72 4c 0a 07 00 6d 79 4d | 65 6e 75 0b 05 00 6d 73 |rL...myM|enu...ms|
|00000cb0| 67 31 0c 04 00 6d 73 67 | 0d 05 00 6d 73 67 32 0e |g1...msg|...msg2.|
|00000cc0| 05 00 6d 73 67 33 0f 05 | 00 6d 73 67 34 10 05 00 |..msg3..|.msg4...|
|00000cd0| 6d 73 67 35 11 05 00 6d | 73 67 36 12 17 01 00 73 |msg5...m|sg6....s|
|00000ce0| 65 74 55 70 4c 6f 63 61 | 6c 69 7a 65 64 53 74 72 |etUpLoca|lizedStr|
|00000cf0| 69 6e 67 73 c4 00 00 00 | 07 01 00 74 6f 74 61 6c |ings....|...total|
|00000d00| 24 02 00 00 0c 01 00 69 | 6e 69 74 69 61 6c 69 7a |$......i|nitializ|
|00000d10| 65 21 00 00 00 0b 01 01 | 61 6c 65 72 74 55 73 65 |e!......|alertUse|
|00000d20| 72 7a 0a 00 00 0e 01 03 | 6d 79 49 53 42 4c 41 4e |rz......|myISBLAN|
|00000d30| 4b 72 6f 77 96 0a 00 00 | 0e 01 03 6d 79 49 53 42 |Krow....|...myISB|
|00000d40| 4c 41 4e 4b 63 6f 6c e9 | 0a 00 00 08 01 00 64 6f |LANKcol.|......do|
|00000d50| 52 6f 77 73 51 08 00 00 | 08 01 00 64 6f 43 6f 6c |RowsQ...|...doCol|
|00000d60| 73 68 09 00 00 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |sh...{**|********|
|00000d70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 54 6f |********|***** To|
|00000d90| 74 61 6c 20 53 43 52 49 | 50 54 20 2a 2a 2a 2a 2a |tal SCRI|PT *****|
|00000da0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000db0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000dc0| 2a 2a 2a 2a 2a 2a 2a 0d | 0d 4d 4f 44 49 46 49 45 |*******.|.MODIFIE|
|00000dd0| 44 3a 20 37 2f 39 2f 39 | 31 0d 0d 54 6f 74 61 6c |D: 7/9/9|1..Total|
|00000de0| 20 61 75 74 6f 6d 61 74 | 69 63 61 6c 6c 79 20 74 | automat|ically t|
|00000df0| 6f 74 61 6c 73 20 74 68 | 65 20 63 6f 6c 75 6d 6e |otals th|e column|
|00000e00| 73 20 61 6e 64 2f 6f 72 | 20 72 6f 77 73 20 6f 66 |s and/or| rows of|
|00000e10| 20 61 20 73 65 6c 65 63 | 74 65 64 20 72 61 6e 67 | a selec|ted rang|
|00000e20| 65 20 6f 66 20 63 65 6c | 6c 73 2e 20 20 49 74 20 |e of cel|ls.  It |
|00000e30| 63 72 65 61 74 65 73 0d | 61 20 22 74 6f 74 61 6c |creates.|a "total|
|00000e40| 22 20 72 6f 77 20 61 6e | 64 2f 6f 72 20 63 6f 6c |" row an|d/or col|
|00000e50| 75 6d 6e 2e 20 20 49 74 | 20 70 6c 61 63 65 73 20 |umn.  It| places |
|00000e60| 61 20 63 72 6f 73 73 20 | 66 6f 6f 74 20 74 6f 74 |a cross |foot tot|
|00000e70| 61 6c 20 77 68 65 72 65 | 20 74 68 65 20 22 74 6f |al where| the "to|
|00000e80| 74 61 6c 22 20 72 6f 77 | 20 61 6e 64 20 63 6f 6c |tal" row| and col|
|00000e90| 75 6d 6e 0d 6d 65 65 74 | 2e 20 20 20 0d 0d 41 73 |umn.meet|.   ..As|
|00000ea0| 73 75 6d 70 74 69 6f 6e | 73 3a 0d 09 a5 20 20 49 |sumption|s:...  I|
|00000eb0| 66 20 74 68 65 20 74 68 | 65 20 72 69 67 68 74 20 |f the th|e right |
|00000ec0| 63 6f 6c 75 6d 6e 20 6f | 72 20 62 6f 74 74 6f 6d |column o|r bottom|
|00000ed0| 20 72 6f 77 20 61 72 65 | 20 65 78 63 6c 75 73 69 | row are| exclusi|
|00000ee0| 76 65 6c 79 20 62 6c 61 | 6e 6b 2c 20 74 68 65 6e |vely bla|nk, then|
|00000ef0| 20 54 6f 74 61 6c 20 77 | 69 6c 6c 20 6f 6e 6c 79 | Total w|ill only|
|00000f00| 20 73 75 6d 20 74 68 65 | 20 0d 09 72 6f 77 73 20 | sum the| ..rows |
|00000f10| 6f 72 20 63 6f 6c 75 6d | 6e 73 2e 0d 09 a5 20 20 |or colum|ns....  |
|00000f20| 49 66 20 61 6e 79 20 63 | 65 6c 6c 20 69 73 20 6e |If any c|ell is n|
|00000f30| 6f 74 20 65 6d 70 74 79 | 20 69 6e 20 74 68 65 20 |ot empty| in the |
|00000f40| 63 6f 6c 75 6d 6e 20 6f | 72 20 72 6f 77 20 64 65 |column o|r row de|
|00000f50| 73 69 67 6e 61 74 65 64 | 20 66 6f 72 20 74 6f 74 |signated| for tot|
|00000f60| 61 6c 69 6e 67 2c 20 74 | 68 65 6e 20 54 6f 74 61 |aling, t|hen Tota|
|00000f70| 6c 20 77 69 6c 6c 20 65 | 78 69 74 20 0d 09 61 6e |l will e|xit ..an|
|00000f80| 64 20 74 68 65 20 75 73 | 65 72 20 77 69 6c 6c 20 |d the us|er will |
|00000f90| 62 65 20 61 6c 65 72 74 | 65 64 2e 20 0d 0d 2a 2a |be alert|ed. ..**|
|00000fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fc0| 2a 2a 2a 2a 2a 20 44 45 | 46 49 4e 45 20 47 4c 4f |***** DE|FINE GLO|
|00000fd0| 42 41 4c 53 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |BALS ***|********|
|00000fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ff0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001000| 2a 7d 0d 0d 44 45 46 49 | 4e 45 20 09 72 6f 77 73 |*}..DEFI|NE .rows|
|00001010| 2c 20 63 6f 6c 73 2c 20 | 73 74 61 72 74 52 6f 77 |, cols, |startRow|
|00001020| 2c 20 73 74 61 72 74 43 | 6f 6c 2c 20 65 6e 64 52 |, startC|ol, endR|
|00001030| 6f 77 2c 20 65 6e 64 43 | 6f 6c 2c 0d 09 09 63 6f |ow, endC|ol,...co|
|00001040| 6c 54 6f 74 61 6c 52 6e | 67 2c 20 72 6f 77 54 6f |lTotalRn|g, rowTo|
|00001050| 74 61 6c 52 6e 67 2c 20 | 63 66 52 61 6e 67 65 2c |talRng, |cfRange,|
|00001060| 20 75 70 70 65 72 52 2c | 20 6c 6f 77 65 72 4c 2c | upperR,| lowerL,|
|00001070| 20 20 0d 09 09 53 74 61 | 72 74 75 70 3a 66 61 69 |  ...Sta|rtup:fai|
|00001080| 6c 65 64 2c 20 6d 79 4d | 65 6e 75 2c 0d 09 09 6d |led, myM|enu,...m|
|00001090| 73 67 31 2c 20 6d 73 67 | 2c 20 6d 73 67 32 2c 20 |sg1, msg|, msg2, |
|000010a0| 6d 73 67 33 2c 20 6d 73 | 67 34 2c 20 6d 73 67 35 |msg3, ms|g4, msg5|
|000010b0| 2c 20 6d 73 67 36 0d 0d | 53 74 61 72 74 75 70 3a |, msg6..|Startup:|
|000010c0| 66 61 69 6c 65 64 20 3d | 20 46 41 4c 53 45 28 29 |failed =| FALSE()|
|000010d0| 09 09 09 09 09 09 09 09 | 09 7b 54 65 6c 6c 20 53 |........|.{Tell S|
|000010e0| 74 61 72 74 75 70 20 77 | 65 20 6c 6f 61 64 65 64 |tartup w|e loaded|
|000010f0| 2f 72 61 6e 20 73 75 63 | 63 65 73 73 66 75 6c 6c |/ran suc|cessfull|
|00001100| 79 7d 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |y}..{***|********|
|00001110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 4d 41 49 |********|**** MAI|
|00001130| 4e 20 53 43 52 49 50 54 | 20 2a 2a 2a 2a 2a 2a 2a |N SCRIPT| *******|
|00001140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001160| 2a 2a 2a 2a 2a 2a 2a 7d | 0d 0d 49 46 20 49 53 45 |*******}|..IF ISE|
|00001170| 52 52 28 53 74 61 72 74 | 75 70 3a 66 61 69 6c 65 |RR(Start|up:faile|
|00001180| 64 29 09 09 09 09 09 7b | 49 66 20 73 63 72 69 70 |d).....{|If scrip|
|00001190| 74 20 68 61 73 20 62 65 | 65 6e 20 6c 6f 61 64 65 |t has be|en loade|
|000011a0| 64 20 62 79 20 52 75 6e | 20 53 63 72 69 70 74 7d |d by Run| Script}|
|000011b0| 0d 09 43 41 4c 4c 20 73 | 65 74 55 70 4c 6f 63 61 |..CALL s|etUpLoca|
|000011c0| 6c 69 7a 65 64 53 74 72 | 69 6e 67 73 28 29 0d 09 |lizedStr|ings()..|
|000011d0| 43 41 4c 4c 20 74 6f 74 | 61 6c 28 29 0d 45 4c 53 |CALL tot|al().ELS|
|000011e0| 45 0d 09 43 41 4c 4c 20 | 69 6e 69 74 69 61 6c 69 |E..CALL |initiali|
|000011f0| 7a 65 28 29 09 09 09 09 | 09 7b 4f 74 68 65 72 77 |ze()....|.{Otherw|
|00001200| 69 73 65 2c 20 73 65 74 | 20 75 70 20 69 74 73 20 |ise, set| up its |
|00001210| 6d 65 6e 75 20 69 74 65 | 6d 7d 0d 45 4e 44 20 49 |menu ite|m}.END I|
|00001220| 46 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |F..{****|********|
|00001230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001240| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 69 6e 69 74 |********|*** init|
|00001250| 69 61 6c 69 7a 65 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ialize *|********|
|00001260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001280| 2a 2a 2a 2a 2a 2a 0d 43 | 72 65 61 74 65 20 6d 65 |******.C|reate me|
|00001290| 6e 75 69 74 65 6d 20 61 | 6e 64 20 61 74 74 61 63 |nuitem a|nd attac|
|000012a0| 68 20 73 63 72 69 70 74 | 2e 0d 2a 2a 2a 2a 2a 2a |h script|..******|
|000012b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000012f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 7d 0d 0d |********|*****}..|
|00001310| 46 55 4e 43 54 49 4f 4e | 20 69 6e 69 74 69 61 6c |FUNCTION| initial|
|00001320| 69 7a 65 28 29 0d 09 53 | 45 4c 45 43 54 20 4d 45 |ize()..S|ELECT ME|
|00001330| 4e 55 20 53 74 61 72 74 | 75 70 3a 75 74 69 6c 4d |NU Start|up:utilM|
|00001340| 65 6e 75 0d 09 43 41 4c | 4c 20 73 65 74 55 70 4c |enu..CAL|L setUpL|
|00001350| 6f 63 61 6c 69 7a 65 64 | 53 74 72 69 6e 67 73 28 |ocalized|Strings(|
|00001360| 29 0d 09 41 44 44 20 4d | 45 4e 55 49 54 45 4d 20 |)..ADD M|ENUITEM |
|00001370| 6d 79 4d 65 6e 75 20 43 | 4f 4d 4d 41 4e 44 20 22 |myMenu C|OMMAND "|
|00001380| 47 45 54 20 53 43 52 49 | 50 54 20 22 22 54 6f 74 |GET SCRI|PT ""Tot|
|00001390| 61 6c 22 22 20 0d 09 09 | 09 09 09 09 20 20 20 20 |al"" ...|....    |
|000013a0| 43 41 4c 4c 20 54 6f 74 | 61 6c 3a 73 65 74 55 70 |CALL Tot|al:setUp|
|000013b0| 4c 6f 63 61 6c 69 7a 65 | 64 53 74 72 69 6e 67 73 |Localize|dStrings|
|000013c0| 28 29 20 0d 09 09 09 09 | 09 09 20 20 20 20 43 41 |() .....|..    CA|
|000013d0| 4c 4c 20 54 6f 74 61 6c | 3a 74 6f 74 61 6c 28 29 |LL Total|:total()|
|000013e0| 20 0d 09 09 09 09 09 09 | 20 20 20 20 52 45 4d 4f | .......|    REMO|
|000013f0| 56 45 20 53 43 52 49 50 | 54 20 22 22 54 6f 74 61 |VE SCRIP|T ""Tota|
|00001400| 6c 22 22 22 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f |l""".END| FUNCTIO|
|00001410| 4e 09 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N...{***|********|
|00001420| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001430| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 4c 4f 43 |********|**** LOC|
|00001440| 41 4c 49 5a 45 20 48 45 | 52 45 20 2a 2a 2a 2a 2a |ALIZE HE|RE *****|
|00001450| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001460| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001470| 2a 2a 2a 2a 2a 2a 2a 0d | 09 09 53 74 72 69 6e 67 |*******.|..String|
|00001480| 73 20 74 68 61 74 20 61 | 72 65 20 6c 6f 63 61 6c |s that a|re local|
|00001490| 69 7a 61 62 6c 65 20 61 | 72 65 20 61 73 73 69 67 |izable a|re assig|
|000014a0| 6e 65 64 20 74 6f 20 76 | 61 72 69 61 62 6c 65 73 |ned to v|ariables|
|000014b0| 20 69 6e 20 74 68 69 73 | 20 66 75 6e 63 74 69 6f | in this| functio|
|000014c0| 6e 2e 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |n..*****|********|
|000014d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000014f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001500| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001510| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001520| 2a 2a 2a 2a 2a 7d 0d 46 | 55 4e 43 54 49 4f 4e 20 |*****}.F|UNCTION |
|00001530| 73 65 74 55 70 4c 6f 63 | 61 6c 69 7a 65 64 53 74 |setUpLoc|alizedSt|
|00001540| 72 69 6e 67 73 28 29 0d | 09 6d 79 4d 65 6e 75 20 |rings().|.myMenu |
|00001550| 3d 20 22 54 6f 74 61 6c | 20 52 61 6e 67 65 22 0d |= "Total| Range".|
|00001560| 09 6d 73 67 20 3d 20 22 | 50 6c 65 61 73 65 20 6f |.msg = "|Please o|
|00001570| 70 65 6e 20 61 20 77 6f | 72 6b 73 68 65 65 74 20 |pen a wo|rksheet |
|00001580| 6f 72 20 62 72 69 6e 67 | 20 6f 6e 65 20 74 6f 20 |or bring| one to |
|00001590| 66 72 6f 6e 74 2e 22 0d | 09 6d 73 67 31 20 3d 20 |front.".|.msg1 = |
|000015a0| 22 57 6f 77 21 20 20 54 | 72 79 20 61 20 73 6d 61 |"Wow!  T|ry a sma|
|000015b0| 6c 6c 65 72 20 72 61 6e | 67 65 20 70 6c 65 61 73 |ller ran|ge pleas|
|000015c0| 65 2e 22 0d 09 6d 73 67 | 32 20 3d 20 22 50 6c 65 |e."..msg|2 = "Ple|
|000015d0| 61 73 65 20 73 65 6c 65 | 63 74 20 61 20 72 61 6e |ase sele|ct a ran|
|000015e0| 67 65 20 6f 66 20 6e 75 | 6d 62 65 72 73 20 74 6f |ge of nu|mbers to|
|000015f0| 20 74 6f 74 61 6c 2e 22 | 0d 09 6d 73 67 33 20 3d | total."|..msg3 =|
|00001600| 20 22 54 68 65 20 63 6f | 6c 75 6d 6e 20 6f 72 20 | "The co|lumn or |
|00001610| 72 6f 77 20 77 68 65 72 | 65 20 74 68 65 20 74 6f |row wher|e the to|
|00001620| 74 61 6c 73 20 77 69 6c | 6c 20 62 65 20 65 6e 74 |tals wil|l be ent|
|00001630| 65 72 65 64 20 61 72 65 | 20 6e 6f 74 20 65 6d 70 |ered are| not emp|
|00001640| 74 79 2e 22 0d 09 6d 73 | 67 34 20 3d 20 22 54 68 |ty."..ms|g4 = "Th|
|00001650| 65 20 63 6f 6c 75 6d 6e | 20 77 68 65 72 65 20 74 |e column| where t|
|00001660| 68 65 20 74 6f 74 61 6c | 73 20 77 69 6c 6c 20 62 |he total|s will b|
|00001670| 65 20 65 6e 74 65 72 65 | 64 20 69 73 20 6e 6f 74 |e entere|d is not|
|00001680| 20 65 6d 70 74 79 2e 22 | 0d 09 6d 73 67 35 20 3d | empty."|..msg5 =|
|00001690| 20 22 54 68 65 20 72 6f | 77 20 77 68 65 72 65 20 | "The ro|w where |
|000016a0| 74 68 65 20 74 6f 74 61 | 6c 73 20 77 69 6c 6c 20 |the tota|ls will |
|000016b0| 62 65 20 65 6e 74 65 72 | 65 64 20 69 73 20 6e 6f |be enter|ed is no|
|000016c0| 74 20 65 6d 70 74 79 2e | 22 0d 09 6d 73 67 35 20 |t empty.|"..msg5 |
|000016d0| 3d 20 22 22 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f |= "".END| FUNCTIO|
|000016e0| 4e 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N..{****|********|
|000016f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001700| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 74 6f 74 61 |********|*** tota|
|00001710| 6c 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |l ******|********|
|00001720| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001730| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001740| 2a 2a 2a 2a 2a 0d 54 68 | 69 73 20 66 75 6e 63 74 |*****.Th|is funct|
|00001750| 69 6f 6e 20 64 65 74 65 | 72 6d 69 6e 65 73 20 77 |ion dete|rmines w|
|00001760| 68 65 72 65 20 74 6f 20 | 70 6c 61 63 65 20 74 6f |here to |place to|
|00001770| 74 61 6c 73 20 66 6f 72 | 20 74 68 65 20 72 61 6e |tals for| the ran|
|00001780| 67 65 20 73 65 6c 65 63 | 74 65 64 2e 0d 2a 2a 2a |ge selec|ted..***|
|00001790| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 7d |********|*******}|
|000017f0| 0d 0d 46 55 4e 43 54 49 | 4f 4e 20 74 6f 74 61 6c |..FUNCTI|ON total|
|00001800| 28 29 0d 44 45 46 49 4e | 45 20 73 65 6c 52 61 6e |().DEFIN|E selRan|
|00001810| 67 65 2c 20 62 6f 74 74 | 6f 6d 52 6f 77 49 73 42 |ge, bott|omRowIsB|
|00001820| 6c 61 6e 6b 2c 20 72 69 | 67 68 74 43 6f 6c 75 6d |lank, ri|ghtColum|
|00001830| 6e 49 73 42 6c 61 6e 6b | 0d 09 49 46 20 49 53 45 |nIsBlank|..IF ISE|
|00001840| 52 52 28 46 75 6c 6c 50 | 61 74 68 4e 61 6d 65 28 |RR(FullP|athName(|
|00001850| 29 29 0d 09 09 4d 45 53 | 53 41 47 45 20 6d 73 67 |))...MES|SAGE msg|
|00001860| 0d 09 09 45 58 49 54 20 | 53 43 52 49 50 54 0d 09 |...EXIT |SCRIPT..|
|00001870| 45 4e 44 20 49 46 0d 09 | 49 4e 56 41 4c 49 44 41 |END IF..|INVALIDA|
|00001880| 54 45 20 4f 4e 0d 09 52 | 45 50 41 49 4e 54 20 53 |TE ON..R|EPAINT S|
|00001890| 45 4c 45 43 54 49 4f 4e | 53 20 4f 46 46 0d 09 63 |ELECTION|S OFF..c|
|000018a0| 66 52 61 6e 67 65 20 3d | 20 22 22 0d 09 72 6f 77 |fRange =| ""..row|
|000018b0| 54 6f 74 61 6c 52 6e 67 | 20 3d 20 22 22 0d 09 63 |TotalRng| = ""..c|
|000018c0| 6f 6c 54 6f 74 61 6c 52 | 6e 67 20 3d 20 22 22 0d |olTotalR|ng = "".|
|000018d0| 09 73 65 6c 52 61 6e 67 | 65 20 3d 20 53 45 4c 45 |.selRang|e = SELE|
|000018e0| 43 54 49 4f 4e 28 31 29 | 0d 09 49 46 20 53 45 4c |CTION(1)|..IF SEL|
|000018f0| 45 43 54 49 4f 4e 54 59 | 50 45 28 31 29 20 3c 3e |ECTIONTY|PE(1) <>|
|00001900| 20 31 09 09 09 09 09 09 | 09 09 09 7b 4d 61 6b 65 | 1......|...{Make|
|00001910| 20 73 75 72 65 20 61 20 | 72 61 6e 67 65 20 6f 66 | sure a |range of|
|00001920| 20 63 65 6c 6c 73 20 68 | 61 76 65 20 62 65 65 6e | cells h|ave been|
|00001930| 20 73 65 6c 65 63 74 65 | 64 7d 0d 09 09 43 41 4c | selecte|d}...CAL|
|00001940| 4c 20 61 6c 65 72 74 55 | 73 65 72 28 6d 73 67 32 |L alertU|ser(msg2|
|00001950| 29 0d 09 45 4e 44 20 49 | 46 0d 09 53 45 4c 45 43 |)..END I|F..SELEC|
|00001960| 54 20 52 41 4e 47 45 20 | 73 65 6c 52 61 6e 67 65 |T RANGE |selRange|
|00001970| 09 09 09 09 09 09 09 09 | 09 7b 52 65 73 65 6c 65 |........|.{Resele|
|00001980| 63 74 20 52 61 6e 67 65 | 20 69 6e 20 63 61 73 65 |ct Range| in case|
|00001990| 20 73 65 6c 65 63 74 69 | 6f 6e 20 77 61 73 20 66 | selecti|on was f|
|000019a0| 72 6f 6d 20 72 69 67 68 | 74 2d 74 6f 2d 6c 65 66 |rom righ|t-to-lef|
|000019b0| 74 7d 0d 09 63 6f 6c 73 | 20 3d 20 43 4f 4c 55 4d |t}..cols| = COLUM|
|000019c0| 4e 53 28 52 41 4e 47 45 | 28 52 45 46 45 52 45 4e |NS(RANGE|(REFEREN|
|000019d0| 43 45 28 73 65 6c 52 61 | 6e 67 65 29 29 29 09 09 |CE(selRa|nge)))..|
|000019e0| 09 09 09 7b 44 65 74 65 | 72 6d 69 6e 65 20 74 6f |...{Dete|rmine to|
|000019f0| 74 61 6c 20 6e 75 6d 62 | 65 72 20 6f 66 20 63 6f |tal numb|er of co|
|00001a00| 6c 75 6d 6e 73 20 61 6e | 64 20 72 6f 77 73 7d 0d |lumns an|d rows}.|
|00001a10| 09 72 6f 77 73 20 3d 20 | 52 4f 57 53 28 52 41 4e |.rows = |ROWS(RAN|
|00001a20| 47 45 28 52 45 46 45 52 | 45 4e 43 45 28 73 65 6c |GE(REFER|ENCE(sel|
|00001a30| 52 61 6e 67 65 29 29 29 | 0d 09 73 74 61 72 74 52 |Range)))|..startR|
|00001a40| 6f 77 20 3d 20 52 4f 57 | 28 29 0d 09 65 6e 64 52 |ow = ROW|()..endR|
|00001a50| 6f 77 20 3d 20 73 74 61 | 72 74 52 6f 77 20 2b 20 |ow = sta|rtRow + |
|00001a60| 28 72 6f 77 73 20 2d 20 | 31 29 0d 09 73 74 61 72 |(rows - |1)..star|
|00001a70| 74 43 6f 6c 20 3d 20 43 | 4f 4c 55 4d 4e 28 29 0d |tCol = C|OLUMN().|
|00001a80| 09 65 6e 64 43 6f 6c 20 | 3d 20 73 74 61 72 74 43 |.endCol |= startC|
|00001a90| 6f 6c 20 2b 20 28 63 6f | 6c 73 20 2d 31 29 0d 09 |ol + (co|ls -1)..|
|00001aa0| 49 46 20 63 6f 6c 73 20 | 3e 20 33 32 37 36 37 20 |IF cols |> 32767 |
|00001ab0| 4f 52 20 72 6f 77 73 20 | 3e 20 33 32 37 36 37 09 |OR rows |> 32767.|
|00001ac0| 09 09 09 09 09 09 7b 4d | 61 6b 65 20 73 75 72 65 |......{M|ake sure|
|00001ad0| 20 74 68 65 20 72 61 6e | 67 65 20 73 69 7a 65 20 | the ran|ge size |
|00001ae0| 73 65 6c 65 63 74 65 64 | 20 69 73 6e 27 74 20 74 |selected| isn't t|
|00001af0| 6f 6f 20 62 69 67 7d 0d | 09 09 43 41 4c 4c 20 61 |oo big}.|..CALL a|
|00001b00| 6c 65 72 74 55 73 65 72 | 28 6d 73 67 31 29 0d 09 |lertUser|(msg1)..|
|00001b10| 45 4e 44 20 49 46 0d 09 | 62 6f 74 74 6f 6d 52 6f |END IF..|bottomRo|
|00001b20| 77 49 73 42 6c 61 6e 6b | 20 3d 20 6d 79 49 53 42 |wIsBlank| = myISB|
|00001b30| 4c 41 4e 4b 72 6f 77 28 | 73 74 61 72 74 43 6f 6c |LANKrow(|startCol|
|00001b40| 2c 20 65 6e 64 43 6f 6c | 2c 20 65 6e 64 52 6f 77 |, endCol|, endRow|
|00001b50| 29 09 09 7b 46 69 6e 64 | 20 6f 75 74 20 69 66 20 |)..{Find| out if |
|00001b60| 62 6f 74 74 6f 6d 20 72 | 6f 77 20 61 6e 64 2f 6f |bottom r|ow and/o|
|00001b70| 72 20 72 69 67 68 74 20 | 63 6f 6c 75 6d 6e 20 61 |r right |column a|
|00001b80| 72 65 20 62 6c 61 6e 6b | 7d 0d 09 72 69 67 68 74 |re blank|}..right|
|00001b90| 43 6f 6c 75 6d 6e 49 73 | 42 6c 61 6e 6b 20 3d 20 |ColumnIs|Blank = |
|00001ba0| 6d 79 49 53 42 4c 41 4e | 4b 63 6f 6c 28 73 74 61 |myISBLAN|Kcol(sta|
|00001bb0| 72 74 52 6f 77 2c 20 65 | 6e 64 52 6f 77 2c 20 65 |rtRow, e|ndRow, e|
|00001bc0| 6e 64 43 6f 6c 29 0d 09 | 49 46 20 63 6f 6c 73 20 |ndCol)..|IF cols |
|00001bd0| 3d 20 31 20 72 69 67 68 | 74 43 6f 6c 75 6d 6e 49 |= 1 righ|tColumnI|
|00001be0| 73 42 6c 61 6e 6b 20 3d | 20 46 41 4c 53 45 28 29 |sBlank =| FALSE()|
|00001bf0| 20 45 4e 44 20 49 46 0d | 09 49 46 20 72 6f 77 73 | END IF.|.IF rows|
|00001c00| 20 3d 20 31 20 62 6f 74 | 74 6f 6d 52 6f 77 49 73 | = 1 bot|tomRowIs|
|00001c10| 42 6c 61 6e 6b 20 3d 20 | 46 41 4c 53 45 28 29 20 |Blank = |FALSE() |
|00001c20| 45 4e 44 20 49 46 0d 09 | 49 46 20 49 53 54 45 58 |END IF..|IF ISTEX|
|00001c30| 54 28 49 4e 44 49 52 45 | 43 54 28 4d 41 4b 45 43 |T(INDIRE|CT(MAKEC|
|00001c40| 45 4c 4c 28 43 4f 4c 55 | 4d 4e 28 29 2c 52 4f 57 |ELL(COLU|MN(),ROW|
|00001c50| 28 29 20 2b 20 31 29 29 | 29 09 09 09 09 7b 49 66 |() + 1))|)....{If|
|00001c60| 20 66 69 72 73 74 20 63 | 6f 6c 75 6d 6e 20 63 6f | first c|olumn co|
|00001c70| 6e 74 61 69 6e 73 20 74 | 65 78 74 2c 20 74 68 65 |ntains t|ext, the|
|00001c80| 6e 20 6d 6f 76 65 20 31 | 20 63 6f 6c 75 6d 6e 20 |n move 1| column |
|00001c90| 74 6f 20 74 68 65 20 72 | 69 67 74 7d 0d 09 09 73 |to the r|igt}...s|
|00001ca0| 74 61 72 74 43 6f 6c 20 | 3d 20 73 74 61 72 74 43 |tartCol |= startC|
|00001cb0| 6f 6c 20 2b 20 31 0d 09 | 45 4e 44 20 49 46 0d 09 |ol + 1..|END IF..|
|00001cc0| 49 46 20 49 53 54 45 58 | 54 28 49 4e 44 49 52 45 |IF ISTEX|T(INDIRE|
|00001cd0| 43 54 28 28 4d 41 4b 45 | 43 45 4c 4c 28 43 4f 4c |CT((MAKE|CELL(COL|
|00001ce0| 55 4d 4e 28 29 20 2b 20 | 31 2c 52 4f 57 28 29 29 |UMN() + |1,ROW())|
|00001cf0| 29 29 29 09 09 09 7b 49 | 66 20 66 69 72 73 74 20 |)))...{I|f first |
|00001d00| 72 6f 77 20 63 6f 6e 74 | 61 69 6e 73 20 74 65 78 |row cont|ains tex|
|00001d10| 74 2c 20 74 68 65 6e 20 | 6d 6f 76 65 20 31 20 72 |t, then |move 1 r|
|00001d20| 6f 77 20 64 6f 77 6e 7d | 0d 09 09 73 74 61 72 74 |ow down}|...start|
|00001d30| 52 6f 77 20 3d 20 73 74 | 61 72 74 52 6f 77 20 2b |Row = st|artRow +|
|00001d40| 20 31 0d 09 45 4e 44 20 | 49 46 0d 09 49 46 20 6d | 1..END |IF..IF m|
|00001d50| 79 49 53 42 4c 41 4e 4b | 72 6f 77 28 73 74 61 72 |yISBLANK|row(star|
|00001d60| 74 43 6f 6c 2c 65 6e 64 | 43 6f 6c 2c 65 6e 64 52 |tCol,end|Col,endR|
|00001d70| 6f 77 29 20 41 4e 44 20 | 28 72 6f 77 73 20 3c 3e |ow) AND |(rows <>|
|00001d80| 20 31 29 09 09 7b 49 66 | 20 72 69 67 68 74 20 6d | 1)..{If| right m|
|00001d90| 6f 73 74 20 63 6f 6c 75 | 6d 6e 20 69 73 20 61 20 |ost colu|mn is a |
|00001da0| 62 6c 61 6e 6b 20 63 6f | 6c 75 6d 6e 2c 20 74 68 |blank co|lumn, th|
|00001db0| 65 6e 20 6d 6f 76 65 20 | 31 20 63 6f 6c 75 6d 6e |en move |1 column|
|00001dc0| 20 69 6e 7d 0d 09 09 65 | 6e 64 52 6f 77 20 3d 20 | in}...e|ndRow = |
|00001dd0| 65 6e 64 52 6f 77 20 2d | 20 31 0d 09 45 4e 44 20 |endRow -| 1..END |
|00001de0| 49 46 0d 09 49 46 20 6d | 79 49 53 42 4c 41 4e 4b |IF..IF m|yISBLANK|
|00001df0| 63 6f 6c 28 73 74 61 72 | 74 52 6f 77 2c 65 6e 64 |col(star|tRow,end|
|00001e00| 52 6f 77 2c 65 6e 64 43 | 6f 6c 29 20 41 4e 44 20 |Row,endC|ol) AND |
|00001e10| 28 63 6f 6c 73 20 3c 3e | 20 31 29 09 09 7b 49 66 |(cols <>| 1)..{If|
|00001e20| 20 62 6f 74 74 6f 6d 20 | 6d 6f 73 74 20 72 6f 77 | bottom |most row|
|00001e30| 20 69 73 20 61 20 62 6c | 61 6e 6b 20 72 6f 77 2c | is a bl|ank row,|
|00001e40| 20 74 68 65 6e 20 6d 6f | 76 65 20 31 20 72 6f 77 | then mo|ve 1 row|
|00001e50| 20 75 70 7d 0d 09 09 65 | 6e 64 43 6f 6c 20 3d 20 | up}...e|ndCol = |
|00001e60| 65 6e 64 43 6f 6c 20 2d | 20 31 0d 09 45 4e 44 20 |endCol -| 1..END |
|00001e70| 49 46 0d 09 43 41 53 45 | 20 0d 09 57 48 45 4e 20 |IF..CASE| ..WHEN |
|00001e80| 4e 4f 54 20 62 6f 74 74 | 6f 6d 52 6f 77 49 73 42 |NOT bott|omRowIsB|
|00001e90| 6c 61 6e 6b 20 41 4e 44 | 20 4e 4f 54 20 72 69 67 |lank AND| NOT rig|
|00001ea0| 68 74 43 6f 6c 75 6d 6e | 49 73 42 6c 61 6e 6b 09 |htColumn|IsBlank.|
|00001eb0| 09 09 7b 54 6f 74 61 6c | 20 52 6f 77 20 61 6e 64 |..{Total| Row and|
|00001ec0| 20 43 6f 6c 75 6d 6e 20 | 61 72 65 20 6e 6f 74 20 | Column |are not |
|00001ed0| 65 6d 70 74 79 7d 0d 09 | 09 49 46 20 4e 4f 54 20 |empty}..|.IF NOT |
|00001ee0| 6d 79 49 53 42 4c 41 4e | 4b 63 6f 6c 28 73 74 61 |myISBLAN|Kcol(sta|
|00001ef0| 72 74 52 6f 77 2c 65 6e | 64 52 6f 77 20 2b 20 31 |rtRow,en|dRow + 1|
|00001f00| 2c 65 6e 64 43 6f 6c 20 | 2b 20 31 29 20 41 4e 44 |,endCol |+ 1) AND|
|00001f10| 20 4e 4f 54 20 6d 79 49 | 53 42 4c 41 4e 4b 72 6f | NOT myI|SBLANKro|
|00001f20| 77 28 73 74 61 72 74 43 | 6f 6c 2c 65 6e 64 43 6f |w(startC|ol,endCo|
|00001f30| 6c 20 2b 20 31 2c 65 6e | 64 52 6f 77 20 2b 20 31 |l + 1,en|dRow + 1|
|00001f40| 29 20 7b 63 68 61 6e 67 | 65 64 20 74 6f 20 41 4e |) {chang|ed to AN|
|00001f50| 44 20 66 72 6f 6d 20 4f | 52 20 36 2f 32 34 7d 0d |D from O|R 6/24}.|
|00001f60| 09 09 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 20 |...SELEC|T RANGE |
|00001f70| 4d 41 4b 45 52 41 4e 47 | 45 28 73 74 61 72 74 43 |MAKERANG|E(startC|
|00001f80| 6f 6c 2c 20 65 6e 64 52 | 6f 77 20 2b 20 31 2c 20 |ol, endR|ow + 1, |
|00001f90| 65 6e 64 43 6f 6c 20 2b | 20 31 2c 20 65 6e 64 52 |endCol +| 1, endR|
|00001fa0| 6f 77 20 2b 20 31 29 0d | 09 09 09 53 45 4c 45 43 |ow + 1).|...SELEC|
|00001fb0| 54 20 4d 4f 52 45 20 52 | 41 4e 47 45 20 4d 41 4b |T MORE R|ANGE MAK|
|00001fc0| 45 52 41 4e 47 45 28 65 | 6e 64 43 6f 6c 20 2b 20 |ERANGE(e|ndCol + |
|00001fd0| 31 2c 20 73 74 61 72 74 | 52 6f 77 2c 20 65 6e 64 |1, start|Row, end|
|00001fe0| 43 6f 6c 20 2b 20 31 2c | 20 65 6e 64 52 6f 77 20 |Col + 1,| endRow |
|00001ff0| 2b 20 31 29 0d 09 09 09 | 43 41 4c 4c 20 61 6c 65 |+ 1)....|CALL ale|
|00002000| 72 74 55 73 65 72 28 6d | 73 67 33 29 0d 09 09 45 |rtUser(m|sg3)...E|
|00002010| 4e 44 20 49 46 0d 09 09 | 49 46 20 28 63 6f 6c 73 |ND IF...|IF (cols|
|00002020| 20 3e 20 31 29 20 41 4e | 44 20 6d 79 49 53 42 4c | > 1) AN|D myISBL|
|00002030| 41 4e 4b 63 6f 6c 28 73 | 74 61 72 74 52 6f 77 2c |ANKcol(s|tartRow,|
|00002040| 65 6e 64 52 6f 77 20 2b | 20 31 2c 65 6e 64 43 6f |endRow +| 1,endCo|
|00002050| 6c 20 2b 20 31 29 20 43 | 41 4c 4c 20 64 6f 52 6f |l + 1) C|ALL doRo|
|00002060| 77 73 28 29 20 45 4e 44 | 20 49 46 0d 20 09 09 49 |ws() END| IF. ..I|
|00002070| 46 20 28 72 6f 77 73 20 | 3e 20 31 29 20 41 4e 44 |F (rows |> 1) AND|
|00002080| 20 6d 79 49 53 42 4c 41 | 4e 4b 72 6f 77 28 73 74 | myISBLA|NKrow(st|
|00002090| 61 72 74 43 6f 6c 2c 65 | 6e 64 43 6f 6c 20 2b 20 |artCol,e|ndCol + |
|000020a0| 31 2c 65 6e 64 52 6f 77 | 20 2b 20 31 29 20 43 41 |1,endRow| + 1) CA|
|000020b0| 4c 4c 20 64 6f 43 6f 6c | 73 28 29 20 45 4e 44 20 |LL doCol|s() END |
|000020c0| 49 46 0d 09 09 49 46 20 | 28 63 6f 6c 73 20 3e 20 |IF...IF |(cols > |
|000020d0| 31 29 20 41 4e 44 20 28 | 72 6f 77 73 20 3e 20 31 |1) AND (|rows > 1|
|000020e0| 29 09 09 09 09 09 09 09 | 7b 49 66 20 6d 6f 72 65 |).......|{If more|
|000020f0| 20 74 68 61 6e 20 31 20 | 63 6f 6c 75 6d 6e 20 61 | than 1 |column a|
|00002100| 6e 64 20 72 6f 77 2c 20 | 74 68 65 6e 20 70 75 74 |nd row, |then put|
|00002110| 20 63 72 6f 73 73 66 6f | 6f 74 20 69 6e 20 6c 6f | crossfo|ot in lo|
|00002120| 77 65 72 20 72 69 67 68 | 74 20 63 65 6c 6c 7d 0d |wer righ|t cell}.|
|00002130| 09 09 09 50 55 54 20 22 | 3d 49 46 28 53 55 4d 28 |...PUT "|=IF(SUM(|
|00002140| 22 20 26 20 63 6f 6c 54 | 6f 74 61 6c 52 6e 67 20 |" & colT|otalRng |
|00002150| 26 20 22 29 3c 3e 53 55 | 4d 28 22 20 26 20 72 6f |& ")<>SU|M(" & ro|
|00002160| 77 54 6f 74 61 6c 52 6e | 67 20 26 20 22 29 2c 45 |wTotalRn|g & "),E|
|00002170| 52 52 28 29 2c 53 55 4d | 28 22 20 26 20 63 6f 6c |RR(),SUM|(" & col|
|00002180| 54 6f 74 61 6c 52 6e 67 | 20 26 20 22 29 29 22 20 |TotalRng| & "))" |
|00002190| 49 4e 54 4f 20 4d 41 4b | 45 43 45 4c 4c 28 65 6e |INTO MAK|ECELL(en|
|000021a0| 64 43 6f 6c 20 2b 20 31 | 2c 65 6e 64 52 6f 77 20 |dCol + 1|,endRow |
|000021b0| 2b 20 31 29 0d 09 09 09 | 53 45 4c 45 43 54 20 52 |+ 1)....|SELECT R|
|000021c0| 41 4e 47 45 20 52 41 4e | 47 45 28 4d 41 4b 45 43 |ANGE RAN|GE(MAKEC|
|000021d0| 45 4c 4c 28 65 6e 64 43 | 6f 6c 20 2b 20 31 2c 65 |ELL(endC|ol + 1,e|
|000021e0| 6e 64 52 6f 77 29 29 09 | 09 7b 47 65 74 20 66 6f |ndRow)).|.{Get fo|
|000021f0| 72 6d 61 74 20 61 62 6f | 76 65 20 63 72 6f 73 73 |rmat abo|ve cross|
|00002200| 66 6f 6f 74 20 66 6f 72 | 20 6c 61 74 65 72 20 70 |foot for| later p|
|00002210| 61 73 74 69 6e 67 7d 0d | 09 09 09 43 4f 50 59 0d |asting}.|...COPY.|
|00002220| 09 09 09 63 66 52 61 6e | 67 65 20 3d 20 4d 41 4b |...cfRan|ge = MAK|
|00002230| 45 43 45 4c 4c 28 65 6e | 64 43 6f 6c 20 2b 20 31 |ECELL(en|dCol + 1|
|00002240| 2c 65 6e 64 52 6f 77 20 | 2b 20 31 29 0d 09 09 45 |,endRow |+ 1)...E|
|00002250| 4e 44 20 49 46 0d 09 57 | 48 45 4e 20 4e 4f 54 20 |ND IF..W|HEN NOT |
|00002260| 62 6f 74 74 6f 6d 52 6f | 77 49 73 42 6c 61 6e 6b |bottomRo|wIsBlank|
|00002270| 20 41 4e 44 20 72 69 67 | 68 74 43 6f 6c 75 6d 6e | AND rig|htColumn|
|00002280| 49 73 42 6c 61 6e 6b 09 | 09 09 09 7b 54 6f 74 61 |IsBlank.|...{Tota|
|00002290| 6c 20 43 6f 6c 75 6d 6e | 20 69 73 20 65 6d 70 74 |l Column| is empt|
|000022a0| 79 7d 0d 09 09 49 46 20 | 4e 4f 54 20 6d 79 49 53 |y}...IF |NOT myIS|
|000022b0| 42 4c 41 4e 4b 63 6f 6c | 28 73 74 61 72 74 52 6f |BLANKcol|(startRo|
|000022c0| 77 2c 65 6e 64 52 6f 77 | 20 2b 20 31 2c 65 6e 64 |w,endRow| + 1,end|
|000022d0| 43 6f 6c 20 2b 20 31 29 | 0d 09 09 09 53 45 4c 45 |Col + 1)|....SELE|
|000022e0| 43 54 20 52 41 4e 47 45 | 20 4d 41 4b 45 52 41 4e |CT RANGE| MAKERAN|
|000022f0| 47 45 28 65 6e 64 43 6f | 6c 20 2b 20 31 2c 20 73 |GE(endCo|l + 1, s|
|00002300| 74 61 72 74 52 6f 77 2c | 20 65 6e 64 43 6f 6c 20 |tartRow,| endCol |
|00002310| 2b 20 31 2c 20 65 6e 64 | 52 6f 77 20 2b 20 31 29 |+ 1, end|Row + 1)|
|00002320| 0d 09 09 09 43 41 4c 4c | 20 61 6c 65 72 74 55 73 |....CALL| alertUs|
|00002330| 65 72 28 6d 73 67 34 29 | 0d 09 09 45 4e 44 20 49 |er(msg4)|...END I|
|00002340| 46 0d 09 09 43 41 4c 4c | 20 64 6f 52 6f 77 73 28 |F...CALL| doRows(|
|00002350| 29 0d 09 57 48 45 4e 20 | 62 6f 74 74 6f 6d 52 6f |)..WHEN |bottomRo|
|00002360| 77 49 73 42 6c 61 6e 6b | 20 41 4e 44 20 4e 4f 54 |wIsBlank| AND NOT|
|00002370| 20 72 69 67 68 74 43 6f | 6c 75 6d 6e 49 73 42 6c | rightCo|lumnIsBl|
|00002380| 61 6e 6b 09 09 09 09 7b | 54 6f 74 61 6c 20 52 6f |ank....{|Total Ro|
|00002390| 77 20 69 73 20 65 6d 70 | 74 79 7d 0d 09 09 49 46 |w is emp|ty}...IF|
|000023a0| 20 4e 4f 54 20 6d 79 49 | 53 42 4c 41 4e 4b 72 6f | NOT myI|SBLANKro|
|000023b0| 77 28 73 74 61 72 74 43 | 6f 6c 2c 65 6e 64 43 6f |w(startC|ol,endCo|
|000023c0| 6c 20 2b 20 31 2c 65 6e | 64 52 6f 77 20 2b 20 31 |l + 1,en|dRow + 1|
|000023d0| 29 0d 09 09 09 53 45 4c | 45 43 54 20 52 41 4e 47 |)....SEL|ECT RANG|
|000023e0| 45 20 4d 41 4b 45 52 41 | 4e 47 45 28 73 74 61 72 |E MAKERA|NGE(star|
|000023f0| 74 43 6f 6c 2c 20 65 6e | 64 52 6f 77 20 2b 20 31 |tCol, en|dRow + 1|
|00002400| 2c 20 65 6e 64 43 6f 6c | 20 2b 20 31 2c 20 65 6e |, endCol| + 1, en|
|00002410| 64 52 6f 77 20 2b 20 31 | 29 0d 09 09 09 43 41 4c |dRow + 1|)....CAL|
|00002420| 4c 20 61 6c 65 72 74 55 | 73 65 72 28 6d 73 67 35 |L alertU|ser(msg5|
|00002430| 29 0d 09 09 45 4e 44 20 | 49 46 0d 09 09 43 41 4c |)...END |IF...CAL|
|00002440| 4c 20 64 6f 43 6f 6c 73 | 28 29 0d 09 57 48 45 4e |L doCols|()..WHEN|
|00002450| 20 62 6f 74 74 6f 6d 52 | 6f 77 49 73 42 6c 61 6e | bottomR|owIsBlan|
|00002460| 6b 20 41 4e 44 20 72 69 | 67 68 74 43 6f 6c 75 6d |k AND ri|ghtColum|
|00002470| 6e 49 73 42 6c 61 6e 6b | 09 09 09 09 09 7b 54 6f |nIsBlank|.....{To|
|00002480| 74 61 6c 20 52 6f 77 20 | 61 6e 64 20 43 6f 6c 75 |tal Row |and Colu|
|00002490| 6d 6e 20 61 72 65 20 65 | 6d 70 74 79 7d 0d 09 09 |mn are e|mpty}...|
|000024a0| 49 46 20 4e 4f 54 20 6d | 79 49 53 42 4c 41 4e 4b |IF NOT m|yISBLANK|
|000024b0| 63 6f 6c 28 73 74 61 72 | 74 52 6f 77 2c 65 6e 64 |col(star|tRow,end|
|000024c0| 52 6f 77 20 2b 20 31 2c | 65 6e 64 43 6f 6c 20 2b |Row + 1,|endCol +|
|000024d0| 20 31 29 20 4f 52 20 4e | 4f 54 20 6d 79 49 53 42 | 1) OR N|OT myISB|
|000024e0| 4c 41 4e 4b 72 6f 77 28 | 73 74 61 72 74 43 6f 6c |LANKrow(|startCol|
|000024f0| 2c 65 6e 64 43 6f 6c 20 | 2b 20 31 2c 65 6e 64 52 |,endCol |+ 1,endR|
|00002500| 6f 77 20 2b 20 31 29 0d | 09 09 09 53 45 4c 45 43 |ow + 1).|...SELEC|
|00002510| 54 20 52 41 4e 47 45 20 | 4d 41 4b 45 52 41 4e 47 |T RANGE |MAKERANG|
|00002520| 45 28 73 74 61 72 74 43 | 6f 6c 2c 20 65 6e 64 52 |E(startC|ol, endR|
|00002530| 6f 77 20 2b 20 31 2c 20 | 65 6e 64 43 6f 6c 20 2b |ow + 1, |endCol +|
|00002540| 20 31 2c 20 65 6e 64 52 | 6f 77 20 2b 20 31 29 0d | 1, endR|ow + 1).|
|00002550| 09 09 09 53 45 4c 45 43 | 54 20 4d 4f 52 45 20 52 |...SELEC|T MORE R|
|00002560| 41 4e 47 45 20 4d 41 4b | 45 52 41 4e 47 45 28 65 |ANGE MAK|ERANGE(e|
|00002570| 6e 64 43 6f 6c 20 2b 20 | 31 2c 20 73 74 61 72 74 |ndCol + |1, start|
|00002580| 52 6f 77 2c 20 65 6e 64 | 43 6f 6c 20 2b 20 31 2c |Row, end|Col + 1,|
|00002590| 20 65 6e 64 52 6f 77 20 | 2b 20 31 29 0d 09 09 09 | endRow |+ 1)....|
|000025a0| 43 41 4c 4c 20 61 6c 65 | 72 74 55 73 65 72 28 6d |CALL ale|rtUser(m|
|000025b0| 73 67 33 29 0d 09 09 45 | 4e 44 20 49 46 0d 09 09 |sg3)...E|ND IF...|
|000025c0| 43 41 4c 4c 20 64 6f 52 | 6f 77 73 28 29 0d 09 09 |CALL doR|ows()...|
|000025d0| 43 41 4c 4c 20 64 6f 43 | 6f 6c 73 28 29 0d 09 09 |CALL doC|ols()...|
|000025e0| 50 55 54 20 22 3d 49 46 | 28 53 55 4d 28 22 20 26 |PUT "=IF|(SUM(" &|
|000025f0| 20 63 6f 6c 54 6f 74 61 | 6c 52 6e 67 20 26 20 22 | colTota|lRng & "|
|00002600| 29 3c 3e 53 55 4d 28 22 | 20 26 20 72 6f 77 54 6f |)<>SUM("| & rowTo|
|00002610| 74 61 6c 52 6e 67 20 26 | 20 22 29 2c 7b 50 75 74 |talRng &| "),{Put|
|00002620| 20 63 72 6f 73 73 66 6f | 6f 74 20 69 6e 20 6c 6f | crossfo|ot in lo|
|00002630| 77 65 72 20 72 69 67 68 | 74 20 63 65 6c 6c 7d 0d |wer righ|t cell}.|
|00002640| 09 09 09 45 52 52 28 29 | 2c 53 55 4d 28 22 20 26 |...ERR()|,SUM(" &|
|00002650| 20 63 6f 6c 54 6f 74 61 | 6c 52 6e 67 20 26 20 22 | colTota|lRng & "|
|00002660| 29 29 22 20 49 4e 54 4f | 20 4d 41 4b 45 43 45 4c |))" INTO| MAKECEL|
|00002670| 4c 28 65 6e 64 43 6f 6c | 20 2b 20 31 2c 65 6e 64 |L(endCol| + 1,end|
|00002680| 52 6f 77 20 2b 20 31 29 | 0d 09 09 53 45 4c 45 43 |Row + 1)|...SELEC|
|00002690| 54 20 52 41 4e 47 45 20 | 52 41 4e 47 45 28 4d 41 |T RANGE |RANGE(MA|
|000026a0| 4b 45 43 45 4c 4c 28 65 | 6e 64 43 6f 6c 20 2b 20 |KECELL(e|ndCol + |
|000026b0| 31 2c 65 6e 64 52 6f 77 | 29 29 09 09 09 7b 47 65 |1,endRow|))...{Ge|
|000026c0| 74 20 66 6f 72 6d 61 74 | 20 61 62 6f 76 65 20 63 |t format| above c|
|000026d0| 72 6f 73 73 66 6f 6f 74 | 20 66 6f 72 20 6c 61 74 |rossfoot| for lat|
|000026e0| 65 72 20 70 61 73 74 69 | 6e 67 7d 0d 09 09 43 4f |er pasti|ng}...CO|
|000026f0| 50 59 0d 09 09 63 66 52 | 61 6e 67 65 20 3d 20 4d |PY...cfR|ange = M|
|00002700| 41 4b 45 43 45 4c 4c 28 | 65 6e 64 43 6f 6c 20 2b |AKECELL(|endCol +|
|00002710| 20 31 2c 65 6e 64 52 6f | 77 20 2b 20 31 29 0d 09 | 1,endRo|w + 1)..|
|00002720| 45 4e 44 20 43 41 53 45 | 0d 09 49 46 20 63 66 52 |END CASE|..IF cfR|
|00002730| 61 6e 67 65 20 3c 3e 20 | 22 22 09 09 09 09 09 09 |ange <> |""......|
|00002740| 09 09 09 09 7b 49 66 20 | 63 66 52 61 6e 67 65 20 |....{If |cfRange |
|00002750| 65 78 69 73 74 73 2c 20 | 74 68 65 6e 20 63 6f 70 |exists, |then cop|
|00002760| 79 20 65 78 69 73 74 69 | 6e 67 20 66 6f 72 6d 61 |y existi|ng forma|
|00002770| 74 20 69 6e 74 6f 20 63 | 72 6f 73 73 66 6f 6f 74 |t into c|rossfoot|
|00002780| 20 63 65 6c 6c 7d 0d 09 | 09 53 45 4c 45 43 54 20 | cell}..|.SELECT |
|00002790| 52 41 4e 47 45 20 63 66 | 52 61 6e 67 65 0d 09 09 |RANGE cf|Range...|
|000027a0| 50 41 53 54 45 20 46 4f | 52 4d 41 54 0d 09 45 4e |PASTE FO|RMAT..EN|
|000027b0| 44 20 49 46 0d 09 49 4e | 56 41 4c 49 44 41 54 45 |D IF..IN|VALIDATE|
|000027c0| 20 4f 46 46 0d 09 52 45 | 50 41 49 4e 54 20 52 41 | OFF..RE|PAINT RA|
|000027d0| 4e 47 45 20 73 65 6c 52 | 61 6e 67 65 0d 09 52 45 |NGE selR|ange..RE|
|000027e0| 50 41 49 4e 54 20 53 45 | 4c 45 43 54 49 4f 4e 53 |PAINT SE|LECTIONS|
|000027f0| 20 4f 4e 0d 45 4e 44 20 | 46 55 4e 43 54 49 4f 4e | ON.END |FUNCTION|
|00002800| 0d 0d 7b 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |..{*****|********|
|00002810| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002820| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 64 6f 52 6f 77 |********|** doRow|
|00002830| 73 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |s ******|********|
|00002840| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002860| 2a 2a 2a 2a 0d 54 68 69 | 73 20 66 75 6e 63 74 69 |****.Thi|s functi|
|00002870| 6f 6e 20 68 61 6e 64 6c | 65 73 20 74 6f 74 61 6c |on handl|es total|
|00002880| 69 6e 67 20 72 6f 77 73 | 0d 2a 2a 2a 2a 2a 2a 2a |ing rows|.*******|
|00002890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000028a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000028b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000028c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000028d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000028e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 7d 0d 0d 46 55 |********|***}..FU|
|000028f0| 4e 43 54 49 4f 4e 20 64 | 6f 52 6f 77 73 28 29 0d |NCTION d|oRows().|
|00002900| 44 45 46 49 4e 45 20 72 | 6f 77 0d 09 46 4f 52 20 |DEFINE r|ow..FOR |
|00002910| 72 6f 77 20 3d 20 73 74 | 61 72 74 52 6f 77 20 54 |row = st|artRow T|
|00002920| 4f 20 65 6e 64 52 6f 77 | 0d 09 09 50 55 54 20 22 |O endRow|...PUT "|
|00002930| 3d 53 55 4d 28 22 20 26 | 20 4d 41 4b 45 52 41 4e |=SUM(" &| MAKERAN|
|00002940| 47 45 28 73 74 61 72 74 | 43 6f 6c 2c 20 72 6f 77 |GE(start|Col, row|
|00002950| 2c 20 65 6e 64 43 6f 6c | 2c 20 72 6f 77 29 20 26 |, endCol|, row) &|
|00002960| 20 22 29 22 20 49 4e 54 | 4f 20 4d 41 4b 45 43 45 | ")" INT|O MAKECE|
|00002970| 4c 4c 28 65 6e 64 43 6f | 6c 20 2b 20 31 2c 20 72 |LL(endCo|l + 1, r|
|00002980| 6f 77 29 0d 09 09 53 45 | 4c 45 43 54 20 52 41 4e |ow)...SE|LECT RAN|
|00002990| 47 45 20 52 41 4e 47 45 | 28 4d 41 4b 45 43 45 4c |GE RANGE|(MAKECEL|
|000029a0| 4c 28 65 6e 64 43 6f 6c | 2c 72 6f 77 29 29 0d 09 |L(endCol|,row))..|
|000029b0| 09 43 4f 50 59 0d 09 09 | 53 45 4c 45 43 54 20 52 |.COPY...|SELECT R|
|000029c0| 41 4e 47 45 20 52 41 4e | 47 45 28 4d 41 4b 45 43 |ANGE RAN|GE(MAKEC|
|000029d0| 45 4c 4c 28 65 6e 64 43 | 6f 6c 20 2b 20 31 2c 72 |ELL(endC|ol + 1,r|
|000029e0| 6f 77 29 29 0d 09 09 50 | 41 53 54 45 20 46 4f 52 |ow))...P|ASTE FOR|
|000029f0| 4d 41 54 0d 09 45 4e 44 | 20 46 4f 52 0d 09 72 6f |MAT..END| FOR..ro|
|00002a00| 77 54 6f 74 61 6c 52 6e | 67 20 3d 20 4d 41 4b 45 |wTotalRn|g = MAKE|
|00002a10| 52 41 4e 47 45 28 73 74 | 61 72 74 43 6f 6c 2c 20 |RANGE(st|artCol, |
|00002a20| 72 6f 77 2c 20 65 6e 64 | 43 6f 6c 2c 20 72 6f 77 |row, end|Col, row|
|00002a30| 29 0d 09 75 70 70 65 72 | 52 20 3d 20 52 41 4e 47 |)..upper|R = RANG|
|00002a40| 45 28 4d 41 4b 45 43 45 | 4c 4c 28 65 6e 64 43 6f |E(MAKECE|LL(endCo|
|00002a50| 6c 20 2b 20 31 2c 20 73 | 74 61 72 74 52 6f 77 20 |l + 1, s|tartRow |
|00002a60| 2d 20 31 29 29 09 09 09 | 7b 50 75 74 20 22 54 6f |- 1))...|{Put "To|
|00002a70| 74 61 6c 22 20 69 6e 74 | 6f 20 75 70 70 65 72 20 |tal" int|o upper |
|00002a80| 72 69 67 68 74 20 69 66 | 20 69 74 73 20 62 6c 61 |right if| its bla|
|00002a90| 6e 6b 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |nk}..SEL|ECT RANG|
|00002aa0| 45 28 4d 41 4b 45 43 45 | 4c 4c 28 65 6e 64 43 6f |E(MAKECE|LL(endCo|
|00002ab0| 6c 2c 73 74 61 72 74 52 | 6f 77 20 2d 20 31 29 29 |l,startR|ow - 1))|
|00002ac0| 09 09 09 09 09 7b 47 65 | 74 20 66 6f 72 6d 61 74 |.....{Ge|t format|
|00002ad0| 20 6f 66 20 63 65 6c 6c | 20 6e 65 78 74 20 74 6f | of cell| next to|
|00002ae0| 20 77 68 65 72 65 20 22 | 54 6f 74 61 6c 22 20 77 | where "|Total" w|
|00002af0| 69 6c 6c 20 67 6f 7d 0d | 09 43 4f 50 59 0d 09 49 |ill go}.|.COPY..I|
|00002b00| 46 20 49 53 42 4c 41 4e | 4b 28 75 70 70 65 72 52 |F ISBLAN|K(upperR|
|00002b10| 29 20 0d 09 09 50 55 54 | 20 22 54 6f 74 61 6c 22 |) ...PUT| "Total"|
|00002b20| 20 49 4e 54 4f 20 75 70 | 70 65 72 52 0d 09 09 53 | INTO up|perR...S|
|00002b30| 45 4c 45 43 54 20 52 41 | 4e 47 45 20 75 70 70 65 |ELECT RA|NGE uppe|
|00002b40| 72 52 09 09 09 09 09 09 | 09 09 09 7b 41 6c 69 67 |rR......|...{Alig|
|00002b50| 6e 20 22 54 6f 74 61 6c | 22 20 69 6e 20 75 70 70 |n "Total|" in upp|
|00002b60| 65 72 20 72 69 67 68 74 | 20 63 65 6c 6c 20 74 6f |er right| cell to|
|00002b70| 20 74 68 65 20 72 69 67 | 68 74 7d 0d 09 09 41 4c | the rig|ht}...AL|
|00002b80| 49 47 4e 20 52 49 47 48 | 54 0d 09 09 50 41 53 54 |IGN RIGH|T...PAST|
|00002b90| 45 20 46 4f 52 4d 41 54 | 0d 09 45 4e 44 20 49 46 |E FORMAT|..END IF|
|00002ba0| 0d 45 4e 44 20 46 55 4e | 43 54 49 4f 4e 0d 0d 7b |.END FUN|CTION..{|
|00002bb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002bc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002bd0| 2a 2a 2a 2a 2a 2a 2a 20 | 64 6f 43 6f 6c 73 20 2a |******* |doCols *|
|00002be0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002bf0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c10| 2a 0d 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |*.This f|unction |
|00002c20| 68 61 6e 64 6c 65 73 20 | 74 6f 74 61 6c 69 6e 67 |handles |totaling|
|00002c30| 20 63 6f 6c 75 6d 6e 73 | 0d 2a 2a 2a 2a 2a 2a 2a | columns|.*******|
|00002c40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 7d 0d 0d 46 55 |********|***}..FU|
|00002ca0| 4e 43 54 49 4f 4e 20 64 | 6f 43 6f 6c 73 28 29 0d |NCTION d|oCols().|
|00002cb0| 44 45 46 49 4e 45 20 63 | 6f 6c 0d 09 46 4f 52 20 |DEFINE c|ol..FOR |
|00002cc0| 63 6f 6c 20 3d 20 73 74 | 61 72 74 43 6f 6c 20 54 |col = st|artCol T|
|00002cd0| 4f 20 65 6e 64 43 6f 6c | 0d 09 09 50 55 54 20 22 |O endCol|...PUT "|
|00002ce0| 3d 53 55 4d 28 22 20 26 | 20 4d 41 4b 45 52 41 4e |=SUM(" &| MAKERAN|
|00002cf0| 47 45 28 63 6f 6c 2c 20 | 73 74 61 72 74 52 6f 77 |GE(col, |startRow|
|00002d00| 2c 20 63 6f 6c 2c 20 65 | 6e 64 52 6f 77 29 20 26 |, col, e|ndRow) &|
|00002d10| 20 22 29 22 20 49 4e 54 | 4f 20 4d 41 4b 45 43 45 | ")" INT|O MAKECE|
|00002d20| 4c 4c 28 63 6f 6c 2c 20 | 65 6e 64 52 6f 77 20 2b |LL(col, |endRow +|
|00002d30| 31 29 0d 09 09 53 45 4c | 45 43 54 20 52 41 4e 47 |1)...SEL|ECT RANG|
|00002d40| 45 20 52 41 4e 47 45 28 | 4d 41 4b 45 43 45 4c 4c |E RANGE(|MAKECELL|
|00002d50| 28 63 6f 6c 2c 20 65 6e | 64 52 6f 77 29 29 0d 09 |(col, en|dRow))..|
|00002d60| 09 43 4f 50 59 0d 09 09 | 53 45 4c 45 43 54 20 52 |.COPY...|SELECT R|
|00002d70| 41 4e 47 45 20 52 41 4e | 47 45 28 4d 41 4b 45 43 |ANGE RAN|GE(MAKEC|
|00002d80| 45 4c 4c 28 63 6f 6c 2c | 20 65 6e 64 52 6f 77 20 |ELL(col,| endRow |
|00002d90| 2b 31 29 29 0d 09 09 50 | 41 53 54 45 20 46 4f 52 |+1))...P|ASTE FOR|
|00002da0| 4d 41 54 0d 09 45 4e 44 | 20 46 4f 52 0d 09 63 6f |MAT..END| FOR..co|
|00002db0| 6c 54 6f 74 61 6c 52 6e | 67 20 3d 20 4d 41 4b 45 |lTotalRn|g = MAKE|
|00002dc0| 52 41 4e 47 45 28 63 6f | 6c 2c 20 73 74 61 72 74 |RANGE(co|l, start|
|00002dd0| 52 6f 77 2c 20 63 6f 6c | 2c 20 65 6e 64 52 6f 77 |Row, col|, endRow|
|00002de0| 29 0d 09 6c 6f 77 65 72 | 4c 20 3d 20 52 41 4e 47 |)..lower|L = RANG|
|00002df0| 45 28 4d 41 4b 45 43 45 | 4c 4c 28 73 74 61 72 74 |E(MAKECE|LL(start|
|00002e00| 43 6f 6c 20 2d 20 31 2c | 20 65 6e 64 52 6f 77 20 |Col - 1,| endRow |
|00002e10| 2b 20 31 29 29 09 09 09 | 7b 50 75 74 20 22 54 6f |+ 1))...|{Put "To|
|00002e20| 74 61 6c 22 20 69 6e 74 | 6f 20 6c 6f 77 65 72 20 |tal" int|o lower |
|00002e30| 6c 65 66 74 20 69 66 20 | 69 74 73 20 62 6c 61 6e |left if |its blan|
|00002e40| 6b 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 |k}..SELE|CT RANGE|
|00002e50| 28 4d 41 4b 45 43 45 4c | 4c 28 73 74 61 72 74 43 |(MAKECEL|L(startC|
|00002e60| 6f 6c 20 2d 20 31 2c 65 | 6e 64 52 6f 77 29 29 09 |ol - 1,e|ndRow)).|
|00002e70| 09 09 09 09 7b 47 65 74 | 20 66 6f 72 6d 61 74 20 |....{Get| format |
|00002e80| 6f 66 20 63 65 6c 6c 20 | 6e 65 78 74 20 74 6f 20 |of cell |next to |
|00002e90| 77 68 65 72 65 20 22 54 | 6f 74 61 6c 22 20 77 69 |where "T|otal" wi|
|00002ea0| 6c 6c 20 67 6f 7d 0d 09 | 43 4f 50 59 0d 09 49 46 |ll go}..|COPY..IF|
|00002eb0| 20 49 53 42 4c 41 4e 4b | 28 6c 6f 77 65 72 4c 29 | ISBLANK|(lowerL)|
|00002ec0| 20 0d 09 09 50 55 54 20 | 22 54 6f 74 61 6c 22 20 | ...PUT |"Total" |
|00002ed0| 49 4e 54 4f 20 6c 6f 77 | 65 72 4c 0d 09 09 53 45 |INTO low|erL...SE|
|00002ee0| 4c 45 43 54 20 52 41 4e | 47 45 20 6c 6f 77 65 72 |LECT RAN|GE lower|
|00002ef0| 4c 0d 09 09 50 41 53 54 | 45 20 46 4f 52 4d 41 54 |L...PAST|E FORMAT|
|00002f00| 0d 09 45 4e 44 20 49 46 | 0d 45 4e 44 20 46 55 4e |..END IF|.END FUN|
|00002f10| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|00002f20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00002f40| 61 6c 65 72 74 55 73 65 | 72 20 2a 2a 2a 2a 2a 2a |alertUse|r ******|
|00002f50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 54 68 69 73 20 66 |********|*.This f|
|00002f80| 75 6e 63 74 69 6f 6e 20 | 70 75 74 73 20 75 70 20 |unction |puts up |
|00002f90| 65 72 72 6f 72 20 6d 65 | 73 73 61 67 65 73 20 61 |error me|ssages a|
|00002fa0| 6e 64 20 74 68 65 6e 20 | 65 78 69 74 73 20 74 68 |nd then |exits th|
|00002fb0| 65 20 73 63 72 69 70 74 | 2e 0d 2a 2a 2a 2a 2a 2a |e script|..******|
|00002fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002fd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ff0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003000| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003010| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|00003020| 55 4e 43 54 49 4f 4e 20 | 61 6c 65 72 74 55 73 65 |UNCTION |alertUse|
|00003030| 72 28 6d 73 67 29 0d 09 | 4d 45 53 53 41 47 45 20 |r(msg)..|MESSAGE |
|00003040| 6d 73 67 0d 09 52 45 50 | 41 49 4e 54 20 53 45 4c |msg..REP|AINT SEL|
|00003050| 45 43 54 49 4f 4e 53 20 | 4f 4e 0d 09 49 4e 56 41 |ECTIONS |ON..INVA|
|00003060| 4c 49 44 41 54 45 20 4f | 46 46 0d 09 52 45 50 41 |LIDATE O|FF..REPA|
|00003070| 49 4e 54 20 57 49 4e 44 | 4f 57 0d 09 45 58 49 54 |INT WIND|OW..EXIT|
|00003080| 20 53 43 52 49 50 54 0d | 45 4e 44 20 46 55 4e 43 | SCRIPT.|END FUNC|
|00003090| 54 49 4f 4e 0d 0d 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |TION..{*|********|
|000030a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000030b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 6d |********|****** m|
|000030c0| 79 49 53 42 4c 41 4e 4b | 72 6f 77 20 2a 2a 2a 2a |yISBLANK|row ****|
|000030d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000030e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000030f0| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 54 68 69 73 20 66 75 |********|.This fu|
|00003100| 6e 63 74 69 6f 6e 20 69 | 73 20 61 20 6d 6f 64 69 |nction i|s a modi|
|00003110| 66 69 63 61 74 69 6f 6e | 20 6f 66 20 49 53 42 4c |fication| of ISBL|
|00003120| 41 4e 4b 2c 20 61 6c 6c | 6f 77 69 6e 67 20 66 6f |ANK, all|owing fo|
|00003130| 72 20 74 68 65 20 70 61 | 72 61 6d 65 74 65 72 73 |r the pa|rameters|
|00003140| 20 6f 66 20 66 69 72 73 | 74 20 61 6e 64 20 6c 61 | of firs|t and la|
|00003150| 73 74 20 63 6f 6c 75 6d | 6e 20 61 6e 64 0d 72 6f |st colum|n and.ro|
|00003160| 77 20 6e 75 6d 62 65 72 | 2e 0d 2a 2a 2a 2a 2a 2a |w number|..******|
|00003170| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003180| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003190| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000031a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000031b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000031c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|000031d0| 55 4e 43 54 49 4f 4e 20 | 6d 79 49 53 42 4c 41 4e |UNCTION |myISBLAN|
|000031e0| 4b 72 6f 77 28 66 69 72 | 73 74 43 6f 6c 2c 6c 61 |Krow(fir|stCol,la|
|000031f0| 73 74 43 6f 6c 2c 74 68 | 65 52 6f 77 29 0d 09 44 |stCol,th|eRow)..D|
|00003200| 45 46 49 4e 45 20 69 2c | 20 69 74 73 42 6c 61 6e |EFINE i,| itsBlan|
|00003210| 6b 0d 09 69 74 73 42 6c | 61 6e 6b 20 3d 20 54 52 |k..itsBl|ank = TR|
|00003220| 55 45 28 29 0d 09 46 4f | 52 20 69 20 3d 20 66 69 |UE()..FO|R i = fi|
|00003230| 72 73 74 43 6f 6c 20 54 | 4f 20 6c 61 73 74 43 6f |rstCol T|O lastCo|
|00003240| 6c 0d 09 09 49 46 20 4e | 4f 54 20 49 53 42 4c 41 |l...IF N|OT ISBLA|
|00003250| 4e 4b 28 52 41 4e 47 45 | 28 4d 41 4b 45 43 45 4c |NK(RANGE|(MAKECEL|
|00003260| 4c 28 69 2c 74 68 65 52 | 6f 77 29 29 29 0d 09 09 |L(i,theR|ow)))...|
|00003270| 09 69 74 73 42 6c 61 6e | 6b 20 3d 20 46 41 4c 53 |.itsBlan|k = FALS|
|00003280| 45 28 29 0d 09 09 09 52 | 45 54 55 52 4e 20 69 74 |E()....R|ETURN it|
|00003290| 73 42 6c 61 6e 6b 0d 09 | 09 45 4e 44 20 49 46 0d |sBlank..|.END IF.|
|000032a0| 09 45 4e 44 20 46 4f 52 | 0d 09 52 45 54 55 52 4e |.END FOR|..RETURN|
|000032b0| 20 69 74 73 42 6c 61 6e | 6b 0d 45 4e 44 20 46 55 | itsBlan|k.END FU|
|000032c0| 4e 43 54 49 4f 4e 0d 0d | 7b 2a 2a 2a 2a 2a 2a 2a |NCTION..|{*******|
|000032d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032f0| 20 6d 79 49 53 42 4c 41 | 4e 4b 63 6f 6c 20 2a 2a | myISBLA|NKcol **|
|00003300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003310| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 0d 54 68 69 73 20 |********|**.This |
|00003330| 66 75 6e 63 74 69 6f 6e | 20 69 73 20 61 20 6d 6f |function| is a mo|
|00003340| 64 69 66 69 63 61 74 69 | 6f 6e 20 6f 66 20 49 53 |dificati|on of IS|
|00003350| 42 4c 41 4e 4b 2c 20 61 | 6c 6c 6f 77 69 6e 67 20 |BLANK, a|llowing |
|00003360| 66 6f 72 20 74 68 65 20 | 70 61 72 61 6d 65 74 65 |for the |paramete|
|00003370| 72 73 20 6f 66 20 66 69 | 72 73 74 20 61 6e 64 20 |rs of fi|rst and |
|00003380| 6c 61 73 74 20 72 6f 77 | 20 61 6e 64 0d 63 6f 6c |last row| and.col|
|00003390| 75 6d 6e 20 6e 75 6d 62 | 65 72 2e 0d 2a 2a 2a 2a |umn numb|er..****|
|000033a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000033b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000033c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000033d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000033e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000033f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|00003400| 0d 46 55 4e 43 54 49 4f | 4e 20 6d 79 49 53 42 4c |.FUNCTIO|N myISBL|
|00003410| 41 4e 4b 63 6f 6c 28 66 | 69 72 73 74 52 6f 77 2c |ANKcol(f|irstRow,|
|00003420| 6c 61 73 74 52 6f 77 2c | 74 68 65 43 6f 6c 29 0d |lastRow,|theCol).|
|00003430| 09 44 45 46 49 4e 45 20 | 69 2c 20 69 74 73 42 6c |.DEFINE |i, itsBl|
|00003440| 61 6e 6b 0d 09 69 74 73 | 42 6c 61 6e 6b 20 3d 20 |ank..its|Blank = |
|00003450| 54 52 55 45 28 29 0d 09 | 46 4f 52 20 69 20 3d 20 |TRUE()..|FOR i = |
|00003460| 66 69 72 73 74 52 6f 77 | 20 54 4f 20 6c 61 73 74 |firstRow| TO last|
|00003470| 52 6f 77 0d 09 09 49 46 | 20 4e 4f 54 20 49 53 42 |Row...IF| NOT ISB|
|00003480| 4c 41 4e 4b 28 52 41 4e | 47 45 28 4d 41 4b 45 43 |LANK(RAN|GE(MAKEC|
|00003490| 45 4c 4c 28 74 68 65 43 | 6f 6c 2c 69 29 29 29 0d |ELL(theC|ol,i))).|
|000034a0| 09 09 09 69 74 73 42 6c | 61 6e 6b 20 3d 20 46 41 |...itsBl|ank = FA|
|000034b0| 4c 53 45 28 29 0d 09 09 | 09 52 45 54 55 52 4e 20 |LSE()...|.RETURN |
|000034c0| 69 74 73 42 6c 61 6e 6b | 0d 09 09 45 4e 44 20 49 |itsBlank|...END I|
|000034d0| 46 0d 09 45 4e 44 20 46 | 4f 52 0d 09 52 45 54 55 |F..END F|OR..RETU|
|000034e0| 52 4e 20 69 74 73 42 6c | 61 6e 6b 0d 45 4e 44 20 |RN itsBl|ank.END |
|000034f0| 46 55 4e 43 54 49 4f 4e | 0d 0d 7b 2a 2a 2a 2a 2a |FUNCTION|..{*****|
|00003500| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003510| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003520| 2a 2a 20 45 72 72 6f 72 | 20 48 61 6e 64 6c 65 72 |** Error| Handler|
|00003530| 20 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a | *******|********|
|00003540| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003550| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 54 68 69 |********|****.Thi|
|00003560| 73 20 68 61 6e 64 6c 65 | 72 20 74 72 61 70 73 20 |s handle|r traps |
|00003570| 65 72 72 6f 72 73 20 73 | 6f 20 77 65 20 63 61 6e |errors s|o we can|
|00003580| 20 63 68 65 63 6b 20 66 | 6f 72 20 73 63 72 69 70 | check f|or scrip|
|00003590| 74 73 20 62 65 69 6e 67 | 20 72 75 6e 20 66 72 6f |ts being| run fro|
|000035a0| 6d 20 52 75 6e 20 53 63 | 72 69 70 74 0d 2a 2a 2a |m Run Sc|ript.***|
|000035b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000035c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000035d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000035e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000035f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003600| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 7d |********|*******}|
|00003610| 0d 4f 4e 20 45 52 52 4f | 52 0d 45 4e 44 20 45 52 |.ON ERRO|R.END ER|
|00003620| 52 4f 52 0d 00 00 00 00 | 00 00 00 00 00 00 00 00 |ROR.....|........|
|00003630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003680| 00 00 01 00 00 00 01 14 | 00 00 00 14 00 00 00 32 |........|.......2|
|00003690| 0d 52 45 50 41 49 4e 54 | 20 53 45 4c 45 43 54 49 |.REPAINT| SELECTI|
|000036a0| 4f 4e 53 20 4f 4e 0d 52 | 45 50 41 49 4e 54 20 4f |ONS ON.R|EPAINT O|
|000036b0| 05 54 6f 74 61 6c 02 00 | 00 00 52 73 53 63 52 73 |.Total..|..RsScRs|
|000036c0| 6c 76 01 00 00 68 00 80 | 00 00 00 00 09 1c 00 00 |lv...h..|........|
|000036d0| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 68 00 80 |..RsScRs|lv...h..|
|000036e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036f0| 00 00 a4 b0 59 9c 00 00 | 35 a5 00 00 01 46 68 69 |....Y...|5....Fhi|
|00003700| 63 61 67 6f 00 00 00 00 | 00 00 00 03 01 00 53 00 |cago....|......S.|
|00003710| 10 00 8a 00 38 04 a0 05 | 38 04 a0 05 2c 01 2c 01 |....8...|8...,.,.|
|00003720| 78 00 04 00 00 00 00 03 | 00 00 01 2c 01 2c 00 00 |x.......|...,.,..|
|00003730| 00 00 0b e0 08 fc ff 7e | ff 83 0c 62 09 79 03 67 |.......~|...b.y.g|
|00003740| 05 28 03 fc 00 02 00 00 | 01 2c 01 2c 00 00 00 00 |.(......|.,.,....|
|00003750| 0b e0 08 fc 00 01 00 00 | 00 64 00 00 00 01 00 01 |........|.d......|
|00003760| 01 01 00 00 00 01 27 0f | 00 01 00 01 00 00 00 00 |......'.|........|
|00003770| 00 00 00 00 00 00 00 00 | 00 02 00 19 01 90 00 00 |........|........|
|00003780| 00 00 00 10 0f 43 6c 61 | 72 69 73 20 52 65 73 6f |.....Cla|ris Reso|
|00003790| 6c 76 65 aa 00 00 01 00 | 00 00 01 14 00 00 00 14 |lve.....|........|
|000037a0| 00 00 00 32 00 e5 75 98 | 04 0c 00 00 00 1c 00 32 |...2..u.|.......2|
|000037b0| 00 00 53 54 52 20 00 00 | 00 0a bf f4 ff ff 00 00 |..STR ..|........|
|000037c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+