home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1993-02-22 | 130.7 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 65 00 61 00 29 01 00 00 | 5e 20 8c 00 00 00 00 01 |e.a.)...|^ ......|
|00000010| 00 01 00 11 00 21 00 69 | 00 b3 00 e1 00 1e 01 5f |.....!.i|......._|
|00000020| 01 8e 01 9e 01 d1 01 12 | 02 4e 02 81 02 b0 02 fe |........|.N......|
|00000030| 02 32 03 71 03 a9 03 d7 | 03 00 04 49 04 84 04 c3 |.2.q....|...I....|
|00000040| 04 1c 05 4c 05 7e 05 bd | 05 f4 05 33 06 8a 06 b4 |...L.~..|...3....|
|00000050| 06 dd 06 20 07 4f 07 96 | 07 e2 07 18 08 7d 08 d9 |... .O..|.....}..|
|00000060| 08 38 09 93 09 c7 09 f5 | 09 3f 0a 9b 0a d5 0a fd |.8......|.?......|
|00000070| 0a 5d 0b af 0b ef 0b 2d | 0c 6a 0c cf 0c fb 0c 21 |.].....-|.j.....!|
|00000080| 0d 9e 0d e0 0d 37 0e 6a | 0e d0 0e 2a 0f 5b 0f a0 |.....7.j|...*.[..|
|00000090| 0f d5 0f 10 10 4f 10 80 | 10 b5 10 f0 10 0e 11 3e |.....O..|.......>|
|000000a0| 11 8f 11 ec 11 17 12 3e | 12 7f 12 cf 12 1e 13 6c |.......>|.......l|
|000000b0| 13 92 13 ca 13 04 14 2b | 14 52 14 64 14 76 14 9d |.......+|.R.d.v..|
|000000c0| 14 c0 14 d2 14 0a 15 2f | 15 66 15 85 15 9c 15 fc |......./|.f......|
|000000d0| 15 43 16 be 16 12 17 13 | 17 3f 17 79 17 ad 17 ef |.C......|.?.y....|
|000000e0| 17 34 18 7d 18 c7 18 f9 | 18 1f 19 72 19 b7 19 fb |.4.}....|...r....|
|000000f0| 19 3f 1a 77 1a b2 1a ee | 1a 32 1b 42 1b 84 1b be |.?.w....|.2.B....|
|00000100| 1b fe 1b 3c 1c 63 1c 91 | 1c cd 1c 0c 1d 50 1d a0 |...<.c..|.....P..|
|00000110| 1d ca 1d 02 1e 21 1e 59 | 1e 8d 1e a9 1e de 1e 22 |.....!.Y|......."|
|00000120| 1f 6e 1f e8 1f 19 20 5d | 20 00 49 6e 74 65 72 6e |.n.... ]| .Intern|
|00000130| 61 6c 20 65 72 72 6f 72 | 2e 00 49 6e 74 65 72 6e |al error|..Intern|
|00000140| 61 6c 20 65 72 72 6f 72 | 2e 00 59 6f 75 20 68 61 |al error|..You ha|
|00000150| 76 65 20 72 65 61 63 68 | 65 64 20 74 68 65 20 6d |ve reach|ed the m|
|00000160| 61 78 69 6d 75 6d 20 6f | 66 20 25 6e 75 6d 62 65 |aximum o|f %numbe|
|00000170| 72 25 20 77 6f 72 6b 73 | 68 65 65 74 73 20 61 6c |r% works|heets al|
|00000180| 6c 6f 77 65 64 20 69 6e | 20 61 20 6d 6f 64 65 6c |lowed in| a model|
|00000190| 2e 00 59 6f 75 20 68 61 | 76 65 20 72 65 61 63 68 |..You ha|ve reach|
|000001a0| 65 64 20 74 68 65 20 6d | 61 78 69 6d 75 6d 20 6e |ed the m|aximum n|
|000001b0| 75 6d 62 65 72 20 6f 66 | 20 63 61 74 65 67 6f 72 |umber of| categor|
|000001c0| 69 65 73 20 61 6c 6c 6f | 77 65 64 20 69 6e 20 61 |ies allo|wed in a|
|000001d0| 20 77 6f 72 6b 73 68 65 | 65 74 2e 00 54 68 65 20 | workshe|et..The |
|000001e0| 6e 61 6d 65 20 27 25 6e | 61 6d 65 25 27 20 6d 61 |name '%n|ame%' ma|
|000001f0| 74 63 68 65 73 20 6d 6f | 72 65 20 74 68 61 6e 20 |tches mo|re than |
|00000200| 6f 6e 65 20 69 74 65 6d | 2e 00 54 68 65 20 6e 61 |one item|..The na|
|00000210| 6d 65 20 27 25 6e 61 6d | 65 25 27 20 6d 61 74 63 |me '%nam|e%' matc|
|00000220| 68 65 73 20 6e 6f 20 69 | 74 65 6d 73 20 69 6e 20 |hes no i|tems in |
|00000230| 74 68 65 20 63 75 72 72 | 65 6e 74 20 77 6f 72 6b |the curr|ent work|
|00000240| 73 68 65 65 74 2e 00 54 | 68 65 20 69 74 65 6d 20 |sheet..T|he item |
|00000250| 6e 61 6d 65 73 20 27 25 | 69 74 65 6d 25 27 20 61 |names '%|item%' a|
|00000260| 6e 64 20 27 25 6e 61 6d | 65 25 27 20 61 72 65 20 |nd '%nam|e%' are |
|00000270| 66 72 6f 6d 20 74 68 65 | 20 73 61 6d 65 20 63 61 |from the| same ca|
|00000280| 74 65 67 6f 72 79 2e 00 | 59 6f 75 20 63 61 6e 6e |tegory..|You cann|
|00000290| 6f 74 20 64 65 6c 65 74 | 65 20 61 6c 6c 20 74 68 |ot delet|e all th|
|000002a0| 65 20 69 74 65 6d 73 20 | 69 6e 20 61 20 63 61 74 |e items |in a cat|
|000002b0| 65 67 6f 72 79 2e 00 49 | 6e 74 65 72 6e 61 6c 20 |egory..I|nternal |
|000002c0| 65 72 72 6f 72 2e 00 59 | 6f 75 20 63 61 6e 6e 6f |error..Y|ou canno|
|000002d0| 74 20 61 64 64 20 61 6e | 79 20 6d 6f 72 65 20 69 |t add an|y more i|
|000002e0| 74 65 6d 73 20 74 6f 20 | 74 68 69 73 20 74 69 6d |tems to |this tim|
|000002f0| 65 20 73 65 72 69 65 73 | 2e 00 59 6f 75 20 63 61 |e series|..You ca|
|00000300| 6e 20 61 64 64 20 69 74 | 65 6d 73 20 61 74 20 74 |n add it|ems at t|
|00000310| 68 65 20 62 65 67 69 6e | 6e 69 6e 67 20 6f 72 20 |he begin|ning or |
|00000320| 65 6e 64 20 6f 66 20 61 | 20 74 69 6d 65 20 73 65 |end of a| time se|
|00000330| 72 69 65 73 20 6f 6e 6c | 79 2e 00 59 6f 75 20 63 |ries onl|y..You c|
|00000340| 61 6e 6e 6f 74 20 64 65 | 6c 65 74 65 20 61 6e 20 |annot de|lete an |
|00000350| 69 74 65 6d 20 66 72 6f | 6d 20 74 68 65 20 6d 69 |item fro|m the mi|
|00000360| 64 64 6c 65 20 6f 66 20 | 61 20 74 69 6d 65 20 73 |ddle of |a time s|
|00000370| 65 72 69 65 73 2e 00 49 | 6d 70 72 6f 76 20 63 61 |eries..I|mprov ca|
|00000380| 6e 6e 6f 74 20 6f 70 65 | 6e 20 74 68 65 20 66 69 |nnot ope|n the fi|
|00000390| 6c 65 20 62 65 63 61 75 | 73 65 20 69 74 20 69 73 |le becau|se it is|
|000003a0| 20 64 61 6d 61 67 65 64 | 2e 00 59 6f 75 20 68 69 | damaged|..You hi|
|000003b0| 64 20 74 6f 6f 20 6d 61 | 6e 79 20 69 74 65 6d 73 |d too ma|ny items|
|000003c0| 2e 20 49 6d 70 72 6f 76 | 20 72 65 73 65 74 20 74 |. Improv| reset t|
|000003d0| 68 65 20 76 69 65 77 2e | 00 54 68 65 72 65 20 61 |he view.|.There a|
|000003e0| 72 65 20 74 6f 6f 20 6d | 61 6e 79 20 69 74 65 6d |re too m|any item|
|000003f0| 73 20 69 6e 20 74 68 65 | 20 72 6f 77 2c 20 63 6f |s in the| row, co|
|00000400| 6c 75 6d 6e 2c 20 6f 72 | 20 70 61 67 65 2e 20 53 |lumn, or| page. S|
|00000410| 6f 6d 65 20 77 69 6c 6c | 20 6e 6f 74 20 62 65 20 |ome will| not be |
|00000420| 73 68 6f 77 6e 2e 00 59 | 6f 75 20 63 61 6e 6e 6f |shown..Y|ou canno|
|00000430| 74 20 64 65 6c 65 74 65 | 20 74 68 65 20 6f 6e 6c |t delete| the onl|
|00000440| 79 20 63 61 74 65 67 6f | 72 79 20 69 6e 20 61 20 |y catego|ry in a |
|00000450| 77 6f 72 6b 73 68 65 65 | 74 2e 00 59 6f 75 20 63 |workshee|t..You c|
|00000460| 61 6e 6e 6f 74 20 64 65 | 6c 65 74 65 20 61 20 63 |annot de|lete a c|
|00000470| 61 74 65 67 6f 72 79 20 | 74 68 61 74 20 63 6f 6e |ategory |that con|
|00000480| 74 61 69 6e 73 20 6d 6f | 72 65 20 74 68 61 6e 20 |tains mo|re than |
|00000490| 6f 6e 65 20 69 74 65 6d | 2e 00 44 65 6c 65 74 69 |one item|..Deleti|
|000004a0| 6e 67 20 74 68 65 20 63 | 61 74 65 67 6f 72 79 20 |ng the c|ategory |
|000004b0| 77 69 6c 6c 20 62 72 65 | 61 6b 20 66 6f 72 6d 75 |will bre|ak formu|
|000004c0| 6c 61 73 20 69 6e 20 74 | 68 65 20 6d 6f 64 65 6c |las in t|he model|
|000004d0| 2e 00 54 68 65 20 6e 61 | 6d 65 20 79 6f 75 20 65 |..The na|me you e|
|000004e0| 6e 74 65 72 65 64 20 68 | 61 73 20 74 6f 6f 20 6d |ntered h|as too m|
|000004f0| 61 6e 79 20 63 68 61 72 | 61 63 74 65 72 73 2e 00 |any char|acters..|
|00000500| 41 20 6e 61 6d 65 20 6d | 75 73 74 20 68 61 76 65 |A name m|ust have|
|00000510| 20 61 74 20 6c 65 61 73 | 74 20 6f 6e 65 20 63 68 | at leas|t one ch|
|00000520| 61 72 61 63 74 65 72 2e | 00 59 6f 75 20 63 61 6e |aracter.|.You can|
|00000530| 6e 6f 74 20 75 73 65 20 | 61 20 63 6f 6c 6f 6e 2c |not use |a colon,|
|00000540| 20 61 20 74 61 62 20 63 | 68 61 72 61 63 74 65 72 | a tab c|haracter|
|00000550| 2c 20 6f 72 20 61 20 63 | 61 72 72 69 61 67 65 20 |, or a c|arriage |
|00000560| 72 65 74 75 72 6e 20 69 | 6e 20 61 20 6e 61 6d 65 |return i|n a name|
|00000570| 2e 00 54 68 65 20 6e 61 | 6d 65 20 27 25 6e 61 6d |..The na|me '%nam|
|00000580| 65 25 27 20 68 61 73 20 | 61 6c 72 65 61 64 79 20 |e%' has |already |
|00000590| 62 65 65 6e 20 75 73 65 | 64 20 69 6e 20 74 68 69 |been use|d in thi|
|000005a0| 73 20 77 6f 72 6b 73 68 | 65 65 74 2e 00 59 6f 75 |s worksh|eet..You|
|000005b0| 20 63 61 6e 6e 6f 74 20 | 73 70 65 63 69 66 79 20 | cannot |specify |
|000005c0| 61 6e 20 69 74 65 6d 20 | 66 72 6f 6d 20 74 68 61 |an item |from tha|
|000005d0| 74 20 63 61 74 65 67 6f | 72 79 20 69 6e 20 74 68 |t catego|ry in th|
|000005e0| 69 73 20 63 6f 6e 74 65 | 78 74 2e 00 4f 6e 6c 79 |is conte|xt..Only|
|000005f0| 20 61 20 67 72 6f 75 70 | 20 6f 72 20 63 61 74 65 | a group| or cate|
|00000600| 67 6f 72 79 20 6e 61 6d | 65 20 63 61 6e 20 70 72 |gory nam|e can pr|
|00000610| 65 63 65 64 65 20 62 72 | 61 63 6b 65 74 65 64 20 |ecede br|acketed |
|00000620| 72 65 63 75 72 72 65 6e | 63 65 20 6b 65 79 77 6f |recurren|ce keywo|
|00000630| 72 64 73 20 61 6e 64 2f | 6f 72 20 69 6e 74 65 67 |rds and/|or integ|
|00000640| 65 72 73 2e 00 4e 6f 20 | 69 74 65 6d 20 63 6f 72 |ers..No |item cor|
|00000650| 72 65 73 70 6f 6e 64 73 | 20 74 6f 20 74 68 65 20 |responds| to the |
|00000660| 76 61 6c 75 65 20 79 6f | 75 20 73 70 65 63 69 66 |value yo|u specif|
|00000670| 69 65 64 2e 00 54 68 65 | 20 65 78 70 72 65 73 73 |ied..The| express|
|00000680| 69 6f 6e 20 77 69 74 68 | 69 6e 20 73 71 75 61 72 |ion with|in squar|
|00000690| 65 20 62 72 61 63 6b 65 | 74 73 20 69 73 20 69 6e |e bracke|ts is in|
|000006a0| 76 61 6c 69 64 2e 00 59 | 6f 75 20 61 72 65 20 61 |valid..Y|ou are a|
|000006b0| 62 6f 75 74 20 74 6f 20 | 64 65 6c 65 74 65 20 74 |bout to |delete t|
|000006c0| 68 65 20 77 6f 72 6b 73 | 68 65 65 74 20 27 25 6e |he works|heet '%n|
|000006d0| 61 6d 65 25 27 20 66 72 | 6f 6d 20 74 68 65 20 6d |ame%' fr|om the m|
|000006e0| 6f 64 65 6c 2e 00 54 68 | 65 20 6e 61 6d 65 20 27 |odel..Th|e name '|
|000006f0| 25 6e 61 6d 65 25 27 20 | 68 61 73 20 61 6c 72 65 |%name%' |has alre|
|00000700| 61 64 79 20 62 65 65 6e | 20 75 73 65 64 20 69 6e |ady been| used in|
|00000710| 20 74 68 69 73 20 6d 6f | 64 65 6c 2e 00 41 6c 6c | this mo|del..All|
|00000720| 20 74 68 65 20 69 74 65 | 6d 73 20 69 6e 20 74 68 | the ite|ms in th|
|00000730| 65 20 73 65 6c 65 63 74 | 69 6f 6e 20 6d 75 73 74 |e select|ion must|
|00000740| 20 62 65 20 66 72 6f 6d | 20 74 68 65 20 73 61 6d | be from| the sam|
|00000750| 65 20 63 61 74 65 67 6f | 72 79 2e 00 44 65 6c 65 |e catego|ry..Dele|
|00000760| 74 69 6e 67 20 74 68 65 | 73 65 20 69 74 65 6d 73 |ting the|se items|
|00000770| 20 77 69 6c 6c 20 70 65 | 72 6d 61 6e 65 6e 74 6c | will pe|rmanentl|
|00000780| 79 20 72 65 6d 6f 76 65 | 20 74 68 65 20 63 6f 6e |y remove| the con|
|00000790| 74 65 6e 74 73 20 6f 66 | 20 63 65 6c 6c 73 20 66 |tents of| cells f|
|000007a0| 72 6f 6d 20 74 68 65 20 | 77 6f 72 6b 73 68 65 65 |rom the |workshee|
|000007b0| 74 2e 00 54 68 69 73 20 | 6f 70 65 72 61 74 69 6f |t..This |operatio|
|000007c0| 6e 20 77 69 6c 6c 20 64 | 65 73 74 72 6f 79 20 61 |n will d|estroy a|
|000007d0| 20 63 65 6c 6c 20 76 61 | 6c 75 65 2e 00 54 68 69 | cell va|lue..Thi|
|000007e0| 73 20 6f 70 65 72 61 74 | 69 6f 6e 20 77 69 6c 6c |s operat|ion will|
|000007f0| 20 64 65 73 74 72 6f 79 | 20 63 65 6c 6c 20 76 61 | destroy| cell va|
|00000800| 6c 75 65 73 2e 00 44 65 | 6c 65 74 69 6e 67 20 74 |lues..De|leting t|
|00000810| 68 65 20 73 65 6c 65 63 | 74 65 64 20 69 74 65 6d |he selec|ted item|
|00000820| 73 20 77 69 6c 6c 20 62 | 72 65 61 6b 20 73 6f 6d |s will b|reak som|
|00000830| 65 20 66 6f 72 6d 75 6c | 61 73 20 69 6e 20 74 68 |e formul|as in th|
|00000840| 65 20 6d 6f 64 65 6c 2e | 00 41 6e 20 69 74 65 6d |e model.|.An item|
|00000850| 20 6e 61 6d 65 20 69 73 | 20 61 6c 72 65 61 64 79 | name is| already|
|00000860| 20 64 65 66 69 6e 65 64 | 20 61 74 20 74 68 69 73 | defined| at this|
|00000870| 20 6c 65 76 65 6c 2e 00 | 54 68 65 20 73 61 6d 65 | level..|The same|
|00000880| 20 69 74 65 6d 20 6e 61 | 6d 65 20 69 73 20 64 65 | item na|me is de|
|00000890| 66 69 6e 65 64 20 69 6e | 20 6d 6f 72 65 20 74 68 |fined in| more th|
|000008a0| 61 6e 20 6f 6e 65 20 6f | 66 20 74 68 65 20 73 65 |an one o|f the se|
|000008b0| 6c 65 63 74 65 64 20 67 | 72 6f 75 70 73 2e 00 43 |lected g|roups..C|
|000008c0| 65 6c 6c 20 76 61 6c 75 | 65 73 20 74 68 61 74 20 |ell valu|es that |
|000008d0| 61 72 65 20 63 61 6c 63 | 75 6c 61 74 65 64 20 62 |are calc|ulated b|
|000008e0| 79 20 66 6f 72 6d 75 6c | 61 73 20 77 69 6c 6c 20 |y formul|as will |
|000008f0| 62 65 20 63 6f 70 69 65 | 64 20 72 61 74 68 65 72 |be copie|d rather|
|00000900| 20 74 68 61 6e 20 63 75 | 74 2e 00 56 61 6c 75 65 | than cu|t..Value|
|00000910| 73 20 74 68 61 74 20 79 | 6f 75 20 70 61 73 74 65 |s that y|ou paste|
|00000920| 20 77 69 6c 6c 20 6f 76 | 65 72 6c 61 70 20 63 61 | will ov|erlap ca|
|00000930| 6c 63 75 6c 61 74 65 64 | 20 76 61 6c 75 65 73 2e |lculated| values.|
|00000940| 00 43 65 6c 6c 20 76 61 | 6c 75 65 73 20 74 68 61 |.Cell va|lues tha|
|00000950| 74 20 61 72 65 20 63 61 | 6c 63 75 6c 61 74 65 64 |t are ca|lculated|
|00000960| 20 62 79 20 66 6f 72 6d | 75 6c 61 73 20 77 69 6c | by form|ulas wil|
|00000970| 6c 20 62 65 20 6f 76 65 | 72 6c 61 70 70 65 64 20 |l be ove|rlapped |
|00000980| 62 79 20 62 6c 61 6e 6b | 20 63 65 6c 6c 73 2e 20 |by blank| cells. |
|00000990| 43 6c 69 63 6b 20 59 65 | 73 20 74 6f 20 70 72 6f |Click Ye|s to pro|
|000009a0| 63 65 65 64 2e 00 4f 6e | 6c 79 20 74 68 65 20 63 |ceed..On|ly the c|
|000009b0| 65 6c 6c 73 20 74 68 61 | 74 20 66 69 74 20 69 6e |ells tha|t fit in|
|000009c0| 74 6f 20 74 68 65 20 64 | 65 73 74 69 6e 61 74 69 |to the d|estinati|
|000009d0| 6f 6e 20 73 65 6c 65 63 | 74 69 6f 6e 20 77 69 6c |on selec|tion wil|
|000009e0| 6c 20 62 65 20 70 61 73 | 74 65 64 2e 20 43 6c 69 |l be pas|ted. Cli|
|000009f0| 63 6b 20 4f 4b 20 74 6f | 20 70 72 6f 63 65 65 64 |ck OK to| proceed|
|00000a00| 2e 00 4f 6e 6c 79 20 74 | 68 65 20 63 65 6c 6c 73 |..Only t|he cells|
|00000a10| 20 74 68 61 74 20 66 69 | 74 20 61 74 20 74 68 69 | that fi|t at thi|
|00000a20| 73 20 70 6f 73 69 74 69 | 6f 6e 20 69 6e 20 74 68 |s positi|on in th|
|00000a30| 65 20 77 6f 72 6b 73 68 | 65 65 74 20 77 69 6c 6c |e worksh|eet will|
|00000a40| 20 62 65 20 70 61 73 74 | 65 64 2e 20 43 6c 69 63 | be past|ed. Clic|
|00000a50| 6b 20 4f 4b 20 74 6f 20 | 70 72 6f 63 65 65 64 2e |k OK to |proceed.|
|00000a60| 00 59 6f 75 20 63 61 6e | 6e 6f 74 20 70 61 73 74 |.You can|not past|
|00000a70| 65 20 69 6e 74 6f 20 61 | 20 73 69 6e 67 6c 65 20 |e into a| single |
|00000a80| 63 65 6c 6c 20 74 68 61 | 74 20 79 6f 75 20 73 70 |cell tha|t you sp|
|00000a90| 65 63 69 66 69 65 64 20 | 62 79 20 6d 61 6b 69 6e |ecified |by makin|
|00000aa0| 67 20 61 20 72 65 66 69 | 6e 65 64 2d 69 74 65 6d |g a refi|ned-item|
|00000ab0| 20 73 65 6c 65 63 74 69 | 6f 6e 2e 00 44 65 6c 65 | selecti|on..Dele|
|00000ac0| 74 65 20 69 73 20 6e 6f | 74 20 61 6c 6c 6f 77 65 |te is no|t allowe|
|00000ad0| 64 20 77 69 74 68 20 61 | 6e 20 69 74 65 6d 73 2d |d with a|n items-|
|00000ae0| 6f 6e 6c 79 20 73 65 6c | 65 63 74 69 6f 6e 2e 00 |only sel|ection..|
|00000af0| 54 68 65 20 73 65 6c 65 | 63 74 69 6f 6e 20 77 69 |The sele|ction wi|
|00000b00| 6c 6c 20 62 65 20 63 6f | 70 69 65 64 20 72 61 74 |ll be co|pied rat|
|00000b10| 68 65 72 20 74 68 61 6e | 20 63 75 74 2e 00 54 68 |her than| cut..Th|
|00000b20| 69 73 20 6e 61 6d 65 20 | 6d 75 73 74 20 69 6e 63 |is name |must inc|
|00000b30| 6c 75 64 65 20 64 6f 75 | 62 6c 65 20 61 70 6f 73 |lude dou|ble apos|
|00000b40| 74 72 6f 70 68 65 73 20 | 77 68 65 6e 20 79 6f 75 |trophes |when you|
|00000b50| 20 65 6e 74 65 72 20 69 | 74 20 69 6e 20 61 20 66 | enter i|t in a f|
|00000b60| 6f 72 6d 75 6c 61 2e 00 | 4f 6e 6c 79 20 63 65 6c |ormula..|Only cel|
|00000b70| 6c 73 20 63 75 74 20 6f | 72 20 63 6f 70 69 65 64 |ls cut o|r copied|
|00000b80| 20 66 72 6f 6d 20 61 20 | 73 69 6e 67 6c 65 20 72 | from a |single r|
|00000b90| 6f 77 20 6f 72 20 63 6f | 6c 75 6d 6e 20 63 61 6e |ow or co|lumn can|
|00000ba0| 20 62 65 20 70 61 73 74 | 65 64 20 69 6e 74 6f 20 | be past|ed into |
|00000bb0| 74 68 65 20 69 74 65 6d | 20 6e 61 6d 65 20 61 72 |the item| name ar|
|00000bc0| 65 61 2e 00 52 65 6e 61 | 6d 69 6e 67 20 74 68 65 |ea..Rena|ming the|
|00000bd0| 20 63 61 74 65 67 6f 72 | 79 20 6d 61 79 20 62 72 | categor|y may br|
|00000be0| 65 61 6b 20 73 6f 6d 65 | 20 69 6e 74 65 72 73 68 |eak some| intersh|
|00000bf0| 65 65 74 20 66 6f 72 6d | 75 6c 61 73 2e 00 43 6f |eet form|ulas..Co|
|00000c00| 6c 6f 6e 73 20 77 69 6c | 6c 20 62 65 20 72 65 6d |lons wil|l be rem|
|00000c10| 6f 76 65 64 20 66 72 6f | 6d 20 69 74 65 6d 20 6e |oved fro|m item n|
|00000c20| 61 6d 65 73 2e 00 44 65 | 6c 65 74 69 6e 67 20 74 |ames..De|leting t|
|00000c30| 68 65 73 65 20 69 74 65 | 6d 73 20 77 69 6c 6c 20 |hese ite|ms will |
|00000c40| 64 65 73 74 72 6f 79 20 | 63 65 6c 6c 20 76 61 6c |destroy |cell val|
|00000c50| 75 65 73 20 61 6e 64 20 | 63 61 75 73 65 20 66 6f |ues and |cause fo|
|00000c60| 72 6d 75 6c 61 73 20 74 | 6f 20 62 72 65 61 6b 2e |rmulas t|o break.|
|00000c70| 20 43 6c 69 63 6b 20 4f | 4b 20 74 6f 20 70 72 6f | Click O|K to pro|
|00000c80| 63 65 65 64 2e 00 59 6f | 75 20 68 61 76 65 20 72 |ceed..Yo|u have r|
|00000c90| 65 61 63 68 65 64 20 74 | 68 65 20 6d 61 78 69 6d |eached t|he maxim|
|00000ca0| 75 6d 20 6f 66 20 25 6e | 75 6d 62 65 72 25 20 76 |um of %n|umber% v|
|00000cb0| 69 65 77 73 20 6f 66 20 | 61 20 77 6f 72 6b 73 68 |iews of |a worksh|
|00000cc0| 65 65 74 20 61 6c 6c 6f | 77 65 64 20 69 6e 20 61 |eet allo|wed in a|
|00000cd0| 20 6d 6f 64 65 6c 2e 00 | 4e 6f 6e 65 20 6f 66 20 | model..|None of |
|00000ce0| 74 68 65 20 73 65 6c 65 | 63 74 65 64 20 67 72 6f |the sele|cted gro|
|00000cf0| 75 70 73 20 63 6f 6e 74 | 61 69 6e 73 20 61 6e 20 |ups cont|ains an |
|00000d00| 61 75 74 6f 6d 61 74 69 | 63 20 73 75 6d 6d 61 72 |automati|c summar|
|00000d10| 79 20 69 74 65 6d 2e 00 | 54 68 65 20 67 72 6f 75 |y item..|The grou|
|00000d20| 70 20 25 67 72 6f 75 70 | 25 20 61 6c 72 65 61 64 |p %group|% alread|
|00000d30| 79 20 63 6f 6e 74 61 69 | 6e 73 20 61 6e 20 61 75 |y contai|ns an au|
|00000d40| 74 6f 6d 61 74 69 63 20 | 73 75 6d 6d 61 72 79 20 |tomatic |summary |
|00000d50| 69 74 65 6d 2e 00 54 68 | 65 20 73 65 6c 65 63 74 |item..Th|e select|
|00000d60| 65 64 20 67 72 6f 75 70 | 73 20 61 6c 72 65 61 64 |ed group|s alread|
|00000d70| 79 20 63 6f 6e 74 61 69 | 6e 20 61 75 74 6f 6d 61 |y contai|n automa|
|00000d80| 74 69 63 20 73 75 6d 6d | 61 72 79 20 69 74 65 6d |tic summ|ary item|
|00000d90| 73 2e 00 41 6e 20 61 75 | 74 6f 6d 61 74 69 63 20 |s..An au|tomatic |
|00000da0| 73 75 6d 6d 61 72 79 20 | 69 74 65 6d 20 77 69 6c |summary |item wil|
|00000db0| 6c 20 62 65 20 63 72 65 | 61 74 65 64 20 6f 6e 6c |l be cre|ated onl|
|00000dc0| 79 20 66 6f 72 20 74 68 | 65 20 73 65 6c 65 63 74 |y for th|e select|
|00000dd0| 65 64 20 67 72 6f 75 70 | 73 20 74 68 61 74 20 64 |ed group|s that d|
|00000de0| 6f 20 6e 6f 74 20 61 6c | 72 65 61 64 79 20 68 61 |o not al|ready ha|
|00000df0| 76 65 20 6f 6e 65 2e 00 | 54 68 65 20 73 65 6c 65 |ve one..|The sele|
|00000e00| 63 74 69 6f 6e 20 68 61 | 73 20 6d 6f 72 65 20 74 |ction ha|s more t|
|00000e10| 68 61 6e 20 25 6c 69 6d | 69 74 25 20 73 65 72 69 |han %lim|it% seri|
|00000e20| 65 73 2e 00 54 68 65 20 | 67 72 61 70 68 20 61 6c |es..The |graph al|
|00000e30| 72 65 61 64 79 20 68 61 | 73 20 25 6c 69 6d 69 74 |ready ha|s %limit|
|00000e40| 25 20 73 65 72 69 65 73 | 2e 00 54 68 65 20 74 6f |% series|..The to|
|00000e50| 74 61 6c 20 6e 75 6d 62 | 65 72 20 6f 66 20 73 65 |tal numb|er of se|
|00000e60| 72 69 65 73 20 69 6e 20 | 74 68 65 20 73 65 6c 65 |ries in |the sele|
|00000e70| 63 74 69 6f 6e 20 61 6e | 64 20 74 68 65 20 67 72 |ction an|d the gr|
|00000e80| 61 70 68 20 65 78 63 65 | 65 64 73 20 25 6c 69 6d |aph exce|eds %lim|
|00000e90| 69 74 25 2e 20 20 4f 6e | 6c 79 20 25 6e 75 6d 62 |it%. On|ly %numb|
|00000ea0| 65 72 25 20 73 65 72 69 | 65 73 20 77 69 6c 6c 20 |er% seri|es will |
|00000eb0| 62 65 20 61 64 64 65 64 | 20 74 6f 20 74 68 65 20 |be added| to the |
|00000ec0| 67 72 61 70 68 2e 00 41 | 64 64 69 6e 67 20 61 20 |graph..A|dding a |
|00000ed0| 63 61 74 65 67 6f 72 79 | 20 77 69 6c 6c 20 62 72 |category| will br|
|00000ee0| 65 61 6b 20 44 44 45 20 | 6c 69 6e 6b 20 66 6f 72 |eak DDE |link for|
|00000ef0| 6d 75 6c 61 73 20 69 6e | 20 74 68 69 73 20 77 6f |mulas in| this wo|
|00000f00| 72 6b 73 68 65 65 74 2e | 00 44 65 6c 65 74 69 6e |rksheet.|.Deletin|
|00000f10| 67 20 74 68 65 73 65 20 | 69 74 65 6d 73 20 77 69 |g these |items wi|
|00000f20| 6c 6c 20 64 65 73 74 72 | 6f 79 20 74 68 65 20 63 |ll destr|oy the c|
|00000f30| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 63 65 6c 6c 73 |ontents |of cells|
|00000f40| 20 61 6e 64 20 6d 69 67 | 68 74 20 62 72 65 61 6b | and mig|ht break|
|00000f50| 20 73 6f 6d 65 20 66 6f | 72 6d 75 6c 61 73 2e 00 | some fo|rmulas..|
|00000f60| 59 6f 75 20 61 72 65 20 | 61 62 6f 75 74 20 74 6f |You are |about to|
|00000f70| 20 64 65 6c 65 74 65 20 | 77 6f 72 6b 73 68 65 65 | delete |workshee|
|00000f80| 74 73 20 66 72 6f 6d 20 | 74 68 65 20 6d 6f 64 65 |ts from |the mode|
|00000f90| 6c 2e 00 59 6f 75 20 61 | 72 65 20 61 62 6f 75 74 |l..You a|re about|
|00000fa0| 20 74 6f 20 64 65 6c 65 | 74 65 20 74 68 65 20 77 | to dele|te the w|
|00000fb0| 6f 72 6b 73 68 65 65 74 | 20 27 25 6e 61 6d 65 25 |orksheet| '%name%|
|00000fc0| 27 20 66 72 6f 6d 20 74 | 68 65 20 6d 6f 64 65 6c |' from t|he model|
|00000fd0| 2e 20 53 6f 6d 65 20 66 | 6f 72 6d 75 6c 61 73 20 |. Some f|ormulas |
|00000fe0| 69 6e 20 74 68 65 20 6d | 6f 64 65 6c 20 77 69 6c |in the m|odel wil|
|00000ff0| 6c 20 62 72 65 61 6b 2e | 00 59 6f 75 20 61 72 65 |l break.|.You are|
|00001000| 20 61 62 6f 75 74 20 74 | 6f 20 64 65 6c 65 74 65 | about t|o delete|
|00001010| 20 77 6f 72 6b 73 68 65 | 65 74 73 20 66 72 6f 6d | workshe|ets from|
|00001020| 20 74 68 65 20 6d 6f 64 | 65 6c 2e 20 53 6f 6d 65 | the mod|el. Some|
|00001030| 20 66 6f 72 6d 75 6c 61 | 73 20 69 6e 20 74 68 65 | formula|s in the|
|00001040| 20 6d 6f 64 65 6c 20 77 | 69 6c 6c 20 62 72 65 61 | model w|ill brea|
|00001050| 6b 2e 00 59 6f 75 20 63 | 61 6e 6e 6f 74 20 64 65 |k..You c|annot de|
|00001060| 6c 65 74 65 20 61 6c 6c | 20 74 68 65 20 77 6f 72 |lete all| the wor|
|00001070| 6b 73 68 65 65 74 73 20 | 69 6e 20 61 20 6d 6f 64 |ksheets |in a mod|
|00001080| 65 6c 2e 00 49 6d 70 72 | 6f 76 20 63 61 6e 6e 6f |el..Impr|ov canno|
|00001090| 74 20 66 69 6e 64 20 74 | 68 65 20 67 72 6f 75 70 |t find t|he group|
|000010a0| 20 27 25 67 72 6f 75 70 | 25 27 20 77 69 74 68 20 | '%group|%' with |
|000010b0| 61 20 6d 65 6d 62 65 72 | 20 6e 61 6d 65 64 20 27 |a member| named '|
|000010c0| 25 6e 61 6d 65 25 27 2e | 00 54 68 65 20 63 61 74 |%name%'.|.The cat|
|000010d0| 65 67 6f 72 79 20 27 25 | 67 72 6f 75 70 25 27 20 |egory '%|group%' |
|000010e0| 68 61 73 20 6e 6f 20 6d | 65 6d 62 65 72 20 6e 61 |has no m|ember na|
|000010f0| 6d 65 64 20 27 25 6e 61 | 6d 65 25 27 2e 00 54 68 |med '%na|me%'..Th|
|00001100| 65 20 69 74 65 6d 20 27 | 25 67 72 6f 75 70 25 27 |e item '|%group%'|
|00001110| 20 68 61 73 20 6e 6f 20 | 69 6d 6d 65 64 69 61 74 | has no |immediat|
|00001120| 65 20 6d 65 6d 62 65 72 | 20 6e 61 6d 65 64 20 27 |e member| named '|
|00001130| 25 6e 61 6d 65 25 27 2e | 00 54 68 65 20 63 61 74 |%name%'.|.The cat|
|00001140| 65 67 6f 72 79 20 27 25 | 67 72 6f 75 70 25 27 20 |egory '%|group%' |
|00001150| 68 61 73 20 6e 6f 20 69 | 6d 6d 65 64 69 61 74 65 |has no i|mmediate|
|00001160| 20 6d 65 6d 62 65 72 20 | 6e 61 6d 65 64 20 27 25 | member |named '%|
|00001170| 6e 61 6d 65 25 27 2e 00 | 54 68 65 20 69 74 65 6d |name%'..|The item|
|00001180| 20 27 25 67 72 6f 75 70 | 25 27 20 68 61 73 20 6e | '%group|%' has n|
|00001190| 6f 20 6d 65 6d 62 65 72 | 20 6e 61 6d 65 64 20 27 |o member| named '|
|000011a0| 25 6e 61 6d 65 25 27 2e | 00 54 68 65 20 63 61 74 |%name%'.|.The cat|
|000011b0| 65 67 6f 72 79 20 27 25 | 67 72 6f 75 70 25 27 20 |egory '%|group%' |
|000011c0| 68 61 73 20 6e 6f 20 6d | 65 6d 62 65 72 20 6e 61 |has no m|ember na|
|000011d0| 6d 65 64 20 27 25 6e 61 | 6d 65 25 27 2e 00 50 61 |med '%na|me%'..Pa|
|000011e0| 73 74 69 6e 67 20 77 69 | 6c 6c 20 6f 76 65 72 77 |sting wi|ll overw|
|000011f0| 72 69 74 65 20 61 6c 6c | 20 74 68 65 20 64 61 74 |rite all| the dat|
|00001200| 61 20 69 6e 20 74 68 65 | 20 73 65 6c 65 63 74 65 |a in the| selecte|
|00001210| 64 20 69 74 65 6d 73 2e | 00 52 65 63 61 6c 63 75 |d items.|.Recalcu|
|00001220| 6c 61 74 69 6f 6e 20 69 | 73 20 69 6e 20 70 72 6f |lation i|s in pro|
|00001230| 67 72 65 73 73 2e 00 41 | 20 63 65 6c 6c 20 76 61 |gress..A| cell va|
|00001240| 6c 75 65 20 69 73 20 74 | 6f 6f 20 6c 6f 6e 67 2e |lue is t|oo long.|
|00001250| 20 49 74 20 77 69 6c 6c | 20 62 65 20 74 72 75 6e | It will| be trun|
|00001260| 63 61 74 65 64 2e 00 54 | 68 65 20 76 69 65 77 20 |cated..T|he view |
|00001270| 6e 61 6d 65 20 27 25 6e | 61 6d 65 25 27 20 68 61 |name '%n|ame%' ha|
|00001280| 73 20 61 6c 72 65 61 64 | 79 20 62 65 65 6e 20 75 |s alread|y been u|
|00001290| 73 65 64 20 66 6f 72 20 | 61 6e 6f 74 68 65 72 20 |sed for |another |
|000012a0| 76 69 65 77 20 6f 66 20 | 74 68 69 73 20 77 6f 72 |view of |this wor|
|000012b0| 6b 73 68 65 65 74 2e 00 | 54 68 65 20 70 72 65 73 |ksheet..|The pres|
|000012c0| 65 6e 74 61 74 69 6f 6e | 20 6e 61 6d 65 20 27 25 |entation| name '%|
|000012d0| 6e 61 6d 65 25 27 20 68 | 61 73 20 61 6c 72 65 61 |name%' h|as alrea|
|000012e0| 64 79 20 62 65 65 6e 20 | 75 73 65 64 20 66 6f 72 |dy been |used for|
|000012f0| 20 61 6e 6f 74 68 65 72 | 20 70 72 65 73 65 6e 74 | another| present|
|00001300| 61 74 69 6f 6e 20 69 6e | 20 74 68 69 73 20 6d 6f |ation in| this mo|
|00001310| 64 65 6c 2e 00 54 68 65 | 20 6e 61 6d 65 20 79 6f |del..The| name yo|
|00001320| 75 20 65 6e 74 65 72 65 | 64 20 62 65 67 69 6e 73 |u entere|d begins|
|00001330| 20 77 69 74 68 20 61 20 | 6e 75 6d 62 65 72 2e 00 | with a |number..|
|00001340| 54 68 65 20 6e 61 6d 65 | 20 79 6f 75 20 65 6e 74 |The name| you ent|
|00001350| 65 72 65 64 20 69 6e 63 | 6c 75 64 65 73 20 61 20 |ered inc|ludes a |
|00001360| 63 6f 6d 6d 61 2e 00 54 | 68 65 20 73 65 6c 65 63 |comma..T|he selec|
|00001370| 74 65 64 20 70 72 65 73 | 65 6e 74 61 74 69 6f 6e |ted pres|entation|
|00001380| 73 20 77 69 6c 6c 20 6e | 6f 74 20 62 65 20 63 6f |s will n|ot be co|
|00001390| 70 69 65 64 20 74 6f 20 | 74 68 65 20 70 61 73 74 |pied to |the past|
|000013a0| 65 62 6f 61 72 64 2e 00 | 54 68 65 20 53 74 61 72 |eboard..|The Star|
|000013b0| 74 20 76 61 6c 75 65 20 | 69 73 20 6e 6f 74 20 61 |t value |is not a|
|000013c0| 20 76 61 6c 69 64 20 6e | 75 6d 62 65 72 20 6f 72 | valid n|umber or|
|000013d0| 20 69 73 20 6e 6f 74 20 | 69 6e 20 61 20 76 61 6c | is not |in a val|
|000013e0| 69 64 20 64 61 74 65 20 | 6f 72 20 74 69 6d 65 20 |id date |or time |
|000013f0| 66 6f 72 6d 61 74 2e 00 | 54 68 65 20 53 74 65 70 |format..|The Step|
|00001400| 20 76 61 6c 75 65 20 69 | 73 20 6e 6f 74 20 61 20 | value i|s not a |
|00001410| 76 61 6c 69 64 20 6e 75 | 6d 62 65 72 20 6f 72 20 |valid nu|mber or |
|00001420| 69 73 20 6e 6f 74 20 69 | 6e 20 61 20 76 61 6c 69 |is not i|n a vali|
|00001430| 64 20 64 61 74 65 20 6f | 72 20 74 69 6d 65 20 66 |d date o|r time f|
|00001440| 6f 72 6d 61 74 2e 00 54 | 68 65 20 45 6e 64 20 76 |ormat..T|he End v|
|00001450| 61 6c 75 65 20 69 73 20 | 6e 6f 74 20 61 20 76 61 |alue is |not a va|
|00001460| 6c 69 64 20 6e 75 6d 62 | 65 72 20 6f 72 20 69 73 |lid numb|er or is|
|00001470| 20 6e 6f 74 20 69 6e 20 | 61 20 76 61 6c 69 64 20 | not in |a valid |
|00001480| 64 61 74 65 20 6f 72 20 | 74 69 6d 65 20 66 6f 72 |date or |time for|
|00001490| 6d 61 74 2e 00 54 68 65 | 20 53 74 61 72 74 20 61 |mat..The| Start a|
|000014a0| 6e 64 20 45 6e 64 20 76 | 61 6c 75 65 73 20 61 72 |nd End v|alues ar|
|000014b0| 65 20 69 6e 76 61 6c 69 | 64 2e 00 56 61 6c 75 65 |e invali|d..Value|
|000014c0| 73 20 74 68 61 74 20 79 | 6f 75 20 65 6e 74 65 72 |s that y|ou enter|
|000014d0| 65 64 20 77 69 6c 6c 20 | 6f 76 65 72 6c 61 70 20 |ed will |overlap |
|000014e0| 63 61 6c 63 75 6c 61 74 | 65 64 20 76 61 6c 75 65 |calculat|ed value|
|000014f0| 73 2e 00 54 68 65 20 66 | 72 61 63 74 69 6f 6e 61 |s..The f|ractiona|
|00001500| 6c 20 70 6f 72 74 69 6f | 6e 20 6f 66 20 74 68 65 |l portio|n of the|
|00001510| 20 53 74 65 70 20 76 61 | 6c 75 65 20 77 69 6c 6c | Step va|lue will|
|00001520| 20 62 65 20 69 67 6e 6f | 72 65 64 2e 00 49 6e 74 | be igno|red..Int|
|00001530| 65 72 73 68 65 65 74 20 | 72 65 66 65 72 65 6e 63 |ersheet |referenc|
|00001540| 65 73 20 61 72 65 20 6e | 6f 74 20 61 6c 6c 6f 77 |es are n|ot allow|
|00001550| 65 64 2e 00 54 68 65 20 | 73 79 6e 74 61 78 20 6f |ed..The |syntax o|
|00001560| 66 20 74 68 65 20 73 6f | 72 74 20 6b 65 79 20 69 |f the so|rt key i|
|00001570| 73 20 69 6e 76 61 6c 69 | 64 2e 00 49 6e 76 61 6c |s invali|d..Inval|
|00001580| 69 64 20 73 6f 72 74 20 | 6b 65 79 2e 00 49 6e 76 |id sort |key..Inv|
|00001590| 61 6c 69 64 20 73 6f 72 | 74 20 6b 65 79 2e 00 52 |alid sor|t key..R|
|000015a0| 65 63 75 72 72 65 6e 63 | 65 20 72 65 66 65 72 65 |ecurrenc|e refere|
|000015b0| 6e 63 65 73 20 61 72 65 | 20 6e 6f 74 20 61 6c 6c |nces are| not all|
|000015c0| 6f 77 65 64 2e 00 54 68 | 65 20 6b 65 79 20 69 73 |owed..Th|e key is|
|000015d0| 20 6e 6f 74 20 61 20 73 | 69 6d 70 6c 65 20 72 65 | not a s|imple re|
|000015e0| 66 65 72 65 6e 63 65 2e | 00 49 6e 76 61 6c 69 64 |ference.|.Invalid|
|000015f0| 20 73 6f 72 74 20 6b 65 | 79 2e 00 59 6f 75 20 68 | sort ke|y..You h|
|00001600| 61 76 65 20 72 65 61 63 | 68 65 64 20 74 68 65 20 |ave reac|hed the |
|00001610| 6d 61 78 69 6d 75 6d 20 | 6f 66 20 25 6e 75 6d 62 |maximum |of %numb|
|00001620| 65 72 25 20 6e 65 73 74 | 65 64 20 67 72 6f 75 70 |er% nest|ed group|
|00001630| 73 2e 00 54 68 65 20 63 | 75 73 74 6f 6d 20 66 6f |s..The c|ustom fo|
|00001640| 72 6d 61 74 20 63 6f 6e | 74 61 69 6e 73 20 61 6e |rmat con|tains an|
|00001650| 20 65 72 72 6f 72 2e 00 | 54 68 65 20 63 61 74 65 | error..|The cate|
|00001660| 67 6f 72 79 20 6e 61 6d | 65 20 79 6f 75 20 65 6e |gory nam|e you en|
|00001670| 74 65 72 65 64 20 68 61 | 73 20 74 6f 6f 20 6d 61 |tered ha|s too ma|
|00001680| 6e 79 20 63 68 61 72 61 | 63 74 65 72 73 2e 00 43 |ny chara|cters..C|
|00001690| 61 6e 6e 6f 74 20 66 69 | 6e 64 20 4c 6f 74 75 73 |annot fi|nd Lotus|
|000016a0| 20 54 4f 4f 4c 53 20 66 | 69 6c 65 73 2e 00 43 61 | TOOLS f|iles..Ca|
|000016b0| 6e 6e 6f 74 20 63 72 65 | 61 74 65 20 61 20 63 68 |nnot cre|ate a ch|
|000016c0| 61 72 74 2e 00 54 68 65 | 20 6d 6f 64 65 6c 20 77 |art..The| model w|
|000016d0| 69 6c 6c 20 62 65 20 6f | 70 65 6e 65 64 20 77 69 |ill be o|pened wi|
|000016e0| 74 68 6f 75 74 20 61 20 | 68 6f 74 20 6c 69 6e 6b |thout a |hot link|
|000016f0| 20 62 65 63 61 75 73 65 | 20 74 68 65 72 65 20 61 | because| there a|
|00001700| 72 65 20 65 72 72 6f 72 | 73 20 69 6e 20 74 68 65 |re error|s in the|
|00001710| 20 49 6d 70 72 6f 76 20 | 62 69 6e 61 72 79 20 66 | Improv |binary f|
|00001720| 69 6c 65 2e 00 59 6f 75 | 20 68 61 76 65 20 65 78 |ile..You| have ex|
|00001730| 63 65 65 64 65 64 20 74 | 68 65 20 6c 69 6d 69 74 |ceeded t|he limit|
|00001740| 20 6f 66 20 25 6e 75 6d | 62 65 72 25 20 76 65 63 | of %num|ber% vec|
|00001750| 74 6f 72 73 20 66 6f 72 | 20 61 6e 20 49 6d 70 72 |tors for| an Impr|
|00001760| 6f 76 20 73 65 73 73 69 | 6f 6e 2e 00 59 6f 75 20 |ov sessi|on..You |
|00001770| 61 72 65 20 61 62 6f 75 | 74 20 74 6f 20 64 65 6c |are abou|t to del|
|00001780| 65 74 65 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 |ete the |selected|
|00001790| 20 77 6f 72 6b 73 68 65 | 65 74 73 2c 20 76 69 65 | workshe|ets, vie|
|000017a0| 77 73 2c 20 70 72 65 73 | 65 6e 74 61 74 69 6f 6e |ws, pres|entation|
|000017b0| 73 2c 20 61 6e 64 20 73 | 63 72 69 70 74 73 2e 20 |s, and s|cripts. |
|000017c0| 53 6f 6d 65 20 66 6f 72 | 6d 75 6c 61 73 20 69 6e |Some for|mulas in|
|000017d0| 20 74 68 65 20 6d 6f 64 | 65 6c 20 77 69 6c 6c 20 | the mod|el will |
|000017e0| 62 72 65 61 6b 2e 00 59 | 6f 75 20 61 72 65 20 61 |break..Y|ou are a|
|000017f0| 62 6f 75 74 20 74 6f 20 | 64 65 6c 65 74 65 20 74 |bout to |delete t|
|00001800| 68 65 20 73 65 6c 65 63 | 74 65 64 20 77 6f 72 6b |he selec|ted work|
|00001810| 73 68 65 65 74 73 2c 20 | 76 69 65 77 73 2c 20 70 |sheets, |views, p|
|00001820| 72 65 73 65 6e 74 61 74 | 69 6f 6e 73 2c 20 61 6e |resentat|ions, an|
|00001830| 64 20 73 63 72 69 70 74 | 73 2e 00 00 59 6f 75 20 |d script|s...You |
|00001840| 61 72 65 20 61 62 6f 75 | 74 20 74 6f 20 64 65 6c |are abou|t to del|
|00001850| 65 74 65 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 |ete the |selected|
|00001860| 20 76 69 65 77 73 2e 00 | 59 6f 75 20 61 72 65 20 | views..|You are |
|00001870| 61 62 6f 75 74 20 74 6f | 20 64 65 6c 65 74 65 20 |about to| delete |
|00001880| 74 68 65 20 76 69 65 77 | 20 27 25 6e 61 6d 65 25 |the view| '%name%|
|00001890| 27 20 66 72 6f 6d 20 74 | 68 65 20 6d 6f 64 65 6c |' from t|he model|
|000018a0| 2e 00 59 6f 75 20 61 72 | 65 20 61 62 6f 75 74 20 |..You ar|e about |
|000018b0| 74 6f 20 64 65 6c 65 74 | 65 20 74 68 65 20 73 65 |to delet|e the se|
|000018c0| 6c 65 63 74 65 64 20 70 | 72 65 73 65 6e 74 61 74 |lected p|resentat|
|000018d0| 69 6f 6e 73 2e 00 59 6f | 75 20 61 72 65 20 61 62 |ions..Yo|u are ab|
|000018e0| 6f 75 74 20 74 6f 20 64 | 65 6c 65 74 65 20 74 68 |out to d|elete th|
|000018f0| 65 20 70 72 65 73 65 6e | 74 61 74 69 6f 6e 20 27 |e presen|tation '|
|00001900| 25 6e 61 6d 65 25 27 20 | 66 72 6f 6d 20 74 68 65 |%name%' |from the|
|00001910| 20 6d 6f 64 65 6c 2e 00 | 54 68 65 20 6d 6f 64 65 | model..|The mode|
|00001920| 6c 20 63 6f 6e 74 61 69 | 6e 73 20 68 6f 74 20 6c |l contai|ns hot l|
|00001930| 69 6e 6b 73 20 74 68 61 | 74 20 72 65 66 65 72 65 |inks tha|t refere|
|00001940| 6e 63 65 20 61 20 6e 6f | 6e 65 78 69 73 74 65 6e |nce a no|nexisten|
|00001950| 74 20 77 6f 72 6b 73 68 | 65 65 74 2e 00 41 20 6e |t worksh|eet..A n|
|00001960| 65 77 20 69 74 65 6d 20 | 6e 61 6d 65 20 63 6f 6e |ew item |name con|
|00001970| 74 61 69 6e 73 20 6e 6f | 20 63 68 61 72 61 63 74 |tains no| charact|
|00001980| 65 72 73 2e 20 54 68 65 | 20 69 74 65 6d 20 77 69 |ers. The| item wi|
|00001990| 6c 6c 20 6b 65 65 70 20 | 69 74 73 20 6f 6c 64 20 |ll keep |its old |
|000019a0| 6e 61 6d 65 2e 00 41 20 | 6e 65 77 20 69 74 65 6d |name..A |new item|
|000019b0| 20 6e 61 6d 65 20 68 61 | 73 20 74 6f 6f 20 6d 61 | name ha|s too ma|
|000019c0| 6e 79 20 63 68 61 72 61 | 63 74 65 72 73 2e 20 54 |ny chara|cters. T|
|000019d0| 68 65 20 69 74 65 6d 20 | 6e 61 6d 65 20 77 69 6c |he item |name wil|
|000019e0| 6c 20 62 65 20 74 72 75 | 6e 63 61 74 65 64 2e 00 |l be tru|ncated..|
|000019f0| 54 68 65 20 70 72 65 73 | 65 6e 74 61 74 69 6f 6e |The pres|entation|
|00001a00| 20 77 69 6e 64 6f 77 20 | 69 73 20 66 6f 72 20 61 | window |is for a|
|00001a10| 20 64 69 66 66 65 72 65 | 6e 74 20 6d 6f 64 65 6c | differe|nt model|
|00001a20| 2e 00 54 68 65 20 69 6d | 70 6f 72 74 20 72 61 6e |..The im|port ran|
|00001a30| 67 65 20 69 73 20 65 6d | 70 74 79 20 6f 72 20 69 |ge is em|pty or i|
|00001a40| 6e 76 61 6c 69 64 2e 00 | 54 68 65 20 69 6d 70 6f |nvalid..|The impo|
|00001a50| 72 74 20 72 61 6e 67 65 | 20 69 73 20 75 6e 64 65 |rt range| is unde|
|00001a60| 66 69 6e 65 64 20 6f 72 | 20 69 6e 76 61 6c 69 64 |fined or| invalid|
|00001a70| 2e 20 49 6d 70 72 6f 76 | 20 77 69 6c 6c 20 69 6d |. Improv| will im|
|00001a80| 70 6f 72 74 20 74 68 65 | 20 65 6e 74 69 72 65 20 |port the| entire |
|00001a90| 77 6f 72 6b 73 68 65 65 | 74 2e 00 59 6f 75 20 68 |workshee|t..You h|
|00001aa0| 61 76 65 20 72 65 61 63 | 68 65 64 20 74 68 65 20 |ave reac|hed the |
|00001ab0| 6d 61 78 69 6d 75 6d 20 | 6e 75 6d 62 65 72 20 6f |maximum |number o|
|00001ac0| 66 20 69 74 65 6d 73 20 | 61 6c 6c 6f 77 65 64 20 |f items |allowed |
|00001ad0| 69 6e 20 61 20 77 6f 72 | 6b 73 68 65 65 74 2e 00 |in a wor|ksheet..|
|00001ae0| 54 68 65 20 72 6f 77 73 | 20 77 69 6c 6c 20 62 65 |The rows| will be|
|00001af0| 20 72 65 6e 61 6d 65 64 | 2c 20 62 75 74 20 74 68 | renamed|, but th|
|00001b00| 65 20 66 69 72 73 74 20 | 63 6f 6c 75 6d 6e 20 77 |e first |column w|
|00001b10| 69 6c 6c 20 6e 6f 74 20 | 62 65 20 64 65 6c 65 74 |ill not |be delet|
|00001b20| 65 64 2e 00 54 68 65 20 | 63 6f 6c 75 6d 6e 73 20 |ed..The |columns |
|00001b30| 77 69 6c 6c 20 62 65 20 | 72 65 6e 61 6d 65 64 2c |will be |renamed,|
|00001b40| 20 62 75 74 20 74 68 65 | 20 66 69 72 73 74 20 72 | but the| first r|
|00001b50| 6f 77 20 77 69 6c 6c 20 | 6e 6f 74 20 62 65 20 64 |ow will |not be d|
|00001b60| 65 6c 65 74 65 64 2e 00 | 52 6f 77 73 20 70 61 73 |eleted..|Rows pas|
|00001b70| 74 20 74 68 65 20 6d 61 | 78 69 6d 75 6d 20 6f 66 |t the ma|ximum of|
|00001b80| 20 25 6e 75 6d 62 65 72 | 25 20 77 69 6c 6c 20 6e | %number|% will n|
|00001b90| 6f 74 20 62 65 20 69 6d | 70 6f 72 74 65 64 2e 00 |ot be im|ported..|
|00001ba0| 43 6f 6c 75 6d 6e 73 20 | 70 61 73 74 20 74 68 65 |Columns |past the|
|00001bb0| 20 6d 61 78 69 6d 75 6d | 20 6f 66 20 25 6e 75 6d | maximum| of %num|
|00001bc0| 62 65 72 25 20 77 69 6c | 6c 20 6e 6f 74 20 62 65 |ber% wil|l not be|
|00001bd0| 20 69 6d 70 6f 72 74 65 | 64 2e 00 54 68 65 20 76 | importe|d..The v|
|00001be0| 61 6c 75 65 20 74 68 61 | 74 20 79 6f 75 20 65 6e |alue tha|t you en|
|00001bf0| 74 65 72 65 64 20 77 69 | 6c 6c 20 6f 76 65 72 6c |tered wi|ll overl|
|00001c00| 61 70 20 61 20 63 61 6c | 63 75 6c 61 74 65 64 20 |ap a cal|culated |
|00001c10| 76 61 6c 75 65 2e 00 54 | 68 65 20 6e 61 6d 65 20 |value..T|he name |
|00001c20| 79 6f 75 20 65 6e 74 65 | 72 65 64 20 68 61 73 20 |you ente|red has |
|00001c30| 74 6f 6f 20 6d 61 6e 79 | 20 63 68 61 72 61 63 74 |too many| charact|
|00001c40| 65 72 73 2e 20 49 74 20 | 77 69 6c 6c 20 62 65 20 |ers. It |will be |
|00001c50| 74 72 75 6e 63 61 74 65 | 64 2e 00 49 6e 74 65 72 |truncate|d..Inter|
|00001c60| 6e 61 6c 20 65 72 72 6f | 72 2e 00 54 68 65 20 6e |nal erro|r..The n|
|00001c70| 75 6d 62 65 72 20 6f 72 | 20 64 61 74 65 20 69 73 |umber or| date is|
|00001c80| 20 6e 6f 74 20 69 6e 20 | 74 68 65 20 63 6f 72 72 | not in |the corr|
|00001c90| 65 63 74 20 66 6f 72 6d | 20 6f 72 20 69 73 20 6f |ect form| or is o|
|00001ca0| 75 74 20 6f 66 20 72 61 | 6e 67 65 2e 00 41 64 64 |ut of ra|nge..Add|
|00001cb0| 69 6e 67 20 74 68 65 73 | 65 20 69 74 65 6d 73 20 |ing thes|e items |
|00001cc0| 77 69 6c 6c 20 62 72 65 | 61 6b 20 73 6f 6d 65 20 |will bre|ak some |
|00001cd0| 66 6f 72 6d 75 6c 61 73 | 20 69 6e 20 74 68 65 20 |formulas| in the |
|00001ce0| 6d 6f 64 65 6c 2e 00 4f | 6e 6c 79 20 74 68 65 20 |model..O|nly the |
|00001cf0| 69 74 65 6d 20 6e 61 6d | 65 73 20 74 68 61 74 20 |item nam|es that |
|00001d00| 66 69 74 20 69 6e 74 6f | 20 74 68 65 20 73 65 6c |fit into| the sel|
|00001d10| 65 63 74 69 6f 6e 20 77 | 69 6c 6c 20 62 65 20 70 |ection w|ill be p|
|00001d20| 61 73 74 65 64 2e 00 55 | 6e 67 72 6f 75 70 69 6e |asted..U|ngroupin|
|00001d30| 67 20 74 68 65 73 65 20 | 69 74 65 6d 73 20 77 69 |g these |items wi|
|00001d40| 6c 6c 20 62 72 65 61 6b | 20 73 6f 6d 65 20 66 6f |ll break| some fo|
|00001d50| 72 6d 75 6c 61 73 20 69 | 6e 20 74 68 65 20 6d 6f |rmulas i|n the mo|
|00001d60| 64 65 6c 2e 00 54 68 65 | 20 6e 61 6d 65 20 79 6f |del..The| name yo|
|00001d70| 75 20 65 6e 74 65 72 65 | 64 20 69 6e 63 6c 75 64 |u entere|d includ|
|00001d80| 65 73 20 61 20 73 6c 61 | 73 68 2e 00 59 6f 75 20 |es a sla|sh..You |
|00001d90| 61 72 65 20 61 62 6f 75 | 74 20 74 6f 20 64 65 6c |are abou|t to del|
|00001da0| 65 74 65 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 |ete the |selected|
|00001db0| 20 73 63 72 69 70 74 73 | 2e 00 59 6f 75 20 61 72 | scripts|..You ar|
|00001dc0| 65 20 61 62 6f 75 74 20 | 74 6f 20 64 65 6c 65 74 |e about |to delet|
|00001dd0| 65 20 74 68 65 20 73 63 | 72 69 70 74 20 27 25 6e |e the sc|ript '%n|
|00001de0| 61 6d 65 25 27 20 66 72 | 6f 6d 20 74 68 65 20 6d |ame%' fr|om the m|
|00001df0| 6f 64 65 6c 2e 00 54 68 | 65 20 73 63 72 69 70 74 |odel..Th|e script|
|00001e00| 20 6e 61 6d 65 20 79 6f | 75 20 65 6e 74 65 72 65 | name yo|u entere|
|00001e10| 64 20 69 73 20 74 68 65 | 20 6e 61 6d 65 20 6f 66 |d is the| name of|
|00001e20| 20 61 6e 20 65 78 69 73 | 74 69 6e 67 20 73 63 72 | an exis|ting scr|
|00001e30| 69 70 74 2e 00 59 6f 75 | 20 68 61 76 65 20 72 65 |ipt..You| have re|
|00001e40| 61 63 68 65 64 20 74 68 | 65 20 6d 61 78 69 6d 75 |ached th|e maximu|
|00001e50| 6d 20 6f 66 20 25 6e 75 | 6d 62 65 72 25 20 73 63 |m of %nu|mber% sc|
|00001e60| 72 69 70 74 73 20 61 6c | 6c 6f 77 65 64 20 69 6e |ripts al|lowed in|
|00001e70| 20 61 20 66 69 6c 65 2e | 00 54 68 65 20 6e 75 6d | a file.|.The num|
|00001e80| 62 65 72 20 6f 66 20 69 | 74 65 6d 73 20 79 6f 75 |ber of i|tems you|
|00001e90| 20 73 70 65 63 69 66 79 | 20 6d 75 73 74 20 62 65 | specify| must be|
|00001ea0| 20 61 20 76 61 6c 69 64 | 20 70 6f 73 69 74 69 76 | a valid| positiv|
|00001eb0| 65 20 69 6e 74 65 67 65 | 72 20 62 65 6c 6f 77 20 |e intege|r below |
|00001ec0| 25 6c 69 6d 69 74 25 2e | 00 54 68 65 20 65 6e 74 |%limit%.|.The ent|
|00001ed0| 72 79 20 69 73 20 74 6f | 6f 20 6c 6f 6e 67 20 74 |ry is to|o long t|
|00001ee0| 6f 20 66 69 74 20 69 6e | 74 6f 20 61 20 63 65 6c |o fit in|to a cel|
|00001ef0| 6c 2e 00 4f 6e 65 20 6f | 72 20 6d 6f 72 65 20 6c |l..One o|r more l|
|00001f00| 69 6e 6b 73 20 74 6f 20 | 6f 74 68 65 72 20 61 70 |inks to |other ap|
|00001f10| 70 6c 69 63 61 74 69 6f | 6e 73 20 77 69 6c 6c 20 |plicatio|ns will |
|00001f20| 62 65 20 62 72 6f 6b 65 | 6e 2e 00 59 6f 75 20 63 |be broke|n..You c|
|00001f30| 61 6e 6e 6f 74 20 68 69 | 64 65 20 61 6c 6c 20 74 |annot hi|de all t|
|00001f40| 68 65 20 69 74 65 6d 73 | 2e 00 4f 6e 65 20 6f 72 |he items|..One or|
|00001f50| 20 6d 6f 72 65 20 6c 69 | 6e 6b 73 20 74 6f 20 6f | more li|nks to o|
|00001f60| 74 68 65 72 20 61 70 70 | 6c 69 63 61 74 69 6f 6e |ther app|lication|
|00001f70| 73 20 77 69 6c 6c 20 62 | 65 20 62 72 6f 6b 65 6e |s will b|e broken|
|00001f80| 2e 00 59 6f 75 20 63 61 | 6e 6e 6f 74 20 70 61 73 |..You ca|nnot pas|
|00001f90| 74 65 20 63 68 61 72 74 | 73 20 6f 72 20 68 6f 74 |te chart|s or hot|
|00001fa0| 76 69 65 77 73 20 62 65 | 74 77 65 65 6e 20 6d 6f |views be|tween mo|
|00001fb0| 64 65 6c 73 2e 00 54 6f | 6f 20 6d 61 6e 79 20 66 |dels..To|o many f|
|00001fc0| 6f 72 6d 61 74 73 20 6f | 72 20 73 74 79 6c 65 73 |ormats o|r styles|
|00001fd0| 2e 00 54 68 69 73 20 73 | 65 6c 65 63 74 69 6f 6e |..This s|election|
|00001fe0| 20 77 69 6c 6c 20 63 72 | 65 61 74 65 20 61 20 63 | will cr|eate a c|
|00001ff0| 68 61 72 74 20 6f 66 20 | 61 20 73 69 6e 67 6c 65 |hart of |a single|
|00002000| 20 63 65 6c 6c 2e 00 59 | 6f 75 20 68 61 76 65 20 | cell..Y|ou have |
|00002010| 72 65 61 63 68 65 64 20 | 74 68 65 20 6d 61 78 69 |reached |the maxi|
|00002020| 6d 75 6d 20 6e 75 6d 62 | 65 72 20 6f 66 20 69 74 |mum numb|er of it|
|00002030| 65 6d 73 20 61 6c 6c 6f | 77 65 64 20 69 6e 20 61 |ems allo|wed in a|
|00002040| 20 63 61 74 65 67 6f 72 | 79 2e 00 54 68 65 20 63 | categor|y..The c|
|00002050| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 74 68 65 20 63 |ontents |of the c|
|00002060| 6c 69 70 62 6f 61 72 64 | 20 69 73 20 74 6f 6f 20 |lipboard| is too |
|00002070| 6c 61 72 67 65 2e 20 20 | 53 6f 6d 65 20 64 61 74 |large. |Some dat|
|00002080| 61 20 77 69 6c 6c 20 6e | 6f 74 20 67 65 74 20 70 |a will n|ot get p|
|00002090| 61 73 74 65 64 2e 00 49 | 6d 70 72 6f 76 20 64 6f |asted..I|mprov do|
|000020a0| 65 73 20 6e 6f 74 20 68 | 61 76 65 20 65 6e 6f 75 |es not h|ave enou|
|000020b0| 67 68 20 6d 65 6d 6f 72 | 79 20 74 6f 20 73 68 6f |gh memor|y to sho|
|000020c0| 77 20 74 68 65 20 66 75 | 6c 6c 20 76 69 65 77 2e |w the fu|ll view.|
|000020d0| 20 4f 6e 6c 79 20 61 20 | 6c 69 6d 69 74 65 64 20 | Only a |limited |
|000020e0| 6e 75 6d 62 65 72 20 6f | 66 20 72 6f 77 73 2c 20 |number o|f rows, |
|000020f0| 63 6f 6c 75 6d 6e 73 2c | 20 6f 72 20 70 61 67 65 |columns,| or page|
|00002100| 73 20 77 69 6c 6c 20 62 | 65 20 73 68 6f 77 6e 2e |s will b|e shown.|
|00002110| 00 53 6f 6d 65 20 66 6f | 72 6d 61 74 20 61 6e 64 |.Some fo|rmat and|
|00002120| 20 73 74 79 6c 65 20 61 | 74 74 72 69 62 75 74 65 | style a|ttribute|
|00002130| 73 20 68 61 76 65 20 62 | 65 65 6e 20 6c 6f 73 74 |s have b|een lost|
|00002140| 2e 00 43 75 74 74 69 6e | 67 20 6f 72 20 64 65 6c |..Cuttin|g or del|
|00002150| 65 74 69 6e 67 20 74 68 | 65 20 76 69 65 77 20 27 |eting th|e view '|
|00002160| 25 6e 61 6d 65 25 27 20 | 77 69 6c 6c 20 62 72 65 |%name%' |will bre|
|00002170| 61 6b 20 6f 6e 65 20 6f | 72 20 6d 6f 72 65 20 6c |ak one o|r more l|
|00002180| 69 6e 6b 73 2e 00 00 ac | 22 00 00 6a 53 8c 00 00 |inks....|"..jS...|
|00002190| 00 01 04 00 00 00 21 00 | 91 00 2e 01 ba 01 bb 02 |......!.|........|
|000021a0| c6 03 87 04 24 05 7d 05 | 22 06 08 07 e2 07 26 08 |....$.}.|".....&.|
|000021b0| 87 08 fb 08 62 09 d7 09 | 91 0a ff 0a 5f 0b c8 0b |....b...|...._...|
|000021c0| 09 0c fd 0c 76 0d 1e 0e | 9f 0e 5e 0f 98 0f 12 10 |....v...|..^.....|
|000021d0| 5b 10 a1 10 e8 10 88 11 | 25 12 ce 12 06 14 87 14 |[.......|%.......|
|000021e0| e7 15 87 16 41 17 fe 17 | 53 18 be 18 8c 19 1b 1a |....A...|S.......|
|000021f0| 75 1b b6 1b 0a 1c 96 1c | 4a 1d 46 1e 17 1f e9 1f |u.......|J.F.....|
|00002200| a8 20 3f 21 b4 21 4e 22 | 1a 23 26 24 96 25 45 27 |. ?!.!N"|.#&$.%E'|
|00002210| a1 27 55 28 cb 28 57 29 | f4 29 ae 2a 6c 2b 07 2c |.'U(.(W)|.).*l+.,|
|00002220| 70 2c d0 2c 3c 2d b4 2d | 54 2e e1 2e 1f 2f aa 2f |p,.,<-.-|T...././|
|00002230| 34 30 bd 30 f8 30 80 31 | ef 31 45 32 9b 32 f1 32 |40.0.0.1|.1E2.2.2|
|00002240| 47 33 9d 33 f3 33 49 34 | c4 34 82 35 f8 35 11 37 |G3.3.3I4|.4.5.5.7|
|00002250| bf 37 36 38 c1 38 6f 3a | 79 3b 7a 3b f1 3b 67 3c |.768.8o:|y;z;.;g<|
|00002260| e6 3c 64 3d 3f 3e ab 3e | 49 3f 10 40 51 40 f6 40 |.<d=?>.>|I?.@Q@.@|
|00002270| 82 41 59 42 2a 43 9d 43 | 16 44 9e 44 d5 44 5c 45 |.AYB*C.C|.D.D.D\E|
|00002280| 05 47 a2 47 3b 48 da 48 | 53 49 a4 49 f4 49 3d 4a |.G.G;H.H|SI.I.I=J|
|00002290| bc 4a 66 4b 1d 4c ec 4c | 0c 4d de 4d 60 4e 22 4f |.JfK.L.L|.M.M`N"O|
|000022a0| 1b 50 a4 50 62 51 42 52 | a6 52 69 53 43 65 6c 6c |.P.PbQBR|.RiSCell|
|000022b0| 20 65 6e 67 69 6e 65 20 | 6d 6f 76 65 20 6f 72 20 | engine |move or |
|000022c0| 63 6f 70 79 20 66 61 69 | 6c 65 64 2e 00 41 6e 20 |copy fai|led..An |
|000022d0| 69 6e 74 65 72 6e 61 6c | 20 63 65 6c 6c 20 65 6e |internal| cell en|
|000022e0| 67 69 6e 65 20 65 72 72 | 6f 72 20 77 61 73 20 72 |gine err|or was r|
|000022f0| 65 74 75 72 6e 65 64 20 | 66 72 6f 6d 20 74 68 65 |eturned |from the|
|00002300| 20 44 65 6c 65 74 65 20 | 43 61 74 65 67 6f 72 79 | Delete |Category|
|00002310| 20 63 6f 6d 6d 61 6e 64 | 2e 20 54 72 79 20 74 6f | command|. Try to|
|00002320| 20 73 61 76 65 20 74 68 | 65 20 66 69 6c 65 2c 20 | save th|e file, |
|00002330| 74 68 65 6e 20 72 65 62 | 6f 6f 74 2e 00 41 20 6d |then reb|oot..A m|
|00002340| 6f 64 65 6c 20 63 61 6e | 20 68 61 76 65 20 75 70 |odel can| have up|
|00002350| 20 74 6f 20 25 6e 75 6d | 62 65 72 25 20 77 6f 72 | to %num|ber% wor|
|00002360| 6b 73 68 65 65 74 73 2e | 20 59 6f 75 20 63 61 6e |ksheets.| You can|
|00002370| 6e 6f 74 20 61 64 64 20 | 61 20 6e 65 77 20 77 6f |not add |a new wo|
|00002380| 72 6b 73 68 65 65 74 20 | 74 6f 20 74 68 65 20 6d |rksheet |to the m|
|00002390| 6f 64 65 6c 20 75 6e 74 | 69 6c 20 79 6f 75 20 75 |odel unt|il you u|
|000023a0| 73 65 20 74 68 65 20 42 | 72 6f 77 73 65 72 20 74 |se the B|rowser t|
|000023b0| 6f 20 64 65 6c 65 74 65 | 20 61 74 20 6c 65 61 73 |o delete| at leas|
|000023c0| 74 20 6f 6e 65 20 65 78 | 69 73 74 69 6e 67 20 77 |t one ex|isting w|
|000023d0| 6f 72 6b 73 68 65 65 74 | 2e 00 41 20 77 6f 72 6b |orksheet|..A work|
|000023e0| 73 68 65 65 74 20 63 61 | 6e 20 68 61 76 65 20 75 |sheet ca|n have u|
|000023f0| 70 20 74 6f 20 31 32 20 | 63 61 74 65 67 6f 72 69 |p to 12 |categori|
|00002400| 65 73 2e 20 59 6f 75 20 | 63 61 6e 6e 6f 74 20 61 |es. You |cannot a|
|00002410| 64 64 20 61 6e 6f 74 68 | 65 72 20 63 61 74 65 67 |dd anoth|er categ|
|00002420| 6f 72 79 20 74 6f 20 74 | 68 65 20 77 6f 72 6b 73 |ory to t|he works|
|00002430| 68 65 65 74 20 75 6e 74 | 69 6c 20 79 6f 75 20 64 |heet unt|il you d|
|00002440| 65 6c 65 74 65 20 61 74 | 20 6c 65 61 73 74 20 6f |elete at| least o|
|00002450| 6e 65 20 65 78 69 73 74 | 69 6e 67 20 63 61 74 65 |ne exist|ing cate|
|00002460| 67 6f 72 79 2e 00 25 66 | 6f 72 6d 75 6c 61 25 0d |gory..%f|ormula%.|
|00002470| 0a 0d 0a 54 68 65 20 6e | 61 6d 65 20 27 25 6e 61 |...The n|ame '%na|
|00002480| 6d 65 25 27 20 6d 61 74 | 63 68 65 73 20 6d 6f 72 |me%' mat|ches mor|
|00002490| 65 20 74 68 61 74 20 6f | 6e 65 20 69 74 65 6d 20 |e that o|ne item |
|000024a0| 69 6e 20 74 68 65 20 77 | 6f 72 6b 73 68 65 65 74 |in the w|orksheet|
|000024b0| 2e 20 51 75 61 6c 69 66 | 79 20 74 68 65 20 69 74 |. Qualif|y the it|
|000024c0| 65 6d 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 72 |em you w|ant to r|
|000024d0| 65 66 65 72 65 6e 63 65 | 20 62 79 20 6e 61 6d 69 |eference| by nami|
|000024e0| 6e 67 20 74 68 65 20 63 | 61 74 65 67 6f 72 79 20 |ng the c|ategory |
|000024f0| 6f 72 20 67 72 6f 75 70 | 20 69 74 20 69 73 20 69 |or group| it is i|
|00002500| 6e 2e 20 45 78 61 6d 70 | 6c 65 3a 20 27 41 3a 41 |n. Examp|le: 'A:A|
|00002510| 31 27 20 69 73 20 74 68 | 65 20 71 75 61 6c 69 66 |1' is th|e qualif|
|00002520| 69 65 64 20 6e 6f 74 61 | 74 69 6f 6e 20 66 6f 72 |ied nota|tion for|
|00002530| 20 74 68 65 20 69 74 65 | 6d 20 27 41 31 27 2c 20 | the ite|m 'A1', |
|00002540| 77 68 69 63 68 20 69 73 | 20 61 20 6d 65 6d 62 65 |which is| a membe|
|00002550| 72 20 6f 66 20 74 68 65 | 20 63 61 74 65 67 6f 72 |r of the| categor|
|00002560| 79 20 27 41 27 2e 00 25 | 66 6f 72 6d 75 6c 61 25 |y 'A'..%|formula%|
|00002570| 0d 0a 0d 0a 54 68 65 20 | 6e 61 6d 65 20 79 6f 75 |....The |name you|
|00002580| 20 65 6e 74 65 72 65 64 | 20 64 6f 65 73 20 6e 6f | entered| does no|
|00002590| 74 20 6d 61 74 63 68 20 | 61 6e 79 20 69 74 65 6d |t match |any item|
|000025a0| 20 6e 61 6d 65 20 69 6e | 20 74 68 65 20 63 75 72 | name in| the cur|
|000025b0| 72 65 6e 74 20 77 6f 72 | 6b 73 68 65 65 74 2e 20 |rent wor|ksheet. |
|000025c0| 54 6f 20 6e 61 6d 65 20 | 61 6e 20 69 74 65 6d 20 |To name |an item |
|000025d0| 66 72 6f 6d 20 61 6e 6f | 74 68 65 72 20 77 6f 72 |from ano|ther wor|
|000025e0| 6b 73 68 65 65 74 20 69 | 6e 20 61 20 66 6f 72 6d |ksheet i|n a form|
|000025f0| 75 6c 61 2c 20 70 72 65 | 63 65 64 65 20 74 68 65 |ula, pre|cede the|
|00002600| 20 69 74 65 6d 20 6e 61 | 6d 65 20 77 69 74 68 20 | item na|me with |
|00002610| 74 68 65 20 77 6f 72 6b | 73 68 65 65 74 20 6e 61 |the work|sheet na|
|00002620| 6d 65 20 66 6f 6c 6c 6f | 77 65 64 20 62 79 20 61 |me follo|wed by a|
|00002630| 20 64 6f 75 62 6c 65 20 | 63 6f 6c 6f 6e 20 28 3a | double |colon (:|
|00002640| 3a 29 2e 20 43 68 65 63 | 6b 20 74 68 65 20 73 70 |:). Chec|k the sp|
|00002650| 65 6c 6c 69 6e 67 20 6f | 66 20 74 68 65 20 6e 61 |elling o|f the na|
|00002660| 6d 65 20 61 6e 64 20 74 | 72 79 20 61 67 61 69 6e |me and t|ry again|
|00002670| 2e 00 25 66 6f 72 6d 75 | 6c 61 25 0d 0a 0d 0a 54 |..%formu|la%....T|
|00002680| 68 65 20 66 6f 72 6d 75 | 6c 61 20 72 65 66 65 72 |he formu|la refer|
|00002690| 65 6e 63 65 20 63 6f 6e | 74 61 69 6e 73 20 6d 6f |ence con|tains mo|
|000026a0| 72 65 20 74 68 61 6e 20 | 6f 6e 65 20 69 74 65 6d |re than |one item|
|000026b0| 20 66 72 6f 6d 20 74 68 | 65 20 73 61 6d 65 20 63 | from th|e same c|
|000026c0| 61 74 65 67 6f 72 79 3a | 20 27 25 69 74 65 6d 25 |ategory:| '%item%|
|000026d0| 27 20 61 6e 64 20 27 25 | 6e 61 6d 65 25 27 2e 20 |' and '%|name%'. |
|000026e0| 49 6e 20 61 20 66 6f 72 | 6d 75 6c 61 20 72 65 66 |In a for|mula ref|
|000026f0| 65 72 65 6e 63 65 2c 20 | 79 6f 75 20 63 61 6e 20 |erence, |you can |
|00002700| 69 6e 63 6c 75 64 65 20 | 6f 6e 6c 79 20 6f 6e 65 |include |only one|
|00002710| 20 69 74 65 6d 20 6f 72 | 20 67 72 6f 75 70 20 66 | item or| group f|
|00002720| 72 6f 6d 20 65 61 63 68 | 20 63 61 74 65 67 6f 72 |rom each| categor|
|00002730| 79 2e 00 41 20 63 61 74 | 65 67 6f 72 79 20 6d 75 |y..A cat|egory mu|
|00002740| 73 74 20 63 6f 6e 74 61 | 69 6e 20 61 74 20 6c 65 |st conta|in at le|
|00002750| 61 73 74 20 6f 6e 65 20 | 69 74 65 6d 2e 20 54 6f |ast one |item. To|
|00002760| 20 64 65 6c 65 74 65 20 | 61 20 63 61 74 65 67 6f | delete |a catego|
|00002770| 72 79 2c 20 64 65 6c 65 | 74 65 20 61 6c 6c 20 62 |ry, dele|te all b|
|00002780| 75 74 20 6f 6e 65 20 69 | 74 65 6d 2c 20 61 6e 64 |ut one i|tem, and|
|00002790| 20 74 68 65 6e 20 73 65 | 6c 65 63 74 20 74 68 65 | then se|lect the|
|000027a0| 20 63 61 74 65 67 6f 72 | 79 20 74 69 6c 65 20 61 | categor|y tile a|
|000027b0| 6e 64 20 63 68 6f 6f 73 | 65 20 45 64 69 74 20 44 |nd choos|e Edit D|
|000027c0| 65 6c 65 74 65 20 43 61 | 74 65 67 6f 72 79 2e 00 |elete Ca|tegory..|
|000027d0| 54 68 69 73 20 69 73 20 | 61 6e 20 49 6d 70 72 6f |This is |an Impro|
|000027e0| 76 20 69 6e 74 65 72 6e | 61 6c 20 65 72 72 6f 72 |v intern|al error|
|000027f0| 2e 20 54 68 65 20 6f 70 | 65 72 61 74 69 6f 6e 20 |. The op|eration |
|00002800| 69 73 20 70 65 72 6d 69 | 74 74 65 64 20 6f 6e 6c |is permi|tted onl|
|00002810| 79 20 6f 6e 20 41 55 54 | 4f 47 45 4e 20 63 61 74 |y on AUT|OGEN cat|
|00002820| 65 67 6f 72 69 65 73 2e | 00 54 68 69 73 20 74 69 |egories.|.This ti|
|00002830| 6d 65 20 73 65 72 69 65 | 73 20 63 61 6e 6e 6f 74 |me serie|s cannot|
|00002840| 20 62 65 20 65 78 74 65 | 6e 64 65 64 20 61 6e 79 | be exte|nded any|
|00002850| 20 66 75 72 74 68 65 72 | 2e 20 46 6f 72 20 65 78 | further|. For ex|
|00002860| 61 6d 70 6c 65 2c 20 79 | 6f 75 20 63 61 6e 6e 6f |ample, y|ou canno|
|00002870| 74 20 61 64 64 20 61 6e | 79 20 6d 6f 6e 74 68 73 |t add an|y months|
|00002880| 20 62 65 79 6f 6e 64 20 | 44 65 63 65 6d 62 65 72 | beyond |December|
|00002890| 2e 20 20 59 6f 75 20 6d | 61 79 20 77 61 6e 74 20 |. You m|ay want |
|000028a0| 74 6f 20 61 64 64 20 61 | 6e 6f 74 68 65 72 20 79 |to add a|nother y|
|000028b0| 65 61 72 20 74 6f 20 67 | 65 74 20 61 64 64 69 74 |ear to g|et addit|
|000028c0| 69 6f 6e 61 6c 20 6d 6f | 6e 74 68 73 2e 00 59 6f |ional mo|nths..Yo|
|000028d0| 75 20 63 61 6e 20 61 64 | 64 20 61 64 64 69 74 69 |u can ad|d additi|
|000028e0| 6f 6e 61 6c 20 69 74 65 | 6d 73 20 74 6f 20 65 69 |onal ite|ms to ei|
|000028f0| 74 68 65 72 20 65 6e 64 | 20 6f 66 20 61 20 74 69 |ther end| of a ti|
|00002900| 6d 65 20 73 65 72 69 65 | 73 2c 20 62 75 74 20 79 |me serie|s, but y|
|00002910| 6f 75 20 63 61 6e 6e 6f | 74 20 69 6e 73 65 72 74 |ou canno|t insert|
|00002920| 20 69 74 65 6d 73 20 69 | 6e 20 74 68 65 20 6d 69 | items i|n the mi|
|00002930| 64 64 6c 65 2e 20 20 46 | 6f 72 20 65 78 61 6d 70 |ddle. F|or examp|
|00002940| 6c 65 2c 20 74 6f 20 61 | 64 64 20 74 68 65 20 6d |le, to a|dd the m|
|00002950| 6f 6e 74 68 20 4a 75 6c | 79 20 74 6f 20 61 20 74 |onth Jul|y to a t|
|00002960| 69 6d 65 20 73 65 72 69 | 65 73 20 74 68 61 74 20 |ime seri|es that |
|00002970| 72 75 6e 73 20 66 72 6f | 6d 20 4a 61 6e 75 61 72 |runs fro|m Januar|
|00002980| 79 20 74 6f 20 4a 75 6e | 65 2c 20 6d 6f 76 65 20 |y to Jun|e, move |
|00002990| 74 68 65 20 63 75 72 73 | 6f 72 20 74 6f 20 4a 75 |the curs|or to Ju|
|000029a0| 6e 65 20 61 6e 64 20 70 | 72 65 73 73 20 45 6e 74 |ne and p|ress Ent|
|000029b0| 65 72 2e 00 59 6f 75 20 | 63 61 6e 20 64 65 6c 65 |er..You |can dele|
|000029c0| 74 65 20 69 74 65 6d 73 | 20 66 72 6f 6d 20 65 69 |te items| from ei|
|000029d0| 74 68 65 72 20 65 6e 64 | 20 6f 66 20 61 20 74 69 |ther end| of a ti|
|000029e0| 6d 65 20 73 65 72 69 65 | 73 2c 20 62 75 74 20 6e |me serie|s, but n|
|000029f0| 6f 74 20 66 72 6f 6d 20 | 74 68 65 20 6d 69 64 64 |ot from |the midd|
|00002a00| 6c 65 20 6f 66 20 74 68 | 65 20 73 65 72 69 65 73 |le of th|e series|
|00002a10| 2e 20 20 49 66 20 79 6f | 75 20 64 6f 20 6e 6f 74 |. If yo|u do not|
|00002a20| 20 77 61 6e 74 20 74 6f | 20 64 69 73 70 6c 61 79 | want to| display|
|00002a30| 20 61 20 74 69 6d 65 20 | 73 65 72 69 65 73 20 69 | a time |series i|
|00002a40| 74 65 6d 2c 20 73 65 6c | 65 63 74 20 74 68 65 20 |tem, sel|ect the |
|00002a50| 69 74 65 6d 20 61 6e 64 | 20 63 68 6f 6f 73 65 20 |item and| choose |
|00002a60| 48 69 64 65 20 53 65 6c | 65 63 74 69 6f 6e 20 66 |Hide Sel|ection f|
|00002a70| 72 6f 6d 20 74 68 65 20 | 56 69 65 77 20 6d 65 6e |rom the |View men|
|00002a80| 75 20 74 6f 20 68 69 64 | 65 20 69 74 2e 00 54 68 |u to hid|e it..Th|
|00002a90| 65 20 49 6d 70 72 6f 76 | 20 66 69 6c 65 20 68 61 |e Improv| file ha|
|00002aa0| 73 20 62 65 65 6e 20 63 | 6f 72 72 75 70 74 65 64 |s been c|orrupted|
|00002ab0| 2e 20 54 72 79 20 6f 70 | 65 6e 69 6e 67 20 61 6e |. Try op|ening an|
|00002ac0| 20 65 61 72 6c 69 65 72 | 20 76 65 72 73 69 6f 6e | earlier| version|
|00002ad0| 2e 00 41 74 20 6c 65 61 | 73 74 20 6f 6e 65 20 69 |..At lea|st one i|
|00002ae0| 74 65 6d 20 69 6e 20 61 | 20 77 6f 72 6b 73 68 65 |tem in a| workshe|
|00002af0| 65 74 20 6d 75 73 74 20 | 73 68 6f 77 2e 20 49 6d |et must |show. Im|
|00002b00| 70 72 6f 76 20 72 65 73 | 65 74 20 74 68 65 20 76 |prov res|et the v|
|00002b10| 69 65 77 20 73 6f 20 74 | 68 61 74 20 61 6c 6c 20 |iew so t|hat all |
|00002b20| 69 74 65 6d 73 20 61 72 | 65 20 73 68 6f 77 69 6e |items ar|e showin|
|00002b30| 67 2e 00 59 6f 75 20 68 | 61 76 65 20 65 78 63 65 |g..You h|ave exce|
|00002b40| 65 64 65 64 20 74 68 65 | 20 6d 61 78 69 6d 75 6d |eded the| maximum|
|00002b50| 20 6f 66 20 25 6e 75 6d | 62 65 72 25 20 69 74 65 | of %num|ber% ite|
|00002b60| 6d 73 20 61 6c 6c 6f 77 | 65 64 20 69 6e 20 61 20 |ms allow|ed in a |
|00002b70| 72 6f 77 2c 20 63 6f 6c | 75 6d 6e 2c 20 6f 72 20 |row, col|umn, or |
|00002b80| 70 61 67 65 2e 20 54 68 | 65 20 72 65 6d 61 69 6e |page. Th|e remain|
|00002b90| 64 65 72 20 77 69 6c 6c | 20 6e 6f 74 20 62 65 20 |der will| not be |
|00002ba0| 73 68 6f 77 6e 2e 00 59 | 6f 75 20 74 72 69 65 64 |shown..Y|ou tried|
|00002bb0| 20 74 6f 20 64 65 6c 65 | 74 65 20 74 68 65 20 6f | to dele|te the o|
|00002bc0| 6e 6c 79 20 63 61 74 65 | 67 6f 72 79 20 69 6e 20 |nly cate|gory in |
|00002bd0| 61 20 77 6f 72 6b 73 68 | 65 65 74 2e 20 45 76 65 |a worksh|eet. Eve|
|00002be0| 72 79 20 77 6f 72 6b 73 | 68 65 65 74 20 6d 75 73 |ry works|heet mus|
|00002bf0| 74 20 68 61 76 65 20 61 | 74 20 6c 65 61 73 74 20 |t have a|t least |
|00002c00| 6f 6e 65 20 63 61 74 65 | 67 6f 72 79 2e 00 54 6f |one cate|gory..To|
|00002c10| 20 64 65 6c 65 74 65 20 | 61 20 63 61 74 65 67 6f | delete |a catego|
|00002c20| 72 79 2c 20 66 69 72 73 | 74 20 64 65 6c 65 74 65 |ry, firs|t delete|
|00002c30| 20 61 6c 6c 20 62 75 74 | 20 6f 6e 65 20 69 74 65 | all but| one ite|
|00002c40| 6d 20 69 6e 20 74 68 65 | 20 63 61 74 65 67 6f 72 |m in the| categor|
|00002c50| 79 2e 20 54 68 65 6e 20 | 73 65 6c 65 63 74 20 74 |y. Then |select t|
|00002c60| 68 65 20 63 61 74 65 67 | 6f 72 79 20 74 69 6c 65 |he categ|ory tile|
|00002c70| 20 61 6e 64 20 70 72 65 | 73 73 20 44 45 4c 45 54 | and pre|ss DELET|
|00002c80| 45 2e 00 49 66 20 79 6f | 75 20 64 65 6c 65 74 65 |E..If yo|u delete|
|00002c90| 20 74 68 69 73 20 63 61 | 74 65 67 6f 72 79 2c 20 | this ca|tegory, |
|00002ca0| 66 6f 72 6d 75 6c 61 73 | 20 74 68 61 74 20 63 75 |formulas| that cu|
|00002cb0| 72 72 65 6e 74 6c 79 20 | 63 61 6c 63 75 6c 61 74 |rrently |calculat|
|00002cc0| 65 20 76 61 6c 75 65 73 | 20 77 69 6c 6c 20 62 72 |e values| will br|
|00002cd0| 65 61 6b 2e 20 49 6d 70 | 72 6f 76 20 74 72 65 61 |eak. Imp|rov trea|
|00002ce0| 74 73 20 62 72 6f 6b 65 | 6e 20 66 6f 72 6d 75 6c |ts broke|n formul|
|00002cf0| 61 73 20 61 73 20 69 66 | 20 74 68 65 79 20 63 6f |as as if| they co|
|00002d00| 6e 74 61 69 6e 20 65 72 | 72 6f 72 73 20 61 6e 64 |ntain er|rors and|
|00002d10| 20 64 6f 65 73 20 6e 6f | 74 20 75 73 65 20 74 68 | does no|t use th|
|00002d20| 65 6d 20 74 6f 20 63 61 | 6c 63 75 6c 61 74 65 20 |em to ca|lculate |
|00002d30| 63 65 6c 6c 20 76 61 6c | 75 65 73 2e 00 54 68 65 |cell val|ues..The|
|00002d40| 20 6e 61 6d 65 20 79 6f | 75 20 65 6e 74 65 72 65 | name yo|u entere|
|00002d50| 64 0d 0a 0d 0a 25 6e 61 | 6d 65 25 0d 0a 0d 0a 69 |d....%na|me%....i|
|00002d60| 73 20 6e 6f 74 20 76 61 | 6c 69 64 20 62 65 63 61 |s not va|lid beca|
|00002d70| 75 73 65 20 69 74 20 68 | 61 73 20 6d 6f 72 65 20 |use it h|as more |
|00002d80| 74 68 61 6e 20 31 30 30 | 20 63 68 61 72 61 63 74 |than 100| charact|
|00002d90| 65 72 73 2e 20 45 6e 74 | 65 72 20 61 20 73 68 6f |ers. Ent|er a sho|
|00002da0| 72 74 65 72 20 6e 61 6d | 65 2e 00 54 68 65 20 6e |rter nam|e..The n|
|00002db0| 61 6d 65 20 79 6f 75 20 | 65 6e 74 65 72 65 64 20 |ame you |entered |
|00002dc0| 69 73 20 6e 6f 74 20 76 | 61 6c 69 64 20 62 65 63 |is not v|alid bec|
|00002dd0| 61 75 73 65 20 69 74 20 | 64 6f 65 73 20 6e 6f 74 |ause it |does not|
|00002de0| 20 68 61 76 65 20 61 74 | 20 6c 65 61 73 74 20 6f | have at| least o|
|00002df0| 6e 65 20 61 6c 70 68 61 | 6e 75 6d 65 72 69 63 20 |ne alpha|numeric |
|00002e00| 63 68 61 72 61 63 74 65 | 72 2e 00 54 68 65 20 6e |characte|r..The n|
|00002e10| 61 6d 65 20 79 6f 75 20 | 65 6e 74 65 72 65 64 0d |ame you |entered.|
|00002e20| 0a 0d 0a 25 6e 61 6d 65 | 25 0d 0a 0d 0a 69 73 20 |...%name|%....is |
|00002e30| 6e 6f 74 20 76 61 6c 69 | 64 20 62 65 63 61 75 73 |not vali|d becaus|
|00002e40| 65 20 69 74 20 69 6e 63 | 6c 75 64 65 73 20 61 20 |e it inc|ludes a |
|00002e50| 63 6f 6c 6f 6e 2c 20 61 | 20 74 61 62 2c 20 6f 72 |colon, a| tab, or|
|00002e60| 20 61 20 63 61 72 72 69 | 61 67 65 20 72 65 74 75 | a carri|age retu|
|00002e70| 72 6e 2e 00 41 6e 6f 74 | 68 65 72 20 69 74 65 6d |rn..Anot|her item|
|00002e80| 20 6f 72 20 63 61 74 65 | 67 6f 72 79 20 69 73 20 | or cate|gory is |
|00002e90| 6e 61 6d 65 64 20 27 25 | 6e 61 6d 65 25 27 2e 20 |named '%|name%'. |
|00002ea0| 45 6e 74 65 72 20 61 20 | 75 6e 69 71 75 65 20 6e |Enter a |unique n|
|00002eb0| 61 6d 65 2e 00 25 6e 61 | 6d 65 25 0d 0a 0d 0a 41 |ame..%na|me%....A|
|00002ec0| 6e 20 69 74 65 6d 20 6e | 61 6d 65 20 69 6e 20 61 |n item n|ame in a|
|00002ed0| 20 66 75 6c 6c 20 6e 61 | 6d 65 20 69 73 20 6e 6f | full na|me is no|
|00002ee0| 74 20 76 61 6c 69 64 20 | 62 65 63 61 75 73 65 20 |t valid |because |
|00002ef0| 69 74 20 63 61 6e 6e 6f | 74 20 62 65 20 73 70 65 |it canno|t be spe|
|00002f00| 63 69 66 69 65 64 20 61 | 74 20 74 68 65 20 73 61 |cified a|t the sa|
|00002f10| 6d 65 20 74 69 6d 65 20 | 61 73 20 6f 74 68 65 72 |me time |as other|
|00002f20| 20 69 74 65 6d 73 20 74 | 68 61 74 20 70 72 65 63 | items t|hat prec|
|00002f30| 65 64 65 20 69 74 2e 20 | 49 74 20 69 73 20 6e 6f |ede it. |It is no|
|00002f40| 74 20 70 6f 73 73 69 62 | 6c 65 20 74 6f 20 73 70 |t possib|le to sp|
|00002f50| 65 63 69 66 79 20 61 6e | 20 69 74 65 6d 20 66 72 |ecify an| item fr|
|00002f60| 6f 6d 20 74 68 61 74 20 | 63 61 74 65 67 6f 72 79 |om that |category|
|00002f70| 20 61 6c 6f 6e 67 20 77 | 69 74 68 20 69 74 65 6d | along w|ith item|
|00002f80| 73 20 66 72 6f 6d 20 74 | 68 65 20 63 61 74 65 67 |s from t|he categ|
|00002f90| 6f 72 69 65 73 20 61 6c | 72 65 61 64 79 20 73 70 |ories al|ready sp|
|00002fa0| 65 63 69 66 69 65 64 2e | 00 25 66 6f 72 6d 75 6c |ecified.|.%formul|
|00002fb0| 61 25 0d 0a 0d 0a 59 6f | 75 20 70 72 65 63 65 64 |a%....Yo|u preced|
|00002fc0| 65 64 20 61 20 62 72 61 | 63 6b 65 74 65 64 20 72 |ed a bra|cketed r|
|00002fd0| 65 63 75 72 72 65 6e 63 | 65 20 6b 65 79 77 6f 72 |ecurrenc|e keywor|
|00002fe0| 64 20 61 6e 64 2f 6f 72 | 20 69 6e 74 65 67 65 72 |d and/or| integer|
|00002ff0| 20 77 69 74 68 20 61 20 | 6e 61 6d 65 20 6f 74 68 | with a |name oth|
|00003000| 65 72 20 74 68 61 6e 20 | 61 20 67 72 6f 75 70 20 |er than |a group |
|00003010| 6f 72 20 63 61 74 65 67 | 6f 72 79 20 6e 61 6d 65 |or categ|ory name|
|00003020| 2e 00 25 66 6f 72 6d 75 | 6c 61 25 0d 0a 0d 0a 54 |..%formu|la%....T|
|00003030| 68 65 20 76 61 6c 75 65 | 20 79 6f 75 20 73 70 65 |he value| you spe|
|00003040| 63 69 66 69 65 64 20 75 | 73 69 6e 67 20 61 20 62 |cified u|sing a b|
|00003050| 72 61 63 6b 65 74 65 64 | 20 72 65 63 75 72 72 65 |racketed| recurre|
|00003060| 6e 63 65 20 6b 65 79 77 | 6f 72 64 20 61 6e 64 2f |nce keyw|ord and/|
|00003070| 6f 72 20 69 6e 74 65 67 | 65 72 20 69 73 20 74 6f |or integ|er is to|
|00003080| 6f 20 6c 61 72 67 65 2e | 20 54 68 65 20 67 72 6f |o large.| The gro|
|00003090| 75 70 20 6f 72 20 63 61 | 74 65 67 6f 72 79 20 64 |up or ca|tegory d|
|000030a0| 6f 65 73 20 6e 6f 74 20 | 63 6f 6e 74 61 69 6e 20 |oes not |contain |
|000030b0| 61 6e 20 69 74 65 6d 20 | 61 74 20 74 68 61 74 20 |an item |at that |
|000030c0| 70 6f 73 69 74 69 6f 6e | 2e 00 25 66 6f 72 6d 75 |position|..%formu|
|000030d0| 6c 61 25 0d 0a 0d 0a 57 | 69 74 68 69 6e 20 73 71 |la%....W|ithin sq|
|000030e0| 75 61 72 65 20 62 72 61 | 63 6b 65 74 73 2c 20 79 |uare bra|ckets, y|
|000030f0| 6f 75 20 6d 61 79 20 69 | 6e 63 6c 75 64 65 20 6f |ou may i|nclude o|
|00003100| 6e 6c 79 20 61 20 72 65 | 63 75 72 72 65 6e 63 65 |nly a re|currence|
|00003110| 20 6b 65 79 77 6f 72 64 | 20 6f 72 20 61 20 72 65 | keyword| or a re|
|00003120| 63 75 72 72 65 6e 63 65 | 20 6b 65 79 77 6f 72 64 |currence| keyword|
|00003130| 20 70 6c 75 73 20 6f 72 | 20 6d 69 6e 75 73 20 61 | plus or| minus a|
|00003140| 6e 20 69 6e 74 65 67 65 | 72 2e 00 44 65 6c 65 74 |n intege|r..Delet|
|00003150| 69 6e 67 20 61 6c 6c 20 | 76 69 65 77 73 20 6f 66 |ing all |views of|
|00003160| 20 61 20 77 6f 72 6b 73 | 68 65 65 74 20 64 65 6c | a works|heet del|
|00003170| 65 74 65 73 20 74 68 65 | 20 77 6f 72 6b 73 68 65 |etes the| workshe|
|00003180| 65 74 2e 20 49 66 20 79 | 6f 75 20 64 65 6c 65 74 |et. If y|ou delet|
|00003190| 65 20 74 68 65 20 77 6f | 72 6b 73 68 65 65 74 2c |e the wo|rksheet,|
|000031a0| 20 61 6c 6c 20 69 74 65 | 6d 73 2c 20 63 61 74 65 | all ite|ms, cate|
|000031b0| 67 6f 72 69 65 73 2c 20 | 66 6f 72 6d 75 6c 61 73 |gories, |formulas|
|000031c0| 2c 20 61 6e 64 20 76 61 | 6c 75 65 73 20 69 6e 20 |, and va|lues in |
|000031d0| 74 68 65 20 77 6f 72 6b | 73 68 65 65 74 20 77 69 |the work|sheet wi|
|000031e0| 6c 6c 20 62 65 20 70 65 | 72 6d 61 6e 65 6e 74 6c |ll be pe|rmanentl|
|000031f0| 79 20 64 65 6c 65 74 65 | 64 20 66 72 6f 6d 20 74 |y delete|d from t|
|00003200| 68 65 20 6d 6f 64 65 6c | 2e 00 41 6e 6f 74 68 65 |he model|..Anothe|
|00003210| 72 20 77 6f 72 6b 73 68 | 65 65 74 20 69 73 20 6e |r worksh|eet is n|
|00003220| 61 6d 65 64 20 27 25 6e | 61 6d 65 25 27 2e 20 45 |amed '%n|ame%'. E|
|00003230| 6e 74 65 72 20 61 20 75 | 6e 69 71 75 65 20 6e 61 |nter a u|nique na|
|00003240| 6d 65 2e 00 54 68 65 20 | 73 65 6c 65 63 74 69 6f |me..The |selectio|
|00003250| 6e 20 63 6f 6e 74 61 69 | 6e 73 20 69 74 65 6d 73 |n contai|ns items|
|00003260| 20 66 72 6f 6d 20 6d 6f | 72 65 20 74 68 61 6e 20 | from mo|re than |
|00003270| 6f 6e 65 20 63 61 74 65 | 67 6f 72 79 2e 20 53 65 |one cate|gory. Se|
|00003280| 6c 65 63 74 20 69 74 65 | 6d 73 20 66 72 6f 6d 20 |lect ite|ms from |
|00003290| 74 68 65 20 73 61 6d 65 | 20 63 61 74 65 67 6f 72 |the same| categor|
|000032a0| 79 2c 20 61 6e 64 20 74 | 72 79 20 74 68 65 20 63 |y, and t|ry the c|
|000032b0| 6f 6d 6d 61 6e 64 20 61 | 67 61 69 6e 2e 00 49 66 |ommand a|gain..If|
|000032c0| 20 79 6f 75 20 63 6c 69 | 63 6b 20 4f 4b 2c 20 74 | you cli|ck OK, t|
|000032d0| 68 65 20 63 6f 6e 74 65 | 6e 74 73 20 6f 66 20 74 |he conte|nts of t|
|000032e0| 68 65 20 61 73 73 6f 63 | 69 61 74 65 64 20 63 65 |he assoc|iated ce|
|000032f0| 6c 6c 73 20 77 69 6c 6c | 20 62 65 20 64 65 73 74 |lls will| be dest|
|00003300| 72 6f 79 65 64 2e 00 49 | 66 20 79 6f 75 20 63 6c |royed..I|f you cl|
|00003310| 69 63 6b 20 4f 4b 2c 20 | 74 68 65 20 63 6f 6e 74 |ick OK, |the cont|
|00003320| 65 6e 74 73 20 6f 66 20 | 74 68 65 20 73 65 6c 65 |ents of |the sele|
|00003330| 63 74 65 64 20 63 65 6c | 6c 20 77 69 6c 6c 20 62 |cted cel|l will b|
|00003340| 65 20 64 65 73 74 72 6f | 79 65 64 2e 00 49 66 20 |e destro|yed..If |
|00003350| 79 6f 75 20 63 6c 69 63 | 6b 20 4f 4b 2c 20 74 68 |you clic|k OK, th|
|00003360| 65 20 63 6f 6e 74 65 6e | 74 73 20 6f 66 20 74 68 |e conten|ts of th|
|00003370| 65 20 73 65 6c 65 63 74 | 65 64 20 63 65 6c 6c 73 |e select|ed cells|
|00003380| 20 77 69 6c 6c 20 62 65 | 20 64 65 73 74 72 6f 79 | will be| destroy|
|00003390| 65 64 2e 00 53 6f 6d 65 | 20 6f 66 20 74 68 65 20 |ed..Some| of the |
|000033a0| 73 65 6c 65 63 74 65 64 | 20 69 74 65 6d 73 20 61 |selected| items a|
|000033b0| 72 65 20 72 65 66 65 72 | 72 65 64 20 74 6f 20 69 |re refer|red to i|
|000033c0| 6e 20 66 6f 72 6d 75 6c | 61 73 20 28 65 69 74 68 |n formul|as (eith|
|000033d0| 65 72 20 65 78 70 6c 69 | 63 69 74 6c 79 20 6f 72 |er expli|citly or|
|000033e0| 20 69 6d 70 6c 69 63 69 | 74 6c 79 29 2e 20 49 66 | implici|tly). If|
|000033f0| 20 79 6f 75 20 63 6c 69 | 63 6b 20 4f 4b 2c 20 74 | you cli|ck OK, t|
|00003400| 68 6f 73 65 20 66 6f 72 | 6d 75 6c 61 73 20 77 69 |hose for|mulas wi|
|00003410| 6c 6c 20 6e 6f 20 6c 6f | 6e 67 65 72 20 63 61 6c |ll no lo|nger cal|
|00003420| 63 75 6c 61 74 65 20 63 | 65 6c 6c 20 76 61 6c 75 |culate c|ell valu|
|00003430| 65 73 2e 00 4f 6e 65 20 | 6f 72 20 6d 6f 72 65 20 |es..One |or more |
|00003440| 6f 66 20 74 68 65 20 69 | 74 65 6d 73 20 69 6e 20 |of the i|tems in |
|00003450| 74 68 65 20 67 72 6f 75 | 70 20 79 6f 75 20 61 72 |the grou|p you ar|
|00003460| 65 20 75 6e 67 72 6f 75 | 70 69 6e 67 20 68 61 73 |e ungrou|ping has|
|00003470| 20 74 68 65 20 73 61 6d | 65 20 6e 61 6d 65 20 61 | the sam|e name a|
|00003480| 73 20 61 6e 20 69 74 65 | 6d 20 61 6c 72 65 61 64 |s an ite|m alread|
|00003490| 79 20 61 74 20 74 68 69 | 73 20 6c 65 76 65 6c 2e |y at thi|s level.|
|000034a0| 20 52 65 6e 61 6d 65 20 | 65 69 74 68 65 72 20 6f | Rename |either o|
|000034b0| 66 20 74 68 65 73 65 20 | 69 74 65 6d 73 20 62 65 |f these |items be|
|000034c0| 66 6f 72 65 20 70 72 6f | 63 65 65 64 69 6e 67 2e |fore pro|ceeding.|
|000034d0| 00 4f 6e 65 20 6f 72 20 | 6d 6f 72 65 20 6f 66 20 |.One or |more of |
|000034e0| 74 68 65 20 69 74 65 6d | 73 20 69 6e 20 61 20 67 |the item|s in a g|
|000034f0| 72 6f 75 70 20 79 6f 75 | 20 61 72 65 20 75 6e 67 |roup you| are ung|
|00003500| 72 6f 75 70 69 6e 67 20 | 68 61 73 20 74 68 65 20 |rouping |has the |
|00003510| 73 61 6d 65 20 6e 61 6d | 65 20 61 73 20 61 6e 20 |same nam|e as an |
|00003520| 69 74 65 6d 20 69 6e 20 | 61 6e 6f 74 68 65 72 20 |item in |another |
|00003530| 67 72 6f 75 70 20 79 6f | 75 20 61 72 65 20 75 6e |group yo|u are un|
|00003540| 67 72 6f 75 70 69 6e 67 | 2e 20 52 65 6e 61 6d 65 |grouping|. Rename|
|00003550| 20 65 69 74 68 65 72 20 | 6f 66 20 74 68 65 73 65 | either |of these|
|00003560| 20 69 74 65 6d 73 20 62 | 65 66 6f 72 65 20 70 72 | items b|efore pr|
|00003570| 6f 63 65 65 64 69 6e 67 | 2e 00 59 6f 75 20 63 61 |oceeding|..You ca|
|00003580| 6e 6e 6f 74 20 63 75 74 | 20 63 61 6c 63 75 6c 61 |nnot cut| calcula|
|00003590| 74 65 64 20 76 61 6c 75 | 65 73 2e 20 49 66 20 79 |ted valu|es. If y|
|000035a0| 6f 75 20 63 6c 69 63 6b | 20 4f 4b 2c 20 49 6d 70 |ou click| OK, Imp|
|000035b0| 72 6f 76 20 63 6f 70 69 | 65 73 20 63 61 6c 63 75 |rov copi|es calcu|
|000035c0| 6c 61 74 65 64 20 76 61 | 6c 75 65 73 20 74 6f 20 |lated va|lues to |
|000035d0| 74 68 65 20 63 6c 69 70 | 62 6f 61 72 64 2e 20 49 |the clip|board. I|
|000035e0| 66 20 74 68 65 20 73 65 | 6c 65 63 74 69 6f 6e 20 |f the se|lection |
|000035f0| 63 6f 6e 74 61 69 6e 73 | 20 61 6e 79 20 64 61 74 |contains| any dat|
|00003600| 61 20 6f 76 65 72 6c 61 | 70 73 2c 20 49 6d 70 72 |a overla|ps, Impr|
|00003610| 6f 76 20 63 75 74 73 20 | 74 68 65 20 64 61 74 61 |ov cuts |the data|
|00003620| 20 61 6e 64 20 64 69 73 | 70 6c 61 79 73 20 74 68 | and dis|plays th|
|00003630| 65 20 63 61 6c 63 75 6c | 61 74 65 64 20 76 61 6c |e calcul|ated val|
|00003640| 75 65 73 20 69 6e 20 74 | 68 65 20 63 65 6c 6c 73 |ues in t|he cells|
|00003650| 2e 20 49 66 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |. If you| want to|
|00003660| 20 6f 76 65 72 6c 61 70 | 20 63 61 6c 63 75 6c 61 | overlap| calcula|
|00003670| 74 65 64 20 76 61 6c 75 | 65 73 20 77 69 74 68 20 |ted valu|es with |
|00003680| 62 6c 61 6e 6b 20 63 65 | 6c 6c 73 2c 20 75 73 65 |blank ce|lls, use|
|00003690| 20 45 64 69 74 20 43 6c | 65 61 72 20 72 61 74 68 | Edit Cl|ear rath|
|000036a0| 65 72 20 74 68 61 6e 20 | 45 64 69 74 20 43 75 74 |er than |Edit Cut|
|000036b0| 2e 00 46 6f 72 6d 75 6c | 61 73 20 61 72 65 20 61 |..Formul|as are a|
|000036c0| 6c 72 65 61 64 79 20 63 | 61 6c 63 75 6c 61 74 69 |lready c|alculati|
|000036d0| 6e 67 20 76 61 6c 75 65 | 73 20 69 6e 20 74 68 69 |ng value|s in thi|
|000036e0| 73 20 73 65 6c 65 63 74 | 69 6f 6e 2e 20 49 66 20 |s select|ion. If |
|000036f0| 79 6f 75 20 63 6c 69 63 | 6b 20 4f 4b 2c 20 74 68 |you clic|k OK, th|
|00003700| 65 20 76 61 6c 75 65 73 | 20 79 6f 75 20 70 61 73 |e values| you pas|
|00003710| 74 65 20 77 69 6c 6c 20 | 6f 76 65 72 6c 61 70 20 |te will |overlap |
|00003720| 63 61 6c 63 75 6c 61 74 | 65 64 20 76 61 6c 75 65 |calculat|ed value|
|00003730| 73 2e 00 54 68 65 20 73 | 65 6c 65 63 74 69 6f 6e |s..The s|election|
|00003740| 20 63 6f 6e 74 61 69 6e | 73 20 63 65 6c 6c 73 20 | contain|s cells |
|00003750| 77 68 6f 73 65 20 76 61 | 6c 75 65 73 20 61 72 65 |whose va|lues are|
|00003760| 20 63 61 6c 63 75 6c 61 | 74 65 64 20 62 79 20 66 | calcula|ted by f|
|00003770| 6f 72 6d 75 6c 61 73 2e | 20 49 66 20 79 6f 75 20 |ormulas.| If you |
|00003780| 70 72 6f 63 65 65 64 2c | 20 63 61 6c 63 75 6c 61 |proceed,| calcula|
|00003790| 74 65 64 20 63 65 6c 6c | 20 76 61 6c 75 65 73 20 |ted cell| values |
|000037a0| 77 69 6c 6c 20 62 65 20 | 6f 76 65 72 6c 61 70 70 |will be |overlapp|
|000037b0| 65 64 20 62 79 20 62 6c | 61 6e 6b 20 63 65 6c 6c |ed by bl|ank cell|
|000037c0| 73 2e 20 49 66 20 79 6f | 75 20 63 6c 69 63 6b 20 |s. If yo|u click |
|000037d0| 4e 6f 2c 20 61 6e 79 20 | 64 61 74 61 20 6f 76 65 |No, any |data ove|
|000037e0| 72 6c 61 70 70 69 6e 67 | 20 76 61 6c 75 65 73 20 |rlapping| values |
|000037f0| 74 68 61 74 20 61 72 65 | 20 63 61 6c 63 75 6c 61 |that are| calcula|
|00003800| 74 65 64 20 62 79 20 66 | 6f 72 6d 75 6c 61 73 20 |ted by f|ormulas |
|00003810| 77 69 6c 6c 20 62 65 20 | 64 65 6c 65 74 65 64 2c |will be |deleted,|
|00003820| 20 61 6e 64 20 74 68 65 | 20 63 61 6c 63 75 6c 61 | and the| calcula|
|00003830| 74 65 64 20 76 61 6c 75 | 65 73 20 77 69 6c 6c 20 |ted valu|es will |
|00003840| 6f 63 63 75 70 79 20 74 | 68 65 20 63 65 6c 6c 73 |occupy t|he cells|
|00003850| 2e 20 41 6e 79 20 6f 74 | 68 65 72 20 63 65 6c 6c |. Any ot|her cell|
|00003860| 20 76 61 6c 75 65 73 20 | 69 6e 63 6c 75 64 65 64 | values |included|
|00003870| 20 69 6e 20 74 68 65 20 | 73 65 6c 65 63 74 69 6f | in the |selectio|
|00003880| 6e 20 77 69 6c 6c 20 62 | 65 20 64 65 6c 65 74 65 |n will b|e delete|
|00003890| 64 2e 00 54 68 65 20 73 | 65 6c 65 63 74 69 6f 6e |d..The s|election|
|000038a0| 20 6f 6e 20 74 68 65 20 | 63 6c 69 70 62 6f 61 72 | on the |clipboar|
|000038b0| 64 20 69 73 20 6c 61 72 | 67 65 72 20 74 68 61 6e |d is lar|ger than|
|000038c0| 20 74 68 65 20 64 65 73 | 74 69 6e 61 74 69 6f 6e | the des|tination|
|000038d0| 20 73 65 6c 65 63 74 69 | 6f 6e 2e 20 49 66 20 79 | selecti|on. If y|
|000038e0| 6f 75 20 70 72 6f 63 65 | 65 64 2c 20 6f 6e 6c 79 |ou proce|ed, only|
|000038f0| 20 74 68 65 20 63 65 6c | 6c 73 20 74 68 61 74 20 | the cel|ls that |
|00003900| 66 69 74 20 69 6e 74 6f | 20 74 68 65 20 64 65 73 |fit into| the des|
|00003910| 74 69 6e 61 74 69 6f 6e | 20 73 65 6c 65 63 74 69 |tination| selecti|
|00003920| 6f 6e 20 77 69 6c 6c 20 | 62 65 20 70 61 73 74 65 |on will |be paste|
|00003930| 64 2e 00 54 68 65 20 73 | 65 6c 65 63 74 69 6f 6e |d..The s|election|
|00003940| 20 6f 6e 20 74 68 65 20 | 63 6c 69 70 62 6f 61 72 | on the |clipboar|
|00003950| 64 20 77 69 6c 6c 20 6e | 6f 74 20 66 69 74 20 61 |d will n|ot fit a|
|00003960| 74 20 74 68 69 73 20 70 | 6f 73 69 74 69 6f 6e 20 |t this p|osition |
|00003970| 77 69 74 68 69 6e 20 74 | 68 65 20 63 75 72 72 65 |within t|he curre|
|00003980| 6e 74 20 62 6f 75 6e 64 | 61 72 69 65 73 20 6f 66 |nt bound|aries of|
|00003990| 20 74 68 65 20 77 6f 72 | 6b 73 68 65 65 74 2e 20 | the wor|ksheet. |
|000039a0| 49 66 20 79 6f 75 20 70 | 72 6f 63 65 65 64 2c 20 |If you p|roceed, |
|000039b0| 6f 6e 6c 79 20 74 68 65 | 20 63 65 6c 6c 73 20 74 |only the| cells t|
|000039c0| 68 61 74 20 66 69 74 20 | 77 69 74 68 69 6e 20 74 |hat fit |within t|
|000039d0| 68 65 20 77 6f 72 6b 73 | 68 65 65 74 20 77 69 6c |he works|heet wil|
|000039e0| 6c 20 62 65 20 70 61 73 | 74 65 64 2e 00 59 6f 75 |l be pas|ted..You|
|000039f0| 20 6d 61 64 65 20 61 20 | 72 65 66 69 6e 65 64 2d | made a |refined-|
|00003a00| 69 74 65 6d 20 73 65 6c | 65 63 74 69 6f 6e 20 74 |item sel|ection t|
|00003a10| 68 61 74 20 69 64 65 6e | 74 69 66 69 65 73 20 6f |hat iden|tifies o|
|00003a20| 6e 6c 79 20 6f 6e 65 20 | 63 65 6c 6c 2e 20 59 6f |nly one |cell. Yo|
|00003a30| 75 20 63 61 6e 6e 6f 74 | 20 70 61 73 74 65 20 61 |u cannot| paste a|
|00003a40| 20 6d 75 6c 74 69 70 6c | 65 2d 63 65 6c 6c 20 73 | multipl|e-cell s|
|00003a50| 65 6c 65 63 74 69 6f 6e | 20 69 6e 74 6f 20 74 68 |election| into th|
|00003a60| 69 73 20 6b 69 6e 64 20 | 6f 66 20 73 65 6c 65 63 |is kind |of selec|
|00003a70| 74 69 6f 6e 2e 20 49 6e | 73 74 65 61 64 2c 20 63 |tion. In|stead, c|
|00003a80| 6c 69 63 6b 20 74 68 65 | 20 63 65 6c 6c 20 61 6e |lick the| cell an|
|00003a90| 64 20 74 68 65 6e 20 63 | 68 6f 6f 73 65 20 45 64 |d then c|hoose Ed|
|00003aa0| 69 74 20 50 61 73 74 65 | 2e 00 59 6f 75 20 63 61 |it Paste|..You ca|
|00003ab0| 6e 6e 6f 74 20 64 65 6c | 65 74 65 20 61 6e 20 69 |nnot del|ete an i|
|00003ac0| 74 65 6d 73 2d 6f 6e 6c | 79 20 73 65 6c 65 63 74 |tems-onl|y select|
|00003ad0| 69 6f 6e 2e 20 53 65 6c | 65 63 74 20 62 6f 74 68 |ion. Sel|ect both|
|00003ae0| 20 69 74 65 6d 20 6e 61 | 6d 65 73 20 61 6e 64 20 | item na|mes and |
|00003af0| 63 65 6c 6c 73 20 69 6e | 73 74 65 61 64 2e 00 59 |cells in|stead..Y|
|00003b00| 6f 75 20 63 61 6e 6e 6f | 74 20 63 75 74 20 61 6e |ou canno|t cut an|
|00003b10| 20 69 74 65 6d 2d 6e 61 | 6d 65 73 2d 6f 6e 6c 79 | item-na|mes-only|
|00003b20| 20 73 65 6c 65 63 74 69 | 6f 6e 2e 20 49 66 20 79 | selecti|on. If y|
|00003b30| 6f 75 20 70 72 6f 63 65 | 65 64 2c 20 74 68 65 20 |ou proce|ed, the |
|00003b40| 73 65 6c 65 63 74 69 6f | 6e 20 77 69 6c 6c 20 62 |selectio|n will b|
|00003b50| 65 20 63 6f 70 69 65 64 | 20 72 61 74 68 65 72 20 |e copied| rather |
|00003b60| 74 68 61 6e 20 63 75 74 | 2e 00 57 68 65 6e 20 79 |than cut|..When y|
|00003b70| 6f 75 20 65 6e 74 65 72 | 20 74 68 65 20 6e 61 6d |ou enter| the nam|
|00003b80| 65 0d 0a 0d 0a 25 6e 61 | 6d 65 25 0d 0a 0d 0a 20 |e....%na|me%.... |
|00003b90| 69 6e 20 61 20 66 6f 72 | 6d 75 6c 61 2c 20 69 6e |in a for|mula, in|
|00003ba0| 63 6c 75 64 65 20 61 20 | 73 65 63 6f 6e 64 20 61 |clude a |second a|
|00003bb0| 70 6f 73 74 72 6f 70 68 | 65 20 6e 65 78 74 20 74 |postroph|e next t|
|00003bc0| 6f 20 65 61 63 68 20 61 | 70 6f 73 74 72 6f 70 68 |o each a|postroph|
|00003bd0| 65 20 69 6e 20 74 68 65 | 20 6e 61 6d 65 2c 20 62 |e in the| name, b|
|00003be0| 65 63 61 75 73 65 20 25 | 72 65 61 73 6f 6e 25 2e |ecause %|reason%.|
|00003bf0| 0d 0a 0d 0a 20 43 6c 69 | 63 6b 20 4f 4b 20 74 6f |.... Cli|ck OK to|
|00003c00| 20 61 63 63 65 70 74 20 | 74 68 65 20 6e 61 6d 65 | accept |the name|
|00003c10| 20 6f 72 20 63 6c 69 63 | 6b 20 43 61 6e 63 65 6c | or clic|k Cancel|
|00003c20| 20 74 6f 20 63 61 6e 63 | 65 6c 20 74 68 65 20 63 | to canc|el the c|
|00003c30| 6f 6d 6d 61 6e 64 2e 00 | 54 68 65 20 63 6c 69 70 |ommand..|The clip|
|00003c40| 62 6f 61 72 64 20 63 6f | 6e 74 61 69 6e 73 20 61 |board co|ntains a|
|00003c50| 20 6d 75 6c 74 69 70 6c | 65 20 72 6f 77 20 6f 72 | multipl|e row or|
|00003c60| 20 63 6f 6c 75 6d 6e 20 | 73 65 6c 65 63 74 69 6f | column |selectio|
|00003c70| 6e 2e 54 6f 20 70 61 73 | 74 65 20 69 6e 74 6f 20 |n.To pas|te into |
|00003c80| 74 68 65 20 69 74 65 6d | 20 6e 61 6d 65 20 61 72 |the item| name ar|
|00003c90| 65 61 2c 20 63 75 74 20 | 6f 72 20 63 6f 70 79 20 |ea, cut |or copy |
|00003ca0| 61 20 73 69 6e 67 6c 65 | 20 72 6f 77 20 6f 72 20 |a single| row or |
|00003cb0| 63 6f 6c 75 6d 6e 20 61 | 6e 64 20 74 68 65 6e 20 |column a|nd then |
|00003cc0| 70 61 73 74 65 2e 00 54 | 68 65 20 6e 61 6d 65 20 |paste..T|he name |
|00003cd0| 6f 66 20 74 68 69 73 20 | 63 61 74 65 67 6f 72 79 |of this |category|
|00003ce0| 20 69 73 20 75 73 65 64 | 20 74 6f 20 6d 61 70 20 | is used| to map |
|00003cf0| 69 74 20 74 6f 20 6f 6e | 65 20 6f 72 20 6d 6f 72 |it to on|e or mor|
|00003d00| 65 20 63 61 74 65 67 6f | 72 69 65 73 20 69 6e 20 |e catego|ries in |
|00003d10| 6f 74 68 65 72 20 77 6f | 72 6b 73 68 65 65 74 73 |other wo|rksheets|
|00003d20| 2e 20 20 52 65 6e 61 6d | 69 6e 67 20 74 68 65 20 |. Renam|ing the |
|00003d30| 63 61 74 65 67 6f 72 79 | 20 6d 61 79 20 62 72 65 |category| may bre|
|00003d40| 61 6b 20 69 6e 74 65 72 | 73 68 65 65 74 20 66 6f |ak inter|sheet fo|
|00003d50| 72 6d 75 6c 61 73 20 74 | 68 61 74 20 72 65 6c 79 |rmulas t|hat rely|
|00003d60| 20 6f 6e 20 74 68 69 73 | 20 6d 61 70 70 69 6e 67 | on this| mapping|
|00003d70| 2e 20 43 6c 69 63 6b 20 | 4f 4b 20 74 6f 20 61 63 |. Click |OK to ac|
|00003d80| 63 65 70 74 20 74 68 65 | 20 6e 65 77 20 6e 61 6d |cept the| new nam|
|00003d90| 65 20 6f 72 20 63 6c 69 | 63 6b 20 43 61 6e 63 65 |e or cli|ck Cance|
|00003da0| 6c 20 74 6f 20 63 61 6e | 63 65 6c 20 74 68 65 20 |l to can|cel the |
|00003db0| 63 6f 6d 6d 61 6e 64 2e | 20 49 6d 70 72 6f 76 20 |command.| Improv |
|00003dc0| 74 72 65 61 74 73 20 62 | 72 6f 6b 65 6e 20 66 6f |treats b|roken fo|
|00003dd0| 72 6d 75 6c 61 73 20 61 | 73 20 69 66 20 74 68 65 |rmulas a|s if the|
|00003de0| 79 20 63 6f 6e 74 61 69 | 6e 20 65 72 72 6f 72 73 |y contai|n errors|
|00003df0| 20 61 6e 64 20 64 6f 65 | 73 20 6e 6f 74 20 75 73 | and doe|s not us|
|00003e00| 65 20 74 68 65 6d 20 74 | 6f 20 63 61 6c 63 75 6c |e them t|o calcul|
|00003e10| 61 74 65 20 63 65 6c 6c | 20 76 61 6c 75 65 73 2e |ate cell| values.|
|00003e20| 00 43 6f 6c 6f 6e 73 20 | 61 72 65 20 6e 6f 74 20 |.Colons |are not |
|00003e30| 70 65 72 6d 69 74 74 65 | 64 20 69 6e 20 69 74 65 |permitte|d in ite|
|00003e40| 6d 20 6e 61 6d 65 73 2c | 20 73 6f 20 74 68 65 79 |m names,| so they|
|00003e50| 20 77 69 6c 6c 20 62 65 | 20 72 65 6d 6f 76 65 64 | will be| removed|
|00003e60| 2e 00 42 79 20 64 65 6c | 65 74 69 6e 67 20 74 68 |..By del|eting th|
|00003e70| 65 73 65 20 69 74 65 6d | 73 2c 20 79 6f 75 20 77 |ese item|s, you w|
|00003e80| 69 6c 6c 20 64 65 73 74 | 72 6f 79 20 73 6f 6d 65 |ill dest|roy some|
|00003e90| 20 63 65 6c 6c 20 76 61 | 6c 75 65 73 20 61 6e 64 | cell va|lues and|
|00003ea0| 20 62 72 65 61 6b 20 73 | 6f 6d 65 20 66 6f 72 6d | break s|ome form|
|00003eb0| 75 6c 61 73 2e 00 41 20 | 77 6f 72 6b 73 68 65 65 |ulas..A |workshee|
|00003ec0| 74 20 63 61 6e 20 68 61 | 76 65 20 75 70 20 74 6f |t can ha|ve up to|
|00003ed0| 20 25 6e 75 6d 62 65 72 | 25 20 76 69 65 77 73 2e | %number|% views.|
|00003ee0| 20 59 6f 75 20 63 61 6e | 6e 6f 74 20 61 64 64 20 | You can|not add |
|00003ef0| 61 6e 6f 74 68 65 72 20 | 76 69 65 77 20 6f 66 20 |another |view of |
|00003f00| 74 68 65 20 77 6f 72 6b | 73 68 65 65 74 20 75 6e |the work|sheet un|
|00003f10| 74 69 6c 20 79 6f 75 20 | 64 65 6c 65 74 65 20 6f |til you |delete o|
|00003f20| 6e 65 20 6f 72 20 6d 6f | 72 65 20 6f 66 20 74 68 |ne or mo|re of th|
|00003f30| 65 20 65 78 69 73 74 69 | 6e 67 20 76 69 65 77 73 |e existi|ng views|
|00003f40| 2e 00 59 6f 75 20 63 61 | 6e 20 63 6f 6c 6c 61 70 |..You ca|n collap|
|00003f50| 73 65 20 61 20 67 72 6f | 75 70 20 6f 6e 6c 79 20 |se a gro|up only |
|00003f60| 69 66 20 69 74 20 63 6f | 6e 74 61 69 6e 73 20 61 |if it co|ntains a|
|00003f70| 6e 20 61 75 74 6f 6d 61 | 74 69 63 20 73 75 6d 6d |n automa|tic summ|
|00003f80| 61 72 79 20 69 74 65 6d | 2e 20 20 54 6f 20 61 64 |ary item|. To ad|
|00003f90| 64 20 61 6e 20 61 75 74 | 6f 6d 61 74 69 63 20 73 |d an aut|omatic s|
|00003fa0| 75 6d 6d 61 72 79 20 69 | 74 65 6d 20 74 6f 20 61 |ummary i|tem to a|
|00003fb0| 20 67 72 6f 75 70 2c 20 | 73 65 6c 65 63 74 20 74 | group, |select t|
|00003fc0| 68 65 20 67 72 6f 75 70 | 20 61 6e 64 20 74 68 65 |he group| and the|
|00003fd0| 6e 20 63 68 6f 6f 73 65 | 20 57 6f 72 6b 73 68 65 |n choose| Workshe|
|00003fe0| 65 74 20 41 64 64 20 47 | 72 6f 75 70 20 53 75 6d |et Add G|roup Sum|
|00003ff0| 6d 61 72 79 2e 00 41 20 | 67 72 6f 75 70 20 63 61 |mary..A |group ca|
|00004000| 6e 20 68 61 76 65 20 6f | 6e 6c 79 20 6f 6e 65 20 |n have o|nly one |
|00004010| 61 75 74 6f 6d 61 74 69 | 63 20 73 75 6d 6d 61 72 |automati|c summar|
|00004020| 79 20 69 74 65 6d 2e 20 | 54 68 65 20 67 72 6f 75 |y item. |The grou|
|00004030| 70 20 25 67 72 6f 75 70 | 25 20 61 6c 72 65 61 64 |p %group|% alread|
|00004040| 79 20 68 61 73 20 74 68 | 65 20 61 75 74 6f 6d 61 |y has th|e automa|
|00004050| 74 69 63 20 73 75 6d 6d | 61 72 79 20 69 74 65 6d |tic summ|ary item|
|00004060| 20 25 69 74 65 6d 25 2e | 20 54 6f 20 63 72 65 61 | %item%.| To crea|
|00004070| 74 65 20 61 20 64 69 66 | 66 65 72 65 6e 74 20 61 |te a dif|ferent a|
|00004080| 75 74 6f 6d 61 74 69 63 | 20 73 75 6d 6d 61 72 79 |utomatic| summary|
|00004090| 20 69 74 65 6d 2c 20 64 | 65 6c 65 74 65 20 25 69 | item, d|elete %i|
|000040a0| 74 65 6d 25 20 61 6e 64 | 20 61 6e 79 20 66 6f 72 |tem% and| any for|
|000040b0| 6d 75 6c 61 20 74 68 61 | 74 20 63 61 6c 63 75 6c |mula tha|t calcul|
|000040c0| 61 74 65 73 20 69 74 2e | 20 54 68 65 6e 20 63 68 |ates it.| Then ch|
|000040d0| 6f 6f 73 65 20 57 6f 72 | 6b 73 68 65 65 74 20 41 |oose Wor|ksheet A|
|000040e0| 64 64 20 47 72 6f 75 70 | 20 53 75 6d 6d 61 72 79 |dd Group| Summary|
|000040f0| 2e 00 41 20 67 72 6f 75 | 70 20 63 61 6e 20 68 61 |..A grou|p can ha|
|00004100| 76 65 20 6f 6e 6c 79 20 | 6f 6e 65 20 61 75 74 6f |ve only |one auto|
|00004110| 6d 61 74 69 63 20 73 75 | 6d 6d 61 72 79 20 69 74 |matic su|mmary it|
|00004120| 65 6d 2e 20 54 6f 20 63 | 72 65 61 74 65 20 61 20 |em. To c|reate a |
|00004130| 64 69 66 66 65 72 65 6e | 74 20 73 75 6d 6d 61 72 |differen|t summar|
|00004140| 79 20 69 74 65 6d 20 66 | 6f 72 20 61 20 67 72 6f |y item f|or a gro|
|00004150| 75 70 2c 20 64 65 6c 65 | 74 65 20 69 74 73 20 61 |up, dele|te its a|
|00004160| 75 74 6f 6d 61 74 69 63 | 20 73 75 6d 6d 61 72 79 |utomatic| summary|
|00004170| 20 69 74 65 6d 20 61 6e | 64 20 61 6e 79 20 66 6f | item an|d any fo|
|00004180| 72 6d 75 6c 61 20 74 68 | 61 74 20 63 61 6c 63 75 |rmula th|at calcu|
|00004190| 6c 61 74 65 73 20 69 74 | 2e 20 54 68 65 6e 20 63 |lates it|. Then c|
|000041a0| 68 6f 6f 73 65 20 57 6f | 72 6b 73 68 65 65 74 20 |hoose Wo|rksheet |
|000041b0| 41 64 64 20 47 72 6f 75 | 70 20 53 75 6d 6d 61 72 |Add Grou|p Summar|
|000041c0| 79 2e 00 41 20 67 72 6f | 75 70 20 63 61 6e 20 68 |y..A gro|up can h|
|000041d0| 61 76 65 20 6f 6e 6c 79 | 20 6f 6e 65 20 61 75 74 |ave only| one aut|
|000041e0| 6f 6d 61 74 69 63 20 73 | 75 6d 6d 61 72 79 20 69 |omatic s|ummary i|
|000041f0| 74 65 6d 2e 20 4f 6e 65 | 20 6f 72 20 6d 6f 72 65 |tem. One| or more|
|00004200| 20 6f 66 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 | of the |selected|
|00004210| 20 67 72 6f 75 70 73 20 | 61 6c 72 65 61 64 79 20 | groups |already |
|00004220| 68 61 76 65 20 61 20 73 | 75 6d 6d 61 72 79 20 69 |have a s|ummary i|
|00004230| 74 65 6d 2e 20 49 66 20 | 79 6f 75 20 70 72 6f 63 |tem. If |you proc|
|00004240| 65 65 64 2c 20 73 75 6d | 6d 61 72 79 20 69 74 65 |eed, sum|mary ite|
|00004250| 6d 73 20 77 69 6c 6c 20 | 62 65 20 63 72 65 61 74 |ms will |be creat|
|00004260| 65 64 20 6f 6e 6c 79 20 | 66 6f 72 20 74 68 65 20 |ed only |for the |
|00004270| 67 72 6f 75 70 73 20 74 | 68 61 74 20 64 6f 20 6e |groups t|hat do n|
|00004280| 6f 74 20 61 6c 72 65 61 | 64 79 20 68 61 76 65 20 |ot alrea|dy have |
|00004290| 6f 6e 65 2e 00 54 68 65 | 20 73 65 6c 65 63 74 69 |one..The| selecti|
|000042a0| 6f 6e 20 79 6f 75 20 6d | 61 64 65 20 65 78 63 65 |on you m|ade exce|
|000042b0| 65 64 73 20 74 68 65 20 | 6c 69 6d 69 74 20 6f 66 |eds the |limit of|
|000042c0| 20 25 6c 69 6d 69 74 25 | 20 73 65 72 69 65 73 20 | %limit%| series |
|000042d0| 69 6e 20 61 20 67 72 61 | 70 68 2e 20 4f 6e 6c 79 |in a gra|ph. Only|
|000042e0| 20 25 6c 69 6d 69 74 25 | 20 6f 66 20 74 68 65 20 | %limit%| of the |
|000042f0| 73 65 72 69 65 73 20 69 | 6e 20 74 68 65 20 73 65 |series i|n the se|
|00004300| 6c 65 63 74 69 6f 6e 20 | 77 69 6c 6c 20 62 65 20 |lection |will be |
|00004310| 67 72 61 70 68 65 64 2e | 20 43 6c 69 63 6b 20 4f |graphed.| Click O|
|00004320| 4b 20 74 6f 20 70 72 6f | 63 65 65 64 20 6f 72 20 |K to pro|ceed or |
|00004330| 63 6c 69 63 6b 20 43 61 | 6e 63 65 6c 20 74 6f 20 |click Ca|ncel to |
|00004340| 63 61 6e 63 65 6c 20 74 | 68 65 20 63 6f 6d 6d 61 |cancel t|he comma|
|00004350| 6e 64 2e 00 41 20 6d 61 | 78 69 6d 75 6d 20 6f 66 |nd..A ma|ximum of|
|00004360| 20 25 6c 69 6d 69 74 25 | 20 73 65 72 69 65 73 20 | %limit%| series |
|00004370| 69 73 20 61 6c 6c 6f 77 | 65 64 20 69 6e 20 61 20 |is allow|ed in a |
|00004380| 73 69 6e 67 6c 65 20 67 | 72 61 70 68 2e 20 59 6f |single g|raph. Yo|
|00004390| 75 20 63 61 6e 6e 6f 74 | 20 61 64 64 20 6d 6f 72 |u cannot| add mor|
|000043a0| 65 20 73 65 72 69 65 73 | 20 75 6e 6c 65 73 73 20 |e series| unless |
|000043b0| 79 6f 75 20 66 69 72 73 | 74 20 64 65 6c 65 74 65 |you firs|t delete|
|000043c0| 20 73 6f 6d 65 20 6f 66 | 20 74 68 65 20 65 78 69 | some of| the exi|
|000043d0| 73 74 69 6e 67 20 73 65 | 72 69 65 73 20 69 6e 20 |sting se|ries in |
|000043e0| 74 68 65 20 67 72 61 70 | 68 2e 00 41 20 6d 61 78 |the grap|h..A max|
|000043f0| 69 6d 75 6d 20 6f 66 20 | 25 6c 69 6d 69 74 25 20 |imum of |%limit% |
|00004400| 73 65 72 69 65 73 20 69 | 73 20 61 6c 6c 6f 77 65 |series i|s allowe|
|00004410| 64 20 69 6e 20 61 20 73 | 69 6e 67 6c 65 20 67 72 |d in a s|ingle gr|
|00004420| 61 70 68 2e 20 43 6c 69 | 63 6b 20 4f 4b 20 74 6f |aph. Cli|ck OK to|
|00004430| 20 70 72 6f 63 65 65 64 | 20 6f 72 20 63 6c 69 63 | proceed| or clic|
|00004440| 6b 20 43 61 6e 63 65 6c | 20 74 6f 20 63 61 6e 63 |k Cancel| to canc|
|00004450| 65 6c 20 74 68 65 20 63 | 6f 6d 6d 61 6e 64 2e 00 |el the c|ommand..|
|00004460| 41 64 64 69 6e 67 20 61 | 20 63 61 74 65 67 6f 72 |Adding a| categor|
|00004470| 79 20 77 69 6c 6c 20 62 | 72 65 61 6b 20 74 68 65 |y will b|reak the|
|00004480| 20 44 44 45 20 6c 69 6e | 6b 20 66 6f 72 6d 75 6c | DDE lin|k formul|
|00004490| 61 73 20 69 6e 20 74 68 | 69 73 20 77 6f 72 6b 73 |as in th|is works|
|000044a0| 68 65 65 74 2e 20 49 66 | 20 79 6f 75 20 63 6c 69 |heet. If| you cli|
|000044b0| 63 6b 20 4f 4b 2c 20 6c | 69 6e 6b 20 66 6f 72 6d |ck OK, l|ink form|
|000044c0| 75 6c 61 73 20 77 69 6c | 6c 20 62 72 65 61 6b 20 |ulas wil|l break |
|000044d0| 61 6e 64 20 77 69 6c 6c | 20 6e 6f 20 6c 6f 6e 67 |and will| no long|
|000044e0| 65 72 20 63 61 6c 63 75 | 6c 61 74 65 20 63 65 6c |er calcu|late cel|
|000044f0| 6c 20 76 61 6c 75 65 73 | 2e 00 49 66 20 79 6f 75 |l values|..If you|
|00004500| 20 70 72 6f 63 65 65 64 | 2c 20 79 6f 75 20 77 69 | proceed|, you wi|
|00004510| 6c 6c 20 64 65 73 74 72 | 6f 79 20 74 68 65 20 63 |ll destr|oy the c|
|00004520| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 63 65 6c 6c 73 |ontents |of cells|
|00004530| 2c 20 61 6e 64 20 73 6f | 6d 65 20 66 6f 72 6d 75 |, and so|me formu|
|00004540| 6c 61 73 20 69 6e 20 74 | 68 65 20 6d 6f 64 65 6c |las in t|he model|
|00004550| 20 6d 69 67 68 74 20 62 | 72 65 61 6b 2e 20 49 6d | might b|reak. Im|
|00004560| 70 72 6f 76 20 74 72 65 | 61 74 73 20 62 72 6f 6b |prov tre|ats brok|
|00004570| 65 6e 20 66 6f 72 6d 75 | 6c 61 73 20 61 73 20 69 |en formu|las as i|
|00004580| 66 20 74 68 65 79 20 63 | 6f 6e 74 61 69 6e 20 65 |f they c|ontain e|
|00004590| 72 72 6f 72 73 20 61 6e | 64 20 64 6f 65 73 20 6e |rrors an|d does n|
|000045a0| 6f 74 20 75 73 65 20 74 | 68 65 6d 20 74 6f 20 63 |ot use t|hem to c|
|000045b0| 61 6c 63 75 6c 61 74 65 | 20 63 65 6c 6c 20 76 61 |alculate| cell va|
|000045c0| 6c 75 65 73 2e 00 49 66 | 20 79 6f 75 20 70 72 6f |lues..If| you pro|
|000045d0| 63 65 65 64 2c 20 79 6f | 75 20 77 69 6c 6c 20 64 |ceed, yo|u will d|
|000045e0| 65 6c 65 74 65 20 74 68 | 65 20 73 65 6c 65 63 74 |elete th|e select|
|000045f0| 65 64 20 77 6f 72 6b 73 | 68 65 65 74 73 20 66 72 |ed works|heets fr|
|00004600| 6f 6d 20 74 68 65 20 6d | 6f 64 65 6c 2e 0d 0a 0d |om the m|odel....|
|00004610| 0a 44 65 6c 65 74 69 6e | 67 20 61 6c 6c 20 76 69 |.Deletin|g all vi|
|00004620| 65 77 73 20 6f 66 20 61 | 20 77 6f 72 6b 73 68 65 |ews of a| workshe|
|00004630| 65 74 20 64 65 6c 65 74 | 65 73 20 74 68 65 20 77 |et delet|es the w|
|00004640| 6f 72 6b 73 68 65 65 74 | 2e 20 49 66 20 79 6f 75 |orksheet|. If you|
|00004650| 20 63 68 6f 6f 73 65 20 | 74 6f 20 64 65 6c 65 74 | choose |to delet|
|00004660| 65 20 74 68 65 20 77 6f | 72 6b 73 68 65 65 74 73 |e the wo|rksheets|
|00004670| 2c 20 61 6c 6c 20 69 74 | 65 6d 73 2c 20 63 61 74 |, all it|ems, cat|
|00004680| 65 67 6f 72 69 65 73 2c | 20 66 6f 72 6d 75 6c 61 |egories,| formula|
|00004690| 73 2c 20 61 6e 64 20 76 | 61 6c 75 65 73 20 69 6e |s, and v|alues in|
|000046a0| 20 74 68 65 6d 20 77 69 | 6c 6c 20 62 65 20 72 65 | them wi|ll be re|
|000046b0| 6d 6f 76 65 64 20 66 72 | 6f 6d 20 74 68 65 20 6d |moved fr|om the m|
|000046c0| 6f 64 65 6c 20 70 65 72 | 6d 61 6e 65 6e 74 6c 79 |odel per|manently|
|000046d0| 2e 00 44 65 6c 65 74 69 | 6e 67 20 61 6c 6c 20 76 |..Deleti|ng all v|
|000046e0| 69 65 77 73 20 6f 66 20 | 61 20 77 6f 72 6b 73 68 |iews of |a worksh|
|000046f0| 65 65 74 20 64 65 6c 65 | 74 65 73 20 74 68 65 20 |eet dele|tes the |
|00004700| 77 6f 72 6b 73 68 65 65 | 74 2e 20 49 66 20 79 6f |workshee|t. If yo|
|00004710| 75 20 63 68 6f 6f 73 65 | 20 74 6f 20 64 65 6c 65 |u choose| to dele|
|00004720| 74 65 20 74 68 65 20 77 | 6f 72 6b 73 68 65 65 74 |te the w|orksheet|
|00004730| 2c 20 61 6c 6c 20 74 68 | 65 20 69 74 65 6d 73 2c |, all th|e items,|
|00004740| 20 63 61 74 65 67 6f 72 | 69 65 73 2c 20 66 6f 72 | categor|ies, for|
|00004750| 6d 75 6c 61 73 2c 20 61 | 6e 64 20 76 61 6c 75 65 |mulas, a|nd value|
|00004760| 73 20 69 6e 20 74 68 65 | 20 77 6f 72 6b 73 68 65 |s in the| workshe|
|00004770| 65 74 20 77 69 6c 6c 20 | 62 65 20 72 65 6d 6f 76 |et will |be remov|
|00004780| 65 64 20 66 72 6f 6d 20 | 74 68 65 20 6d 6f 64 65 |ed from |the mode|
|00004790| 6c 20 70 65 72 6d 61 6e | 65 6e 74 6c 79 2e 20 53 |l perman|ently. S|
|000047a0| 6f 6d 65 20 66 6f 72 6d | 75 6c 61 73 20 69 6e 20 |ome form|ulas in |
|000047b0| 6f 74 68 65 72 20 77 6f | 72 6b 73 68 65 65 74 73 |other wo|rksheets|
|000047c0| 20 69 6e 20 74 68 65 20 | 6d 6f 64 65 6c 20 77 69 | in the |model wi|
|000047d0| 6c 6c 20 62 72 65 61 6b | 2e 20 49 6d 70 72 6f 76 |ll break|. Improv|
|000047e0| 20 74 72 65 61 74 73 20 | 62 72 6f 6b 65 6e 20 66 | treats |broken f|
|000047f0| 6f 72 6d 75 6c 61 73 20 | 61 73 20 69 66 20 74 68 |ormulas |as if th|
|00004800| 65 79 20 63 6f 6e 74 61 | 69 6e 20 65 72 72 6f 72 |ey conta|in error|
|00004810| 73 20 61 6e 64 20 64 6f | 65 73 20 6e 6f 74 20 75 |s and do|es not u|
|00004820| 73 65 20 74 68 65 6d 20 | 74 6f 20 63 61 6c 63 75 |se them |to calcu|
|00004830| 6c 61 74 65 20 63 65 6c | 6c 20 76 61 6c 75 65 73 |late cel|l values|
|00004840| 2e 00 49 66 20 79 6f 75 | 20 70 72 6f 63 65 65 64 |..If you| proceed|
|00004850| 2c 20 79 6f 75 20 77 69 | 6c 6c 20 64 65 6c 65 74 |, you wi|ll delet|
|00004860| 65 20 74 68 65 20 73 65 | 6c 65 63 74 65 64 20 77 |e the se|lected w|
|00004870| 6f 72 6b 73 68 65 65 74 | 73 20 66 72 6f 6d 20 74 |orksheet|s from t|
|00004880| 68 65 20 6d 6f 64 65 6c | 2e 0d 0a 0d 0a 44 65 6c |he model|.....Del|
|00004890| 65 74 69 6e 67 20 61 6c | 6c 20 76 69 65 77 73 20 |eting al|l views |
|000048a0| 6f 66 20 61 20 77 6f 72 | 6b 73 68 65 65 74 20 64 |of a wor|ksheet d|
|000048b0| 65 6c 65 74 65 73 20 74 | 68 65 20 77 6f 72 6b 73 |eletes t|he works|
|000048c0| 68 65 65 74 2e 20 49 66 | 20 79 6f 75 20 63 68 6f |heet. If| you cho|
|000048d0| 6f 73 65 20 74 6f 20 64 | 65 6c 65 74 65 20 74 68 |ose to d|elete th|
|000048e0| 65 20 77 6f 72 6b 73 68 | 65 65 74 73 2c 20 61 6c |e worksh|eets, al|
|000048f0| 6c 20 69 74 65 6d 73 2c | 20 63 61 74 65 67 6f 72 |l items,| categor|
|00004900| 69 65 73 2c 20 66 6f 72 | 6d 75 6c 61 73 2c 20 61 |ies, for|mulas, a|
|00004910| 6e 64 20 76 61 6c 75 65 | 73 20 69 6e 20 74 68 65 |nd value|s in the|
|00004920| 6d 20 77 69 6c 6c 20 62 | 65 20 72 65 6d 6f 76 65 |m will b|e remove|
|00004930| 64 20 66 72 6f 6d 20 74 | 68 65 20 6d 6f 64 65 6c |d from t|he model|
|00004940| 20 70 65 72 6d 61 6e 65 | 6e 74 6c 79 2e 20 53 6f | permane|ntly. So|
|00004950| 6d 65 20 66 6f 72 6d 75 | 6c 61 73 20 69 6e 20 6f |me formu|las in o|
|00004960| 74 68 65 72 20 77 6f 72 | 6b 73 68 65 65 74 73 20 |ther wor|ksheets |
|00004970| 69 6e 20 74 68 65 20 6d | 6f 64 65 6c 20 77 69 6c |in the m|odel wil|
|00004980| 6c 20 62 72 65 61 6b 2e | 20 49 6d 70 72 6f 76 20 |l break.| Improv |
|00004990| 74 72 65 61 74 73 20 62 | 72 6f 6b 65 6e 20 66 6f |treats b|roken fo|
|000049a0| 72 6d 75 6c 61 73 20 61 | 73 20 69 66 20 74 68 65 |rmulas a|s if the|
|000049b0| 79 20 63 6f 6e 74 61 69 | 6e 20 65 72 72 6f 72 73 |y contai|n errors|
|000049c0| 20 61 6e 64 20 64 6f 65 | 73 20 6e 6f 74 20 75 73 | and doe|s not us|
|000049d0| 65 20 74 68 65 6d 20 74 | 6f 20 63 61 6c 63 75 6c |e them t|o calcul|
|000049e0| 61 74 65 20 63 65 6c 6c | 20 76 61 6c 75 65 73 2e |ate cell| values.|
|000049f0| 00 54 6f 20 64 65 6c 65 | 74 65 20 74 68 65 20 65 |.To dele|te the e|
|00004a00| 6e 74 69 72 65 20 6d 6f | 64 65 6c 2c 20 63 6c 6f |ntire mo|del, clo|
|00004a10| 73 65 20 69 74 2c 20 74 | 68 65 6e 20 75 73 65 20 |se it, t|hen use |
|00004a20| 74 68 65 20 57 69 6e 64 | 6f 77 73 20 46 69 6c 65 |the Wind|ows File|
|00004a30| 20 4d 61 6e 61 67 65 72 | 20 74 6f 20 64 65 6c 65 | Manager| to dele|
|00004a40| 74 65 20 74 68 65 20 66 | 69 6c 65 2e 00 25 66 6f |te the f|ile..%fo|
|00004a50| 72 6d 75 6c 61 25 0d 0a | 0d 0a 54 68 65 20 67 72 |rmula%..|..The gr|
|00004a60| 6f 75 70 20 6d 65 6d 62 | 65 72 20 27 25 6e 61 6d |oup memb|er '%nam|
|00004a70| 65 25 27 20 63 6f 75 6c | 64 20 6e 6f 74 20 62 65 |e%' coul|d not be|
|00004a80| 20 66 6f 75 6e 64 2c 20 | 65 69 74 68 65 72 20 62 | found, |either b|
|00004a90| 65 63 61 75 73 65 20 27 | 25 67 72 6f 75 70 25 27 |ecause '|%group%'|
|00004aa0| 20 69 73 20 6e 6f 74 20 | 61 20 67 72 6f 75 70 2c | is not |a group,|
|00004ab0| 20 6f 72 20 62 65 63 61 | 75 73 65 20 69 74 20 68 | or beca|use it h|
|00004ac0| 61 73 20 6e 6f 20 73 75 | 63 68 20 6d 65 6d 62 65 |as no su|ch membe|
|00004ad0| 72 2e 20 43 68 65 63 6b | 20 74 68 65 20 73 70 65 |r. Check| the spe|
|00004ae0| 6c 6c 69 6e 67 20 6f 66 | 20 74 68 65 20 6e 61 6d |lling of| the nam|
|00004af0| 65 20 61 6e 64 20 74 72 | 79 20 61 67 61 69 6e 2e |e and tr|y again.|
|00004b00| 00 25 66 6f 72 6d 75 6c | 61 25 0d 0a 0d 0a 54 68 |.%formul|a%....Th|
|00004b10| 65 72 65 20 69 73 20 6e | 6f 20 69 74 65 6d 20 6e |ere is n|o item n|
|00004b20| 61 6d 65 64 20 27 25 6e | 61 6d 65 25 27 20 69 6e |amed '%n|ame%' in|
|00004b30| 20 74 68 65 20 63 61 74 | 65 67 6f 72 79 20 27 25 | the cat|egory '%|
|00004b40| 67 72 6f 75 70 25 27 2e | 20 43 68 65 63 6b 20 74 |group%'.| Check t|
|00004b50| 68 65 20 73 70 65 6c 6c | 69 6e 67 20 6f 66 20 74 |he spell|ing of t|
|00004b60| 68 65 20 6e 61 6d 65 20 | 61 6e 64 20 74 72 79 20 |he name |and try |
|00004b70| 61 67 61 69 6e 2e 00 25 | 66 6f 72 6d 75 6c 61 25 |again..%|formula%|
|00004b80| 0d 0a 0d 0a 54 68 65 72 | 65 20 69 73 20 6e 6f 20 |....Ther|e is no |
|00004b90| 69 6d 6d 65 64 69 61 74 | 65 20 6d 65 6d 62 65 72 |immediat|e member|
|00004ba0| 20 6f 66 20 74 68 65 20 | 69 74 65 6d 20 27 25 67 | of the |item '%g|
|00004bb0| 72 6f 75 70 25 27 20 74 | 68 61 74 20 69 73 20 6e |roup%' t|hat is n|
|00004bc0| 61 6d 65 64 20 27 25 6e | 61 6d 65 25 27 2e 20 48 |amed '%n|ame%'. H|
|00004bd0| 6f 77 65 76 65 72 2c 20 | 74 68 65 73 65 20 69 74 |owever, |these it|
|00004be0| 65 6d 73 20 64 6f 20 65 | 78 69 73 74 20 69 6e 20 |ems do e|xist in |
|00004bf0| 74 68 65 20 73 61 6d 65 | 20 63 61 74 65 67 6f 72 |the same| categor|
|00004c00| 79 2e 00 25 66 6f 72 6d | 75 6c 61 25 0d 0a 0d 0a |y..%form|ula%....|
|00004c10| 54 68 65 72 65 20 69 73 | 20 6e 6f 20 69 6d 6d 65 |There is| no imme|
|00004c20| 64 69 61 74 65 20 6d 65 | 6d 62 65 72 20 6f 66 20 |diate me|mber of |
|00004c30| 74 68 65 20 63 61 74 65 | 67 6f 72 79 20 27 25 67 |the cate|gory '%g|
|00004c40| 72 6f 75 70 25 27 20 74 | 68 61 74 20 69 73 20 6e |roup%' t|hat is n|
|00004c50| 61 6d 65 64 20 27 25 6e | 61 6d 65 25 27 2e 20 48 |amed '%n|ame%'. H|
|00004c60| 6f 77 65 76 65 72 2c 20 | 74 68 65 20 69 74 65 6d |owever, |the item|
|00004c70| 20 27 25 6e 61 6d 65 25 | 27 20 64 6f 65 73 20 65 | '%name%|' does e|
|00004c80| 78 69 73 74 20 69 6e 20 | 74 68 65 20 63 61 74 65 |xist in |the cate|
|00004c90| 67 6f 72 79 20 27 25 67 | 72 6f 75 70 25 27 2e 00 |gory '%g|roup%'..|
|00004ca0| 25 66 6f 72 6d 75 6c 61 | 25 0d 0a 0d 0a 54 68 65 |%formula|%....The|
|00004cb0| 72 65 20 69 73 20 6e 6f | 20 6d 65 6d 62 65 72 20 |re is no| member |
|00004cc0| 6f 66 20 74 68 65 20 69 | 74 65 6d 20 27 25 67 72 |of the i|tem '%gr|
|00004cd0| 6f 75 70 25 27 20 6e 61 | 6d 65 64 20 27 25 6e 61 |oup%' na|med '%na|
|00004ce0| 6d 65 25 27 2e 20 48 6f | 77 65 76 65 72 2c 20 27 |me%'. Ho|wever, '|
|00004cf0| 25 6e 61 6d 65 25 27 20 | 64 6f 65 73 20 65 78 69 |%name%' |does exi|
|00004d00| 73 74 20 69 6e 20 61 6e | 6f 74 68 65 72 20 63 61 |st in an|other ca|
|00004d10| 74 65 67 6f 72 79 2e 20 | 43 68 65 63 6b 20 74 6f |tegory. |Check to|
|00004d20| 20 73 65 65 20 69 66 20 | 74 68 65 73 65 20 6e 61 | see if |these na|
|00004d30| 6d 65 73 20 73 68 6f 75 | 6c 64 20 62 65 20 73 65 |mes shou|ld be se|
|00004d40| 70 61 72 61 74 65 64 20 | 77 69 74 68 20 61 20 63 |parated |with a c|
|00004d50| 6f 6c 6f 6e 20 28 3a 29 | 2e 00 25 66 6f 72 6d 75 |olon (:)|..%formu|
|00004d60| 6c 61 25 0d 0a 0d 0a 54 | 68 65 72 65 20 69 73 20 |la%....T|here is |
|00004d70| 6e 6f 20 6d 65 6d 62 65 | 72 20 6f 66 20 74 68 65 |no membe|r of the|
|00004d80| 20 63 61 74 65 67 6f 72 | 79 20 27 25 67 72 6f 75 | categor|y '%grou|
|00004d90| 70 25 27 20 6e 61 6d 65 | 64 20 27 25 6e 61 6d 65 |p%' name|d '%name|
|00004da0| 25 27 2e 20 48 6f 77 65 | 76 65 72 2c 20 27 25 6e |%'. Howe|ver, '%n|
|00004db0| 61 6d 65 25 27 20 64 6f | 65 73 20 65 78 69 73 74 |ame%' do|es exist|
|00004dc0| 20 69 6e 20 61 6e 6f 74 | 68 65 72 20 63 61 74 65 | in anot|her cate|
|00004dd0| 67 6f 72 79 2e 20 43 68 | 65 63 6b 20 74 6f 20 73 |gory. Ch|eck to s|
|00004de0| 65 65 20 69 66 20 74 68 | 65 73 65 20 6e 61 6d 65 |ee if th|ese name|
|00004df0| 73 20 73 68 6f 75 6c 64 | 20 62 65 20 73 65 70 61 |s should| be sepa|
|00004e00| 72 61 74 65 64 20 77 69 | 74 68 20 61 20 63 6f 6c |rated wi|th a col|
|00004e10| 6f 6e 20 28 3a 29 2e 00 | 49 66 20 79 6f 75 20 70 |on (:)..|If you p|
|00004e20| 72 6f 63 65 65 64 2c 20 | 61 6c 6c 20 74 68 65 20 |roceed, |all the |
|00004e30| 64 61 74 61 20 69 6e 20 | 74 68 65 20 73 65 6c 65 |data in |the sele|
|00004e40| 63 74 65 64 20 69 74 65 | 6d 73 20 77 69 6c 6c 20 |cted ite|ms will |
|00004e50| 62 65 20 6f 76 65 72 77 | 72 69 74 74 65 6e 2e 20 |be overw|ritten. |
|00004e60| 49 66 20 6e 65 63 65 73 | 73 61 72 79 2c 20 74 68 |If neces|sary, th|
|00004e70| 65 20 63 65 6c 6c 73 20 | 6f 6e 20 74 68 65 20 63 |e cells |on the c|
|00004e80| 6c 69 70 62 6f 61 72 64 | 20 77 69 6c 6c 20 62 65 |lipboard| will be|
|00004e90| 20 72 65 70 6c 69 63 61 | 74 65 64 20 74 6f 20 66 | replica|ted to f|
|00004ea0| 69 6c 6c 20 74 68 65 20 | 73 65 6c 65 63 74 69 6f |ill the |selectio|
|00004eb0| 6e 2e 00 52 65 63 61 6c | 63 75 6c 61 74 69 6f 6e |n..Recal|culation|
|00004ec0| 20 69 73 20 69 6e 20 70 | 72 6f 67 72 65 73 73 2e | is in p|rogress.|
|00004ed0| 20 49 66 20 79 6f 75 20 | 70 72 6f 63 65 65 64 2c | If you |proceed,|
|00004ee0| 20 74 68 65 20 63 65 6c | 6c 73 20 6f 6e 20 74 68 | the cel|ls on th|
|00004ef0| 65 20 63 6c 69 70 62 6f | 61 72 64 20 6d 61 79 20 |e clipbo|ard may |
|00004f00| 6f 72 20 6d 61 79 20 6e | 6f 74 20 62 65 20 72 65 |or may n|ot be re|
|00004f10| 63 61 6c 63 75 6c 61 74 | 65 64 2e 00 41 6e 79 20 |calculat|ed..Any |
|00004f20| 63 65 6c 6c 20 76 61 6c | 75 65 20 74 68 61 74 20 |cell val|ue that |
|00004f30| 68 61 73 20 6d 6f 72 65 | 20 74 68 61 6e 20 25 6e |has more| than %n|
|00004f40| 75 6d 62 65 72 25 20 63 | 68 61 72 61 63 74 65 72 |umber% c|haracter|
|00004f50| 73 20 77 69 6c 6c 20 62 | 65 20 74 72 75 6e 63 61 |s will b|e trunca|
|00004f60| 74 65 64 20 61 6e 64 20 | 70 61 73 74 65 64 20 61 |ted and |pasted a|
|00004f70| 73 20 61 20 73 74 72 69 | 6e 67 2e 00 54 68 65 20 |s a stri|ng..The |
|00004f80| 76 69 65 77 20 6e 61 6d | 65 20 79 6f 75 20 65 6e |view nam|e you en|
|00004f90| 74 65 72 65 64 2c 20 27 | 25 6e 61 6d 65 25 27 2c |tered, '|%name%',|
|00004fa0| 20 69 73 20 74 68 65 20 | 6e 61 6d 65 20 6f 66 20 | is the |name of |
|00004fb0| 61 6e 20 65 78 69 73 74 | 69 6e 67 20 76 69 65 77 |an exist|ing view|
|00004fc0| 20 6f 66 20 74 68 65 20 | 77 6f 72 6b 73 68 65 65 | of the |workshee|
|00004fd0| 74 2e 20 45 6e 74 65 72 | 20 61 20 75 6e 69 71 75 |t. Enter| a uniqu|
|00004fe0| 65 20 6e 61 6d 65 2e 00 | 54 68 65 20 70 72 65 73 |e name..|The pres|
|00004ff0| 65 6e 74 61 74 69 6f 6e | 20 6e 61 6d 65 20 79 6f |entation| name yo|
|00005000| 75 20 65 6e 74 65 72 65 | 64 2c 20 27 25 6e 61 6d |u entere|d, '%nam|
|00005010| 65 25 27 2c 20 69 73 20 | 74 68 65 20 6e 61 6d 65 |e%', is |the name|
|00005020| 20 6f 66 20 61 6e 20 65 | 78 69 73 74 69 6e 67 20 | of an e|xisting |
|00005030| 70 72 65 73 65 6e 74 61 | 74 69 6f 6e 20 69 6e 20 |presenta|tion in |
|00005040| 74 68 65 20 6d 6f 64 65 | 6c 2e 20 45 6e 74 65 72 |the mode|l. Enter|
|00005050| 20 61 20 75 6e 69 71 75 | 65 20 6e 61 6d 65 2e 00 | a uniqu|e name..|
|00005060| 54 68 65 20 66 69 72 73 | 74 20 63 68 61 72 61 63 |The firs|t charac|
|00005070| 74 65 72 20 69 6e 20 74 | 68 65 20 6e 61 6d 65 20 |ter in t|he name |
|00005080| 79 6f 75 20 65 6e 74 65 | 72 65 64 2c 20 27 25 6e |you ente|red, '%n|
|00005090| 61 6d 65 25 27 2c 20 69 | 73 20 61 20 6e 75 6d 62 |ame%', i|s a numb|
|000050a0| 65 72 2e 20 57 6f 72 6b | 73 68 65 65 74 2c 20 76 |er. Work|sheet, v|
|000050b0| 69 65 77 2c 20 61 6e 64 | 20 70 72 65 73 65 6e 74 |iew, and| present|
|000050c0| 61 74 69 6f 6e 20 6e 61 | 6d 65 73 20 63 61 6e 6e |ation na|mes cann|
|000050d0| 6f 74 20 62 65 67 69 6e | 20 77 69 74 68 20 61 20 |ot begin| with a |
|000050e0| 6e 75 6d 62 65 72 2e 20 | 45 6e 74 65 72 20 61 20 |number. |Enter a |
|000050f0| 64 69 66 66 65 72 65 6e | 74 20 6e 61 6d 65 2e 00 |differen|t name..|
|00005100| 54 68 65 20 6e 61 6d 65 | 20 79 6f 75 20 65 6e 74 |The name| you ent|
|00005110| 65 72 65 64 2c 20 27 25 | 6e 61 6d 65 25 27 2c 20 |ered, '%|name%', |
|00005120| 69 6e 63 6c 75 64 65 73 | 20 61 20 63 6f 6d 6d 61 |includes| a comma|
|00005130| 2e 20 43 6f 6d 6d 61 73 | 20 61 72 65 20 6e 6f 74 |. Commas| are not|
|00005140| 20 61 6c 6c 6f 77 65 64 | 20 69 6e 20 61 20 77 6f | allowed| in a wo|
|00005150| 72 6b 73 68 65 65 74 2c | 20 76 69 65 77 2c 20 6f |rksheet,| view, o|
|00005160| 72 20 70 72 65 73 65 6e | 74 61 74 69 6f 6e 20 6e |r presen|tation n|
|00005170| 61 6d 65 2e 20 45 6e 74 | 65 72 20 61 20 64 69 66 |ame. Ent|er a dif|
|00005180| 66 65 72 65 6e 74 20 6e | 61 6d 65 2e 00 43 6f 70 |ferent n|ame..Cop|
|00005190| 79 69 6e 67 20 70 72 65 | 73 65 6e 74 61 74 69 6f |ying pre|sentatio|
|000051a0| 6e 73 20 74 6f 20 74 68 | 65 20 70 61 73 74 65 62 |ns to th|e pasteb|
|000051b0| 6f 61 72 64 20 69 73 20 | 6e 6f 74 20 79 65 74 20 |oard is |not yet |
|000051c0| 73 75 70 70 6f 72 74 65 | 64 2e 00 49 6d 70 72 6f |supporte|d..Impro|
|000051d0| 76 20 64 6f 65 73 20 6e | 6f 74 20 72 65 63 6f 67 |v does n|ot recog|
|000051e0| 6e 69 7a 65 20 74 68 65 | 20 53 74 61 72 74 20 76 |nize the| Start v|
|000051f0| 61 6c 75 65 20 61 73 20 | 61 20 6e 75 6d 62 65 72 |alue as |a number|
|00005200| 2c 20 64 61 74 65 2c 20 | 6f 72 20 74 69 6d 65 2e |, date, |or time.|
|00005210| 20 54 6f 20 65 6e 74 65 | 72 20 61 20 64 61 74 65 | To ente|r a date|
|00005220| 20 6f 72 20 74 69 6d 65 | 2c 20 75 73 65 20 6f 6e | or time|, use on|
|00005230| 65 20 6f 66 20 74 68 65 | 20 61 75 74 6f 6d 61 74 |e of the| automat|
|00005240| 69 63 20 64 61 74 65 2f | 74 69 6d 65 20 66 6f 72 |ic date/|time for|
|00005250| 6d 61 74 73 2e 00 49 6d | 70 72 6f 76 20 64 6f 65 |mats..Im|prov doe|
|00005260| 73 20 6e 6f 74 20 72 65 | 63 6f 67 6e 69 7a 65 20 |s not re|cognize |
|00005270| 74 68 65 20 53 74 65 70 | 20 76 61 6c 75 65 20 61 |the Step| value a|
|00005280| 73 20 61 20 6e 75 6d 62 | 65 72 2c 20 64 61 74 65 |s a numb|er, date|
|00005290| 2c 20 6f 72 20 74 69 6d | 65 2e 20 54 6f 20 65 6e |, or tim|e. To en|
|000052a0| 74 65 72 20 61 20 64 61 | 74 65 20 6f 72 20 74 69 |ter a da|te or ti|
|000052b0| 6d 65 2c 20 75 73 65 20 | 6f 6e 65 20 6f 66 20 74 |me, use |one of t|
|000052c0| 68 65 20 61 75 74 6f 6d | 61 74 69 63 20 64 61 74 |he autom|atic dat|
|000052d0| 65 2f 74 69 6d 65 20 66 | 6f 72 6d 61 74 73 2e 00 |e/time f|ormats..|
|000052e0| 49 6d 70 72 6f 76 20 64 | 6f 65 73 20 6e 6f 74 20 |Improv d|oes not |
|000052f0| 72 65 63 6f 67 6e 69 7a | 65 20 74 68 65 20 45 6e |recogniz|e the En|
|00005300| 64 20 76 61 6c 75 65 20 | 61 73 20 61 20 6e 75 6d |d value |as a num|
|00005310| 62 65 72 2c 20 64 61 74 | 65 2c 20 6f 72 20 74 69 |ber, dat|e, or ti|
|00005320| 6d 65 2e 20 54 6f 20 65 | 6e 74 65 72 20 61 20 64 |me. To e|nter a d|
|00005330| 61 74 65 20 6f 72 20 74 | 69 6d 65 2c 20 75 73 65 |ate or t|ime, use|
|00005340| 20 6f 6e 65 20 6f 66 20 | 74 68 65 20 61 75 74 6f | one of |the auto|
|00005350| 6d 61 74 69 63 20 64 61 | 74 65 2f 74 69 6d 65 20 |matic da|te/time |
|00005360| 66 6f 72 6d 61 74 73 2e | 00 54 68 65 20 53 74 61 |formats.|.The Sta|
|00005370| 72 74 20 76 61 6c 75 65 | 20 79 6f 75 20 65 6e 74 |rt value| you ent|
|00005380| 65 72 20 6d 75 73 74 20 | 62 65 20 6c 65 73 73 20 |er must |be less |
|00005390| 74 68 61 6e 20 74 68 65 | 20 45 6e 64 20 76 61 6c |than the| End val|
|000053a0| 75 65 2e 00 46 6f 72 6d | 75 6c 61 73 20 61 72 65 |ue..Form|ulas are|
|000053b0| 20 61 6c 72 65 61 64 79 | 20 63 61 6c 63 75 6c 61 | already| calcula|
|000053c0| 74 69 6e 67 20 76 61 6c | 75 65 73 20 69 6e 20 74 |ting val|ues in t|
|000053d0| 68 69 73 20 73 65 6c 65 | 63 74 69 6f 6e 2e 20 49 |his sele|ction. I|
|000053e0| 66 20 79 6f 75 20 63 6c | 69 63 6b 20 4f 4b 2c 20 |f you cl|ick OK, |
|000053f0| 74 68 65 20 76 61 6c 75 | 65 73 20 79 6f 75 20 6a |the valu|es you j|
|00005400| 75 73 74 20 65 6e 74 65 | 72 65 64 20 77 69 6c 6c |ust ente|red will|
|00005410| 20 6f 76 65 72 6c 61 70 | 20 63 61 6c 63 75 6c 61 | overlap| calcula|
|00005420| 74 65 64 20 76 61 6c 75 | 65 73 2e 00 46 72 61 63 |ted valu|es..Frac|
|00005430| 74 69 6f 6e 61 6c 20 53 | 74 65 70 20 76 61 6c 75 |tional S|tep valu|
|00005440| 65 73 20 61 72 65 20 6e | 6f 74 20 76 61 6c 69 64 |es are n|ot valid|
|00005450| 20 77 68 65 6e 20 79 6f | 75 20 66 69 6c 6c 20 62 | when yo|u fill b|
|00005460| 79 20 6d 6f 6e 74 68 20 | 6f 72 20 62 79 20 79 65 |y month |or by ye|
|00005470| 61 72 2e 20 4f 6e 6c 79 | 20 74 68 65 20 69 6e 74 |ar. Only| the int|
|00005480| 65 67 65 72 20 70 6f 72 | 74 69 6f 6e 20 77 69 6c |eger por|tion wil|
|00005490| 6c 20 62 65 20 75 73 65 | 64 2e 00 41 20 73 6f 72 |l be use|d..A sor|
|000054a0| 74 20 6b 65 79 20 6d 75 | 73 74 20 63 6f 6e 74 61 |t key mu|st conta|
|000054b0| 69 6e 20 65 78 61 63 74 | 6c 79 20 6f 6e 65 20 69 |in exact|ly one i|
|000054c0| 74 65 6d 20 66 72 6f 6d | 20 65 61 63 68 20 63 61 |tem from| each ca|
|000054d0| 74 65 67 6f 72 79 20 65 | 78 63 65 70 74 20 74 68 |tegory e|xcept th|
|000054e0| 65 20 73 6f 72 74 20 63 | 61 74 65 67 6f 72 79 2e |e sort c|ategory.|
|000054f0| 00 41 20 73 6f 72 74 20 | 6b 65 79 20 6d 75 73 74 |.A sort |key must|
|00005500| 20 63 6f 6e 74 61 69 6e | 20 65 78 61 63 74 6c 79 | contain| exactly|
|00005510| 20 6f 6e 65 20 69 74 65 | 6d 20 66 72 6f 6d 20 65 | one ite|m from e|
|00005520| 61 63 68 20 63 61 74 65 | 67 6f 72 79 20 65 78 63 |ach cate|gory exc|
|00005530| 65 70 74 20 74 68 65 20 | 73 6f 72 74 20 63 61 74 |ept the |sort cat|
|00005540| 65 67 6f 72 79 2e 00 41 | 20 73 6f 72 74 20 6b 65 |egory..A| sort ke|
|00005550| 79 20 6d 75 73 74 20 63 | 6f 6e 74 61 69 6e 20 65 |y must c|ontain e|
|00005560| 78 61 63 74 6c 79 20 6f | 6e 65 20 69 74 65 6d 20 |xactly o|ne item |
|00005570| 66 72 6f 6d 20 65 61 63 | 68 20 63 61 74 65 67 6f |from eac|h catego|
|00005580| 72 79 20 65 78 63 65 70 | 74 20 74 68 65 20 73 6f |ry excep|t the so|
|00005590| 72 74 20 63 61 74 65 67 | 6f 72 79 2e 00 41 20 73 |rt categ|ory..A s|
|000055a0| 6f 72 74 20 6b 65 79 20 | 6d 75 73 74 20 63 6f 6e |ort key |must con|
|000055b0| 74 61 69 6e 20 65 78 61 | 63 74 6c 79 20 6f 6e 65 |tain exa|ctly one|
|000055c0| 20 69 74 65 6d 20 66 72 | 6f 6d 20 65 61 63 68 20 | item fr|om each |
|000055d0| 63 61 74 65 67 6f 72 79 | 20 65 78 63 65 70 74 20 |category| except |
|000055e0| 74 68 65 20 73 6f 72 74 | 20 63 61 74 65 67 6f 72 |the sort| categor|
|000055f0| 79 2e 00 41 20 73 6f 72 | 74 20 6b 65 79 20 6d 75 |y..A sor|t key mu|
|00005600| 73 74 20 63 6f 6e 74 61 | 69 6e 20 65 78 61 63 74 |st conta|in exact|
|00005610| 6c 79 20 6f 6e 65 20 69 | 74 65 6d 20 66 72 6f 6d |ly one i|tem from|
|00005620| 20 65 61 63 68 20 63 61 | 74 65 67 6f 72 79 20 65 | each ca|tegory e|
|00005630| 78 63 65 70 74 20 74 68 | 65 20 73 6f 72 74 20 63 |xcept th|e sort c|
|00005640| 61 74 65 67 6f 72 79 2e | 00 41 20 73 6f 72 74 20 |ategory.|.A sort |
|00005650| 6b 65 79 20 6d 75 73 74 | 20 63 6f 6e 74 61 69 6e |key must| contain|
|00005660| 20 65 78 61 63 74 6c 79 | 20 6f 6e 65 20 69 74 65 | exactly| one ite|
|00005670| 6d 20 66 72 6f 6d 20 65 | 61 63 68 20 63 61 74 65 |m from e|ach cate|
|00005680| 67 6f 72 79 20 65 78 63 | 65 70 74 20 74 68 65 20 |gory exc|ept the |
|00005690| 73 6f 72 74 20 63 61 74 | 65 67 6f 72 79 2e 00 41 |sort cat|egory..A|
|000056a0| 20 73 6f 72 74 20 6b 65 | 79 20 6d 75 73 74 20 63 | sort ke|y must c|
|000056b0| 6f 6e 74 61 69 6e 20 65 | 78 61 63 74 6c 79 20 6f |ontain e|xactly o|
|000056c0| 6e 65 20 69 74 65 6d 20 | 66 72 6f 6d 20 65 61 63 |ne item |from eac|
|000056d0| 68 20 63 61 74 65 67 6f | 72 79 20 65 78 63 65 70 |h catego|ry excep|
|000056e0| 74 20 74 68 65 20 73 6f | 72 74 20 63 61 74 65 67 |t the so|rt categ|
|000056f0| 6f 72 79 2e 00 54 68 65 | 20 6d 61 78 69 6d 75 6d |ory..The| maximum|
|00005700| 20 6e 75 6d 62 65 72 20 | 6f 66 20 6e 65 73 74 65 | number |of neste|
|00005710| 64 20 67 72 6f 75 70 73 | 20 69 73 20 25 6e 75 6d |d groups| is %num|
|00005720| 62 65 72 25 2e 20 59 6f | 75 20 63 61 6e 6e 6f 74 |ber%. Yo|u cannot|
|00005730| 20 63 72 65 61 74 65 20 | 61 20 6e 65 77 20 6e 65 | create |a new ne|
|00005740| 73 74 65 64 20 67 72 6f | 75 70 20 62 65 63 61 75 |sted gro|up becau|
|00005750| 73 65 20 79 6f 75 20 77 | 6f 75 6c 64 20 65 78 63 |se you w|ould exc|
|00005760| 65 65 64 20 74 68 61 74 | 20 6c 69 6d 69 74 2e 00 |eed that| limit..|
|00005770| 54 68 65 20 63 75 73 74 | 6f 6d 20 66 6f 72 6d 61 |The cust|om forma|
|00005780| 74 20 63 6f 6e 74 61 69 | 6e 73 20 61 6e 20 65 72 |t contai|ns an er|
|00005790| 72 6f 72 2e 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 |ror. For| example|
|000057a0| 2c 20 61 20 63 75 73 74 | 6f 6d 20 6e 75 6d 62 65 |, a cust|om numbe|
|000057b0| 72 20 66 6f 72 6d 61 74 | 20 63 61 6e 6e 6f 74 20 |r format| cannot |
|000057c0| 63 6f 6e 74 61 69 6e 20 | 6d 6f 72 65 20 74 68 61 |contain |more tha|
|000057d0| 6e 20 6f 6e 65 20 64 65 | 63 69 6d 61 6c 20 70 6f |n one de|cimal po|
|000057e0| 69 6e 74 20 6f 72 20 6d | 6f 72 65 20 74 68 61 6e |int or m|ore than|
|000057f0| 20 74 68 72 65 65 20 73 | 65 6d 69 63 6f 6c 6f 6e | three s|emicolon|
|00005800| 73 2e 20 43 6f 72 72 65 | 63 74 20 74 68 65 20 65 |s. Corre|ct the e|
|00005810| 72 72 6f 72 20 61 6e 64 | 20 72 65 2d 65 6e 74 65 |rror and| re-ente|
|00005820| 72 20 74 68 65 20 66 6f | 72 6d 61 74 2e 00 54 68 |r the fo|rmat..Th|
|00005830| 65 20 63 61 74 65 67 6f | 72 79 20 6e 61 6d 65 0d |e catego|ry name.|
|00005840| 0a 0d 0a 25 6e 61 6d 65 | 25 0d 0a 0d 0a 69 73 20 |...%name|%....is |
|00005850| 6e 6f 74 20 61 20 76 61 | 6c 69 64 20 6e 61 6d 65 |not a va|lid name|
|00005860| 20 62 65 63 61 75 73 65 | 20 69 74 20 63 6f 6e 74 | because| it cont|
|00005870| 61 69 6e 73 20 6d 6f 72 | 65 20 74 68 61 6e 20 39 |ains mor|e than 9|
|00005880| 35 20 63 68 61 72 61 63 | 74 65 72 73 2e 20 45 6e |5 charac|ters. En|
|00005890| 74 65 72 20 61 20 73 68 | 6f 72 74 65 72 20 6e 61 |ter a sh|orter na|
|000058a0| 6d 65 2e 00 4d 61 6b 65 | 20 73 75 72 65 20 79 6f |me..Make| sure yo|
|000058b0| 75 72 20 57 69 6e 64 6f | 77 73 20 64 69 72 65 63 |ur Windo|ws direc|
|000058c0| 74 6f 72 79 20 63 6f 6e | 74 61 69 6e 73 20 61 20 |tory con|tains a |
|000058d0| 6c 6f 74 75 73 2e 69 6e | 69 20 66 69 6c 65 20 61 |lotus.in|i file a|
|000058e0| 6e 64 20 74 68 61 74 20 | 74 68 65 20 50 72 6f 67 |nd that |the Prog|
|000058f0| 72 61 6d 20 50 61 74 68 | 20 69 6e 20 69 74 73 20 |ram Path| in its |
|00005900| 54 4f 4f 4c 53 20 73 65 | 63 74 69 6f 6e 20 6d 65 |TOOLS se|ction me|
|00005910| 6e 74 69 6f 6e 73 20 61 | 20 64 69 72 65 63 74 6f |ntions a| directo|
|00005920| 72 79 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 73 |ry that |contains|
|00005930| 20 74 68 65 20 66 69 6c | 65 20 6c 74 73 74 6c 73 | the fil|e ltstls|
|00005940| 30 31 2e 64 6c 6c 2e 20 | 49 66 20 79 6f 75 72 20 |01.dll. |If your |
|00005950| 6c 6f 74 75 73 2e 69 6e | 69 20 66 69 6c 65 20 69 |lotus.in|i file i|
|00005960| 73 20 63 6f 72 72 65 63 | 74 2c 20 79 6f 75 20 6d |s correc|t, you m|
|00005970| 61 79 20 68 61 76 65 20 | 72 75 6e 20 6f 75 74 20 |ay have |run out |
|00005980| 6f 66 20 73 79 73 74 65 | 6d 20 6d 65 6d 6f 72 79 |of syste|m memory|
|00005990| 2e 20 43 6c 6f 73 65 20 | 73 6f 6d 65 20 6f 70 65 |. Close |some ope|
|000059a0| 6e 20 66 69 6c 65 73 20 | 61 6e 64 2f 6f 72 20 61 |n files |and/or a|
|000059b0| 70 70 6c 69 63 61 74 69 | 6f 6e 73 2e 00 4d 61 6b |pplicati|ons..Mak|
|000059c0| 65 20 73 75 72 65 20 79 | 6f 75 72 20 57 69 6e 64 |e sure y|our Wind|
|000059d0| 6f 77 73 20 64 69 72 65 | 63 74 6f 72 79 20 63 6f |ows dire|ctory co|
|000059e0| 6e 74 61 69 6e 73 20 61 | 20 6c 74 73 74 6f 6f 6c |ntains a| ltstool|
|000059f0| 73 2e 69 6e 69 20 66 69 | 6c 65 20 61 6e 64 20 74 |s.ini fi|le and t|
|00005a00| 68 61 74 20 74 68 65 20 | 6c 69 6e 65 20 4c 6f 74 |hat the |line Lot|
|00005a10| 75 73 20 43 68 61 72 74 | 3d 20 69 6e 20 69 74 73 |us Chart|= in its|
|00005a20| 20 53 45 52 56 45 52 53 | 20 73 65 63 74 69 6f 6e | SERVERS| section|
|00005a30| 20 6d 65 6e 74 69 6f 6e | 73 20 61 20 64 69 72 65 | mention|s a dire|
|00005a40| 63 74 6f 72 79 20 74 68 | 61 74 20 63 6f 6e 74 61 |ctory th|at conta|
|00005a50| 69 6e 73 20 74 68 65 20 | 66 69 6c 65 20 6c 74 73 |ins the |file lts|
|00005a60| 63 68 65 6e 31 2e 64 6c | 6c 2e 00 54 68 69 73 20 |chen1.dl|l..This |
|00005a70| 6d 6f 64 65 6c 20 68 61 | 73 20 61 20 68 6f 74 20 |model ha|s a hot |
|00005a80| 6c 69 6e 6b 20 74 68 61 | 74 20 72 65 66 65 72 65 |link tha|t refere|
|00005a90| 6e 63 65 73 20 69 74 65 | 6d 73 20 74 68 61 74 20 |nces ite|ms that |
|00005aa0| 6e 6f 20 6c 6f 6e 67 65 | 72 20 65 78 69 73 74 2e |no longe|r exist.|
|00005ab0| 20 49 6d 70 72 6f 76 20 | 77 69 6c 6c 20 6f 70 65 | Improv |will ope|
|00005ac0| 6e 20 74 68 65 20 6d 6f | 64 65 6c 20 77 69 74 68 |n the mo|del with|
|00005ad0| 6f 75 74 20 74 68 65 20 | 68 6f 74 20 6c 69 6e 6b |out the |hot link|
|00005ae0| 2e 00 49 6d 70 72 6f 76 | 20 63 61 6e 6e 6f 74 20 |..Improv| cannot |
|00005af0| 6c 69 6e 6b 20 6d 6f 72 | 65 20 74 68 61 6e 20 25 |link mor|e than %|
|00005b00| 6e 75 6d 62 65 72 25 20 | 76 65 63 74 6f 72 73 20 |number% |vectors |
|00005b10| 74 6f 20 63 68 61 72 74 | 73 20 70 65 72 20 73 65 |to chart|s per se|
|00005b20| 73 73 69 6f 6e 2e 20 44 | 65 6c 65 74 65 20 73 6f |ssion. D|elete so|
|00005b30| 6d 65 20 73 65 72 69 65 | 73 20 6f 72 20 63 68 61 |me serie|s or cha|
|00005b40| 72 74 73 20 66 72 6f 6d | 20 50 72 65 73 65 6e 74 |rts from| Present|
|00005b50| 61 74 69 6f 6e 20 42 75 | 69 6c 64 65 72 20 61 6e |ation Bu|ilder an|
|00005b60| 64 20 74 72 79 20 61 67 | 61 69 6e 2e 00 49 66 20 |d try ag|ain..If |
|00005b70| 79 6f 75 20 70 72 6f 63 | 65 65 64 2c 20 79 6f 75 |you proc|eed, you|
|00005b80| 20 77 69 6c 6c 20 64 65 | 6c 65 74 65 20 74 68 65 | will de|lete the|
|00005b90| 20 73 65 6c 65 63 74 65 | 64 20 77 6f 72 6b 73 68 | selecte|d worksh|
|00005ba0| 65 65 74 73 2c 20 76 69 | 65 77 73 2c 20 70 72 65 |eets, vi|ews, pre|
|00005bb0| 73 65 6e 74 61 74 69 6f | 6e 73 2c 20 61 6e 64 20 |sentatio|ns, and |
|00005bc0| 73 63 72 69 70 74 73 20 | 66 72 6f 6d 20 74 68 65 |scripts |from the|
|00005bd0| 20 6d 6f 64 65 6c 2e 0d | 0a 0d 0a 44 65 6c 65 74 | model..|...Delet|
|00005be0| 69 6e 67 20 61 6c 6c 20 | 76 69 65 77 73 20 6f 66 |ing all |views of|
|00005bf0| 20 61 20 77 6f 72 6b 73 | 68 65 65 74 20 64 65 6c | a works|heet del|
|00005c00| 65 74 65 73 20 74 68 65 | 20 77 6f 72 6b 73 68 65 |etes the| workshe|
|00005c10| 65 74 2c 20 61 6e 64 20 | 61 6c 6c 20 69 74 65 6d |et, and |all item|
|00005c20| 73 2c 20 63 61 74 65 67 | 6f 72 69 65 73 2c 20 66 |s, categ|ories, f|
|00005c30| 6f 72 6d 75 6c 61 73 2c | 20 61 6e 64 20 76 61 6c |ormulas,| and val|
|00005c40| 75 65 73 20 69 6e 20 74 | 68 65 6d 20 77 69 6c 6c |ues in t|hem will|
|00005c50| 20 62 65 20 72 65 6d 6f | 76 65 64 20 66 72 6f 6d | be remo|ved from|
|00005c60| 20 74 68 65 20 6d 6f 64 | 65 6c 20 70 65 72 6d 61 | the mod|el perma|
|00005c70| 6e 65 6e 74 6c 79 2e 20 | 53 6f 6d 65 20 66 6f 72 |nently. |Some for|
|00005c80| 6d 75 6c 61 73 20 69 6e | 20 6f 74 68 65 72 20 77 |mulas in| other w|
|00005c90| 6f 72 6b 73 68 65 65 74 | 73 20 69 6e 20 74 68 65 |orksheet|s in the|
|00005ca0| 20 6d 6f 64 65 6c 20 77 | 69 6c 6c 20 62 72 65 61 | model w|ill brea|
|00005cb0| 6b 2e 20 49 6d 70 72 6f | 76 20 74 72 65 61 74 73 |k. Impro|v treats|
|00005cc0| 20 62 72 6f 6b 65 6e 20 | 66 6f 72 6d 75 6c 61 73 | broken |formulas|
|00005cd0| 20 61 73 20 69 66 20 74 | 68 65 79 20 63 6f 6e 74 | as if t|hey cont|
|00005ce0| 61 69 6e 20 65 72 72 6f | 72 73 20 61 6e 64 20 64 |ain erro|rs and d|
|00005cf0| 6f 65 73 20 6e 6f 74 20 | 75 73 65 20 74 68 65 6d |oes not |use them|
|00005d00| 20 74 6f 20 63 61 6c 63 | 75 6c 61 74 65 20 63 65 | to calc|ulate ce|
|00005d10| 6c 6c 20 76 61 6c 75 65 | 73 2e 00 49 66 20 79 6f |ll value|s..If yo|
|00005d20| 75 20 70 72 6f 63 65 65 | 64 2c 20 79 6f 75 20 77 |u procee|d, you w|
|00005d30| 69 6c 6c 20 64 65 6c 65 | 74 65 20 74 68 65 20 73 |ill dele|te the s|
|00005d40| 65 6c 65 63 74 65 64 20 | 77 6f 72 6b 73 68 65 65 |elected |workshee|
|00005d50| 74 73 2c 20 76 69 65 77 | 73 20 70 72 65 73 65 6e |ts, view|s presen|
|00005d60| 74 61 74 69 6f 6e 73 2c | 20 61 6e 64 20 73 63 72 |tations,| and scr|
|00005d70| 69 70 74 73 20 66 72 6f | 6d 20 74 68 65 20 6d 6f |ipts fro|m the mo|
|00005d80| 64 65 6c 2e 0d 0a 0d 0a | 44 65 6c 65 74 69 6e 67 |del.....|Deleting|
|00005d90| 20 61 6c 6c 20 76 69 65 | 77 73 20 6f 66 20 61 20 | all vie|ws of a |
|00005da0| 77 6f 72 6b 73 68 65 65 | 74 20 64 65 6c 65 74 65 |workshee|t delete|
|00005db0| 73 20 74 68 65 20 77 6f | 72 6b 73 68 65 65 74 2c |s the wo|rksheet,|
|00005dc0| 20 61 6e 64 20 61 6c 6c | 20 69 74 65 6d 73 2c 20 | and all| items, |
|00005dd0| 63 61 74 65 67 6f 72 69 | 65 73 2c 20 66 6f 72 6d |categori|es, form|
|00005de0| 75 6c 61 73 2c 20 61 6e | 64 20 76 61 6c 75 65 73 |ulas, an|d values|
|00005df0| 20 69 6e 20 74 68 65 6d | 20 77 69 6c 6c 20 62 65 | in them| will be|
|00005e00| 20 72 65 6d 6f 76 65 64 | 20 66 72 6f 6d 20 74 68 | removed| from th|
|00005e10| 65 20 6d 6f 64 65 6c 20 | 70 65 72 6d 61 6e 65 6e |e model |permanen|
|00005e20| 74 6c 79 2e 00 00 49 66 | 20 79 6f 75 20 70 72 6f |tly...If| you pro|
|00005e30| 63 65 65 64 2c 20 79 6f | 75 20 77 69 6c 6c 20 6e |ceed, yo|u will n|
|00005e40| 6f 74 20 64 65 6c 65 74 | 65 20 61 6e 79 20 77 6f |ot delet|e any wo|
|00005e50| 72 6b 73 68 65 65 74 73 | 2c 20 62 75 74 20 74 68 |rksheets|, but th|
|00005e60| 65 20 73 65 6c 65 63 74 | 65 64 20 76 69 65 77 73 |e select|ed views|
|00005e70| 20 77 69 6c 6c 20 62 65 | 20 72 65 6d 6f 76 65 64 | will be| removed|
|00005e80| 20 66 72 6f 6d 20 74 68 | 65 20 6d 6f 64 65 6c 20 | from th|e model |
|00005e90| 70 65 72 6d 61 6e 65 6e | 74 6c 79 2e 00 49 66 20 |permanen|tly..If |
|00005ea0| 79 6f 75 20 70 72 6f 63 | 65 65 64 2c 20 79 6f 75 |you proc|eed, you|
|00005eb0| 20 77 69 6c 6c 20 6e 6f | 74 20 64 65 6c 65 74 65 | will no|t delete|
|00005ec0| 20 61 6e 79 20 77 6f 72 | 6b 73 68 65 65 74 73 2c | any wor|ksheets,|
|00005ed0| 20 62 75 74 20 74 68 65 | 20 73 65 6c 65 63 74 65 | but the| selecte|
|00005ee0| 64 20 76 69 65 77 20 77 | 69 6c 6c 20 62 65 20 72 |d view w|ill be r|
|00005ef0| 65 6d 6f 76 65 64 20 66 | 72 6f 6d 20 74 68 65 20 |emoved f|rom the |
|00005f00| 6d 6f 64 65 6c 20 70 65 | 72 6d 61 6e 65 6e 74 6c |model pe|rmanentl|
|00005f10| 79 2e 00 49 66 20 79 6f | 75 20 70 72 6f 63 65 65 |y..If yo|u procee|
|00005f20| 64 2c 20 79 6f 75 20 77 | 69 6c 6c 20 6e 6f 74 20 |d, you w|ill not |
|00005f30| 64 65 6c 65 74 65 20 61 | 6e 79 20 77 6f 72 6b 73 |delete a|ny works|
|00005f40| 68 65 65 74 73 2c 20 62 | 75 74 20 74 68 65 20 73 |heets, b|ut the s|
|00005f50| 65 6c 65 63 74 65 64 20 | 70 72 65 73 65 6e 74 61 |elected |presenta|
|00005f60| 74 69 6f 6e 73 20 77 69 | 6c 6c 20 62 65 20 72 65 |tions wi|ll be re|
|00005f70| 6d 6f 76 65 64 20 66 72 | 6f 6d 20 74 68 65 20 6d |moved fr|om the m|
|00005f80| 6f 64 65 6c 20 70 65 72 | 6d 61 6e 65 6e 74 6c 79 |odel per|manently|
|00005f90| 2e 00 49 66 20 79 6f 75 | 20 70 72 6f 63 65 65 64 |..If you| proceed|
|00005fa0| 2c 20 79 6f 75 20 77 69 | 6c 6c 20 6e 6f 74 20 64 |, you wi|ll not d|
|00005fb0| 65 6c 65 74 65 20 61 6e | 79 20 77 6f 72 6b 73 68 |elete an|y worksh|
|00005fc0| 65 65 74 73 2c 20 62 75 | 74 20 74 68 65 20 73 65 |eets, bu|t the se|
|00005fd0| 6c 65 63 74 65 64 20 70 | 72 65 73 65 6e 74 61 74 |lected p|resentat|
|00005fe0| 69 6f 6e 20 77 69 6c 6c | 20 62 65 20 72 65 6d 6f |ion will| be remo|
|00005ff0| 76 65 64 20 66 72 6f 6d | 20 74 68 65 20 6d 6f 64 |ved from| the mod|
|00006000| 65 6c 20 70 65 72 6d 61 | 6e 65 6e 74 6c 79 2e 00 |el perma|nently..|
|00006010| 54 68 65 20 6d 6f 64 65 | 6c 20 79 6f 75 20 61 72 |The mode|l you ar|
|00006020| 65 20 72 65 61 64 69 6e | 67 20 69 6e 20 68 61 73 |e readin|g in has|
|00006030| 20 61 20 62 61 64 20 50 | 72 65 73 65 6e 74 61 74 | a bad P|resentat|
|00006040| 69 6f 6e 20 42 75 69 6c | 64 65 72 20 68 6f 74 20 |ion Buil|der hot |
|00006050| 6c 69 6e 6b 2e 20 54 68 | 65 20 70 72 6f 62 6c 65 |link. Th|e proble|
|00006060| 6d 20 69 73 20 63 61 75 | 73 65 64 20 65 69 74 68 |m is cau|sed eith|
|00006070| 65 72 20 62 79 20 61 20 | 6d 65 64 69 61 20 66 61 |er by a |media fa|
|00006080| 69 6c 75 72 65 20 6f 72 | 20 62 79 20 61 20 62 75 |ilure or| by a bu|
|00006090| 67 20 69 6e 20 74 68 65 | 20 49 6d 70 72 6f 76 20 |g in the| Improv |
|000060a0| 66 69 6c 65 20 77 72 69 | 74 65 20 63 6f 64 65 2e |file wri|te code.|
|000060b0| 20 49 6d 70 72 6f 76 20 | 77 69 6c 6c 20 72 65 61 | Improv |will rea|
|000060c0| 64 20 69 6e 20 74 68 65 | 20 6d 6f 64 65 6c 20 77 |d in the| model w|
|000060d0| 69 74 68 6f 75 74 20 75 | 73 69 6e 67 20 74 68 65 |ithout u|sing the|
|000060e0| 20 68 6f 74 20 6c 69 6e | 6b 2e 00 59 6f 75 20 61 | hot lin|k..You a|
|000060f0| 72 65 20 61 74 74 65 6d | 70 74 69 6e 67 20 74 6f |re attem|pting to|
|00006100| 20 72 65 6e 61 6d 65 20 | 61 6e 20 69 74 65 6d 20 | rename |an item |
|00006110| 77 69 74 68 20 61 20 6e | 61 6d 65 20 74 68 61 74 |with a n|ame that|
|00006120| 20 68 61 73 20 6e 6f 20 | 63 68 61 72 61 63 74 65 | has no |characte|
|00006130| 72 73 2e 20 54 68 65 20 | 69 74 65 6d 20 77 69 6c |rs. The |item wil|
|00006140| 6c 20 72 65 74 61 69 6e | 20 69 74 73 20 6f 6c 64 |l retain| its old|
|00006150| 20 6e 61 6d 65 2e 00 59 | 6f 75 20 61 72 65 20 61 | name..Y|ou are a|
|00006160| 74 74 65 6d 70 74 69 6e | 67 20 74 6f 20 72 65 6e |ttemptin|g to ren|
|00006170| 61 6d 65 20 61 6e 20 69 | 74 65 6d 20 74 6f 20 61 |ame an i|tem to a|
|00006180| 20 6e 61 6d 65 20 74 68 | 61 74 20 68 61 73 20 6d | name th|at has m|
|00006190| 6f 72 65 20 74 68 61 6e | 20 74 68 65 20 61 6c 6c |ore than| the all|
|000061a0| 6f 77 65 64 20 6e 75 6d | 62 65 72 20 6f 66 20 63 |owed num|ber of c|
|000061b0| 68 61 72 61 63 74 65 72 | 73 2e 20 54 68 65 20 69 |haracter|s. The i|
|000061c0| 74 65 6d 20 77 69 6c 6c | 20 62 65 20 74 72 75 6e |tem will| be trun|
|000061d0| 63 61 74 65 64 20 74 6f | 20 74 68 65 20 6d 61 78 |cated to| the max|
|000061e0| 69 6d 75 6d 20 61 6c 6c | 6f 77 65 64 20 6c 65 6e |imum all|owed len|
|000061f0| 67 74 68 2e 00 59 6f 75 | 20 63 61 6e 20 72 65 70 |gth..You| can rep|
|00006200| 6c 61 63 65 20 61 20 67 | 72 61 70 68 20 69 6e 20 |lace a g|raph in |
|00006210| 61 20 6d 6f 64 65 6c 20 | 6f 6e 6c 79 20 77 69 74 |a model |only wit|
|00006220| 68 20 61 20 67 72 61 70 | 68 20 66 72 6f 6d 20 74 |h a grap|h from t|
|00006230| 68 65 20 73 61 6d 65 20 | 6d 6f 64 65 6c 2e 20 45 |he same |model. E|
|00006240| 69 74 68 65 72 20 63 68 | 6f 6f 73 65 20 74 68 65 |ither ch|oose the|
|00006250| 20 4e 65 77 20 47 72 61 | 70 68 20 63 6f 6d 6d 61 | New Gra|ph comma|
|00006260| 6e 64 2c 20 6f 72 20 73 | 65 6c 65 63 74 20 77 69 |nd, or s|elect wi|
|00006270| 6e 64 6f 77 73 20 69 6e | 20 49 6d 70 72 6f 76 20 |ndows in| Improv |
|00006280| 61 6e 64 20 50 72 65 73 | 65 6e 74 61 74 69 6f 6e |and Pres|entation|
|00006290| 20 42 75 69 6c 64 65 72 | 20 74 68 61 74 20 63 6f | Builder| that co|
|000062a0| 72 72 65 73 70 6f 6e 64 | 20 74 6f 20 74 68 65 20 |rrespond| to the |
|000062b0| 73 61 6d 65 20 6d 6f 64 | 65 6c 2e 00 54 68 65 20 |same mod|el..The |
|000062c0| 66 69 6c 65 20 63 6f 6e | 74 61 69 6e 73 20 6e 6f |file con|tains no|
|000062d0| 20 64 61 74 61 20 77 69 | 74 68 69 6e 20 74 68 65 | data wi|thin the|
|000062e0| 20 69 6d 70 6f 72 74 20 | 72 61 6e 67 65 20 79 6f | import |range yo|
|000062f0| 75 20 73 70 65 63 69 66 | 69 65 64 2e 00 54 68 65 |u specif|ied..The|
|00006300| 20 69 6d 70 6f 72 74 20 | 72 61 6e 67 65 20 6e 61 | import |range na|
|00006310| 6d 65 20 74 68 61 74 20 | 79 6f 75 20 73 70 65 63 |me that |you spec|
|00006320| 69 66 69 65 64 20 69 73 | 20 6e 6f 74 20 64 65 66 |ified is| not def|
|00006330| 69 6e 65 64 20 69 6e 20 | 74 68 65 20 66 69 6c 65 |ined in |the file|
|00006340| 2c 20 6f 72 20 63 6f 6e | 74 61 69 6e 73 20 69 6e |, or con|tains in|
|00006350| 76 61 6c 69 64 20 73 79 | 6e 74 61 78 2e 20 20 49 |valid sy|ntax. I|
|00006360| 66 20 79 6f 75 20 63 6c | 69 63 6b 20 4f 4b 20 74 |f you cl|ick OK t|
|00006370| 6f 20 70 72 6f 63 65 65 | 64 2c 20 74 68 65 20 65 |o procee|d, the e|
|00006380| 6e 74 69 72 65 20 77 6f | 72 6b 73 68 65 65 74 20 |ntire wo|rksheet |
|00006390| 77 69 6c 6c 20 62 65 20 | 69 6d 70 6f 72 74 65 64 |will be |imported|
|000063a0| 2e 00 41 20 77 6f 72 6b | 73 68 65 65 74 20 63 61 |..A work|sheet ca|
|000063b0| 6e 20 63 6f 6e 74 61 69 | 6e 20 61 20 6d 61 78 69 |n contai|n a maxi|
|000063c0| 6d 75 6d 20 6f 66 20 25 | 6e 75 6d 62 65 72 25 20 |mum of %|number% |
|000063d0| 69 74 65 6d 73 2c 20 69 | 6e 63 6c 75 64 69 6e 67 |items, i|ncluding|
|000063e0| 20 63 61 74 65 67 6f 72 | 69 65 73 2e 20 54 68 69 | categor|ies. Thi|
|000063f0| 73 20 6f 70 65 72 61 74 | 69 6f 6e 20 69 73 20 6e |s operat|ion is n|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
