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

next >

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 05 41 75 64 69 74 00 | 00 00 00 00 00 00 00 00 |..Audit.|........|
|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 10 00 | 00 04 26 a4 b0 59 9c a4 |.....5..|..&..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 2f f9 00 00 |........|..../...|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 00 27 00 00 |BAT_BTSC|0101.'..|
|00000090| b8 0d 00 00 bb 0c 00 00 | c3 0c 00 00 d7 0c 00 00 |........|........|
|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 | 16 0c 00 00 0a 00 07 00 |........|........|
|000000d0| 11 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 19 06 41 75 |........|......Au|
|00000100| 64 69 74 c9 f4 00 00 19 | 2e 50 6c 65 61 73 65 20 |dit.....|.Please |
|00000110| 6f 70 65 6e 20 61 20 77 | 6f 72 6b 73 68 65 65 74 |open a w|orksheet|
|00000120| 20 6f 72 20 62 72 69 6e | 67 20 6f 6e 65 20 74 6f | or brin|g one to|
|00000130| 20 66 72 6f 6e 74 2e f4 | 00 09 fb f6 00 00 fd 09 | front..|........|
|00000140| 1c 06 01 05 1a 01 01 ff | 1b 00 00 00 f9 f8 fd 8f |........|........|
|00000150| 1c 08 01 05 1a 00 00 ff | 02 01 00 80 47 45 54 20 |........|....GET |
|00000160| 53 43 52 49 50 54 20 22 | 41 75 64 69 74 22 0d 09 |SCRIPT "|Audit"..|
|00000170| 09 09 09 09 09 20 20 20 | 20 43 41 4c 4c 20 41 75 |.....   | CALL Au|
|00000180| 64 69 74 3a 73 65 74 55 | 70 4c 6f 63 61 6c 69 7a |dit:setU|pLocaliz|
|00000190| 65 64 53 74 72 69 6e 67 | 73 28 29 20 0d 09 09 09 |edString|s() ....|
|000001a0| 09 09 09 20 20 20 20 43 | 41 4c 4c 20 41 75 64 69 |...    C|ALL Audi|
|000001b0| 74 3a 61 75 64 69 74 49 | 74 28 29 20 0d 09 09 09 |t:auditI|t() ....|
|000001c0| 09 09 09 20 20 20 20 52 | 45 4d 4f 56 45 20 53 43 |...    R|EMOVE SC|
|000001d0| 52 49 50 54 20 22 41 75 | 64 69 74 22 00 00 fb f6 |RIPT "Au|dit"....|
|000001e0| 00 08 18 00 00 00 00 00 | 00 f0 3f f4 03 01 18 00 |........|..?.....|
|000001f0| 00 00 00 00 00 00 40 f4 | 03 02 18 00 00 00 00 00 |......@.|........|
|00000200| 00 10 40 f4 03 03 18 00 | 00 00 00 00 00 18 40 f4 |..@.....|......@.|
|00000210| 03 04 18 00 00 00 00 00 | 00 1c 40 f4 03 05 18 00 |........|..@.....|
|00000220| 00 00 00 00 00 20 40 f4 | 03 06 18 00 00 00 00 00 |..... @.|........|
|00000230| 00 2a 40 f4 03 07 18 00 | 00 00 00 00 00 08 40 f4 |.*@.....|......@.|
|00000240| 03 08 fe c7 4f f2 0c 00 | fd 08 23 01 05 1a 00 09 |....O...|..#.....|
|00000250| ff fc fd 04 1b 06 00 fd | 04 1b 05 01 fd 07 1d 00 |........|........|
|00000260| 03 02 20 4e fd 0b 1d 0b | 01 01 05 1a 03 01 ff 00 |.. N....|........|
|00000270| fd d3 21 03 00 01 ce 19 | 26 4f 4e 20 4d 4f 55 53 |..!.....|&ON MOUS|
|00000280| 45 55 50 20 09 41 75 64 | 69 74 3a 61 75 64 69 74 |EUP .Aud|it:audit|
|00000290| 54 79 70 65 20 3d 20 43 | 54 56 41 4c 55 45 28 1a |Type = C|TVALUE(.|
|000002a0| 03 03 af 35 19 27 2c 30 | 29 20 0d 09 09 09 09 09 |...5.',0|) ......|
|000002b0| 41 75 64 69 74 3a 63 69 | 72 63 6c 65 43 6f 6c 6f |Audit:ci|rcleColo|
|000002c0| 72 20 3d 20 20 43 54 56 | 41 4c 55 45 28 35 1a 03 |r =  CTV|ALUE(5..|
|000002d0| 04 af 35 19 25 2c 30 29 | 20 0d 09 09 09 09 09 41 |..5.%,0)| ......A|
|000002e0| 75 64 69 74 3a 63 69 72 | 63 6c 65 4c 69 6e 65 20 |udit:cir|cleLine |
|000002f0| 3d 20 43 54 56 41 4c 55 | 45 28 35 1a 03 05 af 35 |= CTVALU|E(5....5|
|00000300| 19 40 2c 30 29 0d 09 09 | 09 09 09 51 55 49 54 20 |.@,0)...|...QUIT |
|00000310| 44 49 41 4c 4f 47 20 42 | 4f 58 0d 09 09 09 09 09 |DIALOG B|OX......|
|00000320| 43 41 4c 4c 20 41 75 64 | 69 74 3a 64 6f 49 74 28 |CALL Aud|it:doIt(|
|00000330| 29 0d 09 09 09 09 09 45 | 4e 44 20 4d 4f 55 53 45 |)......E|ND MOUSE|
|00000340| 55 50 35 ff fd 0b 1d 0b | 01 01 05 1a 03 02 ff 00 |UP5.....|........|
|00000350| fd 03 1d 09 fd 0b 1d 0b | 01 01 05 1a 03 03 ff 00 |........|........|
|00000360| fd 06 0f 02 00 1c 00 fd | 04 1e 1e 81 fd 3e 21 03 |........|.....>!.|
|00000370| 00 00 38 4f 4e 20 4d 4f | 55 53 45 55 50 20 43 41 |..8ON MO|USEUP CA|
|00000380| 4c 4c 20 41 75 64 69 74 | 3a 73 65 74 43 6f 6c 6f |LL Audit|:setColo|
|00000390| 72 28 43 54 56 41 4c 55 | 45 28 34 2c 30 29 29 20 |r(CTVALU|E(4,0)) |
|000003a0| 45 4e 44 20 4d 4f 55 53 | 45 55 50 fd 0b 1d 0b 01 |END MOUS|EUP.....|
|000003b0| 01 05 1a 03 04 ff 00 fd | 53 21 03 00 01 4e 19 1a |........|S!...N..|
|000003c0| 4f 4e 20 4d 4f 55 53 45 | 55 50 20 53 45 4c 45 43 |ON MOUSE|UP SELEC|
|000003d0| 54 20 43 4f 4e 54 52 4f | 4c 20 1a 03 06 af 35 19 |T CONTRO|L ....5.|
|000003e0| 11 20 46 49 4c 4c 20 46 | 47 20 43 54 56 41 4c 55 |. FILL F|G CTVALU|
|000003f0| 45 28 35 1a 03 04 af 35 | 19 0f 2c 30 29 20 45 4e |E(5....5|..,0) EN|
|00000400| 44 20 4d 4f 55 53 45 55 | 50 35 ff fd 06 1e 5a 02 |D MOUSEU|P5....Z.|
|00000410| dd 00 fd 0b 1d 0b 01 01 | 05 1a 03 06 ff 00 fd 14 |........|........|
|00000420| 0f 00 00 01 0f 1a 03 04 | 18 00 00 00 00 00 00 00 |........|........|
|00000430| 00 e5 ff fd 0b 1d 0b 01 | 01 05 1a 03 05 ff 00 fd |........|........|
|00000440| 04 1e 60 85 fd 04 08 01 | 07 fd 0b 09 01 04 01 00 |..`.....|........|
|00000450| 02 65 63 00 00 fd 0b 09 | 00 04 01 00 02 72 62 00 |.ec.....|.....rb.|
|00000460| 00 fd 0b 09 00 04 01 00 | 02 6c 63 00 00 fd 0b 09 |........|.lc.....|
|00000470| 00 04 01 00 02 75 72 00 | 00 fd 0b 09 00 04 01 00 |.....ur.|........|
|00000480| 02 63 72 00 00 fe 17 18 | 00 00 00 00 00 00 00 00 |.cr.....|........|
|00000490| 39 f2 12 00 fd 0b 1d 0b | 01 01 05 1a 03 07 ff 00 |9.......|........|
|000004a0| fd 03 1e 7a fd 0b 1d 0b | 01 01 05 1a 03 07 ff 00 |...z....|........|
|000004b0| fd 3d 21 03 00 00 37 4f | 4e 20 4d 4f 55 53 45 55 |.=!...7O|N MOUSEU|
|000004c0| 50 0d 09 09 09 09 51 55 | 49 54 20 44 49 41 4c 4f |P.....QU|IT DIALO|
|000004d0| 47 20 42 4f 58 0d 09 09 | 09 09 43 4c 45 41 52 0d |G BOX...|..CLEAR.|
|000004e0| 09 09 09 45 4e 44 20 4d | 4f 55 53 45 55 50 fd 03 |...END M|OUSEUP..|
|000004f0| 1d 03 fd 04 1b 06 01 fd | 04 1b 05 00 fb f6 01 01 |........|........|
|00000500| 1a 03 01 f7 18 00 00 00 | 00 00 00 f0 3f 39 f2 0a |........|....?9..|
|00000510| 00 f8 da f4 03 02 1d 5b | 00 f7 18 00 00 00 00 00 |.......[|........|
|00000520| 00 00 40 39 f2 0a 00 f8 | db f4 03 02 1d 45 00 f7 |..@9....|.....E..|
|00000530| 18 00 00 00 00 00 00 08 | 40 39 f2 0a 00 f8 dc f4 |........|@9......|
|00000540| 03 02 1d 2f 00 f7 18 00 | 00 00 00 00 00 10 40 39 |.../....|......@9|
|00000550| f2 0a 00 f8 de f4 03 02 | 1d 19 00 f7 18 00 00 00 |........|........|
|00000560| 00 00 00 14 40 39 f2 0a | 00 f8 dd f4 03 02 1d 03 |....@9..|........|
|00000570| 00 f8 fd 06 1d 0b 01 86 | 00 fd 09 1e 5a 01 05 1a |........|....Z...|
|00000580| 03 02 ff fd 08 1d 0b 01 | 02 08 00 00 fd 1a 0f 00 |........|........|
|00000590| 00 01 15 18 00 00 00 00 | 00 00 18 40 18 00 00 00 |........|...@....|
|000005a0| 00 00 00 00 00 e5 ff fb | f6 00 07 1a 00 04 f7 18 |........|........|
|000005b0| 00 00 00 00 00 00 f0 3f | 39 f2 34 00 f8 19 02 65 |.......?|9.4....e|
|000005c0| 63 19 12 53 45 4c 45 43 | 54 20 45 52 52 4f 52 20 |c..SELEC|T ERROR |
|000005d0| 43 45 4c 4c 53 1b 02 00 | 05 f9 f8 19 0b 45 72 72 |CELLS...|.....Err|
|000005e0| 6f 72 20 43 65 6c 6c 73 | f4 03 06 1d 76 03 f7 18 |or Cells|....v...|
|000005f0| 00 00 00 00 00 00 00 40 | 39 f2 4b 00 f8 19 02 72 |.......@|9.K....r|
|00000600| 62 19 1b 53 45 4c 45 43 | 54 20 52 45 46 45 52 45 |b..SELEC|T REFERE|
|00000610| 4e 43 45 53 20 54 4f 20 | 42 4c 41 4e 4b 53 1b 02 |NCES TO |BLANKS..|
|00000620| 00 05 f9 f8 19 19 52 65 | 66 65 72 65 6e 63 65 73 |......Re|ferences|
|00000630| 20 54 6f 20 42 6c 61 6e | 6b 20 43 65 6c 6c 73 f4 | To Blan|k Cells.|
|00000640| 03 06 1d 1f 03 f7 18 00 | 00 00 00 00 00 08 40 39 |........|......@9|
|00000650| f2 36 00 f8 19 02 6c 63 | 19 13 53 45 4c 45 43 54 |.6....lc|..SELECT|
|00000660| 20 4c 4f 43 4b 45 44 20 | 43 45 4c 4c 53 1b 02 00 | LOCKED |CELLS...|
|00000670| 05 f9 f8 19 0c 4c 6f 63 | 6b 65 64 20 43 65 6c 6c |.....Loc|ked Cell|
|00000680| 73 f4 03 06 1d dd 02 f7 | 18 00 00 00 00 00 00 10 |s.......|........|
|00000690| 40 39 f2 42 00 f8 19 02 | 75 72 19 19 53 45 4c 45 |@9.B....|ur..SELE|
|000006a0| 43 54 20 55 4e 52 45 46 | 45 52 45 4e 43 45 44 20 |CT UNREF|ERENCED |
|000006b0| 43 45 4c 4c 53 1b 02 00 | 05 f9 f8 19 12 55 6e 72 |CELLS...|.....Unr|
|000006c0| 65 66 65 72 65 6e 63 65 | 64 20 43 65 6c 6c 73 f4 |eference|d Cells.|
|000006d0| 03 06 1d 8f 02 f8 19 13 | 43 69 72 63 75 6c 61 72 |........|Circular|
|000006e0| 20 52 65 66 65 72 65 6e | 63 65 73 f4 03 06 19 02 | Referen|ces.....|
|000006f0| 41 31 f4 00 07 fe b6 f4 | 03 01 18 00 00 00 00 00 |A1......|........|
|00000700| 00 00 00 f4 00 08 fd 04 | 10 02 01 1a 00 07 19 00 |........|........|
|00000710| 3e f2 0a 01 19 00 f4 00 | 07 fd 04 10 03 00 fd 04 |>.......|........|
|00000720| 10 03 02 fd 04 10 03 01 | 1a 00 07 19 00 3e f2 ea |........|.....>..|
|00000730| 00 1a 00 08 2a 00 00 00 | 00 00 00 f0 3f f4 00 08 |....*...|....?...|
|00000740| fd 0b 1e 01 01 01 06 1a | 00 07 d3 ff fd 17 15 02 |........|........|
|00000750| 01 13 19 0a 43 65 6c 6c | 20 4e 6f 74 65 20 1a 00 |....Cell| Note ..|
|00000760| 08 af 35 ff fd 09 1e 65 | 01 05 1a 00 07 ff fd 18 |..5....e|........|
|00000770| 09 01 05 01 13 19 0a 43 | 65 6c 6c 20 4e 6f 74 65 |.......C|ell Note|
|00000780| 20 1a 00 08 af 35 ff fd | 06 1e 16 00 80 80 fd 04 | ....5..|........|
|00000790| 15 08 01 fd 0d 08 01 01 | 01 01 06 1a 00 07 d3 ff |........|........|
|000007a0| 00 1a 00 07 d3 fe 94 f4 | 03 03 fd 18 09 01 05 01 |........|........|
|000007b0| 13 19 0a 43 65 6c 6c 20 | 4e 6f 74 65 20 1a 00 08 |...Cell |Note ...|
|000007c0| af 35 ff fd 05 1e 16 02 | 80 fd 14 1a 08 01 10 1a |.5......|........|
|000007d0| 03 03 18 00 00 00 00 00 | 00 2a 40 ab 35 ff fd 0d |........|.*@.5...|
|000007e0| 08 01 01 01 01 06 1a 00 | 07 d3 ff 00 fd 12 17 01 |........|........|
|000007f0| 09 19 01 22 1a 03 03 35 | ff 01 05 ce cf d4 ff 18 |..."...5|........|
|00000800| 00 00 00 00 00 00 f0 3f | fe 19 19 02 63 72 1a 00 |.......?|....cr..|
|00000810| 08 af 35 1b 02 00 06 f9 | f8 1d f1 fe 1a 03 01 f7 |..5.....|........|
|00000820| 18 00 00 00 00 00 00 00 | 00 39 f2 0b 00 f8 fd 04 |........|.9......|
|00000830| 10 03 00 1d 1f 00 f7 18 | 00 00 00 00 00 00 f0 3f |........|.......?|
|00000840| 39 f2 0b 00 f8 fd 04 10 | 03 01 1d 08 00 f8 fd 04 |9.......|........|
|00000850| 10 03 02 18 00 00 00 00 | 00 00 f0 3f f4 03 02 1a |........|...?....|
|00000860| 00 08 18 00 00 00 00 00 | 00 f0 3f 1d 16 00 1a 00 |........|..?.....|
|00000870| 08 18 00 00 00 00 00 00 | f0 3f f7 1a 03 02 2e f4 |........|.?......|
|00000880| 03 02 1a 03 02 f5 76 00 | fd 18 09 01 05 01 13 19 |......v.|........|
|00000890| 0a 43 65 6c 6c 20 4e 6f | 74 65 20 1a 03 02 af 35 |.Cell No|te ....5|
|000008a0| ff fd 06 1e 16 00 80 80 | fe 50 18 00 00 00 00 00 |........|.P......|
|000008b0| 00 00 00 e4 f4 03 04 fe | 55 f4 03 05 fd 1b 09 01 |........|U.......|
|000008c0| 04 01 01 13 19 0a 43 65 | 6c 6c 20 4e 6f 74 65 20 |......Ce|ll Note |
|000008d0| 1a 03 02 af 35 ff 00 00 | fd 02 07 fd 1d 17 01 13 |....5...|........|
|000008e0| 1a 03 04 1a 03 04 ad 2b | 00 00 00 00 00 00 f0 3f |.......+|.......?|
|000008f0| b7 ff 01 06 1a 03 05 d3 | ff 1d 74 ff fd 0c 09 01 |........|..t.....|
|00000900| 04 01 00 03 63 72 31 00 | 00 18 00 00 00 00 00 00 |....cr1.|........|
|00000910| 00 40 f4 03 02 1a 00 08 | 18 00 00 00 00 00 00 f0 |.@......|........|
|00000920| 3f 1d 16 00 1a 00 08 18 | 00 00 00 00 00 00 f0 3f |?.......|.......?|
|00000930| f7 1a 03 02 2e f4 03 02 | 1a 03 02 f5 19 00 fd 13 |........|........|
|00000940| 09 00 04 01 01 0b 19 02 | 63 72 1a 03 02 af 35 ff |........|cr....5.|
|00000950| 00 00 1d d1 ff fd 04 15 | 0b 01 fd 07 15 02 00 02 |........|........|
|00000960| 63 72 19 03 4e 6f 20 1a | 03 06 35 19 0e 20 77 65 |cr..No .|..5.. we|
|00000970| 72 65 20 66 6f 75 6e 64 | 2e 20 20 35 f4 03 07 1a |re found|.  5....|
|00000980| 00 08 18 00 00 00 00 00 | 00 00 00 3a f2 99 00 1a |........|...:....|
|00000990| 03 06 19 77 20 77 65 72 | 65 20 66 6f 75 6e 64 20 |...w wer|e found |
|000009a0| 61 6e 64 20 68 61 76 65 | 20 62 65 65 6e 20 61 6e |and have| been an|
|000009b0| 6e 6f 74 61 74 65 64 20 | 77 69 74 68 20 63 69 72 |notated |with cir|
|000009c0| 63 6c 65 73 2e 20 20 59 | 6f 75 20 63 61 6e 20 72 |cles.  Y|ou can r|
|000009d0| 65 6d 6f 76 65 20 74 68 | 65 20 63 69 72 63 6c 65 |emove th|e circle|
|000009e0| 73 20 62 79 20 73 65 6c | 65 63 74 69 6e 67 20 61 |s by sel|ecting a|
|000009f0| 6e 64 20 64 65 6c 65 74 | 69 6e 67 20 61 6e 79 20 |nd delet|ing any |
|00000a00| 6f 6e 65 20 63 69 72 63 | 6c 65 2e 35 f4 03 07 fd |one circ|le.5....|
|00000a10| 0b 0f 01 01 00 01 05 1a | 00 05 ff fd 0a 0f 01 00 |........|........|
|00000a20| 01 05 1a 00 06 ff fd 08 | 23 01 05 1a 03 07 ff fb |........|#.......|
|00000a30| f6 02 01 fd 0d 09 01 04 | 01 01 05 1a 03 01 ff 00 |........|........|
|00000a40| 00 fd 02 07 fd 08 22 01 | 05 1a 03 02 ff fe 17 f4 |......".|........|
|00000a50| 00 08 18 00 00 00 00 00 | 00 f0 3f f4 03 03 1a 00 |........|..?.....|
|00000a60| 08 18 00 00 00 00 00 00 | f0 3f 1d 16 00 1a 00 08 |........|.?......|
|00000a70| 18 00 00 00 00 00 00 f0 | 3f f7 1a 03 03 2e f4 03 |........|?.......|
|00000a80| 03 1a 03 03 f5 21 00 fd | 08 22 01 05 1a 03 02 ff |.....!..|."......|
|00000a90| 1a 03 03 fe 19 1a 03 01 | 1a 03 03 af 35 1b 02 00 |........|....5...|
|00000aa0| 06 f9 f8 1d c9 ff fd 11 | 09 01 04 01 01 09 1a 03 |........|........|
|00000ab0| 01 19 01 31 35 ff 00 00 | 18 00 00 00 00 00 00 00 |...15...|........|
|00000ac0| 40 f4 03 03 1a 00 08 18 | 00 00 00 00 00 00 f0 3f |@.......|.......?|
|00000ad0| 1d 16 00 1a 00 08 18 00 | 00 00 00 00 00 f0 3f f7 |........|......?.|
|00000ae0| 1a 03 03 2e f4 03 03 1a | 03 03 f5 18 00 fd 12 09 |........|........|
|00000af0| 00 04 01 01 0a 1a 03 01 | 1a 03 03 af 35 ff 00 00 |........|....5...|
|00000b00| 1d d2 ff fd 04 15 0b 01 | fd 09 15 02 01 05 1a 03 |........|........|
|00000b10| 01 ff fb f6 02 01 1a 03 | 01 fe 93 18 00 00 00 00 |........|........|
|00000b20| 00 00 f0 3f 39 1a 03 01 | fe 92 18 00 00 00 00 00 |...?9...|........|
|00000b30| 00 f0 3f 39 36 f2 60 00 | 1a 03 01 fe 92 1a 03 01 |..?96.`.|........|
|00000b40| fe 93 1a 03 01 fe 92 2a | 00 00 00 00 00 00 f0 3f |.......*|.......?|
|00000b50| 1a 03 01 fe 93 2a 00 00 | 00 00 00 00 f0 3f d8 d3 |.....*..|.....?..|
|00000b60| f4 03 03 fd 2f 15 00 07 | 01 2a 1a 03 03 18 00 00 |..../...|.*......|
|00000b70| 00 00 00 00 00 00 18 00 | 00 00 00 00 00 00 00 18 |........|........|
|00000b80| 00 00 00 00 00 00 50 40 | 18 00 00 00 00 00 00 30 |......P@|.......0|
|00000b90| 40 e3 ff 1d 49 01 1a 03 | 01 fe 93 18 00 00 00 00 |@...I...|........|
|00000ba0| 00 00 f0 3f 39 f2 61 00 | 1a 03 01 fe 92 2b 00 00 |...?9.a.|.....+..|
|00000bb0| 00 00 00 00 f0 3f 1a 03 | 01 fe 93 1a 03 01 fe 92 |.....?..|........|
|00000bc0| 1a 03 01 d0 2e 1a 03 01 | fe 93 1a 03 01 d1 2e d8 |........|........|
|00000bd0| d3 f4 03 03 fd 2f 15 00 | 07 01 2a 1a 03 03 18 00 |...../..|..*.....|
|00000be0| 00 00 00 00 00 00 00 18 | 00 00 00 00 00 80 6b 40 |........|......k@|
|00000bf0| 18 00 00 00 00 00 40 55 | 40 18 00 00 00 00 00 00 |......@U|@.......|
|00000c00| 2e 40 e3 ff 1d d8 00 1a | 03 01 fe 92 18 00 00 00 |.@......|........|
|00000c10| 00 00 00 f0 3f 39 f2 61 | 00 1a 03 01 fe 92 1a 03 |....?9.a|........|
|00000c20| 01 fe 93 2b 00 00 00 00 | 00 00 f0 3f 1a 03 01 fe |...+....|...?....|
|00000c30| 92 1a 03 01 d0 2e 1a 03 | 01 fe 93 1a 03 01 d1 2e |........|........|
|00000c40| d8 d3 f4 03 03 fd 2f 15 | 00 07 01 2a 1a 03 03 18 |....../.|...*....|
|00000c50| 00 00 00 00 00 40 6d 40 | 18 00 00 00 00 00 00 1c |.....@m@|........|
|00000c60| 40 18 00 00 00 00 00 80 | 45 40 18 00 00 00 00 00 |@.......|E@......|
|00000c70| 00 40 40 e3 ff 1d 67 00 | 1a 03 01 fe 92 2b 00 00 |.@@...g.|.....+..|
|00000c80| 00 00 00 00 f0 3f 1a 03 | 01 fe 93 2b 00 00 00 00 |.....?..|...+....|
|00000c90| 00 00 f0 3f 1a 03 01 fe | 92 1a 03 01 d0 2e 1a 03 |...?....|........|
|00000ca0| 01 fe 93 1a 03 01 d1 2e | d8 d3 f4 03 03 fd 2f 15 |........|....../.|
|00000cb0| 00 07 01 2a 1a 03 03 18 | 00 00 00 00 00 00 6a 40 |...*....|......j@|
|00000cc0| 18 00 00 00 00 00 a0 6e | 40 18 00 00 00 00 00 00 |.......n|@.......|
|00000cd0| 56 40 18 00 00 00 00 00 | 00 34 40 e3 ff fd 09 15 |V@......|.4@.....|
|00000ce0| 02 01 05 1a 03 02 ff fd | 05 0f 00 02 80 fb f6 00 |........|........|
|00000cf0| 01 e6 f4 03 01 49 f4 00 | 03 1a 03 01 19 08 43 69 |.....I..|......Ci|
|00000d00| 72 63 75 6c 61 72 ea fe | 41 18 00 00 00 00 00 04 |rcular..|A.......|
|00000d10| 94 40 39 37 f2 42 00 1a | 03 01 1a 03 01 ad 19 05 |.@97.B..|........|
|00000d20| 63 65 6c 6c 20 1a 03 01 | 18 00 00 00 00 00 00 f0 |cell ...|........|
|00000d30| 3f bc 2a 00 00 00 00 00 | 00 10 40 2f b8 f4 00 07 |?.*.....|..@/....|
|00000d40| 1a 00 07 1a 00 07 ad 2b | 00 00 00 00 00 00 f0 3f |.......+|.......?|
|00000d50| b7 f4 00 07 1d 3c 00 1a | 03 01 19 1b 53 65 6c 65 |.....<..|....Sele|
|00000d60| 63 74 69 6f 6e 20 77 61 | 73 20 75 6e 73 75 63 63 |ction wa|s unsucc|
|00000d70| 65 73 73 66 75 6c 2e 3e | fe 41 18 00 00 00 00 00 |essful.>|.A......|
|00000d80| 00 4e 40 3e 36 f2 0b 00 | fd 08 2a 00 82 01 03 e6 |.N@>6...|..*.....|
|00000d90| ff fb fc 07 53 74 61 72 | 74 75 70 00 07 00 66 61 |....Star|tup...fa|
|00000da0| 69 6c 65 64 00 09 00 75 | 74 69 6c 4d 65 6e 75 07 |iled...u|tilMenu.|
|00000db0| 00 6d 79 4d 65 6e 75 00 | 07 00 73 65 6c 52 6e 67 |.myMenu.|..selRng|
|00000dc0| 01 06 00 6e 53 65 6c 73 | 02 06 00 6e 6f 45 72 72 |...nSels|...noErr|
|00000dd0| 03 0a 00 61 75 64 69 74 | 54 79 70 65 04 0c 00 63 |...audit|Type...c|
|00000de0| 69 72 63 6c 65 43 6f 6c | 6f 72 05 0b 00 63 69 72 |ircleCol|or...cir|
|00000df0| 63 6c 65 4c 69 6e 65 06 | 0d 00 63 69 72 63 75 6c |cleLine.|..circul|
|00000e00| 61 72 43 65 6c 6c 07 05 | 00 72 65 66 73 08 04 00 |arCell..|.refs...|
|00000e10| 6d 73 67 09 17 01 00 73 | 65 74 55 70 4c 6f 63 61 |msg....s|etUpLoca|
|00000e20| 6c 69 7a 65 64 53 74 72 | 69 6e 67 73 21 00 00 00 |lizedStr|ings!...|
|00000e30| 09 01 00 61 75 64 69 74 | 49 74 07 01 00 00 0c 01 |...audit|It......|
|00000e40| 00 69 6e 69 74 69 61 6c | 69 7a 65 63 00 00 00 0a |.initial|izec....|
|00000e50| 01 01 73 65 74 43 6f 6c | 6f 72 25 04 00 00 06 01 |..setCol|or%.....|
|00000e60| 00 64 6f 49 74 d0 04 00 | 00 11 01 02 73 65 6c 65 |.doIt...|....sele|
|00000e70| 63 74 52 65 66 65 72 65 | 6e 63 65 58 09 00 00 0c |ctRefere|nceX....|
|00000e80| 01 02 63 69 72 63 6c 65 | 43 65 6c 6c 3b 0a 00 00 |..circle|Cell;...|
|00000e90| 7b 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |{*******|********|
|00000ea0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000eb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 41 75 64 69 74 20 |********|* Audit |
|00000ec0| 53 43 52 49 50 54 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |SCRIPT *|********|
|00000ed0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ee0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ef0| 2a 2a 0d 0d 4d 4f 44 49 | 46 49 45 44 3a 20 37 2f |**..MODI|FIED: 7/|
|00000f00| 39 2f 39 31 0d 0d 41 75 | 64 69 74 20 63 68 65 63 |9/91..Au|dit chec|
|00000f10| 6b 73 20 66 6f 72 20 61 | 6e 64 20 22 63 69 72 63 |ks for a|nd "circ|
|00000f20| 6c 65 73 22 20 45 72 72 | 6f 72 73 2c 20 52 65 66 |les" Err|ors, Ref|
|00000f30| 65 72 65 6e 63 65 73 20 | 74 6f 20 42 6c 61 6e 6b |erences |to Blank|
|00000f40| 20 43 65 6c 6c 73 2c 20 | 55 6e 72 65 66 65 72 65 | Cells, |Unrefere|
|00000f50| 6e 63 65 64 20 43 65 6c | 6c 73 2c 0d 4c 6f 63 6b |nced Cel|ls,.Lock|
|00000f60| 65 64 20 43 65 6c 6c 73 | 2c 20 61 6e 64 20 43 69 |ed Cells|, and Ci|
|00000f70| 72 63 75 6c 61 72 20 52 | 65 66 65 72 65 6e 63 65 |rcular R|eference|
|00000f80| 73 2e 20 20 49 74 20 75 | 73 65 73 20 61 20 64 69 |s.  It u|ses a di|
|00000f90| 61 6c 6f 67 20 62 6f 78 | 20 72 65 73 6f 75 72 63 |alog box| resourc|
|00000fa0| 65 20 63 6f 6e 74 61 69 | 6e 65 64 20 69 6e 20 74 |e contai|ned in t|
|00000fb0| 68 65 20 73 63 72 69 70 | 74 0d 69 74 73 65 6c 66 |he scrip|t.itself|
|00000fc0| 2e 0d 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |...*****|********|
|00000fd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 44 45 46 49 4e |********|** DEFIN|
|00000ff0| 45 20 47 4c 4f 42 41 4c | 53 20 2a 2a 2a 2a 2a 2a |E GLOBAL|S ******|
|00001000| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001010| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001020| 2a 2a 2a 2a 2a 2a 7d 0d | 0d 44 45 46 49 4e 45 20 |******}.|.DEFINE |
|00001030| 09 6d 79 4d 65 6e 75 2c | 20 73 65 6c 52 6e 67 2c |.myMenu,| selRng,|
|00001040| 20 6e 53 65 6c 73 2c 20 | 6e 6f 45 72 72 2c 20 61 | nSels, |noErr, a|
|00001050| 75 64 69 74 54 79 70 65 | 2c 20 63 69 72 63 6c 65 |uditType|, circle|
|00001060| 43 6f 6c 6f 72 2c 20 63 | 69 72 63 6c 65 4c 69 6e |Color, c|ircleLin|
|00001070| 65 2c 20 63 69 72 63 75 | 6c 61 72 43 65 6c 6c 2c |e, circu|larCell,|
|00001080| 20 72 65 66 73 2c 20 6d | 73 67 0d 0d 53 74 61 72 | refs, m|sg..Star|
|00001090| 74 75 70 3a 66 61 69 6c | 65 64 20 3d 20 46 41 4c |tup:fail|ed = FAL|
|000010a0| 53 45 28 29 09 09 09 09 | 09 7b 54 65 6c 6c 20 53 |SE()....|.{Tell S|
|000010b0| 74 61 72 74 75 70 20 77 | 65 20 6c 6f 61 64 65 64 |tartup w|e loaded|
|000010c0| 2f 72 61 6e 20 73 75 63 | 63 65 73 73 66 75 6c 6c |/ran suc|cessfull|
|000010d0| 79 7d 0d 0d 0d 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |y}...{**|********|
|000010e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 4d |********|****** M|
|00001100| 41 49 4e 20 53 43 52 49 | 50 54 20 2a 2a 2a 2a 2a |AIN SCRI|PT *****|
|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 2a 2a 2a 2a |********|********|
|00001130| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 49 46 20 49 53 |********|}..IF IS|
|00001140| 45 52 52 28 53 74 61 72 | 74 75 70 3a 66 61 69 6c |ERR(Star|tup:fail|
|00001150| 65 64 29 09 09 09 09 09 | 7b 49 66 20 73 63 72 69 |ed).....|{If scri|
|00001160| 70 74 20 68 61 73 20 62 | 65 65 6e 20 6c 6f 61 64 |pt has b|een load|
|00001170| 65 64 20 62 79 20 52 75 | 6e 20 53 63 72 69 70 74 |ed by Ru|n Script|
|00001180| 7d 0d 09 43 41 4c 4c 20 | 73 65 74 55 70 4c 6f 63 |}..CALL |setUpLoc|
|00001190| 61 6c 69 7a 65 64 53 74 | 72 69 6e 67 73 28 29 0d |alizedSt|rings().|
|000011a0| 09 43 41 4c 4c 20 61 75 | 64 69 74 49 74 28 29 0d |.CALL au|ditIt().|
|000011b0| 45 4c 53 45 0d 09 43 41 | 4c 4c 20 69 6e 69 74 69 |ELSE..CA|LL initi|
|000011c0| 61 6c 69 7a 65 28 29 09 | 09 09 09 09 7b 4f 74 68 |alize().|....{Oth|
|000011d0| 65 72 77 69 73 65 2c 20 | 73 65 74 20 75 70 20 69 |erwise, |set up i|
|000011e0| 74 73 20 6d 65 6e 75 20 | 69 74 65 6d 7d 0d 45 4e |ts menu |item}.EN|
|000011f0| 44 20 49 46 0d 0d 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |D IF..{*|********|
|00001200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001210| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 4c |********|****** L|
|00001220| 4f 43 41 4c 49 5a 45 20 | 48 45 52 45 20 2a 2a 2a |OCALIZE |HERE ***|
|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 2a 2a 2a 2a 2a |********|********|
|00001250| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 09 09 53 74 |********|***...St|
|00001260| 72 69 6e 67 73 20 74 68 | 61 74 20 61 72 65 20 6c |rings th|at are l|
|00001270| 6f 63 61 6c 69 7a 61 62 | 6c 65 20 61 72 65 20 61 |ocalizab|le are a|
|00001280| 73 73 69 67 6e 65 64 20 | 74 6f 20 76 61 72 69 61 |ssigned |to varia|
|00001290| 62 6c 65 73 20 69 6e 20 | 74 68 69 73 20 61 72 65 |bles in |this are|
|000012a0| 61 2e 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |a..*****|********|
|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 | 7d 0d 0d 46 55 4e 43 54 |********|}..FUNCT|
|00001310| 49 4f 4e 20 73 65 74 55 | 70 4c 6f 63 61 6c 69 7a |ION setU|pLocaliz|
|00001320| 65 64 53 74 72 69 6e 67 | 73 28 29 0d 09 6d 79 4d |edString|s()..myM|
|00001330| 65 6e 75 20 3d 20 22 41 | 75 64 69 74 c9 22 0d 09 |enu = "A|udit."..|
|00001340| 6d 73 67 20 3d 20 22 50 | 6c 65 61 73 65 20 6f 70 |msg = "P|lease op|
|00001350| 65 6e 20 61 20 77 6f 72 | 6b 73 68 65 65 74 20 6f |en a wor|ksheet o|
|00001360| 72 20 62 72 69 6e 67 20 | 6f 6e 65 20 74 6f 20 66 |r bring |one to f|
|00001370| 72 6f 6e 74 2e 22 0d 45 | 4e 44 20 46 55 4e 43 54 |ront.".E|ND FUNCT|
|00001380| 49 4f 4e 0d 0d 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ION..{**|********|
|00001390| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 69 6e |********|***** in|
|000013b0| 69 74 69 61 6c 69 7a 65 | 20 2a 2a 2a 2a 2a 2a 2a |itialize| *******|
|000013c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013e0| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 54 68 69 73 20 66 75 |********|.This fu|
|000013f0| 6e 63 74 69 6f 6e 20 69 | 6e 69 74 69 61 6c 69 7a |nction i|nitializ|
|00001400| 65 73 20 6c 6f 63 61 6c | 69 7a 65 64 20 76 61 72 |es local|ized var|
|00001410| 69 61 62 6c 65 73 2c 20 | 69 6e 73 74 61 6c 6c 73 |iables, |installs|
|00001420| 20 6d 65 6e 75 20 61 6e | 64 20 61 74 74 61 63 68 | menu an|d attach|
|00001430| 65 73 20 73 63 72 69 70 | 74 0d 2a 2a 2a 2a 2a 2a |es scrip|t.******|
|00001440| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001480| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001490| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 7d 0d 0d |********|*****}..|
|000014a0| 46 55 4e 43 54 49 4f 4e | 20 69 6e 69 74 69 61 6c |FUNCTION| initial|
|000014b0| 69 7a 65 28 29 0d 09 53 | 45 4c 45 43 54 20 4d 45 |ize()..S|ELECT ME|
|000014c0| 4e 55 20 53 74 61 72 74 | 75 70 3a 75 74 69 6c 4d |NU Start|up:utilM|
|000014d0| 65 6e 75 0d 09 43 41 4c | 4c 20 73 65 74 55 70 4c |enu..CAL|L setUpL|
|000014e0| 6f 63 61 6c 69 7a 65 64 | 53 74 72 69 6e 67 73 28 |ocalized|Strings(|
|000014f0| 29 0d 09 41 44 44 20 4d | 45 4e 55 49 54 45 4d 20 |)..ADD M|ENUITEM |
|00001500| 6d 79 4d 65 6e 75 20 43 | 4f 4d 4d 41 4e 44 20 22 |myMenu C|OMMAND "|
|00001510| 47 45 54 20 53 43 52 49 | 50 54 20 22 22 41 75 64 |GET SCRI|PT ""Aud|
|00001520| 69 74 22 22 0d 09 09 09 | 09 09 09 20 20 20 20 43 |it""....|...    C|
|00001530| 41 4c 4c 20 41 75 64 69 | 74 3a 73 65 74 55 70 4c |ALL Audi|t:setUpL|
|00001540| 6f 63 61 6c 69 7a 65 64 | 53 74 72 69 6e 67 73 28 |ocalized|Strings(|
|00001550| 29 20 0d 09 09 09 09 09 | 09 20 20 20 20 43 41 4c |) ......|.    CAL|
|00001560| 4c 20 41 75 64 69 74 3a | 61 75 64 69 74 49 74 28 |L Audit:|auditIt(|
|00001570| 29 20 0d 09 09 09 09 09 | 09 20 20 20 20 52 45 4d |) ......|.    REM|
|00001580| 4f 56 45 20 53 43 52 49 | 50 54 20 22 22 41 75 64 |OVE SCRI|PT ""Aud|
|00001590| 69 74 22 22 22 0d 45 4e | 44 20 46 55 4e 43 54 49 |it""".EN|D FUNCTI|
|000015a0| 4f 4e 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ON..{***|********|
|000015b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000015c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 61 75 64 |********|**** aud|
|000015d0| 69 74 49 74 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |itIt ***|********|
|000015e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000015f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001600| 2a 2a 2a 2a 2a 2a 0d 54 | 68 69 73 20 66 75 6e 63 |******.T|his func|
|00001610| 74 69 6f 6e 20 70 75 74 | 73 20 75 70 20 74 68 65 |tion put|s up the|
|00001620| 20 41 75 64 69 74 20 64 | 69 61 6c 6f 67 20 62 6f | Audit d|ialog bo|
|00001630| 78 2e 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |x..*****|********|
|00001640| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001650| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001660| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001670| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001680| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001690| 2a 2a 2a 2a 2a 7d 0d 0d | 46 55 4e 43 54 49 4f 4e |*****}..|FUNCTION|
|000016a0| 20 61 75 64 69 74 49 74 | 28 29 0d 09 44 45 46 49 | auditIt|()..DEFI|
|000016b0| 4e 45 20 6b 4f 4b 42 74 | 6e 2c 20 6b 43 61 6e 63 |NE kOKBt|n, kCanc|
|000016c0| 65 6c 42 74 6e 2c 20 6b | 52 61 64 69 6f 42 75 74 |elBtn, k|RadioBut|
|000016d0| 74 6f 6e 73 2c 20 6b 43 | 6f 6c 6f 72 50 69 63 6b |tons, kC|olorPick|
|000016e0| 65 72 2c 20 6b 4c 69 6e | 65 50 69 63 6b 65 72 2c |er, kLin|ePicker,|
|000016f0| 20 6b 43 6f 6c 6f 72 53 | 77 61 74 63 68 2c 20 6b | kColorS|watch, k|
|00001700| 52 65 6d 6f 76 65 42 74 | 6e 2c 0d 09 09 20 20 6b |RemoveBt|n,...  k|
|00001710| 4f 62 6a 65 63 74 0d 0d | 09 6b 4f 4b 42 74 6e 09 |Object..|.kOKBtn.|
|00001720| 09 3d 20 31 0d 09 6b 43 | 61 6e 63 65 6c 42 74 6e |.= 1..kC|ancelBtn|
|00001730| 09 3d 20 32 0d 09 6b 52 | 61 64 69 6f 42 75 74 74 |.= 2..kR|adioButt|
|00001740| 6f 6e 73 09 3d 20 34 0d | 09 6b 43 6f 6c 6f 72 50 |ons.= 4.|.kColorP|
|00001750| 69 63 6b 65 72 09 3d 20 | 36 0d 09 6b 4c 69 6e 65 |icker.= |6..kLine|
|00001760| 50 69 63 6b 65 72 09 3d | 20 37 0d 09 6b 43 6f 6c |Picker.=| 7..kCol|
|00001770| 6f 72 53 77 61 74 63 68 | 09 3d 20 38 0d 09 6b 52 |orSwatch|.= 8..kR|
|00001780| 65 6d 6f 76 65 42 74 6e | 09 3d 20 31 33 0d 09 6b |emoveBtn|.= 13..k|
|00001790| 4f 62 6a 65 63 74 09 09 | 3d 20 33 0d 0d 09 49 46 |Object..|= 3...IF|
|000017a0| 20 49 53 45 52 52 28 46 | 75 6c 6c 50 61 74 68 4e | ISERR(F|ullPathN|
|000017b0| 61 6d 65 28 29 29 0d 09 | 09 4d 45 53 53 41 47 45 |ame())..|.MESSAGE|
|000017c0| 20 6d 73 67 0d 09 09 45 | 58 49 54 20 53 43 52 49 | msg...E|XIT SCRI|
|000017d0| 50 54 0d 09 45 4e 44 20 | 49 46 0d 09 0d 09 52 45 |PT..END |IF....RE|
|000017e0| 50 41 49 4e 54 20 53 45 | 4c 45 43 54 49 4f 4e 53 |PAINT SE|LECTIONS|
|000017f0| 20 4f 46 46 0d 09 49 4e | 56 41 4c 49 44 41 54 45 | OFF..IN|VALIDATE|
|00001800| 20 4f 4e 0d 0d 09 4e 45 | 57 20 4d 4f 44 41 4c 20 | ON...NE|W MODAL |
|00001810| 52 45 53 4f 55 52 43 45 | 20 44 49 41 4c 4f 47 20 |RESOURCE| DIALOG |
|00001820| 42 4f 58 20 32 30 30 30 | 30 0d 0d 09 53 45 4c 45 |BOX 2000|0...SELE|
|00001830| 43 54 20 43 4f 4e 54 52 | 4f 4c 20 6b 4f 4b 42 74 |CT CONTR|OL kOKBt|
|00001840| 6e 09 09 09 09 09 7b 4f | 4b 20 62 75 74 74 6f 6e |n.....{O|K button|
|00001850| 7d 0d 09 53 43 52 49 50 | 54 20 22 4f 4e 20 4d 4f |}..SCRIP|T "ON MO|
|00001860| 55 53 45 55 50 20 09 41 | 75 64 69 74 3a 61 75 64 |USEUP .A|udit:aud|
|00001870| 69 74 54 79 70 65 20 3d | 20 43 54 56 41 4c 55 45 |itType =| CTVALUE|
|00001880| 28 22 20 26 20 53 54 52 | 28 6b 52 61 64 69 6f 42 |(" & STR|(kRadioB|
|00001890| 75 74 74 6f 6e 73 29 20 | 26 20 22 2c 30 29 20 0d |uttons) |& ",0) .|
|000018a0| 09 09 09 09 09 41 75 64 | 69 74 3a 63 69 72 63 6c |.....Aud|it:circl|
|000018b0| 65 43 6f 6c 6f 72 20 3d | 20 20 43 54 56 41 4c 55 |eColor =|  CTVALU|
|000018c0| 45 28 22 20 26 20 53 54 | 52 28 6b 43 6f 6c 6f 72 |E(" & ST|R(kColor|
|000018d0| 50 69 63 6b 65 72 29 20 | 26 20 22 2c 30 29 20 0d |Picker) |& ",0) .|
|000018e0| 09 09 09 09 09 41 75 64 | 69 74 3a 63 69 72 63 6c |.....Aud|it:circl|
|000018f0| 65 4c 69 6e 65 20 3d 20 | 43 54 56 41 4c 55 45 28 |eLine = |CTVALUE(|
|00001900| 22 20 26 20 53 54 52 28 | 6b 4c 69 6e 65 50 69 63 |" & STR(|kLinePic|
|00001910| 6b 65 72 29 20 26 20 22 | 2c 30 29 0d 09 09 09 09 |ker) & "|,0).....|
|00001920| 09 51 55 49 54 20 44 49 | 41 4c 4f 47 20 42 4f 58 |.QUIT DI|ALOG BOX|
|00001930| 0d 09 09 09 09 09 43 41 | 4c 4c 20 41 75 64 69 74 |......CA|LL Audit|
|00001940| 3a 64 6f 49 74 28 29 0d | 09 09 09 09 09 45 4e 44 |:doIt().|.....END|
|00001950| 20 4d 4f 55 53 45 55 50 | 22 0d 09 53 45 4c 45 43 | MOUSEUP|"..SELEC|
|00001960| 54 20 43 4f 4e 54 52 4f | 4c 20 6b 43 61 6e 63 65 |T CONTRO|L kCance|
|00001970| 6c 42 74 6e 09 09 09 09 | 7b 43 61 6e 63 65 6c 20 |lBtn....|{Cancel |
|00001980| 62 75 74 74 6f 6e 7d 0d | 09 44 49 41 4c 4f 47 20 |button}.|.DIALOG |
|00001990| 43 41 4e 43 45 4c 20 50 | 55 53 48 20 42 55 54 54 |CANCEL P|USH BUTT|
|000019a0| 4f 4e 0d 09 53 45 4c 45 | 43 54 20 43 4f 4e 54 52 |ON..SELE|CT CONTR|
|000019b0| 4f 4c 20 6b 52 61 64 69 | 6f 42 75 74 74 6f 6e 73 |OL kRadi|oButtons|
|000019c0| 09 09 09 09 7b 52 61 64 | 69 6f 20 42 75 74 74 6f |....{Rad|io Butto|
|000019d0| 6e 73 7d 0d 09 4e 4f 20 | 4c 49 4e 45 20 42 4f 52 |ns}..NO |LINE BOR|
|000019e0| 44 45 52 0d 09 52 41 44 | 49 4f 20 42 55 54 54 4f |DER..RAD|IO BUTTO|
|000019f0| 4e 20 31 0d 09 53 43 52 | 49 50 54 20 22 4f 4e 20 |N 1..SCR|IPT "ON |
|00001a00| 4d 4f 55 53 45 55 50 20 | 43 41 4c 4c 20 41 75 64 |MOUSEUP |CALL Aud|
|00001a10| 69 74 3a 73 65 74 43 6f | 6c 6f 72 28 43 54 56 41 |it:setCo|lor(CTVA|
|00001a20| 4c 55 45 28 34 2c 30 29 | 29 20 45 4e 44 20 4d 4f |LUE(4,0)|) END MO|
|00001a30| 55 53 45 55 50 22 20 0d | 09 53 45 4c 45 43 54 20 |USEUP" .|.SELECT |
|00001a40| 43 4f 4e 54 52 4f 4c 20 | 6b 43 6f 6c 6f 72 50 69 |CONTROL |kColorPi|
|00001a50| 63 6b 65 72 09 09 09 09 | 7b 43 6f 6c 6f 72 20 50 |cker....|{Color P|
|00001a60| 69 63 6b 65 72 7d 0d 09 | 53 43 52 49 50 54 20 22 |icker}..|SCRIPT "|
|00001a70| 4f 4e 20 4d 4f 55 53 45 | 55 50 20 53 45 4c 45 43 |ON MOUSE|UP SELEC|
|00001a80| 54 20 43 4f 4e 54 52 4f | 4c 20 22 20 26 20 53 54 |T CONTRO|L " & ST|
|00001a90| 52 28 6b 43 6f 6c 6f 72 | 53 77 61 74 63 68 29 20 |R(kColor|Swatch) |
|00001aa0| 26 20 22 20 46 49 4c 4c | 20 46 47 20 43 54 56 41 |& " FILL| FG CTVA|
|00001ab0| 4c 55 45 28 22 20 26 20 | 53 54 52 28 6b 43 6f 6c |LUE(" & |STR(kCol|
|00001ac0| 6f 72 50 69 63 6b 65 72 | 29 20 26 20 22 2c 30 29 |orPicker|) & ",0)|
|00001ad0| 20 45 4e 44 20 4d 4f 55 | 53 45 55 50 22 0d 09 43 | END MOU|SEUP"..C|
|00001ae0| 4f 4c 4f 52 20 50 49 43 | 4b 45 52 20 52 45 44 28 |OLOR PIC|KER RED(|
|00001af0| 29 0d 09 53 45 4c 45 43 | 54 20 43 4f 4e 54 52 4f |)..SELEC|T CONTRO|
|00001b00| 4c 20 6b 43 6f 6c 6f 72 | 53 77 61 74 63 68 09 09 |L kColor|Swatch..|
|00001b10| 09 09 7b 43 6f 6c 6f 72 | 20 53 77 61 74 63 68 7d |..{Color| Swatch}|
|00001b20| 0d 09 46 49 4c 4c 20 46 | 47 20 43 54 56 41 4c 55 |..FILL F|G CTVALU|
|00001b30| 45 28 6b 43 6f 6c 6f 72 | 50 69 63 6b 65 72 2c 30 |E(kColor|Picker,0|
|00001b40| 29 0d 09 53 45 4c 45 43 | 54 20 43 4f 4e 54 52 4f |)..SELEC|T CONTRO|
|00001b50| 4c 20 6b 4c 69 6e 65 50 | 69 63 6b 65 72 09 09 09 |L kLineP|icker...|
|00001b60| 09 7b 4c 69 6e 65 20 50 | 69 63 6b 65 72 7d 0d 09 |.{Line P|icker}..|
|00001b70| 4c 49 4e 45 20 50 49 43 | 4b 45 52 20 35 0d 09 55 |LINE PIC|KER 5..U|
|00001b80| 4e 53 45 4c 45 43 54 09 | 09 09 09 09 09 09 09 7b |NSELECT.|.......{|
|00001b90| 53 65 74 75 70 20 52 65 | 6d 6f 76 65 20 43 69 72 |Setup Re|move Cir|
|00001ba0| 63 6c 65 73 20 62 75 74 | 74 6f 6e 7d 0d 09 53 45 |cles but|ton}..SE|
|00001bb0| 4c 45 43 54 20 4f 42 4a | 45 43 54 20 22 65 63 22 |LECT OBJ|ECT "ec"|
|00001bc0| 0d 09 53 45 4c 45 43 54 | 20 4d 4f 52 45 20 4f 42 |..SELECT| MORE OB|
|00001bd0| 4a 45 43 54 20 22 72 62 | 22 0d 09 53 45 4c 45 43 |JECT "rb|"..SELEC|
|00001be0| 54 20 4d 4f 52 45 20 4f | 42 4a 45 43 54 20 22 6c |T MORE O|BJECT "l|
|00001bf0| 63 22 0d 09 53 45 4c 45 | 43 54 20 4d 4f 52 45 20 |c"..SELE|CT MORE |
|00001c00| 4f 42 4a 45 43 54 20 22 | 75 72 22 0d 09 53 45 4c |OBJECT "|ur"..SEL|
|00001c10| 45 43 54 20 4d 4f 52 45 | 20 4f 42 4a 45 43 54 20 |ECT MORE| OBJECT |
|00001c20| 22 63 72 22 0d 09 49 46 | 20 4e 52 53 45 4c 45 43 |"cr"..IF| NRSELEC|
|00001c30| 54 49 4f 4e 53 28 29 20 | 3d 20 30 0d 09 09 53 45 |TIONS() |= 0...SE|
|00001c40| 4c 45 43 54 20 43 4f 4e | 54 52 4f 4c 20 6b 52 65 |LECT CON|TROL kRe|
|00001c50| 6d 6f 76 65 42 74 6e 0d | 09 09 47 52 45 59 20 43 |moveBtn.|..GREY C|
|00001c60| 4f 4e 54 52 4f 4c 0d 09 | 45 4e 44 20 49 46 0d 09 |ONTROL..|END IF..|
|00001c70| 53 45 4c 45 43 54 20 43 | 4f 4e 54 52 4f 4c 20 6b |SELECT C|ONTROL k|
|00001c80| 52 65 6d 6f 76 65 42 74 | 6e 0d 09 53 43 52 49 50 |RemoveBt|n..SCRIP|
|00001c90| 54 09 22 4f 4e 20 4d 4f | 55 53 45 55 50 0d 09 09 |T."ON MO|USEUP...|
|00001ca0| 09 09 51 55 49 54 20 44 | 49 41 4c 4f 47 20 42 4f |..QUIT D|IALOG BO|
|00001cb0| 58 0d 09 09 09 09 43 4c | 45 41 52 0d 09 09 09 45 |X.....CL|EAR....E|
|00001cc0| 4e 44 20 4d 4f 55 53 45 | 55 50 22 0d 0d 09 55 53 |ND MOUSE|UP"...US|
|00001cd0| 45 20 44 49 41 4c 4f 47 | 20 42 4f 58 09 0d 09 52 |E DIALOG| BOX...R|
|00001ce0| 45 50 41 49 4e 54 20 53 | 45 4c 45 43 54 49 4f 4e |EPAINT S|ELECTION|
|00001cf0| 53 20 4f 4e 0d 09 49 4e | 56 41 4c 49 44 41 54 45 |S ON..IN|VALIDATE|
|00001d00| 20 4f 46 46 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f | OFF.END| FUNCTIO|
|00001d10| 4e 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N..{****|********|
|00001d20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001d30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 73 65 74 43 |********|*** setC|
|00001d40| 6f 6c 6f 72 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |olor ***|********|
|00001d50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001d60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001d70| 2a 2a 2a 2a 2a 2a 0d 54 | 68 69 73 20 66 75 6e 63 |******.T|his func|
|00001d80| 74 69 6f 6e 20 63 68 61 | 6e 67 65 73 20 74 68 65 |tion cha|nges the|
|00001d90| 20 63 6f 6c 6f 72 20 73 | 77 61 74 63 68 20 69 6e | color s|watch in|
|00001da0| 20 74 68 65 20 64 69 61 | 6c 6f 67 20 62 6f 78 20 | the dia|log box |
|00001db0| 64 65 70 65 6e 64 69 6e | 67 20 6f 6e 20 74 68 65 |dependin|g on the|
|00001dc0| 20 73 65 74 74 69 6e 67 | 20 6f 66 20 74 68 65 20 | setting| of the |
|00001dd0| 72 61 64 69 6f 20 62 74 | 6e 73 2e 0d 2a 2a 2a 2a |radio bt|ns..****|
|00001de0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001df0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|00001e40| 0d 46 55 4e 43 54 49 4f | 4e 20 73 65 74 43 6f 6c |.FUNCTIO|N setCol|
|00001e50| 6f 72 28 72 61 64 69 6f | 42 75 74 74 6f 6e 29 0d |or(radio|Button).|
|00001e60| 44 45 46 49 4e 45 20 74 | 68 65 43 6f 6c 6f 72 0d |DEFINE t|heColor.|
|00001e70| 09 43 41 53 45 20 72 61 | 64 69 6f 42 75 74 74 6f |.CASE ra|dioButto|
|00001e80| 6e 0d 09 57 48 45 4e 20 | 31 0d 09 09 74 68 65 43 |n..WHEN |1...theC|
|00001e90| 6f 6c 6f 72 20 3d 20 52 | 45 44 28 29 0d 09 57 48 |olor = R|ED()..WH|
|00001ea0| 45 4e 20 32 0d 09 09 74 | 68 65 43 6f 6c 6f 72 20 |EN 2...t|heColor |
|00001eb0| 3d 20 47 52 45 45 4e 28 | 29 0d 09 57 48 45 4e 20 |= GREEN(|)..WHEN |
|00001ec0| 33 0d 09 09 74 68 65 43 | 6f 6c 6f 72 20 3d 20 42 |3...theC|olor = B|
|00001ed0| 4c 55 45 28 29 0d 09 57 | 48 45 4e 20 34 0d 09 09 |LUE()..W|HEN 4...|
|00001ee0| 74 68 65 43 6f 6c 6f 72 | 20 3d 20 4d 41 47 45 4e |theColor| = MAGEN|
|00001ef0| 54 41 28 29 0d 09 57 48 | 45 4e 20 35 0d 09 09 74 |TA()..WH|EN 5...t|
|00001f00| 68 65 43 6f 6c 6f 72 20 | 3d 20 43 59 41 4e 28 29 |heColor |= CYAN()|
|00001f10| 0d 09 45 4e 44 20 43 41 | 53 45 0d 09 53 45 4c 45 |..END CA|SE..SELE|
|00001f20| 43 54 20 43 4f 4e 54 52 | 4f 4c 20 36 0d 09 43 4f |CT CONTR|OL 6..CO|
|00001f30| 4c 4f 52 20 50 49 43 4b | 45 52 20 74 68 65 43 6f |LOR PICK|ER theCo|
|00001f40| 6c 6f 72 0d 09 53 45 4c | 45 43 54 20 43 4f 4e 54 |lor..SEL|ECT CONT|
|00001f50| 52 4f 4c 20 38 0d 09 46 | 49 4c 4c 20 46 47 20 43 |ROL 8..F|ILL FG C|
|00001f60| 54 56 41 4c 55 45 28 36 | 2c 30 29 0d 45 4e 44 20 |TVALUE(6|,0).END |
|00001f70| 46 55 4e 43 54 49 4f 4e | 0d 0d 7b 2a 2a 2a 2a 2a |FUNCTION|..{*****|
|00001f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fa0| 2a 2a 20 64 6f 49 74 20 | 2a 2a 2a 2a 2a 2a 2a 2a |** doIt |********|
|00001fb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 54 68 69 73 20 66 |********|*.This f|
|00001fe0| 75 6e 63 74 69 6f 6e 20 | 63 61 6c 6c 73 20 73 65 |unction |calls se|
|00001ff0| 6c 65 63 74 52 65 66 65 | 72 65 6e 63 65 20 74 6f |lectRefe|rence to|
|00002000| 20 63 69 72 63 6c 65 20 | 74 68 65 20 73 65 6c 65 | circle |the sele|
|00002010| 63 74 65 64 20 61 75 64 | 69 74 20 74 79 70 65 2e |cted aud|it type.|
|00002020| 20 0d 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a | .******|********|
|00002030| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002040| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002050| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002060| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002070| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002080| 2a 2a 2a 2a 7d 0d 0d 0d | 46 55 4e 43 54 49 4f 4e |****}...|FUNCTION|
|00002090| 20 64 6f 49 74 28 29 0d | 09 44 45 46 49 4e 45 20 | doIt().|.DEFINE |
|000020a0| 73 61 76 65 52 65 63 61 | 6c 63 4d 6f 64 65 2c 20 |saveReca|lcMode, |
|000020b0| 69 2c 20 63 65 6c 6c 46 | 6f 72 6d 75 6c 61 2c 20 |i, cellF|ormula, |
|000020c0| 63 65 6c 6c 43 6f 6e 74 | 65 6e 74 73 2c 20 74 68 |cellCont|ents, th|
|000020d0| 65 43 65 6c 6c 2c 20 61 | 75 64 69 74 54 79 70 65 |eCell, a|uditType|
|000020e0| 53 74 72 2c 20 6d 73 67 | 53 74 72 0d 09 43 41 53 |Str, msg|Str..CAS|
|000020f0| 45 20 61 75 64 69 74 54 | 79 70 65 0d 09 57 48 45 |E auditT|ype..WHE|
|00002100| 4e 20 31 0d 09 09 43 41 | 4c 4c 20 73 65 6c 65 63 |N 1...CA|LL selec|
|00002110| 74 52 65 66 65 72 65 6e | 63 65 28 22 65 63 22 2c |tReferen|ce("ec",|
|00002120| 22 53 45 4c 45 43 54 20 | 45 52 52 4f 52 20 43 45 |"SELECT |ERROR CE|
|00002130| 4c 4c 53 22 29 0d 09 09 | 61 75 64 69 74 54 79 70 |LLS")...|auditTyp|
|00002140| 65 53 74 72 20 3d 20 22 | 45 72 72 6f 72 20 43 65 |eStr = "|Error Ce|
|00002150| 6c 6c 73 22 0d 09 57 48 | 45 4e 20 32 0d 09 09 43 |lls"..WH|EN 2...C|
|00002160| 41 4c 4c 20 73 65 6c 65 | 63 74 52 65 66 65 72 65 |ALL sele|ctRefere|
|00002170| 6e 63 65 28 22 72 62 22 | 2c 22 53 45 4c 45 43 54 |nce("rb"|,"SELECT|
|00002180| 20 52 45 46 45 52 45 4e | 43 45 53 20 54 4f 20 42 | REFEREN|CES TO B|
|00002190| 4c 41 4e 4b 53 22 29 20 | 0d 09 09 61 75 64 69 74 |LANKS") |...audit|
|000021a0| 54 79 70 65 53 74 72 20 | 3d 20 22 52 65 66 65 72 |TypeStr |= "Refer|
|000021b0| 65 6e 63 65 73 20 54 6f | 20 42 6c 61 6e 6b 20 43 |ences To| Blank C|
|000021c0| 65 6c 6c 73 22 0d 09 57 | 48 45 4e 20 33 0d 09 09 |ells"..W|HEN 3...|
|000021d0| 43 41 4c 4c 20 73 65 6c | 65 63 74 52 65 66 65 72 |CALL sel|ectRefer|
|000021e0| 65 6e 63 65 28 22 6c 63 | 22 2c 22 53 45 4c 45 43 |ence("lc|","SELEC|
|000021f0| 54 20 4c 4f 43 4b 45 44 | 20 43 45 4c 4c 53 22 29 |T LOCKED| CELLS")|
|00002200| 20 0d 09 09 61 75 64 69 | 74 54 79 70 65 53 74 72 | ...audi|tTypeStr|
|00002210| 20 3d 20 22 4c 6f 63 6b | 65 64 20 43 65 6c 6c 73 | = "Lock|ed Cells|
|00002220| 22 0d 09 57 48 45 4e 20 | 34 0d 09 09 43 41 4c 4c |"..WHEN |4...CALL|
|00002230| 20 73 65 6c 65 63 74 52 | 65 66 65 72 65 6e 63 65 | selectR|eference|
|00002240| 28 22 75 72 22 2c 22 53 | 45 4c 45 43 54 20 55 4e |("ur","S|ELECT UN|
|00002250| 52 45 46 45 52 45 4e 43 | 45 44 20 43 45 4c 4c 53 |REFERENC|ED CELLS|
|00002260| 22 29 20 0d 09 09 61 75 | 64 69 74 54 79 70 65 53 |") ...au|ditTypeS|
|00002270| 74 72 20 3d 20 22 55 6e | 72 65 66 65 72 65 6e 63 |tr = "Un|referenc|
|00002280| 65 64 20 43 65 6c 6c 73 | 22 0d 09 4f 54 48 45 52 |ed Cells|"..OTHER|
|00002290| 57 49 53 45 0d 09 09 61 | 75 64 69 74 54 79 70 65 |WISE...a|uditType|
|000022a0| 53 74 72 20 3d 20 22 43 | 69 72 63 75 6c 61 72 20 |Str = "C|ircular |
|000022b0| 52 65 66 65 72 65 6e 63 | 65 73 22 0d 09 09 63 69 |Referenc|es"...ci|
|000022c0| 72 63 75 6c 61 72 43 65 | 6c 6c 20 3d 20 22 41 31 |rcularCe|ll = "A1|
|000022d0| 22 0d 09 09 73 61 76 65 | 52 65 63 61 6c 63 4d 6f |"...save|RecalcMo|
|000022e0| 64 65 20 3d 20 52 45 43 | 41 4c 43 4d 4f 44 45 28 |de = REC|ALCMODE(|
|000022f0| 29 09 09 09 09 09 7b 73 | 61 76 65 20 52 65 63 61 |).....{s|ave Reca|
|00002300| 6c 63 20 4d 6f 64 65 20 | 62 65 63 61 75 73 65 20 |lc Mode |because |
|00002310| 69 74 20 77 69 6c 6c 20 | 63 68 61 6e 67 65 7d 0d |it will |change}.|
|00002320| 09 09 72 65 66 73 20 3d | 20 30 0d 09 09 41 55 54 |..refs =| 0...AUT|
|00002330| 4f 4d 41 54 49 43 20 52 | 45 43 41 4c 43 0d 09 09 |OMATIC R|ECALC...|
|00002340| 57 48 49 4c 45 20 63 69 | 72 63 75 6c 61 72 43 65 |WHILE ci|rcularCe|
|00002350| 6c 6c 20 3c 3e 20 22 22 | 0d 09 09 09 63 69 72 63 |ll <> ""|....circ|
|00002360| 75 6c 61 72 43 65 6c 6c | 20 3d 20 22 22 0d 09 09 |ularCell| = ""...|
|00002370| 09 4e 41 54 55 52 41 4c | 20 52 45 43 41 4c 43 09 |.NATURAL| RECALC.|
|00002380| 09 09 09 09 09 09 7b 63 | 68 61 6e 67 65 20 52 65 |......{c|hange Re|
|00002390| 63 61 6c 63 20 4d 6f 64 | 65 20 75 6e 74 69 6c 20 |calc Mod|e until |
|000023a0| 61 20 63 69 72 63 75 6c | 61 72 20 65 72 72 6f 72 |a circul|ar error|
|000023b0| 20 6f 63 63 75 72 73 7d | 0d 09 09 09 52 4f 57 20 | occurs}|....ROW |
|000023c0| 52 45 43 41 4c 43 0d 09 | 09 09 43 4f 4c 55 4d 4e |RECALC..|..COLUMN|
|000023d0| 20 52 45 43 41 4c 43 0d | 09 09 09 49 46 20 63 69 | RECALC.|...IF ci|
|000023e0| 72 63 75 6c 61 72 43 65 | 6c 6c 20 3c 3e 20 22 22 |rcularCe|ll <> ""|
|000023f0| 09 09 09 09 09 7b 49 66 | 20 61 20 63 69 72 63 20 |.....{If| a circ |
|00002400| 65 72 72 6f 72 20 6f 63 | 63 75 72 73 2c 20 73 61 |error oc|curs, sa|
|00002410| 76 65 20 69 74 27 73 20 | 63 65 6c 6c 20 72 65 66 |ve it's |cell ref|
|00002420| 20 61 6e 64 20 63 6f 6e | 74 65 6e 74 73 20 74 6f | and con|tents to|
|00002430| 20 61 20 63 65 6c 6c 20 | 6e 6f 74 65 7d 09 09 09 | a cell |note}...|
|00002440| 09 09 09 09 0d 09 09 09 | 09 72 65 66 73 20 3d 20 |........|.refs = |
|00002450| 72 65 66 73 20 2b 20 31 | 09 09 09 09 09 7b 62 65 |refs + 1|.....{be|
|00002460| 63 61 75 73 65 20 77 65 | 20 77 69 6c 6c 20 63 68 |cause we| will ch|
|00002470| 61 6e 67 65 20 69 74 27 | 73 20 66 6f 72 6d 75 6c |ange it'|s formul|
|00002480| 61 20 69 6e 74 6f 20 61 | 20 73 74 72 69 6e 67 20 |a into a| string |
|00002490| 73 6f 20 69 74 20 77 6f | 6e 27 74 20 70 72 6f 64 |so it wo|n't prod|
|000024a0| 75 63 65 7d 0d 09 09 09 | 09 41 44 44 20 46 49 45 |uce}....|.ADD FIE|
|000024b0| 4c 44 20 52 41 4e 47 45 | 20 52 41 4e 47 45 28 63 |LD RANGE| RANGE(c|
|000024c0| 69 72 63 75 6c 61 72 43 | 65 6c 6c 29 09 7b 61 20 |ircularC|ell).{a |
|000024d0| 63 69 72 63 75 6c 61 72 | 20 65 72 72 6f 72 20 61 |circular| error a|
|000024e0| 67 61 69 6e 20 77 68 69 | 6c 65 20 77 65 20 63 68 |gain whi|le we ch|
|000024f0| 65 63 6b 20 66 6f 72 20 | 6d 6f 72 65 2e 7d 09 09 |eck for |more.}..|
|00002500| 0d 09 09 09 09 4f 42 4a | 45 43 54 20 4e 41 4d 45 |.....OBJ|ECT NAME|
|00002510| 20 22 43 65 6c 6c 20 4e | 6f 74 65 20 22 20 26 20 | "Cell N|ote " & |
|00002520| 53 54 52 28 72 65 66 73 | 29 0d 09 09 09 09 53 48 |STR(refs|).....SH|
|00002530| 4f 57 20 43 4f 4e 54 52 | 4f 4c 20 54 49 54 4c 45 |OW CONTR|OL TITLE|
|00002540| 20 63 69 72 63 75 6c 61 | 72 43 65 6c 6c 0d 09 09 | circula|rCell...|
|00002550| 09 09 41 43 54 49 56 41 | 54 45 20 46 49 45 4c 44 |..ACTIVA|TE FIELD|
|00002560| 20 22 43 65 6c 6c 20 4e | 6f 74 65 20 22 20 26 20 | "Cell N|ote " & |
|00002570| 53 54 52 28 72 65 66 73 | 29 20 53 45 4c 45 43 54 |STR(refs|) SELECT|
|00002580| 20 46 49 45 4c 44 20 54 | 45 58 54 20 46 52 4f 4d | FIELD T|EXT FROM|
|00002590| 20 30 20 54 4f 20 30 0d | 09 09 09 09 46 49 45 4c | 0 TO 0.|....FIEL|
|000025a0| 44 20 20 4e 4f 54 45 0d | 09 09 09 09 53 45 4c 45 |D  NOTE.|....SELE|
|000025b0| 43 54 20 52 41 4e 47 45 | 20 52 41 4e 47 45 28 63 |CT RANGE| RANGE(c|
|000025c0| 69 72 63 75 6c 61 72 43 | 65 6c 6c 29 0d 09 09 09 |ircularC|ell)....|
|000025d0| 09 63 65 6c 6c 46 6f 72 | 6d 75 6c 61 20 3d 20 46 |.cellFor|mula = F|
|000025e0| 4f 52 4d 55 4c 41 54 45 | 58 54 28 52 41 4e 47 45 |ORMULATE|XT(RANGE|
|000025f0| 28 63 69 72 63 75 6c 61 | 72 43 65 6c 6c 29 29 0d |(circula|rCell)).|
|00002600| 09 09 09 09 41 43 54 49 | 56 41 54 45 20 46 49 45 |....ACTI|VATE FIE|
|00002610| 4c 44 20 22 43 65 6c 6c | 20 4e 6f 74 65 20 22 20 |LD "Cell| Note " |
|00002620| 26 20 53 54 52 28 72 65 | 66 73 29 0d 09 09 09 09 |& STR(re|fs).....|
|00002630| 53 45 4c 45 43 54 20 46 | 49 45 4c 44 20 4c 49 4e |SELECT F|IELD LIN|
|00002640| 45 20 30 0d 09 09 09 09 | 50 55 54 20 54 45 58 54 |E 0.....|PUT TEXT|
|00002650| 20 63 65 6c 6c 46 6f 72 | 6d 75 6c 61 20 26 20 43 | cellFor|mula & C|
|00002660| 48 41 52 28 31 33 29 0d | 09 09 09 09 53 45 4c 45 |HAR(13).|....SELE|
|00002670| 43 54 20 52 41 4e 47 45 | 20 52 41 4e 47 45 28 63 |CT RANGE| RANGE(c|
|00002680| 69 72 63 75 6c 61 72 43 | 65 6c 6c 29 0d 09 09 09 |ircularC|ell)....|
|00002690| 09 50 55 54 20 22 22 22 | 22 20 26 20 63 65 6c 6c |.PUT """|" & cell|
|000026a0| 46 6f 72 6d 75 6c 61 20 | 49 4e 54 4f 20 4d 41 4b |Formula |INTO MAK|
|000026b0| 45 43 45 4c 4c 28 43 4f | 4c 55 4d 4e 28 29 2c 52 |ECELL(CO|LUMN(),R|
|000026c0| 4f 57 28 29 29 0d 09 09 | 09 09 43 41 4c 4c 20 63 |OW())...|..CALL c|
|000026d0| 69 72 63 6c 65 43 65 6c | 6c 28 53 45 4c 45 43 54 |ircleCel|l(SELECT|
|000026e0| 49 4f 4e 28 31 29 2c 22 | 63 72 22 20 26 20 53 54 |ION(1),"|cr" & ST|
|000026f0| 52 28 72 65 66 73 29 29 | 0d 09 09 09 45 4e 44 20 |R(refs))|....END |
|00002700| 49 46 0d 09 09 45 4e 44 | 20 57 48 49 4c 45 0d 09 |IF...END| WHILE..|
|00002710| 09 43 41 53 45 20 73 61 | 76 65 52 65 63 61 6c 63 |.CASE sa|veRecalc|
|00002720| 4d 6f 64 65 09 09 09 09 | 09 09 09 7b 52 65 73 74 |Mode....|...{Rest|
|00002730| 6f 72 65 20 52 65 63 61 | 6c 63 20 4d 6f 64 65 20 |ore Reca|lc Mode |
|00002740| 74 6f 20 69 74 73 20 73 | 61 76 65 64 20 76 61 6c |to its s|aved val|
|00002750| 75 65 7d 0d 09 09 57 48 | 45 4e 20 30 0d 09 09 09 |ue}...WH|EN 0....|
|00002760| 4e 41 54 55 52 41 4c 20 | 52 45 43 41 4c 43 0d 09 |NATURAL |RECALC..|
|00002770| 09 57 48 45 4e 20 31 0d | 09 09 09 43 4f 4c 55 4d |.WHEN 1.|...COLUM|
|00002780| 4e 20 52 45 43 41 4c 43 | 0d 09 09 4f 54 48 45 52 |N RECALC|...OTHER|
|00002790| 57 49 53 45 0d 09 09 09 | 52 4f 57 20 52 45 43 41 |WISE....|ROW RECA|
|000027a0| 4c 43 0d 09 09 45 4e 44 | 20 43 41 53 45 0d 09 09 |LC...END| CASE...|
|000027b0| 46 4f 52 20 69 20 3d 20 | 31 20 54 4f 20 72 65 66 |FOR i = |1 TO ref|
|000027c0| 73 09 09 09 09 09 09 09 | 7b 4e 6f 77 20 72 65 73 |s.......|{Now res|
|000027d0| 74 6f 72 65 20 65 61 63 | 68 20 63 65 6c 6c 20 66 |tore eac|h cell f|
|000027e0| 72 6f 6d 20 74 68 65 20 | 76 61 6c 75 65 73 20 73 |rom the |values s|
|000027f0| 61 76 65 64 20 69 6e 20 | 69 74 73 20 63 65 6c 6c |aved in |its cell|
|00002800| 20 6e 6f 74 65 2e 20 20 | 52 65 6d 6f 76 65 20 74 | note.  |Remove t|
|00002810| 68 65 20 63 65 6c 6c 20 | 6e 6f 74 65 73 7d 0d 09 |he cell |notes}..|
|00002820| 09 09 41 43 54 49 56 41 | 54 45 20 46 49 45 4c 44 |..ACTIVA|TE FIELD|
|00002830| 20 22 43 65 6c 6c 20 4e | 6f 74 65 20 22 20 26 20 | "Cell N|ote " & |
|00002840| 53 54 52 28 69 29 20 53 | 45 4c 45 43 54 20 46 49 |STR(i) S|ELECT FI|
|00002850| 45 4c 44 20 54 45 58 54 | 20 46 52 4f 4d 20 30 20 |ELD TEXT| FROM 0 |
|00002860| 54 4f 20 30 0d 09 09 09 | 63 65 6c 6c 43 6f 6e 74 |TO 0....|cellCont|
|00002870| 65 6e 74 73 20 3d 20 43 | 54 53 54 52 49 4e 47 28 |ents = C|TSTRING(|
|00002880| 4e 55 4d 42 45 52 28 29 | 2c 30 29 0d 09 09 09 74 |NUMBER()|,0)....t|
|00002890| 68 65 43 65 6c 6c 20 3d | 20 54 49 54 4c 45 28 29 |heCell =| TITLE()|
|000028a0| 0d 09 09 09 53 45 4c 45 | 43 54 20 4f 42 4a 45 43 |....SELE|CT OBJEC|
|000028b0| 54 20 22 43 65 6c 6c 20 | 4e 6f 74 65 20 22 20 26 |T "Cell |Note " &|
|000028c0| 20 53 54 52 28 69 29 0d | 09 09 09 43 4c 45 41 52 | STR(i).|...CLEAR|
|000028d0| 0d 09 09 09 50 55 54 20 | 4c 45 46 54 28 63 65 6c |....PUT |LEFT(cel|
|000028e0| 6c 43 6f 6e 74 65 6e 74 | 73 2c 4c 45 4e 28 63 65 |lContent|s,LEN(ce|
|000028f0| 6c 6c 43 6f 6e 74 65 6e | 74 73 29 20 2d 20 31 29 |llConten|ts) - 1)|
|00002900| 20 49 4e 54 4f 20 52 41 | 4e 47 45 28 74 68 65 43 | INTO RA|NGE(theC|
|00002910| 65 6c 6c 29 0d 09 09 45 | 4e 44 20 46 4f 52 0d 09 |ell)...E|ND FOR..|
|00002920| 09 09 09 09 09 09 09 09 | 09 09 09 7b 4e 6f 77 20 |........|...{Now |
|00002930| 67 72 6f 75 70 20 61 6c | 6c 20 63 69 72 63 6c 65 |group al|l circle|
|00002940| 64 20 63 65 6c 6c 73 7d | 0d 09 09 53 45 4c 45 43 |d cells}|...SELEC|
|00002950| 54 20 4f 42 4a 45 43 54 | 20 22 63 72 31 22 0d 09 |T OBJECT| "cr1"..|
|00002960| 09 46 4f 52 20 69 20 3d | 20 32 20 54 4f 20 72 65 |.FOR i =| 2 TO re|
|00002970| 66 73 0d 09 09 09 53 45 | 4c 45 43 54 20 4d 4f 52 |fs....SE|LECT MOR|
|00002980| 45 20 4f 42 4a 45 43 54 | 20 22 63 72 22 20 26 20 |E OBJECT| "cr" & |
|00002990| 53 54 52 28 69 29 0d 09 | 09 45 4e 44 20 46 4f 52 |STR(i)..|.END FOR|
|000029a0| 0d 09 09 47 52 4f 55 50 | 0d 09 09 4f 42 4a 45 43 |...GROUP|...OBJEC|
|000029b0| 54 20 4e 41 4d 45 20 22 | 63 72 22 0d 09 45 4e 44 |T NAME "|cr"..END|
|000029c0| 20 43 41 53 45 0d 09 6d | 73 67 53 74 72 20 3d 20 | CASE..m|sgStr = |
|000029d0| 22 4e 6f 20 22 20 26 20 | 61 75 64 69 74 54 79 70 |"No " & |auditTyp|
|000029e0| 65 53 74 72 20 26 20 22 | 20 77 65 72 65 20 66 6f |eStr & "| were fo|
|000029f0| 75 6e 64 2e 20 20 22 0d | 09 49 46 20 72 65 66 73 |und.  ".|.IF refs|
|00002a00| 20 3e 20 30 0d 09 09 6d | 73 67 53 74 72 20 3d 20 | > 0...m|sgStr = |
|00002a10| 61 75 64 69 74 54 79 70 | 65 53 74 72 20 26 20 22 |auditTyp|eStr & "|
|00002a20| 20 77 65 72 65 20 66 6f | 75 6e 64 20 61 6e 64 20 | were fo|und and |
|00002a30| 68 61 76 65 20 62 65 65 | 6e 20 61 6e 6e 6f 74 61 |have bee|n annota|
|00002a40| 74 65 64 20 77 69 74 68 | 20 63 69 72 63 6c 65 73 |ted with| circles|
|00002a50| 2e 20 20 59 6f 75 20 63 | 61 6e 20 72 65 6d 6f 76 |.  You c|an remov|
|00002a60| 65 20 74 68 65 20 63 69 | 72 63 6c 65 73 20 62 79 |e the ci|rcles by|
|00002a70| 20 73 65 6c 65 63 74 69 | 6e 67 20 61 6e 64 20 64 | selecti|ng and d|
|00002a80| 65 6c 65 74 69 6e 67 20 | 61 6e 79 20 6f 6e 65 20 |eleting |any one |
|00002a90| 63 69 72 63 6c 65 2e 22 | 0d 09 09 4c 49 4e 45 20 |circle."|...LINE |
|00002aa0| 46 47 20 63 69 72 63 6c | 65 43 6f 6c 6f 72 0d 09 |FG circl|eColor..|
|00002ab0| 09 4c 49 4e 45 20 57 49 | 44 54 48 20 63 69 72 63 |.LINE WI|DTH circ|
|00002ac0| 6c 65 4c 69 6e 65 0d 09 | 45 4e 44 20 49 46 0d 09 |leLine..|END IF..|
|00002ad0| 4d 45 53 53 41 47 45 20 | 6d 73 67 53 74 72 0d 45 |MESSAGE |msgStr.E|
|00002ae0| 4e 44 20 46 55 4e 43 54 | 49 4f 4e 0d 0d 7b 2a 2a |ND FUNCT|ION..{**|
|00002af0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b10| 2a 2a 2a 2a 2a 20 73 65 | 6c 65 63 74 52 65 66 65 |***** se|lectRefe|
|00002b20| 72 65 6e 63 65 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |rence **|********|
|00002b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00002b50| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 73 65 |This fun|ction se|
|00002b60| 6c 65 63 74 73 20 61 6c | 6c 20 63 65 6c 6c 73 20 |lects al|l cells |
|00002b70| 6f 66 20 74 79 70 65 20 | 27 74 79 70 65 53 74 72 |of type |'typeStr|
|00002b80| 69 6e 67 27 2e 0d 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ing'..**|********|
|00002b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ba0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002be0| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 46 55 4e 43 54 |********|}..FUNCT|
|00002bf0| 49 4f 4e 20 73 65 6c 65 | 63 74 52 65 66 65 72 65 |ION sele|ctRefere|
|00002c00| 6e 63 65 28 74 79 70 65 | 53 74 72 69 6e 67 2c 73 |nce(type|String,s|
|00002c10| 65 6c 65 63 74 53 74 72 | 69 6e 67 29 0d 7b 57 61 |electStr|ing).{Wa|
|00002c20| 6c 6b 20 74 68 72 6f 75 | 67 68 20 65 61 63 68 20 |lk throu|gh each |
|00002c30| 65 72 72 6f 72 20 63 65 | 6c 6c 20 61 6e 64 20 6e |error ce|ll and n|
|00002c40| 61 6d 65 20 61 6e 64 20 | 63 69 72 63 6c 65 20 69 |ame and |circle i|
|00002c50| 74 7d 0d 09 44 45 46 49 | 4e 45 20 69 0d 09 53 45 |t}..DEFI|NE i..SE|
|00002c60| 4c 45 43 54 20 4f 42 4a | 45 43 54 20 74 79 70 65 |LECT OBJ|ECT type|
|00002c70| 53 74 72 69 6e 67 0d 09 | 43 4c 45 41 52 0d 09 52 |String..|CLEAR..R|
|00002c80| 55 4e 20 73 65 6c 65 63 | 74 53 74 72 69 6e 67 0d |UN selec|tString.|
|00002c90| 09 72 65 66 73 20 3d 20 | 4e 52 53 45 4c 45 43 54 |.refs = |NRSELECT|
|00002ca0| 49 4f 4e 53 28 29 0d 09 | 46 4f 52 20 69 20 3d 20 |IONS()..|FOR i = |
|00002cb0| 31 20 54 4f 20 72 65 66 | 73 0d 09 09 52 55 4e 20 |1 TO ref|s...RUN |
|00002cc0| 73 65 6c 65 63 74 53 74 | 72 69 6e 67 0d 09 09 43 |selectSt|ring...C|
|00002cd0| 41 4c 4c 20 63 69 72 63 | 6c 65 43 65 6c 6c 28 53 |ALL circ|leCell(S|
|00002ce0| 45 4c 45 43 54 49 4f 4e | 28 69 29 2c 74 79 70 65 |ELECTION|(i),type|
|00002cf0| 53 74 72 69 6e 67 20 26 | 20 53 54 52 28 69 29 29 |String &| STR(i))|
|00002d00| 0d 09 45 4e 44 20 46 4f | 52 0d 09 53 45 4c 45 43 |..END FO|R..SELEC|
|00002d10| 54 20 4f 42 4a 45 43 54 | 20 74 79 70 65 53 74 72 |T OBJECT| typeStr|
|00002d20| 69 6e 67 20 26 20 22 31 | 22 0d 09 46 4f 52 20 69 |ing & "1|"..FOR i|
|00002d30| 20 3d 20 32 20 54 4f 20 | 72 65 66 73 0d 09 09 53 | = 2 TO |refs...S|
|00002d40| 45 4c 45 43 54 20 4d 4f | 52 45 20 4f 42 4a 45 43 |ELECT MO|RE OBJEC|
|00002d50| 54 20 74 79 70 65 53 74 | 72 69 6e 67 20 26 20 53 |T typeSt|ring & S|
|00002d60| 54 52 28 69 29 0d 09 45 | 4e 44 20 46 4f 52 0d 09 |TR(i)..E|ND FOR..|
|00002d70| 47 52 4f 55 50 0d 09 4f | 42 4a 45 43 54 20 4e 41 |GROUP..O|BJECT NA|
|00002d80| 4d 45 20 74 79 70 65 53 | 74 72 69 6e 67 0d 45 4e |ME typeS|tring.EN|
|00002d90| 44 20 46 55 4e 43 54 49 | 4f 4e 0d 0d 7b 2a 2a 2a |D FUNCTI|ON..{***|
|00002da0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002db0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002dc0| 2a 2a 2a 2a 20 63 69 72 | 63 6c 65 43 65 6c 6c 20 |**** cir|cleCell |
|00002dd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002de0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002df0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 54 |********|******.T|
|00002e00| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 63 69 72 |his func|tion cir|
|00002e10| 63 6c 65 73 20 63 65 6c | 6c 73 20 66 6f 75 6e 64 |cles cel|ls found|
|00002e20| 20 62 79 20 74 68 65 20 | 66 75 6e 63 74 69 6f 6e | by the |function|
|00002e30| 20 73 65 6c 65 63 74 52 | 65 66 65 72 65 6e 63 65 | selectR|eference|
|00002e40| 2e 0d 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |..******|********|
|00002e50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ea0| 2a 2a 2a 2a 7d 0d 0d 46 | 55 4e 43 54 49 4f 4e 20 |****}..F|UNCTION |
|00002eb0| 63 69 72 63 6c 65 43 65 | 6c 6c 28 74 61 72 67 65 |circleCe|ll(targe|
|00002ec0| 74 43 65 6c 6c 2c 63 69 | 72 63 6c 65 4e 61 6d 65 |tCell,ci|rcleName|
|00002ed0| 29 0d 09 44 45 46 49 4e | 45 20 63 69 72 63 6c 65 |)..DEFIN|E circle|
|00002ee0| 52 61 6e 67 65 0d 09 43 | 41 53 45 0d 09 57 48 45 |Range..C|ASE..WHE|
|00002ef0| 4e 20 52 4f 57 4f 46 28 | 74 61 72 67 65 74 43 65 |N ROWOF(|targetCe|
|00002f00| 6c 6c 29 20 3d 20 31 20 | 41 4e 44 20 43 4f 4c 4f |ll) = 1 |AND COLO|
|00002f10| 46 28 74 61 72 67 65 74 | 43 65 6c 6c 29 20 3d 20 |F(target|Cell) = |
|00002f20| 31 0d 09 09 63 69 72 63 | 6c 65 52 61 6e 67 65 20 |1...circ|leRange |
|00002f30| 3d 20 52 41 4e 47 45 28 | 4d 41 4b 45 52 41 4e 47 |= RANGE(|MAKERANG|
|00002f40| 45 28 43 4f 4c 4f 46 28 | 74 61 72 67 65 74 43 65 |E(COLOF(|targetCe|
|00002f50| 6c 6c 29 2c 52 4f 57 4f | 46 28 74 61 72 67 65 74 |ll),ROWO|F(target|
|00002f60| 43 65 6c 6c 29 2c 43 4f | 4c 4f 46 28 74 61 72 67 |Cell),CO|LOF(targ|
|00002f70| 65 74 43 65 6c 6c 29 20 | 2b 20 31 2c 20 52 4f 57 |etCell) |+ 1, ROW|
|00002f80| 4f 46 28 74 61 72 67 65 | 74 43 65 6c 6c 29 2b 31 |OF(targe|tCell)+1|
|00002f90| 29 29 0d 09 09 41 44 44 | 20 4f 56 41 4c 20 52 41 |))...ADD| OVAL RA|
|00002fa0| 4e 47 45 20 46 52 41 43 | 28 63 69 72 63 6c 65 52 |NGE FRAC|(circleR|
|00002fb0| 61 6e 67 65 3b 30 3b 30 | 3b 36 34 3b 31 36 29 0d |ange;0;0|;64;16).|
|00002fc0| 09 57 48 45 4e 20 52 4f | 57 4f 46 28 74 61 72 67 |.WHEN RO|WOF(targ|
|00002fd0| 65 74 43 65 6c 6c 29 20 | 3d 20 31 0d 09 09 63 69 |etCell) |= 1...ci|
|00002fe0| 72 63 6c 65 52 61 6e 67 | 65 20 3d 20 52 41 4e 47 |rcleRang|e = RANG|
|00002ff0| 45 28 4d 41 4b 45 52 41 | 4e 47 45 28 43 4f 4c 4f |E(MAKERA|NGE(COLO|
|00003000| 46 28 74 61 72 67 65 74 | 43 65 6c 6c 29 20 2d 20 |F(target|Cell) - |
|00003010| 31 2c 52 4f 57 4f 46 28 | 74 61 72 67 65 74 43 65 |1,ROWOF(|targetCe|
|00003020| 6c 6c 29 2c 43 4f 4c 4f | 46 28 74 61 72 67 65 74 |ll),COLO|F(target|
|00003030| 43 65 6c 6c 29 20 2b 20 | 43 4f 4c 55 4d 4e 53 28 |Cell) + |COLUMNS(|
|00003040| 74 61 72 67 65 74 43 65 | 6c 6c 29 2c 20 52 4f 57 |targetCe|ll), ROW|
|00003050| 4f 46 28 74 61 72 67 65 | 74 43 65 6c 6c 29 20 2b |OF(targe|tCell) +|
|00003060| 20 52 4f 57 53 28 74 61 | 72 67 65 74 43 65 6c 6c | ROWS(ta|rgetCell|
|00003070| 29 29 29 0d 09 09 41 44 | 44 20 4f 56 41 4c 20 52 |)))...AD|D OVAL R|
|00003080| 41 4e 47 45 20 46 52 41 | 43 28 63 69 72 63 6c 65 |ANGE FRA|C(circle|
|00003090| 52 61 6e 67 65 3b 30 3b | 32 32 30 3b 38 35 3b 31 |Range;0;|220;85;1|
|000030a0| 35 29 0d 09 57 48 45 4e | 20 43 4f 4c 4f 46 28 74 |5)..WHEN| COLOF(t|
|000030b0| 61 72 67 65 74 43 65 6c | 6c 29 20 3d 20 31 0d 09 |argetCel|l) = 1..|
|000030c0| 09 63 69 72 63 6c 65 52 | 61 6e 67 65 20 3d 20 52 |.circleR|ange = R|
|000030d0| 41 4e 47 45 28 4d 41 4b | 45 52 41 4e 47 45 28 43 |ANGE(MAK|ERANGE(C|
|000030e0| 4f 4c 4f 46 28 74 61 72 | 67 65 74 43 65 6c 6c 29 |OLOF(tar|getCell)|
|000030f0| 2c 52 4f 57 4f 46 28 74 | 61 72 67 65 74 43 65 6c |,ROWOF(t|argetCel|
|00003100| 6c 29 20 2d 20 31 2c 43 | 4f 4c 4f 46 28 74 61 72 |l) - 1,C|OLOF(tar|
|00003110| 67 65 74 43 65 6c 6c 29 | 20 2b 20 43 4f 4c 55 4d |getCell)| + COLUM|
|00003120| 4e 53 28 74 61 72 67 65 | 74 43 65 6c 6c 29 2c 20 |NS(targe|tCell), |
|00003130| 52 4f 57 4f 46 28 74 61 | 72 67 65 74 43 65 6c 6c |ROWOF(ta|rgetCell|
|00003140| 29 20 2b 20 52 4f 57 53 | 28 74 61 72 67 65 74 43 |) + ROWS|(targetC|
|00003150| 65 6c 6c 29 29 29 0d 09 | 09 41 44 44 20 4f 56 41 |ell)))..|.ADD OVA|
|00003160| 4c 20 52 41 4e 47 45 20 | 46 52 41 43 28 63 69 72 |L RANGE |FRAC(cir|
|00003170| 63 6c 65 52 61 6e 67 65 | 3b 32 33 34 3b 37 3b 34 |cleRange|;234;7;4|
|00003180| 33 3b 33 32 29 0d 09 4f | 54 48 45 52 57 49 53 45 |3;32)..O|THERWISE|
|00003190| 0d 09 09 63 69 72 63 6c | 65 52 61 6e 67 65 20 3d |...circl|eRange =|
|000031a0| 20 52 41 4e 47 45 28 4d | 41 4b 45 52 41 4e 47 45 | RANGE(M|AKERANGE|
|000031b0| 28 43 4f 4c 4f 46 28 74 | 61 72 67 65 74 43 65 6c |(COLOF(t|argetCel|
|000031c0| 6c 29 20 2d 20 31 2c 52 | 4f 57 4f 46 28 74 61 72 |l) - 1,R|OWOF(tar|
|000031d0| 67 65 74 43 65 6c 6c 29 | 20 2d 20 31 2c 43 4f 4c |getCell)| - 1,COL|
|000031e0| 4f 46 28 74 61 72 67 65 | 74 43 65 6c 6c 29 20 2b |OF(targe|tCell) +|
|000031f0| 20 43 4f 4c 55 4d 4e 53 | 28 74 61 72 67 65 74 43 | COLUMNS|(targetC|
|00003200| 65 6c 6c 29 2c 20 52 4f | 57 4f 46 28 74 61 72 67 |ell), RO|WOF(targ|
|00003210| 65 74 43 65 6c 6c 29 20 | 2b 20 52 4f 57 53 28 74 |etCell) |+ ROWS(t|
|00003220| 61 72 67 65 74 43 65 6c | 6c 29 29 29 0d 09 09 41 |argetCel|l)))...A|
|00003230| 44 44 20 4f 56 41 4c 20 | 52 41 4e 47 45 20 46 52 |DD OVAL |RANGE FR|
|00003240| 41 43 28 63 69 72 63 6c | 65 52 61 6e 67 65 3b 32 |AC(circl|eRange;2|
|00003250| 30 38 3b 32 34 35 3b 38 | 38 3b 32 30 29 0d 09 45 |08;245;8|8;20)..E|
|00003260| 4e 44 20 43 41 53 45 0d | 09 4f 42 4a 45 43 54 20 |ND CASE.|.OBJECT |
|00003270| 4e 41 4d 45 20 63 69 72 | 63 6c 65 4e 61 6d 65 0d |NAME cir|cleName.|
|00003280| 09 46 49 4c 4c 20 50 41 | 54 54 45 52 4e 20 30 0d |.FILL PA|TTERN 0.|
|00003290| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|000032a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032c0| 2a 2a 2a 2a 2a 2a 20 45 | 52 52 4f 52 20 48 61 6e |****** E|RROR Han|
|000032d0| 64 6c 65 72 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |dler ***|********|
|000032e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003300| 0d 54 68 69 73 20 68 61 | 6e 64 6c 65 72 20 74 72 |.This ha|ndler tr|
|00003310| 61 70 73 20 65 72 72 6f | 72 73 20 61 6e 64 20 61 |aps erro|rs and a|
|00003320| 6c 6c 6f 77 73 20 6d 65 | 20 74 6f 20 68 61 6e 64 |llows me| to hand|
|00003330| 6c 65 20 74 68 65 6d 20 | 77 69 74 68 6f 75 74 20 |le them |without |
|00003340| 61 6c 65 72 74 69 6e 67 | 20 74 68 65 20 75 73 65 |alerting| the use|
|00003350| 72 2e 20 20 49 6e 20 70 | 61 72 74 69 63 75 6c 61 |r.  In p|articula|
|00003360| 72 2c 20 0d 69 66 20 61 | 20 43 69 72 63 75 6c 61 |r, .if a| Circula|
|00003370| 72 20 45 72 72 6f 72 20 | 6f 63 63 75 72 73 2c 20 |r Error |occurs, |
|00003380| 73 61 76 65 20 74 68 65 | 20 63 65 6c 6c 20 72 65 |save the| cell re|
|00003390| 66 65 72 65 6e 63 65 2e | 0d 2a 2a 2a 2a 2a 2a 2a |ference.|.*******|
|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 7d 0d 0d 4f 4e |********|***}..ON|
|00003400| 20 45 52 52 4f 52 0d 09 | 44 45 46 49 4e 45 20 65 | ERROR..|DEFINE e|
|00003410| 72 72 6f 72 53 74 72 69 | 6e 67 0d 09 65 72 72 6f |rrorStri|ng..erro|
|00003420| 72 53 74 72 69 6e 67 20 | 3d 20 53 45 72 72 6f 72 |rString |= SError|
|00003430| 28 29 0d 09 6e 6f 45 72 | 72 20 3d 20 46 41 4c 53 |()..noEr|r = FALS|
|00003440| 45 28 29 0d 09 49 46 20 | 43 4f 4e 54 41 49 4e 53 |E()..IF |CONTAINS|
|00003450| 28 65 72 72 6f 72 53 74 | 72 69 6e 67 2c 22 43 69 |(errorSt|ring,"Ci|
|00003460| 72 63 75 6c 61 72 22 29 | 20 4f 52 20 28 4c 45 52 |rcular")| OR (LER|
|00003470| 52 4f 52 28 29 20 3d 20 | 31 32 38 31 29 0d 09 09 |ROR() = |1281)...|
|00003480| 63 69 72 63 75 6c 61 72 | 43 65 6c 6c 20 3d 20 52 |circular|Cell = R|
|00003490| 49 47 48 54 28 65 72 72 | 6f 72 53 74 72 69 6e 67 |IGHT(err|orString|
|000034a0| 2c 4c 45 4e 28 65 72 72 | 6f 72 53 74 72 69 6e 67 |,LEN(err|orString|
|000034b0| 29 20 2d 20 28 46 49 4e | 44 28 22 63 65 6c 6c 20 |) - (FIN|D("cell |
|000034c0| 22 2c 65 72 72 6f 72 53 | 74 72 69 6e 67 2c 31 29 |",errorS|tring,1)|
|000034d0| 20 2b 20 34 29 29 0d 09 | 09 63 69 72 63 75 6c 61 | + 4))..|.circula|
|000034e0| 72 43 65 6c 6c 20 3d 20 | 4c 45 46 54 28 63 69 72 |rCell = |LEFT(cir|
|000034f0| 63 75 6c 61 72 43 65 6c | 6c 2c 4c 45 4e 28 63 69 |cularCel|l,LEN(ci|
|00003500| 72 63 75 6c 61 72 43 65 | 6c 6c 29 20 2d 20 31 29 |rcularCe|ll) - 1)|
|00003510| 0d 09 45 4c 53 45 0d 09 | 09 49 46 20 28 65 72 72 |..ELSE..|.IF (err|
|00003520| 6f 72 53 74 72 69 6e 67 | 20 3c 3e 20 22 53 65 6c |orString| <> "Sel|
|00003530| 65 63 74 69 6f 6e 20 77 | 61 73 20 75 6e 73 75 63 |ection w|as unsuc|
|00003540| 63 65 73 73 66 75 6c 2e | 22 29 20 41 4e 44 20 28 |cessful.|") AND (|
|00003550| 4c 45 52 52 4f 52 28 29 | 20 3c 3e 20 36 30 29 0d |LERROR()| <> 60).|
|00003560| 09 09 09 41 4c 45 52 54 | 20 32 20 53 45 72 72 6f |...ALERT| 2 SErro|
|00003570| 72 28 29 0d 09 09 45 4e | 44 20 49 46 0d 09 45 4e |r()...EN|D IF..EN|
|00003580| 44 20 49 46 0d 45 4e 44 | 20 45 52 52 4f 52 0d 00 |D IF.END| ERROR..|
|00003590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003600| 00 00 01 00 00 00 03 9c | 00 00 02 9c 00 00 00 8a |........|........|
|00003610| 4f 52 28 29 20 3c 3e 20 | 36 30 29 0d 09 09 09 41 |OR() <> |60)....A|
|00003620| 4c 45 52 54 20 32 20 53 | 45 72 72 6f 72 28 29 0d |LERT 2 S|Error().|
|00003630| 05 41 75 64 69 74 02 00 | 00 00 52 73 53 63 52 73 |.Audit..|..RsScRs|
|00003640| 6c 76 01 00 00 00 00 00 | 00 00 00 00 09 0e 00 00 |lv......|........|
|00003650| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 00 00 00 |..RsScRs|lv......|
|00003660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003670| 00 00 a4 b0 59 9c 00 00 | 35 10 00 00 04 26 01 1a |....Y...|5....&..|
|00003680| 03 01 fe 93 18 00 00 00 | 00 00 00 f0 3f 39 f2 69 |........|....?9.i|
|00003690| 00 1a 03 01 fe 92 2b 00 | 00 00 00 00 00 f0 3f 1a |......+.|......?.|
|000036a0| 03 01 fe 93 1a 03 01 fe | 92 2a 00 00 00 00 00 00 |........|.*......|
|000036b0| f0 3f 1a 03 01 fe 93 2a | 00 00 00 00 00 00 f0 3f |.?.....*|.......?|
|000036c0| d8 d3 f4 03 03 fd 2f 15 | 00 07 01 2a 1a 03 03 18 |....../.|...*....|
|000036d0| 00 00 00 00 00 00 00 00 | 18 00 00 00 00 00 80 6b |........|.......k|
|000036e0| 40 18 00 00 00 00 00 40 | 55 40 18 00 00 00 00 00 |@......@|U@......|
|000036f0| 00 2e 40 e3 ff 1d b1 00 | 1a 03 01 fe 92 18 00 00 |..@.....|........|
|00003700| 00 00 01 98 00 12 00 00 | 00 00 00 80 00 99 00 94 |........|........|
|00003710| 00 f0 04 02 4f 4b 00 00 | 00 00 00 a2 00 99 00 b6 |....OK..|........|
|00003720| 00 f0 04 06 43 61 6e 63 | 65 6c 00 00 00 00 00 12 |....Canc|el......|
|00003730| 00 17 00 72 00 f1 40 02 | 01 f4 00 00 00 00 00 1f |...r..@.|........|
|00003740| 00 1e 00 6e 00 da 40 02 | 01 f4 00 00 00 00 00 27 |...n..@.|.......'|
|00003750| 00 21 00 35 00 92 06 0b | 45 72 72 6f 72 20 43 65 |.!.5....|Error Ce|
|00003760| 6c 6c 73 72 00 00 00 00 | 00 30 00 21 00 3f 00 dd |llsr....|.0.!.?..|
|00003770| 06 19 52 65 66 65 72 65 | 6e 63 65 73 20 74 6f 20 |..Refere|nces to |
|00003780| 42 6c 61 6e 6b 20 43 65 | 6c 6c 73 00 00 00 00 00 |Blank Ce|lls.....|
|00003790| 00 3f 00 21 00 4f 00 c0 | 06 0c 4c 6f 63 6b 65 64 |.?.!.O..|..Locked|
|000037a0| 20 43 65 6c 6c 73 00 00 | 00 00 00 4c 00 21 00 5c | Cells..|...L.!.\|
|000037b0| 00 be 06 12 55 6e 72 65 | 66 65 72 65 6e 63 65 64 |....Unre|ferenced|
|000037c0| 20 43 65 6c 6c 73 00 00 | 00 00 00 59 00 21 00 6e | Cells..|...Y.!.n|
|000037d0| 00 b9 06 13 43 69 72 63 | 75 6c 61 72 20 52 65 66 |....Circ|ular Ref|
|000037e0| 65 72 65 6e 63 65 73 00 | 00 00 00 00 00 7e 00 17 |erences.|.....~..|
|000037f0| 00 9e 00 88 c0 02 01 f4 | 00 00 00 00 00 89 00 1e |........|........|
|00003800| 00 99 00 2e c0 02 01 94 | 00 00 00 00 00 89 00 2f |........|......./|
|00003810| 00 99 00 3f c0 02 01 92 | 00 00 00 00 00 89 00 49 |...?....|.......I|
|00003820| 00 99 00 82 c0 02 01 f4 | 00 00 00 00 00 77 00 20 |........|.....w. |
|00003830| 00 86 00 2b c0 02 4e 21 | 00 00 00 00 00 78 00 2b |...+..N!|.....x.+|
|00003840| 00 86 00 3f c0 02 27 13 | 00 00 00 00 00 0b 00 20 |...?..'.|....... |
|00003850| 00 1c 00 67 88 0c 20 43 | 69 72 63 6c 65 20 41 6c |...g.. C|ircle Al|
|00003860| 6c 3a 00 00 00 00 00 74 | 00 20 00 84 00 26 88 00 |l:.....t|. ...&..|
|00003870| 00 00 00 00 00 a2 00 17 | 00 b6 00 88 04 0e 52 65 |........|......Re|
|00003880| 6d 6f 76 65 20 43 69 72 | 63 6c 65 73 00 00 00 00 |move Cir|cles....|
|00003890| 00 7e 00 8f 00 b6 00 90 | c0 02 01 f4 00 00 00 1a |.~......|........|
|000038a0| ff ff ff ff 00 c6 01 03 | 00 00 00 00 00 00 00 00 |........|........|
|000038b0| 00 00 4e 20 05 41 75 64 | 69 74 00 00 00 10 0f 43 |..N .Aud|it.....C|
|000038c0| 6c 61 72 69 73 20 52 65 | 73 6f 6c 76 65 aa 00 00 |laris Re|solve...|
|000038d0| 00 73 00 73 01 e3 00 0b | 01 f1 00 1f 11 01 a0 00 |.s.s....|........|
|000038e0| 82 01 00 0a 00 00 00 00 | 02 d0 02 40 90 00 04 01 |........|...@....|
|000038f0| e3 00 08 01 f1 00 20 01 | e3 00 0b 01 f1 00 1f 01 |...... .|........|
|00003900| e3 00 0b 01 f1 00 1f 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003910| 00 00 3f 00 00 00 c0 c0 | 00 01 00 20 00 02 00 10 |..?.....|... ....|
|00003920| 00 02 00 10 00 02 00 10 | 00 02 00 10 00 01 00 20 |........|....... |
|00003930| 00 00 c0 c0 00 00 3f 00 | 00 00 00 00 00 00 00 00 |......?.|........|
|00003940| 00 a0 00 83 ff 00 00 00 | 53 00 53 00 08 00 0a 00 |........|S.S.....|
|00003950| 17 00 15 11 01 01 00 0a | 00 00 00 00 00 20 00 20 |........|..... . |
|00003960| 90 00 02 00 08 00 0a 00 | 17 00 15 00 08 00 0a 00 |........|........|
|00003970| 17 00 15 00 08 00 0a 00 | 17 00 15 00 01 03 e9 02 |........|........|
|00003980| 60 02 60 02 63 02 6e 02 | 69 02 60 02 60 03 f2 01 |`.`.c.n.|i.`.`...|
|00003990| 40 01 52 01 cd 00 90 00 | 8c ff 94 ff 00 00 01 00 |@.R.....|........|
|000039a0| 00 00 03 9c 00 00 02 9c | 00 00 00 8a 00 e5 75 98 |........|......u.|
|000039b0| 04 0c 00 00 00 1c 00 7a | 00 03 44 49 54 4c 00 00 |.......z|..DITL..|
|000039c0| 00 22 44 4c 4f 47 00 00 | 00 2e 53 54 52 20 00 00 |."DLOG..|..STR ..|
|000039d0| 00 3a 50 49 43 54 00 01 | 00 46 4e 20 00 00 20 00 |.:PICT..|.FN .. .|
|000039e0| 00 00 00 00 00 00 4e 20 | 00 06 20 00 01 9c 00 00 |......N |.. .....|
|000039f0| 00 00 bf f4 ff ff 00 00 | 01 ba 00 00 00 00 27 13 |........|......'.|
|00003a00| ff ff 14 00 01 ce 00 e6 | 1a 6c 4e 21 00 0c 14 00 |........|.lN!....|
|00003a10| 02 45 00 e6 1a 68 05 41 | 75 64 69 74 05 41 75 64 |.E...h.A|udit.Aud|
|00003a20| 69 74 03 70 65 6e 00 00 | 00 00 00 00 00 00 00 00 |it.pen..|........|
|00003a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+